How to assign loaded tables to different variables in a loop in Python?

Question

I am trying to import n tables with a loop, giving a different name for each table.

I can write the code to import the tables but I can't give a different name for each table:

the path to find the files (csv)
```
totalbaseURL=('path')
```
find all the csv files
```
folders = os.listdir(totalbaseURL)
```
i.e., folders becomes ["house","cars","food","pubs"].

folders contains the name of the csv files

for f in folders:        
    path=totalbaseURL+f
    table=pd.read_csv(path,delimiter=';')

How could I put, instead of "table"? I would like to use the names in folders: (house, cars, food, pubs).

To associate strings with values, use a dictionary.

Kevin
– Kevin

2018-06-05 16:25:04 +00:00
Commented Jun 5, 2018 at 16:25 — Kevin
– Kevin, Commented Jun 5, 2018 at 16:25

Shivam Singh · Accepted Answer · 2018-06-05 16:32:46Z

2

Use a dict,

folders=["house","cars","food","pubs"]

di = {}

for f in folders:        
    path=totalbaseURL+f
    di[f]=pd.read_csv(path,delimiter=';')

answered Jun 5, 2018 at 16:32

Shivam Singh

1,6241 gold badge11 silver badges9 bronze badges

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

Comments

Shubham Gupta · Accepted Answer · 2018-06-05 16:42:10Z

0

U can use a dict to achieve it:

dataframe_dict = {}
totalbaseURL=('path')
folders = os.listdir(totalbaseURL)
for f in folders:
    path=totalbaseURL+f
    dataframe_dict[f]=pd.read_csv(path,delimiter=';')
print dataframe_dict

Output:

{"house": DataFrame1, "cars": DataFrame2, "food": DataFrame3, "pubs": DataFrame4}

answered Jun 5, 2018 at 16:42

Shubham Gupta

264 bronze badges

Comments

AGN Gazer · Accepted Answer · 2018-06-05 16:59:37Z

0

import os
for f in folders:        
    path = os.path.join(totalbaseURL, f)
    globals()[f] = pd.read_csv(path, delimiter=';')

This will create global variables house, cars, food, and pubs. If this code is inside a function, use locals() instead of globals().

answered Jun 5, 2018 at 16:59

AGN Gazer

8,4272 gold badges31 silver badges49 bronze badges

Collectives™ on Stack Overflow

How to assign loaded tables to different variables in a loop in Python?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related