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.
__
R-help@r-p
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 mai
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
___
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
4 matches
Mail list logo
