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 <gdo...@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]] ______________________________________________ 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.
