擅长:python、mysql、java
<p>我想你需要<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.isin.html" rel="nofollow noreferrer">^{<cd1>}</a>用<code>~</code>倒过来的条件:</p>
<pre><code>salesdf[~salesdf['Document type'].isin(['AVC', 'CC','CDI', 'BSX','BTR','FAF'])]
</code></pre>
<p><strong>样本</strong>:</p>
<pre><code>salesdf = pd.DataFrame({
'Document type': ['AVC','CDI','CC','a','b','FAF','BTR','c','BSX']
})
print (salesdf)
Document type
0 AVC
1 CDI
2 CC
3 a
4 b
5 FAF
6 BTR
7 c
8 BSX
a = salesdf.loc[(salesdf['Document type'] != 'AVC') &
(salesdf['Document type'] != 'CC') &
(salesdf['Document type'] != 'CDI') &
(salesdf['Document type'] != 'BSX') &
(salesdf['Document type'] != 'BTR') &
(salesdf['Document type'] != 'FAF')]
print (a)
Document type
3 a
4 b
7 c
b = salesdf[~salesdf['Document type'].isin(['AVC', 'CC','CDI', 'BSX','BTR','FAF'])]
print (b)
Document type
3 a
4 b
7 c
</code></pre>