Re: [R] Aggregate to find majority level of a factor

From: Peter Alspach <PAlspach_at_hortresearch.co.nz>
Date: Fri, 01 Jun 2007 08:22:47 +1200

Jon

One way: assuming your data.frame is 'jon'

aggregate(jon[,2], list(jon[,1]), function(x) levels(x)[which.max(table(x))])
  Group.1 x
1 Plot1 big
2 Plot2 small
3 Plot3 small

HTH ........ Peter Alspach

> -----Original Message-----
> From: r-help-bounces_at_stat.math.ethz.ch
> [mailto:r-help-bounces_at_stat.math.ethz.ch] On Behalf Of
> Thompson, Jonathan
> Sent: Friday, 1 June 2007 7:26 a.m.
> To: r-help_at_stat.math.ethz.ch
> Subject: [R] Aggregate to find majority level of a factor
>
> I want to use the aggregate function to summarize data by a
> factor (my field plots), but I want the summary to be the
> majority level of another factor.
>
>
> For example, given the dataframe:
>
> Plot1 big
> Plot1 big
> Plot1 small
> Plot2 big
> Plot2 small
> Plot2 small
> Plot3 small
> Plot3 small
> Plot3 small
>
>
> My desired result would be:
> Plot1 big
> Plot2 small
> Plot3 small
>
>
> I can't seem to find a scalar function that will give me the
> majority level.
>
> Thanks in advance,
>
> Jonathan Thompson
>
> ______________________________________________
> R-help_at_stat.math.ethz.ch 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.
>


The contents of this e-mail are privileged and/or confidenti...{{dropped}}



R-help_at_stat.math.ethz.ch 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. Received on Thu 31 May 2007 - 21:14:46 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 31 May 2007 - 21:32:06 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.