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

From CommunityData
Revision as of 23:05, 27 April 2017 by Guyrt (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)