Row.names in read.csv vs read.csv.sql (sqldf package)

the description of the argument row.namesin read.csv.sqlsimply says: "Like in" read.csv "

However, when I try to read in a simple csv file with the first column as row names, the behavior is read.csv.sqlnot what I expect.

 d <- data.frame("a"=c(1:10), "b"=c(15:24), "c"=c(21:30), row.names=paste("r", c(1:10), sep=""))
 write.csv(d,"foo.txt", quote=T)
 head(read.csv("foo.txt", row.names=1), 3)
   a  b  c
r1 1 15 21
r2 2 16 22
r3 3 17 23

read.csvgives what I could hope for. When I try read.csv.sqlhowever:

 head(read.csv.sql("foo.txt", row.names=1), 3)
 Error in try({ :
 RS-DBI driver: (RS_sqlite_import: ./foo.txt line 2 expected 5 columns of data but found      4)
 Error in sqliteExecStatement(con, statement, bind.data) :
 RS-DBI driver: (error in statement: no such table: file)

, , csv read.csv.sql header=T , , , , , , , , , .

-, , , read.csv.sql 1 ?

+3

All Articles