Дана таблица продаж (как словарь) с колонками: 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}}
Регионы и продукты отсортированы по алфавиту.
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}}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}}