sqldf (0.4-11)

6 users

Manipulate R Data Frames Using SQL.

https://github.com/ggrothendieck/sqldf
https://groups.google.com/group/sqldf
http://cran.r-project.org/web/packages/sqldf

The sqldf() function is typically passed a single argument which is an SQL select statement where the table names are ordinary R data frame names. sqldf() transparently sets up a database, imports the data frames into that database, performs the SQL select or other statement and returns the result using a heuristic to determine which class to assign to each column of the returned data frame. The sqldf() or read.csv.sql() functions can also be used to read filtered files into R even if the original files are larger than R itself can handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported.

Maintainer: G Grothendieck
Author(s): G. Grothendieck <ggrothendieck@gmail.com>

License: GPL-2

Uses: chron, DBI, gsubfn, proto, RSQLite, RMySQL, RPostgreSQL, svUnit, MASS, RH2
Reverse depends: dmRTools, Fgmutils, pbdDEMO, rEHR, RSDA, smbinning, vmsbase
Reverse suggests: sqlutils
Reverse enhances: pbdDEMO

Released about 1 month ago.


20 previous versions

Ratings

Overall:

  5.0/5 (1 vote)

Documentation:

  0.0/5 (0 votes)

Log in to vote.

Reviews


Related packages: GAMBoost, Matching, bayesm, biglm, bnlearn, caret, ff, inline, latentnet, lga, nws, pls, proftools, pvclust, rJava, rgenoud, rlecuyer, snowFT, snow, tm(20 best matches, based on common tags.)


Search for sqldf on google, google scholar, r-help, r-devel.

Visit sqldf on R Graphical Manual.