Efficient conversion of data.table to xts, data.table must have POSIXct or Date type in first column.
as.xts.data.table(x, ...)
data.table to convert to xts, must have POSIXct or Date in the first column. All others non-numeric columns will be omitted with warning.
ignored, just for consistency with generic method.
# NOT RUN {
if (requireNamespace("xts", quietly = TRUE)) {
sample.dt <- data.table(date = as.Date((Sys.Date()-999):Sys.Date(),origin="1970-01-01"),
quantity = sample(10:50,1000,TRUE),
value = sample(100:1000,1000,TRUE))
# print data.table
print(sample.dt)
# print head of xts
print(head(as.xts.data.table(sample.dt))) # xts might not be attached on search path
}
# }
Run the code above in your browser using DataLab