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

1 vote109 views1 answer
Create iterator object python
Python
0 vote112 views1 answer
Flip a coin with array in python
Python
5 votes165 views3 answers
Pytorch 1.7
Python
0 vote102 views1 answer
Bs4 table examples python
Python
0 vote110 views2 answers
Pandas delete first row
Python
0 vote114 views1 answer
MASS algorithm python
Python
0 vote107 views1 answer
Sqlalchemy datetime default now create table
Python
31 votes109 views3 answers
Pandas order dataframe by column of other dataframe
Python
3 votes122 views4 answers
How to get dictionary input from user in python
Python
6 votes117 views2 answers
Django read mesage
Python