[R] duplicate row.names are not allowed

From: <stephenc_at_ics.mq.edu.au>
Date: Fri, 7 Dec 2007 17:24:05 +1100 (EST)


I am using read.table and keep on getting this message.

The function is confusing my first column with a row.names column. I have checked the table carefully using excel and it seems quite symetric and with a name at the top of each column.

This is what I am using:

form1 = read.table("c:/horses/form.tbl", sep="\t", header = T)

and this is the top few rows of the table:

fields.result	fields.age	fields.sex	fields.barrier	horse.winnings	
horse.form.ran	horse.form.win	horse.form.place	horse.form.at.this.track.ran	horse.form.at.this.track.win	horse.form.at.this.track.place	horse.form.at.this.distance.ran	horse.form.at.this.distance.win	horse.form.at.this.distance.place	horse.form.with.this.jockey.ran	horse.form.with.this.jockey.win	horse.form.with.this.jockey.place	horse.form.with.this.going.ran	horse.form.with.this.going.win	horse.form.with.this.going.place	rider.rides.last.3	rider.places.last.3	trainer.rides.last.3	trainer.places.last.3
4	4	G	3	50	5	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	36	0.166666667
2	5	G	5	3250	9	0	0.333333333	0	0	0	0	0	0	5	0	0.4	3	0	0.333333333	35	0.114285714	7	0.285714286
3	4	M	4	2075	11	0	0.090909091	0	0	0	0	0	0	0	0	0	1	0	0	0	0	13	0.307692308
5	5	M	2	0	2	0	0	0	0	0	0	0	0	1	0	0	1	0	0	54	0.185185185	2	0
1	4	M	7	1800	4	0	0.5	0	0	0	0	0	0	0	0	0	2	0	0	0	0	90	0.366666667

Can anyone suggest whats wrong or a workaround.

Thanks

Stephen



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 Fri 07 Dec 2007 - 06:30:50 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 Fri 07 Dec 2007 - 08:30:17 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.