Re: [R] (no subject)

From: Charilaos Skiadas <>
Date: Mon, 10 Mar 2008 08:00:39 -0400

If you have an original file in excel, the way I get such files is to save them as csv (comma-separated), and then to use read.csv. Then these empty spots are more easily handled, since they correspond to too successive commas.

Haris Skiadas
Department of Mathematics and Computer Science Hanover College

On Mar 10, 2008, at 7:26 AM, Alfons Sutter wrote:

> Thank you! I have the origenal file in MS-Excel, I save the excel
> file in a txt file. In the excel file there are missing value empty
> places for these missing value? Do I need to replace the empty
> places in a symbol for missing value and could you tell me place
> how can I avoid this warning message?
> Thank you in advance!
> ----- Original Message ----
> From: Duncan Murdoch <>
> To: Alfons Sutter <>
> Cc:
> Sent: Monday, March 10, 2008 12:18:11 PM
> Subject: Re: [R] (no subject)
> On 10/03/2008 6:50 AM, Alfons Sutter wrote:
>> Hi all,
>> I am trying to read a text file in R! I have a warning message:
>> In read.table(file = "data1.txt", header = T) : uncompleted last
>> line of readTableHeader in 'data1.txt'
> R is warning you that the file may be incomplete. In Unix, text files
> are supposed to always end with a newline. Windows programs often
> omit
> it on the last line. So on Unix, R is probably right to warn you, but
> it could well be a false positive if you're on Windows.
>> Could you please tell me why? and how can I deal with missing
>> value when I read this file?
> How you deal with missing values really depends on what you want to do
> with the data. There's no general answer.
> Duncan Murdoch
> mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Mon 10 Mar 2008 - 12:30:42 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 Mon 10 Mar 2008 - 14:30:20 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive