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 vote46 views1 answer
How to apply class method to pandas python
Python
0 vote49 views1 answer
How to add 30 minutes in datetime column in pandas
Python
0 vote73 views1 answer
Make screenshot of specific part of screen and save it python
Python
0 vote66 views1 answer
Fomat json load python
Python
0 vote41 views1 answer
Applymap(lambda x: x.encode('unicode_escape'). decode('utf-8') if isinstance(x, str) else x)
Python
4 votes46 views1 answer
Python get file date creation
Python
3 votes62 views3 answers
Simple jwt django
Python Django
0 vote57 views1 answer
Create pandas df without column name toy dataset
Python
0 vote60 views1 answer
Form list of filename get the filename with highest num pythn
Python
1 vote52 views1 answer
Save pythonpath
Python