If this is my dataset
Id Weight Category
1 10.2 Pre
1 12.1 Post
2 11.3 Post
3 12.9 Pre
4 10.3 Post
4 12.3 Pre
5 11.8 Pre
How Do I get rid of duplicate IDs that are also Category=Pre. My final expected dataset would be
Id Weight Category
1 12.1 Post
2 11.3 Post
3 12.9 Pre
4 10.3 Post
5 11.8 Pre