Style Python Pandas DataFrames! (Conditional Formatting, Color Bars and more!)

[@darrena3080]

This is exactly what ive been struggling with for these past couple of weeks.Im teaching myself data analytics and this video is making things so much better

[@datagy]

Thanks so much!!

[@evyatarse]

it's important to me that you know how much you're content helps me.
thank you so very much

[@datagy]

Thank you so much, Evyatar! That means a lot to me!

[@mjacfardk]

great comprehensive and deep tutorial
Thank you

[@datagy]

Thank you Dukaan!!

[@PaulWirsing]

Any hints or tutorials on applying this to pivot tables?

[@clockfixer5049]

An excellent tutorial, thank you so much

[@sachinmaroky4600]

thank you
May I know when you used the styles in the second data frame , why $ sign not showing ?

[@kobilee7110]

Is there any way to output these styles to an excel file or CSV?

[@datagy]

Hi Kobi! You can export to Excel by applying the .to_excel() method to the styler object (rather than just the DataFrame).

[@narendramishra3503]

Hello, I have an excel sheet which has some background colours in cells , while I am conditionally filtering and creating a new excel sheet using python pandas dataframe I am lossing the background colour in the cells. Can anyone help me how I can retain background colour ?

[@balajibalaji9706]

How to apply colour for columns?

[@chriskeo392]

This styling passes into csv and excel files?

[@datagy]

Unfortunately not! For that, you can use other libraries like openpyxl :)

[@KakdeG]

wonder if this works with steramlit

[@KakdeG]

Just checked. Does not work with streamlit when using pandas dataframe

[@datagy]

Thanks for the update!! You may be able to do some trickery to convert the dataframe to html first (which keeps the formatting) and then insert as an html block in streamlit?

[@KakdeG]

@@datagy Thanks for the idea. Will give it a shot

[@brunowendt1194]

Nothing is working lol