Skip to content

Instantly share code, notes, and snippets.

@0asa

0asa/pandas-merge-xls.py

Created May 22, 2015 08:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 0asa/8c0e762cc13bbf5e13ab to your computer and use it in GitHub Desktop.
Save 0asa/8c0e762cc13bbf5e13ab to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pandas-merge-xls.py
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