[R] incomplete final line found by readTableHeader

Jeff Newmiller jdnewmil at dcn.davis.ca.us
Wed Oct 24 05:12:29 CEST 2012


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.
---------------------------------------------------------------------------
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.




More information about the R-help mailing list