[R] SQL vs R

Gabor Grothendieck ggrothendieck at gmail.com
Tue May 6 01:17:14 CEST 2014


On Fri, May 2, 2014 at 5:23 PM, Dr Eberhard Lisse <nospam at lisse.na> wrote:
> Hi,
>
> How do I do something like this without using sqldf?
>
> a <- sqldf("SELECT COUNT(*) FROM b WHERE c = 'd'")
>
> or
>
> e <- sqldf("SELECT f, COUNT(*) FROM b GROUP BY f ORDER BY f")
>

In the examples section at the bottom of ?sqldf are a number of SQL
statements and the corresponding R statements.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com



More information about the R-help mailing list