[R] Error when naming rows of dataset

[Prof Brian Ripley]

On Wed, 25 Oct 2006, yongchuan wrote:

> I'm pretty new with R, so the only error message I see is
> the below that I pasted.

Which you misread: did you not notice it ended with a comma?

> I'm attaching the first few rows of the file for reference. The layout 
> looks screwy when I attach it here but 'Start' to 'closingCoupon' is the 
> first row in the .txt file. Thx!
>
> 	Start	Stop	PrepayDate	modBalance	closingCoupon
> 1.1	6	7	0	811.2769	8.35
> 1.2	7	8	0	811.2769	8.35
> 1.3	8	9	1	811.2769	8.35
> 2.1	4	5	0	2226.0825	8.7
> 2.2	5	6	0	2226.0825	8.7
> 2.3	6	7	0	2226.0825	8.7
> 2.4	7	8	0	2226.0825	8.7
> 2.5	8	9	0	2226.0825	8.7
> 2.6	9	10	0	2226.0825	8.7
> 2.7	10	11	0	2226.0825	8.7
> 2.8	11	12	0	2226.0825	8.7
> 2.9	12	13	0	2226.0825	8.7
> 2.1	13	14	0	2226.0825	8.7

There are two rows named '2.1' there, so your problem is already evident.
Row names must be unique, as it says in ?data.frame and in many other 
places in the R documentation.

>> From: Michael Dewey <info at aghmed.fsnet.co.uk>
>> Date: Wed 25/10/2006 6:38 PM SGT
>> To: yongchuan <panyc at pacific.net.sg>, <r-help at stat.math.ethz.ch>
>> Subject: Re: [R] Error when naming rows of dataset
>>
>> At 17:30 24/10/2006, yongchuan wrote:
>>> I get the following error when I try reading in a table.
>>> How are 1.1, 1.2, 1.3 duplicate row names? Thx.
>>
>> R gives you brief details of where it was when it fell over.
>> Have you checked in latestWithNumber.txt' to see whether R is right?
>>
>>
>>>> table <- read.table('latestWithNumber.txt', header=T)
>>> Error in "row.names<-.data.frame"(`*tmp*`, value = c("1.1", "1.2", "1.3",  :
>>>         duplicate 'row.names' are not allowed
>>>
>>> Yongchuan
>>
>> Michael Dewey
>> http://www.aghmed.fsnet.co.uk

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595