gale_shapley.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "metadata": {},
   "outputs": [],
   "source": [
    "gps = pd.read_excel('HackathonDataNEW.xlsx', 'GradPreferences')\n",
    "rps = pd.read_excel('HackathonDataNEW.xlsx', 'TeamPreferences')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 249,
   "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>Teams</th>\n",
       "      <th>Number of Spaces</th>\n",
       "      <th>Grad Preference 1</th>\n",
       "      <th>Grad Preference 2</th>\n",
       "      <th>Grad Preference 3</th>\n",
       "      <th>Grad Preference 4</th>\n",
       "      <th>Grad Preference 5</th>\n",
       "      <th>Skill #1</th>\n",
       "      <th>Skill #2</th>\n",
       "      <th>Skill #3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Post Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Core Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Legal Software Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GTB: Trade Finance</td>\n",
       "      <td>1</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>abFX Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FX Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Python</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GTB Technology Surveillance</td>\n",
       "      <td>1</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>Java</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Financial Spreading Automation</td>\n",
       "      <td>3</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Aiza Currie</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Enterprise Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Python</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sales, Origination &amp; Advisory Information Tech...</td>\n",
       "      <td>1</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Python</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Stategic Analytics</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>FlowRisk</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Aiza Currie</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CIB Tech: Data</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRDS</td>\n",
       "      <td>1</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>GTB Instant Payments</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mercury Team</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>JavaScript</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Looking Glass</td>\n",
       "      <td>1</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Operations Automation</td>\n",
       "      <td>1</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Python</td>\n",
       "      <td>Machine Learning</td>\n",
       "      <td>Data science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CCNG</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C++</td>\n",
       "      <td>KDB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DbSyndicate</td>\n",
       "      <td>1</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Fixed Income &amp; Currencies Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Jarod Arias</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Distribution Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Equity Strats</td>\n",
       "      <td>1</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Finance &amp; Loan Agency</td>\n",
       "      <td>1</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Trade Services Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ratings Advisory Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>GT Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Test Delivery</td>\n",
       "      <td>1</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>GTO - Data Solutions &amp; Knowledge Visualisation</td>\n",
       "      <td>1</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JavaScript</td>\n",
       "      <td>React</td>\n",
       "      <td>SQL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Trade Finance Deal Management</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Cash Management Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>CIB Regulatory Adherence</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>HR Digital Development</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Finance - GVG</td>\n",
       "      <td>2</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>End User Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C#</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Vulnerability &amp; Compliance Remediation</td>\n",
       "      <td>1</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JavaScript</td>\n",
       "      <td>React</td>\n",
       "      <td>Python</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Transition &amp; Steering Office</td>\n",
       "      <td>1</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>SQL</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Enterprise Security Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Client Lifecycle Management</td>\n",
       "      <td>1</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>End User Services</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>AFC - Financial Crime Operations</td>\n",
       "      <td>2</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Java</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Trade Finance Operations</td>\n",
       "      <td>1</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JavaScript</td>\n",
       "      <td>Angular</td>\n",
       "      <td>Java</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Margin Loans</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Finance Control Oversight</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Teams  Number of Spaces  \\\n",
       "0                             Post Trading Technology                 1   \n",
       "1                             Core Trading Technology                 1   \n",
       "2                         Legal Software Architecture                 1   \n",
       "3                                  GTB: Trade Finance                 1   \n",
       "4                                     abFX Technology                 2   \n",
       "5                                  FX Risk Technology                 1   \n",
       "6                         GTB Technology Surveillance                 1   \n",
       "7                      Financial Spreading Automation                 3   \n",
       "8                          Enterprise Risk Technology                 1   \n",
       "9   Sales, Origination & Advisory Information Tech...                 1   \n",
       "10                                 Stategic Analytics                 1   \n",
       "11                                           FlowRisk                 1   \n",
       "12                                     CIB Tech: Data                 1   \n",
       "13                                               BRDS                 1   \n",
       "14                               GTB Instant Payments                 1   \n",
       "15                                       Mercury Team                 1   \n",
       "16                                      Looking Glass                 1   \n",
       "17                              Operations Automation                 1   \n",
       "18                                               CCNG                 1   \n",
       "19                                        DbSyndicate                 1   \n",
       "20               Fixed Income & Currencies Technology                 1   \n",
       "21                            Distribution Technology                 1   \n",
       "22                                      Equity Strats                 1   \n",
       "23                              Finance & Loan Agency                 1   \n",
       "24                          Trade Services Technology                 2   \n",
       "25                        Ratings Advisory Technology                 1   \n",
       "26                                      GT Production                 1   \n",
       "27                                     Test Delivery                  1   \n",
       "28     GTO - Data Solutions & Knowledge Visualisation                 1   \n",
       "29                      Trade Finance Deal Management                 1   \n",
       "30                         Cash Management Technology                 1   \n",
       "31                          CIB Regulatory Adherence                  1   \n",
       "32                            HR Digital Development                  2   \n",
       "33                                      Finance - GVG                 2   \n",
       "34                                End User Production                 1   \n",
       "35            Vulnerability & Compliance Remediation                  1   \n",
       "36                       Transition & Steering Office                 1   \n",
       "37                   Enterprise Security Architecture                 1   \n",
       "38                        Client Lifecycle Management                 1   \n",
       "39                                  End User Services                 1   \n",
       "40                   AFC - Financial Crime Operations                 2   \n",
       "41                           Trade Finance Operations                 1   \n",
       "42                                       Margin Loans                 1   \n",
       "43                          Finance Control Oversight                 1   \n",
       "\n",
       "     Grad Preference 1   Grad Preference 2   Grad Preference 3  \\\n",
       "0     Danyal Schofield         Ruth Holder                 NaN   \n",
       "1         Chanel Leech      Chelsey Magana          Shiv Rosas   \n",
       "2    Amy-Louise Conroy       Karson Waller         Melody Cook   \n",
       "3        Syed Thompson     Arissa Mcmillan       Willem Mcgill   \n",
       "4       Danny Connelly       Marlon Osborn       Tristan Hanna   \n",
       "5           Mia Morley     Courtnie Barker  Annabella Crawford   \n",
       "6         Briana Glass      Mathias Becker    Florrie Thornton   \n",
       "7           Shiv Rosas       Rio Wilkinson    Florrie Thornton   \n",
       "8          Melody Cook        Vishal Logan       Syed Thompson   \n",
       "9        Willem Mcgill        Lauren Chang       Willem Mcgill   \n",
       "10       Tristan Hanna          Alex Hulme        Vishal Logan   \n",
       "11  Annabella Crawford         Aiza Currie   Amy-Louise Conroy   \n",
       "12    Florrie Thornton       Maryam Lennon        Vishal Logan   \n",
       "13       Yolanda Tyson          Ivan Nixon      Derrick Sadler   \n",
       "14                 NaN                 NaN                 NaN   \n",
       "15       Everly Holman         Aida Curran          Mia Morley   \n",
       "16         Ruth Holder     Presley Sargent     Presley Sargent   \n",
       "17      Chelsey Magana       Anjali Bowden          Mia Morley   \n",
       "18       Karson Waller      Derrick Sadler       Yolanda Tyson   \n",
       "19     Arissa Mcmillan       Nabilah Miles    Caitlin Browning   \n",
       "20       Marlon Osborn         Jarod Arias                 NaN   \n",
       "21     Courtnie Barker   Amy-Louise Conroy                 NaN   \n",
       "22      Mathias Becker       Syed Thompson                 NaN   \n",
       "23       Rio Wilkinson      Danny Connelly   Amy-Louise Conroy   \n",
       "24      Danny Connelly          Mia Morley       Syed Thompson   \n",
       "25         Melody Cook        Briana Glass      Danny Connelly   \n",
       "26       Karson Waller          Shiv Rosas          Mia Morley   \n",
       "27      Derrick Sadler         Melody Cook        Briana Glass   \n",
       "28       Nabilah Miles                 NaN                 NaN   \n",
       "29                 NaN                 NaN                 NaN   \n",
       "30       Tristan Hanna  Annabella Crawford       Willem Mcgill   \n",
       "31  Annabella Crawford    Florrie Thornton       Tristan Hanna   \n",
       "32      Danny Connelly       Yolanda Tyson  Annabella Crawford   \n",
       "33       Maryam Lennon    Caitlin Browning    Florrie Thornton   \n",
       "34          Ivan Nixon       Everly Holman       Yolanda Tyson   \n",
       "35         Lesley West    Danyal Schofield       Karson Waller   \n",
       "36         Aida Curran        Chanel Leech     Arissa Mcmillan   \n",
       "37     Presley Sargent   Amy-Louise Conroy       Marlon Osborn   \n",
       "38       Anjali Bowden       Syed Thompson     Courtnie Barker   \n",
       "39    Florrie Thornton      Danny Connelly          Ivan Nixon   \n",
       "40       Yolanda Tyson          Mia Morley         Lesley West   \n",
       "41    Caitlin Browning        Briana Glass         Aida Curran   \n",
       "42       Everly Holman          Shiv Rosas     Presley Sargent   \n",
       "43  Annabella Crawford         Melody Cook       Anjali Bowden   \n",
       "\n",
       "   Grad Preference 4 Grad Preference 5    Skill #1         Skill #2   \\\n",
       "0                NaN               NaN          C#               SQL   \n",
       "1       Briana Glass               NaN         NaN               NaN   \n",
       "2   Caitlin Browning               NaN         NaN               NaN   \n",
       "3       Chanel Leech               NaN        Java               NaN   \n",
       "4     Chelsey Magana               NaN        Java               NaN   \n",
       "5        Ruth Holder               NaN      Python               NaN   \n",
       "6         Shiv Rosas        Alex Hulme        Java               SQL   \n",
       "7      Syed Thompson       Aiza Currie         SQL               NaN   \n",
       "8      Tristan Hanna     Maryam Lennon      Python               NaN   \n",
       "9       Vishal Logan        Ivan Nixon      Python               NaN   \n",
       "10     Willem Mcgill               NaN        Java               NaN   \n",
       "11     Yolanda Tyson               NaN         NaN               NaN   \n",
       "12               NaN               NaN         NaN               NaN   \n",
       "13               NaN               NaN        Java               SQL   \n",
       "14               NaN               NaN          C#               NaN   \n",
       "15               NaN               NaN          C#        JavaScript   \n",
       "16               NaN               NaN        Java               NaN   \n",
       "17               NaN               NaN      Python  Machine Learning   \n",
       "18               NaN               NaN         C++               KDB   \n",
       "19               NaN               NaN        Java               SQL   \n",
       "20               NaN               NaN        Java               NaN   \n",
       "21               NaN               NaN        Java               SQL   \n",
       "22               NaN               NaN         NaN               NaN   \n",
       "23               NaN               NaN         NaN               NaN   \n",
       "24               NaN               NaN         NaN               NaN   \n",
       "25               NaN               NaN         NaN               NaN   \n",
       "26               NaN               NaN        Java               NaN   \n",
       "27               NaN               NaN          C#               NaN   \n",
       "28               NaN               NaN  JavaScript             React   \n",
       "29               NaN               NaN         NaN               NaN   \n",
       "30               NaN               NaN        Java               NaN   \n",
       "31               NaN               NaN          C#               NaN   \n",
       "32     Rio Wilkinson               NaN        Java               NaN   \n",
       "33      Vishal Logan               NaN          C#               NaN   \n",
       "34      Lauren Chang               NaN          C#               NaN   \n",
       "35        Alex Hulme               NaN  JavaScript             React   \n",
       "36               NaN               NaN        Java               SQL   \n",
       "37     Maryam Lennon               NaN        Java               NaN   \n",
       "38        Ivan Nixon               NaN           C               NaN   \n",
       "39               NaN               NaN         NaN               NaN   \n",
       "40               NaN               NaN        Java               NaN   \n",
       "41               NaN               NaN  JavaScript           Angular   \n",
       "42               NaN               NaN         NaN               NaN   \n",
       "43               NaN               NaN         NaN               NaN   \n",
       "\n",
       "        Skill #3  \n",
       "0            NaN  \n",
       "1            NaN  \n",
       "2            NaN  \n",
       "3            NaN  \n",
       "4            NaN  \n",
       "5            NaN  \n",
       "6            NaN  \n",
       "7            NaN  \n",
       "8            NaN  \n",
       "9            NaN  \n",
       "10           NaN  \n",
       "11           NaN  \n",
       "12           NaN  \n",
       "13           NaN  \n",
       "14           NaN  \n",
       "15           NaN  \n",
       "16           NaN  \n",
       "17  Data science  \n",
       "18           NaN  \n",
       "19           NaN  \n",
       "20           NaN  \n",
       "21           NaN  \n",
       "22           NaN  \n",
       "23           NaN  \n",
       "24           NaN  \n",
       "25           NaN  \n",
       "26           NaN  \n",
       "27           NaN  \n",
       "28           SQL  \n",
       "29           NaN  \n",
       "30           NaN  \n",
       "31           NaN  \n",
       "32           NaN  \n",
       "33           NaN  \n",
       "34           NaN  \n",
       "35        Python  \n",
       "36           NaN  \n",
       "37           NaN  \n",
       "38           NaN  \n",
       "39           NaN  \n",
       "40           NaN  \n",
       "41          Java  \n",
       "42           NaN  \n",
       "43           NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(rps)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 250,
   "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>Teams</th>\n",
       "      <th>Number of Spaces</th>\n",
       "      <th>Grad Preference 1</th>\n",
       "      <th>Grad Preference 2</th>\n",
       "      <th>Grad Preference 3</th>\n",
       "      <th>Grad Preference 4</th>\n",
       "      <th>Grad Preference 5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Post Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Core Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Legal Software Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GTB: Trade Finance</td>\n",
       "      <td>1</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>abFX Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FX Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GTB Technology Surveillance</td>\n",
       "      <td>1</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Alex Hulme</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Financial Spreading Automation</td>\n",
       "      <td>3</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Aiza Currie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Enterprise Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sales, Origination &amp; Advisory Information Tech...</td>\n",
       "      <td>1</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Stategic Analytics</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>FlowRisk</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Aiza Currie</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CIB Tech: Data</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRDS</td>\n",
       "      <td>1</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>GTB Instant Payments</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mercury Team</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Looking Glass</td>\n",
       "      <td>1</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Operations Automation</td>\n",
       "      <td>1</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CCNG</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DbSyndicate</td>\n",
       "      <td>1</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Fixed Income &amp; Currencies Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Jarod Arias</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Distribution Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Equity Strats</td>\n",
       "      <td>1</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Finance &amp; Loan Agency</td>\n",
       "      <td>1</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Trade Services Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ratings Advisory Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>GT Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Test Delivery</td>\n",
       "      <td>1</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>GTO - Data Solutions &amp; Knowledge Visualisation</td>\n",
       "      <td>1</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Trade Finance Deal Management</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Cash Management Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>CIB Regulatory Adherence</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>HR Digital Development</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Finance - GVG</td>\n",
       "      <td>2</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>End User Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Vulnerability &amp; Compliance Remediation</td>\n",
       "      <td>1</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Transition &amp; Steering Office</td>\n",
       "      <td>1</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Enterprise Security Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Client Lifecycle Management</td>\n",
       "      <td>1</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>End User Services</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>AFC - Financial Crime Operations</td>\n",
       "      <td>2</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Trade Finance Operations</td>\n",
       "      <td>1</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Margin Loans</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Finance Control Oversight</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Teams  Number of Spaces  \\\n",
       "0                             Post Trading Technology                 1   \n",
       "1                             Core Trading Technology                 1   \n",
       "2                         Legal Software Architecture                 1   \n",
       "3                                  GTB: Trade Finance                 1   \n",
       "4                                     abFX Technology                 2   \n",
       "5                                  FX Risk Technology                 1   \n",
       "6                         GTB Technology Surveillance                 1   \n",
       "7                      Financial Spreading Automation                 3   \n",
       "8                          Enterprise Risk Technology                 1   \n",
       "9   Sales, Origination & Advisory Information Tech...                 1   \n",
       "10                                 Stategic Analytics                 1   \n",
       "11                                           FlowRisk                 1   \n",
       "12                                     CIB Tech: Data                 1   \n",
       "13                                               BRDS                 1   \n",
       "14                               GTB Instant Payments                 1   \n",
       "15                                       Mercury Team                 1   \n",
       "16                                      Looking Glass                 1   \n",
       "17                              Operations Automation                 1   \n",
       "18                                               CCNG                 1   \n",
       "19                                        DbSyndicate                 1   \n",
       "20               Fixed Income & Currencies Technology                 1   \n",
       "21                            Distribution Technology                 1   \n",
       "22                                      Equity Strats                 1   \n",
       "23                              Finance & Loan Agency                 1   \n",
       "24                          Trade Services Technology                 2   \n",
       "25                        Ratings Advisory Technology                 1   \n",
       "26                                      GT Production                 1   \n",
       "27                                     Test Delivery                  1   \n",
       "28     GTO - Data Solutions & Knowledge Visualisation                 1   \n",
       "29                      Trade Finance Deal Management                 1   \n",
       "30                         Cash Management Technology                 1   \n",
       "31                          CIB Regulatory Adherence                  1   \n",
       "32                            HR Digital Development                  2   \n",
       "33                                      Finance - GVG                 2   \n",
       "34                                End User Production                 1   \n",
       "35            Vulnerability & Compliance Remediation                  1   \n",
       "36                       Transition & Steering Office                 1   \n",
       "37                   Enterprise Security Architecture                 1   \n",
       "38                        Client Lifecycle Management                 1   \n",
       "39                                  End User Services                 1   \n",
       "40                   AFC - Financial Crime Operations                 2   \n",
       "41                           Trade Finance Operations                 1   \n",
       "42                                       Margin Loans                 1   \n",
       "43                          Finance Control Oversight                 1   \n",
       "\n",
       "     Grad Preference 1   Grad Preference 2   Grad Preference 3  \\\n",
       "0     Danyal Schofield         Ruth Holder                 NaN   \n",
       "1         Chanel Leech      Chelsey Magana          Shiv Rosas   \n",
       "2    Amy-Louise Conroy       Karson Waller         Melody Cook   \n",
       "3        Syed Thompson     Arissa Mcmillan       Willem Mcgill   \n",
       "4       Danny Connelly       Marlon Osborn       Tristan Hanna   \n",
       "5           Mia Morley     Courtnie Barker  Annabella Crawford   \n",
       "6         Briana Glass      Mathias Becker    Florrie Thornton   \n",
       "7           Shiv Rosas       Rio Wilkinson    Florrie Thornton   \n",
       "8          Melody Cook        Vishal Logan       Syed Thompson   \n",
       "9        Willem Mcgill        Lauren Chang       Willem Mcgill   \n",
       "10       Tristan Hanna          Alex Hulme        Vishal Logan   \n",
       "11  Annabella Crawford         Aiza Currie   Amy-Louise Conroy   \n",
       "12    Florrie Thornton       Maryam Lennon        Vishal Logan   \n",
       "13       Yolanda Tyson          Ivan Nixon      Derrick Sadler   \n",
       "14                 NaN                 NaN                 NaN   \n",
       "15       Everly Holman         Aida Curran          Mia Morley   \n",
       "16         Ruth Holder     Presley Sargent     Presley Sargent   \n",
       "17      Chelsey Magana       Anjali Bowden          Mia Morley   \n",
       "18       Karson Waller      Derrick Sadler       Yolanda Tyson   \n",
       "19     Arissa Mcmillan       Nabilah Miles    Caitlin Browning   \n",
       "20       Marlon Osborn         Jarod Arias                 NaN   \n",
       "21     Courtnie Barker   Amy-Louise Conroy                 NaN   \n",
       "22      Mathias Becker       Syed Thompson                 NaN   \n",
       "23       Rio Wilkinson      Danny Connelly   Amy-Louise Conroy   \n",
       "24      Danny Connelly          Mia Morley       Syed Thompson   \n",
       "25         Melody Cook        Briana Glass      Danny Connelly   \n",
       "26       Karson Waller          Shiv Rosas          Mia Morley   \n",
       "27      Derrick Sadler         Melody Cook        Briana Glass   \n",
       "28       Nabilah Miles                 NaN                 NaN   \n",
       "29                 NaN                 NaN                 NaN   \n",
       "30       Tristan Hanna  Annabella Crawford       Willem Mcgill   \n",
       "31  Annabella Crawford    Florrie Thornton       Tristan Hanna   \n",
       "32      Danny Connelly       Yolanda Tyson  Annabella Crawford   \n",
       "33       Maryam Lennon    Caitlin Browning    Florrie Thornton   \n",
       "34          Ivan Nixon       Everly Holman       Yolanda Tyson   \n",
       "35         Lesley West    Danyal Schofield       Karson Waller   \n",
       "36         Aida Curran        Chanel Leech     Arissa Mcmillan   \n",
       "37     Presley Sargent   Amy-Louise Conroy       Marlon Osborn   \n",
       "38       Anjali Bowden       Syed Thompson     Courtnie Barker   \n",
       "39    Florrie Thornton      Danny Connelly          Ivan Nixon   \n",
       "40       Yolanda Tyson          Mia Morley         Lesley West   \n",
       "41    Caitlin Browning        Briana Glass         Aida Curran   \n",
       "42       Everly Holman          Shiv Rosas     Presley Sargent   \n",
       "43  Annabella Crawford         Melody Cook       Anjali Bowden   \n",
       "\n",
       "   Grad Preference 4 Grad Preference 5  \n",
       "0                NaN               NaN  \n",
       "1       Briana Glass               NaN  \n",
       "2   Caitlin Browning               NaN  \n",
       "3       Chanel Leech               NaN  \n",
       "4     Chelsey Magana               NaN  \n",
       "5        Ruth Holder               NaN  \n",
       "6         Shiv Rosas        Alex Hulme  \n",
       "7      Syed Thompson       Aiza Currie  \n",
       "8      Tristan Hanna     Maryam Lennon  \n",
       "9       Vishal Logan        Ivan Nixon  \n",
       "10     Willem Mcgill               NaN  \n",
       "11     Yolanda Tyson               NaN  \n",
       "12               NaN               NaN  \n",
       "13               NaN               NaN  \n",
       "14               NaN               NaN  \n",
       "15               NaN               NaN  \n",
       "16               NaN               NaN  \n",
       "17               NaN               NaN  \n",
       "18               NaN               NaN  \n",
       "19               NaN               NaN  \n",
       "20               NaN               NaN  \n",
       "21               NaN               NaN  \n",
       "22               NaN               NaN  \n",
       "23               NaN               NaN  \n",
       "24               NaN               NaN  \n",
       "25               NaN               NaN  \n",
       "26               NaN               NaN  \n",
       "27               NaN               NaN  \n",
       "28               NaN               NaN  \n",
       "29               NaN               NaN  \n",
       "30               NaN               NaN  \n",
       "31               NaN               NaN  \n",
       "32     Rio Wilkinson               NaN  \n",
       "33      Vishal Logan               NaN  \n",
       "34      Lauren Chang               NaN  \n",
       "35        Alex Hulme               NaN  \n",
       "36               NaN               NaN  \n",
       "37     Maryam Lennon               NaN  \n",
       "38        Ivan Nixon               NaN  \n",
       "39               NaN               NaN  \n",
       "40               NaN               NaN  \n",
       "41               NaN               NaN  \n",
       "42               NaN               NaN  \n",
       "43               NaN               NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def remove_skill_columns(df):\n",
    "    skill_columns = [col for col in df.columns if 'Skill' in col]\n",
    "    df.drop(axis=1, columns=skill_columns, inplace=True)\n",
    "    return df\n",
    "\n",
    "gps = remove_skill_columns(gps)\n",
    "rps = remove_skill_columns(rps)\n",
    "display(rps)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 251,
   "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>t</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Post Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Core Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Legal Software Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GTB: Trade Finance</td>\n",
       "      <td>1</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>abFX Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FX Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GTB Technology Surveillance</td>\n",
       "      <td>1</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Alex Hulme</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Financial Spreading Automation</td>\n",
       "      <td>3</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Aiza Currie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Enterprise Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sales, Origination &amp; Advisory Information Tech...</td>\n",
       "      <td>1</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Stategic Analytics</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>FlowRisk</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Aiza Currie</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CIB Tech: Data</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRDS</td>\n",
       "      <td>1</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>GTB Instant Payments</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mercury Team</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Looking Glass</td>\n",
       "      <td>1</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Operations Automation</td>\n",
       "      <td>1</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CCNG</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DbSyndicate</td>\n",
       "      <td>1</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Fixed Income &amp; Currencies Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Jarod Arias</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Distribution Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Equity Strats</td>\n",
       "      <td>1</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Finance &amp; Loan Agency</td>\n",
       "      <td>1</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Trade Services Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ratings Advisory Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>GT Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Test Delivery</td>\n",
       "      <td>1</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>GTO - Data Solutions &amp; Knowledge Visualisation</td>\n",
       "      <td>1</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Trade Finance Deal Management</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Cash Management Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>CIB Regulatory Adherence</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>HR Digital Development</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Finance - GVG</td>\n",
       "      <td>2</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>End User Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Vulnerability &amp; Compliance Remediation</td>\n",
       "      <td>1</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Transition &amp; Steering Office</td>\n",
       "      <td>1</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Enterprise Security Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Client Lifecycle Management</td>\n",
       "      <td>1</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>End User Services</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>AFC - Financial Crime Operations</td>\n",
       "      <td>2</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Trade Finance Operations</td>\n",
       "      <td>1</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Margin Loans</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Finance Control Oversight</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    t  1                   2  \\\n",
       "0                             Post Trading Technology  1    Danyal Schofield   \n",
       "1                             Core Trading Technology  1        Chanel Leech   \n",
       "2                         Legal Software Architecture  1   Amy-Louise Conroy   \n",
       "3                                  GTB: Trade Finance  1       Syed Thompson   \n",
       "4                                     abFX Technology  2      Danny Connelly   \n",
       "5                                  FX Risk Technology  1          Mia Morley   \n",
       "6                         GTB Technology Surveillance  1        Briana Glass   \n",
       "7                      Financial Spreading Automation  3          Shiv Rosas   \n",
       "8                          Enterprise Risk Technology  1         Melody Cook   \n",
       "9   Sales, Origination & Advisory Information Tech...  1       Willem Mcgill   \n",
       "10                                 Stategic Analytics  1       Tristan Hanna   \n",
       "11                                           FlowRisk  1  Annabella Crawford   \n",
       "12                                     CIB Tech: Data  1    Florrie Thornton   \n",
       "13                                               BRDS  1       Yolanda Tyson   \n",
       "14                               GTB Instant Payments  1                 NaN   \n",
       "15                                       Mercury Team  1       Everly Holman   \n",
       "16                                      Looking Glass  1         Ruth Holder   \n",
       "17                              Operations Automation  1      Chelsey Magana   \n",
       "18                                               CCNG  1       Karson Waller   \n",
       "19                                        DbSyndicate  1     Arissa Mcmillan   \n",
       "20               Fixed Income & Currencies Technology  1       Marlon Osborn   \n",
       "21                            Distribution Technology  1     Courtnie Barker   \n",
       "22                                      Equity Strats  1      Mathias Becker   \n",
       "23                              Finance & Loan Agency  1       Rio Wilkinson   \n",
       "24                          Trade Services Technology  2      Danny Connelly   \n",
       "25                        Ratings Advisory Technology  1         Melody Cook   \n",
       "26                                      GT Production  1       Karson Waller   \n",
       "27                                     Test Delivery   1      Derrick Sadler   \n",
       "28     GTO - Data Solutions & Knowledge Visualisation  1       Nabilah Miles   \n",
       "29                      Trade Finance Deal Management  1                 NaN   \n",
       "30                         Cash Management Technology  1       Tristan Hanna   \n",
       "31                          CIB Regulatory Adherence   1  Annabella Crawford   \n",
       "32                            HR Digital Development   2      Danny Connelly   \n",
       "33                                      Finance - GVG  2       Maryam Lennon   \n",
       "34                                End User Production  1          Ivan Nixon   \n",
       "35            Vulnerability & Compliance Remediation   1         Lesley West   \n",
       "36                       Transition & Steering Office  1         Aida Curran   \n",
       "37                   Enterprise Security Architecture  1     Presley Sargent   \n",
       "38                        Client Lifecycle Management  1       Anjali Bowden   \n",
       "39                                  End User Services  1    Florrie Thornton   \n",
       "40                   AFC - Financial Crime Operations  2       Yolanda Tyson   \n",
       "41                           Trade Finance Operations  1    Caitlin Browning   \n",
       "42                                       Margin Loans  1       Everly Holman   \n",
       "43                          Finance Control Oversight  1  Annabella Crawford   \n",
       "\n",
       "                     3                   4                 5              6  \n",
       "0          Ruth Holder                 NaN               NaN            NaN  \n",
       "1       Chelsey Magana          Shiv Rosas      Briana Glass            NaN  \n",
       "2        Karson Waller         Melody Cook  Caitlin Browning            NaN  \n",
       "3      Arissa Mcmillan       Willem Mcgill      Chanel Leech            NaN  \n",
       "4        Marlon Osborn       Tristan Hanna    Chelsey Magana            NaN  \n",
       "5      Courtnie Barker  Annabella Crawford       Ruth Holder            NaN  \n",
       "6       Mathias Becker    Florrie Thornton        Shiv Rosas     Alex Hulme  \n",
       "7        Rio Wilkinson    Florrie Thornton     Syed Thompson    Aiza Currie  \n",
       "8         Vishal Logan       Syed Thompson     Tristan Hanna  Maryam Lennon  \n",
       "9         Lauren Chang       Willem Mcgill      Vishal Logan     Ivan Nixon  \n",
       "10          Alex Hulme        Vishal Logan     Willem Mcgill            NaN  \n",
       "11         Aiza Currie   Amy-Louise Conroy     Yolanda Tyson            NaN  \n",
       "12       Maryam Lennon        Vishal Logan               NaN            NaN  \n",
       "13          Ivan Nixon      Derrick Sadler               NaN            NaN  \n",
       "14                 NaN                 NaN               NaN            NaN  \n",
       "15         Aida Curran          Mia Morley               NaN            NaN  \n",
       "16     Presley Sargent     Presley Sargent               NaN            NaN  \n",
       "17       Anjali Bowden          Mia Morley               NaN            NaN  \n",
       "18      Derrick Sadler       Yolanda Tyson               NaN            NaN  \n",
       "19       Nabilah Miles    Caitlin Browning               NaN            NaN  \n",
       "20         Jarod Arias                 NaN               NaN            NaN  \n",
       "21   Amy-Louise Conroy                 NaN               NaN            NaN  \n",
       "22       Syed Thompson                 NaN               NaN            NaN  \n",
       "23      Danny Connelly   Amy-Louise Conroy               NaN            NaN  \n",
       "24          Mia Morley       Syed Thompson               NaN            NaN  \n",
       "25        Briana Glass      Danny Connelly               NaN            NaN  \n",
       "26          Shiv Rosas          Mia Morley               NaN            NaN  \n",
       "27         Melody Cook        Briana Glass               NaN            NaN  \n",
       "28                 NaN                 NaN               NaN            NaN  \n",
       "29                 NaN                 NaN               NaN            NaN  \n",
       "30  Annabella Crawford       Willem Mcgill               NaN            NaN  \n",
       "31    Florrie Thornton       Tristan Hanna               NaN            NaN  \n",
       "32       Yolanda Tyson  Annabella Crawford     Rio Wilkinson            NaN  \n",
       "33    Caitlin Browning    Florrie Thornton      Vishal Logan            NaN  \n",
       "34       Everly Holman       Yolanda Tyson      Lauren Chang            NaN  \n",
       "35    Danyal Schofield       Karson Waller        Alex Hulme            NaN  \n",
       "36        Chanel Leech     Arissa Mcmillan               NaN            NaN  \n",
       "37   Amy-Louise Conroy       Marlon Osborn     Maryam Lennon            NaN  \n",
       "38       Syed Thompson     Courtnie Barker        Ivan Nixon            NaN  \n",
       "39      Danny Connelly          Ivan Nixon               NaN            NaN  \n",
       "40          Mia Morley         Lesley West               NaN            NaN  \n",
       "41        Briana Glass         Aida Curran               NaN            NaN  \n",
       "42          Shiv Rosas     Presley Sargent               NaN            NaN  \n",
       "43         Melody Cook       Anjali Bowden               NaN            NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def change_column_names(df, label):\n",
    "    c = [n for n in range(len(df.columns))]\n",
    "    c[0] = label\n",
    "    df.columns = c\n",
    "    return df\n",
    "\n",
    "gps = change_column_names(gps, 'g')\n",
    "rps = change_column_names(rps, 't')\n",
    "display(rps)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 252,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_mappings(df):\n",
    "    \n",
    "    # create numerical values to map to\n",
    "    mapping = pd.Series(df.iloc[:,0].unique())\n",
    "    mapping = mapping.to_dict()\n",
    "    \n",
    "    # flip dictionary\n",
    "    inv_mapping = {v: k for k, v in mapping.items()}\n",
    "    \n",
    "    return inv_mapping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 253,
   "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>t</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Post Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Core Trading Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Legal Software Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GTB: Trade Finance</td>\n",
       "      <td>1</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>abFX Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FX Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GTB Technology Surveillance</td>\n",
       "      <td>1</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Alex Hulme</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Financial Spreading Automation</td>\n",
       "      <td>3</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Aiza Currie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Enterprise Risk Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Sales, Origination &amp; Advisory Information Tech...</td>\n",
       "      <td>1</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Stategic Analytics</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>FlowRisk</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Aiza Currie</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CIB Tech: Data</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRDS</td>\n",
       "      <td>1</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>GTB Instant Payments</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mercury Team</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Looking Glass</td>\n",
       "      <td>1</td>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Operations Automation</td>\n",
       "      <td>1</td>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CCNG</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DbSyndicate</td>\n",
       "      <td>1</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Fixed Income &amp; Currencies Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Jarod Arias</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Distribution Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Equity Strats</td>\n",
       "      <td>1</td>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Finance &amp; Loan Agency</td>\n",
       "      <td>1</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Trade Services Technology</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ratings Advisory Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>GT Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Test Delivery</td>\n",
       "      <td>1</td>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>GTO - Data Solutions &amp; Knowledge Visualisation</td>\n",
       "      <td>1</td>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Trade Finance Deal Management</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Cash Management Technology</td>\n",
       "      <td>1</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>CIB Regulatory Adherence</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>HR Digital Development</td>\n",
       "      <td>2</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Finance - GVG</td>\n",
       "      <td>2</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>End User Production</td>\n",
       "      <td>1</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Vulnerability &amp; Compliance Remediation</td>\n",
       "      <td>1</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Transition &amp; Steering Office</td>\n",
       "      <td>1</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Enterprise Security Architecture</td>\n",
       "      <td>1</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Client Lifecycle Management</td>\n",
       "      <td>1</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>End User Services</td>\n",
       "      <td>1</td>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>AFC - Financial Crime Operations</td>\n",
       "      <td>2</td>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>Lesley West</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Trade Finance Operations</td>\n",
       "      <td>1</td>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Margin Loans</td>\n",
       "      <td>1</td>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Finance Control Oversight</td>\n",
       "      <td>1</td>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    t  1                   2  \\\n",
       "0                             Post Trading Technology  1    Danyal Schofield   \n",
       "1                             Core Trading Technology  1        Chanel Leech   \n",
       "2                         Legal Software Architecture  1   Amy-Louise Conroy   \n",
       "3                                  GTB: Trade Finance  1       Syed Thompson   \n",
       "4                                     abFX Technology  2      Danny Connelly   \n",
       "5                                  FX Risk Technology  1          Mia Morley   \n",
       "6                         GTB Technology Surveillance  1        Briana Glass   \n",
       "7                      Financial Spreading Automation  3          Shiv Rosas   \n",
       "8                          Enterprise Risk Technology  1         Melody Cook   \n",
       "9   Sales, Origination & Advisory Information Tech...  1       Willem Mcgill   \n",
       "10                                 Stategic Analytics  1       Tristan Hanna   \n",
       "11                                           FlowRisk  1  Annabella Crawford   \n",
       "12                                     CIB Tech: Data  1    Florrie Thornton   \n",
       "13                                               BRDS  1       Yolanda Tyson   \n",
       "14                               GTB Instant Payments  1                 NaN   \n",
       "15                                       Mercury Team  1       Everly Holman   \n",
       "16                                      Looking Glass  1         Ruth Holder   \n",
       "17                              Operations Automation  1      Chelsey Magana   \n",
       "18                                               CCNG  1       Karson Waller   \n",
       "19                                        DbSyndicate  1     Arissa Mcmillan   \n",
       "20               Fixed Income & Currencies Technology  1       Marlon Osborn   \n",
       "21                            Distribution Technology  1     Courtnie Barker   \n",
       "22                                      Equity Strats  1      Mathias Becker   \n",
       "23                              Finance & Loan Agency  1       Rio Wilkinson   \n",
       "24                          Trade Services Technology  2      Danny Connelly   \n",
       "25                        Ratings Advisory Technology  1         Melody Cook   \n",
       "26                                      GT Production  1       Karson Waller   \n",
       "27                                     Test Delivery   1      Derrick Sadler   \n",
       "28     GTO - Data Solutions & Knowledge Visualisation  1       Nabilah Miles   \n",
       "29                      Trade Finance Deal Management  1                 NaN   \n",
       "30                         Cash Management Technology  1       Tristan Hanna   \n",
       "31                          CIB Regulatory Adherence   1  Annabella Crawford   \n",
       "32                            HR Digital Development   2      Danny Connelly   \n",
       "33                                      Finance - GVG  2       Maryam Lennon   \n",
       "34                                End User Production  1          Ivan Nixon   \n",
       "35            Vulnerability & Compliance Remediation   1         Lesley West   \n",
       "36                       Transition & Steering Office  1         Aida Curran   \n",
       "37                   Enterprise Security Architecture  1     Presley Sargent   \n",
       "38                        Client Lifecycle Management  1       Anjali Bowden   \n",
       "39                                  End User Services  1    Florrie Thornton   \n",
       "40                   AFC - Financial Crime Operations  2       Yolanda Tyson   \n",
       "41                           Trade Finance Operations  1    Caitlin Browning   \n",
       "42                                       Margin Loans  1       Everly Holman   \n",
       "43                          Finance Control Oversight  1  Annabella Crawford   \n",
       "\n",
       "                     3                   4                 5              6  \n",
       "0          Ruth Holder                 NaN               NaN            NaN  \n",
       "1       Chelsey Magana          Shiv Rosas      Briana Glass            NaN  \n",
       "2        Karson Waller         Melody Cook  Caitlin Browning            NaN  \n",
       "3      Arissa Mcmillan       Willem Mcgill      Chanel Leech            NaN  \n",
       "4        Marlon Osborn       Tristan Hanna    Chelsey Magana            NaN  \n",
       "5      Courtnie Barker  Annabella Crawford       Ruth Holder            NaN  \n",
       "6       Mathias Becker    Florrie Thornton        Shiv Rosas     Alex Hulme  \n",
       "7        Rio Wilkinson    Florrie Thornton     Syed Thompson    Aiza Currie  \n",
       "8         Vishal Logan       Syed Thompson     Tristan Hanna  Maryam Lennon  \n",
       "9         Lauren Chang       Willem Mcgill      Vishal Logan     Ivan Nixon  \n",
       "10          Alex Hulme        Vishal Logan     Willem Mcgill            NaN  \n",
       "11         Aiza Currie   Amy-Louise Conroy     Yolanda Tyson            NaN  \n",
       "12       Maryam Lennon        Vishal Logan               NaN            NaN  \n",
       "13          Ivan Nixon      Derrick Sadler               NaN            NaN  \n",
       "14                 NaN                 NaN               NaN            NaN  \n",
       "15         Aida Curran          Mia Morley               NaN            NaN  \n",
       "16     Presley Sargent     Presley Sargent               NaN            NaN  \n",
       "17       Anjali Bowden          Mia Morley               NaN            NaN  \n",
       "18      Derrick Sadler       Yolanda Tyson               NaN            NaN  \n",
       "19       Nabilah Miles    Caitlin Browning               NaN            NaN  \n",
       "20         Jarod Arias                 NaN               NaN            NaN  \n",
       "21   Amy-Louise Conroy                 NaN               NaN            NaN  \n",
       "22       Syed Thompson                 NaN               NaN            NaN  \n",
       "23      Danny Connelly   Amy-Louise Conroy               NaN            NaN  \n",
       "24          Mia Morley       Syed Thompson               NaN            NaN  \n",
       "25        Briana Glass      Danny Connelly               NaN            NaN  \n",
       "26          Shiv Rosas          Mia Morley               NaN            NaN  \n",
       "27         Melody Cook        Briana Glass               NaN            NaN  \n",
       "28                 NaN                 NaN               NaN            NaN  \n",
       "29                 NaN                 NaN               NaN            NaN  \n",
       "30  Annabella Crawford       Willem Mcgill               NaN            NaN  \n",
       "31    Florrie Thornton       Tristan Hanna               NaN            NaN  \n",
       "32       Yolanda Tyson  Annabella Crawford     Rio Wilkinson            NaN  \n",
       "33    Caitlin Browning    Florrie Thornton      Vishal Logan            NaN  \n",
       "34       Everly Holman       Yolanda Tyson      Lauren Chang            NaN  \n",
       "35    Danyal Schofield       Karson Waller        Alex Hulme            NaN  \n",
       "36        Chanel Leech     Arissa Mcmillan               NaN            NaN  \n",
       "37   Amy-Louise Conroy       Marlon Osborn     Maryam Lennon            NaN  \n",
       "38       Syed Thompson     Courtnie Barker        Ivan Nixon            NaN  \n",
       "39      Danny Connelly          Ivan Nixon               NaN            NaN  \n",
       "40          Mia Morley         Lesley West               NaN            NaN  \n",
       "41        Briana Glass         Aida Curran               NaN            NaN  \n",
       "42          Shiv Rosas     Presley Sargent               NaN            NaN  \n",
       "43         Melody Cook       Anjali Bowden               NaN            NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(rps)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "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>g</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Danyal Schofield</td>\n",
       "      <td>Tax Technology</td>\n",
       "      <td>36</td>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Chanel Leech</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>43</td>\n",
       "      <td>40</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Amy-Louise Conroy</td>\n",
       "      <td>1</td>\n",
       "      <td>38</td>\n",
       "      <td>7</td>\n",
       "      <td>13</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Syed Thompson</td>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>20</td>\n",
       "      <td>30</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Danny Connelly</td>\n",
       "      <td>3</td>\n",
       "      <td>40</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Mia Morley</td>\n",
       "      <td>4</td>\n",
       "      <td>41</td>\n",
       "      <td>5</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Briana Glass</td>\n",
       "      <td>5</td>\n",
       "      <td>14</td>\n",
       "      <td>26</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Shiv Rosas</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>21</td>\n",
       "      <td>38</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Melody Cook</td>\n",
       "      <td>7</td>\n",
       "      <td>15</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Willem Mcgill</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Tristan Hanna</td>\n",
       "      <td>9</td>\n",
       "      <td>17</td>\n",
       "      <td>28</td>\n",
       "      <td>21</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Annabella Crawford</td>\n",
       "      <td>10</td>\n",
       "      <td>18</td>\n",
       "      <td>32</td>\n",
       "      <td>34</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Florrie Thornton</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Yolanda Tyson</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>16</td>\n",
       "      <td>14</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Caitlin Browning</td>\n",
       "      <td>14</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>6</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Everly Holman</td>\n",
       "      <td>14</td>\n",
       "      <td>22</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ruth Holder</td>\n",
       "      <td>15</td>\n",
       "      <td>23</td>\n",
       "      <td>17</td>\n",
       "      <td>28</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chelsey Magana</td>\n",
       "      <td>16</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Karson Waller</td>\n",
       "      <td>17</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Arissa Mcmillan</td>\n",
       "      <td>18</td>\n",
       "      <td>26</td>\n",
       "      <td>9</td>\n",
       "      <td>16</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Marlon Osborn</td>\n",
       "      <td>19</td>\n",
       "      <td>27</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Courtnie Barker</td>\n",
       "      <td>20</td>\n",
       "      <td>28</td>\n",
       "      <td>Tax Technology</td>\n",
       "      <td>15</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Mathias Becker</td>\n",
       "      <td>21</td>\n",
       "      <td>29</td>\n",
       "      <td>27</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Rio Wilkinson</td>\n",
       "      <td>22</td>\n",
       "      <td>30</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Vishal Logan</td>\n",
       "      <td>23</td>\n",
       "      <td>31</td>\n",
       "      <td>41</td>\n",
       "      <td>25</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Lauren Chang</td>\n",
       "      <td>14</td>\n",
       "      <td>32</td>\n",
       "      <td>24</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Alex Hulme</td>\n",
       "      <td>25</td>\n",
       "      <td>33</td>\n",
       "      <td>36</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Aiza Currie</td>\n",
       "      <td>26</td>\n",
       "      <td>34</td>\n",
       "      <td>35</td>\n",
       "      <td>16</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Maryam Lennon</td>\n",
       "      <td>27</td>\n",
       "      <td>35</td>\n",
       "      <td>31</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Ivan Nixon</td>\n",
       "      <td>28</td>\n",
       "      <td>36</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Lesley West</td>\n",
       "      <td>29</td>\n",
       "      <td>37</td>\n",
       "      <td>38</td>\n",
       "      <td>19</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Aida Curran</td>\n",
       "      <td>30</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Presley Sargent</td>\n",
       "      <td>31</td>\n",
       "      <td>39</td>\n",
       "      <td>19</td>\n",
       "      <td>21</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Anjali Bowden</td>\n",
       "      <td>32</td>\n",
       "      <td>40</td>\n",
       "      <td>21</td>\n",
       "      <td>22</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Derrick Sadler</td>\n",
       "      <td>33</td>\n",
       "      <td>41</td>\n",
       "      <td>34</td>\n",
       "      <td>23</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Nabilah Miles</td>\n",
       "      <td>34</td>\n",
       "      <td>14</td>\n",
       "      <td>39</td>\n",
       "      <td>24</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Jarod Arias</td>\n",
       "      <td>35</td>\n",
       "      <td>13</td>\n",
       "      <td>8</td>\n",
       "      <td>25</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     g               1   2               3   4   5\n",
       "0     Danyal Schofield  Tax Technology  36              23   4  37\n",
       "1         Chanel Leech               0  37              43  40  22\n",
       "2    Amy-Louise Conroy               1  38               7  13  33\n",
       "3        Syed Thompson               2  39              20  30  23\n",
       "4       Danny Connelly               3  40              11  18  43\n",
       "5           Mia Morley               4  41               5  31   7\n",
       "6         Briana Glass               5  14              26  12  20\n",
       "7           Shiv Rosas               6  14              21  38  11\n",
       "8          Melody Cook               7  15               6   1   5\n",
       "9        Willem Mcgill               8  16               3  19  26\n",
       "10       Tristan Hanna               9  17              28  21  14\n",
       "11  Annabella Crawford              10  18              32  34   6\n",
       "12    Florrie Thornton              11  19               2  26   3\n",
       "13       Yolanda Tyson              12  20              16  14  40\n",
       "14    Caitlin Browning              14  21              21   6  13\n",
       "15       Everly Holman              14  22              15   3  30\n",
       "16         Ruth Holder              15  23              17  28  18\n",
       "17      Chelsey Magana              16  24               0  32  31\n",
       "18       Karson Waller              17  25              25   2  12\n",
       "19     Arissa Mcmillan              18  26               9  16  40\n",
       "20       Marlon Osborn              19  27              10  14  13\n",
       "21     Courtnie Barker              20  28  Tax Technology  15  30\n",
       "22      Mathias Becker              21  29              27  17  18\n",
       "23       Rio Wilkinson              22  30              29   0  31\n",
       "24        Vishal Logan              23  31              41  25  12\n",
       "25        Lauren Chang              14  32              24   9  40\n",
       "26          Alex Hulme              25  33              36  15  13\n",
       "27         Aiza Currie              26  34              35  16  30\n",
       "28       Maryam Lennon              27  35              31  17  18\n",
       "29          Ivan Nixon              28  36              12  18  31\n",
       "30         Lesley West              29  37              38  19  12\n",
       "31         Aida Curran              30  38               1  20   6\n",
       "32     Presley Sargent              31  39              19  21   3\n",
       "33       Anjali Bowden              32  40              21  22  28\n",
       "34      Derrick Sadler              33  41              34  23  32\n",
       "35       Nabilah Miles              34  14              39  24   2\n",
       "36         Jarod Arias              35  13               8  25  16"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# replace all values in dataframe\n",
    "gps.replace(get_mappings(rps), inplace=True)\n",
    "gps.replace(get_mappings(gps))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Returns true if grad 'g' prefers team 'r1' (current) over team 'r' (new)\n",
    "def gPrefersR1OverR(gps, rps, g, r, r1):\n",
    "    \n",
    "    # check if g prefers r over their current team r1\n",
    "    for i in range(len(gps[g])):\n",
    "        \n",
    "        # if r1 comes before r in g's preferences, do nothing\n",
    "        if (gps[g][i] == r1):\n",
    "            return True\n",
    "        \n",
    "        # if r comes before r1 in g's preferences, update g's match\n",
    "        if (gps[g][i] == r):\n",
    "            return False\n",
    "        \n",
    "    return False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Returns stable matching for N grads and N teams\n",
    "def stable_matching(gps, rps):\n",
    "    \n",
    "    # Stores the grads' teams. This is our pairing matrix. '-1' says the grad is free\n",
    "    role = [-1 for x in range(len(tps))]\n",
    "    \n",
    "    # Stores the availability of roles. If rFree[i] is false, role 'i' is free.\n",
    "    rFree = [True for x in range(len(rps))]\n",
    "    \n",
    "    freeCount = len(gps)\n",
    "    \n",
    "    # While there are free roles\n",
    "    while freeCount > 0:\n",
    "        \n",
    "        # Pick the first free role\n",
    "        r = 0\n",
    "        for r in range(len(gps)):\n",
    "            if rFree[r] == True:\n",
    "                break\n",
    "\n",
    "        # Go to all grads according to r's preferences. r is the picked free role.\n",
    "        for i in rps[r]:\n",
    "            print(i)\n",
    "            if rFree[r] == True:\n",
    "                \n",
    "                # Store the grad's current preferences\n",
    "                g = gps[r][i]\n",
    "                \n",
    "                # If the grad of preference is free, g and r are paired\n",
    "                if role[g] == -1:\n",
    "                    role[g] = r\n",
    "                    rFree[r] = False\n",
    "                    freeCount = freeCount - 1\n",
    "                    \n",
    "                # If the grad of preference is not free, compute preferences\n",
    "                else:\n",
    "                    \n",
    "                    # Current engagement of g\n",
    "                    r1 = role[g]\n",
    "                    \n",
    "                    if gPrefersR1OverR(gps, rps, g, r, r1) == False:\n",
    "                        role[g] = r\n",
    "                        rFree[r] = False\n",
    "                        rFree[r1] = True\n",
    "                        \n",
    "    return role"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "1\n",
      "2\n",
      "3\n",
      "0\n",
      "3\n",
      "1\n",
      "2\n",
      "0\n",
      "1\n",
      "2\n",
      "3\n",
      "3\n",
      "2\n",
      "1\n",
      "0\n"
     ]
    }
   ],
   "source": [
    "gps = [[3,2,1,0],[1,0,2,3],[0,1,2,3],[0,1,2,3]]\n",
    "rps = [[0,1,2,3],[0,3,1,2],[0,1,2,3],[3,2,1,0]]\n",
    "roles = stable_matching(gps, rps)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   \n",
      "4 2\n",
      "   \n",
      "5 1\n",
      "   \n",
      "6 3\n",
      "   \n",
      "7 0\n"
     ]
    }
   ],
   "source": [
    "for i in range(numOfGrads):\n",
    "    print('   ')\n",
    "    print(i + numOfGrads, roles[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}