我有一个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')

这将工作