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 30 Jan. 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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

kesernetwork  
Visualization of the KESER Network
A shiny app to visualize the knowledge networks for the code concepts. Using co-occurrence matrices ...
Download / Learn more Package Citations See dependency  
GGMncv  
Gaussian Graphical Models with Nonconvex Regularization
Estimate Gaussian graphical models with nonconvex penalties , including ...
Download / Learn more Package Citations See dependency  
fastmit  
Fast Mutual Information Based Independence Test
A mutual information estimator based on k-nearest neighbor method proposed by A. Kraskov, et al. (20 ...
Download / Learn more Package Citations See dependency  
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  
WtTopsis  
Weighted Method for Multiple-Criteria Decision Making
Evaluation of alternatives based on multiple criteria using weighted technique for Order preference ...
Download / Learn more Package Citations See dependency  
convertid  
Convert Gene IDs Between Each Other and Fetch Annotations from Biomart
Gene Symbols or Ensembl Gene IDs are converted using the Bimap interface in 'AnnotationDbi' in conve ...
Download / Learn more Package Citations See dependency  

23,580

R Packages

204,057

Dependencies

63,980

Author Associations

23,581

Publication Badges

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