🔎 Pandas Interview Question (Query-Based | Tricky)

Ques : You have a DataFrame df with columns customer_id, order_date, and amount.

How would you find customers who placed more than 3 orders AND whose total purchase amount is greater than 50,000?

✅ Answer

df.groupby('customer_id')
.agg(order_count=('order_date', 'count'),
total_amount=('amount', 'sum'))
.query('order_count > 3 and total_amount > 50000')

⚠️ Why This Is Tricky

Candidates often apply filters before aggregation or struggle to combine multiple conditions correctly.

💡 Interview Tip:

For conditions on aggregated values → groupby → agg → query

👍 React if this helped