Re: [R] "unique" rows in data frame

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Tue, 2 Oct 2007 18:12:01 -0400

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



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. Received on Tue 02 Oct 2007 - 22:16:05 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 02 Oct 2007 - 22:35:54 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.