Pandas Dataframe replace part of string with value from another column

Question

I having replace issue while I try to replace a string with value from another column. I want to replace 'Length' with df['Length'].

df["Length"]= df["Length"].replace('Length', df['Length'], regex = True)

Below is my data

Input:
**Formula**  **Length**
Length           5
Length+1.5       6
Length-2.5       5
Length           4
5                5

Expected Output:
**Formula**  **Length**
5                5
6+1.5            6
5-2.5            5
4                4
5                5

However, with the code I used above, it will replace my entire cell instead of Length only. I getting below output: I found it was due to df['column'] is used, if I used any other string the behind offset (-1.5) will not get replaced.

**Formula**  **Length**
5                5
6                6
5                5
4                4
5                5

May I know is there any replace method for values from other columns?

Thank you.

jezrael · Accepted Answer · 2020-07-20 06:56:22Z

18

If want replace by another column is necessary use DataFrame.apply:

df["Formula"]= df.apply(lambda x: x['Formula'].replace('Length', str(x['Length'])), axis=1)
print (df)
  Formula  Length
0       5       5
1   6+1.5       6
2   5-2.5       5
3       4       4
4       5       5

Or list comprehension:

df["Formula"]= [x.replace('Length', str(y)) for x, y  in df[['Formula','Length']].to_numpy()]

edited Jul 20, 2020 at 6:56

answered Jul 20, 2020 at 6:49

jezrael

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

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

1 Comment

Js _ lfzr Over a year ago

Thanks jezrael :) It is working good! Thanks for introduce .apply with me and also the alternative solution. I am really appreciate it :)

pdaawr · Accepted Answer · 2021-11-21 17:06:36Z

0

Just wanted to add, that list comprehension is much faster of course:

df = pd.DataFrame({'a': ['aba'] * 1000000, 'c': ['c'] * 1000000})

%timeit df.apply(lambda x: x['a'].replace('b', x['c']), axis=1)
# 1 loop, best of 5: 11.8 s per loop

%timeit [x.replace('b', str(y)) for x, y in df[['a', 'c']].to_numpy()]
# 1 loop, best of 5: 1.3 s per loop

answered Nov 21, 2021 at 17:06

pdaawr

5989 silver badges20 bronze badges

Collectives™ on Stack Overflow

Pandas Dataframe replace part of string with value from another column

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related