Add (insert) a column between two columns in a data.frame

r dataframe insert
Mark picture Mark · Nov 21, 2012 · Viewed 122.4k times · Source

I have a data frame that has columns a, b, and c. I'd like to add a new column d between b and c.

I know I could just add d at the end by using cbind but how can I insert it in between two columns?

Answer

Kevin Zarca picture Kevin Zarca · Nov 24, 2016

I would suggest you to use the function add_column() from the tibble package.

library(tibble)
dataset <- data.frame(a = 1:5, b = 2:6, c=3:7)
add_column(dataset, d = 4:8, .after = 2)

Note that you can use column names instead of column index :

add_column(dataset, d = 4:8, .after = "b")

Or use argument .before instead of .after if more convenient.

add_column(dataset, d = 4:8, .before = "c")

Related questions

Add new row to dataframe, at specific row-index, not appended?

The following code combines a vector with a dataframe: newrow = c(1:4) existingDF = rbind(existingDF,newrow) However this code always inserts the new row at the end of the dataframe. How can I insert the row at a specified point within …

Read More
Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More
Drop data frame columns by name

I have a number of columns that I would like to remove from a data frame. I know that we can delete them individually using something like: df$x <- NULL But I was hoping to do this with …

Read More