Dear all,
I am having trouble creating summary tables using aggregate function.
given the following table:
Var1 Var2 Var3 dummy
S1 T1 I 1
S1 T1 I 1
S1 T1 D 1
S1 T1 D 1
S1 T2 I 1
S1 T2 I 1
S1 T2 D 1
S1 T2 D 1
S2 T1 I 1
S2 T1 I 1
S2 T1 D 1
S2 T1 D 1
S2 T2 I 1
S2 T2 I 1
S2 T2 I 1
S2 T2 I 1
I want to create a summary table that shows for each category of Var1,
Var2, the number of cells that are Var3=D and Var3-I :
Var1 Var2 Var3(D) Var3(I)
S1 T1 2 2
S1 T2 2 2
S2 T1 2 2
S2 T2 0 4
However, if I do: Count.Cells= aggregate(dummy~ Var1+Var2+Var3, FUN='sum')
, I get:
Var1 Var2 Var3 Count of Resp
S1 T1 D 2
S1 T1 I 2
S1 T2 D 2
S1 T2 I 2
S2 T1 D 2
S2 T1 I 2
S2 T2 I 4
Is there a way to get different columns for each Var3 level?
Thank you for any help you can give!
[[alternative HTML version deleted]]
______________________________________________
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.
