Substitute NA values based on second column

Asked Jan 17 '23 at 03:05

Active Jan 17 '23 at 03:05

Viewed 25 times

really simple question here. I need help writing a simple if_else statment.

I need a line of code that replaces NA in column A based on a condition met in column B

Sample code:

for example, if cell incolumnn B=5, then fill NA in column A

Desired output:

A   B
1   3
4   2
NA  5
NA  5

asked Jan 17 '23 at 03:05

pradoer

1

See also [Replace all 0 values to NA](https://stackoverflow.com/questions/11036989/replace-all-0-values-to-na) – benson23 Jan 17 '23 at 03:09
1

If your data frame were called `df1`, you could use `df1$A = ifelse(df1$B == 5, NA, df1$A)` – Jon Spring Jan 17 '23 at 03:13
1

Could also try `df[df$B == 5, “A”] <- NA` – jpsmith Jan 17 '23 at 03:21

0 Answers0