remove_NA_in_String #R

remove_NA_in_String

# remove NA in string variables

library(dplyr)
Names = c("Peter","NA", "Gabriel", "John", "Lennon","Stuart")
Country=c("Sweden", "Switzerland", "Cumberland", "Wonderland", "Nowhereland", "Land")
Numbers=c(1,2,3,4,NA,6)
id<- 1:6

data<-data.frame(id, Names, Numbers, Country)
head(data)
str(data)

data<-data %>% 
  mutate(across(where(is.character), str_remove,"NA"))%>%  # this line just removes the NA, result will be an empty string
  mutate(across(where(is.character), na_if,""))

# or even shorter 
data<-data.frame(id, Names, Numbers, Country)

data<-data %>% 
  mutate(across(where(is.character), na_if,"NA"))