[R] "unique" rows in data frame

Gabor Grothendieck ggrothendieck at gmail.com
Wed Oct 3 00:12:01 CEST 2007


Try this:

> DF[!duplicated(DF$x1), ]
  x1 x2
1  A  1
2  B  2
> # or
> subset(DF, !duplicated(x1))
  x1 x2
1  A  1
2  B  2


On 10/2/07, Dieter Best <dieterbest_2000 at yahoo.com> wrote:
> Hello there,
>
>  I have a data frame a small version of which could look like the following:
>
>    x1 x2
> 1  A  1
> 2  B  2
> 3  B  3
>
>  Now I need to remove rows which are duplicate in x1, i.e. in the example above I would remove row 3.
>
>  I have an ugly solution with for and while loops and ifs. ... And of course my data set is much larger and my solution takes along time.
>
>  Any ideas what could be the best way to do this in R?
>
>  Better yet: I actually would like to sort of collapse row 2 and 3 in the example above by replacing 2 and 3 with a new row 2 which has in x2 the mean of old x2 of row 2 and 3 (maybe this is poorly said).
>
>  Anyways, thanks a lot in advance for suggestions.
>
>  -- D
>
>
>
> ---------------------------------
>
>        [[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.
>



More information about the R-help mailing list