Rename Names of MultiIndex Pandas Dataframe

Question

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 !

`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

score 4 · Answer 1 · answered Jun 14 '22 at 11:19

4

Short and simple , it would just rename your columns with respect to Multi-index

df.columns = df.columns.map('_'.join)

answered Jun 14 '22 at 11:19

suraj

81
4

score 2 · Accepted Answer · answered Jan 27 '23 at 08:02

2

df = df.rename(columns={'id_prod': 'no_sales', 'price': 'revenue'}, level=0)

The level=0 indicates where in the multi-index the keys to be renamed can be found.

answered Jan 27 '23 at 08:02

BrsG

146
3

Rename Names of MultiIndex Pandas Dataframe

2 Answers2

Linked

Related