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, dMrs, drugprepr, 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 form https://CRAN.R-project.org/package=sqldf to link to this page.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4