1315 lines
106 KiB
Text
1315 lines
106 KiB
Text
{
|
||
"cells": [
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# 15 minute explore of Womens March Dataset from data.world"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 8,
|
||
"metadata": {
|
||
"collapsed": true
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"import pandas as pd\n",
|
||
"import seaborn as sns\n",
|
||
"% matplotlib inline"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"## Load Data"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 3,
|
||
"metadata": {
|
||
"collapsed": true
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"df = pd.read_csv('https://query.data.world/s/78ou6jcu4jfseul53lu1w3nio')"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 4,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/html": [
|
||
"<div>\n",
|
||
"<table border=\"1\" class=\"dataframe\">\n",
|
||
" <thead>\n",
|
||
" <tr style=\"text-align: right;\">\n",
|
||
" <th></th>\n",
|
||
" <th>location</th>\n",
|
||
" <th>crowd-low-estimate</th>\n",
|
||
" <th>crowd-high-estimate</th>\n",
|
||
" <th>mean-high-low</th>\n",
|
||
" <th>source</th>\n",
|
||
" <th>Latitude</th>\n",
|
||
" <th>Longitude</th>\n",
|
||
" </tr>\n",
|
||
" </thead>\n",
|
||
" <tbody>\n",
|
||
" <tr>\n",
|
||
" <th>0</th>\n",
|
||
" <td>Abilene, TX</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>200.0</td>\n",
|
||
" <td>http://www.reporternews.com/story/news/local/2...</td>\n",
|
||
" <td>32.576489</td>\n",
|
||
" <td>-99.665323</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>1</th>\n",
|
||
" <td>Accident, MD</td>\n",
|
||
" <td>54</td>\n",
|
||
" <td>54</td>\n",
|
||
" <td>54.0</td>\n",
|
||
" <td>Twitter; on-site witness</td>\n",
|
||
" <td>39.628700</td>\n",
|
||
" <td>-79.319760</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>2</th>\n",
|
||
" <td>Adak, AK</td>\n",
|
||
" <td>10</td>\n",
|
||
" <td>10</td>\n",
|
||
" <td>10.0</td>\n",
|
||
" <td>adn.com</td>\n",
|
||
" <td>0.000000</td>\n",
|
||
" <td>0.000000</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>3</th>\n",
|
||
" <td>Adrian, MI</td>\n",
|
||
" <td>130</td>\n",
|
||
" <td>150</td>\n",
|
||
" <td>140.0</td>\n",
|
||
" <td>https://www.facebook.com/events/847360115406578/</td>\n",
|
||
" <td>41.889943</td>\n",
|
||
" <td>-84.065892</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>4</th>\n",
|
||
" <td>Ajo, AZ</td>\n",
|
||
" <td>250</td>\n",
|
||
" <td>250</td>\n",
|
||
" <td>250.0</td>\n",
|
||
" <td>https://www.facebook.com/plugins/post.php?href...</td>\n",
|
||
" <td>32.384890</td>\n",
|
||
" <td>-112.890110</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>5</th>\n",
|
||
" <td>Alameda, CA</td>\n",
|
||
" <td>8</td>\n",
|
||
" <td>8</td>\n",
|
||
" <td>8.0</td>\n",
|
||
" <td>FB</td>\n",
|
||
" <td>37.770563</td>\n",
|
||
" <td>-122.264779</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>6</th>\n",
|
||
" <td>Alamosa, CO</td>\n",
|
||
" <td>350</td>\n",
|
||
" <td>350</td>\n",
|
||
" <td>350.0</td>\n",
|
||
" <td>https://twitter.com/zepol/status/8232349739352...</td>\n",
|
||
" <td>37.479933</td>\n",
|
||
" <td>-105.790967</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>7</th>\n",
|
||
" <td>Albany, CA</td>\n",
|
||
" <td>500</td>\n",
|
||
" <td>500</td>\n",
|
||
" <td>500.0</td>\n",
|
||
" <td>https://twitter.com/ben_silverman/status/82303...</td>\n",
|
||
" <td>42.614852</td>\n",
|
||
" <td>-73.970812</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>8</th>\n",
|
||
" <td>Albany, NY</td>\n",
|
||
" <td>7,000</td>\n",
|
||
" <td>9,000</td>\n",
|
||
" <td>8000.0</td>\n",
|
||
" <td>http://www.timesunion.com/local/article/Albany...</td>\n",
|
||
" <td>42.614852</td>\n",
|
||
" <td>-73.970812</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>9</th>\n",
|
||
" <td>Alexandria, VA</td>\n",
|
||
" <td>17</td>\n",
|
||
" <td>17</td>\n",
|
||
" <td>17.0</td>\n",
|
||
" <td>https://twitter.com/TinaPStacy/status/82322604...</td>\n",
|
||
" <td>38.819853</td>\n",
|
||
" <td>-77.059645</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>10</th>\n",
|
||
" <td>Albuquerque, NM</td>\n",
|
||
" <td>3,000</td>\n",
|
||
" <td>20,000</td>\n",
|
||
" <td>11500.0</td>\n",
|
||
" <td>http://www.koat.com/article/thousands-fill-civ...</td>\n",
|
||
" <td>35.199592</td>\n",
|
||
" <td>-106.644831</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>11</th>\n",
|
||
" <td>Almanor West, CA</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>4.0</td>\n",
|
||
" <td>eyewitness; picture</td>\n",
|
||
" <td>44.984663</td>\n",
|
||
" <td>-93.542233</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>12</th>\n",
|
||
" <td>Alpine, TX</td>\n",
|
||
" <td>96</td>\n",
|
||
" <td>96</td>\n",
|
||
" <td>96.0</td>\n",
|
||
" <td>https://twitter.com/sarahmvasquez/status/82318...</td>\n",
|
||
" <td>32.810624</td>\n",
|
||
" <td>-116.710667</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>13</th>\n",
|
||
" <td>Amarillo, TX</td>\n",
|
||
" <td>600</td>\n",
|
||
" <td>600</td>\n",
|
||
" <td>600.0</td>\n",
|
||
" <td>https://www.texastribune.org/2017/01/21/thousa...</td>\n",
|
||
" <td>35.206030</td>\n",
|
||
" <td>-101.839602</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>14</th>\n",
|
||
" <td>Amelia Island, FL</td>\n",
|
||
" <td>700</td>\n",
|
||
" <td>1,300</td>\n",
|
||
" <td>1000.0</td>\n",
|
||
" <td>http://www.firstcoastnews.com/news/womens-marc...</td>\n",
|
||
" <td>42.271790</td>\n",
|
||
" <td>-88.188464</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>15</th>\n",
|
||
" <td>Anacortes, WA</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>http://www.goskagit.com/skagit/hundreds-partic...</td>\n",
|
||
" <td>48.499172</td>\n",
|
||
" <td>-122.607111</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>16</th>\n",
|
||
" <td>Anchorage, AK</td>\n",
|
||
" <td>2,000</td>\n",
|
||
" <td>3,000</td>\n",
|
||
" <td>2500.0</td>\n",
|
||
" <td>https://www.adn.com/alaska-news/2017/01/21/lar...</td>\n",
|
||
" <td>61.220018</td>\n",
|
||
" <td>-149.855702</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>17</th>\n",
|
||
" <td>Ann Arbor, MI</td>\n",
|
||
" <td>11,000</td>\n",
|
||
" <td>11,000</td>\n",
|
||
" <td>11000.0</td>\n",
|
||
" <td>http://www.mlive.com/news/ann-arbor/index.ssf/...</td>\n",
|
||
" <td>42.266638</td>\n",
|
||
" <td>-83.849042</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>18</th>\n",
|
||
" <td>Annapolis, MD</td>\n",
|
||
" <td>1,600</td>\n",
|
||
" <td>1,600</td>\n",
|
||
" <td>1600.0</td>\n",
|
||
" <td>http://www.capitalgazette.com/news/annapolis/p...</td>\n",
|
||
" <td>38.987750</td>\n",
|
||
" <td>-76.552800</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>19</th>\n",
|
||
" <td>Arlington, VA</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>32.635563</td>\n",
|
||
" <td>-97.148829</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>20</th>\n",
|
||
" <td>Asbury Park, NJ</td>\n",
|
||
" <td>6,000</td>\n",
|
||
" <td>6,000</td>\n",
|
||
" <td>6000.0</td>\n",
|
||
" <td>https://twitter.com/JuliaJHobbs/status/8229551...</td>\n",
|
||
" <td>40.250725</td>\n",
|
||
" <td>-74.048582</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>21</th>\n",
|
||
" <td>Asheville, NC</td>\n",
|
||
" <td>7,000</td>\n",
|
||
" <td>10,000</td>\n",
|
||
" <td>8500.0</td>\n",
|
||
" <td>http://wlos.com/news/local/photo-gallery-the-w...</td>\n",
|
||
" <td>35.602711</td>\n",
|
||
" <td>-82.567281</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>22</th>\n",
|
||
" <td>Ashland, OR</td>\n",
|
||
" <td>6,000</td>\n",
|
||
" <td>8000</td>\n",
|
||
" <td>7000.0</td>\n",
|
||
" <td>http://www.mailtribune.com/news/20170121/voice...</td>\n",
|
||
" <td>38.473824</td>\n",
|
||
" <td>-82.647933</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>23</th>\n",
|
||
" <td>Aspen, CO</td>\n",
|
||
" <td>1,000</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>1000.0</td>\n",
|
||
" <td>https://twitter.com/SarahGoTrillIum/status/823...</td>\n",
|
||
" <td>39.169324</td>\n",
|
||
" <td>-106.776744</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>24</th>\n",
|
||
" <td>Astoria, OR</td>\n",
|
||
" <td>100</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>550.0</td>\n",
|
||
" <td>http://www.dailyastorian.com/Local_News/201701...</td>\n",
|
||
" <td>46.142206</td>\n",
|
||
" <td>-123.795996</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>25</th>\n",
|
||
" <td>Athens, GA</td>\n",
|
||
" <td>700</td>\n",
|
||
" <td>5000</td>\n",
|
||
" <td>2850.0</td>\n",
|
||
" <td>http://onlineathens.com/slideshow/2017-01-21/p...</td>\n",
|
||
" <td>40.605382</td>\n",
|
||
" <td>-73.755133</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>26</th>\n",
|
||
" <td>Atlanta, GA</td>\n",
|
||
" <td>60,000</td>\n",
|
||
" <td>63000</td>\n",
|
||
" <td>61500.0</td>\n",
|
||
" <td>http://www.ajc.com/news/state--regional-govt--...</td>\n",
|
||
" <td>33.844371</td>\n",
|
||
" <td>-84.474050</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>27</th>\n",
|
||
" <td>Augusta, GA</td>\n",
|
||
" <td>600</td>\n",
|
||
" <td>600</td>\n",
|
||
" <td>600.0</td>\n",
|
||
" <td>http://chronicle.augusta.com/news/2017-01-21/h...</td>\n",
|
||
" <td>44.351642</td>\n",
|
||
" <td>-69.803773</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>28</th>\n",
|
||
" <td>Augusta, ME</td>\n",
|
||
" <td>10,000</td>\n",
|
||
" <td>10000</td>\n",
|
||
" <td>10000.0</td>\n",
|
||
" <td>http://bangordailynews.com/2017/01/21/news/sta...</td>\n",
|
||
" <td>44.351642</td>\n",
|
||
" <td>-69.803773</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>29</th>\n",
|
||
" <td>Austin, TX</td>\n",
|
||
" <td>30,000</td>\n",
|
||
" <td>50,000</td>\n",
|
||
" <td>40000.0</td>\n",
|
||
" <td>http://kut.org/post/tens-thousands-participate...</td>\n",
|
||
" <td>30.326374</td>\n",
|
||
" <td>-97.771258</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>...</th>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>...</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>511</th>\n",
|
||
" <td>Watertown, NY</td>\n",
|
||
" <td>250</td>\n",
|
||
" <td>250</td>\n",
|
||
" <td>250.0</td>\n",
|
||
" <td>http://www.watertowndailytimes.com/news03/wate...</td>\n",
|
||
" <td>43.968892</td>\n",
|
||
" <td>-75.906501</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>512</th>\n",
|
||
" <td>Watsonville, CA</td>\n",
|
||
" <td>300</td>\n",
|
||
" <td>500</td>\n",
|
||
" <td>400.0</td>\n",
|
||
" <td>eyewitness</td>\n",
|
||
" <td>36.980250</td>\n",
|
||
" <td>-121.746960</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>513</th>\n",
|
||
" <td>Wausau, WI</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>200.0</td>\n",
|
||
" <td>FB</td>\n",
|
||
" <td>44.963304</td>\n",
|
||
" <td>-89.704051</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>514</th>\n",
|
||
" <td>Welches, OR</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>45.327305</td>\n",
|
||
" <td>-121.973561</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>515</th>\n",
|
||
" <td>Wellfleet, MA</td>\n",
|
||
" <td>113</td>\n",
|
||
" <td>113</td>\n",
|
||
" <td>113.0</td>\n",
|
||
" <td>via email (JP)</td>\n",
|
||
" <td>40.762172</td>\n",
|
||
" <td>-100.760429</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>516</th>\n",
|
||
" <td>Wenatchee, WA</td>\n",
|
||
" <td>2,000</td>\n",
|
||
" <td>2,000</td>\n",
|
||
" <td>2000.0</td>\n",
|
||
" <td>http://www.wenatcheeworld.com/news/2017/jan/21...</td>\n",
|
||
" <td>47.573816</td>\n",
|
||
" <td>-120.351884</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>517</th>\n",
|
||
" <td>West Chester, PA</td>\n",
|
||
" <td>150</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>175.0</td>\n",
|
||
" <td>https://wcborodems.org/2017/01/21/in-solidarit...</td>\n",
|
||
" <td>39.980107</td>\n",
|
||
" <td>-75.610503</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>518</th>\n",
|
||
" <td>West Jefferson, NC</td>\n",
|
||
" <td>250</td>\n",
|
||
" <td>300</td>\n",
|
||
" <td>275.0</td>\n",
|
||
" <td>https://twitter.com/wineymomof2/status/8229288...</td>\n",
|
||
" <td>39.948860</td>\n",
|
||
" <td>-83.309892</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>519</th>\n",
|
||
" <td>West Lima, WI</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>Twitter</td>\n",
|
||
" <td>42.078130</td>\n",
|
||
" <td>-76.845236</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>520</th>\n",
|
||
" <td>West Palm Beach, FL</td>\n",
|
||
" <td>5,000</td>\n",
|
||
" <td>7000</td>\n",
|
||
" <td>6000.0</td>\n",
|
||
" <td>http://www.palmbeachpost.com/news/local/thousa...</td>\n",
|
||
" <td>40.224597</td>\n",
|
||
" <td>-111.669615</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>521</th>\n",
|
||
" <td>Westfield, NJ</td>\n",
|
||
" <td>1,000</td>\n",
|
||
" <td>2,000</td>\n",
|
||
" <td>1500.0</td>\n",
|
||
" <td>https://www.tapinto.net/towns/westfield/articl...</td>\n",
|
||
" <td>40.691613</td>\n",
|
||
" <td>-112.001050</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>522</th>\n",
|
||
" <td>Wichita, KS</td>\n",
|
||
" <td>3000</td>\n",
|
||
" <td>3000</td>\n",
|
||
" <td>3000.0</td>\n",
|
||
" <td>http://www.kansas.com/news/local/article127951...</td>\n",
|
||
" <td>37.651974</td>\n",
|
||
" <td>-97.258997</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>523</th>\n",
|
||
" <td>Wichita Falls, TX</td>\n",
|
||
" <td>150</td>\n",
|
||
" <td>150</td>\n",
|
||
" <td>150.0</td>\n",
|
||
" <td>http://www.timesrecordnews.com/story/news/loca...</td>\n",
|
||
" <td>33.905544</td>\n",
|
||
" <td>-98.479881</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>524</th>\n",
|
||
" <td>Williamsburg, VA</td>\n",
|
||
" <td>700</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>850.0</td>\n",
|
||
" <td>http://wydaily.com/2017/01/21/womens-march-in-...</td>\n",
|
||
" <td>37.310451</td>\n",
|
||
" <td>-76.746769</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>525</th>\n",
|
||
" <td>Willits, CA</td>\n",
|
||
" <td>50</td>\n",
|
||
" <td>50</td>\n",
|
||
" <td>50.0</td>\n",
|
||
" <td>FB</td>\n",
|
||
" <td>39.525958</td>\n",
|
||
" <td>-123.365730</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>526</th>\n",
|
||
" <td>Wilmington, NC</td>\n",
|
||
" <td>3000</td>\n",
|
||
" <td>3000</td>\n",
|
||
" <td>3000.0</td>\n",
|
||
" <td>http://www.twcnews.com/nc/coastal/news/2017/01...</td>\n",
|
||
" <td>34.271985</td>\n",
|
||
" <td>-77.963628</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>527</th>\n",
|
||
" <td>Wilton, NH</td>\n",
|
||
" <td>100</td>\n",
|
||
" <td>125</td>\n",
|
||
" <td>112.5</td>\n",
|
||
" <td>onsite eyewitness who did headcount (via googl...</td>\n",
|
||
" <td>43.073715</td>\n",
|
||
" <td>-73.740236</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>528</th>\n",
|
||
" <td>Winchester, VA</td>\n",
|
||
" <td>700</td>\n",
|
||
" <td>1200</td>\n",
|
||
" <td>950.0</td>\n",
|
||
" <td>onsite eyewitness & local news (via google form)</td>\n",
|
||
" <td>36.131662</td>\n",
|
||
" <td>-115.168382</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>529</th>\n",
|
||
" <td>Winston-Salem, NC</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>36.111102</td>\n",
|
||
" <td>-80.200493</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>530</th>\n",
|
||
" <td>Winters, CA</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>200</td>\n",
|
||
" <td>200.0</td>\n",
|
||
" <td>FB</td>\n",
|
||
" <td>28.686894</td>\n",
|
||
" <td>-81.273258</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>531</th>\n",
|
||
" <td>Woodstock, NY</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>1000.0</td>\n",
|
||
" <td>FB</td>\n",
|
||
" <td>42.320271</td>\n",
|
||
" <td>-88.462832</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>532</th>\n",
|
||
" <td>Woodstock, VA</td>\n",
|
||
" <td>400</td>\n",
|
||
" <td>400</td>\n",
|
||
" <td>400.0</td>\n",
|
||
" <td>http://www.nvdaily.com/uncategorized/2017/01/w...</td>\n",
|
||
" <td>42.320271</td>\n",
|
||
" <td>-88.462832</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>533</th>\n",
|
||
" <td>Wooster, OH</td>\n",
|
||
" <td>500</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>750.0</td>\n",
|
||
" <td>http://www.the-daily-record.com/local%20news/2...</td>\n",
|
||
" <td>40.830699</td>\n",
|
||
" <td>-81.895377</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>534</th>\n",
|
||
" <td>Worcester, MA</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>http://www.telegram.com/news/20170121/central-...</td>\n",
|
||
" <td>42.265275</td>\n",
|
||
" <td>-71.879415</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>535</th>\n",
|
||
" <td>Wyckoff, NJ</td>\n",
|
||
" <td>300</td>\n",
|
||
" <td>500</td>\n",
|
||
" <td>400.0</td>\n",
|
||
" <td>http://www.northjersey.com/story/news/local/20...</td>\n",
|
||
" <td>45.341881</td>\n",
|
||
" <td>-117.872662</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>536</th>\n",
|
||
" <td>Yakima, WA</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>1000</td>\n",
|
||
" <td>1000.0</td>\n",
|
||
" <td>http://www.yakimaherald.com/news/local/hundred...</td>\n",
|
||
" <td>46.722625</td>\n",
|
||
" <td>-120.406039</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>537</th>\n",
|
||
" <td>Ypsilanti, MI</td>\n",
|
||
" <td>1200</td>\n",
|
||
" <td>1200</td>\n",
|
||
" <td>1200.0</td>\n",
|
||
" <td>https://twitter.com/theplaidjunct/status/82298...</td>\n",
|
||
" <td>42.202139</td>\n",
|
||
" <td>-83.620494</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>538</th>\n",
|
||
" <td>Yucca Valley, CA</td>\n",
|
||
" <td>50</td>\n",
|
||
" <td>75</td>\n",
|
||
" <td>62.5</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>34.185894</td>\n",
|
||
" <td>-116.432416</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>539</th>\n",
|
||
" <td>Yuma, AZ</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>32.701461</td>\n",
|
||
" <td>-114.657232</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>540</th>\n",
|
||
" <td>Zebulon, GA</td>\n",
|
||
" <td>35</td>\n",
|
||
" <td>35</td>\n",
|
||
" <td>35.0</td>\n",
|
||
" <td>SPLCenter on twitter</td>\n",
|
||
" <td>35.879220</td>\n",
|
||
" <td>-78.355582</td>\n",
|
||
" </tr>\n",
|
||
" </tbody>\n",
|
||
"</table>\n",
|
||
"<p>541 rows × 7 columns</p>\n",
|
||
"</div>"
|
||
],
|
||
"text/plain": [
|
||
" location crowd-low-estimate crowd-high-estimate \\\n",
|
||
"0 Abilene, TX 200 200 \n",
|
||
"1 Accident, MD 54 54 \n",
|
||
"2 Adak, AK 10 10 \n",
|
||
"3 Adrian, MI 130 150 \n",
|
||
"4 Ajo, AZ 250 250 \n",
|
||
"5 Alameda, CA 8 8 \n",
|
||
"6 Alamosa, CO 350 350 \n",
|
||
"7 Albany, CA 500 500 \n",
|
||
"8 Albany, NY 7,000 9,000 \n",
|
||
"9 Alexandria, VA 17 17 \n",
|
||
"10 Albuquerque, NM 3,000 20,000 \n",
|
||
"11 Almanor West, CA 4 4 \n",
|
||
"12 Alpine, TX 96 96 \n",
|
||
"13 Amarillo, TX 600 600 \n",
|
||
"14 Amelia Island, FL 700 1,300 \n",
|
||
"15 Anacortes, WA NaN NaN \n",
|
||
"16 Anchorage, AK 2,000 3,000 \n",
|
||
"17 Ann Arbor, MI 11,000 11,000 \n",
|
||
"18 Annapolis, MD 1,600 1,600 \n",
|
||
"19 Arlington, VA NaN NaN \n",
|
||
"20 Asbury Park, NJ 6,000 6,000 \n",
|
||
"21 Asheville, NC 7,000 10,000 \n",
|
||
"22 Ashland, OR 6,000 8000 \n",
|
||
"23 Aspen, CO 1,000 1000 \n",
|
||
"24 Astoria, OR 100 1000 \n",
|
||
"25 Athens, GA 700 5000 \n",
|
||
"26 Atlanta, GA 60,000 63000 \n",
|
||
"27 Augusta, GA 600 600 \n",
|
||
"28 Augusta, ME 10,000 10000 \n",
|
||
"29 Austin, TX 30,000 50,000 \n",
|
||
".. ... ... ... \n",
|
||
"511 Watertown, NY 250 250 \n",
|
||
"512 Watsonville, CA 300 500 \n",
|
||
"513 Wausau, WI 200 200 \n",
|
||
"514 Welches, OR NaN NaN \n",
|
||
"515 Wellfleet, MA 113 113 \n",
|
||
"516 Wenatchee, WA 2,000 2,000 \n",
|
||
"517 West Chester, PA 150 200 \n",
|
||
"518 West Jefferson, NC 250 300 \n",
|
||
"519 West Lima, WI 1 1 \n",
|
||
"520 West Palm Beach, FL 5,000 7000 \n",
|
||
"521 Westfield, NJ 1,000 2,000 \n",
|
||
"522 Wichita, KS 3000 3000 \n",
|
||
"523 Wichita Falls, TX 150 150 \n",
|
||
"524 Williamsburg, VA 700 1000 \n",
|
||
"525 Willits, CA 50 50 \n",
|
||
"526 Wilmington, NC 3000 3000 \n",
|
||
"527 Wilton, NH 100 125 \n",
|
||
"528 Winchester, VA 700 1200 \n",
|
||
"529 Winston-Salem, NC NaN NaN \n",
|
||
"530 Winters, CA 200 200 \n",
|
||
"531 Woodstock, NY 1000 1000 \n",
|
||
"532 Woodstock, VA 400 400 \n",
|
||
"533 Wooster, OH 500 1000 \n",
|
||
"534 Worcester, MA NaN NaN \n",
|
||
"535 Wyckoff, NJ 300 500 \n",
|
||
"536 Yakima, WA 1000 1000 \n",
|
||
"537 Ypsilanti, MI 1200 1200 \n",
|
||
"538 Yucca Valley, CA 50 75 \n",
|
||
"539 Yuma, AZ NaN NaN \n",
|
||
"540 Zebulon, GA 35 35 \n",
|
||
"\n",
|
||
" mean-high-low source \\\n",
|
||
"0 200.0 http://www.reporternews.com/story/news/local/2... \n",
|
||
"1 54.0 Twitter; on-site witness \n",
|
||
"2 10.0 adn.com \n",
|
||
"3 140.0 https://www.facebook.com/events/847360115406578/ \n",
|
||
"4 250.0 https://www.facebook.com/plugins/post.php?href... \n",
|
||
"5 8.0 FB \n",
|
||
"6 350.0 https://twitter.com/zepol/status/8232349739352... \n",
|
||
"7 500.0 https://twitter.com/ben_silverman/status/82303... \n",
|
||
"8 8000.0 http://www.timesunion.com/local/article/Albany... \n",
|
||
"9 17.0 https://twitter.com/TinaPStacy/status/82322604... \n",
|
||
"10 11500.0 http://www.koat.com/article/thousands-fill-civ... \n",
|
||
"11 4.0 eyewitness; picture \n",
|
||
"12 96.0 https://twitter.com/sarahmvasquez/status/82318... \n",
|
||
"13 600.0 https://www.texastribune.org/2017/01/21/thousa... \n",
|
||
"14 1000.0 http://www.firstcoastnews.com/news/womens-marc... \n",
|
||
"15 NaN http://www.goskagit.com/skagit/hundreds-partic... \n",
|
||
"16 2500.0 https://www.adn.com/alaska-news/2017/01/21/lar... \n",
|
||
"17 11000.0 http://www.mlive.com/news/ann-arbor/index.ssf/... \n",
|
||
"18 1600.0 http://www.capitalgazette.com/news/annapolis/p... \n",
|
||
"19 NaN NaN \n",
|
||
"20 6000.0 https://twitter.com/JuliaJHobbs/status/8229551... \n",
|
||
"21 8500.0 http://wlos.com/news/local/photo-gallery-the-w... \n",
|
||
"22 7000.0 http://www.mailtribune.com/news/20170121/voice... \n",
|
||
"23 1000.0 https://twitter.com/SarahGoTrillIum/status/823... \n",
|
||
"24 550.0 http://www.dailyastorian.com/Local_News/201701... \n",
|
||
"25 2850.0 http://onlineathens.com/slideshow/2017-01-21/p... \n",
|
||
"26 61500.0 http://www.ajc.com/news/state--regional-govt--... \n",
|
||
"27 600.0 http://chronicle.augusta.com/news/2017-01-21/h... \n",
|
||
"28 10000.0 http://bangordailynews.com/2017/01/21/news/sta... \n",
|
||
"29 40000.0 http://kut.org/post/tens-thousands-participate... \n",
|
||
".. ... ... \n",
|
||
"511 250.0 http://www.watertowndailytimes.com/news03/wate... \n",
|
||
"512 400.0 eyewitness \n",
|
||
"513 200.0 FB \n",
|
||
"514 NaN NaN \n",
|
||
"515 113.0 via email (JP) \n",
|
||
"516 2000.0 http://www.wenatcheeworld.com/news/2017/jan/21... \n",
|
||
"517 175.0 https://wcborodems.org/2017/01/21/in-solidarit... \n",
|
||
"518 275.0 https://twitter.com/wineymomof2/status/8229288... \n",
|
||
"519 1.0 Twitter \n",
|
||
"520 6000.0 http://www.palmbeachpost.com/news/local/thousa... \n",
|
||
"521 1500.0 https://www.tapinto.net/towns/westfield/articl... \n",
|
||
"522 3000.0 http://www.kansas.com/news/local/article127951... \n",
|
||
"523 150.0 http://www.timesrecordnews.com/story/news/loca... \n",
|
||
"524 850.0 http://wydaily.com/2017/01/21/womens-march-in-... \n",
|
||
"525 50.0 FB \n",
|
||
"526 3000.0 http://www.twcnews.com/nc/coastal/news/2017/01... \n",
|
||
"527 112.5 onsite eyewitness who did headcount (via googl... \n",
|
||
"528 950.0 onsite eyewitness & local news (via google form) \n",
|
||
"529 NaN NaN \n",
|
||
"530 200.0 FB \n",
|
||
"531 1000.0 FB \n",
|
||
"532 400.0 http://www.nvdaily.com/uncategorized/2017/01/w... \n",
|
||
"533 750.0 http://www.the-daily-record.com/local%20news/2... \n",
|
||
"534 NaN http://www.telegram.com/news/20170121/central-... \n",
|
||
"535 400.0 http://www.northjersey.com/story/news/local/20... \n",
|
||
"536 1000.0 http://www.yakimaherald.com/news/local/hundred... \n",
|
||
"537 1200.0 https://twitter.com/theplaidjunct/status/82298... \n",
|
||
"538 62.5 NaN \n",
|
||
"539 NaN NaN \n",
|
||
"540 35.0 SPLCenter on twitter \n",
|
||
"\n",
|
||
" Latitude Longitude \n",
|
||
"0 32.576489 -99.665323 \n",
|
||
"1 39.628700 -79.319760 \n",
|
||
"2 0.000000 0.000000 \n",
|
||
"3 41.889943 -84.065892 \n",
|
||
"4 32.384890 -112.890110 \n",
|
||
"5 37.770563 -122.264779 \n",
|
||
"6 37.479933 -105.790967 \n",
|
||
"7 42.614852 -73.970812 \n",
|
||
"8 42.614852 -73.970812 \n",
|
||
"9 38.819853 -77.059645 \n",
|
||
"10 35.199592 -106.644831 \n",
|
||
"11 44.984663 -93.542233 \n",
|
||
"12 32.810624 -116.710667 \n",
|
||
"13 35.206030 -101.839602 \n",
|
||
"14 42.271790 -88.188464 \n",
|
||
"15 48.499172 -122.607111 \n",
|
||
"16 61.220018 -149.855702 \n",
|
||
"17 42.266638 -83.849042 \n",
|
||
"18 38.987750 -76.552800 \n",
|
||
"19 32.635563 -97.148829 \n",
|
||
"20 40.250725 -74.048582 \n",
|
||
"21 35.602711 -82.567281 \n",
|
||
"22 38.473824 -82.647933 \n",
|
||
"23 39.169324 -106.776744 \n",
|
||
"24 46.142206 -123.795996 \n",
|
||
"25 40.605382 -73.755133 \n",
|
||
"26 33.844371 -84.474050 \n",
|
||
"27 44.351642 -69.803773 \n",
|
||
"28 44.351642 -69.803773 \n",
|
||
"29 30.326374 -97.771258 \n",
|
||
".. ... ... \n",
|
||
"511 43.968892 -75.906501 \n",
|
||
"512 36.980250 -121.746960 \n",
|
||
"513 44.963304 -89.704051 \n",
|
||
"514 45.327305 -121.973561 \n",
|
||
"515 40.762172 -100.760429 \n",
|
||
"516 47.573816 -120.351884 \n",
|
||
"517 39.980107 -75.610503 \n",
|
||
"518 39.948860 -83.309892 \n",
|
||
"519 42.078130 -76.845236 \n",
|
||
"520 40.224597 -111.669615 \n",
|
||
"521 40.691613 -112.001050 \n",
|
||
"522 37.651974 -97.258997 \n",
|
||
"523 33.905544 -98.479881 \n",
|
||
"524 37.310451 -76.746769 \n",
|
||
"525 39.525958 -123.365730 \n",
|
||
"526 34.271985 -77.963628 \n",
|
||
"527 43.073715 -73.740236 \n",
|
||
"528 36.131662 -115.168382 \n",
|
||
"529 36.111102 -80.200493 \n",
|
||
"530 28.686894 -81.273258 \n",
|
||
"531 42.320271 -88.462832 \n",
|
||
"532 42.320271 -88.462832 \n",
|
||
"533 40.830699 -81.895377 \n",
|
||
"534 42.265275 -71.879415 \n",
|
||
"535 45.341881 -117.872662 \n",
|
||
"536 46.722625 -120.406039 \n",
|
||
"537 42.202139 -83.620494 \n",
|
||
"538 34.185894 -116.432416 \n",
|
||
"539 32.701461 -114.657232 \n",
|
||
"540 35.879220 -78.355582 \n",
|
||
"\n",
|
||
"[541 rows x 7 columns]"
|
||
]
|
||
},
|
||
"execution_count": 4,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"df"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"## Top locations"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 18,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"<matplotlib.axes._subplots.AxesSubplot at 0xb5c7898>"
|
||
]
|
||
},
|
||
"execution_count": 18,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
},
|
||
{
|
||
"data": {
|
||
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAF7CAYAAAA9u5chAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xm87dX8x/HXufc2KDeFi6LS+E4iSimajEmI0GgqSRSF\nKOSnyJAhQpqUSBFRQqmIJBnSbPikkiRSaZSG2z2/Pz5rf+++p3uGe75rn2H3fj4e93H32ee7P/u7\n99n7+/mu9V3rswYGBwcxMzMDmDHZO2BmZlOHk4KZmTWcFMzMrOGkYGZmDScFMzNrOCmYmVlj1mTv\ngI1M0heAzcqPawN/Bf5Xft44Iv630Acu+vMsCZwBfCEiTiv3PRq4Efhz16bviIjzhzz2G8BFEfH5\nGvvSFfcVwDMj4iBJrwI2i4h31XyOIc+3Ovk6lu3Vc/QrSUcCN0TEwRVi9ezvLuk44LCIuKxGvH7k\npDDFRcQ7O7clXQfsHBEX1XwOSc8FvgysCXyh61cbA+dGxEtrPt8i2BB4JEBEnAqcOkn7YROrl3/3\nF7PgZ9yGcFKY5iRtDnwKWBK4H/hgRJwtaTfg1cBiwArADcAbIuJfCwnzTmA/4IAh9z8HmCPpAmAp\n4IiIOHo8+1N+dwDweuABIIBdgHnAkcDqwGOAO4AdgMcBuwEzJd0JXA+8LCJeKWklMomtBAwAX42I\nQ8uZ/hnAT4ANgGWB90fEKZKeChwDLFEec1REHLWQlzCznE0+s+z/XsBFwNXAbhHxs/Jajgd+FxGH\nd7321YEzgfOBZ5Pfr/cCewACfkMm9UFJmwCfLO/rg8CHI+IMSY9c2PsREVdL+iXwC2CT8tp/DuwS\nEQvMQJW0PHAUmeTnAYdHxOHl8TcBTwG+BPxwmPfxh8B3IuJrkjYtz7lyRFwv6UDyM/Up4FhgHeCf\n5XluGPpmShogP1evIrurrwXeHhH/kvRa4APA3PIevAcYZPi/+y+BXwMvID8fnwOeCGwKPALYLiL+\nUE5yPkF+BpcHzoyI3SV9sjzuZEk7A9cAhwFPLa/pHOB9EfHg0NfxcOJrCtOYpDnAt4E9I2JdYFfg\npHLQBHgusEdErA1cDiy0eycito+IHy/kVw8A3ye/dK8A9pP08vHsj6RtgZ2AZ0fEOuQB5G3A1sDN\nEbFRRKwBXFIe/yvgK8CJEfF/Q57qm8DZEfH0sm+7SHpN+d0awOkRsQF5MDqk3P8+4HsRsT7wMmAL\nSQv7/D8S+FFEPBM4CPgOMBM4AnhLeZ3LAi8FTljI41cHTomIp5IH00OB7ciD5wuADSQ9hjyg7hQR\n65EHzKMlPWm496Mr/pOBLYB1gZeQCWKoo4ArI2It8jOwp6RVyu9uiYi1I+LLI7yP3wO2Ktu/BPgX\n8MLy8yuA7wIHA3eSCWaH8v/C7AKsBWwYEc8gE3bnxOIzwFvK3+ogYPNR/u4AK5a/zXbAp8v+Pws4\nt+t92hv4QERsSHa5vkbSuhGxP/BvYPvS2j4MuLB8Jp5JJpC9h3kdDxtuKUxvGwN/7nQnRcQVkn4D\nbF5+/+OIuLrcPoY8yxqziDiw68e/SzoaeCXwg3Hsz8bAtyPi9vK75ssn6WpJ7yQPqJuRB9OFkrQM\n2b2wRYlzu6SvkwexS4H7gLPK5hcDjy63TwWOk7QxeWB6Z0TMW8hT3BIR3y2xz5C0BHnGfRzwwXJA\n3wk4LSLuXMjj742IM8rta4DFI+Lusu//LPvzBPIAdLqkzuPmAetExMmjvB8/KPt9h6Rrul5ftxeS\nrT8i4jbywEh5rvPH8D7uBxwiaSawJfAx4EWSzgGWjYiLJZ1InnAMAjdJOm0h+wGZgNcDLirPPxNY\nvPzuW8APSsvkHOCzw8To9r3y/zVkq+Lsrp83KrdfD7xU0gfJhLQkpTtqiK2B9SS9tfz8CPLz87Dm\nlsL0NpP8YnSbQTaFIZvl3fcvUrNY0t7l7LVjgGw9jGd/5nb/TtJyklaW9A7yzPFu4ESypTEwwnMs\n7DPb/Zrv7epOGezEKhfP1wROAZ4FXCnpyQuJNfQ9mgE8EBH/IRPLTmQL6Mhh9m/oQWVh79dM4IqI\neEbnH5k0fzqG96N7YMEgC3+vHmDB93o1SbPLj3d3va6hZgCLRcQtwB+Al5PdbSeQyeOVZCuho/u5\nuz9rQ1/rx7pe5waUk5aI2I9soVxMvqcXlO6mkXS/v/OGdvWUx19AJrM/AgeS3VsLizsLeFXXvm0E\n7DPK8/c9J4Xp7VfAOpKeBSDpaWR3wc/L719U+pcB3srwZ/jD2Yzs56WcIe9KHqTGsz8/IZvxnYPT\nR8mm+pbAcRFxHHAVeWY5s2wzl/kHeyDPaMmDyNvKcyxLnhmeM9ILkfRtYNuI+GZ57H+BJy1k08dL\nekl5zKuA28l+cIDDgXcD90fExSM93yh+Baxd+r6RtB752h/PyO/HWP2U7LZB0nJk18qq3RuM4X38\nHtkv/5OIuIMc9fZe5ieFM4HdJM0oo9SG61Y8C3hL19/9Y8BXJS0m6W9kEjoCeAfZopnFQv7ui+Ax\nwDOA/cpF6pWBVVj4Z+os4F2SBsroux+S138e1pwUprGIuAnYHjhC0hXkGd3rI6JzELuB7NP/E3lB\n7t2L+BRvB1aRdCV5IDssIs4dz/5ExOnl5wvL7x4NfIjsF95L0iXkAekistsE8uC2raSh10J2BF4i\n6XKyS+xbEbGw/v1uBwFvknRZecy3I+KXC9nun8COki4lE+JrOmejEfF74C6GbyWMSXmfXgN8ruzP\n8eT1hRsY+f0Yq7cDTy+xfwF8ZJghmCO9j6eSXS+dJHEWebz4Tfm509//Z/K60xXD7MuRZBfPryX9\ngbz2sGtEPEB+Hr8t6WLy+sYu5f7h/u6jKq2cTwOXSvo9sC/52e28h6cBp0h6PnkNYrmy75eRSXIs\nXVh9bcCls/tTGX30soh45WTvS7+QtAZ5wFozIu6d7P0x6wW3FMzGQNLHybPudzshWD9zS8HMzBpu\nKZiZWWNM8xQkvZ+ctLI4OQPyPPLi2CBwJTnZaJ6kD5Njf+cC+0TEb8ssz1bbVnqtZmY2ilFbCpK2\nIMsdPJccX7wiOUvzgIjYlBz/u00ZVrc5Ob1/B3L4Hm23rfAazcxsjMbSUtiSHLJ1KrAMOVb5LWRr\nAXK88ovJWjZnl4lD10uaVcoerN9y22GLYd18811jviCy3HJLcdtt94x180XSq9jTLW4vY0+3uL2M\nPd3i9jL2dIvby9iLEnfOnNnDThIcS1J4LDkB5GXkJJDTgRlds0bvAh5FJoxbux7XuX+g5bbDWm65\npZg1a+zzeubMmT36RuPUq9jTLW4vY0+3uL2MPd3i9jL2dIvby9g14o4lKdxK1rO5HwhJ95JdSB2z\nyVmfd5bbQ++f13LbYS1Ktp0zZzY333zXmLdfFL2KPd3i9jL2dIvby9jTLW4vY0+3uL2MvShxR0oe\nYxl99Ety1uOApBWApckaLVuU329FFtm6ANiyTHtfiWxN3AJc0nJbMzObIKO2FCLih5I2A35LJpE9\nyToox0haHPgTWSr4QUnnAxd2bQdZKmDc21Z6nWZmNgZjGpIaEe9byN2bL2S7A8mqhN33XdV2WzMz\nmxievGZmZg0nBTMzazgpmJlZw0nBzMwafblG866fHHYdmIc4bv/n93BPzMymF7cUzMys4aRgZmYN\nJwUzM2s4KZiZWcNJwczMGk4KZmbWcFIwM7OGk4KZmTWcFMzMrOGkYGZmDScFMzNrOCmYmVnDScHM\nzBpOCmZm1nBSMDOzhpOCmZk1nBTMzKzhpGBmZg0nBTMzazgpmJlZw0nBzMwaTgpmZtZwUjAzs8as\nsWwk6RLgjvLjX4GjgMOAucDZEXGQpBnAl4F1gfuA3SLiakkbtdm21gs1M7PRjZoUJC0JEBFbdN13\nKfBq4FrgR5LWA54MLBkRG5eD+2eBbYAj22wbERfXealmZjaasbQU1gWWknR22f5AYImIuAZA0lnA\nC4DlgR8DRMSvJT1L0jIVtnVSMDObIGNJCvcAnwG+AqwBnAnc3vX7u4BVgWWY38UE8GC5786W2w5r\nueWWYtasmWN4CcObM2d2q8fXjjPd4/Yy9nSL28vY0y1uL2NPt7i9jF0j7liSwlXA1RExCFwl6Q7g\n0V2/n00miaXK7Y4Z5EF+dstth3XbbfeMYfdHdvPNd7WOMWfO7CpxpnvcXsaebnF7GXu6xe1l7OkW\nt5exFyXuSMljLKOPdiX7/JG0AnlA/6+k1SQNAFsC5wMXAC8t220EXBERdwL3t9zWzMwmyFhaCscC\nx0v6JTBIJol5wInATHKU0G8k/Q54kaRfAQPALuXxe7TZtsaLNDOzsRk1KUTE/cBOC/nVRkO2m0ce\n1Ic+/tdttjUzs4njyWtmZtZwUjAzs4aTgpmZNZwUzMysMabaR5Z2/eS5Y972uP2f38M9MTPrDbcU\nzMys4aRgZmYNJwUzM2s4KZiZWcNJwczMGk4KZmbWcFIwM7OGk4KZmTU8eW2K8MQ4M5sK3FIwM7OG\nk4KZmTWcFMzMrOGkYGZmDScFMzNrOCmYmVnDScHMzBpOCmZm1nBSMDOzhpOCmZk1nBTMzKzhpGBm\nZg0nBTMzazgpmJlZY0ylsyU9Dvg98CJgLnA8MAhcCewZEfMkfRjYuvx+n4j4raTV225b64Wamdno\nRm0pSFoMOAr4X7nrUOCAiNgUGAC2kbQesDnwbGAH4PAa27Z/eWZmtijG0n30GeBI4Mby8/rAeeX2\nmcALgU2AsyNiMCKuB2ZJmlNhWzMzm0Ajdh9JehNwc0ScJen95e6BiBgst+8CHgUsA9za9dDO/W23\nHdFyyy3FrFkzR9tsRHPmzG71+ImOWyv2VN+/fojby9jTLW4vY0+3uL2MXSPuaNcUdgUGJb0QeAbw\ndeBxXb+fDdwO3FluD71/XsttR3TbbfeMtsmobr75rtYxJjJujdhz5szu2f71KvZ0i9vL2NMtbi9j\nT7e4vYy9KHFHSh4jdh9FxGYRsXlEbAFcCrwBOFPSFmWTrYDzgQuALSXNkLQSMCMibgEuabmtmZlN\noDGNPhriPcAxkhYH/gScEhEPSjofuJBMNHvW2Ha8L8rMzMZnzEmhtBY6Nl/I7w8EDhxy31VttzUz\ns4njyWtmZtZwUjAzs4aTgpmZNZwUzMys4aRgZmYNJwUzM2s4KZiZWcNJwczMGk4KZmbWcFIwM7OG\nk4KZmTWcFMzMrOGkYGZmDScFMzNrOCmYmVnDScHMzBpOCmZm1nBSMDOzhpOCmZk1nBTMzKzhpGBm\nZg0nBTMzazgpmJlZw0nBzMwaTgpmZtZwUjAzs4aTgpmZNZwUzMysMWu0DSTNBI4BBAwCewD3AseX\nn68E9oyIeZI+DGwNzAX2iYjfSlq97bb1Xq6ZmY1kLC2FlwNExHOBA4CPAYcCB0TEpsAAsI2k9YDN\ngWcDOwCHl8e32rb1KzQzszEbNSlExGnA7uXHlYHbgfWB88p9ZwIvBDYBzo6IwYi4HpglaU6Fbc3M\nbIKM2n0EEBFzJX0NeBXwGuBFETFYfn0X8ChgGeDWrod17h9oue2wlltuKWbNmjmWlzCsOXNmt3r8\nRMetFXuq718/xO1l7OkWt5exp1vcXsauEXdMSQEgIt4oaT/gN8Ajun41m2w93FluD71/Xstth3Xb\nbfeMdfeHdfPNd7WOMZFxa8SeM2d2z/avV7GnW9xexp5ucXsZe7rF7WXsRYk7UvIYtftI0uslvb/8\neA954L5I0hblvq2A84ELgC0lzZC0EjAjIm4BLmm5rZmZTZCxtBS+B3xV0i+AxYB9gD8Bx0havNw+\nJSIelHQ+cCGZbPYsj39Pm21rvEgzMxubUZNCRPwX2G4hv9p8IdseCBw45L6r2m5rZmYTw5PXzMys\n4aRgZmYNJwUzM2s4KZiZWcNJwczMGk4KZmbWcFIwM7OGk4KZmTWcFMzMrOGkYGZmDScFMzNrOCmY\nmVnDScHMzBpjXmTHpqddP3numLc9bv/n93BPzGw6cEvBzMwaTgpmZtZwUjAzs4aTgpmZNZwUzMys\n4aRgZmYNJwUzM2s4KZiZWcNJwczMGk4KZmbWcFIwM7OGk4KZmTWcFMzMrOGkYGZmjRFLZ0taDDgO\neDKwBHAw8EfgeGAQuBLYMyLmSfowsDUwF9gnIn4rafW221Z9tWZmNqLRWgqvA26NiE2BrYAvAYcC\nB5T7BoBtJK0HbA48G9gBOLw8vtW2dV6imZmN1WhJ4TvAh7p+ngusD5xXfj4TeCGwCXB2RAxGxPXA\nLElzKmxrZmYTaMTuo4i4G0DSbOAU4ADgMxExWDa5C3gUsAxwa9dDO/cPtNx2RMsttxSzZs0cbbMR\nzZkzu9XjJzpuL2MvStyXv+f7Y972B5+t0+ibCq97qsSebnF7GXu6xe1l7BpxR12OU9KKwKnAlyPi\nJEmf6vr1bOB24M5ye+j981puO6LbbrtntE1GdfPNd7WOMZFxexl7KsedM2d2T/avV3F7GXu6xe1l\n7OkWt5exFyXuSMljxO4jSY8Hzgb2i4jjyt2XSNqi3N4KOB+4ANhS0gxJKwEzIuKWCtuamdkEGq2l\n8AFgOeBDkjrXFvYGviBpceBPwCkR8aCk84ELyUSzZ9n2PcAx4922yis0M7MxG+2awt5kEhhq84Vs\neyBw4JD7rmq7rZmZTRxPXjMzs4aTgpmZNZwUzMys4aRgZmaNUecpmE20XT957pi3PW7/5/dwT8we\nftxSMDOzhpOCmZk1nBTMzKzhpGBmZg0nBTMzazgpmJlZw0nBzMwaTgpmZtZwUjAzs4ZnNNvDhmdK\nm43OLQUzM2s4KZiZWcNJwczMGk4KZmbWcFIwM7OGk4KZmTWcFMzMrOF5CmYtef6D9RO3FMzMrOGk\nYGZmDScFMzNrOCmYmVnDScHMzBpjGn0k6dnAIRGxhaTVgeOBQeBKYM+ImCfpw8DWwFxgn4j4bY1t\n671UMzMbzagtBUnvA74CLFnuOhQ4ICI2BQaAbSStB2wOPBvYATi8xrbtX56ZmS2KsXQfXQNs2/Xz\n+sB55faZwAuBTYCzI2IwIq4HZkmaU2FbMzObQKN2H0XEdyU9ueuugYgYLLfvAh4FLAPc2rVN5/62\n245oueWWYtasmaNtNqI5c2a3evxEx+1l7OkWt5exp3rcqb5/Exl7usXtZewaccczo7m7n382cDtw\nZ7k99P62247ottvuWZT9Xqibb76rdYyJjNvL2NMtbi9jT+W4c+bM7sn+9SpuL2NPt7i9jL0ocUdK\nHuNJCpdI2iIifg5sBfwMuBr4lKTPAE8CZkTELZLabmv2sLUo5TPAJTSsjvEkhfcAx0haHPgTcEpE\nPCjpfOBC8jrFnjW2He+LMjOz8RlTUoiI64CNyu2ryNFDQ7c5EDhwyH2ttzUzs4njKqlmD0O9quzq\nirHTn2c0m5lZwy0FM5vyfNF94rilYGZmDScFMzNrOCmYmVnDScHMzBpOCmZm1nBSMDOzhoekmtnD\nmifcLcgtBTMzazgpmJlZw0nBzMwavqZgZtYD0/VahVsKZmbWcFIwM7OGk4KZmTV8TcHMbBrpdRlx\ntxTMzKzhpGBmZg0nBTMzazgpmJlZw0nBzMwaTgpmZtZwUjAzs4aTgpmZNZwUzMys4aRgZmaNKVXm\nQtIM4MvAusB9wG4RcfXk7pWZ2cPHVGspvBJYMiI2BvYHPjvJ+2Nm9rAy1ZLCJsCPASLi18CzJnd3\nzMweXgYGBwcnex8akr4CfDciziw/Xw+sGhFzJ3fPzMweHqZaS+FOYHbXzzOcEMzMJs5USwoXAC8F\nkLQRcMXk7o6Z2cPLlBp9BJwKvEjSr4ABYJdJ3h8zs4eVKXVNwczMJtdU6z4yM7NJ5KRgZmYNJwUz\nM2s4KbQkaZakHSrE2bLG/izC8y01kc/3cCTpMZL2n+z96GeS1pF0ZI9ib9SjuE+sEGOhx25Jj20b\ne6qNPqpC0jLAkcBbI+IuSTsC2wBviYi7Kj3H8sAewJuBS4FvtQx5kKSXAu+NiPvb7t8Y/BzYsG0Q\nSfsCbwUeAdwPfDkiPtM27pDnmA28CXhbRKxdOfbLgT0j4iUVY24A7AVsCZzSMtZfgc5okIGu20TE\nqi3iLj7c72p8/iStB9wREdeUn5cEDoqI/SrEnglsS77Hjwe+0jZmV+wlgJ1K7CWAdSrGfl6J+1zg\nCS3DnSNpx4j4d1f85wPHAqu0CdyXSYFMCL8F7i4/fwd4InAE8Lo2gSVtTv5hnwnMAzaOiL+3iVk8\nB3gfcIGkXSLiygoxRzLQNoCkfYA1gfVK8l0G+Jyk90bEpyvEX5t8r7cDvgu8sW3MEvfRwG7A7sA1\nVDiolIPsjsCeZDHHZYBVIuJ/LUOvNeTnrYDPlX9tBJlgOp+Dzu1BYNzJBkDSF8nvx6MkHQz8hUyO\n57SM+wTyBOT1wIXAEhEx9P0Zb+wnk3+77cn3YfuI+FWFuEtTTmjIRPAOMum0dQhwrqQ9gfOBj5K1\n47ZtG7hfk8KKEdG88WVW9GckXdgmqKTfA38CjgLOBX5UKSEQEfOAT0r6EfnHvpryJY2I59R4jiFq\njEV+DbBZ2Xci4k5JewC/AMadFCS9mvyCLg58FVBEvLXtzkpan0wyzwG+DdwQEbW67a4DvgnsHBF/\nkXRmhYRARNwHTXff54CnAVtGxFUtQ68aEb0aj/7ciFhP0qOAnwJLk630n7aMezXwBeCZ5STkzLY7\nCiDp+8BywNfJlsHJlRLCF4Hnk/OvXgl8MSK+2TYuQEScLWkr8jO3LPArYIOIuKdt7H5NCvOGub9t\ns/i35AFlK+Af1DmwNkrz73Dgi+QHtEbMT/DQ/RwgW05t3d9JCB0R8YCkB1rG/TrweeDQiLi1JIka\nfgV8BnhaRNwv6YxKcQEOI88An1xqeLVuiXVI2gw4Gvga2YU23Od7Ufxd0nlkAcqzurshKrgDICLu\nKF1/W0bEdRXivrn8O1fSceRJQw0DwANkF+gM6n2vNwF+D/wGuLZi3I6NgOXJz/VqwKOA1kmhXy80\n/0XSNt13SHoF8M82QSPibeQf4nLyS7qxpLeV7ohWJB1BHgh3ioiPRsTfOv9ahv4z2VXQ/e/PwAda\nxgUYlPS47jskPZ7hk/JYrQ78Fzhf0slA64tnxWbAHOAPkg4BHlkpLhFxSESsS57J7gRsIOkQSa36\npCV9lrxe9SGyC211SWtKWrPlLq8GHFP+/5akCyR9TNKmLePCgge/GyslBCLi5Ih4MfBaYAVgVUkn\nS3pZy7ivILsmH00ewNeV9JLhLuYuQtxnkl3Z25LfuzUl1eruOgZ4J/C8iHg9+bk7T9LWbWP35Yxm\nScuSzarHA38FVgRuBl4fEf+p+DxrkX3T20fEii1jfQb4QO2LzL28oFgunH0a+DjZN78K8EHydbTq\nP+56jhcAbwGeTVbQ3bdCzKWBHci/3QzghIj4Utu4Q55jWfL61ZvLwWG8cX42zK8GI+L544075Dke\nC2wB7A2sFRFzWsb7G3AieQa+U7kNQETUOBnpPM8MslbaWyJim9G2H2PMAXKAwG7AhhGxUqW4symf\nB4CIaLUsgKSPAgdGxINd961Cdn21GkDSl91HEXE7sJWklcgziusj4sYasSWtFRF/Lj/eDxwPvL9C\n6NOBjSQ95BcR8YsWcTsXFLtVuaAYET+T9Ebmj8K6Adg9Ii5pE3fIc/wU+Kmkx5AXGGvE/C85SuNY\nSU8jDwCtSXoxcE7pq18JuLpNQgCIiOfV2LehyuigrSkFKIGzgPeSXaRt/d8wt1uTtDtwXLlO+Fzg\nSbUSQrE88EfgXcC9bYOVwRdzy6jHI4AjJD2jbVzg2u6EABARf5X03LaB+zIpAJRm1PZk18MNkr4Z\nEcOddY015quBj0vaMCLuIEcTfBXYDzit5S6/bcjPg+RFqiXIi2DjEhGthqeNwT8j4h3QdB09OMr2\noyr9xdVJugFYoB89Iq4gz5Dbxn4b80fFdIY9f1jSShFxdIu45w73u5Ythd+RF9t3rNW90xERXytn\n3JsBKwPXA+e1vbAt6UDyQvA3gLnA34F3SZoTER9tEXdt4Evl/TwXuI285rYP8L0WcfcC3gPMlfSO\niOgsIHbpeGN2eT157FlARLS9ntefSaEM09qKvPh3E/nB/KCkNdp8QYF9ySGonQtpvyp9sKfTMilE\nxI6d2+UaxZfJ0uG7tonbS2V47tclPSMibgOeDnxF0s4R8csWoZ8FLEV++TsVc2tYDdiY7Cr5VhmT\n/nPgzJb7CznscPOIuBcgIi6X9CLgZ+T1p/G6m7zG8m3yM9Z6RFOxCfkdOVHS3WSiPLOrFTxu5eTg\nh+Roob8CLwcOlbR1RLS5rrcVsFEnuUTEdZK2Jz8j404K5PDO95Xb/4yI50lanRyqPO6kQHadiRye\nfAJlVclKlpa0Bgv5brQdmdaXSQHYGdi0q3l1uaSzgbNp9wW9d+g1iYj4t6TWzcwO5QS2zwOHRcTh\nteL2yMHkgfA2gIg4pxwIjwXGfcEyIp5eLtC+jlyr+xfANyLi6jY7W4Z3/hz4+ZB+9N3JC9Bt3NNJ\nCF3Pd7ekVpMlI+IVkpYjW72fIAdLnEQO9WwT90KyVfN/ZbDAS4CjJT0pWkyKKz4L7N89BFXSS8gh\ntW1m/989tLVRRru1nZC6VERcVG53TviultT2+HhvuW53y0jX9sZpTXJo/NCk0OlhGLd+TQr3L6S/\n7T5JbVdxG5T0iO7x52X8+GIt4yLpkeSX5inAVlFmgk5xc4d2PUTEVZJaD5mMnLy3PzRDMj8hacWI\nGHfpgR73oz8g6bERcUvX8z2WCt+xknSPBI6UtDLwKXJ46riHFZfunWeQyXszYA1yVF2N2cErDp2T\nEBE/lvShlnH/J2nViLi2c4ekVWk/1PMRnRsR8cqu+1t3xXSpNkS5uLTWQIOh+jUpDHdQavuH+QJw\nhqTPk+OOVyQPKjVGrlxBfji/Dry5+4JzzREbHZL2I9+Pz8T4lzydIWlG97h5ZQmCKmdF5SLdq8iZ\nwkuT3Ult9KwfHfgIcLakr5GfjZXIi+/vG/FRY6T8QOwIvIIcPNB2Mt+NwCXAT8jyEzVXOWx9XWkY\n+wGnSfq+2JF6AAAgAElEQVQp89/jLWk/0/0f5Tphc3IgaUPgXy3jPlXSSeT3rHMbgOiaXDvV9GtS\nWF+5elu3AfIsfNwi4jRJN5FDJFcgZ7G+PyJ+3SZucWCFGIviUuBi8iL2zeOM8Q3gm5I+zvwk+SHg\n5DY7Jum15AFwJbJPd49KB/Ge9aNHxC/LQITXk62RvwGvajvPRNJ7yZnj/yaHWW8SFWatAivXHv7c\n5XpJL4uIH3buKAM/rmsTNCL+UK7hbUN+/y4GPhLt65m9Dzi9JJuryVF5LyCvhbSxXdft2kX7Xls5\nXqNf5ymsPNzv2n5JpzNJTwXWBv5SaQQE5ULfW5mfJL8aEW2Twjxygt1l5a7uInBVzrC6+tF3I4c1\ntu1H74nyXlwDdLqlut+LXpQ/aa10m30PuJ3581ceD7y8u3ttKpH0CDIJrEKOavp+Gbr8sNOXScEe\nStI7ydEQv6bU/onK1UxrKaOaFioizmsRd7h+9HMiokpZkdqm8wmOstbUqsA/okItIZsYTgoPE8pi\ngJtGxFxJiwG/iogNJnu/JpKkfzK/H/2cyv3ofaG0oO6KCsX8bHrq12sKE6qXXyRJTyeH4l076sYj\nG+hcUI46Reumo172oy9Uxb/fRDkMuEbSkRFxw2TvzFiUmeT3R8TPJ3tfxqKX+6ssi3IpOYDkH+OJ\n0dcthTKdfHdgyc59EVF9Mpikb5J9p9W/SJI+R178+n6b2MrCaiuTtdc3Bf4aEe+ts5c2nFp/Pxte\nGUn3B3KYZrX3uFcH717tby39nhQuJYeLNmseRMRZk7dHi07Scp3JYRVibU2OwPpjRNQsGz30eVqf\nrQwTd1qdEfaSsubUQEQc3zLOiuRIr+4Tp4+027thn6vKPk+UqX7whqbQ3lYs+PdrdX2s37uP/hUR\n1Zbq6yhdAkuT8yE+Dnx86GSdFrG/GPNrCW1Jrq3QtkwykroLkz1L0rpksjy5bb0USY/qlP6A3hVx\nI1fz+kOZdVvzjLBa91/5bBxLDs/9J7BrVCwQOMTvJa0Q7Yo9foe8xlJlsagxGPc+l5ONhZ7F9mIi\nV0QcUiOOsmz/XuTxdgB4bEQ8rUZs4PvknJPO36/1WX6/J4XrlAunX0J5syLi7ApxjyT/yAeRpaI/\nRcuyA13ulPRJstb/OuSwyRrWJevmnE+uCdE5aG1J++qjPyLnAPRUrS/pQtTsRz8M2C0iLivdl4eT\n1TyrKTO7v1Yp3F0RcUClWCOqsM97lP8/TNaBuoBcZ7zVegodPTx4H0wO296DrIX1wgoxO2ZERKsl\nhofq96SwBFmQqjM9eJCsf9TWvWSzcvGI+LWkajM4I+KDkj4NrB4RW9SKCywbEZ0VzI6SdHZEvF5S\n20JwAP+RtDc507azNGfr97nUUXo3+XekxO3FGeGOo281ZjMi4rIS99IKpVWAZhLb7eTSi7tI+nFE\nvLtC6Csl7cCCJ06tCqpJ+isLnrE+QJaCuTci1h5v3IiIEv/xEfHtcvepkt4x7p1dUK8O3v+MiAsl\n7RERx0t6U6W4kHXdnk1213b+fq0GU/R1UoiIXZSF1dYGrqo1YYt8879OlrzYjgo1Uspwyc4XaQB4\nvKQbASJihbbxgWU7tXmUaxM8qgxNXapC7FvJ8f+dOvG1ku/nyPLFVbs2JD2RrIw5h1xQ/vKI+E2l\n8A8oVwI7n5wLcV+luNsCm5OzsJ9KvZZp998NKhRUA9YiP8OHA0dFxG8lPRN4e8u4DUlvZv7yuLVG\nlPXq4H2fsn7XYqVLuNZKgpCfie6Z163XSenrpFDOIHYil9jbV1KtCVvbk6synaFcfaxN5UcAImJ5\nyHWaI2LYGvotfBj4jaQ7ya6pd5C13o9tG7gk3zXJ0tRXkH2cNVwfET+pFKvb0WQlzw+RFVi/Rnap\n1fBmch3oT5KLtbylUtxBcv2OmyJiUFmIsbXIMtGPIf9219aYcRxZjRZJq3XqCUXEJaV+Uw07k922\n25Et9p0rxe3VwfttZKI8mCzxfXCluEQuAVtVXycFMiEsMGGL/MK2dR/wnFLr5kfk2q61lvk8kFzo\no6qI+KFyofo5wL8jSxBXqe+uXEzkVeT7cDw5U3ivCqH/LelIFuzaaFP6vGPJiDhX0gEREapY+pxc\n/+DoyDLie1FKMVfwM7Ls9+vKMNcf1Qha6kwdDPwJWEfSgRHRtvBgx+3KZSM7Z/St1kjviIh/lbid\nETdLk63VtoYevNus0UDXgIilmd/arbFKI5K+FBF7lUmpQ8uJtyp/0u9JoVcTto4DziSbbseWf8OW\nZlhEg5JOZcH++dZVUstFtD3Jvt2B0pVUawTEDuTch3Mj4jBJv6sU96/l/ydUitdxXzkTnClpIyos\nu9jlW+TFZsgThW9Q4UJoRHyQPDtG0u/ajhjr8m5g/ci1H2aTJyS1ksLOZP/8y8gz+gNrBJX0ZXIY\n5j+Zv7RsjTpQu0RE5yz+1ZI+Qbviju8u/44acn+NLrpOwnoDC3afPbpl3L5PChdIOoXs392EHK1Q\nw2Mi4jhJr4tcfa1mrfSeLEVJj0dAlP87ZyxV+tEj4qAyt+Kp+WN8v0ZcckLjZ8jugX156FKobSwd\npTpoRJwkqdX6z8OdEUqqVRBvXkTcDRARd1VuNd1Dfvc6JwnPJrvr2toQWC26Sra3Ua5P7AY8RbnI\nFeRnenFanNl3BgL0aIj2QOmy/To5enCA3OejyPdn3Po6KUTEe7ombB0fEVWa3ACS1ir/P4m69eNP\nJA/eawNXkYt919DLERDfJL/sK5cuqrbrVQNQztTWAH4JvFHSphGxb4t4nXUe/k2eYfXC/WXU1K/J\nL2fbA1fnjLD1dathXKOc7f4L8sJ4zcWdvkt2V/6d+Wf0NZLC1WTXUY0S4pAto58CHwA+Vu6bR35O\nWitzhPYi15UGqgwe2YhcNVDMX4FtHrlwVCt9mRSUC73MJJvy2wPnkF0F51Ya0rg3uWj2U8jRK9VG\nVZB/4NvJfd6cXAmrxgGslyMgjiAnQK1DntFfXinuZhHxXABJh5EH2jaCh07u6RysapXO3o1shXyB\nvNDcdjGcvUe4Pltj8aVdyX18Ebm/+1eI2fGESq2ZoVYC/iapszzrYJvnKRfGr5O0B7k+eOdaxSrU\nSWIvJ+tuVauNFhGnkQsOvbR2dYK+TArkB/0DZF90kF/8B8kzztYiq2tuXCPWQqwREZuV26fpoYsF\njdfbyLOK6iMgyBFHPwC+0naM+xCLaf7Kbp2D97hFxCoAkjaIiOa6h6QtWu3lgs9xdRmAMEB+RtoO\np432ezWiJchZsd9l/uJRtUpy/7nCjOuFqTmvpNspwONYcHZwjaTwb+ou7dntfuX61zPI6gcfioiT\nRnnMiPoyKUTEMcAxknaNiGp99EPmEnQMkGcqNeYSACwpaamIuEe58MfMWnGBx5dRN3+h/Vl3t3XJ\nZSIPlbQkudDOiRXinkxeF/o12R/ddvGeTchuuXdLOrTcPYNs2q/TJnbXc3yeHMmzMrAecBMtlovs\nzAJWLiLfi27FU0qs15AthaPJWe41bEKuwtZZ2a/W92QxcuWxxcjv3wq0b5FB5ZaNslDmILnA0CWS\nriy/Gox6y3F+jBxl2Zk5/23ASWEEm5YDQccD5FnA4TGOInOduQQ9dhhwWfkArU3OL6jh6+S8BMjh\njMeSSw62VmZQniLpX+RkswPIayNtHUb2ka5F7m/bEhS3A8uTZ8edv+U8Kq2jXGwQEftI+lmZA1Br\nklmvuhWXIlt5+0TEGyRVG4AQEa1rdg3jJOBUMuncSM67qaF2y6b2EpwLcw954jG3DNV17aNRLEle\nOOvU+9mAbMp9jTyzHRflspZHkiUHTgSujK71aMcZc6mIuCciTpR0JtnH/deIqDH+GoAoa0lHxPmS\nZoy2/ViVC2nbkWvmfiEiWjW5JT0BWIb5IysuJ8/oz6bFyIqIuJIs63BtRJzQ9XzbjfCwRTVD0npk\nH/XiwOxKcXvVrbg4eY3s95LWJsfUV1GG++5C1xl9RNRohdwdEZ+QtEZE7Crp/AoxoXLLJsoqgcqC\nix8kC1v+gfkXs2u4i5xvdLSkPalwcbzfk8KcmF/X5ixlvZ8PSWrbT/gF8sN+DHkGeybQKikAF0l6\nQ0RcFBH/od5kuI7bJe0OXEgeWNsudt7tNnJB+dsrxevJyApl+YnnAjtKekq5ewa5EPy3h33gojmB\n7I7ZlSyUOHSM+nj1qlvxPcAryQPVzuT7XssR5HvwGvK60+Ijbz5mg+XEYbakpanUUuhhy+bk8u84\n8vN3ApWK+JHdaKtFxB+VJX2OaRuw35PCMpLWiog/lyGks8uU/tYfonJBcTAibpZU4wC7M3kd5FSy\nFHfthS7eRJ6tvIrsO6652ND3gd3L9QSgXU3+Ho6suAx4DFkttnMBdx45Sq2KiPgy8OXy4z614lK5\nW7Frtu0tZFfU48iuqZpuiYhvSnpxRBwoadzraw9xEPk5PoGc4Fhlfe0etmyIiE5X0mWVW6b7Qc5b\n6dJqPYx+Twp7ASdKWgG4npzRuz3tm2//kfRWYGllhcnWZ8ilNszG5B/5rDLprvO7cZd26PryL8f8\ngxXkzMfWdW6Kb9ObmvxVR1ZExN+Br0k6oXvik6TW14oknRIRr9FDCxtWubja1a24Ctmt2LYl+R7g\nXfRmtm3HvNLVupTyqNV6ti1A6Z7stPYfVyNm0auWzZ8l7UxOGl0fuLVMPGtdkZa8ngD5WVuP+RNJ\nx62vk0JkMa71h9x9UYXQbyaHvN5Cjmt+c4WYkH/Qpcg5BJ0DVdsWQy+n2nf0qiZ/9ZEVxYclvZ38\n0i9FjuZ5apuAEfGa8v/ykpaOiP/WvGgp6TlkUn8CcIOk3aJF1d+IeFf5v1cLIkF+7p5KdreeRMvZ\n+l0J9yHDkyuNaupVy2at8q97dvtRVPgORsQC3+ty4tBKXycFSW8gJ+N0d2vUmKT0DOCM8q88lf4e\n7dZQ3pi8PvEjYOMyoaa1Hk+176hek7+oPrKi2AZ4Elma+1AWbEG1Ui66L0meNBwm6aKoszjQF4Gd\nuvqOj6ZFvR/1aM2DErtzhv2X8g8qzOsZbvSfpCotEHrXsunZd6/T4ihWIBfPaqWvkwLZFfMK6ndr\nHEyesf2eXCLyfvJC4DER8elxxvw68Oa2I3eGo95Mte/oRU1+gDupPLKi+GdE3Cdpdrk2VKubAGCb\niFgfICJeK+kCcu2Gtm6PiD+WuFdKalvioZdrHvR05rgWXLL2xeQ67DUuEveqZdOt9rymTosDcoJu\n62KG/Z4Uro2Iq0ffbJHdAzw9Iu6VtAQ5G3Rbsp9zvEnhmVEKk/VI9an2HWU8/qPICVvXVnwd2zF/\nZMVTyQuiNdwgaVfgv8r6SstWigt5trl4RNyvLNdea+jvvyV9haxiuj459HV3GN81p+jhmgcTMHO8\n6pK1E92yqal89zYkT/heTIUZ8P2eFO4pfWzdS9XVqBczJyLuLfHuU5ahvr/N2P8eJwTo4VR7ZVmH\nA8jP07fLqKwaZTTmAAeV8fNXkRdGr6sQ961k99F3yFFZtWaXQs5fuVLSFeTZ+Kcqxf1z+X8NsgV1\nHnndqW2XWvU1D9TjmeNRf8naXrdsejGvaXGy3MfbyZ6KZYBVapz09XtSqFooqstpyrWNf0tOiDtd\n0tuAK0d+2MTTxEy1fzc5t+DHZNfaRdSprXQMOSLkF8AW1JuFvTRZPnt58hpOreUciYhjJZ1OHkyu\niQormZW4B5VRUt3DJS+sEHromgc1ZtD3ZOb4QkZ2VVmydgJaNr2Y13QdWZ34dRHxF0ln1uoF6Muk\nIOlZEXERlVZ6GioiPirp+2SV1ONKH+8cKkxrl/Rj4HvAaRFRow99IqbazystpsHIpSL/WynukhFx\nerl9mqQaC9VDDxdJkvQMMuEsWX4mIlrPCZF0LNmlsTTwCOBa6iwheh+5IuHvyAPtq8mDzbh1zRwf\nbDNfZSFxe9Id0+uWDfRkXtNhZAv3yaVbsdqaLtVKHUwxnbPJHYf8q1KTXtKKZD+mgG0l/V9E3Fxp\nwtmbydmqx0o6W9I72wQrU+0FXFBuzwOe0pmCX8n5pUXyJOXymbVWXpsl6WkA5f9ao48eE1ko8YGI\n+BUVv1DkcqQXM38Wa6sifl3WJS+CnkUewGothnMq2To4nGyV1RpeDbCFsox9VZI2knSUpOMkfVVS\n2zUEhrZslie7LmvU74LezGs6JHJ95i+QyWEDSYeUkWmt9GVLoTMEMHJB+ceSY9Fr+g69mawFWeDr\nd+Rks1eSk+2+MN5gkj4MPI0clTCX3Od3SZoTEa3WoO2IiA+USWYXA3+OiB/UiAu8EzhOOfnwH+QZ\neBXq3SJJ/4qIWhfEu91aWmFLR8QtFa4Hdzw2IjYuZ5vvoO6s5jnAjV3DX1ute9Cl6iSzrpbNMeS1\nps5F21NGfODY9WpeU+ek7zxJy5J1wk4gR0SOW18mhQ5JR5Gthn9Tdy3XXk3WgvzgXE8OY3xRRLRd\n+P2lwEadVkxEXCdpe7LLoHVSkPR08sv5WLKK6Z9HfsTYRcQl5BnQkuQBpcrcDTLZ9GqRpOsk7c+C\nczbOrhD395L2JQ+y3yK7kGroDG1dOiL+V3EuCNSr7zNU1UlmXRdt9yS706pctJW0UteP3XNhHknl\n2maRdce+WP610tdJgWxyr1GpW6dbryZrQX6RtiRrE71a0k+GzlpcRHcPff0R8UCNfk1JryXnghxF\nXlxemSyh/X/RYj1lSeuSF6pvIusSnUwWQXtXdFU3Ha9yZrixpOXIiXE1iwMuQXbXdU7lB8nqrq2U\n1tgjyW6jrchBDjV8r8xhuUy5bkXNUXAPkhMEu0eP1VB7ktl15HWUnStftO10HT6GrJZ7BdkFeBNZ\nkmJK6vekcCP5x7izctxeTdYich3l68l934kcMtkmKfxP0qoRcW3nDkmrUqd/fm9g84hoLixLOh44\nnSySN15HkP3cjybXe34mcDM5umncSUFZ0vpYskrsy8iL8LdL2rdWl1dE7DLkOatcHJX0RLL1OIds\n3TyZ+XVvxi0iDu96jh8xf5x+Db0aPfZuMtF0Jpkd2zJeTy7aRsTGAMoil2+IiLuUVV1bXcjvtb5M\nCpIuJA96jwP+IqlzQKzSp9k9bb1cs3hL25hd8S4hu5BOJc9c/tEy5H7kyJ2fkiNWViJbIuNeDazL\n3O6EAFA++G376O+PiHMAJO0dEX8pt9uexX4aeGNpKX2M7Fr7CzkSqUpSkHQQ2R1Vra5ScTTwWeBD\n5EH2a7QYfSRppNm6tSro9mr02H/JhPiPzuzxNso1yEMkbU7WJ9pA0iHACaVV2daTOq3RyJpYE7FY\n17j1ZVKg0iijkUjagPkXpL5bMfQLyP751YABSQNtur8i4g+SNiXr/axAXgz+SKUuk3nD3N92VFt3\n3O5RNm3jzoyIy8uF66Uj4vcAkoZ7HePRq7pKS0YupXpARISktqOPnkUmrW+Q15dqjsDqmCXpaRFx\nRY3RY6X77Jtkd8x1wBqS/g3sGBGtewN6cdG2OLtc97iIbKWeViFmz/RlUoiIv0FzEXRp8iDz8fJv\n3IuSD3NBatXKpSN2ImvFP5o8G1ydTD7jVi5WV6k5P8RTJQ2tWjpANu1rxB0Ycrtt3M6M7peQo8dQ\nlqKotToa9K6u0n2StgRmKuv+t0oKEfH0MnzxdWTRyF8A34i6ZWE6o8eWJ7tD27aoPwl8JyKaz7Kk\n3cgWYI01moG6F21LvA9KWp+sz/T1iLisRtxe6cuk0OVI8oB6ELnAzKeANmvmXkdvLkh12wHYFDg3\nIj4vqdaY/14YbrGQthPmuuMeOczt8fiJskDdisArJK1GFlOrNZcAeldXaXfgM2Qrcl/gbW0Dlq6R\n/QEkbQZ8QtKKEdF6UpykZfIpYoO2sbqsGxELnCBFxFck1ZxbUZ2k1ckehcWANSW9PSKqJbHa+j0p\n3EtO3V88In5doa+7Z7MIu3S6SDpN7VrDMKurPAFuIuIeoixBcUdE3FiSwtERcWrFp3kf2YKsWlcp\nsix79W7RcvB+FdkCXpoKVTYl7UUu4jNX0l4R0XZyWcdwtbvmDnP/VHESeY1wE7LFVGX50F7p96Qw\nSHabnKFcAq9VQbgJuCAF+QH6BbCypDOY4v2P001E/Knr9jXANZWf4gcRsUm5XaX7AUDSB8iEcw8V\nyi+X4cQ7kgMPvgfsERHXVdhVyEQoMjmeQMu1tbv8R/NL2ABZ0ob665nXdndEfELSGhGxq6TzJ3uH\nRtLvSWF78sLOmeSQuCpnWj28IEVEfKmMFFonf4zLa8S1CfMfSXuTlTfnQbXJa9uRRfDarqPQcTI5\n0fAycsb7xzuzpKN9ocR7I+J+4JaK11Qgu81Ol/RzMpmvAryQLAs/lQ1KegK5RvzSuKUwqeYBjyIP\n3APkEL5P1Ape84KUcpW4oZ4h6RndF9ZsyruVBeexVJm8Rl7Pqnn9qpcr8XWr1sVaZuNvCGxNVqH9\nLfDBocOip6CDyC66E4C/0ptBH9UMDA7Wnuw7dZRhYH8Cnk5+oe6JiCl5VlEuSnYbIMvt3hOltK9N\nXUO7NXoQ/wyyq+eKclfN0udVSbqJHNAxQE7qbAZ3TNV9tvn6vaUwEBF7lIk6uwFTti8vIt7fuV1G\nKxxP1lzfZ7L2yRbJpyiz2iUdFhF7V45fY0nPiTLc6LGHFc1f/6FTdw3qL8dZXb8nhbnKYmpLk3+U\nKq93YfMfIqLNUNfu2HuSieBd0XJ1JptQ3d0kT+tB/IvJmkdL9iB2Vb0aPTbdxAQsx9kL/Z4UDicP\nsGeTJaN/WSlu7fkPndo2XyVHUmwYEbe13UmbUL3uh/0+OZyxU669f/t9+0SZfX6w5q9+2JjK3Wh9\nmRQ6U+sj4rtd932nxlT4ovb8B8ilPO8nF2Y/XF318qfyB8gaT5S0O9li6NwGICKOrhB/RkS8rkIc\nmzidelrTqgutL5MC8EXl4innkZU1zykjhWqpOv+heGWFGDZ5TmL+esTdt2ud0V8u6dnApcwv115t\nbWmrr6ucxd/INUe6F/uasl1sfTv6SNIS5Jq2WwDPLXf/IiqsNlYqo24YEWcoF/e+PCKm+gQam8Yk\nXUZOBusYjIhVJ2t/bOxK1eYfA//q3NdyjZSe6teWAqUo2e/JwnKzyUUtqkwwI7t5nlcuCl8FeIKZ\n9VTkerw2Pd0TEQdN9k6MVV8mhVK3fWuyGNlPyKGd+0dEjW4egOPI5t+JwObk8NFXVIpt1pD0pYjY\nq2uNkEaNtUGsdyStWW7eJGlHcgRZ7ZUaq+vLpAD8H9lc+wRwXsVk0PGYiOjMYr5U0msqx7dpTNLj\n6Bo6GhHXtwjX6e7s+RohVl13F9HuXberrdTYC/2aFOaQ5adfStZ0+SdZ/+iMll/QjkdIekJE/EvS\n44GZFWJaH5D0ZfJzdyPzJy21OaN/a/dItCE+0iKu9VhEPK9UoZ1bsWZVz/VlUigtg3PLPyS9BPgA\nOW+hxgH8Q8CvJN1BXvyrthynTXsbkgsv1VrN7R3A7eQ6HjfQm3Lt1gPlmuO+1C8h3lN9mRRKOd1N\ny7+1yEqQXyNXmWqtrB+8qqTHRsQtpSyFGcDVZNdRrTPD5cmV4nYkB0p8FzglItquV229tzO9KSHe\nU32ZFMg6MWcBBwOXtFnjeCQRcUu5eRJ5hmi2EvA3SZ1lLQfbXBCOiLnkQIkfljWKtwVOknRPRPg6\nw9TWqxLiPdWXSSEiXjDBT+kmvXXs2MPY65NzblYGzunh81h90+YY0ZdJYRL05wxAG4/FgNeW/weA\nFWixqLykDchE8yLgQrJVukevWr9W1VMlnUR+Djq3galdusZJYREsrLAV+Qf3zFLrqL0e72/INUF+\nTE6afDHwYklExAdaxrbempYlxJ0UFs1wf9hp8we3nqu9Hu8uVfbKJtx0LSHupLAIpusf2SZU7fV4\ntwEuAH4YEdF678xG4aRgVlft9XhfQ3ZFvVnSWuSQ1x+RM/Xntoxt9hB9WyXVbDJJWhaYV3ENj07c\nVYCXA5tGxGtrxjYDtxTMqpC0HnAsOV/l5cARwO2S9o2IH4z44JHj7r6Qu+/DQ1KtR5wUzOr4NPDG\niHhA0sHkespXkzW3xp0UmL9Yz1Bu4ltPOCmY1TEzIi6XtAKwdERcDCCpVQ2kTh1+SStV2EezUTkp\nmNXRKc/+EnINDyQtRi7wVMPJZOtgBrAK8BfyArRZVU4KZnX8RNIFwIrAKyStBnyJPJi3FhEbd26X\ni9hTdjlHm95mTPYOmPWDiDgE2A3YKCIuLXcfHRGf6MHT3QGs1oO4Zh6SajYddC3HOUAuIvWTiNhj\ncvfK+pG7j8ymh+4y2fdGxE2TtifW15wUzKaHBaqvSlohIsZdfdVsOL6mYDY9dMoub0KOPnrMJO6L\n9TEnBbPp4e5y0fqGiHgT8PhJ3h/rU04KZtND7eqrZgvlpGA2PQytvvrTyd0d61cekmo2xUlaBpgb\nEfdM9r5Y/3NLwWwKk7QXcBlwmaQtJ3t/rP85KZhNbTsBAjYG9pnkfbGHAScFs6nt3oi4PyJuARaf\n7J2x/uekYDZ9DEz2Dlj/84VmsylM0k3kSKMB4Pl0jTqKiJ0ma7+sf7nMhdnUtl3X7SMnbS/sYcMt\nBTMza/iagpmZNZwUzMys4aRgNg1Jetlk74P1JycFs+lpjcneAetPTgpm04CkZw256+JJ2RHrex6S\najaFSdoUWBt4l6RDy90zgT2BdSZtx6xvOSmYTW23AU8AlgCWL/fNA943aXtkfc3zFMymgbIm842S\nlgUejIi7JnufrD85KZhNYZLWA44FNgReDhwB3A7sGxE/mMx9s/7kC81mU9ungTdGxAPAwcBWwAbA\n/pO6V9a3fE3BbGqbGRGXS1oBWDoiLgaQNG+S98v6lFsKZlPbA+X/lwA/AZC0GDB70vbI+ppbCmZT\n208kXQCsCLxC0mrAl4CTJ3e3rF/5QrPZFCfpKcAdZfTRasDTI+LUyd4v609OCmZm1vA1BTMzazgp\nmLjSFB8AAAH5SURBVJlZw0nBrIukLST9vGK8r0paudw+owwtNZuyPPrIrLeeBxwEEBEvneR9MRuV\nk4LZQkhaEzgaeDTwX+CdEfG7ctb/VeBxwD3AbmVy2ceAF5TtbwG2Bd4ErACcUaqd/h7YArge+HzZ\nfhA4ISIOkbQF8IES9ynAFcBOEXH/RLxmM3D3kdlwvgF8ISKeDrwLOEXSEsCXge9GxDrAgcABklYH\n1gKeExFrAlcDO0fEJ4EbgZdGxK1dsfcg5x08naxp9GpJW5ffPQfYi0wKKwFb9vZlmi3ILQWzh3ok\nsGpEfA8gIn4t6T+AgM2BHcv9ZwBnAEh6D7CbJAEbA9eMEP/5wPER8SBwj6QTyVbD6cCVEXFDifkn\nsuVhNmGcFMweamEt6AHy+9IpO4GkAfKM/hHAN4FDgVOAB8v2Y43fiQ1wb9f9g6PEMavO3UdmD3Un\ncK2kbQEkbUQudHMl8Atgh7LdC8nrDpsDP4+II4E/Ai8mV0cDmMtDT77OBd4oaaakpYCdgZ/17uWY\njZ2TgtnCvQ54p6QryFpD25YLvnuR1wAuJUcV7U7WIVpX0uXkAf9yYJUS54fkheZVumIfBdwAXAZc\nAvzAZStsqnCZCzMza7ilYGZmDScFMzNrOCmYmVnDScHMzBpOCmZm1nBSMDOzhpOCmZk1nBTMzKzx\n/yxYOEc0AdSwAAAAAElFTkSuQmCC\n",
|
||
"text/plain": [
|
||
"<matplotlib.figure.Figure at 0xb5c7080>"
|
||
]
|
||
},
|
||
"metadata": {},
|
||
"output_type": "display_data"
|
||
}
|
||
],
|
||
"source": [
|
||
"title = 'Top 15 locations by mean crowd estimate'\n",
|
||
"(df.sort_values('mean-high-low', ascending=False)\n",
|
||
" .head(15)\n",
|
||
" .set_index('location')[['mean-high-low']]\n",
|
||
" .plot(kind='bar', title=title, legend=False)\n",
|
||
" )"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"## Create State Column\n",
|
||
"using last 2 characters of location"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 17,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"df['State'] = df['location'].str[-2:]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 38,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/html": [
|
||
"<div>\n",
|
||
"<table border=\"1\" class=\"dataframe\">\n",
|
||
" <thead>\n",
|
||
" <tr style=\"text-align: right;\">\n",
|
||
" <th></th>\n",
|
||
" <th>location</th>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>State</th>\n",
|
||
" <th></th>\n",
|
||
" </tr>\n",
|
||
" </thead>\n",
|
||
" <tbody>\n",
|
||
" <tr>\n",
|
||
" <th>CA</th>\n",
|
||
" <td>69</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>WA</th>\n",
|
||
" <td>27</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>NY</th>\n",
|
||
" <td>25</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>OR</th>\n",
|
||
" <td>24</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>AK</th>\n",
|
||
" <td>22</td>\n",
|
||
" </tr>\n",
|
||
" </tbody>\n",
|
||
"</table>\n",
|
||
"</div>"
|
||
],
|
||
"text/plain": [
|
||
" location\n",
|
||
"State \n",
|
||
"CA 69\n",
|
||
"WA 27\n",
|
||
"NY 25\n",
|
||
"OR 24\n",
|
||
"AK 22"
|
||
]
|
||
},
|
||
"execution_count": 38,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"df.groupby('State').count().sort_values('location', ascending=False)[['location']].head()"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"Looks Like there are a few errors in State that would need cleansed (at least 12)\n",
|
||
"\n",
|
||
"15 minutes is not enough to fix this by hand, I know there is a package that would do this faster that has been mentioned on talk python to me. Ill have to look into this package another day"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 42,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"62"
|
||
]
|
||
},
|
||
"execution_count": 42,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"len(df.groupby('State').count())"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 40,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/html": [
|
||
"<div>\n",
|
||
"<table border=\"1\" class=\"dataframe\">\n",
|
||
" <thead>\n",
|
||
" <tr style=\"text-align: right;\">\n",
|
||
" <th></th>\n",
|
||
" <th>location</th>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>State</th>\n",
|
||
" <th></th>\n",
|
||
" </tr>\n",
|
||
" </thead>\n",
|
||
" <tbody>\n",
|
||
" <tr>\n",
|
||
" <th>DE</th>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>OK</th>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>LA</th>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>DC</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>RI</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ah</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>er</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>es</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ge</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>le</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>na</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>nd</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>on</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>t)</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>te</th>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" </tbody>\n",
|
||
"</table>\n",
|
||
"</div>"
|
||
],
|
||
"text/plain": [
|
||
" location\n",
|
||
"State \n",
|
||
"DE 2\n",
|
||
"OK 2\n",
|
||
"LA 2\n",
|
||
"DC 1\n",
|
||
"RI 1\n",
|
||
"ah 1\n",
|
||
"er 1\n",
|
||
"es 1\n",
|
||
"ge 1\n",
|
||
"le 1\n",
|
||
"na 1\n",
|
||
"nd 1\n",
|
||
"on 1\n",
|
||
"t) 1\n",
|
||
"te 1"
|
||
]
|
||
},
|
||
"execution_count": 40,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"df.groupby('State').count().sort_values('location', ascending=False)[['location']].tail(15)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"## Show top and bottom 15 states"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 23,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"<matplotlib.axes._subplots.AxesSubplot at 0xba487b8>"
|
||
]
|
||
},
|
||
"execution_count": 23,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
},
|
||
{
|
||
"data": {
|
||
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEbCAYAAAA1T5h7AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XecVNX5x/HPsmuNCKhr+1lQwcfYUOwNULGi2BVrEoJR\nxF6JJaKxF4wFRVFEo0assUFsEMWCimJL9DEaSyRqUEFRpO/vj3PmOK6zu8PeGbbwfb9evJi5c+4z\nd2Zn7veec8tU1NTUICIiAtCmqRdARESaD4WCiIgkCgUREUkUCiIikigUREQkUSiIiEhS1dQLII1n\nZtcA3eLddYEPgR/i/a3c/YeCM87/8ywOjAKucfe/xmnLAP8F3s1repy7j6s1bwUwEDgIqAAqY62z\n3H22mW0JHOHuxzSwDEW1K/L1dAImuHv7rLUWNmY2FPjU3S8oQa3ewMbufp6Z7QN0c/eTMi9kqD0c\nuNrd3yhFvYWJQqEFc/fjc7fN7CPgUHefUMrnMLNtgOuBtYFr8h7aChjj7rs3UKIP0AvY0t1nmNkS\nwAPAOcAfgPWBlYtYlGLbScuxObAUgLs/CDxYwto789PPqxRJodCKmVl34DJgcWAWYev8CTPrB+wH\nLEJY0X5K2Ar/vECZ44EzgLNrTd8aqDaz54ElgRvc/aYC869E6B0sAcxw9x/M7BhgOTPrSAiGdmZ2\nM3AU8CdgM2DpOH9f4PP8du7ez8z2Bs6Mr+F74BR3f8nM1gOGAYsReiY3uvuNBZarMm5Nbhzfm2OB\nCcD7QD93HxvfwxHAK+4+JO997QSMBsYBWxC+R6cBRwMGvEQI6Boz2xa4JL5Hc4Fz3X2UmS0FDAU6\nAcsC3wB93P19M3sOeBbYFlgN+DvwG3f/yZmmZrYScCMhsOcBQ9x9SJz/C+CXwHXAo4RgXy2+J7e6\n+2AzexS4191vM7Pt4nOu7u6fmNmg+N5eBtxCCOXP4vN8WvvNjD3Cs4F9CMPS/waOcffPzeyA+Lea\nE9+DU4AaoF/8O3wLfALs4e57x+UfD+wILA9cBfwfsB3hc3Sgu/8jbrBcTPh8rwSMdvffmdklcb6R\nZnYo8AFwNbBefE1PAqe7+9zar0O0T6HVMrNq4B5ggLt3Iaxc7zKz1WKTbYCj3X1d4E3Cyvhn3P0g\nd/9bgYdmAw8Rvqi9gTPMbM8C7YYTVtpfmNkLZnYFsIq7v+LuHwHnA2PdvR8xaICt43LdBZxRu52Z\nrQOcB+zi7hsDxwAPxmGu04EH3H0TYA+gh5kV+pwvBTwW5z8PuJcQXjcAR8b3sD2wO/DnAvN3Au5z\n9/UIK9PBwIGEleeOwGZmtixhhXqIu3clrDBvMrNVCL2nye6+pbt3BiYCA/LqdwR6AF2AXQkBUduN\nwNvuvg7h7znAzNaIj33p7uu6+/XAX4An3H1Dwt/rN2a2P6HHtltsvyshfHvG+72B+4ELgG8JAdMn\n/l/Ib4B1gM3dfSPgKSC3kXAFcKS7b0Z4r7u7+wvAzcCd7v6HAvVWjX+bA4HL4/JvCozJe59OAM50\n980Jw6f7m1kXdx8I/A84KPacrwZejJ+JjQkBckIdr2Ohp55C67UV8G5uOMnd3zKzl4Du8fG/ufv7\n8fYwwpZZ0dx9UN7d/5jZTcDewCO12k0FeprZWsD2hBXdaDO72t3PqtV2nJlNBo6KW+M9gK8LPP3O\nhC3HsWaWm1YDrEUYghhuZlsRVkzHu/u8AjW+dPf74/OOMrPFCFvcw4Gz4gr9EOCv7v5tgflnuPuo\nePsDYFF3/w7AzD4DlgFWJKyAHs5bznnA+u4+0szeN7PjCQHTjRAuOY/E5f7GzD6I9WrrSejJ4e5T\nCCtG4nONi7eXJgzT9IjtpprZ7YQwOAO41MwqgV2AC4GdzOxJoL27v2ZmdxI2HmoIwf7XAssBIYC7\nAhPi81cCi8bH7gYeiT2TJ4Er66iR74H4/weEv+0Tefe3jLcPB3Y3s7MIgbQ4cTiqll5AVzM7Kt5f\nAphZxDIslNRTaL0qCV+mfG0I3WcIXfn86fPVlTazE+IWb04FofdQu91AM9vS3T9w95vd/TDCCmRA\ngbZ78WOoPEjY0qwo8PSVwOPuvlHuH2FF8U7cEb42cB+wKfB2HKaqrfbrbQPMdvev43MfQuhdDS38\nDvxspfKz1x6X861ay7kV8LSZHRdf33fAnYReXf5rzT9IoIbC78Ns8v7GZraWmbWNd7/Le121tQEW\ncfcvgX8AexKG2/5MCI+9Cb2EnPznzv/c1H6tF+a9zs2IGyDufgahh/Ia4T19Pg431Sf//Z1Xe6gn\nzv88Icz+CQwiDG8VqlsF7FPrs3JiA8+/0FIotF4vAOub2aYAZrYBYYjh7/HxneKYNISx/Ed+VqF+\n3Qhjw8St6r6EFVttSwEXm1mHvGnrEFYQEFYyuaDaibBlfgPwKmHlVFmg3dPAbma2dnz+3sDrwOJm\ndg+wr7v/BehPGLrKD6+cFcxs1zj/PsBUwjg4wBDgZGCWu79WYN5ivQCsG8e+MbOuwHvACoSV2XB3\nHx6n7ZH3Wov1NGHYhvj+jgHWzG8Qe2qvEd6L3JDY4YQtdghb5BcDT7n7N4Qj2E7jx1AYDfQzszbx\niLNCQ4QAjwNH5oXShcCtZraImX1MCKEbgOMIPZoqfvo3nV/LAhsRhhcfBFYH1qDw5+Vx4CQzq4hD\njI8S9v9IAQqFVsrdvyAcBnqDmb1F2Ao83N1zK75PCfsY3iEMxZw8n09xDLCGmb1NWPld7e5jCrQ7\nF3gGGG9m75iZE8bHD46PvwBsYGb3EsbzdzKzN+P0fwFrxq3C1M7d3ySs5O4xszcIO6F7u/t0wpj1\nr+P08cA97v5cgeX6DDjYzF4nhNv+ua1Rd38VmEbdvYSixL/B/sBVcXlGEPYvfEoYJz/WzCYSVtAT\nCMNI8+MYYMNY+1ng/DoOwTwY2DW+r+OBu909t5/kQUJI50LiccJ64aV4Pzfe/y5hH9JbdSzLUMIQ\nz3gz+wdh30Nfd59N+GzdY2avEfZv/CZOfxrY18wK7s+qT+zlXA68bmavAqcSPiO59/CvwH1mtgOh\nV9ohLvsbhJAsZghroVShS2cvfOLRR3u4+95NvSzNkZl1Jqyw1nb3GU29PCILknoKInnM7CLCVvfJ\nCgRZGKmnICIiiXoKIiKSKBRERCRRKIiISNKiz2iePHla0TtEOnRYkilTppdlOcpVu6XVLWftlla3\nnLVbWt1y1m5pdctZe37qVle3rfPkwYWmp1BVNb/nBTV97ZZWt5y1W1rdctZuaXXLWbul1S1n7VLV\nXWhCQUREGqZQEBGRRKEgIiKJQkFERBKFgoiIJAoFERFJFAoiIpK06JPXRKT56ntJoZ/XaLzhA3co\nab1S2H//PbnzzvtYbLHF0rTx41/giy8+Z6+99i04z7XXXsviiy/F3nvvX2fdCy8cxI477syWW25d\n8mVuiEJBRKSEmmJFXkqtMhTmZwulOW59iEjjjBr1CM8//ywzZ87kq6++5IADDmbcuGf48MMPGDDg\nBGbPnsPIkXfSpk0bNtxwI/r3P47//e8LrrjiEmbNCvMceeQx7LffnvzqV33YaKOufPDB+wBccslg\nllpqqZ8955VXXsJ//zsJgIsuuoLnnnuGjz/+iP79j2PEiJt59tmxtG/fgRkzZtCvX/gV0HHjnmXs\n2Kf55ptv6NfvaLbdtlvB1zNnzhwuvvg8Jk2axNy5c+nT51BWW211hg27gcsu+xNPPvk37rjjNm67\n7S9MmDCBu+++jzPOOCvTe9gqQ0FEFl7Tp0/nqquG8NRTjzNy5F3cdNMIJk58lZEj72TSpE+5+eY/\ns/jii/PHP57DK6+MByro0+dQunbdlLfeeoNbbrmR/fbbk++//56ePXfhpJNO57zzzmb8+Ofp2XOX\nnz1fr1570aXLRlx44SBeeeWlNP1f/3qP8eNfYNiw25kzZzZHHNEnPVZdXc3Agefw2msTuOuu2+sM\nhYceup927dpzzjl/ZPr07+nb9zCGDr2Vzz//jJkzZ/LSSy9SUVHB119/xZgxY+jeffvM759CQURa\nlc6dDYCllmpLx45rUFFRQdu2bfnhhx+YOnUKp556PBDCY9KkSWy44UbcdtstPPbYQ0AFc+bMSbXW\nXjvUWn75FZg1axb33z+SsWOfBuDccy8AYJ111gFgmWWWZebMH3+s7+OPP+SXv1yPyspKKisrWWed\nX6bHzMLtZZddjhkzZvDGG68zbNj1ABxyyBGp3UcffcSmm24OwJJL/oKOHddg0qRP2XzzrZg48VX+\n978v2HnnXZkw4WUmTJjA4Ycfmfn9UyiISKtSUVH4AqAVFRUsv/wK/OlP11NVVcWoUY/QufPa3Hzz\nUPbcc2+22mobHnvsYUaPfjR/rp/U2G+/g9hvv4NqVy74fGussRb33z+SefPmMWfOHN57z/OW5adt\nu3TZiOuuuyndHzv2KQA6duzIm29OpHv37Zk+/Xs++OADVl55Zbp168FNN11P587G5ptvxeWXX8Ra\na61BVVX2VbpCQUQWCpWVVRx00KEce+zvmDt3LiuttDI77LAT22+/I0OGXM0dd4ygunp5pk6dWpLn\nW2utTmy55TYcddSvadeuPVVVVfO90u7de18uvfQC+vf/LTNnzqRv3yPp0GEZ2rfvwH/+8zGHHnoE\nnTp15vPPP6N//6NKstwt+jea6/o9hQW9o7m6ui2TJ0/LXKel1y1n7ZZWt5y1W1rdctZuznWnTPma\nsWOfZt99D2DWrFkcfviBXH31UDbYoHOTL3N9v6egnoKISBm0a9eed9/9J/36HUFFBeyxx96suOKK\nTb1YDVIoiIiUQZs2bTjzzHObejHmmy5zISIiiUJBREQShYKIiCQKBRERSRQKIiKSKBRERCRp8JBU\nM1sEuA3oCMwFjgTmACOAGuBtYIC7zzOzc4Fe8fET3f1lM+uUtW3JXq2IiNSrmJ7C7kCVu28NnA9c\nCAwGznb37QgX/tjLzLoC3YEtgD7AkDh/prbZX6KIiBSrmFB4D6gyszbA0sBsYBPgmfj4aKAnsC3w\nhLvXuPsncZ7qErQVEZEFpJgzmr8jDB29CywH7AF0c/fcdYemAe0IgfFV3ny56RUZ29apQ4clqaqq\nLOIl1K26um2m+Utdp6XXLWftlla3nLVbWt1y1m5pdctZuxR1iwmFk4DH3f33ZrYqMAZYNO/xtsBU\n4Nt4u/b0eRnb1mnKlOlFLH79SnFhquZ8Ua4FWbectVta3XLWbml1y1m7pdUtZ+35vCBenY8VM3w0\nBfgm3v4aWASYaGY94rTdgHHA88AuZtbGzFYD2rj7lyVoKyIiC0gxPYWrgOFmNo7QQzgTmAAMM7NF\ngXeA+9x9bmzzIiFsBsT5T8nSthQvUkREitNgKLj7d8CBBR7qXqDtIGBQrWnvZW0rIiILhk5eExGR\nRKEgIiKJQkFERBKFgoiIJAoFERFJFAoiIpIoFEREJFEoiIhIolAQEZFEoSAiIolCQUREEoWCiIgk\nCgUREUkUCiIikigUREQkUSiIiEiiUBARkUShICIiiUJBREQShYKIiCQKBRERSRQKIiKSKBRERCRR\nKIiISKJQEBGRRKEgIiKJQkFERBKFgoiIJAoFERFJFAoiIpIoFEREJFEoiIhIolAQEZFEoSAiIolC\nQUREEoWCiIgkCgUREUkUCiIikigUREQkqSqmkZn9HugNLApcDzwDjABqgLeBAe4+z8zOBXoBc4AT\n3f1lM+uUtW2JXquIiDSgwZ6CmfUAtga2AboDqwKDgbPdfTugAtjLzLrGx7cA+gBDYolMbUvwGkVE\npEjFDB/tArwFPAg8AjwKbELoLQCMBnoC2wJPuHuNu38CVJlZdQnaiojIAlLM8NFywOrAHsAawMNA\nG3eviY9PA9oBSwNf5c2Xm16Rsa2IiCwgxYTCV8C77j4LcDObQRhCymkLTAW+jbdrT5+XsW2dOnRY\nkqqqyiJeQt2qq9s23GgB1mnpdctZu6XVLWftlla3nLVbWt1y1i5F3WJC4TngBDMbDKwE/AJ42sx6\nuPvfgd2AscD7wGVmdgWwCqE38aWZTczYtk5Tpkyf/1dcy+TJ0zLXqK5uW5I6Lb1uOWu3tLrlrN3S\n6pazdkurW87a81O3vvBoMBTc/VEz6wa8TNgHMQD4EBhmZosC7wD3uftcMxsHvJjXDuCULG2LeoUi\nIlISRR2S6u6nF5jcvUC7QcCgWtPey9pWREQWDJ28JiIiiUJBRESSooaPJOh7yZii2w4fuEMZl0RE\npDzUUxARkUShICIiiUJBREQShYKIiCQKBRERSRQKIiKSKBRERCRRKIiISKJQEBGRRKEgIiKJQkFE\nRBKFgoiIJAoFERFJFAoiIpIoFEREJFEoiIhIoh/ZaSb0Az4i0hyopyAiIolCQUREEoWCiIgkCgUR\nEUkUCiIikigUREQkUSiIiEiiUBARkUShICIiiUJBREQShYKIiCQKBRERSRQKIiKSKBRERCRRKIiI\nSKJQEBGRRKEgIiKJQkFERBKFgoiIJAoFERFJqoppZGbLA68COwFzgBFADfA2MMDd55nZuUCv+PiJ\n7v6ymXXK2rZUL1RERBrWYE/BzBYBbgR+iJMGA2e7+3ZABbCXmXUFugNbAH2AIaVom/3liYjI/Chm\n+OgKYCjw33h/E+CZeHs00BPYFnjC3Wvc/ROgysyqS9BWREQWoHqHj8zs18Bkd3/czH4fJ1e4e028\nPQ1oBywNfJU3a2561rb16tBhSaqqKhtqVq/q6raZ5l/QdUtVu7kvX2uoW87aLa1uOWu3tLrlrF2K\nug3tU+gL1JhZT2Aj4HZg+bzH2wJTgW/j7drT52VsW68pU6Y31KRBkydPy1xjQdYtRe3q6rZlW75y\n1W5pdctZu6XVLWftlla3nLXnp2594VHv8JG7d3P37u7eA3gdOAIYbWY9YpPdgHHA88AuZtbGzFYD\n2rj7l8DEjG1FRGQBKuroo1pOAYaZ2aLAO8B97j7XzMYBLxKCZkAp2jb2RYmISOMUHQqxt5DTvcDj\ng4BBtaa9l7WtiIgsODp5TUREEoWCiIgkCgUREUkUCiIikigUREQkUSiIiEiiUBARkUShICIiiUJB\nREQShYKIiCQKBRERSRQKIiKSKBRERCRRKIiISKJQEBGRRKEgIiKJQkFERBKFgoiIJAoFERFJFAoi\nIpIoFEREJFEoiIhIolAQEZFEoSAiIolCQUREEoWCiIgkCgUREUkUCiIiklQ19QJIefW9ZEzRbYcP\n3KGMSyIiLYF6CiIikigUREQkUSiIiEiiUBARkUShICIiiUJBREQShYKIiCQKBRERSRQKIiKS6Ixm\naRSdKS3SOtUbCma2CDAc6AgsBlwA/BMYAdQAbwMD3H2emZ0L9ALmACe6+8tm1ilr25K+WhERqVdD\nw0eHAV+5+3bAbsB1wGDg7DitAtjLzLoC3YEtgD7AkDh/praleYkiIlKshkLhXuCcvPtzgE2AZ+L9\n0UBPYFvgCXevcfdPgCozqy5BWxERWYDqHT5y9+8AzKwtcB9wNnCFu9fEJtOAdsDSwFd5s+amV2Rs\nW68OHZakqqqyoWb1qq5um2n+BV23nLWbe93mvnwLsnZLq1vO2i2tbjlrl6JugzuazWxV4EHgene/\ny8wuy3u4LTAV+Dberj19Xsa29ZoyZXpDTRo0efK0zDUWZN1y1m7Odaur25Zl+cpVt5y1W1rdctZu\naXXLWXt+6tYXHvUOH5nZCsATwBnuPjxOnmhmPeLt3YBxwPPALmbWxsxWA9q4+5claCsiIgtQQz2F\nM4EOwDlmltu3cAJwjZktCrwD3Ofuc81sHPAiIWgGxLanAMMa27Ykr1BERIrW0D6FEwghUFv3Am0H\nAYNqTXsva1tZ+OgcCJGmo5PXZKGhsBFpmC5zISIiiUJBREQShYKIiCQKBRERSRQKIiKSKBRERCRR\nKIiISKJQEBGRRKEgIiKJQkFERBKFgoiIJAoFERFJFAoiIpIoFEREJFEoiIhIot9TEMlIv9MgrYl6\nCiIikigUREQk0fCRSDM1P8NSoKEpKQ31FEREJFFPQWQhpJ3jUhf1FEREJFFPQURKplw9kHLuX1Gv\n6afUUxARkUShICIiiUJBREQS7VMQESmDlrqvQj0FERFJFAoiIpIoFEREJFEoiIhIoh3NIiItSLkv\nlKiegoiIJAoFERFJFAoiIpIoFEREJFEoiIhIolAQEZGkWR2SamZtgOuBLsBMoJ+7v9+0SyUisvBo\nbj2FvYHF3X0rYCBwZRMvj4jIQqW5hcK2wN8A3H08sGnTLo6IyMKluYXC0sA3effnmlmzGuISEWnN\nKmpqapp6GRIzGwyMd/d74v1P3X2VJl4sEZGFRnPrKTwP7A5gZlsCbzXt4oiILFya29DMg8BOZvYC\nUAH8pomXR0RkodKsho9ERKRpNbfhIxERaUIKBRERSRQKIiKSKBRERCRZaELBzNY3s6FNvRzSeGa2\neFMvgzSemW1Xprr/l3H+DeqYfliWug0855blqp1VczsktaTMrBLYFzgWWAG4uQQ1FwHOA8539xlm\n1gvYDjjb3edkqPs7d78p6/LN53P+2d0Pz1ijAugGrA58Ajzj7iU9pM3M1gQGAIcR/o6lrN0W+DXQ\n393XzVhrOeAHd/8+b1p/d78hQ82xQMH3093n78d3f1p357oec/cnGlu3AVcCm5eqmJltT/hubwOs\nmKHUCDO7xt1vi3WXBG4AOgF3ZF7QyMwWAw4hLPNiwPoZai0NDAWOcvdpZnYwsBdwpLtPy7KcrTIU\nzGxF4CjgcOBFYDF3X6dE5a8CZgPz4v0XgV2AwcDxGerubGa7A33d/etsi1g0yzSz2QrAo8D7wIfA\nnsBgM+vl7p9lXrjwfuS+9JcAG2WtmVd73Vj7QOB+4FcZ6/0e+C1QZWa/Bf4FjCRctqXRoQAcXet+\nF+Bq4K4MNXN1p8bbFXnTa4ByhUJFw03qZ2a/IIY4IQiOI6xos+gO3GJm3YBhwC3AA0DfjHUBMLOO\nhI2agwjvwUHu/kLGskOBl4Hv4v17gf8jfNYy9XBaZSgQVlLXABvHFB1dwtqbxKu4AuDuX5vZCcBL\nWYq6+/5m1gcYa2anlXFrrZSuBAa6+9O5CWa2KyE4+zS2qJmdQvjivxGfo427X5xtUVPt/Qhf0EWB\nWwFz96NKULoPsC6wHHA3oUdzqbsPz1LU3R1Sj2wgcATQx92fyba4LEsImL8Do4En3X1qvXNkl6kH\naWbXAjsQTnLdG7jW3f+SdaHc/TvgIDMbRbiqwtHuPixrXQAzewjoANxO6BmMLEEgAKzq7ikM4yjF\nFWb2YtbCrTUUfhv/jTGz4YQVQKn8UHuCu9eY2feFGs8Pd7/bzN4AXjSz6YStihp3XzlL3TqGCioI\nFyDMYtX8QABw97+Z2TkZ654K/AW41d3fiiFRKrcDfwIGu/tXMSRK4Wt3nwX8N45xH+Dur5WisJl1\nJiz3m8BmcSWWibt3j8MZWwE9gN+ZGYThvwuy1I4rptoBUAFk7a1vC7xK2AD7d4HnaBQzWxa4jfDd\n3hm42swqSjScW0EYWViCsA+3VEOr8+qYPitr4Va5o9ndR7r7zsABwMrAmmY20sz2KEH5yWb2k0t6\nm9lmwPSshc2sL/AYcJy7r+zuK2UNhOhgwpZs/r+DgKxbLHMzzl+XjsAEwpfzJWBVM2tXotqdge+B\ncWY2krBlXwr5X/ZPShgIxwGPA5cShkpmmdmiZpZ5Q8fdZxJWsm/Gf1VA16x1gVGEz9zBhIDPff4K\n7tAtlrtvTBg22RdwYG0zK8Ww8EvAo+6+X9zI2RbY1czuzVrY3XsThiaXic/Txcx2iz8olsW/zGyv\n/Alm1hvIPGzbai9zYWa/A4a7+5w4VrgRsKO779XArA3VXQV4iLBT9d/AqsAahC3DjzLUHQVUEvYp\nTMqyjAVq19WlrHH3rTPUHQHc7+6P5E3rBRzi7odmqLuBu78Vb3cCjiSE2AR337+xdQs8z46x9hbA\nfe5+WoZaThjqqgBOIuxjAiDLFqeZfRhv/uyL6u5rZqh7MtALaA88Rfgdk+fcfXZja+bVHpPbCZ5/\nuxTiDtY5hO/KYYQRAdy90b+9YmYPuPu+Baaf7O6DC83TyOdZlfCeHwB0dvfVMtRqT+hNr0DYn7cK\n8CVweNZ9kq1y+MjMBhHG7+4gfIA+AU4kbBVl4u6fmtmRwBWEP/AdwFlZAiEaRdhptGPsxuc/5+0Z\nazd6fL8BpwIPxPfjA0I4rkDY4ZzFtTF8nyGsrC4GzgR6Z6xLHE7M9wPwNiEcGh0KhB2/KwJrErbW\ntiZsNGTdufp3QiBk3klbyx/48b19phRhkKeijtuZmNmxwCmE7/Sx8aiuG8ws6wEI7QtNLEUgxAMa\nrovB+ARh5/4qwMkZS/cm7LtanTBk9CrwKbAHYaix0VplKAC7AVvmDo1094/MLDdccn6WwmZ2AHA6\ncBPwBeGPcp+Z/cHdH8pQuvax1rmrxE4n4x/Z3T/OMn89db80s7sIH8iOhB2A67n7lxnr9qg93h0f\nejY+RxabAksSwjx3NV6A6zLWvZKw5bYcYcttPaCaMHSSRVfC8t7Jj8N9pVjRVhMOpd4duMjMPiPs\ncB7l7p9krF1Tx+2sDiEcMbc08GfCsBru/nrGumuZ2UWFHnD3MzPWvpSwvgD43N23j73fmwlHDDXW\nL/NuL0H4TFxOCdYXrTUUvqt9rLy7zzazzDvogBOAHrWORR8BPEwYVmoUd/99Xr1OwAjC4Z4nNrZm\nueX1yG5391fioXcnmtly7v7HLLXdfaaZvUoYi21LWDlunHGRcfcNzWx9wtDDQELQ3OHu72csfQlw\nb36vLh6aejnh8OjGLm+Xcixv7BmMif9yR42dCQwhDM1ksYn9ePn7dfNuZxquBGbEnflflmKfSp7p\nhH0U5bCku0+It78BcPf3LeMvSpZzfdFaQ+EHM1vT3f+dmxBPgKprj/38mJMfCADxsNeS7HQ1swGE\nP+xJ7v5oKWqWUX09skaHQoHx7kcJh76WZIjD3d8mrGCJ+5suNrNV3T3LWaZd3P3YWs9zi5n1y1Az\nV6fkyxtp5fPtAAADsUlEQVQPltgu/luHcPjvbWQ8xj3asAQ1GlLK4bTPcyeulcESuRvuvnfe9JJ8\nlsuxvmitoXAG8Fcze5owrrsa4QSzTCcoRXUFS6ajCeJhjLcCXwObu/uULPUWkLp6ZJnOqKS8491A\n2mG5D2F45xdkP3O1rmVs9Fnu+cqwvJcShl8uACbW/jtmUa7hSmC9OFxZkXc795xZTmDLvK+xHpPM\nbHN3fzk3wcw2Bz7PUrSc64tWGQru/g8L11nZi3BI6muEy1JkXVlBrQ9jVEE4cSmLtwk7jMYAQ/J3\nNmf8wJdTXT2yrCuYso13x31CBxM2FB4gnKj0UbbFBeBrM9s0b6ggtzWe6UiQci2vu++YtUYTODDv\ndsmuY+bup5aqVgGnAw/HDdT3CQci7Ej2gzHKtr5otYeklouZda/rsSxnmZarbjmZ2XqEnas/65G5\n+8QSPk9uvHsbd8803m1m84B3CcMlkBdgWb5McX/Kw4SjhXJHYvUE9nT3D+ues8G6ZVleWXDMbAlC\nCKwB/Ad4qPYQdCNqlm19oVCQTOJJZbke2ceEk4Ay9cjqGO9+inAphqw9hbJ9mSxcxbUXYWtwEs38\nyy9SiEJBmp3Y1X6cEAQlHe8WkfopFEREJGmV1z4SEZHGUSiIiEjSKg9JFSkHM9sf+D3he9OGcCb3\n5WZ2HvCUu4+rZ949gLVLeYE1kXJQT0GkCPFkoSuBnd29C+G6TH3i5Yq70/ClITYl++9XiJSdegoi\nxVkOWIRwcbqv3P07M/sV4dr+mwI3m9k+hGs1XRjbdSCcvPQP4s9qmtnHhAuhDSFcN6qS8AttmX9B\nTKQU1FMQKYK7v0G44OG/zexlM7sUqHT38wk/CNQv/gbEcfF2V8K1/v/g7v8knIE71N1vBc4GXnX3\nTYBuwFnxTHCRJqdQECmSu/cnXCL8BsIl08ebWe0fZzkMWN/CT5KeAixVoFRP4Ggze51w1dNfEC61\nLdLkNHwkUoT4i3JLuftIwoXIbo0/LvTbWk3HAWMJl7t4mvDjO7VVAoflfrLTzFYg4zWSREpFPQWR\n4kwnXLK6I4CZ5S6COJFwJdQqM1sGWJswZDSK8CPwuR3Qc/hxI2wM0D/WWYnw+8iN/mlGkVLSGc0i\nRYo7lk8j7HCGcCmO0wj7EY4GjgD2J1wL6lvgRcJvS68GbEL4vYLB8f/rCb8bXglcUsbr+YvMF4WC\niIgkGj4SEZFEoSAiIolCQUREEoWCiIgkCgUREUkUCiIikigUREQkUSiIiEjy/zI1gmGYCP6fAAAA\nAElFTkSuQmCC\n",
|
||
"text/plain": [
|
||
"<matplotlib.figure.Figure at 0xb8c7ef0>"
|
||
]
|
||
},
|
||
"metadata": {},
|
||
"output_type": "display_data"
|
||
}
|
||
],
|
||
"source": [
|
||
"title = 'Top 15 States by mean crowd estimate'\n",
|
||
"(df.groupby('State').sum()\n",
|
||
" .sort_values('mean-high-low', ascending=False)\n",
|
||
" .head(15)\n",
|
||
" [['mean-high-low']]\n",
|
||
" .plot(kind='bar', title=title)\n",
|
||
" )"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 25,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"<matplotlib.axes._subplots.AxesSubplot at 0xcb73f98>"
|
||
]
|
||
},
|
||
"execution_count": 25,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
},
|
||
{
|
||
"data": {
|
||
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAEbCAYAAADUCE9vAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XmcU9X5x/HPMKNSdES0o5W6oMg8WK1QcMG6gLjv1qVS\ndxEXita1FS0q1g0Vl7buKOJeWnerKAqIqKCiuFV9/IlrcUNFRVFwYH5/nDOQxmQmM8kdyOX7fr14\nkdycPDm5c/PNuecmNxX19fWIiEh6tVncHRARkWQp6EVEUk5BLyKScgp6EZGUU9CLiKScgl5EJOWq\nFncHliZm1gmYDrwSF1UCc4CT3P2pJu67CXCEux8Tr48FDnD3zxLs7w7ARe7ePWPZJcB+wBdxkbv7\n/jnu2xW4BFgzLpoF/Nndn4y3jwCucffnm+hDQe0KfD6jgFfdfXixtZYmZvZTYKa7V5So3sJt18we\nAk5x99dKUPd/XiOyiIK+9X2XFZy/BUYBXZq43wbAGhnXty991xb26SfAn4Fjgf9m3fxroJ+7P91E\nmbuAIe5+T6y5NfCgma3j7l8Q+n9tAd0ptJ2Uj4XbrrvvUsK62a8RiRT0i98qwEcNV8zsKOAPwHzg\nE0LYfgf8BWhvZjdm3HeCme0CrAhcEWvVA5e4+81m1ge4APiQ8CKYA5wV6xtwl7ufmKNPOwLLA/3j\n4zb0bTngV8ApZtYZeAs40d3fz1Fj9VgDAHd/Ir6pzTez84COwG1mdghQAVwELBfv96i7H5Gj3RvA\nX4FfAssA44A/unudmZ0N/AaYB3wOHObuC9drhi3NbN+4zsYCpwD7A7939y3i81wLmAJ0cvd5Gc9/\nVFyHmwI/A/4JzAR2j9cHuPt4M1sWuBDoTdhrmwb8wd2/NrPdgNOBZYFVgZvc/Yz4tzoPeBvYMK6L\nQe4+IfsJmFl/4GTCNvIZcCjQOa6bb4EVgE3i8uxtqR3wgLuvGWs9Anzs7ofGv++HwLrAtrE/c4Dn\ncqzHhr6sHx93lfhc/+buI81sBeBGwgBmAfA8cDRwQ7xrw7Y7Cdg39rnJbdXM2gCXAb2AasK2MwB4\nn4zXiLsfbma7A0Piup5D2HOYnO+5pJnm6FvfT8zsxfjvPcKL5AIAM+sL/AnYxt27AbcD9xJG1WcC\nk9z9cHc/PNbahvAmcT/wd3ffCNgZON/MNo9tNgHOdfeuhBf7acCuQA9gkJl1zO6gu98b3wC+yLqp\nIzA+1uhOCMP7zCzXLv0g4O9m9qGZ/dPMjgWec/ev3P3PhBf0ge7+DHA8cKa7bwb8AtjDzHrmaHcZ\n8Ly79yS84fwUOMnM1gROADZx940JAb5ZnvW/BiHEugPdgCOBfwHrmdkGsc0AQgDPy3H/HsDmwMbA\nicA37v5rwt9xcGwzGKgDesa/44fAsLieTgYOjf3sBZwWp0aIfb7E3X9FCMSh2Q9uZt0IbyI7xb/3\n/YS9LwhvEL+Ly7cg97b0EvCDmW0Y99y6An3j/bcFngHaAiOBfeK6fi/XijSzKuBOYHBs15swCOhF\neNOtjnuvm8S7rJu57br7B1klC9lWNyNsh5u7+y+Am+Ljf0DGa8TMugDnA7vE9XkUcLeZLc9SSEHf\n+r5z9+7x39pAH+AfZrYOsBMw2t1nArj7KODnQKdG6tUCbd397nifDwnTJjvF299x92nx8nRggrvP\ni3P7XwMrF9pxd3/H3XfxoB4YThhJ/qh/7n4HYXTeMBLvD7wWj1NkOxRYycxOB64CfkIY4WXbDTja\nzF4kjBA3JYzuZxAC7AUzGw686O735nkat7j7tzHEbwW2j5evBwaYWSVwGHBdnvs/4O4/uPvHhNHz\nw3H5dBaty92APYFpsa97Ab+I62x3oKeZnQVcShiRNoTPe+7+Yrz8Arn/NtsCjzSEpLtfnjEn/YG7\nN4RyY9vSPYQBQR/CXtGn8U1uT8K2syXwSsa8eb6ps1rC339kfJ4TCX+7XwFPAhuY2eOEN77L3f2t\nPHUaNLmtxhH5EMJ2MJxFewPZtidsf+Ni324j7Fms10QfUklTN4uZuz9tZk4IrUrC1EOmCsI0RT6V\nhOmaTG0y7jM367YfWthVzGwjoJu735LVvx+y2nUlTJ0MBh6L/840s0cJL8zsg6FPAC8TQvOfhFFb\nrr2ESmA/d389Ps5KQL27LzCz3oRR9nbAZWY2wd2Pz1FjfsblNhl9v4YwRTGRcMD2nTyroZD1WQkc\n7+5jYj9XANrG0eQ0QtBOIoya98p4rt9l1Kgn9zqoI+PvHUfla8er32T1Id+2dA9wDmFk/CjwKWG6\nbmfCtFKfrMeuy9GPhsf4KuuY02px2fdmtl6s1Rd4zMyOc/c789SCAtatme1K2Hu6BLiPMIg4KE/f\nxmV+UCDu+X3YyOOnlkb0i5mZ1RJGRtMIQdfPzGribYcT5pvfIrzYMgN/frz+BmFXfO94n47APoQX\ncKktAP4W9z4ABgIvu3v2AdtPgKPiXDixXysDqxFGqhCfTwzrTYBT417JzwmjrsrMdvHyI8CJZlYR\n55PvB46N0xmvAq+7+wWEKZ5ueZ5DPzNbzszaEvYkxgDEEfLkeN+rm7NScngk9mvZOKc8gjA914Vw\nbGCIuz9AmOpYLuO5FmICsJ2ZrR6vH004vpGtsW3pacJIfDfCm/BYwtTXm+7+OeGNd4O4XiHs4eTi\nwHdmdlB8jDUJf4eeZjaQMEc/1t1Pjetkw3i/hm23JbYn7FVdTXhj3ovc28o4YIc46CAeD3iZsMex\n1FHQt77MOfoXCXOcR7n7m+7+KCFoxpvZfwhBtJu7LyDMh3c1s3tinbsJu8dG2NiPN7OXCS/cv+Q6\niFcsd38VOA54wMxeJ8zD/i5Hu1mEUdwRZvZufC6PARe7+/jY7F5gNGFP5gLCtMtUwrzsUyzaxb4X\nGG3ho55/IExzvEJ40b5C+PjnS4Q9gamxRn/C/Hku7xBG09MIgXZTxm03EkLjoeaslxzOAd6Nj/Ea\nYXR8cuzzv4E3zOwFYI94e8HTCe7+CvBH4GEze4kwRfOjjxM2ti3F7WkMMDtO7TxJmCa6K953JnAA\n4SD4C8A62fVju3mE6Z4BcdsbC5zh4aPCNxPW5Wtm9jzQnjASh7jtmtmGOco25RqgT3y8yYQpnnXi\nG+rC10icdjqKMC36EuFvsoe7f5OvcJpV6DTFIhCD4grCPPmFi7s/IqWkEb0s9cysmjCt0ZkQ9iKp\nohG9iEjKaUQvIpJyCnoRkZRT0IuIpNwS94WpmTNnF3zQoEOHdsyaNSeRfiRVu9zqJlm73OomWbvc\n6iZZu9zqJlm7OXVraqrznl20rEf0VVXN+Z7JklG73OomWbvc6iZZu9zqJlm73OomWbtUdcs66EVE\npGkKehGRlFPQi4iknIJeRCTlFPQiIimnoBcRSTkFvYhIyi1xX5gqRP9h45tu1AwjB/dtulEr23ff\n3bnttjtZbrnlFi6bMuVpPvnkY/bcc++c97nhhmtZZZVV2GuvfXPeDnDeeUPZdtsd6NXr1yXvs4gs\nmcoy6JdWCmcRaQkFfYEeeugBnnrqCebOncvnn3/Gfvv9jkmTJvLOO9MZNOh4fvihjtGjb6NNmzZs\ntFF3Bg48jk8//YThw4cxb164z5FH/p599tmdQw/tR/fuPZg+PfxW8rBhl7LCCj/+feNLLhnGhx/O\nAOD884fz5JMTee+9dxk48DhGjbqeJ56YwEordeD777/nlFNOAmDSpCeYMGEcX331FQMGHMOWW26d\n8/nU1dVxwQVnM2PGDObPn0+/fgey1lprM2LE1Vx00eU8+ujD3HrrTdx00x1MnTqVf/zjTk499c8J\nrV2RpVtzZymaOwuhoG+GOXPmcNllV/LYY48wevTtXHfdKKZNe57Ro29jxoz/cv31t9C2bVvOOecM\nnntuClBBv34H0qPHxrzyykvccMO17LPP7nz77bdst92OnHjinzj77CFMmfIU2223448eb9dd96Rb\nt+6cd95QnnvumYXL/+//3mTKlKcZMeJm6up+4JBD+i28raamhsGDz+CFF6Zy++035w36++67i/bt\nV+KMM85hzpxv6d//IK655kY+/vgj5s6dyzPPTKaiooIvvvic8ePH07v3NiVfnyLSOhT0zdCliwGw\nwgrVdOq0DhUVFVRXV/Pdd9/x5ZezOOWUPwDhDWHGjBlstFF3brrpBh588D6ggrq6uoW1amtDrVVX\nXY158+Zx112jmTBhHABnnXUuAF27dgVg5ZVXYe7c7xfe97333mH99TegsrKSyspKunZdf+FtZuHy\nKqv8lO+//56XXnqRESOuAuCAAw5Z2O7dd99l4403BaBdu+Xp1GkdZsz4L5tuujnTpj3Pp59+wg47\n7MTUqc8ydepUDj74yNKtSBFpVQr6ZqioyH1yuIqKClZddTUuv/wqqqqqeOihB+jSpZbrr7+G3Xff\ni80334IHH7yfMWP+nXmv/6mxzz77s88++2dXzvl466zTmbvuGs2CBQuoq6vjzTc9oy//27Zbt+5c\nccV1C69PmPAYAJ06deLll6fRu/c2zJnzLdOnT6djx45svXUfrrvuKrp0MTbddHMuvvh8Ondeh6oq\nbSoi5Uqv3hKorKxi//0P5Nhjj2L+/PmsvnpH+vbdnm222ZYrr/wrt946ipqaVfnyyy9L8nidO69H\nr15bcPTRh9G+/UpUVVU1O4j32GNvLrzwXAYOPIK5c+fSv/+RdOiwMiut1IEPPniPAw88hPXW68LH\nH3/EwIFHl6TfIrJ4LHG/Gduc89HX1FQzc+bsRPqRVO1S1J016wsmTBjH3nvvx7x58zj44N9y6623\nsMwy1SXq5f9aktdFa9ZNsna51U2ydrnVLUXtUhyMbex89BrRl6H27VfijTdeY8CAQ6iogN1224uO\nHTsmthGLSHlT0JehNm3acPrpZy3ubohImSgo6M1sGvBVvPoOcC3wV6AOGOvuZ5tZG+AqoBswFxjg\n7m+ZWa/stiV+DiIi0ogmg97M2gK4e5+MZS8C+wBvAw+aWQ+gE9DW3TeP4X4JsCdwTXZbd3+hxM9D\nRETyKGRE3w1oZ2ZjY/uhwHLuPh3AzB4BtgVWBx4GcPcpZraxma2Yp62CXkSklRQS9HOA4cD1QBdg\nDJD5OcHZwLrAiiya3gGYH5d9naNtXh06tGvWD+LW1CTzSZMka5db3SRrl1vdJGuXW90ka5db3aRr\nF/tYhQT9m8Bb7l4PvGlmXwErZ9xeTQj+dvFygzaEkK/O0TavWbPmFNClYEn+uFRa6iZZu9zqJlm7\n3OomWbvc6iZdO5dcj9VY+BdyPvr+hPl2zKwjIdC/NbPOZlYB7AhMAp4CdontegGvuPvXwLwcbUVE\npJUUMqK/ARhlZk8C9YTgXwDcBlQSPknzjJk9B2xvZk8Tvrt/eLz/MdltS/wcRESkEU0GvbvPAw7I\ncVOvrHYLCKGeff8p2W1FRKT16KcERURSTkEvIpJyCnoRkZRT0IuIpJyCXkQk5RT0IiIpp6AXEUk5\nBb2ISMop6EVEUk5BLyKScgp6EZGUU9CLiKScgl5EJOUK+nFwERGB/sPGF9x25OC+CfakeTSiFxFJ\nOQW9iEjKKehFRFJOQS8iknIKehGRlFPQi4iknIJeRCTlFPQiIimnoBcRSTkFvYhIyinoRURSTkEv\nIpJyCnoRkZRT0IuIpJyCXkQk5RT0IiIpp6AXEUm5gn5hysxWBZ4HtgfqgFFAPfAqMMjdF5jZWcCu\n8fYT3P1ZM1svV9tSPwkREcmvyRG9mS0DXAt8FxddCgxx962ACmBPM+sB9AY2A/oBV+ZrW9rui4hI\nUwqZuhkOXAN8GK/3BCbGy2OA7YAtgbHuXu/u7wNVZlaTp62IiLSiRqduzOwwYKa7P2Jmp8XFFe5e\nHy/PBtoDKwKfZ9y1YXmuto3q0KEdVVWVBT+Bmprqgts2V1K1y61ukrXLrW6StcutbpK1y61uaz9W\nc2s3NUffH6g3s+2A7sDNwKoZt1cDXwJfx8vZyxfkWNaoWbPmNN3rqKammpkzZxfcvjmSql1udZOs\nXW51k6xdbnWTrF1udfNJ8rFy1W4s/BudunH3rd29t7v3AV4EDgHGmFmf2GRnYBLwFLCjmbUxs7WA\nNu7+GTAtR1sREWlFBX3qJsvJwAgzWxZ4HbjT3eeb2SRgMuHNY1C+tiXos4iINEPBQR9H9Q1657h9\nKDA0a9mbudqKiEjr0RemRERSTkEvIpJyCnoRkZRT0IuIpJyCXkQk5RT0IiIpp6AXEUk5Bb2ISMop\n6EVEUk5BLyKSci05142IyBKt/7DxBbcdObhvgj1ZMmhELyKScgp6EZGUU9CLiKScgl5EJOUU9CIi\nKaegFxFJOQW9iEjKKehFRFJOQS8iknIKehGRlFPQi4iknIJeRCTlFPQiIimnoBcRSTkFvYhIyino\nRURSTkEvIpJyCnoRkZRT0IuIpJyCXkQk5Zr8cXAzqwRGAAbUA8cA3wOj4vVXgUHuvsDMzgJ2BeqA\nE9z9WTNbL1fb0j8VERHJpZAR/e4A7r4FMAQ4D7gUGOLuWwEVwJ5m1gPoDWwG9AOujPf/UduSPgMR\nEWlUk0Hv7vcCR8WrawNfAj2BiXHZGGA7YEtgrLvXu/v7QJWZ1eRpKyIiraTJqRsAd68zs5uA3wD7\nAtu7e328eTbQHlgR+Dzjbg3LK3K0zatDh3ZUVVUW/ARqaqoLbttcSdUut7pJ1i63uknWLre6SdZO\nss+t9VhL0novKOgB3P1QMzsVeAb4ScZN1YRR/tfxcvbyBTmW5TVr1pxCu0RNTTUzZ84uuH1zJFW7\n3OomWbvc6iZZu9zqlqJ2/2Hjm9V+5OC+LX6sxiS1fpKqm692Y+Hf5NSNmR1sZqfFq3MIwT3VzPrE\nZTsDk4CngB3NrI2ZrQW0cffPgGk52oqISCspZER/N3CjmT0BLAOcALwOjDCzZePlO919vplNAiYT\n3kAGxfufnN22xM9BREQa0WTQu/u3wG9z3NQ7R9uhwNCsZW/maisiIq1DX5gSEUk5Bb2ISMop6EVE\nUq7gj1eKyNKpOR+DTOojkFIcjehFRFJOQS8iknIKehGRlFPQi4iknIJeRCTlFPQiIimnoBcRSTkF\nvYhIyinoRURSTkEvIpJyCnoRkZRT0IuIpJyCXkQk5RT0IiIpp6AXEUk5Bb2ISMop6EVEUk5BLyKS\ncgp6EZGUU9CLiKScgl5EJOUU9CIiKaegFxFJOQW9iEjKKehFRFJOQS8iknIKehGRlKtq7EYzWwYY\nCXQClgPOBV4DRgH1wKvAIHdfYGZnAbsCdcAJ7v6sma2Xq20iz0RERHJqakR/EPC5u28F7AxcAVwK\nDInLKoA9zawH0BvYDOgHXBnv/6O2pX8KIiLSmKaC/l/AGRnX64CewMR4fQywHbAlMNbd6939faDK\nzGrytBURkVbU6NSNu38DYGbVwJ3AEGC4u9fHJrOB9sCKwOcZd21YXpGjrYiItKJGgx7AzNYE7gGu\ncvfbzeyijJurgS+Br+Pl7OULcixrVIcO7aiqqiyg60FNTXXTjVooqdrlVjfJ2uVWN8na5Va3tR+r\n3NbPkrQumjoYuxowFjjW3cfFxdPMrI+7P06Yt58AvAVcZGbDgTWANu7+mZnlatuoWbPmFNz5mppq\nZs6cXXD75kiqdrnVTbJ2udVNsna51c0nycdKqna51c1Xu7Hwb2pEfzrQATjDzBrm6o8H/mZmywKv\nA3e6+3wzmwRMJsz7D4ptTwZGZLYt/KmIiEgpNDVHfzwh2LP1ztF2KDA0a9mbudqKiEjr0RemRERS\nTkEvIpJyCnoRkZRT0IuIpJyCXkQk5RT0IiIpp6AXEUk5Bb2ISMop6EVEUk5BLyKScgp6EZGUU9CL\niKScgl5EJOUU9CIiKaegFxFJOQW9iEjKKehFRFKuyR8HF5Hy0H/Y+ILbjhzcN8GeyJJGI3oRkZRT\n0IuIpJyCXkQk5RT0IiIpp6AXEUk5Bb2ISMop6EVEUk5BLyKScgp6EZGUU9CLiKScgl5EJOUU9CIi\nKaegFxFJuYLOXmlmmwEXunsfM1sPGAXUA68Cg9x9gZmdBewK1AEnuPuz+dqW/mmIiEg+TY7ozexP\nwPVA27joUmCIu28FVAB7mlkPoDewGdAPuDJf29J2X0REmlLI1M10YO+M6z2BifHyGGA7YEtgrLvX\nu/v7QJWZ1eRpKyIirajJoHf3u4AfMhZVuHt9vDwbaA+sCHyV0aZhea62IiLSilryC1OZc+zVwJfA\n1/Fy9vJcbRvVoUM7qqoqC+5MTU11041aKKna5VY3ydrlVjfJ2kn2ubUeS+s9+botqd2SoJ9mZn3c\n/XFgZ2AC8BZwkZkNB9YA2rj7Z2aWq22jZs2aU3BHamqqmTlzdguewuKrXW51k6xdbnWTrJ1kn3NJ\n6rGSfA7l1ufWXheNhX9Lgv5kYISZLQu8Dtzp7vPNbBIwmTAdNChf2xY8noiIFKGgoHf3d4Fe8fKb\nhE/YZLcZCgzNWpazrYiItB59YUpEJOUU9CIiKaegFxFJOQW9iEjKKehFRFJOQS8iknIKehGRlFPQ\ni4iknIJeRCTlFPQiIimnoBcRSTkFvYhIyinoRURSTkEvIpJyCnoRkZRT0IuIpJyCXkQk5RT0IiIp\np6AXEUk5Bb2ISMop6EVEUk5BLyKScgp6EZGUq1rcHRBZmvQfNr5Z7UcO7ptQT2RpohG9iEjKKehF\nRFJOQS8iknKaoxfJoTlz6ZpHlyWdRvQiIimnoBcRSTlN3UhZ0xSLSNMSD3ozawNcBXQD5gID3P2t\npB9XRESC1hjR7wW0dffNzawXcAmwZys8rjRTkqNjjbxFFp/WCPotgYcB3H2KmW3cCo+ZagpNEWmO\n1gj6FYGvMq7PN7Mqd69rhcdukkaxIpJ2FfX19Yk+gJldCkxx93/G6/919zUSfVAREVmoNT5e+RSw\nC0Cco3+lFR5TRESi1pi6uQfY3syeBiqAw1vhMUVEJEp86kZERBYvfTNWRCTlFPQiIimnoBcRSTkF\nvYhIyqUi6M1s58XdB1lymNmai7sPi4uZVeRZvnZr90VaxszWNbNNzaxjqWqW1dkrzeww4HzgO2Bf\n4G1gBNAVGFNE3TPz3ebuf2lp3Yz61cCpwOrAg8DLxZ7YzczWAY4F+gArA58C44Br3f29ojoc6nci\nrON2DctKtC42BK4GVgJuA15193+XoO4fgS9j3cPN7GF3P6nYurH2esB+wDKEjwh3dPejS1B3TeB3\nQNuGZSVYx+OAvrH+xe7+x7j8xoblLWVmxwL7A6sA/wX+4e4ji6z5f8BNwA3u/lExtfLU7+buL5nZ\nMsBRhBMrjnT3BS2sdwdwlLvPLmU/Y+1OwD+BeYTX89pm9i2wf7HrptxG9CcBGwC7EwL/CeANoGeR\ndT+J/zYHfgZMJ4Rn9yLrNhhJeFOqBT4GbiimWHxjOhsYD/wm1t0dmAycZ2ZDi6kf3QEsz6J180kJ\nagL8lfBdis8I62FoieruTQiMnQnbSKn+dgC3x/+3BNYhBF0p/ItwipBSruPMEX3PPMubLW5TGwL9\ngV7AyUBvMxtSTF3g18Ac4CEzu6eUe+dmdhJwnZlVAcOB7YFfApcVUXYyMMXMtipBF7NdCpzk7lu6\n+97u3hM4B7iy6Mr19fVl86+2tvbxjMvv1dbW7lzi+o9kXX+0RHXHZ/3/RJH1Noz/D8lafkH8/5cl\n6PO4hP6G47LWxYQS1X26trZ2rdra2jvi9Skl7HNDX0fG/yeVqG5Jtq+smhPyXB5fZN3JOZa1qa2t\nnVjCvm9SW1t7dW1t7QvZ23ZL+1xbW1sZ+zmztra2Q8O2UmTdzrW1tY/U1taeV5uhBP3NuV3V1tY+\nVmztspq6ATJ3t95z9xZP1+Sxipl1dvfpZtYVaF+qwrEeZrYGML/IcpuZ2QhgfTPbJS6rJEwtnObu\nLT7NhJnVxoufmNkBwPNAPYC7v1lEnxt8YWZHA8ubWT9gVglqAkwAHgcONLPLgaKngzLUm9nPgGoz\nWx5YoUR1X43rYBqlW8f1eS4X6/vsBe6+wMxKdnJCd3/OzCoJ/T4YOLfIkrPdfb6Z9QDedveGba2o\nvZuYD5cCowizABWEPhd7ZsIf8iwveual3IJ+FTPbgbBiV4yXAXD3sSWofzxwt5mtBswAip6Hjf5A\nmL5Zn7C7/vsi691KmIs9HTgvLltAmNcr1rUZlwfEfwDLAVuUoP4rQCdgJrBx/L8UxhJ+52Ak4bQb\npZzvPZvwuwq3EKbgbilR3e7AtkBn4B3C36/YsOgZTzcC8IuMU4+sX2TdfG8aRYUmLDxQfAjQD3iN\ncNxtULF1CW/QtYSpwgfiY3UBWvzmZGbtgb8DXYDeJRr8NFglM9OiCsI0clHKLehfAI4h/KGmEQ5k\nQdgISxH06wHLEg72rkw4MLJuCeo+AqzGonCbaGafAL9390ebW8zd5wLvEg4ulZS7bwNgZscQjok0\nHIDMN9ooiJkdQXjTWB94PS7eKtYvhXOArYG7gL8QTqZX1LGQDOsQBgFtCfPJewOnlKDu1YRR66OE\nueMbS1BzI8IB6VMIpwefRBhczCuy7hZm9mHWsgqgQzFFzexzwuviBmAbdy/FYKXBEMKb8sfAaWbW\nO17/bRE13ybMpR/q7qU+f8wLhDe7hjfPDoS9/xeKLVxuQf884SDQfOBYd3+4xPX/RDio+UGJ6z4B\nDHV3N7POwFmEMLqV8CJfEv0e6E14sfyLEHTFSHIvBGCBu39hZvXu/r2ZlfJTEUltFycCPdz9m/jJ\nrPEUv7ewKaG/1xI/uQHcCZwJFPNprHyDimLD7jXg54RPzvU2s0fd/csiazYYCPyHEJx/A35CeOM7\nCpjSwprLEvYQ1jWzh4FS9vfvhD3STQjb29WEN+uiBxXlFvQHED5h0p7wgih10L+d0O/ZruHuDgvn\n99Zy97dKOb+ZgA/d/SMzq3b3x83srGKKJbkXEr1lZhcQdn8HU1yoZUtqu1jg7t8AuPtsM/vRPHgL\nHA/0cfdvGxaY2SjgfuC+Iup2zbpeARxG2Pu9uaVF3X0rM1uOMNfdBzjKzACecPdzWlo32pgQ7rcB\nDVNYRXHqRVZuAAAERElEQVT36gT7ezFwiLv/YGbnEj5B9hbho+P3F1O43IL+e3f/AfjMzJZNoP4c\nMxsDvMiig2Onl6DuR2Y2jLCx/Rr42My2p/jd6SR9ZWZ7EeY5jwZ+urg71IRjCFNDTwLfAkeWsHZS\n28V0M7uEsMe3NeFjvcWqywx5WPgmUtQHANz9tIbL8XsFowjfCTmhmLqx9lwze54wXVoN9AB+VYK6\nG8XvbRwEDCas51uLfdNOqr9Apbu/HL8otby7vwBgZkVPEZVb0Gcq+t05h4cSqAnhQNNRhHfoVwmf\nHf8Vi44xLIkGEI5ZDCbsOh63eLvTuPjTlNckVD6p7aI/4YD/9oTjFoNLUDPfF4FK8p0ZMxtECPcT\nS/RFt5OAXQnHFR4jfFpqcBzQFc3dXyWuVzPbGrjAzNZ0915LYH8bauwUaxO/6FX0p7zK6nz08QDm\nOELI942XAXD3AxZXv0SWFBmvkUwVhAOdPyui7s8JB4u/AAZmfFSxKGb2JWEK9npgYqkCPusxViR8\nsfB3hC8Bjnb3K1pYK7H+mtmpwB7AmvH/2cAVhGmhC4qpXW5B3zvfbe4+sTX7IrIkSuo1YmazCFON\n48k6AFvMICuOWLci/Nzo1oSPxY4BHnL391taN9bejxDuawF3A7e7+7tF1kysv7H++sBX7v5h/ODG\nRu5+T7F1yyroRWTxaK1BlpntRPhk1hbuXllkrQWEU6S8FBctDLtSzQCUsr9JKuc5ehFpJUntMZvZ\nxoQR8laET/a8RDhn0UElKL9NCWr8j4T7mxiN6EVksTGzcYQvFD4GTEvgS0glVW79baCgFxFJuXI7\nTbGIiDSTgl5EJOV0MFaWama2L3Aa4bXQBrjZ3S82s7OBx9x9UiP33Q2odfdLW6e3Ii2jEb0steKX\ngC4BdnD3boTzl/Qzsz0IJ3Rr6uNyGxN+IUpkiaYRvSzNfko4TXI74PN4FslDCach3hi43sx+Qzin\nyXmxXQfC2SH/Qzi/Dmb2HuEMn1cSfm6vErjQ3e9o3acjkptG9LLUcveXCGd0fNvMnjWzCwknlvoL\nMBUYEH+t67h4uQdwBHCmu79GOLfONe5+I+F0zs/H3/ncGvizmZXitwxEiqagl6Wauw8k/OLV1YRz\nt08xs72zmh0EbGhmZxB+DyHXSaa2A44xsxcJZ0lcnvAj5SKLnaZuZKllZrsCK7j7aMIJu240syMJ\no/ZMk1j0m7TjgNtzlKsEDso4texqhBOAiSx2GtHL0mwO4bS1nQDMrAL4BeFnKuuAKjNbmfBjN2e6\n+0PADiw6SFvHosHSeMIvGmFmqwMvE06mJbLY6ZuxslSLB1//yKLfrn0kXj+OcLD1EGBfwg+Pfw1M\nBvYnhHhPwnlOLo3/X0X4we9KYJi739RqT0SkEQp6EZGU09SNiEjKKehFRFJOQS8iknIKehGRlFPQ\ni4iknIJeRCTlFPQiIimnoBcRSbn/B51QiV4YGEOgAAAAAElFTkSuQmCC\n",
|
||
"text/plain": [
|
||
"<matplotlib.figure.Figure at 0xcb36f60>"
|
||
]
|
||
},
|
||
"metadata": {},
|
||
"output_type": "display_data"
|
||
}
|
||
],
|
||
"source": [
|
||
"title = 'Bottom 15 States by mean crowd estimate'\n",
|
||
"(df.groupby('State').sum()\n",
|
||
" .sort_values('mean-high-low', ascending=True)\n",
|
||
" .head(15)\n",
|
||
" [['mean-high-low']]\n",
|
||
" .plot(kind='bar', title=title)\n",
|
||
" )"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 20,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"<matplotlib.axes._subplots.AxesSubplot at 0x85265c0>"
|
||
]
|
||
},
|
||
"execution_count": 20,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
},
|
||
{
|
||
"data": {
|
||
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEbCAYAAAAh9sTfAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XmYFNW5x/HvMGNEdETUcU1uQMVXoxEjiuCKikZRlLhc\nFVeQuMW4Eq8at8SVRKJeFBVXFEk0UVRQUFn0gmgSBBWT+CoqimtGHRAZFlnuH+cMNp2Z6R66i5ku\nfp/n4aG7lrdO11S9derUcsqWL1+OiIikS6vmLoCIiBSfkruISAopuYuIpJCSu4hICim5i4ikkJK7\niEgKVTR3AdLOzNoD7wIz4qByoBa40N1fyjHvbsBp7n5m/P4c0Mfdv0iwvAcBv3P3nTOGDQKOAb6K\ng9zdj61n3u2AQcAP4qAa4NfuPjmOvxu4091fzVGGvKbL8/c8ALzp7jcVGmtNYmYbA9XuXlakeCu2\nXTN7Bhjg7v8sQtyV9hH5jpL76rEgK1n+N/AA0DHHfDsA38/4fmDxi7aiTOsAvwbOAT7KGr0HcJy7\nT8kR5jHgcncfGWPuAzxtZh3c/StC+e/Kozj5TielY8W26+49ixg3ex+RSMm9eWwEfFr3xcxOB84F\nlgKfExLsAuC3QFszuz9j3olm1hNYH7gtxloODHL3B82sO3AD8Alhw68FrorxDXjM3S+op0w/BdYF\n+sXl1pVtbeAnwAAz2xqYCVzg7h/WE2PzGAMAd/+/eCBbambXAVsAD5vZyUAZ8Dtg7Tjf8+5+Wj3T\nvQXcCvwYWAsYD/zK3ZeY2W+AnwGLgS+BU919xXrNsJeZHR3X2XPAAOBY4Gx33zP+zv8CXgHau/vi\njN//QFyHXYDNgEeBaqBX/N7f3SeY2feAgcC+hLOz6cC57v61mR0GXAZ8D9gEGObuV8S/1XXAe8CO\ncV38wt0nZv8AM+sHXETYRr4ATgG2jutmPrAesFscnr0ttQFGufsPYqxngc/c/ZT49/0E2Ao4IJan\nFvh7Peuxrizbx+VuFH/r/7r7fWa2HnA/odKyDHgVOAO4N85at+1OAo6OZc65rZpZK+BmoCtQSdh2\n+gMfkrGPuHtfM+sFXB7XdS3hDOHlhn5LmqnNffVYx8xei/8+IOwYNwCY2f7AxcB+7t4JGAE8Qag9\nXwlMcve+7t43xtqPcGB4Chjs7jsBhwDXm1m3OM1uwLXuvh1hB78UOBTYBfiFmW2RXUB3fyIm/a+y\nRm0BTIgxdiYkwCfNrL7T9V8Ag83sEzN71MzOAf7u7nPd/deEnfgEd/8rcB5wpbvvDvwIONzMOtcz\n3c3Aq+7emXCQ2Ri40Mx+AJwP7ObuuxKS9u4NrP/vExLXzkAn4OfAn4FtzGyHOE1/QtJdXM/8uwDd\ngF2BC4Bv3H0Pwt/xkjjNJcASoHP8O34C3BjX00XAKbGcXYFLY7MHscyD3P0nhCR4dfbCzawT4cBx\ncPx7P0U4y4JwUDg+Dt+T+rel14FvzWzHeIa2HbB/nP8A4K9Aa+A+4Ki4rj+ob0WaWQXwF+CSON2+\nhAN/V8KBtjKepe4WZ9kqc9t199lZIfPZVncnbIfd3P1HwLC4/Nlk7CNm1hG4HugZ1+fpwONmti5r\nICX31WOBu+8c//0Q6A78ycw6AAcDj7h7NYC7PwBsCbRvJN62QGt3fzzO8wmhSeTgOP59d58eP78L\nTHT3xbGt/mtgw3wL7u7vu3tPD5YDNxFqjP9RPnf/I6EWXlfj7gf8M153yHYKsIGZXQYMAdYh1OSy\nHQacYWavEWqCXQi1+I8JSWuamd0EvObuTzTwMx5y9/kxcQ8HDoyf7wH6m1k5cCowtIH5R7n7t+7+\nGaGWPDYOf5fv1uVhwBHA9FjW3sCP4jrrBXQ2s6uAPxBqnnUJ5wN3fy1+nkb9f5sDgGfrEqO735LR\nxjzb3esScWPb0khCJaA74ezn3/HAdgRh29kLmJHRDt5Qs9i2hL//ffF3vkj42/0EmAzsYGYvEA52\nt7j7zAbi1Mm5rcaa9+WE7eAmvqv1ZzuQsP2Nj2V7mHAGsU2OMqSSmmWagbtPMTMnJKpyQrNCpjJC\nE0RDyglNMZlaZcyzKGvct6tYVMxsJ6CTuz+UVb5vs6bbjtAscgkwLv670syeJ+yM2Rc0/w94g5Ao\nHyXUzuo7GygHjnH3f8XlbAAsd/dlZrYvoTbdA7jZzCa6+3n1xFia8blVRtnvJDQ/vEi46Pp+A6sh\nn/VZDpzn7mNiOdcDWsda43RCcp1EqB33zvitCzJiLKf+dbCEjL93rH3/MH79JqsMDW1LI4FrCDXg\n54F/E5riDiE0GXXPWvaSespRt4y5WdeQNo3DFprZNjHW/sA4M/ulu/+lgViQx7o1s0MJZ0mDgCcJ\nFYcTGyjb+MyL/fEM75NGlp9aqrk3AzPbllADmk5IbseZWVUc15fQfjyTsINlJvml8ftbhNPsI+M8\nWwBHEXbaYlsG/G88ywA4C3jD3bMvun4OnB7btonl2hDYlFAjhfh7YoLeDfifePaxJaF2VZ45Xfz8\nLHCBmZXF9uGngHNiU8WbwL/c/QZC802nBn7DcWa2tpm1JpwxjAGINeGX47x3NGWl1OPZWK7vxTbi\nuwlNbx0Jbf2Xu/soQjPG2hm/NR8TgR5mtnn8fgbhekW2xralKYQa92GEA+9zhGatt939S8LBdoe4\nXiGcydTHgQVmdmJcxg8If4fOZnYWoc39OXf/n7hOdozz1W27q+JAwtnTHYSDcW/q31bGAwfFigax\nff8NwpnFGkfJffXIbHN/jdBmebq7v+3uzxOSywQz+wch+Rzm7ssI7dvbmdnIGOdxwqmvETbw88zs\nDcLO+tv6LsQVyt3fBH4JjDKzfxHaVY+vZ7oaQm3tNDObFX/LOOD37j4hTvYE8AjhjOUGQpPKVEI7\n60t8d/r8BPCIhdsyzyU0Ycwg7KgzCLdqvk6o8U+NMfoR2sPr8z6h1jydkMSGZYy7n5AonmnKeqnH\nNcCsuIx/EmrBF8UyjwbeMrNpwOFxfN5NBe4+A/gVMNbMXic0v/zHrX+NbUtxexoDzIvNNpMJTUCP\nxXmrgT6EC9nTgA7Z8eN0iwlNOf3jtvcccIWH23ofJKzLf5rZq0BbQo0b4rZrZjvWEzaXO4HucXkv\nE5pvOsSD6Ip9JDYpnU5o8nyd8Dc53N2/aShwmpXplb+yporJ4TZCu/fA5i6PSDGp5i5rJDOrJDRZ\nbE1I8CKpopq7iEgKqeYuIpJCSu4iIimk5C4ikkIt5iGm6up5eTf+t2vXhpqa2qKXIam4ScZW3ORj\nl1rcJGOXWtwkY7eUuFVVlfW+ubMka+4VFU15/qP54yYZW3GTj11qcZOMXWpxk4zd0uOWZHIXEZHG\nKbmLiKSQkruISAopuYuIpJCSu4hICuW8FdLM1iK8g7o94VWl17r7UxnjexF6Q1kC3Ofud8f3TQ8n\ndCk2j9ALTXXxiy8iIvXJp+Z+IvClu+9NeLH/ipcsxcR/M3AQ4T3Vp5vZZoR3fs+I8zxI6EVFRERW\nk3weYvoz4f3jdTJ7aNkemBnf5Y2ZTQb2JnTZVdeZwBjgisKLCv1unJB7oia475L9c0+0Gh19dC8e\nfvgvrL322iuGvfLKFD7//DOOOOLIeucZPHgwrVuvR+/eR9c7HuC6667mgAMOomvXPYpeZhFpmXIm\n97oX3cdXpP6FlWvh6wNzM77PI7ygP3N43TBZBUrIIrIq8nr9QOxKayQwxN1HZIz6GqjM+F4JzMka\nXjesUe3atUn0KbX6VFVVNjrs8ccfZ+LEiSxcuJDq6mpOPvlkxo8fzzvvvMPFF1/Mt99+ywMPPECr\nVq3o3LkzAwYM4LPPPuPqq69m0aJFVFdXc/7559OjRw969epFly5dcHfKysoYMmQIlZUrL7+8vBW3\n3z6Ijz4KPdjddtttjB8/nvfee48BAwZw++23M27cODbccEMWLFjAeeeF7kL/+teXmDz5BebMmcN5\n553H/vuvfEbSuvVatG27Dhts0JrLLruM2bNns3TpUvr27UuHDh245ZZbuOuuuxg9ejRDhw7lqaee\nYurUqTz55JNcc801xV7t9a73lh671OImGbvU4hYau9dFTzZp+lGDjkgkdlPiQn4XVDcldKV1jruP\nzxr9L6Bj7CvzG2AfQkfIPwR6An8jtNNPyrWcpN4r0Zjq6nkrfa+qqlxp2Lx5C6mpmcvNN9/OuHHP\n8uCDwxk69AGmT3+VESMe5uOPP+Keex6idevWXHPNFTzzzPNAGT/72bHsssuuzJjxOvfeexedOu3O\n/Pnz2XPP/TjzzPP5zW8uZ/ToZ+nR46crLX/p0mUccEBPOnXameuuu5oxY8azaNFCamsXM2XKq0yY\n8AJ33HE/S5Z8y8knH8ecOWGdtW27IZdccgXTpk1l2LAH+fGPd1sp7sKF3zJ37gLuvXcYrVuvy+DB\nd1NbO59+/U7kzjvv58MPZ/PRR1/w/PMTWLp0Oe6zmDBhAl267PUf66hQ2eu4FGKXWtwkY5da3KRj\n1yepZTUUt6EDVz4198uAdsAVZlbXdn43sK67DzWzCwkd4bYi3C3zsZndAQyLbfCLCX0zlqSOHQ2A\n9darpH37DpSVlVFZWcmCBQuYM6eGAQPOBaC2tpaPP/6YnXbamWHD7uXpp58Eyliy5LtLFNtuG2Jt\nssmmLF68mMcee4SJE8Px8qqrrgVgu+22A2DDDTdi0aKFK+b94IP32X77HSgvL6e8vJztttt+xTiz\n8HmjjTZm4cKFvP76a9x99xAA+vQ5ecV0s2bNYtdduwDQps26tG/fgY8//oguXboxffqr/Pvfn3PQ\nQQczderfmDp1Kied9PPirUgRWa3yaXM/DzivkfGjgFFZw2qBYwouXQtQVlbvC9coKytjk0025ZZb\nhlBRUcEzz4yiY8dtueeeO+nVqzfduu3J008/xZgxozPnWinGUUcdy1FHHZsdud7ldeiwNY899gjL\nli1jyZIlvP22Z5Rl5Wk7ddqZ224buuL7xInjAGjfvj1vvDGdfffdj9ra+bz77rtsscUW7LNPd4YO\nHULHjkaXLt34/e+vZ+utO1BR0WJeGioiTaS9dxWVl1dw7LEncM45p7N06VI233wL9t//QPbb7wBu\nv/1Whg9/gKqqTZgzJ+flhrxsvfU2dO26J2eccSpt225ARUVFk5Pv4YcfycCB13LWWaexaNEi+vX7\nOe3abcgGG7Rj9uwPOOGEk9lmm4589tmnnHXWGUUpt4g0jxbTh2pT3ue+Jrb71dR8xcSJ4znyyGNY\nvHgxJ53039x66538+McdS2pdtOR1nJa4ScYutbjFiN3UW7Cbcot1U2I3FLeh97mr5l4i2rbdgLfe\n+if9+59MWRkcdlhvNttss+Yuloi0UEruJaJVq1ZcdtlVzV0MESkRenGYiEgKKbmLiKSQkruISAop\nuYuIpJCSu4hICim5i4ikkJK7iEgKKbmLiKSQkruISAopuYuIpJCSu4hICim5i4ikkJK7iEgKKbmL\niKRQXq/8NbPdgYHu3j1j2GbAnzIm2xm4BLgL+Ah4Jw5/2d0vLUppRUQkLzmTu5ldDJwEzM8c7u6f\nAd3jNN2A6wgdZ28NTHP3XsUurIiI5CefZpl3gSMbGmlmZcBg4Cx3Xwp0BrY0s4lm9oyZWXGKKiIi\n+cpZc3f3x8ysfSOT9AL+4e4ev38K3ODufzazvYDhwG65ltOuXRsqKsrzKHJQVVWZ97RNkVTcJGMr\nbvKxSy1ukrFLLW7SsVfXspoatxjd7J0I3JrxfSqwBMDdJ5vZlmZW5u6NdoBdU1Ob9wLXxE56Fbf5\nYpda3CRjl1rcpGPXJ6llNRS3oaRfjLtlOgNTMr5fBZwPYGadgA9zJXYRESmuJtfczawPsJ67DzWz\nKmBeVvK+ERhuZocSavCnFqWkIiKSt7ySu7vPArrGzyMyhlcTboHMnLYGOLR4RRQRkabSQ0wiIimk\n5C4ikkJK7iIiKaTkLiKSQkruIiIppOQuIpJCSu4iIimk5C4ikkJK7iIiKaTkLiKSQkruIiIppOQu\nIpJCSu4iIimk5C4ikkJK7iIiKaTkLiKSQkruIiIppOQuIpJCeXWzZ2a7AwPdvXvW8AuB04DqOOgM\n4ENgOLAJMA84JXbHJyIiq0nOmruZXQzcA7SuZ/QuwMnu3j3+c+AsYIa77w08CFxezAKLiEhu+TTL\nvAsc2cC4zsClZjbZzC6Nw/YCxsbPY4AehRVRRESaKmezjLs/ZmbtGxj9J+B24GtgpJkdBqwPzI3j\n5wFt8ylIu3ZtqKgoz2dSAKqqKvOetimSiptkbMVNPnapxU0ydqnFTTr26lpWU+Pm1eZeHzMrA25x\n97nx+9PATwiJvq4UlcCcfOLV1NTmveyqqkqqq+c1qbzNGTfJ2IqbfOxSi5tk7FKLm3Ts+iS1rIbi\nNpT0Vzm5E2rob5rZ9sB8YH/gPqAW6An8DTgEmFTAMkREZBU0ObmbWR9gPXcfamaXAROBRcB4d3/G\nzF4AhpnZZGAx0KeYBRYRkdzySu7uPgvoGj+PyBj+EPBQ1rS1wDHFK6KIiDSVHmISEUkhJXcRkRRS\nchcRSSEldxGRFFJyFxFJISV3EZEUUnIXEUkhJXcRkRRSchcRSSEldxGRFFJyFxFJISV3EZEUUnIX\nEUkhJXcRkRRSchcRSSEldxGRFFJyFxFJISV3EZEUyqubPTPbHRjo7t2zhh8PnA8sBd4Aznb3ZWY2\nHZgbJ3vf3fsWr8giIpJLzuRuZhcDJwHzs4avA1wL/Njda83sj8BhZvYcQPaBQEREVp98mmXeBY6s\nZ/giYI/YITaEA8VCoBPQxsyeM7MJZta1OEUVEZF85ay5u/tjZta+nuHLgM8BzOyXwHrA88COwE3A\nPUBHYIyZmbsvaWw57dq1oaKiPO+CV1VV5j1tUyQVN8nYipt87FKLm2TsUoubdOzVtaymxs2rzb0h\nZtYK+B2wLXCUuy83s7eBme6+HHjbzL4ENgdmNxarpqa2sdErqaqqpLp63qoXfDXHTTK24iYfu9Ti\nJhm71OImHbs+SS2robgNJf1C75a5C2gN9M5onukHDAIwsy2A9YFPC1yOiIg0QZNr7mbWh9AEMxU4\nDZgETDAzgFuBe4EHzGwysBzol6tJRkREiiuv5O7us4Cu8fOIjFEN1fz7FFYsEREphB5iEhFJISV3\nEZEUUnIXEUkhJXcRkRRSchcRSSEldxGRFFJyFxFJISV3EZEUUnIXEUkhJXcRkRRSchcRSSEldxGR\nFFJyFxFJISV3EZEUUnIXEUkhJXcRkRRSchcRSSEldxGRFMqrmz0z2x0Y6O7ds4b3Aq4ElgD3ufvd\nZrYOMBzYBJgHnOLu1UUttYiINCpnzd3MLgbuAVpnDV8LuBk4CNgXON3MNgPOAma4+97Ag8DlxS60\niIg0Lp9mmXeBI+sZvj0w091r3H0xMBnYG9gLGBunGQP0KEZBRUQkfzmbZdz9MTNrX8+o9YG5Gd/n\nAW2zhtcNy6lduzZUVJTnMykAVVWVeU/bFEnFTTJ2oXF7XfRk3tOOGnREauMmGTvNcZOM3RLiNlVL\n2c/zanNvwNdA5tIqgTlZw+uG5VRTU5v3gquqKqmunpf39M0dN8nYSZa5Pkktq9TiJhm71OImGbvU\n4iYZu6G4DSX9QpL7v4COZrYh8A2wD3AT8EOgJ/A34BBgUgHLEBGRVdDk5G5mfYD13H2omV0IPEto\nu7/P3T82szuAYWY2GVgM9ClqiUVEJKe8kru7zwK6xs8jMoaPAkZlTVsLHFO8IoqISFPpISYRkRRS\nchcRSSEldxGRFFJyFxFJISV3EZEUUnIXEUkhJXcRkRRSchcRSSEldxGRFFJyFxFJISV3EZEUUnIX\nEUkhJXcRkRRSchcRSSEldxGRFFJyFxFJISV3EZEUUnIXEUmhnN3smVkrYAjQCVgE9Hf3mXHczsAt\nGZN3BXoTOsd+G3gzDh/p7rcWsdwiItKIfPpQ7Q20dvduZtYVGAQcAeDurwHdAczsGOATdx9rZj2A\nP7r7L5MptoiINCaf5L4XMBbA3V8xs12zJzCzdYHfAPvEQZ2BXczsReDfwLnu/mlxiiwiIrnkk9zX\nB+ZmfF9qZhXuviRj2GnAn939i/j9LeBVdx9nZicAg4GjG1tIu3ZtqKgoz7vgVVWVeU/bFEnFTTJ2\nkmVeXcsqtbhJxi61uEnGLrW4ScZuatx8kvvXQGbUVlmJHeAEVk7eE4Da+Hkk8NtcC6mpqc01yQpV\nVZVUV8/Le/rmjptk7CTLXJ+kllVqcZOMXWpxk4xdanGTjN1Q3IaSfj53y7wE9ASIbe4zMkeaWVtg\nbXefnTH4HuCo+PkA4NU8liMiIkWST819JHCgmU0ByoC+ZnYhMNPdnwK2BWZlzXMJcJ+ZnQ3MB/oX\nr8giIpJLzuTu7suAM7MGv5Ux/u+EO2oy53kf2K8YBRQRkabTQ0wiIimk5C4ikkJK7iIiKaTkLiKS\nQkruIiIppOQuIpJCSu4iIimk5C4ikkJK7iIiKaTkLiKSQkruIiIppOQuIpJCSu4iIimk5C4ikkJK\n7iIiKaTkLiKSQkruIiIplLMnJjNrBQwBOgGLgP7uPjNj/P8CewJ1vbceAawFjADWAT4B+rp7/j1g\ni4hIQfKpufcGWrt7N0LfqIOyxu8C/NTdu8d/c4ErgRHuvjcwHTijmIUWEZHG5ZPc9wLGArj7K8Cu\ndSNirb4jMNTMXjKzftnzAGOAHkUrsYiI5JRPcl8fmJvxfamZ1TXnrAsMBk4EDgbONrOdsuaZB7Qt\nTnFFRCQfOdvcga+Byozvrdx9SfxcC9xa155uZhMIbfN18yyI/8/JtZB27dpQUVGed8GrqipzT7QK\nkoqbZOwky7y6llVqcZOMXWpxk4xdanGTjN3UuPkk95eAXsCjZtYVmJExblvgT2a2C+EsYC9gWJyn\nJ/AAcAgwKddCamryv95aVVVJdfW83BM2UVJxk4ydZJnrk9SySi1ukrFLLW6SsUstbpKxG4rbUNLP\nJ7mPBA40sylAGdDXzC4EZrr7U2b2MPAK8C3woLv/w8yuBYaZ2c+BL4A+Tf4lIiKyynImd3dfBpyZ\nNfitjPG/A36XNc/nhDZ4ERFpBnqISUQkhZTcRURSSMldRCSFlNxFRFJIyV1EJIWU3EVEUkjJXUQk\nhZTcRURSSMldRCSFlNxFRFJIyV1EJIWU3EVEUkjJXUQkhZTcRURSSMldRCSFlNxFRFJIyV1EJIWU\n3EVEUihnN3tm1goYAnQCFgH93X1mxvgLgOPi12fc/TdmVgZ8BLwTh7/s7pcWteQiItKgfDrI7g20\ndvduZtYVGAQcAWBmWwEnALsDy4FJZjYSqAWmuXuvZIotIiKNyadZZi9gLIC7vwLsmjFuNnCwuy+N\nHWmvBSwEOgNbmtlEM3vGzKzI5RYRkUbkk9zXB+ZmfF9qZhUA7v6tu39hZmVmdhMw3d3fBj4FbnD3\n/YDrgeHFLriIiDQsn2aZr4HKjO+t3H1J3Rczaw3cB8wDzo6DpwJLANx9spltaWZl7r68oYW0a9eG\nioryvAteVVWZe6JVkFTcJGMnWebVtaxSi5tk7FKLm2TsUoubZOymxs0nub8E9AIejW3uM+pGxAun\nTwIT3H1gxjxXAV8CvzOzTsCHjSV2gJqa2rwLXVVVSXX1vLynb+64ScZOssz1SWpZpRY3ydilFjfJ\n2KUWN8nYDcVtKOnnk9xHAgea2RSgDOhrZhcCM4FyYF9gbTM7JE5/KXAjMNzMDiXU4E/N/yeIiEih\ncib3eKH0zKzBb2V8bt3ArIeuaqFERKQweohJRCSFlNxFRFJIyV1EJIWU3EVEUkjJXUQkhZTcRURS\nSMldRCSFlNxFRFJIyV1EJIWU3EVEUkjJXUQkhZTcRURSSMldRCSFlNxFRFJIyV1EJIWU3EVEUkjJ\nXUQkhZTcRURSKGc3e2bWChgCdAIWAf3dfWbG+J8DZxD6Sr3W3Ueb2cbACGAd4BOgr7vn3wO2iIgU\nJJ+ae2+gtbt3Ay4BBtWNMLPNgHOBPYGfAjeY2drAlcAId98bmE5I/iIisprkk9z3AsYCuPsrwK4Z\n47oAL7n7InefC8wEdsqcBxgD9ChaiUVEJKd8kvv6wNyM70vNrKKBcfOAtlnD64aJiMhqUrZ8+fJG\nJzCzPwCvuPuj8ftH7v79+Plw4GB3Pzt+HwlcBwyNw/9tZp2A69z9sAR/h4iIZMin5v4S0BPAzLoC\nMzLG/Q3Y28xam1lbYHvgzcx5gEOASUUrsYiI5JRPzb3ubpmdgDKgLyFxz3T3p+LdMqcTDhTXu/tj\nZrYpMAyoBL4A+rj7/OR+hoiIZMqZ3EVEpPToISYRkRRSchcRSSEldxGRFFJyF1kNzOwMM/tePcPP\nbo7ySHGY2SHNXYaGlGRyN7PWRYhRVoyytAQteQOTFW4CJpnZFlnDj26OwkjTmNmpZvaJmb1rZj8x\ns7Zm9igwsLnL1pCcLw5rScxsK+AXwInApgWGGw/sX3Ch6hFfnLYg8/ZPMzvL3e8oMO6pwPXAAkJS\neA+4G9iO8JqHVY17UEPj3P25VY0bY78PZN6SVXdQXe7uWxUQ93uEdXEUsDbhSehHgN+6+5IC4ia1\nLqYSHu6bbGYnuvuUOLwolYwktrmEt4syYB/gh8CHwIvuXpRb9xKKfSGwA7A54f1aWwBPAicUGDex\nfaQkkruZ9QTOIbyg7EZg5+YtUcPM7FLgNKDCzE4D3iEknblAQcmd5DawM4E58XNmslkOFLQTA6OA\nzsA4YDhhZyuGQcCnwPbuvtDMKoGLCTXk8wuIm9S6WO7ufzQzB/5kZje5+9AC4q2Q4DaXyLqIz8GM\nJryL6n2gF/AHMzvU3T9d1bgJx/7K3WuAGjP7EXCmu69yhSpLIvtIi07uZnYRcCrwOmFnbuXuNxQp\n/A5mNqK+Ee7ep4C4xwE/AjYG/kQ4wxjo7vcVELNOUhvYRoRXOr9AOAN43t3nNDpHntz93Pgg3EHA\nFcCGwBPAo4RXSK+qzu6+R8Zy5gFXmNkLBcSE5NZFGYC7TzOzPQgJvjPF2QeT2uaSWheDgEvcfXzd\nADM7GLjVsSWtAAAHqUlEQVSZ8FtaYuxlGZ8/KGJiT2wfadHJHRgA/BG4391nxGRfLJ8AdxUxXp2v\n3H0x8ImZbQkc4+7TihQ7kQ3M3feNr2ruBnQHTjczCKez1xYh/jLCW0LHmtmGhNrkYML7/ldVQxv9\nsgaG5yXBdfFyxjK+iE0e9wB7NDxL3hLZ5hJcFz/ITL5xWWPN7IoCYiYdeyMzO5BwnXL9zCarQpuo\nYoyi7yMtPbm3J7Sp3mpm6wJtzKxtfL1woea4+4tFiJMts+3swyImdggb2EGEWmBRNzB3X2RmrxJq\nDZXALvFfwWKt5EDgeEKT2hhgtwLDlpnZWqzcXFBGEW4SSGJduPtldZ/NbDdCM+NPCa/pKFRi21xC\n28XSggu2+mNPA+rO6KcTzgKqCNt1MW7wKPo+0tKT+7buPgIYYWbbAD8HXjezqe5e6F0GT5vZ6cB9\n7r7EzPYGdnD3OwuMu2WMWwZsHj8DUIQ21mmEdtAlhA3s+Di80DbQC4FDgQ0I7X6jCae23xZU2hD7\ndmBfwqn90IwLiYX6IeBFirVCUusiXgA+nnBDwCLCa7E7uPuCwkoMJLTNJbhdfGhmvdx9VMayDgVm\nFRg3sdju3jcjXhfCwXk34N5C4sZ4iewjLT25Dzaz7wMvEk5ZbgAuAw4vQuz1gK6ECxhLgNnABWZW\n5e7XFBB3BLAZsBXhgt8ehLtainFXxKvARYTayTnuPjbH9Pm6ku/W74vFSOoZzgK+JJyBHRlP6wFw\n9+zbApviBcJBLXu9FnpXRFLrYhahifEEd3/HzMYUKbFDcttcUutiAPB4fOngu0AHwnWCXi01dsbB\n+WxgMcU9OCeyj7To5O7u3bPb/OKo/wNGFhj+EKBr3S1S7j7LzI4FpgCFJPdBhJ14Y8LV+h0Ip2/H\nNzZTnvoA2xI6P3mI73q7KlQVsDfhbZ/Xm9mnhNPCZ9y90Cv3fRsYXmgS3gVoAzxM+JtBcQ6gSa2L\nWwl/v/Zmdg9FugUySmqbS2RdxGsOIwiVlfaEfXkHd/+iwPImGXsWYR2fmMDBOZF9pEUnd2iwze8n\nRQg9P/veV3f/1szmFRj3RuDP7v5g3YB4e9rvKbwv2YWx9vRFfU87rqoYc0L8V3d3wWXA7UB5geG3\ny/peRrgDagHw4H9MnSd372RmOxKeebiEcMAfntl5+yrGTWRduPtAYKCZ7Qv0B3Yzs4HAQ+7+ZiFl\nJqFtLql1YWZXAzsCD7r7382sPXC+mW1c4FlzkrGTPDgnso+06Ff+1tPmNxaYXKS24NHAue7+Xsaw\nrYC73f2AAuJO8tAxePbwlz10Mr7KzGyCu++f/blQZrYroYa2N2FDe52wvp8vQs09cznbAA8Q2srP\nj7cvFiv2PsAvCXdLdC0gzupaFxsAJwH93L2gykpS21xS68LM/krGWXMcthYwxd0LuoiYZOwYq+7g\n3JNwt1MxDs6Z8Yu2j7T0mnuSbcH/AzxhZuMJ7ZP/Rbh74ZQC4zZUxlV+ajJD3b35ZWTdp1/gvfkD\ngWeBa4Hp2Wc0xWBmvyA8XHSBu48uYtz1gZ8RmiDWJVxDKUTi6wIg3i8+OP4rVFLbXFLr4puEzpqT\njk28w+7FjIPzQxSnJaHo+0hLT+6JtQW7+z/iHTJHEJ70nEZ4dL3QjeArM9vV3afWDYg1oK8KjAvw\n3xmfC72rZ4VCzlRyifdd30/4/V08PIRVjLjHEBL6fwGPEx7omlVo3CTXRYIS2eYSXBcLzGyres6a\ni3HwSDL2CsU8OCe1j7ToZplsGW1+e7p7oW3BiYhtfE8R7uaou1rfA+jl7u83X8mah5nVEO4umEDW\nDlbI2YaZLQPeIjQVkBm7wLOYklNq25yZ7UC4OPkfZ83uPr2lxk5KUvtIi07uq6v9s9gsvLXyUMKt\naR8DT/oa2odsbKOsVyEPkSUVt1SV2jZnZm357qz5A2B0sa7BJBk7CUltyy09uY8ntPmNI8H2TxGR\ntGnRyV1ERFZNSXbWISIijVNyFxFJoZZ+K6RIIszsaOBSwj7QivBE4+/N7DfAOHef1Mi8hxFeaveH\n1VNakaZTzV3WOPG+4kHAQe7eifDuouPM7HDC2/ly3Wa7K+HFUSItlmrusibaGFiL8OKxL939GzM7\nBTiSkLjvMbOfEd5ndF2crh2hG79/EF67jJl9APyZ8K6VHQkHhYHu/sfV+3NE/pNq7rLGcffXCX3P\nvmdmf4sv8Cp3998SOrLu7+4zCO+q6e/uuxD6KL3S3f9JeDr4Tne/H7gceNXdOxM6Zf51fCJSpFkp\nucsayd3PIrwS9g5Cxx+vmNmRWZOdCOxooYu2iwh9AGTrAZxpZq8R3ky5LuGVuyLNSs0yssaJPfOs\n5+6PEN7pcX/s3OG0rEknARMJj/WPJ3SKka2c8I7vaTH2phTnPUIiBVHNXdZEtcAN8Z0smFkZ8CNC\n14VLgAoLnRRvS2iKeYbQM33dhdYlfFcxmkDoSQcz2xx4g/A+E5FmpSdUZY0UL6D+inBhFcJrLn5F\naGc/EzgZOJrwjpKvgZeBYwmJuzOhY+s/xP+HEDo1LgdudPdidHotUhAldxGRFFKzjIhICim5i4ik\nkJK7iEgKKbmLiKSQkruISAopuYuIpJCSu4hICim5i4ik0P8DWaOMbDD2GJcAAAAASUVORK5CYII=\n",
|
||
"text/plain": [
|
||
"<matplotlib.figure.Figure at 0xb7bb978>"
|
||
]
|
||
},
|
||
"metadata": {},
|
||
"output_type": "display_data"
|
||
}
|
||
],
|
||
"source": [
|
||
"title = 'Bottom 15 States by mean crowd estimate'\n",
|
||
"(df.sort_values('mean-high-low', ascending=True)\n",
|
||
" .head(15)\n",
|
||
" .set_index('State')[['mean-high-low']]\n",
|
||
" .plot(kind='bar', title=title)\n",
|
||
" )"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# Conclusion"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"This is my first 15 minute data explore, and 15 minutes flys by very quickly. I was able to gain a bit of an understanding of the dataset, but not able to do much analysis at this point."
|
||
]
|
||
}
|
||
],
|
||
"metadata": {
|
||
"kernelspec": {
|
||
"display_name": "Python [conda root]",
|
||
"language": "python",
|
||
"name": "conda-root-py"
|
||
},
|
||
"language_info": {
|
||
"codemirror_mode": {
|
||
"name": "ipython",
|
||
"version": 3
|
||
},
|
||
"file_extension": ".py",
|
||
"mimetype": "text/x-python",
|
||
"name": "python",
|
||
"nbconvert_exporter": "python",
|
||
"pygments_lexer": "ipython3",
|
||
"version": "3.4.5"
|
||
}
|
||
},
|
||
"nbformat": 4,
|
||
"nbformat_minor": 1
|
||
}
|