An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111212/60664191/attachment.pl>
round Date object to 10 minutes intervals?
3 messages · Katharina May, Brian Ripley, kmay
You haven't specified how you want 00:05 rounded (it is neither > nor < 5). But here's one way t2 <- strptime(timeStamp, format="%d.%m.%Y %H:%M") t2$min <- round(t2$min, -1)
format(t2, "%d.%m.%Y %H:%M")
[1] "31.03.2011 09:30" "31.03.2011 09:40" "31.03.2011 10:00" "31.03.2011 10:10" [5] "31.03.2011 10:30" "31.03.2011 10:40" "31.03.2011 10:50" "01.04.2011 00:00" That will round 5 to even. You may need to consider things like t2$min <- 10*floor((t2$min + 5)/10) t2$min <- 10*floor((t2$min + 4)/10)
On Mon, 12 Dec 2011, Katharina May wrote:
Hello *,
I'm trying to round time stamps, consisting of a date and time part, to 10
minutes intervals
The timestamps have the following format: %d.%m.%Y %H:%M
*timeStamp <- c("31.03.2011 09:30", "31.03.2011 09:41", "31.03.2011 10:04",
"31.03.2011 10:10", "31.03.2011 10:28", "31.03.2011 10:35", "31.03.2011
10:49", "31.03.2011 23:59")*
should look like this:
*timeStamp2 <- c("31.03.2011 09:30", "31.03.2011 09:40", "31.03.2011
10:00", "31.03.2011 10:10", "31.03.2011 10:30", "31.03.2011 10:40",
"31.03.2011 10:55", "01.04.2011 00:00")*
I've found this topic on the web:
http://stats.stackexchange.com/questions/5305/how-to-re-sample-an-xts-time-series-in-r
library(xts)
align.time(as.POSIXct(timeStamp, format="%d.%m.%Y %H:%M"), 10 * 60)
which uses the align.time function from the library xts BUT as far as I can
see only supports either all timestamps being either rounded up or down
(not both, depending on the minutes 0-9 being either > or < 5 line the way
I need it)
As I'm really struggling with this topic, any help and hint is awarded
with greatest thankfulness from my side?
Best regards, Katharina
[[alternative HTML version deleted]]
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Dear Mr. Ripley, your answer perfectly fits my needs, thank you very much. (And yes, rounding 5 to even is what I wanted). Prof Brian Ripley wrote
t2 <- strptime(timeStamp, format="%d.%m.%Y %H:%M") t2$min <- round(t2$min, -1)
format(t2, "%d.%m.%Y %H:%M")
[1] "31.03.2011 09:30" "31.03.2011 09:40" "31.03.2011 10:00" "31.03.2011 10:10" [5] "31.03.2011 10:30" "31.03.2011 10:40" "31.03.2011 10:50" "01.04.2011 00:00"
Prof Brian Ripley wrote
t2$min <- 10*floor((t2$min + 5)/10) t2$min <- 10*floor((t2$min + 4)/10)
This really got me thinking and as a result increased my understanding of maths & R , a big thanks to you -- View this message in context: http://r.789695.n4.nabble.com/round-Date-object-to-10-minutes-intervals-tp4185496p4185776.html Sent from the R help mailing list archive at Nabble.com.