擅长:python、mysql、java
<p>我认为使用<code>isin</code>这很简单:</p>
<pre><code>In [504]: df2['Check'] = ((df1.Cntr_No.isin(df2.Cntr_No))&((df1.Total_Amount.isin(df2.Amount_2))|(df1.Total_Amount.isin(df2.Amount_3))|(df1.Total_Amount.isin(df2.Total_Amount)))).map({True:'Match',False:'No'})
In [505]: df2
Out[505]:
Amount_2 Amount_3 Cntr_No Total_Amount Check
0 40 100 HLBU 1234567 50 Match
</code></pre>