擅长:python、mysql、java
<p>下面是一个与SQL(Oracle)减号操作等效的pandas:</p>
<pre><code>select col1, col2 from tab1
minus
select col1, col2 from tab2
</code></pre>
<p>熊猫:</p>
^{pr2}$
<p>说明:</p>
<pre><code>In [60]: pd.DataFrame(df2.values, columns=df1.columns)
Out[60]:
col_a col_b
0 1397 foo
1 1500 foo
2 1621 foo
In [61]: pd.DataFrame(df2.values, columns=df1.columns).to_dict('l')
Out[61]: {'col_a': [1397, 1500, 1621], 'col_b': ['foo', 'foo', 'foo']}
In [62]: df1.isin(pd.DataFrame(df2.values, columns=df1.columns).to_dict('l'))
Out[62]:
col_a col_b
0 False True
1 True True
2 False True
In [63]: df1.isin(pd.DataFrame(df2.values, columns=df1.columns).to_dict('l')).all(1)
Out[63]:
0 False
1 True
2 False
dtype: bool
</code></pre>