using !duplicated() on multiple columns

Asked Dec 12 '17 at 21:13

Active Dec 12 '17 at 21:37

Viewed 26 times

I am using the duplicated() function in R to find samples with duplicate entries in 3 columns

df <- data.frame(ID = c("1","2","3"), Lastname = c("Brown", "Wright", "Brown"), Firstname = c("Bob", "Jo", "Bob"), DOB = c("10/10/1970", "08/08/1980","10/10/1970"))

I want to get entries where Lastname, Firstname and DOB match or are duplicate

test <- df[duplicated(df[c('Lastname', 'Firstname', 'DOB')]),]

I am only returning one duplicate not both duplicates

ID  Lastname    Firstname   DOB
3   Brown   Bob 10/10/70

I want to return ALL entries that are duplicated I would expect

ID  Lastname    Firstname   DOB
1   Brown   Bob 10/10/70
3   Brown   Bob 10/10/70

edited Dec 12 '17 at 21:37

Frank

66,179
8
96
180

asked Dec 12 '17 at 21:13

N Wright

1

You want only ID 3 not ID 1? You can try `duplicated(..., fromLast = TRUE)` perhaps. – Frank Dec 12 '17 at 21:16
I want ID 1 and 3 removing 2 – N Wright Dec 12 '17 at 21:23
Ok, then the idiom is (strangely) two duplicated calls as covered in the link. – Frank Dec 12 '17 at 21:30
1

I have edited the post, to reflect what I want to return. – N Wright Dec 12 '17 at 21:36
read the post that this was marked duplicate of. – Matt W. Dec 12 '17 at 21:46

using !duplicated() on multiple columns

0 Answers0