ค้นหารหัสของลูกค้าที่มีสถานะการสั่งซื้อทั้ง "บนถนน" และ "จัดส่งแล้ว"
Find the id of the customers who have order status both "On Road" and "Shipped".
df_customers = pd.DataFrame(columns=['customer_id']); df_orders = pd.DataFrame(columns=['customer_id', 'order_status'])
on_road_customers = df_orders[df_orders['order_status'] == 'On Road']['customer_id']; shipped_customers = df_orders[df_orders['order_status'] == 'Shipped']['customer_id']; pd.Series(list(set(on_road_customers).intersection(set(shipped_customers))))