擅长:python、mysql、java
<p>您想要的数据结构必须有重复的条目(排列与组合),因此首先要将数据帧加倍,同时反转团队的方向。然后只需按两个团队列分组并计算对:</p>
<pre><code>pd.concat([scores, scores.rename(columns={"Team_1": "Team_2", "Team_2": "Team_1"})])
[['Team_1', 'Team_2', 'date']]
.groupby(["Team_1", "Team_2"])
.count()
date
Team_1 Team_2
Australia Pakistan 1
Bangladesh India 2
SriLanka 2
India Bangladesh 2
SriLanka 3
Pakistan Australia 1
SriLanka Bangladesh 2
India 3
</code></pre>