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 <miaojpm@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]]

