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

0 vote320 views1 answer
Load pandas dataframe with one row per line and 1 column no delimiter
Python
0 vote332 views1 answer
Purge python3.y from every place in my path
Python
2 votes321 views6 answers
Variable python
Python
7 votes348 views4 answers
Numpy normalize
Python
0 vote376 views1 answer
Highlight Active Links in Django Website
Python Django
0 vote349 views1 answer
Find allurl in text python
Python
10 votes327 views9 answers
Google traduction
Python
0 vote303 views1 answer
How make aloop in python
Python
38 votes320 views6 answers
Pip is not recognized as an internal or external command
Python
1 vote370 views3 answers
Link in embed discord.py
Python