SQLDataFrame: Representation of SQL database in DataFrame metaphor

SQLDataFrame is developed to lazily represent and efficiently analyze SQL-based tables in _R_. SQLDataFrame supports common and familiar 'DataFrame' operations such as '[' subsetting, rbind, cbind, etc.. The internal implementation is based on the widely adopted dplyr grammar and SQL commands. In-memory datasets or plain text files (.txt, .csv, etc.) could also be easily converted into SQLDataFrames objects (which generates a new database on-disk).

Package details

AuthorQian Liu [aut, cre] (<https://orcid.org/0000-0003-1456-5099>), Martin Morgan [aut]
Bioconductor views DataRepresentation Infrastructure
MaintainerQian Liu <qian.liu@roswellpark.org>
LicenseGPL-3
Version1.4.2
URL https://github.com/Bioconductor/SQLDataFrame
Package repositoryView on Bioconductor
Installation Install the latest version of this package by entering the following in R:
if (!requireNamespace("BiocManager", quietly = TRUE))
    install.packages("BiocManager")

BiocManager::install("SQLDataFrame")

Try the SQLDataFrame package in your browser

Any scripts or data that you put into this service are public.

SQLDataFrame documentation built on Nov. 29, 2020, 2:01 a.m.