R package citation, R package reverse dependencies, R package scholars, install an r package from GitHub hy is package acceptance pending why is package undeliverable amazon why is package on hold dhl tour packages why in r package r and r package full form why is r free why r is bad which r package to install which r package has which r package which r package version which r package readxl which r package ggplot which r package fread which r package license where is package.json where is package-lock.json where is package.swift where is package explorer in eclipse where is package where is package manager unity where is package installer android where is package manager console in visual studio who r package which r package to install which r package version who is package who is package deal who is package design r and r package full form r and r package meaning what r package has what package r what is package in java what is package what is package-lock.json what is package in python what is package.json what is package installer do r package can't install r packages r can't find package r can't load package can't load xlsx package r can't install psych package r can't install sf package r Write if else in NONMEM pk pd
sqldf
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]
[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
A shiny app to visualize the knowledge networks for the code concepts. Using co-occurrence matrices ...
Download / Learn more Package Citations See dependency
Download / Learn more Package Citations See dependency
Maintainer: Su-Chun Cheng (view profile)
GGMncv
Estimate Gaussian graphical models with nonconvex penalties ,
including ...
Download / Learn more Package Citations See dependency
Download / Learn more Package Citations See dependency
Maintainer: Donald Williams (view profile)
fastmit
A mutual information estimator based on k-nearest neighbor method proposed by A. Kraskov, et al. (20 ...
Download / Learn more Package Citations See dependency
Download / Learn more Package Citations See dependency
Maintainer: Shiyun Lin (view profile)
r2resize
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency
Download / Learn more Package Citations See dependency
Maintainer: Obinna Obianom (view profile)
WtTopsis
Evaluation of alternatives based on multiple criteria using weighted technique for Order preference ...
Download / Learn more Package Citations See dependency
Download / Learn more Package Citations See dependency
Maintainer: zhengyu wu (view profile)
convertid
Gene Symbols or Ensembl Gene IDs are converted using the Bimap interface in 'AnnotationDbi' in conve ...
Download / Learn more Package Citations See dependency
Download / Learn more Package Citations See dependency
Maintainer: Vidal Fey (view profile)