[R] Find backward duplicates in a data frame

arun smartpink111 at yahoo.com
Sat Nov 16 00:08:39 CET 2013


Hi,May be:

fun1 <- function(dat){
indx <- apply(dat,1,function(x) {
        any(x==sort(x))| !any(as.character(interaction(dat,sep="")) %in% paste(sort(x),collapse=""))
        })
dat[indx,]
}

test1 <- rbind(test,data.frame(a="F",u="E"))
fun1(test)
fun1(test1)




A.K.




On Friday, November 15, 2013 4:58 PM, Hermann Norpois <hnorpois at gmail.com> wrote:
Hello,

I am looking for a method to eliminate rows dupblicates in a backwards
manner, for instance:
I want to keep A B but not B A (see my data.frame test).
Thanks
Hermann

> test
  a u
1 A B
2 A C
3 B A
4 B F
5 C A
6 D W
> dput (test)
structure(list(a = structure(c(1L, 1L, 2L, 2L, 3L, 4L), .Label = c("A",
"B", "C", "D"), class = "factor"), u = structure(c(2L, 3L, 1L,
4L, 1L, 5L), .Label = c("A", "B", "C", "F", "W"), class = "factor")),
.Names = c("a",
"u"), row.names = c(NA, -6L), class = "data.frame")

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