Automate Excel | How to produce beautiful, well formatted reports with Python | Pandas | XlsxWriter

Video Description

Python Automation Tutorial In this video we'll cover the basics of how to automate your excel reports. we will see how to produce well composed, visually appealing reports in excel. Pandas makes it very easy to output a DataFrame to Excel. However, there are limited options for customizing the output and using Excel’s features to make your output as useful as it could be. Fortunately, it is easy to use the excellent XlsxWriter module to customize and enhance the Excel workbooks created by Panda’s to_excel function. We will use XlsxWriter and Pandas to produce a well composed, visually appealing, and practical Excel workbooks. What is XlsxWriter? XlsxWriter is a Python module for creating Excel XLSX files. Link to XlsxWriter Library: https://xlsxwriter.readthedocs.io/index.html 💻 Code: https://github.com/hnawaz007/pythondataanalysis/tree/main/AutomateExcelReports ⚙️ Set up Python and Jupyter Environment: https://www.youtube.com/watch?v=B0G-44dqHRM&t Link to Pandas tips and tricks video: https://www.youtube.com/watch?v=-jerzfh2bS0&t --------------------------------------------- Follow me on social media! Subscribe: https://www.youtube.com/c/HaqNawaz Github: https://github.com/hnawaz007 Instagram: https://www.instagram.com/bi_insights_inc LinkedIn: https://www.linkedin.com/in/haq-nawaz/ --------------------------------------------- More information about the XlsxWriter can be found here: https://xlsxwriter.readthedocs.io/index.html #Pandas #ExcelReports #XlsxWriter Topics covered in this video: 0:00 - Intro to XlsxWriter 2:14 - Import libraries and read data 2:44 - Select & rename columns 2:57 - Multiple filter conditions, add new column 3:31 Export simple output to excel 4:21 - XlsxWriter writer, workbook, worksheet 5:19 - Set zoom, format headers & add title 6:19 Format numbers and columns 7:09 Add report totals 8:25 Export formatted report to Excel