Home/ Questions/Q 1897
Next
In Process
dishach
  • 0
Explainer
Asked: 2023-07-05T09:32:48+00:00 In:

Display highest values from duplicates in Pandas dataframe.

  • 0

I have a dataframe as given below, I want to display only the rows with highest values on comparing with its duplicate city.

City ID Value
Denmark 1 11
Amsterdam 1 16
Canada 1 17
New York 1 23
Bulgaria 1 14
Bulgaria 1 20

Output:

City ID Value
Denmark 1 11
Amsterdam 1 16
Canada 1 17
New York 1 23
Bulgaria 1 20
pandasprogramspython
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. Explainer

    By dropping the duplicate values and sorting it on descending order:

    df = df.sort_values(by=['Value'], ascending=False).drop_duplicates(['City', 'ID'], keep='first')

    Output:

            City  ID  Value
3   New York   1  23
5   Bulgaria   1  20
2     Canada   1  17
1  Amsterdam   1  16
0    Denmark   1  11

     

    • 0