dbs = db[‘prescription_name’] db[db[‘prescription_name’].isin(dbs.drop_duplicates(keep=‘first’).append(dbs.drop_duplicates(keep=False)).drop_duplicates(keep=False))].sort_values(by=‘prescription_name’,ascending= False)