[R] Split xts data set into weeks

Seimizu Joukan saimizi at gmail.com
Sun Feb 3 01:59:47 CET 2013


Hi

I am trying to use split() to split a xts data set into weeks, but the
result seems not right.
original data is as following:

> head(xec)
             Open   High    Low  Close     mean
2011-02-28 112.34 113.34 111.96 112.87 112.6275
2011-03-01 112.89 113.71 112.75 112.80 113.0375
2011-03-02 112.75 113.56 112.50 113.54 113.0875
2011-03-03 113.50 115.08 113.10 115.05 114.1825
2011-03-04 115.16 115.97 114.85 115.06 115.2600
2011-03-07 115.21 115.26 114.55 114.85 114.9675
...

and I did the split() as following

> head(split(x=xec,f="weeks"))
[[1]]
             Open   High    Low  Close     mean
2011-02-28 112.34 113.34 111.96 112.87 112.6275

[[2]]
             Open   High    Low  Close     mean
2011-03-01 112.89 113.71 112.75 112.80 113.0375
2011-03-02 112.75 113.56 112.50 113.54 113.0875
2011-03-03 113.50 115.08 113.10 115.05 114.1825
2011-03-04 115.16 115.97 114.85 115.06 115.2600
2011-03-07 115.21 115.26 114.55 114.85 114.9675
...

the "2011-02-28" is the Monday but not being grouped with the other
days in that week,
which makes the second groups begin from Tuesday ("2011-03-01").

I want it to be as following

[[1]]
             Open   High    Low  Close     mean
2011-02-28 112.34 113.34 111.96 112.87 112.6275
2011-03-01 112.89 113.71 112.75 112.80 113.0375
2011-03-02 112.75 113.56 112.50 113.54 113.0875
2011-03-03 113.50 115.08 113.10 115.05 114.1825
2011-03-04 115.16 115.97 114.85 115.06 115.2600

[[2]]
             Open   High    Low  Close     mean
2011-03-07 115.21 115.26 114.55 114.85 114.9675
...

Could anyone please give some advice?
Thanks in advance.

Seimizu Joukan



More information about the R-help mailing list