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]
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 07 Apr. 2025.
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)
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
03/0803/0903/1003/1103/1203/1303/1403/1503/1603/1703/1803/1903/2003/2103/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/0404/05Downloads for sqldf30040050060070080090010001100120013001400TrendBars

Today's Hot Picks in Authors and Packages

r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
MetaAnalyser  
An Interactive Visualisation of Meta-Analysis as a Physical Weighing Machine
An interactive application to visualise meta-analysis data as a physical weighing machine. The inte ...
Download / Learn more Package Citations See dependency  
letsR  
Data Handling and Analysis in Macroecology
Handling, processing, and analyzing geographic data on species' distributions and environmental var ...
Download / Learn more Package Citations See dependency  
ASMap  
Linkage Map Construction using the MSTmap Algorithm
Functions for Accurate and Speedy linkage map construction, manipulation and diagnosis of Doubled Ha ...
Download / Learn more Package Citations See dependency  
probout  
Unsupervised Multivariate Outlier Probabilities for Large Datasets
Estimates unsupervised outlier probabilities for multivariate numeric data with many observations fr ...
Download / Learn more Package Citations See dependency  
nutriNetwork  
Structure Learning with Copula Graphical Model
Statistical tool for learning the structure of direct associations among variables for continuous d ...
Download / Learn more Package Citations See dependency  

24,012

R Packages

207,311

Dependencies

64,867

Author Associations

24,013

Publication Badges

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