1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation in Julia

Exercise

Minimum wage by region

Looking at summary statistics of grouped data is a great way to learn about potential differences and similarities between the groups. Combine it with the @chain macro and you have nicely readable code!

In this exercise, you'll revisit the US minimum wage trends. As the 50 states plus Washington, D.C., is too much, you will look at the four regions of the United States - Northeast, Midwest, South, and West. The dataset has been loaded as wages.

Let's see how the different regions handle the minimum wage!

DataFrames, Statistics, Chain, and Plots packages have been loaded for you with the using keyword.

Instructions

100 XP
  • Create a chain macro on the wages DataFrame and save the result as regions_wage.
  • Inside the macro, group by region and year columns.
  • Calculate the median of effective_min_wage_2020_dollars and name the column median_effective_wage_2020.
  • Unstack the result so that the rows correspond to years, columns to regions, and values to the median wage.