我就廢話不多說了，大家還是直接看代碼吧！

# -*- encoding=utf-8 -*-import pandas as pddata=[’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)

運行：

name num0 abc 11 abc 22 abc 23 asc 14 ase 25 ase 16 ase 2 name num mmm0 abc 1 11 abc 2 22 asc 1 13 ase 1 14 ase 2 2 name num mmm0 abc 1 11 abc 2 22 asc 1 13 ase 1 14 ase 2 2 name num mmm sum0 abc 1 1 11 abc 2 2 32 asc 1 1 13 ase 1 1 14 ase 2 2 3 name num0 abc 31 asc 12 ase 3 name num_x mmm sum num_y0 abc 1 1 1 31 abc 2 2 3 32 asc 1 1 1 13 ase 1 1 1 34 ase 2 2 3 3 name num mmm sum numsum ratio0 abc 1 1 1 3 0.3333331 abc 2 2 3 3 1.0000002 asc 1 1 1 1 1.0000003 ase 1 1 1 3 0.3333334 ase 2 2 3 3 1.000000 mmm ratio0 1 0.5555561 2 1.000000Process finished with exit code 0

補充知識：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_income 132

2、

from django.db.models import Sum,Countnew_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_income 572

第二種輸出的是正確的數字

以上這篇python 實現分組求和與分組累加求和代碼就是小編分享給大家的全部內容了，希望能給大家一個參考，也希望大家多多支持好吧啦網。