[R] rbind with partially overlapping column names

[Dennis Murphy]

Hi:

Another way, with a little less typing but using the same principle, is

df1$c <- df2$a <- NA
rbind(df1, df2)

Dennis

On Sun, May 15, 2011 at 5:50 PM, Ian Gow <iandgow at gmail.com> wrote:
> Hi:
>
> This is a bit of a kluge, but works for your test case:
>
>> df2[,setdiff(names(df1),names(df2))] <- NA
>> df1[,setdiff(names(df2),names(df1))] <- NA
>> df3 <- rbind(df1,df2)
>> df3
> a b c
> 1 A B <NA>
> 2 A B <NA>
> 3 <NA> b c
> 4 <NA> b c
>
> -Ian
>
>
> On 5/15/11 7:41 PM, "Jonathan Flowers" <jonathanmflowers at gmail.com> wrote:
>
>>Hello,
>>
>>I would like to merge two data frames with partially overlapping column
>>names with an rbind-like operation.
>>
>>For the follow data frames,
>>
>>df1 <- data.frame(a=c("A","A"),b=c("B","B"))
>>df2 <- data.frame(b=c("b","b"),c=c("c","c"))
>>
>>I would like the output frame to be (with NAs where the frames don't
>>overlap)
>>
>>a      b     c
>>A     B     NA
>>A     B     NA
>>NA   b     c
>>NA   b     c
>>
>>I am familiar with ?merge and ?rbind, but neither seem to offer a means to
>>accomplish this.
>>
>>Thanks in advance.
>>
>>Jonathan
>>
>>       [[alternative HTML version deleted]]
>>
>>______________________________________________
>>R-help at r-project.org mailing list
>>https://stat.ethz.ch/mailman/listinfo/r-help
>>PLEASE do read the posting guide
>>http://www.R-project.org/posting-guide.html
>>and provide commented, minimal, self-contained, reproducible code.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>