Change Multiindex values in DataFrame

Question

This is may DataFrame (two columns : name and age and two indices : player_id and season_id).

		name	age
player_id	season_id
991	28	Fabio	33
1028	28	Luigi	25

I want to change a value inside the MultiIndex in this way:

		name	age
player id	season id
991	26	Fabio	33
1028	28	Luigi	25

I've tried different ways without any effect.

df.loc[[(991,28)]].index.set_levels = (991,26)
df.loc[[(991,28)]].index.set_levels([991,26], inplace=True)
df.loc[[(991,28)]].index = df.loc[[(991,28)]].index.set_levels([991,26])

Has someone some suggests?

You probably have to build a new index, since index are mostly immutable — sammywemmy
– sammywemmy, Commented Mar 9, 2022 at 12:55

jezrael · Accepted Answer · 2022-03-09 13:13:25Z

1

Use list comprehension with if-else and recreate df.index:

df.index = pd.MultiIndex.from_tuples([(991,26) if x == (991,28) else x for x in df.index], 
                                     names=df.index.names)
print (df)
                      name  age
player_id season_id            
991       26         Fabio   33
1028      28         Luigi   25

edited Mar 9, 2022 at 13:13

answered Mar 9, 2022 at 12:56

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

SergFSM · Accepted Answer · 2022-03-09 15:52:07Z

0

this code should work either:

df.index.set_levels([26,28], level='season_id', inplace=True)

answered Mar 9, 2022 at 15:52

SergFSM

1,4991 gold badge6 silver badges9 bronze badges

Collectives™ on Stack Overflow

Change Multiindex values in DataFrame

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related