R: Stacking mismatched data.frames

Question

I would like to stack vertically two data frames that do not match in variables. For the variables that do not appear in one of the data frames, I would like the variables to be filled in with whatever missing values are appropriate NA or "" as the case may be. I would program something myself but I hate to reinvent the wheel if someone already has programmed this tool.

A <- data.frame(a=1:10, b=rnorm(10), c=rnorm(10))
B <- data.frame(a=1:10, c=rnorm(10), d=rnorm(10))

score 1 · Accepted Answer · edited Jul 07 '15 at 11:21

1

You can use rbindlist after keeping the data.frames in a list

library(data.table)#v1.9.5+
rbindlist(list(A,B), fill=TRUE)

Or

library(dplyr)
bind_rows(A,B)

Or

library(plyr)
rbind.fill(A, B)

edited Jul 07 '15 at 11:21

hrbrmstr

74,560
11
127
189

answered Jul 07 '15 at 11:15

akrun

789,025
32
460
575

1

I'll add the `plyr` one here to keep it all in one referable answer. – hrbrmstr Jul 07 '15 at 11:20

R: Stacking mismatched data.frames

1 Answers1