16_Regression.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:5fad55cb6c3e291b81b092723faaa825d58d48d582e071b8947e112664eed632"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "%matplotlib inline"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "communities = pd.read_csv('community_crime_rates_socio.csv')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "communities"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>Unnamed: 0</th>\n",
        "      <th>Crime Count</th>\n",
        "      <th>population</th>\n",
        "      <th>Crime Rate</th>\n",
        "      <th>Community Area Number</th>\n",
        "      <th>COMMUNITY AREA NAME</th>\n",
        "      <th>PERCENT OF HOUSING CROWDED</th>\n",
        "      <th>PERCENT HOUSEHOLDS BELOW POVERTY</th>\n",
        "      <th>PERCENT AGED 16+ UNEMPLOYED</th>\n",
        "      <th>PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA</th>\n",
        "      <th>PERCENT AGED UNDER 18 OR OVER 64</th>\n",
        "      <th>PER CAPITA INCOME</th>\n",
        "      <th>HARDSHIP INDEX</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>0</td>\n",
        "      <td>3525</td>\n",
        "      <td>54991</td>\n",
        "      <td>64.101398</td>\n",
        "      <td>1</td>\n",
        "      <td>Rogers Park</td>\n",
        "      <td>7.7</td>\n",
        "      <td>23.6</td>\n",
        "      <td>8.7</td>\n",
        "      <td>18.2</td>\n",
        "      <td>27.5</td>\n",
        "      <td>23939</td>\n",
        "      <td>39</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>1</td>\n",
        "      <td>3063</td>\n",
        "      <td>71942</td>\n",
        "      <td>42.575964</td>\n",
        "      <td>2</td>\n",
        "      <td>West Ridge</td>\n",
        "      <td>7.8</td>\n",
        "      <td>17.2</td>\n",
        "      <td>8.8</td>\n",
        "      <td>20.8</td>\n",
        "      <td>38.5</td>\n",
        "      <td>23040</td>\n",
        "      <td>46</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>2</td>\n",
        "      <td>3592</td>\n",
        "      <td>56362</td>\n",
        "      <td>63.730883</td>\n",
        "      <td>3</td>\n",
        "      <td>Uptown</td>\n",
        "      <td>3.8</td>\n",
        "      <td>24.0</td>\n",
        "      <td>8.9</td>\n",
        "      <td>11.8</td>\n",
        "      <td>22.2</td>\n",
        "      <td>35787</td>\n",
        "      <td>20</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>3</td>\n",
        "      <td>1751</td>\n",
        "      <td>39493</td>\n",
        "      <td>44.336971</td>\n",
        "      <td>4</td>\n",
        "      <td>Lincoln Square</td>\n",
        "      <td>3.4</td>\n",
        "      <td>10.9</td>\n",
        "      <td>8.2</td>\n",
        "      <td>13.4</td>\n",
        "      <td>25.5</td>\n",
        "      <td>37524</td>\n",
        "      <td>17</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>4</td>\n",
        "      <td>1379</td>\n",
        "      <td>31867</td>\n",
        "      <td>43.273606</td>\n",
        "      <td>5</td>\n",
        "      <td>North Center</td>\n",
        "      <td>0.3</td>\n",
        "      <td>7.5</td>\n",
        "      <td>5.2</td>\n",
        "      <td>4.5</td>\n",
        "      <td>26.2</td>\n",
        "      <td>57123</td>\n",
        "      <td>6</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>5</td>\n",
        "      <td>5511</td>\n",
        "      <td>94368</td>\n",
        "      <td>58.399034</td>\n",
        "      <td>6</td>\n",
        "      <td>Lake View</td>\n",
        "      <td>1.1</td>\n",
        "      <td>11.4</td>\n",
        "      <td>4.7</td>\n",
        "      <td>2.6</td>\n",
        "      <td>17.0</td>\n",
        "      <td>60058</td>\n",
        "      <td>5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>6</td>\n",
        "      <td>3729</td>\n",
        "      <td>64116</td>\n",
        "      <td>58.160210</td>\n",
        "      <td>7</td>\n",
        "      <td>Lincoln Park</td>\n",
        "      <td>0.8</td>\n",
        "      <td>12.3</td>\n",
        "      <td>5.1</td>\n",
        "      <td>3.6</td>\n",
        "      <td>21.5</td>\n",
        "      <td>71551</td>\n",
        "      <td>2</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td>7</td>\n",
        "      <td>8944</td>\n",
        "      <td>80484</td>\n",
        "      <td>111.127678</td>\n",
        "      <td>8</td>\n",
        "      <td>Near North Side</td>\n",
        "      <td>1.9</td>\n",
        "      <td>12.9</td>\n",
        "      <td>7.0</td>\n",
        "      <td>2.5</td>\n",
        "      <td>22.6</td>\n",
        "      <td>88669</td>\n",
        "      <td>1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td>8</td>\n",
        "      <td>254</td>\n",
        "      <td>11187</td>\n",
        "      <td>22.704925</td>\n",
        "      <td>9</td>\n",
        "      <td>Edison Park</td>\n",
        "      <td>1.1</td>\n",
        "      <td>3.3</td>\n",
        "      <td>6.5</td>\n",
        "      <td>7.4</td>\n",
        "      <td>35.3</td>\n",
        "      <td>40959</td>\n",
        "      <td>8</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9</th>\n",
        "      <td>9</td>\n",
        "      <td>1259</td>\n",
        "      <td>37023</td>\n",
        "      <td>34.005888</td>\n",
        "      <td>10</td>\n",
        "      <td>Norwood Park</td>\n",
        "      <td>2.0</td>\n",
        "      <td>5.4</td>\n",
        "      <td>9.0</td>\n",
        "      <td>11.5</td>\n",
        "      <td>39.5</td>\n",
        "      <td>32875</td>\n",
        "      <td>21</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td>10</td>\n",
        "      <td>1144</td>\n",
        "      <td>25448</td>\n",
        "      <td>44.954417</td>\n",
        "      <td>11</td>\n",
        "      <td>Jefferson Park</td>\n",
        "      <td>2.7</td>\n",
        "      <td>8.6</td>\n",
        "      <td>12.4</td>\n",
        "      <td>13.4</td>\n",
        "      <td>35.5</td>\n",
        "      <td>27751</td>\n",
        "      <td>25</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td>11</td>\n",
        "      <td>444</td>\n",
        "      <td>18508</td>\n",
        "      <td>23.989626</td>\n",
        "      <td>12</td>\n",
        "      <td>Forest Glen</td>\n",
        "      <td>1.1</td>\n",
        "      <td>7.5</td>\n",
        "      <td>6.8</td>\n",
        "      <td>4.9</td>\n",
        "      <td>40.5</td>\n",
        "      <td>44164</td>\n",
        "      <td>11</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td>12</td>\n",
        "      <td>830</td>\n",
        "      <td>17931</td>\n",
        "      <td>46.288551</td>\n",
        "      <td>13</td>\n",
        "      <td>North Park</td>\n",
        "      <td>3.9</td>\n",
        "      <td>13.2</td>\n",
        "      <td>9.9</td>\n",
        "      <td>14.4</td>\n",
        "      <td>39.0</td>\n",
        "      <td>26576</td>\n",
        "      <td>33</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td>13</td>\n",
        "      <td>2508</td>\n",
        "      <td>51542</td>\n",
        "      <td>48.659346</td>\n",
        "      <td>14</td>\n",
        "      <td>Albany Park</td>\n",
        "      <td>11.3</td>\n",
        "      <td>19.2</td>\n",
        "      <td>10.0</td>\n",
        "      <td>32.9</td>\n",
        "      <td>32.0</td>\n",
        "      <td>21323</td>\n",
        "      <td>53</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>14</td>\n",
        "      <td>3399</td>\n",
        "      <td>64124</td>\n",
        "      <td>53.006675</td>\n",
        "      <td>15</td>\n",
        "      <td>Portage Park</td>\n",
        "      <td>4.1</td>\n",
        "      <td>11.6</td>\n",
        "      <td>12.6</td>\n",
        "      <td>19.3</td>\n",
        "      <td>34.0</td>\n",
        "      <td>24336</td>\n",
        "      <td>35</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td>15</td>\n",
        "      <td>2967</td>\n",
        "      <td>53359</td>\n",
        "      <td>55.604490</td>\n",
        "      <td>16</td>\n",
        "      <td>Irving Park</td>\n",
        "      <td>6.3</td>\n",
        "      <td>13.1</td>\n",
        "      <td>10.0</td>\n",
        "      <td>22.4</td>\n",
        "      <td>31.6</td>\n",
        "      <td>27249</td>\n",
        "      <td>34</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td>16</td>\n",
        "      <td>1636</td>\n",
        "      <td>41932</td>\n",
        "      <td>39.015549</td>\n",
        "      <td>17</td>\n",
        "      <td>Dunning</td>\n",
        "      <td>5.2</td>\n",
        "      <td>10.6</td>\n",
        "      <td>10.0</td>\n",
        "      <td>16.2</td>\n",
        "      <td>33.6</td>\n",
        "      <td>26282</td>\n",
        "      <td>28</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td>17</td>\n",
        "      <td>575</td>\n",
        "      <td>13426</td>\n",
        "      <td>42.827350</td>\n",
        "      <td>18</td>\n",
        "      <td>Montclaire</td>\n",
        "      <td>8.1</td>\n",
        "      <td>15.3</td>\n",
        "      <td>13.8</td>\n",
        "      <td>23.5</td>\n",
        "      <td>38.6</td>\n",
        "      <td>22014</td>\n",
        "      <td>50</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td>18</td>\n",
        "      <td>4775</td>\n",
        "      <td>78743</td>\n",
        "      <td>60.640311</td>\n",
        "      <td>19</td>\n",
        "      <td>Belmont Cragin</td>\n",
        "      <td>10.8</td>\n",
        "      <td>18.7</td>\n",
        "      <td>14.6</td>\n",
        "      <td>37.3</td>\n",
        "      <td>37.3</td>\n",
        "      <td>15461</td>\n",
        "      <td>70</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td>19</td>\n",
        "      <td>1707</td>\n",
        "      <td>25010</td>\n",
        "      <td>68.252699</td>\n",
        "      <td>20</td>\n",
        "      <td>Hermosa</td>\n",
        "      <td>6.9</td>\n",
        "      <td>20.5</td>\n",
        "      <td>13.1</td>\n",
        "      <td>41.6</td>\n",
        "      <td>36.4</td>\n",
        "      <td>15089</td>\n",
        "      <td>71</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td>20</td>\n",
        "      <td>2230</td>\n",
        "      <td>39262</td>\n",
        "      <td>56.797922</td>\n",
        "      <td>21</td>\n",
        "      <td>Avondale</td>\n",
        "      <td>6.0</td>\n",
        "      <td>15.3</td>\n",
        "      <td>9.2</td>\n",
        "      <td>24.7</td>\n",
        "      <td>31.0</td>\n",
        "      <td>20039</td>\n",
        "      <td>42</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td>21</td>\n",
        "      <td>4747</td>\n",
        "      <td>73595</td>\n",
        "      <td>64.501665</td>\n",
        "      <td>22</td>\n",
        "      <td>Logan Square</td>\n",
        "      <td>3.2</td>\n",
        "      <td>16.8</td>\n",
        "      <td>8.2</td>\n",
        "      <td>14.8</td>\n",
        "      <td>26.2</td>\n",
        "      <td>31908</td>\n",
        "      <td>23</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td>22</td>\n",
        "      <td>8021</td>\n",
        "      <td>56323</td>\n",
        "      <td>142.410738</td>\n",
        "      <td>23</td>\n",
        "      <td>Humboldt park</td>\n",
        "      <td>14.8</td>\n",
        "      <td>33.9</td>\n",
        "      <td>17.3</td>\n",
        "      <td>35.4</td>\n",
        "      <td>38.0</td>\n",
        "      <td>13781</td>\n",
        "      <td>85</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td>23</td>\n",
        "      <td>6975</td>\n",
        "      <td>81432</td>\n",
        "      <td>85.654288</td>\n",
        "      <td>24</td>\n",
        "      <td>West Town</td>\n",
        "      <td>2.3</td>\n",
        "      <td>14.7</td>\n",
        "      <td>6.6</td>\n",
        "      <td>12.9</td>\n",
        "      <td>21.7</td>\n",
        "      <td>43198</td>\n",
        "      <td>10</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td>24</td>\n",
        "      <td>17050</td>\n",
        "      <td>98514</td>\n",
        "      <td>173.071848</td>\n",
        "      <td>25</td>\n",
        "      <td>Austin</td>\n",
        "      <td>6.3</td>\n",
        "      <td>28.6</td>\n",
        "      <td>22.6</td>\n",
        "      <td>24.4</td>\n",
        "      <td>37.9</td>\n",
        "      <td>15957</td>\n",
        "      <td>73</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td>25</td>\n",
        "      <td>5804</td>\n",
        "      <td>18001</td>\n",
        "      <td>322.426532</td>\n",
        "      <td>26</td>\n",
        "      <td>West Garfield Park</td>\n",
        "      <td>9.4</td>\n",
        "      <td>41.7</td>\n",
        "      <td>25.8</td>\n",
        "      <td>24.5</td>\n",
        "      <td>43.6</td>\n",
        "      <td>10934</td>\n",
        "      <td>92</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td>26</td>\n",
        "      <td>5279</td>\n",
        "      <td>20567</td>\n",
        "      <td>256.673312</td>\n",
        "      <td>27</td>\n",
        "      <td>East Garfield Park</td>\n",
        "      <td>8.2</td>\n",
        "      <td>42.4</td>\n",
        "      <td>19.6</td>\n",
        "      <td>21.3</td>\n",
        "      <td>43.2</td>\n",
        "      <td>12961</td>\n",
        "      <td>83</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td>27</td>\n",
        "      <td>7804</td>\n",
        "      <td>54881</td>\n",
        "      <td>142.198575</td>\n",
        "      <td>28</td>\n",
        "      <td>Near West Side</td>\n",
        "      <td>3.8</td>\n",
        "      <td>20.6</td>\n",
        "      <td>10.7</td>\n",
        "      <td>9.6</td>\n",
        "      <td>22.2</td>\n",
        "      <td>44689</td>\n",
        "      <td>15</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td>28</td>\n",
        "      <td>8053</td>\n",
        "      <td>35912</td>\n",
        "      <td>224.242593</td>\n",
        "      <td>29</td>\n",
        "      <td>North Lawndale</td>\n",
        "      <td>7.4</td>\n",
        "      <td>43.1</td>\n",
        "      <td>21.2</td>\n",
        "      <td>27.6</td>\n",
        "      <td>42.7</td>\n",
        "      <td>12034</td>\n",
        "      <td>87</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td>29</td>\n",
        "      <td>4404</td>\n",
        "      <td>79288</td>\n",
        "      <td>55.544345</td>\n",
        "      <td>30</td>\n",
        "      <td>South Lawndale</td>\n",
        "      <td>15.2</td>\n",
        "      <td>30.7</td>\n",
        "      <td>15.8</td>\n",
        "      <td>54.8</td>\n",
        "      <td>33.8</td>\n",
        "      <td>10402</td>\n",
        "      <td>96</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",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>47</th>\n",
        "      <td>47</td>\n",
        "      <td>1461</td>\n",
        "      <td>13812</td>\n",
        "      <td>105.777585</td>\n",
        "      <td>48</td>\n",
        "      <td>Calumet Heights</td>\n",
        "      <td>2.1</td>\n",
        "      <td>11.5</td>\n",
        "      <td>20.0</td>\n",
        "      <td>11.0</td>\n",
        "      <td>44.0</td>\n",
        "      <td>28887</td>\n",
        "      <td>38</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>48</th>\n",
        "      <td>48</td>\n",
        "      <td>6555</td>\n",
        "      <td>44619</td>\n",
        "      <td>146.910509</td>\n",
        "      <td>49</td>\n",
        "      <td>Roseland</td>\n",
        "      <td>2.5</td>\n",
        "      <td>19.8</td>\n",
        "      <td>20.3</td>\n",
        "      <td>16.9</td>\n",
        "      <td>41.2</td>\n",
        "      <td>17949</td>\n",
        "      <td>52</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>49</th>\n",
        "      <td>49</td>\n",
        "      <td>1037</td>\n",
        "      <td>7325</td>\n",
        "      <td>141.569966</td>\n",
        "      <td>50</td>\n",
        "      <td>Pullman</td>\n",
        "      <td>1.5</td>\n",
        "      <td>21.6</td>\n",
        "      <td>22.8</td>\n",
        "      <td>13.1</td>\n",
        "      <td>38.6</td>\n",
        "      <td>20588</td>\n",
        "      <td>51</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>50</th>\n",
        "      <td>50</td>\n",
        "      <td>1904</td>\n",
        "      <td>15109</td>\n",
        "      <td>126.017605</td>\n",
        "      <td>51</td>\n",
        "      <td>South Deering</td>\n",
        "      <td>4.0</td>\n",
        "      <td>29.2</td>\n",
        "      <td>16.3</td>\n",
        "      <td>21.0</td>\n",
        "      <td>39.5</td>\n",
        "      <td>14685</td>\n",
        "      <td>65</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>51</th>\n",
        "      <td>51</td>\n",
        "      <td>1304</td>\n",
        "      <td>23042</td>\n",
        "      <td>56.592310</td>\n",
        "      <td>52</td>\n",
        "      <td>East Side</td>\n",
        "      <td>6.8</td>\n",
        "      <td>19.2</td>\n",
        "      <td>12.1</td>\n",
        "      <td>31.9</td>\n",
        "      <td>42.8</td>\n",
        "      <td>17104</td>\n",
        "      <td>64</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>52</th>\n",
        "      <td>52</td>\n",
        "      <td>3957</td>\n",
        "      <td>29651</td>\n",
        "      <td>133.452497</td>\n",
        "      <td>53</td>\n",
        "      <td>West Pullman</td>\n",
        "      <td>3.3</td>\n",
        "      <td>25.9</td>\n",
        "      <td>19.4</td>\n",
        "      <td>20.5</td>\n",
        "      <td>42.1</td>\n",
        "      <td>16563</td>\n",
        "      <td>62</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>53</th>\n",
        "      <td>53</td>\n",
        "      <td>1175</td>\n",
        "      <td>6482</td>\n",
        "      <td>181.271213</td>\n",
        "      <td>54</td>\n",
        "      <td>Riverdale</td>\n",
        "      <td>5.8</td>\n",
        "      <td>56.5</td>\n",
        "      <td>34.6</td>\n",
        "      <td>27.5</td>\n",
        "      <td>51.5</td>\n",
        "      <td>8201</td>\n",
        "      <td>98</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>54</th>\n",
        "      <td>54</td>\n",
        "      <td>507</td>\n",
        "      <td>9426</td>\n",
        "      <td>53.787397</td>\n",
        "      <td>55</td>\n",
        "      <td>Hegewisch</td>\n",
        "      <td>3.3</td>\n",
        "      <td>17.1</td>\n",
        "      <td>9.6</td>\n",
        "      <td>19.2</td>\n",
        "      <td>42.9</td>\n",
        "      <td>22677</td>\n",
        "      <td>44</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>55</th>\n",
        "      <td>55</td>\n",
        "      <td>1800</td>\n",
        "      <td>34513</td>\n",
        "      <td>52.154261</td>\n",
        "      <td>56</td>\n",
        "      <td>Garfield Ridge</td>\n",
        "      <td>2.6</td>\n",
        "      <td>8.8</td>\n",
        "      <td>11.3</td>\n",
        "      <td>19.3</td>\n",
        "      <td>38.1</td>\n",
        "      <td>26353</td>\n",
        "      <td>32</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>56</th>\n",
        "      <td>56</td>\n",
        "      <td>986</td>\n",
        "      <td>13393</td>\n",
        "      <td>73.620548</td>\n",
        "      <td>57</td>\n",
        "      <td>Archer Heights</td>\n",
        "      <td>8.5</td>\n",
        "      <td>14.1</td>\n",
        "      <td>16.5</td>\n",
        "      <td>35.9</td>\n",
        "      <td>39.2</td>\n",
        "      <td>16134</td>\n",
        "      <td>67</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>57</th>\n",
        "      <td>57</td>\n",
        "      <td>2715</td>\n",
        "      <td>45368</td>\n",
        "      <td>59.843943</td>\n",
        "      <td>58</td>\n",
        "      <td>Brighton Park</td>\n",
        "      <td>14.4</td>\n",
        "      <td>23.6</td>\n",
        "      <td>13.9</td>\n",
        "      <td>45.1</td>\n",
        "      <td>39.3</td>\n",
        "      <td>13089</td>\n",
        "      <td>84</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>58</th>\n",
        "      <td>58</td>\n",
        "      <td>1066</td>\n",
        "      <td>15612</td>\n",
        "      <td>68.280810</td>\n",
        "      <td>59</td>\n",
        "      <td>McKinley Park</td>\n",
        "      <td>7.2</td>\n",
        "      <td>18.7</td>\n",
        "      <td>13.4</td>\n",
        "      <td>32.9</td>\n",
        "      <td>35.6</td>\n",
        "      <td>16954</td>\n",
        "      <td>61</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>59</th>\n",
        "      <td>59</td>\n",
        "      <td>1590</td>\n",
        "      <td>31977</td>\n",
        "      <td>49.723239</td>\n",
        "      <td>60</td>\n",
        "      <td>Bridgeport</td>\n",
        "      <td>4.5</td>\n",
        "      <td>18.9</td>\n",
        "      <td>13.7</td>\n",
        "      <td>22.2</td>\n",
        "      <td>31.3</td>\n",
        "      <td>22694</td>\n",
        "      <td>43</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>60</th>\n",
        "      <td>60</td>\n",
        "      <td>4848</td>\n",
        "      <td>44377</td>\n",
        "      <td>109.245780</td>\n",
        "      <td>61</td>\n",
        "      <td>New City</td>\n",
        "      <td>11.9</td>\n",
        "      <td>29.0</td>\n",
        "      <td>23.0</td>\n",
        "      <td>41.5</td>\n",
        "      <td>38.9</td>\n",
        "      <td>12765</td>\n",
        "      <td>91</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>61</th>\n",
        "      <td>61</td>\n",
        "      <td>1033</td>\n",
        "      <td>18109</td>\n",
        "      <td>57.043459</td>\n",
        "      <td>62</td>\n",
        "      <td>West Elsdon</td>\n",
        "      <td>11.1</td>\n",
        "      <td>15.6</td>\n",
        "      <td>16.7</td>\n",
        "      <td>37.0</td>\n",
        "      <td>37.7</td>\n",
        "      <td>15754</td>\n",
        "      <td>69</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>62</th>\n",
        "      <td>62</td>\n",
        "      <td>2335</td>\n",
        "      <td>39894</td>\n",
        "      <td>58.530105</td>\n",
        "      <td>63</td>\n",
        "      <td>Gage Park</td>\n",
        "      <td>15.8</td>\n",
        "      <td>23.4</td>\n",
        "      <td>18.2</td>\n",
        "      <td>51.5</td>\n",
        "      <td>38.8</td>\n",
        "      <td>12171</td>\n",
        "      <td>93</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>63</th>\n",
        "      <td>63</td>\n",
        "      <td>926</td>\n",
        "      <td>23139</td>\n",
        "      <td>40.019016</td>\n",
        "      <td>64</td>\n",
        "      <td>Clearing</td>\n",
        "      <td>2.7</td>\n",
        "      <td>8.9</td>\n",
        "      <td>9.5</td>\n",
        "      <td>18.8</td>\n",
        "      <td>37.6</td>\n",
        "      <td>25113</td>\n",
        "      <td>29</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>64</th>\n",
        "      <td>64</td>\n",
        "      <td>2029</td>\n",
        "      <td>33355</td>\n",
        "      <td>60.830460</td>\n",
        "      <td>65</td>\n",
        "      <td>West Lawn</td>\n",
        "      <td>5.8</td>\n",
        "      <td>14.9</td>\n",
        "      <td>9.6</td>\n",
        "      <td>33.6</td>\n",
        "      <td>39.6</td>\n",
        "      <td>16907</td>\n",
        "      <td>56</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>65</th>\n",
        "      <td>65</td>\n",
        "      <td>6095</td>\n",
        "      <td>55628</td>\n",
        "      <td>109.567124</td>\n",
        "      <td>66</td>\n",
        "      <td>Chicago Lawn</td>\n",
        "      <td>7.6</td>\n",
        "      <td>27.9</td>\n",
        "      <td>17.1</td>\n",
        "      <td>31.2</td>\n",
        "      <td>40.6</td>\n",
        "      <td>13231</td>\n",
        "      <td>80</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>66</th>\n",
        "      <td>66</td>\n",
        "      <td>7213</td>\n",
        "      <td>35505</td>\n",
        "      <td>203.154485</td>\n",
        "      <td>67</td>\n",
        "      <td>West Englewood</td>\n",
        "      <td>4.8</td>\n",
        "      <td>34.4</td>\n",
        "      <td>35.9</td>\n",
        "      <td>26.3</td>\n",
        "      <td>40.7</td>\n",
        "      <td>11317</td>\n",
        "      <td>89</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>67</th>\n",
        "      <td>67</td>\n",
        "      <td>7006</td>\n",
        "      <td>30654</td>\n",
        "      <td>228.550923</td>\n",
        "      <td>68</td>\n",
        "      <td>Englewood</td>\n",
        "      <td>3.8</td>\n",
        "      <td>46.6</td>\n",
        "      <td>28.0</td>\n",
        "      <td>28.5</td>\n",
        "      <td>42.5</td>\n",
        "      <td>11888</td>\n",
        "      <td>94</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>68</th>\n",
        "      <td>68</td>\n",
        "      <td>6669</td>\n",
        "      <td>32602</td>\n",
        "      <td>204.558003</td>\n",
        "      <td>69</td>\n",
        "      <td>Greater Grand Crossing</td>\n",
        "      <td>3.6</td>\n",
        "      <td>29.6</td>\n",
        "      <td>23.0</td>\n",
        "      <td>16.5</td>\n",
        "      <td>41.0</td>\n",
        "      <td>17285</td>\n",
        "      <td>66</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>69</th>\n",
        "      <td>69</td>\n",
        "      <td>2283</td>\n",
        "      <td>41081</td>\n",
        "      <td>55.573136</td>\n",
        "      <td>70</td>\n",
        "      <td>Ashburn</td>\n",
        "      <td>4.0</td>\n",
        "      <td>10.4</td>\n",
        "      <td>11.7</td>\n",
        "      <td>17.7</td>\n",
        "      <td>36.9</td>\n",
        "      <td>23482</td>\n",
        "      <td>37</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>70</th>\n",
        "      <td>70</td>\n",
        "      <td>7748</td>\n",
        "      <td>48743</td>\n",
        "      <td>158.956158</td>\n",
        "      <td>71</td>\n",
        "      <td>Auburn Gresham</td>\n",
        "      <td>4.0</td>\n",
        "      <td>27.6</td>\n",
        "      <td>28.3</td>\n",
        "      <td>18.5</td>\n",
        "      <td>41.9</td>\n",
        "      <td>15528</td>\n",
        "      <td>74</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>71</th>\n",
        "      <td>71</td>\n",
        "      <td>977</td>\n",
        "      <td>20034</td>\n",
        "      <td>48.767096</td>\n",
        "      <td>72</td>\n",
        "      <td>Beverly</td>\n",
        "      <td>0.9</td>\n",
        "      <td>5.1</td>\n",
        "      <td>8.0</td>\n",
        "      <td>3.7</td>\n",
        "      <td>40.5</td>\n",
        "      <td>39523</td>\n",
        "      <td>12</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>72</th>\n",
        "      <td>72</td>\n",
        "      <td>3114</td>\n",
        "      <td>26493</td>\n",
        "      <td>117.540482</td>\n",
        "      <td>73</td>\n",
        "      <td>Washington Height</td>\n",
        "      <td>1.1</td>\n",
        "      <td>16.9</td>\n",
        "      <td>20.8</td>\n",
        "      <td>13.7</td>\n",
        "      <td>42.6</td>\n",
        "      <td>19713</td>\n",
        "      <td>48</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>73</th>\n",
        "      <td>73</td>\n",
        "      <td>609</td>\n",
        "      <td>19093</td>\n",
        "      <td>31.896507</td>\n",
        "      <td>74</td>\n",
        "      <td>Mount Greenwood</td>\n",
        "      <td>1.0</td>\n",
        "      <td>3.4</td>\n",
        "      <td>8.7</td>\n",
        "      <td>4.3</td>\n",
        "      <td>36.8</td>\n",
        "      <td>34381</td>\n",
        "      <td>16</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>74</th>\n",
        "      <td>74</td>\n",
        "      <td>2055</td>\n",
        "      <td>22544</td>\n",
        "      <td>91.155075</td>\n",
        "      <td>75</td>\n",
        "      <td>Morgan Park</td>\n",
        "      <td>0.8</td>\n",
        "      <td>13.2</td>\n",
        "      <td>15.0</td>\n",
        "      <td>10.8</td>\n",
        "      <td>40.3</td>\n",
        "      <td>27149</td>\n",
        "      <td>30</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75</th>\n",
        "      <td>75</td>\n",
        "      <td>1621</td>\n",
        "      <td>12756</td>\n",
        "      <td>127.077454</td>\n",
        "      <td>76</td>\n",
        "      <td>O'Hare</td>\n",
        "      <td>3.6</td>\n",
        "      <td>15.4</td>\n",
        "      <td>7.1</td>\n",
        "      <td>10.9</td>\n",
        "      <td>30.3</td>\n",
        "      <td>25828</td>\n",
        "      <td>24</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>76</th>\n",
        "      <td>76</td>\n",
        "      <td>2213</td>\n",
        "      <td>56521</td>\n",
        "      <td>39.153589</td>\n",
        "      <td>77</td>\n",
        "      <td>Edgewater</td>\n",
        "      <td>4.1</td>\n",
        "      <td>18.2</td>\n",
        "      <td>9.2</td>\n",
        "      <td>9.7</td>\n",
        "      <td>23.8</td>\n",
        "      <td>33385</td>\n",
        "      <td>19</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>77 rows \u00d7 13 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 57,
       "text": [
        "    Unnamed: 0  Crime Count  population  Crime Rate  Community Area Number  \\\n",
        "0            0         3525       54991   64.101398                      1   \n",
        "1            1         3063       71942   42.575964                      2   \n",
        "2            2         3592       56362   63.730883                      3   \n",
        "3            3         1751       39493   44.336971                      4   \n",
        "4            4         1379       31867   43.273606                      5   \n",
        "5            5         5511       94368   58.399034                      6   \n",
        "6            6         3729       64116   58.160210                      7   \n",
        "7            7         8944       80484  111.127678                      8   \n",
        "8            8          254       11187   22.704925                      9   \n",
        "9            9         1259       37023   34.005888                     10   \n",
        "10          10         1144       25448   44.954417                     11   \n",
        "11          11          444       18508   23.989626                     12   \n",
        "12          12          830       17931   46.288551                     13   \n",
        "13          13         2508       51542   48.659346                     14   \n",
        "14          14         3399       64124   53.006675                     15   \n",
        "15          15         2967       53359   55.604490                     16   \n",
        "16          16         1636       41932   39.015549                     17   \n",
        "17          17          575       13426   42.827350                     18   \n",
        "18          18         4775       78743   60.640311                     19   \n",
        "19          19         1707       25010   68.252699                     20   \n",
        "20          20         2230       39262   56.797922                     21   \n",
        "21          21         4747       73595   64.501665                     22   \n",
        "22          22         8021       56323  142.410738                     23   \n",
        "23          23         6975       81432   85.654288                     24   \n",
        "24          24        17050       98514  173.071848                     25   \n",
        "25          25         5804       18001  322.426532                     26   \n",
        "26          26         5279       20567  256.673312                     27   \n",
        "27          27         7804       54881  142.198575                     28   \n",
        "28          28         8053       35912  224.242593                     29   \n",
        "29          29         4404       79288   55.544345                     30   \n",
        "..         ...          ...         ...         ...                    ...   \n",
        "47          47         1461       13812  105.777585                     48   \n",
        "48          48         6555       44619  146.910509                     49   \n",
        "49          49         1037        7325  141.569966                     50   \n",
        "50          50         1904       15109  126.017605                     51   \n",
        "51          51         1304       23042   56.592310                     52   \n",
        "52          52         3957       29651  133.452497                     53   \n",
        "53          53         1175        6482  181.271213                     54   \n",
        "54          54          507        9426   53.787397                     55   \n",
        "55          55         1800       34513   52.154261                     56   \n",
        "56          56          986       13393   73.620548                     57   \n",
        "57          57         2715       45368   59.843943                     58   \n",
        "58          58         1066       15612   68.280810                     59   \n",
        "59          59         1590       31977   49.723239                     60   \n",
        "60          60         4848       44377  109.245780                     61   \n",
        "61          61         1033       18109   57.043459                     62   \n",
        "62          62         2335       39894   58.530105                     63   \n",
        "63          63          926       23139   40.019016                     64   \n",
        "64          64         2029       33355   60.830460                     65   \n",
        "65          65         6095       55628  109.567124                     66   \n",
        "66          66         7213       35505  203.154485                     67   \n",
        "67          67         7006       30654  228.550923                     68   \n",
        "68          68         6669       32602  204.558003                     69   \n",
        "69          69         2283       41081   55.573136                     70   \n",
        "70          70         7748       48743  158.956158                     71   \n",
        "71          71          977       20034   48.767096                     72   \n",
        "72          72         3114       26493  117.540482                     73   \n",
        "73          73          609       19093   31.896507                     74   \n",
        "74          74         2055       22544   91.155075                     75   \n",
        "75          75         1621       12756  127.077454                     76   \n",
        "76          76         2213       56521   39.153589                     77   \n",
        "\n",
        "       COMMUNITY AREA NAME  PERCENT OF HOUSING CROWDED  \\\n",
        "0              Rogers Park                         7.7   \n",
        "1               West Ridge                         7.8   \n",
        "2                   Uptown                         3.8   \n",
        "3           Lincoln Square                         3.4   \n",
        "4             North Center                         0.3   \n",
        "5                Lake View                         1.1   \n",
        "6             Lincoln Park                         0.8   \n",
        "7          Near North Side                         1.9   \n",
        "8              Edison Park                         1.1   \n",
        "9             Norwood Park                         2.0   \n",
        "10          Jefferson Park                         2.7   \n",
        "11             Forest Glen                         1.1   \n",
        "12              North Park                         3.9   \n",
        "13             Albany Park                        11.3   \n",
        "14            Portage Park                         4.1   \n",
        "15             Irving Park                         6.3   \n",
        "16                 Dunning                         5.2   \n",
        "17              Montclaire                         8.1   \n",
        "18          Belmont Cragin                        10.8   \n",
        "19                 Hermosa                         6.9   \n",
        "20                Avondale                         6.0   \n",
        "21            Logan Square                         3.2   \n",
        "22           Humboldt park                        14.8   \n",
        "23               West Town                         2.3   \n",
        "24                  Austin                         6.3   \n",
        "25      West Garfield Park                         9.4   \n",
        "26      East Garfield Park                         8.2   \n",
        "27          Near West Side                         3.8   \n",
        "28          North Lawndale                         7.4   \n",
        "29          South Lawndale                        15.2   \n",
        "..                     ...                         ...   \n",
        "47         Calumet Heights                         2.1   \n",
        "48                Roseland                         2.5   \n",
        "49                 Pullman                         1.5   \n",
        "50           South Deering                         4.0   \n",
        "51               East Side                         6.8   \n",
        "52            West Pullman                         3.3   \n",
        "53               Riverdale                         5.8   \n",
        "54               Hegewisch                         3.3   \n",
        "55          Garfield Ridge                         2.6   \n",
        "56          Archer Heights                         8.5   \n",
        "57           Brighton Park                        14.4   \n",
        "58           McKinley Park                         7.2   \n",
        "59              Bridgeport                         4.5   \n",
        "60                New City                        11.9   \n",
        "61             West Elsdon                        11.1   \n",
        "62               Gage Park                        15.8   \n",
        "63                Clearing                         2.7   \n",
        "64               West Lawn                         5.8   \n",
        "65            Chicago Lawn                         7.6   \n",
        "66          West Englewood                         4.8   \n",
        "67               Englewood                         3.8   \n",
        "68  Greater Grand Crossing                         3.6   \n",
        "69                 Ashburn                         4.0   \n",
        "70          Auburn Gresham                         4.0   \n",
        "71                 Beverly                         0.9   \n",
        "72       Washington Height                         1.1   \n",
        "73         Mount Greenwood                         1.0   \n",
        "74             Morgan Park                         0.8   \n",
        "75                  O'Hare                         3.6   \n",
        "76               Edgewater                         4.1   \n",
        "\n",
        "    PERCENT HOUSEHOLDS BELOW POVERTY  PERCENT AGED 16+ UNEMPLOYED  \\\n",
        "0                               23.6                          8.7   \n",
        "1                               17.2                          8.8   \n",
        "2                               24.0                          8.9   \n",
        "3                               10.9                          8.2   \n",
        "4                                7.5                          5.2   \n",
        "5                               11.4                          4.7   \n",
        "6                               12.3                          5.1   \n",
        "7                               12.9                          7.0   \n",
        "8                                3.3                          6.5   \n",
        "9                                5.4                          9.0   \n",
        "10                               8.6                         12.4   \n",
        "11                               7.5                          6.8   \n",
        "12                              13.2                          9.9   \n",
        "13                              19.2                         10.0   \n",
        "14                              11.6                         12.6   \n",
        "15                              13.1                         10.0   \n",
        "16                              10.6                         10.0   \n",
        "17                              15.3                         13.8   \n",
        "18                              18.7                         14.6   \n",
        "19                              20.5                         13.1   \n",
        "20                              15.3                          9.2   \n",
        "21                              16.8                          8.2   \n",
        "22                              33.9                         17.3   \n",
        "23                              14.7                          6.6   \n",
        "24                              28.6                         22.6   \n",
        "25                              41.7                         25.8   \n",
        "26                              42.4                         19.6   \n",
        "27                              20.6                         10.7   \n",
        "28                              43.1                         21.2   \n",
        "29                              30.7                         15.8   \n",
        "..                               ...                          ...   \n",
        "47                              11.5                         20.0   \n",
        "48                              19.8                         20.3   \n",
        "49                              21.6                         22.8   \n",
        "50                              29.2                         16.3   \n",
        "51                              19.2                         12.1   \n",
        "52                              25.9                         19.4   \n",
        "53                              56.5                         34.6   \n",
        "54                              17.1                          9.6   \n",
        "55                               8.8                         11.3   \n",
        "56                              14.1                         16.5   \n",
        "57                              23.6                         13.9   \n",
        "58                              18.7                         13.4   \n",
        "59                              18.9                         13.7   \n",
        "60                              29.0                         23.0   \n",
        "61                              15.6                         16.7   \n",
        "62                              23.4                         18.2   \n",
        "63                               8.9                          9.5   \n",
        "64                              14.9                          9.6   \n",
        "65                              27.9                         17.1   \n",
        "66                              34.4                         35.9   \n",
        "67                              46.6                         28.0   \n",
        "68                              29.6                         23.0   \n",
        "69                              10.4                         11.7   \n",
        "70                              27.6                         28.3   \n",
        "71                               5.1                          8.0   \n",
        "72                              16.9                         20.8   \n",
        "73                               3.4                          8.7   \n",
        "74                              13.2                         15.0   \n",
        "75                              15.4                          7.1   \n",
        "76                              18.2                          9.2   \n",
        "\n",
        "    PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA  \\\n",
        "0                                           18.2   \n",
        "1                                           20.8   \n",
        "2                                           11.8   \n",
        "3                                           13.4   \n",
        "4                                            4.5   \n",
        "5                                            2.6   \n",
        "6                                            3.6   \n",
        "7                                            2.5   \n",
        "8                                            7.4   \n",
        "9                                           11.5   \n",
        "10                                          13.4   \n",
        "11                                           4.9   \n",
        "12                                          14.4   \n",
        "13                                          32.9   \n",
        "14                                          19.3   \n",
        "15                                          22.4   \n",
        "16                                          16.2   \n",
        "17                                          23.5   \n",
        "18                                          37.3   \n",
        "19                                          41.6   \n",
        "20                                          24.7   \n",
        "21                                          14.8   \n",
        "22                                          35.4   \n",
        "23                                          12.9   \n",
        "24                                          24.4   \n",
        "25                                          24.5   \n",
        "26                                          21.3   \n",
        "27                                           9.6   \n",
        "28                                          27.6   \n",
        "29                                          54.8   \n",
        "..                                           ...   \n",
        "47                                          11.0   \n",
        "48                                          16.9   \n",
        "49                                          13.1   \n",
        "50                                          21.0   \n",
        "51                                          31.9   \n",
        "52                                          20.5   \n",
        "53                                          27.5   \n",
        "54                                          19.2   \n",
        "55                                          19.3   \n",
        "56                                          35.9   \n",
        "57                                          45.1   \n",
        "58                                          32.9   \n",
        "59                                          22.2   \n",
        "60                                          41.5   \n",
        "61                                          37.0   \n",
        "62                                          51.5   \n",
        "63                                          18.8   \n",
        "64                                          33.6   \n",
        "65                                          31.2   \n",
        "66                                          26.3   \n",
        "67                                          28.5   \n",
        "68                                          16.5   \n",
        "69                                          17.7   \n",
        "70                                          18.5   \n",
        "71                                           3.7   \n",
        "72                                          13.7   \n",
        "73                                           4.3   \n",
        "74                                          10.8   \n",
        "75                                          10.9   \n",
        "76                                           9.7   \n",
        "\n",
        "    PERCENT AGED UNDER 18 OR OVER 64  PER CAPITA INCOME   HARDSHIP INDEX  \n",
        "0                               27.5               23939              39  \n",
        "1                               38.5               23040              46  \n",
        "2                               22.2               35787              20  \n",
        "3                               25.5               37524              17  \n",
        "4                               26.2               57123               6  \n",
        "5                               17.0               60058               5  \n",
        "6                               21.5               71551               2  \n",
        "7                               22.6               88669               1  \n",
        "8                               35.3               40959               8  \n",
        "9                               39.5               32875              21  \n",
        "10                              35.5               27751              25  \n",
        "11                              40.5               44164              11  \n",
        "12                              39.0               26576              33  \n",
        "13                              32.0               21323              53  \n",
        "14                              34.0               24336              35  \n",
        "15                              31.6               27249              34  \n",
        "16                              33.6               26282              28  \n",
        "17                              38.6               22014              50  \n",
        "18                              37.3               15461              70  \n",
        "19                              36.4               15089              71  \n",
        "20                              31.0               20039              42  \n",
        "21                              26.2               31908              23  \n",
        "22                              38.0               13781              85  \n",
        "23                              21.7               43198              10  \n",
        "24                              37.9               15957              73  \n",
        "25                              43.6               10934              92  \n",
        "26                              43.2               12961              83  \n",
        "27                              22.2               44689              15  \n",
        "28                              42.7               12034              87  \n",
        "29                              33.8               10402              96  \n",
        "..                               ...                 ...             ...  \n",
        "47                              44.0               28887              38  \n",
        "48                              41.2               17949              52  \n",
        "49                              38.6               20588              51  \n",
        "50                              39.5               14685              65  \n",
        "51                              42.8               17104              64  \n",
        "52                              42.1               16563              62  \n",
        "53                              51.5                8201              98  \n",
        "54                              42.9               22677              44  \n",
        "55                              38.1               26353              32  \n",
        "56                              39.2               16134              67  \n",
        "57                              39.3               13089              84  \n",
        "58                              35.6               16954              61  \n",
        "59                              31.3               22694              43  \n",
        "60                              38.9               12765              91  \n",
        "61                              37.7               15754              69  \n",
        "62                              38.8               12171              93  \n",
        "63                              37.6               25113              29  \n",
        "64                              39.6               16907              56  \n",
        "65                              40.6               13231              80  \n",
        "66                              40.7               11317              89  \n",
        "67                              42.5               11888              94  \n",
        "68                              41.0               17285              66  \n",
        "69                              36.9               23482              37  \n",
        "70                              41.9               15528              74  \n",
        "71                              40.5               39523              12  \n",
        "72                              42.6               19713              48  \n",
        "73                              36.8               34381              16  \n",
        "74                              40.3               27149              30  \n",
        "75                              30.3               25828              24  \n",
        "76                              23.8               33385              19  \n",
        "\n",
        "[77 rows x 13 columns]"
       ]
      }
     ],
     "prompt_number": 57
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "communities.columns"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": [
        "Index([u'Unnamed: 0', u'Crime Count', u'population', u'Crime Rate',\n",
        "       u'Community Area Number', u'COMMUNITY AREA NAME',\n",
        "       u'PERCENT OF HOUSING CROWDED', u'PERCENT HOUSEHOLDS BELOW POVERTY',\n",
        "       u'PERCENT AGED 16+ UNEMPLOYED',\n",
        "       u'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA',\n",
        "       u'PERCENT AGED UNDER 18 OR OVER 64', u'PER CAPITA INCOME ',\n",
        "       u'HARDSHIP INDEX'],\n",
        "      dtype='object')"
       ]
      }
     ],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "communities.drop(['Unnamed: 0'], axis=1, inplace=True)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 59
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "communities.plot(kind='scatter', \n",
      "                 x='PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA', \n",
      "                 y='Crime Rate')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 75,
       "text": [
        "<matplotlib.axes._subplots.AxesSubplot at 0x7fc5f3e4fc10>"
       ]
      },
      {
       "metadata": {},
       "output_type": "display_data",
       "png": "iVBORw0KGgoAAAANSUhEUgAAAYkAAAEPCAYAAAC3NDh4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3XucHGWd7/HPd8BouF+iwHJXUZEVGHQhCmcz6E4Crhsk\nHBV1MaiIvlQWIWpAVpP1BBHd4Iq7rouLEHeXFReNBg9kEoRxT+QilwARCEYFRVbisgqChIvmd/6o\nZ0Kl0zXT3dM9XdXzfb9e/Zrqpy796+qa+lU9T9VTigjMzMzq6et2AGZmVl5OEmZmVshJwszMCjlJ\nmJlZIScJMzMr5CRhZmaFOpokJD1X0k2SVktaI2lBKr9E0k9T+W2SDs7Nc6GkdZJul3RoJ+MzM7PR\nbd3JhUfEU5KOjognJG0FfF/S8jT6wxHxzfz0ko4FXhQRB0g6AvgSML2TMZqZWbGOVzdFxBNp8Llk\nSWljeq86kx8HfDXNdxOwo6TdOh2jmZnV1/EkIalP0mrgIWBlRNycRi1KVUqLJT0nle0JPJCb/cFU\nZmZmXTARZxIbI6If2As4XNLLgbMi4kDgT4BdgfmdjsPMzJrX0TaJvIj4raRh4JiIuCCVPSPpEmBe\nmuxBYO/cbHulss1IcodTZmYtiIh6Vf2FOn110zRJO6bhqcAgsFbS7qlMwBuBH6ZZlgHvSOOmA49E\nxPp6y46Iyr4WLFjQ9Rgcf/fjmIzxVzn2Xoi/FZ0+k9gDWCKpjywhXR4RV0n6rqRpZI3XtwPvA0jj\nXi/px8DvgHd2OD4zMxtFpy+BXQMcVqf8daPM88FOxmRmZo3zHdddMDAw0O0QxsXxd1eV469y7FD9\n+FuhVuupuklSVDFuM7NukkSUqeHazMyqzUnCzMwKOUmYmVkhJwkzMyvkJGFmZoWcJMzMrJCThJmZ\nFXKSMDOzQk4SZuMwNDTEzJknMHPmCQwNDXU7HLO28x3XZi0aGhri+OPnsmHD+QBMnTqfpUuXMGvW\nrC5HZlZfK3dcO0mYtWjmzBNYuXI2MDeVLGFwcBkrVnyjm2GZFXK3HGZm1lYT9mQ6s14zb96prFo1\nlw0bsvdTp85n3rwl3Q3KrM1c3WQ2DkNDQyxefBGQJQ23R1iZuU3CzMwKuU3CzMzayknCzMwKOUmY\nmVkhJwkzMyvkJGFmZoWcJMzMrFBHk4Sk50q6SdJqSWskLUjl+0m6UdKPJP27pK1T+RRJX5O0TtIN\nkvbpZHxmZja6jiaJiHgKODoi+oFDgWMlHQGcDyyOiJcAjwDvTrO8G/h1RBwA/B3wmU7GZ2Zmo+t4\ndVNEPJEGn0vWDUgARwMjvaAtAd6Yho9L7wGuAF7X6fjMzKxYx5OEpD5Jq4GHgJXAT4BHImJjmuQX\nwJ5peE/gAYCI+APwiKRdOh2jmZnV1/EO/lIy6Je0A7AUeFkTsxfePr5w4cJNwwMDAwwMDLQYoZlZ\nbxoeHmZ4eHhcy5jQvpskfRzYAHwU2D0iNkqaDiyIiGMlLU/DN0naCvhlRLygznLcd5OZWZNK13eT\npGmSdkzDU4FB4G7gOuBNabK5wLfT8DKefYLLm4BrOxmfmZmNrtNtEnsA10m6HbgJGIqIq4CzgDMl\n/QjYBbg4TX8xME3SOuBDaTqzyvOzsK2q3FW4WYf5WdhWFn6ehFkJ+VnYVhala5MwM7Nq8zOuzTrM\nz8K2KnN1k9kE8LOwrQzcJmFmZoXcJmFmZm3lJGFmZoWcJMzMrJCThJmZFXKSMDOzQk4SZmZWyEnC\nzMwKOUmYmVkhJwkzMyvkJGFmZoWcJMzMrJCThJmZFXKSMDOzQk4SZmZWyEnCzMwKOUlUxNDQEDNn\nnsDMmScwNDTU7XB6itetWTE/dKgChoaGOP74uWzYcD6QPf5y6dIlfrpZG3jd2mTiJ9P1qJkzT2Dl\nytnA3FSyhMHBZaxY8Y1uhtUTvG5tMindk+kk7SXpWkl3SVoj6bRUvkDSLyTdll7H5OY5W9I6SfdI\nmtnJ+MzMbHRbd3j5vwfOjIjbJW0H3CppZRp3QURckJ9Y0oHAm4EDgb2AayQdMKlOG+qYN+9UVq2a\ny4YN2fupU+czb96S7gbVI7xuzUY3odVNkr4FfAE4Cng8IhbXjD8LiIg4P72/GlgYETfVTDfp8sbQ\n0BCLF18EZDs215m3j9etTRalbpOQtB8wDPwxMI+sEvi3wC3AvIh4VNIXgBsi4rI0zz8DV0XEN2uW\nNemShJnZeLWSJDpd3QRAqmq6Ajg9Ih6X9EXgkxERkhYBi4FTmlnmwoULNw0PDAwwMDDQvoDNzHrA\n8PAww8PD41pGx88kJG0NfAe4OiI+X2f8vsCVEXFwneqm5cACVzeZmY1f6a5uSr4C3J1PEJJ2z42f\nA/wwDS8DTpQ0RdL+wIuBH0xAjGZmVkdHq5skHQm8HVgjaTUQwMeAt0k6FNgI3A+8FyAi7pb0deBu\n4Bng/T5lMDPrHt9MZ2Y2SZS1usnMzCrKScLMzAo5SZiZWSEnCbM2c9fj1kvccG3WRu563Mqs1N1y\ntJOThJWVux63MvPVTWYV5moqK6MJ6bvJbLJotevx2mqqVavmuprKSsHVTWZt1krX466msolQ2l5g\nzSaTWbNmNZQY8snk4Yf/p9NhmbXEScKsC2qrl6ZM+RBTpnyEp5/OxvsJeVYWThJmXbB48UUpQWTV\nS08/Df39X2batGUAzJvn9ggrBycJs5KYNm03t0FY6ThJmHVBq1dBmU00X91k1iWtXAVlNh6+49rM\nzAr5jmszM2urhpKEpKmSXtrpYMzMrFzGTBKS/gK4HVie3h8qaVmnAzMzs+5r5ExiIXA48AhARNwO\n7N/BmMzMrCQaSRLPRMSjNWVuNTYzmwQaSRJ3SXobsJWkAyR9Abi+w3GZbcbdaJt1RyNJ4jTgIOAp\n4DLgUeD0TgZlljfSz9HKlbNZuXI2xx8/t1KJwgnOqmzM+yQkvSki/mOssoJ59wK+CuwGbAS+HBEX\nStoZuBzYF7gfePNIlZakC4Fjgd8BJ6c2kNrl+j6JSaTK3Wj7caZWJp26T+LsBsvq+T1wZkQcBLwa\n+ICklwFnAddExEuBa0eWJ+lY4EURcQDwXuBLDX6OWSlt3pFflixG7rI2q4LCvpvSDvv1wJ7p6H7E\nDmQ7/zFFxEPAQ2n4cUn3AHsBxwEz0mRLgOvIEsdxZGceRMRNknaUtFtErG/qW1lPcT9HZt0zWgd/\n/wXcAswGbs2VPwac0ewHSdoPOBS4Edi044+IhyTtlibbE3ggN9uDqcxJYhKbNWsWS5cuyfVzVJ3q\nGic4q7rCJBERdwB3SLosIp4Zz4dI2g64Ajg9nVHUNig03cCwcOHCTcMDAwMMDAyMJ0QruUaf9lY2\nVU5wVn3Dw8MMDw+PaxmNNFwfAJwHvBx43kh5RLywoQ+Qtga+A1wdEZ9PZfcAAxGxXtLuwHURcaCk\nL6Xhy9N0a4EZtdVNbrg2M2tepxquLwH+kawd4miyNoN/beIzvgLcPZIgkmXAyWn4ZODbufJ3AEia\nDjzi9oje5stDzcqtkTOJWyPilZLWRMQr8mVjLlw6EvhPYA1ZlVIAHwN+AHwd2Bv4GdklsI+kef4e\nOIbsEth3RsRtdZbrM4ke4MtDzSZWR54nIel64CiyNoVryRqTP50uX+0KJ4neUOX7H8yqqFPVTacD\n2wB/BbwSOIln/6vNzKyHjfmM64i4OQ0+DrwTQNI+nQzKJgdfHmpWfqNWN0l6Ndl9Cv8ZEb+SdDDZ\nTW//KyL2nqAY68Xl6qYe4ec8m02ctrZJSPos8AayBw69GBgCTiG7HPafIuLJ8YXbOicJM7PmtTtJ\n3A0cFhFPpg75HgD+OCLuH3ek4+QkYb3AZ1E20drdcP3kyNlCRPwGWFeGBGG9YbLfH1H17s9t8hjt\nTOIRsnscRvxp/n1EzO5saMV8JlFtvj/Cl/9ad7RyJjHa1U3H1bxf3HxIZlvavPts2LAhK5tMScKs\nKkbr4O97ExmI2WTiy3+tKhq5mc6srebNO5WpU+eTPUpkSdpBntrtsFrSatvKSO+wg4PLGBxcNumq\n26w6xuyWo4zcJlF9vXBlj9tWrGo60ndTbuHbRMQTLUXWZk4SVgZufLaq6UjfTZJek+6ZWJveHyLp\niy3GaGZmFTJm303A54BZZM96ICLukPSnHY3KrALc+GyTQSNJgoh4QNrsDOUPnQnHrDr8aFKbDBp5\nnsQVwAXA3wNHkHUd/qqIOLHz4RXG5DYJM7Mmdep5Eu8DPkDWG+yDwKHpvZmZ9ThfAms2AXrhkl+r\nvk49vnR/4DRgP3JtGO67ycqojDtj309hZdGpJHEHcDGwBtg4Ut7NbjucJKyesu6MfT+FlUW7O/gb\n8WREXNhiTGYTxh0HmrVfI0ni85IWACuAp0YKI+K2jkVl1kN8P4VVWSNJ4hXAScBreba6KdJ7s9Io\n687Y91NYlTXSJvFj4OUR8XTTC5cuJntO9vqIODiVLQDeA/wqTfaxiFiexp0NvAv4PXB6RKwoWK7b\nJKyuMjZcm5VFpxquvwWcGhG/GnXC+vMeBTwOfLUmSTwWERfUTHsgcBnwJ8BewDXAAfWygZOEmVnz\nOtVwvROwVtLNbN4mMeYlsBGxStK+dUbVC/I44GsR8XvgfknrgMOBmxqI0czMOqCRJLGgA5/7AUkn\nAbcA8yLiUbI7um/ITfNgKjPbxNVJZhNrzCTRgfshvgh8MiJC0iKyZ2ef0uxCFi5cuGl4YGCAgYGB\ndsVnJVV7H8SqVXNLcR+EWVkNDw8zPDw8rmUUtklIWhURR0l6jOxqpk2jgIiIHRr6gKy66cqRNomi\ncZLOSss9P41bDiyIiC2qm9wmMTn5pjSz8WlrB38RcVT6u31E7JB7bd9oghiJi1wbhKTdc+PmAD9M\nw8uAEyVNSV2BvBj4QROfYx3S6nOcrXr8W1utUaubJG0F3BURL2tl4ZIuAwaAXSX9nKx942hJh5Ld\nc3E/8F6AiLhb0teBu4FngPf7dKH72lXF00pbQn6eGTMO4+GH19PXdwYb0906ZbkPole4Os/qiohR\nX8C3gX3Gmm4iX1nYNhEGB+cEXBoQ6XVpDA7OaWoZy5cvj6lTd0vLuTSmTt0tli9f3sQ88wJ22DTc\n17dr9PfPGHMZ1px2/NZWbmnf2dT+tpGrm3YG7pL0A+B3ueTStV5grVpa6VNp83lOAC7cNP/Gja9g\n2rRlPsI1mwCNJImPdzwKK61OdnXhy1nLpazdmliXFZ1ikDUcH1mn/CjgRc2esrTzhaubJtTy5ctj\ncHBODA7OaamKp15106JFi0atgiqubmqsuspaM97f2sqNFqqbRrsE9jvA2RGxpqb8FcCnIuIvOpe6\nRudLYLuv2bOA2ukXL75ozMtZaxuuv/e92xr+vHbGbtYrWrkEdrSj9ZtHGbem2WzUzhc+k+iqVhqi\na3WrkbQdsZtVFS2cSRTeJ0HWZ1ORqU1lIuspmzcqZ5dMjhyZN2revFOZOnU+sARYkuq/T21rnPWu\n+W9H7GaTyWgN17dIek9EfDlfKOkU4NbOhmW9rtPPWCi65t/MmjNakvgQsFTS23k2KbwKmAIc3+nA\nrLyevQpmDfB9+vrWMWPGGU0vZ9asWR1rDyi67Lb2Cp6+vjN4+OGXMzQ05LYJszpG65ZjfUS8Bvgb\nsjuj7wf+JiJeHREPTUx4VkazZs3inHNOo6/vK8D72LhxMeee+4VKdOMwcgbT338JfX3z2LjxXaxe\n/R6OP35uJeI3m2hjPnSojHx1U/eVvbO92uqmqVPnb9bFRNnjN+uETj10yKxy/Fxps/bwmYS1ZKwj\n9bKrevxmrejIM67LyEmiHKp+U1rV4zdrlpOEVYJ3zmbd4SRhpedqHrPucZKw0vNVRWbd09bHl5qZ\nmTlJlFgvPm94IvpsMrP2cZIoqZG6+5UrZ7Ny5eyeuSN45P6FwcFlDA4uc3vEOPXKgUSvfI+e1Gy3\nsWV4MQm6Cvfzhm0svdLtea98jyqgzV2Fm42pTEeAZYplIvRKt+e98j16lbvlKKkqPG+4qDvublQf\nlSkWs57S7KlHGV5MguqmiPI/b7hMVWJlimWi9Eo1Ta98jyqgheqmjp5JSLoYeAOwPiIOTmU7A5cD\n+5J1P/7miHg0jbsQOBb4HXByRNzeyfjKrpPPW7Dq65VODHvle/Sqjt5MJ+ko4HHgq7kkcT7wPxHx\nGUnzgZ0j4ixJxwIfjIg/l3QE8PmImF6w3Ohk3NaYMt09XaZYzMqqlHdcS9oXuDKXJNYCMyJivaTd\ngesi4kBJX0rDl6fp7gEGImJ9nWU6SZREmfphKlMsZmVUlSTx64jYJTf+1xGxi6QrgfMi4vpUfg3w\n0Yi4rc4ynSTMzJpU1YcOtbS3X7hw4abhgYEBBgYG2hSOmVlvGB4eZnh4eFzL6MaZxKZqpDGqmzZV\nS9VZps8kzMyaVNYO/pReI5YBJ6fhk4Fv58rfASBpOvBIvQRhZmYTp6NJQtJlwPXASyT9XNI7gU8D\ng5LuBV6b3hMRVwH3Sfox8E/A+zsZm43fZLvD2Wwy8vMkrCW+5NSsekp5dVMnOEl0nx8eZFY9ZW2T\nsBKayKoiV0uZVViz/XiU4cUk6bupU9rRV06jy3C/PGblQQt9N7m6aRJqV1VRI3c4u1rKrDyqejOd\nVZQ7IDTrfW6TmIQm8jnTfqZ1ubm9yMbi6qZJaiI7w3PHe+Xky5gnH18Ca2YNc3vR5ONLYK0rXGVh\n1rucJGxcRqosVq6czcqVszn++LlOFBUxVnuRk7+Bq5tsnFxlUW1F7UVur+hNvgTWzJpSdBnz4sUX\npQSRJf8NG7KydiUJX8xQHU4SNi7z5p3KqlVz2bAhe59VWSzpblC2SRl3xrVnKatWzeWcc07je9/L\nHkJZljgtafYW7TK8cLccpbJ8+fIYHJwTg4Nz3OVGiYynS5ROdqcyODgnLTfS69Lo69vVXbdMANwt\nh5mNGG97UafOQurFBV8CbmgpTmucL4G1rhrP1TDjvZLGV+K036xZs1ix4husWPGNtlb/1F5V1dd3\nBnBk25ZvbdbsqUcZXri6qXS6WbXhnmbrK/N6yVdRLlq0qLRx9hpaqG7q+g6/lZeTRPnUq2ceHJzT\n8XnbMX8vq20vakf7USfaoNyuNTFaSRK+usmsh+Uvca13VVGz9z60Yxljxdmqbl3JVcYryNqq2axS\nhheT5Eyi3tFVJ44M2xWrq5vKrR1nXP39RwZMD5gTsLw0Z23d2gaqtu3h6qbeUW/jq627nTJlp5gy\n5fml2UDHk7BanXdkvv7+GdHff2TbkmUz8ZQlUY8Vy3iTxPLly6Ovb+dN2xvsFjCvFEmiW1WO7fjc\nidx+nCR6SL2Nb5ddXlRTNn1S18WPdRQ3nsTT6NFhmY4kG1kf44m16P6GbifGotiqkCQmevtxkugh\nThJjG+0fdPny5ZudZU2Z8vyG//ma+ccvU6N5I7GM56i13vL7+2e08Ru0rqrVTRO9/bSSJLrWcC3p\nfuBRYCPwTEQcLmln4HJgX+B+4M0R8Wi3Yuymet1dnHnmaZx77vxNZVOmrAU+wtNPPzuNu8TInH32\neTz99DuAZQA8/fQ7OPvs83qvUbFJ42kgrrdNnndeOba3WbNmsXTpklwD8sR0Rtitz51QzWaVdr2A\nnwI715SdD3w0Dc8HPl0wbzuTa2lVqeG6G0Y7ittuuz0CpuXqz6fFdtvt0dByFy1alLqJmB4wr2eq\nm9r1GZN1e+sEVzeNniTuA3atKVsL7JaGdwfWFszb3jVXMf5HfVbRuth++723OI3ffvu9G1pe/p+2\nr2/nWLRoUUsxdIMPIqrHDdejn0ncAtwMnJLKflMzza8L5m3vmquQMh25tkOn/kH6+2e0VH9epjaG\n8eq1bcXGr5Uk0c2b6Y6MiF9Kej6wQtK9QNRMU/t+k4ULF24aHhgYYGBgoBMxlk6n+/nvpNqbjoCO\n3JgFcN55ZzN79kmb2mumTPkI5533L+NebpVUeVux9hgeHmZ4eHh8C2k2q3TiBSwA5gH3sHl10z0F\n07c1u1ZJ0RUmZa9SqHe1Ub2j/XYetbdyljLa0XfVqm566azI2oOqVDcB2wDbpeFtge8DM8karuen\n8knfcF1P7U5sypTnx5QpO5W+SqFeQth++326uhMr2ukXXTBQtaqbKsZsnVWlJLE/cDuwGlgDnJXK\ndwGuAe4FVgA7Fczf/rVXIfmdWNZNQvmPFre8x+PS2G67PTqyE2vkiL/ZHWhVj8qrdvZjnVWZJDHe\n12RPEnkTsfNqx44mS2abX5La339kwzv0ZrrIaGTn3+x6q2qSMMtzkpiEOl2l0K7lZ20SO0V278H0\nmDJlp4aW06kj/mZ3+q66sV7gJDFJdbJKoZ1H0K3E2akj/lZ2+q66saprJUn4eRI9oB198Y9XI33q\nT0Sc9bqOqNdVSSvdKZRhPZtNuGazShle+Exik04f3TZyxN3Jqhgf8Zu1Dy2cSSibr1okRRXjbrfa\np4RNnTq/bTej1X7OaGcJM2eewMqVsxm5aQuWMDi4jBUrvjEhn29mjZFERKiZeVzdVGETdUdtt6tZ\nuv35ZpOZk4SNW6PtAGZWPa5uqrCJqm5qNBZXCZmVWyvVTU4SFeeds5k1ykliEms2WTi5mE0+ThKT\nVLPVTmWqpjKzieMkMUk1ewlqpy9ZNbNyaiVJ9HUqGDMzqz5fAtsDmr0E1ZesmlmjXN3UI9xwbWZj\ncZuEmZkVcpuEmZm1lZOEmZkVcpIwM7NCThJmZlbIScLMzAo5SZiZWaFSJglJx0haK+lHkuZ3Ox4z\ns8mqdElCUh/w98As4CDgrZJe1t2o2mt4eLjbIYyL4++uKsdf5dih+vG3onRJAjgcWBcRP4uIZ4Cv\nAcd1Oaa2qvqG5vi7q8rxVzl2qH78rShjktgTeCD3/hepzMzMJlgZk4SZmZVE6fpukjQdWBgRx6T3\nZwEREefnpilX0GZmFVH5Dv4kbQXcC7wO+CXwA+CtEXFPVwMzM5uESvc8iYj4g6QPAivIqsMudoIw\nM+uO0p1JmJlZeVSq4VrS/5b0Q0l/kHRYzbizJa2TdI+kmd2KcSxVu1FQ0sWS1ku6M1e2s6QVku6V\nNCRpx27GWETSXpKulXSXpDWS/iqVVyX+50q6SdLqFP+CVL6fpBvTNvTvkkpXI5AnqU/SbZKWpfeV\niV/S/ZLuSL/BD1JZVbafHSX9R9on3iXpiFZir1SSANYAxwPfyxdKOhB4M3AgcCzwRUlNNc5MhIre\nKHgJWbx5ZwHXRMRLgWuBsyc8qsb8HjgzIg4CXg18IK3vSsQfEU8BR0dEP3AocKykI4DzgcUR8RLg\nEeDdXQyzEacDd+feVyn+jcBARPRHxOGprBLbD/B54KqIOBA4BFhLK7FHROVewHXAYbn3ZwHzc++v\nBo7odpx14p4OXF0Ud1lfwL7Anbn3a4Hd0vDuwNpux9jg9/gW8GdVjB/YBriF7GbTXwF9uW1qebfj\nGyXuvYCVwACwLJX9d4Xivw/Ytaas9NsPsAPwkzrlTcdetTOJIrU34D1IOW/A65UbBV8QEesBIuIh\n4AVdjmdMkvYjOxq/keyfpBLxp6qa1cBDZDvbnwCPRMTGNMkvgD/qVnwN+BzwESAAJO0K/KZC8Qcw\nJOlmSaeksipsP/sDD0u6JFX1XSRpG1qIvXR1gZJWArvli8h+qHMi4sruRGVjKPXVD5K2A64ATo+I\nx+vcZ1Pa+NPOtF/SDsBSoOzVk5tI+nNgfUTcLmkgP6pLIbXiyIj4paTnAysk3cuW20sZt5+tgcOA\nD0TELZI+R1Zz0XTspUsSETHYwmwPAnvn3u+VysrmQWCf3PuyxjmW9ZJ2i4j1knYnq/4opdQoegXw\nLxHx7VRcmfhHRMRvJQ2Tta3sJKkvJZAyb0NHArMlvR6YCmxPVk++Y0XiJyJ+mf7+t6RvkVX3VWH7\n+QXwQETckt5/gyxJNB17laub8kcjy4ATJU2RtD/wYrKb8MrmZuDFkvaVNAU4kSz2shNbru+T0/Bc\n4Nu1M5TIV4C7I+LzubJKxC9p2sjVJ5KmAoNkDcDXAW9Kk5U2/oj4WETsExEvJNvWr42Iv6Qi8Uva\nJp2FImlbYCbZxTOl335SldIDkl6Sil4H3EUrsXe7gaXJxpg3ktXpbyC7GzvfCHw28GPgHmBmt2Md\n5TscQ3ZH+TrgrG7H00C8lwH/BTwF/Bx4J7AzcE36HiuAnbodZ0HsRwJ/AG4HVgO3pfW/S0Xif0WK\n+XbgTrIqV8jqm28CfgRcDjyn27E28F1m8GzDdSXiT3GObDtrRv5fK7T9HEJ2YHo78E1gx1Zi9810\nZmZWqMrVTWZm1mFOEmZmVshJwszMCjlJmJlZIScJMzMr5CRhZmaFnCSalLopvy113Xy5pOfVlK9O\nfz+ayodT1+C3p26fD84ta1tJX5L049Q3zLWS/qSB5d2cW8YrJV0naTBNu1rSY+kzb5N0acH3+JCk\nDZK2ryk/PC3vXkm3SLpS0kFp3AJJv6iJawdJMyQ9IunW9LnDqUuGep/7ttT18h2SVtWsjy26ZW7h\n9/mmpNm592slfSz3/gpJb0wxXynp5Nx6eyp9/m2SPiVprqQv1Cz/OqVu6tN3X6Ksi/p1ki4dWZ8j\ny6+Z9xJJJ6QYV6d5Hkmfd5uyR/fWTj+npuyx9HdfSWty5WP9bmfWLOc+SbvUWX/vknRnWg93SvqL\n3LgPK+t2+ra0Lf9l7TopiO2oNP09ku6W9J6azzw1N+5GSUfWW9/1pM96Im17I/PPzY2fK+nC3HoY\n2X7vlPSGovWTyveU9C1lXZqvk/Q5pW7N0++7UdK7ctMfksrOzJVtJelXkj5V9B1Kr9s3fFTtBfw2\nN/yvwIdqy2umvw7oT8MnAyty4/4dODf3fl/g2AaWdz8wK71/JdmdrPlprh35zFG+x41kXa7PzZW9\ngKzXyyNyZa8BZqfhBWRdb9cua9ONUrmbeO4j6+a6dtrpwI5p+Bjgxty4nwI7jxH3fWOMnwd8Og3v\nAtwKXJkb/2D6npvFXO/zye5IvbDO+j8sDf8H8IncuIXA1+utk1R2CTCnaL3V+S6bTZ/fLsj1zEvW\n11lTv1u6U9+4AAAG3UlEQVT6rrvUlO1JdkPqdun9NsC+afh9ZL0rb5vebwecVLtO6sS2O/Az4JDc\nb3ILz27nbyC74Wvn9L4/Tf+Cesuus45qeyjej+zmt7m1v2F+PZD1gfXfY2zXNwHvSMMC/hn4TO63\nu5NcD7bAp8lufjwzV3YMsApYN9p2W+aXzyTG5/+RdQECo3daNjLuBlKPl5JeSNYPzF+PTBQRP4uI\nqxtY3mfz8xV8XuH86bO3Tct4W27UB4FLI+KmXEzXR0S+65AxO2eLiDuATwKn1Rl3Y0Q8mt7eyOa9\n4Iqxz27HuvvzerI7rSHbUV4JPB829QT7REQU9Vcz6nrbbELpRWQdqP2fXPEngVcq6xpmIn2AsX+3\nWvW+5wuA3wJPpGU8ERE/S+POBt4XEb9L4x6PiH9pYNnvBy5J2wQR8Wvgo2T9CJGGPxwRv0njVwOX\npu/UtIi4HziT7BkWo023FnhG0rS6X0B6LbAhIr6apg/gDOBdSrUHZMnseco6/4MsIVxds6i3An8H\n/Lz2TLEqnCSaJ9jUcdyxZEcTAFO1eTXMm+rMeyzZMw0ge+jQ7Wnjq2e05d0APCVpRovf4USys5hV\nwEtyG/lBZEdCozkjF9d3R5nuNuClYyzrFDb/p8p3y/yegnnG2onfChyUfp/XkCWNe5U9bGjkfTNO\nzFUHrSY7cwN4OTW/X2Qd1t1Bth7b5W9rPr+eRn63M2uWs0edae4g6/DtPklfyVXHbE92dvGzOvOM\n+LeR5QP/tya2W2umvYVn11G92G9lfOtwzG1P2cObNkbEwwWTbBF3RDxGlhhenCu+AnizpNek6Z/K\nfcZzyfpMupLs/y1/QFYZpesFtgKmpn8EyM4kvpKGn4iIorrTf0sbzLZkzzRoxGjLAzgX+DjQyiNQ\n3wq8MSJC0jfJOlv7Yu1Ekm4ke3jJUESckYoviIgLGviMUXfmko4m6wfqqFxxvlvmlZLuiYhVytoU\nRpLkHrn1//2I2OxsJSKelnQX2c58OtlT0F5EdnbRD3y/gdjzvhYRf5WL+9oG5ytK/s32g/PhiPhm\n7vN/O9YMjfxukn66RWBZkjtG0qvIdm4XpPaAzzF2cn5bOgtA0r5kO8ZuGS3WM1NbymNkT7Mcz7ID\n+Hp6vYwsERyZG/8G4LqIeErSUuATkk4f5cCwlHwm0bwnIuKw9Do9In7fwDxvi6wnzCVkjy+FrEfG\nQ6TWHrMaEdcBzyPbETZM0h8DB5DthH8KvIUsaYzENHKkTERMJ0tErTzD9zCyzhbrxXAwcBFZnflv\ncp+3qVtmsmcnHJ7efyqyx0f2A/+VW/9bVGcl3wf+lOzo91Gyaq3XkHWz3eyZxBbhp793U5Pw0295\naBr3P2T173m7AEVHruPRyu9WuN1FxC0RcT7ZdnFCOoJ+LFXXNbu8u4FX1ZS9KsW8RezJK3PjW1G4\n7ZEly8MiYkZEjLYtbBG3smd67E3WbgNAqrp8huyJh7Vn1m8F/iz9n91C9vu/tpkvUgZOEs0r+mdo\npE3iE8ARkl4SESMbzt9smii7UuPYBpY34lyyOt1mvBVYEBEvTK+9gD+StDfwD8DcmrrTbQq+S61N\n5SkJ/DXPJkRy4/Yh69v+pIj4Sa68XrfMPxztc0ZxA/BesuoTyKoEpwP7RES9ZTYtxb5a0sdzxR8H\nbk2/7Tqys56Xwqaj64PJeuQcD9UZbuR3G3vB0h6S+nNFI43IkDXK/oOevXprW0knNRDnSGyHpPl2\nTcs6P43/LHC+0pVWkg4la2z+hzrLGuuzRtqdPgtcOMY8hcsAiIjvktUajFzBtRXwt2TtK0/WzPtx\nsscQbzpDSOvpfwF7p/+z/cnaWSpX5eTqpuYVnSo+L1WDjDxJb3lEfCw/fUQ8KWkx2eMc35NeiyX9\nmKyx8OE0rtHlXS3pV3ViGu109i3A62vKlgInRsRnJb0F+IykPyKrn36YrEF2xIckvT0X1xtT+VGS\nbiWrUlsPfDAihut8/sfJjqi+mI68n4nsAfO7AUuVPTVua+DfImJFnfkbOVW/nqyb53MBIuIPaT2N\nVqfe6LLz05wCfCH9fkGWnN6dPvPptIO5NFU1PgO8Ox2VN6pePFE7HNkDZMb63RpZ9nPI2kD2AJ4k\nexb1+9Jn/GNK4jdLejp9n8VjxRkRD6X18GU9e7n15yLiqjT+yhTz9ZI2klUDvb3m4oLvSHomDd8Q\nEW+p+awXpm1vKlnD+9+N0qhe5BxJp5O264jYB5hDtp1+IpVfBZyzxReNuLH2ewPHA9+tqWlYRvYb\nPScinqEi3FW4mZkVcnWTmZkVcpIwM7NCThJmZlbIScLMzAo5SZiZWSEnCTMzK+QkYWZmhZwkzMys\n0P8HYqr2n1yjNIgAAAAASUVORK5CYII=\n",
       "text": [
        "<matplotlib.figure.Figure at 0x7fc5f3c149d0>"
       ]
      }
     ],
     "prompt_number": 75
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import statsmodels.api as sm"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 19
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "X = communities.drop(['Crime Rate', 'COMMUNITY AREA NAME', 'Crime Count'], axis=1)\n",
      "y = communities['Crime Rate']"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 60
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "X = sm.add_constant(X)\n",
      "model = sm.OLS(y, X)\n",
      "results = model.fit()\n",
      "results.summary()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<table class=\"simpletable\">\n",
        "<caption>OLS Regression Results</caption>\n",
        "<tr>\n",
        "  <th>Dep. Variable:</th>       <td>Crime Rate</td>    <th>  R-squared:         </th> <td>   0.743</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Model:</th>                   <td>OLS</td>       <th>  Adj. R-squared:    </th> <td>   0.708</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Method:</th>             <td>Least Squares</td>  <th>  F-statistic:       </th> <td>   21.47</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Date:</th>             <td>Thu, 25 Feb 2016</td> <th>  Prob (F-statistic):</th> <td>1.55e-16</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Time:</th>                 <td>12:31:14</td>     <th>  Log-Likelihood:    </th> <td> -381.61</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>No. Observations:</th>      <td>    77</td>      <th>  AIC:               </th> <td>   783.2</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Df Residuals:</th>          <td>    67</td>      <th>  BIC:               </th> <td>   806.7</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Df Model:</th>              <td>     9</td>      <th>                     </th>     <td> </td>   \n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Covariance Type:</th>      <td>nonrobust</td>    <th>                     </th>     <td> </td>   \n",
        "</tr>\n",
        "</table>\n",
        "<table class=\"simpletable\">\n",
        "<tr>\n",
        "                        <td></td>                          <th>coef</th>     <th>std err</th>      <th>t</th>      <th>P>|t|</th> <th>[95.0% Conf. Int.]</th> \n",
        "</tr>\n",
        "<tr>\n",
        "  <th>const</th>                                        <td>   83.6523</td> <td>   63.630</td> <td>    1.315</td> <td> 0.193</td> <td>  -43.354   210.659</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>population</th>                                   <td>   -0.0001</td> <td>    0.000</td> <td>   -0.509</td> <td> 0.612</td> <td>   -0.001     0.000</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Community Area Number</th>                        <td>    0.1615</td> <td>    0.230</td> <td>    0.701</td> <td> 0.486</td> <td>   -0.298     0.621</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>PERCENT OF HOUSING CROWDED</th>                   <td>    2.1276</td> <td>    2.839</td> <td>    0.750</td> <td> 0.456</td> <td>   -3.538     7.794</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>PERCENT HOUSEHOLDS BELOW POVERTY</th>             <td>    1.1320</td> <td>    1.107</td> <td>    1.023</td> <td> 0.310</td> <td>   -1.077     3.341</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>PERCENT AGED 16+ UNEMPLOYED</th>                  <td>    1.6460</td> <td>    1.574</td> <td>    1.046</td> <td> 0.299</td> <td>   -1.496     4.788</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA</th> <td>   -5.5273</td> <td>    1.334</td> <td>   -4.142</td> <td> 0.000</td> <td>   -8.191    -2.864</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>PERCENT AGED UNDER 18 OR OVER 64</th>             <td>   -2.8399</td> <td>    1.327</td> <td>   -2.141</td> <td> 0.036</td> <td>   -5.488    -0.192</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>PER CAPITA INCOME </th>                           <td>    0.0009</td> <td>    0.001</td> <td>    1.474</td> <td> 0.145</td> <td>   -0.000     0.002</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>HARDSHIP INDEX</th>                               <td>    3.0019</td> <td>    1.068</td> <td>    2.810</td> <td> 0.006</td> <td>    0.870     5.134</td>\n",
        "</tr>\n",
        "</table>\n",
        "<table class=\"simpletable\">\n",
        "<tr>\n",
        "  <th>Omnibus:</th>       <td>12.939</td> <th>  Durbin-Watson:     </th> <td>   1.788</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Prob(Omnibus):</th> <td> 0.002</td> <th>  Jarque-Bera (JB):  </th> <td>  30.224</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Skew:</th>          <td> 0.435</td> <th>  Prob(JB):          </th> <td>2.73e-07</td>\n",
        "</tr>\n",
        "<tr>\n",
        "  <th>Kurtosis:</th>      <td> 5.944</td> <th>  Cond. No.          </th> <td>7.38e+05</td>\n",
        "</tr>\n",
        "</table>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 61,
       "text": [
        "<class 'statsmodels.iolib.summary.Summary'>\n",
        "\"\"\"\n",
        "                            OLS Regression Results                            \n",
        "==============================================================================\n",
        "Dep. Variable:             Crime Rate   R-squared:                       0.743\n",
        "Model:                            OLS   Adj. R-squared:                  0.708\n",
        "Method:                 Least Squares   F-statistic:                     21.47\n",
        "Date:                Thu, 25 Feb 2016   Prob (F-statistic):           1.55e-16\n",
        "Time:                        12:31:14   Log-Likelihood:                -381.61\n",
        "No. Observations:                  77   AIC:                             783.2\n",
        "Df Residuals:                      67   BIC:                             806.7\n",
        "Df Model:                           9                                         \n",
        "Covariance Type:            nonrobust                                         \n",
        "================================================================================================================\n",
        "                                                   coef    std err          t      P>|t|      [95.0% Conf. Int.]\n",
        "----------------------------------------------------------------------------------------------------------------\n",
        "const                                           83.6523     63.630      1.315      0.193       -43.354   210.659\n",
        "population                                      -0.0001      0.000     -0.509      0.612        -0.001     0.000\n",
        "Community Area Number                            0.1615      0.230      0.701      0.486        -0.298     0.621\n",
        "PERCENT OF HOUSING CROWDED                       2.1276      2.839      0.750      0.456        -3.538     7.794\n",
        "PERCENT HOUSEHOLDS BELOW POVERTY                 1.1320      1.107      1.023      0.310        -1.077     3.341\n",
        "PERCENT AGED 16+ UNEMPLOYED                      1.6460      1.574      1.046      0.299        -1.496     4.788\n",
        "PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA    -5.5273      1.334     -4.142      0.000        -8.191    -2.864\n",
        "PERCENT AGED UNDER 18 OR OVER 64                -2.8399      1.327     -2.141      0.036        -5.488    -0.192\n",
        "PER CAPITA INCOME                                0.0009      0.001      1.474      0.145        -0.000     0.002\n",
        "HARDSHIP INDEX                                   3.0019      1.068      2.810      0.006         0.870     5.134\n",
        "==============================================================================\n",
        "Omnibus:                       12.939   Durbin-Watson:                   1.788\n",
        "Prob(Omnibus):                  0.002   Jarque-Bera (JB):               30.224\n",
        "Skew:                           0.435   Prob(JB):                     2.73e-07\n",
        "Kurtosis:                       5.944   Cond. No.                     7.38e+05\n",
        "==============================================================================\n",
        "\n",
        "Warnings:\n",
        "[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.\n",
        "[2] The condition number is large, 7.38e+05. This might indicate that there are\n",
        "strong multicollinearity or other numerical problems.\n",
        "\"\"\""
       ]
      }
     ],
     "prompt_number": 61
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "y - results.fittedvalues"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 76,
       "text": [
        "0     -30.548340\n",
        "1     -17.860678\n",
        "2     -27.746741\n",
        "3      -6.912807\n",
        "4     -25.744970\n",
        "5     -44.667030\n",
        "6     -33.001879\n",
        "7       0.118674\n",
        "8       2.004039\n",
        "9      10.857009\n",
        "10      1.313185\n",
        "11    -12.518830\n",
        "12     -9.725766\n",
        "13      1.054443\n",
        "14      8.231496\n",
        "15     17.906104\n",
        "16     -4.780052\n",
        "17    -29.994605\n",
        "18      3.323975\n",
        "19     31.423562\n",
        "20      9.583057\n",
        "21      5.131727\n",
        "22     -0.489824\n",
        "23     39.306076\n",
        "24     23.368762\n",
        "25    100.219960\n",
        "26     52.933863\n",
        "27     42.121330\n",
        "28     42.588384\n",
        "29    -15.052890\n",
        "         ...    \n",
        "47     11.021966\n",
        "48     37.655931\n",
        "49     -4.262890\n",
        "50    -12.664496\n",
        "51      1.419393\n",
        "52      8.277694\n",
        "53    -46.961619\n",
        "54     -4.565217\n",
        "55     24.415173\n",
        "56     15.127637\n",
        "57    -11.015180\n",
        "58      2.858249\n",
        "59    -31.368946\n",
        "60    -19.744856\n",
        "61    -13.071495\n",
        "62    -15.867696\n",
        "63     18.173843\n",
        "64     40.443706\n",
        "65    -18.244945\n",
        "66    -11.719264\n",
        "67     15.979260\n",
        "68     28.511758\n",
        "69     -3.709392\n",
        "70    -31.535948\n",
        "71     -1.481777\n",
        "72      4.299939\n",
        "73    -32.743896\n",
        "74     16.173232\n",
        "75     46.651569\n",
        "76    -60.695775\n",
        "dtype: float64"
       ]
      }
     ],
     "prompt_number": 76
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}