擅长:python、mysql、java
<p>使用具有定义的顺序和排序的“category”数据类型:</p>
<pre><code>df['values'] = df['values'].astype('category', ordered=True)\
.cat.reorder_categories(['reason2',
'reason3',
'reason1',
'reason4',
'reason5'])
df.sort_values('values').drop_duplicates('ID', keep='first')
</code></pre>
<p>输出:</p>
^{pr2}$