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

Example: Replace Several Values in Numeric Variables of Data Frame

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

Further Resources & Related Articles

You may find some additional R programming tutorials in the following list.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu
Top