Katkat
In progressTechnical Screen

Pandas Tasks and Open-Ended Retention Prediction

MixpanelData Scientist · Technical Screen · Sep 2026

Following up on my previous SQL post: This was the Python screen in the same Mixpanel DS phone-interview round, about 45 minutes. There were four questions: two hands-on pandas tasks and two open-ended questions. Aggregate the users and events dataframes separately. Merge the two dataframes and check for duplicates. An easy one. Open-ended: Which features might predict retention? Explore the data…

Shared by a candidate · reported Sep 2026. Interview formats change; use it as a guide, not a script.