Change columns that contain string and replace rows

Question

How could I change all columns that have "change_" in the column name? For these columns I want to then conditionally replace rows. Want in general code for a larger dataset

df         change_1   comment   change_2
             onee       number   two
             three      larger   onee

[df[col].mask(df[col]=="onee","one") for col in df.columns if 'change_' in col]

Expected Output:

df         change_1   comment   change_2
             one       number    two
             three      larger   one

Mayank Porwal · Accepted Answer · 2021-01-05 17:05:27Z

3

Use df.filter to filter out columns and then use df.replace:

In [555]: cols = df.filter(like='change_').columns

In [556]: df[cols] = df[cols].replace('onee', 'one')

In [557]: df
Out[557]: 
  change_1 comment change_2
0      one  number      two
1    three  larger      one

answered Jan 5, 2021 at 17:05

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

Comments

Dani Mesejo · Accepted Answer · 2021-01-05 17:09:01Z

0

You could use str.match to find the columns that start with change_, then use replace:

res = df.columns[df.columns.str.match('change_')]
df[res] = df[res].replace({'onee' : 'one'})
print(df)

Output

  change_1 comment change_2
0      one  number      two
1    three  larger      one

answered Jan 5, 2021 at 17:09

Dani Mesejo

62.2k6 gold badges57 silver badges86 bronze badges

Collectives™ on Stack Overflow

Change columns that contain string and replace rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related