Rename Names of MultiIndex Pandas Dataframe

Asked Dec 28 '21 at 18:24

Active Feb 26 '22 at 15:09

Viewed 42 times

I'm in trouble with a dataframe created from a groupby function.

df = base.groupby(['year', 'categ']).agg({'id_prod':'count', 'price':'sum'}).unstack(level=1)

it returns this result :

but I would like to rename id_prod and price to no_sales and revenue but I don't know how to do that because of the MultiIndex

with the print(df.columns) the result is :

MultiIndex([('id_prod', 0),
            ('id_prod', 1),
            ('id_prod', 2),
            (  'price', 0),
            (  'price', 1),
            (  'price', 2)],
           names=[None, 'categ'])

So is this names=[] I would like to change Thanks for your help !

edited Feb 26 '22 at 15:09

benson23

8,765
8
15
32

asked Dec 28 '21 at 18:24

Lilly_Co

`df = df.rename(columns={'id_prod': 'no_sales', 'price': 'revenue'})` should work. – Yusuf Ertas Dec 28 '21 at 18:33
Thanks for your answer but df.rename() isn't working because of the mutiindex, it's not basics columns – Lilly_Co Dec 28 '21 at 18:43
Please see [this link](https://stackoverflow.com/a/67458211/10256587). It should work regardless of the multiindex. – Yusuf Ertas Dec 28 '21 at 18:45
Thanks ! I found the solution :) – Lilly_Co Dec 28 '21 at 20:50

Rename Names of MultiIndex Pandas Dataframe

0 Answers0