[R] SQL on R

Bernardo Rangel Tura tura at centroin.com.br
Sun Jul 5 13:53:52 CEST 2009


On Sat, 2009-07-04 at 22:24 -0700, JoK LoQ wrote:
> I'm dealing with lots of columns and conditions, wats t best way to deal with
> that?
> How do I work with SQL on R? the manual is quite confuse talking about that.
> Do I need a package?

I don't understand your question, but 

if you think use SQL in your data frames do you use SQLDF
(http://cran.r-project.org/web/packages/sqldf/index.html) 

if you thinks use a database server and access it in R i sugest you use
RMySQL (http://cran.r-project.org/web/packages/RMySQL/index.html)
-- 
Bernardo Rangel Tura, M.D,MPH,Ph.D
National Institute of Cardiology
Brazil




More information about the R-help mailing list