[R] Table of Summaries
sedm1000
gdoran at mit.edu
Wed Jun 3 15:43:29 CEST 2009
Thanks for all your help guys - turns out it was a very simple request,
table1<-table(DF$COLUMN1,DF$COLUMN2)
did the trick. I've much to learn...
Cheers.
sedm1000 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-tp23842984p23851705.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list