O'Reilly logo

Data Analysis with R - Second Edition by Tony Fischetti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reshaping data with tidyr

Finally, we get to turn our attention to the other staple of the tidyverse, tidyr.

Though this package offers more functionality, the main purpose of this package is to reshape data (convert from long to wide format) in a tidy manner.

Let’s recreate long, a long format that contains the play counts for each year/month, using the following code:

> long <- tracks %>%+   group_by(theyear=year(thedate), themonth) %>%+   summarise(N=n())> long# A tibble: 107 x 3# Groups: theyear [?]   theyear themonth     N     <dbl> <ord>    <int> 1    2008 Jan        877 2    2008 Feb        984 3    2008 Mar       1486 4    2008 Apr       1101...# ... with 97 more rows

Now let’s get this into wide format with the different month in its own columns.

The tidyr equivalent of the dcast function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required