1# credit to Stack Overflow user in source link
2
3import pandas as pd
4import glob
5
6path = r'C:\DRO\DCL_rawdata_files' # use your path
7all_files = glob.glob(path + "/*.csv")
8
9li = []
10
11for filename in all_files:
12 df = pd.read_csv(filename, index_col=None, header=0)
13 li.append(df)
14
15frame = pd.concat(li, axis=0, ignore_index=True)