/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

1 vote168 views1 answer
Groupby year datetime pandas
Python
0 vote184 views1 answer
Append vector to vector python
Python
-3 votes184 views2 answers
Mean
Python
2 votes229 views2 answers
How to check django rest framework version
Python Django
0 vote236 views1 answer
Find the highest id in model django
Python Django
0 vote172 views1 answer
Counting valleys hackerrank solution python
Python
5 votes176 views2 answers
Python tkinter text get
Python
1 vote203 views1 answer
Django m2m .add
Python Django
2 votes211 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python Django
4 votes176 views3 answers
How to write to an output file in pytion
Python