[R] Date period

Pascal Oettli kridox at ymail.com
Wed Aug 1 09:37:49 CEST 2012


Hello,

You can try the following:

x <- read.table(text="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")

colnames(x) <- c('Date','Time','Value')

y <- c('00:00:00','01:00:00','02:00:00','03:00:00','04:00:00','05:00:00')

idx <- is.element(x$Time, y)
x[idx,]

Hope this help.
Pascal


Le 01/08/2012 15:48, Васильченко Александр a écrit :
> 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