Hello Jim,Your example works well.Thank you for your help,Kai On Tuesday, June 1, 2021, 04:59:09 PM PDT, Kai Yang via R-help <r-help@r-project.org> wrote: Hi List, I have a column MMR in a data frame proband_crc2. The column contents missing value and + (means positive). I need to replace all missing value into - (means negative) I did try with difference ways. Below are my testing, but not any one works. Can someone help me? Thanks, Kai proband_crc2 %>% mutate(MMR=recode(MMR, '' = "-")) proband_crc2 <- data.frame (ifelse(proband_crc2$MMR !="+", "-", NA)) proband_crc2$MMR <- ifelse(MMR %in% c(""," ","-"), NA, MMR) proband_crc2$MMR[proband_crc2$MMR==NA] <- "-" proband_crc2 <- data.frame( proband_crc2 %>% mutate(across(c("MMR"), ~ifelse(.==NA, "-", as.character(.)))))
[[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.