擅长:python、mysql、java
<p>根据注释,这可以是实现之一:(实现<a href="https://stackoverflow.com/users/2789863/brittenb">@brittenb</a>的思想)</p>
<pre><code>priority_dict = {
'reason1':1,
'reason2':2,
'reason3':3,
'reason4':4,
'reason5':5
}
df['priority'] = df['values'].map(priority_dict)
df = df.sort_values(by=['ID', 'priority'])
df.drop_duplicates(['ID'], keep='first')
</code></pre>
<p>输出:</p>
^{pr2}$