Dear R-help list,

Apologies. I  am trying to convert one table to another. It feels that it
should be a very straightforward answer with a single (or two) commands with
the right extensions, but I really can't figure this out right now. I have
several hundred pheno factors actually, so manually doing this line by line
is not an option.

My original table is approximately like this :

   ID         pheno
1   A Breast Cancer
2   A  Appendicitis
3   A  Microcephaly
4   B        Polyps
5   B        Autism
6   C        Autism
7   D Breast Cancer
8   D        Polyps
9   D  Appendicitis
10  E Breast Cancer


What I want is this :
    ID Breast Cancer Appendicitis Microcephaly Polyps Autism  A 1 1 1   B  1
1  C   1  D 1  1  E 1

The data is here
data <-
data.frame(ID=c(rep("A",3),rep("B",2),rep("C",1),rep("D",3),rep("E",1)),
pheno=c("Breast
Cancer","Appendicitis","Microcephaly","Polyps","Autism","Autism","Breast
Cancer","Polyps","Appendicitis","Breast Cancer"))

Thank you very much! Many apologies.

Min-Han

	[[alternative HTML version deleted]]

