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 edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
** Filters | ** Filters | ||
** Sorting | ** Sorting | ||
* Stats! Let's talk about the | * Stats! Let's talk about the [https://en.wikipedia.org/wiki/Odds_ratio Odds Ratio] | ||
Let's use what we learned to answer some questions | Let's use what we learned to answer some questions | ||
| Line 18: | Line 18: | ||
* What kinds of accidents are more likely to occur at Intersections than in a Block? | * 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) | * Do accidents with speeding involved result in a higher chance of injury? (Hint: use an odds ratio) | ||
* Look at columns HITPARKEDCAR and COLLISIONS. What do you notice about HITPARKEDCAR | |||
* Is speeding more likely to result in injuries or death? | |||
* what is the most dangerous corner in Seattle? | |||
* What do JunctionType and AddrType tell you about this data set? | |||
Latest revision as of 23:28, 2 May 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 Odds 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)
- Look at columns HITPARKEDCAR and COLLISIONS. What do you notice about HITPARKEDCAR
- Is speeding more likely to result in injuries or death?
- what is the most dangerous corner in Seattle?
- What do JunctionType and AddrType tell you about this data set?
