擅长:python、mysql、java
<p>如果我理解正确,我们做<code>Categorical</code>,然后<code>sort_values</code>+<code>drop_duplicates</code>:</p>
<pre><code>df.Degree = pd.Categorical(df.Degree, ordered=True,
categories='PHD>MBA>Masters>Bachelors>Others'.split('>')[::-1])
Yourdf=df.sort_values('Degree').drop_duplicates('ID',keep='last')
ID Degree
3 2 Bachelors
2 1 PHD
5 3 PHD
</code></pre>