Re: [R] Unique.data.frame...still getting duplicates

About this list Date view Thread view Subject view Author view Attachment view

From: Alec Stephenson (astephen@efs.mq.edu.au)
Date: Fri 25 Jun 2004 - 12:45:26 EST 

Message-id: <s0dc1e88.043@efs04.efs.mq.edu.au>

data[!duplicated(data$ID),]
will do. Your unique(data[ID,]) removes duplicated rows in data[ID,],
assuming the object ID exists.

Alec Stephenson
Department of Statistics
Macquarie University
NSW 2109, Australia

>>> "F Z" <gerifalte28@hotmail.com> 06/25/04 12:12pm >>>
Hi there

I have a data frame with about 65,000 rows and 8 variables. I am
trying to
get rid of the double entries of a factor variable "ID" so I can get a

unique observation for each ID

I tried:

>dupl_unique.data.frame(data[ID,]) #I obtain a data frame with 21,547
>observations..so far so good, but then when I check for duplicates

>d_duplicated(dupl2$ID)
>summary(as.factor(d))
FALSE TRUE
  6836 14711

Meaning that I am still getting 14,711 duplicates!

I tried changing the ID type to integer and repeated the process but I
got
dentical results....what am I missing?

Thanks!

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Wed 30 Jun 2004 - 23:05:10 EST