Pandas Dataframe Replace Substring

Question

For instance I have data similar to this

      name                    flag               seen_week_end
0    Mick Am Johnson         TRUE                 03/05/2017
1    Brian Ma Yeager          FALSE                 NaN
2    Maggie Alvarez       FALSE                NaN
3    Christine Ma Yin           FALSE                NaN

In the above dataframe I want to replace the word in name column

Am as Yan
Ma as Mu

How to use dictionary and replace?

BENY · Accepted Answer · 2019-12-26 03:20:04Z

2

Here is replace

df['name']=df['name'].replace({r'\bAm\b':'Yan',r'\bMa\b':'Mu'},regex=True)

edited Dec 26, 2019 at 3:20

answered Dec 26, 2019 at 3:13

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Pandas Dataframe Replace Substring

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related