[R] merging 3 data sets at once

[Gabor Grothendieck]

Using the built in dataset, women, here is a 3-way merge
on height using sqldf:

library(sqldf)
sqldf("select * from women u, women v, women w where u.height =
v.height and v.height = w.height")

See home page at http://sqldf.googlecode.com for more info.


Its also possible in zoo if you can represent your data as zoo objects:

library(zoo)
w <- zoo(women$weight, women$height)
z <- merge(w, w, w) # zoo object
transform(as.data.frame(z), height = time(z)) # data frame

?zoo
?merge.zoo
Also three vignettes in package.

On Wed, Jun 4, 2008 at 7:24 PM, kayj <kjaja27 at yahoo.com> wrote:
>
> Hi All,
>
> I am looking into merging 3 data sets I know how to do that by merging data1
> with data2 and then merging the result with data 3. I was wondering if it
> can be done all at once so I tried,
>
> M<-merge(data1,data2,data3, by="ID")
>
> It does not work!
> Any ideas?
>
>
>
> --
> View this message in context: http://www.nabble.com/merging-3-data-sets-at-once-tp17658873p17658873.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>