[R] read.csv.sql() to select from a large csv file

[Juliane Struve]

Dear list,
 
Dear list,
I am using read.csv.sql() from the sqldf package to read
individual-based data from a csv file that is too large for R. 
My original file contains a column called “ID” that
identifies the individual. I would like to read in data for only 
one individual at a
time, for example "Bobby". 
read.csv.sql("filename",sql = 'select * from file where ID = “Bobby”') 
works fine, but 
Name <- "Bobby"
read.csv.sql("filename",sql = 'select * from file
where ID = Name') gives me an error message 
 “Error in sqliteExecStatement(con, statement,
bind.data) : 
RS-DBI driver: (error in statement: no such column: Name)”
 
I would like to use a variable in the select statement because I have many 
individuals in the original csv file, is this possible ? I have no experience 
with sql, perhaps someone can kindly point out how to do this correctly or 
offer an alternative solution ?
Thank you very much and happy Friday,
Juliane 
Dr. Juliane Struve
Fisheries and Aquatic Sciences
7922 NW 71st Street, Gainesville, FL 32653
352-273-3632 (tel)
352-392-3672 (fax)
email:mailto:jstr...@ufl.edu
        [[alternative HTML version deleted]]


______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.