cleaning available health staff.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "avail_health_staff = pd.read_csv(\"Available-Health-Staff-Skilled-and-Supporting-by-region-2014.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "avail_health_staff.columns = ['Region Cadre', 'Anaesthesiologists',\n",
    "                              'Assistant Dental Officer',\n",
    "       'Assistant Environmental Health Officer', 'Assistant Lab Tech',\n",
    "       'Assistant Medical Officer', 'Assistant Nursing Officer',\n",
    "       'Audiometrists', 'Chemist/Chemist Assistants',\n",
    "       'Biomedical Technician/Technologist & Engineers', 'Clinical Assistant',\n",
    "       'Clinical Officer', 'Conversation designation',\n",
    "       'cook/Chef/catering Officer', 'Dental Assistants/Technologists',\n",
    "       'Dental Therapist/Officers', 'Environmental Health Assistant',\n",
    "       'Environmental Health Officer', 'Health Laboratory Assistant',\n",
    "       'Health Laboratory Scientist',\n",
    "       'Health Laboratory Technician/Technologists', 'Medical Recorders',\n",
    "       'Health Secretary', 'ICT Profession', 'Laundry staff',\n",
    "       'Medical Attendant', 'Medical Doctors',\n",
    "       'Medical Specialist/Consultants', 'Nurses', 'Nursing Officer',\n",
    "       'Nutrition Officer', 'Occupational Therapist Staff',\n",
    "       'Optometric Technologist', 'Optometrist', 'Orthotist/Prosthetist',\n",
    "       'Other Non0Medical Professionals', 'Pharmaceutical Technologist',\n",
    "       'Pharmacist', 'Physiotherapist', 'Physiotherapist Assistant',\n",
    "       'Prothetist/Orthotist', 'Radiologists & Radiologic Technologists',\n",
    "       'Radiography staff', 'Radiotherapist', 'Researchers',\n",
    "       'Speech Therapist', 'Sociol welfare Staff', 'Support Staff',\n",
    "       'Technicians &Technologists', 'Tutors/Lecturers/Professor']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "avail_health_staff[\"Year\"] = 2014"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>17</th>\n",
       "      <th>22</th>\n",
       "      <th>12</th>\n",
       "      <th>10</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Region Cadre</th>\n",
       "      <td>Pwani</td>\n",
       "      <td>Singida</td>\n",
       "      <td>Mbeya</td>\n",
       "      <td>Manyara</td>\n",
       "      <td>Geita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anaesthesiologists</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Dental Officer</th>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Environmental Health Officer</th>\n",
       "      <td>61</td>\n",
       "      <td>23</td>\n",
       "      <td>80</td>\n",
       "      <td>34</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Lab Tech</th>\n",
       "      <td>44</td>\n",
       "      <td>36</td>\n",
       "      <td>104</td>\n",
       "      <td>44</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Medical Officer</th>\n",
       "      <td>59</td>\n",
       "      <td>48</td>\n",
       "      <td>141</td>\n",
       "      <td>59</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Nursing Officer</th>\n",
       "      <td>114</td>\n",
       "      <td>113</td>\n",
       "      <td>379</td>\n",
       "      <td>354</td>\n",
       "      <td>115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Audiometrists</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chemist/Chemist Assistants</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biomedical Technician/Technologist &amp; Engineers</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Clinical Assistant</th>\n",
       "      <td>41</td>\n",
       "      <td>34</td>\n",
       "      <td>99</td>\n",
       "      <td>41</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Clinical Officer</th>\n",
       "      <td>210</td>\n",
       "      <td>172</td>\n",
       "      <td>499</td>\n",
       "      <td>209</td>\n",
       "      <td>105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Conversation designation</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cook/Chef/catering Officer</th>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>43</td>\n",
       "      <td>18</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dental Assistants/Technologists</th>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>41</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dental Therapist/Officers</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Environmental Health Assistant</th>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>41</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Environmental Health Officer</th>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>19</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Laboratory Assistant</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Laboratory Scientist</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Laboratory Technician/Technologists</th>\n",
       "      <td>31</td>\n",
       "      <td>26</td>\n",
       "      <td>75</td>\n",
       "      <td>31</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Recorders</th>\n",
       "      <td>16</td>\n",
       "      <td>13</td>\n",
       "      <td>21</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Secretary</th>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ICT Profession</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Laundry staff</th>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Attendant</th>\n",
       "      <td>687</td>\n",
       "      <td>744</td>\n",
       "      <td>2057</td>\n",
       "      <td>819</td>\n",
       "      <td>413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Doctors</th>\n",
       "      <td>59</td>\n",
       "      <td>14</td>\n",
       "      <td>218</td>\n",
       "      <td>37</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Specialist/Consultants</th>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>28</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nurses</th>\n",
       "      <td>987</td>\n",
       "      <td>656</td>\n",
       "      <td>1978</td>\n",
       "      <td>728</td>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nursing Officer</th>\n",
       "      <td>126</td>\n",
       "      <td>53</td>\n",
       "      <td>193</td>\n",
       "      <td>41</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nutrition Officer</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Occupational Therapist Staff</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Optometric Technologist</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Optometrist</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Orthotist/Prosthetist</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Non0Medical Professionals</th>\n",
       "      <td>65</td>\n",
       "      <td>48</td>\n",
       "      <td>90</td>\n",
       "      <td>43</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmaceutical Technologist</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmacist</th>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>40</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Physiotherapist</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Physiotherapist Assistant</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Prothetist/Orthotist</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Radiologists &amp; Radiologic Technologists</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Radiography staff</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Radiotherapist</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Researchers</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Speech Therapist</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sociol welfare Staff</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Support Staff</th>\n",
       "      <td>111</td>\n",
       "      <td>177</td>\n",
       "      <td>242</td>\n",
       "      <td>191</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technicians &amp;Technologists</th>\n",
       "      <td>35</td>\n",
       "      <td>33</td>\n",
       "      <td>113</td>\n",
       "      <td>34</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tutors/Lecturers/Professor</th>\n",
       "      <td>17</td>\n",
       "      <td>14</td>\n",
       "      <td>21</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   17       22     12  \\\n",
       "Region Cadre                                    Pwani  Singida  Mbeya   \n",
       "Anaesthesiologists                                  0        0      1   \n",
       "Assistant Dental Officer                            6        5     14   \n",
       "Assistant Environmental Health Officer             61       23     80   \n",
       "Assistant Lab Tech                                 44       36    104   \n",
       "Assistant Medical Officer                          59       48    141   \n",
       "Assistant Nursing Officer                         114      113    379   \n",
       "Audiometrists                                       0        0      0   \n",
       "Chemist/Chemist Assistants                          0        1      0   \n",
       "Biomedical Technician/Technologist & Engineers      1        1      1   \n",
       "Clinical Assistant                                 41       34     99   \n",
       "Clinical Officer                                  210      172    499   \n",
       "Conversation designation                            3        3      8   \n",
       "cook/Chef/catering Officer                         18       15     43   \n",
       "Dental Assistants/Technologists                    20        4     41   \n",
       "Dental Therapist/Officers                           5        0     12   \n",
       "Environmental Health Assistant                     10       11     41   \n",
       "Environmental Health Officer                       13       16     19   \n",
       "Health Laboratory Assistant                         2        1      4   \n",
       "Health Laboratory Scientist                         3        0      3   \n",
       "Health Laboratory Technician/Technologists         31       26     75   \n",
       "Medical Recorders                                  16       13     21   \n",
       "Health Secretary                                   14       13     28   \n",
       "ICT Profession                                      3        3      8   \n",
       "Laundry staff                                       8        6     18   \n",
       "Medical Attendant                                 687      744   2057   \n",
       "Medical Doctors                                    59       14    218   \n",
       "Medical Specialist/Consultants                     15        3     28   \n",
       "Nurses                                            987      656   1978   \n",
       "Nursing Officer                                   126       53    193   \n",
       "Nutrition Officer                                   1        3      9   \n",
       "Occupational Therapist Staff                        1        0      0   \n",
       "Optometric Technologist                             0        2     11   \n",
       "Optometrist                                         0        0      0   \n",
       "Orthotist/Prosthetist                               0        0      0   \n",
       "Other Non0Medical Professionals                    65       48     90   \n",
       "Pharmaceutical Technologist                         4        5     15   \n",
       "Pharmacist                                         18        4     40   \n",
       "Physiotherapist                                     1        2     21   \n",
       "Physiotherapist Assistant                           0        0      5   \n",
       "Prothetist/Orthotist                                0        0      0   \n",
       "Radiologists & Radiologic Technologists             3        4     21   \n",
       "Radiography staff                                   5        1      0   \n",
       "Radiotherapist                                      3        0      0   \n",
       "Researchers                                         1        1      2   \n",
       "Speech Therapist                                    0        0      0   \n",
       "Sociol welfare Staff                                0        0      0   \n",
       "Support Staff                                     111      177    242   \n",
       "Technicians &Technologists                         35       33    113   \n",
       "Tutors/Lecturers/Professor                         17       14     21   \n",
       "Year                                             2014     2014   2014   \n",
       "\n",
       "                                                     10     3   \n",
       "Region Cadre                                    Manyara  Geita  \n",
       "Anaesthesiologists                                    0      0  \n",
       "Assistant Dental Officer                              6      3  \n",
       "Assistant Environmental Health Officer               34     35  \n",
       "Assistant Lab Tech                                   44     22  \n",
       "Assistant Medical Officer                            59     30  \n",
       "Assistant Nursing Officer                           354    115  \n",
       "Audiometrists                                         0      0  \n",
       "Chemist/Chemist Assistants                            0      1  \n",
       "Biomedical Technician/Technologist & Engineers        0      0  \n",
       "Clinical Assistant                                   41     21  \n",
       "Clinical Officer                                    209    105  \n",
       "Conversation designation                              3      2  \n",
       "cook/Chef/catering Officer                           18      9  \n",
       "Dental Assistants/Technologists                       2      5  \n",
       "Dental Therapist/Officers                             4      0  \n",
       "Environmental Health Assistant                       11     15  \n",
       "Environmental Health Officer                          4     10  \n",
       "Health Laboratory Assistant                           0      0  \n",
       "Health Laboratory Scientist                           1      1  \n",
       "Health Laboratory Technician/Technologists           31     16  \n",
       "Medical Recorders                                    16      8  \n",
       "Health Secretary                                     12      8  \n",
       "ICT Profession                                        3      2  \n",
       "Laundry staff                                         7      4  \n",
       "Medical Attendant                                   819    413  \n",
       "Medical Doctors                                      37     15  \n",
       "Medical Specialist/Consultants                        2      0  \n",
       "Nurses                                              728    500  \n",
       "Nursing Officer                                      41      6  \n",
       "Nutrition Officer                                     2      0  \n",
       "Occupational Therapist Staff                          0      0  \n",
       "Optometric Technologist                               3      1  \n",
       "Optometrist                                           2      0  \n",
       "Orthotist/Prosthetist                                 0      0  \n",
       "Other Non0Medical Professionals                      43      1  \n",
       "Pharmaceutical Technologist                          11     14  \n",
       "Pharmacist                                            7      4  \n",
       "Physiotherapist                                       6      2  \n",
       "Physiotherapist Assistant                             0      1  \n",
       "Prothetist/Orthotist                                  0      0  \n",
       "Radiologists & Radiologic Technologists               1      4  \n",
       "Radiography staff                                     4      0  \n",
       "Radiotherapist                                        1      0  \n",
       "Researchers                                           1      0  \n",
       "Speech Therapist                                      0      0  \n",
       "Sociol welfare Staff                                  0      0  \n",
       "Support Staff                                       191     20  \n",
       "Technicians &Technologists                           34     20  \n",
       "Tutors/Lecturers/Professor                           12      3  \n",
       "Year                                               2014   2014  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avail_health_staff.sample(5).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "avail_health_staff_important = avail_health_staff[[\"Region Cadre\",\n",
    "                                                   \"Year\",\n",
    "                                                   \"Assistant Lab Tech\",\n",
    "                                                   \"Assistant Medical Officer\",\n",
    "                                                  \"Assistant Nursing Officer\",\n",
    "                                                  \"Biomedical Technician/Technologist & Engineers\",\n",
    "                                                  \"Clinical Assistant\",\n",
    "                                                  \"Clinical Officer\",\n",
    "                                                  \"Health Laboratory Assistant\",\n",
    "                                                  \"Health Laboratory Scientist\",\n",
    "                                                  \"Health Laboratory Technician/Technologists\",\n",
    "                                                  \"Medical Recorders\",\n",
    "                                                  \"Health Secretary\",\n",
    "                                                  \"Medical Attendant\",\n",
    "                                                  \"Medical Doctors\",\n",
    "                                                  \"Medical Specialist/Consultants\",\n",
    "                                                  \"Nurses\",\n",
    "                                                  \"Nursing Officer\",\n",
    "                                                  \"Nutrition Officer\",\n",
    "                                                  \"Pharmaceutical Technologist\",\n",
    "                                                  \"Pharmacist\",\n",
    "                                                  \"Researchers\",\n",
    "                                                  \"Support Staff\",\n",
    "                                                  \"Technicians &Technologists\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>22</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>8</th>\n",
       "      <th>11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Region Cadre</th>\n",
       "      <td>Singida</td>\n",
       "      <td>Njombe</td>\n",
       "      <td>Pwani</td>\n",
       "      <td>Kilimanjaro</td>\n",
       "      <td>Mara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Lab Tech</th>\n",
       "      <td>36</td>\n",
       "      <td>34</td>\n",
       "      <td>44</td>\n",
       "      <td>108</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Medical Officer</th>\n",
       "      <td>48</td>\n",
       "      <td>46</td>\n",
       "      <td>59</td>\n",
       "      <td>146</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Assistant Nursing Officer</th>\n",
       "      <td>113</td>\n",
       "      <td>126</td>\n",
       "      <td>114</td>\n",
       "      <td>505</td>\n",
       "      <td>136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Biomedical Technician/Technologist &amp; Engineers</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Clinical Assistant</th>\n",
       "      <td>34</td>\n",
       "      <td>32</td>\n",
       "      <td>41</td>\n",
       "      <td>102</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Clinical Officer</th>\n",
       "      <td>172</td>\n",
       "      <td>164</td>\n",
       "      <td>210</td>\n",
       "      <td>519</td>\n",
       "      <td>195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Laboratory Assistant</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Laboratory Scientist</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Laboratory Technician/Technologists</th>\n",
       "      <td>26</td>\n",
       "      <td>24</td>\n",
       "      <td>31</td>\n",
       "      <td>78</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Recorders</th>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Health Secretary</th>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>31</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Attendant</th>\n",
       "      <td>744</td>\n",
       "      <td>656</td>\n",
       "      <td>687</td>\n",
       "      <td>2072</td>\n",
       "      <td>714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Doctors</th>\n",
       "      <td>14</td>\n",
       "      <td>24</td>\n",
       "      <td>59</td>\n",
       "      <td>111</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical Specialist/Consultants</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>24</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nurses</th>\n",
       "      <td>656</td>\n",
       "      <td>729</td>\n",
       "      <td>987</td>\n",
       "      <td>1789</td>\n",
       "      <td>951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nursing Officer</th>\n",
       "      <td>53</td>\n",
       "      <td>28</td>\n",
       "      <td>126</td>\n",
       "      <td>164</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nutrition Officer</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmaceutical Technologist</th>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pharmacist</th>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Researchers</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Support Staff</th>\n",
       "      <td>177</td>\n",
       "      <td>113</td>\n",
       "      <td>111</td>\n",
       "      <td>558</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technicians &amp;Technologists</th>\n",
       "      <td>33</td>\n",
       "      <td>22</td>\n",
       "      <td>35</td>\n",
       "      <td>111</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     22      16     17  \\\n",
       "Region Cadre                                    Singida  Njombe  Pwani   \n",
       "Year                                               2014    2014   2014   \n",
       "Assistant Lab Tech                                   36      34     44   \n",
       "Assistant Medical Officer                            48      46     59   \n",
       "Assistant Nursing Officer                           113     126    114   \n",
       "Biomedical Technician/Technologist & Engineers        1       0      1   \n",
       "Clinical Assistant                                   34      32     41   \n",
       "Clinical Officer                                    172     164    210   \n",
       "Health Laboratory Assistant                           1       2      2   \n",
       "Health Laboratory Scientist                           0       0      3   \n",
       "Health Laboratory Technician/Technologists           26      24     31   \n",
       "Medical Recorders                                    13       6     16   \n",
       "Health Secretary                                     13      16     14   \n",
       "Medical Attendant                                   744     656    687   \n",
       "Medical Doctors                                      14      24     59   \n",
       "Medical Specialist/Consultants                        3       1     15   \n",
       "Nurses                                              656     729    987   \n",
       "Nursing Officer                                      53      28    126   \n",
       "Nutrition Officer                                     3       0      1   \n",
       "Pharmaceutical Technologist                           5      10      4   \n",
       "Pharmacist                                            4       9     18   \n",
       "Researchers                                           1       1      1   \n",
       "Support Staff                                       177     113    111   \n",
       "Technicians &Technologists                           33      22     35   \n",
       "\n",
       "                                                         8     11  \n",
       "Region Cadre                                    Kilimanjaro  Mara  \n",
       "Year                                                   2014  2014  \n",
       "Assistant Lab Tech                                      108    41  \n",
       "Assistant Medical Officer                               146    55  \n",
       "Assistant Nursing Officer                               505   136  \n",
       "Biomedical Technician/Technologist & Engineers            4     0  \n",
       "Clinical Assistant                                      102    39  \n",
       "Clinical Officer                                        519   195  \n",
       "Health Laboratory Assistant                               3     2  \n",
       "Health Laboratory Scientist                               9     0  \n",
       "Health Laboratory Technician/Technologists               78    29  \n",
       "Medical Recorders                                        56    11  \n",
       "Health Secretary                                         31    11  \n",
       "Medical Attendant                                      2072   714  \n",
       "Medical Doctors                                         111    33  \n",
       "Medical Specialist/Consultants                           24     4  \n",
       "Nurses                                                 1789   951  \n",
       "Nursing Officer                                         164    50  \n",
       "Nutrition Officer                                         4     2  \n",
       "Pharmaceutical Technologist                              30    18  \n",
       "Pharmacist                                               19     8  \n",
       "Researchers                                               2     1  \n",
       "Support Staff                                           558   116  \n",
       "Technicians &Technologists                              111    23  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avail_health_staff_important.sample(5).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 25 entries, 0 to 24\n",
      "Data columns (total 24 columns):\n",
      "Region Cadre                                      25 non-null object\n",
      "Year                                              25 non-null int64\n",
      "Assistant Lab Tech                                25 non-null int64\n",
      "Assistant Medical Officer                         25 non-null int64\n",
      "Assistant Nursing Officer                         25 non-null int64\n",
      "Biomedical Technician/Technologist & Engineers    25 non-null int64\n",
      "Clinical Assistant                                25 non-null int64\n",
      "Clinical Officer                                  25 non-null int64\n",
      "Health Laboratory Assistant                       25 non-null int64\n",
      "Health Laboratory Scientist                       25 non-null int64\n",
      "Health Laboratory Technician/Technologists        25 non-null int64\n",
      "Medical Recorders                                 25 non-null int64\n",
      "Health Secretary                                  25 non-null int64\n",
      "Medical Attendant                                 25 non-null int64\n",
      "Medical Doctors                                   25 non-null int64\n",
      "Medical Specialist/Consultants                    25 non-null int64\n",
      "Nurses                                            25 non-null int64\n",
      "Nursing Officer                                   25 non-null int64\n",
      "Nutrition Officer                                 25 non-null int64\n",
      "Pharmaceutical Technologist                       25 non-null int64\n",
      "Pharmacist                                        25 non-null int64\n",
      "Researchers                                       25 non-null int64\n",
      "Support Staff                                     25 non-null int64\n",
      "Technicians &Technologists                        25 non-null int64\n",
      "dtypes: int64(23), object(1)\n",
      "memory usage: 4.8+ KB\n"
     ]
    }
   ],
   "source": [
    "avail_health_staff_important.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "avail_health_staff_important.to_csv(\"more_cleaned_available_health_staff.csv\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python (myenv3.6.5)",
   "language": "python",
   "name": "myenv3.6.5"
  },
  "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}