[R] subsetting time series
arun
smartpink111 at yahoo.com
Thu Dec 13 19:34:53 CET 2012
Hi,
Try this:
seq1<-seq(from=as.POSIXct("2012-05-30 18:30:00",tz="UTC"),to=as.POSIXct("2012-05-31 02:30:00",tz="UTC"),by="1 hour")
seq2<-seq(from=as.POSIXct("2012-05-31 00:30:00",tz="UTC"),to=as.POSIXct("2012-05-31 08:30:00",tz="UTC"),by="1 hour")
seq3<-seq(from=as.POSIXct("2012-05-31 06:30:00",tz="UTC"),to=as.POSIXct("2012-05-31 07:30:00",tz="UTC"),by="1 hour")
Sys.setenv(TZ="UTC")
Series1<-c(seq1,seq2,seq3)
split(Series1,rep(1:3,each=9))
#or individually if it is a small dataset
Series1[1:9]
Series1[10:18]
etc.
A.K.
----- Original Message -----
From: m p <mzp3769 at gmail.com>
To: r-help at stat.math.ethz.ch
Cc:
Sent: Thursday, December 13, 2012 11:52 AM
Subject: [R] subsetting time series
Hello,
my series of dates look like
[1] "2012-05-30 18:30:00 UTC" "2012-05-30 19:30:00 UTC"
[3] "2012-05-30 20:30:00 UTC" "2012-05-30 21:30:00 UTC"
[5] "2012-05-30 22:30:00 UTC" "2012-05-30 23:30:00 UTC"
[7] "2012-05-31 00:30:00 UTC" "2012-05-31 01:30:00 UTC"
[9] "2012-05-31 02:30:00 UTC" "2012-05-31 00:30:00 UTC"
[11] "2012-05-31 01:30:00 UTC" "2012-05-31 02:30:00 UTC"
[13] "2012-05-31 03:30:00 UTC" "2012-05-31 04:30:00 UTC"
[15] "2012-05-31 05:30:00 UTC" "2012-05-31 06:30:00 UTC"
[17] "2012-05-31 07:30:00 UTC" "2012-05-31 08:30:00 UTC"
[19] "2012-05-31 06:30:00 UTC" "2012-05-31 07:30:00 UTC"
...
I'd like to subset this to four series
1)
[1] "2012-05-30 18:30:00 UTC" "2012-05-30 19:30:00 UTC"
[3] "2012-05-30 20:30:00 UTC" "2012-05-30 21:30:00 UTC"
[5] "2012-05-30 22:30:00 UTC" "2012-05-30 23:30:00 UTC"
[7] "2012-05-31 00:30:00 UTC" "2012-05-31 01:30:00 UTC"
[9] "2012-05-31 02:30:00 UTC"
[10] "2012-05-31 18:30:00 UTC" "2012-05-31 19:30:00 UTC"
...
2)
"2012-05-31 00:30:00 UTC"
-> [1]
[11] "2012-05-31 01:30:00 UTC" "2012-05-31 02:30:00 UTC" -> [2,3]
[13] "2012-05-31 03:30:00 UTC" "2012-05-31 04:30:00 UTC"
[15] "2012-05-31 05:30:00 UTC" "2012-05-31 06:30:00 UTC"
[17] "2012-05-31 07:30:00 UTC" "2012-05-31 08:30:00 UTC"
[10] "2012-06-01 00:30:00 UTC"
3)
[19] "2012-05-31 06:30:00 UTC" "2012-05-31 07:30:00 UTC"
...
so that I can plot data for each of the series separately without e.g. data
at hour "2012-05-31 02:30:00 UTC" connecting in the figure to "2012-05-31
00:30:00 UTC"
Basically, cycling through the series with period 9
Thanks for any suggestions/help,
thanks,
Mark
[[alternative HTML version deleted]]
______________________________________________
R-help at 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.
More information about the R-help
mailing list