擅长:python、mysql、java
<p>一种方法是使用字典映射,然后使用列表理解:</p>
<pre><code>cols = ['Amount_2', 'Amount_3', 'Total_Amount']
d = {k: set(v.values()) for k, v in \
df2.set_index('Cntr_No')[cols].to_dict(orient='index').items()}
df1['Check'] = [j in d.get(i, set()) for i, j in zip(df1['Cntr_No'], df1['Total_Amount'])]
df1['Check'] = df1['Check'].map({True: 'Match', False: 'No'})
</code></pre>
<p>结果:</p>
^{pr2}$