如何将R中的数据帧分解为30分钟的桶

Question

我有一天的时间格式为2014-01-31 15:33:50。

我试着写一个逻辑，把一整天都分解成30分钟的桶，这样我就可以做一些统计测试了。

你能建议我如何通过R来完成吗？

Answer 1

试一试如下：

start <- as.POSIXct("2012-01-15")
end <- start + as.difftime(1, units="mins")
Time.DF <- data.frame(Time = seq(from=start, by=15, to=end),
                      Info = 1:5)
# This is one way to do it
Time.DF$Bins <- with(Time.DF, {cut(
  Time, breaks = seq(from=min(Time), by=30, to=max(Time + 30)), labels = F)})
#                     Time Info Bins
# 1 2012-01-15 00:00:00    1    1
# 2 2012-01-15 00:00:15    2    1
# 3 2012-01-15 00:00:30    3    2
# 4 2012-01-15 00:00:45    4    2
# 5 2012-01-15 00:01:00    5    3

# This is a second way to do it
Time.DF$Bins2 <- with(Time.DF, {as.numeric(cut(
  Time, breaks = seq(from=min(Time), by=30, to=max(Time + 30))))})
#                     Time Info Bins Bins2
# 1 2012-01-15 00:00:00    1    1     1
# 2 2012-01-15 00:00:15    2    1     1
# 3 2012-01-15 00:00:30    3    2     2
# 4 2012-01-15 00:00:45    4    2     2
# 5 2012-01-15 00:01:00    5    3     3