A pivot table aggregates data along two dimensions: categories as rows, others as columns, and an aggregated value (sum, mean, count) in the cells. In pandas, pivot_table produces it; Excel and Power BI offer the same principle.
Example
df.pivot_table(index="region", columns="annee", values="ca", aggfunc="sum")