擅长:python、mysql、java
<p>您可以通过翻转列名,用<code>pd.concat()</code>复制df2。可以通过使用<code>rename</code>设置它们来完成此操作</p>
<pre><code>df3 = df2.rename(columns={'Team 1':'Team 2','Team 2':'Team 1',
'Team1_Avg':'Team2_Avg','Team2_Avg':'Team1_Avg'})
</code></pre>
<p>现在我们可以对df2和新创建的<code>merge</code>和{<cd4>}执行左<code>df3</code></p>
^{pr2}$
<p>给你想要的数据帧</p>
<pre><code> Team 1 Team 2 Team1_Score Team2_score Team1_Avg Team2_Avg
0 A B 25 56 5.0 15.0
1 B C 30 55 35.0 15.0
2 D E 25 75 NaN NaN
</code></pre>