Python import multiple csv

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

57 votes89 views11 answers
Python print color
Python
114 votes101 views5 answers
How to use inputs in python
Python
2 votes114 views3 answers
How to get an input into a list python
Python
0 vote118 views1 answer
Fast input python
Python
0 vote108 views1 answer
How to convert array to vector in python
Python
9 votes123 views4 answers
Capitalize first letter of each word python
Python
13 votes113 views3 answers
How to split text into list python by characters
Python
17 votes120 views5 answers
Convert numpy array to tensor
Python
10 votes138 views2 answers
How to detect an even number in python
Python
1 vote166 views1 answer
Howt to make caluclator in python
Python