擅长:python、mysql、java
<p>让我们让它变得更简单,只要做<code>merge</code></p>
<pre><code>df2.drop(df2[df2['final_odds'] < 0].index, inplace = True)
m = df1[['id_event','id_indiv']].agg(tuple,1).isin(df1[['id_event','id_indiv']].agg(tuple,1))
df1 = df1[m]
</code></pre>
<p>还有<code>merge</code></p>
<pre><code>df2.drop(df2[df2['final_odds'] < 0].index, inplace = True)
df1 = df1.merge(df2.drop_duplicates(['id_event','id_indiv']),how='right')
</code></pre>