Please use the original dput structure I posted for this following question:
The first column where you see GO-2019770786 is the event_unique_id, although it says unique I see duplicates. I understand that one event can have multiple offences i,e, MCI categories in the dataset and those will not be duplicates. However, I found the duplicate event ids with the same MCI for some records. In this case, how would I drop the duplicates.
I am not sure how to proceed here.