Re: [R] Creating zoo object on monthly time series

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Sun, 01 Jun 2008 10:31:42 -0400

Please upgrade to the latest version of zoo. as.yearmon.factor was only added to zoo in recent versions and its likely your date column is a factor.

If that is not the problem then please provide the dput output as requested.

On Sun, Jun 1, 2008 at 9:59 AM, Megh Dal <megh700004_at_yahoo.com> wrote:
>> packageDescription("zoo")$Version
> [1] "1.1-1"
>
>
> Gabor Grothendieck <ggrothendieck_at_gmail.com> wrote:
>
> You need to unambiguously specify what your data
> looks like. Please provide the dput output as previously
> requested. Also what version of zoo are you using?
>
> packageDescription("zoo")$Version
>
>
> On Sun, Jun 1, 2008 at 9:37 AM, Megh Dal wrote:
>> I got following:
>>
>>> z <- zoo(data1[,3], as.yearmon(data1[,1], "%b-%y"))
>>> head(z)
>> Jan 0001 Jan 0002 Jan 0003 Jan 0004 Jan 0005 Jan 0006
>> 1206.68 782.45 1187.00 1398.77 1883.23 1431.80
>>
>>> z <- zoo(data1[,3], as.Date(as.yearmon(data1[,1], "%b-%y")))
>>> head(z)
>> 0001-01-01 0002-01-01 0003-01-01 0004-01-01 0005-01-01 0006-01-01
>> 1206.68 782.45 1187.00 1398.77 1883.23 1431.80
>>
>> Nowhere 1980 is coming. Any better suggestion?
>>
>> Gabor Grothendieck wrote:
>>
>> On Sun, Jun 1, 2008 at 8:47 AM, Gabor Grothendieck
>> wrote:
>>> On Sun, Jun 1, 2008 at 8:35 AM, Megh Dal 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)
>>>>
>>>> 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.
>>>>
>>>
>>
>>
>
>



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. Received on Mon 02 Jun 2008 - 04:24:12 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 02 Jun 2008 - 04:30:40 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive