INFO474-A3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv \n",
    "import pandas as pd \n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.DataFrame(pd.read_csv('gun_violence_data.csv'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>State</th>\n",
       "      <th>Reliability Score (1-5)</th>\n",
       "      <th>Killed (includes shooter)</th>\n",
       "      <th>Wounded</th>\n",
       "      <th>Total Injured/Killed Victims</th>\n",
       "      <th>Gender of Victims (M/F/Both)</th>\n",
       "      <th>Victim's Affiliation w/ School</th>\n",
       "      <th>Victim's age(s)</th>\n",
       "      <th>Victims Race</th>\n",
       "      <th>...</th>\n",
       "      <th>Caliber of Firearm</th>\n",
       "      <th>Number of Shooters</th>\n",
       "      <th>Shooter Name</th>\n",
       "      <th>Shooter Age</th>\n",
       "      <th>Shooter Gender</th>\n",
       "      <th>Shooter Race</th>\n",
       "      <th>Shooter Ethnicity</th>\n",
       "      <th>Shooter's Affiliation with School</th>\n",
       "      <th>Shooter had an accomplice who did not fire gun (Y/N)</th>\n",
       "      <th>Hostages Taken (Y/N)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1970</td>\n",
       "      <td>DC</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1970</td>\n",
       "      <td>DC</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1970</td>\n",
       "      <td>DC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1970</td>\n",
       "      <td>OH</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Gertis J. Perry</td>\n",
       "      <td>18.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1970</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Male</td>\n",
       "      <td>Multiple Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Obidde Cowart, Lavaughn Hunter</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Other Staff</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1970</td>\n",
       "      <td>AR</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "      <td>Both</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Larry Fitzgerald, Willie Warrior, John H. Mart...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1970</td>\n",
       "      <td>DE</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Black</td>\n",
       "      <td>...</td>\n",
       "      <td>.38 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Carlton E. Thornton</td>\n",
       "      <td>16.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1970</td>\n",
       "      <td>FL</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Theodore Williams</td>\n",
       "      <td>18.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1970</td>\n",
       "      <td>UT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Both</td>\n",
       "      <td>Multiple Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>9mm</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kevin Harold Magee</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1970</td>\n",
       "      <td>TX</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Some Other</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1970</td>\n",
       "      <td>FL</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Parent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Some Other</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Frederick Williams</td>\n",
       "      <td>27.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Black</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1970</td>\n",
       "      <td>TN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Black</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>William Earl Moore</td>\n",
       "      <td>18.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Black</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1970</td>\n",
       "      <td>IA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Herschel Thomas Davis</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1970</td>\n",
       "      <td>MI</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1970</td>\n",
       "      <td>TN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Larry Kilpatrick</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1970</td>\n",
       "      <td>TN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Wendell K. Gross</td>\n",
       "      <td>13.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1970</td>\n",
       "      <td>OH</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.38 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Frank Bonham</td>\n",
       "      <td>13.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1970</td>\n",
       "      <td>IL</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Both</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>UNK</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1970</td>\n",
       "      <td>WI</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>42.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Service Weapon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Police Officer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Police Officer/SRO</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Police Officer/SRO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Officer Involved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1971</td>\n",
       "      <td>PA</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Teacher</td>\n",
       "      <td>56.0</td>\n",
       "      <td>White</td>\n",
       "      <td>...</td>\n",
       "      <td>.45 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Kevin Simmons</td>\n",
       "      <td>14.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Black</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1971</td>\n",
       "      <td>PA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Steven Perrin</td>\n",
       "      <td>14.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1971</td>\n",
       "      <td>TX</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>12 gauge</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Dennis Ray King</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1971</td>\n",
       "      <td>OH</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1971</td>\n",
       "      <td>AZ</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Student</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>13.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1971</td>\n",
       "      <td>PA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Student</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Frank J. Lane</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1971</td>\n",
       "      <td>MI</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Grady Clay</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1971</td>\n",
       "      <td>NY</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Daniel Meldon</td>\n",
       "      <td>13.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1971</td>\n",
       "      <td>PA</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Black</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>James Rock</td>\n",
       "      <td>72.0</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Police Officer/SRO</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1971</td>\n",
       "      <td>TX</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Black</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1971</td>\n",
       "      <td>NY</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unnamed in story</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</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",
       "      <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>938</th>\n",
       "      <td>2008</td>\n",
       "      <td>LA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>939</th>\n",
       "      <td>2008</td>\n",
       "      <td>WA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>...</td>\n",
       "      <td>.25 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Porfito Arnold Chavez</td>\n",
       "      <td>49.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940</th>\n",
       "      <td>2008</td>\n",
       "      <td>WA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Luis F Cosgaya-Alvarez</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Some Other</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Relative</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>941</th>\n",
       "      <td>2008</td>\n",
       "      <td>TN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Jamar Silar</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Some Other</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>942</th>\n",
       "      <td>2008</td>\n",
       "      <td>OH</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>...</td>\n",
       "      <td>.45 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Andrea Lee</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>943</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.38 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Michael Berry</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>944</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Both</td>\n",
       "      <td>Multiple Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>945</th>\n",
       "      <td>2008</td>\n",
       "      <td>MI</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Both</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>William Morton</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Black</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>946</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>14.0</td>\n",
       "      <td>White</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Jeremiah Lasater</td>\n",
       "      <td>14.0</td>\n",
       "      <td>M</td>\n",
       "      <td>White</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>2008</td>\n",
       "      <td>AL</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Parent</td>\n",
       "      <td>43.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Irilmoskomazzerella Washington</td>\n",
       "      <td>50.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Parent</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Teacher</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Pellet</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>10.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>949</th>\n",
       "      <td>2008</td>\n",
       "      <td>MA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Randall Hofland</td>\n",
       "      <td>55.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>950</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>...</td>\n",
       "      <td>BB</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>UNK</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>951</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>UNK</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>952</th>\n",
       "      <td>2008</td>\n",
       "      <td>FL</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Teah Wimberly</td>\n",
       "      <td>15.0</td>\n",
       "      <td>F</td>\n",
       "      <td>Black</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953</th>\n",
       "      <td>2008</td>\n",
       "      <td>CO</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Adrian A. Rodarte</td>\n",
       "      <td>18.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>2008</td>\n",
       "      <td>UT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>15.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.38 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tucker Thayer</td>\n",
       "      <td>15.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Victims</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Minor</td>\n",
       "      <td>13.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>956</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Enrique Garcia</td>\n",
       "      <td>18.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Student</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>957</th>\n",
       "      <td>2008</td>\n",
       "      <td>TX</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>18.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>958</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>19.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>959</th>\n",
       "      <td>2008</td>\n",
       "      <td>CA</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Both</td>\n",
       "      <td>Student</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>.22 caliber</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ezekiel Lopez-Figueroa</td>\n",
       "      <td>17.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>960</th>\n",
       "      <td>2008</td>\n",
       "      <td>MN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Teacher</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Len Jones</td>\n",
       "      <td>34.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Teacher</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>961</th>\n",
       "      <td>2008</td>\n",
       "      <td>NY</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>9mm</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Omar Tomlinson</td>\n",
       "      <td>27.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Black</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>962</th>\n",
       "      <td>2008</td>\n",
       "      <td>NC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>No Relation</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>9mm</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Meredith Kandies</td>\n",
       "      <td>16.0</td>\n",
       "      <td>F</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Y</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>2008</td>\n",
       "      <td>SC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Student</td>\n",
       "      <td>17.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Ranardo Laval Weldon</td>\n",
       "      <td>22.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>2008</td>\n",
       "      <td>FL</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Teacher</td>\n",
       "      <td>47.0</td>\n",
       "      <td>White</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Linda Joy Taylor</td>\n",
       "      <td>47.0</td>\n",
       "      <td>F</td>\n",
       "      <td>White</td>\n",
       "      <td>Not Hispanic or Latino</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>965</th>\n",
       "      <td>2008</td>\n",
       "      <td>PA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>Both</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>966</th>\n",
       "      <td>2008</td>\n",
       "      <td>GA</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Other Staff</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Brittany Lovett</td>\n",
       "      <td>18.0</td>\n",
       "      <td>F</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967</th>\n",
       "      <td>2008</td>\n",
       "      <td>OK</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Male</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>68.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>68.0</td>\n",
       "      <td>M</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>N</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>968 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Date State  Reliability Score (1-5)  Killed (includes shooter)  Wounded  \\\n",
       "0    1970    DC                      3.0                          1      0.0   \n",
       "1    1970    DC                      3.0                          0      1.0   \n",
       "2    1970    DC                      2.0                          0      0.0   \n",
       "3    1970    OH                      2.0                          0      1.0   \n",
       "4    1970    CA                      2.0                          0      2.0   \n",
       "5    1970    AR                      3.0                          1      5.0   \n",
       "6    1970    DE                      3.0                          1      0.0   \n",
       "7    1970    FL                      2.0                          0      1.0   \n",
       "8    1970    UT                      2.0                          0      2.0   \n",
       "9    1970    TX                      2.0                          0      1.0   \n",
       "10   1970    FL                      2.0                          1      0.0   \n",
       "11   1970    TN                      2.0                          1      2.0   \n",
       "12   1970    IA                      2.0                          0      1.0   \n",
       "13   1970    MI                      2.0                          0      4.0   \n",
       "14   1970    TN                      2.0                          1      0.0   \n",
       "15   1970    TN                      2.0                          0      1.0   \n",
       "16   1970    OH                      2.0                          0      1.0   \n",
       "17   1970    IL                      2.0                          0      2.0   \n",
       "18   1970    WI                      3.0                          1      0.0   \n",
       "19   1971    PA                      3.0                          1      0.0   \n",
       "20   1971    PA                      2.0                          0      1.0   \n",
       "21   1971    TX                      3.0                          0      2.0   \n",
       "22   1971    OH                      3.0                          1      0.0   \n",
       "23   1971    AZ                      3.0                          0      1.0   \n",
       "24   1971    PA                      2.0                          0      1.0   \n",
       "25   1971    MI                      2.0                          0      1.0   \n",
       "26   1971    NY                      3.0                          1      0.0   \n",
       "27   1971    PA                      3.0                          0      1.0   \n",
       "28   1971    TX                      3.0                          1      0.0   \n",
       "29   1971    NY                      2.0                          1      0.0   \n",
       "..    ...   ...                      ...                        ...      ...   \n",
       "938  2008    LA                      2.0                          1      0.0   \n",
       "939  2008    WA                      1.0                          0      0.0   \n",
       "940  2008    WA                      2.0                          1      0.0   \n",
       "941  2008    TN                      1.0                          1      0.0   \n",
       "942  2008    OH                      2.0                          0      0.0   \n",
       "943  2008    CA                      2.0                          1      0.0   \n",
       "944  2008    CA                      2.0                          0      2.0   \n",
       "945  2008    MI                      2.0                          1      3.0   \n",
       "946  2008    CA                      2.0                          1      0.0   \n",
       "947  2008    AL                      2.0                          0      1.0   \n",
       "948  2008    CA                      1.0                          0      1.0   \n",
       "949  2008    MA                      2.0                          0      0.0   \n",
       "950  2008    CA                      2.0                          0      0.0   \n",
       "951  2008    CA                      2.0                          1      0.0   \n",
       "952  2008    FL                      2.0                          1      0.0   \n",
       "953  2008    CO                      2.0                          1      0.0   \n",
       "954  2008    UT                      2.0                          1      0.0   \n",
       "955  2008    CA                      2.0                          0      0.0   \n",
       "956  2008    CA                      2.0                          0      1.0   \n",
       "957  2008    TX                      1.0                          0      1.0   \n",
       "958  2008    CA                      1.0                          0      1.0   \n",
       "959  2008    CA                      2.0                          1      1.0   \n",
       "960  2008    MN                      2.0                          1      0.0   \n",
       "961  2008    NY                      2.0                          0      1.0   \n",
       "962  2008    NC                      2.0                          1      0.0   \n",
       "963  2008    SC                      2.0                          0      1.0   \n",
       "964  2008    FL                      3.0                          1      0.0   \n",
       "965  2008    PA                      1.0                          0      2.0   \n",
       "966  2008    GA                      1.0                          0      1.0   \n",
       "967  2008    OK                      1.0                          1      0.0   \n",
       "\n",
       "     Total Injured/Killed Victims Gender of Victims (M/F/Both)  \\\n",
       "0                               1                         Male   \n",
       "1                               1                         Male   \n",
       "2                               0                   No Victims   \n",
       "3                               1                         Male   \n",
       "4                               2                         Male   \n",
       "5                               6                         Both   \n",
       "6                               1                         Male   \n",
       "7                               1                         Male   \n",
       "8                               2                         Both   \n",
       "9                               1                         Male   \n",
       "10                              1                         Male   \n",
       "11                              3                         Male   \n",
       "12                              1                       Female   \n",
       "13                              4                         Male   \n",
       "14                              1                         Male   \n",
       "15                              1                         Male   \n",
       "16                              1                         Male   \n",
       "17                              2                         Both   \n",
       "18                              1                         Male   \n",
       "19                              1                         Male   \n",
       "20                              1                         Male   \n",
       "21                              2                      Unknown   \n",
       "22                              1                         Male   \n",
       "23                              1                       Female   \n",
       "24                              1                       Female   \n",
       "25                              1                         Male   \n",
       "26                              1                         Male   \n",
       "27                              1                         Male   \n",
       "28                              1                         Male   \n",
       "29                              1                         Male   \n",
       "..                            ...                          ...   \n",
       "938                             1                         Male   \n",
       "939                             0                   No Victims   \n",
       "940                             1                         Male   \n",
       "941                             1                         Male   \n",
       "942                             0                   No Victims   \n",
       "943                             1                         Male   \n",
       "944                             2                         Both   \n",
       "945                             4                         Both   \n",
       "946                             1                         Male   \n",
       "947                             1                       Female   \n",
       "948                             1                       Female   \n",
       "949                             0                   No Victims   \n",
       "950                             0                   No Victims   \n",
       "951                             1                         Male   \n",
       "952                             1                       Female   \n",
       "953                             1                         Male   \n",
       "954                             1                         Male   \n",
       "955                             0                   No Victims   \n",
       "956                             1                         Male   \n",
       "957                             1                         Male   \n",
       "958                             1                         Male   \n",
       "959                             2                         Both   \n",
       "960                             1                         Male   \n",
       "961                             1                         Male   \n",
       "962                             1                         Male   \n",
       "963                             1                         Male   \n",
       "964                             1                       Female   \n",
       "965                             2                         Both   \n",
       "966                             1                      Unknown   \n",
       "967                             1                         Male   \n",
       "\n",
       "    Victim's Affiliation w/ School  Victim's age(s)  Victims Race  \\\n",
       "0                          Student              15.0      Unknown   \n",
       "1                          Student               NaN      Unknown   \n",
       "2                       No Victims               NaN   No Victims   \n",
       "3                          Student              18.0      Unknown   \n",
       "4                 Multiple Victims               NaN      Unknown   \n",
       "5                          Student               NaN      Unknown   \n",
       "6                          Student              18.0        Black   \n",
       "7                          Student              19.0      Unknown   \n",
       "8                 Multiple Victims               NaN      Unknown   \n",
       "9                          Student              15.0   Some Other   \n",
       "10                          Parent               NaN   Some Other   \n",
       "11                         Student               NaN        Black   \n",
       "12                         Student               NaN      Unknown   \n",
       "13                         Student               NaN      Unknown   \n",
       "14                         Student               NaN      Unknown   \n",
       "15                         Student              15.0      Unknown   \n",
       "16                         Student              15.0      Unknown   \n",
       "17                         Student               NaN      Unknown   \n",
       "18                     No Relation              42.0      Unknown   \n",
       "19                         Teacher              56.0        White   \n",
       "20                         Student              13.0      Unknown   \n",
       "21                         Student               NaN      Unknown   \n",
       "22                         Student              15.0      Unknown   \n",
       "23                         Student              14.0      Unknown   \n",
       "24                         Student              18.0      Unknown   \n",
       "25                         Student              16.0      Unknown   \n",
       "26                         Student              13.0      Unknown   \n",
       "27                         Student              18.0        Black   \n",
       "28                         Student              16.0        Black   \n",
       "29                         Student              23.0      Unknown   \n",
       "..                             ...               ...          ...   \n",
       "938                        Student               NaN      Unknown   \n",
       "939                     No Victims               NaN   No Victims   \n",
       "940                        Unknown              26.0      Unknown   \n",
       "941                        Student              15.0      Unknown   \n",
       "942                     No Victims               NaN   No Victims   \n",
       "943                        Student              17.0      Unknown   \n",
       "944               Multiple Victims               NaN      Unknown   \n",
       "945                        Student               NaN      Unknown   \n",
       "946                        Student              14.0        White   \n",
       "947                         Parent              43.0      Unknown   \n",
       "948                        Teacher               NaN      Unknown   \n",
       "949                     No Victims               NaN   No Victims   \n",
       "950                     No Victims               NaN   No Victims   \n",
       "951                        Unknown              18.0          NaN   \n",
       "952                        Student              15.0      Unknown   \n",
       "953                    No Relation              23.0      Unknown   \n",
       "954                        Student              15.0      Unknown   \n",
       "955                     No Victims               NaN   No Victims   \n",
       "956                        Student              19.0      Unknown   \n",
       "957                        Unknown               NaN      Unknown   \n",
       "958                    No Relation              19.0      Unknown   \n",
       "959                        Student               NaN      Unknown   \n",
       "960                        Teacher              34.0      Unknown   \n",
       "961                        Student              14.0      Unknown   \n",
       "962                    No Relation              16.0      Unknown   \n",
       "963                        Student              17.0      Unknown   \n",
       "964                        Teacher              47.0        White   \n",
       "965                        Unknown               NaN      Unknown   \n",
       "966                    Other Staff               NaN      Unknown   \n",
       "967                        Unknown              68.0      Unknown   \n",
       "\n",
       "            ...          Caliber of Firearm Number of Shooters  \\\n",
       "0           ...                     Unknown                1.0   \n",
       "1           ...                 .22 caliber                1.0   \n",
       "2           ...                     Unknown                1.0   \n",
       "3           ...                     Unknown                1.0   \n",
       "4           ...                     Unknown                2.0   \n",
       "5           ...                     Unknown                8.0   \n",
       "6           ...                 .38 caliber                1.0   \n",
       "7           ...                 .22 caliber                1.0   \n",
       "8           ...                         9mm                1.0   \n",
       "9           ...                     Unknown                2.0   \n",
       "10          ...                     Unknown                1.0   \n",
       "11          ...                     Unknown                1.0   \n",
       "12          ...                     Unknown                1.0   \n",
       "13          ...                     Unknown                NaN   \n",
       "14          ...                     Unknown                1.0   \n",
       "15          ...                     Unknown                1.0   \n",
       "16          ...                 .38 caliber                1.0   \n",
       "17          ...                     Unknown                1.0   \n",
       "18          ...              Service Weapon                NaN   \n",
       "19          ...                 .45 caliber                1.0   \n",
       "20          ...                     Unknown                1.0   \n",
       "21          ...                    12 gauge                1.0   \n",
       "22          ...                 .22 caliber                1.0   \n",
       "23          ...                 .22 caliber                1.0   \n",
       "24          ...                     Unknown                1.0   \n",
       "25          ...                     Unknown                1.0   \n",
       "26          ...                 .22 caliber                1.0   \n",
       "27          ...                     Unknown                1.0   \n",
       "28          ...                 .22 caliber                1.0   \n",
       "29          ...                     Unknown                1.0   \n",
       "..          ...                         ...                ...   \n",
       "938         ...                     Unknown                1.0   \n",
       "939         ...                 .25 caliber                1.0   \n",
       "940         ...                     Unknown                1.0   \n",
       "941         ...                 .22 caliber                1.0   \n",
       "942         ...                 .45 caliber                1.0   \n",
       "943         ...                 .38 caliber                1.0   \n",
       "944         ...                     Unknown                NaN   \n",
       "945         ...                     Unknown                1.0   \n",
       "946         ...                     Unknown                1.0   \n",
       "947         ...                     Unknown                1.0   \n",
       "948         ...                      Pellet                1.0   \n",
       "949         ...                     Unknown                1.0   \n",
       "950         ...                          BB                NaN   \n",
       "951         ...                     Unknown                1.0   \n",
       "952         ...                 .22 caliber                1.0   \n",
       "953         ...                     Unknown                1.0   \n",
       "954         ...                 .38 caliber                1.0   \n",
       "955         ...                     Unknown                1.0   \n",
       "956         ...                     Unknown                1.0   \n",
       "957         ...                     Unknown                1.0   \n",
       "958         ...                     Unknown                1.0   \n",
       "959         ...                 .22 caliber                1.0   \n",
       "960         ...                     Unknown                1.0   \n",
       "961         ...                         9mm                1.0   \n",
       "962         ...                         9mm                1.0   \n",
       "963         ...                     Unknown                1.0   \n",
       "964         ...                     Unknown                1.0   \n",
       "965         ...                     Unknown                1.0   \n",
       "966         ...                     Unknown                1.0   \n",
       "967         ...                     Unknown                1.0   \n",
       "\n",
       "                                          Shooter Name Shooter Age  \\\n",
       "0                                                Minor        15.0   \n",
       "1                                                Minor         NaN   \n",
       "2                                              Unknown         NaN   \n",
       "3                                      Gertis J. Perry        18.0   \n",
       "4                       Obidde Cowart, Lavaughn Hunter         NaN   \n",
       "5    Larry Fitzgerald, Willie Warrior, John H. Mart...         NaN   \n",
       "6                                  Carlton E. Thornton        16.0   \n",
       "7                                    Theodore Williams        18.0   \n",
       "8                                   Kevin Harold Magee        15.0   \n",
       "9                                                Minor         NaN   \n",
       "10                                  Frederick Williams        27.0   \n",
       "11                                  William Earl Moore        18.0   \n",
       "12                               Herschel Thomas Davis        17.0   \n",
       "13                                             Unknown         NaN   \n",
       "14                                    Larry Kilpatrick        17.0   \n",
       "15                                    Wendell K. Gross        13.0   \n",
       "16                                        Frank Bonham        13.0   \n",
       "17                                             Unknown        15.0   \n",
       "18                                      Police Officer         NaN   \n",
       "19                                       Kevin Simmons        14.0   \n",
       "20                                       Steven Perrin        14.0   \n",
       "21                                     Dennis Ray King        17.0   \n",
       "22                                               Minor         NaN   \n",
       "23                                               Minor        13.0   \n",
       "24                                       Frank J. Lane        17.0   \n",
       "25                                          Grady Clay        17.0   \n",
       "26                                       Daniel Meldon        13.0   \n",
       "27                                          James Rock        72.0   \n",
       "28                                               Minor        15.0   \n",
       "29                                    Unnamed in story         NaN   \n",
       "..                                                 ...         ...   \n",
       "938                                            Unknown         NaN   \n",
       "939                              Porfito Arnold Chavez        49.0   \n",
       "940                             Luis F Cosgaya-Alvarez        17.0   \n",
       "941                                        Jamar Silar        15.0   \n",
       "942                                         Andrea Lee        15.0   \n",
       "943                                      Michael Berry        17.0   \n",
       "944                                            Unknown         NaN   \n",
       "945                                     William Morton        15.0   \n",
       "946                                   Jeremiah Lasater        14.0   \n",
       "947                     Irilmoskomazzerella Washington        50.0   \n",
       "948                                              Minor        10.0   \n",
       "949                                    Randall Hofland        55.0   \n",
       "950                                            Unknown         NaN   \n",
       "951                                            Unknown         NaN   \n",
       "952                                      Teah Wimberly        15.0   \n",
       "953                                  Adrian A. Rodarte        18.0   \n",
       "954                                      Tucker Thayer        15.0   \n",
       "955                                              Minor        13.0   \n",
       "956                                     Enrique Garcia        18.0   \n",
       "957                                            Unknown        18.0   \n",
       "958                                            Unknown         NaN   \n",
       "959                             Ezekiel Lopez-Figueroa        17.0   \n",
       "960                                          Len Jones        34.0   \n",
       "961                                     Omar Tomlinson        27.0   \n",
       "962                                   Meredith Kandies        16.0   \n",
       "963                               Ranardo Laval Weldon        22.0   \n",
       "964                                   Linda Joy Taylor        47.0   \n",
       "965                                            Unknown         NaN   \n",
       "966                                    Brittany Lovett        18.0   \n",
       "967                                            Unknown        68.0   \n",
       "\n",
       "         Shooter Gender Shooter Race       Shooter Ethnicity  \\\n",
       "0                     M      Unknown                 Unknown   \n",
       "1                     M      Unknown                 Unknown   \n",
       "2                     M      Unknown                 Unknown   \n",
       "3                     M      Unknown  Not Hispanic or Latino   \n",
       "4                     M      Unknown  Not Hispanic or Latino   \n",
       "5                     M      Unknown                 Unknown   \n",
       "6                     M      Unknown  Not Hispanic or Latino   \n",
       "7                     M      Unknown  Not Hispanic or Latino   \n",
       "8                     M        White  Not Hispanic or Latino   \n",
       "9                     M      Unknown                 Unknown   \n",
       "10                    M        Black  Not Hispanic or Latino   \n",
       "11                    M        Black  Not Hispanic or Latino   \n",
       "12                    M      Unknown                 Unknown   \n",
       "13                    M      Unknown                 Unknown   \n",
       "14                    M      Unknown                 Unknown   \n",
       "15                    M      Unknown                 Unknown   \n",
       "16                    M      Unknown                 Unknown   \n",
       "17                    M      Unknown                 Unknown   \n",
       "18   Police Officer/SRO      Unknown                 Unknown   \n",
       "19                    M        Black  Not Hispanic or Latino   \n",
       "20                    M      Unknown                 Unknown   \n",
       "21                    M      Unknown                 Unknown   \n",
       "22                    M      Unknown                 Unknown   \n",
       "23                    M      Unknown                 Unknown   \n",
       "24                    M      Unknown                 Unknown   \n",
       "25                    M      Unknown                 Unknown   \n",
       "26                    M      Unknown                 Unknown   \n",
       "27                    M        White  Not Hispanic or Latino   \n",
       "28                    M        White  Not Hispanic or Latino   \n",
       "29              Unknown      Unknown                 Unknown   \n",
       "..                  ...          ...                     ...   \n",
       "938             Unknown      Unknown                     NaN   \n",
       "939                   M      Unknown                     NaN   \n",
       "940                   M   Some Other                     NaN   \n",
       "941                   M   Some Other                     NaN   \n",
       "942                   M      Unknown                     NaN   \n",
       "943                   M      Unknown                     NaN   \n",
       "944                   M      Unknown                     NaN   \n",
       "945                   M        Black                     NaN   \n",
       "946                   M        White  Not Hispanic or Latino   \n",
       "947                   M      Unknown                     NaN   \n",
       "948                   M      Unknown                     NaN   \n",
       "949                   M      Unknown                     NaN   \n",
       "950             Unknown      Unknown                     NaN   \n",
       "951             Unknown      Unknown                     NaN   \n",
       "952                   F        Black  Not Hispanic or Latino   \n",
       "953                   M      Unknown                     NaN   \n",
       "954                   M      Unknown                     NaN   \n",
       "955                   M      Unknown                     NaN   \n",
       "956                   M      Unknown                     NaN   \n",
       "957                   M      Unknown                     NaN   \n",
       "958                   M      Unknown                     NaN   \n",
       "959                   M      Unknown                     NaN   \n",
       "960                   M      Unknown                     NaN   \n",
       "961                   M        Black                     NaN   \n",
       "962                   F      Unknown                     NaN   \n",
       "963                   M      Unknown                     NaN   \n",
       "964                   F        White  Not Hispanic or Latino   \n",
       "965             Unknown      Unknown                     NaN   \n",
       "966                   F      Unknown                     NaN   \n",
       "967                   M      Unknown                     NaN   \n",
       "\n",
       "    Shooter's Affiliation with School  \\\n",
       "0                             Student   \n",
       "1                             Student   \n",
       "2                             Student   \n",
       "3                             Student   \n",
       "4                         Other Staff   \n",
       "5                         No Relation   \n",
       "6                             Student   \n",
       "7                             Student   \n",
       "8                             Student   \n",
       "9                             Student   \n",
       "10                        No Relation   \n",
       "11                            Student   \n",
       "12                            Student   \n",
       "13                            Student   \n",
       "14                            Student   \n",
       "15                            Student   \n",
       "16                            Student   \n",
       "17                            Student   \n",
       "18                 Police Officer/SRO   \n",
       "19                            Student   \n",
       "20                            Student   \n",
       "21                            Student   \n",
       "22                            Student   \n",
       "23                            Student   \n",
       "24                            Student   \n",
       "25                            Student   \n",
       "26                            Student   \n",
       "27                 Police Officer/SRO   \n",
       "28                            Student   \n",
       "29                            Student   \n",
       "..                                ...   \n",
       "938                           Student   \n",
       "939                       No Relation   \n",
       "940                          Relative   \n",
       "941                           Student   \n",
       "942                           Student   \n",
       "943                           Student   \n",
       "944                           Unknown   \n",
       "945                           Student   \n",
       "946                           Student   \n",
       "947                            Parent   \n",
       "948                           Student   \n",
       "949                       No Relation   \n",
       "950                           Unknown   \n",
       "951                           Unknown   \n",
       "952                           Student   \n",
       "953                           Student   \n",
       "954                           Student   \n",
       "955                           Student   \n",
       "956                           Student   \n",
       "957                           Unknown   \n",
       "958                       No Relation   \n",
       "959                           Unknown   \n",
       "960                           Teacher   \n",
       "961                           Unknown   \n",
       "962                           Unknown   \n",
       "963                           Unknown   \n",
       "964                           Unknown   \n",
       "965                           Unknown   \n",
       "966                           Unknown   \n",
       "967                           Unknown   \n",
       "\n",
       "    Shooter had an accomplice who did not fire gun (Y/N) Hostages Taken (Y/N)  \n",
       "0                                                    Y                      N  \n",
       "1                                                    N                      N  \n",
       "2                                                    Y                      N  \n",
       "3                                                    N                      N  \n",
       "4                                                    Y                      N  \n",
       "5                                                    Y                      N  \n",
       "6                                                    N                      N  \n",
       "7                                                    N                      N  \n",
       "8                                                    N                      N  \n",
       "9                                                    Y                      N  \n",
       "10                                                 NaN                      N  \n",
       "11                                                 NaN                      N  \n",
       "12                                                 NaN                      N  \n",
       "13                                                   Y                      N  \n",
       "14                                                   N                      N  \n",
       "15                                                 NaN                      N  \n",
       "16                                                   N                      N  \n",
       "17                                                 UNK                      N  \n",
       "18                                                 NaN       Officer Involved  \n",
       "19                                                   N                      N  \n",
       "20                                                   N                      N  \n",
       "21                                                   Y                      N  \n",
       "22                                                   Y                      N  \n",
       "23                                                   N                      N  \n",
       "24                                                   N                      N  \n",
       "25                                                   N                      N  \n",
       "26                                                   N                      N  \n",
       "27                                                   N                      N  \n",
       "28                                                   N                      N  \n",
       "29                                                   N                      N  \n",
       "..                                                 ...                    ...  \n",
       "938                                                  N                      N  \n",
       "939                                                  N                      N  \n",
       "940                                                  Y                      N  \n",
       "941                                                  N                      N  \n",
       "942                                                  N                      N  \n",
       "943                                                  N                      N  \n",
       "944                                                  Y                      N  \n",
       "945                                                  Y                      N  \n",
       "946                                                  N                      N  \n",
       "947                                                  N                      N  \n",
       "948                                                  N                      N  \n",
       "949                                                  N                      N  \n",
       "950                                                UNK                      N  \n",
       "951                                                UNK                      N  \n",
       "952                                                  N                      N  \n",
       "953                                                  N                      N  \n",
       "954                                                  N                      N  \n",
       "955                                            Unknown                      N  \n",
       "956                                                  N                      N  \n",
       "957                                            Unknown                      N  \n",
       "958                                                  Y                      N  \n",
       "959                                                  N                      N  \n",
       "960                                                  N                      N  \n",
       "961                                                  N                      N  \n",
       "962                                                  Y                      N  \n",
       "963                                            Unknown                      N  \n",
       "964                                                  N                      N  \n",
       "965                                            Unknown                      N  \n",
       "966                                                  N                      N  \n",
       "967                                                  N                      N  \n",
       "\n",
       "[968 rows x 38 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Date'] = pd.to_datetime(data['Date']).dt.year\n",
    "data[(data.Date <= 2008) & (data.Date <= 2018)]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_year = data[(data['Date'] == 1998)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "years = np.array(range(2008,2019))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2008 36\n",
      "2008 23.857142857142858\n",
      "Counts 1330\n",
      "2009 38\n",
      "2009 17.238095238095237\n",
      "Counts 1178\n",
      "2010 19\n",
      "2010 25.0\n",
      "Counts 570\n",
      "2011 23\n",
      "2011 19.545454545454547\n",
      "Counts 494\n",
      "2012 49\n",
      "2012 18.6\n",
      "Counts 684\n",
      "2013 44\n",
      "2013 21.444444444444443\n",
      "Counts 1254\n",
      "2014 52\n",
      "2014 21.70967741935484\n",
      "Counts 1672\n",
      "2015 40\n",
      "2015 23.833333333333332\n",
      "Counts 1254\n",
      "2016 63\n",
      "2016 20.129032258064516\n",
      "Counts 1710\n",
      "2017 78\n",
      "2017 24.714285714285715\n",
      "Counts 1672\n",
      "2018 165\n",
      "2018 20.166666666666668\n",
      "Counts 3686\n"
     ]
    }
   ],
   "source": [
    "for year in years: \n",
    "    yearData = data[(data['Date'] == year)]\n",
    "    totVictims = yearData['Total Injured/Killed Victims'].sum()\n",
    "    print(year, totVictims)\n",
    "    print(year, yearData['Shooter Age'].mean())\n",
    "    print(\"Counts\", yearData.size)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "metadata": {},
   "outputs": [],
   "source": [
    "totVictims = []\n",
    "shooterAvgAge = []\n",
    "totShootings = []\n",
    "\n",
    "for year in years: \n",
    "    yearData = data[(data['Date'] == year)]\n",
    "    totVictims.append(yearData['Total Injured/Killed Victims'].sum())\n",
    "    shooterAvgAge.append(round(yearData['Shooter Age'].mean()))\n",
    "    totShootings.append(yearData.size)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleanData = {'Year' : years, 'Total Shootings': totShootings, 'Total Victims': totVictims, 'Shooter Avg Age': shooterAvgAge}\n",
    "cleanDf = pd.DataFrame(data=cleanData)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Year,Total Shootings,Total Victims,Shooter Avg Age\\n2008,1330,36,24\\n2009,1178,38,17\\n2010,570,19,25\\n2011,494,23,20\\n2012,684,49,19\\n2013,1254,44,21\\n2014,1672,52,22\\n2015,1254,40,24\\n2016,1710,63,20\\n2017,1672,78,25\\n2018,3686,165,20\\n'"
      ]
     },
     "execution_count": 162,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleanDf.to_csv(index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [],
   "source": [
    "cleanDf.to_csv('clean_data.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}