[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