Re: [R] Fwd: Datatable manipulation

Hi, Check these links: http://stackoverflow.com/questions/19626534/r-issue-error-in-sqliteexecstatementcon-statement-bind-data-no-such-tabl http://r.789695.n4.nabble.com/Problem-with-SQLDF-Error-in-sqliteExecStatement-con-statement-bind-data-RS-DBI-driver-error-in-state-td4621931.html A.K.

Re: [R] Fwd: Datatable manipulation

Hi, I have a doubt after a long time :) . I have a function which has sqldf statements and it works fine when I call it from console but when I am calling that function within another function, it gives me the error that *Error in sqliteExecStatement(con, statement, bind.data) : * * RS-DBI driver:

Re: [R] Fwd: Datatable manipulation

Hi, Assuming that this is the case: dat1 <- read.table(text="a b c d   e 1 2 3 4 5 10 9 8 7 6",sep="",header=TRUE) Names1<- read.table(text="Original  New   e ee g    gg a aa c cc f ff",sep="",header=TRUE,stringsAsFactors=FALSE

Re: [R] Fwd: Datatable manipulation

Hi, Try: dat1 <- read.table(text="a     b     c     d   e 1     2     3     4     5 10     9     8     7     6",sep="",header=TRUE) Names1<- read.table(text="Original      New    e     ee b     bb    a     aa c     cc d     dd",sep="",header=TRUE,stringsAsFactors=FALSE) It is better to d