Thumbtack·Data Scientist·Technical Phone Screen
- Given a CSV with job posting data (job_id, job_category, invitations_sent, provider_responses, region, created_at), write pandas code that: computes a per-job response rate while treating zero-invitation rows as missing; calculates an invitation-weighted response rate per job category with 95% Wilson score confidence intervals; returns the top 5 categories ranked by weighted rate with CI lower bound as tiebreaker; drops and logs rows with impossible values like negative counts or provider_responses exceeding invitations_sent; and verifies that the job-level weighted average matches the aggregate rate within floating point tolerance.
“This was a lot to hold in your head at once.”