Answers for "import multiple csv worksheets into multiple dataframes"

pandas dataframe from multiple csv

# credit to Stack Overflow user in source link

import pandas as pd
import glob

path = r'C:DRODCL_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)

Posted by: Guest on May-28-2021

Code answers related to "import multiple csv worksheets into multiple dataframes"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Answers for "import multiple csv worksheets into multiple dataframes"

Code answers related to "import multiple csv worksheets into multiple dataframes"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Answers for "import multiple csv worksheets into multiple dataframes"

Code answers related to "import multiple csv worksheets into multiple dataframes"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us