[R-SIG-Finance] Filtering dates/times from zoo/xts series
chrisbird
chris at chrisbird.com
Mon Sep 26 10:24:23 CEST 2011
Ok, I don't know whether I'm just rested after the weekend, but after
struggling to figure this out last week I now seem to have solved it all
this morning.
My solution is as follows:
# filter the data source on time range
data_source <- data_source[.indexhour(min_hour) >= min_hour &
.indexhour(data_source) < max_hour]
# now remove any data for which there is now enough daily samples
# aggregate samples per day
day_samples <- apply.daily(as.xts(data_source[,1]),length)
# get rid of any which do not have enough samples
day_samples <- day_samples[day_samples >= min_samples_per_day]
# get day index of the remaining days
days <- .indexday(as.xts(day_samples))
# filter data by remaining days
data_source <- data_source[.indexday(as.xts(data_source[,1])) %in% days]
Any comments on whether or not this is an optimal solution or acan be
improved in any way would be appreciated.
--
View this message in context: http://r.789695.n4.nabble.com/Filtering-dates-times-from-zoo-xts-series-tp3842937p3843065.html
Sent from the Rmetrics mailing list archive at Nabble.com.
More information about the R-SIG-Finance
mailing list