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
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. >
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 > <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. >>
Try this:> as.data.frame(AP12, row.names = as.character(time(AP12)))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 7:12 AM, Bunny, lautloscrew.com <bunny at lautloscrew.com> wrote:> 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 >> <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. >>> > >