Changing a NA value

[jaqo]

Hi,
I am searching for the formula to change a 'NA' value with a value such as 'Y' within a column of a dataset.
Thanks,

[bayesian]

Assuming your column is called col1 and your dataset is df, you can do this:

# Replace NAs with "Y", otherwise keep it as the existing value
df <- df %>% 
  mutate(col1 = ifelse(is.na(col1) == TRUE, "Y", col1))

[StatSteph]

Another way is with the function replace_na.

library(tidyverse)

# this replaces all values of NA with a "Y"
df %>% 
  replace_na("Y")

# this replaces all values of NA with a "Y" for variable col1

df %>%
  replace_na(list(col1="Y"))

[jaqo]

Thanks very much. The code worked just fine..