pandas版本:
import pandas as pd
import numpy as np
def YcxfyFunc(dfData, dfPerson):
path = '../out/性费用分析输出.xlsx'
#ExcelWriter写入excel
with pd.ExcelWriter(path) as writer:
nameList = np.unique(dfPerson['姓名'].values)
cutoff_date = pd.to_datetime('2020-04-01')
df1 = dfData[dfData['时间'] >= cutoff_date]
df4 = df1[(df1['客户名'] == df1['营业员']) & (df1['客户名'].isin(nameList))]
#写入sheet
df4.to_excel(writer, sheet_name='费用收录到营业员名下清单')
g3 = df4.groupby(['客户名']).agg({'金额': 'sum', '客户名': 'count'})
g31 = g3.rename(columns={'客户名': '笔数'})
#写入sheet
g31.to_excel(writer, sheet_name='费用统计分析清单')
data_excel = pd.read_excel('../file/费用.xlsx', sheet_name='费用')
person_excel = pd.read_excel('../file/人员明细.xlsx',sheet_name='Sheet1')
Func(data_excel,person_excel)