ค้นหาแพทย์ที่ได้รับการฝึกอบรมในขั้นตอนที่แพงที่สุด?
Find the physician who was trained in the most expensive procedure?
df_trained_in = pd.DataFrame(columns=['physician', 'treatment']); df_physician = pd.DataFrame(columns=['name', 'employeeid']); df_procedures = pd.DataFrame(columns=['code', 'cost'])
df_physician[df_physician['employeeid'].isin(df_trained_in[df_trained_in['treatment']==df_procedures.loc[df_procedures['cost'].idxmax()]['code']]['physician'])]['name']