how to read multiple CSV files from folder into pandas with dataframe name as file name

Question

I have a folder which contain files like

  dm.csv
  ae.csv
  ex.csv

I want to read all file in one go without specifying file name into pandas with dataframe name as dm, ae, ex respectively.

I have tried different methods like use libraries

 dask.dataframe.read_csv
 glob.glob
 os.listdir

every method indicating concat of all dtaframes but i want individually

Use globand list.

Jan Christoph Terasa
– Jan Christoph Terasa

2019-01-30 07:06:25 +00:00
Commented Jan 30, 2019 at 7:06 — Jan Christoph Terasa
– Jan Christoph Terasa, Commented Jan 30, 2019 at 7:06

Genesis · Accepted Answer · 2019-01-30 07:20:29Z

2

Now you cannot create variable names on fly. But what you can do is create a dictionary of dataframes with key as your file name.

from os import listdir
from os.path import isfile, join
import pandas as pd
mypath = 'folder path'
files = [f.split('.')[0] for f in listdir(mypath) if isfile(join(mypath, f))]

dataframe={}
for file in files:
     dataframe[file] = pd.read_csv(mypath+file+'.csv')#provide separator if required

answered Jan 30, 2019 at 7:20

Genesis

504 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to read multiple CSV files from folder into pandas with dataframe name as file name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related