擅长:python、mysql、java
<p>我添加了列总数和总计</p>
<pre><code>data=[('Team1','Player1', 2, 1, 1),
('Team1','Player2', 3, 1, 0),
('Team2','Player3', 2, 2, 1)]
df=pd.DataFrame(data=data,columns=['Team','Player','Goals', 'YellowCards','RedCards'])
fp=df.pivot_table(index='Team',aggfunc='sum')
fp['Totals'] = fp.sum(axis='columns')
fp.loc[('Grand Total'), :] = fp.sum()
print(fp)
</code></pre>
<p>输出</p>
<pre><code> Goals RedCards YellowCards Totals
Team
Team1 5.0 1.0 2.0 8.0
Team2 2.0 1.0 2.0 5.0
Grand Total 7.0 2.0 4.0 13.0
</code></pre>