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/blob/master/Excel%20Files.zip 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: https://twitter.com/DatagyIo Mailing List: https://mailchi.mp/f6a58f2d73d0/datag... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)