How to use a for loop to create multiple dataframes with different names

Question

for key in CatDict:
    CatName = CatDict[key]['name']
    print('This is the ' + CatName + 'info')
    **Problem Area (CatName + 'DF')** = CalcDF[CalcDF.Cat == CatDict[key]['number']]

Basically what I am trying to do is create a new dataframe that is named by concatenating 'CatName' with the string 'DF' for every iteration of this loop.

I have been having a lot of trouble with that and I am not sure if what I am trying to do is feasible.

The dataframes are already formed outside the for loop I am just doing this to assign them the data that I want

Thank you

Please include a minimal reproducible example. In this current state, I have no idea what you are doing. — piRSquared
– piRSquared, Commented Mar 23, 2021 at 20:14
I asked this question really badly so I am going to think on it some more and if I can't find a solution reask with a better example. Thanks for the help though — BirdBud
– BirdBud, Commented Mar 23, 2021 at 20:28
I understand. But think about it this way. Everyone who could possibly answer your question is someone who volunteers their time. So if you want a good answer, you should do your best to make it as easy as possible to answer. For example, you should have provided the code necessary to construct whatever CatDict is. You should also include a representation of what you think the final result should look like. One the more aggrevating things an answerer can encounter is to try to answer someone's question only for the asker to say "that's not what I meant". — piRSquared
– piRSquared, Commented Mar 23, 2021 at 20:32
Yeah I know. I was under the impression that the question I was asking was more or less straight forward but I have been just working on solving this for the last couple of hours so I guess I put too much on the people answering. — BirdBud
– BirdBud, Commented Mar 23, 2021 at 20:47

RJ Adriaansen · Accepted Answer · 2021-03-23 20:23:12Z

1

You are trying to create variable variable names. This is not recommended. Rather you could create a dictionary of dataframes with their variable names as keys:

dataframes = {key[‘name’] + 'DF': CalcDF[CalcDF.Cat == CatDict[key]['number']] for key in CatDict}

answered Mar 23, 2021 at 20:23

RJ Adriaansen

9,7092 gold badges16 silver badges29 bronze badges

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

1 Comment

BirdBud Over a year ago

Awesome! this is exactly what I was looking for. Thank you very much

Juan Pablo Sepúlveda Adriazola · Accepted Answer · 2021-03-23 20:20:05Z

0

You may utilize the built-in function exec as:

for key in CatDict:
CatName = CatDict[key]['name']
print('This is the ' + CatName + 'info')
exec('{}DF = CalcDF[CalcDF.Cat == CatDict[key]['number']]'.format(CatName))

answered Mar 23, 2021 at 20:20

Juan Pablo Sepúlveda Adriazola

141 bronze badge

1 Comment

Juan Pablo Sepúlveda Adriazola Over a year ago

Maybe there is a syntax error, but the fundamental idea is to interpret a string as code and execute it

Collectives™ on Stack Overflow

How to use a for loop to create multiple dataframes with different names

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related