Other packages > Find by keyword >

sqldf  

Manipulate R Data Frames Using SQL
View on CRAN: Click here


Download and install sqldf package within the R console
Install from CRAN:
install.packages("sqldf")

Install from Github:
library("remotes")
install_github("cran/sqldf")

Install by package version:
library("remotes")
install_version("sqldf", "0.4-12")



Attach the package and use:
library("sqldf")
Maintained by
G. Grothendieck
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2007-07-21
Latest Update: 2017-06-28
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.
How to cite:
G. Grothendieck (2007). sqldf: Manipulate R Data Frames Using SQL. R package version 0.4-12, https://cran.r-project.org/web/packages/sqldf. Accessed 29 Oct. 2026.
Previous versions and publish date:
(2026-07-09 07:08), 0-1.0 (2007-07-21 14:12), 0-1.1 (2007-07-29 11:42), 0-1.2 (2008-12-10 09:37), 0-1.4 (2008-12-11 10:16), 0-1.5 (2009-06-07 15:09), 0-1.7 (2009-09-24 08:38), 0-2.0 (2009-12-24 11:42), 0-2.1 (2009-12-28 11:53), 0-3.2 (2010-02-01 20:26), 0-3.3 (2010-02-07 20:27), 0.3-4 (2010-02-14 15:44), 0.3-5 (2010-06-05 19:59), 0.4-0 (2011-06-15 20:13), 0.4-1.2 (2011-07-23 16:43), 0.4-1 (2011-06-29 11:42), 0.4-2 (2011-08-09 06:59), 0.4-3 (2011-11-06 08:39), 0.4-4 (2011-11-15 07:50), 0.4-5 (2011-11-22 13:19), 0.4-6.1 (2011-12-19 12:17), 0.4-6.4 (2012-03-28 20:13), 0.4-6 (2011-12-11 11:41), 0.4-7.1 (2014-03-15 16:35), 0.4-7 (2014-02-22 15:00), 0.4-9 (2014-10-27 07:12), 0.4-10 (2014-11-07 01:01), 0.4-11 (2017-06-28 08:43)
Other packages that cited sqldf R package
View sqldf citation profile
Other R packages that sqldf depends, imports, suggests or enhances
Complete documentation for sqldf
Functions, R codes and Examples using the sqldf R package
Some associated functions: read.csv.sql . sqldf-package . sqldf . 
Some associated R codes: sqldf.R . zzz.R .  Full sqldf package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
personalized2part  
Two-Part Estimation of Treatment Rules for Semi-Continuous Data
Implements the methodology of Huling, Smith, and Chen (2020) , w ...
Download / Learn more Package Citations See dependency  
binovisualfields  
Depth-Dependent Binocular Visual Fields Simulation
Simulation and visualization depth-dependent integrated visual fields. Visual fields are measured mo ...
Download / Learn more Package Citations See dependency  
fastRG  
Sample Generalized Random Dot Product Graphs in Linear Time
Samples generalized random product graphs, a generalization of a broad class of network models. Giv ...
Download / Learn more Package Citations See dependency  
GEVcdn  
GEV Conditional Density Estimation Network
Implements a flexible nonlinear modelling framework for nonstationary generalized extreme value anal ...
Download / Learn more Package Citations See dependency  

29,218

R Packages

247,686

Dependencies

77,281

Author Associations

29,219

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA