Unable to read data using read.csv.sql in R

r
read_write

#1

I am still in learning phase and discovered the sqldfI was using read.csv.sql command of the sqldf package to read my file. Though the command is running, it is not returning any rows. I wrote the following code :

tr<-read.csv.sql("train.csv", sql = "select * from file", sep = ",")

Thanks in advance!


#2

@Corporate_Cowboy

Please reproduce the exact prblem so that we may help.

Regards


#3

Hi @NSS,

I was reading the ‘Crime Detection Dataset’ through the sqldf package when this error occured. The first command I used was
tr<-read.csv.sql("train.csv", sql = "select * from file", sep = ",")

Dataset is here