擅长:python、mysql、java
<pre><code>data = []
for shipment_id in set(df['ShipmentID'].values):
row = {
'ShipmentID':shipment_id,
'AccessorialCode': 'LNH',
'Cost': sum(df[df['ShipmentID'] == shipment_id]['Cost'].values),
}
data.append(row)
df0 = df(data)
</code></pre>