Switch to using AG Grid for interactive table

[alyssadai]

We're gradually reaching the limit of what the native dash datatable can offer in terms of filtering capabilities and other features, and have already needed to code or investigate workarounds for e.g., multiple values selection, filtering for missing values.

These kinds of features are supported by default in Dash AG Grid, which offers significantly greater customization, (apparently) better performance, and overall seems like a more sustainable solution for a heavily interactive datatable. Based on a quick overview of community posts, it also seems like Dash AG Grid is being more actively maintained.

This issue will serve as a place to catch new feature requests that would require custom workarounds in dash datatable and so will not be fixed/implemented until after the migration:

• Filtering for non-blank values in a column (see https://dash.plotly.com/dash-ag-grid/column-filters)

Resources:

• https://dash.plotly.com/dash-ag-grid
• https://medium.com/plotly/announcing-dash-ag-grid-fbb4a1c83e62
• https://community.plotly.com/t/ag-grid-vs-datatable/77479

[github-actions]

We want to keep our issues up to date and active. This issue hasn't seen any activity in the last 75 days.
We have applied the _flag:stale label to indicate that this issue should be reviewed again.
When you review, please reread the spec and then apply one of these three options:

• prioritize: apply the flag:schedule label to suggest moving this issue into the backlog now
• close: if the issue is no longer relevant, explain why (give others a chance to reply) and then close.
• archive: sometimes an issue has important information or ideas but we won't work on it soon. In this case
  apply the someday label to show that this won't be prioritized. The stalebot will ignore issues with this
  label in the future. Use sparingly!