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.*

Ready to put your knowledge into practice?

Join SQL Mastery and learn through interactive exercises.