如何从数据集中聚合信息以生成结果选项卡

Question

假设我有一个csv格式的数据集：

Date    | Payment Method | Amount ($)

01-08-19  Cash             10.00
01-08-19  Cash             5.00
01-08-19  Credit           13.00
01-08-19  Credit           6.00
02-08-19  Cash             2.00
02-08-19  Credit           18.00
02-08-19  Credit           24.00

我想用pandas来添加每天的所有现金和信用购买：

Date    | Payment Method | Amount ($)

01-08-19  Cash             15.00
01-08-19  Credit           19.00
02-08-19  Cash             2.00
02-08-19  Credit           42.00

把它变成这样一张桌子：

Payment Method | Number of days that total payments exceeded $10

Cash             1
Credit           2

如果不使用任何循环，我怎么做呢

任何帮助都将不胜感激，谢谢

Answer 1

这能解决问题吗

df1=df.groupby(['Day','Payment'])['Amount'].sum().reset_index()

df1
Out[28]: 
         Day Payment  Amount
0  1/08/2019    Cash      15
1  1/08/2019  Credit      19
2  2/08/2019    Cash       2
3  2/08/2019  Credit      42

df1['days Pay exceeded $10']=np.where(df1['Amount']>10,1,0)

df1
Out[30]: 
         Day Payment  Amount  days Pay exceeded $10
0  1/08/2019    Cash      15                      1
1  1/08/2019  Credit      19                      1
2  2/08/2019    Cash       2                      0
3  2/08/2019  Credit      42                      1

df1.groupby(['Payment'])['days Pay exceeded $10'].sum().reset_index()
Out[31]: 
  Payment  days Pay exceeded $10
0    Cash                      1
1  Credit                      2