https://wiki.communitydata.science/index.php?title=Community_Data_Science_Course_(Spring_2019)/Day_8_notes&feed=atom&action=historyCommunity Data Science Course (Spring 2019)/Day 8 notes - Revision history2024-03-29T15:30:08ZRevision history for this page on the wikiMediaWiki 1.38.4https://wiki.communitydata.science/index.php?title=Community_Data_Science_Course_(Spring_2019)/Day_8_notes&diff=141610&oldid=prevBenjamin Mako Hill: Benjamin Mako Hill moved page Day 8 notes to Community Data Science Course (Spring 2019)/Day 8 notes without leaving a redirect: wrong name2019-05-22T02:33:39Z<p>Benjamin Mako Hill moved page <a href="/index.php?title=Day_8_notes&action=edit&redlink=1" class="new" title="Day 8 notes (page does not exist)">Day 8 notes</a> to <a href="/Community_Data_Science_Course_(Spring_2019)/Day_8_notes" title="Community Data Science Course (Spring 2019)/Day 8 notes">Community Data Science Course (Spring 2019)/Day 8 notes</a> without leaving a redirect: wrong name</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 03:33, 22 May 2019</td>
</tr>
<!-- diff cache key wiki_communitydata:diff::1.12:old-140537:rev-141610 -->
</table>Benjamin Mako Hillhttps://wiki.communitydata.science/index.php?title=Community_Data_Science_Course_(Spring_2019)/Day_8_notes&diff=140537&oldid=prevGuyrt: 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..."2019-05-20T21:41:05Z<p>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..."</p>
<p><b>New page</b></p><div>Today we'll take a partial digression from python to talk about Pivot Tables in Excel.<br />
<br />
Outline:<br />
<br />
* Load the SDOT data from last time<br />
* Creating basic pivot tables<br />
* Rows, columns, values, filters<br />
* Aggregation functions<br />
* Common tricks<br />
** Percentiles<br />
** Visualizations<br />
** Filters<br />
** Sorting<br />
* Stats! Let's talk about the [https://en.wikipedia.org/wiki/Odds_ratio Odds Ratio]<br />
<br />
Let's use what we learned to answer some questions<br />
<br />
* What kinds of accidents are more likely to occur at Intersections than in a Block?<br />
* Do accidents with speeding involved result in a higher chance of injury? (Hint: use an odds ratio)<br />
* Look at columns HITPARKEDCAR and COLLISIONS. What do you notice about HITPARKEDCAR<br />
* Is speeding more likely to result in injuries or death?<br />
* what is the most dangerous corner in Seattle?<br />
* What do JunctionType and AddrType tell you about this data set?</div>Guyrt