[R] Summarizing data containing data/time information (as factor)
arun
smartpink111 at yahoo.com
Thu Sep 6 17:41:25 CEST 2012
HI HJ,
No problem.
The gsub() was used to just format your date column to make almost the way you wanted the results:
dat2$date
# [1] "2012-04-29" "2012-04-30" "2012-05-01" "2012-04-28" "2012-04-29"
#[6] "2012-04-30" "2012-05-01" "2012-05-02" "2012-04-30" "2012-05-01"
gsub(".*-(.*)-(.*)","\\2/\\1",dat2$date)
#[1] "29/04" "30/04" "01/05" "28/04" "29/04" "30/04" "01/05" "02/05" "30/04"
#[10] "01/05"
#Suppose I just reverse the contents inside the second " ".
gsub(".*-(.*)-(.*)","\\1/\\2",dat2$date)
#[1] "04/29" "04/30" "05/01" "04/28" "04/29" "04/30" "05/01" "05/02" "04/30"
#[10] "05/01"
#From the p.s., I guess you understand the difference.
#The contents inside the first " " are the pattern we match, and the second " " are the replacement.
#Now, the ".*-(.*)-(.*)" -first .* will match all the contents before "-" in dat2$date. I used brackets (.*) for the second and third so that it could be select those specifically and use it #as replacement \\1 and \\2 inside the second " ".
#If you want to learn regular expressions, there are a lot of resources on the net.
#For example:
http://www.regular-expressions.info/
http://gnosis.cx/publish/programming/regular_expressions.html
A.K.
________________________________
From: HJ YAN <yhj204 at googlemail.com>
To: arun <smartpink111 at yahoo.com>
Sent: Thursday, September 6, 2012 10:49 AM
Subject: Re: [R] Summarizing data containing data/time information (as factor)
Wow! Thanks so much Arun!!
I like this piece of code very much, especially using 'aggregate()' to solve my problem. Marvellous!
The code does what I wanted perfectly. May I just ask how the gsub() bit works, e.g. now I understand it replace the pattern in the first part, and `(.*)` groups everything between the two '-' in my date/time data, but I did not get how the second part works (e.g. '\\2/\\1')?? I think this gsub() and grep() are very useful for coding, so if there is a good source (better than using help(grub)) to learn them that can be recommended that would be very much grateful.
Massive thanks again!
p.s. I just learned using as.Date and mended the following code to make the table in Chronological order as I originally wanted,
e.g. ' 28/04 29/04 30/04 01/05 02/05' rather than '01/05 02/05 28/04 29/04 30/04'
dat2$date1<-as.Date(gsub(".*-(.*)-(.*)","\\2/\\1",dat2$date),format="%d/%m")
HJ
On Thu, Sep 6, 2012 at 1:40 PM, arun <smartpink111 at yahoo.com> wrote:
Hi,
>May be this is what you wanted:
>I named your dput() data as dat1.
> source("HuYan.txt")
>head(dat1)
>dat1$date<- as.Date(dat1$V2,format="%d/%m/%Y %H:%M")
>dat2<-aggregate(V3~date+V1,data=dat1,mean)
>dat2$date1<-gsub(".*-(.*)-(.*)","\\2/\\1",dat2$date)
> dat2$V3<-1
> xtabs(V3~V1+date1,data=dat2)
> date1
>V1 01/05 02/05 28/04 29/04 30/04
>
> 532703 1 0 0 1 1
>
> 532704 1 1 1 1 1
> 532705 1 0 0 0 1
>A.K.
>
>
>
>
>
>
>
>________________________________
>From: HJ YAN <yhj204 at googlemail.com>
>To: arun <smartpink111 at yahoo.com>
>Cc: r-help at r-project.org; dwinsemius at comcast.net
>Sent: Thursday, September 6, 2012 5:02 AM
>Subject: Re: [R] Summarizing data containing data/time information (as factor)
>
>
>
>
>
>
>
>Hi Arun and David
>
>
>Thanks a lot for your reply and sorry for sending the csv file. (p.s. I can download my csv file from the email I sent, so I'm not sure why this doesn`t work for other users...)
>
>
>Anyway, below I used dput() and I am attaching the output from R:
>
>
>structure(list(V1 = c(532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532703L,
>532703L, 532703L, 532703L, 532703L, 532703L, 532703L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532704L,
>532704L, 532704L, 532704L, 532704L, 532704L, 532704L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L, 532705L, 532705L, 532705L,
>532705L, 532705L, 532705L, 532705L), V2 = structure(c(258L, 259L,
>260L, 261L, 262L, 263L, 264L, 265L, 266L, 267L, 268L, 269L, 270L,
>271L, 272L, 273L, 274L, 275L, 276L, 277L, 278L, 279L, 280L, 281L,
>282L, 283L, 284L, 285L, 286L, 287L, 288L, 289L, 290L, 291L, 292L,
>293L, 294L, 295L, 296L, 297L, 298L, 299L, 300L, 301L, 302L, 303L,
>304L, 305L, 306L, 307L, 308L, 309L, 310L, 311L, 312L, 313L, 314L,
>315L, 316L, 317L, 318L, 319L, 320L, 321L, 322L, 323L, 324L, 325L,
>326L, 327L, 328L, 329L, 330L, 331L, 332L, 333L, 334L, 335L, 336L,
>337L, 338L, 339L, 340L, 341L, 342L, 343L, 344L, 345L, 346L, 347L,
>348L, 349L, 350L, 351L, 352L, 353L, 354L, 355L, 356L, 357L, 358L,
>359L, 360L, 361L, 362L, 363L, 364L, 365L, 366L, 367L, 368L, 369L,
>370L, 371L, 372L, 373L, 374L, 375L, 376L, 377L, 378L, 379L, 380L,
>381L, 382L, 383L, 384L, 385L, 386L, 387L, 388L, 389L, 390L, 391L,
>392L, 393L, 394L, 395L, 396L, 397L, 398L, 399L, 400L, 401L, 402L,
>403L, 404L, 405L, 406L, 407L, 408L, 409L, 410L, 411L, 412L, 413L,
>414L, 415L, 416L, 417L, 418L, 419L, 420L, 421L, 422L, 423L, 424L,
>425L, 426L, 427L, 428L, 429L, 430L, 431L, 432L, 433L, 434L, 435L,
>436L, 437L, 438L, 439L, 440L, 441L, 442L, 443L, 444L, 445L, 446L,
>447L, 448L, 449L, 450L, 451L, 452L, 453L, 454L, 455L, 456L, 457L,
>458L, 459L, 460L, 461L, 462L, 463L, 464L, 465L, 466L, 467L, 468L,
>469L, 470L, 471L, 472L, 473L, 474L, 475L, 476L, 477L, 478L, 479L,
>480L, 481L, 482L, 483L, 484L, 485L, 486L, 487L, 488L, 489L, 490L,
>1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L, 11L, 12L, 13L, 14L,
>15L, 16L, 17L, 18L, 19L, 20L, 21L, 22L, 23L, 24L, 25L, 26L, 27L,
>28L, 29L, 30L, 31L, 32L, 33L, 34L, 35L, 36L, 37L, 38L, 39L, 40L,
>41L, 42L, 43L, 44L, 194L, 195L, 196L, 197L, 198L, 199L, 200L,
>201L, 202L, 203L, 204L, 205L, 206L, 207L, 208L, 209L, 210L, 211L,
>212L, 213L, 214L, 215L, 216L, 217L, 218L, 219L, 220L, 221L, 222L,
>223L, 224L, 225L, 226L, 227L, 228L, 229L, 230L, 231L, 232L, 233L,
>234L, 235L, 236L, 237L, 238L, 239L, 240L, 241L, 242L, 243L, 244L,
>245L, 246L, 247L, 248L, 249L, 250L, 251L, 252L, 253L, 254L, 255L,
>256L, 257L, 258L, 259L, 260L, 261L, 262L, 263L, 264L, 265L, 266L,
>267L, 268L, 269L, 270L, 271L, 272L, 273L, 274L, 275L, 276L, 277L,
>278L, 279L, 280L, 281L, 282L, 283L, 284L, 285L, 286L, 287L, 288L,
>289L, 290L, 291L, 292L, 293L, 294L, 295L, 296L, 297L, 298L, 299L,
>300L, 301L, 302L, 303L, 304L, 305L, 306L, 307L, 308L, 309L, 310L,
>311L, 312L, 313L, 314L, 315L, 316L, 317L, 318L, 319L, 320L, 321L,
>322L, 323L, 324L, 325L, 326L, 327L, 328L, 329L, 330L, 331L, 332L,
>333L, 334L, 335L, 336L, 337L, 338L, 339L, 340L, 341L, 342L, 343L,
>344L, 345L, 346L, 347L, 348L, 349L, 350L, 351L, 352L, 353L, 354L,
>355L, 356L, 357L, 358L, 359L, 360L, 361L, 362L, 363L, 364L, 365L,
>366L, 367L, 368L, 369L, 370L, 371L, 372L, 373L, 374L, 375L, 376L,
>377L, 378L, 379L, 380L, 381L, 382L, 383L, 384L, 385L, 386L, 387L,
>388L, 389L, 390L, 391L, 392L, 393L, 394L, 395L, 396L, 397L, 398L,
>399L, 400L, 401L, 402L, 403L, 404L, 405L, 406L, 407L, 408L, 409L,
>410L, 411L, 412L, 413L, 414L, 415L, 416L, 417L, 418L, 419L, 420L,
>421L, 422L, 423L, 424L, 425L, 426L, 427L, 428L, 429L, 430L, 431L,
>432L, 433L, 434L, 435L, 436L, 437L, 438L, 439L, 440L, 441L, 442L,
>443L, 444L, 445L, 446L, 447L, 448L, 449L, 450L, 451L, 452L, 453L,
>454L, 455L, 456L, 457L, 458L, 459L, 460L, 461L, 462L, 463L, 464L,
>465L, 466L, 467L, 468L, 469L, 470L, 471L, 472L, 473L, 474L, 475L,
>476L, 477L, 478L, 479L, 480L, 481L, 482L, 483L, 484L, 485L, 486L,
>487L, 488L, 489L, 490L, 1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L,
>11L, 12L, 13L, 14L, 15L, 16L, 17L, 18L, 19L, 20L, 21L, 22L, 23L,
>24L, 25L, 26L, 27L, 28L, 29L, 30L, 31L, 32L, 33L, 34L, 35L, 36L,
>37L, 38L, 39L, 40L, 41L, 42L, 43L, 44L, 45L, 46L, 47L, 48L, 49L,
>50L, 51L, 52L, 53L, 54L, 55L, 56L, 57L, 58L, 59L, 60L, 61L, 62L,
>63L, 64L, 65L, 66L, 67L, 68L, 69L, 70L, 71L, 72L, 73L, 74L, 75L,
>76L, 77L, 78L, 79L, 80L, 81L, 82L, 83L, 84L, 85L, 86L, 87L, 88L,
>89L, 90L, 91L, 92L, 93L, 94L, 95L, 96L, 97L, 98L, 99L, 100L,
>101L, 102L, 103L, 104L, 105L, 106L, 107L, 108L, 109L, 110L, 111L,
>112L, 113L, 114L, 115L, 116L, 117L, 118L, 119L, 120L, 121L, 122L,
>123L, 124L, 125L, 126L, 127L, 128L, 129L, 130L, 131L, 132L, 133L,
>134L, 135L, 136L, 137L, 138L, 139L, 140L, 141L, 142L, 143L, 144L,
>145L, 146L, 147L, 148L, 149L, 150L, 151L, 152L, 153L, 154L, 155L,
>156L, 157L, 158L, 159L, 160L, 161L, 162L, 163L, 164L, 165L, 166L,
>167L, 168L, 169L, 170L, 171L, 172L, 173L, 174L, 175L, 176L, 177L,
>178L, 179L, 180L, 181L, 182L, 183L, 184L, 185L, 186L, 187L, 188L,
>189L, 190L, 191L, 192L, 193L, 471L, 472L, 473L, 474L, 475L, 476L,
>477L, 478L, 479L, 480L, 481L, 482L, 483L, 484L, 485L, 486L, 487L,
>488L, 489L, 490L, 1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L, 11L,
>12L, 13L, 14L, 15L, 16L, 17L, 18L, 19L, 20L, 21L, 22L, 23L, 24L,
>25L, 26L, 27L, 28L, 29L, 30L, 31L, 32L, 33L, 34L, 35L, 36L, 37L,
>38L, 39L, 40L, 41L, 42L, 43L, 44L, 45L, 46L, 47L, 48L, 49L, 50L,
>51L, 52L, 53L, 54L, 55L, 56L, 57L, 58L, 59L, 60L, 61L, 62L, 63L,
>64L, 65L, 66L, 67L, 68L, 69L, 70L, 71L, 72L, 73L, 74L, 75L, 76L,
>77L, 78L, 79L, 80L, 81L, 82L, 83L, 84L, 85L, 86L, 87L, 88L, 89L,
>90L, 91L, 92L, 93L, 94L, 95L, 96L, 97L, 98L, 99L, 100L, 101L,
>102L, 103L, 104L, 105L, 106L, 107L, 108L, 109L, 110L, 111L, 112L,
>113L, 114L, 115L, 116L, 117L, 118L, 119L, 120L, 121L, 122L, 123L,
>124L, 125L), .Label = c("01/05/2012 00:00", "01/05/2012 00:10",
>"01/05/2012 00:20", "01/05/2012 00:30", "01/05/2012 00:40", "01/05/2012 00:50",
>"01/05/2012 01:00", "01/05/2012 01:10", "01/05/2012 01:20", "01/05/2012 01:30",
>"01/05/2012 01:40", "01/05/2012 01:50", "01/05/2012 02:00", "01/05/2012 02:10",
>"01/05/2012 02:20", "01/05/2012 02:30", "01/05/2012 02:40", "01/05/2012 02:50",
>"01/05/2012 03:00", "01/05/2012 03:10", "01/05/2012 03:20", "01/05/2012 03:30",
>"01/05/2012 03:40", "01/05/2012 03:50", "01/05/2012 04:00", "01/05/2012 04:10",
>"01/05/2012 04:20", "01/05/2012 04:30", "01/05/2012 04:40", "01/05/2012 04:50",
>"01/05/2012 05:00", "01/05/2012 05:10", "01/05/2012 05:20", "01/05/2012 05:30",
>"01/05/2012 05:40", "01/05/2012 05:50", "01/05/2012 06:00", "01/05/2012 06:10",
>"01/05/2012 06:20", "01/05/2012 06:30", "01/05/2012 06:40", "01/05/2012 06:50",
>"01/05/2012 07:00", "01/05/2012 07:10", "01/05/2012 07:20", "01/05/2012 07:30",
>"01/05/2012 07:40", "01/05/2012 07:50", "01/05/2012 08:00", "01/05/2012 08:10",
>"01/05/2012 08:20", "01/05/2012 08:30", "01/05/2012 08:40", "01/05/2012 08:50",
>"01/05/2012 09:00", "01/05/2012 09:10", "01/05/2012 09:20", "01/05/2012 09:30",
>"01/05/2012 09:40", "01/05/2012 09:50", "01/05/2012 10:00", "01/05/2012 10:10",
>"01/05/2012 10:20", "01/05/2012 10:30", "01/05/2012 10:40", "01/05/2012 10:50",
>"01/05/2012 11:00", "01/05/2012 11:10", "01/05/2012 11:20", "01/05/2012 11:30",
>"01/05/2012 11:40", "01/05/2012 11:50", "01/05/2012 12:00", "01/05/2012 12:10",
>"01/05/2012 12:20", "01/05/2012 12:30", "01/05/2012 12:40", "01/05/2012 12:50",
>"01/05/2012 13:00", "01/05/2012 13:10", "01/05/2012 13:20", "01/05/2012 13:30",
>"01/05/2012 13:40", "01/05/2012 13:50", "01/05/2012 14:00", "01/05/2012 14:10",
>"01/05/2012 14:20", "01/05/2012 14:30", "01/05/2012 14:40", "01/05/2012 14:50",
>"01/05/2012 15:00", "01/05/2012 15:10", "01/05/2012 15:20", "01/05/2012 15:30",
>"01/05/2012 15:40", "01/05/2012 15:50", "01/05/2012 16:00", "01/05/2012 16:10",
>"01/05/2012 16:20", "01/05/2012 16:30", "01/05/2012 16:40", "01/05/2012 16:50",
>"01/05/2012 17:00", "01/05/2012 17:10", "01/05/2012 17:20", "01/05/2012 17:30",
>"01/05/2012 17:40", "01/05/2012 17:50", "01/05/2012 18:00", "01/05/2012 18:10",
>"01/05/2012 18:20", "01/05/2012 18:30", "01/05/2012 18:40", "01/05/2012 18:50",
>"01/05/2012 19:00", "01/05/2012 19:10", "01/05/2012 19:20", "01/05/2012 19:30",
>"01/05/2012 19:40", "01/05/2012 19:50", "01/05/2012 20:00", "01/05/2012 20:10",
>"01/05/2012 20:20", "01/05/2012 20:30", "01/05/2012 20:40", "01/05/2012 20:50",
>"01/05/2012 21:00", "01/05/2012 21:10", "01/05/2012 21:20", "01/05/2012 21:30",
>"01/05/2012 21:40", "01/05/2012 21:50", "01/05/2012 22:00", "01/05/2012 22:10",
>"01/05/2012 22:20", "01/05/2012 22:30", "01/05/2012 22:40", "01/05/2012 22:50",
>"01/05/2012 23:00", "01/05/2012 23:10", "01/05/2012 23:20", "01/05/2012 23:30",
>"01/05/2012 23:40", "01/05/2012 23:50", "02/05/2012 00:00", "02/05/2012 00:10",
>"02/05/2012 00:20", "02/05/2012 00:30", "02/05/2012 00:40", "02/05/2012 00:50",
>"02/05/2012 01:00", "02/05/2012 01:10", "02/05/2012 01:20", "02/05/2012 01:30",
>"02/05/2012 01:40", "02/05/2012 01:50", "02/05/2012 02:00", "02/05/2012 02:10",
>"02/05/2012 02:20", "02/05/2012 02:30", "02/05/2012 02:40", "02/05/2012 02:50",
>"02/05/2012 03:00", "02/05/2012 03:10", "02/05/2012 03:20", "02/05/2012 03:30",
>"02/05/2012 03:40", "02/05/2012 03:50", "02/05/2012 04:00", "02/05/2012 04:10",
>"02/05/2012 04:20", "02/05/2012 04:30", "02/05/2012 04:40", "02/05/2012 04:50",
>"02/05/2012 05:00", "02/05/2012 05:10", "02/05/2012 05:20", "02/05/2012 05:30",
>"02/05/2012 05:40", "02/05/2012 05:50", "02/05/2012 06:00", "02/05/2012 06:10",
>"02/05/2012 06:20", "02/05/2012 06:30", "02/05/2012 06:40", "02/05/2012 06:50",
>"02/05/2012 07:00", "02/05/2012 07:10", "02/05/2012 07:20", "02/05/2012 07:30",
>"02/05/2012 07:40", "02/05/2012 07:50", "02/05/2012 08:00", "28/04/2012 22:30",
>"28/04/2012 22:40", "28/04/2012 22:50", "28/04/2012 23:00", "28/04/2012 23:10",
>"28/04/2012 23:20", "28/04/2012 23:30", "28/04/2012 23:40", "28/04/2012 23:50",
>"29/04/2012 00:00", "29/04/2012 00:10", "29/04/2012 00:20", "29/04/2012 00:30",
>"29/04/2012 00:40", "29/04/2012 00:50", "29/04/2012 01:00", "29/04/2012 01:10",
>"29/04/2012 01:20", "29/04/2012 01:30", "29/04/2012 01:40", "29/04/2012 01:50",
>"29/04/2012 02:00", "29/04/2012 02:10", "29/04/2012 02:20", "29/04/2012 02:30",
>"29/04/2012 02:40", "29/04/2012 02:50", "29/04/2012 03:00", "29/04/2012 03:10",
>"29/04/2012 03:20", "29/04/2012 03:30", "29/04/2012 03:40", "29/04/2012 03:50",
>"29/04/2012 04:00", "29/04/2012 04:10", "29/04/2012 04:20", "29/04/2012 04:30",
>"29/04/2012 04:40", "29/04/2012 04:50", "29/04/2012 05:00", "29/04/2012 05:10",
>"29/04/2012 05:20", "29/04/2012 05:30", "29/04/2012 05:40", "29/04/2012 05:50",
>"29/04/2012 06:00", "29/04/2012 06:10", "29/04/2012 06:20", "29/04/2012 06:30",
>"29/04/2012 06:40", "29/04/2012 06:50", "29/04/2012 07:00", "29/04/2012 07:10",
>"29/04/2012 07:20", "29/04/2012 07:30", "29/04/2012 07:40", "29/04/2012 07:50",
>"29/04/2012 08:00", "29/04/2012 08:10", "29/04/2012 08:20", "29/04/2012 08:30",
>"29/04/2012 08:40", "29/04/2012 08:50", "29/04/2012 09:00", "29/04/2012 09:10",
>"29/04/2012 09:20", "29/04/2012 09:30", "29/04/2012 09:40", "29/04/2012 09:50",
>"29/04/2012 10:00", "29/04/2012 10:10", "29/04/2012 10:20", "29/04/2012 10:30",
>"29/04/2012 10:40", "29/04/2012 10:50", "29/04/2012 11:00", "29/04/2012 11:10",
>"29/04/2012 11:20", "29/04/2012 11:30", "29/04/2012 11:40", "29/04/2012 11:50",
>"29/04/2012 12:00", "29/04/2012 12:10", "29/04/2012 12:20", "29/04/2012 12:30",
>"29/04/2012 12:40", "29/04/2012 12:50", "29/04/2012 13:00", "29/04/2012 13:10",
>"29/04/2012 13:20", "29/04/2012 13:30", "29/04/2012 13:40", "29/04/2012 13:50",
>"29/04/2012 14:00", "29/04/2012 14:10", "29/04/2012 14:20", "29/04/2012 14:30",
>"29/04/2012 14:40", "29/04/2012 14:50", "29/04/2012 15:00", "29/04/2012 15:10",
>"29/04/2012 15:20", "29/04/2012 15:30", "29/04/2012 15:40", "29/04/2012 15:50",
>"29/04/2012 16:00", "29/04/2012 16:10", "29/04/2012 16:20", "29/04/2012 16:30",
>"29/04/2012 16:40", "29/04/2012 16:50", "29/04/2012 17:00", "29/04/2012 17:10",
>"29/04/2012 17:20", "29/04/2012 17:30", "29/04/2012 17:40", "29/04/2012 17:50",
>"29/04/2012 18:00", "29/04/2012 18:10", "29/04/2012 18:20", "29/04/2012 18:30",
>"29/04/2012 18:40", "29/04/2012 18:50", "29/04/2012 19:00", "29/04/2012 19:10",
>"29/04/2012 19:20", "29/04/2012 19:30", "29/04/2012 19:40", "29/04/2012 19:50",
>"29/04/2012 20:00", "29/04/2012 20:10", "29/04/2012 20:20", "29/04/2012 20:30",
>"29/04/2012 20:40", "29/04/2012 20:50", "29/04/2012 21:00", "29/04/2012 21:10",
>"29/04/2012 21:20", "29/04/2012 21:30", "29/04/2012 21:40", "29/04/2012 21:50",
>"29/04/2012 22:00", "29/04/2012 22:10", "29/04/2012 22:20", "29/04/2012 22:30",
>"29/04/2012 22:40", "29/04/2012 22:50", "29/04/2012 23:00", "29/04/2012 23:10",
>"29/04/2012 23:20", "29/04/2012 23:30", "29/04/2012 23:40", "29/04/2012 23:50",
>"30/04/2012 00:00", "30/04/2012 00:10", "30/04/2012 00:20", "30/04/2012 00:30",
>"30/04/2012 00:40", "30/04/2012 00:50", "30/04/2012 01:00", "30/04/2012 01:10",
>"30/04/2012 01:20", "30/04/2012 01:30", "30/04/2012 01:40", "30/04/2012 01:50",
>"30/04/2012 02:00", "30/04/2012 02:10", "30/04/2012 02:20", "30/04/2012 02:30",
>"30/04/2012 02:40", "30/04/2012 02:50", "30/04/2012 03:00", "30/04/2012 03:10",
>"30/04/2012 03:20", "30/04/2012 03:30", "30/04/2012 03:40", "30/04/2012 03:50",
>"30/04/2012 04:00", "30/04/2012 04:10", "30/04/2012 04:20", "30/04/2012 04:30",
>"30/04/2012 04:40", "30/04/2012 04:50", "30/04/2012 05:00", "30/04/2012 05:10",
>"30/04/2012 05:20", "30/04/2012 05:30", "30/04/2012 05:40", "30/04/2012 05:50",
>"30/04/2012 06:00", "30/04/2012 06:10", "30/04/2012 06:20", "30/04/2012 06:30",
>"30/04/2012 06:40", "30/04/2012 06:50", "30/04/2012 07:00", "30/04/2012 07:10",
>"30/04/2012 07:20", "30/04/2012 07:30", "30/04/2012 07:40", "30/04/2012 07:50",
>"30/04/2012 08:00", "30/04/2012 08:10", "30/04/2012 08:20", "30/04/2012 08:30",
>"30/04/2012 08:40", "30/04/2012 08:50", "30/04/2012 09:00", "30/04/2012 09:10",
>"30/04/2012 09:20", "30/04/2012 09:30", "30/04/2012 09:40", "30/04/2012 09:50",
>"30/04/2012 10:00", "30/04/2012 10:10", "30/04/2012 10:20", "30/04/2012 10:30",
>"30/04/2012 10:40", "30/04/2012 10:50", "30/04/2012 11:00", "30/04/2012 11:10",
>"30/04/2012 11:20", "30/04/2012 11:30", "30/04/2012 11:40", "30/04/2012 11:50",
>"30/04/2012 12:00", "30/04/2012 12:10", "30/04/2012 12:20", "30/04/2012 12:30",
>"30/04/2012 12:40", "30/04/2012 12:50", "30/04/2012 13:00", "30/04/2012 13:10",
>"30/04/2012 13:20", "30/04/2012 13:30", "30/04/2012 13:40", "30/04/2012 13:50",
>"30/04/2012 14:00", "30/04/2012 14:10", "30/04/2012 14:20", "30/04/2012 14:30",
>"30/04/2012 14:40", "30/04/2012 14:50", "30/04/2012 15:00", "30/04/2012 15:10",
>"30/04/2012 15:20", "30/04/2012 15:30", "30/04/2012 15:40", "30/04/2012 15:50",
>"30/04/2012 16:00", "30/04/2012 16:10", "30/04/2012 16:20", "30/04/2012 16:30",
>"30/04/2012 16:40", "30/04/2012 16:50", "30/04/2012 17:00", "30/04/2012 17:10",
>"30/04/2012 17:20", "30/04/2012 17:30", "30/04/2012 17:40", "30/04/2012 17:50",
>"30/04/2012 18:00", "30/04/2012 18:10", "30/04/2012 18:20", "30/04/2012 18:30",
>"30/04/2012 18:40", "30/04/2012 18:50", "30/04/2012 19:00", "30/04/2012 19:10",
>"30/04/2012 19:20", "30/04/2012 19:30", "30/04/2012 19:40", "30/04/2012 19:50",
>"30/04/2012 20:00", "30/04/2012 20:10", "30/04/2012 20:20", "30/04/2012 20:30",
>"30/04/2012 20:40", "30/04/2012 20:50", "30/04/2012 21:00", "30/04/2012 21:10",
>"30/04/2012 21:20", "30/04/2012 21:30", "30/04/2012 21:40", "30/04/2012 21:50",
>"30/04/2012 22:00", "30/04/2012 22:10", "30/04/2012 22:20", "30/04/2012 22:30",
>"30/04/2012 22:40", "30/04/2012 22:50", "30/04/2012 23:00", "30/04/2012 23:10",
>"30/04/2012 23:20", "30/04/2012 23:30", "30/04/2012 23:40", "30/04/2012 23:50"
>), class = "factor"), V3 = c(0.03, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03,
>0.04, 0.04, 0.04, 0.03, 0.03, 0.03, 0.03, 0.03, 0.04, 0.03, 0.03,
>0.03, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.03, 0.03,
>0.03, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.03, 0.03, 0.04,
>0.03, 0.03, 0.03, 0.03, 0.03, 0.03, 0.03, 0.04, 0.03, 0.04, 0.03,
>0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04,
>0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.03, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.03,
>0.04, 0.04, 0.03, 0.04, 0.03, 0.04, 0.04, 0.03, 0.03, 0.04, 0.04,
>0.04, 0.04, 0.03, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.03, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.03, 0.03, 0.03, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04,
>0.04, 0.03, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.03, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.03, 0.03, 0.04, 0.04, 0.03, 0.04, 0.04, 0.03, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.03, 0.03,
>0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.03,
>0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.03, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04, 0.04,
>0.04, 0.04, 0.04, 0.04)), .Names = c("V1", "V2", "V3"), class = "data.frame", row.names = c(NA,
>-912L))
>
>
>Let make my question clearer:
>
>I want to make summary of the data above into a table as below to show the days that there are any data available, e.g.value=1 if
>there are any data available for that day, otherwise value=0. There are three id in my data: 532703, 532704 and 532705. data are collected at 10 minutes interval each day (e.g. 144 observations for a day if no missing data).
>
>
> 28/04 29/04 30/04 01/05 02/05
>532703 0 1 1 1 0
>532704 1 1 1 1 1
>532705 0 0 1 1 0
>
>
>
>Sorry for the confusion to David, and hope this is clear now.
>
>Many thanks again.
>
>Best wishes,
>
>HJ
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>On Thu, Sep 6, 2012 at 2:08 AM, arun <smartpink111 at yahoo.com> wrote:
>
>Hi,
>>
>>I couldn't find any attached data. Could you dput() the data?
>>A.K.
>>
>>
>>
>>
>>----- Original Message -----
>>From: HJ YAN <yhj204 at googlemail.com>
>>To: r-help at r-project.org
>>Cc:
>>Sent: Wednesday, September 5, 2012 7:57 PM
>>Subject: [R] Summarizing data containing data/time information (as factor)
>>
>>Dear R user
>>
>>I want to create a table (as below) to summarize the attached data
>>(Test.csv, which can be read into R by using 'read.csv(Test.csv, header=F)'
>>), to indicate the day that there are any data available, e.g.value=1 if
>>there are any data available for that day, otherwise value=0.
>>
>>
>> 28/04 29/04 30/04 01/05 02/05
>>532703 0 1 1 1 0
>>532704 1 1 1 1 1
>>532705 0 0 1 1 0
>>
>>Only Column A (Names: automatically stored as integer if being read into R)
>>and Column B (date/time: automatically stored as factor if being read into
>>R) are useful for this task.
>>
>>Could anyone kindly provide me some hints/ideas about how to write some
>>code to to this job please?
>>
>>
>>Many thanks in advance!
>>
>>Best wishes
>>HJ
>>
>>______________________________________________
>>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