擅长:python、mysql、java
<p>因为需要<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.pivot_table.html" rel="nofollow noreferrer">^{<cd1>}</a>,最简单的解决方案是:</p>
<pre><code>df = df.pivot_table(index='Team',aggfunc='sum')
print (df)
Goals RedCards YellowCards
Team
Team1 5 1 2
Team2 2 1 2
</code></pre>
<p>像聚合一样工作<code>sum</code>:</p>
<pre><code>df = df.groupby('Team').sum()
</code></pre>
<p>编辑:如果需要,请指定列:</p>
<pre><code>df = df.pivot_table(index='Team',aggfunc='sum',values=['Goals','RedCards','YellowCards'])
print (df)
Goals RedCards YellowCards
Team
Team1 5 1 2
Team2 2 1 2
</code></pre>
<p>工作方式如下:</p>
<pre><code>df = df.groupby('Team')[['Goals','RedCards','YellowCards']].sum()
</code></pre>