Message-ID: <971536df0911170249t62d4795av42c5036c8f9a1c6c@mail.gmail.com>
Date: 2009-11-17T10:49:34Z
From: Gabor Grothendieck
Subject: tseries to csv or xls
In-Reply-To: <CD567943-348A-43D1-831B-E6058B643D46@lautloscrew.com>
Using the built in AirPassengers data that comes with R this works:
> AP12 <- ts(matrix(AirPassengers[], nc = 12, byrow = TRUE), start(AirPassengers)[1])
> colnames(AP12) <- month.abb
> library(zoo)
> write.zoo(as.zoo(AP12), sep = ",")
"Index","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"
1949,112,118,132,129,121,135,148,148,136,119,104,118
1950,115,126,141,135,125,149,170,170,158,133,114,140
1951,145,150,178,163,172,178,199,199,184,162,146,166
1952,171,180,193,181,183,218,230,242,209,191,172,194
1953,196,196,236,235,229,243,264,272,237,211,180,201
1954,204,188,235,227,234,264,302,293,259,229,203,229
1955,242,233,267,269,270,315,364,347,312,274,237,278
1956,284,277,317,313,318,374,413,405,355,306,271,306
1957,315,301,356,348,355,422,465,467,404,347,305,336
1958,340,318,362,348,363,435,491,505,404,359,310,337
1959,360,342,406,396,420,472,548,559,463,407,362,405
1960,417,391,419,461,472,535,622,606,508,461,390,432
On Tue, Nov 17, 2009 at 4:09 AM, Bunny, lautloscrew.com
<bunny at lautloscrew.com> wrote:
> Hi all,
>
> is there a common way to write time series objects generated by ?ts() to some .csv or .xls.
> write.table does not work by default since it expects a data.frame which a ts object is not.
> Therefore write.table creates a data.frame which basically ignores the rows and columns of ts objects and just saves one big vector.
> What I want to do is export it, the same way as a ts object is printed on console, like this:
> ? ? ? ? Qtr1 ? ? ? ?Qtr2 ? ? ? ?Qtr3 ? ? ? ?Qtr4
> 1990 ?1.80926644 ?1.57801902 -0.06466631 -0.89682263
> 1991 ?0.38314894 ?0.58986441 ?0.61502833 ?1.55998143
> 1992 ?1.34689938 -0.61304408 ?2.17411932 ?0.13529151
> 1993 -0.07747732 ?1.76763799 ?0.37560837 ?0.36530430
> 1994 -1.03461000 ?0.88674850 ?1.71258524 ?0.79961787
>
> I hope email transmission does not blow the formatting :) Thx for any help in advance
>
> matt
> ______________________________________________
> 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.
>