python - 查询最大值

Question

如何查询各部门工资最高的职位：

Employment    Salary    Department
Alex          10000       Sales
Joe           20000       Sales 
Chris         30000       Mar
Tony          40000       Mar

期望的输出

Employment    Salary     Department
Joe           20000        Sales
Tony          40000        Mar

标签： pythonpandas

Answer 1

您可以先按部门分组，然后申请.max()：

print(df.groupby(['Department'], as_index=False).max())