擅长:python、mysql、java
<p>这是一种方法。如下所示,我建议您使用Boolean而不是<code>float</code>来表示<code>val3</code>,因为这是系列所代表的。在</p>
<pre><code># merge and set index
res = df1.merge(df2, how='left').set_index('index')
# map val2 from df2
res['val3'] = df2.set_index('index')['val2']
# check for equality of val3 and val2
res['val3'] = res['val3'] == res['val2']
print(res)
val1 val2 val3
index
1 str1 abc1 True
2 str2 abc2 True
3 str3 abc3 False
4 str4 abc9 False
5 str5 abc4 True
</code></pre>