SF_Salaries_Exercise.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "___\n",
    "\n",
    "<a href='http://www.pieriandata.com'> <img src='../../Pierian_Data_Logo.png' /></a>\n",
    "___"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# SF Salaries Exercise \n",
    "\n",
    "Welcome to a quick exercise for you to practice your pandas skills! We will be using the [SF Salaries Dataset](https://www.kaggle.com/kaggle/sf-salaries) from Kaggle! Just follow along and complete the tasks outlined in bold below. The tasks will get harder and harder as you go along."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** Import pandas as pd.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** Read Salaries.csv as a dataframe called sal.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('Salaries.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** Check the head of the DataFrame. **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "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>Id</th>\n",
       "      <th>EmployeeName</th>\n",
       "      <th>JobTitle</th>\n",
       "      <th>BasePay</th>\n",
       "      <th>OvertimePay</th>\n",
       "      <th>OtherPay</th>\n",
       "      <th>Benefits</th>\n",
       "      <th>TotalPay</th>\n",
       "      <th>TotalPayBenefits</th>\n",
       "      <th>Year</th>\n",
       "      <th>Notes</th>\n",
       "      <th>Agency</th>\n",
       "      <th>Status</th>\n",
       "      <th>totallen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>NATHANIEL FORD</td>\n",
       "      <td>GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY</td>\n",
       "      <td>167411.18</td>\n",
       "      <td>0.00</td>\n",
       "      <td>400184.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>567595.43</td>\n",
       "      <td>567595.43</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>GARY JIMENEZ</td>\n",
       "      <td>CAPTAIN III (POLICE DEPARTMENT)</td>\n",
       "      <td>155966.02</td>\n",
       "      <td>245131.88</td>\n",
       "      <td>137811.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>538909.28</td>\n",
       "      <td>538909.28</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>ALBERT PARDINI</td>\n",
       "      <td>CAPTAIN III (POLICE DEPARTMENT)</td>\n",
       "      <td>212739.13</td>\n",
       "      <td>106088.18</td>\n",
       "      <td>16452.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>335279.91</td>\n",
       "      <td>335279.91</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>CHRISTOPHER CHONG</td>\n",
       "      <td>WIRE ROPE CABLE MAINTENANCE MECHANIC</td>\n",
       "      <td>77916.00</td>\n",
       "      <td>56120.71</td>\n",
       "      <td>198306.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>332343.61</td>\n",
       "      <td>332343.61</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>PATRICK GARDNER</td>\n",
       "      <td>DEPUTY CHIEF OF DEPARTMENT,(FIRE DEPARTMENT)</td>\n",
       "      <td>134401.60</td>\n",
       "      <td>9737.00</td>\n",
       "      <td>182234.59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>326373.19</td>\n",
       "      <td>326373.19</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>DAVID SULLIVAN</td>\n",
       "      <td>ASSISTANT DEPUTY CHIEF II</td>\n",
       "      <td>118602.00</td>\n",
       "      <td>8601.00</td>\n",
       "      <td>189082.74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>316285.74</td>\n",
       "      <td>316285.74</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>ALSON LEE</td>\n",
       "      <td>BATTALION CHIEF, (FIRE DEPARTMENT)</td>\n",
       "      <td>92492.01</td>\n",
       "      <td>89062.90</td>\n",
       "      <td>134426.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>315981.05</td>\n",
       "      <td>315981.05</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>DAVID KUSHNER</td>\n",
       "      <td>DEPUTY DIRECTOR OF INVESTMENTS</td>\n",
       "      <td>256576.96</td>\n",
       "      <td>0.00</td>\n",
       "      <td>51322.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>307899.46</td>\n",
       "      <td>307899.46</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>MICHAEL MORRIS</td>\n",
       "      <td>BATTALION CHIEF, (FIRE DEPARTMENT)</td>\n",
       "      <td>176932.64</td>\n",
       "      <td>86362.68</td>\n",
       "      <td>40132.23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>303427.55</td>\n",
       "      <td>303427.55</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>JOANNE HAYES-WHITE</td>\n",
       "      <td>CHIEF OF DEPARTMENT, (FIRE DEPARTMENT)</td>\n",
       "      <td>285262.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17115.73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>302377.73</td>\n",
       "      <td>302377.73</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>ARTHUR KENNEY</td>\n",
       "      <td>ASSISTANT CHIEF OF DEPARTMENT, (FIRE DEPARTMENT)</td>\n",
       "      <td>194999.39</td>\n",
       "      <td>71344.88</td>\n",
       "      <td>33149.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>299494.17</td>\n",
       "      <td>299494.17</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>PATRICIA JACKSON</td>\n",
       "      <td>CAPTAIN III (POLICE DEPARTMENT)</td>\n",
       "      <td>99722.00</td>\n",
       "      <td>87082.62</td>\n",
       "      <td>110804.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>297608.92</td>\n",
       "      <td>297608.92</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>EDWARD HARRINGTON</td>\n",
       "      <td>EXECUTIVE CONTRACT EMPLOYEE</td>\n",
       "      <td>294580.02</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>294580.02</td>\n",
       "      <td>294580.02</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>JOHN MARTIN</td>\n",
       "      <td>DEPARTMENT HEAD V</td>\n",
       "      <td>271329.03</td>\n",
       "      <td>0.00</td>\n",
       "      <td>21342.59</td>\n",
       "      <td>NaN</td>\n",
       "      <td>292671.62</td>\n",
       "      <td>292671.62</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>DAVID FRANKLIN</td>\n",
       "      <td>BATTALION CHIEF, (FIRE DEPARTMENT)</td>\n",
       "      <td>174872.64</td>\n",
       "      <td>74050.30</td>\n",
       "      <td>37424.11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>286347.05</td>\n",
       "      <td>286347.05</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>RICHARD CORRIEA</td>\n",
       "      <td>COMMANDER III, (POLICE DEPARTMENT)</td>\n",
       "      <td>198778.01</td>\n",
       "      <td>73478.20</td>\n",
       "      <td>13957.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>286213.86</td>\n",
       "      <td>286213.86</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>AMY HART</td>\n",
       "      <td>DEPARTMENT HEAD V</td>\n",
       "      <td>268604.57</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16115.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>284720.43</td>\n",
       "      <td>284720.43</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>SEBASTIAN WONG</td>\n",
       "      <td>CAPTAIN, EMERGENCYCY MEDICAL SERVICES</td>\n",
       "      <td>140546.87</td>\n",
       "      <td>119397.26</td>\n",
       "      <td>18625.08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>278569.21</td>\n",
       "      <td>278569.21</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>MARTY ROSS</td>\n",
       "      <td>BATTALION CHIEF, (FIRE DEPARTMENT)</td>\n",
       "      <td>168692.63</td>\n",
       "      <td>69626.12</td>\n",
       "      <td>38115.47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>276434.22</td>\n",
       "      <td>276434.22</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>ELLEN MOFFATT</td>\n",
       "      <td>ASSISTANT MEDICAL EXAMINER</td>\n",
       "      <td>257510.59</td>\n",
       "      <td>880.16</td>\n",
       "      <td>16159.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>274550.25</td>\n",
       "      <td>274550.25</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>VENUS AZAR</td>\n",
       "      <td>ASSISTANT MEDICAL EXAMINER</td>\n",
       "      <td>257510.48</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16679.79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>274190.27</td>\n",
       "      <td>274190.27</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>JUDY MELINEK</td>\n",
       "      <td>ASSISTANT MEDICAL EXAMINER</td>\n",
       "      <td>257510.44</td>\n",
       "      <td>377.21</td>\n",
       "      <td>15883.56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>273771.21</td>\n",
       "      <td>273771.21</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>GEORGE GARCIA</td>\n",
       "      <td>CAPTAIN, FIRE SUPPRESSION</td>\n",
       "      <td>140546.88</td>\n",
       "      <td>93200.58</td>\n",
       "      <td>39955.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>273702.71</td>\n",
       "      <td>273702.71</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>VICTOR WYRSCH</td>\n",
       "      <td>BATTALION CHIEF, (FIRE DEPARTMENT)</td>\n",
       "      <td>168692.63</td>\n",
       "      <td>77896.14</td>\n",
       "      <td>24083.86</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270672.63</td>\n",
       "      <td>270672.63</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>JOSEPH DRISCOLL</td>\n",
       "      <td>CAPTAIN, FIRE SUPPRESSION</td>\n",
       "      <td>140546.86</td>\n",
       "      <td>97868.77</td>\n",
       "      <td>31909.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>270324.91</td>\n",
       "      <td>270324.91</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>GREGORY SUHR</td>\n",
       "      <td>CHIEF OF POLICE</td>\n",
       "      <td>256470.41</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11522.18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>267992.59</td>\n",
       "      <td>267992.59</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>JOHN HANLEY</td>\n",
       "      <td>CAPTAIN, FIRE SUPPRESSION</td>\n",
       "      <td>92080.80</td>\n",
       "      <td>40008.00</td>\n",
       "      <td>133695.76</td>\n",
       "      <td>NaN</td>\n",
       "      <td>265784.56</td>\n",
       "      <td>265784.56</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>RAYMOND GUZMAN</td>\n",
       "      <td>BATTALION CHIEF, (FIRE DEPARTMENT)</td>\n",
       "      <td>168692.59</td>\n",
       "      <td>80706.88</td>\n",
       "      <td>16063.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>265463.46</td>\n",
       "      <td>265463.46</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>DENISE SCHMITT</td>\n",
       "      <td>DEPUTY CHIEF III (POLICE DEPARTMENT)</td>\n",
       "      <td>261717.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2357.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>264074.60</td>\n",
       "      <td>264074.60</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>MONICA FIELDS</td>\n",
       "      <td>DEPUTY CHIEF OF DEPARTMENT,(FIRE DEPARTMENT)</td>\n",
       "      <td>246225.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15140.54</td>\n",
       "      <td>NaN</td>\n",
       "      <td>261366.14</td>\n",
       "      <td>261366.14</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>971</td>\n",
       "      <td>GABRIEL SHIN</td>\n",
       "      <td>FIREFIGHTER</td>\n",
       "      <td>105934.68</td>\n",
       "      <td>47640.85</td>\n",
       "      <td>16904.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170480.33</td>\n",
       "      <td>170480.33</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>972</td>\n",
       "      <td>MOJGAN YOUSEFKHAN</td>\n",
       "      <td>PRINCIPAL CIVIL ENGINEER</td>\n",
       "      <td>162362.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8112.38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170475.16</td>\n",
       "      <td>170475.16</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>973</td>\n",
       "      <td>TERRY SMERDEL</td>\n",
       "      <td>LIEUTENANT, FIRE DEPARTMENT</td>\n",
       "      <td>124863.62</td>\n",
       "      <td>31978.14</td>\n",
       "      <td>13593.70</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170435.46</td>\n",
       "      <td>170435.46</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>974</td>\n",
       "      <td>MATTHEW LANE</td>\n",
       "      <td>FIRE FIGHTER PARAMEDIC</td>\n",
       "      <td>116781.05</td>\n",
       "      <td>45173.46</td>\n",
       "      <td>8430.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170384.78</td>\n",
       "      <td>170384.78</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>975</td>\n",
       "      <td>LARRY CAMILLERI</td>\n",
       "      <td>INSPECTOR III, (POLICE DEPARTMENT)</td>\n",
       "      <td>69076.00</td>\n",
       "      <td>21434.52</td>\n",
       "      <td>79863.62</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170374.14</td>\n",
       "      <td>170374.14</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>976</td>\n",
       "      <td>DAVID ELLIOTT</td>\n",
       "      <td>INSPECTOR III, (POLICE DEPARTMENT)</td>\n",
       "      <td>130457.96</td>\n",
       "      <td>9086.08</td>\n",
       "      <td>30801.33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170345.37</td>\n",
       "      <td>170345.37</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>977</td>\n",
       "      <td>DOUGLAS SPIKES</td>\n",
       "      <td>FIRE FIGHTER PARAMEDIC</td>\n",
       "      <td>122404.98</td>\n",
       "      <td>32584.75</td>\n",
       "      <td>15277.80</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170267.53</td>\n",
       "      <td>170267.53</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>978</td>\n",
       "      <td>GABRIEL ALCARAZ</td>\n",
       "      <td>POLICE OFFICER II</td>\n",
       "      <td>110118.84</td>\n",
       "      <td>32981.90</td>\n",
       "      <td>27162.71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170263.45</td>\n",
       "      <td>170263.45</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>979</td>\n",
       "      <td>VALERIE MATTHEWS</td>\n",
       "      <td>INSPECTOR III, (POLICE DEPARTMENT)</td>\n",
       "      <td>130466.58</td>\n",
       "      <td>20619.01</td>\n",
       "      <td>19145.69</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170231.28</td>\n",
       "      <td>170231.28</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>980</td>\n",
       "      <td>EUGENE CLENDINEN</td>\n",
       "      <td>MANAGER VIII</td>\n",
       "      <td>161479.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8750.10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170229.37</td>\n",
       "      <td>170229.37</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>981</td>\n",
       "      <td>EDWARD BROWNE</td>\n",
       "      <td>POLICE OFFICER III</td>\n",
       "      <td>112401.08</td>\n",
       "      <td>7430.89</td>\n",
       "      <td>50391.05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170223.02</td>\n",
       "      <td>170223.02</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>982</td>\n",
       "      <td>WILLIAM WYCKOFF</td>\n",
       "      <td>FIREFIGHTER</td>\n",
       "      <td>105934.64</td>\n",
       "      <td>52697.70</td>\n",
       "      <td>11553.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170185.61</td>\n",
       "      <td>170185.61</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>983</td>\n",
       "      <td>CHARLES MC COY</td>\n",
       "      <td>LIEUTENANT, FIRE DEPARTMENT</td>\n",
       "      <td>123105.00</td>\n",
       "      <td>31227.51</td>\n",
       "      <td>15842.22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170174.73</td>\n",
       "      <td>170174.73</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>984</td>\n",
       "      <td>MICHAEL HASTEY</td>\n",
       "      <td>FIRE FIGHTER PARAMEDIC</td>\n",
       "      <td>122405.00</td>\n",
       "      <td>32171.52</td>\n",
       "      <td>15551.55</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170128.07</td>\n",
       "      <td>170128.07</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>985</td>\n",
       "      <td>PEIYUE HO</td>\n",
       "      <td>DIAGNOSTIC IMAGING TECH II</td>\n",
       "      <td>103971.40</td>\n",
       "      <td>23945.61</td>\n",
       "      <td>42208.30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170125.31</td>\n",
       "      <td>170125.31</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>986</td>\n",
       "      <td>CAROL WOLTHER</td>\n",
       "      <td>ELECTRICAL TRANSIT SHOP SUPERVISOR I</td>\n",
       "      <td>109160.81</td>\n",
       "      <td>43092.79</td>\n",
       "      <td>17859.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170112.61</td>\n",
       "      <td>170112.61</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>987</td>\n",
       "      <td>KENNETH LOMBARDI</td>\n",
       "      <td>CAPTAIN, FIRE SUPPRESSION</td>\n",
       "      <td>135103.40</td>\n",
       "      <td>23598.47</td>\n",
       "      <td>11377.28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170079.15</td>\n",
       "      <td>170079.15</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>988</td>\n",
       "      <td>DANIEL COLE</td>\n",
       "      <td>SERGEANT III (POLICE DEPARTMENT)</td>\n",
       "      <td>131715.02</td>\n",
       "      <td>5201.24</td>\n",
       "      <td>33112.94</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170029.20</td>\n",
       "      <td>170029.20</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>989</td>\n",
       "      <td>DOUGLAS PRICE-HANSON</td>\n",
       "      <td>PHYSICIAN SPECIALIST</td>\n",
       "      <td>159511.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10513.63</td>\n",
       "      <td>NaN</td>\n",
       "      <td>170025.58</td>\n",
       "      <td>170025.58</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>990</td>\n",
       "      <td>SUSAN OBATA</td>\n",
       "      <td>SUPERVISING PHYSICIAN SPECIALIST</td>\n",
       "      <td>169941.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169941.65</td>\n",
       "      <td>169941.65</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>991</td>\n",
       "      <td>RICHARD THOMPSON</td>\n",
       "      <td>SENIOR DEPUTY SHERIFF</td>\n",
       "      <td>96252.08</td>\n",
       "      <td>64426.82</td>\n",
       "      <td>9244.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169922.94</td>\n",
       "      <td>169922.94</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>992</td>\n",
       "      <td>LOUIS ESPINDA</td>\n",
       "      <td>LIEUTENANT III (POLICE DEPARTMENT)</td>\n",
       "      <td>149050.78</td>\n",
       "      <td>6220.38</td>\n",
       "      <td>14638.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169909.66</td>\n",
       "      <td>169909.66</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>993</td>\n",
       "      <td>DAMEN TOLLIVER</td>\n",
       "      <td>FIREFIGHTER</td>\n",
       "      <td>105934.64</td>\n",
       "      <td>54436.25</td>\n",
       "      <td>9533.84</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169904.73</td>\n",
       "      <td>169904.73</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>994</td>\n",
       "      <td>GRACE SALUD</td>\n",
       "      <td>NURSE MANAGER</td>\n",
       "      <td>156312.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13587.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169899.12</td>\n",
       "      <td>169899.12</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>995</td>\n",
       "      <td>YUSUFU CAUNGULA</td>\n",
       "      <td>FIREFIGHTER</td>\n",
       "      <td>105934.67</td>\n",
       "      <td>53551.86</td>\n",
       "      <td>10357.93</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169844.46</td>\n",
       "      <td>169844.46</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>996</td>\n",
       "      <td>ANTIONETTE GRIFFIN</td>\n",
       "      <td>CLINICAL NURSE SPECIALIST</td>\n",
       "      <td>169572.08</td>\n",
       "      <td>0.00</td>\n",
       "      <td>250.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169822.08</td>\n",
       "      <td>169822.08</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>997</td>\n",
       "      <td>KATHERINE MAH</td>\n",
       "      <td>CLINICAL NURSE SPECIALIST</td>\n",
       "      <td>169572.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>250.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169822.06</td>\n",
       "      <td>169822.06</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>998</td>\n",
       "      <td>CHRISTINE DAVENPORT</td>\n",
       "      <td>CLINICAL NURSE SPECIALIST</td>\n",
       "      <td>169572.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>250.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169822.05</td>\n",
       "      <td>169822.05</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>999</td>\n",
       "      <td>ANNE HUGHES</td>\n",
       "      <td>CLINICAL NURSE SPECIALIST</td>\n",
       "      <td>169572.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>250.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169822.01</td>\n",
       "      <td>169822.01</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1000</td>\n",
       "      <td>JOHN FAZIO</td>\n",
       "      <td>CLINICAL NURSE SPECIALIST</td>\n",
       "      <td>169572.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>250.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169822.00</td>\n",
       "      <td>169822.00</td>\n",
       "      <td>2011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Id          EmployeeName  \\\n",
       "0       1        NATHANIEL FORD   \n",
       "1       2          GARY JIMENEZ   \n",
       "2       3        ALBERT PARDINI   \n",
       "3       4     CHRISTOPHER CHONG   \n",
       "4       5       PATRICK GARDNER   \n",
       "5       6        DAVID SULLIVAN   \n",
       "6       7             ALSON LEE   \n",
       "7       8         DAVID KUSHNER   \n",
       "8       9        MICHAEL MORRIS   \n",
       "9      10    JOANNE HAYES-WHITE   \n",
       "10     11         ARTHUR KENNEY   \n",
       "11     12      PATRICIA JACKSON   \n",
       "12     13     EDWARD HARRINGTON   \n",
       "13     14           JOHN MARTIN   \n",
       "14     15        DAVID FRANKLIN   \n",
       "15     16       RICHARD CORRIEA   \n",
       "16     17              AMY HART   \n",
       "17     18        SEBASTIAN WONG   \n",
       "18     19            MARTY ROSS   \n",
       "19     20         ELLEN MOFFATT   \n",
       "20     21            VENUS AZAR   \n",
       "21     22          JUDY MELINEK   \n",
       "22     23         GEORGE GARCIA   \n",
       "23     24         VICTOR WYRSCH   \n",
       "24     25       JOSEPH DRISCOLL   \n",
       "25     26          GREGORY SUHR   \n",
       "26     27           JOHN HANLEY   \n",
       "27     28        RAYMOND GUZMAN   \n",
       "28     29        DENISE SCHMITT   \n",
       "29     30         MONICA FIELDS   \n",
       "..    ...                   ...   \n",
       "970   971          GABRIEL SHIN   \n",
       "971   972     MOJGAN YOUSEFKHAN   \n",
       "972   973         TERRY SMERDEL   \n",
       "973   974          MATTHEW LANE   \n",
       "974   975       LARRY CAMILLERI   \n",
       "975   976         DAVID ELLIOTT   \n",
       "976   977        DOUGLAS SPIKES   \n",
       "977   978       GABRIEL ALCARAZ   \n",
       "978   979      VALERIE MATTHEWS   \n",
       "979   980      EUGENE CLENDINEN   \n",
       "980   981         EDWARD BROWNE   \n",
       "981   982       WILLIAM WYCKOFF   \n",
       "982   983        CHARLES MC COY   \n",
       "983   984        MICHAEL HASTEY   \n",
       "984   985             PEIYUE HO   \n",
       "985   986         CAROL WOLTHER   \n",
       "986   987      KENNETH LOMBARDI   \n",
       "987   988           DANIEL COLE   \n",
       "988   989  DOUGLAS PRICE-HANSON   \n",
       "989   990           SUSAN OBATA   \n",
       "990   991      RICHARD THOMPSON   \n",
       "991   992         LOUIS ESPINDA   \n",
       "992   993        DAMEN TOLLIVER   \n",
       "993   994           GRACE SALUD   \n",
       "994   995       YUSUFU CAUNGULA   \n",
       "995   996    ANTIONETTE GRIFFIN   \n",
       "996   997         KATHERINE MAH   \n",
       "997   998   CHRISTINE DAVENPORT   \n",
       "998   999           ANNE HUGHES   \n",
       "999  1000            JOHN FAZIO   \n",
       "\n",
       "                                             JobTitle    BasePay  OvertimePay  \\\n",
       "0      GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY  167411.18         0.00   \n",
       "1                     CAPTAIN III (POLICE DEPARTMENT)  155966.02    245131.88   \n",
       "2                     CAPTAIN III (POLICE DEPARTMENT)  212739.13    106088.18   \n",
       "3                WIRE ROPE CABLE MAINTENANCE MECHANIC   77916.00     56120.71   \n",
       "4        DEPUTY CHIEF OF DEPARTMENT,(FIRE DEPARTMENT)  134401.60      9737.00   \n",
       "5                           ASSISTANT DEPUTY CHIEF II  118602.00      8601.00   \n",
       "6                  BATTALION CHIEF, (FIRE DEPARTMENT)   92492.01     89062.90   \n",
       "7                      DEPUTY DIRECTOR OF INVESTMENTS  256576.96         0.00   \n",
       "8                  BATTALION CHIEF, (FIRE DEPARTMENT)  176932.64     86362.68   \n",
       "9              CHIEF OF DEPARTMENT, (FIRE DEPARTMENT)  285262.00         0.00   \n",
       "10   ASSISTANT CHIEF OF DEPARTMENT, (FIRE DEPARTMENT)  194999.39     71344.88   \n",
       "11                    CAPTAIN III (POLICE DEPARTMENT)   99722.00     87082.62   \n",
       "12                        EXECUTIVE CONTRACT EMPLOYEE  294580.02         0.00   \n",
       "13                                  DEPARTMENT HEAD V  271329.03         0.00   \n",
       "14                 BATTALION CHIEF, (FIRE DEPARTMENT)  174872.64     74050.30   \n",
       "15                 COMMANDER III, (POLICE DEPARTMENT)  198778.01     73478.20   \n",
       "16                                  DEPARTMENT HEAD V  268604.57         0.00   \n",
       "17              CAPTAIN, EMERGENCYCY MEDICAL SERVICES  140546.87    119397.26   \n",
       "18                 BATTALION CHIEF, (FIRE DEPARTMENT)  168692.63     69626.12   \n",
       "19                         ASSISTANT MEDICAL EXAMINER  257510.59       880.16   \n",
       "20                         ASSISTANT MEDICAL EXAMINER  257510.48         0.00   \n",
       "21                         ASSISTANT MEDICAL EXAMINER  257510.44       377.21   \n",
       "22                          CAPTAIN, FIRE SUPPRESSION  140546.88     93200.58   \n",
       "23                 BATTALION CHIEF, (FIRE DEPARTMENT)  168692.63     77896.14   \n",
       "24                          CAPTAIN, FIRE SUPPRESSION  140546.86     97868.77   \n",
       "25                                    CHIEF OF POLICE  256470.41         0.00   \n",
       "26                          CAPTAIN, FIRE SUPPRESSION   92080.80     40008.00   \n",
       "27                 BATTALION CHIEF, (FIRE DEPARTMENT)  168692.59     80706.88   \n",
       "28               DEPUTY CHIEF III (POLICE DEPARTMENT)  261717.60         0.00   \n",
       "29       DEPUTY CHIEF OF DEPARTMENT,(FIRE DEPARTMENT)  246225.60         0.00   \n",
       "..                                                ...        ...          ...   \n",
       "970                                       FIREFIGHTER  105934.68     47640.85   \n",
       "971                          PRINCIPAL CIVIL ENGINEER  162362.78         0.00   \n",
       "972                       LIEUTENANT, FIRE DEPARTMENT  124863.62     31978.14   \n",
       "973                            FIRE FIGHTER PARAMEDIC  116781.05     45173.46   \n",
       "974                INSPECTOR III, (POLICE DEPARTMENT)   69076.00     21434.52   \n",
       "975                INSPECTOR III, (POLICE DEPARTMENT)  130457.96      9086.08   \n",
       "976                            FIRE FIGHTER PARAMEDIC  122404.98     32584.75   \n",
       "977                                 POLICE OFFICER II  110118.84     32981.90   \n",
       "978                INSPECTOR III, (POLICE DEPARTMENT)  130466.58     20619.01   \n",
       "979                                      MANAGER VIII  161479.27         0.00   \n",
       "980                                POLICE OFFICER III  112401.08      7430.89   \n",
       "981                                       FIREFIGHTER  105934.64     52697.70   \n",
       "982                       LIEUTENANT, FIRE DEPARTMENT  123105.00     31227.51   \n",
       "983                            FIRE FIGHTER PARAMEDIC  122405.00     32171.52   \n",
       "984                        DIAGNOSTIC IMAGING TECH II  103971.40     23945.61   \n",
       "985              ELECTRICAL TRANSIT SHOP SUPERVISOR I  109160.81     43092.79   \n",
       "986                         CAPTAIN, FIRE SUPPRESSION  135103.40     23598.47   \n",
       "987                  SERGEANT III (POLICE DEPARTMENT)  131715.02      5201.24   \n",
       "988                              PHYSICIAN SPECIALIST  159511.95         0.00   \n",
       "989                  SUPERVISING PHYSICIAN SPECIALIST  169941.65         0.00   \n",
       "990                             SENIOR DEPUTY SHERIFF   96252.08     64426.82   \n",
       "991                LIEUTENANT III (POLICE DEPARTMENT)  149050.78      6220.38   \n",
       "992                                       FIREFIGHTER  105934.64     54436.25   \n",
       "993                                     NURSE MANAGER  156312.00         0.00   \n",
       "994                                       FIREFIGHTER  105934.67     53551.86   \n",
       "995                         CLINICAL NURSE SPECIALIST  169572.08         0.00   \n",
       "996                         CLINICAL NURSE SPECIALIST  169572.06         0.00   \n",
       "997                         CLINICAL NURSE SPECIALIST  169572.05         0.00   \n",
       "998                         CLINICAL NURSE SPECIALIST  169572.01         0.00   \n",
       "999                         CLINICAL NURSE SPECIALIST  169572.00         0.00   \n",
       "\n",
       "      OtherPay  Benefits   TotalPay  TotalPayBenefits  Year  Notes  \\\n",
       "0    400184.25       NaN  567595.43         567595.43  2011    NaN   \n",
       "1    137811.38       NaN  538909.28         538909.28  2011    NaN   \n",
       "2     16452.60       NaN  335279.91         335279.91  2011    NaN   \n",
       "3    198306.90       NaN  332343.61         332343.61  2011    NaN   \n",
       "4    182234.59       NaN  326373.19         326373.19  2011    NaN   \n",
       "5    189082.74       NaN  316285.74         316285.74  2011    NaN   \n",
       "6    134426.14       NaN  315981.05         315981.05  2011    NaN   \n",
       "7     51322.50       NaN  307899.46         307899.46  2011    NaN   \n",
       "8     40132.23       NaN  303427.55         303427.55  2011    NaN   \n",
       "9     17115.73       NaN  302377.73         302377.73  2011    NaN   \n",
       "10    33149.90       NaN  299494.17         299494.17  2011    NaN   \n",
       "11   110804.30       NaN  297608.92         297608.92  2011    NaN   \n",
       "12        0.00       NaN  294580.02         294580.02  2011    NaN   \n",
       "13    21342.59       NaN  292671.62         292671.62  2011    NaN   \n",
       "14    37424.11       NaN  286347.05         286347.05  2011    NaN   \n",
       "15    13957.65       NaN  286213.86         286213.86  2011    NaN   \n",
       "16    16115.86       NaN  284720.43         284720.43  2011    NaN   \n",
       "17    18625.08       NaN  278569.21         278569.21  2011    NaN   \n",
       "18    38115.47       NaN  276434.22         276434.22  2011    NaN   \n",
       "19    16159.50       NaN  274550.25         274550.25  2011    NaN   \n",
       "20    16679.79       NaN  274190.27         274190.27  2011    NaN   \n",
       "21    15883.56       NaN  273771.21         273771.21  2011    NaN   \n",
       "22    39955.25       NaN  273702.71         273702.71  2011    NaN   \n",
       "23    24083.86       NaN  270672.63         270672.63  2011    NaN   \n",
       "24    31909.28       NaN  270324.91         270324.91  2011    NaN   \n",
       "25    11522.18       NaN  267992.59         267992.59  2011    NaN   \n",
       "26   133695.76       NaN  265784.56         265784.56  2011    NaN   \n",
       "27    16063.99       NaN  265463.46         265463.46  2011    NaN   \n",
       "28     2357.00       NaN  264074.60         264074.60  2011    NaN   \n",
       "29    15140.54       NaN  261366.14         261366.14  2011    NaN   \n",
       "..         ...       ...        ...               ...   ...    ...   \n",
       "970   16904.80       NaN  170480.33         170480.33  2011    NaN   \n",
       "971    8112.38       NaN  170475.16         170475.16  2011    NaN   \n",
       "972   13593.70       NaN  170435.46         170435.46  2011    NaN   \n",
       "973    8430.27       NaN  170384.78         170384.78  2011    NaN   \n",
       "974   79863.62       NaN  170374.14         170374.14  2011    NaN   \n",
       "975   30801.33       NaN  170345.37         170345.37  2011    NaN   \n",
       "976   15277.80       NaN  170267.53         170267.53  2011    NaN   \n",
       "977   27162.71       NaN  170263.45         170263.45  2011    NaN   \n",
       "978   19145.69       NaN  170231.28         170231.28  2011    NaN   \n",
       "979    8750.10       NaN  170229.37         170229.37  2011    NaN   \n",
       "980   50391.05       NaN  170223.02         170223.02  2011    NaN   \n",
       "981   11553.27       NaN  170185.61         170185.61  2011    NaN   \n",
       "982   15842.22       NaN  170174.73         170174.73  2011    NaN   \n",
       "983   15551.55       NaN  170128.07         170128.07  2011    NaN   \n",
       "984   42208.30       NaN  170125.31         170125.31  2011    NaN   \n",
       "985   17859.01       NaN  170112.61         170112.61  2011    NaN   \n",
       "986   11377.28       NaN  170079.15         170079.15  2011    NaN   \n",
       "987   33112.94       NaN  170029.20         170029.20  2011    NaN   \n",
       "988   10513.63       NaN  170025.58         170025.58  2011    NaN   \n",
       "989       0.00       NaN  169941.65         169941.65  2011    NaN   \n",
       "990    9244.04       NaN  169922.94         169922.94  2011    NaN   \n",
       "991   14638.50       NaN  169909.66         169909.66  2011    NaN   \n",
       "992    9533.84       NaN  169904.73         169904.73  2011    NaN   \n",
       "993   13587.12       NaN  169899.12         169899.12  2011    NaN   \n",
       "994   10357.93       NaN  169844.46         169844.46  2011    NaN   \n",
       "995     250.00       NaN  169822.08         169822.08  2011    NaN   \n",
       "996     250.00       NaN  169822.06         169822.06  2011    NaN   \n",
       "997     250.00       NaN  169822.05         169822.05  2011    NaN   \n",
       "998     250.00       NaN  169822.01         169822.01  2011    NaN   \n",
       "999     250.00       NaN  169822.00         169822.00  2011    NaN   \n",
       "\n",
       "            Agency  Status  totallen  \n",
       "0    San Francisco     NaN        46  \n",
       "1    San Francisco     NaN        31  \n",
       "2    San Francisco     NaN        31  \n",
       "3    San Francisco     NaN        36  \n",
       "4    San Francisco     NaN        44  \n",
       "5    San Francisco     NaN        25  \n",
       "6    San Francisco     NaN        34  \n",
       "7    San Francisco     NaN        30  \n",
       "8    San Francisco     NaN        34  \n",
       "9    San Francisco     NaN        38  \n",
       "10   San Francisco     NaN        48  \n",
       "11   San Francisco     NaN        31  \n",
       "12   San Francisco     NaN        27  \n",
       "13   San Francisco     NaN        17  \n",
       "14   San Francisco     NaN        34  \n",
       "15   San Francisco     NaN        34  \n",
       "16   San Francisco     NaN        17  \n",
       "17   San Francisco     NaN        37  \n",
       "18   San Francisco     NaN        34  \n",
       "19   San Francisco     NaN        26  \n",
       "20   San Francisco     NaN        26  \n",
       "21   San Francisco     NaN        26  \n",
       "22   San Francisco     NaN        25  \n",
       "23   San Francisco     NaN        34  \n",
       "24   San Francisco     NaN        25  \n",
       "25   San Francisco     NaN        15  \n",
       "26   San Francisco     NaN        25  \n",
       "27   San Francisco     NaN        34  \n",
       "28   San Francisco     NaN        36  \n",
       "29   San Francisco     NaN        44  \n",
       "..             ...     ...       ...  \n",
       "970  San Francisco     NaN        11  \n",
       "971  San Francisco     NaN        24  \n",
       "972  San Francisco     NaN        27  \n",
       "973  San Francisco     NaN        22  \n",
       "974  San Francisco     NaN        34  \n",
       "975  San Francisco     NaN        34  \n",
       "976  San Francisco     NaN        22  \n",
       "977  San Francisco     NaN        17  \n",
       "978  San Francisco     NaN        34  \n",
       "979  San Francisco     NaN        12  \n",
       "980  San Francisco     NaN        18  \n",
       "981  San Francisco     NaN        11  \n",
       "982  San Francisco     NaN        27  \n",
       "983  San Francisco     NaN        22  \n",
       "984  San Francisco     NaN        26  \n",
       "985  San Francisco     NaN        36  \n",
       "986  San Francisco     NaN        25  \n",
       "987  San Francisco     NaN        32  \n",
       "988  San Francisco     NaN        20  \n",
       "989  San Francisco     NaN        32  \n",
       "990  San Francisco     NaN        21  \n",
       "991  San Francisco     NaN        34  \n",
       "992  San Francisco     NaN        11  \n",
       "993  San Francisco     NaN        13  \n",
       "994  San Francisco     NaN        11  \n",
       "995  San Francisco     NaN        25  \n",
       "996  San Francisco     NaN        25  \n",
       "997  San Francisco     NaN        25  \n",
       "998  San Francisco     NaN        25  \n",
       "999  San Francisco     NaN        25  \n",
       "\n",
       "[1000 rows x 14 columns]"
      ]
     },
     "execution_count": 172,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head(1000)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** Use the .info() method to find out how many entries there are.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 148654 entries, 0 to 148653\n",
      "Data columns (total 13 columns):\n",
      "Id                  148654 non-null int64\n",
      "EmployeeName        148654 non-null object\n",
      "JobTitle            148654 non-null object\n",
      "BasePay             148045 non-null float64\n",
      "OvertimePay         148650 non-null float64\n",
      "OtherPay            148650 non-null float64\n",
      "Benefits            112491 non-null float64\n",
      "TotalPay            148654 non-null float64\n",
      "TotalPayBenefits    148654 non-null float64\n",
      "Year                148654 non-null int64\n",
      "Notes               0 non-null float64\n",
      "Agency              148654 non-null object\n",
      "Status              0 non-null float64\n",
      "dtypes: float64(8), int64(2), object(3)\n",
      "memory usage: 14.7+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**What is the average BasePay ?**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "66325.44884050643"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.BasePay.mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** What is the highest amount of OvertimePay in the dataset ? **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "245131.88"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.OvertimePay.max()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** What is the job title of  JOSEPH DRISCOLL ? Note: Use all caps, otherwise you may get an answer that doesn't match up (there is also a lowercase Joseph Driscoll). **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'CAPTAIN, FIRE SUPPRESSION'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data['EmployeeName'] == 'JOSEPH DRISCOLL', 'JobTitle'].iloc[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** How much does JOSEPH DRISCOLL make (including benefits)? **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "270324.91"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data['EmployeeName'] == 'JOSEPH DRISCOLL', 'TotalPayBenefits'].iloc[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** What is the name of highest paid person (including benefits)?**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'NATHANIEL FORD'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data['TotalPayBenefits'] == data['TotalPayBenefits'].max(), 'EmployeeName'].iloc[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** What is the name of lowest paid person (including benefits)? Do you notice something strange about how much he or she is paid?**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "EmployeeName        Joe Lopez\n",
       "TotalPayBenefits      -618.13\n",
       "Name: 148653, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data['TotalPayBenefits'] == data['TotalPayBenefits'].min(), ('EmployeeName','TotalPayBenefits')].iloc[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** What was the average (mean) BasePay of all employees per year? (2011-2014) ? **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2011   63595.956516774524\n",
      "2012   65436.40685742255\n",
      "2013   69630.0302164812\n",
      "2014   66564.42192449933\n"
     ]
    }
   ],
   "source": [
    "\n",
    "for i in range(2011,2015):\n",
    "    print(i,\" \",data[data['Year'] == i]['BasePay'].mean())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** How many unique job titles are there? **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2159"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data['JobTitle'].unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** What are the top 5 most common jobs? **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Transit Operator                7036\n",
       "Special Nurse                   4389\n",
       "Registered Nurse                3736\n",
       "Public Svc Aide-Public Works    2518\n",
       "Police Officer 3                2421\n",
       "Name: JobTitle, dtype: int64"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['JobTitle'].value_counts().head(5)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** How many Job Titles were represented by only one person in 2013? (e.g. Job Titles with only one occurence in 2013?) **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Principal Real Property Ofc\n",
      "Asphalt Plant Supervisor 1\n",
      "Window Cleaner Supervisor\n",
      "Track Maint Supt, Muni Railway\n",
      "Bd/Comm Secretary 3\n",
      "Legislation Clerk\n",
      "Mgr Museum Security Services\n",
      "Animal Care Asst Supv\n",
      "Senior Plan Checker\n",
      "Court Reporter Coordinator\n",
      "Asst Dir of Clinical Svcs 1\n",
      "Junior Clerk Typist\n",
      "Special Assistant 15\n",
      "Assessor\n",
      "Feasibility Analyst, Port\n",
      "Sr Opers Mgr\n",
      "Assistant Director, Probate\n",
      "IS Technician Assistant\n",
      "Dir Emp Relations Div\n",
      "Mental Health Hearing Officer\n",
      "Wire Rope Cable Maint Sprv\n",
      "Assistant Power House Operator\n",
      "Emergency Services Coord I\n",
      "Electric Motor Repair Sprv 1\n",
      "Ex Asst to Ex Dir, Retirement\n",
      "Crane Mechanic Supervisor\n",
      "Adm, SFGH Medical Center\n",
      "Emergency Medical Svcs Chief\n",
      "Sprv Adult Prob Ofc (SFERS)\n",
      "Special Assistant 16\n",
      "Chf Victim/Witness Invstgtor\n",
      "Asst Director, Juvenile Hall\n",
      "Conservatorship/Case Mgt Sprv\n",
      "Acupuncturist\n",
      "Signal and Systems Engineer\n",
      "Communications Director\n",
      "Employee Assistance Counselor\n",
      "Payroll Supervisor\n",
      "Public Safety Comm Tech\n",
      "Industrial Engineer\n",
      "Animal Care Supervisor\n",
      "Farmer\n",
      "District Attorney\n",
      "Research Psychologist\n",
      "Performance Analyst I\n",
      "Auto Body & Fender Wrk Sprv 1\n",
      "Telecommunications Tech Supv\n",
      "Public Defender\n",
      "Senior Museum Preparator\n",
      "Media Training Specialist\n",
      "Shelter Officer Supervisor\n",
      "Director, Probation Services\n",
      "Sctry, Human Svcs. Commission\n",
      "Trnst Power Line Wrk Sprv 2\n",
      "Water Meter Shop Supervisor 1\n",
      "Director, Fiscal Services\n",
      "Sr Light Rail Veh Equip Eng\n",
      "PrDAInvest,SpecUnit (SFERS)\n",
      "Chief Plumbing Inspector\n",
      "Senior Psychiatric Orderly\n",
      "Mech Shop & Equip Supt\n",
      "Administrative Analyst I\n",
      "Board Scty, MTA\n",
      "Arborist Technician Supv II\n",
      "Mayoral Staff VII\n",
      "Depty Sealer of Weights & Meas\n",
      "Chief Fire Alarm Dispatcher\n",
      "Attorney, Tax Collector\n",
      "Vet Laboratory Technologist\n",
      "Administrative Analyst II\n",
      "Director, Info Tech Group\n",
      "IS Operator-Analyst\n",
      "Senior Pharmacy Helper\n",
      "Senior Morgue Attendant\n",
      "Operating Room Nurse\n",
      "Chief of Police\n",
      "Director, Juvenile Hall\n",
      "Senior Transit Traffic Checker\n",
      "Librarian 2 - Asian Arts\n",
      "Chief Adult Probation Officer\n",
      "Graphics Supervisor\n",
      "Rent Board Supervisor\n",
      "Transit Paint Shop Sprv1\n",
      "Chief Housing Inspector\n",
      "Secretary, Library Commission\n",
      "Roofer Supervisor 1\n",
      "Secretary, Health Commission\n",
      "Treasurer\n",
      "Traffic Sign Manager\n",
      "Specialist in Aging 2\n",
      "Victim & Witness Technician\n",
      "Supervising Parts Storekeeper\n",
      "Senior Transcriber Typist\n",
      "Shelter Office Asst Supv\n",
      "Ornamental Iron Wrk Sprv 1\n",
      "Materials/Supplies Supervisor\n",
      "Civil Case Settlmnt Specialist\n",
      "Orthopedic Technician 2\n",
      "Cement Finisher Supervisor 2\n",
      "Media Production Specialist\n",
      "Captain, (Fire Department)\n",
      "Animal Control Supervisor\n",
      "Ex Asst to the Controller\n",
      "Principal Museum Preparator\n",
      "Wharfinger 1\n",
      "Asst Dir, Log Cabin Rnch\n",
      "City Shops Asst Superintendent\n",
      "Sup Welfare Fraud Investigator\n",
      "Disability Access Coordinator\n",
      "Assistant Industrial Hygienist\n",
      "Court Interpreter Supervisor\n",
      "Soft Floor Coverer Supvr I\n",
      "Court Asst., Superior Court\n",
      "IS Operator-Journey\n",
      "Chief Dep Adlt Prob Of (SFERS)\n",
      "Media/Security Syst Supv\n",
      "Crime Lab Mgr\n",
      "Assistant Inspector\n",
      "Chf District Atty Investigator\n",
      "Power Plant Supervisor 1\n",
      "Senior Book Repairer\n",
      "Orthopedic Technician 1\n",
      "Ex Dir, SE Com Fac Comm\n",
      "Director, Probate\n",
      "Court Asst-Sr, Superior Court\n",
      "Parking Hearing Examiner\n",
      "Special Assistant 14\n",
      "Secretary, Comm on the Environ\n",
      "Human Resources Director\n",
      "Sr Employee Asst Counselor\n",
      "Chief Nursery Specialist\n",
      "Head Photographer\n",
      "Court Clerk\n",
      "Director, Human Resources\n",
      "Laboratory Technician I\n",
      "Assistant Law Librarian\n",
      "Electroencephalograph Tech 1\n",
      "Environmental Hlth Tech 2\n",
      "Chief, Fire Department\n",
      "Airport Communications Officer\n",
      "Senior Assessment Clerk\n",
      "IS Trainer-Senior\n",
      "Pr Investigator, Tax Collector\n",
      "Port Director\n",
      "Law Librarian\n",
      "Assistant Sheriff\n",
      "Field Svcs Asst Supv\n",
      "Administrator, DPH\n",
      "Dir, Log Cabin Ranch (SFERS)\n",
      "Undersheriff\n",
      "Metalsmith\n",
      "Managing Attorney\n",
      "Forensic Toxicologist\n",
      "Area Sprv Parks, Squares & Fac\n",
      "Real Estate Devt. Mgr, SFMTA\n",
      "Media Programming Spec\n",
      "Braillist\n",
      "Cfdntal Sctry to City Atty\n",
      "Claims Process Clerk\n",
      "Asst Chf, Bur Clm Invest&Admin\n",
      "Supply Room Attendant\n",
      "Sheet Metal Wrk Supervisor 2\n",
      "Asst Superintendent Rec\n",
      "City Attorney\n",
      "Market Research Spec, Port\n",
      "Training Coordinator\n",
      "Employment & Training Spec 6\n",
      "Senior Food Service Supervisor\n",
      "Court Executive Officer\n",
      "Traffic Signal Operator\n",
      "Plumber Supervisor 2\n",
      "Mayoral Staff X\n",
      "Traf Signal Electrician Sup II\n",
      "Baker\n",
      "Special Assistant 21\n",
      "Mayoral Staff XII\n",
      "Dep Dir for Investments, Ret\n",
      "Senior Data Entry Operator\n",
      "Glazier Supervisor 1\n",
      "Principal Recreation Sprv\n",
      "Sctry, Juv Probation Comm\n",
      "Senior Offset Machine Operator\n",
      "Gen Mgr, Public Trnsp Dept\n",
      "Chief Electrical Inspector\n",
      "Airport Mechanical Maint Sprv\n",
      "Sr Medical Transcriber Typist\n",
      "Chief Deputy Adlt Probation Of\n",
      "Emergency Services Assistant\n",
      "Shade and Drapery Worker\n",
      "Sr General Utility Mechanic\n",
      "Assoc Musm Cnsrvt, AAM\n",
      "Painter Supervisor 2\n",
      "Mayor\n",
      "Controller\n",
      "Sheriff (SFERS)\n",
      "Assistant Inspector 2\n",
      "Statistician\n",
      "Municipal Stadium Groundskpr\n",
      "Chief Telephone Operator\n",
      "Sup Ct Admin Secretary\n",
      "Drug Court Coordinator\n",
      "Training Technician\n",
      "202\n"
     ]
    }
   ],
   "source": [
    "data_2 = data[data['Year']==2013]['JobTitle'].value_counts().to_dict()\n",
    "\n",
    "count=0\n",
    "\n",
    "for keys,value in data_2.items(): \n",
    "    if value == 1:\n",
    "        print(keys)\n",
    "        count+=1\n",
    "    \n",
    "print(count)\n",
    "count=0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** How many people have the word Chief in their job title? (This is pretty tricky) **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['deputy', 'chief', 'of', 'department,(fire', 'department)']\n",
      "['assistant', 'deputy', 'chief', 'ii']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'of', 'department,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'of', 'department,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'of', 'police']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['deputy', 'chief', 'iii', '(police', 'department)']\n",
      "['deputy', 'chief', 'of', 'department,(fire', 'department)']\n",
      "['deputy', 'chief', 'iii', '(police', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['deputy', 'chief', 'of', 'department,(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['deputy', 'chief', 'iii', '(police', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['deputy', 'chief', 'iii', '(police', 'department)']\n",
      "['assistant', 'deputy', 'chief', 'ii']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'of', 'department,', '(fire', 'department)']\n",
      "['deputy', 'chief', 'iii', '(police', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['confidential', 'chief', 'attorney', 'ii', '(civil', '&', 'criminal)']\n",
      "['confidential', 'chief', 'attorney', 'ii', '(civil', '&', 'criminal)']\n",
      "['confidential', 'chief', 'attorney', 'ii', '(civil', '&', 'criminal)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'attorney', 'i', '(civil', '&', 'criminal)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'deputy', 'chief', 'ii']\n",
      "['assistant', 'deputy', 'chief', 'ii']\n",
      "['chief', 'attorney', 'i', '(civil', '&', 'criminal)']\n",
      "['chief', 'attorney', 'i', '(civil', '&', 'criminal)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'attorney', 'ii']\n",
      "['assistant', 'chief', 'attorney', 'ii']\n",
      "['assistant', 'chief', 'attorney', 'ii']\n",
      "['chief', 'probation', 'officer,', 'juvenile', 'court']\n",
      "['assistant', 'chief', 'attorney', 'ii']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'adult', 'probation', 'officer']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['assistant', 'deputy', 'chief', 'ii']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['asst.', 'chief', 'probation', 'officer-juvenile', 'probation']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['assistant', 'chief', 'attorney', 'ii']\n",
      "['chief', 'district', \"attorney's\", 'investigator']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'attorney', 'i', '(civil', '&', 'criminal)']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer,', 'water', 'treatment', 'plant']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer,', 'water', 'treatment', 'plant']\n",
      "['asst.', 'chief,', 'bureau', 'of', 'claims', 'invest.', '&', 'admin']\n",
      "['chief', 'stationary', 'engineer,', 'water', 'treatment', 'plant']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'plumbing', 'inspector']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'stationary', 'engineer,', 'water', 'treatment', 'plant']\n",
      "['chief', 'electrical', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'water', 'treatment', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'housing', 'inspector']\n",
      "['assistant', 'chief', 'district', \"attorney's\", 'investigator']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['assistant', 'chief', 'district', \"attorney's\", 'investigator']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['assistant', 'chief', 'district', \"attorney's\", 'investigator']\n",
      "['assistant', 'chief', 'district', \"attorney's\", 'investigator']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'microbiologist']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'fire', 'alarm', 'dispatcher']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'victim/witness', 'investigator']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['assistant', 'chief', 'victim/witness', 'investigator']\n",
      "['assistant', 'chief', 'victim/witness', 'investigator']\n",
      "['assistant', 'chief', 'victim/witness', 'investigator']\n",
      "['assistant', 'chief', 'victim/witness', 'investigator']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['assistant', 'chief', 'victim/witness', 'investigator']\n",
      "['chief', 'nursery', 'specialist']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'payroll', 'and', 'personnel', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'payroll', 'and', 'personnel', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['assistant', 'chief', 'of', 'department,', '(fire', 'department)']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'deputy', 'adult', 'probation', 'officer']\n",
      "['chief', 'payroll', 'and', 'personnel', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['chief', 'clerk']\n",
      "['chief', 'attorney', 'i', '(civil', '&', 'criminal)']\n",
      "['assistant', 'chief', 'attorney', 'i']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'telephone', 'operator']\n",
      "['chief', 'deputy', 'adult', 'probation', 'officer']\n",
      "['chief', 'preparator']\n",
      "['chief', 'clerk']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer,', 'sewage', 'plant']\n",
      "['chief', 'preparator']\n",
      "['battalion', 'chief,', '(fire', 'department)']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'payroll', 'and', 'personnel', 'clerk']\n",
      "['chief', 'adult', 'probation', 'officer']\n",
      "['chief', 'of', 'police']\n",
      "['chief,', 'fire', 'department']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['deputy', 'chief', '3']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['deputy', 'chief', '3']\n",
      "['deputy', 'chief', '3']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['deputy', 'chief', '3']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['emergency', 'medical', 'svcs', 'chief']\n",
      "['deputy', 'chief', '3']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['deputy', 'chief', '3']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'adult', 'probation', 'officer']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['chief', 'building', 'inspector']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'plumbing', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'electrical', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'housing', 'inspector']\n",
      "['chief', 'dep', 'adlt', 'prob', 'of', '(sfers)']\n",
      "['chief', 'fire', 'alarm', 'dispatcher']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'nursery', 'specialist']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'preparator']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'telephone', 'operator']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'deputy', 'adlt', 'probation', 'of']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'clerk']\n",
      "['chief', 'surveyor']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'deputy', 'adlt', 'probation', 'of']\n",
      "['chief', 'clerk']\n",
      "['battlion', 'chief,', 'fire', 'suppressi']\n",
      "['chief', 'of', 'police']\n",
      "['chief,', 'fire', 'department']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['deputy', 'chief', '3']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['deputy', 'chief', '3']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['deputy', 'chief', '3']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['deputy', 'chief', '3']\n",
      "['deputy', 'chief', '3']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['emergency', 'medical', 'svcs', 'chief']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['chief', 'adult', 'probation', 'officer']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'dep', 'adlt', 'prob', 'of', '(sfers)']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['deputy', 'chief', '3']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'plumbing', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'electrical', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'housing', 'inspector']\n",
      "['chief', 'fire', 'alarm', 'dispatcher']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['deputy', 'chief', '3']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'nursery', 'specialist']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'preparator']\n",
      "['chief', 'clerk']\n",
      "['chief', 'telephone', 'operator']\n",
      "['chief', 'stationary', 'engineer']\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['chief', 'stationary', 'engineer']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'deputy', 'adlt', 'probation', 'of']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'clerk']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'preparator']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['deputy', 'chief', '3']\n",
      "['chief', 'investment', 'officer']\n",
      "['chief', 'of', 'police']\n",
      "['chief,', 'fire', 'department']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['deputy', 'chief', '3']\n",
      "['deputy', 'chief', '3']\n",
      "['deputy', 'chief', '3']\n",
      "['deputy', 'chief', '3']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['deputy', 'chief', '3']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'deputy', 'chief', '2']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['emergency', 'medical', 'svcs', 'chief']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'forensic', 'toxicologist']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'adult', 'probation', 'officer']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['assistant', 'chief', 'attorney', '2']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['battalion', 'chief,', 'fire', 'suppress']\n",
      "['deputy', 'chief', '3']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'deputy', 'sheriff']\n",
      "['chief', 'dep', 'adlt', 'prob', 'of', '(sfers)']\n",
      "['deputy', 'chief', '3']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'plumbing', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'building', 'inspector']\n",
      "['chief', 'electrical', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'water', 'service', 'inspector']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'atty1', '(civil', '&', 'criminal)']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'housing', 'inspector']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'fire', 'alarm', 'dispatcher']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'dietitian']\n",
      "['chief', 'stationary', 'engineer']\n",
      "['chief', 'surveyor']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'clerk']\n",
      "['chief', 'telephone', 'operator']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'clerk']\n",
      "['chief', 'preparator']\n",
      "['chief', 'surveyor']\n",
      "['assistant', 'chief', 'attorney', '1']\n",
      "['chief', 'deputy', 'adlt', 'probation', 'of']\n",
      "['chief', 'clerk']\n",
      "['chief', 'nursery', 'specialist']\n",
      "['chief', 'preparator']\n",
      "['chief', 'stationary', 'engineer']\n",
      "627\n"
     ]
    }
   ],
   "source": [
    "import re\n",
    "count = 0\n",
    "\n",
    "for names in data.JobTitle:\n",
    "    names=str(names.lower().split())\n",
    "    if re.search(\"Chief\".lower(),names):\n",
    "        print(names)\n",
    "        count+=1\n",
    "print(count)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "477"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** Bonus: Is there a correlation between length of the Job Title string and Salary? **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "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>totallen</th>\n",
       "      <th>TotalPayBenefits</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>totallen</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.036878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TotalPayBenefits</th>\n",
       "      <td>-0.036878</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  totallen  TotalPayBenefits\n",
       "totallen          1.000000         -0.036878\n",
       "TotalPayBenefits -0.036878          1.000000"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "data['totallen'] = data['JobTitle'].apply(len)\n",
    "data[['totallen','TotalPayBenefits']].corr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Great Job!"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}