Saving filters configuration in Streamlit Ag-grid

Custom Components
1

Hi I am using streamlit ag-grid for visualizing some dataframes. I am trying to figure out if there is any way to save the current state of the columns filters, so that next time I can just apply the filters configuration to the table and not repeating the process of filtering everything again.

Thanks!

2

Could you post a minimal code that we can explore.

Also have a look on posting guide.

3

Hi,

I’m also looking for something similar.
Did you mange to find the solution?

The small code snippet would be something in the line of

import pandas as pd
import streamlit as st
from st_aggrid import AgGrid
data = pd.DataFrame({"a": [1, 2, 3], "b": [4, 5, 6]})
grid = AgGrid(data)

And then, let’s say the user filtered out a column a to value = 2 and entered a new number.
I would like for a filter to remain after the number change.

There is this method getFilterModel in JS
JavaScript Data Grid: Filter API that should be able to return all filters but I’m not sure how to call it from Streamlit.

4

Hi I have just assumed it is just not possible, I saw this post from Pablo Fonseca:

MicrosoftTeams-image (3)
MicrosoftTeams-image (3)1018×385 17.8 KB

5

Hey @Mila_Sincic / @Miguel_Gonzalez,

I want to implement the exact functionality as mention by @Mila_Sincic. Were you able to find any solution? Thank you in advance!

6

Hi, no I do not think it is possible yet. I kind of figured out a workaround by predefining some setup for the position of the columns and some filters rules, saving it on a config file for uploading it afterwards. But you have to do it manually.

7

Hi Miguel, could you please give some examples of manual getting/uploading columns filter state?

8

I have a solution here:

This allows the user to click an update button and save the state.