Build Tested Data Processing Program | Dataford Interview Questions

Write a complete, functional program in the language of your choice that solves a specific data processing task, complete with automated tests and comprehensive documentation. Implement the task below as a function that parses CSV text with a category,value header, aggregates values by category, and returns [category, total] pairs sorted by descending total and then ascending category. Document the function and provide tests covering normal input, quoted categories, repeated categories, and edge values.

Constraints

1 <= number of data rows <= 1000
The first row is exactly category,value
Each data row contains exactly two CSV fields
Each value is a valid base-10 integer
Category names are nonempty after trimming whitespace
Return categories in descending total order, then ascending lexicographic category order

Function Signature

def aggregate_csv(csv_text):

Your question is Build Tested Data Processing Program. 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 <= number of data rows <= 1000
The first row is exactly category,value
Each data row contains exactly two CSV fields
Each value is a valid base-10 integer
Category names are nonempty after trimming whitespace
Return categories in descending total order, then ascending lexicographic category order

Function Signature

def aggregate_csv(csv_text):

Your question is Build Tested Data Processing Program. 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.