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 <[EMAIL PROTECTED]> 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@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@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.
