Loading the 80s
Your colleague is interested in digging deeper into the U.S. minimum wage trends in the 80s and 90s. Their computer is not the newest, though, so it would be best to load only the pertinent data and not to filter the whole DataFrame. Can you help them?
The wages.csv dataset contains data for the 50 states and Washington D.C. The records start in the year 1968 and are sorted by the year and then alphabetically by the state, so the first record is from 1968 Alabama, and the last is from 2020 Wyoming. Overall, there are 12 years of records for the total of 51 areas, along with the header line, before you get to the first record for 1980.
The CSV and DataFrames packages have been loaded for you.
This exercise is part of the course
Data Manipulation in Julia
Exercise instructions
- Load the records from the 80s and save them to
wages_80sas a DataFrame. - Print the first and last lines to check if you got the correct data.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load wages from the 80s
____
# Print first and last lines to check
println(____(wages_80s))
println(____(wages_80s))