Pandas GroupBy和Sum不创建新的数据框架

Question

我有一个数据帧-

     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

我想创建一个新的数据帧，它将TransactionAmt分组按TransactionHour求和，比如-

        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)

Answer 1

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"})

Answer 2

sliced_data2 = data.groupby('TransactionHour',as_index = False).agg({"TransactionAmt" : "sum"})

Answer 3

sliced_data2 = data.groupby(['TransactionHour'])['TransactionAmt'].agg('sum')

这会有用的