melt and pivot

melt() turns a wide table (one column per period, for example) into long format (one row per observation), and pivot() does the reverse. Long format is often preferable for grouping, filtering and plotting charts. pivot requires unique row/column pairs.

Example

long = df.melt(id_vars='produit', var_name='mois', value_name='ventes')

Related concepts

The whole glossary