Bernhard Von Boyen
2010-Jul-30 08:05 UTC
[R] CBIND / MERGE two time series objects along time (overlapping indices, redundant data)
Hi there, I need to merge/bind two time series objects (from RPackage: timeSeries) by column. The theory is laid out nicely, even for overlapping indices. In my example, I have overlapping indices ("01.01.2001"), where in one time series I have one data point and in the other redundant data. Default usage of merge and cbind would lead to the result that the one data point would be replicated (see example below). However, I do not like the replicating feature and would like to have the NA's filled instead. Desired output, would be: TS.1 SS.2 2001-01-01 23.1 23.1 2001-01-01 NA 23.4 Is there a slick way to produce above result? Thank you for your answer - help is really appreciated. Kind regards, Bernhard. <---------------------------------------------------------------------------------------------------> # R Console example: require(timeSeries) date <-timeDate("01.01.2001", format = "%d.%m.%Y") test1 <- timeSeries(c(23.1), charvec = date) test2 <- timeSeries(c(23.1, 23.4), charvec = c(date, date)) colnames(test2) <- "SS.2" merge(test1, test2) GMT TS.1 SS.2 2001-01-01 23.1 23.1 2001-01-01 23.1 23.4 cbind(test1, test2) Fehler in cbind(deparse.level, ...) : number of rows must match cbind(test2, test1) GMT SS.2 TS.1 2001-01-01 23.1 23.1 2001-01-01 23.4 23.1 [[alternative HTML version deleted]]