擅长:python、mysql、java
<p>这将过滤掉<code>None</code>和空值(如果存在任何非<code>None</code>或非空值),只保留<code>Vehicle</code>遇到的第一个值</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
df=pd.DataFrame({"Name": ["Dave", "Mark", "Steve", "Dave", "Steve"], "Vehicle": ["Car", "Bike", "Car", None, ""]})
res=df.sort_values("Vehicle", ascending=False).groupby("Name")["Vehicle"].first().reset_index()
</code></pre>
<p>输出:</p>
<pre class="lang-py prettyprint-override"><code> Name Vehicle
0 Dave Car
1 Mark Bike
2 Steve Car
</code></pre>