python pandas rename multiple column headers the same way

Question

Considering a simple df:

HeaderA | HeaderB | HeaderC 
    476      4365      457

Is there a way to rename all columns, for example to add to all columns an "X" in the end?

HeaderAX | HeaderBX | HeaderCX 
    476      4365      457

I am concatenating multiple dataframes and want to easily differentiate the columns dependent on which dataset they came from.

Or is this the only way?

df.rename(columns={'HeaderA': 'HeaderAX'}, inplace=True)

I have over 50 column headers and ten files; so the above approach will take a long time.

Thank You

piRSquared · Accepted Answer · 2017-04-17 21:20:06Z

12

pd.DataFrame.add_suffix

df.add_suffix('X')

   HeaderAX  HeaderBX  HeaderCX
0       476      4365       457

And the sister method
pd.DataFrame.add_prefix

df.add_prefix('X')

   XHeaderA  XHeaderB  XHeaderC
0       476      4365       457

You can also use the pd.DataFrame.rename method and pass a function. To accomplish the same thing:

df.rename(columns='{}X'.format)

   HeaderAX  HeaderBX  HeaderCX
0       476      4365       457

In this example, '{}X'.format is a function that takes a single argument and appends an 'X'

The advantage of this method is that you can use inplace=True if you chose to.

edited Apr 17, 2017 at 21:20

answered Apr 17, 2017 at 21:09

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

1 Comment

piRSquared Over a year ago

@jeangelj glad I can help :-)

Community · Accepted Answer · 2017-05-23 12:17:55Z

2

From SO post. Let's try using a lambda function in rename:

df.rename(columns = lambda x: x+'X', inplace = True)

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Apr 17, 2017 at 21:05

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

Comments

JavNoor · Accepted Answer · 2017-04-17 21:07:39Z

2

df.columns = list(map(lambda s: s+'X', df.columns))

edited Apr 17, 2017 at 21:07

user2285236

answered Apr 17, 2017 at 21:03

JavNoor

4022 silver badges11 bronze badges

Comments

Grr · Accepted Answer · 2017-04-17 21:01:54Z

1

df.columns = [column + 'X' for column in df.columns]

answered Apr 17, 2017 at 21:01

Grr

16.2k7 gold badges72 silver badges91 bronze badges

Collectives™ on Stack Overflow

python pandas rename multiple column headers the same way

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related