We list the different values ​​in the vector in R

Question

How can I list the various values ​​in a vector where the values ​​are replicative? I mean, similar to the following SQL statement:

SELECT DISTINCT product_code FROM data 

Answer 1

You mean unique :

 R> x = c(1,1,2,3,4,4,4) R> x [1] 1 1 2 3 4 4 4 R> unique(x) [1] 1 2 3 4 

Answer 2

You can also use the sqldf package in R. Z <-sqldf ('SELECT DISTINCT tablename.columnname FROM tablename')

Answer 3

Try using a duplicate function in conjunction with the negation operator "!".

Example:

 wdups <- rep(1:5,5) wodups <- wdups[which(!duplicated(wdups))] 

Hope this helps.