Merging a lot of data.frames [duplicate]

by

Put them into a list and use merge with Reduce

Reduce(function(x, y) merge(x, y, all=TRUE), list(df1, df2, df3))
#    id v1 v2 v3
# 1   1  1 NA NA
# 2  10  4 NA NA
# 3   2  3  4 NA
# 4  43  5 NA NA
# 5  73  2 NA NA
# 6  23 NA  2  1
# 7  57 NA  3 NA
# 8  62 NA  5  2
# 9   7 NA  1 NA
# 10 96 NA  6 NA

You can also use this more concise version:

Reduce(function(...) merge(..., all=TRUE), list(df1, df2, df3))

More Related Contents:

  1. Simultaneously merge multiple data.frames in a list
  2. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  3. Merge two data frames while keeping the original row order
  4. How do I combine two data-frames based on two columns? [duplicate]
  5. Merge unequal dataframes and replace missing rows with 0
  6. How to append rows to an R data frame
  7. Read and rbind multiple csv files
  8. Select rows from one data.frame that are not present in a second data.frame
  9. Merge data frames based on rownames in R
  10. Merge or combine by rownames
  11. Identify records in data frame A not contained in data frame B [closed]
  12. How can I merge more than 2 dataframes in R by rownames?
  13. Data.frame Merge and Selection of values which are common in 2 Data.frames
  14. Deleting specific rows with a pattern[start and end indicators] from a dataframe [closed]
  15. Replace values in a dataframe based on lookup table
  16. Sample random rows in dataframe
  17. Left join using data.table
  18. Subset / filter rows in a data frame based on a condition in a column
  19. Replacing character values with NA in a data frame
  20. Subset dataframe by multiple logical conditions of rows to remove
  21. Why am I getting X. in my column names when reading a data frame?
  22. Creating a summary statistical table from a data frame
  23. Add an index (numeric ID) column to large data frame [duplicate]
  24. Replace logical values (TRUE / FALSE) with numeric (1 / 0)
  25. Convert a dataframe to a vector (by rows)
  26. Filter data frame rows based on values in vector
  27. Replace empty values with value from other column in a dataframe
  28. Replace value with the name of its respective column
  29. How to create a new variable in a data.frame based on a condition?
  30. Interpolating timeseries

Leave a Comment