python - 如何显示最大速率

Question

我有一个数据，其中包含多年来各国的自杀率，例如，我想显示每年针对年龄范围的最大自杀值。

Country,Year,Age,Suicides
Albania,1987,15-24 years,21
Albania,1987,35-54 years,16
Albania,1987,15-24 years,14
Albania,1987,75+ years,1
Albania,1987,25-34 years,9
Albania,1987,75+ years,1
Albania,1987,35-54 years,6
Albania,1987,25-34 years,4
Albania,1987,55-74 years,1
Albania,1987,5-14 years,0
Albania,1987,55-74 years,0
Albania,1987,5-14 years,0

在 1987 年的阿尔巴尼亚，大多数自杀者的年龄区间是 15-24 岁，我想展示每个国家每年自杀率最高的值。我怎样才能做到这一点

标签： pythonpandas

Answer 1

以下是我将如何去做：

from io import StringIO

s = StringIO('''Country,Year,Age,Suicides
Albania,1987,15-24 years,21 
Albania,1987,35-54 years,16 
Albania,1987,15-24 years,14 
Albania,1987,75+ years,1
Albania,1987,25-34 years,9 
Albania,1987,75+ years,1 
Albania,1987,35-54 years,6 
Albania,1987,25-34 years,4 
Albania,1987,55-74 years,1 
Albania,1987,5-14 years,0 
Albania,1987,55-74 years,0 
Albania,1987,5-14 years,0''')

df = pd.read_csv(s)


df.groupby(['Country', 'Year', 'Age']).Suicides.sum().idxmax()

输出：（“阿尔巴尼亚”，1987，“15-24 岁”）