我有一个dataframe -
TransactionDT TransactionAmt TransactionHour
0 86400 68.5 0
1 86401 29.0 1
2 86469 59.0 1
3 86499 50.0 2
4 86506 50.0 3
我想创建一个由TransactionHour
总结TransactionAmt
grouping新的数据帧,比如 -
Sum(TransactionAmt) TransactionHour
0 68.5 0
1 88.0 1 (sum of those with TransactionHour == 1)
2 50.0 2
3 50.0 3
我写的代码是 -
sliced_data2 = data.groupby(['TransactionHour'])['TransactionAmt'].sum()
但它只是给了我Sum(TransactionHour)
分析解答
sliced_data2 = data.groupby(['TransactionHour'])['TransactionAmt'].agg('sum')
这将工作