5. Loading multiple files

Using For Loop

filenames = [‘sales2015.csv’, ‘sales2016.csv’]

dataframes = [] # initialize an empty list

for f in filenames:

dataframes.append(pd.read_csv(f))

Using a comprehension

filenames = [‘sales2015.csv’, ‘sales2016.csv’]

dataframes = [pd.read_csv(f) for f in filenames]

Using a glob

# Useful for filenames having similar names

from glob import glob

filenames = glob(‘sales*.csv’] #asterisk is a wildcard

dataframes = [pd.read_csv(f) for f in filenames]