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 <smartpink...@yahoo.com>
To: Ye Lin <ye...@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 <ye...@lbl.gov>
To: arun <smartpink...@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 <smartpink...@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 <ye...@lbl.gov>
>To: arun <smartpink...@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?
>
______________________________________________
R-help@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.
