Remove duplicates based on multiple criteria
You can use sort_values with key = lambda x: x != '' to order the rows by whether the verified column has a value. Then giving the parameter keep = 'first' to df.duplicated will keep a row with a nonempty value, if any exist.
Remove duplicates based on multiple criteriaRemove duplicates based on multiple criteria