Pandas read all csv in folder

Load all csv files in a folder python pandas

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

2 votes235 views2 answers
Python snippets
Python
2 votes228 views1 answer
Python how to get number of strings in a list
Python
0 vote264 views1 answer
How to find the summation of all the values in a tuple python
Python
3 votes229 views5 answers
Python get attributes of object
Python
4 votes246 views2 answers
Discord py color
Python
0 vote253 views1 answer
How to use methods defined within class
Python
8 votes238 views2 answers
How to count the number of files in a directory using Python
Python
0 vote288 views1 answer
Django tempalte tag datetime to timestamp
Python
1 vote230 views1 answer
Directly changing the fonts in the plotting file
Python
0 vote246 views1 answer
How to import axes3D
Python