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@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.
