How do i change column name in a dataframe in python pandas [duplicate]

Question

im new to python, i used to code...

StoreGrouper= DonHenSaless.groupby('Store')
StoreGrouperT= StoreGrouper["SalesDollars"].agg(np.sum)
StoreGrouperT.rename(columns={SalesDollars:TotalSalesDollars})

to group stores and sum by the SalesDollars then rename SalesDollars to TotalSalesDollars. it outputted the following error...

NameError: name 'SalesDollars' is not defined

I also tried using quotes

StoreGrouper= DonHenSaless.groupby('Store')
StoreGrouperT= StoreGrouper["SalesDollars"].agg(np.sum)
StoreGrouperT= StoreGrouperT.rename(columns={'SalesDollars':'TotalSalesDollars'})

This output the error: rename() got an unexpected keyword argument 'columns'

Here is my df df

you're probably working with a Series, rather than a DataFrame after .agg - what happens if you display it or call type()? — ti7
– ti7, Commented Mar 15, 2022 at 18:24
Please provide a minimal reproducible example. How to make good reproducible pandas examples — wwii
– wwii, Commented Mar 15, 2022 at 18:37
Thank you @ti7 that worked didn't realize they were series and not dataframes :) — Danny Warner
– Danny Warner, Commented Mar 15, 2022 at 20:43

Qoi VamBorg · Accepted Answer · 2022-03-15 18:27:15Z

1

In order to rename a column you need quotes so it would be:

StoreGrouperT.rename(columns={'SalesDollars':'TotalSalesDollars'})

Also I usually assign it a variable

StoreGrouperT = StoreGrouperT.rename(columns={'SalesDollars':'TotalSalesDollars'})

answered Mar 15, 2022 at 18:27

Qoi VamBorg

351 silver badge5 bronze badges

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

Comments

Maria Anson · Accepted Answer · 2022-03-15 18:33:14Z

1

Use the pandas rename option to change the column name. You can also use inplace as true if you want your change to get reflected to the dataframe rather than saving it again on the df variable

df.rename(columns={'old_name':'new_name'}, inplace=True)

answered Mar 15, 2022 at 18:33

Maria Anson

132 bronze badges

Collectives™ on Stack Overflow

How do i change column name in a dataframe in python pandas [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related