Equivalent of SQL CASE WHEN Statement in R (Example Code)
In this R tutorial you’ll learn how to apply the case_when function of the dplyr package.
Example Data
data(iris) # Loading iris data set for the example head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
data(iris) # Loading iris data set for the example head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
Example: Applying cases_when() Function of dplyr Package to Create New Vector of Different Cases
install.packages("dplyr") # Install dplyr package library("dplyr") # Load dplyr package |
install.packages("dplyr") # Install dplyr package library("dplyr") # Load dplyr package
case_when(iris$Sepal.Length > 5 ~ "First Case", # Using case_when() function iris$Sepal.Width <= 3 ~ "Second Case", TRUE ~ "Third Case") # [1] "First Case" "Second Case" "Third Case" "Third Case" "Third Case" "First Case" "Third Case" ... |
case_when(iris$Sepal.Length > 5 ~ "First Case", # Using case_when() function iris$Sepal.Width <= 3 ~ "Second Case", TRUE ~ "Third Case") # [1] "First Case" "Second Case" "Third Case" "Third Case" "Third Case" "First Case" "Third Case" ...