CSV Data Aggregation with Errors | Dataford Interview Questions

Given CSV data of employees (Name, Department, Years of Experience), perform an operation such as finding the maximum experience or counting employees in a department, treating the data as erroneous: fields may be empty or of the wrong type and must be ignored in aggregations.

Asked in the HackerRank coding round stage. The input is a CSV string with a header row. Implement employee_aggregate(csv_data, operation, department=None): return the maximum valid experience for "max_experience", or the count of valid employees in department for "count_department". A valid row has exactly three nonempty fields, a nonnegative integer experience, and a matching department when counting. Return None when no valid experience exists.

Constraints

The CSV string contains a header row.
Each valid data row has three fields: name, department, and years of experience.
0 <= number of data rows <= 1000.
Valid years of experience are nonnegative integers.
operation is either "max_experience" or "count_department".
department is provided for "count_department" operations.

Function Signature

def employee_aggregate(csv_data, operation, department=None):

Your question is CSV Data Aggregation with Errors. 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

The CSV string contains a header row.
Each valid data row has three fields: name, department, and years of experience.
0 <= number of data rows <= 1000.
Valid years of experience are nonnegative integers.
operation is either "max_experience" or "count_department".
department is provided for "count_department" operations.

Function Signature

def employee_aggregate(csv_data, operation, department=None):

Your question is CSV Data Aggregation with Errors. 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.