Skip to content

Instantly share code, notes, and snippets.

@0asa
Created May 22, 2015 08:57
Show Gist options
  • Save 0asa/8c0e762cc13bbf5e13ab to your computer and use it in GitHub Desktop.
Save 0asa/8c0e762cc13bbf5e13ab to your computer and use it in GitHub Desktop.
import glob
import pandas as pd
files = glob.glob('*.xlsx')
df = pd.DataFrame()
for f in files:
data = pd.read_excel(f,'Sheet1')
df = df.append(data)
df.to_excel('merged.xlsx', index=False)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment