[R] confused with yearmon, xts and maybe zoo

Gabor Grothendieck ggrothendieck at gmail.com
Sun Apr 18 14:55:22 CEST 2010


On Sun, Apr 18, 2010 at 8:25 AM, simeon duckworth
<simeonduckworth at gmail.com> wrote:
> R-listers,
>
> I am using xts with a yearmon index, but am getting some inconsistent
> results with the date index when i drop observations (for example by using
> na.omit).
>
> The issue is illustrated in the example below.  If I start with a monthly
> zooreg series starting in 2009, yearmon converts this to "Dec-2008".  Not
> such a worry for my example, but strange.  Having converted to xts, i drop
> the first observation.  The index shows jan 2009.  But if i create a new
> variable with this index, it shifts the series back to dec 2008.
>
> No doubt i am doing something wrong.  very grateful for any tips
>
> library(xts)
>
> z <- zooreg(1:24,frequency=12,start=c(2009,1))  # monthly data starting 2009
> x <- xts(z,as.yearmon(index(z)))                        # starts Dec 2008

Not for me.  It starts in January 2009 for me.

Also please show your code in such a way that it can be pasted into a
session.  Either comment out the output using # or else preface input
lines with > so its clear what is input and what is output.  And show
what versions of the software and R you are using and what platform.

> z <- zooreg(1:24,frequency=12,start=c(2009,1))  # monthly data starting 2009
> head(z)
2009(1) 2009(2) 2009(3) 2009(4) 2009(5) 2009(6)
      1       2       3       4       5       6
> x <- xts(z,as.yearmon(index(z)))
> head(x)
         x
Jan 2009 1
Feb 2009 2
Mar 2009 3
Apr 2009 4
May 2009 5
Jun 2009 6
> R.version.string
[1] "R version 2.10.1 (2009-12-14)"
> win.version()
[1] "Windows Vista (build 6002) Service Pack 2"
> packageDescription("zoo")$Version
[1] "1.6-3"
> packageDescription("xts")$Version
[1] "0.7-0"

I also tried older versions zoo 1.6-0, xts 0.6-8 and R 2.9.2 and got
the same result as I got here.



More information about the R-help mailing list