[R] Creating zoo object on monthly time series

Gabor Grothendieck ggrothendieck at gmail.com
Sun Jun 1 14:53:05 CEST 2008


On Sun, Jun 1, 2008 at 8:47 AM, Gabor Grothendieck
<ggrothendieck at gmail.com> wrote:
> On Sun, Jun 1, 2008 at 8:35 AM, Megh Dal <megh700004 at yahoo.com> wrote:
>> Hi all,
>>
>> I have following monthly time series :
>>
>>> head(data1)
>>      V1 V2      V3
>> 1 Nov-80 NA 1007.44
>> 2 Dec-80 NA  982.05
>> 3 Jan-81 NA  994.25
>> 4 Feb-81 NA  996.31
>> 5 Mar-81 NA  939.91
>> 6 Apr-81 NA  923.32
>
> If the suggestion below does not work then try
> dput(head(data1)) to display it in an unambiguous form that is
> readily re-input into R.
>
>>
>> Now I want to convert it to a 'zoo' object. I wrote following syntax :
>>
>> ss = zoo(data1[,3], as.Date(data1[,1], format="%m/%y"))
>>
>
> See ?strptime and try "%b-%y"

That should be:

   z <- zoo(data1[,3], as.yearmon(data1[,1], "%b-%y"))

or, if you want it as Date instead of yearmon:

   z <- zoo(data1[,3], as.Date(as.yearmon(data1[,1], "%b-%y")))

>
>> However I got following :
>>> head(ss)
>>   <NA>    <NA>    <NA>    <NA>    <NA>    <NA>
>> 1007.44  982.05  994.25  996.31  939.91  923.32
>>
>>
>> Can anyone please tell me what will be the correct syntax?
>>
>> Thanks
>>
>>
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>



More information about the R-help mailing list