sqldf: Perform SQL Selects on R Data Frames

> library(sqldf)

Loading required package: gsubfn

Loading required package: proto

Loading required package: RSQLite

バージョン: 0.4.10

関数名 概略
read.csv.sql Read File Filtered by SQL
sqldf SQL select on data frames
sqldf-package sqldf package overview

read.csv.sql

Arguments

  • file... ファイルまでのパスかURI（http, ftp）を指定
  • sql
  • header
  • seq
  • row.names
  • eol
  • skip
  • filter
  • nrows
  • field.types
  • colClasses
  • dbname
  • drv
  • ...
> read.csv.sql(file, 
+              sql = "select * from file", 
+              header = TRUE, 
+              sep = ",", 
+              row.names, 
+              eol, 
+              skip, 
+              filter,
+              nrows, 
+              field.types,
+              colClasses, 
+              dbname = tempfile(), 
+              drv = "SQLite", 
+              ...)
> 
> read.csv2.sql(file, 
+               sql = "select * from file", 
+               header = TRUE, 
+               sep = ";", 
+               row.names, 
+               eol, 
+               skip, 
+               filter, 
+               nrows, 
+               field.types,
+               colClasses,
+               dbname = tempfile(), 
+               drv = "SQLite", 
+               ...)

sqldf

Arguments

  • x
  • stringsAsFactors
  • row.names
  • envir
  • method
  • file.format
  • dbname
  • drv
  • user
  • password
  • host
  • port
  • dll
  • connection
  • verbose
> sqldf("select * from table_test")