擅长:python、mysql、java
<pre><code>import pandas as pd
rawData = {
'order_number': ['11xa', '11xa', '11xa', '21xb', '31xc'],
'working_area': ['LLA', 'LLE', 'LLS', 'MLA', 'MLE'],
'time': ['1', '6', '13', '35', '24']
}
df = pd.DataFrame(rawData)
df['time'] = df['time'].apply(int)
df = df.groupby('order_number', as_index=False).apply(lambda g: g.assign(sum=g.time.sum()))
df.groupby('order_number', ascending=False).apply(lambda x: x.sort_values('time').head(1)).reset_index(drop=True)
</code></pre>
<p>给你</p>
<pre><code> order_number working_area time sum
0 11xa LLA 1 20
1 21xb MLA 35 35
2 31xc MLE 24 24
</code></pre>