R How to Add a New Variable Between 2 Data Frame Columns (Example Code)

In this tutorial you’ll learn how to append an additional column to a data table in the R programming language.

Example Data

data(iris)                                                     # Iris data set
head(iris)                                                     # Head of 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
add_var <- 1:nrow(iris)                                        # Create new variable
add_var                                                        # Structure of new variable
# [1]   1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20 ...

Example: Inserting New Column with add_column Function of tibble Package

install.packages("tibble")                                       # Install & load tibble
library("tibble")
iris_new <- add_column(iris, add_var, .after = "Sepal.Width")  # Apply add_column function by name
head(iris_new)                                                 # Print updated iris data
#   Sepal.Length Sepal.Width add_var Petal.Length Petal.Width Species
# 1          5.1         3.5       1          1.4         0.2  setosa
# 2          4.9         3.0       2          1.4         0.2  setosa
# 3          4.7         3.2       3          1.3         0.2  setosa
# 4          4.6         3.1       4          1.5         0.2  setosa
# 5          5.0         3.6       5          1.4         0.2  setosa
# 6          5.4         3.9       6          1.7         0.4  setosa

Leave a Reply

Your email address will not be published.

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