擅长:python、mysql、java
<p>首先可以找到列<code>CorporationName</code>的<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.unique.html" rel="nofollow">^{<cd1>}</a>值,而不是(<code>~</code>)<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.contains.html" rel="nofollow">^{<cd4>}</a>字符串{<cd5>}。然后可以使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.isin.html" rel="nofollow">^{<cd7>}</a>按掩码过滤{<cd6>}:</p>
<pre><code>uni= ownercombo.loc[~ownercombo.CorporationName.str.contains('n/a'), 'Building ID'].unique()
print uni
[1 4]
print ownercombo[~ownercombo['Building ID'].isin(uni)]
Building ID CorporationName IndividualName
3 2 n/a Tim
4 2 n/a Larry
5 2 n/a Paul
6 3 n/a Rachel
</code></pre>