Description Usage Arguments Details Value References See Also
Edited version of read.csv.sql
in the sqldf
package (tcltk
functionality removed), used mainly
to create a SQLite database from a text file. The function
makeDb
wraps this function in the tornado package,
so no need to execute this directly.
1 2 3 |
file |
A file path or a URL (beginning with
|
sql |
character string holding an SQL statement. The
table representing the file should be referred to as
|
header |
as in |
sep |
as in |
row.names |
as in |
eol |
Character that ends lines |
skip |
Skip indicated number of lines in input file. |
filter |
see |
nrows |
Number of rows used to determine column types. It defaults to 50. Using -1 causes it to use all rows for determining column types. This argument is rarely needed. |
field.types |
A list whose names are the column names and whose contents are the SQLite types (not the R class names) of the columns. Specifying these types improves how fast it takes. Unless speed is very important this argument is not normally used. |
comment.char |
If specified this character and anything following it on any line of the input will be ignored. |
dbname |
As in |
drv |
ignored: the only drive used can be SQLite. |
... |
arguments passed to |
This function is entirely wrapped by makeDb
–
experienced users may use this for debugging, but otherwise
not usually necessary to call directly.
If the sql statement is a select statement then a data frame is returned. In tornado, this is never the case.
http://cran.r-project.org/web/packages/sqldf/sqldf.pdf
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.