Using STREAMLIT with AG Grid Table - Interactive Table | Part 1/2

[@Avra_b]

Here's the 2nd part of the video - kzbin.info/www/bejne/kKScXmuqp7WUmrc More more videos with Streamlit AgGrid use cases?Feel free to drop your feedbacks below in the comment section. 👇🏽 Happy Coding ! 😃

[@francisco_cervantes]

Hi men, I´m from México and tomorrow I have to show my proyect. Your video gave me confidence to continue programming with Streamlit, tanks a lot!!

[@Avra_b]

Hi Francisco. I’m so happy to listen to this . This keeps me motivated to create more content , thank you for being so kind and stay in touch :)

[@ddjLai-b5e]

Introducing AgGrid is excellent!

[@Avra_b]

Happy to hear !

[@jorge1869]

Excellent and powerful content for easy data management from the user interface. We missed you, regards

[@Avra_b]

Thank you again Jorge, for your such kind words. I'm so sorry for being unable to upload lately. Covid, war and personal commitments made things bit difficult.However, I'll be back with more videos soon 💪🏽. I hope you and your loved ones doing well. Best wishes, stay connected 🤗

[@mustgame2233]

This is game changer. Thank you so much for this video.

[@Avra_b]

Glad it was helpful! Happy to hear ! Stay tuned !

[@pmshadow]

Super nice video! Thank you very much for the amazing content!!

[@Avra_b]

Glad you enjoyed it!

[@M20081986]

Great tutorial Avra ! Much appreciate 🙂

[@Avra_b]

Hey thanks for your kind words . Means a lot . Stay in touch , cheers

[@SolidBuildersInc]

I am very glad I watched this tutorial. Thanks. This would really make slicing and dicing data very interactive along with the sidebar filter of Streamlit.

[@Avra_b]

Hi Davis , glad to see you back here , hope you are doing great . Yes, thanks for your feedback 🤗 Indeed , AgGrid adds that advantage to your data frame as you mentioned . Stay in touch and regards Avra

[@amitbuch]

Very Good intro Avra. Kudos.

[@Avra_b]

I'm glad you like it! Stay tuned ! :)

[@Challseus]

I really need agrid for my work, thanks for this!

[@Avra_b]

Hi , im glad that it helped you. Stay in touch and good luck with your projects 🤗🎈

[@lfmtube]

Great Video. Very very useful! Thanks a lot!

[@Avra_b]

I’m glad to hear that . Stay in touch 🤗🎈

[@jamesdow272]

This really was a great tutorial for what I'm trying to do, amazing job, honestly!

[@Avra_b]

So nice to hear James ! Thank you , stay in touch !

[@jamesdow272]

@@Avra_b Actually, i was wondering if you knew if it was possible to edit the data directly in the AgGrid grid and save the cahnges you make. Would it be possible without using Javascript? or would I need to branch out to other languages for that

[@walter_ullon]

Great content like always Avra!

[@Avra_b]

Thank you so much Walter , means a lot 🎈🤗

[@praveenkumawat2662]

Thank buddy for sharing this

[@Avra_b]

I’m glad to hear Praveen. Stay in touch 🤗

[@dorelia7784]

Thank you! great tutorial! is its possible to connect aggrid to DB and update the DB through aggrid?

[@Avra_b]

Thanks for you feedback . Ofcourse it’s possible . You can save the AgGrid data to any databases such as SQLite or intact send it to Google sheet or Firestore. In my playlist you can find such tutorials as well . Further you can store the data with Streamlit session state . Hope this helps , and let me know how it goes , cheers 🤗🎈

[@dorelia7784]

@@Avra_b Hey! Thanks for the response i couldn't find a video about update sqlite database through ag-grid any chance you can help me?

[@Avra_b]

@@dorelia7784 Hey, I haven't made any videos with Sqlite yet, but you can find in my playlist with Firestore or GoogleSheet as database. It's a good suggestoin, I would love to make a video on it. However, I don't want you to wait for it, so , as far as I remember @JCharisTech, has made a video with Sqlite and Streamlit. Please refer to it and I hope it wil be useful for you. Let me know :)

