result_out = result.groupby(['服务中心', '业务名称'])['统计系数'].sum().unstack(level='业务名称', fill_value=0).reset_index()
result_gr = result[result['看管人'].notna()]
result_gr = result_gr.groupby(['看管人', '业务名称'])['统计系数'].sum().unstack(level='业务名称', fill_value=0).reset_index()
for name in ['服务中心', '宽带', '号卡','超惠卡','FTTR', '千兆','泛全终端','信用购','尊享会员','智家','权益及智客', '升舱一元购','5GA加速包']:
if name not in result_out.columns:
result_out[name] = 0
if name not in result_gr.columns:
result_gr[name] = 0
result_out = pd.merge(dict_pq, result_out, on=['服务中心'], how='left').fillna(0)
result_out = result_out[
['服务中心', '宽带', '号卡','超惠卡','FTTR', '千兆','泛全终端','信用购','尊享会员','智家','权益及智客', '升舱一元购','5GA加速包']].set_index(
result_out.columns[0]).T.rename(columns={'服务中心':'index'})
result_out = result_out[['柏垭','二龙','河溪','洪山','江南','老观','千佛','水观','思依','古城','七里']]
result_gr = pd.merge(dict_gr, result_gr, on=['看管人'], how='left').fillna(0)
result_gr = result_gr[
['看管人', '宽带', '号卡', '超惠卡', 'FTTR', '千兆', '泛全终端', '信用购', '尊享会员', '智家', '权益及智客','升舱一元购', '5GA加速包']].set_index(
result_gr.columns[0]).T.rename(columns={'看管人':'index'})
result_gr = result_gr[['陈瑛丽','赵欢','张瑜','邓丽君','邱冬梅','廖波(渠道)','段语庭','王云双','岳尹涵','廖波(直销)']]
print(result_gr)
result_all = result_out.merge(result_gr,on='index',how="left")
result_all = result_all[['柏垭','二龙','河溪','洪山','江南','老观','千佛','水观','思依','古城','七里','陈瑛丽','赵欢','张瑜','邓丽君','邱冬梅','廖波(渠道)','段语庭','王云双','岳尹涵','廖波(直销)']]
with pd.ExcelWriter(os.path.join(file_path, result_file_name), mode='a', engine='openpyxl',
if_sheet_exists='replace') as writer:
#result_out.to_excel(writer, sheet_name='服务中心数据', index=True, index_label='指标')
#result_gr.to_excel(writer, sheet_name='个人数据', index=True, index_label='指标')
result_all.to_excel(writer, sheet_name='BOOS数据', index=True, index_label='指标')
#df_ghfz.to_excel(writer, sheet_name='工号发展量', index=False)
最新发布