Description Usage Arguments Value See Also Examples
Instruct MonetDB to read a CSV file, optionally also create the table for it.
1 2 |
conn |
A MonetDB.R database connection. Created using |
files |
A single string or a vector of strings containing the absolute file names of the CSV files to be imported. |
tablename |
Name of the database table the CSV files should be imported in. Created if necessary. |
nrows |
Total number of rows to import. Can be an upper bound. |
header |
Whether or not the CSV files contain a header line. |
locked |
Whether or not to disable transactions for import. Setting this to TRUE can greatly improve the import performance. |
na.strings |
Which string value to interpret as |
... |
Additional parameters. Currently not in use. |
nrow.check |
Amount of rows that should be read from the CSV when the table is being created to determine column types. |
delim |
Field separator in CSV file. |
Returns the number of rows imported if successful.
dbWriteTable
in DBIConnection-class
1 2 3 4 5 6 7 8 9 10 11 | ## Not run:
# connect to MonetDB
conn <- dbConnect(MonetDB.R(), "monetdb://localhost/demo")
# write test data to temporary CSV file
data(iris)
file <- tempfile()
write.table(iris, file, sep=",")
# create table and import CSV
monetdb.read.csv(conn, file, "iris", 150)
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.