[R] subsetting a data.frame to the 'unique' of a column

Rudi Alberts r.alberts at rug.nl
Thu Dec 23 20:28:31 CET 2004


Hi,

I often run into this problem:
I have a data.frame with one column containing entries that are not
unique. What I then want is a subset of the data.frame in which
the entries in that column have become the 'unique' of the original
column. 
Normally I program around it by taking the unique of the column and
making a new data.frame with it and filling the rest of the data.

(By the way, when moving to the smaller data.frame for example 5 rows
with the same value in that column will be replaced by one row for that
value. I don't mind which of the rows now..)


something like this, however, this gives me the complete df.

df[df$colname %in% unique(df$colname),]

or this, which doesnt work

df[df$colname == unique(df$colname),]


regards, R. Alberts




More information about the R-help mailing list