Re: [R] Compiling a contingency table of counts by case

From: hadley wickham <>
Date: Fri 22 Sep 2006 - 16:04:02 GMT

> I have asked a similar question before but this time
> the problem is somewhat more involved. I have the
> following data:
> case;name;x
> 1;Joe;1
> 1;Mike;1
> 1;Zoe;1
> 2;Joe;1
> 2;Mike;0
> 2;Zoe;1
> 2;John;1
> 3;Mike;1
> 3;Zoe;0
> 3;Karl;0
> I would like to count the number of "case"
> in which any two "name"
> a. both have "x=1",
> b. the first has "x=0" - the second has "x=1",
> c. the first has "x=1" - the second has "x=0",
> d. both have "x=0",

One way is to use the reshape package:

dat <- read.delim("clipboard", sep=";")
dat <- rename(dat, c(x=value))
cast(dat, name ~ case)

(which doesn't give you exactly what you want, but I think might be more illuminating)

Hadley mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Sat Sep 23 02:06:28 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 22 Sep 2006 - 16:30:47 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.