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 vote202 views1 answer
Python program to switch first and second characters in a string
Python
11 votes132 views3 answers
Delete row from dataframe python
Python
-1 vote162 views1 answer
Compare list and dataframe in pandas
Python
0 vote162 views1 answer
Pyspark rdd method
Python
36 votes157 views4 answers
Python sum
Python
0 vote118 views2 answers
Loading images as sprites in pygame
Python
0 vote117 views1 answer
Python tkinter dynamic toggle button
Python
2 votes117 views2 answers
How to make a latency command in discord py
Python
28 votes131 views2 answers
Tofixed in python
Python
0 vote123 views1 answer
Python Sorted Word frequency count
Python