Timestamp,XCV,VBN
30-03-2016 20:00,207,496
30-03-2016 20:06,213,500
30-03-2016 20:12,216,502
30-03-2016 20:18,223,503
30-03-2016 20:24,227,503
30-03-2016 20:30,226,503
30-03-2016 20:36,228,505
30-03-2016 20:42,233,507
30-03-2016 20:48,242,507
30-03-2016 20:54,257,509
30-03-2016 21:00,265,509
我尝试使用
df <- data.frame(interval = seq(
from=as.POSIXct("10-03-2016 00:00",format="%d-%m-%Y %H:%M"),
to=as.POSIXct("30-03-2016 21:00",format="%d-%m-%Y %H:%M"),
by="6 mins")
ts(mydata,start=c(2010,03),frequency=24*60/10)
,但似乎不起作用。有人可以在这里提供帮助吗?
从r的freq值中的r中,您可以使用60 / 6
指定频率:
ts(df[-1], frequency=10)
或者您可以使用xts
库在数据中读取并以XTS格式继续分析。
library(xts)
xtsFmt <- xts(df[-1], as.POSIXct(df[[1]],format="%d-%m-%Y %H:%M"))
as.ts(xtsFmt)
数据:
df <- read.csv(text="Timestamp,XCV,VBN
30-03-2016 20:00,207,496
30-03-2016 20:06,213,500
30-03-2016 20:12,216,502
30-03-2016 20:18,223,503
30-03-2016 20:24,227,503
30-03-2016 20:30,226,503
30-03-2016 20:36,228,505
30-03-2016 20:42,233,507
30-03-2016 20:48,242,507
30-03-2016 20:54,257,509
30-03-2016 21:00,265,509
")