slavisha84
2/19/2020 - 2:52 PM

Combining excel sheets

# Import dependencies
import pandas as pd
import numpy as np
import glob

# Read all excel file from specific location
all_data = pd.DataFrame()
for f in glob.glob("C:/TEMPLATES/*.xlsx"):
    df = pd.read_excel(f)
    all_data = all_data.append(df,ignore_index=True)

# Export to excel
all_data.to_excel("ALL_DATA.xlsx", engine='xlsxwriter')

# Import dependencies
import pandas as pd
all_dfs = pd.read_excel("C:/TEMPLATES/TEST.xlsx", sheet_name=None)
df = pd.concat(all_dfs, ignore_index=True)
# Or df = pd.concat(pd.read_excel(workbook_url, sheet_name=None), ignore_index=True)