-2

I have a data frame and one of the columns contain both continuous data and NA. I want to recode all continuous data as one level of categorical data and the NA as another using if_else() and is.na(). How can I do it?

Example data frame:

df<-tibble(id=1:10,score=c(3,1,-3,-9,NA,NA,12,NA,5,NA))

How can I recode all the numbers into "results" and NA into "no_results"?

P Z
  • 3
  • 2

1 Answers1

0

I have provided a toy example to stand in for the code that you described:

df <- data.frame(x = c(1,2,3,4,NA,NA,NA,NA))

Here, we have a data frame with continuous and NA values, and using dplyr, we can use you functions to categorize "x":

library(dplyr)
df <- df %>% 
mutate(new_data = if_else(is.na(x), "is NA", "is not NA"))

This creates a new column that categorizes your NA values to "is NA".

Kieran Liming
  • 40
  • 4