[R] missing values in document

From: Monna Nygård <monnire_at_hotmail.com>
Date: Wed, 30 Apr 2008 13:51:16 +0300

No matter how I´ve tried o find a solution for this simple question, I can´t. Sorry for bothering with such a matter.  

I have an excel-files with some empty cells=missing values. How do I tell R that these should be NA´s?  

> TRFLP1 <-(read.table(file="S://SEDIM//Kokeilu//TRFLP1.txt",col.names= c("Dye_Sample Peak", "Sample_File_Name", "Size", "Height", "Area_in_Point", "Area_in_BP", "Data_Point", "Begin_Point", "Begin_BP", "End_Point", "End_BP", "Width_in_Point", "Width_in_BP", "1" ), header=F , dec = ",", )Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : line 1743 did not have 14 elements

I believe the error occurs becouse line 1743 has an empty cell. How do I read in the file without first checking for missing values and changing them to NAs myself?  

Thank you for you time,  

Monna Nygård

        [[alternative HTML version deleted]]

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. Received on Wed 30 Apr 2008 - 11:31:22 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 30 Apr 2008 - 13:30:33 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive