[R] Merge xts

Lily_stats
2010-08-17T09:10:01Z

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.