Remove row in Pandas while leaving other entries with the same value

I have tried to drop rows. I have attempted if else loops. However, the following may be overly complicated to succeed.

For a given date, time and reference, when cancel is selected, the first 'No' should be dropped. The remaining 'Cancel' and 'No' entries should remain untouched.

I am hoping to get the following.