datawrangle.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>EP ID</th>\n",
       "      <th>Status</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>OP ID</th>\n",
       "      <th>Product</th>\n",
       "      <th>Work Field</th>\n",
       "      <th>SDG Goal</th>\n",
       "      <th>SDG Target</th>\n",
       "      <th>...</th>\n",
       "      <th>utm_medium</th>\n",
       "      <th>utm_source</th>\n",
       "      <th>utm_content</th>\n",
       "      <th>utm_campaign</th>\n",
       "      <th>Tags</th>\n",
       "      <th>APL ID</th>\n",
       "      <th>Global Project</th>\n",
       "      <th>Global Partner</th>\n",
       "      <th>Company Name</th>\n",
       "      <th>Branch Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>open</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289392</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409972</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>VirtualSoft Technologies Pvt Ltd.</td>\n",
       "      <td>Chandigarh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1282746</td>\n",
       "      <td>GV (New)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.6</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6380081</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>AARS Design</td>\n",
       "      <td>Mumbai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1282747</td>\n",
       "      <td>GV (New)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6380323</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Sujata Adarsh Foundation</td>\n",
       "      <td>Mumbai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289195</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409974</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Vellore Institute of Technology, Vellore</td>\n",
       "      <td>Chennai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1285692</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6372779</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Tonic Worldwide</td>\n",
       "      <td>Mumbai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84738</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>rejected</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1291326</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Administration</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6422948</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Deutsche Post DHL Group</td>\n",
       "      <td>DHL UAE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84739</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1288369</td>\n",
       "      <td>GTe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6420688</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>American School Way</td>\n",
       "      <td>Bogotá</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84740</th>\n",
       "      <td>fffcc1f3b2e7c1dcbec944fb845af4a1</td>\n",
       "      <td>open</td>\n",
       "      <td>Cairo University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1279532</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6419905</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Unicosmos School</td>\n",
       "      <td>Adarsh Educational Society</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84741</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1261791</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Other</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6372436</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>DesignPr</td>\n",
       "      <td>Eskişehir</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84742</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1287703</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6376654</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Gads Online Marketing</td>\n",
       "      <td>Cluj-Napoca</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>84743 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  EP ID     Status           Home LC  \\\n",
       "0      000281faa05c064092497533cc4c854c       open    COCODY-ABIDJAN   \n",
       "1      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "2      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "3      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "4      000281faa05c064092497533cc4c854c  withdrawn    COCODY-ABIDJAN   \n",
       "...                                 ...        ...               ...   \n",
       "84738  fffbd3b49ef6bd916995f2754104d0eb   rejected             İZMİR   \n",
       "84739  fffbd3b49ef6bd916995f2754104d0eb  withdrawn             İZMİR   \n",
       "84740  fffcc1f3b2e7c1dcbec944fb845af4a1       open  Cairo University   \n",
       "84741  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "84742  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "\n",
       "             Home MC             Home Region    OP ID   Product  \\\n",
       "0      Cote D'Ivoire  Middle East and Africa  1289392       GTa   \n",
       "1      Cote D'Ivoire  Middle East and Africa  1282746  GV (New)   \n",
       "2      Cote D'Ivoire  Middle East and Africa  1282747  GV (New)   \n",
       "3      Cote D'Ivoire  Middle East and Africa  1289195       GTa   \n",
       "4      Cote D'Ivoire  Middle East and Africa  1285692       GTa   \n",
       "...              ...                     ...      ...       ...   \n",
       "84738         Turkey                  Europe  1291326       GTa   \n",
       "84739         Turkey                  Europe  1288369       GTe   \n",
       "84740          Egypt  Middle East and Africa  1279532       GTa   \n",
       "84741          Egypt  Middle East and Africa  1261791       GTa   \n",
       "84742          Egypt  Middle East and Africa  1287703       GTa   \n",
       "\n",
       "                    Work Field  SDG Goal  SDG Target  ...  utm_medium  \\\n",
       "0                    Marketing       NaN         NaN  ...          \"\"   \n",
       "1                          NaN       8.0         8.6  ...          \"\"   \n",
       "2                          NaN       4.0         4.6  ...          \"\"   \n",
       "3                    Marketing       NaN         NaN  ...          \"\"   \n",
       "4                    Marketing       NaN         NaN  ...          \"\"   \n",
       "...                        ...       ...         ...  ...         ...   \n",
       "84738  Business Administration       NaN         NaN  ...          \"\"   \n",
       "84739                      NaN       NaN         NaN  ...          \"\"   \n",
       "84740                Marketing       NaN         NaN  ...          \"\"   \n",
       "84741                    Other       NaN         NaN  ...         NaN   \n",
       "84742                Marketing       NaN         NaN  ...         NaN   \n",
       "\n",
       "      utm_source utm_content utm_campaign Tags   APL ID Global Project  \\\n",
       "0             \"\"          \"\"           \"\"  NaN  6409972          False   \n",
       "1             \"\"          \"\"           \"\"  NaN  6380081          False   \n",
       "2             \"\"          \"\"           \"\"  NaN  6380323          False   \n",
       "3             \"\"          \"\"           \"\"  NaN  6409974          False   \n",
       "4             \"\"          \"\"           \"\"  NaN  6372779          False   \n",
       "...          ...         ...          ...  ...      ...            ...   \n",
       "84738         \"\"          \"\"           \"\"  NaN  6422948          False   \n",
       "84739         \"\"          \"\"           \"\"  NaN  6420688          False   \n",
       "84740         \"\"          \"\"           \"\"  NaN  6419905          False   \n",
       "84741        NaN         NaN          NaN  NaN  6372436          False   \n",
       "84742        NaN         NaN          NaN  NaN  6376654          False   \n",
       "\n",
       "      Global Partner                              Company Name  \\\n",
       "0              False         VirtualSoft Technologies Pvt Ltd.   \n",
       "1              False                              AARS Design    \n",
       "2              False                  Sujata Adarsh Foundation   \n",
       "3              False  Vellore Institute of Technology, Vellore   \n",
       "4              False                           Tonic Worldwide   \n",
       "...              ...                                       ...   \n",
       "84738           True                   Deutsche Post DHL Group   \n",
       "84739          False                       American School Way   \n",
       "84740          False                          Unicosmos School   \n",
       "84741          False                                  DesignPr   \n",
       "84742          False                     Gads Online Marketing   \n",
       "\n",
       "                      Branch Name  \n",
       "0                      Chandigarh  \n",
       "1                          Mumbai  \n",
       "2                          Mumbai  \n",
       "3                         Chennai  \n",
       "4                          Mumbai  \n",
       "...                           ...  \n",
       "84738                     DHL UAE  \n",
       "84739                      Bogotá  \n",
       "84740  Adarsh Educational Society  \n",
       "84741                   Eskişehir  \n",
       "84742                 Cluj-Napoca  \n",
       "\n",
       "[84743 rows x 38 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "app = pd.read_csv('jan23_applications.csv')\n",
    "app\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>EP ID</th>\n",
       "      <th>Status</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>OP ID</th>\n",
       "      <th>Product</th>\n",
       "      <th>Work Field</th>\n",
       "      <th>SDG Goal</th>\n",
       "      <th>SDG Target</th>\n",
       "      <th>...</th>\n",
       "      <th>utm_medium</th>\n",
       "      <th>utm_source</th>\n",
       "      <th>utm_content</th>\n",
       "      <th>utm_campaign</th>\n",
       "      <th>Tags</th>\n",
       "      <th>APL ID</th>\n",
       "      <th>Global Project</th>\n",
       "      <th>Global Partner</th>\n",
       "      <th>Company Name</th>\n",
       "      <th>Branch Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>open</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289392</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409972</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>VirtualSoft Technologies Pvt Ltd.</td>\n",
       "      <td>Chandigarh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289195</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409974</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Vellore Institute of Technology, Vellore</td>\n",
       "      <td>Chennai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1285692</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6372779</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Tonic Worldwide</td>\n",
       "      <td>Mumbai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>000619cc73c5728e1a49948c18c423c6</td>\n",
       "      <td>open</td>\n",
       "      <td>Lahore</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1262154</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6410798</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>DUAL Systems Hungary Ltd.</td>\n",
       "      <td>DUAL Systems Hungary Ltd.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000619cc73c5728e1a49948c18c423c6</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Lahore</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1290573</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6405195</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Deutsche Post DHL Group</td>\n",
       "      <td>Deutsche Post DHL Group - Bonn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84738</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>rejected</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1291326</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Administration</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6422948</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Deutsche Post DHL Group</td>\n",
       "      <td>DHL UAE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84739</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1288369</td>\n",
       "      <td>GTe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6420688</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>American School Way</td>\n",
       "      <td>Bogotá</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84740</th>\n",
       "      <td>fffcc1f3b2e7c1dcbec944fb845af4a1</td>\n",
       "      <td>open</td>\n",
       "      <td>Cairo University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1279532</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>\"\"</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6419905</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Unicosmos School</td>\n",
       "      <td>Adarsh Educational Society</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84741</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1261791</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Other</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6372436</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>DesignPr</td>\n",
       "      <td>Eskişehir</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84742</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1287703</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6376654</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Gads Online Marketing</td>\n",
       "      <td>Cluj-Napoca</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64315 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  EP ID     Status           Home LC  \\\n",
       "0      000281faa05c064092497533cc4c854c       open    COCODY-ABIDJAN   \n",
       "3      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "4      000281faa05c064092497533cc4c854c  withdrawn    COCODY-ABIDJAN   \n",
       "6      000619cc73c5728e1a49948c18c423c6       open            Lahore   \n",
       "7      000619cc73c5728e1a49948c18c423c6   rejected            Lahore   \n",
       "...                                 ...        ...               ...   \n",
       "84738  fffbd3b49ef6bd916995f2754104d0eb   rejected             İZMİR   \n",
       "84739  fffbd3b49ef6bd916995f2754104d0eb  withdrawn             İZMİR   \n",
       "84740  fffcc1f3b2e7c1dcbec944fb845af4a1       open  Cairo University   \n",
       "84741  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "84742  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "\n",
       "             Home MC             Home Region    OP ID Product  \\\n",
       "0      Cote D'Ivoire  Middle East and Africa  1289392     GTa   \n",
       "3      Cote D'Ivoire  Middle East and Africa  1289195     GTa   \n",
       "4      Cote D'Ivoire  Middle East and Africa  1285692     GTa   \n",
       "6           Pakistan            Asia Pacific  1262154     GTa   \n",
       "7           Pakistan            Asia Pacific  1290573     GTa   \n",
       "...              ...                     ...      ...     ...   \n",
       "84738         Turkey                  Europe  1291326     GTa   \n",
       "84739         Turkey                  Europe  1288369     GTe   \n",
       "84740          Egypt  Middle East and Africa  1279532     GTa   \n",
       "84741          Egypt  Middle East and Africa  1261791     GTa   \n",
       "84742          Egypt  Middle East and Africa  1287703     GTa   \n",
       "\n",
       "                    Work Field  SDG Goal  SDG Target  ...  utm_medium  \\\n",
       "0                    Marketing       NaN         NaN  ...          \"\"   \n",
       "3                    Marketing       NaN         NaN  ...          \"\"   \n",
       "4                    Marketing       NaN         NaN  ...          \"\"   \n",
       "6       Information Technology       NaN         NaN  ...         NaN   \n",
       "7       Information Technology       NaN         NaN  ...         NaN   \n",
       "...                        ...       ...         ...  ...         ...   \n",
       "84738  Business Administration       NaN         NaN  ...          \"\"   \n",
       "84739                      NaN       NaN         NaN  ...          \"\"   \n",
       "84740                Marketing       NaN         NaN  ...          \"\"   \n",
       "84741                    Other       NaN         NaN  ...         NaN   \n",
       "84742                Marketing       NaN         NaN  ...         NaN   \n",
       "\n",
       "      utm_source utm_content utm_campaign Tags   APL ID Global Project  \\\n",
       "0             \"\"          \"\"           \"\"  NaN  6409972          False   \n",
       "3             \"\"          \"\"           \"\"  NaN  6409974          False   \n",
       "4             \"\"          \"\"           \"\"  NaN  6372779          False   \n",
       "6            NaN         NaN          NaN  NaN  6410798          False   \n",
       "7            NaN         NaN          NaN  NaN  6405195          False   \n",
       "...          ...         ...          ...  ...      ...            ...   \n",
       "84738         \"\"          \"\"           \"\"  NaN  6422948          False   \n",
       "84739         \"\"          \"\"           \"\"  NaN  6420688          False   \n",
       "84740         \"\"          \"\"           \"\"  NaN  6419905          False   \n",
       "84741        NaN         NaN          NaN  NaN  6372436          False   \n",
       "84742        NaN         NaN          NaN  NaN  6376654          False   \n",
       "\n",
       "      Global Partner                              Company Name  \\\n",
       "0              False         VirtualSoft Technologies Pvt Ltd.   \n",
       "3              False  Vellore Institute of Technology, Vellore   \n",
       "4              False                           Tonic Worldwide   \n",
       "6              False                 DUAL Systems Hungary Ltd.   \n",
       "7               True                   Deutsche Post DHL Group   \n",
       "...              ...                                       ...   \n",
       "84738           True                   Deutsche Post DHL Group   \n",
       "84739          False                       American School Way   \n",
       "84740          False                          Unicosmos School   \n",
       "84741          False                                  DesignPr   \n",
       "84742          False                     Gads Online Marketing   \n",
       "\n",
       "                          Branch Name  \n",
       "0                          Chandigarh  \n",
       "3                             Chennai  \n",
       "4                              Mumbai  \n",
       "6           DUAL Systems Hungary Ltd.  \n",
       "7      Deutsche Post DHL Group - Bonn  \n",
       "...                               ...  \n",
       "84738                         DHL UAE  \n",
       "84739                          Bogotá  \n",
       "84740      Adarsh Educational Society  \n",
       "84741                       Eskişehir  \n",
       "84742                     Cluj-Napoca  \n",
       "\n",
       "[64315 rows x 38 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#remobe GV (New)\n",
    "# remove rows by filtering\n",
    "app = app[app['Product'] != 'GV (New)']\n",
    "# display the dataframe\n",
    "app"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>EP ID</th>\n",
       "      <th>Status</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>OP ID</th>\n",
       "      <th>Product</th>\n",
       "      <th>Work Field</th>\n",
       "      <th>Semi-Remote OP</th>\n",
       "      <th>Duration Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Date Applied</th>\n",
       "      <th>Date Accepted</th>\n",
       "      <th>Date Rejected</th>\n",
       "      <th>Date Approved</th>\n",
       "      <th>Date Realized</th>\n",
       "      <th>Date Finished</th>\n",
       "      <th>Campaign ID</th>\n",
       "      <th>APL ID</th>\n",
       "      <th>Company Name</th>\n",
       "      <th>Branch Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>open</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289392</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-11-09 22:47:43</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>6409972</td>\n",
       "      <td>VirtualSoft Technologies Pvt Ltd.</td>\n",
       "      <td>Chandigarh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289195</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-11-09 22:57:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-11-23 09:13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409974</td>\n",
       "      <td>Vellore Institute of Technology, Vellore</td>\n",
       "      <td>Chennai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1285692</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-08-05 11:29:10</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>6372779</td>\n",
       "      <td>Tonic Worldwide</td>\n",
       "      <td>Mumbai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>000619cc73c5728e1a49948c18c423c6</td>\n",
       "      <td>open</td>\n",
       "      <td>Lahore</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1262154</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-11-11 20:42:02</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>6410798</td>\n",
       "      <td>DUAL Systems Hungary Ltd.</td>\n",
       "      <td>DUAL Systems Hungary Ltd.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000619cc73c5728e1a49948c18c423c6</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Lahore</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1290573</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-10-30 13:06:02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-11-14 10:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6405195</td>\n",
       "      <td>Deutsche Post DHL Group</td>\n",
       "      <td>Deutsche Post DHL Group - Bonn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84738</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>rejected</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1291326</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Administration</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-12-08 07:38:18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-12-21 10:08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6422948</td>\n",
       "      <td>Deutsche Post DHL Group</td>\n",
       "      <td>DHL UAE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84739</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1288369</td>\n",
       "      <td>GTe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-12-02 07:50:02</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>6420688</td>\n",
       "      <td>American School Way</td>\n",
       "      <td>Bogotá</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84740</th>\n",
       "      <td>fffcc1f3b2e7c1dcbec944fb845af4a1</td>\n",
       "      <td>open</td>\n",
       "      <td>Cairo University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1279532</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-11-30 17:18:12</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>6419905</td>\n",
       "      <td>Unicosmos School</td>\n",
       "      <td>Adarsh Educational Society</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84741</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1261791</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Other</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-08-04 11:13:08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-09-29 15:56</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6372436</td>\n",
       "      <td>DesignPr</td>\n",
       "      <td>Eskişehir</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84742</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1287703</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-08-17 12:15:16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-08-26 09:30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6376654</td>\n",
       "      <td>Gads Online Marketing</td>\n",
       "      <td>Cluj-Napoca</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64315 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  EP ID     Status           Home LC  \\\n",
       "0      000281faa05c064092497533cc4c854c       open    COCODY-ABIDJAN   \n",
       "3      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "4      000281faa05c064092497533cc4c854c  withdrawn    COCODY-ABIDJAN   \n",
       "6      000619cc73c5728e1a49948c18c423c6       open            Lahore   \n",
       "7      000619cc73c5728e1a49948c18c423c6   rejected            Lahore   \n",
       "...                                 ...        ...               ...   \n",
       "84738  fffbd3b49ef6bd916995f2754104d0eb   rejected             İZMİR   \n",
       "84739  fffbd3b49ef6bd916995f2754104d0eb  withdrawn             İZMİR   \n",
       "84740  fffcc1f3b2e7c1dcbec944fb845af4a1       open  Cairo University   \n",
       "84741  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "84742  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "\n",
       "             Home MC             Home Region    OP ID Product  \\\n",
       "0      Cote D'Ivoire  Middle East and Africa  1289392     GTa   \n",
       "3      Cote D'Ivoire  Middle East and Africa  1289195     GTa   \n",
       "4      Cote D'Ivoire  Middle East and Africa  1285692     GTa   \n",
       "6           Pakistan            Asia Pacific  1262154     GTa   \n",
       "7           Pakistan            Asia Pacific  1290573     GTa   \n",
       "...              ...                     ...      ...     ...   \n",
       "84738         Turkey                  Europe  1291326     GTa   \n",
       "84739         Turkey                  Europe  1288369     GTe   \n",
       "84740          Egypt  Middle East and Africa  1279532     GTa   \n",
       "84741          Egypt  Middle East and Africa  1261791     GTa   \n",
       "84742          Egypt  Middle East and Africa  1287703     GTa   \n",
       "\n",
       "                    Work Field  Semi-Remote OP Duration Type  ...  \\\n",
       "0                    Marketing           False     Long-term  ...   \n",
       "3                    Marketing           False    Short-term  ...   \n",
       "4                    Marketing           False     Long-term  ...   \n",
       "6       Information Technology           False     Long-term  ...   \n",
       "7       Information Technology           False     Long-term  ...   \n",
       "...                        ...             ...           ...  ...   \n",
       "84738  Business Administration           False     Long-term  ...   \n",
       "84739                      NaN           False     Long-term  ...   \n",
       "84740                Marketing           False     Long-term  ...   \n",
       "84741                    Other           False    Short-term  ...   \n",
       "84742                Marketing           False    Short-term  ...   \n",
       "\n",
       "              Date Applied Date Accepted     Date Rejected Date Approved  \\\n",
       "0      2022-11-09 22:47:43           NaN               NaN           NaN   \n",
       "3      2022-11-09 22:57:45           NaN  2022-11-23 09:13           NaN   \n",
       "4      2022-08-05 11:29:10           NaN               NaN           NaN   \n",
       "6      2022-11-11 20:42:02           NaN               NaN           NaN   \n",
       "7      2022-10-30 13:06:02           NaN  2022-11-14 10:00           NaN   \n",
       "...                    ...           ...               ...           ...   \n",
       "84738  2022-12-08 07:38:18           NaN  2022-12-21 10:08           NaN   \n",
       "84739  2022-12-02 07:50:02           NaN               NaN           NaN   \n",
       "84740  2022-11-30 17:18:12           NaN               NaN           NaN   \n",
       "84741  2022-08-04 11:13:08           NaN  2022-09-29 15:56           NaN   \n",
       "84742  2022-08-17 12:15:16           NaN  2022-08-26 09:30           NaN   \n",
       "\n",
       "      Date Realized Date Finished Campaign ID   APL ID  \\\n",
       "0               NaN           NaN         NaN  6409972   \n",
       "3               NaN           NaN         NaN  6409974   \n",
       "4               NaN           NaN         NaN  6372779   \n",
       "6               NaN           NaN         NaN  6410798   \n",
       "7               NaN           NaN         NaN  6405195   \n",
       "...             ...           ...         ...      ...   \n",
       "84738           NaN           NaN         NaN  6422948   \n",
       "84739           NaN           NaN         NaN  6420688   \n",
       "84740           NaN           NaN         NaN  6419905   \n",
       "84741           NaN           NaN         NaN  6372436   \n",
       "84742           NaN           NaN         NaN  6376654   \n",
       "\n",
       "                                   Company Name  \\\n",
       "0             VirtualSoft Technologies Pvt Ltd.   \n",
       "3      Vellore Institute of Technology, Vellore   \n",
       "4                               Tonic Worldwide   \n",
       "6                     DUAL Systems Hungary Ltd.   \n",
       "7                       Deutsche Post DHL Group   \n",
       "...                                         ...   \n",
       "84738                   Deutsche Post DHL Group   \n",
       "84739                       American School Way   \n",
       "84740                          Unicosmos School   \n",
       "84741                                  DesignPr   \n",
       "84742                     Gads Online Marketing   \n",
       "\n",
       "                          Branch Name  \n",
       "0                          Chandigarh  \n",
       "3                             Chennai  \n",
       "4                              Mumbai  \n",
       "6           DUAL Systems Hungary Ltd.  \n",
       "7      Deutsche Post DHL Group - Bonn  \n",
       "...                               ...  \n",
       "84738                         DHL UAE  \n",
       "84739                          Bogotá  \n",
       "84740      Adarsh Educational Society  \n",
       "84741                       Eskişehir  \n",
       "84742                     Cluj-Napoca  \n",
       "\n",
       "[64315 rows x 28 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "app_final = app.drop(columns=['SDG Goal',\n",
    "                  'SDG Target',\n",
    "                  'utm_term',\n",
    "                  'utm_medium',\n",
    "                  'utm_source',\n",
    "                  'utm_content',\n",
    "                  'utm_campaign',\n",
    "                  'Tags',\n",
    "                  'Global Project',\n",
    "                  'Global Partner'])\n",
    "\n",
    "app_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>EP ID</th>\n",
       "      <th>Status</th>\n",
       "      <th>Background</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Signed Up</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0113ceeaca1a9483e552b49ef556cb96</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Business administration</td>\n",
       "      <td>Male</td>\n",
       "      <td>30.20</td>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>Dasmariñas</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>Asia Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>02e749a9d063d73eaaa4894b05eb9e9a</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Business administration | Industrial engineering</td>\n",
       "      <td>female</td>\n",
       "      <td>26.67</td>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>MC Costa Rica</td>\n",
       "      <td>Costa Rica</td>\n",
       "      <td>Americas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>07ae23c2fdbab6bdab91131953a585d5</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Computer engineering | Computer sciences</td>\n",
       "      <td>female</td>\n",
       "      <td>22.51</td>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>ISTANBUL WEST</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0d104f6e2569647c4005b58d059883a1</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Accounting | Finance</td>\n",
       "      <td>female</td>\n",
       "      <td>24.83</td>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>Oran</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>107fa2d75077ac8de80c87c0efb87b9d</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Business administration</td>\n",
       "      <td>Male</td>\n",
       "      <td>24.23</td>\n",
       "      <td>2022-07-01</td>\n",
       "      <td>Carthage</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13888</th>\n",
       "      <td>deb6017bde317ffc2686cd3fa3a48ae3</td>\n",
       "      <td>open</td>\n",
       "      <td>Business administration | Logistics | Sales</td>\n",
       "      <td>male</td>\n",
       "      <td>29.00</td>\n",
       "      <td>2023-02-06</td>\n",
       "      <td>India National Office</td>\n",
       "      <td>India</td>\n",
       "      <td>Asia Pacific</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13889</th>\n",
       "      <td>ea0e5cdbbd50f7284afaf5a15fe7300d</td>\n",
       "      <td>accepted</td>\n",
       "      <td>International relations</td>\n",
       "      <td>female</td>\n",
       "      <td>21.97</td>\n",
       "      <td>2023-02-06</td>\n",
       "      <td>KOCAELI</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13890</th>\n",
       "      <td>f580095dc7857ce944662e5744ae7a5c</td>\n",
       "      <td>open</td>\n",
       "      <td>Computer sciences</td>\n",
       "      <td>female</td>\n",
       "      <td>25.79</td>\n",
       "      <td>2023-02-06</td>\n",
       "      <td>Cairo University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13891</th>\n",
       "      <td>f580095dc7857ce944662e5744ae7a5c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Computer sciences</td>\n",
       "      <td>female</td>\n",
       "      <td>25.79</td>\n",
       "      <td>2023-02-06</td>\n",
       "      <td>Cairo University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13892</th>\n",
       "      <td>f5a96f85ab45d6a8ced17742763040fe</td>\n",
       "      <td>open</td>\n",
       "      <td>Electrical engineering | Languages</td>\n",
       "      <td>female</td>\n",
       "      <td>25.10</td>\n",
       "      <td>2023-02-06</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>India</td>\n",
       "      <td>Asia Pacific</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13893 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  EP ID    Status  \\\n",
       "0      0113ceeaca1a9483e552b49ef556cb96  rejected   \n",
       "1      02e749a9d063d73eaaa4894b05eb9e9a  rejected   \n",
       "2      07ae23c2fdbab6bdab91131953a585d5  rejected   \n",
       "3      0d104f6e2569647c4005b58d059883a1  rejected   \n",
       "4      107fa2d75077ac8de80c87c0efb87b9d  rejected   \n",
       "...                                 ...       ...   \n",
       "13888  deb6017bde317ffc2686cd3fa3a48ae3      open   \n",
       "13889  ea0e5cdbbd50f7284afaf5a15fe7300d  accepted   \n",
       "13890  f580095dc7857ce944662e5744ae7a5c      open   \n",
       "13891  f580095dc7857ce944662e5744ae7a5c  rejected   \n",
       "13892  f5a96f85ab45d6a8ced17742763040fe      open   \n",
       "\n",
       "                                             Background  Gender    Age  \\\n",
       "0                               Business administration    Male  30.20   \n",
       "1      Business administration | Industrial engineering  female  26.67   \n",
       "2              Computer engineering | Computer sciences  female  22.51   \n",
       "3                                  Accounting | Finance  female  24.83   \n",
       "4                               Business administration    Male  24.23   \n",
       "...                                                 ...     ...    ...   \n",
       "13888       Business administration | Logistics | Sales    male  29.00   \n",
       "13889                           International relations  female  21.97   \n",
       "13890                                 Computer sciences  female  25.79   \n",
       "13891                                 Computer sciences  female  25.79   \n",
       "13892                Electrical engineering | Languages  female  25.10   \n",
       "\n",
       "        Signed Up                Home LC      Home MC             Home Region  \n",
       "0      2022-07-01             Dasmariñas  Philippines            Asia Pacific  \n",
       "1      2022-07-01          MC Costa Rica   Costa Rica                Americas  \n",
       "2      2022-07-01          ISTANBUL WEST       Turkey                  Europe  \n",
       "3      2022-07-01                   Oran      Algeria  Middle East and Africa  \n",
       "4      2022-07-01               Carthage      Tunisia  Middle East and Africa  \n",
       "...           ...                    ...          ...                     ...  \n",
       "13888  2023-02-06  India National Office        India            Asia Pacific  \n",
       "13889  2023-02-06                KOCAELI       Turkey                  Europe  \n",
       "13890  2023-02-06       Cairo University        Egypt  Middle East and Africa  \n",
       "13891  2023-02-06       Cairo University        Egypt  Middle East and Africa  \n",
       "13892  2023-02-06                 Mumbai        India            Asia Pacific  \n",
       "\n",
       "[13893 rows x 9 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pbg = pd.read_csv('jan23_People-backgrounds.csv')\n",
    "pbg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>EP ID</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>Interest in GV</th>\n",
       "      <th>Interest in GTa</th>\n",
       "      <th>Interest in GTe</th>\n",
       "      <th>Skills</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e8c8b11d2902ce069d9bb27d26ed696f</td>\n",
       "      <td>Constantine</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Mac usage | Beginner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a98e8c0c63f2cb7c9d8b537244f5b550</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>United States</td>\n",
       "      <td>Americas</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Professional Skills | Advanced; Adaptability |...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>107fa2d75077ac8de80c87c0efb87b9d</td>\n",
       "      <td>Carthage</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Controlling | Intermediate; Internet usage | A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0d104f6e2569647c4005b58d059883a1</td>\n",
       "      <td>Oran</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Microsoft Excel | Advanced; Photoshop | Beginn...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>004fa4265748f0fe017a4dbb97cd1293</td>\n",
       "      <td>Oran</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>Microsoft Word | Advanced; Event Planning | Ad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18785</th>\n",
       "      <td>3df29e02ddebe9960f90de730a61b2d7</td>\n",
       "      <td>Dehradun</td>\n",
       "      <td>India</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Adaptability | Advanced</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18786</th>\n",
       "      <td>fa75d86f80604391623f40237bacaa03</td>\n",
       "      <td>Bejaia</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Construction Management | Beginner; Adaptabili...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18787</th>\n",
       "      <td>d7c03f6a7485cde346ade1b17e31dad8</td>\n",
       "      <td>ISTANBUL</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Database Administration | Beginner; Data Manag...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18788</th>\n",
       "      <td>8fb1d0f84938f06768104c4cc17e4361</td>\n",
       "      <td>EASTERN MEDITERRANEAN</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Microsoft Excel | Advanced; Microsoft Powerpoi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18789</th>\n",
       "      <td>fa5228a56439cb7f1191216b71bfd9e4</td>\n",
       "      <td>Ain Shams University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Client servicing | Advanced; Analytical thinki...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18790 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  EP ID                Home LC        Home MC  \\\n",
       "0      e8c8b11d2902ce069d9bb27d26ed696f            Constantine        Algeria   \n",
       "1      a98e8c0c63f2cb7c9d8b537244f5b550               SAN JOSE  United States   \n",
       "2      107fa2d75077ac8de80c87c0efb87b9d               Carthage        Tunisia   \n",
       "3      0d104f6e2569647c4005b58d059883a1                   Oran        Algeria   \n",
       "4      004fa4265748f0fe017a4dbb97cd1293                   Oran        Algeria   \n",
       "...                                 ...                    ...            ...   \n",
       "18785  3df29e02ddebe9960f90de730a61b2d7               Dehradun          India   \n",
       "18786  fa75d86f80604391623f40237bacaa03                 Bejaia        Algeria   \n",
       "18787  d7c03f6a7485cde346ade1b17e31dad8               ISTANBUL         Turkey   \n",
       "18788  8fb1d0f84938f06768104c4cc17e4361  EASTERN MEDITERRANEAN         Turkey   \n",
       "18789  fa5228a56439cb7f1191216b71bfd9e4   Ain Shams University          Egypt   \n",
       "\n",
       "                  Home Region  Interest in GV  Interest in GTa  \\\n",
       "0      Middle East and Africa           False            False   \n",
       "1                    Americas           False             True   \n",
       "2      Middle East and Africa           False            False   \n",
       "3      Middle East and Africa           False            False   \n",
       "4      Middle East and Africa           False            False   \n",
       "...                       ...             ...              ...   \n",
       "18785            Asia Pacific           False             True   \n",
       "18786  Middle East and Africa           False            False   \n",
       "18787                  Europe           False            False   \n",
       "18788                  Europe           False             True   \n",
       "18789  Middle East and Africa           False            False   \n",
       "\n",
       "       Interest in GTe                                             Skills  \n",
       "0                False                               Mac usage | Beginner  \n",
       "1                False  Professional Skills | Advanced; Adaptability |...  \n",
       "2                False  Controlling | Intermediate; Internet usage | A...  \n",
       "3                False  Microsoft Excel | Advanced; Photoshop | Beginn...  \n",
       "4                 True  Microsoft Word | Advanced; Event Planning | Ad...  \n",
       "...                ...                                                ...  \n",
       "18785            False                            Adaptability | Advanced  \n",
       "18786            False  Construction Management | Beginner; Adaptabili...  \n",
       "18787            False  Database Administration | Beginner; Data Manag...  \n",
       "18788            False  Microsoft Excel | Advanced; Microsoft Powerpoi...  \n",
       "18789            False  Client servicing | Advanced; Analytical thinki...  \n",
       "\n",
       "[18790 rows x 8 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ps = pd.read_csv('jan23_People-skills.csv')\n",
    "ps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>EP ID</th>\n",
       "      <th>Status_x</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>OP ID</th>\n",
       "      <th>Product</th>\n",
       "      <th>Work Field</th>\n",
       "      <th>Semi-Remote OP</th>\n",
       "      <th>Duration Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Date Finished</th>\n",
       "      <th>Campaign ID</th>\n",
       "      <th>APL ID</th>\n",
       "      <th>Company Name</th>\n",
       "      <th>Branch Name</th>\n",
       "      <th>Status_y</th>\n",
       "      <th>Background</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Signed Up</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>open</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289392</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409972</td>\n",
       "      <td>VirtualSoft Technologies Pvt Ltd.</td>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>open</td>\n",
       "      <td>Marketing | Sales</td>\n",
       "      <td>female</td>\n",
       "      <td>22.92</td>\n",
       "      <td>2022-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>open</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289392</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409972</td>\n",
       "      <td>VirtualSoft Technologies Pvt Ltd.</td>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Marketing | Sales</td>\n",
       "      <td>female</td>\n",
       "      <td>22.92</td>\n",
       "      <td>2022-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>open</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289392</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409972</td>\n",
       "      <td>VirtualSoft Technologies Pvt Ltd.</td>\n",
       "      <td>Chandigarh</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>Marketing | Sales</td>\n",
       "      <td>female</td>\n",
       "      <td>22.92</td>\n",
       "      <td>2022-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289195</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409974</td>\n",
       "      <td>Vellore Institute of Technology, Vellore</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>open</td>\n",
       "      <td>Marketing | Sales</td>\n",
       "      <td>female</td>\n",
       "      <td>22.92</td>\n",
       "      <td>2022-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000281faa05c064092497533cc4c854c</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COCODY-ABIDJAN</td>\n",
       "      <td>Cote D'Ivoire</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1289195</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6409974</td>\n",
       "      <td>Vellore Institute of Technology, Vellore</td>\n",
       "      <td>Chennai</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Marketing | Sales</td>\n",
       "      <td>female</td>\n",
       "      <td>22.92</td>\n",
       "      <td>2022-08-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85681</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1288369</td>\n",
       "      <td>GTe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6420688</td>\n",
       "      <td>American School Way</td>\n",
       "      <td>Bogotá</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Business administration | Political science | ...</td>\n",
       "      <td>male</td>\n",
       "      <td>23.76</td>\n",
       "      <td>2022-11-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85682</th>\n",
       "      <td>fffbd3b49ef6bd916995f2754104d0eb</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>İZMİR</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>Europe</td>\n",
       "      <td>1288369</td>\n",
       "      <td>GTe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6420688</td>\n",
       "      <td>American School Way</td>\n",
       "      <td>Bogotá</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>Business administration | Political science | ...</td>\n",
       "      <td>male</td>\n",
       "      <td>23.76</td>\n",
       "      <td>2022-11-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85683</th>\n",
       "      <td>fffcc1f3b2e7c1dcbec944fb845af4a1</td>\n",
       "      <td>open</td>\n",
       "      <td>Cairo University</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1279532</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6419905</td>\n",
       "      <td>Unicosmos School</td>\n",
       "      <td>Adarsh Educational Society</td>\n",
       "      <td>open</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Male</td>\n",
       "      <td>24.76</td>\n",
       "      <td>2022-11-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85684</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1261791</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Other</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6372436</td>\n",
       "      <td>DesignPr</td>\n",
       "      <td>Eskişehir</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Design</td>\n",
       "      <td>female</td>\n",
       "      <td>28.22</td>\n",
       "      <td>2022-08-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85685</th>\n",
       "      <td>fffd0db8cbc5f27f67f3e0e40b951204</td>\n",
       "      <td>rejected</td>\n",
       "      <td>MSA</td>\n",
       "      <td>Egypt</td>\n",
       "      <td>Middle East and Africa</td>\n",
       "      <td>1287703</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Short-term</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6376654</td>\n",
       "      <td>Gads Online Marketing</td>\n",
       "      <td>Cluj-Napoca</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Design</td>\n",
       "      <td>female</td>\n",
       "      <td>28.22</td>\n",
       "      <td>2022-08-04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85686 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  EP ID   Status_x           Home LC  \\\n",
       "0      000281faa05c064092497533cc4c854c       open    COCODY-ABIDJAN   \n",
       "1      000281faa05c064092497533cc4c854c       open    COCODY-ABIDJAN   \n",
       "2      000281faa05c064092497533cc4c854c       open    COCODY-ABIDJAN   \n",
       "3      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "4      000281faa05c064092497533cc4c854c   rejected    COCODY-ABIDJAN   \n",
       "...                                 ...        ...               ...   \n",
       "85681  fffbd3b49ef6bd916995f2754104d0eb  withdrawn             İZMİR   \n",
       "85682  fffbd3b49ef6bd916995f2754104d0eb  withdrawn             İZMİR   \n",
       "85683  fffcc1f3b2e7c1dcbec944fb845af4a1       open  Cairo University   \n",
       "85684  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "85685  fffd0db8cbc5f27f67f3e0e40b951204   rejected               MSA   \n",
       "\n",
       "             Home MC             Home Region    OP ID Product Work Field  \\\n",
       "0      Cote D'Ivoire  Middle East and Africa  1289392     GTa  Marketing   \n",
       "1      Cote D'Ivoire  Middle East and Africa  1289392     GTa  Marketing   \n",
       "2      Cote D'Ivoire  Middle East and Africa  1289392     GTa  Marketing   \n",
       "3      Cote D'Ivoire  Middle East and Africa  1289195     GTa  Marketing   \n",
       "4      Cote D'Ivoire  Middle East and Africa  1289195     GTa  Marketing   \n",
       "...              ...                     ...      ...     ...        ...   \n",
       "85681         Turkey                  Europe  1288369     GTe        NaN   \n",
       "85682         Turkey                  Europe  1288369     GTe        NaN   \n",
       "85683          Egypt  Middle East and Africa  1279532     GTa  Marketing   \n",
       "85684          Egypt  Middle East and Africa  1261791     GTa      Other   \n",
       "85685          Egypt  Middle East and Africa  1287703     GTa  Marketing   \n",
       "\n",
       "       Semi-Remote OP Duration Type  ... Date Finished Campaign ID   APL ID  \\\n",
       "0               False     Long-term  ...           NaN         NaN  6409972   \n",
       "1               False     Long-term  ...           NaN         NaN  6409972   \n",
       "2               False     Long-term  ...           NaN         NaN  6409972   \n",
       "3               False    Short-term  ...           NaN         NaN  6409974   \n",
       "4               False    Short-term  ...           NaN         NaN  6409974   \n",
       "...               ...           ...  ...           ...         ...      ...   \n",
       "85681           False     Long-term  ...           NaN         NaN  6420688   \n",
       "85682           False     Long-term  ...           NaN         NaN  6420688   \n",
       "85683           False     Long-term  ...           NaN         NaN  6419905   \n",
       "85684           False    Short-term  ...           NaN         NaN  6372436   \n",
       "85685           False    Short-term  ...           NaN         NaN  6376654   \n",
       "\n",
       "                                   Company Name                 Branch Name  \\\n",
       "0             VirtualSoft Technologies Pvt Ltd.                  Chandigarh   \n",
       "1             VirtualSoft Technologies Pvt Ltd.                  Chandigarh   \n",
       "2             VirtualSoft Technologies Pvt Ltd.                  Chandigarh   \n",
       "3      Vellore Institute of Technology, Vellore                     Chennai   \n",
       "4      Vellore Institute of Technology, Vellore                     Chennai   \n",
       "...                                         ...                         ...   \n",
       "85681                       American School Way                      Bogotá   \n",
       "85682                       American School Way                      Bogotá   \n",
       "85683                          Unicosmos School  Adarsh Educational Society   \n",
       "85684                                  DesignPr                   Eskişehir   \n",
       "85685                     Gads Online Marketing                 Cluj-Napoca   \n",
       "\n",
       "        Status_y                                         Background  Gender  \\\n",
       "0           open                                  Marketing | Sales  female   \n",
       "1       rejected                                  Marketing | Sales  female   \n",
       "2      withdrawn                                  Marketing | Sales  female   \n",
       "3           open                                  Marketing | Sales  female   \n",
       "4       rejected                                  Marketing | Sales  female   \n",
       "...          ...                                                ...     ...   \n",
       "85681   rejected  Business administration | Political science | ...    male   \n",
       "85682  withdrawn  Business administration | Political science | ...    male   \n",
       "85683       open                                          Marketing    Male   \n",
       "85684   rejected                                             Design  female   \n",
       "85685   rejected                                             Design  female   \n",
       "\n",
       "         Age   Signed Up  \n",
       "0      22.92  2022-08-02  \n",
       "1      22.92  2022-08-02  \n",
       "2      22.92  2022-08-02  \n",
       "3      22.92  2022-08-02  \n",
       "4      22.92  2022-08-02  \n",
       "...      ...         ...  \n",
       "85681  23.76  2022-11-28  \n",
       "85682  23.76  2022-11-28  \n",
       "85683  24.76  2022-11-30  \n",
       "85684  28.22  2022-08-04  \n",
       "85685  28.22  2022-08-04  \n",
       "\n",
       "[85686 rows x 33 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "app_pbg = pd.merge(app_final, pbg, on = [\"EP ID\",\"Home LC\",\"Home MC\",\"Home Region\"], how = \"left\")\n",
    "\n",
    "app_pbg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "d:\\INSTALLED\\Conda\\lib\\site-packages\\IPython\\lib\\pretty.py:700: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.\n",
      "  output = repr(obj)\n",
      "d:\\INSTALLED\\Conda\\lib\\site-packages\\IPython\\core\\formatters.py:345: FutureWarning: In a future version, object-dtype columns with all-bool values will not be included in reductions with bool_only=True. Explicitly cast to bool dtype instead.\n",
      "  return method()\n"
     ]
    },
    {
     "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>EP ID</th>\n",
       "      <th>Status_x</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>OP ID</th>\n",
       "      <th>Product</th>\n",
       "      <th>Work Field</th>\n",
       "      <th>Semi-Remote OP</th>\n",
       "      <th>Duration Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Branch Name</th>\n",
       "      <th>Status_y</th>\n",
       "      <th>Background</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Signed Up</th>\n",
       "      <th>Interest in GV</th>\n",
       "      <th>Interest in GTa</th>\n",
       "      <th>Interest in GTe</th>\n",
       "      <th>Skills</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1285407</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Koding Kingdom (Hong Kong) Limited</td>\n",
       "      <td>open</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1285407</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Koding Kingdom (Hong Kong) Limited</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1285407</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Koding Kingdom (Hong Kong) Limited</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287280</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>True</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Level 33 Indústria e Comércio</td>\n",
       "      <td>open</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287280</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>True</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Level 33 Indústria e Comércio</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2257</th>\n",
       "      <td>fd2ae62c8480078ee6345327e8cdeb0d</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO NORTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1290596</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Finance</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Electrolux Poland</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1282736</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2259</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287308</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Development</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2260</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287310</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Development</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>İstanbul - Beyoğlu</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2261</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1288102</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Utrecht</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2262 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 EP ID  Status_x        Home LC    Home MC  \\\n",
       "0     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "1     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "2     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "3     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "4     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "...                                ...       ...            ...        ...   \n",
       "2257  fd2ae62c8480078ee6345327e8cdeb0d  rejected  COLOMBO NORTH  Sri Lanka   \n",
       "2258  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "2259  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "2260  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "2261  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "\n",
       "       Home Region    OP ID Product              Work Field  Semi-Remote OP  \\\n",
       "0     Asia Pacific  1285407     GTa  Information Technology           False   \n",
       "1     Asia Pacific  1285407     GTa  Information Technology           False   \n",
       "2     Asia Pacific  1285407     GTa  Information Technology           False   \n",
       "3     Asia Pacific  1287280     GTa  Information Technology            True   \n",
       "4     Asia Pacific  1287280     GTa  Information Technology            True   \n",
       "...            ...      ...     ...                     ...             ...   \n",
       "2257  Asia Pacific  1290596     GTa                 Finance           False   \n",
       "2258  Asia Pacific  1282736     GTa               Marketing           False   \n",
       "2259  Asia Pacific  1287308     GTa    Business Development           False   \n",
       "2260  Asia Pacific  1287310     GTa    Business Development           False   \n",
       "2261  Asia Pacific  1288102     GTa               Marketing           False   \n",
       "\n",
       "     Duration Type  ...                         Branch Name   Status_y  \\\n",
       "0        Long-term  ...  Koding Kingdom (Hong Kong) Limited       open   \n",
       "1        Long-term  ...  Koding Kingdom (Hong Kong) Limited   rejected   \n",
       "2        Long-term  ...  Koding Kingdom (Hong Kong) Limited  withdrawn   \n",
       "3        Long-term  ...       Level 33 Indústria e Comércio       open   \n",
       "4        Long-term  ...       Level 33 Indústria e Comércio   rejected   \n",
       "...            ...  ...                                 ...        ...   \n",
       "2257     Long-term  ...                   Electrolux Poland        NaN   \n",
       "2258     Long-term  ...                               Delhi        NaN   \n",
       "2259     Long-term  ...                             Chennai        NaN   \n",
       "2260     Long-term  ...                  İstanbul - Beyoğlu        NaN   \n",
       "2261     Long-term  ...                             Utrecht        NaN   \n",
       "\n",
       "                                             Background  Gender    Age  \\\n",
       "0     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "1     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "2     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "3     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "4     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "...                                                 ...     ...    ...   \n",
       "2257                                                NaN     NaN    NaN   \n",
       "2258                                                NaN     NaN    NaN   \n",
       "2259                                                NaN     NaN    NaN   \n",
       "2260                                                NaN     NaN    NaN   \n",
       "2261                                                NaN     NaN    NaN   \n",
       "\n",
       "       Signed Up Interest in GV Interest in GTa Interest in GTe  \\\n",
       "0     2022-10-17          False            True           False   \n",
       "1     2022-10-17          False            True           False   \n",
       "2     2022-10-17          False            True           False   \n",
       "3     2022-10-17          False            True           False   \n",
       "4     2022-10-17          False            True           False   \n",
       "...          ...            ...             ...             ...   \n",
       "2257         NaN            NaN             NaN             NaN   \n",
       "2258         NaN            NaN             NaN             NaN   \n",
       "2259         NaN            NaN             NaN             NaN   \n",
       "2260         NaN            NaN             NaN             NaN   \n",
       "2261         NaN            NaN             NaN             NaN   \n",
       "\n",
       "                                                 Skills  \n",
       "0     Android | Advanced; Python | Intermediate; Str...  \n",
       "1     Android | Advanced; Python | Intermediate; Str...  \n",
       "2     Android | Advanced; Python | Intermediate; Str...  \n",
       "3     Android | Advanced; Python | Intermediate; Str...  \n",
       "4     Android | Advanced; Python | Intermediate; Str...  \n",
       "...                                                 ...  \n",
       "2257                                                NaN  \n",
       "2258                                                NaN  \n",
       "2259                                                NaN  \n",
       "2260                                                NaN  \n",
       "2261                                                NaN  \n",
       "\n",
       "[2262 rows x 37 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "app_pbg_ps = pd.merge(app_pbg, ps, on = [\"EP ID\",\"Home LC\",\"Home MC\",\"Home Region\"], how = \"left\")\n",
    "\n",
    "app_pbg_ps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>EP ID</th>\n",
       "      <th>Status_x</th>\n",
       "      <th>Home LC</th>\n",
       "      <th>Home MC</th>\n",
       "      <th>Home Region</th>\n",
       "      <th>OP ID</th>\n",
       "      <th>Product</th>\n",
       "      <th>Work Field</th>\n",
       "      <th>Semi-Remote OP</th>\n",
       "      <th>Duration Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Branch Name</th>\n",
       "      <th>Status_y</th>\n",
       "      <th>Background</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age</th>\n",
       "      <th>Signed Up</th>\n",
       "      <th>Interest in GV</th>\n",
       "      <th>Interest in GTa</th>\n",
       "      <th>Interest in GTe</th>\n",
       "      <th>Skills</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1285407</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Koding Kingdom (Hong Kong) Limited</td>\n",
       "      <td>open</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1285407</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Koding Kingdom (Hong Kong) Limited</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1285407</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Koding Kingdom (Hong Kong) Limited</td>\n",
       "      <td>withdrawn</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287280</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>True</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Level 33 Indústria e Comércio</td>\n",
       "      <td>open</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0084c73bae1b494abc0395b72ad1a38e</td>\n",
       "      <td>open</td>\n",
       "      <td>USJ</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287280</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>True</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Level 33 Indústria e Comércio</td>\n",
       "      <td>rejected</td>\n",
       "      <td>Biology | Chemistry | Computer engineering | C...</td>\n",
       "      <td>female</td>\n",
       "      <td>25.64</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Android | Advanced; Python | Intermediate; Str...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2257</th>\n",
       "      <td>fd2ae62c8480078ee6345327e8cdeb0d</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO NORTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1290596</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Finance</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Electrolux Poland</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2258</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1282736</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Delhi</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2259</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287308</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Development</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Chennai</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2260</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1287310</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Business Development</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>İstanbul - Beyoğlu</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2261</th>\n",
       "      <td>ff373ecce5a96cad76f5ee2bec7acf22</td>\n",
       "      <td>rejected</td>\n",
       "      <td>COLOMBO SOUTH</td>\n",
       "      <td>Sri Lanka</td>\n",
       "      <td>Asia Pacific</td>\n",
       "      <td>1288102</td>\n",
       "      <td>GTa</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>False</td>\n",
       "      <td>Long-term</td>\n",
       "      <td>...</td>\n",
       "      <td>Utrecht</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",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2262 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 EP ID  Status_x        Home LC    Home MC  \\\n",
       "0     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "1     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "2     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "3     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "4     0084c73bae1b494abc0395b72ad1a38e      open            USJ  Sri Lanka   \n",
       "...                                ...       ...            ...        ...   \n",
       "2257  fd2ae62c8480078ee6345327e8cdeb0d  rejected  COLOMBO NORTH  Sri Lanka   \n",
       "2258  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "2259  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "2260  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "2261  ff373ecce5a96cad76f5ee2bec7acf22  rejected  COLOMBO SOUTH  Sri Lanka   \n",
       "\n",
       "       Home Region    OP ID Product              Work Field  Semi-Remote OP  \\\n",
       "0     Asia Pacific  1285407     GTa  Information Technology           False   \n",
       "1     Asia Pacific  1285407     GTa  Information Technology           False   \n",
       "2     Asia Pacific  1285407     GTa  Information Technology           False   \n",
       "3     Asia Pacific  1287280     GTa  Information Technology            True   \n",
       "4     Asia Pacific  1287280     GTa  Information Technology            True   \n",
       "...            ...      ...     ...                     ...             ...   \n",
       "2257  Asia Pacific  1290596     GTa                 Finance           False   \n",
       "2258  Asia Pacific  1282736     GTa               Marketing           False   \n",
       "2259  Asia Pacific  1287308     GTa    Business Development           False   \n",
       "2260  Asia Pacific  1287310     GTa    Business Development           False   \n",
       "2261  Asia Pacific  1288102     GTa               Marketing           False   \n",
       "\n",
       "     Duration Type  ...                         Branch Name   Status_y  \\\n",
       "0        Long-term  ...  Koding Kingdom (Hong Kong) Limited       open   \n",
       "1        Long-term  ...  Koding Kingdom (Hong Kong) Limited   rejected   \n",
       "2        Long-term  ...  Koding Kingdom (Hong Kong) Limited  withdrawn   \n",
       "3        Long-term  ...       Level 33 Indústria e Comércio       open   \n",
       "4        Long-term  ...       Level 33 Indústria e Comércio   rejected   \n",
       "...            ...  ...                                 ...        ...   \n",
       "2257     Long-term  ...                   Electrolux Poland        NaN   \n",
       "2258     Long-term  ...                               Delhi        NaN   \n",
       "2259     Long-term  ...                             Chennai        NaN   \n",
       "2260     Long-term  ...                  İstanbul - Beyoğlu        NaN   \n",
       "2261     Long-term  ...                             Utrecht        NaN   \n",
       "\n",
       "                                             Background  Gender    Age  \\\n",
       "0     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "1     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "2     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "3     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "4     Biology | Chemistry | Computer engineering | C...  female  25.64   \n",
       "...                                                 ...     ...    ...   \n",
       "2257                                                NaN     NaN    NaN   \n",
       "2258                                                NaN     NaN    NaN   \n",
       "2259                                                NaN     NaN    NaN   \n",
       "2260                                                NaN     NaN    NaN   \n",
       "2261                                                NaN     NaN    NaN   \n",
       "\n",
       "       Signed Up Interest in GV Interest in GTa Interest in GTe  \\\n",
       "0     2022-10-17          False            True           False   \n",
       "1     2022-10-17          False            True           False   \n",
       "2     2022-10-17          False            True           False   \n",
       "3     2022-10-17          False            True           False   \n",
       "4     2022-10-17          False            True           False   \n",
       "...          ...            ...             ...             ...   \n",
       "2257         NaN            NaN             NaN             NaN   \n",
       "2258         NaN            NaN             NaN             NaN   \n",
       "2259         NaN            NaN             NaN             NaN   \n",
       "2260         NaN            NaN             NaN             NaN   \n",
       "2261         NaN            NaN             NaN             NaN   \n",
       "\n",
       "                                                 Skills  \n",
       "0     Android | Advanced; Python | Intermediate; Str...  \n",
       "1     Android | Advanced; Python | Intermediate; Str...  \n",
       "2     Android | Advanced; Python | Intermediate; Str...  \n",
       "3     Android | Advanced; Python | Intermediate; Str...  \n",
       "4     Android | Advanced; Python | Intermediate; Str...  \n",
       "...                                                 ...  \n",
       "2257                                                NaN  \n",
       "2258                                                NaN  \n",
       "2259                                                NaN  \n",
       "2260                                                NaN  \n",
       "2261                                                NaN  \n",
       "\n",
       "[2262 rows x 37 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "app_pbg_ps = app_pbg_ps[app_pbg_ps['Home MC'] == 'Sri Lanka']\n",
    "# display the dataframe\n",
    "app_pbg_ps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "app_pbg_ps.to_csv('application_people_skills_background.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.9.7"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "44e5c2402f9c33ea0aa43f3420f1b2f7e8504c40a09e9636bd8a710639b58852"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}