The way to Create Effectively-Styled Streamlit Dataframes, Half 2: Utilizing AgGrid | by Jose Parreño | Aug, 2024

The pandas Styler is cool. However AgGrid is approach cooler. Make your Streamlit dataframes interactive and beautiful.

In my earlier submit, we coated the way to create fairly styled dataframes utilizing the pandas Styler object. On this submit, I need to inform you a couple of second possibility: Streamlit AgGrid. I’ll share the way to construct dataframes just like the one displayed above. After studying this submit you’ll study:

1. The important thing parts inside AgGrid. These are gridOptions() , configure_column() , configure_default_column(), and configure_side_bar().
2. The primary choices to allow filtering and aggregating tables utilizing the instantly the UI. No extra constructing ad-hoc queries for easy transformations!
3. Making the dataframe prettier with Javascript features. It is possible for you to to repeat paste them in your code in order for you. Or examine my Git repo.

Disclaimer 1: I’ve no affiliation or partnership with AgGrid. I simply discover lots of worth within the open-source product. AgGrid does have a paid tiered product, however the weblog will solely use the free parts of AgGrid.

Disclaimer 2: All photographs and GIFs are authored on my own except specified in any other case.