RStudio -> How can I combine multiple True/False variables into a single categorical variable?

62 Views Asked by At

Trying to change raw data to categorical groups that can be used in analysis.

Data to look like this enter image description here

df=df %>%
  mutate(
    Swedish=factor(Swedish, levels=c("Checked", "Unchecked")
)

NEWdf$Country=df %>%
  case_when(
      Swedish="Checked"~"Swedish", 
      #ect for other Nationalities, 
      .default="Other"
  )
1

There are 1 best solutions below

0
jyr On

In this case it should be inside a mutate

library(dplyr)
# Example data
df <- data.frame(
  Swedish = sample(c("Checked", "Unchecked"), 10, replace =  TRUE)
)
df=df %>%
  mutate(
    Swedish=factor(Swedish, levels=c("Checked", "Unchecked"))
)

df = df %>%
mutate(country = 
  case_when(
      Swedish == "Checked" ~ "Swedish", 
      TRUE ~ "Other"
  )
)
df

output

     Swedish country
     1    Checked Swedish
     2  Unchecked   Other
     3  Unchecked   Other
     4  Unchecked   Other