Mission202Solution.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>age</th>\n",
       "      <th>gender</th>\n",
       "      <th>raceethnicity</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>year</th>\n",
       "      <th>streetaddress</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>...</th>\n",
       "      <th>share_hispanic</th>\n",
       "      <th>p_income</th>\n",
       "      <th>h_income</th>\n",
       "      <th>county_income</th>\n",
       "      <th>comp_income</th>\n",
       "      <th>county_bucket</th>\n",
       "      <th>nat_bucket</th>\n",
       "      <th>pov</th>\n",
       "      <th>urate</th>\n",
       "      <th>college</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A'donte Washington</td>\n",
       "      <td>16</td>\n",
       "      <td>Male</td>\n",
       "      <td>Black</td>\n",
       "      <td>February</td>\n",
       "      <td>23</td>\n",
       "      <td>2015</td>\n",
       "      <td>Clearview Ln</td>\n",
       "      <td>Millbrook</td>\n",
       "      <td>AL</td>\n",
       "      <td>...</td>\n",
       "      <td>5.6</td>\n",
       "      <td>28375</td>\n",
       "      <td>51367</td>\n",
       "      <td>54766</td>\n",
       "      <td>0.937936</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>14.1</td>\n",
       "      <td>0.097686</td>\n",
       "      <td>0.168510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aaron Rutledge</td>\n",
       "      <td>27</td>\n",
       "      <td>Male</td>\n",
       "      <td>White</td>\n",
       "      <td>April</td>\n",
       "      <td>2</td>\n",
       "      <td>2015</td>\n",
       "      <td>300 block Iris Park Dr</td>\n",
       "      <td>Pineville</td>\n",
       "      <td>LA</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>14678</td>\n",
       "      <td>27972</td>\n",
       "      <td>40930</td>\n",
       "      <td>0.683411</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>28.8</td>\n",
       "      <td>0.065724</td>\n",
       "      <td>0.111402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Aaron Siler</td>\n",
       "      <td>26</td>\n",
       "      <td>Male</td>\n",
       "      <td>White</td>\n",
       "      <td>March</td>\n",
       "      <td>14</td>\n",
       "      <td>2015</td>\n",
       "      <td>22nd Ave and 56th St</td>\n",
       "      <td>Kenosha</td>\n",
       "      <td>WI</td>\n",
       "      <td>...</td>\n",
       "      <td>16.8</td>\n",
       "      <td>25286</td>\n",
       "      <td>45365</td>\n",
       "      <td>54930</td>\n",
       "      <td>0.825869</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>14.6</td>\n",
       "      <td>0.166293</td>\n",
       "      <td>0.147312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aaron Valdez</td>\n",
       "      <td>25</td>\n",
       "      <td>Male</td>\n",
       "      <td>Hispanic/Latino</td>\n",
       "      <td>March</td>\n",
       "      <td>11</td>\n",
       "      <td>2015</td>\n",
       "      <td>3000 Seminole Ave</td>\n",
       "      <td>South Gate</td>\n",
       "      <td>CA</td>\n",
       "      <td>...</td>\n",
       "      <td>98.8</td>\n",
       "      <td>17194</td>\n",
       "      <td>48295</td>\n",
       "      <td>55909</td>\n",
       "      <td>0.863814</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>11.7</td>\n",
       "      <td>0.124827</td>\n",
       "      <td>0.050133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Adam Jovicic</td>\n",
       "      <td>29</td>\n",
       "      <td>Male</td>\n",
       "      <td>White</td>\n",
       "      <td>March</td>\n",
       "      <td>19</td>\n",
       "      <td>2015</td>\n",
       "      <td>364 Hiwood Ave</td>\n",
       "      <td>Munroe Falls</td>\n",
       "      <td>OH</td>\n",
       "      <td>...</td>\n",
       "      <td>1.7</td>\n",
       "      <td>33954</td>\n",
       "      <td>68785</td>\n",
       "      <td>49669</td>\n",
       "      <td>1.384868</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.063550</td>\n",
       "      <td>0.403954</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 name age gender    raceethnicity     month  day  year  \\\n",
       "0  A'donte Washington  16   Male            Black  February   23  2015   \n",
       "1      Aaron Rutledge  27   Male            White     April    2  2015   \n",
       "2         Aaron Siler  26   Male            White     March   14  2015   \n",
       "3        Aaron Valdez  25   Male  Hispanic/Latino     March   11  2015   \n",
       "4        Adam Jovicic  29   Male            White     March   19  2015   \n",
       "\n",
       "            streetaddress          city state    ...     share_hispanic  \\\n",
       "0            Clearview Ln     Millbrook    AL    ...                5.6   \n",
       "1  300 block Iris Park Dr     Pineville    LA    ...                0.5   \n",
       "2    22nd Ave and 56th St       Kenosha    WI    ...               16.8   \n",
       "3       3000 Seminole Ave    South Gate    CA    ...               98.8   \n",
       "4          364 Hiwood Ave  Munroe Falls    OH    ...                1.7   \n",
       "\n",
       "   p_income  h_income  county_income  comp_income  county_bucket  nat_bucket  \\\n",
       "0     28375     51367          54766     0.937936              3           3   \n",
       "1     14678     27972          40930     0.683411              2           1   \n",
       "2     25286     45365          54930     0.825869              2           3   \n",
       "3     17194     48295          55909     0.863814              3           3   \n",
       "4     33954     68785          49669     1.384868              5           4   \n",
       "\n",
       "    pov     urate   college  \n",
       "0  14.1  0.097686  0.168510  \n",
       "1  28.8  0.065724  0.111402  \n",
       "2  14.6  0.166293  0.147312  \n",
       "3  11.7  0.124827  0.050133  \n",
       "4   1.9  0.063550  0.403954  \n",
       "\n",
       "[5 rows x 34 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "police_killings = pd.read_csv(\"police_killings.csv\", encoding=\"ISO-8859-1\")\n",
    "police_killings.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['name', 'age', 'gender', 'raceethnicity', 'month', 'day', 'year',\n",
       "       'streetaddress', 'city', 'state', 'latitude', 'longitude', 'state_fp',\n",
       "       'county_fp', 'tract_ce', 'geo_id', 'county_id', 'namelsad',\n",
       "       'lawenforcementagency', 'cause', 'armed', 'pop', 'share_white',\n",
       "       'share_black', 'share_hispanic', 'p_income', 'h_income',\n",
       "       'county_income', 'comp_income', 'county_bucket', 'nat_bucket', 'pov',\n",
       "       'urate', 'college'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "police_killings.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['White',\n",
       " 'Black',\n",
       " 'Hispanic/Latino',\n",
       " 'Unknown',\n",
       " 'Asian/Pacific Islander',\n",
       " 'Native American']"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "counts = police_killings[\"raceethnicity\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "([<matplotlib.axis.XTick at 0x10800db70>,\n",
       "  <matplotlib.axis.XTick at 0x10809f4e0>,\n",
       "  <matplotlib.axis.XTick at 0x106a85748>,\n",
       "  <matplotlib.axis.XTick at 0x106b67128>,\n",
       "  <matplotlib.axis.XTick at 0x106b67b38>,\n",
       "  <matplotlib.axis.XTick at 0x106b6a588>],\n",
       " <a list of 6 Text xticklabel objects>)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAXIAAAFgCAYAAACmOvKZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAH+ZJREFUeJzt3XnYXHV9/vH3bQIKBATEhi0CVrZUZFFQRGrAFnBjqcgi\n",
       "Koo/ai9+FsS6Yauk2KpV4XIXWxGjAhI3BPuTLQVRQFMQBAyrECVAgiBIgiAB7t8f5zxk8vBsSWbm\n",
       "5Hvmfl3XXJk5M8P5DHlyP2e+53s+X9kmIiLK9YymC4iIiFWTII+IKFyCPCKicAnyiIjCJcgjIgqX\n",
       "II+IKNyYQS5pmqRLJP1a0g2Sjq23z5S0QNI19e3VHe85QdKtkm6StE+vP0BExKDTWPPIJW0MbGz7\n",
       "WklTgKuBA4FDgMW2Txn2+unAmcCuwGbAxcA2tp/sUf0REQNvzCNy2wttX1vfXwLcSBXQABrhLQcA\n",
       "Z9leans+cBuwW/fKjYiI4SY8Ri5pS2Bn4Of1pn+U9CtJp0lav962KbCg420LWBb8ERHRA5Mn8qJ6\n",
       "WOW7wHG2l0j6MnBS/fRHgZOBd4zy9qeN3UhKX4CIiJVg+2mjIeMGuaQ1gO8B37J9Tv0furfj+a8C\n",
       "59UP7wKmdbx983rbhIppC0kzbc9suo5eaPNng3y+0g3A5xvxIHi8WSsCTgPm2f5Mx/ZNOl52EHB9\n",
       "ff9c4DBJa0raCtgamLsqhUdExNjGOyLfA3gzcJ2ka+ptHwIOl7QT1bDJHcA7AWzPkzQbmAc8Dhzj\n",
       "tFeMiOipMacf9mynkls+tDLD9qVN19ELbf5skM9XugH4fCNmZ4I8IqIQo2VnLtGPiChcgjwionAJ\n",
       "8oiIwiXIIyIKlyCPiChcgjwionAJ8oiIwk2oaVYvlNY4K/PeI2J11ViQj9AUcTWWDI+I1VeGViIi\n",
       "Cpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJwCfKI\n",
       "iMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8\n",
       "IqJwCfKIiMIlyCMiCpcgj4go3JhBLmmapEsk/VrSDZKOrbdvKOkiSbdIulDS+h3vOUHSrZJukrRP\n",
       "rz9ARMSgk+3Rn5Q2Bja2fa2kKcDVwIHA24H7bH9S0geADWx/UNJ04ExgV2Az4GJgG9tPDvvvGkbf\n",
       "7+pH2FbTVUTEYJPkkbJozCNy2wttX1vfXwLcSBXQ+wOz6pfNogp3gAOAs2wvtT0fuA3YrSufICIi\n",
       "RjThMXJJWwI7A78AptpeVD+1CJha398UWNDxtgVUwR8RET0yeSIvqodVvgccZ3uxtOzI3raroZJR\n",
       "jfLczI77M+pbREQMkTSDCYTjuEEuaQ2qEP+m7XPqzYskbWx7oaRNgHvr7XcB0zrevnm9bQQzx9t1\n",
       "RMRAs30pcOnQY0knjvS68WatCDgNmGf7Mx1PnQscWd8/EjinY/thktaUtBWwNTB3JeqPiIgJGm/W\n",
       "yiuAy4DrWDZEcgJVOM8GngfMBw6x/WD9ng8BRwGPUw3FXDDCfzezViIiVtBos1bGDPJeFpMgj4hY\n",
       "MSs1/TAiIlZ/CfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIl\n",
       "yCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJw\n",
       "CfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4goXII8IqJwCfKIiMIlyCMiCpcgj4go\n",
       "XII8IqJwCfKIiMIlyCMiCjdukEv6mqRFkq7v2DZT0gJJ19S3V3c8d4KkWyXdJGmfXhUeERGViRyR\n",
       "nw7sN2ybgVNs71zffgwgaTpwKDC9fs+XJOWoPyKih8YNWds/BR4Y4SmNsO0A4CzbS23PB24Ddlul\n",
       "CiMiYkyrcrT8j5J+Jek0SevX2zYFFnS8ZgGw2SrsIyIixrGyQf5lYCtgJ+Ae4OQxXuuV3EdEREzA\n",
       "5JV5k+17h+5L+ipwXv3wLmBax0s3r7eNYGbH/Rn1LSIihkiawQTCUfb4B8yStgTOs71D/XgT2/fU\n",
       "948HdrX9pvpk55lU4+KbARcDL/CwnUhyWQfqwvZI5wQiIvpGkkfKonGPyCWdBbwS2EjSncCJwAxJ\n",
       "O1Gl8R3AOwFsz5M0G5gHPA4cMzzEIyKiuyZ0RN71neaIPCJihY12RJ453hERhUuQR0QULkEeEVG4\n",
       "BHlEROES5BERhUuQR0QULkEeEVG4BHlEROES5BERhVupplkxturK1bLkytWIciXIe6akLE+GR5Qs\n",
       "QysREYVLkEdEFC5BHhFRuAR5REThEuQREYVLkEdEFC5BHhFRuAR5REThEuQREYVLkEdEFC5BHhFR\n",
       "uAR5REThEuQREYVLkEdEFC5BHhFRuAR5REThEuQREYVLkEdEFC5BHhFRuAR5REThEuQREYVLkEdE\n",
       "FC5BHhFRuAR5REThEuQREYUbN8glfU3SIknXd2zbUNJFkm6RdKGk9TueO0HSrZJukrRPrwqPiIjK\n",
       "RI7ITwf2G7btg8BFtrcB5tSPkTQdOBSYXr/nS5Jy1B8R0UPjhqztnwIPDNu8PzCrvj8LOLC+fwBw\n",
       "lu2ltucDtwG7dafUiIgYycoeLU+1vai+vwiYWt/fFFjQ8boFwGYruY+IiJiAyav6H7BtSR7rJSNv\n",
       "ntlxf0Z9i4iIIZJmMIFwXNkgXyRpY9sLJW0C3FtvvwuY1vG6zettI5i5kruOiBgMti8FLh16LOnE\n",
       "kV63skMr5wJH1vePBM7p2H6YpDUlbQVsDcxdyX1ERMQEjHtELuks4JXARpLuBD4CfAKYLekdwHzg\n",
       "EADb8yTNBuYBjwPH2B5r2CUiIlaRmsjZaky9pHwXtjXhV7f880VEMyR5pH+rmeMdEVG4BHlEROES\n",
       "5BERhUuQR0QULkEeEVG4BHlEROES5BERhUuQR0QULkEeEVG4BHlEROES5BERhUuQR0QULkEeEVG4\n",
       "BHlEROES5BERhUuQR0QULkEeEVG4BHlEROES5BERhUuQR0QULkEeEVG4BHlEROES5BERhUuQR0QU\n",
       "LkEeEVG4yU0XEGWR5KZrWBm21XQNEb2SII+VUFqWJ8Oj3TK0EhFRuAR5REThEuQREYVLkEdEFC5B\n",
       "HhFRuAR5REThEuQREYVLkEdEFC5BHhFRuFW6slPSfOAh4Algqe3dJG0InA1sAcwHDrH94CrWGRER\n",
       "o1jVI3IDM2zvbHu3etsHgYtsbwPMqR9HRESPdGNoZXgji/2BWfX9WcCBXdhHRESMohtH5BdLukrS\n",
       "0fW2qbYX1fcXAVNXcR8RETGGVe1+uIfteyQ9F7hI0k2dT9r26G1PZ3bcn1HfIiJiiKQZTCAcZXen\n",
       "JamkE4ElwNFU4+YLJW0CXGJ7u2GvdVmtULVC/azb/PnK+2ywon9/EasrSR7pZ3mlh1YkrS1p3fr+\n",
       "OsA+wPXAucCR9cuOBM5Z2X1ERMT4VmVoZSrwA0lD/50zbF8o6SpgtqR3UE8/XOUqIyJiVF0bWlmh\n",
       "nRb39TxDK0+9srjPBhlaibbo+tBKRESsHhLkERGFS5BHRBQuQR4RUbgEeURE4RLkERGFS5BHRBQu\n",
       "QR4RUbgEeURE4RLkERGFS5BHRBQuQR4RUbgEeURE4RLkERGFS5BHRBQuQR4RUbgEeURE4RLkERGF\n",
       "S5BHRBQuQR4RUbgEeURE4RLkERGFS5BHRBQuQR4RUbgEeURE4RLkERGFm9x0ARGrE0luuoaVYVtN\n",
       "1xDNSZBHPE1pWZ4MH3QZWomIKFyCPCKicAnyiIjCZYw8YoDkZG47JcgjBk5pWZ4MH0+GViIiCpcg\n",
       "j4goXE+CXNJ+km6SdKukD/RiHxERUZHd3fEySZOAm4G/Ae4C/hc43PaNHa9xWeN0WqGTLW3+fOV9\n",
       "Nsjn63jlQHy+sqxotoz0+l6c7NwNuM32/HrH3wYOAG4c600REd1RUpZ350RuL4ZWNgPu7Hi8oN4W\n",
       "ERE90IsgL+nXYURE8XoxtHIXMK3j8TSqo/JhypobuuJjb23+fGV9NsjnG/bq3hXSI23+fN0Y1+/F\n",
       "yc7JVCc7XwXcDcxl2MnOiIjonq4fkdt+XNK7gAuAScBpCfGIiN7p+hF5RET0V67sjIgoXJpm9Yjq\n",
       "mftN19ENkjYGdqWakTTX9r0Nl9Q1kp4FvAHYkmX/Hmz7pMaK6hJJAja3fee4Ly6YpM2o/v4mUZ3p\n",
       "tO3LGi2qz/pyRC7pGZLeIukj9ePnSdqtH/vuB0kfHfZ4EnBGQ+V0laRDgF8AbwQOAeZKemOzVXXV\n",
       "D4H9gaXAkvr2cKMVddePmy6glyT9B3A58M/A+4D31n8OlL6MkUs6FXgS2Nv2dpI2BC60/ZKe77wP\n",
       "JH0duNn2xyU9E5gNXGN7ZqOFdYGk64C/GToKl/RcYI7tFzVbWXdIusH2C5uuo1ckzQK+aHtu07X0\n",
       "gqRbgB1s/7npWprUrzHyl9o+BngEwPYfgDX6tO9+OAp4kaQTgB8Bl7YhxGsCft/x+H5Km6g7tisk\n",
       "teKX0iheBlwp6XZJ19e365ouqot+A6zZdBFN69cY+WP1cAPw1FHdk33ad89IejHLrmT9DPAV4Arg\n",
       "J5J2sf3LxorrnvOBCySdSRXgh9Kur+t7Am+XdAcwdFTntnzjAPZtuoAeewS4VtIclv/7O7bBmvqu\n",
       "X0Mrb6YaX30xMAs4GPgX27N7vvMeknQpy7ckUOdj23v1u6Zuq0+Y/R3wCqrP9lPbP2i2qu6RtAUj\n",
       "fMMYavrWBpL2BF5g+/T6IGqK7TuarqsbJL1thM22PavftTSpb/PIJW1PdbUnVGOsuUgoGifp34Cf\n",
       "AFfYbtNJTgAkzaQ6gNrW9jb1DI/ZtvdotrLopn7NWvmm7Rttf6G+3Sjpm/3Ydz9I+pik9Tseb1AH\n",
       "RPEkvaFeIOQhSYvr20NN19VFtwNvAq6S9L+STpZ0YNNFddFBVG2kHwawfRewbqMVdZGkbSR9V9I8\n",
       "SXfUt9ubrqvf+nWyc7lZAXU/lhf3ad/98BrbDw49sP0A8NoG6+mmTwL7217P9rr1bb2mi+oW21+z\n",
       "/XZgL+BbVEOA32q2qq76s+2nzkdJWqfJYnrgdOBU4HFgBtXQbSum/q6Inga5pA9JWgzs0HE0txi4\n",
       "Fzi3l/vus2fUF5YAIGkt2nMmfWGbh8EknSbpCuDLVCf/3wBs0GxVXfUdSV8B1pf098Ac4KsN19RN\n",
       "a9m+mGqY+Lf1bLG2HERNWE9nrdj+GPAxSZ+w/cFe7qthZwBzJH2N6sTZ24FvNFtS11wl6WzgHOCx\n",
       "epttf7/BmrppQ6p/Bw8CfwDus7202ZK6x/anJO0DLAa2AT5s+6KGy+qmR+sZcbfVzfruBtr2rWNc\n",
       "PT3ZKWk72zcNm6b3lJZMzwNA0qup1ik1cJHtCxouqSvqi51g2N9fPRzRGvXJ+P2AdwOTbG/ecEkx\n",
       "AfUV4jcC6wMfBdYDPmn7540W1me9DvL/sn30CNP0gHZMz4uySXo91VzyPanC4OdUUyy/1mhhq0jS\n",
       "EkZfrcttOs8RaWPbFZJ2Bz4HbA88k6p5z5KS/7FI+oDt/5D0+RGebs0FF5K+CFxGFd53N11Pt9Wz\n",
       "p+5m2QncI4BNbX+4uaq6R9JFwBuHJhtI2gD4tu22Xwi1nL51P5T0cpbvMIfttowjfwE4jKrHykuA\n",
       "twLbNlrRqptX/3k1Y1z0VDrb/3eou6OkXWhZd0eqGUedV6l+ub5EvxVBDjx3+IwxSVObLKgJfQly\n",
       "Sd8Cng9cCzzR8VRbghzbt0qaZPsJ4HRJ1wLFnuC1fV5990/Dr8CtOyK2Qv1ZPkV1UZCAL0h6n+3v\n",
       "NFtZ1zxcX1l9Vv34MKoOj23xhKQtbP8WQNKWtKD9x4rq1yX6NwLT29KfezhJlwF/SzWt6x5gIXCk\n",
       "7R0bLawLJF1je+fxtpVqALo7bgV8Fnh5vely4Li2tCCQtB/wn1TDYwB/Dfy97fObq6r/+jW0cgOw\n",
       "CdVYXRu9lWpO/ruA44HNqeYjF6uehfMaYDNJn2NZP5J1qXp3t0WruzvWPVX2b7qOXrF9fj0r7mVU\n",
       "Q37vtn1fw2X1Xa9nrQx9PZ8C7AzMZfkOZa39ASudpB2p/s5OohpPHQq3h4BL6qtXiyfpU8COQGd3\n",
       "x+tsv7/RwrpE0l8AR/P0FZCOaqyoLpC0fd3qY2hq89DPp6FdU5snotdBfjzVFY6/ZNnFJFD/T7d9\n",
       "ac923geSrh/j6Va0QpW0pu3Hxn9lmQagu+OVVMMOV7Ns7Ni2v9dcVasuU5uX1+sgPxnYnWpa3vVU\n",
       "43OXU3Wa+0PPdtwn9YmVUbVhHFLSNsDHgOnAWvVm235+c1XFREm61vZOTdfRC5KeAexu+/Kma2la\n",
       "v052PpNqWt7uVCdddgcetL19z3feZ5I2Au5vy4ldSZcDJwKnAK+naj8wqUXzkN8AfAKYSsfX85Kv\n",
       "AehUzyO/0vZ/N11LL7T5F9WK6Ff3w7WoLp19dn27m+oKuqJJ2l3SpZK+L2kXSTdQndi9tz5Z2AZt\n",
       "b0rU6u6OVC0HzpP0aEvbEF8s6eB6iGxg9XTWiqT/ovpKvpjqROcVwCltOVFGdSHQCVS/nP4H2M/2\n",
       "zyVtB3ybdiyJ1vamRK3u7mh7StM19Ng/AO+hmk/+aL2tNd+oJqrX0w+fR3XJ+q3AXfXtwTHfUZZJ\n",
       "ti8EkHTSUKOeulFYK4ZWqI7o1gaOZVlToiMbrai72t7dceiy9a2Bp1ot275s9HeUYwB+UU1Ir9vY\n",
       "7lufkPgrqnHx91D1Jr8f+Lntj/Ry/33QGdaPjvqqgtmeW99dDLwNQNKnacHQWO3ZwJ+AfYZtb0WQ\n",
       "Szqa6pfwNOAaqvnWVwJ7N1lXt9T5cgSwle2TJD0P2Ljj53Yg9HPNzmlUJzr3AF4HPMf2s/uy8x6R\n",
       "9ARVCEB1HuCRjqfXst23Xjb9JOlO29OarqMbJD3H9v3Dtj3fdiuWC6vP2+xKdcJzp3rY7+O2D2q4\n",
       "tK6QdCrVtMq9bW8naUPgQtsvabi0vur1CkHHSTpb0u+oelm8nqp38EFUDf2LZntSxwmyyR33121r\n",
       "iLfQeZKeOqCQNB04b4zXl+ZR248ASHqW7Zsov6Fbp5faPob6IKqe1rxGsyX1X6/DZkuqjoDHt7FF\n",
       "aJvVRzYjPkX/Zjv1w79ThflrqALuG1Rf1dviznqM/BzgIkkPAPObLamrHqtPxgNP9cpJ06wIAEnz\n",
       "GaNdre2t+ldNb0k6CHg/VSuJg23f3HBJPSFpBtXJ6vPbcrVu3dnxEKrF3GcBBwP/MrxjZ9slyGNE\n",
       "A3Bp/vAFM/YGfgP8lhYsnDHGNyrgqSGIVqiX6XtV/XBOm6eTjiZBHiOSdBWwADif6ghufrMVdZek\n",
       "t7HsG0dnwyVRBfmsJurqlgH7RrUB1VTnyaRpVsTy6l7W+wH7UrXm/Rnw/4Cf2P7zWO+N6AdJH6Wa\n",
       "Fns7HWPjaZoVMQJJa1ItULwvMAP4ve3iL9WX9AqqXjJbsnyb11Y0BZO0B/Ar20skvYWqNfFnh1bU\n",
       "KZ2kW4AXtnkYcCIS5DEmSetQTWF7on48ieoKwQ1sL2i0uC6QdDPV1au/pGMZwrYsTlC3Wt4R2AH4\n",
       "OnAa1WLFr2yyrm6R9APgH2wvarqWJmWuc4znf6hOJA2t87g2cIHtl4/+lqI8aLsNPXFG87jtJyUd\n",
       "CHzR9lclFb2oxDAfA66pL3wa2EVrEuQxnmfafmqxXtuLJa3dZEFddkm9StD3Wb7XSltOli2W9CHg\n",
       "zcCe9TeqNl0w8w2qNsQ30LFwRnPlNCNBHuN5WNKLbV8NIOklLN+KoHQvrf8cfkl3W06WHQq8CTjK\n",
       "9sK6F8mnG66pm5bY/lzTRTQtY+QxJkm7UrXkvafetAlwqO2rmqtq1Un6p2GbDNwH/KwtfVYGgaRT\n",
       "qIZUzmXZ0EqmH0YMV89Y2ZYq7G62vbThklaZpJk8/Sv4hlTTLWfaPqvvRXWRpCWMPsTQmn7dWbOz\n",
       "kiCPEUl6le059VJoI61S3oo2r8PVV0TOsb1z07XEypG0se2FTdfRTxkjj9H8NTCHqmPlSL/tWxnk\n",
       "tv8w4KuGFUnS+lR9Vg6nWux902Yr6q8ckUd0kLQX8GHbrVh4oc3q2VMHUIX3TlQNwQ4Efjp03cOg\n",
       "SJDHmCQ9C3gDT7/y8aTGiuqC+kKZ4TagOqn71kFsvFQSSWdRzTi6kKpV9k+A29rUQ2ZFZGglxvND\n",
       "qnVWr6Zdy9m9fthjA/d3zplvA0nPB+7pWFxiLWBqC5qgbQ/cS7VQzY22nxjkIbEckceYJN1g+4VN\n",
       "1xErR9LVwO5DvUgkPRO4vA1LodXtaw+n6kf+e6pwf+GgneiEdq30Er1xhaQXNV1ErLRJnQ2l6q6V\n",
       "rbiy0/aNtj9iezvgeKqFJeZKuqLh0vouQysxnj2Bt0u6g+V7WSTcy3CfpANs/xBA0gFUFz61Sn2B\n",
       "2lWS3kf1MztQMrQSY5K05UjbWzDGOhAkvQA4g2XT8RYAb7F9W3NVRbclyGNCJP0FVftaAGz/rsFy\n",
       "YgVJmgLQtpO5UcnQSoxJ0v7AyVRHdPcCW1DNFPirJuuKsUl6i+1v1j1l3LF9aCm7U5qrLrotJztj\n",
       "PP8G7A7cUs/RfRXwi2ZLigkYajW87rDblPrPVpC0saTTJJ1fP54u6R1N19VvOSKP8Sy1fZ+kZ0ia\n",
       "ZPsSSZ9tuqgY11/Wf86zPbvRSnrr68DpwD/Xj2+lukDotKYKakKOyGM8D0haF/gpcIakz7FstaBY\n",
       "fb2mHkY5oelCemwj22dTL9NXd+Z8vNmS+i9H5DGeA6kWkng31Soz6wH/2mhFMRE/Bh4ApkhaPOy5\n",
       "1rSxBZZIes7QA0kvA/7YYD2NyKyVGJekTYDdqE6azR3EK+dKJencNq9fKenFwOepTr7/GngucLDt\n",
       "XzVaWJ8lyGNMkv4P8BHgknrTDOAk2wM1BhmrL0mTge2oeubf3Hkl66BIkMeYJN1C1avj/vrxc4Ar\n",
       "bW/TbGUxFkmX295jlJWCWjO0Iuk6qqUIz7b9m6braUpOdsZ47mP5k5tLaOEl3m1je4/6zym21x12\n",
       "a0WI1/anOtE5W9JVkt5bLzA9UHJEHmOS9E3ghVTtbKFq5H9dfcuFJau5+uTfPNsP1Y/XA7a33bpr\n",
       "ASRtDXwYOML2pKbr6afMWonx/Ka+Df3G/2F9f0pjFcWKOBXYpePxw/W21qxJWvcDOpSqne0TwPub\n",
       "rKcJCfIYk+2ZQ/clTQKm2B646V0ls/1kx/0n6r/HVpD0C2BNqouA3mj79oZLakTGyGNMks6UtJ6k\n",
       "dYDrgXmSBu6Ip2B3SDpW0hqS1pR0HNCmsHur7Z1tf3xQQxwyRh7jkPQr2ztKOoLqK/oHgV/a3qHh\n",
       "0mICJE0FPgfsVW+aAxxn+97mqlp1IzQF61znbeDO3WRoJcYzWdIaVFd4ftH2Ukn57V8I24uoxo/b\n",
       "prMp2MD/PCbIYzxfAeZTzVK5rD6xlDHyQtSLLb8DmM7y/eSPaqyoLrD9lfruxbZ/1vmcpFc0UFKj\n",
       "MrQSK6RuxDTJ9sA1JiqRpO9S9Y8/gqpHzpupVp0/ttHCukTSNbZ3Hrbtl7Z3Ge09bZQj8hjRKAsT\n",
       "DI1DGhioMciCvcD2wfW6nbMknQn8bNx3reYk7Q68HHiupPew7GdzXaA1s3ImKkEeoxltDFJkTLIk\n",
       "Q31H/ihpB2AhVWOp0q3JstDuXCjjIeDgRipqUIZWIlqsbnr2fWAHqkUYpgAftn1qk3V1i6QtsxB4\n",
       "gjxGIenzHQ9Hmt7VijHWtqrPZRwIvAC4zvYFDZfUE/Wi4O+nOpm7Vr3Ztvdurqr+y9BKjOZqlgX4\n",
       "v1K1su0cI4/V25eowu0K4KOSXmr7pIZr6oUzgLOB1wHvBN4G/L7JgpqQI/IY10gzA2L1JunXwIvq\n",
       "S/LXBn7WxpkcQzNUJF1n+0X1tqtsv6Tp2vopR+QR7fSY7aF1LP9UD7W00dDJ3IWSXgfcDWzQYD2N\n",
       "SJBHtNN2kq7vePyXHY89dPTaAv8uaX3gn6iWfFsPOL7ZkvovQysxomEry6xFtQDzkNasMNNWkrYY\n",
       "ujvS85np0S4J8ogWknQBcD7wY9s3NV1Pt0k6cZSnDNDSE7ujSpBHtJCkTYD9gH2BbYFfAD+m6k3y\n",
       "cJO1dYOk9/L02VPrUPWV2cj2Ov2vqjkJ8oiWqxeSeCnwamBv4FHgAtufbLSwLqmXrzuWKsRnAyeX\n",
       "3qZ3RSXIIwaMpI2AfW2f0XQtq0LSc6hObB4BfAP4jO0Hmq2qGZm1EtFi9ZWPRwNbsuzfu0tvYyvp\n",
       "08BBwH9SzZdf3HBJjcoReUSLSboSuIzqSt2htTtt+3vNVbXqJD1JNYd86QhPD9ysqgR5RItJutb2\n",
       "Tk3XEb2VxZcj2u1Hkl7bdBHRWzkij2ix+sKutVl+GGLghh7aLkEeEVG4zFqJaDlJGwBbs/ziy5c1\n",
       "V1F0W4I8osUkHU11scw04BrgZcCVVBcGRUvkZGdEux0H7AbMt70XsDPwx2ZLim5LkEe026O2HwGQ\n",
       "9Ky6gda2DdcUXZahlYh2u7MeIz8HuEjSA8D8ZkuKbsuslYgBIWkG1cIL59t+bJyXR0ES5BEtJGk9\n",
       "2w9J2nCk523/od81Re8kyCNaSNJ/236tpPk8vW83trfqf1XRKwnyiIjCZdZKRItJ2kPSlPr+WySd\n",
       "0rGeZ7REgjyi3U4F/iRpR+A9wO1UizBEiyTII9rtcdtPAgcCX7T9BWDdhmuKLss88oh2WyzpQ8Cb\n",
       "gT3r9TvXaLim6LIckUe026HAn4GjbC8ENgM+1WxJ0W2ZtRIxQCTtCRxu+5ima4nuydBKRMtJ2gU4\n",
       "HDgEuAMoer3OeLoEeUQLSdqWKrwPBX4PfIfqG/iMJuuK3sjQSkQL1avM/wh4l+3f1dvuyBWd7ZST\n",
       "nRHt9HfAI8Blkk6V9CpADdcUPZIj8ogWq6/qPIBqmGUvqouBfmD7wkYLi65KkEcMiLoT4sHAYbaz\n",
       "1FuLJMgjIgqXMfKIiMIlyCMiCpcgj4goXII8IqJw/x8xxAHAVvo71wAAAABJRU5ErkJggg==\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x108001080>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "plt.bar(range(6), counts)\n",
    "plt.xticks(range(6), counts.index, rotation=\"vertical\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "White                     0.505353\n",
       "Black                     0.289079\n",
       "Hispanic/Latino           0.143469\n",
       "Unknown                   0.032120\n",
       "Asian/Pacific Islander    0.021413\n",
       "Native American           0.008565\n",
       "dtype: float64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "counts / sum(counts)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Racial breakdown\n",
    "\n",
    "It looks like people identified as `Black` are far overrepresented in the shootings versus in the population of the US (`28%` vs `16%`).  You can see the breakdown of population by race [here](https://en.wikipedia.org/wiki/Race_and_ethnicity_in_the_United_States#Racial_makeup_of_the_U.S._population).  \n",
    "\n",
    "People identified as `Hispanic` appear to be killed about as often as random chance would account for (`14%` of the people killed as Hispanic, versus `17%` of the overall population).\n",
    "\n",
    "Whites are underrepresented among shooting victims vs their population percentage, as are Asians."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x107f797f0>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": [
       "iVBORw0KGgoAAAANSUhEUgAAAYEAAAEACAYAAABVtcpZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n",
       "AAALEgAACxIB0t1+/AAAGAJJREFUeJzt3X+sZGd93/H3F6+xwaZeNlbXxjZch8QBA7VDA3ZbqNfE\n",
       "UJckgKIIGymWXZr8Q1JwKgG7pGrzTyl2FcVNKlQpidkVAgeHgIvVNPXi7EmQQjEULxjbi3HDCtvJ\n",
       "rh1gXRqpio2//eM81zu+M3t37vx6nnvn/ZJG95wz88x89pzZ+c483zP3RmYiSVpOz6sdQJJUj0VA\n",
       "kpaYRUCSlphFQJKWmEVAkpaYRUCSlti6RSAibo2IoxFx38C2/xgRD0bE1yLiMxFx1sB1eyLiWxFx\n",
       "KCLeMs/gkqTpneyTwMeAq9dsuwt4VWZeAjwE7AGIiIuBa4CLy5iPRoSfNCSpYeu+SGfmF4Dvr9m2\n",
       "PzOfKatfAs4vy28HbsvMpzLzMPAw8PrZxpUkzdK079TfDfxxWX4J8OjAdY8C5015/5KkOZq4CETE\n",
       "rwN/l5mfXOdm/k4KSWrYtkkGRcQNwFuBnx7Y/BhwwcD6+WXb2rEWBkmaQGbGPO503QuwAtw3sH41\n",
       "cD9w9prbXQwcBJ4PXAj8byBG3F+e7DFrXIDfqJ3BTGZaxlxmGjtTzuN+1/0kEBG3AVcAZ0fEI8C/\n",
       "oz8b6PnA/ogA+GJmviczH4iI24EHgKeB92RJvkms1A4wwkrtACOs1A4wwkrtACOs1A5wAiu1A4yw\n",
       "UjvACCu1AyzKukUgM981YvOt69z+w8CHpw0lSVoMz+M/bm/tACPsrR1ghL21A4ywt3aAEfbWDnAC\n",
       "e2sHGGFv7QAj7K0dYFFi0TM2EZE5j+aGJG1h83rt9JNAERG7amdYy0zjMdP4WsxlprosApK0xJwO\n",
       "kqRNwOkgSdLMWQSKFucAzTQeM42vxVxmqssiIElLzJ6AJG0C9gQkSTNnEShanAM003jMNL4Wc5mp\n",
       "LouAJC0xewKStAnYE5AkzZxFoGhxDtBM4zHT+FrMZaa6LAKStMTsCUjSJmBPQJI0cxaBosU5QDON\n",
       "x0zjazGXmeqyCEjSErMnIEmbgD0BSdLMWQSKFucAzTQeM42vxVxmqssiIElLzJ6AJG0C9gQkSTNn\n",
       "EShanAM003jMNL4Wc5mprm21AyyriBhrHi5i9Kc/p9QkzcK6PYGIuBX4GeDxzHxN2bYD+BTwMuAw\n",
       "8M7MPFau2wO8G/gh8N7MvGvEfdoTYLUITNqPCYuAtGRq9QQ+Bly9ZttuYH9mXgTcXdaJiIuBa4CL\n",
       "y5iPRoTTTZLUsHVfpDPzC8D312x+G7CvLO8D3lGW3w7clplPZeZh4GHg9bOLOl9tzgF2tQMMaXE/\n",
       "mWl8LeYyU12TvFPfmZlHy/JRYGdZfgnw6MDtHgXOmyKbJGnOppquyb6hsN7E9mK/hDCFzOxqZxi2\n",
       "q3aAIS3uJzONr8VcZqprkrODjkbEOZl5JCLOBR4v2x8DLhi43fll25CI2EvfVAY4Bhxc3emrH8O2\n",
       "+vpxXfm5a4PrvVb+Pa677vps18vyDfQOMycn/cZwRKwAdw6cHXQz8N3MvCkidgPbM3N3aQx/kr4P\n",
       "cB7weeDHcs0DtHp2UETsWmT1H+/soI7RnwbqnR206P00DjONr8VcZhrPvF471/0kEBG3AVcAZ0fE\n",
       "I8C/BT4C3B4R/5JyiihAZj4QEbcDDwBPA+9ZWwAkSW3xdwdV4vcEJG2EvztIkjRzFoGizfOCu9oB\n",
       "hrS4n8w0vhZzmakui4AkLTF7ApXYE5C0EfYEJEkzZxEo2pwD7GoHGNLifjLT+FrMZaa6LAKStMTs\n",
       "CVQybU9gGu5/afOp8o1htaxOAZG0tTgdVLQ5B9jVDjCkxf1kpvG1mMtMdVkEJGmJ2ROoZPqegN8x\n",
       "kJaJ3xOQJM2cRaBocw6wqx1gSIv7yUzjazGXmeqyCEjSErMnUIk9AUkbYU9AkjRzFoGizTnArnaA\n",
       "IS3uJzONr8VcZqrLIiBJS8yeQCX2BCRthD0BSdLMWQSKNucAu9oBhrS4n8w0vhZzmakui4AkLTF7\n",
       "ApXYE5C0EfYEJEkzZxEo2pwD7GoHGNLifjLT+FrMZaa6LAKStMTsCVRiT0DSRtgTkCTN3MRFICL2\n",
       "RMT9EXFfRHwyIk6LiB0RsT8iHoqIuyJi+yzDzlObc4Bd7QBDWtxPZhpfi7nMVNdERSAiVoBfBl6b\n",
       "ma8BTgGuBXYD+zPzIuDusi5JatREPYGI2AF8Ebgc+AHwWeC3gd8BrsjMoxFxDtBl5ivWjLUngD0B\n",
       "SRvTVE8gM78H/CbwHeCvgGOZuR/YmZlHy82OAjtnklKSNBfbJhkUES8HbgRWgCeBP4yIXxy8TWZm\n",
       "/2535Pi9wOGyegw4mJlduW5XGb/Q9dVti3y8Xld+7hqx3g3cbu3144wftd5nmCL/jTRwvNasX5qZ\n",
       "tzSUh9VtreTx+G2+41eWbyhxDjMnk04HXQO8OTN/qaxfRz819Cbgysw8EhHnAgc2y3TQ4Avjgh5v\n",
       "jOmgjsEX74HR1JoOWvR+GoeZxtdiLjONZ16vnZMWgUuATwCvA/4fsBe4B3gZ8N3MvCkidgPbM3P3\n",
       "mrFNFoFFsycgaSOaKgIAEfEB4HrgGeCrwC8BLwJuB15K//HlnZl5bM04iwAWAUkb01RjGCAzb87M\n",
       "V2XmazLz+sx8KjO/l5lXZeZFmfmWtQWgZW2eF9zVDjCkxf1kpvG1mMtMdfmNYUlaYv7uoEqcDpK0\n",
       "EfN67ZzoFFH1TnQKrCRtFk4HFZPPAeaEl3F0k0WaoxbnSs00vhZzmakui4AkLTF7AlOoOa9vT0Ba\n",
       "Ls2dIipJ2vwsAkWbc4Bd7QBDWtxPZhpfi7nMVJdFQJKWmD2BKdgTkLQo9gQkSTNnESjanAPsagcY\n",
       "0uJ+MtP4WsxlprosApK0xOwJTMGegKRFsScgSZo5i0DR5hxgVzvAkBb3k5nG12IuM9VlEZCkJWZP\n",
       "YAr2BCQtij0BSdLMWQSKNucAu9oBhrS4n8w0vhZzmakui4AkLTF7AlOwJyBpUewJSJJmziJQtDkH\n",
       "2NUOMKTF/WSm8bWYy0x1WQQkaYnZE5iCPQFJi2JPQJI0cxaBos05wK52gCEt7iczja/FXGaqa+Ii\n",
       "EBHbI+LTEfFgRDwQEZdFxI6I2B8RD0XEXRGxfZZhJUmzNXFPICL2AX+WmbdGxDbgDODXgb/JzJsj\n",
       "4oPAizNz95px9gT60dgTkDSueb12TlQEIuIs4N7M/NE12w8BV2Tm0Yg4B+gy8xVrbmMR6EdjEZA0\n",
       "rtYawxcCT0TExyLiqxHxuxFxBrAzM4+W2xwFds4k5QK0OQfY1Q4wpMX9ZKbxtZjLTHVtm2Lca4Ff\n",
       "zcwvR8QtwHOmfTIz+3fKwyJiL3C4rB4DDmZmV67bVcYvdH0g24bGH3+hXr2bcdc5yfXzGt//Gybd\n",
       "X8ClEbHw43OS9UtX/6GN5HlWK3k8fpvv+JXlG0qUw8zJpNNB5wBfzMwLy/obgD3AjwJXZuaRiDgX\n",
       "OOB00AlH43SQpHE1NR2UmUeARyLiorLpKuB+4E7g+rLteuCOqRNKkuZmmu8J/CvgExHxNeAfAP8e\n",
       "+Ajw5oh4CHhTWd8U2pwD7GoHGNLifjLT+FrMZaa6Ju0JkJlfA1434qqrJo+jRThRr2ZMV84siKTq\n",
       "/N1BU9isPQH7CdLm01RPQJK0NVgEijbnALvaAYa0uJ/MNL4Wc5mpLouAJC0xewJTsCcgaVHsCUiS\n",
       "Zs4iULQ5B9jVDjCkxf1kpvG1mMtMdVkEJGmJ2ROYgj0BSYtiT0CSNHMWgaLNOcCudoAhLe4nM42v\n",
       "xVxmqssiIElLzJ7AFOwJSFoUewKSpJmzCBRtzgF2tQMMaXE/mWl8LeYyU10WAUlaYvYEpmBPQNKi\n",
       "2BOQJM2cRaBocw6wqx1gSIv7yUzjazGXmeqyCEjSErMnMAV7ApIWxZ6AJGnmLAJFm3OAXe0AQ1rc\n",
       "T2YaX4u5zFSXRUCSlpg9gSnYE5C0KPN67dw26zvU1tYXvslYQKT2OB1UtDkH2NUOMMIB+k8SG73M\n",
       "T4vHrsVM0GYuM9VlEZCkJTZVTyAiTgG+AjyamT8XETuATwEvAw4D78zMY2vG2BPoR7NsY7fKcZdq\n",
       "aPV7Au8DHuD4K8NuYH9mXgTcXdYlSY2auAhExPnAW4Hfo3+LCPA2YF9Z3ge8Y6p0C9TmHGBXO8AI\n",
       "Xe0AQ1o8di1mgjZzmamuaT4J/BbwfuCZgW07M/NoWT4K7Jzi/iVJczbRKaIR8bPA45l574kqZmbm\n",
       "iU4njIi99D0DgGPAwczsynW7yvhNsX78nfHqbhh3nZNcv6tcphk/an1127i3n9X43ryOx7zvf6us\n",
       "r25rJY/H78TrZfmGsmsOMycTNYYj4sPAdcDTwOnA3wM+A7wO2JWZRyLiXOBAZr5izVgbw/1olm3s\n",
       "VjnuUg1NNYYz80OZeUFmXghcC/xpZl4HfA64vtzseuCO2cScvzbnALvaAUboagcY0uKxazETtJnL\n",
       "THXN6nsCq28PPwK8OSIeAt5U1iVJjfJ3B03B6aCNjd0qx12qoanpIEnS1mARKNqcA+xqBxihqx1g\n",
       "SIvHrsVM0GYuM9VlEZCkJWZPYAr2BDY2dqscd6kGewKSpJmzCBRtzgF2tQOM0NUOMKTFY9diJmgz\n",
       "l5nqsghI0hKzJzAFewIbG7tVjrtUgz0BSdLMWQSKNucAu9oBRuhqBxjS4rFrMRO0mctMdVkEJGmJ\n",
       "2ROYgj2BjY3dKsddqsGegCRp5iwCRZtzgF3tACN0tQMMafHYtZgJ2sxlprosApK0xOwJTMGewMbG\n",
       "bpXjLtUwr9fOif7QvDSJvmhOxgIizYfTQUWbc4Bd7QAjdFOMzQkv62vx2LWYCdrMZaa6LAKStMTs\n",
       "CUzBnsDixm6V54w0Kb8nIEmaOYtA0eYcYFc7wAhd7QBDWjx2LWaCNnOZqS6LgCQtMXsCU7AnsLix\n",
       "W+U5I03KnoAkaeYsAkWbc4Bd7QAjdLUDDGnx2LWYCdrMZaa6LAKStMTsCUzBnsDixm6V54w0qaZ6\n",
       "AhFxQUQciIj7I+IbEfHesn1HROyPiIci4q6I2D7buJKkWZp0Ougp4Ncy81XA5cCvRMQrgd3A/sy8\n",
       "CLi7rG8Kbc4BdrUDjNDVDjCkxWPXYiZoM5eZ6pqoCGTmkcw8WJb/L/AgcB7wNmBfudk+4B2zCClJ\n",
       "mo+pewIRsQL8GfBq4DuZ+eKyPYDvra4P3L6pnsA0v964t/nm1zfj2JaeM1INTf49gYg4E/gj4H2Z\n",
       "+YP+db+XmTn9C+yiTPPCJkmb18RFICJOpS8AH8/MO8rmoxFxTmYeiYhzgcdPMHYvcLisHgMOZmZX\n",
       "rtsFsKj13urirjXLa6+b5fqoxz5RlknHj1pf3Tbu7deu3wJcOsF4TnL9eONPcDwvzcxb1rl+4eur\n",
       "21rJM7B+IxX/v3n8xl8vyzeUOIeZk4mmg8pUzz7gu5n5awPbby7bboqI3cD2zNy9ZmyD00HJc18Y\n",
       "xx7NfKdHOkZnqjmlc+AEmeb7uOs9ZyJi13OLen0tZoI2c5lpPPN67Zy0CLwB+HPg6xz/n70HuAe4\n",
       "HXgpfeV6Z2YeWzO20SIw0Wgcu5ixLT1npBqaKgJTPaBFwLETjG3pOSPV0NSXxbamrnaAEbraAUbo\n",
       "agcY0uI53S1mgjZzmakui4AkLTGng5wO2hRjW3rOSDU0+T0BaVGm+c6JBUQ6MaeDntXVDjBCVzvA\n",
       "CF2lx811LgfWua6OVueUW8xlprosApK0xOwJ2BPY8mNber5Jk/IUUUnSzFkEntXVDjBCVzvACF3t\n",
       "ACN0tQMMaXVOucVcZqrLIiBJS8yegD2BLT+2peebNCl7ApKkmbMIPKurHWCErnaAEbraAUboagcY\n",
       "0uqccou5zFSXRUCSlpg9AXsCSzB2ci09V7Xc/N1B0sT8G9LSiTgd9KyudoARutoBRuhqBxihqx1g\n",
       "SKtzyi3mMlNdFgFJWmL2BOwJOHadsS09V7Xc/J6AJGnmLALP6moHGKGrHWCErnaAEbraAYa0Oqfc\n",
       "Yi4z1WURkKQlZk/AnoBj1xnb0nNVy82egCRp5jb9l8Ui4jzgBdPfUwfsmv5uZqrDTOPoaC1TROzK\n",
       "zK52jrVazGWmujZ9EYAzPwunvhpO++HGxz5xOkwwTJK2iE3fE4g4+yB8+pLJ3gle8iR8/azNOFft\n",
       "2MWMtSegVvi7g6QK+hMHFs/io0WZeWM4Iq6OiEMR8a2I+OCs739+utoBRuhqBxihqx1ghG6O950T\n",
       "XqYdOx8tnv9uprpmWgQi4hTgPwNXAxcD74qIV87yMebnYO0AI5hpPC1mmk5E5KSXk9z1pQv5B2yM\n",
       "mSqa9SeB1wMPZ+bhzHwK+APg7TN+jDk5VjvACGYaT4uZpjW3TxHb5xB2WmaqaNY9gfOARwbWHwUu\n",
       "m/FjSJqDafsfy9LH2Gr7adZFoEIT7emn4ca/hR1Pb3zsw6cfXz48s0Szc7h2gBEO1w4wwuHaATaT\n",
       "lfWvrvIHeFamGTwnK+tfvXX+UNFMTxGNiMuB38jMq8v6HuCZzLxp4DZVzraQpM1uHp8iZl0EtgHf\n",
       "BH4a+CvgHuBdmfngzB5EkjQzM50OysynI+JXgf8BnAL8vgVAktq18G8MS5IakpkLu9B/f+AQ8C3g\n",
       "g3O4/1uBo8B9A9t2APuBh4C7gO0D1+0pWQ4BbxnY/g+B+8p1/2lg+2nAp8r2/wm8bIxMFwAHgPuB\n",
       "bwDvrZ0LOB34Ev0J9g8A/6F2poFxpwD3Ane2kIm+6/z1kumeRjJtBz4NPFiO32UNZPqJso9WL08C\n",
       "720g1x76/3v3AZ8s91E70/vKfX0DeF/t59RMX4TH+M/9MH3X/VT6F6BXzvgx3gj8JM8tAjcDHyjL\n",
       "HwQ+UpYvLhlOLZke5vgno3uA15flPwauLsvvAT5alq8B/mCMTOcAl5blM+l7Jq9sINcLy89t5Yny\n",
       "htqZym3/NfAJ4HONHL9vAzvWbKudaR/w7oHjd1btTGvyPQ/4a/o3QNVylfv9S+C0sv4p4PrKmV5N\n",
       "/8J9Ov1r4n7g5VUzbeTgTnMB/hHwJwPru4Hdc3icFZ5bBA4BO8vyOcChsryHgU8jwJ8AlwPnAg8O\n",
       "bL8W+C8Dt7ls4D/fExPkuwO4qpVcwAuBLwOvqp0JOB/4PHAlxz8J1M70beBH1myrlon+Bf8vR2xv\n",
       "4vlUxrwF+ELtXPTvrr8JvLjc/k7gzZUz/QLwewPr/wb4QM1Mi/yjMqO+SHbeAh53Z2YeLctHgZ1l\n",
       "+SUlw9o8a7c/xvGcz/4bMvNp4MmI2DFukIhYof+k8qXauSLieRFxsDz2gcy8v3Ym4LeA9wPPDGyr\n",
       "nSmBz0fEVyLilxvIdCHwRER8LCK+GhG/GxFnVM601rXAbWW5Wq7M/B7wm8B36M9WPJaZ+2tmop8C\n",
       "emNE7IiIFwJvpX/zUy3TIotALvCxRgfoS2OVHBFxJvBH9HOAP6idKzOfycxL6Z+A/zQirqyZKSJ+\n",
       "Fng8M+/lBN+oqXT8/klm/iTwz4FfiYg3Vs60DXgt/cf91wJ/S/+pumamZ0XE84GfA/5w7XUVnlMv\n",
       "B26knx14CXBmRPxizUyZeQi4iX7e/7/TT/X8cM1tFpppkUXgMfo5wlUX8NxKNi9HI+IcgIg4F3j8\n",
       "BHnOL3keK8trt6+OeWm5r23AWeXdxroi4lT6AvDxzLyjlVwAmfkk8N/om0w1M/1j4G0R8W36d5Fv\n",
       "ioiPV85EZv51+fkE8Fn6349VM9OjwKOZ+eWy/mn6onCkhecTfbH8X2V/Qd199VPAX2Tmd8s74s/Q\n",
       "T0tX3VeZeWtm/lRmXgF8n74ZXG0/LbIIfAX48YhYKe8WrgE+t4DH/Rx9M4jy846B7ddGxPMj4kLg\n",
       "x+nP/jgC/J+IuCwiArgO+K8j7usXgLtP9uDlPn4feCAzb2khV0ScHRHby/IL6OdJ762ZKTM/lJkX\n",
       "ZOaF9NMJf5qZ11XeTy+MiBeV5TPo57rvq7yfjgCPRMRFZdNV9Ge/3Fkr0xrv4vhU0Nr7WnSuQ8Dl\n",
       "EfGCcl9X0Z9NVXVfRcTfLz9fCvw8/VlL9fbTeg2DWV/o3yV8k77DvWcO938b/dzf39HPif0L+ubQ\n",
       "5xl96tWHSpZDwD8b2L566tXDwG8PbD8NuJ3jp16tjJHpDfRz3Ac5fvrc1TVzAa8BvloyfR14fx5v\n",
       "pFXbVwNjr+D42UE199OFZR8dpJ/L3VM7UxlzCX0z/2v0727Pqp2pjDsD+BvgRQPbau+rD3D8FNF9\n",
       "9GfZ1M705yXTQeDK2vvJL4tJ0hJb5HSQJKkxFgFJWmIWAUlaYhYBSVpiFgFJWmIWAUlaYhYBSVpi\n",
       "FgFJWmL/H5jWl+1sWZOIAAAAAElFTkSuQmCC\n"
      ],
      "text/plain": [
       "<matplotlib.figure.Figure at 0x10824f0b8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "police_killings[\"p_income\"][police_killings[\"p_income\"] != \"-\"].astype(float).hist(bins=20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "22348.0"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "police_killings[\"p_income\"][police_killings[\"p_income\"] != \"-\"].astype(float).median()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Income breakdown\n",
    "\n",
    "According to the [Census](https://en.wikipedia.org/wiki/Personal_income_in_the_United_States), median personal income in the US is `28,567`, and our median is `22,348`, which means that shootings tend to happen in less affluent areas.  Our sample size is relatively small, though, so it's hard to make sweeping conclusions."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "state_pop = pd.read_csv(\"state_population.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "counts = police_killings[\"state_fp\"].value_counts()\n",
    "\n",
    "states = pd.DataFrame({\"STATE\": counts.index, \"shootings\": counts})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "states = states.merge(state_pop, on=\"STATE\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATE</th>\n",
       "      <th>shootings</th>\n",
       "      <th>SUMLEV</th>\n",
       "      <th>REGION</th>\n",
       "      <th>DIVISION</th>\n",
       "      <th>NAME</th>\n",
       "      <th>POPESTIMATE2015</th>\n",
       "      <th>POPEST18PLUS2015</th>\n",
       "      <th>PCNT_POPEST18PLUS</th>\n",
       "      <th>rate</th>\n",
       "      <th>pop_millions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Connecticut</td>\n",
       "      <td>3590886</td>\n",
       "      <td>2826827</td>\n",
       "      <td>78.7</td>\n",
       "      <td>0.278483</td>\n",
       "      <td>3.590886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>42</td>\n",
       "      <td>7</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>Pennsylvania</td>\n",
       "      <td>12802503</td>\n",
       "      <td>10112229</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.546768</td>\n",
       "      <td>12.802503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>3123899</td>\n",
       "      <td>2395103</td>\n",
       "      <td>76.7</td>\n",
       "      <td>0.640226</td>\n",
       "      <td>3.123899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>36</td>\n",
       "      <td>13</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>New York</td>\n",
       "      <td>19795791</td>\n",
       "      <td>15584974</td>\n",
       "      <td>78.7</td>\n",
       "      <td>0.656705</td>\n",
       "      <td>19.795791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>6794422</td>\n",
       "      <td>5407335</td>\n",
       "      <td>79.6</td>\n",
       "      <td>0.735898</td>\n",
       "      <td>6.794422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>New Hampshire</td>\n",
       "      <td>1330608</td>\n",
       "      <td>1066610</td>\n",
       "      <td>80.2</td>\n",
       "      <td>0.751536</td>\n",
       "      <td>1.330608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Maine</td>\n",
       "      <td>1329328</td>\n",
       "      <td>1072948</td>\n",
       "      <td>80.7</td>\n",
       "      <td>0.752260</td>\n",
       "      <td>1.329328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>12859995</td>\n",
       "      <td>9901322</td>\n",
       "      <td>77.0</td>\n",
       "      <td>0.855366</td>\n",
       "      <td>12.859995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>39</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Ohio</td>\n",
       "      <td>11613423</td>\n",
       "      <td>8984946</td>\n",
       "      <td>77.4</td>\n",
       "      <td>0.861073</td>\n",
       "      <td>11.613423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>55</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>5771337</td>\n",
       "      <td>4476711</td>\n",
       "      <td>77.6</td>\n",
       "      <td>0.866350</td>\n",
       "      <td>5.771337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>26</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Michigan</td>\n",
       "      <td>9922576</td>\n",
       "      <td>7715272</td>\n",
       "      <td>77.8</td>\n",
       "      <td>0.907023</td>\n",
       "      <td>9.922576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>47</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>6600299</td>\n",
       "      <td>5102688</td>\n",
       "      <td>77.3</td>\n",
       "      <td>0.909050</td>\n",
       "      <td>6.600299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>37</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>North Carolina</td>\n",
       "      <td>10042802</td>\n",
       "      <td>7752234</td>\n",
       "      <td>77.2</td>\n",
       "      <td>0.995738</td>\n",
       "      <td>10.042802</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>32</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Nevada</td>\n",
       "      <td>2890845</td>\n",
       "      <td>2221681</td>\n",
       "      <td>76.9</td>\n",
       "      <td>1.037759</td>\n",
       "      <td>2.890845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>51</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>8382993</td>\n",
       "      <td>6512571</td>\n",
       "      <td>77.7</td>\n",
       "      <td>1.073602</td>\n",
       "      <td>8.382993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>54</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>West Virginia</td>\n",
       "      <td>1844128</td>\n",
       "      <td>1464532</td>\n",
       "      <td>79.4</td>\n",
       "      <td>1.084523</td>\n",
       "      <td>1.844128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>27</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>5489594</td>\n",
       "      <td>4205207</td>\n",
       "      <td>76.6</td>\n",
       "      <td>1.092977</td>\n",
       "      <td>5.489594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>18</td>\n",
       "      <td>8</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>Indiana</td>\n",
       "      <td>6619680</td>\n",
       "      <td>5040224</td>\n",
       "      <td>76.1</td>\n",
       "      <td>1.208518</td>\n",
       "      <td>6.619680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>34</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>8958013</td>\n",
       "      <td>6959192</td>\n",
       "      <td>77.7</td>\n",
       "      <td>1.227951</td>\n",
       "      <td>8.958013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Arkansas</td>\n",
       "      <td>2978204</td>\n",
       "      <td>2272904</td>\n",
       "      <td>76.3</td>\n",
       "      <td>1.343091</td>\n",
       "      <td>2.978204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>29</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>Florida</td>\n",
       "      <td>20271272</td>\n",
       "      <td>16166143</td>\n",
       "      <td>79.7</td>\n",
       "      <td>1.430596</td>\n",
       "      <td>20.271272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>District of Columbia</td>\n",
       "      <td>672228</td>\n",
       "      <td>554121</td>\n",
       "      <td>82.4</td>\n",
       "      <td>1.487591</td>\n",
       "      <td>0.672228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>53</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Washington</td>\n",
       "      <td>7170351</td>\n",
       "      <td>5558509</td>\n",
       "      <td>77.5</td>\n",
       "      <td>1.534095</td>\n",
       "      <td>7.170351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>10214860</td>\n",
       "      <td>7710688</td>\n",
       "      <td>75.5</td>\n",
       "      <td>1.566346</td>\n",
       "      <td>10.214860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>Kentucky</td>\n",
       "      <td>4425092</td>\n",
       "      <td>3413425</td>\n",
       "      <td>77.1</td>\n",
       "      <td>1.581888</td>\n",
       "      <td>4.425092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>29</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>6083672</td>\n",
       "      <td>4692196</td>\n",
       "      <td>77.1</td>\n",
       "      <td>1.643744</td>\n",
       "      <td>6.083672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>Alabama</td>\n",
       "      <td>4858979</td>\n",
       "      <td>3755483</td>\n",
       "      <td>77.3</td>\n",
       "      <td>1.646436</td>\n",
       "      <td>4.858979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>24</td>\n",
       "      <td>10</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>Maryland</td>\n",
       "      <td>6006401</td>\n",
       "      <td>4658175</td>\n",
       "      <td>77.6</td>\n",
       "      <td>1.664891</td>\n",
       "      <td>6.006401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>49</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Utah</td>\n",
       "      <td>2995919</td>\n",
       "      <td>2083423</td>\n",
       "      <td>69.5</td>\n",
       "      <td>1.668937</td>\n",
       "      <td>2.995919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Wyoming</td>\n",
       "      <td>586107</td>\n",
       "      <td>447212</td>\n",
       "      <td>76.3</td>\n",
       "      <td>1.706173</td>\n",
       "      <td>0.586107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>47</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Texas</td>\n",
       "      <td>27469114</td>\n",
       "      <td>20257343</td>\n",
       "      <td>73.7</td>\n",
       "      <td>1.711013</td>\n",
       "      <td>27.469114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>45</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>South Carolina</td>\n",
       "      <td>4896146</td>\n",
       "      <td>3804558</td>\n",
       "      <td>77.7</td>\n",
       "      <td>1.838180</td>\n",
       "      <td>4.896146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>74</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>California</td>\n",
       "      <td>39144818</td>\n",
       "      <td>30023902</td>\n",
       "      <td>76.7</td>\n",
       "      <td>1.890416</td>\n",
       "      <td>39.144818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Montana</td>\n",
       "      <td>1032949</td>\n",
       "      <td>806529</td>\n",
       "      <td>78.1</td>\n",
       "      <td>1.936204</td>\n",
       "      <td>1.032949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>41</td>\n",
       "      <td>8</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>4028977</td>\n",
       "      <td>3166121</td>\n",
       "      <td>78.6</td>\n",
       "      <td>1.985616</td>\n",
       "      <td>4.028977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>28</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>Mississippi</td>\n",
       "      <td>2992333</td>\n",
       "      <td>2265485</td>\n",
       "      <td>75.7</td>\n",
       "      <td>2.005124</td>\n",
       "      <td>2.992333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Kansas</td>\n",
       "      <td>2911641</td>\n",
       "      <td>2192084</td>\n",
       "      <td>75.3</td>\n",
       "      <td>2.060694</td>\n",
       "      <td>2.911641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>Delaware</td>\n",
       "      <td>945934</td>\n",
       "      <td>741548</td>\n",
       "      <td>78.4</td>\n",
       "      <td>2.114312</td>\n",
       "      <td>0.945934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>5456574</td>\n",
       "      <td>4199509</td>\n",
       "      <td>77.0</td>\n",
       "      <td>2.199182</td>\n",
       "      <td>5.456574</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>22</td>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Louisiana</td>\n",
       "      <td>4670724</td>\n",
       "      <td>3555911</td>\n",
       "      <td>76.1</td>\n",
       "      <td>2.355095</td>\n",
       "      <td>4.670724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>35</td>\n",
       "      <td>5</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>New Mexico</td>\n",
       "      <td>2085109</td>\n",
       "      <td>1588201</td>\n",
       "      <td>76.2</td>\n",
       "      <td>2.397956</td>\n",
       "      <td>2.085109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Idaho</td>\n",
       "      <td>1654930</td>\n",
       "      <td>1222093</td>\n",
       "      <td>73.8</td>\n",
       "      <td>2.417021</td>\n",
       "      <td>1.654930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Alaska</td>\n",
       "      <td>738432</td>\n",
       "      <td>552166</td>\n",
       "      <td>74.8</td>\n",
       "      <td>2.708442</td>\n",
       "      <td>0.738432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>15</td>\n",
       "      <td>4</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Hawaii</td>\n",
       "      <td>1431603</td>\n",
       "      <td>1120770</td>\n",
       "      <td>78.3</td>\n",
       "      <td>2.794071</td>\n",
       "      <td>1.431603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>31</td>\n",
       "      <td>6</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>1896190</td>\n",
       "      <td>1425853</td>\n",
       "      <td>75.2</td>\n",
       "      <td>3.164240</td>\n",
       "      <td>1.896190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>25</td>\n",
       "      <td>40</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>6828065</td>\n",
       "      <td>5205215</td>\n",
       "      <td>76.2</td>\n",
       "      <td>3.661359</td>\n",
       "      <td>6.828065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40</td>\n",
       "      <td>22</td>\n",
       "      <td>40</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>Oklahoma</td>\n",
       "      <td>3911338</td>\n",
       "      <td>2950017</td>\n",
       "      <td>75.4</td>\n",
       "      <td>5.624674</td>\n",
       "      <td>3.911338</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    STATE  shootings  SUMLEV REGION DIVISION                  NAME  \\\n",
       "43      9          1      40      1        1           Connecticut   \n",
       "22     42          7      40      1        2          Pennsylvania   \n",
       "38     19          2      40      2        4                  Iowa   \n",
       "6      36         13      40      1        2              New York   \n",
       "29     25          5      40      1        1         Massachusetts   \n",
       "42     33          1      40      1        1         New Hampshire   \n",
       "45     23          1      40      1        1                 Maine   \n",
       "11     17         11      40      2        3              Illinois   \n",
       "12     39         10      40      2        3                  Ohio   \n",
       "31     55          5      40      2        3             Wisconsin   \n",
       "16     26          9      40      2        3              Michigan   \n",
       "28     47          6      40      3        6             Tennessee   \n",
       "15     37         10      40      3        5        North Carolina   \n",
       "36     32          3      40      4        8                Nevada   \n",
       "18     51          9      40      3        5              Virginia   \n",
       "40     54          2      40      3        5         West Virginia   \n",
       "25     27          6      40      2        4             Minnesota   \n",
       "20     18          8      40      2        3               Indiana   \n",
       "8      34         11      40      1        2            New Jersey   \n",
       "35      5          4      40      3        7              Arkansas   \n",
       "2      12         29      40      3        5               Florida   \n",
       "44     11          1      40      3        5  District of Columbia   \n",
       "9      53         11      40      4        9            Washington   \n",
       "5      13         16      40      3        5               Georgia   \n",
       "23     21          7      40      3        6              Kentucky   \n",
       "13     29         10      40      2        4              Missouri   \n",
       "21      1          8      40      3        6               Alabama   \n",
       "14     24         10      40      3        5              Maryland   \n",
       "30     49          5      40      4        8                  Utah   \n",
       "46     56          1      40      4        8               Wyoming   \n",
       "1      48         47      40      3        7                 Texas   \n",
       "17     45          9      40      3        5        South Carolina   \n",
       "0       6         74      40      4        9            California   \n",
       "37     30          2      40      4        8               Montana   \n",
       "19     41          8      40      4        9                Oregon   \n",
       "26     28          6      40      3        6           Mississippi   \n",
       "24     20          6      40      2        4                Kansas   \n",
       "41     10          2      40      3        5              Delaware   \n",
       "7       8         12      40      4        8              Colorado   \n",
       "10     22         11      40      3        7             Louisiana   \n",
       "32     35          5      40      4        8            New Mexico   \n",
       "33     16          4      40      4        8                 Idaho   \n",
       "39      2          2      40      4        9                Alaska   \n",
       "34     15          4      40      4        9                Hawaii   \n",
       "27     31          6      40      2        4              Nebraska   \n",
       "3       4         25      40      4        8               Arizona   \n",
       "4      40         22      40      3        7              Oklahoma   \n",
       "\n",
       "    POPESTIMATE2015  POPEST18PLUS2015  PCNT_POPEST18PLUS      rate  \\\n",
       "43          3590886           2826827               78.7  0.278483   \n",
       "22         12802503          10112229               79.0  0.546768   \n",
       "38          3123899           2395103               76.7  0.640226   \n",
       "6          19795791          15584974               78.7  0.656705   \n",
       "29          6794422           5407335               79.6  0.735898   \n",
       "42          1330608           1066610               80.2  0.751536   \n",
       "45          1329328           1072948               80.7  0.752260   \n",
       "11         12859995           9901322               77.0  0.855366   \n",
       "12         11613423           8984946               77.4  0.861073   \n",
       "31          5771337           4476711               77.6  0.866350   \n",
       "16          9922576           7715272               77.8  0.907023   \n",
       "28          6600299           5102688               77.3  0.909050   \n",
       "15         10042802           7752234               77.2  0.995738   \n",
       "36          2890845           2221681               76.9  1.037759   \n",
       "18          8382993           6512571               77.7  1.073602   \n",
       "40          1844128           1464532               79.4  1.084523   \n",
       "25          5489594           4205207               76.6  1.092977   \n",
       "20          6619680           5040224               76.1  1.208518   \n",
       "8           8958013           6959192               77.7  1.227951   \n",
       "35          2978204           2272904               76.3  1.343091   \n",
       "2          20271272          16166143               79.7  1.430596   \n",
       "44           672228            554121               82.4  1.487591   \n",
       "9           7170351           5558509               77.5  1.534095   \n",
       "5          10214860           7710688               75.5  1.566346   \n",
       "23          4425092           3413425               77.1  1.581888   \n",
       "13          6083672           4692196               77.1  1.643744   \n",
       "21          4858979           3755483               77.3  1.646436   \n",
       "14          6006401           4658175               77.6  1.664891   \n",
       "30          2995919           2083423               69.5  1.668937   \n",
       "46           586107            447212               76.3  1.706173   \n",
       "1          27469114          20257343               73.7  1.711013   \n",
       "17          4896146           3804558               77.7  1.838180   \n",
       "0          39144818          30023902               76.7  1.890416   \n",
       "37          1032949            806529               78.1  1.936204   \n",
       "19          4028977           3166121               78.6  1.985616   \n",
       "26          2992333           2265485               75.7  2.005124   \n",
       "24          2911641           2192084               75.3  2.060694   \n",
       "41           945934            741548               78.4  2.114312   \n",
       "7           5456574           4199509               77.0  2.199182   \n",
       "10          4670724           3555911               76.1  2.355095   \n",
       "32          2085109           1588201               76.2  2.397956   \n",
       "33          1654930           1222093               73.8  2.417021   \n",
       "39           738432            552166               74.8  2.708442   \n",
       "34          1431603           1120770               78.3  2.794071   \n",
       "27          1896190           1425853               75.2  3.164240   \n",
       "3           6828065           5205215               76.2  3.661359   \n",
       "4           3911338           2950017               75.4  5.624674   \n",
       "\n",
       "    pop_millions  \n",
       "43      3.590886  \n",
       "22     12.802503  \n",
       "38      3.123899  \n",
       "6      19.795791  \n",
       "29      6.794422  \n",
       "42      1.330608  \n",
       "45      1.329328  \n",
       "11     12.859995  \n",
       "12     11.613423  \n",
       "31      5.771337  \n",
       "16      9.922576  \n",
       "28      6.600299  \n",
       "15     10.042802  \n",
       "36      2.890845  \n",
       "18      8.382993  \n",
       "40      1.844128  \n",
       "25      5.489594  \n",
       "20      6.619680  \n",
       "8       8.958013  \n",
       "35      2.978204  \n",
       "2      20.271272  \n",
       "44      0.672228  \n",
       "9       7.170351  \n",
       "5      10.214860  \n",
       "23      4.425092  \n",
       "13      6.083672  \n",
       "21      4.858979  \n",
       "14      6.006401  \n",
       "30      2.995919  \n",
       "46      0.586107  \n",
       "1      27.469114  \n",
       "17      4.896146  \n",
       "0      39.144818  \n",
       "37      1.032949  \n",
       "19      4.028977  \n",
       "26      2.992333  \n",
       "24      2.911641  \n",
       "41      0.945934  \n",
       "7       5.456574  \n",
       "10      4.670724  \n",
       "32      2.085109  \n",
       "33      1.654930  \n",
       "39      0.738432  \n",
       "34      1.431603  \n",
       "27      1.896190  \n",
       "3       6.828065  \n",
       "4       3.911338  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "states[\"pop_millions\"] = states[\"POPESTIMATE2015\"] / 1000000\n",
    "states[\"rate\"] = states[\"shootings\"] / states[\"pop_millions\"]\n",
    "\n",
    "states.sort(\"rate\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Killings by state\n",
    "\n",
    "States in the midwest and south seem to have the highest police killing rates, whereas those in the northeast seem to have the lowest."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CA    74\n",
       "TX    46\n",
       "FL    29\n",
       "AZ    25\n",
       "OK    22\n",
       "GA    16\n",
       "NY    14\n",
       "CO    12\n",
       "LA    11\n",
       "WA    11\n",
       "IL    11\n",
       "NJ    11\n",
       "MO    10\n",
       "MD    10\n",
       "OH    10\n",
       "NC    10\n",
       "VA     9\n",
       "SC     9\n",
       "MI     9\n",
       "AL     8\n",
       "OR     8\n",
       "IN     8\n",
       "PA     7\n",
       "KY     7\n",
       "MS     6\n",
       "KS     6\n",
       "NE     6\n",
       "TN     6\n",
       "MN     6\n",
       "UT     5\n",
       "MA     5\n",
       "WI     5\n",
       "NM     5\n",
       "ID     4\n",
       "HI     4\n",
       "AR     4\n",
       "NV     3\n",
       "MT     2\n",
       "AK     2\n",
       "DE     2\n",
       "WV     2\n",
       "IA     2\n",
       "DC     1\n",
       "CT     1\n",
       "NH     1\n",
       "WY     1\n",
       "ME     1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "police_killings[\"state\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/vik/python_envs/dscontent/lib/python3.4/site-packages/IPython/kernel/__main__.py:7: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "/Users/vik/python_envs/dscontent/lib/python3.4/site-packages/IPython/kernel/__main__.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "/Users/vik/python_envs/dscontent/lib/python3.4/site-packages/IPython/kernel/__main__.py:9: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    }
   ],
   "source": [
    "pk = police_killings[\n",
    "    (police_killings[\"share_white\"] != \"-\") & \n",
    "    (police_killings[\"share_black\"] != \"-\") & \n",
    "    (police_killings[\"share_hispanic\"] != \"-\")\n",
    "]\n",
    "\n",
    "pk[\"share_white\"] = pk[\"share_white\"].astype(float)\n",
    "pk[\"share_black\"] = pk[\"share_black\"].astype(float)\n",
    "pk[\"share_hispanic\"] = pk[\"share_hispanic\"].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "lowest_states = [\"CT\", \"PA\", \"IA\", \"NY\", \"MA\", \"NH\", \"ME\", \"IL\", \"OH\", \"WI\"]\n",
    "highest_states = [\"OK\", \"AZ\", \"NE\", \"HI\", \"AK\", \"ID\", \"NM\", \"LA\", \"CO\", \"DE\"]\n",
    "\n",
    "ls = pk[pk[\"state\"].isin(lowest_states)]\n",
    "hs = pk[pk[\"state\"].isin(highest_states)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pop                4201.660714\n",
       "county_income     54830.839286\n",
       "share_white          60.616071\n",
       "share_black          21.257143\n",
       "share_hispanic       12.948214\n",
       "dtype: float64"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns = [\"pop\", \"county_income\", \"share_white\", \"share_black\", \"share_hispanic\"]\n",
    "\n",
    "ls[columns].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pop                4315.750000\n",
       "county_income     48706.967391\n",
       "share_white          55.652174\n",
       "share_black          11.532609\n",
       "share_hispanic       20.693478\n",
       "dtype: float64"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hs[columns].mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## State by state rates\n",
    "\n",
    "It looks like the states with low rates of shootings tend to have a higher proportion of blacks in the population, and a lower proportion of hispanics in the census regions where the shootings occur.  It looks like the income of the counties where the shootings occur is higher.\n",
    "\n",
    "States with high rates of shootings tend to have high hispanic population shares in the counties where shootings occur."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}