Skip to content

Instantly share code, notes, and snippets.

@kstreepy
Created May 29, 2019 17:37
Show Gist options
  • Save kstreepy/365718d5033fa5c84b69c9cec456eefd to your computer and use it in GitHub Desktop.
Save kstreepy/365718d5033fa5c84b69c9cec456eefd to your computer and use it in GitHub Desktop.
Read multiple CSV's in file folder into single pandas dataframe.
import pandas as pd
import glob
def read_multi_csv(path):
'''
Given a file path with wildcard and extension, parse all files with that extension in directory
into a single dataframe.
'''
all_files = glob.glob(path)
li = []
for filename in all_files:
df = pd.read_csv(filename, index_col=None, header=1)
li.append(df)
df = pd.concat(li, axis=0, ignore_index=True)
return df
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment