擅长:python、mysql、java
<pre><code>raw_data = {'TransactionDT': [86400, 86401, 86469, 86499, 86506],
'TransactionAmt': [68.5, 29.0, 59.0, 50.0, 50.0],
'TransactionHour': [0,1,1,2,3]}
df = pd.DataFrame(raw_data)
df.groupby('TransactionHour',as_index = False).agg({"TransactionAmt" : "sum"})
</code></pre>