Rename Dataframe name python

Question

I want to change the name of an dataframe using variables.

db = pd.Dataframe()

sopa = ['cebola','batata']


for sopa_id in sopa: 

    sopa_id = db

I want that the output to be:

 cebola = db

 batata = db

The goal is that each one of the variable get the dataframe name.

So you want to make two copies of `db` and have one named `cebola` and one to be `batata`? — Shavk with a Hoon, Jul 01 '22 at 14:24

Shavk with a Hoon · Answer 1 · 2022-07-01T14:49:52.813

0

For dynamic variable names in python, see How can you dynamically create variables?

The way to do it is to make a dictionary where the key is the name and the value is the dataframe db. I would discourage dynamic variable names as a general rule though.

db = pd.DataFrame()
# -- Do whatever here to populate --
sopa = ['cebola','batata']

dataframeDict = {}
for sopa_id in sopa:
    dataframeDict[sopa_id] = db

edited Jul 01 '22 at 14:49

answered Jul 01 '22 at 14:26

Shavk with a Hoon

568
4
21

Thanks for your answer, but i've got the following result: "NameError: name 'copy' is not defined" – Magalhaez Jul 01 '22 at 14:30
Add import line – Shavk with a Hoon Jul 01 '22 at 14:33
i wan't that the new dataframe name came from the loop "for sopa_id in sopa" where sopa = ['cebola','batata'] – Magalhaez Jul 01 '22 at 14:40
You can simply write: cebola = db.copy() batata = db.copy(). And make sure to capitalize the f in DataFrame not Dataframe – Shodai Thox Jul 01 '22 at 14:41
Why? you can't hardcode that if `sopa` isn't hardcoded. If you want a variable/dynamic variable names then check this out. https://stackoverflow.com/questions/5036700/how-can-you-dynamically-create-variables – Shavk with a Hoon Jul 01 '22 at 14:43

score 0 · Answer 2 · answered Jul 01 '22 at 14:43

I start by saying that what you are doing is probably not good practice. This can probably be solved with dict.

Anyway I think locals() can come in handy.

for i in range(3):
    locals()["var"+str(i)] = i
    
print(var0)
print(var1)
print(var2)

As you can see var0, var1 and var2 don't exist before the loop. You can find more Here!

score 0 · Answer 3 · answered Jul 01 '22 at 14:52

0

Thank you all, problem solved.

db = pd.Dataframe()

sopa = ['cebola','batata']


for sopa_id in sopa: 
    locals()["new_name_is_"+str(sopa_id)] = db

best,

answered Jul 01 '22 at 14:52

Magalhaez

1
1

Rename Dataframe name python

3 Answers3