Skip to content
Sections
>> Trisquel >> Packages >> aramo >> gnu-r >> r-cran-sqldf
aramo  ]
[ Source: r-cran-sqldf  ]

Package: r-cran-sqldf (0.4-11-2)

manipulate GNU 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.

Other Packages Related to r-cran-sqldf

  • depends
  • recommends
  • suggests
  • dep: r-api-4.0
    virtual package provided by r-base-core
  • dep: r-base-core (>= 4.1.2-1ubuntu1)
    GNU R core of statistical computation and graphics system
  • dep: r-cran-chron
    GNU R package for chronologically ordered objects
  • dep: r-cran-dbi
    GNU R package providing a generic database interface
  • dep: r-cran-gsubfn (>= 0.6)
    GNU R utilities for strings and function arguments
  • dep: r-cran-proto
    Prototype object-based programming
  • dep: r-cran-rsqlite
    Database Interface R driver for SQLite
  • rec: r-cran-svunit
    SciViews - Unit, Integration and System Testing
  • sug: r-cran-mass
    GNU R package of Venables and Ripley's MASS
  • sug: r-cran-rmysql
    GNU R package providing a DBI-compliant interface to MySQL
  • sug: r-cran-rpostgresql
    GNU R package providing database interface and driver for PostgreSQL

Download r-cran-sqldf

Download for all available architectures
Architecture Package Size Installed Size Files
all 75.4 kB134 kB [list of files]