thx for the help. write.zoo may help me a lot with some other beginner issues i have, but I need to convert it into a data.frame though. I`d like to write stata files or .xls files and both functions need data.frames as a basis.
best matt Am 17.11.2009 um 11:49 schrieb Gabor Grothendieck: > 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 > <bu...@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@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@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.