Re: [R] missing values in document

2008-04-30 Thread jim holtman
How are the 'empty' cell identified? It appears that you are using the default of read.table which says blanks are the delimiters. How are two or more empty cells identified? Can you output a CSV file so that you have commas as separators so you can identify the empty fields? On Wed, Apr 30, 20

Re: [R] missing values in document

2008-04-30 Thread Jim Lemon
Monna Nygård wrote: 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//T

Re: [R] missing values in document

2008-04-30 Thread S Ellison
What exactly is on line 1743? Genuinely empty cells will probably read as NA anyway. Excel errors, prefixed # in excel, will be read as comment markers and cause the remainder of the line to be ignored. This often causes this kind of error. Steve E >>> Monna Nygård <[EMAIL PROTECTED]> 30/04/20

[R] missing values in document

2008-04-30 Thread Monna Nygård
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.name