[R] SQL vs R

Dr Eberhard W Lisse el at lisse.NA
Sat May 3 21:53:10 CEST 2014


Thanks,

will try to figure this out :-)-O

el

On 2014-05-03, 06:40 , Carlos Ortega wrote:
> Hi,
> 
> With the new package "dplyr" you can create equivalent SQL sintaxt
> queries like the one you need.
> You can find examples of how to apply it here:
> 
> http://martinsbioblogg.wordpress.com/2014/03/26/using-r-quickly-calculating-summary-statistics-with-dplyr/
> 
> http://martinsbioblogg.wordpress.com/2014/03/27/more-fun-with-and/
> 
> Regards,
> Carlos.
> 
> 
> 
> 
> 2014-05-02 23:23 GMT+02:00 Dr Eberhard Lisse <nospam at lisse.na
> <mailto:nospam at lisse.na>>:
> 
>     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")
> 
>     greetings, el
> 
>     ______________________________________________
>     R-help at r-project.org <mailto: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.
> 
> 
> 
> 
> -- 
> Saludos,
> Carlos Ortega
> www.qualityexcellence.es <http://www.qualityexcellence.es>



More information about the R-help mailing list