如何在pandas中使用groupby计算绝对值之和?
例如,给定以下DataFrame:
Player Score
0 A 100
1 B -150
2 A -110
3 B 180
4 B 125
我想要得到选手A的总分数(100+110=210),以及忽略分数符号后,选手B的总分数(150+180+125=455)。
我可以使用以下代码来计算总和:
import pandas as pd
import numpy as np
frame = pd.DataFrame({'Player' : ['A', 'B', 'A', 'B', 'B'],
'Score' : [100, -150, -110, 180, 125]})
print('frame: {0}'.format(frame))
total_scores = frame[['Player','Score']].groupby(['Player']).agg(['sum'])
print('total_scores: {0}'.format(total_scores))
但是我怎么能用groupby计算绝对值之和呢?
frame[['Player','Score']].abs().groupby(['Player']).agg(['sum'])
不出所料地返回:
Traceback (most recent call last):
File "O:\tests\absolute_count.py", line 10, in <module>
total_scores = frame[['Player','Score']].abs().groupby(['Player']).agg(['sum'])
File "C:\Users\dernoncourt\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\core\generic.py", line 5518, in abs
return np.abs(self)
TypeError: bad operand type for abs(): 'str'
我不想修改DataFrame。