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 <iand...@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" <jonathanmflow...@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@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@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@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.
