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.

Total

1,265,595

Last month

31,324

Last week

7,321

Average per day

1,044

Daily downloads

Total downloads

Description file content

Package
sqldf
Version
0.4-11
Date
2017-06-23
Title
Manipulate R Data Frames Using SQL
Author
G. Grothendieck
Maintainer
G. Grothendieck
Description
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.
ByteCompile
true
Depends
R (>= 3.1.0), gsubfn (>= 0.6), proto, RSQLite
Suggests
RH2, RMySQL, RPostgreSQL, svUnit, tcltk, MASS
Imports
DBI, chron
License
GPL-2
BugReports
https://github.com/ggrothendieck/sqldf/issues
URL
NeedsCompilation
no
Packaged
2017-06-28 00:38:13 UTC; Louis
Repository
CRAN
Date/Publication
2017-06-28 06:43:10 UTC

install.packages('sqldf')

0.4-11

a year ago

https://github.com/ggrothendieck/sqldf

G. Grothendieck

GPL-2

Depends on

R (>= 3.1.0), gsubfn (>= 0.6), proto, RSQLite

Imports

DBI, chron

Suggests

RH2, RMySQL, RPostgreSQL, svUnit, tcltk, MASS

Discussions