Question

我有服务器日志价值一个月的交通流量。

"UploadDateGMT","UserFileSize","TotalBusinessUnits"
"2012-01-01 00:00:38","1223","1"
"2012-01-01 00:01:16","1302","1"
"2012-01-01 00:08:10","1302","1"

我想将它转换成一组数据,在那里我计算出每个5分钟的窗口里每个5分钟的滚动基础上有多少字节的呈文。 (即0-5、1-6、2-7等)从中,我可以提取最大负荷,95%的负载,制作漂亮的负载图等等。

Answer 1

@PLapointes https://stackoverflow.com/a/10741562/2716><回答:

endp <- endpoints(tab2, on="mins", k=1) # 1 minute endpoints
onemin <- period.apply(tab2,endp,sum)   # sum per 1-minute period
onemin <- align.time(onemin)            # align to end-of-period times
# all one-minute increments from start--end of onemin
allonemin <- seq(start(onemin), end(onemin), by="1 min")
onemin <- merge(onemin, xts(,allonemin))
fivemin <-  rollapplyr(onemin, 5, sum, na.rm=TRUE, fill=NA)

Answer 2

xts 软件包将执行以下操作 :

library(xts)
tab <-read.table(text="UploadDateGMT,UserFileSize,TotalBusinessUnits
 2012-01-01 00:00:38 ,1223,1
 2012-01-01 00:01:16 ,1302,1
 2012-01-01 00:08:10 ,1302,1", header=TRUE, as.is=TRUE,sep = ",")

tab2<-xts(tab$UserFileSize,order.by=as.POSIXct(tab$UploadDateGMT) ) #create xts object
endp <-endpoints(tab2, on="mins", k=5) #5 minutes endpoints
fivemin <-period.apply(tab2,endp,sum) #sum per 5-minute period
fivemin

                    [,1]
2012-01-01 00:01:16 2525
2012-01-01 00:08:10 1302

如果您希望时间列以5分钟递增为以内时间列 :

res<- align.time( fivemin[endpoints(fivemin, on="mins", k=5)], n=60*5)

友情链接