[R] incomplete final line found by readTableHeader

[David Winsemius]

On Oct 23, 2012, at 8:12 PM, Jeff Newmiller wrote:

> Keep in mind that this is NOT a homework support list... you are supposed to use the support provided by your educational institution if you are in a course. Read the posting guide mentioned in the footer of every email.
> 
> FWIW, as described your problem is with Excel, and this is not an Excel support list either. I suggest that you edit the csv file with a text editor (e.g. NotePad) to make sure the correct number of commas are on each line of the data file.

All true. Plus it's just a warning that the last line did not end with a <cr>. You should find that the data got into the object just fine. Warnings are NOT errors.

-- 
David.
> ---------------------------------------------------------------------------
> Jeff Newmiller                        The     .....       .....  Go Live...
> DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
>                                      Live:   OO#.. Dead: OO#..  Playing
> Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
> /Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
> --------------------------------------------------------------------------- 
> Sent from my phone. Please excuse my brevity.
> 
> Shane2012 <wenbo520 at live.cn> wrote:
> 
>> Hello, 
>> 
>> I am trying to read in an Excel file that I saved as a .csv so I can
>> analyze 
>> my assignment data! I am getting really frustrated because this is what
>> I 
>> keep getting: 
>> Warning message:
>> In read.table("CityData.CSV", sep = "/", header = T) :
>> incomplete final line found by readTableHeader on 'CityData.CSV'
>> 
>> I have open the file and make sure click return after the last line,
>> then
>> save the file.
>> 
>> I try to use kinds of read data frame methods, such as 
>> 
>> read.table  
>> 
>> read.csv   or 
>> my.files <- list.files("path")
>> for(i in my.files) 
>> { 
>> 	nam <- paste("CityData", substr(i, 14, 15), sep ='')
>> 	assign(nam, read.csv(i))
>> }
>> -------------------------
>> They all failed.
>> 
>> Can anyone offer some help? Thanks a lot!  
>> 
>> 
>> 
>> --
>> View this message in context:
>> http://r.789695.n4.nabble.com/incomplete-final-line-found-by-readTableHeader-tp4647259.html
>> Sent from the R help mailing list archive at Nabble.com.
>> 
>> ______________________________________________
>> R-help at 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.
> 
> ______________________________________________
> R-help at 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.

David Winsemius, MD
Alameda, CA, USA