Message-ID: <AANLkTin7Rta9GdkxG3eWfcSEybvC6EX0Xz0AjecmWXvM@mail.gmail.com>
Date: 2011-03-09T14:45:48Z
From: Sarah Goslee
Subject: Help to eliminate duplicated from data.frame but Special Problem
In-Reply-To: <AANLkTint50rkiKDhCmVtCJJHSNuiQhND1ATgV8RwoBq=@mail.gmail.com>
So you want to look at all rows, not just the index?
Then specify that:
> my.df[!duplicated(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
R will do exactly what you tell it, and only that.
And thank you for including a workable example!
Sarah
On Wed, Mar 9, 2011 at 9:42 AM, gianni lavaredo
<gianni.lavaredo at gmail.com> 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
>
--
Sarah Goslee
http://www.functionaldiversity.org