Hi, > How can I best do this in R? I've looked into merge but it excludes ids that > aren't in all 3 data sets. You need to look a bit harder at merge(), specifically the all.x and all.y options.
Sarah On Thu, Jun 23, 2011 at 12:53 PM, cddesjar <cddesjard...@gmail.com> wrote: > Hi, > I am trying to merge data similar to the example data below > >> dat0 > > id var1 var2 var3 > 2 1 0 1 > 3 1 0 1 > 4 0 1 1 > 5 0 1 1 > >> dat1 > > id var4 var5 var6 > 2 1 0 1 > 3 1 0 1 > 6 0 1 1 > 7 0 1 1 > >> dat2 > > id var7 var8 var9 > 2 1 0 1 > 5 1 0 1 > 6 0 1 1 > 8 0 1 1 > > Basically what I'd like to do is combine these variables on id and create > one large data frame that looks like the following. > >> dat3 > > id var1 var2 var3 var4 var5 var6 var7 var8 var9 > 2 1 0 1 1 0 1 1 0 > 1 > 3 1 0 1 1 0 1 NA NA > NA > 4 0 1 1 NA NA NA NA NA NA > 5 0 1 1 NA NA NA NA NA NA > 6 NA NA NA 0 1 1 0 1 1 > 7 NA NA NA 0 1 1 NA NA NA > 8 NA NA NA NA NA NA 0 1 1 > > How can I best do this in R? I've looked into merge but it excludes ids that > aren't in all 3 data sets. > -- Sarah Goslee http://www.functionaldiversity.org ______________________________________________ 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.
