擅长:python、mysql、java
<p>您可以在每个数据帧中生成一个虚拟列,使用pd合并()右联接数据帧,然后使用掩码筛选空值。在</p>
<pre><code>In [1]: dfa = pd.DataFrame({'A': range(4, 8)})
In [2]: dfb = pd.DataFrame({'A': range(6, 10)})
In [3]: dfa['ones'] = 1
In [4]: dfb['ones'] = 1
In [5]: dfa
Out[5]:
A ones
0 4 1
1 5 1
2 6 1
3 7 1
In [6]: dfb
Out[6]:
A ones
0 6 1
1 7 1
2 8 1
3 9 1
In [7]: df = pd.merge(dfa, dfb, on = 'A', how = 'right')
In [8]: df
Out[8]:
A ones_x ones_y
0 6 1 1
1 7 1 1
2 8 NaN 1
3 9 NaN 1
In [8]: df[df.ones_x.notnull()][['A']]
Out[8]:
A
0 6
1 7
</code></pre>