[@guilhermechina0506]

Hii. Great tutorial Avra. Let me ask ya. Is there any way to display aggrid tables side by side? Like a st.columns in streamlit. Thankss

[@Avra_b]

Hey thanks , glad that you liked it . I haven’t tried it - but I’m pretty sure , just dumping AgGrid in two columns must be possible . col1, col2 = st.columns(2) with col1: AgGrid(df1) with col2 : AgGrid(df2) Let me know if it works . Best ,Avra

[@jonggunpark7420]

hi Avra, if I want to hover a specific column header, how do I implement this? tysm!!

[@Avra_b]

Hi ! I need to check the Aggrid documentation. It would be very similar implementation like the other JS rendering

[@daniel198045]

Hi Avra , thank you for the tutorial and your time , I would like to ask you a question , I have a streamlit app and every time I select a new option the table tha was modified get the original values , is there a way to freeze tha table, in a way I can modify the table but keep those changes without refreshing the table after every action with select box or other st component ? Thank you again

[@Avra_b]

Hi thank you for your feedback. Have you tried session state ? Can that work ?

[@giridharrangarajan4586]

Excellent tutorial!! I want to add collapsible/expandable rows to the table. Can you help me out with it ?

[@Avra_b]

I’m glad that you liked it . If I understood you properly, probably this feature isn’t implemented. do you want something like grouped row ? You can try that using Object.configure_column('colnams', rowGroup=True) Best Avra

[@Mj_All_In_One]

What did you end up doing? Do you recall?

[@AshishPrasadMaharana]

Hi!!! I am looking at selecting specific columns from a aggrid table and exporting it. Can you tell me how to configure the grid to do this in streamlit-aggrid???

[@Avra_b]

Is it resolved ?

[@NehaKumari-su1gg]

Hi Avra, Great Explanation I am new to this Streamlit AgGrid. I am currently using this in my POC project. I have a requirement that is I need to change the table size everytime on any column filter change, the reason of that because In case of small no of records, I am getting an empty space below. My requirement is to get rid of that empty space and update the table size on every filter change. Can we achieve that in Streamlit AgGrid?

[@Avra_b]

Yes possible !

[@ophirharoche8625]

Hello! Thanks for the great tutorial. Do you know how to make only a subset of the columns of the table editable? In your vid you make all of them editable. Thanks!

[@Avra_b]

Hey I'm glad that you liked this video . 🤗 Yes, you can make specific columns editable. For that , you need to specify separately , example : gd.configure_column("your_column_name", editable = True) . Hope this helps ! And Merry Christmas 🎄

[@Septumsempra8818]

Great vid. Real eye opener. How do we build complex filters? I work with financial data and may want eg. top 30% of stocks ordered by price returns and then after passing through the filter show me the stocks in the bottom third of volitility (preferably in a single dataframe). s/o from South Africa

[@Avra_b]

Hey Alexandros , thank you ! It seems a great idea . Let me figure it out if I can cover it in an additional video. I’ll get back to you soon-ish 🤗

[@tokelo2547]

Hi Avra, Great video. I love streamline but Agrid is very slow even on my localhost. It cannot efficiently handle even just 700 rows data. Do you know how I can improve the performance of Agrdi library or it is just currently slow?

[@Avra_b]

Hey thank you for your feedback. Unfortunately, it’s a very common issue reported with AgGrid . I would recommend to use st-AgGrid for smaller datasets ( usually 700 rows should work well ) and ensure a robust alternative while coding blocks related to AgGrid. Incase I come across a solution , I would definitely update since it looks like a common issue . Apologies . Stay in touch , cheers

[@virajsin9328]

Hii avra, thanks for this wonderful video... It there any feature in AgGrid which edit rows in AgGrid tables based on user input ??

[@Avra_b]

AgGrid cells are editable . Enable that feature in your code . If it’s editable user can make inputs . Hope it helps . Stay in touch cheers

[@ibaha411]

Can you create an editable user input table in streamlit? Then that table would be used to do some calculations within the code and some results would be shown. Is this doable in streamlit?

[@Avra_b]

