2020-05-01
阅读量:
781
计算每个员工销售额最大的前两单的总和，题目详情见正文
df表详情如下：
要求计算所有人单笔销售额最大的两单的加和值
参考代码：
np.random.seed(0)
df = pd.DataFrame(
{'name': ["Allen","Tom","Alice","Lucy","Han","Allen","Tom","Alice","Lucy","Han","Allen","Tom","Alice","Lucy","Han"],
'sale': np.random.randint(10,100,15)})
df.index = range(1,16)
df
df1 = df.groupby('name')['sale'].nlargest(2).sum(level=0)
df1代码结果：
87.9753
1
2
关注作者
收藏
评论(0)
发表评论
暂无数据
推荐帖子
anranhui
2020-06-18
2条评论
PhilipLiang
2020-06-18
6条评论
PhilipLiang
2020-06-18
7条评论