Description Usage Arguments Details Value Examples
Performs rbind on SQLDataFrame
objects.
1 2 |
... |
One or more |
deparse.level |
See ‘?base::cbind’ for a description of this argument. |
rbind
supports aggregation of SQLDataFrame
objects. For representation of SQLite tables, same or different
connections are supported. For representation of MySQL tables,
at least one SQLDataFrame must have write permission.
A SQLDataFrame
object.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | test.db1 <- system.file("extdata/test.db", package = "SQLDataFrame")
test.db2 <- system.file("extdata/test1.db", package = "SQLDataFrame")
con1 <- DBI::dbConnect(DBI::dbDriver("SQLite"), dbname = test.db1)
con2 <- DBI::dbConnect(DBI::dbDriver("SQLite"), dbname = test.db2)
obj1 <- SQLDataFrame(conn = con1,
dbtable = "state",
dbkey = c("region", "population"))
obj2 <- SQLDataFrame(conn = con2,
dbtable = "state1",
dbkey = c("region", "population"))
obj1_sub <- obj1[1:10, 2:3]
obj2_sub <- obj2[8:15,2:3]
## rbind
res_rbind <- rbind(obj1_sub, obj2_sub)
res_rbind
dim(res_rbind)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.