ค้นหาชื่อลูกค้าที่ไม่เคยสั่งผลิตภัณฑ์ Latte
Find the names of customers who never ordered product Latte.
df_order_items = pd.DataFrame(columns=['order_id', 'product_id']); df_customer_orders = pd.DataFrame(columns=['customer_id', 'order_id']); df_products = pd.DataFrame(columns=['product_id', 'product_details']); df_customers = pd.DataFrame(columns=['customer_name', 'customer_id'])
list(set(df_customers['customer_name']) - set(df_customers[df_customers['customer_id'].isin(df_customer_orders[df_customer_orders['order_id'].isin(df_order_items[df_order_items['product_id'].isin(df_products[df_products['product_details'] == 'Latte']['product_id'])]['order_id'])]['customer_id'])]['customer_name']))