Python - Pandas - Replace a string from a column based on the value from other column - Dealing with substrings

Question

Based on the following post: Python - Pandas - Replace a string from a column based on the value from other column

I was doing some similar on my side and I have faced new challenges. I use the same example as the previous post.

The new challenge that consists with the substrings.

Imagine that I have the following dataframe:

What I am trying is to replace on col2 the values that exists on col0 with the values from col2.

If I use the code (it is the same from the previous post):

df['col3'] = df['col1'].replace(df['col0'].values, df['col2'].values, regex = True)

I will return the following dataframe:

And what I am trying is the following one:

Can I add some more precision on .values to achieve this?

Thanks!

Did you try with setting regex = False?

Asetti sri harsha
– Asetti sri harsha

2020-02-14 11:40:11 +00:00
Commented Feb 14, 2020 at 11:40 — Asetti sri harsha
– Asetti sri harsha, Commented Feb 14, 2020 at 11:40

jezrael · Accepted Answer · 2020-02-14 11:49:48Z

1

Use re.sub with replace by rows in DataFrame.apply:

import re

df['col3'] = df.apply(lambda x: re.sub(x['col0'],x['col2'],x['col1']), axis=1)

Or in list comprehension:

df['col3'] = [re.sub(a,c,b) for a,b,c in df[['col0','col1','col2']].to_numpy()]

print (df)
        col0                  col1     col2                col3
0    Table 1    Tablename: Table 1  Table A  Tablename: Table A
1    Table 2    Tablename: Table 2  Table B  Tablename: Table B
2  Table 2_1  Tablename: Table 2_1  Table C  Tablename: Table C

edited Feb 14, 2020 at 11:49

answered Feb 14, 2020 at 11:38

jezrael

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

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

Collectives™ on Stack Overflow

Python - Pandas - Replace a string from a column based on the value from other column - Dealing with substrings

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related