python 实现分组求和与分组累加求和代码
我就废话不多说了，大家还是直接看代码吧！
#-*-encoding=utf-8-*-
importpandasaspd
data=['abc','abc','abc','asc','ase','ase','ase']
num=[1,2,2,1,2,1,2]
df1=pd.DataFrame({'name':data,'num':num})
print(df1)
df1['mmm']=df1['num']
df2=df1.groupby(['name','num'],as_index=False).count()
print(df2)
df2.sort_values(['name','num'],ascending=[1,1],inplace=True)
print(df2)
df2['sum']=df2.groupby(['name'])['mmm'].cumsum()
print(df2)
kk=df2.groupby(['name'],as_index=False)['num'].sum()
print(kk)
df3=pd.merge(df2,kk,on='name',how='left',)
print(df3)
df3['ratio']=df3['sum']/df3['num_y']
df3.columns=['name','num','mmm','sum','numsum','ratio']
print(df3)
df4=df3.groupby(['mmm'],as_index=False)['ratio'].mean()
print(df4)
运行：
namenum 0abc1 1abc2 2abc2 3asc1 4ase2 5ase1 6ase2 namenummmm 0abc11 1abc22 2asc11 3ase11 4ase22 namenummmm 0abc11 1abc22 2asc11 3ase11 4ase22 namenummmmsum 0abc111 1abc223 2asc111 3ase111 4ase223 namenum 0abc3 1asc1 2ase3 namenum_xmmmsumnum_y 0abc1113 1abc2233 2asc1111 3ase1113 4ase2233 namenummmmsumnumsumratio 0abc11130.333333 1abc22331.000000 2asc11111.000000 3ase11130.333333 4ase22331.000000 mmmratio 010.555556 121.000000 Processfinishedwithexitcode0
补充知识：python项目篇-对符合条件的某个字段进行求和,聚合函数annotate(),aggregate()函数
对符合条件的某个字段求和
需求是，计算每日的收入和
1、
new_dayincome=request.POST.get("dayincome_time",None)
#total_income=models.bathAccount.objects.filter(dayBath=new_dayincome).aggregate(nums=Sum('priceBath'))
total_income=models.bathAccount.objects.values('priceBath').annotate(nums=Sum('priceBath')).filter(dayBath=new_dayincome)
print("total_income",total_income[0]['nums'])
输出结果：total_income132
2、
fromdjango.db.modelsimportSum,Count
new_dayincome=request.POST.get("dayincome_time",None)
total_income=models.bathAccount.objects.filter(dayBath=new_dayincome).aggregate(nums=Sum('priceBath'))
print("total_income",total_income['nums'])
输出结果:total_income572
第二种输出的是正确的数字
以上这篇python实现分组求和与分组累加求和代码就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持毛票票。
热门推荐
3 祝福语简短的微信
10 幼儿祝福语大全简短贺卡
11 感谢教官文案祝福语简短
12 鼠年同事祝福语简短创意
13 元旦祝福语 简短独特群发
14 妈咪跟我生日祝福语简短
15 给儿子新婚祝福语简短
16 伴娘祝福语长文案简短
17 恭喜高考完祝福语简短
18 生日祝福语送老公简短