combining two data frames of different lengths [closed]

by

In the plyr package there is a function rbind.fill that will merge data.frames and introduce NA for empty cells:

library(plyr)
combined <- rbind.fill(mtcars[c("mpg", "wt")], mtcars[c("wt", "cyl")])
combined[25:40, ]

    mpg    wt cyl
25 19.2 3.845  NA
26 27.3 1.935  NA
27 26.0 2.140  NA
28 30.4 1.513  NA
29 15.8 3.170  NA
30 19.7 2.770  NA
31 15.0 3.570  NA
32 21.4 2.780  NA
33   NA 2.620   6
34   NA 2.875   6
35   NA 2.320   4

More Related Contents:

  1. Select the row with the maximum value in each group
  2. Create a sequential number (counter) for rows within each group of a dataframe [duplicate]
  3. Extracting specific columns from a data frame
  4. Find indices of duplicated rows [duplicate]
  5. How to drop columns by name in a data frame
  6. Reshape multiple values at once
  7. Remove columns from dataframe where ALL values are NA
  8. How to move cells with a value row-wise to the left in a dataframe [duplicate]
  9. Call apply-like function on each row of dataframe with multiple arguments from each row
  10. How to add a row to a data frame in R?
  11. Replace all particular values in a data frame
  12. Subtract a column in a dataframe from many columns in R
  13. Converting a data frame to xts
  14. Interpolate NA values in a data frame with na.approx
  15. How to subset data in R without losing NA rows?
  16. How to delete columns that contain ONLY NAs?
  17. Using grep to help subset a data frame
  18. Merge rows in a dataframe where the rows are disjoint and contain NAs
  19. How to sort a data frame by date
  20. Randomly insert NAs into dataframe proportionaly
  21. How to delete rows where all the columns are zero
  22. R: Split unbalanced list in data.frame column
  23. Transposing a dataframe maintaining the first column as heading
  24. Should I use a data.frame or a matrix?
  25. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  26. Replace values in data frame based on other data frame in R
  27. Add an image to a table-like output in R
  28. Count unique values for every column
  29. What you can do with a data.frame that you can’t with a data.table?
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment