擅长:python、mysql、java
<p>另一种解决方案:</p>
<pre><code>df2=df2.merge(df1,on=['HomeTeam','AwayTeam'],how='left')
df2['SELECTION']=df2.groupby('EVENT_ID').apply(lambda x : x.SELECTION.replace({x.HomeTeam.values[0]:'Home',x.AwayTeam.values[0]:'Away'})).values
df2.set_index(['HomeTeam','AwayTeam','Date','SELECTION']).ODDS.unstack().reset_index()
Out[1151]:
SELECTION HomeTeam AwayTeam Date Away Home TheDraw
0 CeltaVigo Valencia 06/01/14 2.43 3.30 3.55
1 RealMadrid CeltaVigo 06/01/14 47.50 1.13 16.00
</code></pre>