Exchange Multiple Values in Data Frame Variables in R (Example Code)
In this tutorial you’ll learn how to substitute several values in certain data frame variables in R programming.
Creation of Example Data
data(iris) # Example data 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) # Example data 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: Replace Several Values in Numeric Variables of Data Frame
num_col <- 1:4 # Specify numeric columns num_col # [1] 1 2 3 4 |
num_col <- 1:4 # Specify numeric columns num_col # [1] 1 2 3 4
iris_repl <- iris # Replace values in numeric columns iris_repl[ , num_col] <- sapply(iris_repl[ , num_col], function(x) replace(x, x %in% c(1.4, 0.2), "x")) head(iris_repl) # Display new data frame # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 x x setosa # 2 4.9 3 x x setosa # 3 4.7 3.2 1.3 x setosa # 4 4.6 3.1 1.5 x setosa # 5 5 3.6 x x setosa # 6 5.4 3.9 1.7 0.4 setosa |
iris_repl <- iris # Replace values in numeric columns iris_repl[ , num_col] <- sapply(iris_repl[ , num_col], function(x) replace(x, x %in% c(1.4, 0.2), "x")) head(iris_repl) # Display new data frame # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 x x setosa # 2 4.9 3 x x setosa # 3 4.7 3.2 1.3 x setosa # 4 4.6 3.1 1.5 x setosa # 5 5 3.6 x x setosa # 6 5.4 3.9 1.7 0.4 setosa
Further Resources & Related Articles
You may find some additional R programming tutorials in the following list.