/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

11 votes289 views1 answer
Python discord
Python
0 vote288 views1 answer
Reactstrap example
Python
0 vote296 views1 answer
Printing a varible with a varible. python
Python
3 votes297 views1 answer
Python input separated by
Python
2 votes269 views1 answer
Converting datetime object format to datetime format python
Python
0 vote278 views1 answer
Precision and recall from confusion matrix python
Python
1 vote297 views2 answers
How to 404 custom page not found in django
Python
73 votes291 views6 answers
Python round to two decimals
Python
2 votes296 views1 answer
Python find specific file in directory
Python
5 votes268 views1 answer
Python pip yaml
Python