擅长:python、mysql、java
<p><strong>A)如果您认为id列中存在重复项</strong></p>
<p>首先,让我们获取您感兴趣的df2的子集</p>
<pre><code>df2_subset = df2[df2['final_odds']>=0]
# Then, eliminate duplicates based on the subset ['id_event','id_indiv']
df2_subset = df2_subset.groupby(['id_event','id_indiv'], as_index=False).nth(0)
</code></pre>
<p>一旦我们有了df2_子集,我们就可以合并了</p>
<pre><code>df3 = df1.merge(df2, on=['id_event','id_indiv'],how='left')
</code></pre>
<p><strong>B)如果您知道id列中没有重复项</strong></p>
<p>你只需一行就可以解决你的问题</p>
<pre><code>df3 = df1.merge(df2[df2['final_odds']>=0], on=['id_event','id_indiv'],how='left')
</code></pre>