What is "the excel format" in R? From what you put below, it sure looks like the date is visible...perhaps you want time()?
Michael On Tue, Feb 21, 2012 at 9:01 PM, jpm miao <miao...@gmail.com> wrote: > Hello, > > I have built a zoo object. I try to see it in a tabular form. Is there > any way to view the date and the data in the excel format? If I use > as.matrix, I can only see the data but not the date. > >> x2zooq CPI CPIZF UNR UNRSA > 1978 Q1 NaN NaN 1.870000 1.970000 > 1978 Q2 NaN NaN 1.643333 1.786667 > 1978 Q3 NaN NaN 1.870000 1.606667 > 1978 Q4 NaN NaN 1.283333 1.303333 > 1979 Q1 NaN NaN 1.260000 1.366667 > 1979 Q2 NaN NaN 1.133333 1.303333 > 1979 Q3 NaN NaN 1.496667 1.246667 > 1979 Q4 NaN NaN 1.200000 1.196667 > 1980 Q1 NaN NaN 1.036667 1.133333 > 1980 Q2 NaN NaN 1.140000 1.326667 > 1980 Q3 NaN NaN 1.500000 1.246667 > 1980 Q4 NaN NaN 1.236667 1.223333 > 1981 Q1 62.90000 66.77333 1.160000 1.246667 > 1981 Q2 63.73000 66.77333 1.066667 1.276667 > 1981 Q3 64.97333 67.11333 1.653333 1.383333 > 1981 Q4 65.02000 67.83000 1.533333 1.500000 > 1982 Q1 65.15333 68.55667 1.433333 1.523333 > 1982 Q2 65.67333 69.06667 1.806667 2.036667 > > >> temp<-as.matrix(x2zooq) > > > Then I see a table > row.namesCPICPIZFUNRUNRSA11NaNNaN1.8700001.97000024NaNNaN1.6433331.78666737 > NaNNaN1.8700001.606667410NaNNaN1.2833331.303333513NaNNaN1.2600001.366667616 > NaNNaN1.1333331.303333719NaNNaN1.4966671.246667822NaNNaN1.2000001.196667925 > NaNNaN1.0366671.1333331028NaNNaN1.1400001.3266671131NaNNaN1.5000001.24666712 > 34NaNNaN1.2366671.223333133762.9000066.773331.1600001.246667144063.73000 > 66.773331.0666671.276667154364.9733367.113331.6533331.383333164665.02000 > 67.830001.5333331.500000174965.1533368.556671.4333331.523333185265.67333 > 69.066671.8066672.036667195566.9766769.333332.5133332.240000205866.40333 > 69.570002.7566672.723333216166.9433369.786673.0300003.120000226467.50667 > 69.733332.5133332.763333236766.9700069.570002.8300002.540000247066.39333 > 69.683332.4666672.430000257366.1466770.100002.3933332.496667267667.13333 > 70.666672.1166672.366667277967.4300070.776672.8566672.520000288267.02667 > 70.626672.4100002.386667298567.0800070.486672.2233332.343333308866.77333 > 70.110002.4600002.700000319166.8733369.483333.7200003.386667329466.58667 > 69.793333.2133333.203333 > > 2012/2/17 jpm miao <miao...@gmail.com> > >> Hello, >> >> I have a question on how to tabulate the time series data. I use >> RStudio, but if can be done in any other R editor, it should work in >> RStudio as well. >> >> > a1<-11:22 >> >> > a1ts<-ts(a1, frequency=4, start=c(1978,1)) >> >> > a1ts Qtr1 Qtr2 Qtr3 Qtr4 >> 1978 11 12 13 14 >> 1979 15 16 17 18 >> 1980 19 20 21 22 >> >> >> If I click the variable "a1ts" on the workspace, I see >> >> structure(11:22, .Tsp = c(1978, 1980.75, 4), class = "ts") >> >> If I coerce the variable to become a matrix, >> >> > a1tsm<-as.matrix(a1ts) >> >> >> and click the variable "a1tsm", I see the vector in a tabular form and >> can paste it into Excel , but I don't see the dates at all >> V1 >> 1 11 >> 2 12 >> 3 13 >> 4 14 >> 5 15 >> 6 16 >> 7 17 >> 8 18 >> 9 19 >> 10 20 >> 11 21 >> 12 22 >> >> How could I see both the dates and the data in a tabular form? >> >> The second question is that if I have another data sequence, how can >> I combine the two and see both data in a tabular form? >> >> > a2<-101:116> a2ts<-ts(a2, frequency=4, start=c(1979,1))> a2ts Qtr1 >> > Qtr2 Qtr3 Qtr4 >> 1979 101 102 103 104 >> 1980 105 106 107 108 >> 1981 109 110 111 112 >> 1982 113 114 115 116 >> >> > >> Thank you, >> >> Miao >> >> > > [[alternative HTML version deleted]] > > ______________________________________________ > 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.
