There is most probably a function doing exactly this, but i would give
this solution a try:
dataframe=dataframe[order(dataframe[,1],-dataframe[,2]),]
kept.rows<-which(diff(dataframe[,1])+1
new.dataframe <- dataframe[kept.rows,]
D?vav?nyai Agamemn?n schrieb:> Sorry!
> I try it again
>
> Dear R Users!
>
>
> I have a dataframe with duplicatecases. Var1 duplicated by var2.
>
>
>
> var1 var2 var3 var4 var5
> 1 4 500 1 2
> 1 3 200 2 5
> 1 8 125 1 9
> 2 2 120 2 52
> 2 6 22 1 20
> 2 9 400 1 22
> 3 1 100 2 8
> 3 2 200 5 40
> 4 8 20 1 60
>
> I want to delete duplicate ones from var1 which have low rank at var2, and
keep that case which has highest rank at var2. I would like to keep the Whole
row (with the other variables:
>
> var1 var2 var3 var4 var5
> 1 8 125 1 9
> 2 9 400 1 22
> 3 2 200 50 40
> 4 8 200 1 60 Thanks Ag
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>
>