[R] Date period

Rui Barradas ruipbarradas at sapo.pt
Wed Aug 1 14:33:39 CEST 2012


Hello,

Try the following.


dat <- structure(list(date = c("2000-01-05 00:00:00", "2000-01-05 
01:00:00",
"2000-01-05 05:00:00", "2000-01-05 06:00:00", "2000-01-05 07:00:00",
"2000-01-05 08:00:00", "2000-01-05 09:00:00", "2000-01-05 10:00:00",
"2000-01-05 11:00:00", "2000-02-05 00:00:00", "2000-02-05 01:00:00",
"2000-02-05 05:00:00", "2000-02-05 06:00:00", "2000-02-05 07:00:00",
"2000-02-05 08:00:00", "2000-02-05 09:00:00", "2000-02-05 10:00:00",
"2000-02-05 11:00:00"), value = c(1, 1, 3.6, 3.6, 2.2, 2.2, 2.2,
2.2, 2.2, 1, 1, 3.6, 3.6, 2.2, 2.2, 2.2, 2.2, 2.2)), .Names = c("date",
"value"), row.names = c(NA, -18L), class = "data.frame")

library(chron) # needed for times()
dat$date <- as.POSIXct(dat$date)
tm <- times(format(dat$date, format="%H:%M:%S"))
inx <- times("00:00:00") <= tm & tm <= times("05:00:00")
dat[inx, ]

Hope this helps,

Rui Barradas
Em 01-08-2012 07:48, Васильченко Александр escreveu:
> Hello
> I have dataframe
> How to remove dates in hourly time seriesThe example time series likedate
>                                 value
> 2000-01-05 00:00:00           1.0
> 2000-01-05 01:00:00           1.0
> 2000-01-05 05:00:00           3.6
> 2000-01-05 06:00:00           3.6
> 2000-01-05 07:00:00           2.2
> 2000-01-05 08:00:00           2.2
> 2000-01-05 09:00:00           2.2
> 2000-01-05 10:00:00           2.2
> 2000-01-05 11:00:00           2.2
> 2000-02-05 00:00:00           1.0
> 2000-02-05 01:00:00           1.0
> 2000-02-05 05:00:00           3.6
> 2000-02-05 06:00:00           3.6
> 2000-02-05 07:00:00           2.2
> 2000-02-05 08:00:00           2.2
> 2000-02-05 09:00:00           2.2
> 2000-02-05 10:00:00           2.2
> 2000-02-05 11:00:00           2.2
>
> And I take interval for example from 00:00:00 to 05:00:00.
> date                                  value
> 2000-01-05 00:00:00           1.0
> 2000-01-05 01:00:00           1.0
> 2000-01-05 05:00:00           3.6
> 2000-02-05 00:00:00           1.0
> 2000-02-05 01:00:00           1.0
> 2000-02-05 05:00:00           3.6
> Regards, Aleksander.
>
> 	[[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