ระบุชื่อลูกค้าที่เคยยกเลิกการซื้อผลิตภัณฑ์ "อาหาร" (สถานะรายการคือ "ยกเลิก")
List the names of customers who have once canceled the purchase of the product "food" (the item status is "Cancel").
df_orders = pd.DataFrame(columns=['customer_id', 'order_id']); df_customers = pd.DataFrame(columns=['customer_name', 'customer_id']); df_products = pd.DataFrame(columns=['product_id', 'product_name']); df_order_items = pd.DataFrame(columns=['product_id', 'order_item_status', 'order_id'])
df_customers[df_customers.customer_id.isin(df_orders[df_orders.order_id.isin(df_order_items[(df_order_items.order_item_status=='Cancel') & (df_order_items.product_id.isin(df_products[df_products.product_name=='food'].product_id))].order_id)].customer_id)].customer_name