Hi there,

It is not so many ellegant, but can works.

df<-read.table(stdin(), head=T, sep=",")
Name,Fraction
Harry,335/335
Harry,124/506
Harry,124/506
Dick,133
Tom,335/335
Tom,335/335
df.freq<-data.frame(table(df))
df.freq
df.freq.wide<-reshape(df.freq, v.names="Freq", idvar="Name",
timevar="Fraction", direction="wide")
df.freq.wide

cheers

milton
brazil=toronto



On Tue, Jun 2, 2009 at 7:41 PM, sedm1000 <gdoran@mit.edu> wrote:

>
> Apologies for the novice question, but this is likely beyond my google
> searching range..
>
> I am trying to create a table from the summaries of a file. The 2 column
> data table looks like;
>
> Harry  335/335
> Harry  124/506
> Harry  124/506
> Dick   133
> Tom    335/335
> Tom    335/335
>
> with 1000 unique values in col 1, 300 unique in col 2. The  'summary'
> doesn't seem to handle this many values well.
>
> I would like to summarise this data in a table that reads the number of
> occurences of the values of col 2  for each unique name in col 1...
>
> Along the lines...
>
>          335/335  124/506  133
> Tom        2            0            0
> Dick        0            0            1
> Harry       1            2            0
>
> I hope I can trouble someone for their expert advice on what is likely a
> trivial matter...
> Many thanks.
> --
> View this message in context:
> http://www.nabble.com/Table-of-Summaries-tp23842984p23842984.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>

	[[alternative HTML version deleted]]


