Python Loop through Excel sheets, place into one df - Stack Overflow | thiscodeWorks

PHOTO

Tue Jul 23 2024 15:34:32 GMT+0000 (Coordinated Universal Time)

Saved by @knguyencookie

import pandas as pd
 
sheets_dict = pd.read_excel('Book1.xlsx', sheetname=None)
 
full_table = pd.DataFrame()
for name, sheet in sheets_dict.items():
    sheet['sheet'] = name
    sheet = sheet.rename(columns=lambda x: x.split('\n')[-1])
    full_table = full_table.append(sheet)
 
full_table.reset_index(inplace=True, drop=True)
 
print full_table

https://www.thiscodeworks.com/python-loop-through-excel-sheets-place-into-one-df-stack-overflow-python/5ff5c97426c684001453b627

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

dbrix

@knguyencookie

Finding most frequent elements Create a Pandas DataFrame from Lists - GeeksforGeeks pyspark.sql.column — PySpark 3.5.0 documentation Create a subset DataFrame expr() function from pyspark.sql.functions to use SQL syntax Query Azure DB from Databricks Friendly Date Format Create Mnt Dbrix to Azure Storage Python Loop through Excel sheets, place into one df - Stack Overflow | thiscodeWorks Compare Pre Run Df & Post Run Df After Eloqua DataLoad Job Delete Files Older Than 120 Days in a Directory TM Incremental Attendance API

Browse more snippets >>