Excel Filtering in Pandas Dataframe using QGrid Library | Python

Excel allows us to filter sort with the help of a button click but all these manipulations require some good amount of code when we are working with python and pandas dataframe. Qgrid is a Jupyter notebook widget which uses SlickGrid to render pandas DataFrames within a Jupyter notebook. This allows you to explore your DataFrames with intuitive scrolling, sorting, and filtering controls, as well as edit your DataFrames by double clicking cells.

If you do have any questions with what we covered in this video then feel free to ask in the comment section below & I'll do my best to answer those.

If you enjoy these tutorials & would like to support them then the easiest way is to simply like the video & give it a thumbs up & also it's a huge help to share these videos with anyone who you think would find them useful.

Be sure to subscribe for future videos & thank you all for watching.

You can find me on:

#pandasfiltering #qgrid #excel #python #deeplearning #datascience #youtube

[pavelgrigorov]

how transform qgrid object to dataFrame, i want use qgrid to input data, but make calculate with dataFrame (pandas). Thanks!

[antonl]

Cool feature, will use this for sure ! Thanks !

[sukeshjena]

After doing the filtering can we save that file..if yes tell how?

[AlonsoParejawee]

Ty! Is there a way to get datagrams based on the filter from one column? I have a csv where a column has professors and want to create for each professor one table

[shinuignatious]

df_qgrid can be used as a filtered data set from then on ?, if i change it in middle of the project, will it be updated?

[nikhildmehta]

Any option to clear all filters at once?

[servetum]

I get "module 'pandas.core' has no attribute 'index'" error

[LSl]

['heart'] ['heart'] ['heart'] ['Thank you !!!)']