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.
