R Create New Data Frame Column Using Other Variables (Example Code)
In this R programming tutorial you’ll learn how to add a new data frame variable according to the values of other columns.
Creation of Example Data
data(iris) # Iris as example data set 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) # Iris as example data set 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: Adding New Variable to Data Frame Using ifelse() Function
iris$new <- ifelse(iris$Sepal.Length > 5 & iris$Sepal.Width > 3.8, "yes", "no") head(iris) # Print updated data # Sepal.Length Sepal.Width Petal.Length Petal.Width Species new # 1 5.1 3.5 1.4 0.2 setosa no # 2 4.9 3.0 1.4 0.2 setosa no # 3 4.7 3.2 1.3 0.2 setosa no # 4 4.6 3.1 1.5 0.2 setosa no # 5 5.0 3.6 1.4 0.2 setosa no # 6 5.4 3.9 1.7 0.4 setosa yes |
iris$new <- ifelse(iris$Sepal.Length > 5 & iris$Sepal.Width > 3.8, "yes", "no") head(iris) # Print updated data # Sepal.Length Sepal.Width Petal.Length Petal.Width Species new # 1 5.1 3.5 1.4 0.2 setosa no # 2 4.9 3.0 1.4 0.2 setosa no # 3 4.7 3.2 1.3 0.2 setosa no # 4 4.6 3.1 1.5 0.2 setosa no # 5 5.0 3.6 1.4 0.2 setosa no # 6 5.4 3.9 1.7 0.4 setosa yes
Further Resources & Related Articles
Have a look at the following R programming tutorials. They illustrate topics such as loops, variables, and lists: