Parse Complex Data Format with Business Rules | Dataford Interview Questions

Tell me how you would parse a complex data format such as a CSV string and implement business logic based on conditional requirements.

Implement parse_csv_fees(csv_text) for CSV input with the header id,amount,currency,status,customer_type. Return one result per active row, preserving order. Standard CSV quoting and escaped quotes must be supported. For active rows, premium customers have a "0.00" fee; other customers pay 2% of the amount, plus "1.00" when the currency is EUR. Return dictionaries containing id and a two-decimal string fee.

Constraints

The input contains the required header exactly once.
1 <= number of data rows <= 500
Each amount is a valid non-negative decimal with at most two fractional digits.
Each status is active or inactive, ignoring surrounding whitespace and case.
Each currency is USD or EUR.
Each customer_type is premium or standard.
CSV fields may contain commas, escaped quotes, or line breaks according to standard CSV rules.

Function Signature

def parse_csv_fees(csv_text):

Your question is Parse Complex Data Format with Business Rules. 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

Tell me how you would parse a complex data format such as a CSV string and implement business logic based on conditional requirements.

Constraints

The input contains the required header exactly once.
1 <= number of data rows <= 500
Each amount is a valid non-negative decimal with at most two fractional digits.
Each status is active or inactive, ignoring surrounding whitespace and case.
Each currency is USD or EUR.
Each customer_type is premium or standard.
CSV fields may contain commas, escaped quotes, or line breaks according to standard CSV rules.

Function Signature

def parse_csv_fees(csv_text):

Your question is Parse Complex Data Format with Business Rules. 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.