我有一个熊猫数据框
import pandas as pd
country = ['US','US','UK','Canada',"Mexico"]
rating = [0,2,1,4,3,1]
count = [1,1]
df = pd.DataFrame(list(zip(country,rating,count)),columns =['country','rating','count'])
导致以下数据框
country rating count
0 US 0 1
1 US 2 2
2 US 1 3
3 UK 4 1
4 UK 3 2
5 Canada 1 1
6 Canada 0 2
7 Mexico 1 1
我想要做的是按第一列值分组,并为各个组找到第二列和第三列的最大值。所以输出数据帧如下:
country rating count
0 US 2 3
1 UK 4 2
2 Canada 1 2
3 Mexico 1 1