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 |
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 ... |
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") |
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 |
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