{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from assign_unique_ids_functions import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('../input/trr-statuses.csv.gz')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(201401, 14)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Status.Time</th>\n",
       "      <th>Status.Date</th>\n",
       "      <th>Race</th>\n",
       "      <th>Appointed.Date</th>\n",
       "      <th>Star</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Current.Age</th>\n",
       "      <th>TRR.ID</th>\n",
       "      <th>Status</th>\n",
       "      <th>Last.Name</th>\n",
       "      <th>Suffix.Name</th>\n",
       "      <th>First.Name</th>\n",
       "      <th>Middle.Initial</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OFFICER</td>\n",
       "      <td>18:20:00</td>\n",
       "      <td>2004-01-17</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>1994-01-18</td>\n",
       "      <td>3646</td>\n",
       "      <td>MALE</td>\n",
       "      <td>36</td>\n",
       "      <td>4</td>\n",
       "      <td>SUBMITTED</td>\n",
       "      <td>VELAZQUEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANGELO</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SERGEANT</td>\n",
       "      <td>18:25:00</td>\n",
       "      <td>2004-01-17</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>1991-01-30</td>\n",
       "      <td>1652</td>\n",
       "      <td>MALE</td>\n",
       "      <td>37</td>\n",
       "      <td>4</td>\n",
       "      <td>REVIEWED</td>\n",
       "      <td>RIOS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUAN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CAPTAIN</td>\n",
       "      <td>19:28:00</td>\n",
       "      <td>2004-01-17</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>1973-10-22</td>\n",
       "      <td>27</td>\n",
       "      <td>MALE</td>\n",
       "      <td>52</td>\n",
       "      <td>4</td>\n",
       "      <td>APPROVED</td>\n",
       "      <td>ELMER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RICHARD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OFFICER</td>\n",
       "      <td>18:23:00</td>\n",
       "      <td>2004-01-17</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>1985-11-18</td>\n",
       "      <td>17714</td>\n",
       "      <td>MALE</td>\n",
       "      <td>47</td>\n",
       "      <td>5</td>\n",
       "      <td>SUBMITTED</td>\n",
       "      <td>REYES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDRE</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SERGEANT</td>\n",
       "      <td>18:26:00</td>\n",
       "      <td>2004-01-17</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>1991-01-30</td>\n",
       "      <td>1652</td>\n",
       "      <td>MALE</td>\n",
       "      <td>37</td>\n",
       "      <td>5</td>\n",
       "      <td>REVIEWED</td>\n",
       "      <td>RIOS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUAN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Rank Status.Time Status.Date      Race Appointed.Date   Star Gender  \\\n",
       "0   OFFICER    18:20:00  2004-01-17  HISPANIC     1994-01-18   3646   MALE   \n",
       "1  SERGEANT    18:25:00  2004-01-17  HISPANIC     1991-01-30   1652   MALE   \n",
       "2   CAPTAIN    19:28:00  2004-01-17     WHITE     1973-10-22     27   MALE   \n",
       "3   OFFICER    18:23:00  2004-01-17  HISPANIC     1985-11-18  17714   MALE   \n",
       "4  SERGEANT    18:26:00  2004-01-17  HISPANIC     1991-01-30   1652   MALE   \n",
       "\n",
       "   Current.Age  TRR.ID     Status  Last.Name Suffix.Name First.Name  \\\n",
       "0           36       4  SUBMITTED  VELAZQUEZ         NaN     ANGELO   \n",
       "1           37       4   REVIEWED       RIOS         NaN       JUAN   \n",
       "2           52       4   APPROVED      ELMER         NaN    RICHARD   \n",
       "3           47       5  SUBMITTED      REYES         NaN      ANDRE   \n",
       "4           37       5   REVIEWED       RIOS         NaN       JUAN   \n",
       "\n",
       "   Middle.Initial  \n",
       "0             NaN  \n",
       "1             NaN  \n",
       "2             NaN  \n",
       "3             NaN  \n",
       "4             NaN  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df.shape)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "id_cols = [\"First.Name\", \"Last.Name\", \"Middle.Initial\", \"Suffix.Name\",\n",
    "          \"Appointed.Date\", \"Race\", \"Gender\", \"Current.Age\", \"Star\", \"Rank\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dfu = df[id_cols].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(47866, 10)"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfu.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>First.Name</th>\n",
       "      <th>Last.Name</th>\n",
       "      <th>Middle.Initial</th>\n",
       "      <th>Suffix.Name</th>\n",
       "      <th>Appointed.Date</th>\n",
       "      <th>Race</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Current.Age</th>\n",
       "      <th>Star</th>\n",
       "      <th>Rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>140832</th>\n",
       "      <td>AARON</td>\n",
       "      <td>CUNNINGHAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-06-29</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>45</td>\n",
       "      <td>15522</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156619</th>\n",
       "      <td>AARON</td>\n",
       "      <td>CUNNINGHAM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-06-29</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>45</td>\n",
       "      <td>10758</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14430</th>\n",
       "      <td>AARON</td>\n",
       "      <td>PORADZISZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2004-04-26</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>25</td>\n",
       "      <td>16543</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26386</th>\n",
       "      <td>AARON</td>\n",
       "      <td>PORADZISZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2004-04-26</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>25</td>\n",
       "      <td>3770</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44633</th>\n",
       "      <td>ALBERTA</td>\n",
       "      <td>RAYMOND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1978-12-11</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>55</td>\n",
       "      <td>611</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45658</th>\n",
       "      <td>ALBERTA</td>\n",
       "      <td>RAYMOND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1978-12-11</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>55</td>\n",
       "      <td>129</td>\n",
       "      <td>CAPTAIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50505</th>\n",
       "      <td>ALFRED</td>\n",
       "      <td>NAGODE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-12-05</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>42</td>\n",
       "      <td>742</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56730</th>\n",
       "      <td>ALFRED</td>\n",
       "      <td>NAGODE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-12-05</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>42</td>\n",
       "      <td>66</td>\n",
       "      <td>CAPTAIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10811</th>\n",
       "      <td>ALLEN</td>\n",
       "      <td>CAIN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1991-11-18</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>35</td>\n",
       "      <td>1029</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11231</th>\n",
       "      <td>ALLEN</td>\n",
       "      <td>CAIN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1991-11-18</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>35</td>\n",
       "      <td>2263</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136811</th>\n",
       "      <td>ALVIN</td>\n",
       "      <td>JONES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-03-18</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>45</td>\n",
       "      <td>19462</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152417</th>\n",
       "      <td>ALVIN</td>\n",
       "      <td>JONES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-03-18</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>45</td>\n",
       "      <td>1791</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133914</th>\n",
       "      <td>ANDREW</td>\n",
       "      <td>COSTELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995-12-04</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>41</td>\n",
       "      <td>1391</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144633</th>\n",
       "      <td>ANDREW</td>\n",
       "      <td>COSTELLO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995-12-04</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>41</td>\n",
       "      <td>195</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7006</th>\n",
       "      <td>ANDREW</td>\n",
       "      <td>RILEY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002-09-30</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>26</td>\n",
       "      <td>14738</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18975</th>\n",
       "      <td>ANDREW</td>\n",
       "      <td>RILEY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2002-09-30</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>26</td>\n",
       "      <td>6518</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88193</th>\n",
       "      <td>ANGEL</td>\n",
       "      <td>CINTRON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-10-29</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>26</td>\n",
       "      <td>4266</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104556</th>\n",
       "      <td>ANGEL</td>\n",
       "      <td>CINTRON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-10-29</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>26</td>\n",
       "      <td>3955</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47274</th>\n",
       "      <td>ANGEL</td>\n",
       "      <td>NOVALEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000-09-11</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>34</td>\n",
       "      <td>14449</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57943</th>\n",
       "      <td>ANGEL</td>\n",
       "      <td>NOVALEZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000-09-11</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>34</td>\n",
       "      <td>1879</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140292</th>\n",
       "      <td>ANGELO</td>\n",
       "      <td>MONACO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-12-02</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>47</td>\n",
       "      <td>19253</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147210</th>\n",
       "      <td>ANGELO</td>\n",
       "      <td>MONACO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-12-02</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>47</td>\n",
       "      <td>1595</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106215</th>\n",
       "      <td>ANTHONY</td>\n",
       "      <td>ENGLISH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1991-11-18</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>41</td>\n",
       "      <td>2403</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109436</th>\n",
       "      <td>ANTHONY</td>\n",
       "      <td>ENGLISH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1991-11-18</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>41</td>\n",
       "      <td>291</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41245</th>\n",
       "      <td>ARTHUR</td>\n",
       "      <td>PARRA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1977-01-03</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>52</td>\n",
       "      <td>287</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45737</th>\n",
       "      <td>ARTHUR</td>\n",
       "      <td>PARRA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1977-01-03</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>52</td>\n",
       "      <td>67</td>\n",
       "      <td>CAPTAIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186501</th>\n",
       "      <td>ARTURO</td>\n",
       "      <td>VILLANUEVA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-06-04</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>35</td>\n",
       "      <td>19277</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194520</th>\n",
       "      <td>ARTURO</td>\n",
       "      <td>VILLANUEVA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-06-04</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>35</td>\n",
       "      <td>14209</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120414</th>\n",
       "      <td>AZIZ</td>\n",
       "      <td>ABDELMAJEID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-04-28</td>\n",
       "      <td>API</td>\n",
       "      <td>MALE</td>\n",
       "      <td>27</td>\n",
       "      <td>14048</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131577</th>\n",
       "      <td>AZIZ</td>\n",
       "      <td>ABDELMAJEID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-04-28</td>\n",
       "      <td>API</td>\n",
       "      <td>MALE</td>\n",
       "      <td>27</td>\n",
       "      <td>14008</td>\n",
       "      <td>OFFICER</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125971</th>\n",
       "      <td>TRACEY</td>\n",
       "      <td>EDWARDS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-07-30</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>33</td>\n",
       "      <td>4947</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139806</th>\n",
       "      <td>TRACEY</td>\n",
       "      <td>EDWARDS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2007-07-30</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>33</td>\n",
       "      <td>4948</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14712</th>\n",
       "      <td>TREVOR</td>\n",
       "      <td>STOTTS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000-06-19</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>27</td>\n",
       "      <td>14665</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19707</th>\n",
       "      <td>TREVOR</td>\n",
       "      <td>STOTTS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000-06-19</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>27</td>\n",
       "      <td>10792</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135236</th>\n",
       "      <td>VALERY</td>\n",
       "      <td>ROYTMAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1991-05-22</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>49</td>\n",
       "      <td>2150</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143491</th>\n",
       "      <td>VALERY</td>\n",
       "      <td>ROYTMAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1991-05-22</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>49</td>\n",
       "      <td>579</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95211</th>\n",
       "      <td>VICKY</td>\n",
       "      <td>PEREZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-05-19</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>26</td>\n",
       "      <td>11609</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104199</th>\n",
       "      <td>VICKY</td>\n",
       "      <td>PEREZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-05-19</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>26</td>\n",
       "      <td>15656</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31143</th>\n",
       "      <td>VICTOR</td>\n",
       "      <td>GREEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995-07-10</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>37</td>\n",
       "      <td>20484</td>\n",
       "      <td>DETECTIVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34643</th>\n",
       "      <td>VICTOR</td>\n",
       "      <td>GREEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995-07-10</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>37</td>\n",
       "      <td>1558</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12683</th>\n",
       "      <td>VINCENT</td>\n",
       "      <td>AVERY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1990-07-30</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>43</td>\n",
       "      <td>1529</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17330</th>\n",
       "      <td>VINCENT</td>\n",
       "      <td>AVERY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1990-07-30</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>43</td>\n",
       "      <td>1354</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163754</th>\n",
       "      <td>WALTER</td>\n",
       "      <td>HEINICHEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-12-02</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>45</td>\n",
       "      <td>1492</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169798</th>\n",
       "      <td>WALTER</td>\n",
       "      <td>HEINICHEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-12-02</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>45</td>\n",
       "      <td>410</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152033</th>\n",
       "      <td>WAYNE</td>\n",
       "      <td>WIBERG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1994-05-02</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>43</td>\n",
       "      <td>848</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166961</th>\n",
       "      <td>WAYNE</td>\n",
       "      <td>WIBERG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1994-05-02</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>43</td>\n",
       "      <td>514</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1248</th>\n",
       "      <td>WENDY</td>\n",
       "      <td>PACINO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-11-04</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>33</td>\n",
       "      <td>19698</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6120</th>\n",
       "      <td>WENDY</td>\n",
       "      <td>PACINO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-11-04</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>FEMALE</td>\n",
       "      <td>33</td>\n",
       "      <td>13821</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61184</th>\n",
       "      <td>WILFREDO</td>\n",
       "      <td>ROMAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JR</td>\n",
       "      <td>2000-06-19</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>31</td>\n",
       "      <td>18565</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71579</th>\n",
       "      <td>WILFREDO</td>\n",
       "      <td>ROMAN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JR</td>\n",
       "      <td>2000-06-19</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>31</td>\n",
       "      <td>2594</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168988</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>JASKI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-01-25</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>54</td>\n",
       "      <td>1815</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169600</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>JASKI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1988-01-25</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>54</td>\n",
       "      <td>728</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190332</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>MORALES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-10-26</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>43</td>\n",
       "      <td>15318</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201003</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>MORALES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1998-10-26</td>\n",
       "      <td>HISPANIC</td>\n",
       "      <td>MALE</td>\n",
       "      <td>43</td>\n",
       "      <td>1030</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82649</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>PRUENTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995-09-05</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>48</td>\n",
       "      <td>13326</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83807</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>PRUENTE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1995-09-05</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>48</td>\n",
       "      <td>16114</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>559</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>WALLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-06-15</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>55</td>\n",
       "      <td>222</td>\n",
       "      <td>LIEUTENANT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7368</th>\n",
       "      <td>WILLIAM</td>\n",
       "      <td>WALLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1970-06-15</td>\n",
       "      <td>WHITE</td>\n",
       "      <td>MALE</td>\n",
       "      <td>55</td>\n",
       "      <td>22</td>\n",
       "      <td>CAPTAIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80324</th>\n",
       "      <td>WILLIE</td>\n",
       "      <td>WHITEHEAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1989-12-26</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>52</td>\n",
       "      <td>11320</td>\n",
       "      <td>OFFICER</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87174</th>\n",
       "      <td>WILLIE</td>\n",
       "      <td>WHITEHEAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1989-12-26</td>\n",
       "      <td>BLACK</td>\n",
       "      <td>MALE</td>\n",
       "      <td>52</td>\n",
       "      <td>1358</td>\n",
       "      <td>SERGEANT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>674 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       First.Name    Last.Name  Middle.Initial Suffix.Name Appointed.Date  \\\n",
       "140832      AARON   CUNNINGHAM             NaN         NaN     1998-06-29   \n",
       "156619      AARON   CUNNINGHAM             NaN         NaN     1998-06-29   \n",
       "14430       AARON    PORADZISZ             NaN         NaN     2004-04-26   \n",
       "26386       AARON    PORADZISZ             NaN         NaN     2004-04-26   \n",
       "44633     ALBERTA      RAYMOND             NaN         NaN     1978-12-11   \n",
       "45658     ALBERTA      RAYMOND             NaN         NaN     1978-12-11   \n",
       "50505      ALFRED       NAGODE             NaN         NaN     1988-12-05   \n",
       "56730      ALFRED       NAGODE             NaN         NaN     1988-12-05   \n",
       "10811       ALLEN         CAIN             NaN         NaN     1991-11-18   \n",
       "11231       ALLEN         CAIN             NaN         NaN     1991-11-18   \n",
       "136811      ALVIN        JONES             NaN         NaN     1996-03-18   \n",
       "152417      ALVIN        JONES             NaN         NaN     1996-03-18   \n",
       "133914     ANDREW     COSTELLO             NaN         NaN     1995-12-04   \n",
       "144633     ANDREW     COSTELLO             NaN         NaN     1995-12-04   \n",
       "7006       ANDREW        RILEY             NaN         NaN     2002-09-30   \n",
       "18975      ANDREW        RILEY             NaN         NaN     2002-09-30   \n",
       "88193       ANGEL      CINTRON             NaN         NaN     2007-10-29   \n",
       "104556      ANGEL      CINTRON             NaN         NaN     2007-10-29   \n",
       "47274       ANGEL      NOVALEZ             NaN         NaN     2000-09-11   \n",
       "57943       ANGEL      NOVALEZ             NaN         NaN     2000-09-11   \n",
       "140292     ANGELO       MONACO             NaN         NaN     1996-12-02   \n",
       "147210     ANGELO       MONACO             NaN         NaN     1996-12-02   \n",
       "106215    ANTHONY      ENGLISH             NaN         NaN     1991-11-18   \n",
       "109436    ANTHONY      ENGLISH             NaN         NaN     1991-11-18   \n",
       "41245      ARTHUR        PARRA             NaN         NaN     1977-01-03   \n",
       "45737      ARTHUR        PARRA             NaN         NaN     1977-01-03   \n",
       "186501     ARTURO   VILLANUEVA             NaN         NaN     2007-06-04   \n",
       "194520     ARTURO   VILLANUEVA             NaN         NaN     2007-06-04   \n",
       "120414       AZIZ  ABDELMAJEID             NaN         NaN     2008-04-28   \n",
       "131577       AZIZ  ABDELMAJEID             NaN         NaN     2008-04-28   \n",
       "...           ...          ...             ...         ...            ...   \n",
       "125971     TRACEY      EDWARDS             NaN         NaN     2007-07-30   \n",
       "139806     TRACEY      EDWARDS             NaN         NaN     2007-07-30   \n",
       "14712      TREVOR       STOTTS             NaN         NaN     2000-06-19   \n",
       "19707      TREVOR       STOTTS             NaN         NaN     2000-06-19   \n",
       "135236     VALERY      ROYTMAN             NaN         NaN     1991-05-22   \n",
       "143491     VALERY      ROYTMAN             NaN         NaN     1991-05-22   \n",
       "95211       VICKY        PEREZ             NaN         NaN     2008-05-19   \n",
       "104199      VICKY        PEREZ             NaN         NaN     2008-05-19   \n",
       "31143      VICTOR        GREEN             NaN         NaN     1995-07-10   \n",
       "34643      VICTOR        GREEN             NaN         NaN     1995-07-10   \n",
       "12683     VINCENT        AVERY             NaN         NaN     1990-07-30   \n",
       "17330     VINCENT        AVERY             NaN         NaN     1990-07-30   \n",
       "163754     WALTER    HEINICHEN             NaN         NaN     1996-12-02   \n",
       "169798     WALTER    HEINICHEN             NaN         NaN     1996-12-02   \n",
       "152033      WAYNE       WIBERG             NaN         NaN     1994-05-02   \n",
       "166961      WAYNE       WIBERG             NaN         NaN     1994-05-02   \n",
       "1248        WENDY       PACINO             NaN         NaN     1996-11-04   \n",
       "6120        WENDY       PACINO             NaN         NaN     1996-11-04   \n",
       "61184    WILFREDO        ROMAN             NaN          JR     2000-06-19   \n",
       "71579    WILFREDO        ROMAN             NaN          JR     2000-06-19   \n",
       "168988    WILLIAM        JASKI             NaN         NaN     1988-01-25   \n",
       "169600    WILLIAM        JASKI             NaN         NaN     1988-01-25   \n",
       "190332    WILLIAM      MORALES             NaN         NaN     1998-10-26   \n",
       "201003    WILLIAM      MORALES             NaN         NaN     1998-10-26   \n",
       "82649     WILLIAM      PRUENTE             NaN         NaN     1995-09-05   \n",
       "83807     WILLIAM      PRUENTE             NaN         NaN     1995-09-05   \n",
       "559       WILLIAM      WALLACE             NaN         NaN     1970-06-15   \n",
       "7368      WILLIAM      WALLACE             NaN         NaN     1970-06-15   \n",
       "80324      WILLIE    WHITEHEAD             NaN         NaN     1989-12-26   \n",
       "87174      WILLIE    WHITEHEAD             NaN         NaN     1989-12-26   \n",
       "\n",
       "            Race  Gender  Current.Age   Star        Rank  \n",
       "140832     WHITE    MALE           45  15522     OFFICER  \n",
       "156619     WHITE    MALE           45  10758     OFFICER  \n",
       "14430      WHITE    MALE           25  16543     OFFICER  \n",
       "26386      WHITE    MALE           25   3770     OFFICER  \n",
       "44633      BLACK  FEMALE           55    611  LIEUTENANT  \n",
       "45658      BLACK  FEMALE           55    129     CAPTAIN  \n",
       "50505      WHITE    MALE           42    742  LIEUTENANT  \n",
       "56730      WHITE    MALE           42     66     CAPTAIN  \n",
       "10811      WHITE    MALE           35   1029    SERGEANT  \n",
       "11231      WHITE    MALE           35   2263    SERGEANT  \n",
       "136811     BLACK    MALE           45  19462     OFFICER  \n",
       "152417     BLACK    MALE           45   1791    SERGEANT  \n",
       "133914     WHITE    MALE           41   1391    SERGEANT  \n",
       "144633     WHITE    MALE           41    195  LIEUTENANT  \n",
       "7006       WHITE    MALE           26  14738     OFFICER  \n",
       "18975      WHITE    MALE           26   6518     OFFICER  \n",
       "88193   HISPANIC    MALE           26   4266     OFFICER  \n",
       "104556  HISPANIC    MALE           26   3955     OFFICER  \n",
       "47274   HISPANIC    MALE           34  14449     OFFICER  \n",
       "57943   HISPANIC    MALE           34   1879    SERGEANT  \n",
       "140292     WHITE    MALE           47  19253     OFFICER  \n",
       "147210     WHITE    MALE           47   1595    SERGEANT  \n",
       "106215     WHITE    MALE           41   2403    SERGEANT  \n",
       "109436     WHITE    MALE           41    291  LIEUTENANT  \n",
       "41245   HISPANIC    MALE           52    287  LIEUTENANT  \n",
       "45737   HISPANIC    MALE           52     67     CAPTAIN  \n",
       "186501  HISPANIC    MALE           35  19277     OFFICER  \n",
       "194520  HISPANIC    MALE           35  14209     OFFICER  \n",
       "120414       API    MALE           27  14048     OFFICER  \n",
       "131577       API    MALE           27  14008     OFFICER  \n",
       "...          ...     ...          ...    ...         ...  \n",
       "125971     BLACK  FEMALE           33   4947     OFFICER  \n",
       "139806     BLACK  FEMALE           33   4948     OFFICER  \n",
       "14712      WHITE    MALE           27  14665     OFFICER  \n",
       "19707      WHITE    MALE           27  10792     OFFICER  \n",
       "135236     WHITE    MALE           49   2150    SERGEANT  \n",
       "143491     WHITE    MALE           49    579  LIEUTENANT  \n",
       "95211   HISPANIC  FEMALE           26  11609     OFFICER  \n",
       "104199  HISPANIC  FEMALE           26  15656     OFFICER  \n",
       "31143      BLACK    MALE           37  20484   DETECTIVE  \n",
       "34643      BLACK    MALE           37   1558    SERGEANT  \n",
       "12683      BLACK    MALE           43   1529    SERGEANT  \n",
       "17330      BLACK    MALE           43   1354    SERGEANT  \n",
       "163754     WHITE    MALE           45   1492    SERGEANT  \n",
       "169798     WHITE    MALE           45    410  LIEUTENANT  \n",
       "152033     WHITE    MALE           43    848    SERGEANT  \n",
       "166961     WHITE    MALE           43    514  LIEUTENANT  \n",
       "1248       WHITE  FEMALE           33  19698     OFFICER  \n",
       "6120       WHITE  FEMALE           33  13821     OFFICER  \n",
       "61184   HISPANIC    MALE           31  18565     OFFICER  \n",
       "71579   HISPANIC    MALE           31   2594    SERGEANT  \n",
       "168988     WHITE    MALE           54   1815    SERGEANT  \n",
       "169600     WHITE    MALE           54    728  LIEUTENANT  \n",
       "190332  HISPANIC    MALE           43  15318     OFFICER  \n",
       "201003  HISPANIC    MALE           43   1030    SERGEANT  \n",
       "82649      WHITE    MALE           48  13326     OFFICER  \n",
       "83807      WHITE    MALE           48  16114     OFFICER  \n",
       "559        WHITE    MALE           55    222  LIEUTENANT  \n",
       "7368       WHITE    MALE           55     22     CAPTAIN  \n",
       "80324      BLACK    MALE           52  11320     OFFICER  \n",
       "87174      BLACK    MALE           52   1358    SERGEANT  \n",
       "\n",
       "[674 rows x 10 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "id_cols = [\"First.Name\", \"Last.Name\", \"Middle.Initial\", \"Suffix.Name\",\n",
    "          \"Appointed.Date\", \"Race\", \"Gender\", \"Current.Age\"]\n",
    "keep_duplicates(dfu, id_cols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
