Pandas dataframe replace with regex doesn't work

Question

I have dataframe with many rows. I want to use pd.replace to replace values in entire columns.

import pandas as pd
import re
list = ['MD 15241', 'MD', 'TD', 'TD 15487']
a = pd.DataFrame(list)
b = a.copy()

b.replace(r'[A-Z]{2}', 'USA', inplace = True)
b

output

    0
0   MD 15241
1   MD
2   TD
3   TD 15487

I tried r'MD' or r'TD' , it works.

You might want to add the tag Pandas

petezurich
– petezurich

2017-09-14 04:40:56 +00:00
Commented Sep 14, 2017 at 4:40 — petezurich
– petezurich, Commented Sep 14, 2017 at 4:40

akuiper · Accepted Answer · 2017-09-14 02:45:05Z

2

You need regex=True in the replace method:

b.replace(r'[A-Z]{2}', 'USA', inplace=True, regex=True)

b
#0
#0  USA 15241
#1  USA
#2  USA
#3  USA 15487

answered Sep 14, 2017 at 2:45

akuiper

216k33 gold badges362 silver badges379 bronze badges

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

Comments

kalehmann · Accepted Answer · 2019-04-08 11:10:02Z

0

def replace_string_inside_df(df):
    df.replace(r'[^a-zA-Z0-9]', ' ', inplace=True, regex=True)
    return df

print(replace_string_inside_df(df))

edited Apr 8, 2019 at 11:10

kalehmann

5,0896 gold badges29 silver badges37 bronze badges

answered Apr 8, 2019 at 10:37

Sushil Ranjan

313 bronze badges

Collectives™ on Stack Overflow

Pandas dataframe replace with regex doesn't work

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related