Thanks Jim. But my data is like that and I have to live with that. Any idea on workaround. Thanks, On Sun, Sep 4, 2016 at 3:40 PM, Jim Lemon <drjimlemon at gmail.com> wrote:> Hi Christofer, > You have embedded commas in your data structure. This is guaranteed to > mess up a CSV read. > > Jim > > > On Sun, Sep 4, 2016 at 5:54 PM, Christofer Bogaso > <bogaso.christofer at gmail.com> wrote: >> Hi again, >> >> I was trying to read a subset of Data from a CSV file using below code >> as example : >> >> library(sqldf) >> >> Dat = structure(list(`col 1` = c(133261L, 133261L, 133262L, 133262L >> ), `col 2` = structure(1:4, .Label = c("aaa1", "aaa2", "bbb1, bbb", >> "bbb3, bbb"), class = "factor"), `col 3` = c(10.59, 10.56, 10.59, >> 10.56), `col 4` = c(10.59, 10.56, 10.59, 10.56), `col 5` = c(10.59, >> 10.56, 10.59, 10.56), `col 6` = structure(c(1L, 2L, 1L, 2L), .Label >> c("04-Jul-16", >> "05-Jul-16"), class = "factor")), .Names = c("col 1", "col 2", >> "col 3", "col 4", "col 5", "col 6"), class = "data.frame", row.names = c(NA, >> -4L)) >> Dat >> >> write.csv(Dat, "Dat.csv", quote = FALSE, row.names = FALSE) >> >> ReadName = '133261' >> read.csv.sql("Dat.csv", sql = "select * from file where 'col 1' = ReadName") >> >> Loading required package: tcltk >> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : >> line 1 did not have 7 elements >> >> This code generates above Error. Could you please help me with a >> pointer where something went wrong? My actual CSV file is quite huge >> so I cant read it as whole. However basic structure of my original >> file is similar as above "Dat" >> >> Thanks for your time. >> >> ______________________________________________ >> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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.
I suppose you could try quote=TRUE Jim On Sun, Sep 4, 2016 at 8:13 PM, Christofer Bogaso <bogaso.christofer at gmail.com> wrote:> Thanks Jim. But my data is like that and I have to live with that. Any > idea on workaround. Thanks, > > On Sun, Sep 4, 2016 at 3:40 PM, Jim Lemon <drjimlemon at gmail.com> wrote: >> Hi Christofer, >> You have embedded commas in your data structure. This is guaranteed to >> mess up a CSV read. >> >> Jim >> >> >> On Sun, Sep 4, 2016 at 5:54 PM, Christofer Bogaso >> <bogaso.christofer at gmail.com> wrote: >>> Hi again, >>> >>> I was trying to read a subset of Data from a CSV file using below code >>> as example : >>> >>> library(sqldf) >>> >>> Dat = structure(list(`col 1` = c(133261L, 133261L, 133262L, 133262L >>> ), `col 2` = structure(1:4, .Label = c("aaa1", "aaa2", "bbb1, bbb", >>> "bbb3, bbb"), class = "factor"), `col 3` = c(10.59, 10.56, 10.59, >>> 10.56), `col 4` = c(10.59, 10.56, 10.59, 10.56), `col 5` = c(10.59, >>> 10.56, 10.59, 10.56), `col 6` = structure(c(1L, 2L, 1L, 2L), .Label >>> c("04-Jul-16", >>> "05-Jul-16"), class = "factor")), .Names = c("col 1", "col 2", >>> "col 3", "col 4", "col 5", "col 6"), class = "data.frame", row.names = c(NA, >>> -4L)) >>> Dat >>> >>> write.csv(Dat, "Dat.csv", quote = FALSE, row.names = FALSE) >>> >>> ReadName = '133261' >>> read.csv.sql("Dat.csv", sql = "select * from file where 'col 1' = ReadName") >>> >>> Loading required package: tcltk >>> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : >>> line 1 did not have 7 elements >>> >>> This code generates above Error. Could you please help me with a >>> pointer where something went wrong? My actual CSV file is quite huge >>> so I cant read it as whole. However basic structure of my original >>> file is similar as above "Dat" >>> >>> Thanks for your time. >>> >>> ______________________________________________ >>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >>> 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.
Didnt work.... getting unused argument error. On Sun, Sep 4, 2016 at 4:47 PM, Jim Lemon <drjimlemon at gmail.com> wrote:> I suppose you could try quote=TRUE > > Jim > > > On Sun, Sep 4, 2016 at 8:13 PM, Christofer Bogaso > <bogaso.christofer at gmail.com> wrote: >> Thanks Jim. But my data is like that and I have to live with that. Any >> idea on workaround. Thanks, >> >> On Sun, Sep 4, 2016 at 3:40 PM, Jim Lemon <drjimlemon at gmail.com> wrote: >>> Hi Christofer, >>> You have embedded commas in your data structure. This is guaranteed to >>> mess up a CSV read. >>> >>> Jim >>> >>> >>> On Sun, Sep 4, 2016 at 5:54 PM, Christofer Bogaso >>> <bogaso.christofer at gmail.com> wrote: >>>> Hi again, >>>> >>>> I was trying to read a subset of Data from a CSV file using below code >>>> as example : >>>> >>>> library(sqldf) >>>> >>>> Dat = structure(list(`col 1` = c(133261L, 133261L, 133262L, 133262L >>>> ), `col 2` = structure(1:4, .Label = c("aaa1", "aaa2", "bbb1, bbb", >>>> "bbb3, bbb"), class = "factor"), `col 3` = c(10.59, 10.56, 10.59, >>>> 10.56), `col 4` = c(10.59, 10.56, 10.59, 10.56), `col 5` = c(10.59, >>>> 10.56, 10.59, 10.56), `col 6` = structure(c(1L, 2L, 1L, 2L), .Label >>>> c("04-Jul-16", >>>> "05-Jul-16"), class = "factor")), .Names = c("col 1", "col 2", >>>> "col 3", "col 4", "col 5", "col 6"), class = "data.frame", row.names = c(NA, >>>> -4L)) >>>> Dat >>>> >>>> write.csv(Dat, "Dat.csv", quote = FALSE, row.names = FALSE) >>>> >>>> ReadName = '133261' >>>> read.csv.sql("Dat.csv", sql = "select * from file where 'col 1' = ReadName") >>>> >>>> Loading required package: tcltk >>>> Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : >>>> line 1 did not have 7 elements >>>> >>>> This code generates above Error. Could you please help me with a >>>> pointer where something went wrong? My actual CSV file is quite huge >>>> so I cant read it as whole. However basic structure of my original >>>> file is similar as above "Dat" >>>> >>>> Thanks for your time. >>>> >>>> ______________________________________________ >>>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >>>> 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.