Replace all specific values in dataframe with value in another column

Question

I have a dataframe where I want to replace all values of 999999 with another column value, while leaving all other values alone. Here is an example of what I have now:

Account	max val	Biology	Statistics
Bill	100	999999	200
Frank	150	150	999999
Wendy	90	999999	100

Here is what I want the dataframe to look like:

Account	max val	Biology	Statistics
Bill	100	100	200
Frank	150	150	150
Wendy	90	90	100

Is there an efficient way to accomplish this?

Thanks in advance.

Presumably all your columns are numeric, not string, or mixed string and numeric. (Because if they were string, you could use df.map(); see Remap values in pandas column with a dict, preserve NaNs) — smci
– smci, Commented Nov 9, 2021 at 5:32

BENY · Accepted Answer · 2021-11-09 04:29:00Z

2

I will do

df = df.mask(df==999999).ffill(axis = 1)
  Account max val Biology Statistics
0    Bill     100     100      200.0
1   Frank     150   150.0      150.0
2   Wendy      90      90      100.0

answered Nov 9, 2021 at 4:29

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Replace all specific values in dataframe with value in another column

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