[R] Removing all duplicate row except by one

Rolf Turner rolf.turner at xtra.co.nz
Fri Aug 12 00:39:35 CEST 2011


On 12/08/11 07:37, m.marcinmichal wrote:
> Hi,
> It's my problem, supppose that we have a data.frame:
>
> t
>    a b c
> 1 1 1 1
> 2 0 1 1
> 3 1 1 1
> 4 0 0 0
> 5 1 0 1
> 6 0 1 0
> 7 1 1 1
> 8 0 1 0
>
> I need extract duplicat row i.e i nedd frame like this
>
>    a b c
> 3 1 1 1
> 8 0 1 0
>
> I try use subset(t, duplicated(t)) and t[duplicated(t), ] but this command
> return
>
>    a b c
> 3 1 1 1
> 7 1 1 1
> 8 0 1 0

unique(t[duplicated(t),])

BTW "t" is not a good name for an object since it is the name of a
base function in R (the transpose function).

     cheers,

         Rolf Turner



More information about the R-help mailing list