Description Usage Arguments Value See Also Examples
Instruct MonetDBLite to read a CSV file, optionally also create the table for it.
1 2 3 4 |
conn |
A MonetDBLite 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. |
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. |
best.effort |
Use best effort flag when reading csv files and continue importing even if parsing of fields/lines fails. |
na.strings |
Which string value to interpret as |
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. |
newline |
Newline in CSV file, usually \n for UNIX-like systems and \r\r on Windows. |
quote |
Quote character(s) in CSV file. |
lower.case.names |
Convert all column names to lowercase in the database? |
col.names |
Optional column names in case the ones from CSV file should not be used |
sep |
alias for |
... |
Additional parameters. Currently not in use. |
Returns the number of rows imported if successful.
dbWriteTable
in DBIConnection-class
1 2 3 4 5 6 7 8 9 10 11 12 13 | # initiate a MonetDBLite server
library(DBI)
dbdir <- file.path( tempdir() , 'readcsv' )
con <- dbConnect( MonetDBLite::MonetDBLite() , dbdir )
# write test data to temporary CSV file
file <- tempfile()
write.table(iris, file, sep=",", row.names=FALSE)
# create table and import CSV
monetdb.read.csv(con, file, "iris")
dbDisconnect(con, shutdown=TRUE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.