Uber·Data Scientist·Technical Phone Screen
- Given a DataFrame of orders with columns for order_id, city, order_type, and status, compute the completion rate (completed / total) for a given (city, order_type) pair. Handle NaN values, zero denominators, and case sensitivity correctly.
- If the completion rate for a specific city is unusually low, what are the possible root causes and how would you validate each? Which intervention would you ship first?
“I went straight for pandas groupby and immediately second-guessed myself on NaN handling.”