Python Excel Automation #1 - Consolidate Excel Workbooks, Python Pivot Tables, and Excel Charts

Learn how to automate your Excel spreadsheet reporting with Python and Pandas. You'll learn how to consolidate Excel workbooks, summarize data with pivot tables, format values and add an Excel chart. To learn about glob: https://datagy.io/list-files-os-glob/ To learn about Python Pandas Pivot Tables: https://datagy.io/python-pivot-tables/ Download files: https://github.com/datagy/mediumdata/... 0:00 Overview 1:18 Loading libraries and data 2:40 Loading files with Python glob 3:30 Creating a Summary Pandas Dataframe 6:50 Summarizing data with Pandas Pivot Tables 8:50 Saving Pandas Dataframe to Excel 9:45 Formatting Excel Data with Openpyxl 12:35 Adding an Excel chart with Openpyxl 15:44 Conclusion Learn Python programming the right way! ---------------------------------------------------------- ✅ Check out my eBook to get started with Python for Data Science: https://gumroad.com/l/introtopythonfo... ✅ 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)