Re: [R] How to delete duplicate cases?

[Erik Iverson]

Daniel -

First, use order() to arrange the data.frame into an appropriate format.
Then, use duplicated() with the negation operator to get rid of the 
duplicated values.



Daniel Wagner wrote:
Dear R users,
 
I have a dataframe with lot of duplicate cases and I want to delete duplicate ones which have low rank and keep that case which has highest rank.
e.g
 
df1
  cno      rank
1Â  1342Â Â Â  0.23
2Â  1342Â Â Â  0.14
3Â  1342Â Â Â  0.56
4Â Â 2568Â Â Â  0.15
5Â  2568Â Â Â  0.89
 
so I want to keep 3rd and 5th  cases with highest rank (0.56 & 0.89) and delete rest of the duplicate cases.
Could somebody help me?
 
Regards
 
Daniel
Amsterdam
 
 
 
 
 
 
 
 

Send instant messages to your online friends http://uk.messenger.yahoo.com 
	[[alternative HTML version deleted]]



------------------------------------------------------------------------

______________________________________________
R-help@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.

______________________________________________
R-help@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.