runtimequestion 413 pandas Foundations · easy
Average price per unit sold
A shop wants the average price per unit sold, not per invoice line: a line of 32 boxes at £10.95 counts 32 times. Write average_unit_price(path): read the invoice-lines CSV and return total revenue (Quantity × Price, summed) divided by total units (Quantity, summed). With no units sold, return None.
Function
average_unit_price(path)Filea CSV with
Invoice,StockCode,Description,Quantity,Price,Customer IDReturnsa float, or
None when the file has no rowsExamples
callaverage_unit_price('lines.csv')returns7.64811320754717
callaverage_unit_price('two.csv')returns2.7
callaverage_unit_price('boxes.csv')returns10.95