[R] identify data points by certain criteria

arun smartpink111 at yahoo.com
Fri Jun 14 04:21:52 CEST 2013


Hi,
Check if this works for you:
source("Ye_data.txt")
 dim(dat1)
library(xts)
 xt1<- xts(dat1[,-1],strptime(dat1[,1],"%m/%d/%Y %H:%M"))
xtSub<-xt1["T00:00:00/T08:00:00"]
lst1<-split(xtSub,as.Date(index(xtSub)))
res<- do.call(rbind,lapply(lst1,function(x){indx<- which(rowSums(x)==0);x[indx[which.max(c(diff(indx),0))],]}))
tail(res)

  #                   Var1 Var2
#2012-12-26 03:49:00    0    0
#2012-12-27 02:24:00    0    0
#2012-12-28 06:13:00    0    0
#2012-12-29 02:02:00    0    0
#2012-12-30 06:37:00    0    0
#2012-12-31 07:07:00    0    0
A.K.


----- Original Message -----
From: arun <smartpink111 at yahoo.com>
To: Ye Lin <yelin at lbl.gov>
Cc: 
Sent: Thursday, June 13, 2013 10:04 PM
Subject: Re: [R] identify data points by certain criteria




"""
e.g. 12/31, the time period where sum(Var1+Var2)=0 are:

 from 00:00:00 to 00:55:00 (55 min)

from 01:07:00 to 07:07:00   (6h=360min)
from 07:43:00 to 08:00:00   (17min)

then when apply "sapply(lst1,function(x) {indx <- 
which(rowSums(x)==0);indx1 <- 
which.max(c(1,diff(index(x)[indx])))})", for 12/31 it should return 360 
and 01:07:00

"""

I was trying to understand what you meant by 55 min and 360 min in this case: here, the rows from 1:07:00 to 07:07:00 are zero's for Var1 and Var2.  So, the difference should be 1,1,1,........................1 instead of 55, and 360.  If the 01:07:00 row had both the rows==0 and then all the rows until 07:07:00 have either one of the variables>0, then the difference should 360.  Do you think so?

________________________________
From: Ye Lin <yelin at lbl.gov>
To: arun <smartpink111 at yahoo.com> 
Sent: Thursday, June 13, 2013 8:14 PM
Subject: Re: [R] identify data points by certain criteria



Thanks so much Arun! I feel bad that I take up your spare time though.....

Yes you are right, I dont know what happened to my brain when I typed up the question...It shud return the starting point of max duration of (Var1=0 and Var2=0)






On Thu, Jun 13, 2013 at 4:58 PM, arun <smartpink111 at yahoo.com> wrote:

