ลูกค้าที่สั่งสินค้าจำนวนมากที่สุดชื่ออะไร?
What is the name of the customer that made the order with the largest quantity?
df_order_items = pd.DataFrame(columns=['order_id', 'order_quantity']); df_customers = pd.DataFrame(columns=['customer_name', 'customer_id']); df_customer_orders = pd.DataFrame(columns=['customer_id', 'order_id'])
df_customers.loc[df_customers['customer_id'].isin(df_customer_orders.loc[df_customer_orders['order_id'].isin(df_order_items.loc[df_order_items['order_quantity'].idxmax(), 'order_id'])]['customer_id']), 'customer_name']