Pandas: replace substring in string

Question

I want to replace substring icashier.alipay.com in column in df

url
icashier.alipay.com/catalog/2758186/detail.aspx
icashier.alipay.com/catalog/2758186/detail.aspx
icashier.alipay.com/catalog/2758186/detail.aspx
vk.com

to aliexpress.com.

Desire output

aliexpress.com/catalog/2758186/detail.aspx
aliexpress.com/catalog/2758186/detail.aspx
aliexpress.com/catalog/2758186/detail.aspx
vk.com

I try df['url'].replace('icashier.alipay.com', 'aliexpress.com', 'inplace=True') but it return empty dataframe.

jezrael · Accepted Answer · 2020-08-22 15:38:39Z

48

Use replace with dict for replacing and regex=True:

df['url'] = df['url'].replace({'icashier.alipay.com': 'aliexpress.com'}, regex=True)
print (df)
                                          url
0  aliexpress.com/catalog/2758186/detail.aspx
1  aliexpress.com/catalog/2758186/detail.aspx
2  aliexpress.com/catalog/2758186/detail.aspx
3                                      vk.com

edited Aug 22, 2020 at 15:38

answered Jul 25, 2016 at 10:56

jezrael

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

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

2 Comments

kjohnsen Over a year ago

This appears only to work for a column, not for a dataframe. When I try this on a dataframe it no longer finds substrings.

AstroFloyd Over a year ago

For me this works for both columns and whole dataframes (without .str), for Pandas v2.2.2.

EdChum · Accepted Answer · 2016-07-31 15:40:29Z

31

use str.replace to replace a substring, replace looks for exact matches unless you pass a regex pattern and param regex=True:

In [25]:
df['url'] = df['url'].str.replace('icashier.alipay.com', 'aliexpress.com')
df['url']

Out[25]:
0    aliexpress.com/catalog/2758186/detail.aspx
1    aliexpress.com/catalog/2758186/detail.aspx
2    aliexpress.com/catalog/2758186/detail.aspx
3                                        vk.com
Name: url, dtype: object

edited Jul 31, 2016 at 15:40

answered Jul 25, 2016 at 10:55

EdChum

397k204 gold badges836 silver badges583 bronze badges

2 Comments

TharsDimitris Over a year ago

The .str fixed it for me with this one. if you commit .str then it does not replace substring in string

AstroFloyd Over a year ago

For me this is the opposite - it only works without .str, for Pandas v2.2.2, both for columns and whole dataframes.

Lukas · Accepted Answer · 2021-02-09 15:25:00Z

2

In case someone (like me) needs to replace substring in whole DataFrame:

df = df.apply(lambda col: col.str.replace('icash...', 'aliex...'))

or just in defined columns (and all others remain unchanged):

cols = ['a', 'c'] # list of all columns with value to replace
df = df.apply(lambda col: col.str.replace('icash...', 'aliex...') if col.name in cols else col)

edited Feb 9, 2021 at 15:25

answered Feb 9, 2021 at 15:13

Lukas

2,34722 silver badges28 bronze badges

1 Comment

user5054 Over a year ago

For the entire data frame, you can also use df.replace('icash...', 'aliex...', regex=True)

Collectives™ on Stack Overflow

Pandas: replace substring in string

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related