擅长:python、mysql、java
<pre><code>rawData = {
'order number': ['11xa', '11xa', '11xa', '21xb', '31xc'],
'working area': ['LLA', 'LLE', 'LLS', 'MLA', 'MLE'],
'time': ['1', '6', '13', '35', '24']
}
dataframe = pd.DataFrame(rawData)
dataframe['time'] = dataframe['time'].astype(int)
dataframe.groupby(['order number']).sum().reset_index()
</code></pre>
<p>输出</p>
<pre><code>order number time
0 11xa 20
1 21xb 35
2 31xc 24
</code></pre>