R help - Sep 2013 - Help about a R command

Hi,

I was trying to get an answer to this issue:

bookRatingData <- read.table(file.choose(),header=TRUE,nrows=1048570)

Warning message:
In read.table(file.choose(), header = TRUE, nrows = 1048570) :
  incomplete final line found by readTableHeader on
'C:\Users\srinivas\Downloads\BX-Book-Ratings (2).xlsx'



I tried opening the data file (BX-Book-Ratings (2).xlsx) and added a new
line and then saved it. However, that didn't fix the incomplete final line
issue. I still have the same problem. Any suggestions?

Thanks,
Srinivas

-- 
Srinivas Sridhara
Westford, MA 01886
Tel: (978) 467-6857

	[[alternative HTML version deleted]]

On 13-09-28 11:18 AM, Srinivas Sridhara wrote:
> Hi,
>
> I was trying to get an answer to this issue:
>
> bookRatingData <- read.table(file.choose(),header=TRUE,nrows=1048570)
>
> Warning message:
> In read.table(file.choose(), header = TRUE, nrows = 1048570) :
>    incomplete final line found by readTableHeader on
> 'C:\Users\srinivas\Downloads\BX-Book-Ratings (2).xlsx'
>
>
>
> I tried opening the data file (BX-Book-Ratings (2).xlsx) and added a new
> line and then saved it. However, that didn't fix the incomplete final
line
> issue. I still have the same problem. Any suggestions?
That's just a warning.  It says that the last line in your file doesn't 
have a line ending (LF, or CR/LF).  On Unix that often signals a 
problem.  On Windows it's pretty common.

Duncan Murdoch
>
> Thanks,
> Srinivas
>