Using the items in the list as the name for empty pandas data frame

Question

I have a list as below

list = ['df1','df2','df3']

I want to create empty dataframes with these list items and I have tried the below

for i in list:
    str(i) = pd.DataFrame()

I would like to get 3 pandas dataframe created

df1
df2
df3

I have done an extensive search but not able to find a solution.

can the make the question some more clear, by showing your desired output — Jeril, Feb 08 '19 at 04:05
Basically, I want to create 3 empty pandas data frame whose name will be the same as the item names of the list — Ahamed Moosa, Feb 08 '19 at 04:07
`str(i) = pd.DataFrame()` - what are you doing there - how can you equate a string to a dataframe ? — bhaskarc, Feb 08 '19 at 04:10
the items in your list [df1,df2, df3] - is it a list of strings or is it a list of dataframes ? — bhaskarc, Feb 08 '19 at 04:12

score 1 · Accepted Answer · answered Feb 08 '19 at 04:14

1

Use the exec function:

l = ['df1','df2','df3']
for x in l:
    exec('%s = pd.DataFrame()' %x)

answered Feb 08 '19 at 04:14

It_is_Chris

Thanks, but can I have space in the list item? l = ['df 1','df 2','df 3'] Wondering if this will work – Ahamed Moosa Feb 08 '19 at 04:25
@MosesSoleman you cannot have a space. `exec` just excites python code and you cannot set a variable that has a space – It_is_Chris Feb 08 '19 at 04:36
Yeah, understood. sorry I didn't think about that part. I will replace the space with _ – Ahamed Moosa Feb 08 '19 at 04:40
No need to apologize. Good luck! – It_is_Chris Feb 08 '19 at 04:41

1 Answers1