Extracting data from Excel with Python
summary
Shows concrete methods to turn messy Excel into tidy data: reading specific sheets and ranges, collapsing pivot tables into long form, extracting cell metadata like conditional formatting colors and embedded comments, and harvesting repeated small tables across sheets. Uses Pandas, openpyxl, pyjanitor and numpy with about 30 lines to aggregate many tables into ~70 usable rows. Code captures formats and comments as columns so the extraction actually works and is reusable.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 0:45Overview
- 9:49Conditional formatting
- 12:06Embedded comments
- 14:10Small multiples
- 15:47Manipulation
- 19:19Resources
related talks
39mPython & Spreadsheets: 2017 Edition
01h 27mCleaning and Tidying Data in Pandas
01h 24mIntroduction to Data-Analysis with Pandas
01h 25mAdvanced Excel Analytics: Python Integration Workshop
01h 53mAnalyze your data in Python
42mUsing Python pandas for scientific Research
02h 52mFrom Spreadsheets to DataFrames
58mProductivity Revolution in Excel