Merge multiple csv files

path = r'C:\DRO\DCL_rawdata_files' # use your path
all_files = glob.glob(path + "/*.csv")

li = []

for filename in all_files:
    df = pd.read_csv(filename, index_col=None, header=0)
    li.append(df)

frame = pd.concat(li, axis=0, ignore_index=True)

Source: stackoverflow.com

Similar codes

0 vote272 views1 answer
Python use variable name as variable
Python
0 vote280 views1 answer
Passport parsing python
Python
17 votes331 views5 answers
Random python range
Python
0 vote271 views1 answer
Hide password input tkinter
Python
2 votes286 views1 answer
Best python framework
Python
7 votes266 views2 answers
Check if is the last element in list python
Python
3 votes297 views2 answers
Python find largest variable
Python
0 vote307 views1 answer
Python string ignore characters
Python
0 vote276 views1 answer
Draw a bow tie in python
Python
0 vote242 views1 answer
2d list input in python
Python