Pivot Table

Create a pivot table from a list of dictionaries. Group by row_col, pivot on pivot_col, and sum the value_col.

Example

data = [
  {"region": "East", "product": "A", "sales": 10},
  {"region": "East", "product": "B", "sales": 20},
  {"region": "West", "product": "A", "sales": 30},
  {"region": "East", "product": "A", "sales": 5}
]
pivot_table(data, "region", "product", "sales")
# => {"East": {"A": 15, "B": 20}, "West": {"A": 30}}