Analytic Resources

Reshaping Data

Often you have a data that is in "long" format (i.e., a single cases having data in multiple rows) that you need to get into "wide" format (i.e., a file that each row is a single case with multiple variables).

As with everything in R, there are multiple ways to wrangle and work with data. The following provide a couple of examples of how to change your long data to wide and your wide data to long.

InfoWorld: R tip: Reshape data with tidyr (6:18)

UC Business Analytics R Programming Guide- Reshaping Your Data with tidyr

This tutorial provides you with the basic understanding of the four fundamental functions of data tidying that tidyr provides:

gather() makes “wide” data longer
spread() makes “long” data wider
separate() splits a single column into multiple columns
unite() combines multiple columns into a single column

15.20 Converting Data from Long to Wide | R Graphics Cookbook, 2nd editionThis cookbook contains more than 150 recipes to help scientists, engineers, programmers, and data analysts generate high-quality graphs quickly—without having to comb through all the details of R’s graphing systems. Each recipe tackles a specific problem with a solution you can apply to your own project and includes a discussion of how and why the recipe works.

15.19 Converting Data from Wide to Long | R Graphics Cookbook, 2nd editionThis cookbook contains more than 150 recipes to help scientists, engineers, programmers, and data analysts generate high-quality graphs quickly—without having to comb through all the details of R’s graphing systems. Each recipe tackles a specific problem with a solution you can apply to your own project and includes a discussion of how and why the recipe works.

R for Social Scientists- Data Wrangling with dplyr and tidyr

Has several interactive examples, including how to
Split-apply-combine data analysis and the summarize() function
Reshaping with pivot_wider() and pivot_longer()

Quick-R by DataCamp- Reshaping Data

R provides a variety of methods for reshaping data prior to analysis.

TutorialsPoint: R- Data Reshaping

Data Reshaping in R is about changing the way data is organized into rows and columns.

Report abuse