<p>设置-</p>
<pre><code>df1
Team 1 Team 2 Team1_Score Team2_Score
Index
0 A B 25 56
1 B C 30 55
2 D E 35 75
df2
Team 1 Team 2 Team1_Avg Team2_Avg
Index
0 A B 5 15
1 F G 25 10
2 B C 35 15
</code></pre>
<p>首先,我们需要对<code>Team *</code>列进行排序,并相应地以相同的方式对<code>Team*_Score</code>列进行排序。我们将使用<code>argsort</code>来执行此操作。在</p>
^{pr2}$
<p>现在,对<code>df2</code>重复相同的过程,使用<code>Team *</code>和{<cd6>}。在</p>
<pre><code>j = np.argsort(df2[['Team 1', 'Team 2']], axis=1).values
df2[['Team 1', 'Team 2']] = df2[['Team 1', 'Team 2']].values[i, j]
df2[['Team1_Avg', 'Team2_Avg']] = df2[['Team1_Avg', 'Team2_Avg']].values[i, j]
</code></pre>
<p>现在,执行左外<code>merge</code>-</p>
<pre><code>df1.merge(df2, on=['Team 1', 'Team 2'], how='left')
Team 1 Team 2 Team1_Score Team2_Score Team1_Avg Team2_Avg
0 A B 25 56 5 15
1 B C 30 55 35 15
2 D E 35 75
</code></pre>