cbind 2 dataframes with different number of rows

by

I think you should instead use merge:

merge(df1, df2, by="year", all = T)

For your data:

df1 = data.frame(matrix(0, 7, 4))
names(df1) = c("year", "avg", "hr", "sal")
df1$year = 2010:2016
df1$avg = c(.3, .29, .275, .280, .295, .33, .315)
df1$hr = c(31, 30, 14, 24, 18, 26, 40)
df1$sal = c(2000, 4000, 600, 800, 1000, 7000, 9000)
df2 = data.frame(matrix(0, 5, 3))
names(df2) = c("year", "pos", "fld")
df2$year = c(2010, 2011, 2013, 2014, 2015)
df2$pos = c('A', 'B', 'C', 'B', 'D')
df2$fld = c(.99,.995,.97,.98,.99)

cbind is meant to column-bind two dataframes that are in all sense compatible. But what you aim to do is actual merge, where you want the elements from the two data frames not be discarded, and for missing values you get NA instead.

More Related Contents:

  1. cbind a dataframe with an empty dataframe – cbind.fill?
  2. cbind: is there a way to have missing values set to NA?
  3. Convert an upper to lower triangle matrix in r [duplicate]
  4. Deleting specific rows with a pattern[start and end indicators] from a dataframe [closed]
  5. Create a sequential number (counter) for rows within each group of a dataframe [duplicate]
  6. Can dplyr package be used for conditional mutating?
  7. ggplot2 keep unused levels barplot
  8. Faster version of combn
  9. as.Date with dates in format m/d/y in R
  10. ggplot2 geom_bar – how to keep order of data.frame [duplicate]
  11. Memory Allocation “Error: cannot allocate vector of size 75.1 Mb” [duplicate]
  12. How do I install an R package from the source tarball on windows?
  13. Remove rows in R matrix where all data is NA [duplicate]
  14. pass function arguments to both dplyr and ggplot
  15. Dynamic column names in data.table
  16. Common legend for multiple plots in R
  17. Find which interval row in a data frame that each element of a vector belongs in
  18. ggplot2: Changing the order of stacks on a bar graph
  19. What’s the difference between integer class and numeric class in R
  20. Center Plot title in ggplot2
  21. In R, how do I add a max by group? [duplicate]
  22. Group by using base R
  23. Saving grid.arrange() plot to file
  24. How to plot a Stacked and grouped bar chart in ggplot?
  25. Sort legend in ggplot2
  26. Efficiently merging two data frames on a non-trivial criteria
  27. The perils of aligning plots in ggplot
  28. How to create a new variable in a data.frame based on a condition?
  29. how to plot ellipse given a general equation in R?
  30. What does the %% operator mean in R? [closed]

Leave a Comment