/Python/Pandas dataframe from multiple csv

Pandas dataframe from multiple csv

# credit to Stack Overflow user in source link

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

8 votes197 views2 answers
Selenium press button
Python
2 votes206 views2 answers
Read csv and store in dictionary python
Python
1 vote224 views1 answer
Numpy divide array by scalar
Python
8 votes194 views1 answer
Input stdout python
Python
0 vote197 views1 answer
Return tuples form functions in Python
Python
2 votes206 views4 answers
ValueError: Input contains NaN, infinity or a value too large for dtype('float32').
Python
0 vote193 views1 answer
Why python stops after plt.show()
Python
0 vote203 views1 answer
How to get values in each cluster
Python
8 votes229 views1 answer
Show more columns / rows of a Pandas DataFrame
Python
0 vote201 views1 answer
Get the time of 1 minute later in python
Python