The Conversion Drop
Join three CSVs of users, signup events, and experiments in pandas to find the real cause of a 12% conversion drop.
You're an analyst at Tempo, a music streaming startup. Trial-to-paid conversion has dropped 12% over the last 4 weeks. Marketing thinks it's the new pricing page. Engineering thinks the email flow is broken. The PM needs a sharp answer in two days.
Three CSVs are already in your workspace: , , . Your job: find the real cause and write up a short recommendation.
What you'll practice: pandas DataFrames, merges, groupbys, funnel analysis, hypothesis testing.
You'll practice
Load the data
50 XPLoad users.csv, signup_events.csv, experiments.csv into pandas DataFrames named users, signup_events, experiments. The variable names matter — downstream cells assume these exact names.
Done when: all three DataFrames exist in the kernel.