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-11")



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-11, https://cran.r-project.org/web/packages/sqldf. Accessed 20 Sep. 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

fresh  
Create Custom 'Bootstrap' Themes to Use in 'Shiny'
Customize 'Bootstrap' and 'Bootswatch' themes, like colors, fonts, grid layout, to use in 'Shiny' a ...
Download / Learn more Package Citations See dependency  
mvShapiroTest  
Generalized Shapiro-Wilk test for multivariate normality
This package implements the generalization of the Shapiro-Wilk testfor multivariate normalit ...
Download / Learn more Package Citations See dependency  
wordgraph  
Graph Functionality of Free Associated Words
Functions that help less experienced R users to make graph analysis for free associated words or mor ...
Download / Learn more Package Citations See dependency  
MSGARCHelm  
Hybridization of MS-GARCH and ELM Model
Implements the three parallel forecast combinations of Markov Switching GARCH and extreme learning m ...
Download / Learn more Package Citations See dependency  
sqldf  
Manipulate R Data Frames Using SQL
The sqldf() function is typically passed a single argument which is an SQL select statement where ...
Download / Learn more Package Citations See dependency  
finalfit  
Quickly Create Elegant Regression Results Tables and Plots when Modelling
Generate regression results tables and plots in final format for publication. Explore models and ex ...
Download / Learn more Package Citations See dependency  

28,720

R Packages

239,283

Dependencies

75,677

Author Associations

28,566

Publication Badges

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