HI Ye,
>
>I will look it later when I get back to home.
>But before, that let me go back to your dummy dataset.
>
>dat2<-read.table(text="
>
>Time    Var1      Var2
>00:00    1              0
>00:01    0              0
>00:02    1              0
>00:03    1              0
>00:04    0              0
>00:05    1              0
>00:06    1              0
>00:07    1              0
>00:08    1              0
>00:09    0              0
>00:10    1              0
>00:11    1              0
>00:12    1              0
>00:13    0              0
>",sep="",header=TRUE,stringsAsFactors=FALSE)
>
>
>##Your question:
>
>>>>>I want to identify the data points where Var1=0 and Var2=0, ( in this
>>>>>example shud be the points highlighted above), then calculate the time
>>>>>duration between these data points, (in this example, shud be 3min, 5 min
>>>>>and 4min), then identify the starting point of the max time duration ( in
>>>>>this example shud be the starting point of 5-min-duration, return the data
>>>>>points at 00:09), finally return the value in "Time" column ( in this
>>>>>example shud be "00:09")
>
>
> indx<- which(rowSums(dat2[,-1])==0)
> indx
>#[1]  2  5 10 14
>###According to this, the starting point of the max time duration is 00:04
>
>
> dat2[indx[which.max(c(diff(as.numeric(gsub(".*:","",dat2[,1][indx]))),0))],]
>#   Time Var1 Var2
>#5 00:04    0    0
>
>
>Let us clear this first before going to the real dataset.
>
>
>
>
>________________________________
>From: Ye Lin <yelin at lbl.gov>
>To: arun <smartpink111 at yahoo.com>
>Sent: Thursday, June 13, 2013 7:21 PM
>
>Subject: Re: [R] identify data points by certain criteria
>
>
>
>Hey Arun,
>
>The code doesnt return the correct timastamp index. 
>
>e.g. 12/31, the time period where sum(Var1+Var2)=0 are:
>
> from 00:00:00 to 00:55:00 (55 min)
>
>from 01:07:00 to 07:07:00   (6h=360min)
>from 07:43:00 to 08:00:00   (17min)
>
>then when apply "sapply(lst1,function(x) {indx <- which(rowSums(x)==0);indx1 <- which.max(c(1,diff(index(x)[indx])))})", for 12/31 it should return 360 and 01:07:00
>
>however, it returns:
>
>> sapply(lst1,function(x) {indx <- which(rowSums(x)==0);indx1 <- which.max(c(1,diff(index(x)[indx])))})
>2012-12-01 2012-12-02 2012-12-03 2012-12-04 2012-12-05 2012-12-06 2012-12-07 
>       373         41        262        268        266        254        274 
>2012-12-08 2012-12-09 2012-12-10 2012-12-11 2012-12-12 2012-12-13 2012-12-14 
>       109          1        323        264        279        353        265 
>2012-12-15 2012-12-16 2012-12-17 2012-12-18 2012-12-19 2012-12-20 2012-12-21 
>       327        226        264        269        271        267        276 
>2012-12-22 2012-12-23 2012-12-24 2012-12-25 2012-12-26 2012-12-27 2012-12-28 
>       360        162        222         81        231        143        364 
>2012-12-29 2012-12-30 2012-12-31 
>       122        399        418
>
>
>>lst2 <- lapply(lst1,function(x) {indx <- which(rowSums(x)==0);indx1 <- which.max(c(1,diff(index(x)[indx])));index(x)[indx1] })
>
>$`2012-12-31`
>[1] "2012-12-31 06:57:00 PST"
>
>12/31 data:
>2012-12-31 00:00:00            0.000      0.00
>2012-12-31 00:01:00            0.000      0.00
>2012-12-31 00:02:00            0.000      0.00
>2012-12-31 00:03:00            0.000      0.00
>2012-12-31 00:04:00            0.000      0.00
>2012-12-31 00:05:00            0.000      0.00
>2012-12-31 00:06:00            0.000      0.00
>2012-12-31 00:07:00            0.000      0.00
>2012-12-31 00:08:00            0.000      0.00
>2012-12-31 00:09:00            0.000      0.00
>2012-12-31 00:10:00            0.000      0.00
>2012-12-31 00:11:00            0.000      0.00
>2012-12-31 00:12:00            0.000      0.00
>2012-12-31 00:13:00            0.000      0.00
>2012-12-31 00:14:00            0.000      0.00
>2012-12-31 00:15:00            0.000      0.00
>2012-12-31 00:16:00            0.000      0.00
>2012-12-31 00:17:00            0.000      0.00
>2012-12-31 00:18:00            0.000      0.00
>2012-12-31 00:19:00            0.000      0.00
>2012-12-31 00:20:00            0.000      0.00
>2012-12-31 00:21:00            0.000      0.00
>2012-12-31 00:22:00            0.000      0.00
>2012-12-31 00:23:00            0.000      0.00
>2012-12-31 00:24:00            0.000      0.00
>2012-12-31 00:25:00            0.000      0.00
>2012-12-31 00:26:00            0.000      0.00
>2012-12-31 00:27:00            0.000      0.00
>2012-12-31 00:28:00            0.000      0.00
>2012-12-31 00:29:00            0.000      0.00
>2012-12-31 00:30:00            0.000      0.00
>2012-12-31 00:31:00            0.000      0.00
>2012-12-31 00:32:00            0.000      0.00
>2012-12-31 00:33:00            0.000      0.00
>2012-12-31 00:34:00            0.000      0.00
>2012-12-31 00:35:00            0.000      0.00
>2012-12-31 00:36:00            0.000      0.00
>2012-12-31 00:37:00            0.000      0.00
>2012-12-31 00:38:00            0.000      0.00
>2012-12-31 00:39:00            0.000      0.00
>2012-12-31 00:40:00            0.000      0.00
>2012-12-31 00:41:00            0.000      0.00
>2012-12-31 00:42:00            0.000      0.00
>2012-12-31 00:43:00            0.000      0.00
>2012-12-31 00:44:00            0.000      0.00
>2012-12-31 00:45:00            0.000      0.00
>2012-12-31 00:46:00            0.000      0.00
>2012-12-31 00:47:00            0.000      0.00
>2012-12-31 00:48:00            0.000      0.00
>2012-12-31 00:49:00            0.000      0.00
>2012-12-31 00:50:00            0.000      0.00
>2012-12-31 00:51:00            0.000      0.00
>2012-12-31 00:52:00            0.000      0.00
>2012-12-31 00:53:00            0.000      0.00
>2012-12-31 00:54:00            0.000      0.00
>2012-12-31 00:55:00            0.000      0.00
>2012-12-31 00:56:00            1.690      0.00
>2012-12-31 00:57:00            2.324      0.00
>2012-12-31 00:58:00            2.318      0.00
>2012-12-31 00:59:00            2.308      0.00
>2012-12-31 01:00:00            2.303      0.00
>2012-12-31 01:01:00            2.300      0.00
>2012-12-31 01:02:00            2.324      0.00
>2012-12-31 01:03:00            2.333      0.00
>2012-12-31 01:04:00            2.335      0.00
>2012-12-31 01:05:00            2.334      0.00
>2012-12-31 01:06:00            2.258      0.00
>2012-12-31 01:07:00            0.000      0.00
>2012-12-31 01:08:00            0.000      0.00
>2012-12-31 01:09:00            0.000      0.00
>2012-12-31 01:10:00            0.000      0.00
>2012-12-31 01:11:00            0.000      0.00
>2012-12-31 01:12:00            0.000      0.00
>2012-12-31 01:13:00            0.000      0.00
>2012-12-31 01:14:00            0.000      0.00
>2012-12-31 01:15:00            0.000      0.00
>2012-12-31 01:16:00            0.000      0.00
>2012-12-31 01:17:00            0.000      0.00
>2012-12-31 01:18:00            0.000      0.00
>2012-12-31 01:19:00            0.000      0.00
>2012-12-31 01:20:00            0.000      0.00
>2012-12-31 01:21:00            0.000      0.00
>2012-12-31 01:22:00            0.000      0.00
>2012-12-31 01:23:00            0.000      0.00
>2012-12-31 01:24:00            0.000      0.00
>2012-12-31 01:25:00            0.000      0.00
>2012-12-31 01:26:00            0.000      0.00
>2012-12-31 01:27:00            0.000      0.00
>2012-12-31 01:28:00            0.000      0.00
>2012-12-31 01:29:00            0.000      0.00
>2012-12-31 01:30:00            0.000      0.00
>2012-12-31 01:31:00            0.000      0.00
>2012-12-31 01:32:00            0.000      0.00
>2012-12-31 01:33:00            0.000      0.00
>2012-12-31 01:34:00            0.000      0.00
>2012-12-31 01:35:00            0.000      0.00
>2012-12-31 01:36:00            0.000      0.00
>2012-12-31 01:37:00            0.000      0.00
>2012-12-31 01:38:00            0.000      0.00
>2012-12-31 01:39:00            0.000      0.00
>2012-12-31 01:40:00            0.000      0.00
>2012-12-31 01:41:00            0.000      0.00
>2012-12-31 01:42:00            0.000      0.00
>2012-12-31 01:43:00            0.000      0.00
>2012-12-31 01:44:00            0.000      0.00
>2012-12-31 01:45:00            0.000      0.00
>2012-12-31 01:46:00            0.000      0.00
>2012-12-31 01:47:00            0.000      0.00
>2012-12-31 01:48:00            0.000      0.00
>2012-12-31 01:49:00            0.000      0.00
>2012-12-31 01:50:00            0.000      0.00
>2012-12-31 01:51:00            0.000      0.00
>2012-12-31 01:52:00            0.000      0.00
>2012-12-31 01:53:00            0.000      0.00
>2012-12-31 01:54:00            0.000      0.00
>2012-12-31 01:55:00            0.000      0.00
>2012-12-31 01:56:00            0.000      0.00
>2012-12-31 01:57:00            0.000      0.00
>2012-12-31 01:58:00            0.000      0.00
>2012-12-31 01:59:00            0.000      0.00
>2012-12-31 02:00:00            0.000      0.00
>2012-12-31 02:01:00            0.000      0.00
>2012-12-31 02:02:00            0.000      0.00
>2012-12-31 02:03:00            0.000      0.00
>2012-12-31 02:04:00            0.000      0.00
>2012-12-31 02:05:00            0.000      0.00
>2012-12-31 02:06:00            0.000      0.00
>2012-12-31 02:07:00            0.000      0.00
>2012-12-31 02:08:00            0.000      0.00
>2012-12-31 02:09:00            0.000      0.00
>2012-12-31 02:10:00            0.000      0.00
>2012-12-31 02:11:00            0.000      0.00
>2012-12-31 02:12:00            0.000      0.00
>2012-12-31 02:13:00            0.000      0.00
>2012-12-31 02:14:00            0.000      0.00
>2012-12-31 02:15:00            0.000      0.00
>2012-12-31 02:16:00            0.000      0.00
>2012-12-31 02:17:00            0.000      0.00
>2012-12-31 02:18:00            0.000      0.00
>2012-12-31 02:19:00            0.000      0.00
>2012-12-31 02:20:00            0.000      0.00
>2012-12-31 02:21:00            0.000      0.00
>2012-12-31 02:22:00            0.000      0.00
>2012-12-31 02:23:00            0.000      0.00
>2012-12-31 02:24:00            0.000      0.00
>2012-12-31 02:25:00            0.000      0.00
>2012-12-31 02:26:00            0.000      0.00
>2012-12-31 02:27:00            0.000      0.00
>2012-12-31 02:28:00            0.000      0.00
>2012-12-31 02:29:00            0.000      0.00
>2012-12-31 02:30:00            0.000      0.00
>2012-12-31 02:31:00            0.000      0.00
>2012-12-31 02:32:00            0.000      0.00
>2012-12-31 02:33:00            0.000      0.00
>2012-12-31 02:34:00            0.000      0.00
>2012-12-31 02:35:00            0.000      0.00
>2012-12-31 02:36:00            0.000      0.00
>2012-12-31 02:37:00            0.000      0.00
>2012-12-31 02:38:00            0.000      0.00
>2012-12-31 02:39:00            0.000      0.00
>2012-12-31 02:40:00            0.000      0.00
>2012-12-31 02:41:00            0.000      0.00
>2012-12-31 02:42:00            0.000      0.00
>2012-12-31 02:43:00            0.000      0.00
>2012-12-31 02:44:00            0.000      0.00
>2012-12-31 02:45:00            0.000      0.00
>2012-12-31 02:46:00            0.000      0.00
>2012-12-31 02:47:00            0.000      0.00
>2012-12-31 02:48:00            0.000      0.00
>2012-12-31 02:49:00            0.000      0.00
>2012-12-31 02:50:00            0.000      0.00
>2012-12-31 02:51:00            0.000      0.00
>2012-12-31 02:52:00            0.000      0.00
>2012-12-31 02:53:00            0.000      0.00
>2012-12-31 02:54:00            0.000      0.00
>2012-12-31 02:55:00            0.000      0.00
>2012-12-31 02:56:00            0.000      0.00
>2012-12-31 02:57:00            0.000      0.00
>2012-12-31 02:58:00            0.000      0.00
>2012-12-31 02:59:00            0.000      0.00
>2012-12-31 03:00:00            0.000      0.00
>2012-12-31 03:01:00            0.000      0.00
>2012-12-31 03:02:00            0.000      0.00
>2012-12-31 03:03:00            0.000      0.00
>2012-12-31 03:04:00            0.000      0.00
>2012-12-31 03:05:00            0.000      0.00
>2012-12-31 03:06:00            0.000      0.00
>2012-12-31 03:07:00            0.000      0.00
>2012-12-31 03:08:00            0.000      0.00
>2012-12-31 03:09:00            0.000      0.00
>2012-12-31 03:10:00            0.000      0.00
>2012-12-31 03:11:00            0.000      0.00
>2012-12-31 03:12:00            0.000      0.00
>2012-12-31 03:13:00            0.000      0.00
>2012-12-31 03:14:00            0.000      0.00
>2012-12-31 03:15:00            0.000      0.00
>2012-12-31 03:16:00            0.000      0.00
>2012-12-31 03:17:00            0.000      0.00
>2012-12-31 03:18:00            0.000      0.00
>2012-12-31 03:19:00            0.000      0.00
>2012-12-31 03:20:00            0.000      0.00
>2012-12-31 03:21:00            0.000      0.00
>2012-12-31 03:22:00            0.000      0.00
>2012-12-31 03:23:00            0.000      0.00
>2012-12-31 03:24:00            0.000      0.00
>2012-12-31 03:25:00            0.000      0.00
>2012-12-31 03:26:00            0.000      0.00
>2012-12-31 03:27:00            0.000      0.00
>2012-12-31 03:28:00            0.000      0.00
>2012-12-31 03:29:00            0.000      0.00
>2012-12-31 03:30:00            0.000      0.00
>2012-12-31 03:31:00            0.000      0.00
>2012-12-31 03:32:00            0.000      0.00
>2012-12-31 03:33:00            0.000      0.00
>2012-12-31 03:34:00            0.000      0.00
>2012-12-31 03:35:00            0.000      0.00
>2012-12-31 03:36:00            0.000      0.00
>2012-12-31 03:37:00            0.000      0.00
>2012-12-31 03:38:00            0.000      0.00
>2012-12-31 03:39:00            0.000      0.00
>2012-12-31 03:40:00            0.000      0.00
>2012-12-31 03:41:00            0.000      0.00
>2012-12-31 03:42:00            0.000      0.00
>2012-12-31 03:43:00            0.000      0.00
>2012-12-31 03:44:00            0.000      0.00
>2012-12-31 03:45:00            0.000      0.00
>2012-12-31 03:46:00            0.000      0.00
>2012-12-31 03:47:00            0.000      0.00
>2012-12-31 03:48:00            0.000      0.00
>2012-12-31 03:49:00            0.000      0.00
>2012-12-31 03:50:00            0.000      0.00
>2012-12-31 03:51:00            0.000      0.00
>2012-12-31 03:52:00            0.000      0.00
>2012-12-31 03:53:00            0.000      0.00
>2012-12-31 03:54:00            0.000      0.00
>2012-12-31 03:55:00            0.000      0.00
>2012-12-31 03:56:00            0.000      0.00
>2012-12-31 03:57:00            0.000      0.00
>2012-12-31 03:58:00            0.000      0.00
>2012-12-31 03:59:00            0.000      0.00
>2012-12-31 04:00:00            0.000      0.00
>2012-12-31 04:01:00            0.000      0.00
>2012-12-31 04:02:00            0.000      0.00
>2012-12-31 04:03:00            0.000      0.00
>2012-12-31 04:04:00            0.000      0.00
>2012-12-31 04:05:00            0.000      0.00
>2012-12-31 04:06:00            0.000      0.00
>2012-12-31 04:07:00            0.000      0.00
>2012-12-31 04:08:00            0.000      0.00
>2012-12-31 04:09:00            0.000      0.00
>2012-12-31 04:10:00            0.000      0.00
>2012-12-31 04:11:00            0.000      0.00
>2012-12-31 04:12:00            0.000      0.00
>2012-12-31 04:13:00            0.000      0.00
>2012-12-31 04:14:00            0.000      0.00
>2012-12-31 04:15:00            0.000      0.00
>2012-12-31 04:16:00            0.000      0.00
>2012-12-31 04:17:00            0.000      0.00
>2012-12-31 04:18:00            0.000      0.00
>2012-12-31 04:19:00            0.000      0.00
>2012-12-31 04:20:00            0.000      0.00
>2012-12-31 04:21:00            0.000      0.00
>2012-12-31 04:22:00            0.000      0.00
>2012-12-31 04:23:00            0.000      0.00
>2012-12-31 04:24:00            0.000      0.00
>2012-12-31 04:25:00            0.000      0.00
>2012-12-31 04:26:00            0.000      0.00
>2012-12-31 04:27:00            0.000      0.00
>2012-12-31 04:28:00            0.000      0.00
>2012-12-31 04:29:00            0.000      0.00
>2012-12-31 04:30:00            0.000      0.00
>2012-12-31 04:31:00            0.000      0.00
>2012-12-31 04:32:00            0.000      0.00
>2012-12-31 04:33:00            0.000      0.00
>2012-12-31 04:34:00            0.000      0.00
>2012-12-31 04:35:00            0.000      0.00
>2012-12-31 04:36:00            0.000      0.00
>2012-12-31 04:37:00            0.000      0.00
>2012-12-31 04:38:00            0.000      0.00
>2012-12-31 04:39:00            0.000      0.00
>2012-12-31 04:40:00            0.000      0.00
>2012-12-31 04:41:00            0.000      0.00
>2012-12-31 04:42:00            0.000      0.00
>2012-12-31 04:43:00            0.000      0.00
>2012-12-31 04:44:00            0.000      0.00
>2012-12-31 04:45:00            0.000      0.00
>2012-12-31 04:46:00            0.000      0.00
>2012-12-31 04:47:00            0.000      0.00
>2012-12-31 04:48:00            0.000      0.00
>2012-12-31 04:49:00            0.000      0.00
>2012-12-31 04:50:00            0.000      0.00
>2012-12-31 04:51:00            0.000      0.00
>2012-12-31 04:52:00            0.000      0.00
>2012-12-31 04:53:00            0.000      0.00
>2012-12-31 04:54:00            0.000      0.00
>2012-12-31 04:55:00            0.000      0.00
>2012-12-31 04:56:00            0.000      0.00
>2012-12-31 04:57:00            0.000      0.00
>2012-12-31 04:58:00            0.000      0.00
>2012-12-31 04:59:00            0.000      0.00
>2012-12-31 05:00:00            0.000      0.00
>2012-12-31 05:01:00            0.000      0.00
>2012-12-31 05:02:00            0.000      0.00
>2012-12-31 05:03:00            0.000      0.00
>2012-12-31 05:04:00            0.000      0.00
>2012-12-31 05:05:00            0.000      0.00
>2012-12-31 05:06:00            0.000      0.00
>2012-12-31 05:07:00            0.000      0.00
>2012-12-31 05:08:00            0.000      0.00
>2012-12-31 05:09:00            0.000      0.00
>2012-12-31 05:10:00            0.000      0.00
>2012-12-31 05:11:00            0.000      0.00
>2012-12-31 05:12:00            0.000      0.00
>2012-12-31 05:13:00            0.000      0.00
>2012-12-31 05:14:00            0.000      0.00
>2012-12-31 05:15:00            0.000      0.00
>2012-12-31 05:16:00            0.000      0.00
>2012-12-31 05:17:00            0.000      0.00
>2012-12-31 05:18:00            0.000      0.00
>2012-12-31 05:19:00            0.000      0.00
>2012-12-31 05:20:00            0.000      0.00
>2012-12-31 05:21:00            0.000      0.00
>2012-12-31 05:22:00            0.000      0.00
>2012-12-31 05:23:00            0.000      0.00
>2012-12-31 05:24:00            0.000      0.00
>2012-12-31 05:25:00            0.000      0.00
>2012-12-31 05:26:00            0.000      0.00
>2012-12-31 05:27:00            0.000      0.00
>2012-12-31 05:28:00            0.000      0.00
>2012-12-31 05:29:00            0.000      0.00
>2012-12-31 05:30:00            0.000      0.00
>2012-12-31 05:31:00            0.000      0.00
>2012-12-31 05:32:00            0.000      0.00
>2012-12-31 05:33:00            0.000      0.00
>2012-12-31 05:34:00            0.000      0.00
>2012-12-31 05:35:00            0.000      0.00
>2012-12-31 05:36:00            0.000      0.00
>2012-12-31 05:37:00            0.000      0.00
>2012-12-31 05:38:00            0.000      0.00
>2012-12-31 05:39:00            0.000      0.00
>2012-12-31 05:40:00            0.000      0.00
>2012-12-31 05:41:00            0.000      0.00
>2012-12-31 05:42:00            0.000      0.00
>2012-12-31 05:43:00            0.000      0.00
>2012-12-31 05:44:00            0.000      0.00
>2012-12-31 05:45:00            0.000      0.00
>2012-12-31 05:46:00            0.000      0.00
>2012-12-31 05:47:00            0.000      0.00
>2012-12-31 05:48:00            0.000      0.00
>2012-12-31 05:49:00            0.000      0.00
>2012-12-31 05:50:00            0.000      0.00
>2012-12-31 05:51:00            0.000      0.00
>2012-12-31 05:52:00            0.000      0.00
>2012-12-31 05:53:00            0.000      0.00
>2012-12-31 05:54:00            0.000      0.00
>2012-12-31 05:55:00            0.000      0.00
>2012-12-31 05:56:00            0.000      0.00
>2012-12-31 05:57:00            0.000      0.00
>2012-12-31 05:58:00            0.000      0.00
>2012-12-31 05:59:00            0.000      0.00
>2012-12-31 06:00:00            0.000      0.00
>2012-12-31 06:01:00            0.000      0.00
>2012-12-31 06:02:00            0.000      0.00
>2012-12-31 06:03:00            0.000      0.00
>2012-12-31 06:04:00            0.000      0.00
>2012-12-31 06:05:00            0.000      0.00
>2012-12-31 06:06:00            0.000      0.00
>2012-12-31 06:07:00            0.000      0.00
>2012-12-31 06:08:00            0.000      0.00
>2012-12-31 06:09:00            0.000      0.00
>2012-12-31 06:10:00            0.000      0.00
>2012-12-31 06:11:00            0.000      0.00
>2012-12-31 06:12:00            0.000      0.00
>2012-12-31 06:13:00            0.000      0.00
>2012-12-31 06:14:00            0.000      0.00
>2012-12-31 06:15:00            0.000      0.00
>2012-12-31 06:16:00            0.000      0.00
>2012-12-31 06:17:00            0.000      0.00
>2012-12-31 06:18:00            0.000      0.00
>2012-12-31 06:19:00            0.000      0.00
>2012-12-31 06:20:00            0.000      0.00
>2012-12-31 06:21:00            0.000      0.00
>2012-12-31 06:22:00            0.000      0.00
>2012-12-31 06:23:00            0.000      0.00
>2012-12-31 06:24:00            0.000      0.00
>2012-12-31 06:25:00            0.000      0.00
>2012-12-31 06:26:00            0.000      0.00
>2012-12-31 06:27:00            0.000      0.00
>2012-12-31 06:28:00            0.000      0.00
>2012-12-31 06:29:00            0.000      0.00
>2012-12-31 06:30:00            0.000      0.00
>2012-12-31 06:31:00            0.000      0.00
>2012-12-31 06:32:00            0.000      0.00
>2012-12-31 06:33:00            0.000      0.00
>2012-12-31 06:34:00            0.000      0.00
>2012-12-31 06:35:00            0.000      0.00
>2012-12-31 06:36:00            0.000      0.00
>2012-12-31 06:37:00            0.000      0.00
>2012-12-31 06:38:00            0.000      0.00
>2012-12-31 06:39:00            0.000      0.00
>2012-12-31 06:40:00            0.000      0.00
>2012-12-31 06:41:00            0.000      0.00
>2012-12-31 06:42:00            0.000      0.00
>2012-12-31 06:43:00            0.000      0.00
>2012-12-31 06:44:00            0.000      0.00
>2012-12-31 06:45:00            0.000      0.00
>2012-12-31 06:46:00            0.000      0.00
>2012-12-31 06:47:00            0.000      0.00
>2012-12-31 06:48:00            0.000      0.00
>2012-12-31 06:49:00            0.000      0.00
>2012-12-31 06:50:00            0.000      0.00
>2012-12-31 06:51:00            0.000      0.00
>2012-12-31 06:52:00            0.000      0.00
>2012-12-31 06:53:00            0.000      0.00
>2012-12-31 06:54:00            0.000      0.00
>2012-12-31 06:55:00            0.000      0.00
>2012-12-31 06:56:00            0.000      0.00
>2012-12-31 06:57:00            0.000      0.00
>2012-12-31 06:58:00            0.000      0.00
>2012-12-31 06:59:00            0.000      0.00
>2012-12-31 07:00:00            0.000      0.00
>2012-12-31 07:01:00            0.000      0.00
>2012-12-31 07:02:00            0.000      0.00
>2012-12-31 07:03:00            0.000      0.00
>2012-12-31 07:04:00            0.000      0.00
>2012-12-31 07:05:00            0.000      0.00
>2012-12-31 07:06:00            0.000      0.00
>2012-12-31 07:07:00            0.000      0.00
>2012-12-31 07:08:00            0.410      0.00
>2012-12-31 07:09:00            2.289      0.00
>2012-12-31 07:10:00            2.305      0.00
>2012-12-31 07:11:00            2.303      0.00
>2012-12-31 07:12:00            2.301      0.00
>2012-12-31 07:13:00            2.296      0.00
>2012-12-31 07:14:00            2.296      0.00
>2012-12-31 07:15:00            2.299      0.00
>2012-12-31 07:16:00            2.296      0.00
>2012-12-31 07:17:00            2.297      0.00
>2012-12-31 07:18:00            2.298      0.00
>2012-12-31 07:19:00            2.301      0.00
>2012-12-31 07:20:00            2.302      0.00
>2012-12-31 07:21:00            2.304      0.00
>2012-12-31 07:22:00            2.296      0.00
>2012-12-31 07:23:00            2.281      0.00
>2012-12-31 07:24:00            2.270      0.00
>2012-12-31 07:25:00            2.267      0.00
>2012-12-31 07:26:00            2.257      0.00
>2012-12-31 07:27:00            2.258      0.00
>2012-12-31 07:28:00            2.261      0.00
>2012-12-31 07:29:00            2.263      0.00
>2012-12-31 07:30:00            2.261      0.00
>2012-12-31 07:31:00            2.259      0.00
>2012-12-31 07:32:00            2.267      0.00
>2012-12-31 07:33:00            2.288      0.00
>2012-12-31 07:34:00            2.284      0.00
>2012-12-31 07:35:00            2.284      0.00
>2012-12-31 07:36:00            2.287      0.00
>2012-12-31 07:37:00            2.285      0.00
>2012-12-31 07:38:00            2.305      0.00
>2012-12-31 07:39:00            2.307      0.00
>2012-12-31 07:40:00            2.308      0.00
>2012-12-31 07:41:00            2.307      0.00
>2012-12-31 07:42:00            1.631      0.00
>2012-12-31 07:43:00            0.000      0.00
>2012-12-31 07:44:00            0.000      0.00
>2012-12-31 07:45:00            0.000      0.00
>2012-12-31 07:46:00            0.000      0.00
>2012-12-31 07:47:00            0.000      0.00
>2012-12-31 07:48:00            0.000      0.00
>2012-12-31 07:49:00            0.000      0.00
>2012-12-31 07:50:00            0.000      0.00
>2012-12-31 07:51:00            0.000      0.00
>2012-12-31 07:52:00            0.000      0.00
>2012-12-31 07:53:00            0.000      0.00
>2012-12-31 07:54:00            0.000      0.00
>2012-12-31 07:55:00            0.000      0.00
>2012-12-31 07:56:00            0.000      0.00
>2012-12-31 07:57:00            0.000      0.00
>2012-12-31 07:58:00            0.000      0.00
>2012-12-31 07:59:00            0.000      0.00
>2012-12-31 08:00:00            0.000      0.00
>
>I have no clue why it returns index list like that as the code looks fine with me, could you help me with this?
>



More information about the R-help mailing list