[R] Removing not duplicated rows

Hello R users, I have a problem to delete rows in a table which are not duplicated in order of an id number a short example: x - data.frame(cbind(id=c(1,2,2,2,3,3,4,5,6,6), value=1:10)) x_new - x[which(duplicated(x$id)),] x_new id value 3 2 3 4 2 4 6 3 6 10 610

Re: [R] Removing not duplicated rows

As I understand it, you are trying to subset the data frame to include only rows with a non-unique id. Try this: x - data.frame(cbind(id=c(1,2,2,2,3,3,4,5,6,6), value=1:10)) id.table - table(x$id) x_new - subset(x, id %in% id.table[id.table 1]) Jeremy

Re: [R] Removing not duplicated rows

Sorry, I left out the names() function in the last step. Try this instead: x - data.frame(cbind(id=c(1,2,2,2,3,3,4,5,6,6), value=1:10)) id.table - table(x$id) x_new - subset(x, id %in% names(id.table[id.table 1])) Jeremy __ R-help@r-project.org

Re: [R] Removing not duplicated rows

Thanks a lot, Jeremy! It's working perfectly. With best regards -- View this message in context: http://r.789695.n4.nabble.com/Removing-not-duplicated-rows-tp3436600p3436736.html Sent from the R help mailing list archive at Nabble.com. __