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

2 votes177 views1 answer
How to use sum with range python
Python
2 votes167 views2 answers
Array of random integers python
Python
0 vote225 views1 answer
Django import excel file from same directory
Python Django
0 vote165 views1 answer
Return object in python
Python
0 vote172 views1 answer
HOW TO CREATE A DATETIME LIST QUICK
Python
11 votes165 views2 answers
Re.compile example
Python
0 vote180 views4 answers
Craeting a method that can take any number of arguments in python
Python
0 vote181 views1 answer
Rename column in pandas with second row
Python
1 vote160 views1 answer
For loop in django
Python
0 vote188 views1 answer
Unindent does not match any outer indentation level
Python