Data Science
Reshaping Data: Pivot and Melt
Senior Data Analyst
April 21, 2026
5 min read
Pivot (Rows to Columns)
pivot = df.pivot_table(index='product', columns='month', values='sales', aggfunc='sum')
Melt (Columns to Rows)
melted = pd.melt(df, id_vars=['product'], value_vars=['jan', 'feb', 'mar'],
var_name='month', value_name='sales')
*Day 112: Working with Dates and Times.*