Quantitative Analysis Guide: Reshaping Data Sets

This table illustrates basic types of reshaping/restructuring of flat data sets containing identifier variables.

We will represent these transformations schematically using the diagram below.

• SPSS
• JMP
• Stata
• SAS
• R
• MATLAB
• Python

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)

• Wide to Mixed (Left) to Long
• Wide to Mixed (Right) to Long

• Long to Mixed (Left) to Wide
• Long to Mixed (Right) to Wide

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)

Page under development

Page under development

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)

Page under development

Page under development

• Wide to Mixed (Left)
• Wide to Mixed (Right)

• Long to Mixed (Left)
• Long to Mixed (Right)

• Mixed (Left) to Long
• Mixed (Right) to Long

• Mixed (Left) to Wide
• Mixed (Right) to Wide

• Mixed (Left) to Mixed (Right)
• Mixed (Right) to Mixed (Left)