Sean Zhang
2009-Aug-19 19:35 UTC
[R] why need a new database to store results generated from another database in filehash?
Dear R-Helpers: I am trying filehash and would like to know whether I have to create a new database to store results generated from another database. Example code is presented below to show the question. #R code below------------ library(filehash) dbCreate("myDB1") db1 <- dbInit("myDB1") dbDelete(db1,"a") dbInsert(db1, "a", data.frame(id=I(LETTERS[1:3]))) dbInsert(db1, "b", data.frame(id=I(LETTERS[2:3]))) #the following line does Not work, "a_and_b" will not created dbInsert(db1,"a_and_b",merge(db1$a,db1$b,by='id')) dbList(db1) #however, a new database(db2) can store "a_and_b" dbCreate("myDB2") db2<-dbInit("myDB2") dbInsert(db2,"a_and_b",merge(db1$a,db1$b,by='id')) dbList(db2) db2$a_and_b #R code above ------------ Is it possible to make dbInsert(db1,"a_and_b",merge(db1$a,db1$b,by='id')) work? I am interested in avoiding creating db2. Many thanks in advance! -Sean [[alternative HTML version deleted]]