Pivoting Data

This lesson is called Pivoting Data, part of the Data Cleaning with R course. This lesson is called Pivoting Data, part of the Data Cleaning with R course.

Transcript

Click on the transcript to go to that point in the video. Please note that transcripts are auto generated and may contain minor inaccuracies.

Your Turn

Solution

wp:coblocks/gist {"url":"
          ## %######################################################%##
          #                                                          #
          ####             Pivoting Data - Your Turn              ####
          #                                                          #      
          ## %######################################################%##
        
          # Load the dog ranks data ("dogranks_your.csv")
          # Pivot the data (wide to long and back to wide)
          # load packages -----------------------------------------------------------
        
          library(readr)
          library(tidyr)
        
          # import data -------------------------------------------------------------
          dogranks <- read_csv("data/dogranks-your.csv")
          # pivoting ----------------------------------------------------------------
          # longer
        
          dogranks_long <- dogranks %>% pivot_longer(
            cols = -c(Breed, Size),
            names_to = "Year",
            values_to = "Popularity.Rank"
          )
        
          # back to wide
          dogranks_wide <- dogranks_long %>%
            pivot_wider(names_from = "Year", values_from = "Popularity.Rank")
        ","file":""} /--></div>
</details>
</div>
<p>

Load the dog ranks data ("dogranks_your.csv")
Pivot the data (wide to long and back to wide)

Learn More

The tidyr pivoting vignette is a great place to start to learn more about pivoting your data. Two other sources that have information on pivoting are cmdlinetips.com and Storybench.

Pivoting Data

Transcript

Your Turn

Solution

Learn More

Course Content