Hi thanks for the suggestion . I think its doable. This video partly covers what you mentioned - Python Web App using INTERACTIVE AGGRID Table connected to GOOGLE SHEET |JavaScript Injection | kzbin.info/www/bejne/qYCpfmZpac58gtU Let me know your feedback 🤗

[@ibaha411]

@@Avra_b Thanks for the reply. I will check out the video you sent. I really appreciate it.

[@assavinkengkart9141]

Great sharing and it is very useful. Just something is wrong here. I follow the code above, but my "Multiple" selection mode doesn't work. Not sure how to solve it. I mean I can't select multiple rows after choosing "Multiple" mode.

[@Avra_b]

Hi thanks ! I need to look onto it . Perhaps some update with AgGrid ? Is the demo app behaving the same ?

[@george777ify]

Great video. Maybe you can answer this. I have a single column grid which is only 1 inch wide or so. However the column header of the column extends to the right as if there are several more columns. Is there a way to get the column head to be the same width as the column itself? Of course not by widening the column but by shrinking the column header. Thanks.

[@Avra_b]

Thanks ! Could you figure out the answer ?

[@yarraramu4774]

hi @Avra this video is helping a lot, but am stuck in middle, can you please help me, my selected_rows showing empty list, help me to slove.

[@Avra_b]

Tell me a bit more

[@pericleszacariasabrahao6913]

Hello, I would like to edit a field in the DataFrame and save the changed field in a table, is this possible? Do you have something similar?

[@Avra_b]

I think this is something you are looking for - Python Web App using INTERACTIVE AGGRID Table connected to GOOGLE SHEET |JavaScript Injection | kzbin.info/www/bejne/qYCpfmZpac58gtU Let me know :)

[@AshishSingh-wd6bn]

can we redirect to other page of streamlit app by clicking a column in the table and pass the column value to that page on which we jump?

[@Avra_b]

Do you mean , you would like to add any URL link? Yes that’s possible

[@AshishSingh-wd6bn]

​@@Avra_b yes, and by passing the value of that clicked element to the other page

[@Mj_All_In_One]

Hey Avra, is there any licensing required for the ag-grid? Which features can be used without license for aggrid?

[@Avra_b]

No not necessarily. But I’m sure there are limitations, worth to check their docs

[@sathyahisto]

Can we have a subgroup at every row and update the subgroup values that summarises at the groups level??

[@Avra_b]

Thanks for this suggestion. Yes it is possible with AgGrid to create subgroups. Perhaps I would come up with a video / blog post . Stay in touch :)

[@dfrecipes1138]

Hi and thanks for making these videos.!!! One question. I'm trying to use AGGRID, I have one column that is editable (COL1), I would like for the user to input into Col1, then it would be multiplied with Col2, and the result would be in Col3, and the AgGrid Table would be refreshed to show all these new values. Any thoughts on how I could do this? I've been researching for 2 days now, and I can't seem to figure it out. Thanks. and please help! please.

[@Avra_b]

Hey , thanks for your feedbacks. I’m pretty sure this is possible as well . Since I’m away from keyboard this weekend, right now can’t share with you the code snippets , but how about trying this very similar workaround I found in the community forum of Streamlit - discuss.streamlit.io/t/ag-grid-component-with-input-support/8108/233?u=avratanubiswas I’m pretty sure it will solve your use case . Let me know . Best

[@pavanpraneeth4659]

After editing cab we again save the edited dataframe to excel file

[@thaily-nn1my]

Great video, anyways do you have any implements on dashboard showing the graphs,charts, data table, and map and those are interective each other in Streamlit! I hope you feedback soon. Thank you! Keep it up!

[@Avra_b]

Thanks for your feedback! This is a great suggestion. If I understood you correctly - any change on AgGrid interactive dataframe - there would be change in the visualization ( plots etc ) ?

[@sylviowei1971]

Great presentation!! May I know the code editor that you're using in this presentation?

[@Avra_b]

I’m glad that you liked it . I’m using Visual Studio Code . Stay in touch 🤗🎈

[@uditsingh9487]

when i am using st.write(sel_row) it's not showing the selected row. i am not getting any error. Can you please help. .

