sqldf: Manipulate R Data Frames Using SQL
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.
Version: |
0.4-11 |
Depends: |
R (≥ 3.1.0), gsubfn (≥ 0.6), proto, RSQLite |
Imports: |
DBI, chron |
Suggests: |
RH2, RMySQL, RPostgreSQL, svUnit, tcltk, MASS |
Published: |
2017-06-28 |
DOI: |
10.32614/CRAN.package.sqldf |
Author: |
G. Grothendieck |
Maintainer: |
G. Grothendieck <ggrothendieck at gmail.com> |
BugReports: |
https://github.com/ggrothendieck/sqldf/issues |
License: |
GPL-2 |
URL: |
https://github.com/ggrothendieck/sqldf,
https://groups.google.com/group/sqldf |
NeedsCompilation: |
no |
Materials: |
README NEWS INSTALL |
In views: |
Databases, HighPerformanceComputing |
CRAN checks: |
sqldf results |
Documentation:
Downloads:
Reverse dependencies:
Reverse depends: |
Fgmutils, metevalue, smbinning |
Reverse imports: |
BETS, casper, Clustering, drugprepr, fdq, FIESTA, FIESTAutils, healthyR, idem, InterMineR, kangar00, KinSwingR, miRNAtap, msig, multimorbidity, mygene, nlive, OnomasticDiversity, ProfoundData, puzzle, r3Cseq, RareComb, RcextTools, RiboProfiling, RImmPort, RITAN, Rprofet, RSDA, scorecardModelUtils, STRINGdb, tcpl, visit, WeibullFit |
Reverse suggests: |
DOPE, prqlr, R6causal, rcellminer, remotePARTS |
Linking:
Please use the canonical form
https://CRAN.R-project.org/package=sqldf
to link to this page.