pandas replace part of a column with another column

Question

I have a pandas data frame, let's call it data. data has two columns, column a and column b. Like this:

  a          b
0 aaa        tts
1 abb        tst
2 aba        tss

I would like to replace each "a" in column a with column b.Like this:

  a          b
0 ttsttstts tts
1 tstbb      tst
2 tssbtss    tss

I tied something like this :

data['a'] = data['a'].apply(lambda x:x.replace("sub-string",data['b']))

but as I excepted, did not work. Could anyone please tell me what to do?

EdChum · Accepted Answer · 2016-11-21 09:39:57Z

11

You need to iterate row-wise on the df (passing axis=1) so that you can access the individual 'b' column values that you intend to replace all occurrences of 'a' in the first column:

In [51]:
df['a'] = df.apply(lambda x: x['a'].replace('a',x['b']), axis=1)
df

Out[51]:
           a    b
0  ttsttstts  tts
1      tstbb  tst
2    tssbtss  tss

edited Nov 21, 2016 at 9:39

answered Nov 21, 2016 at 9:28

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

2 Comments

J.Chu Over a year ago

thanks so much this problem has bugged me for a long time and now my mind is finally at peace~~~

ah bon Over a year ago

Sorry, i get an error: TypeError: replace() argument 2 must be str, not float

Collectives™ on Stack Overflow

pandas replace part of a column with another column

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related