# coding:utf-8

import pandas as pd

import numpy as np

# path = r'C:\Users\wuzaipei\Desktop\桂林三金项目签到情况\桂林三金签到.xlsx'

#

# data = pd.read_excel(path,header=0)

df=pd.DataFrame([[1,2,2],[1,4,5],[1,2,4],[1,6,3],[2,3,1],[2,4,1],[2,3,5],[3,1,1]],columns=['A','B','C'])

print(df)

gp=df.groupby(by=['A'])['B','C'].mean()  # 求均值

gs=df.groupby(by=['A'])['B','C'].sum()  # 求和

df1 = df.groupby('A').agg({'B': np.mean, 'C': np.sum}) # 求均值和求和

# gp.size()

print(type(gp))

print(gp)

print(df1)