Hello,
I am new to R and need some help.
I have data in following format
DATA matrix
========================
DateTime o h l c
2009-01-01 07:30:00 2 3 4 5
2009-01-01 07:33:00 4 2 5 7
I am able to fill the gap using combination of seq and chron
2009-01-01 07:30:00
2009-01-01 07:31:00
2009-01-01 07:32:00
2009-01-01 07:33:00
x <- as.numeric(index(DATA[,1]))
y <- x + 100
zz <- seq(x,y,1)
How can I refill a new matrix with the values from the corresponding values
So the data should look like this and then I can apply interpolation on this
data.
DateTime o h l c
2009-01-01 07:30:00 2 3 4 5
2009-01-01 07:31:00 NA NA NA NA
2009-01-01 07:32:00 NA NA NA NA
2009-01-01 07:33:00 4 2 5 7
Or is there a short cut to do direct linear interpolation on the original
data matrix?
Rusty
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
