Change column name with matching string from list

Question

Hello i have one pandas datafrmae and a list

my data frame

xy_123        ba_322         ab_321      zx_223

  1            1                1           1 

  s2           f32             r32          s223

list= [ "xy_123_8.4", "ba_322_9.5", "ab_321_8.4", "zx_223_9.5"]

output i am looking at

xy_123_8.4        ba_322_9.5        ab_321_8.4     zx_223_9.5

       1            1                1           1 

       s2           f32             r32          s223

I have large dataframe want to change column name is there any posibility do from python pandas

jezrael · Accepted Answer · 2020-04-20 11:33:53Z

1

Use rename by dictionary:

L =  [ "xy_123_8.4", "ba_322_9.5", "ab_321_8.4", "zx_223_9.5"]

d = {x.rsplit('_', 1)[0]:x for x in L}

df = df.rename(columns=d)
print (df)
  xy_123_8.4 ba_322_9.5 ab_321_8.4 zx_223_9.5
0          1          1          1          1
1         s2        f32        r32       s223

answered Apr 20, 2020 at 11:33

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

hemant c naik Over a year ago

Thank you so much worked fine , same how can change row names

Aravinth · Accepted Answer · 2020-04-20 11:30:06Z

0

I recommend not to use list as a variable name. in your case

df.columns = list

answered Apr 20, 2020 at 11:30

Aravinth

185 bronze badges

Collectives™ on Stack Overflow

Change column name with matching string from list

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related