Community Data Science Course (Spring 2017)/Day 5 Notes

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)