[R] How to implement a "select distinct x, count(distinct y) ... group by x" for a data frame

[Gabor Grothendieck]

Regarding your subject, the sqldf package on CRAN allows you to apply
SQL statements directly to R data frames.  http://sqldf.googlecode.com

On Sat, Jan 23, 2010 at 5:46 PM, Dimitri Shvorob
<dimitri.shvorob at gmail.com> wrote:
>
> ... Being an R newbie, I can only think of extracting distinct x values with
> unique, looping over them, extracting matching rows from the original data
> frame, applying table, and recording the size of table's output alongside
> the x value being checked. Is there a more elegant way?
>
> Thank you.
> --
> View this message in context: http://n4.nabble.com/How-to-implement-a-select-distinct-x-count-distinct-y-group-by-x-for-a-data-frame-tp1288418p1288418.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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.
>