Check for unbalanced quotes or comments. try: count.fields("RWM Shopper Tracker - RAW DATA - 22JUN09 - Copy.csv", quote='', comment.char='', sep=",")
On Mon, Jun 22, 2009 at 9:38 PM, Chris Howden <tall.chr...@yahoo.com.au>wrote: > Morning all, > > I'm trying to read in a csv file and R is having some problems. For some > reason its not 'seeing' all the columns for each row, and as such is not > reading in the file. > > I've opened the file in EXCEL and I can't see any problems with it. All > rows > have the correct number of columns. > > The code and error messages I've used are below. I've also run > 'count'fields" and have included that output too. > > Any help or suggestions would be much appreciated. > > Thanks > > > <-read.table("RWM Shopper Tracker - RAW DATA - 22JUN09 - Copy.csv", > header=TRUE, sep =",", row.names=NULL) > > Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, > : > line 13 did not have 2264 elements > > > > count.fields("RWM Shopper Tracker - RAW DATA - 22JUN09 - Copy.csv", > sep=",") > [1] 2264 2264 2264 2264 2264 2264 2264 2264 2264 2264 384 2264 2264 > 384 2264 2264 2264 2264 2264 2264 2264 2264 > [23] 2264 2264 2264 2264 152 2264 384 2264 2264 2264 2264 2264 2264 > 2264 2264 2264 2264 2264 2264 2264 2264 2264 > > > Chris Howden > Marketing Scientist > For all your Analysis, Modelling, Experimental Design and Training needs > (mobile) 0410 689 945 > (fax / office) (+618) 8952 7878 > tall.chr...@yahoo.com.au > > ______________________________________________ > 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. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? [[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.