擅长:python、mysql、java
<p>我认为您需要具有位<code>AND</code>(<code>&</code>)和<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.notna.html" rel="nofollow noreferrer">^{<cd3>}</a>和<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.duplicated.html" rel="nofollow noreferrer">^{<cd4>}</a>的链2掩码:</p>
<pre><code>m1 = df['Vehicle'].notna()
m2 = ~df['Name'].duplicated()
df1 = df[m1 & m2]
print (df1)
Name Vehicle
0 Dave Car
1 Mark Bike
2 Steve Car
</code></pre>
<p>如果要分别执行这些操作-首先删除所有nan行,然后删除重复项,以避免测试<code>NaN</code>行中的重复项(如果需要):</p>
<pre><code>df2 = df.dropna(subset=['Vehicle']).drop_duplicates('Name')
print (df2)
Name Vehicle
0 Dave Car
1 Mark Bike
2 Steve Car
</code></pre>