Skip to main content
AI Assist is now on Stack Overflow. Start a chat to get instant answers from across the network. Sign up to save and share your chats.
2 of 4
edited tags
Aran-Fey
  • 44k
  • 13
  • 113
  • 161

python - Pandas - Dataframe.set_index - how to keep the old index column

I have this Dataframe:

import pandas as pd df = pd.DataFrame({'Hugo' : {'age' : 21, 'weight' : 75}, 'Bertram': {'age' : 45, 'weight' : 65}, 'Donald' : {'age' : 75, 'weight' : 85}}).T df.index.names = ['name'] age weight name Bertram 45 65 Donald 75 85 Hugo 21 75 

now i want to change the index to the column 'age'

df.set_index('age', inplace=True) weight age 45 65 75 85 21 75 

now the old index-column name gets lost. Is there a way to change the index without loosing the old index-column and getting the old column als 'normal' column again, so it should look like this ?

 name weight age 45 Bertram 65 75 Donald 85 21 Hugo 75 

Thanks

Egirus

Egirus Ornila
  • 1.3k
  • 4
  • 17
  • 42