When Second Condition is Met, First Condition Fails: A Pandas DataFrame Filtering Problem

Comparing Values in a Pandas DataFrame Using `diff` and Mapping to an If-Else Statement