excel
Combining Spreadsheets with Pandas
Combining Spreadsheets with Pandas
· ☕ 3 min read
Combining Spreadsheets With Pandas I was tasked with combining a bunch of spreadsheets that are automatically generated everynight. The task is super easy with Pandas and Python. So I took those 18 spreadsheets and made each one a different tab in one spreadsheet. WHAM BAM I thought I was done and then I found out the requestor wanted each spreadsheet on the same tab just shoved together one after another. So after some research I figured out Pandas can do this too!