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 vote152 views3 answers
Pandas assign multiple columns at once
Python
11 votes146 views6 answers
Dataframe delete duplicate rows with same column value
Python
2 votes132 views1 answer
Confidence intervals in python
Python
15 votes177 views4 answers
How to find last element in array python
Python
2 votes164 views3 answers
List to text python
Python
14 votes145 views5 answers
Python trim whitespace from end of string
Python
56 votes140 views6 answers
Scikit learn train test split
Python
-3 votes148 views2 answers
Multiplication table python
Python
4 votes135 views1 answer
Dropdown in tkinter
Python
8 votes133 views1 answer
Numpy where
Python