*When i tried to read a table i**n .csv or .txt format R i get the following message and give some problem in orden to run the data o make test, etc* *Warning message* *In read.table(file = file, header = header, sep =";") *>* incomplete final line found by readTableHeader on 'test.csv* *I tried Uninstall R and Excel, and install again but the problem doesnt fix.* *Regard* [[alternative HTML version deleted]]
http://stackoverflow.com/questions/5990654/incomplete-final-line-warning-when-trying-to-read-a-csv-file-into-r On Tue, Oct 6, 2015 at 11:14 AM, Marco Otoya Chavarria <marco.otoya.chavarria at una.cr> wrote:> *When i tried to read a table i**n .csv or .txt format R i get the > following message and give some problem in orden to run the data o > make test, etc* > > *Warning message* > > *In read.table(file = file, header = header, sep =";") > *>* incomplete final line found by readTableHeader on 'test.csv* > > *I tried Uninstall R and Excel, and install again but the problem doesnt fix.* > > *Regard* >-- Sarah Goslee http://www.functionaldiversity.org
You have a warning, not an error. The command ran but there was a problem with the .csv or .txt file. You should have a partial data set in R. Try using the str() function to see what variables and what rows were read. Adding the fill=TRUE argument to read.table() will pad incomplete rows with blanks, but you should check the data to make sure you have what you were expecting. Without the data it is impossible to be sure, but you may have an incomplete line at the end of your data file. Use a text editor to look at your data so see if the last line is incomplete. ------------------------------------- David L Carlson Department of Anthropology Texas A&M University College Station, TX 77840-4352 -----Original Message----- From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Marco Otoya Chavarria Sent: Tuesday, October 6, 2015 10:15 AM To: r-help at r-project.org Subject: [R] help with problem *When i tried to read a table i**n .csv or .txt format R i get the following message and give some problem in orden to run the data o make test, etc* *Warning message* *In read.table(file = file, header = header, sep =";") *>* incomplete final line found by readTableHeader on 'test.csv* *I tried Uninstall R and Excel, and install again but the problem doesnt fix.* *Regard* [[alternative HTML version deleted]] ______________________________________________ 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.
It's possible that you have some invisible characters in the last line(s) of the csv file. You can use a text editor as Davis suggested or in Excel delete a bunch of the blank rows after the end of the data rows. If that doesn't work cut-and paste the rows you do want into a fresh spreadsheet. Sarah On Tue, Oct 6, 2015 at 4:59 PM, David L Carlson <dcarlson at tamu.edu> wrote:> You have a warning, not an error. The command ran but there was a problem > with the .csv or .txt file. > > You should have a partial data set in R. Try using the str() function to > see what variables and what rows were read. Adding the fill=TRUE argument > to read.table() will pad incomplete rows with blanks, but you should check > the data to make sure you have what you were expecting. > > Without the data it is impossible to be sure, but you may have an > incomplete line at the end of your data file. Use a text editor to look at > your data so see if the last line is incomplete. > > ------------------------------------- > David L Carlson > Department of Anthropology > Texas A&M University > College Station, TX 77840-4352 > > > > -----Original Message----- > From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Marco > Otoya Chavarria > Sent: Tuesday, October 6, 2015 10:15 AM > To: r-help at r-project.org > Subject: [R] help with problem > > *When i tried to read a table i**n .csv or .txt format R i get the > following message and give some problem in orden to run the data o > make test, etc* > > *Warning message* > > *In read.table(file = file, header = header, sep =";") > *>* incomplete final line found by readTableHeader on 'test.csv* > > *I tried Uninstall R and Excel, and install again but the problem doesnt > fix.* > > *Regard* > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. > > ______________________________________________ > 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. >-- Sarah Hardy, PhD Associate Professor of Mathematics University of Maine Farmington 207-778-7124 Office: Brinkman 100 [[alternative HTML version deleted]]