Hi
>
> On 26 August 2011 03:37, R. Michael Weylandt
<michael.weyla...@gmail.com> wrote:
> > If you could, dput() them so we can see everything about them. You
also
> > might see if merge() gives you more expected behavior....
>
> Ok...
> > dput(a)
> structure(c(7.6343, 7.6343, 7.5458, 7.4532, 7.404, 7.3317), class =
c("xts",
> "zoo"), .indexCLASS = "Date", .indexTZ = "", index =
structure(c(1270105200,
> 1270191600, 1270278000, 1270364400, 1270450800, 1270537200), tzone =
> "", tclass = "Date"), .Dim = c(6L,
> 1L), .Dimnames = list(NULL, "ZWD.UGX"))
> > dput(b)
> structure(c(28.02, 28.3, 28.38, 28.21, 28.31, 28.47), .indexCLASS =
> "Date", .indexTZ = "", src = "yahoo", updated =
> structure(1314356091.21457, class = c("POSIXct",
> "POSIXt")), class = c("xts", "zoo"), index = structure(c(1270072800,
> 1270418400, 1270504800, 1270591200, 1270677600, 1270764000), tzone =
> "", tclass = "Date"), .Dim = c(6L,
> 1L), .Dimnames = list(NULL, "SCHB.Close"))
> > merge(a,b)
> > merge(a,b)
> ZWD.UGX SCHB.Close
> 2010-04-01 NA 28.02
> 2010-04-01 7.6343 NA
> 2010-04-02 7.6343 NA
> 2010-04-03 7.5458 NA
> 2010-04-04 7.4532 NA
> 2010-04-05 NA 28.30
> 2010-04-05 7.4040 NA
> 2010-04-06 NA 28.38
> 2010-04-06 7.3317 NA
> 2010-04-07 NA 28.21
> 2010-04-08 NA 28.31
> 2010-04-09 NA 28.47
> > q()
I get slightly different result
> xx<-(merge(a,b))
> xx
ZWD.UGX SCHB.Close
1270072800 NA 28.02
1270105200 7.6343 NA
1270191600 7.6343 NA
1270278000 7.5458 NA
1270364400 7.4532 NA
1270418400 NA 28.30
1270450800 7.4040 NA
1270504800 NA 28.38
1270537200 7.3317 NA
1270591200 NA 28.21
1270677600 NA 28.31
1270764000 NA 28.47
but from what you want it seems to me that aggregate could be suitable
second step.
something like
aggregate(xx, list(those dates you have but I don't), mean, na.rm=T)
could do what you want.
Regards
Petr
>
> So, no, merge doesn't work...
> --
> Sent from my mobile device
> Envoyait de mon telephone mobil
>
> ______________________________________________
> 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.
