Calculating Message Latency from Two CSV Logs

You are given two CSV log files: ComputeA-send.csv: when messages are sent by ComputeA ComputeB-receive.csv: when messages are received by ComputeB Each row contains: message_type: string identifying the message type id: a unique, incrementing integer identifying the message synchronized_timestamp: integer timestamp when the message is sent/received Compute the message latency for each message that appears in both files: latency = receive_timestamp - send_timestamp Print results as: message_type, id, latency Example: Send: message_type, id, synchronized_timestamp altitude, 0, 222 altitude, 2, 224 altitude, 1, 223 altitude, 3, 230 Receive: message_type, id, synchronized_timestamp altitude, 0, 223 altitude, 1, 225 altitude, 2, 226 Output: message_type, id, latency altitude, 0, 1 altitude, 1, 2 altitude, 2, 2 Assume up to ~1e5 rows per file; aim for efficient runtime (near O(n) or O(n log n)). Example Input SEND message_type,id,synchronized_timestamp altitude,0,222 altitude,2,224 altitude,1,223 altitude,3,230 RECV message_type,id,synchronized_timestamp altitude,0,223 altitude,1,225 altitude,2,226 Output message_type,id,latency altitude,0,1 altitude,1,2 altitude,2,2