Goal: Get students to think ahead to the visualizations they want to produce, then work through the steps to get there.
First half¶
Do the following as a group, with students directing.
Look at the columns/data through the Portal (don’t download).
Decide how you want to visualize.
What columns should be used?
What chart type should be used?
Keep it simple.
Avoid anything that would require complex transformations.
For the purposes of this lab, it’s ok to cut corners.
Avoid using date/time columns - we’ll cover those in Week 11. Years are fine.
Get the CSV URL.
Create a new notebook.
Read in the data.
Do any necessary data cleaning.
Create the visualization.
If you have time, repeat with a different visualization type, using a different dataset if you need. It’s ok if it’s a bit bumpy; use any dead ends as teachable moments.
Examples¶
Using crash data, make a histogram of contributing factors.
Using city payroll data, make a scatterplot of base salary vs. total other pay.
You’ll need to deal with formatting / data types.
Second half¶
Walk through Lab 11 Exercise.