Deleting rows based on duplicate entries in one columns in a data matrix

Hi everybody,

I would like to delete rows based on duplicate entries in column 3 in the
data matrix X (size 60000 x 57). I have tried the unique(x) command as
data <- X[unique(X[,3]),]
however, for some reason the command introduces a lot of NA's into the
dataset. 
So, now I'm looking for a function that eliminates rows, if they have
duplicate values in column 3.

Does anyone have an idea how to do this?

Cheers and thanks a lot for the help,
Fran
View this message in context: http://n4.nabble.com/Deleting-rows-based-on-duplicate-entries-in-one-columns-in-a-data-matrix-tp1018110p1018110.html
Sent from the R help mailing list archive at Nabble.com.
Use duplicated indeed of unique.
Hi everybody,

I would like to delete rows based on duplicate entries in column 3 in the
data matrix X (size 60000 x 57). I have tried the unique(x) command as

data <- X[unique(X[,3]),]
however, for some reason the command introduces a lot of NA's into the
dataset.
So, now I'm looking for a function that eliminates rows, if they have
duplicate values in column 3.

Does anyone have an idea how to do this?

Cheers and thanks a lot for the help,
Fran
--
View this message in context: http://n4.nabble.com/Deleting-rows-based-on-duplicate-entries-in-one-columns-in-a-data-matrix-tp1018110p1018110.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
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.

Henrique Dallazuanna
Curitiba-Paran?-Brasil
25? 25' 40" S 49? 16' 22" O
See:

?duplicated
Hi everybody,

I would like to delete rows based on duplicate entries in column 3 in the
data matrix X (size 60000 x 57). I have tried the unique(x) command as

data <- X[unique(X[,3]),]
however, for some reason the command introduces a lot of NA's into the
dataset.
So, now I'm looking for a function that eliminates rows, if they have
duplicate values in column 3.

Does anyone have an idea how to do this?

Cheers and thanks a lot for the help,
Fran
--
View this message in context: http://n4.nabble.com/Deleting-rows-based-on-duplicate-entries-in-one-columns-in-a-data-matrix-tp1018110p1018110.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
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.

Thanks for the swift replies.

I have found this to work for my purpose:

data <- subset(X, !duplicated(X[,3])
View this message in context: http://n4.nabble.com/Deleting-rows-based-on-duplicate-entries-in-one-columns-in-a-data-matrix-tp1018110p1018126.html
Sent from the R help mailing list archive at Nabble.com.