Try:

xtabs(x ~ Group.2 + Group.1, data=x)

On Fri, May 9, 2008 at 1:25 PM, Oh Dong-hyun <r.arecibo@gmail.com> wrote:

> Hi useRs!
>
> I would like to know how to make aggregated data.frame with aggregate()
> tabulated.
>
> For example, I run the following command to aggregate re with respect to
> group1 and group2.
>
> > (aggr <- with(final, aggregate(re, group1, group2, mean)))
>    Group.1 Group.2       x
> 1      1992      15 0.16392
> 2      1993      15 0.15467
> 3      1994      15 0.15456
> 4      1995      15 0.15391
> 5      1996      15 0.16511
> 6      1997      15 0.17368
> 7      1998      15 0.17955
> 8      1999      15 0.19805
> 9      2000      15 0.20546
> 10     1992      16 0.16237
> 11     1993      16 0.18359
> 12     1994      16 0.13811
> 13     1995      16 0.13988
> 14     1996      16 0.15604
> 15     1997      16 0.16802
> 16     1998      16 0.16978
> 17     1999      16 0.18407
> 18     2000      16 0.18646
> 19     1992      17 0.24604
> 20     1993      17 0.25263
> 21     1994      17 0.21407
> 22     1995      17 0.26483
> 23     1996      17 0.26427
> 24     1997      17 0.26282
> 25     1998      17 0.31137
> 26     1999      17 0.26982
> 27     2000      17 0.22898
> 28     1992      18 0.29417
> 29     1993      18 0.36586
> 30     1994      18 0.25143
> 31     1995      18 0.25570
> 32     1996      18 0.24628
> 33     1997      18 0.24293
> 34     1998      18 0.24888
> 35     1999      18 0.19515
> 36     2000      18 0.18057
>
> I want make aggr as follows with class of data.frame.
>       1992          1993          1994   1995   1996   1997   1998   1999
> 2000
> 15   0.16392    0.15467......
> 16   0.16237    0.18359.......
> 17   .....
> 18   ......
>
> Thank you in advance.
>
> ______________________________________________
> 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.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

	[[alternative HTML version deleted]]

