Pivot Table

MediumPython
05:00
Лучше работает на десктопе
Pandaspivot_tablereshape

Дана таблица продаж (как словарь) с колонками: region, product, revenue.

Постройте pivot table: строки — region, столбцы — product, значения — сумма revenue.
Верните результат как dict of dicts: {region: {product: sum_revenue}}.

Пропуски заполнить 0.

Сигнатура

def pivot_sales(data: dict) -> dict:

Примеры

data = {"region": ["Moscow","Moscow","SPb","Moscow"], "product": ["A","B","A","A"], "revenue": [100,200,150,50]}
pivot_sales(data) → {"Moscow": {"A": 150, "B": 200}, "SPb": {"A": 150, "B": 0}}

Регионы и продукты отсортированы по алфавиту.

Примеры

Пример 1

Вход:
data = {"region":["Moscow","Moscow","SPb","Moscow"],"product":["A","B","A","A"],"revenue":[100,200,150,50]}
Выход:{"Moscow":{"A":150,"B":200},"SPb":{"A":150,"B":0}}

Пример 2

Вход:
data = {"region":["North","North","South","South","North"],"product":["X","Y","X","Y","X"],"revenue":[10,20,30,40,5]}
Выход:{"North":{"X":15,"Y":20},"South":{"X":30,"Y":40}}
Консоль
Нажмите Run или Ctrl+Enter для запуска