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 <[EMAIL PROTECTED]> 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@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.
