提问人：rrn_di 提问时间：12/15/2022 最后编辑：Vinícius Félixrrn_di 更新时间：12/17/2022 访问量：45
如何从 R 中的 csv 文件查找每秒/小时/每天的请求数
How to find the number of requests per second/hour/day from csv file in R
问：
我有一个包含以下数据的 csv 文件：
#type_of_r,date_time
request1,2022.12.09 12:03:06.836
reqeust2,2022.12.09 12:03:06.897
request3,2022.12.09 12:04:07.840
request1,2022.12.09 12:05:07.220
request1,2022.12.09 12:10:08.001
request2,2022.12.09 21:40:08.005
目前，该文件包含相对于 1 天期限的信息。 现在，我需要获取一个图表，显示每秒、每小时和每天有多少个请求。
答：
0赞
Vinícius Félix
12/15/2022
#1
library(dplyr)
library(lubridate)
df <-
structure(list(request = c("request1", "request2", "request3", "request1",
"request1", "request2"),
dttm = c("2022.12.09 12:03:06.836", "2022.12.09 12:03:06.897",
"2022.12.09 12:04:07.840", "2022.12.09 12:05:07.220", "2022.12.09 12:10:08.001",
"2022.12.09 21:40:08.005")),
class = "data.frame", row.names = c(NA,-6L)) %>%
mutate(
dttm = ymd_hms(dttm),
day = day(dttm),
hour = hour(dttm),
minute = minute(dttm),
second = second(dttm)
)
#requests by second/minute/hour
df %>%
count(hour,minute,second)
#requests by hour
df %>%
count(hour)
#requests by day
df %>%
count(day)
评论