Hi all , I have 12 xts objects of differing timeseries stamp. For example :
> str(s1_predict.xts) An ‘xts’ object from 1990-03-25 20:00:00 to 1990-12-15 09:00:00 containing: Data: num [1:725, 1] 11.23 10.18 9.3 9.74 10.18 ... - attr(*, "dimnames")=List of 2 ..$ : NULL ..$ : NULL Indexed by objects of class: [POSIXt,POSIXct] TZ: Original class: 'double' xts Attributes: NULL > str(s2_predict.xts) An ‘xts’ object from 1990-03-26 22:00:00 to 1990-12-17 containing: Data: num [1:437, 1] 7.79 7.45 7.12 6.27 5.93 ... - attr(*, "dimnames")=List of 2 ..$ : NULL ..$ : NULL Indexed by objects of class: [POSIXt,POSIXct] TZ: Original class: 'double' xts Attributes: NULL I would like to merge all the data onto one xts object. i.e./ put all the time series in order and its corresponding data. I have tried several ways, but it seems because my timestamps all differ, I am not able to use the merge function. If I use the merge function it puts the time series together but the data are all in differing columns, for example , >merge_1<-merge(s1_predict.xts,s2_predict.xts,s3_predict.xts) 1990-03-27 02:00:00 6.142707 NA NA 1990-03-27 03:00:00 6.142707 NA NA 1990-03-27 04:00:00 NA 6.2688687 NA 1990-03-27 05:00:00 NA 5.9300110 NA 1990-03-27 06:00:00 NA NA 6.1398562 1990-03-27 07:00:00 NA NA 5.3504461 Ideally, I would like this : 1990-03-27 02:00:00 6.142707 1990-03-27 03:00:00 6.142707 1990-03-27 04:00:00 6.2688687 1990-03-27 05:00:00 5.9300110 1990-03-27 06:00:00 6.1398562 1990-03-27 07:00:00 5.3504461 Is there a smart way around this? Thank you in advance. -- View this message in context: http://r.789695.n4.nabble.com/Merge-xts-tp2327981p2327981.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.
