作者celestialgod (天)
看板R_Language
标题Re: [问题] 时间做分类
时间Wed Apr 5 19:33:47 2017
※ 引述《CAPPON (JI3)》之铭言:
: 我有一个data.frame
: 要将时间栏位做分类 , 以早上7点为卡点
: 用天来做分类
: 因为有 好几万笔的资料,如果用回圈来判断会比较麻烦
: 这可以怎麽做呢???
: 谢谢
: 2017-03-31 07:44:50.257375 --> 2017-03-31
: 2017-03-31 15:27:13.210377 --> 2017-03-31
: 2017-04-01 03:29:17.611750 --> 2017-03-31
: 2017-04-01 15:29:17.611750 --> 2017-04-01
: 2017-04-02 06:29:17.611750 --> 2017-04-01
library(lubridate)
timeStr <- c("2017-03-31 07:44:50.257375", "2017-03-31 15:27:13.210377",
"2017-04-01 03:29:17.611750", "2017-04-01 15:29:17.611750",
"2017-04-02 06:29:17.611750")
as_date(parse_date_time(timeStr, "YmdHMOS") - as.difftime(7, units = "hours"))
# [1] "2017-03-31" "2017-03-31" "2017-03-31" "2017-04-01" "2017-04-01"
--
R资料整理套件系列文:
magrittr #1LhSWhpH (R_Language) https://goo.gl/72l1m9
data.table #1LhW7Tvj (R_Language) https://goo.gl/PZa6Ue
dplyr(上.下) #1LhpJCfB,#1Lhw8b-s (R_Language) https://goo.gl/I5xX9b
tidyr #1Liqls1R (R_Language) https://goo.gl/i7yzAz
pipeR #1NXESRm5 (R_Language) https://goo.gl/zRUISx
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 118.170.38.47
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/R_Language/M.1491392032.A.756.html
※ 编辑: celestialgod (118.170.38.47), 04/05/2017 19:36:24
1F:推 zardabab: 解的漂亮! 04/07 13:29