Driver Signups and Inactivity | Dataford Interview Questions

Given fact_trip (trip details, driver_id, rider_id, start_time, end_time, city_id) and driver_signup (driver_id, signup_date), find driver_ids who have not taken a trip in the first 7 days of their signup. Discuss optimizations based on data volume.

Asked in the Round 1 stage. Implement this with Python lists of dictionaries. driver_signup contains driver_id and signup_date; fact_trip contains the listed trip fields. Treat a trip as qualifying when its start_time is on or after signup and before signup plus 7 days. Return qualifying driver IDs in ascending order.

Constraints

1 <= len(driver_signup) <= 1000
0 <= len(fact_trip) <= 10000
Each driver_id in driver_signup is unique
Dates use ISO 8601 strings parseable by datetime.fromisoformat
A qualifying trip is counted when signup_date <= start_time < signup_date + 7 days

Function Signature

def drivers_without_first_week_trip(driver_signup, fact_trip):

Your question is Driver Signups and Inactivity. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Constraints

1 <= len(driver_signup) <= 1000
0 <= len(fact_trip) <= 10000
Each driver_id in driver_signup is unique
Dates use ISO 8601 strings parseable by datetime.fromisoformat
A qualifying trip is counted when signup_date <= start_time < signup_date + 7 days

Function Signature

def drivers_without_first_week_trip(driver_signup, fact_trip):

Your question is Driver Signups and Inactivity. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.