示例如下所示:
# A tibble: 10 x 3
trip_id start_time end_time
<int> <dttm> <dttm>
1 1 2020-10-05 11:11:36 2020-10-05 12:12:54
2 2 2020-10-05 16:09:16 2020-10-05 20:00:42
3 3 2020-10-05 09:16:33 2020-10-05 11:16:27
4 4 2020-10-05 14:16:38 2020-10-05 14:37:38
5 5 2020-10-05 13:08:16 2020-10-05 13:13:16
6 6 2020-10-05 11:02:23 2020-10-05 13:04:16
7 7 2020-10-05 13:15:19 2020-10-05 15:54:19
8 56562 2020-10-09 11:05:25 2020-10-09 13:37:44
9 56563 2020-10-09 14:11:30 2020-10-09 14:12:30
10 56564 2020-10-09 16:00:40 2020-10-09 16:46:58
data <- structure(list(trip_id = c(1L, 2L, 3L, 4L, 5L, 6L, 7L, 56562L,56563L, 56564L), start_time = structure(c(1601896296, 1601914156,1601889393, 1601907398, 1601903296, 1601895743, 1601903719, 1602241525,1602252690, 1602259240), tzone = "UTC", class = c("POSIXct","POSIXt")), end_time = structure(c(1601899974, 1601928042, 1601896587,1601908658, 1601903596, 1601903056, 1601913259, 1602250664, 1602252750,1602262018), tzone = "UTC", class = c("POSIXct", "POSIXt"))), row.names = c(NA,-10L), class = c("tbl_df", "tbl", "data.frame"))
根据上面的问题,我想创建其他列,将时间列转换为数值。我认为有很多方法可以转换它。例如,可能需要second
从 0 点或hour
从 0 点或minute
从 0 点开始。6 o'clock
表示为3600
从 0 点算起的秒数。
那么,任何包和函数都可以做到这一点吗?
是否有另一种合适的方法将我的时间列数据转换为数值?
我只想专注于我的时间(日期不算在内)。
预先感谢您的任何帮助。