[@Avra_b]

Hey Udit, thanks for reaching out . So do you mean , there's no result on selecting any row / check box ? Probably it's because the update grid model hasn't been used in your code. I'm away from keyboard right now. Probably today later or tomorrow I'll update with the code , that might help you. Let me know how it goes . See you around :)

[@Avra_b]

I've updated with the code , github.com/avrabyt/Streamlit-Tutorials-2021-22/tree/main/Streamlit-AgGrid-Usage

[@kshitijdubey8994]

can we add a column which shows images ?

[@Avra_b]

Yes . I’ll be soon coming up with a video. Apologies for the late reply . Stay in touch 🤗

[@lucasseibert4505]

i'm trying to drag and drop the rows, to reordering. Someone to help?

[@Avra_b]

Could you figure out?

[@PANDURANG99]

It is good edit tables, but how to save it into database.because you have use csv

[@Avra_b]

You can easily download the table as csv . This feature is inbuilt in AgGrid table .

[@maivish100]

How to change column background color in St.dataframe. Kindly reply

[@Avra_b]

Streamlit docs have a nice way to do that. Please refer to that :)

[@vijaymane34]

Which editor is this?

[@Avra_b]

Hi , generally I use vscode :)

[@samketola919]

Are you using the free version of AG Grid?

[@Avra_b]

Yes , it’s a free version .

[@factuallyfantastic]

dude if you could teach us how to create an inventory and order management web app in streamlit....i have been designing this in streamlit for a month with no success for a client...i wish you could guide me to use dataframes or mysql

[@Avra_b]

Hey thanks for your wonderful suggestion ! Yes, indeed I have no video with sql, probably it's time to create one. However, I created a demo app and a video, Chemical Inventory management, using SpreadSheet, that might be useful for you ? Link - kzbin.info/www/bejne/e369qomNnLqIa6M Let me know :)

[@factuallyfantastic]

@@Avra_b thanks for reply man, hope your and my channel grows exponentially...but I was asking for STREAMLIT python framework specifically...

[@Avra_b]

Hey thanks ! The link of the video is with Streamlit Python and Google Sheet automation . Check it out :) thanks for your wishes , likewise . Do share the link of your channel , I would love to subscribe and check your content :)

[@factuallyfantastic]

@@Avra_b thanks..this is my gaming channel mostly kzbin.info/door/r0kMWfE9tp9xhKE5idDMOg

[@xmorales]

excelent !!

[@Avra_b]

Thanks Daniel 🤗

[@anandakrishnangopalakrishn1961]

im facing hang issue and the dimension of the dataframe is row-1787 and column is 55

[@Avra_b]

Hi what do you mean by hang issue ?

[@anandakrishnangopalakrishn1961]

@@Avra_b yes whenever i use only AgGrid(df), im facing the hang issue such that taking time to render the data and not responding to the functions i clicking in the table and after using grid options and functions now it is working fine. and now im facing an issue in the table pages since the dataset is of 1787 rows intially the pages were 18 and nearly 100 rows each and whenever i move to the last page 18 then the page count increasing to 22 and then 32 and finally 500+ pages with 3 rows each page

[@pmshadow]

Is this for free or paid version of aggrid?

[@Avra_b]

Free version

[@pmshadow]

Wow so fast reply!! Thanks a lot!!

[@Avra_b]

@@pmshadow I usually try to . Sometimes I do miss few ...

[@androidbox6876]

What is this text editor? It looks so cool 🤓.

[@Avra_b]

Thanks ! Vs code

[@orlanino]

how can I display multiple lines in a cell, please?

[@Avra_b]

Not sure - have you checked aggrid docs ?

[@init_yeah]

why is my aggrid df table lagging so badly?

[@Avra_b]

Thanks for your feedback. Unfortunately, this is a common issue reported. I’ll see if there is a plausible way to speed up , will update . Stay in touch cheers .

[@pericleszacariasabrahao6913]

Sabia que não dava para confiar

[@Avra_b]

Neither I

[@yogeshmvmr]

Grid Too Slow Bro

[@Avra_b]

Im sorry . That’s true with AgGrid - Streamlit component .