Code: Select all
name type count
robert x 123
robert y 456
robert z 5123
charlie x 442123
charlie y 0
charlie z 42
Code: Select all
name type count
robert z 5123
charlie x 442123
Code: Select all
df.sort_values('count', ascending=False).drop_duplicates('name').sort_index()