sqldf

MaRDI QIDQ36621swMATHCRANFDO

Authors G. Grothendieck

Last update 30 January 2026

Copyright license GNU General Public License, version 2.0

Software version identifier 0.4-11, PACKAGES.rds, 0-1.0, 0-1.1, 0-1.2, 0-1.4, 0-1.5, 0-1.7, 0-2.0, 0-2.1, 0-3.2, 0-3.3, 0.3-4, 0.3-5, 0.4-0, 0.4-1.2, 0.4-1, 0.4-2, 0.4-3, 0.4-4, 0.4-5, 0.4-6.1, 0.4-6.4, 0.4-6, 0.4-7.1, 0.4-7, 0.4-9, 0.4-10, 0.4-12

Official website https://cran.r-project.org/web/packages/sqldf/index.html

Source code repository https://github.com/cran/sqldf

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 otherstatement 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.

Cited in

(42)

• Clustering
• bdvis
• RareComb
• drugprepr
• msig
• Fgmutils
• nlive
• ColByCol
• MatrixModels
• ProfoundData
• puzzle
• visit
• WeibullFit
• RcextTools
• plyr
• boxr
• cowplot
• mapReduce
• APL2
• SwissAir
• scoringTools
• smbinning
• RSDA
• PROC_R
• scientific article; zbMATH DE number 6323197 (Why is no real title available?)
• OnomasticDiversity
• metevalue
• FIESTAutils
• icesDatsuQC
• healthyR
• ACRER
• epicR
• dMrs
• Rprofet
• fdq
• scorecardModelUtils
• multimorbidity
• FIESTA
• taxotools
• kangar00
• tcpl
• elfgen

This page was built for software: sqldf