如何把图1实际数量提取到图2的项目数量里

图1

img


图2

img

# 计算各类别数量和患者姓名数
for doctor in df['医生姓名'].unique():
doctor_data = dfldf[ 医生姓名] = doctor]
# 计算各类别数量
item counts = {
拔牙类': doctor_data[doctor_data["收费小类 ] ==拔牙类][数].sum()
补牙类': doctor_data[doctor_data["收费小类'] == 补牙类 ]["数].sum()
儿牙类': doctor_data[doctor_data["收费小类'] ==儿牙类 ]["数].sum()
洁牙类': doctor_data[doctor_data["收费小类 ] ==洁牙类][数'].sum()
美牙类': doctor_data[doctor_data[收费小类 ] == 美牙类 ][ 数 ].sum()
牙周类': doctor_data[doctor_data["收费小类 ] ==牙周类]['数].sum()
正畸类': doctor_data[doctor_data[收费小类'] == 正类][数量].sum()
种植类': doctor_data[doctor_data["收费小类'] == 种植类][数].sum()，
根管治疗类': doctor_data[doctor_data["收费小类] ==根管治疗类][数].sum()
固定修复类': doctor_data[doctor_data[收费小类 ] == 固定修复类]["数].sum()
活动修复类': doctor_data[doctor_data["收费小类 ] ==活动修复类][数量].sum()
patient_counts = doctor_data[ 患者姓名'].nunique()total counts = sum(item counts .values())
# 修改”项目数量"列item_counts['项目数量'] = total_counts

谢邀～
你现在写的逻辑是OK的，只需要修改这里
#计算总数量
total counts = doctor data['数量'].sum()
这里改一下就好了，你试试～