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:<jdnew...@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 <wenbo...@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@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@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 ______________________________________________ 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.