Add search and/or filter functionality to dataframes

[nthmost]

User story:

• It would be really handy to be able to search within a displayed dataframe. I type in what i'm searching in a text box (maybe it appears when I hover over the dataframe or maybe it's always there). Search results could potentially be highlighted in their cell and/or listed above or below the dataframe dynamically.
• When displaying the dataframe, I'd like the ability to filter what i'm seeing, perhaps by applying search patterns to columns. Examples:
  • Filter a date field by year, e.g. "YY = 2000"
  • Filter a text field on a word or phrase

Desired behavior

• SEARCH: Display a search box that is displayed meaningfully attached to the dataframe (e.g. top left corner of the div).
  • Display results by highlighting cells and/or by printing relevant rows to a list above or below the dataframe.
• FILTER: TBD

---

Community voting on feature requests enables the Streamlit team to understand which features are most important to our users.

If you'd like the Streamlit team to prioritize this feature request, please use the 👍 (thumbs up emoji) reaction in response to the initial post.

[vbabaria]

i concur, this would be a great enhancement.

should this issue be raised to streamlit-aggrid code repo as well?

[jrieke]

Search is enabled since a while by clicking on a dataframe and pressing cmd/ctrl + F. Filtering is planned but it will probably take a bit until we get to it!

[xinyu-dev]

I concur!!

[andreaschiappacasse]

I agree, filtering is the one feature I am missing to completely replace aggrid with st.dataframe in my use cases

[sfc-gh-pkommini]

@jrieke Is this the right place to also request a group by column context menu feature? or Should I open a new github issue?

[jrieke]

@sfc-gh-pkommini sorry didn't see this. A new GitHub issue would be best, so we don't lose track if we close this one!