Traversing, cleaning batch worksheets in batch Excel files, and interacting with MySQL

Cleaning only with Pandas

Photo by the author

Today’s story will include:

1. How to only use pandas to traverse and clean dirty batch Excel worksheets
2. Based on step 1, how to traverse batch Excel workbooks and consolidate the report