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 25 Jun. 2026.
Previous versions and publish date:
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

edeaR  
Exploratory and Descriptive Event-Based Data Analysis
Exploratory and descriptive analysis of event based data. Provides methods for describing and select ...
Download / Learn more Package Citations See dependency  
sitmo  
Parallel Pseudo Random Number Generator (PPRNG) 'sitmo' Header Files
Provided within are two high quality and fast PPRNGs that may be used in an 'OpenMP' parallel enviro ...
Download / Learn more Package Citations See dependency  
foster  
Forest Structure Extrapolation with R
Set of tools to streamline the modeling of the relationship betweensatellite imagery time series or ...
Download / Learn more Package Citations See dependency  
quickcode  
Quick and Essential 'R' Tricks for Better Scripts
The NOT functions, 'R' tricks and a compilation of some simple quick plus often used 'R' codes to im ...
Download / Learn more Package Citations See dependency  
airGRiwrm  
'airGR' Integrated Water Resource Management
Semi-distributed Precipitation-Runoff Modelling based on 'airGR' package models integrating human i ...
Download / Learn more Package Citations See dependency  

27,535

R Packages

236,180

Dependencies

73,223

Author Associations

27,536

Publication Badges

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