Дана таблица продаж (как словарь). Для каждой категории товаров посчитайте:
- общую сумму продаж (total)
- среднюю сумму продажи (avg, округлить до 2 знаков)
Задача основана на вопросах с собеседований в Ozon и Сбер.
def sales_aggregation(data: dict) -> list[dict]:
data = {"category": ["Electronics", "Electronics", "Food", "Food", "Food"], "amount": [100, 200, 50, 30, 20]}
sales_aggregation(data) → [
{"category": "Electronics", "total": 300, "avg": 150.0},
{"category": "Food", "total": 100, "avg": 33.33}
]
Результат отсортирован по category (по алфавиту).
data = {"category":["Electronics","Electronics","Food","Food","Food"],"amount":[100,200,50,30,20]}[{"category":"Electronics","total":300,"avg":150},{"category":"Food","total":100,"avg":33.33}]data = {"category":["A","B","A","B","C"],"amount":[10,20,30,40,50]}[{"category":"A","total":40,"avg":20},{"category":"B","total":60,"avg":30},{"category":"C","total":50,"avg":50}]data = {"category":["X"],"amount":[100]}[{"category":"X","total":100,"avg":100}]