Community Data Science Course (Spring 2017)/Day 5 Notes: Difference between revisions
From CommunityData
(Created page with "Today we'll take a partial digression from python to talk about Pivot Tables in Excel. Outline: * Load the SDOT data from last time * Creating basic pivot tables * Rows, col...") |
(No difference)
|
Revision as of 01:05, 28 April 2017
Today we'll take a partial digression from python to talk about Pivot Tables in Excel.
Outline:
- Load the SDOT data from last time
- Creating basic pivot tables
- Rows, columns, values, filters
- Aggregation functions
- Common tricks
- Percentiles
- Visualizations
- Filters
- Sorting
- Stats! Let's talk about the [Ratio]
Let's use what we learned to answer some questions
- What kinds of accidents are more likely to occur at Intersections than in a Block?
- Do accidents with speeding involved result in a higher chance of injury? (Hint: use an odds ratio)