Reshaping wages
You would like to look at the wages dataset in a different way. What about making a pivot table out of it? Let's see if the data would be easier to read.
The wages dataset and the DataFrames package have been loaded for you.
This exercise is part of the course
Data Manipulation in Julia
Exercise instructions
- Make a pivot table from the
wagesDataFrame, where:- column values correspond to
stateandregion, in that order; - row values correspond to
year; - actual values are given by the
effective_min_wage_2020_dollarscolumn.
- column values correspond to
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Make a pivot table
____(____, [____], ____, ____)