Append\Union two or several tables into one

r union read.table
qqqwww picture qqqwww · Apr 26, 2016 · Viewed 18.7k times · Source

I input 5 text data sets into R using read.table. Each data set has the same structure (100 rows, 50 cols). I would like to union\append all the five tables together into one table, which will be 500 rows * 50 cols. Anyone know how to do that?

Answer

Raphael K picture Raphael K · Apr 26, 2016

From package dplyr:

install.packages('dplyr')
library(dplyr)
new_df <- bind_rows(table1, table2, table3, table4, table5)

Related questions

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
Changing column names of a data frame

I have a data frame called "newprice" (see below) and I want to change the column names in my program in R. > newprice Chang. Chang. Chang. 1 100 36 136 2 120 -33 87 3 150 14 164 In fact this is what am doing: names(newprice)[1]<-paste("premium") …

Read More