Data visualization
| Class 3 | Feb. 1, 2017 |
What good data visualizations have in common. Let’s make some of our own.
POP QUIZ!
- Fill out this form, answer these questions
Story
Readings from homework
- Using Data Visualization to Find Insights in Data
- Using visualizations to tell stories
- An interactive visualization of every line in Hamilton
- How does ‘Hamilton’ the non stop, hip-hop Broadway sensation tap rap’s master rhymes to blur musical lines?
- Wait for it: Last-minute tickets pay off with cheaper prices
- The Lin-Manuel Miranda Effect
- Hamilton is the very model of a modern fast-paced musical
- #Ham4Ham
- The Business of Broadway
- 50 years of Broadway musical source material
- How unaffordable are Hamilton tickets
Discussion points
- Describe the structure
- List all the sources that went into telling the story
- Reverse engineer the questions or pitch that the reporter presented to his or her boss assuming they had done no reporting yet
- What did you find most compelling about the story?
- What’s the most complicated idea you took from the story?
Presentations
Lab
Walkthroughs
- More Google Sheets fun: Charts
- Plot.ly
- Making charts with third-party programs
- Datawrapper
- Highcharts
Data for lab
Homework
Read
| Type | Where | Details |
|---|---|---|
| Reading | GQ | Inside the Federal Bureau of Way Too Many Guns |
| Reading | Quantified Selfie | Forget me nots |
| Reading | Flowing Data | Where people run |
| Reading | Flowing Data | Running while female |
Lab
Part 1
Analyze these data sets (ie. pivot tables) and create a different type of chart using each of these services
- Google Sheets
- School languages
- Specifically, make a bar chart looking at the 5 most-spoken languages aside from English in Connecticut schools
- So the data should look like, Language 1: 50000, Language 2: 40000, Language 3: 350000, etc
- And then bar chart it
- Also, you might find a <=5 messing up your calculations
- Filter those out or find and replace those with 0. This is how.
- Plot.ly
- District enrollment
- Chart out the 5 school districts with the largest gaps between number of Male and Female students.
- So subtract Male from Female and then sort it high to low and chart the first 5 results in a bar chart.
Take a screenshot of the charts and save them to your JRN-418 Homework Google Drive folder.
Part 2
- Read this introduction to R
- Install the R software on your computer
- Install RStudio that runs off the R software