sqldf swMATH ID: 24873 Software Authors: G. Grothendieck Description: R package sqldf: Manipulate R Data Frames Using SQL. 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. Homepage: https://cran.r-project.org/web/packages/sqldf/index.html Source Code: https://github.com/cran/sqldf Dependencies: R Related Software: R; PROC_R; plyr; SAS; ColByCol; MatrixModels; RgoogleMaps; mapReduce; rpy2; RStudio; Hadoop; JGR; RODBC; foreign; Tinn-R; lme4; VGAM; nlme; quantreg; CRAN Cited in: 1 Publication Cited by 1 Author 1 Charpentier, Arthur Cited in 1 Serial 1 Chapman & Hall/CRC The R Series Cited in 1 Field 1 Game theory, economics, finance, and other social and behavioral sciences (91-XX) Citations by Year