rbind dataframes with a different column name

by

My favourite use of mapply:

Example Data

a <- data.frame(a=runif(5), b=runif(5))
> a
          a         b
1 0.8403348 0.1579255
2 0.4759767 0.8182902
3 0.8091875 0.1080651
4 0.9846333 0.7035959
5 0.2153991 0.8744136

and b

b <- data.frame(c=runif(5), d=runif(5))
> b
          c         d
1 0.7604137 0.9753853
2 0.7553924 0.1210260
3 0.7315970 0.6196829
4 0.5619395 0.1120331
5 0.5711995 0.7252631

Solution

Using mapply:

> mapply(c, a,b)    #or as.data.frame(mapply(c, a,b)) for a data.frame
              a         b
 [1,] 0.8403348 0.1579255
 [2,] 0.4759767 0.8182902
 [3,] 0.8091875 0.1080651
 [4,] 0.9846333 0.7035959
 [5,] 0.2153991 0.8744136
 [6,] 0.7604137 0.9753853
 [7,] 0.7553924 0.1210260
 [8,] 0.7315970 0.6196829
 [9,] 0.5619395 0.1120331
[10,] 0.5711995 0.7252631

And based on @Marat’s comment below:

You can also do data.frame(mapply(c, a, b, SIMPLIFY=FALSE)) or, alternatively, data.frame(Map(c,a,b)) to avoid double data.frame-matrix conversion

More Related Contents:

  1. Converting nested list to dataframe
  2. How can I prevent rbind() from geting really slow as dataframe grows larger?
  3. rbind data frames based on a common pattern in data frame name
  4. Combine several data frames in the global environment by row (rbind)
  5. Reshaping data.frame from wide to long format
  6. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  7. Combine two data frames by rows (rbind) when they have different sets of columns
  8. Counting unique / distinct values by group in a data frame
  9. Convert a list to a data frame
  10. How to combine multiple conditions to subset a data-frame using “OR”?
  11. cbind a dataframe with an empty dataframe – cbind.fill?
  12. Conditional replacement of values in a data.frame
  13. How do I combine two data-frames based on two columns? [duplicate]
  14. Changing Column Names in a List of Data Frames in R
  15. dplyr filter with condition on multiple columns
  16. Find duplicated rows (based on 2 columns) in Data Frame in R
  17. Converting two columns of a data frame to a named vector
  18. R – use rbind on multiple variables with similar names
  19. Change value of variable with dplyr
  20. How to initialize empty data frame (lot of columns at the same time) in R
  21. Practical limits of R data frame
  22. R: Assign variable labels of data frame columns
  23. Read and rbind multiple csv files
  24. Count number of zeros per row, and remove rows with more than n zeros
  25. How I can select rows from a dataframe that do not match?
  26. Select last non-NA value in a row, by row
  27. How to append a whole dataframe to a CSV in R
  28. Convert a data frame to a data.table without copy
  29. How can I merge more than 2 dataframes in R by rownames?
  30. What is the first column in R’s mtcars dataset?

Leave a Comment