Message-ID: <5018DCCD.5090103@ymail.com>
Date: 2012-08-01T07:37:49Z
From: Pascal Oettli
Subject: Date period
In-Reply-To: <CAGGxVMsnibpQhdZXkVe+0n5k_gOh6hiueMmNyxcHTNcMdBes6w@mail.gmail.com>
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.
>