[R] Ideas for tricky subset of XTS object
Noah Silverman
noahsilverman at ucla.edu
Tue Aug 23 22:41:50 CEST 2011
Hi,
I have a very large XTS object. It is about 600,000 entries over 1 year time.
I would like to subset a specific piece, by "number of days" not a specific date.
The way I do it now is awkward. Would love to find a way to do this easier to generate a new object just containing the days I want.
---------------------------------------
dayEnds <- endpoints(dataset, on="days")
datasetEnd <- max(dayEnds)
for( d in 1:ndays(dataset)){
day <- dataset[ (dayEnds[d]+1):dayEnds[d+1], ]
daysToEnd <- round(as.numeric( index(dataset[datasetEnd]) - index(tail(day, n=1)) , unit="days" ))
if(daysToEnd > 30|| daysToEnd < 10){
next;
}
# Will only get here if the days until the end are between 10 and 30
# Do the work here
}
-------------------------------------------
The above works but:
1) It is slow and awkward
2) I never wind up with a single clean dataset of just the days I want.
Any ideas?
Thanks!
--
Noah Silverman
UCLA Department of Statistics
8117 Math Sciences Building
Los Angeles, CA 90095
More information about the R-help
mailing list