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 vote226 views1 answer
Python selenium class
Python
2 votes210 views1 answer
How to find the text inside button in tkinter
Python
20 votes239 views3 answers
How to convert all items in a list to integer python
Python
0 vote224 views1 answer
Squre value of a column pandas
Python
0 vote224 views1 answer
Weight constraints keras cnn
Python
0 vote222 views1 answer
Webex teams api attach file
Python
5 votes216 views2 answers
Python plot two lines on same graph
Python
0 vote218 views1 answer
Import NoSuchKey in boto3
Python
0 vote241 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python
0 vote205 views1 answer
Change date format on django templates
Python