DataDriven
LearnPracticeInterviewDiscussDailyJobs

The Timezone Trap

A medium Python mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
Python
Difficulty
medium
Seniority
L4

Interview Prompt

Given a list of trip dicts (each with 'city', 'status', 'completed_utc' in ISO format with 'Z'), filter to city='San Francisco' AND status='completed'. Convert completed_utc to Pacific time (UTC-8 fixed, ignoring DST for simplicity). Per YYYY-MM (in Pacific time), count completions. Return a dict {year-month: count}.

Summary

Trip data and timezones. They're not the same thing.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your python solution with real code execution
  4. Get instant feedback and a hire/no-hire decision

Related

  • All Mock Interviews
  • Practice Mode (untimed)
  • Python Interview Questions
  • Data Engineering Interview Prep Guide
  • Practice Problems
  • Daily Challenge