[R] Table and ftable

[Gabor Grothendieck]

Try this which gives an object of the required shape and of
class c("xtabs", "table") :

   xx <- xtabs(area ~ sic + level, DF)

You can optionally do it like this to make it class "matrix"

   xx <- xtabs(area ~ sic + level, DF)[]

and if you don't want the call attribute:

   attr(xx, "call") <- NULL

On 9/4/07, Giulia Bennati <bennati at gmail.com> wrote:
> Dear listmembers,
> I have a little question: I have my data organized as follow
>
> sic  level  area
> a    211    2.4
> b    311    2.3
> b    322    0.2
> b    322    0.5
> c    100    3.0
> c    100    1.5
> c    242    1.5
> d    222    0.2
>
> where levels and sics are factors. I'm trying to obtain a matrix like this:
>
>        level
>         211    311    322   100    242     222
> sic
> a        2.4      0       0       0       0        0
> b         0       2.3    0.7     0       0        0
> c         0        0      0       4.5     1.5     0
> d         0        0      0        0       0       0.2
>
> I tryed with table function as
> table(sic,level) but i obteined only a contingency table.
> Have you any suggestions?
> Thank you very much,
> Giulia
>
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>