Create categories by comparing a numeric column with a fixed value
dataframe, r
Solution
Try
iris$Regulation <- ifelse(iris$Sepal.Length >=5, "UP", "DOWN")
Problem
Consider the `iris` data: ``` 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 7 4.6 3.4 1.4 0.3 setosa ``` I want to create a new column based on a comparison of the values in variable `Sepal.Length` with a fixed limit / cut-off, e.g. check if the values are larger or smaller than 5: `if Sepal.Length >= 5 assign "UP" else assign "DOWN"` to a new column "Regulation". What's the way to do that?