[R] delete duplicated from data.frame
Christian Schulz
ozric at web.de
Tue May 18 16:22:30 CEST 2004
Hi,
?unique
unique returns a vector, data frame or array like x * but with duplicate
elements removed *
what i'm doing wrong delete duplicated rows with same MEMEBRNO.
februar <- dmsegment[unique(dmsegment$MEMBERNO),]
This reduce from 197.188 rows to 184.199 but duplicated MEMBERNO didn't left
all what a Primary Key setting in mysql me say and with a fix(februar) could
recognize .
Courious why MEMEBRNO 4,5 ,6 and 11 are left !
dmsegment$MEMBERNO[1:10]
[1] 1 4 5 6 7 9 10 11 16 21
februar$MEMBERNO[1:10]
[1] 1 6 7 9 10 16 21 26 53 72
Using unique with a single vector it works like i expect.
P.S.
i try -duplcated but get not better succes?
Many Thanks,
Christian
More information about the R-help
mailing list