Normalize Uber Eats Order JSON | Dataford Interview Questions

Write a script to clean, transform, and normalize nested JSON payload data from a simulated Uber Eats order event stream.

Implement normalize_order_events(events). Trim string identifiers, lowercase statuses, uppercase currencies, convert valid monetary values to integer cents using half-up rounding, and aggregate valid duplicate items by ID. Skip events without an order ID and invalid items. Return one normalized object per valid order with missing scalar values represented by null.

Input is a list of JSON objects. Each output object contains event_id, order_id, status, customer_id, total_cents, currency, and items; each item contains item_id, name, quantity, and unit_price_cents.

Constraints

1 <= len(events) <= 10^4
Each event is a JSON-compatible dictionary containing an optional payload object
Each valid order has a non-empty string-convertible id
Item quantities must be positive integers after conversion
Monetary values are decimal-compatible strings or numbers
Duplicate items are identified by normalized item ID

Function Signature

def normalize_order_events(events):

Your question is Normalize Uber Eats Order JSON. 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

Write a script to clean, transform, and normalize nested JSON payload data from a simulated Uber Eats order event stream.

Constraints

1 <= len(events) <= 10^4
Each event is a JSON-compatible dictionary containing an optional payload object
Each valid order has a non-empty string-convertible id
Item quantities must be positive integers after conversion
Monetary values are decimal-compatible strings or numbers
Duplicate items are identified by normalized item ID

Function Signature

def normalize_order_events(events):

Your question is Normalize Uber Eats Order JSON. 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.