[R] Loading Intraday Time Series Data
Steve Johns
steve.johns at verizon.net
Sun May 16 13:22:31 CEST 2010
Hi,
I am trying to load a data file that looks like this:
|Date,Time,Open,High,Low,Close,Up,Down
05/02/2001,0030,421.20,421.20,421.20,421.20,11,0
05/02/2001,0130,421.20,421.40,421.20,421.40,7,0
05/02/2001,0200,421.30,421.30,421.30,421.30,0,5
05/02/2001,0230,421.60,421.60,421.50,421.50,26,1|
etc.
into an R timeseries or ts object.
The key point is that both the date and time need to become part of the
index.
With zoo, this line will load the data:
z <- read.zoo("foo_hs.csv", format = "%m/%d/%Y", sep=",", header = TRUE )
but the Time does not become part of the index this way. This means the
index is non-unique, and that is not the goal.
Could someone kindly show me a way, using R itself, to deal with the
separate Date and Time columns so as to properly combine them into the
index for the timeseries?
Thanks!
More information about the R-help
mailing list