GroupBy and aggregation

groupby splits rows into buckets by one or more keys, applies a function to each bucket and combines the results back into a frame.

agg computes several statistics at once and names the output columns; as_index=False keeps the key as a normal column.

transform returns a value per original row instead of per group — perfect for group shares or group-mean centring.