polars.lazyframe.groupby.LazyGroupBy.sum

LazyGroupBy.sum() → LazyFrame

Reduce the groups to the sum.

Examples

>>> ldf = pl.DataFrame(
...     {
...         "a": [1, 2, 2, 3, 4, 5],
...         "b": [0.5, 0.5, 4, 10, 13, 14],
...         "c": [True, True, True, False, False, True],
...         "d": ["Apple", "Orange", "Apple", "Apple", "Banana", "Banana"],
...     }
... ).lazy()
>>> ldf.groupby("d", maintain_order=True).sum().collect()
shape: (3, 4)
┌────────┬─────┬──────┬─────┐
│ d      ┆ a   ┆ b    ┆ c   │
│ ---    ┆ --- ┆ ---  ┆ --- │
│ str    ┆ i64 ┆ f64  ┆ u32 │
╞════════╪═════╪══════╪═════╡
│ Apple  ┆ 6   ┆ 14.5 ┆ 2   │
│ Orange ┆ 2   ┆ 0.5  ┆ 1   │
│ Banana ┆ 9   ┆ 27.0 ┆ 1   │
└────────┴─────┴──────┴─────┘