ค้นหาชื่อยาที่ใช้กับคนไข้ที่เข้าพักห้อง 111?
Find the name of medication used on the patient who stays in room 111?
df_prescribes = pd.DataFrame(columns = ['Patient', 'Medication']); df_medication = pd.DataFrame(columns = ['name', 'Code']); df_patient = pd.DataFrame(columns = ['SSN']); df_stay = pd.DataFrame(columns = ['Patient'])
df_patient_id = df_stay[df_stay['Patient'] == '111']['Patient'].iloc[0]; df_medication_code = df_prescribes[df_prescribes['Patient'] == df_patient_id]['Medication'].iloc[0]; df_medication[df_medication['Code'] == df_medication_code]['name']