I want to remove all duplicate rows in my data set whose have the same value in in columns 1,4,5 of my data set. I did the following :
cols <- c(col1,col4,col5)
NonJointTrip<-CLEANED[!duplicated(CLEANED[cols]) | duplicated(CLEANED[cols], fromLast = TRUE), ]
my problem is that this code keep one of rows and delete the others one. I need a code which don't keep even one row. here is an example
col1 col2 col3 col4 col5
1 2 3 4 5
1 3 5 4 5
3 2 1 7 8
the first and lsecond rows have the same value in col1,col4,col5, the above code remove one of them and gives me
col1 col2 col3 col4 col5
1 2 3 4 5
3 2 1 7 8
But I want both rows to be deleted and give me:
col1 col2 col3 col4 col5
3 2 1 7 8