Skip to main content

10 Must-Know Tidyverse Functions: #3 – Pivot Wider and Longer

[This article was first published on business-science.io, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

This article is part of a R-Tips Weekly, a weekly video tutorial that shows you step-by-step how to do common R coding tasks.

Learn how to use pivot_wider() and pivot_longer() to format data like a data wizard:

(Click image to play tutorial)

Why Pivot Wider?

Pivoting wider is essential for making summary tables that go into reports & help humans (like you and me) understand key information.

Let’s say we have some automobile manufacturer data that we want to format into a table that people can read.

We can summarize and pivot the data by manufacturer and class to understand the number of vehicle classes that each manufacturer produces.

The result is a table that I can glean for insights.

Why Pivot Longer?

Pivot longer lengthens data, increasing the number of rows and decreasing the number of columns.

We can convert from wide to long with Pivot Longer, which gets it into the correct format to visualize with GGPLOT HEATMAP. 💥💥💥

That was ridiculously easy. Keep it up & you’ll become a tidyverse rockstar.

rockstar

You Learned Something New!

Great! But, you need to learn a lot to become an R programming wizard.

What happens after you learn R for Business from Matt 👇

Tidyverse wizard

…And the look on your boss’ face after seeing your first Shiny App. 👇

Amazed

This is career acceleration.

SETUP R-TIPS WEEKLY PROJECT

  1. Sign Up to Get the R-Tips Weekly (You’ll get email notifications of NEW R-Tips as they are released): https://ift.tt/3c9jyg7

  2. Set Up the GitHub Repo: https://ift.tt/3isu3NG

  3. Check out the setup video (https://youtu.be/F7aYV0RPyD0). Or, Hit Pull in the Git Menu to get the R-Tips Code

Once you take these actions, you’ll be set up to receive R-Tips with Code every week. =)

To leave a comment for the author, please follow the link and comment on their blog: business-science.io.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

The post 10 Must-Know Tidyverse Functions: #3 - Pivot Wider and Longer first appeared on R-bloggers.



from R-bloggers https://ift.tt/3noiBon
via IFTTT
Labels:

Comments

Post a Comment

Popular posts from this blog

Zooming in on maps with sf and ggplot2

(This article was first published on r-bloggers – WZB Data Science Blog , and kindly contributed to R-bloggers) When working with geo-spatial data in R, I usually use the sf package for manipulating spatial data as Simple Features objects and ggplot2 with geom_sf for visualizing these data. One thing that comes up regularly is “zooming in” on a certain region of interest, i.e. displaying a certain map detail. There are several ways to do so. Three common options are: selecting only certain areas of interest from the spatial dataset (e.g. only certain countries / continent(s) / etc.) cropping the geometries in the spatial dataset using sf_crop() restricting the display window via coord_sf() I will show the advantages and disadvantages of these options and especially focus on how to zoom in on a certain point of interest at a specific “zoom level”. We will see how to calculate the coordinates of the display window or “bounding box” around this zoom point. Loading t...
Post a Comment
Read more

Controlling legend appearance in ggplot2 with override.aes

[This article was first published on Very statisticious on Very statisticious , and kindly contributed to R-bloggers ]. (You can report issue about the content on this page here ) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. In ggplot2 , aesthetics and their scale_*() functions change both the plot appearance and the plot legend appearance simultaneously. The override.aes argument in guide_legend() allows the user to change only the legend appearance without affecting the rest of the plot. This is useful for making the legend more readable or for creating certain types of combined legends. In this post I’ll first introduce override.aes with a basic example and then go through three additional plotting scenarios to how other instances where override.aes comes in handy. Table of Contents R packages Introducing override.aes Adding a guides() layer Using the guide argument in scale_*() Changing multiple aesthetic par...
Post a Comment
Read more