Python import multiple csv

import pandas as pd
import glob

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 vote300 views1 answer
Combine two dictionary adding values for common keys
Python
0 vote353 views1 answer
Python change terminal name
Python
0 vote346 views1 answer
Displace items in array python
Python
13 votes345 views3 answers
Hstack in numpy
Python
12 votes329 views1 answer
Link shortener
Python
1 vote351 views1 answer
Python convert current datetime to rfc 1123 format
Python
0 vote321 views1 answer
Expected a list of items but got type int . django
Python
0 vote331 views1 answer
Pathlib check is file
Python
0 vote311 views1 answer
Função find python
Python
23 votes314 views3 answers
Python3 format leading 0
Python