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.

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

Download the files here: https://github.com/datagy/mediumdata/blob/master/Excel%20Files.zip 

Subscribe: https://www.youtube.com/@datagy/featured 

#excel #python