Automate Excel Reporting with Python! Combine Workbooks and Add Charts with Pandas and Openpyxl
Learn how to automate boring Excel reporting with Python, by combining workbooks, adding styles, and adding a chart! Learn how to use the Pandas and Openpyxl libraries in this hands-on tutorial.
Download the files here: https://github.com/datagy/mediumdata/...
0:00 Introduction
0:19 Overview
0:59 Installing and Importing Libraries
2:20 Combine Multiple Excel Workbooks with Python
6:45 Summarize Excel Data with Pivot Tables in Python
9:17 Adding Header Rows to Excel with Python
14:09 Adding Charts to Excel with Python
19:30 Adding Formatting to Excel with Python
----------------------------------------------------------
✅ Follow me on other platforms:
Website: https://datagy.io
Twitter: / datagyio
Mailing List: https://mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)
