Merge Duplicate Dataset Records

Problem

Given a list of records records, where each record is a list [id, value, timestamp], merge all records with the same id. For each id, return one record [id, total_value, latest_timestamp] where total_value is the sum of all values for that id and latest_timestamp is the maximum timestamp seen for that id. Return the final list sorted by id in ascending order.

Constraints

• 1 <= len(records) <= 10^5
• records[i].length == 3
• 1 <= id <= 10^9
• -10^6 <= value <= 10^6
• 0 <= timestamp <= 10^9