How the rename all columns using regular expression in Python?

Question

I have columns in pandas data frame that look like:

Variable Names    
name1 [a]

name2 [b]

name3 [c]

I am using the following code to remove all the square brackets and everything within those brackets from all the variable names. This is the code I am using:

import re 
df = df.rename(columns=lambda n: n.replace(r'[\d+.*', r''))

This code is not working. How can I modify this code to get it to work?

Thanks!

ak_slick · Accepted Answer · 2018-04-03 17:00:21Z

1

This should do what you are looking for.

df.rename(columns=lambda x: re.sub("[\[].*?[\]]", "", x))

answered Apr 3, 2018 at 17:00

ak_slick

1,0167 silver badges21 bronze badges

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

1 Comment

ak_slick Over a year ago

Please accept the answer if it works for you. Thanks

Collectives™ on Stack Overflow

How the rename all columns using regular expression in Python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related