ค้นหาแพทย์ที่ได้รับการฝึกอบรมในกระบวนการที่มีค่าใช้จ่ายมากกว่า 5,000
Find the physicians who are trained in a procedure that costs more than 5000.
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'].isin(df_procedures[df_procedures['cost']>5000]['code'])]['physician'])]['name']