ค้นหาชื่อผู้ป่วยที่ไม่ได้ใช้ยา Procrastin-X
Find the names of patients who are not using the medication of Procrastin-X.
df_Prescribes = pd.DataFrame(columns=['Patient', 'Medication']); df_Medication = pd.DataFrame(columns=['Code', 'name']); df_patient = pd.DataFrame(columns=['name', 'SSN'])
df_patient[~df_patient['SSN'].isin(df_Prescribes[df_Prescribes['Medication'].isin(df_Medication[df_Medication['name'] == 'Procrastin-X']['Code'])]['Patient'])]['name']