[R] contingency table, several variables from dataframe

Eik Vettorazzi E.Vettorazzi at uke.uni-hamburg.de
Thu Oct 2 13:16:29 CEST 2008


First of all your construction of ABC leads to a structure with 3 factor 
variables due to the way cbind processes the input variables -  which is 
not intended I think.

You can do sth like

ABC<-data.frame(A,B,C)
aggregate(ABC[,2:3],by=list(A),sum)

hth.

Birgitle schrieb:
> Hello R-Users!
>
> I need a little help to build up a contingency table out of several
> variables.
>
>   A<-c("F","M","M","F","F","F","F","M","F","M","F","F")
>   B<-c(0,0,0,0,0,0,1,1,1,1,0,1)
>   C<-c(0,1,1,1,1,1,1,1,1,0,0,0)
>
>   ABC<-as.data.frame(cbind(A,B,C))
>
>   ABC
>
>    A B C
> 1  F 0 0
> 2  M 0 1
> 3  M 0 1
> 4  F 0 1
> 5  F 0 1
> 6  F 0 1
> 7  F 1 1
> 8  M 1 1
> 9  F 1 1
> 10 M 1 0
> 11 F 0 0
> 12 F 1 0
>
> I would like to count in each variable B and C the frequencies for M and F
> (variable A) and finally get the following table:
>
>      B   C
> F   3   5
>
> M  2   3
>
> Is there a function that can do that in one step?
> Tried ?structable, ?ftable, ?xtabs, ?table but could not get what I would
> like to have.
>
> Maybe I did not use the tried functions in the right way.
>
> Many thanks in advance for any help.
>
> B.
>
>
>
> -----
> The art of living is more like wrestling than dancing.
> (Marcus Aurelius)
>   

-- 
Eik Vettorazzi
Institut für Medizinische Biometrie und Epidemiologie
Universitätsklinikum Hamburg-Eppendorf

Martinistr. 52
20246 Hamburg

T ++49/40/42803-8243
F ++49/40/42803-7790



More information about the R-help mailing list