Hi Gianni,
From the example it seems like you want to check if value1 is
duplicated, not Id:
> my.df[!duplicated(my.df$value1),]
You can also remove duplicated rows based on the values of more than one
column:
> my.df[!duplicated(my.df[,c("Id","value1")]),]
Does any of these do what you want?
Cheers,
Jon
On 3/9/2011 3:42 PM, gianni lavaredo wrote:
Dear Reseacher,
i need to resolve the following problem. I wish to delete duplicate row from
a data.frame but not all duplicate row:
ex:
my.df<- data.frame(Id=c(1,2,3,4,5,5,6,7,8,8,8,9),
value1=c(10,20,30,40,50,50,60,70,80,80,81,90),
value2=c(100,200,300,400,500,500,600,700,800,800,799,900))
my.df
Id value1 value2
1 1 10 100
2 2 20 200
3 3 30 300
4 4 40 400
5 5 50 500
6 5 50 500
7 6 60 600
8 7 70 700
9 8 80 800
10 8 80 800
11 8 81 799
12 9 90 900
eliminate
my.df
Id value1 value2
1 1 10 100
2 2 20 200
3 3 30 300
4 4 40 400
5 5 50 500
7 6 60 600
8 7 70 700
9 8 80 800
11 8 81 799
12 9 90 900
but if I use
xx<- my.df[!duplicated( my.df$Id), ]
my result is
xx
Id value1 value2
1 1 10 100
2 2 20 200
3 3 30 300
4 4 40 400
5 5 50 500
7 6 60 600
8 7 70 700
9 8 80 800
12 9 90 900
thanks in advance
Gianni
[[alternative HTML version deleted]]
_______________________________________________
R-sig-Geo mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-geo
_______________________________________________
R-sig-Geo mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-geo
