Conditional Formatting with Pandas and Python | Excel Hacks

Learn how to perform conditional formatting by using pandas. Learn how to style multiple stylesheets and export the result to excel. Process several excel sheets with ease and speed.

Learn how to build a machine learning API that connects to a back end machine learning model and returns a response based on feedback from the ML model.

👉 Instagram: @theaiwarriors

What Does a Data Science Executive Carry Around in 2019?

Laptop - 2018 MacBook Pro with Touch Bar
Tablet - 2017 9.7” iPad or

Home Setup for more intense analysis and editing:

Other options to run Python on a budget

Any inexpensive Android Tablet (all Fire tablets with playstore side loaded)

Favourite Mobile Apps to Run Python and Code

Music:

Creative Commons — Attribution 3.0 Unported — CC BY 3.0

[iubob]

WOW!!!! i spent almost 3 days at the office trying to figure out how to style only selected columns in df. I TRIED EVERYTHING. I should've just watched your video. could've saved me so much time. But regardless learned a lot through the process.

[robmonkriedlinger]

Just what I was looking for - thank you so much!

[saurabhjain]

You should consider making more videos. Thanks for this video.

[shinrafahell]

Thank you sir this tutorial is quite comprehensive!

[willykitheka]

very useful stuff! Thanks for sharing!

[asdak]

That was a very simple explanation. Thank you!

[chriskeo]

@6:19 can we do else pass?

I have the row already a certain color and dont want to change it.




Video is awesome!

[gdnoob]

I can not seem to have the conditional formatting to be exported into .xlsx file. The conditional formatting appears in my VS Code Jupyter notebook.

[chriskeo]

Possible to used styled and have the columns auto fit when we use to_excel?

[sakshiagrawal]

How to add dynamic borders to output excel file.

[coltinbarney]

Is it possible to kick this back into excel with the highlighting?

[aloknagar]

One query...When I export formatting in excel using (openpyxl->.to_excel), it randomly export conditional formatting by column/field. Can you please suggest

[swingtrades]

how to get count of colored cells for each column

[radams]

Everything was great! My only issue is it will not format the $$ amounts. I dont get errors, just doesnt format. Any thoughts? I am using Spyder and checking results in Excel. Speaking to that, is there a way to check condition formatting is Spyder w/o having to export to excel? Main question is about the formatting. Thanks and again, love the videos. YOU have single handedly made me a better python user!

[jefralston]

If I have an existing spreadsheet that has a bunch of customization to it, can I take that spreadsheet and create a "style sheet template" from it? That way I can use this stylesheet to use as the basis for creating other sheets with identical formatting but different data? Can you point me in the correct direction for such a task?

[imothar]

Thank you for an interesting video👍 Can you do the same formatting with strings? If so, can you recommend a video or documentation on this matter?

[ganeshgupta]

Can you tell how can we assign custom colours using hex values

[d.i.oluwaseyi]

Please where is the link as promised for windows if you are getting errors when trying to confirm if python has been successfully installed on your system????

[surakshapanchangam]

what if I want color only column names that is (category, month scale, margin, margin_rate ) .

[imwatchingmystories]

Why did this work and not present a Styler datatype error?