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 <nos...@lisse.na > <mailto:nos...@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@r-project.org <mailto:R-help@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>
______________________________________________ R-help@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.
