How to replace value in pandas with value in the same row but in a different column

Question

I have this dataframe. I want to replace all the 'DEBIT' values in the 'Payee' column to their corresponding value in the 'Memo' column.

e.g. the first DEBIT value should be replaced with 'FC02-0224-0185673-83 mom ball tickets' and so on and so forth.

I have experimented with some replace and mask functions to no avail.

Any ideas on how to do this with syntax examples would be greatly appreciated.

images of data/code are not acceptable, please provide reproducible text — mozway
– mozway, Commented Jul 18, 2022 at 8:55
Please post your question in pure text form: why-should-i-not-upload-images-of-code-data-errors-when-asking-a-question — sebo1234
– sebo1234, Commented Jul 18, 2022 at 8:59
@mozway My code is not reproducible as the dataframe is based on an uploaded CSV file, and so it will change everytime. I just need a way of replacing every DEBIT value that exists with the value in the Memo column in the same row. — Nicholas Coetzee
– Nicholas Coetzee, Commented Jul 18, 2022 at 8:59
@BerlinBenilo Sorry, I don't think I can do that as I do not have enough reputation. If you post it as an answer I will gladly mark it correct. Thank you for your help. — Nicholas Coetzee
– Nicholas Coetzee, Commented Jul 18, 2022 at 9:05

Berlin Benilo · Accepted Answer · 2022-07-18 09:03:51Z

1

Try this

df.Payee[df.Payee == 'DEBIT'] = df.Memo

answered Jul 18, 2022 at 9:03

Berlin Benilo

5102 silver badges14 bronze badges

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

1 Answer 1