แพทย์ที่สั่งยาธีสิซินชื่ออะไร
What is the names of the physicians who prescribe medication Thesisin?
df_physician = pd.DataFrame(columns = ['name', 'employeeid']); df_prescribes = pd.DataFrame(columns = ['physician', 'medication']); df_medication = pd.DataFrame(columns = ['code', 'name'])
df_medication_code = df_medication[df_medication['name'] == 'Thesisin']['code'].iloc[0]; df_physician[df_physician['employeeid'].isin(df_prescribes[df_prescribes['medication'] == df_medication_code]['physician'])]['name']