[datatable-help] Grouping with sort

Steve Harman stvharman at gmail.com
Fri May 6 21:16:05 CEST 2011


Connected to this RMySQL performs much better
(using GROUP BY and functions such as GROUP_CONCAT which allows you
to
order and use a separator too).

So, I would recommend using them if you want grouping with sorting.

On May 6, 2:36 pm, Steve Harman <stvhar... at gmail.com> wrote:
> Hello !
> When grouping using data.table, mean and sum functions applied within
> groups work well but if we use sort(x) function it takes much longer.
>
> I would like to do first sort(x) and put it inside paste such as
> paste(sort(x),collapse=",")
> I was wondering if there is any more efficient of effective way of
> doing this?
>
> thanks in advance,
>
> Steve
> _______________________________________________
> datatable-help mailing list
> datatable-h... at lists.r-forge.r-project.orghttps://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatabl...


More information about the datatable-help mailing list