1. Learn
  2. /
  3. Courses
  4. /
  5. Data Manipulation with dplyr

Exercise

Using transmute

As you learned in the video, the transmute verb allows you to control which variables you keep, which variables you calculate, and which variables you drop.

Instructions

100 XP
  • Keep only the state, county, and population columns, and add a new column, density, that contains the population per land_area.
  • Filter for only counties with a population greater than one million.
  • Sort the table in ascending order of density.