1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation with dplyr
Connected

Exercise

Using summarize, slice_max, and count together

In this chapter, you've learned to use six dplyr verbs related to aggregation: count(), group_by(), summarize(), ungroup(), slice_max(), and slice_min(). In this exercise, you'll combine them to answer a question:

In how many states do more people live in metro areas than non-metro areas?

Recall that the metro column has one of the two values "Metro" (for high-density city areas) or "Nonmetro" (for suburban and country areas).

counties_selected <- counties %>%
  select(state, metro, population)

Instructions 1/3

undefined XP
  • 1

    For each combination of state and metro, find the total population as total_pop.

  • 2

    Extract the most populated row from each state, which will be either Metro or Nonmetro.

  • 3

    Ungroup, then count how often Metro or Nonmetro appears to see how many states have more people living in those areas.