CRAN/E | sqldf

sqldf

Manipulate R Data Frames Using SQL

Installation

About

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.

github.com/ggrothendieck/sqldf
groups.google.com/group/sqldf
Bug report File report

Key Metrics

Version 0.4-11
R ≥ 3.1.0
Published 2017-06-28 2583 days ago
Needs compilation? no
License GPL-2
CRAN checks sqldf results

Downloads

Yesterday 892 0%
Last 7 days 4.389 -30%
Last 30 days 22.293 -22%
Last 90 days 83.398 -34%
Last 365 days 424.189 -36%

Maintainer

Maintainer

G. Grothendieck

Authors

G. Grothendieck

Material

README
NEWS
INSTALL
Reference manual
Package source

In Views

Databases
HighPerformanceComputing

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

sqldf archive

Depends

R ≥ 3.1.0
gsubfn ≥ 0.6
proto
RSQLite

Imports

DBI
chron

Suggests

RH2
RMySQL
RPostgreSQL
svUnit
tcltk
MASS

Reverse Depends

Fgmutils
smbinning

Reverse Imports

bdvis
BETS
casper
Clustering
drugprepr
elfgen
fdq
FIESTA
FIESTAutils
healthyR
helda
icesDatsuQC
idem
InterMineR
kangar00
KinSwingR
miRNAtap
msig
multimorbidity
mygene
ProfoundData
puzzle
r3Cseq
RareComb
RcextTools
RiboProfiling
RImmPort
RITAN
Rprofet
RSDA
scorecardModelUtils
scoringTools
STRINGdb
tcpl
visit
WeibullFit

Reverse Suggests

DOPE
R6causal
rcellminer