且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

汇总Pandas DataFrame中的列值

更新时间:2022-12-10 12:01:17

这是groupby的工作:

>>> df.groupby(["score", "type"]).sum()
                        count
score    type                
9.397000 advanced  537.331573
9.397995 advanced    9.641728
9.397996 newbie      0.100000
9.399900 expert     19.6541374
>>> df.groupby(["score", "type"], as_index=False).sum()
      score      type       count
0  9.397000  advanced  537.331573
1  9.397995  advanced    9.641728
2  9.397996    newbie    0.100000
3  9.399900    expert   19.654137