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 otherstatement 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,dMrs,elfgen,fdq,FIESTA,FIESTAutils,healthyR,icesDatsuQC,kangar00,KinSwingR,miRNAtap,msig,multimorbidity,mygene,nlive,OnomasticDiversity,puzzle,r3Cseq,RareComb,RcextTools,RiboProfiling,RImmPort,RITAN,Rprofet,RSDA,scorecardModelUtils,STRINGdb,taxotools,tcpl,WeibullFit |
| Reverse suggests: | DOPE,prqlr,R6causal,rcellminer,remotePARTS |
Linking:
Please use the canonical formhttps://CRAN.R-project.org/package=sqldfto link to this page.