Hi I have two irregular time series, which are of different lengths and being and end at different times. For the common subset of time that they both span, they should have the same values, but the values may occur at slightly different time intervals. I am trying to "line up" the identical values and reconcile them. I have merged the two series into a zoo object which looks like the following:
> head(m) aq$mid d2$mid 2009-06-22 16:25:40.044 NA 1.63755 2009-06-22 16:25:40.909 1.63760 NA 2009-06-22 16:25:40.987 NA 1.63760 2009-06-22 16:25:41.657 1.63755 NA 2009-06-22 16:25:41.738 NA 1.63755 2009-06-22 16:25:41.909 1.63760 NA What I would like to do is merge the series column-wise : ie where one column contains NAs, replace the NAs with the non-NA value from the other column. Is this possible easily? Here is a dput() of the data above: structure(c(NA, 1.6376, NA, 1.63755, NA, 1.6376, 1.63755, NA, 1.6376, NA, 1.63755, NA), .Dim = c(6L, 2L), .Dimnames = list( NULL, c("aq$mid", "d2$mid")), index = structure(c(1245684340.044, 1245684340.909, 1245684340.987, 1245684341.657, 1245684341.738, 1245684341.909), class = c("POSIXt", "POSIXct")), class = "zoo") Cheers -- Rory [[alternative HTML version deleted]] ______________________________________________ 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.