How to apply conditional formatting in Excel using Python | Automate Excel reports | XlsxWriter
In this video we'll cover how to apply conditional formatting in Excel using Python. We will produce well composed, visually appealing Excel reports.
We will cover two methods; first with Pandas and output the DataFrame to Excel. However, there are limited options for customizing the output to make it visually appealing.
In the second method, we will use XlsxWriter module to customize and enhance the Excel workbooks. We will use XlsxWriter apply conditional formatting to an Excel workbook. Also, we will produce a well composed, visually appealing, and practical Excel workbook.
Link to medium article on the topic: https://blog.devgenius.io/how-to-prod...
💻 Code: https://github.com/hnawaz007/pythonda...
Link to Previous video: • Automate Excel | How to produce beaut...
⚙️ Set up Python and Jupyter Environment: • Install Jupyter Notebook on Windows |...
Link to Pandas tips and tricks video:
• Python Pandas Data Science Tutorial (...
---------------------------------------------
Follow me on social media!
Subscribe: / haqnawaz
Github: https://github.com/hnawaz007
Instagram: / bi_insights_inc
LinkedIn: / haq-nawaz
---------------------------------------------
#conditionalformating #Excel #XlsxWriter
Topics covered in this video:
0:00 - Intro to conditional formatting
0:57 - Import libraries and read data
1:27 - Method 1: Function to highlight rows
2:28 - Save to Excel
3:25 Method 2: XlsxWriter
3:40 - Create Excel workbook and worksheet with XlsxWriter
3:54 - Set zoom, format headers & add title
4:20 - Add Title and Sub-title
4:31 - Format numbers
4:50 - Conditional Formatting
6:02 Export formatted report to Excel