forVFL2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "from bs4 import BeautifulSoup\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "__REFERENCE WEBSITE__ <br>\n",
    "http://h1bdata.info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def collect_tables(target):\n",
    "    # access website, populate form, get results as html\n",
    "    url = \"http://h1bdata.info/index.php?em={}\".format(target)\n",
    "    content = requests.get(url).text\n",
    "    \n",
    "    #process the html code\n",
    "    soup = BeautifulSoup(content)\n",
    "    table = soup.find(\"tbody\")  #go to table body\n",
    "    colnames = [tag.text for tag in soup.find(\"thead\").find_all(\"th\")]  #fetch Column headers\n",
    "\n",
    "    #cycle through tags and populate df with contents\n",
    "    df = pd.DataFrame(\n",
    "        ((tag.text for tag in lst.find_all(\"td\")) for lst in table.find_all(\"tr\")),\n",
    "        columns = colnames\n",
    "    )\n",
    "    return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Fetch the Data from the Web"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/conda3/lib/python3.6/site-packages/bs4/__init__.py:181: UserWarning: No parser was explicitly specified, so I'm using the best available HTML parser for this system (\"lxml\"). This usually isn't a problem, but if you run this code on another system, or in a different virtual environment, it may use a different parser and behave differently.\n",
      "\n",
      "The code that caused this warning is on line 193 of the file /usr/local/conda3/lib/python3.6/runpy.py. To get rid of this warning, change code that looks like this:\n",
      "\n",
      " BeautifulSoup(YOUR_MARKUP})\n",
      "\n",
      "to this:\n",
      "\n",
      " BeautifulSoup(YOUR_MARKUP, \"lxml\")\n",
      "\n",
      "  markup_type=markup_type))\n"
     ]
    }
   ],
   "source": [
    "#list of companies for which to fetch data\n",
    "targets = [\"Google\", \"Facebook\"]\n",
    "\n",
    "#iteratively call the UDF for each company in the list\n",
    "collection = [collect_tables(target) for target in targets]"
   ]
  },
  {
   "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>EMPLOYER</th>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th>BASE SALARY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>SUBMIT DATE</th>\n",
       "      <th>START DATE</th>\n",
       "      <th>CASE STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>1615.29860</td>\n",
       "      <td>115,000</td>\n",
       "      <td>KIRKLAND, WA</td>\n",
       "      <td>01/26/2018</td>\n",
       "      <td>07/25/2018</td>\n",
       "      <td>WITHDRAWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>1615.34491</td>\n",
       "      <td>93,000</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>11/28/2017</td>\n",
       "      <td>01/22/2018</td>\n",
       "      <td>DENIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>1615.34491</td>\n",
       "      <td>93,000</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>12/07/2017</td>\n",
       "      <td>01/22/2018</td>\n",
       "      <td>WITHDRAWN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GOOGLE INC</td>\n",
       "      <td>ACCOUNT ANALYST</td>\n",
       "      <td>121,402</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>12/16/2015</td>\n",
       "      <td>04/05/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GOOGLE INC</td>\n",
       "      <td>ACCOUNT ASSOCIATE</td>\n",
       "      <td>74,700</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>01/07/2015</td>\n",
       "      <td>05/07/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     EMPLOYER          JOB TITLE BASE SALARY           LOCATION SUBMIT DATE  \\\n",
       "0  GOOGLE LLC         1615.29860     115,000       KIRKLAND, WA  01/26/2018   \n",
       "1  GOOGLE LLC         1615.34491      93,000  MOUNTAIN VIEW, CA  11/28/2017   \n",
       "2  GOOGLE LLC         1615.34491      93,000  MOUNTAIN VIEW, CA  12/07/2017   \n",
       "3  GOOGLE INC    ACCOUNT ANALYST     121,402       NEW YORK, NY  12/16/2015   \n",
       "4  GOOGLE INC  ACCOUNT ASSOCIATE      74,700  MOUNTAIN VIEW, CA  01/07/2015   \n",
       "\n",
       "   START DATE CASE STATUS  \n",
       "0  07/25/2018   WITHDRAWN  \n",
       "1  01/22/2018      DENIED  \n",
       "2  01/22/2018   WITHDRAWN  \n",
       "3  04/05/2016   CERTIFIED  \n",
       "4  05/07/2015   CERTIFIED  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection[0].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EMPLOYER</th>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th>BASE SALARY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>SUBMIT DATE</th>\n",
       "      <th>START DATE</th>\n",
       "      <th>CASE STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>360 VIDEO PRODUCT MARKETING MANAGER</td>\n",
       "      <td>100,000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/22/2016</td>\n",
       "      <td>01/02/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>360 VIDEO PRODUCT MARKETING MANAGER</td>\n",
       "      <td>125,400</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/19/2018</td>\n",
       "      <td>08/15/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ABUSE ANALYST</td>\n",
       "      <td>110,000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>04/20/2015</td>\n",
       "      <td>05/18/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCESS MANAGEMENT LEAD</td>\n",
       "      <td>114,642</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/02/2018</td>\n",
       "      <td>08/28/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCESS MANAGEMENT LEAD(INTERNAL TOOLS)</td>\n",
       "      <td>114,642</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/11/2017</td>\n",
       "      <td>09/09/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       EMPLOYER                               JOB TITLE BASE SALARY  \\\n",
       "0  FACEBOOK INC     360 VIDEO PRODUCT MARKETING MANAGER     100,000   \n",
       "1  FACEBOOK INC     360 VIDEO PRODUCT MARKETING MANAGER     125,400   \n",
       "2  FACEBOOK INC                           ABUSE ANALYST     110,000   \n",
       "3  FACEBOOK INC                  ACCESS MANAGEMENT LEAD     114,642   \n",
       "4  FACEBOOK INC  ACCESS MANAGEMENT LEAD(INTERNAL TOOLS)     114,642   \n",
       "\n",
       "         LOCATION SUBMIT DATE  START DATE CASE STATUS  \n",
       "0  MENLO PARK, CA  12/22/2016  01/02/2017   CERTIFIED  \n",
       "1  MENLO PARK, CA  02/19/2018  08/15/2018   CERTIFIED  \n",
       "2  MENLO PARK, CA  04/20/2015  05/18/2015   CERTIFIED  \n",
       "3      AUSTIN, TX  03/02/2018  08/28/2018   CERTIFIED  \n",
       "4      AUSTIN, TX  03/11/2017  09/09/2017   CERTIFIED  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection[1].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>EMPLOYER</th>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th>BASE SALARY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>SUBMIT DATE</th>\n",
       "      <th>START DATE</th>\n",
       "      <th>CASE STATUS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>22549</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VP OF VR</td>\n",
       "      <td>525,000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/06/2018</td>\n",
       "      <td>08/06/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22550</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WEB ANALYTICS LEAD</td>\n",
       "      <td>165,000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>08/16/2017</td>\n",
       "      <td>09/04/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22551</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WIRELESS COMMUNICATION RESEARCHER</td>\n",
       "      <td>145,000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/15/2016</td>\n",
       "      <td>06/14/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22552</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WIRELESS COMMUNICATIONS SYSTEMS ENGINEER</td>\n",
       "      <td>120,000</td>\n",
       "      <td>WOODLAND HILLS, CA</td>\n",
       "      <td>12/16/2016</td>\n",
       "      <td>06/15/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22553</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WIRELESS SYSTEMS ENGINEER</td>\n",
       "      <td>130,000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/07/2016</td>\n",
       "      <td>08/25/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           EMPLOYER                                 JOB TITLE BASE SALARY  \\\n",
       "22549  FACEBOOK INC                                  VP OF VR     525,000   \n",
       "22550  FACEBOOK INC                        WEB ANALYTICS LEAD     165,000   \n",
       "22551  FACEBOOK INC         WIRELESS COMMUNICATION RESEARCHER     145,000   \n",
       "22552  FACEBOOK INC  WIRELESS COMMUNICATIONS SYSTEMS ENGINEER     120,000   \n",
       "22553  FACEBOOK INC                 WIRELESS SYSTEMS ENGINEER     130,000   \n",
       "\n",
       "                 LOCATION SUBMIT DATE  START DATE CASE STATUS  \n",
       "22549      MENLO PARK, CA  02/06/2018  08/06/2018   CERTIFIED  \n",
       "22550      MENLO PARK, CA  08/16/2017  09/04/2017   CERTIFIED  \n",
       "22551      MENLO PARK, CA  12/15/2016  06/14/2017   CERTIFIED  \n",
       "22552  WOODLAND HILLS, CA  12/16/2016  06/15/2017   CERTIFIED  \n",
       "22553      MENLO PARK, CA  03/07/2016  08/25/2016   CERTIFIED  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#combine the indiviual dataframes into one big dataframe\n",
    "df = pd.concat(collection).reset_index(drop=True)\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['EMPLOYER', 'JOB TITLE', 'BASE SALARY', 'LOCATION', 'SUBMIT DATE',\n",
       "       'START DATE', 'CASE STATUS'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "22554"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Clean the Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#get a fresh DF\n",
    "df_ = pd.concat(collection).reset_index(drop=True)\n",
    "\n",
    "#strip the comma, cast to 'int'\n",
    "df_['BASE SALARY'] = df_['BASE SALARY'].str.replace(',','').astype(int)\n",
    "type(df_['BASE SALARY'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>EMPLOYER</th>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th>BASE SALARY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>SUBMIT DATE</th>\n",
       "      <th>START DATE</th>\n",
       "      <th>CASE STATUS</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>1615.29860</td>\n",
       "      <td>115000</td>\n",
       "      <td>KIRKLAND, WA</td>\n",
       "      <td>01/26/2018</td>\n",
       "      <td>07/25/2018</td>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>WA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>1615.34491</td>\n",
       "      <td>93000</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>11/28/2017</td>\n",
       "      <td>01/22/2018</td>\n",
       "      <td>DENIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>1615.34491</td>\n",
       "      <td>93000</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>12/07/2017</td>\n",
       "      <td>01/22/2018</td>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GOOGLE INC</td>\n",
       "      <td>ACCOUNT ANALYST</td>\n",
       "      <td>121402</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>12/16/2015</td>\n",
       "      <td>04/05/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GOOGLE INC</td>\n",
       "      <td>ACCOUNT ASSOCIATE</td>\n",
       "      <td>74700</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>01/07/2015</td>\n",
       "      <td>05/07/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     EMPLOYER          JOB TITLE  BASE SALARY           LOCATION SUBMIT DATE  \\\n",
       "0  GOOGLE LLC         1615.29860       115000       KIRKLAND, WA  01/26/2018   \n",
       "1  GOOGLE LLC         1615.34491        93000  MOUNTAIN VIEW, CA  11/28/2017   \n",
       "2  GOOGLE LLC         1615.34491        93000  MOUNTAIN VIEW, CA  12/07/2017   \n",
       "3  GOOGLE INC    ACCOUNT ANALYST       121402       NEW YORK, NY  12/16/2015   \n",
       "4  GOOGLE INC  ACCOUNT ASSOCIATE        74700  MOUNTAIN VIEW, CA  01/07/2015   \n",
       "\n",
       "   START DATE CASE STATUS STATE  \n",
       "0  07/25/2018   WITHDRAWN    WA  \n",
       "1  01/22/2018      DENIED    CA  \n",
       "2  01/22/2018   WITHDRAWN    CA  \n",
       "3  04/05/2016   CERTIFIED    NY  \n",
       "4  05/07/2015   CERTIFIED    CA  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#add a column for the state state\n",
    "newcol = df_['LOCATION'].apply(lambda x: x.split(', ') [-1])\n",
    "df_['STATE'] = newcol\n",
    "df_.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Basic Aggregation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>count</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EMPLOYER</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>GOOGLE INC</th>\n",
       "      <td>12834</td>\n",
       "      <td>1139001</td>\n",
       "      <td>131253.485</td>\n",
       "      <td>56000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FACEBOOK INC</th>\n",
       "      <td>5659</td>\n",
       "      <td>525000</td>\n",
       "      <td>146641.252</td>\n",
       "      <td>48880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOOGLE LLC</th>\n",
       "      <td>4014</td>\n",
       "      <td>370000</td>\n",
       "      <td>134978.110</td>\n",
       "      <td>54500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOOGLE LIFE SCIENCES LLC</th>\n",
       "      <td>34</td>\n",
       "      <td>200000</td>\n",
       "      <td>132207.118</td>\n",
       "      <td>102000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FACEBOOK MIAMI INC</th>\n",
       "      <td>4</td>\n",
       "      <td>275256</td>\n",
       "      <td>186742.750</td>\n",
       "      <td>90000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FACEBOOK SERVICES INC</th>\n",
       "      <td>3</td>\n",
       "      <td>140000</td>\n",
       "      <td>136000.000</td>\n",
       "      <td>130000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOOGLE CAPITAL MANAGEMENT COMPANY LLC</th>\n",
       "      <td>3</td>\n",
       "      <td>156000</td>\n",
       "      <td>149166.667</td>\n",
       "      <td>136500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOOGLE VENTURES MANAGEMENT COMPANY LLC</th>\n",
       "      <td>2</td>\n",
       "      <td>152467</td>\n",
       "      <td>151233.500</td>\n",
       "      <td>150000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FACEBOOK PAYMENTS INC</th>\n",
       "      <td>1</td>\n",
       "      <td>163400</td>\n",
       "      <td>163400.000</td>\n",
       "      <td>163400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        count      max        mean     min\n",
       "EMPLOYER                                                                  \n",
       "GOOGLE INC                              12834  1139001  131253.485   56000\n",
       "FACEBOOK INC                             5659   525000  146641.252   48880\n",
       "GOOGLE LLC                               4014   370000  134978.110   54500\n",
       "GOOGLE LIFE SCIENCES LLC                   34   200000  132207.118  102000\n",
       "FACEBOOK MIAMI INC                          4   275256  186742.750   90000\n",
       "FACEBOOK SERVICES INC                       3   140000  136000.000  130000\n",
       "GOOGLE CAPITAL MANAGEMENT COMPANY LLC       3   156000  149166.667  136500\n",
       "GOOGLE VENTURES MANAGEMENT COMPANY LLC      2   152467  151233.500  150000\n",
       "FACEBOOK PAYMENTS INC                       1   163400  163400.000  163400"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agglist = ('count','mean', 'min', 'max')\n",
    "pd.set_option('precision',3)\n",
    "\n",
    "temp3 = df_.pivot_table('BASE SALARY', index = [\"EMPLOYER\"], aggfunc = agglist)\n",
    "\n",
    "temp3.sort_values('count', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>EMPLOYER</th>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th>BASE SALARY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>SUBMIT DATE</th>\n",
       "      <th>START DATE</th>\n",
       "      <th>CASE STATUS</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>16887</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>360 VIDEO PRODUCT MARKETING MANAGER</td>\n",
       "      <td>100000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/22/2016</td>\n",
       "      <td>01/02/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16888</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>360 VIDEO PRODUCT MARKETING MANAGER</td>\n",
       "      <td>125400</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/19/2018</td>\n",
       "      <td>08/15/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16889</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ABUSE ANALYST</td>\n",
       "      <td>110000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>04/20/2015</td>\n",
       "      <td>05/18/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16890</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCESS MANAGEMENT LEAD</td>\n",
       "      <td>114642</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/02/2018</td>\n",
       "      <td>08/28/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16891</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCESS MANAGEMENT LEAD(INTERNAL TOOLS)</td>\n",
       "      <td>114642</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/11/2017</td>\n",
       "      <td>09/09/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16892</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCOUNT MANAGER</td>\n",
       "      <td>85000</td>\n",
       "      <td>CHICAGO, IL</td>\n",
       "      <td>03/19/2014</td>\n",
       "      <td>09/18/2014</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>IL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16893</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCOUNT MANAGER, SMALL &amp; MEDIUM BUSINESS</td>\n",
       "      <td>79914</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>02/19/2015</td>\n",
       "      <td>08/19/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16894</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCOUNT MANAGER, SMB</td>\n",
       "      <td>94361</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/13/2017</td>\n",
       "      <td>09/05/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16895</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ACCOUNTING ANALYST</td>\n",
       "      <td>109000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>09/26/2016</td>\n",
       "      <td>10/10/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16896</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>AD ASSOCIATE</td>\n",
       "      <td>91369</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/06/2017</td>\n",
       "      <td>07/31/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16897</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS INTEGRITY ASSOCIATE</td>\n",
       "      <td>72900</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/20/2015</td>\n",
       "      <td>09/18/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16898</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS INTEGRITY ASSOCIATE</td>\n",
       "      <td>82508</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>03/17/2017</td>\n",
       "      <td>09/14/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16899</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS PRODUCT MEASUREMENT</td>\n",
       "      <td>112000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>07/20/2017</td>\n",
       "      <td>07/31/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16900</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS PRODUCT STRATEGY LEAD</td>\n",
       "      <td>132300</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>08/18/2017</td>\n",
       "      <td>08/28/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16901</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS PRODUCT STRATEGY LEAD</td>\n",
       "      <td>195000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/14/2018</td>\n",
       "      <td>02/26/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16902</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS PRODUCT STRATEGY LEAD</td>\n",
       "      <td>195000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/05/2018</td>\n",
       "      <td>08/01/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16903</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS RESEARCH LEAD</td>\n",
       "      <td>150000</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>03/09/2018</td>\n",
       "      <td>09/05/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16904</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADS RISK ANALYST</td>\n",
       "      <td>105000</td>\n",
       "      <td>AUSTIN, TX</td>\n",
       "      <td>09/25/2014</td>\n",
       "      <td>09/29/2014</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16905</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADVERTISING ANALYST</td>\n",
       "      <td>90629</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>02/05/2016</td>\n",
       "      <td>08/05/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16906</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADVERTISING AUDIENCE ANALYST</td>\n",
       "      <td>90000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>04/23/2015</td>\n",
       "      <td>04/27/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16907</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ADVERTISING OPTIMIZATION RESEARCHER (91.10133)</td>\n",
       "      <td>140419</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/02/2018</td>\n",
       "      <td>07/26/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16908</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>AERODYNAMICIST</td>\n",
       "      <td>120000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/21/2017</td>\n",
       "      <td>08/20/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16909</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>AEROSPACE ENGINEER</td>\n",
       "      <td>138125</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>06/20/2016</td>\n",
       "      <td>07/04/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16910</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>AGENCY MEASUREMENT LEAD</td>\n",
       "      <td>117000</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>07/15/2016</td>\n",
       "      <td>07/25/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16911</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>AGENT OPERATIONS SPECIALIST</td>\n",
       "      <td>120000</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>12/29/2017</td>\n",
       "      <td>01/08/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16912</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>AIRCRAFT NAGIVATION AND CONTROL ENGINEER</td>\n",
       "      <td>200000</td>\n",
       "      <td>WOODLAND HILLS, CA</td>\n",
       "      <td>02/01/2017</td>\n",
       "      <td>07/30/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16913</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ANALYST, GLOBAL VERTICAL STRATEGY</td>\n",
       "      <td>108332</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>03/18/2014</td>\n",
       "      <td>09/15/2014</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16914</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ANALYST, INSIGHTS &amp; OPERATIONS</td>\n",
       "      <td>114000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/19/2017</td>\n",
       "      <td>01/01/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16915</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ANALYST, INSIGHTS &amp; OPERATIONS</td>\n",
       "      <td>114000</td>\n",
       "      <td>SAN FRANCISCO, CA</td>\n",
       "      <td>01/24/2018</td>\n",
       "      <td>01/29/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16916</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>ANALYST, NEW PRODUCTS</td>\n",
       "      <td>79040</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>05/11/2016</td>\n",
       "      <td>05/23/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</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>22524</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>128000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/22/2016</td>\n",
       "      <td>06/21/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22525</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>130000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>07/12/2017</td>\n",
       "      <td>07/31/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22526</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>130329</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/10/2017</td>\n",
       "      <td>09/08/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22527</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>131874</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/12/2018</td>\n",
       "      <td>09/08/2018</td>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22528</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>131874</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/15/2018</td>\n",
       "      <td>09/08/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22529</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>135000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/05/2016</td>\n",
       "      <td>12/19/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22530</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>135000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/14/2016</td>\n",
       "      <td>01/02/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22531</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>135000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>06/04/2015</td>\n",
       "      <td>08/01/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22532</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>139650</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/12/2015</td>\n",
       "      <td>09/10/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22533</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>154400</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/01/2018</td>\n",
       "      <td>07/31/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22534</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>154400</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>03/19/2018</td>\n",
       "      <td>09/12/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22535</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER</td>\n",
       "      <td>160000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>01/26/2018</td>\n",
       "      <td>07/25/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22536</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>UX RESEARCHER (HUMAN FACTORS ENGINEER)</td>\n",
       "      <td>160000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>10/29/2015</td>\n",
       "      <td>11/09/2015</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22537</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VERTICAL MANAGER</td>\n",
       "      <td>177244</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>10/24/2013</td>\n",
       "      <td>11/18/2013</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22538</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VERTICAL MARKETING MANAGER</td>\n",
       "      <td>173000</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>01/03/2018</td>\n",
       "      <td>01/22/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22539</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VERTICAL MARKETING MANAGER</td>\n",
       "      <td>173000</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>01/29/2018</td>\n",
       "      <td>07/25/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22540</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VERTICAL MARKETING MANAGER</td>\n",
       "      <td>173000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>05/26/2017</td>\n",
       "      <td>06/12/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22541</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VERTICAL MEASUREMENT LEAD</td>\n",
       "      <td>130000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>11/01/2016</td>\n",
       "      <td>11/14/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22542</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VERTICAL MEASUREMENT LEAD</td>\n",
       "      <td>170000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>08/25/2016</td>\n",
       "      <td>09/05/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22543</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VIDEO PRODUCT MARKETING MANAGER</td>\n",
       "      <td>150000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>10/14/2016</td>\n",
       "      <td>10/31/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22544</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VIRTUAL REALITY SOFTWARE LEAD</td>\n",
       "      <td>207500</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>06/30/2017</td>\n",
       "      <td>07/17/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22545</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VISITING RESEARCHER</td>\n",
       "      <td>200000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/23/2017</td>\n",
       "      <td>05/01/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22546</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VISITING RESEARCHER</td>\n",
       "      <td>200000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>06/05/2017</td>\n",
       "      <td>11/02/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22547</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VISUALIZATION MANAGER, SPO MARKETING INTELLIGENCE</td>\n",
       "      <td>160000</td>\n",
       "      <td>CHICAGO, IL</td>\n",
       "      <td>10/20/2016</td>\n",
       "      <td>10/31/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>IL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22548</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VISUALIZATION MANAGER, SPO MARKETING INTELLIGENCE</td>\n",
       "      <td>174081</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>08/15/2017</td>\n",
       "      <td>08/28/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22549</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>VP OF VR</td>\n",
       "      <td>525000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>02/06/2018</td>\n",
       "      <td>08/06/2018</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22550</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WEB ANALYTICS LEAD</td>\n",
       "      <td>165000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>08/16/2017</td>\n",
       "      <td>09/04/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22551</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WIRELESS COMMUNICATION RESEARCHER</td>\n",
       "      <td>145000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>12/15/2016</td>\n",
       "      <td>06/14/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22552</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WIRELESS COMMUNICATIONS SYSTEMS ENGINEER</td>\n",
       "      <td>120000</td>\n",
       "      <td>WOODLAND HILLS, CA</td>\n",
       "      <td>12/16/2016</td>\n",
       "      <td>06/15/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22553</th>\n",
       "      <td>FACEBOOK INC</td>\n",
       "      <td>WIRELESS SYSTEMS ENGINEER</td>\n",
       "      <td>130000</td>\n",
       "      <td>MENLO PARK, CA</td>\n",
       "      <td>03/07/2016</td>\n",
       "      <td>08/25/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5659 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           EMPLOYER                                          JOB TITLE  \\\n",
       "16887  FACEBOOK INC                360 VIDEO PRODUCT MARKETING MANAGER   \n",
       "16888  FACEBOOK INC                360 VIDEO PRODUCT MARKETING MANAGER   \n",
       "16889  FACEBOOK INC                                      ABUSE ANALYST   \n",
       "16890  FACEBOOK INC                             ACCESS MANAGEMENT LEAD   \n",
       "16891  FACEBOOK INC             ACCESS MANAGEMENT LEAD(INTERNAL TOOLS)   \n",
       "16892  FACEBOOK INC                                    ACCOUNT MANAGER   \n",
       "16893  FACEBOOK INC           ACCOUNT MANAGER, SMALL & MEDIUM BUSINESS   \n",
       "16894  FACEBOOK INC                               ACCOUNT MANAGER, SMB   \n",
       "16895  FACEBOOK INC                                 ACCOUNTING ANALYST   \n",
       "16896  FACEBOOK INC                                       AD ASSOCIATE   \n",
       "16897  FACEBOOK INC                            ADS INTEGRITY ASSOCIATE   \n",
       "16898  FACEBOOK INC                            ADS INTEGRITY ASSOCIATE   \n",
       "16899  FACEBOOK INC                            ADS PRODUCT MEASUREMENT   \n",
       "16900  FACEBOOK INC                          ADS PRODUCT STRATEGY LEAD   \n",
       "16901  FACEBOOK INC                          ADS PRODUCT STRATEGY LEAD   \n",
       "16902  FACEBOOK INC                          ADS PRODUCT STRATEGY LEAD   \n",
       "16903  FACEBOOK INC                                  ADS RESEARCH LEAD   \n",
       "16904  FACEBOOK INC                                   ADS RISK ANALYST   \n",
       "16905  FACEBOOK INC                                ADVERTISING ANALYST   \n",
       "16906  FACEBOOK INC                       ADVERTISING AUDIENCE ANALYST   \n",
       "16907  FACEBOOK INC     ADVERTISING OPTIMIZATION RESEARCHER (91.10133)   \n",
       "16908  FACEBOOK INC                                     AERODYNAMICIST   \n",
       "16909  FACEBOOK INC                                 AEROSPACE ENGINEER   \n",
       "16910  FACEBOOK INC                            AGENCY MEASUREMENT LEAD   \n",
       "16911  FACEBOOK INC                        AGENT OPERATIONS SPECIALIST   \n",
       "16912  FACEBOOK INC           AIRCRAFT NAGIVATION AND CONTROL ENGINEER   \n",
       "16913  FACEBOOK INC                  ANALYST, GLOBAL VERTICAL STRATEGY   \n",
       "16914  FACEBOOK INC                     ANALYST, INSIGHTS & OPERATIONS   \n",
       "16915  FACEBOOK INC                     ANALYST, INSIGHTS & OPERATIONS   \n",
       "16916  FACEBOOK INC                              ANALYST, NEW PRODUCTS   \n",
       "...             ...                                                ...   \n",
       "22524  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22525  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22526  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22527  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22528  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22529  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22530  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22531  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22532  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22533  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22534  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22535  FACEBOOK INC                                      UX RESEARCHER   \n",
       "22536  FACEBOOK INC             UX RESEARCHER (HUMAN FACTORS ENGINEER)   \n",
       "22537  FACEBOOK INC                                   VERTICAL MANAGER   \n",
       "22538  FACEBOOK INC                         VERTICAL MARKETING MANAGER   \n",
       "22539  FACEBOOK INC                         VERTICAL MARKETING MANAGER   \n",
       "22540  FACEBOOK INC                         VERTICAL MARKETING MANAGER   \n",
       "22541  FACEBOOK INC                          VERTICAL MEASUREMENT LEAD   \n",
       "22542  FACEBOOK INC                          VERTICAL MEASUREMENT LEAD   \n",
       "22543  FACEBOOK INC                    VIDEO PRODUCT MARKETING MANAGER   \n",
       "22544  FACEBOOK INC                      VIRTUAL REALITY SOFTWARE LEAD   \n",
       "22545  FACEBOOK INC                                VISITING RESEARCHER   \n",
       "22546  FACEBOOK INC                                VISITING RESEARCHER   \n",
       "22547  FACEBOOK INC  VISUALIZATION MANAGER, SPO MARKETING INTELLIGENCE   \n",
       "22548  FACEBOOK INC  VISUALIZATION MANAGER, SPO MARKETING INTELLIGENCE   \n",
       "22549  FACEBOOK INC                                           VP OF VR   \n",
       "22550  FACEBOOK INC                                 WEB ANALYTICS LEAD   \n",
       "22551  FACEBOOK INC                  WIRELESS COMMUNICATION RESEARCHER   \n",
       "22552  FACEBOOK INC           WIRELESS COMMUNICATIONS SYSTEMS ENGINEER   \n",
       "22553  FACEBOOK INC                          WIRELESS SYSTEMS ENGINEER   \n",
       "\n",
       "       BASE SALARY            LOCATION SUBMIT DATE  START DATE CASE STATUS  \\\n",
       "16887       100000      MENLO PARK, CA  12/22/2016  01/02/2017   CERTIFIED   \n",
       "16888       125400      MENLO PARK, CA  02/19/2018  08/15/2018   CERTIFIED   \n",
       "16889       110000      MENLO PARK, CA  04/20/2015  05/18/2015   CERTIFIED   \n",
       "16890       114642          AUSTIN, TX  03/02/2018  08/28/2018   CERTIFIED   \n",
       "16891       114642          AUSTIN, TX  03/11/2017  09/09/2017   CERTIFIED   \n",
       "16892        85000         CHICAGO, IL  03/19/2014  09/18/2014   CERTIFIED   \n",
       "16893        79914          AUSTIN, TX  02/19/2015  08/19/2015   CERTIFIED   \n",
       "16894        94361          AUSTIN, TX  03/13/2017  09/05/2017   CERTIFIED   \n",
       "16895       109000      MENLO PARK, CA  09/26/2016  10/10/2016   CERTIFIED   \n",
       "16896        91369      MENLO PARK, CA  02/06/2017  07/31/2017   CERTIFIED   \n",
       "16897        72900          AUSTIN, TX  03/20/2015  09/18/2015   CERTIFIED   \n",
       "16898        82508          AUSTIN, TX  03/17/2017  09/14/2017   CERTIFIED   \n",
       "16899       112000      MENLO PARK, CA  07/20/2017  07/31/2017   CERTIFIED   \n",
       "16900       132300      MENLO PARK, CA  08/18/2017  08/28/2017   CERTIFIED   \n",
       "16901       195000      MENLO PARK, CA  02/14/2018  02/26/2018   CERTIFIED   \n",
       "16902       195000      MENLO PARK, CA  02/05/2018  08/01/2018   CERTIFIED   \n",
       "16903       150000        NEW YORK, NY  03/09/2018  09/05/2018   CERTIFIED   \n",
       "16904       105000          AUSTIN, TX  09/25/2014  09/29/2014   CERTIFIED   \n",
       "16905        90629        NEW YORK, NY  02/05/2016  08/05/2016   CERTIFIED   \n",
       "16906        90000      MENLO PARK, CA  04/23/2015  04/27/2015   CERTIFIED   \n",
       "16907       140419      MENLO PARK, CA  02/02/2018  07/26/2018   CERTIFIED   \n",
       "16908       120000      MENLO PARK, CA  02/21/2017  08/20/2017   CERTIFIED   \n",
       "16909       138125      MENLO PARK, CA  06/20/2016  07/04/2016   CERTIFIED   \n",
       "16910       117000        NEW YORK, NY  07/15/2016  07/25/2016   CERTIFIED   \n",
       "16911       120000   MOUNTAIN VIEW, CA  12/29/2017  01/08/2018   CERTIFIED   \n",
       "16912       200000  WOODLAND HILLS, CA  02/01/2017  07/30/2017   CERTIFIED   \n",
       "16913       108332        NEW YORK, NY  03/18/2014  09/15/2014   CERTIFIED   \n",
       "16914       114000      MENLO PARK, CA  12/19/2017  01/01/2018   CERTIFIED   \n",
       "16915       114000   SAN FRANCISCO, CA  01/24/2018  01/29/2018   CERTIFIED   \n",
       "16916        79040      MENLO PARK, CA  05/11/2016  05/23/2016   CERTIFIED   \n",
       "...            ...                 ...         ...         ...         ...   \n",
       "22524       128000      MENLO PARK, CA  12/22/2016  06/21/2017   CERTIFIED   \n",
       "22525       130000      MENLO PARK, CA  07/12/2017  07/31/2017   CERTIFIED   \n",
       "22526       130329      MENLO PARK, CA  03/10/2017  09/08/2017   CERTIFIED   \n",
       "22527       131874      MENLO PARK, CA  03/12/2018  09/08/2018   WITHDRAWN   \n",
       "22528       131874      MENLO PARK, CA  03/15/2018  09/08/2018   CERTIFIED   \n",
       "22529       135000      MENLO PARK, CA  12/05/2016  12/19/2016   CERTIFIED   \n",
       "22530       135000      MENLO PARK, CA  12/14/2016  01/02/2017   CERTIFIED   \n",
       "22531       135000      MENLO PARK, CA  06/04/2015  08/01/2015   CERTIFIED   \n",
       "22532       139650      MENLO PARK, CA  03/12/2015  09/10/2015   CERTIFIED   \n",
       "22533       154400      MENLO PARK, CA  02/01/2018  07/31/2018   CERTIFIED   \n",
       "22534       154400        NEW YORK, NY  03/19/2018  09/12/2018   CERTIFIED   \n",
       "22535       160000      MENLO PARK, CA  01/26/2018  07/25/2018   CERTIFIED   \n",
       "22536       160000      MENLO PARK, CA  10/29/2015  11/09/2015   CERTIFIED   \n",
       "22537       177244      MENLO PARK, CA  10/24/2013  11/18/2013   CERTIFIED   \n",
       "22538       173000        NEW YORK, NY  01/03/2018  01/22/2018   CERTIFIED   \n",
       "22539       173000        NEW YORK, NY  01/29/2018  07/25/2018   CERTIFIED   \n",
       "22540       173000      MENLO PARK, CA  05/26/2017  06/12/2017   CERTIFIED   \n",
       "22541       130000      MENLO PARK, CA  11/01/2016  11/14/2016   CERTIFIED   \n",
       "22542       170000      MENLO PARK, CA  08/25/2016  09/05/2016   CERTIFIED   \n",
       "22543       150000      MENLO PARK, CA  10/14/2016  10/31/2016   CERTIFIED   \n",
       "22544       207500      MENLO PARK, CA  06/30/2017  07/17/2017   CERTIFIED   \n",
       "22545       200000      MENLO PARK, CA  03/23/2017  05/01/2017   CERTIFIED   \n",
       "22546       200000      MENLO PARK, CA  06/05/2017  11/02/2017   CERTIFIED   \n",
       "22547       160000         CHICAGO, IL  10/20/2016  10/31/2016   CERTIFIED   \n",
       "22548       174081      MENLO PARK, CA  08/15/2017  08/28/2017   CERTIFIED   \n",
       "22549       525000      MENLO PARK, CA  02/06/2018  08/06/2018   CERTIFIED   \n",
       "22550       165000      MENLO PARK, CA  08/16/2017  09/04/2017   CERTIFIED   \n",
       "22551       145000      MENLO PARK, CA  12/15/2016  06/14/2017   CERTIFIED   \n",
       "22552       120000  WOODLAND HILLS, CA  12/16/2016  06/15/2017   CERTIFIED   \n",
       "22553       130000      MENLO PARK, CA  03/07/2016  08/25/2016   CERTIFIED   \n",
       "\n",
       "      STATE  \n",
       "16887    CA  \n",
       "16888    CA  \n",
       "16889    CA  \n",
       "16890    TX  \n",
       "16891    TX  \n",
       "16892    IL  \n",
       "16893    TX  \n",
       "16894    TX  \n",
       "16895    CA  \n",
       "16896    CA  \n",
       "16897    TX  \n",
       "16898    TX  \n",
       "16899    CA  \n",
       "16900    CA  \n",
       "16901    CA  \n",
       "16902    CA  \n",
       "16903    NY  \n",
       "16904    TX  \n",
       "16905    NY  \n",
       "16906    CA  \n",
       "16907    CA  \n",
       "16908    CA  \n",
       "16909    CA  \n",
       "16910    NY  \n",
       "16911    CA  \n",
       "16912    CA  \n",
       "16913    NY  \n",
       "16914    CA  \n",
       "16915    CA  \n",
       "16916    CA  \n",
       "...     ...  \n",
       "22524    CA  \n",
       "22525    CA  \n",
       "22526    CA  \n",
       "22527    CA  \n",
       "22528    CA  \n",
       "22529    CA  \n",
       "22530    CA  \n",
       "22531    CA  \n",
       "22532    CA  \n",
       "22533    CA  \n",
       "22534    NY  \n",
       "22535    CA  \n",
       "22536    CA  \n",
       "22537    CA  \n",
       "22538    NY  \n",
       "22539    NY  \n",
       "22540    CA  \n",
       "22541    CA  \n",
       "22542    CA  \n",
       "22543    CA  \n",
       "22544    CA  \n",
       "22545    CA  \n",
       "22546    CA  \n",
       "22547    IL  \n",
       "22548    CA  \n",
       "22549    CA  \n",
       "22550    CA  \n",
       "22551    CA  \n",
       "22552    CA  \n",
       "22553    CA  \n",
       "\n",
       "[5659 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "facebook= df_[df_['EMPLOYER']=='FACEBOOK INC']\n",
    "facebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SOFTWARE_ENGINEER                                      2599\n",
       "RESEARCH SCIENTIST                                      237\n",
       "DATA ENGINEER                                           179\n",
       "DATA SCIENTIST                                          173\n",
       "PRODUCTION ENGINEER                                     158\n",
       "PRODUCT MANAGER                                         127\n",
       "PRODUCT DESIGNER                                        121\n",
       "ENGINEERING MANAGER                                     103\n",
       "FRONT END ENGINEER                                       82\n",
       "TECHNICAL PROGRAM MANAGER                                60\n",
       "APPLICATION ENGINEER                                     58\n",
       "SOLUTIONS ENGINEER                                       40\n",
       "UX RESEARCHER                                            39\n",
       "DEVELOPER_                                               38\n",
       "NETWORK ENGINEER                                         29\n",
       "GROWTH MARKETING ANALYST                                 27\n",
       "CLIENT SOLUTIONS MANAGER                                 24\n",
       "SECURITY ENGINEER                                        23\n",
       "SMB ANALYST                                              19\n",
       "ENTERPRISE ENGINEER                                      19\n",
       "NETWORK INFRASTRUCTURE ENGINEER                          18\n",
       "DATA SCIENTIST, ANALYTICS                                17\n",
       "CONTENT STRATEGIST                                       17\n",
       "HARDWARE ENGINEER                                        17\n",
       "PRODUCT MARKETING MANAGER                                17\n",
       "PARTNER ENGINEER                                         15\n",
       "PERFORMANCE AND CAPACITY ENGINEER                        15\n",
       "DATA ENGINEER, ANALYTICS                                 15\n",
       "SYSTEMS ENGINEER                                         15\n",
       "OPERATIONS PROGRAM MANAGER                               14\n",
       "                                                       ... \n",
       "DIR. OF INT'L BUS. DEV. AND OPERATOR PARTNERSHIPS         1\n",
       "ANALYTICS ENGINEER                                        1\n",
       "SECURITY DATA ANALYTICS ENGINEER                          1\n",
       "DATA CENTER ENVIRONMENTAL COORDINATOR                     1\n",
       "RESEARCH SCIENTIST, ARTIFICIAL INTELLIGENCE               1\n",
       "REVENUE ACCOUNTANT                                        1\n",
       "DATABASE PERFORMANCE ENGINEER                             1\n",
       "HARDWARE APPLICATION ENGINEER                             1\n",
       "ADVERTISING OPTIMIZATION RESEARCHER (91.10133)            1\n",
       "TRAINING COORDINATOR SPECIALIST                           1\n",
       "QUANTITATIVE RESEARCHER, MARKETING SCIENCE RESEARCH       1\n",
       "HCM INTEGRATIONS SPECIALIST                               1\n",
       "DATA CENTER PLANNING MANAGER                              1\n",
       "MANAGER, BUSINESS OPERATIONS                              1\n",
       "QUANTITATIVE RESEARCHER (91.7799)                         1\n",
       "ADS PRODUCT MEASUREMENT                                   1\n",
       "ASSOCIATE GENERAL COUNSEL - PRIVACY/PRODUCT               1\n",
       "ANALYTICS PROGRAM MANAGER                                 1\n",
       "DATA SCIENTIST, ECONOMIC RESEARCH                         1\n",
       "SAFETY PROGRAM MANAGER, GLOBAL                            1\n",
       "HARDWARE SUSTAINING ENGINEER, ANALYTICS                   1\n",
       "SMB ANALYTICS MANAGER                                     1\n",
       "PROGRAM MANAGER, EMERGING PRODUCTS                        1\n",
       "MM-WAVE HARDWARE ENGINEER                                 1\n",
       "ENTERPRISE PRODUCT MANAGER, DATA                          1\n",
       "GLOBAL DISTRIBUTION LOGISTICS MANAGER                     1\n",
       "DATA SCIENCE ANALYTICS MANAGER                            1\n",
       "RESEARCH SCIENTIST (91.6249)                              1\n",
       "VERTICAL MANAGER                                          1\n",
       "SOLUTIONS ENGINEER 91.133693                              1\n",
       "Name: JOB TITLE, Length: 760, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "facebook['JOB TITLE'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SOFTWARE ENGINEER                                         9007\n",
       "PRODUCT MANAGER                                            291\n",
       "RESEARCH SCIENTIST                                         280\n",
       "SOFTWARE ENGINEER IN TEST                                  207\n",
       "DATA ENGINEER                                              179\n",
       "DATA SCIENTIST                                             177\n",
       "TECHNICAL PROGRAM MANAGER                                  173\n",
       "PRODUCTION ENGINEER                                        158\n",
       "PROGRAM MANAGER                                            139\n",
       "HARDWARE ENGINEER                                          133\n",
       "PRODUCT DESIGNER                                           122\n",
       "ENGINEERING MANAGER                                        105\n",
       "TEST ENGINEER                                              104\n",
       "NETWORK ENGINEER                                            93\n",
       "QUANTITATIVE ANALYST                                        91\n",
       "BUSINESS SYSTEMS INTEGRATOR                                 90\n",
       "INTERACTION DESIGNER                                        83\n",
       "FRONT END ENGINEER                                          82\n",
       "SOFTWARE ENGINEER, TOOLS AND INFRASTRUCTURE                 80\n",
       "APPLICATION ENGINEER                                        69\n",
       "FINANCIAL ANALYST                                           55\n",
       "SITE RELIABILITY ENGINEER                                   53\n",
       "PRODUCT MARKETING MANAGER                                   49\n",
       "BUSINESS ANALYST                                            48\n",
       "UX RESEARCHER                                               45\n",
       "SECURITY ENGINEER                                           42\n",
       "SOLUTIONS ENGINEER                                          41\n",
       "TECHNICAL SOLUTIONS CONSULTANT                              37\n",
       "SOFTWARE ENGINEERING MANAGER                                34\n",
       "USER INTERFACE DESIGNER                                     31\n",
       "                                                          ... \n",
       "SOFTWARE ENGINEER (1615.17694)                               1\n",
       "TECHNICAL PROGRAM MANAGER 1615.24989                         1\n",
       "SOFTWARE ENGINEER 1615.34336                                 1\n",
       "SOFTWARE ENGINEER 1615.28874                                 1\n",
       "TEST ENGINEER 1615.35765                                     1\n",
       "SOLUTIONS CONSULTANT 1615.37393                              1\n",
       "LEAD PARTNER SOLUTIONS SPECIALIST                            1\n",
       "SOFTWARE ENGINEER (1615.33509)                               1\n",
       "SOFTWARE ENGINEER (1615.18254)                               1\n",
       "SOFTWARE ENGINEER 1615.2949                                  1\n",
       "PRODUCT MANAGER 1615.320                                     1\n",
       "CREATIVE (MOTION GRAPHIC DESIGNER)                           1\n",
       "MARKET ANALYST, SMB                                          1\n",
       "SOFTWARE ENGINEER, TOOLS AND INFRASTRUCTURE 1615.16650       1\n",
       "SOFTWARE ENGINEER 1615.34473                                 1\n",
       "SOFTWARE ENGINEER (1615.35607)                               1\n",
       "SOFTWARE ENGINEER 1615.28754                                 1\n",
       "SOFTWARE ENGINEER (1615.32147)                               1\n",
       "GLOBAL PROGRAM MANAGER 1615.1504                             1\n",
       "SOFTWARE ENGINEER (1615.37223)                               1\n",
       "SOFTWARE ENGINEER 1615.34492                                 1\n",
       "SOFTWARE ENGINEER 1615.35040                                 1\n",
       "MANAGER, YOUTUBE OERATIONS                                   1\n",
       "SOFTWARE ENGINEER 1615.28894                                 1\n",
       "SOFTWARE ENGINEER 1615.34649                                 1\n",
       "SOFTWARE ENGINEER 1615.30547                                 1\n",
       "HEAD OF FINANCIAL RISK STRATEGY                              1\n",
       "HARDWARE ENGINEER   1615.37199                               1\n",
       "SOFTWARE ENGINEER 1615.26762                                 1\n",
       "SOFTWARE ENGINEER 1615.10729                                 1\n",
       "Name: JOB TITLE, Length: 7935, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#show types of jobs\n",
    "df_['JOB TITLE'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Facebook Only"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SOFTWARE ENGINEER                               2519\n",
       "RESEARCH SCIENTIST                               237\n",
       "DATA ENGINEER                                    179\n",
       "DATA SCIENTIST                                   173\n",
       "PRODUCTION ENGINEER                              158\n",
       "PRODUCT MANAGER                                  127\n",
       "PRODUCT DESIGNER                                 121\n",
       "ENGINEERING MANAGER                              103\n",
       "FRONT END ENGINEER                                82\n",
       "TECHNICAL PROGRAM MANAGER                         60\n",
       "APPLICATION ENGINEER                              58\n",
       "SOLUTIONS ENGINEER                                40\n",
       "UX RESEARCHER                                     39\n",
       "NETWORK ENGINEER                                  29\n",
       "SOFTWARE ENGINEERING MANAGER                      28\n",
       "GROWTH MARKETING ANALYST                          27\n",
       "CLIENT SOLUTIONS MANAGER                          24\n",
       "SECURITY ENGINEER                                 23\n",
       "SMB ANALYST                                       19\n",
       "ENTERPRISE ENGINEER                               19\n",
       "NETWORK INFRASTRUCTURE ENGINEER                   18\n",
       "HARDWARE ENGINEER                                 17\n",
       "CONTENT STRATEGIST                                17\n",
       "DATA SCIENTIST, ANALYTICS                         17\n",
       "PRODUCT MARKETING MANAGER                         17\n",
       "PARTNER ENGINEER                                  15\n",
       "DATA ENGINEER, ANALYTICS                          15\n",
       "PERFORMANCE AND CAPACITY ENGINEER                 15\n",
       "SYSTEMS ENGINEER                                  15\n",
       "DECISION SCIENTIST                                14\n",
       "                                                ... \n",
       "DEVELOPER SUPPORT ENGINEER (91.11607)              1\n",
       "MANAGER, PRODUCT DESIGN                            1\n",
       "HARDWARE SYSTEMS ENGINEER                          1\n",
       "MANAGER, PARTNER ENGINEERING                       1\n",
       "MARKETING COMMUNICATIONS MANAGER                   1\n",
       "PRODUCT MARKETING LEAD, ECOMMERCE                  1\n",
       "DATA ENGINGEER                                     1\n",
       "COMPUTER VISION SOFTWARE ENGINEER                  1\n",
       "ASSOCIATE, COMMUNITY OPERATIONS                    1\n",
       "RESEARCH SCIENTIST, ARTIFICIAL INTELLIGENCE        1\n",
       "TECHNICAL INFOSEC COMPLIANCE SPECIALIST            1\n",
       "DCC RETROFIT PROJECT  MANAGER                      1\n",
       "PRODUCTION DATABASE MANAGER                        1\n",
       "TECHNICAL PROGRAM MANAGER (91.12801)               1\n",
       "PRE-CONSTRUCTION MANAGER                           1\n",
       "ORACLE APPLICATIONS DEVELOPER                      1\n",
       "DATA SCIENTIST, PRODUCT                            1\n",
       "SOLUTIONS ENGINEER (91.13427)                      1\n",
       "OPERATIONS RESEARCH SCIENTIST                      1\n",
       "MANAGER, OPEN SOURCE & DEVELOPER PROGRAMS          1\n",
       "SMALL & MEDIUM BUSINESS ANALYST                    1\n",
       "MARKETING MANAGER, SMALL AND MEDIUM BUSINESS       1\n",
       "PERFORMANCE & CAPACITY ENGINEER                    1\n",
       "OPERATIONS PRODUCT MANAGER                         1\n",
       "GLOBAL SECURITY INTELLIGENCE ANALYST               1\n",
       "QUALITY SPECIALIST                                 1\n",
       "NETWORK DEPLOYMENT & SUPPORT MANAGER               1\n",
       "ONLINE MARKETING ASSOCIATE                         1\n",
       "DATABASE/SQL SERVER ENGINEER                       1\n",
       "SOFTWARE RESEARCH ENGINEER                         1\n",
       "Name: JOB TITLE, Length: 814, dtype: int64"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#show types of jobs\n",
    "df_2 = collection[1] #Company2 df\n",
    "\n",
    "df_2['BASE SALARY']= df_2['BASE SALARY'].astype(int)\n",
    "\n",
    "df_2['JOB TITLE'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>count</th>\n",
       "      <th>max</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>VP OF VR</th>\n",
       "      <td>1</td>\n",
       "      <td>525000</td>\n",
       "      <td>525000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIRECTOR, PRODUCT MANAGEMENT</th>\n",
       "      <td>2</td>\n",
       "      <td>340000</td>\n",
       "      <td>340000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIRECTOR, NETWORK INVESTMENTS</th>\n",
       "      <td>1</td>\n",
       "      <td>320000</td>\n",
       "      <td>320000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENGINEERING DIRECTOR</th>\n",
       "      <td>2</td>\n",
       "      <td>297577</td>\n",
       "      <td>293788.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIRECTOR, RESEARCH SCIENCE</th>\n",
       "      <td>1</td>\n",
       "      <td>283194</td>\n",
       "      <td>283194.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIR. OF INT'L BUS. DEV. AND OPERATOR PARTNERSHIPS</th>\n",
       "      <td>1</td>\n",
       "      <td>280000</td>\n",
       "      <td>280000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HEAD OF PAN REGIONAL</th>\n",
       "      <td>1</td>\n",
       "      <td>275256</td>\n",
       "      <td>275256.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PUBLISHER EXPERIENCE DIRECTOR</th>\n",
       "      <td>1</td>\n",
       "      <td>275000</td>\n",
       "      <td>275000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIRECTOR, ENGINEERING</th>\n",
       "      <td>3</td>\n",
       "      <td>297984</td>\n",
       "      <td>270529.667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ANALYTICS DIRECTOR</th>\n",
       "      <td>1</td>\n",
       "      <td>260713</td>\n",
       "      <td>260713.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRODUCT DESIGN DIRECTOR</th>\n",
       "      <td>5</td>\n",
       "      <td>266485</td>\n",
       "      <td>255297.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEDIA PARTNERSHIPS, LATAM</th>\n",
       "      <td>1</td>\n",
       "      <td>250900</td>\n",
       "      <td>250900.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INTERFACE ENGINEER</th>\n",
       "      <td>2</td>\n",
       "      <td>250000</td>\n",
       "      <td>250000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIRECTOR OF FINANCIAL PLANNING &amp; ANALYSIS</th>\n",
       "      <td>1</td>\n",
       "      <td>250000</td>\n",
       "      <td>250000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SUPPLY CHAIN ENGINEERING, FATP LEAD</th>\n",
       "      <td>1</td>\n",
       "      <td>250000</td>\n",
       "      <td>250000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE GENERAL COUNSEL, PRIVACY &amp; PRODUCT</th>\n",
       "      <td>1</td>\n",
       "      <td>241006</td>\n",
       "      <td>241006.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IOT ENGINEERING LEAD</th>\n",
       "      <td>1</td>\n",
       "      <td>240000</td>\n",
       "      <td>240000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B8 TECHNICAL PROJECT ASSOCIATE</th>\n",
       "      <td>1</td>\n",
       "      <td>240000</td>\n",
       "      <td>240000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INNOVATIONS PRODUCT MANAGER</th>\n",
       "      <td>1</td>\n",
       "      <td>240000</td>\n",
       "      <td>240000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GLOBAL INTELLECTUAL PROPERTY AND PRIVACY OPERATIONS DIRECTOR</th>\n",
       "      <td>1</td>\n",
       "      <td>235000</td>\n",
       "      <td>235000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SALES OPERATIONS LEAD</th>\n",
       "      <td>1</td>\n",
       "      <td>231250</td>\n",
       "      <td>231250.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARKETING PROGRAM MANAGER</th>\n",
       "      <td>1</td>\n",
       "      <td>230000</td>\n",
       "      <td>230000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE GENERAL COUNSEL</th>\n",
       "      <td>1</td>\n",
       "      <td>229202</td>\n",
       "      <td>229202.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SALES OPERATIONS MANAGER, RESELLER &amp; PARTNERSHIP</th>\n",
       "      <td>1</td>\n",
       "      <td>227614</td>\n",
       "      <td>227614.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SECURITY PARTNER</th>\n",
       "      <td>2</td>\n",
       "      <td>225000</td>\n",
       "      <td>225000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ECOSYSTEMS PARTNER MANAGER</th>\n",
       "      <td>1</td>\n",
       "      <td>225000</td>\n",
       "      <td>225000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HEAD OF PRODUCT, PEOPLE INSIGHTS AND ENGINEERING</th>\n",
       "      <td>1</td>\n",
       "      <td>225000</td>\n",
       "      <td>225000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TAX MANAGER</th>\n",
       "      <td>1</td>\n",
       "      <td>225000</td>\n",
       "      <td>225000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SECURITY PARTNER, ENTERPRISE PRODUCTS</th>\n",
       "      <td>1</td>\n",
       "      <td>225000</td>\n",
       "      <td>225000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE GENERAL COUNSEL - PRIVACY/PRODUCT</th>\n",
       "      <td>1</td>\n",
       "      <td>224158</td>\n",
       "      <td>224158.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NORTH AMERICA MARKET SPECIALIST, COMMUNITY OPERATIONS</th>\n",
       "      <td>1</td>\n",
       "      <td>82508</td>\n",
       "      <td>82508.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRAPH INTEGRITY PROCESS SPECIALIST</th>\n",
       "      <td>1</td>\n",
       "      <td>81225</td>\n",
       "      <td>81225.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MOBILE ADVERTISING ACCOUNT MANAGER</th>\n",
       "      <td>1</td>\n",
       "      <td>81000</td>\n",
       "      <td>81000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARKETING MANAGER SEO, SMB</th>\n",
       "      <td>1</td>\n",
       "      <td>81000</td>\n",
       "      <td>81000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TOOLING PROJECT MANAGER</th>\n",
       "      <td>2</td>\n",
       "      <td>89898</td>\n",
       "      <td>80486.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PEOPLE OPERATIONS HR SPECIALIST</th>\n",
       "      <td>3</td>\n",
       "      <td>84553</td>\n",
       "      <td>80252.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENTITIES SPECIALIST</th>\n",
       "      <td>2</td>\n",
       "      <td>90160</td>\n",
       "      <td>80076.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DATA CENTER ENGINEER</th>\n",
       "      <td>1</td>\n",
       "      <td>80018</td>\n",
       "      <td>80018.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FP&amp;A ANALYST</th>\n",
       "      <td>1</td>\n",
       "      <td>80000</td>\n",
       "      <td>80000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COMMUNITY ESCALATIONS SPECIALIST</th>\n",
       "      <td>1</td>\n",
       "      <td>80000</td>\n",
       "      <td>80000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ACCOUNT MANAGER, SMALL &amp; MEDIUM BUSINESS</th>\n",
       "      <td>1</td>\n",
       "      <td>79914</td>\n",
       "      <td>79914.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE, COMMUNITY OPERATIONS</th>\n",
       "      <td>1</td>\n",
       "      <td>79914</td>\n",
       "      <td>79914.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOFTWARE ENGINEER INTERN</th>\n",
       "      <td>1</td>\n",
       "      <td>79200</td>\n",
       "      <td>79200.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ONLINE MARKETING ASSOCIATE</th>\n",
       "      <td>1</td>\n",
       "      <td>78228</td>\n",
       "      <td>78228.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE PRODUCT MARKETING MANAGER</th>\n",
       "      <td>1</td>\n",
       "      <td>78000</td>\n",
       "      <td>78000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ADS INTEGRITY ASSOCIATE</th>\n",
       "      <td>2</td>\n",
       "      <td>82508</td>\n",
       "      <td>77704.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPECIALIST, MEDIA ANALYTICS</th>\n",
       "      <td>1</td>\n",
       "      <td>75296</td>\n",
       "      <td>75296.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPECIALIST, PMD INFRASTRUCTURE</th>\n",
       "      <td>1</td>\n",
       "      <td>75005</td>\n",
       "      <td>75005.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARKETING ANALYTICS ASSOCIATE</th>\n",
       "      <td>1</td>\n",
       "      <td>75000</td>\n",
       "      <td>75000.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RECRUITING COORDINATOR</th>\n",
       "      <td>1</td>\n",
       "      <td>74048</td>\n",
       "      <td>74048.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPECIALIST, COMMUNITY OPERATIONS (INTELLECTUAL PROPERTY)</th>\n",
       "      <td>1</td>\n",
       "      <td>72280</td>\n",
       "      <td>72280.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRODUCT RELEASE SPECIALIST</th>\n",
       "      <td>1</td>\n",
       "      <td>71198</td>\n",
       "      <td>71198.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BUSINESS INTEGRITY SPECIALIST</th>\n",
       "      <td>3</td>\n",
       "      <td>79943</td>\n",
       "      <td>70972.333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRODUCT DEVELOPMENT SPECIALIST</th>\n",
       "      <td>1</td>\n",
       "      <td>70720</td>\n",
       "      <td>70720.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TRAINING COORDINATOR SPECIALIST</th>\n",
       "      <td>1</td>\n",
       "      <td>70158</td>\n",
       "      <td>70158.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DIVERSITY PROGRAMS SPECIALIST</th>\n",
       "      <td>1</td>\n",
       "      <td>69992</td>\n",
       "      <td>69992.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPECIALIST, PUBLIC CONTENT OPERATIONS</th>\n",
       "      <td>5</td>\n",
       "      <td>69659</td>\n",
       "      <td>67545.800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPECIALIST, RISK OPERATIONS</th>\n",
       "      <td>1</td>\n",
       "      <td>67496</td>\n",
       "      <td>67496.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPECIALIST, GSS - INSIGHTS</th>\n",
       "      <td>1</td>\n",
       "      <td>67454</td>\n",
       "      <td>67454.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CLIENT SOLUTIONS MANAGER, TECH/TELCO</th>\n",
       "      <td>1</td>\n",
       "      <td>64709</td>\n",
       "      <td>64709.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>814 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    count     max        mean\n",
       "JOB TITLE                                                                    \n",
       "VP OF VR                                                1  525000  525000.000\n",
       "DIRECTOR, PRODUCT MANAGEMENT                            2  340000  340000.000\n",
       "DIRECTOR, NETWORK INVESTMENTS                           1  320000  320000.000\n",
       "ENGINEERING DIRECTOR                                    2  297577  293788.500\n",
       "DIRECTOR, RESEARCH SCIENCE                              1  283194  283194.000\n",
       "DIR. OF INT'L BUS. DEV. AND OPERATOR PARTNERSHIPS       1  280000  280000.000\n",
       "HEAD OF PAN REGIONAL                                    1  275256  275256.000\n",
       "PUBLISHER EXPERIENCE DIRECTOR                           1  275000  275000.000\n",
       "DIRECTOR, ENGINEERING                                   3  297984  270529.667\n",
       "ANALYTICS DIRECTOR                                      1  260713  260713.000\n",
       "PRODUCT DESIGN DIRECTOR                                 5  266485  255297.000\n",
       "MEDIA PARTNERSHIPS, LATAM                               1  250900  250900.000\n",
       "INTERFACE ENGINEER                                      2  250000  250000.000\n",
       "DIRECTOR OF FINANCIAL PLANNING & ANALYSIS               1  250000  250000.000\n",
       "SUPPLY CHAIN ENGINEERING, FATP LEAD                     1  250000  250000.000\n",
       "ASSOCIATE GENERAL COUNSEL, PRIVACY & PRODUCT            1  241006  241006.000\n",
       "IOT ENGINEERING LEAD                                    1  240000  240000.000\n",
       "B8 TECHNICAL PROJECT ASSOCIATE                          1  240000  240000.000\n",
       "INNOVATIONS PRODUCT MANAGER                             1  240000  240000.000\n",
       "GLOBAL INTELLECTUAL PROPERTY AND PRIVACY OPERAT...      1  235000  235000.000\n",
       "SALES OPERATIONS LEAD                                   1  231250  231250.000\n",
       "MARKETING PROGRAM MANAGER                               1  230000  230000.000\n",
       "ASSOCIATE GENERAL COUNSEL                               1  229202  229202.000\n",
       "SALES OPERATIONS MANAGER, RESELLER & PARTNERSHIP        1  227614  227614.000\n",
       "SECURITY PARTNER                                        2  225000  225000.000\n",
       "ECOSYSTEMS PARTNER MANAGER                              1  225000  225000.000\n",
       "HEAD OF PRODUCT, PEOPLE INSIGHTS AND ENGINEERING        1  225000  225000.000\n",
       "TAX MANAGER                                             1  225000  225000.000\n",
       "SECURITY PARTNER, ENTERPRISE PRODUCTS                   1  225000  225000.000\n",
       "ASSOCIATE GENERAL COUNSEL - PRIVACY/PRODUCT             1  224158  224158.000\n",
       "...                                                   ...     ...         ...\n",
       "NORTH AMERICA MARKET SPECIALIST, COMMUNITY OPER...      1   82508   82508.000\n",
       "GRAPH INTEGRITY PROCESS SPECIALIST                      1   81225   81225.000\n",
       "MOBILE ADVERTISING ACCOUNT MANAGER                      1   81000   81000.000\n",
       "MARKETING MANAGER SEO, SMB                              1   81000   81000.000\n",
       "TOOLING PROJECT MANAGER                                 2   89898   80486.000\n",
       "PEOPLE OPERATIONS HR SPECIALIST                         3   84553   80252.000\n",
       "ENTITIES SPECIALIST                                     2   90160   80076.000\n",
       "DATA CENTER ENGINEER                                    1   80018   80018.000\n",
       "FP&A ANALYST                                            1   80000   80000.000\n",
       "COMMUNITY ESCALATIONS SPECIALIST                        1   80000   80000.000\n",
       "ACCOUNT MANAGER, SMALL & MEDIUM BUSINESS                1   79914   79914.000\n",
       "ASSOCIATE, COMMUNITY OPERATIONS                         1   79914   79914.000\n",
       "SOFTWARE ENGINEER INTERN                                1   79200   79200.000\n",
       "ONLINE MARKETING ASSOCIATE                              1   78228   78228.000\n",
       "ASSOCIATE PRODUCT MARKETING MANAGER                     1   78000   78000.000\n",
       "ADS INTEGRITY ASSOCIATE                                 2   82508   77704.000\n",
       "SPECIALIST, MEDIA ANALYTICS                             1   75296   75296.000\n",
       "SPECIALIST, PMD INFRASTRUCTURE                          1   75005   75005.000\n",
       "MARKETING ANALYTICS ASSOCIATE                           1   75000   75000.000\n",
       "RECRUITING COORDINATOR                                  1   74048   74048.000\n",
       "SPECIALIST, COMMUNITY OPERATIONS (INTELLECTUAL ...      1   72280   72280.000\n",
       "PRODUCT RELEASE SPECIALIST                              1   71198   71198.000\n",
       "BUSINESS INTEGRITY SPECIALIST                           3   79943   70972.333\n",
       "PRODUCT DEVELOPMENT SPECIALIST                          1   70720   70720.000\n",
       "TRAINING COORDINATOR SPECIALIST                         1   70158   70158.000\n",
       "DIVERSITY PROGRAMS SPECIALIST                           1   69992   69992.000\n",
       "SPECIALIST, PUBLIC CONTENT OPERATIONS                   5   69659   67545.800\n",
       "SPECIALIST, RISK OPERATIONS                             1   67496   67496.000\n",
       "SPECIALIST, GSS - INSIGHTS                              1   67454   67454.000\n",
       "CLIENT SOLUTIONS MANAGER, TECH/TELCO                    1   64709   64709.000\n",
       "\n",
       "[814 rows x 3 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "\n",
    "agglist = ('count', 'mean', 'max')\n",
    "new = df_2.pivot_table('BASE SALARY', index='JOB TITLE', aggfunc=agglist)\n",
    "new.sort_values('mean', ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "EMPLOYER\n",
       "FACEBOOK INC             AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "FACEBOOK MIAMI INC       AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "FACEBOOK PAYMENTS INC    AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "FACEBOOK SERVICES INC    AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "Name: BASE SALARY, dtype: object"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAD8CAYAAACLrvgBAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAGn1JREFUeJzt3X90VeWd7/H3lxAJMlNRjFwlCnaGdiJptTXLYutcC7gCFmdwltoL046xSYtAyW3HzgUks9Q6hUupo1XawnKNjHBvG6Q/HKmVAoXYNndsId6xBosVWq1m7NVolBHCjwDf+8d5ku6kJ8mTA4edZD6vtc46Z3/3s/fzJLX5sPez9z7m7oiIiMQYlvYARERk8FBoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhEG572AE61c8891ydMmJD2MEREBpWnn376DXcv7qvdkAuNCRMm0NjYmPYwREQGFTP7bUw7nZ4SEZFoCg0REYmm0BARkWgKDRERiabQEBGRaAoNkTyrq6ujrKyMgoICysrKqKurS3tIIjkbcpfcigwkdXV11NbW8tBDD3HVVVfR0NBAdXU1AHPmzEl5dCL9Z0Pt617Ly8td92nIQFFWVsaqVauYMmVKZ62+vp6amhp2796d4shEujKzp929vM92Cg2R/CkoKODw4cMUFhZ21trb2ykqKuL48eMpjkykq9jQ0JyGSB6VlpbS0NDQpdbQ0EBpaWlKIxI5OQoNkTyqra2lurqa+vp62tvbqa+vp7q6mtra2rSHJpITTYSL5FHHZHdNTQ179uyhtLSUZcuWaRJcBi3NaYiIiOY0RETk1FNoiIhItKjQMLOXzKzJzJ4xs8ZQO8fMtpnZ3vB+dqibmT1gZvvM7Fkz+2BiP5Wh/V4zq0zULw/73xe2td76EBGRdPTnSGOKu1+WOOe1BNju7hOB7WEZ4FpgYnjNBVZDJgCAO4EPAVcAdyZCYHVo27HdjD76EBGRFJzM6alZwLrweR1wfaK+3jN+Bow2s/OB6cA2d29197eAbcCMsO5d7v6UZ2bl13fbV7Y+REQkBbGh4cBWM3vazOaG2lh3/x1AeD8v1McBryS2bQ613urNWeq99SEiIimIvU/jI+7+qpmdB2wzs+d7aWtZap5DPVoIsrkAF110UX82FRGRfog60nD3V8P768CjZOYkXgunlgjvr4fmzcCFic1LgFf7qJdkqdNLH93H96C7l7t7eXFxccyPJCIiOegzNMxslJn9ccdnoALYDWwCOq6AqgQeC583ATeHq6gmA/vDqaUtQIWZnR0mwCuALWHdO2Y2OVw1dXO3fWXrQ0REUhBzemos8Gi4CnY48C13/6GZ7QI2mlk18DJwU2j/BPAxYB/QBnwKwN1bzewfgF2h3d3u3ho+zwceBkYCm8MLYEUPfYiISAr0GBEREdFjRERE5NRTaIiISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISLTo0DCzAjP7NzN7PCxfbGY/N7O9ZvaImZ0R6iPC8r6wfkJiH7eH+q/MbHqiPiPU9pnZkkQ9ax8iIpKO/hxpfA7Yk1j+MnCfu08E3gKqQ70aeMvd/xS4L7TDzC4BZgOTgBnAN0IQFQBfB64FLgHmhLa99SEiIimICg0zKwFmAv8Ulg2YCnwnNFkHXB8+zwrLhPXTQvtZwAZ3P+LuLwL7gCvCa5+7/8bdjwIbgFl99CEiIimIPdL4KrAIOBGWxwBvu/uxsNwMjAufxwGvAIT1+0P7znq3bXqq99aHiIikoM/QMLPrgNfd/elkOUtT72PdqapnG+NcM2s0s8aWlpZsTURE5BSIOdL4CPCXZvYSmVNHU8kceYw2s+GhTQnwavjcDFwIENafBbQm69226an+Ri99dOHuD7p7ubuXFxcXR/xIIiKSiz5Dw91vd/cSd59AZiJ7h7t/AqgHbgzNKoHHwudNYZmwfoe7e6jPDldXXQxMBHYCu4CJ4UqpM0Ifm8I2PfUhIiIpOJn7NBYDt5nZPjLzDw+F+kPAmFC/DVgC4O7PARuBXwI/BD7r7sfDnMVCYAuZq7M2hra99SEiIimwzD/oh47y8nJvbGxMexgiIoOKmT3t7uV9tdMd4SIiEk2hISIi0RQaIiISTaEhIiLRFBoiIhJNoSEiItEUGiIiEk2hISIi0RQaIiISTaEhIiLRFBoiIhJNoSEiItEUGiIiEk2hISIi0RQaIiISTaEhIiLRFBoiIhJNoSGSZzU1NRQVFWFmFBUVUVNTk/aQRHKm0BDJo5qaGtasWcPy5cs5ePAgy5cvZ82aNQoOGbT0HeEieVRUVMTy5cu57bbbOmv33nsvS5cu5fDhwymOTKSr2O8IV2iI5JGZcfDgQc4888zOWltbG6NGjWKo/X9PBrfY0NDpKZE8GjFiBGvWrOlSW7NmDSNGjEhpRCInZ3jaAxAZyj7zmc+wePFiAObNm8eaNWtYvHgx8+bNS3lkIrlRaIjk0apVqwBYunQpX/jCFxgxYgTz5s3rrIsMNprTEBERzWmIDBR1dXWUlZVRUFBAWVkZdXV1aQ9JJGc6PSWSR3V1ddTW1vLQQw9x1VVX0dDQQHV1NQBz5sxJeXQi/afTUyJ5VFZWxqpVq5gyZUpnrb6+npqaGnbv3p3iyES60n0aIgNAQUEBhw8fprCwsLPW3t5OUVERx48fT3FkIl1pTkNkACgtLaWhoaFLraGhgdLS0pRGJHJyFBoieVRbW0t1dTX19fW0t7dTX19PdXU1tbW1aQ9NJCeaCBfJo47J7pqaGvbs2UNpaSnLli3TJLgMWprTEBGRUzenYWZFZrbTzH5hZs+Z2RdD/WIz+7mZ7TWzR8zsjFAfEZb3hfUTEvu6PdR/ZWbTE/UZobbPzJYk6ln7EBGRdMTMaRwBprr7pcBlwAwzmwx8GbjP3ScCbwHVoX018Ja7/ylwX2iHmV0CzAYmATOAb5hZgZkVAF8HrgUuAeaEtvTSh8igoZv7ZCjpMzQ840BYLAwvB6YC3wn1dcD14fOssExYP83MLNQ3uPsRd38R2AdcEV773P037n4U2ADMCtv01IfIoFBXV8ett97KCy+8wIkTJ3jhhRe49dZbFRwyaEVdPRWOCJ4BXge2Ab8G3nb3Y6FJMzAufB4HvAIQ1u8HxiTr3bbpqT6mlz5EBoWFCxfS1tbGihUrOHjwICtWrKCtrY2FCxemPTSRnERdPeXux4HLzGw08CiQ7SLzjhl162FdT/VswdVb+z9gZnOBuQAXXXRRtiYiqWhtbWXlypWd39x32223cfz4cRYtWpTyyERy06/7NNz9beBJYDIw2sw6QqcEeDV8bgYuBAjrzwJak/Vu2/RUf6OXPrqP60F3L3f38uLi4v78SCJ519LS0mVOo6WlJe0hieQs5uqp4nCEgZmNBK4B9gD1wI2hWSXwWPi8KSwT1u/wzHW9m4DZ4eqqi4GJwE5gFzAxXCl1BpnJ8k1hm576EBkUCgoKuOeee6iqquKdd96hqqqKe+65h4KCgrSHJpKTPu/TMLP3k5mELiATMhvd/W4zezeZSetzgH8DPunuR8ysCPhfwAfIHGHMdvffhH3VAlXAMeDz7r451D8GfDX0sdbdl4V61j56G6/u05CBZMyYMbz99tsUFxfz2muvMXbsWFpaWhg9ejRvvvlm2sMT6aQHFooMAAUFBUydOpXt27fj7pgZ06ZNY8eOHXpgoQwoemChyABwwQUXsGvXLsaPH4+ZMX78eHbt2sUFF1yQ9tBEcqLQEMmjtrY2Dhw4QE1NTZf3tra2tIcmkhOFhkgetba2MnPmTJYuXcqoUaNYunQpM2fOpLW1Ne2hieREoSGSZzt37mTz5s0cPXqUzZs3s3PnzrSHJJIzhYZIHg0fPpyjR492qR09epThw/WtBDI46b9ckRxlHo/Wt9bWVqZOnZrz9kPtCkcZ3HSkIZIjd+/zNWnSJMrLyzNXTi1+HDOjvLycSZMmRW2vwJCBRqEhkkfjxo2jsbGRefPmATBv3jwaGxsZN07P3pTBSTf3ieRRUVERw4YN49ChQ4xf/Di//fJ1jBw5khMnTnD48OG0hyfSKfbmPs1piOTRkSOZp94UFRV1vh86dCjNIYmcFJ2eEjkNOh4ZokeHyGCn0BA5DUaMGNHlXWSwUmiInAYHDhzo8i4yWGkiXAS49Itb2X+oPe1hnLSzRhbyizsr0h6GDEKaCBfph/2H2nlpxcxTvt/ebuDLxz/YJiz5wSnfp0iSTk+JiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhIND17SiRHvT1X6lRuP9QeKiqDm440RHLk7n2+KiqyP3G2oqIiansFhgw0Cg2RPNqyZQsVFRWdRxVmRkVFBVu2bEl5ZCK5UWiI5NmWLVs4ceIE4xc/zokTJxQYMqgpNEREJJpCQ0REoik0REQkWp+hYWYXmlm9me0xs+fM7HOhfo6ZbTOzveH97FA3M3vAzPaZ2bNm9sHEvipD+71mVpmoX25mTWGbByzMGvbUh4iIpCPmSOMY8AV3LwUmA581s0uAJcB2d58IbA/LANcCE8NrLrAaMgEA3Al8CLgCuDMRAqtD247tZoR6T32IiEgK+gwNd/+du//f8PkdYA8wDpgFrAvN1gHXh8+zgPWe8TNgtJmdD0wHtrl7q7u/BWwDZoR173L3pzxzUfr6bvvK1oeIiKSgX3MaZjYB+ADwc2Csu/8OMsECnBeajQNeSWzWHGq91Zuz1Omlj+7jmmtmjWbW2NLS0p8fSURE+iE6NMzsj4DvAp939//orWmWmudQj+buD7p7ubuXFxcX92dTERHph6jQMLNCMoHxTXf/Xii/Fk4tEd5fD/Vm4MLE5iXAq33US7LUe+tDRERSEHP1lAEPAXvc/d7Eqk1AxxVQlcBjifrN4SqqycD+cGppC1BhZmeHCfAKYEtY946ZTQ593dxtX9n6EBGRFFhfD0Qzs6uAnwJNwIlQXkpmXmMjcBHwMnCTu7eGP/xfI3MFVBvwKXdvDPuqCtsCLHP3fw71cuBhYCSwGahxdzezMdn66G285eXl3tjYGP0LEAF437r3pT2EU6apsintIcggZGZPu3t5X+36fDS6uzeQfd4BYFqW9g58tod9rQXWZqk3AmVZ6m9m60PkVHtnzwpeWjEzr31MWPKD09KHSD7p+zREgDPO3cb71v3+NqAN120AYPbjsztr8y+dz4LLFjB141RaDmWu0is9p5SNf7GRu/71Lr6797udbbfftJ1fvvlLanbUdNYKR/8VMLPLUc3VJVfztWlfY+H2hfy4+ced9abKJr79wre5+6m7O2urpq7ikjGXMO3bv/931A0Tb+CuD9/Fx7//cfa07uGMc6cB+Q0m+c+tz9NTg41OT0kuTtdRwFDoQ4am2NNTevaUiIhEU2iIiEg0hYaIiERTaIiISDSFhoiIRFNoiIhINIWGiIhE030aIugxIiKn7DEiIv8ZnI7HiJwOeoyI5JtOT4mISDSFhoiIRFNoiIhINIWGiIhEU2iIiEg0XT0lwun5Po07rryDm95zk75PQwY13achgu7TENF9GiL9oPs0ROIoNERyZGanpZ+hdjZABjednhJBp6dE9HWvIv1wpGVal+UN123onAzvMP/S+TRVNlE8srizVnpOKU2VTdww8YYubbfftJ1VU1d1qd1x5R1/8Af96pKraaps4uqSq7vUmyqbuOPKO7rUVk1dxfabtnep3TDxBpoqmyg9pzTrzyFyqulIQ4ShNRcwFOZm5PTTRLhIP/X3j+1AnNMYSuEnA5NCQyRHQ+0oXSSGQkMk0L/SRfqm0BAJ8j0XMGHJD05LHyL5pNAQCU7HH9x893HWyMK87l9EoSHC6bni6HQcaYjkm+7TEBGRaAoNERGJptAQEZFofYaGma01s9fNbHeido6ZbTOzveH97FA3M3vAzPaZ2bNm9sHENpWh/V4zq0zULzezprDNAxbumOqpDxERSU/MkcbDwIxutSXAdnefCGwPywDXAhPDay6wGjIBANwJfAi4ArgzEQKrQ9uO7Wb00YeIiKSkz9Bw958Ard3Ks4B14fM64PpEfb1n/AwYbWbnA9OBbe7e6u5vAduAGWHdu9z9Kc/cXru+276y9SEiIinJdU5jrLv/DiC8nxfq44BXEu2aQ623enOWem99iIhISk71RHi2J7h5DvX+dWo218wazayxpaWlv5uLiEikXEPjtXBqifD+eqg3Axcm2pUAr/ZRL8lS762PP+DuD7p7ubuXFxcX99RMREROUq6hsQnouAKqEngsUb85XEU1GdgfTi1tASrM7OwwAV4BbAnr3jGzyeGqqZu77StbHyIikpI+HyNiZnXAR4FzzayZzFVQK4CNZlYNvAzcFJo/AXwM2Ae0AZ8CcPdWM/sHYFdod7e7d0yuzydzhdZIYHN40UsfIiKSEn1zn0iOBuKXMInkSt8RLpJn7t6v1/jFj/d7GwWGDDQKDRERiabQEBGRaAoNERGJptAQEZFoCg0REYmm0BDJs+nTpzNs2DB+++XrGDZsGNOnT097SCI5U2iI5NH06dPZunVr56Wz7s7WrVsVHDJoKTRE8mjr1q0AzJ8/n5L/voH58+d3qYsMNrojXCRHuiNchhLdES6SZ7F3c1dVVXWpVVVVRW+vwJCBRqEhkmdr165lwYIF7N+/nwULFrB27dq0hySSM4WGSB5VVFQAsHr1akaPHs3q1au71EUGG4WGSB7dcsstFBYWdqkVFhZyyy23pDMgkZOk0BDJo0WLFjFmzBh27NjB0aNH2bFjB2PGjGHRokVpD00kJwoNkTxqbm5m/fr1TJkyhcLCQqZMmcL69etpbm5Oe2giOVFoiIhINIWGSB6VlJRQWVlJfX097e3t1NfXU1lZSUlJSdpDE8mJQkMkj1auXMmxY8eoqqqiqKiIqqoqjh07xsqVK9MemkhOFBoieTRnzhzuv/9+Ro0aBcCoUaO4//77mTNnTsojE8mNHiMiIiJ6jIiIiJx6Cg0REYmm0BARkWgKDRERiabQEBGRaEPu6ikzawF+m/Y4RLI4F3gj7UGI9GC8uxf31WjIhYbIQGVmjTGXNIoMZDo9JSIi0RQaIiISTaEhcvo8mPYARE6W5jRERCSajjRERCSaQkNOOzM7bmbPJF4TEuvuN7N/N7Nh3ba51swazWyPmT1vZveE+l2hfXJ/o83so2a2Pyw/a2Y/MrPzEvu7PtSfN7MmM7s+sc7M7O/NbK+ZvWBm9WY2KbH+JTM7N3y+3MxeNLMPdBvvmWb2zbDv3WbWYGZ/1MPPvyTUnzSzX5nZL8xsl5ldFuoPm9mt3fZ/vZk9ET4fSNTfY2ZPmNm+8LvaaGZju/0+Ol7XhG1qzey58Pt4xsw+lOV/s4fN7MbEOBsT68rN7MnE8hVm9pPwszxvZv9kZmf2+B+EDC7urpdep/UFHOihPgx4GfgZ8NFEvQz4NfBnYXk4sCB8vgv4uyz7+ijweGL5fwJfDJ8vBfYBF4fli8Py+8PyQuAJ4MywXBH6LwrLL5G55+L9wIvAFVn6vx24N7H8XmBEHz//k0B5+PwpYFv4PB2o79Z2A/A3yf0BRcBe4C8S7aaE31+X30di/ZXAU4mxnQtckKXdw8CNiXG+DFwblsuBJ8PnsWTuk7oyLBtwIzA27f/u9Do1Lx1pyEAyBdgNrAaSXzixCFjm7s8DuPsxd/9G7E7NzIA/Bt4Kpb8Dlrv7i2F/L5IJlf8R1i8Gaty9LazfCvwr8InEbkuBfyHzh3tnlm7PB/69Y8Hdf+XuR2LHTOYP+bjw+UfAn5nZ+eHnORO4JvSf9NfAU+7+/US/9e6+u5d+zgfe6Bibu7/h7q9GjO8rwN9nqX8WWOfuT4X9ubt/x91fi9inDAIKDUnDyMQpkkcT9TlAHfAocJ2ZFYZ6GfB0L/v728T+6hP1PzezZ8j8q/gaYG2oT8qyv0Zgkpm9Cxjl7r/Otj6x/Biw0N0behjTWmCxmT1lZl8ys4mJdcmf/xkz+29Ztp9BCAV3Pw58D/h4WPeXZI483um2TV+/pz/v1u+fAFuBC8NpuG+Y2dW9bJ/0FHDEzKb0cwwyyCk0JA2H3P2y8PorADM7A/gY8C/u/h/Az8mcFopxX2J/yT9iPw21C4F/Bjq+Y9WA7pcNZqv1tv5HwKfNrCBbY3d/Bng3mX+RnwPsMrPSsDr581/m7o8kNv2mmTWTOdpZlajXAbPD59lhub9+2q3fX7v7AeByYC7QAjxiZrdE7u9LZD/akCFMoSEDxQzgLKDJzF4CruL3p6ieI/OH7WRsAv5rYn/dH+fxQeCXIbAOmtm7s61PLC8M7z2eJnP3A+7+PXdfAPxvMqHYl0+QmWP5FvD1RP3/AOeb2aXAh8nMuXSX0+/J3Y+7+5PufieZn+uGyO12kJlHmXyyY5DBQ6EhA8Uc4NPuPsHdJ5D5w1kRzt9/BVhqZu8BMLNhZnZbP/d/FZnJbIB7gNstXLUV3pcC/xjWfwV4wMxGhvXXhO2/ldjfiTDm95rZ3d07M7OPmNnZ4fMZwCVEPkjT3dvJ/At+csfRibs7sBFYBzzh7oezbPot4MNmNjMxjhlm9r6e+jKz93Y7dXZZ7DiDZWTmnDp8DahMXoFlZp80s//Sj33KADY87QGIhGCYDnReVuruB82sgcyVQI+Y2eeButDWgR8kdvG3ZvbJxHLH5bMdcxoG7Ac+Hfb9jJktBr4f5k3agUXhlBJkTgudTeao5zjw/4BZ7n4oOW53P2Jms4Afm9lr7p48MvgTYHWYhB8WxvvdsG5kGFeHH7r7km77PmRm/0hm0r46lOvITNZ3adttm+uAr5rZV8PP9SzwOWBM4vfR4Utkrv5aZWajgWNkriKbm23/PfT5hGWeLN2x/JqZzQbuscwlzieAn5CZk5EhQHeEi4hINJ2eEhGRaAoNERGJptAQEZFoCg0REYmm0BARkWgKDRERiabQEBGRaAoNERGJ9v8BQY8vJIM0RCEAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x739a91211978>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_2.groupby(['EMPLOYER'])['BASE SALARY'].plot(kind='box', legend = True, meanline = True, showmeans=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "EMPLOYER\n",
       "FACEBOOK INC             AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "FACEBOOK MIAMI INC       AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "FACEBOOK PAYMENTS INC    AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "FACEBOOK SERVICES INC    AxesSubplot(0.125,0.125;0.775x0.755)\n",
       "Name: BASE SALARY, dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY4AAAD8CAYAAABgmUMCAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3XmcFOW1//HPYZiwiJFVNCyZAUGQxUFHlCgG3EXZDCLLvSESr0ZxBwyocYlLRFFiLpiIy4VEZRAXQGT3aozXIIIOyDgi6y+MElBwAREBOb8/urrpgWamC+lZer7v16tfXX3qqarnaYY5U9spc3dERESSVa28OyAiIpWLEoeIiISixCEiIqEocYiISChKHCIiEooSh4iIhKLEISIioShxiIhIKEocIiISSvXy7kAqNGzY0LOyssq7GyIilcrSpUs/d/dGpbVLy8SRlZXFkiVLyrsbIiKVipn9v2Ta6VCViIiEosQhIiKhKHGIiEgoKTvHYWY1gTeBGsF2XnD3O80sG8gD6gPvAf/p7rvMrAbwV+BkYAtwmbuvD9Y1Gvg18D1wvbvPS1W/RQ6n3bt3U1RUxM6dO8u7KyIxNWvWpGnTpmRmZh7S8qk8Of4dcJa7bzezTOAtM5sD3AyMc/c8M/sLkYTw5+D9C3c/zswGAGOAy8zsBGAA0A74CbDQzFq7+/cp7LvIYVFUVMSRRx5JVlYWZlbe3RHB3dmyZQtFRUVkZ2cf0jpSdqjKI7YHHzODlwNnAS8E8clAn2C6d/CZYP7ZFvmf1hvIc/fv3H0dsBronKp+ixxOO3fupEGDBkoaUmGYGQ0aNPhBe8EpPcdhZhlmlg9sBhYAa4Av3X1P0KQIaBJMNwE2AATzvwIaxMcTLCNS4SlpSEXzQ38mU5o43P17d88BmhLZS2ibqFnwnmgkXkK8GDO70syWmNmSzz777FC7LCIipSiTGwDd/UszewM4DahrZtWDvYqmwKdBsyKgGVBkZtWBo4CtcfGo+GXitzERmAiQm5urB6lLhZQ16tXDur71D1xUapuMjAw6dOgQ+zx9+nSilRVuuOEGXnjhBTZs2EC1avv+jpwzZw6/+93v+Oabb3B3Lr74YsaOHctdd93FE088QaNG+24ufuONN8jPz6d3795kZ2ezd+9ejj76aJ577jmOPvro2DbvuOMOdu3aRWZmJvfccw99+kSOUrs79913H5MnT8bMaNKkCePHj6ddu3bAvht6GzZsyNKlS+nXrx8vvfQSnTp1KtaHsWPHMmvWLCZNmsTQoUPJz8+nY8eOALRv355Zs2aRlZXF9u3bGT58OAsXLqRmzZo0aNCAhx56iFNPPfUQ/xWqnlReVdUI2B0kjVrAOUROeL8O9CNyZdUQYEawyMzg8z+D+f/r7m5mM4HnzOwRIifHWwGLU9Xvqupw/0Kr6JL5hZsuatWqRX5+/gHxvXv38vLLL9OsWTPefPNNunXrBsCKFSu49tprefXVV2nTpg179uxh4sSJseVuuukmRowYccD6unbtyqxZswAYPXo0EyZM4O6772bZsmWMGDGCBQsWkJ2dzbp16zj33HNp0aIFHTt2ZMKECbz99tssW7aM2rVrM3/+fHr16kVBQQE1a9aMrX/58uX069ePqVOnFksaiTRt2pT77ruPqVOnHjDviiuuIDs7m1WrVlGtWjXWrl1LYWFhUt+lRKTyUNWxwOtmthx4F1jg7rOA3wI3m9lqIucwngraPwU0COI3A6MA3L0AeB74EJgLDNMVVSI/3Ouvv0779u25+uqrmTJlSiz+4IMPctttt9GmTRsAqlevzjXXXJP0et2dbdu2Ua9ePQDGjh3LrbfeGruCJzs7m9GjR/PQQw8BMGbMGP77v/+b2rVrA3Deeefxs5/9jGeffTa2zsLCQvr06cPf/vY3Oncu/dqYiy++mIKCAlauXFksvmbNGt555x3uvffe2B5WixYtuOiiqvOHxOGQyquqlrt7J3fv6O7t3f33QXytu3d29+Pc/VJ3/y6I7ww+HxfMXxu3rvvcvaW7H+/uc1LVZ5F09O2335KTk0NOTg59+/aNxadMmcLAgQPp27cvs2bNYvfu3UBkj+Pkk08+6PrGjRsXW1/37t1j8X/84x/k5OTQvHlzFi5cyNChQwEoKCg4YH25ubkUFBTw9ddf880339CyZcuE86N69+7N+PHjOeOMM5Iac7Vq1bjlllu4//77i8ULCgrIyckhIyMjqfVIYrpzXCTNRQ9V5efn8/LLLwOwa9cuZs+eTZ8+ffjxj3/Mqaeeyvz585Na30033RRb3+uvvx6Ld+3alfz8fDZs2MDll1/OLbfcAkT2QPa/iidRrKT555xzDk8++STff5/8wYZBgwaxaNEi1q1bl/QykhwlDpEqaO7cuXz11Vd06NCBrKws3nrrrdjhqnbt2rF06dIftP5evXrx5ptvxta3f7Xq9957jxNOOIEf//jHHHHEEaxduzbh/Kjx48cDhDpkVr16dYYPH86YMWNisXbt2rFs2TL27t0bekyyjxKHSBU0ZcoUnnzySdavX8/69etZt24d8+fPZ8eOHYwcOZL777+fjz/+GIicRH/kkUdCrf+tt96KHX4aMWIEf/jDH1i/fj0A69ev5/7772f48OEAjBw5kuuvv55vv/0WgIULF/LWW28xaNCg2PqqVavGlClTWLlyJXfccUfS/fjVr37FwoULiV6i37JlS3Jzc7nzzjtxj1x8uWrVKmbMmFHSamQ/afk8DpGKqiJczbVjxw7mzZvH448/HosdccQRnHHGGbzyyitcdtll/PGPf2TgwIHs2LEDMyt28njcuHE888wzsc/Tp08H9p3jcHeOOuoonnzySQBycnIYM2YMPXv2ZPfu3WRmZvLggw+Sk5MDwHXXXccXX3xBhw4dyMjI4JhjjmHGjBnUqlWrWL9r1KjBjBkz+PnPf07jxo0ZNmxYqWP90Y9+xPXXX88NN9wQiz355JMMHz6c4447jtq1a8cux5XkWTTrppPc3FzXg5zC0eW4qVFYWEjbtonuexUpX4l+Ns1sqbvnlrasDlWJiEgoShwiIhKKEoeIiISixCEiIqEocYiISChKHCIiEooSh0hZuuuow/tKQkZGRqy2VE5OTuxGPIiUVW/SpMkBd1LPmTOH3Nxc2rZtS5s2bWLVcO+66y6aNGlSbH1ffvklb7zxBkcddRQ5OTl07NiRc845h82bN8fWN336dDp27EibNm3o0KFD7N4PiJQXuffee2nVqhWtW7eme/fuxepUZWVl8fnnnwOwdOlSsrOzef/994v194033sDMeOqpp2Kx999/HzNj7NixQORmwBdeeCE2/7PPPiMzM7PY/SzR7XXt2rVYLCcnh/bt28e2dfHFFx/wPcfHJ02aRLVq1Vi+fHlsfvv27WPf/fbt27nqqqto2bIl7dq148wzz+Sdd945YJ0VlRKHSJqLr1WVn58fexbH/mXVo6Jl1Z955hkKCwtZsWIFLVq0iM2Pr1WVn59P3bp1gX21qpYvX84pp5zChAkTAGJl1WfMmMFHH33EzJkzGTFiROyXanxZ9Y8//pjRo0fTq1evAx5tWlpZ9Q4dOhQro56Xl8eJJ5540O9l2rRpnHbaacUqA0dt27aNDRsiDx491JLr0dLuiVxxxRXUr1+fVatWUVBQwKRJk2LJsTJQ4hCpotKtrHrz5s3ZuXMnmzZtwt2ZO3cuF1544UH7OWXKFB5++GGKior45JNPis3r379/LAlFqwiHlc6l3ZU4RNJcVSqr3q9fP6ZNm8bbb7/NSSedRI0aNRK227BhA//+97/p3LlzsSQRv56XXnoJgFdeeYWePXuWuN1E0rm0uxKHSJqrSmXV+/fvz7Rp00rdS8jLy6N///4ADBgw4IDDVfXr16devXrk5eXRtm3b2N5QWOla2l2JQ6QKStey6scccwyZmZksWLCAs88++6DtpkyZwqRJk8jKyqJXr14sW7aMVatWFWtz2WWXMWzYsEM6TBWVrqXdlThEqqB0Lqv++9//njFjxhz0UNDKlSv55ptv+OSTT2LjHz16NHl5ecXa9e3bl1tuuYXzzz8/1Nj3l46l3VVWXaQs3fVVefcg7cuq/+xnPytx/FOmTCl2rgfgF7/4BQMGDOB3v/tdLHbkkUfy29/+tsR1JSMdS7urrLoAKqueKiqrLhXVDymrrj2OBKraL1ERkTB0jkNEREJR4hARkVCUOEREJBQlDhERCUWJQ0REQklZ4jCzZmb2upkVmlmBmd0QxO8ys0/MLD949YhbZrSZrTazlWZ2flz8giC22sxGparPIqnWYXKHw/pKRlUpq37UUUfRqVMn2rZty913311s/v7jLCgooHXr1rGbDgEuuugi8vLymDRpEmbGa6+9Fpv38ssvY2axsuzdunXj+OOPj30H/fr1i30/tWvXLjb2OnXqsGXLlljbY445pth3uGvXLu677z7atWtHx44dycnJSVhiPb4sfLdu3cjN3XfV7JIlS+jWrVvs8+LFiznzzDM5/vjjadOmDVdccQU7duw4YJ2HKpV7HHuA4e7eFjgNGGZm0RoC49w9J3jNBgjmDQDaARcAj5lZhpllABOAC4ETgIFx6xGRUlSVsupdu3bl/fffZ8mSJTzzzDOxsimJxtmuXTsuueSSWNnz6dOns3v3bgYMGABESrTH169KVKL92WefjX0H8c/5aNiwIQ8//HCxtg0aNIi1/c1vflPsO1y6dCmzZs3ivffeY/ny5SxcuJBmzZqV+G8KsHnzZubMmXNAfNOmTVx66aWMGTOGlStXUlhYyAUXXMC2bdtKXWeyUpY43H2ju78XTG8DCoEmJSzSG8hz9+/cfR2wGugcvFa7+1p33wXkBW1F5AdIt7LqUUcccQQnn3wya9asKXGcd9xxB9OmTSM/P59Ro0bFEh1EktDixYvZvXs327dvZ/Xq1bE73UszdOhQpk6dytatW5Nqv3HjRho2bBir5NuwYUN+8pOflLrcyJEjuffeew+IT5gwgSFDhtClSxcAzIx+/frRuHHjpPqTjDI5x2FmWUAnILr/da2ZLTezp82sXhBrAmyIW6woiB0sLiJJqEpl1QG2bNnCokWLaNeuXYnjrF27NmPHjuXMM89kwIABtGrVKrYOM+Occ85h3rx5zJgxg169eh2wncGDB8e+h5EjR8biderUYejQoTz66KOl9hUiiXLDhg20bt2aa665hr///e9JLdelSxdq1KhRrEIxlP7vdzikPHGYWR3gReBGd/8a+DPQEsgBNgLRfbpENZa9hPj+27nSzJaY2ZJoMTERqTpl1f/xj3/QqVMnzjvvPEaNGkW7du1KHWfPnj2pW7duwj2qAQMGkJeXR15eXsIKufGHqvavM3X99dczefJkvv7664P2N6pOnTosXbqUiRMn0qhRIy677DImTZpU6nIAt99+e8K9jlRLaeIws0wiSeNZd38JwN03ufv37r4XeILIoSiI7EnEH9hrCnxaQrwYd5/o7rnuntuoUaPDPxiRNJKOZdWj5ziWLl3Kb37zm1LHGVWtWrXYk/jide7cmRUrVvD555/TunXrEKOHunXrMmjQIB577LGk2mdkZNCtWzfuvvtuxo8fz4svvpjUcmeddRY7d+5k0aJFsdjh+PcrTSqvqjLgKaDQ3R+Jix8b16wvsCKYngkMMLMaZpYNtAIWA+8Crcws28x+ROQE+sxU9VukKkjnsurJjjMZf/jDHw54gl+ybr75Zh5//HH27NlTYruVK1cWexZIfn4+P/3pT5Pezm233caDDz4Y+3zttdcyefLkYldmPfPMM/z73/8O0fuSpbLI4enAfwIfmFl+ELuVyFVROUQON60HrgJw9wIzex74kMgVWcPc/XsAM7sWmAdkAE+7ewEildAHQz4o7y6kfVn1MOMsTUnPLB88eHCsjw0bNmThwoXF5jds2JC+ffsybty4Erexfft2rrvuOr788kuqV6/Occcdx8SJE0vtW1SPHj2IP8rSuHFj8vLyGDFiBJs3b6ZatWqceeaZXHLJJUmvszQqq56AquOmP5VVl6ruh5RV153jIiISihKHiIiEosQhIiKhKHGIiEgoShwiIhKKEoeIiISixCFShgrbtD2sr2RUhbLqO3bsYPDgwXTo0IH27dtzxhlnsH379oTjf+CBB4B9pdFPPPFETjnlFPLzI7eb/epXvyp270e0/z16RJ4AUadOnVj8448/pkePHhx33HG0bduW/v37s2nTpmLfR/QVvc+jspVQTySVNwCKSAUQrVW1v/3LjUd/GUXLqr/66qu0adOGPXv2FLsh7aabboolknhdu3Zl1qxZAIwePZoJEyZw9913x8qqL1iwgOzsbNatW8e5555LixYt6NixY7Gy6rVr12b+/Pn06tWLgoICatasGVt/SWXVH330URo3bswHH0RusFy5ciWZmZkljh8i9aZyc3P5n//5H0aOHMmCBQsYOHAgDzzwAFdddVWsXaJ6VTt37uSiiy7ikUceoWfPnkCkEm+0Vl789xH1z3/+M1ZCvUaNGnz++efs2rUrYd/iRUuo739DYrSEel5eHl26dMHdefHFF9m2bVus2nAqaI9DpIpKp7LqGzdupEmTfUWzjz/++FiZ8mR06dKFTz75BIgUVPzoo4/YuHEjENmbWbhwIX369Cm2zHPPPUeXLl1iSQOge/futG/f/qDbqYwl1BNR4hBJc1WhrPrQoUMZM2YMXbp04fbbby9W+yl+/Dk5OUydOvWA5efOnRtLDBkZGVxyySU8//zzAMycOZPu3btz5JFHFlumtO8p+n1EX2vWrKmUJdQTUeIQSXNVoax6Tk4Oa9euZeTIkWzdupVTTjmFwsLCA8afn59frEbV4MGDadq0KWPGjOG6666LxQcOHEheXh6Q+DBVMqLfR/TVsmXLSllCPRElDpEqKB3LqtepU4dLLrmExx57jP/4j/9g9uzZpfbz2WefZd26dQwaNKhY0cTTTz+djRs3smzZMt5+++3YifF4h/o9VbYS6okocYhUQelWVv3//u//+OKLL4DI3tSHH36YdGnyzMxM7r33XhYtWhTbSzEz+vfvz5AhQ+jRo0exk/RRgwYN4u233+bVV/cVRZ07d27sBH0ilbGEeiK6qkqkDLX9qLC8u5CWZdXXrFnD1Vdfjbuzd+9eLrroIn7xi18A+85xRF1wwQWxS3KjatWqxfDhwxk7dixPPfUUEDlc9dBDDx3QNn6ZWbNmceONN3LjjTeSmZlJx44defTRR9myZUvs+4i6/fbbyc7OrnQl1BNRWfUEVFY9/amsulR1KqsuIiJlRolDRERCUeIQSbF0PBwsldsP/ZlU4hBJoZo1a7JlyxYlD6kw3J0tW7YkvFIsWbqqSiSFmjZtSlFRUax+kUhFULNmTZo2bXrIyytxiKRQZmZmrEaTSLrQoSoREQlFiUNEREJR4hARkVCUOEREJBQlDhERCSVlicPMmpnZ62ZWaGYFZnZDEK9vZgvMbFXwXi+Im5n9ycxWm9lyMzspbl1DgvarzGxIqvosIiKlS+Uexx5guLu3BU4DhpnZCcAo4DV3bwW8FnwGuBBoFbyuBP4MkUQD3AmcCnQG7owmGxERKXspSxzuvtHd3wumtwGFQBOgNzA5aDYZiD7ItzfwV49YBNQ1s2OB84EF7r7V3b8AFgAXpKrfIiJSsjI5x2FmWUAn4B2gsbtvhEhyAY4OmjUBNsQtVhTEDhYXEZFykPLEYWZ1gBeBG93965KaJoh5CfH9t3OlmS0xsyUq7yAikjopTRxmlkkkaTzr7i8F4U3BISiC981BvAhoFrd4U+DTEuLFuPtEd89199z4J2SJiMjhlcqrqgx4Cih09/gHFs8EoldGDQFmxMV/GVxddRrwVXAoax5wnpnVC06KnxfERESkHKSyyOHpwH8CH5hZfhC7FXgAeN7Mfg38C7g0mDcb6AGsBnYAlwO4+1Yzuwd4N2j3e3ffmsJ+i4hICVKWONz9LRKfnwA4O0F7B4YlaIu7Pw08ffh6JyIih0p3jouISChJJQ4za5/qjoiISOWQ7B7HX8xssZldY2Z1U9ojERGp0JJKHO5+BjCYyGWxS8zsOTM7N6U9ExGRCinpcxzuvgq4Hfgt8HPgT2b2kZldkqrOiYhIxZPsOY6OZjaOSL2ps4CeQfHCs4BxKeyfiIhUMMlejjseeAK41d2/jQbd/VMzuz0lPRMRkQop2cTRA/jW3b8HMLNqQE133+Huf0tZ70REpMJJ9hzHQqBW3OfaQUxERKqYZBNHTXffHv0QTNdOTZdERKQiSzZxfLPfo1xPBr4tob2IiKSpZM9x3AhMM7NoOfNjgctS0yUREanIkkoc7v6umbUBjidSuPAjd9+d0p6JiEiFFKY67ilAVrBMJzPD3f+akl6JiEiFlVTiMLO/AS2BfOD7IOyAEoeISBWT7B5HLnBC8MwMERGpwpK9qmoFcEwqOyIiIpVDsnscDYEPzWwx8F006O69UtIrERGpsJJNHHelshMiIlJ5JHs57t/N7KdAK3dfaGa1gYzUdk1ERCqiZMuq/xfwAvB4EGoCTE9Vp0REpOJK9uT4MOB04GuIPdTp6FR1SkREKq5kE8d37r4r+sHMqhO5j0NERKqYZBPH383sVqBW8KzxacArqeuWiIhUVMkmjlHAZ8AHwFXAbCLPHxcRkSom2auq9hJ5dOwTqe2OiIhUdMleVbXOzNbu/yplmafNbLOZrYiL3WVmn5hZfvDqETdvtJmtNrOVZnZ+XPyCILbazEYdyiBFROTwCVOrKqomcClQv5RlJgHjObAQ4jh3HxsfMLMTgAFAO+AnwEIzax3MngCcCxQB75rZTHf/MMl+i4jIYZbUHoe7b4l7feLufwTOKmWZN4GtSfajN5Dn7t+5+zpgNdA5eK1297XBVV15QVsRESknyZZVPynuYzUieyBHHuI2rzWzXwJLgOHu/gWRGwoXxbUpCmIAG/aLn3qQPl4JXAnQvHnzQ+yaiIiUJtlDVQ/HTe8B1gP9D2F7fwbuIXIPyD3BeocSearg/pzEe0QJ7x9x94nARIDc3FzdYyIikiLJXlXV/XBszN03RafN7AlgVvCxCGgW17QpEH2++cHiIiJSDpI9VHVzSfPd/ZEk13Osu28MPvYl8pwPgJnAc2b2CJGT462AxUT2RFqZWTbwCZET6IOS2ZaIiKRGmKuqTiHyCx6gJ/Amxc8/FGNmU4BuQEMzKwLuBLqZWQ6Rw03ridxMiLsXmNnzwIdEDoUNc/fvg/VcC8wjUo33aXcvCDE+ERE5zMI8yOkkd98GkfsxgGnufsXBFnD3gQnCT5XQ/j7gvgTx2UTuVBcRkQog2ZIjzYFdcZ93AVmHvTciIlLhJbvH8TdgsZm9TOQwU18OvLFPRESqgGSvqrrPzOYAXYPQ5e7+fuq6JSIiFVWyh6oAagNfu/ujQFFwpZOIiFQxyRY5vBP4LTA6CGUCz6SqUyIiUnElu8fRF+gFfAPg7p9y6CVHRESkEks2cexydyco92FmR6SuSyIiUpElmzieN7PHgbpm9l/AQvRQJxGRKinZq6rGBs8a/xo4HrjD3RektGciIlIhlZo4zCwDmOfu5wBKFiIiVVyph6qCmlE7zOyoMuiPiIhUcMneOb4T+MDMFhBcWQXg7tenpFciIlJhJZs4Xg1eIiJSxZWYOMysubv/y90nl1WHRESkYivtHMf06ISZvZjivoiISCVQWuKIfxZ4i1R2REREKofSEocfZFpERKqo0k6On2hmXxPZ86gVTBN8dnf/cUp7JyIiFU6JicPdM8qqIyIiUjmEeR6HiIiIEoeIiISjxCEiIqEocYiISChKHCIiEooSh4iIhKLEISIioaQscZjZ02a22cxWxMXqm9kCM1sVvNcL4mZmfzKz1Wa23MxOiltmSNB+lZkNSVV/RUQkOanc45gEXLBfbBTwmru3Al4LPgNcCLQKXlcCf4ZIogHuBE4FOgN3RpONiIiUj5QlDnd/E9i6X7g3EC3RPhnoExf/q0csAuqa2bHA+cACd9/q7l8QeXTt/slIRETKUFmf42js7hsBgvejg3gTYENcu6IgdrD4AczsSjNbYmZLPvvss8PecRERiagoJ8ctQcxLiB8YdJ/o7rnuntuoUaPD2jkREdmnrBPHpuAQFMH75iBeBDSLa9cU+LSEuIiIlJOyThwzgeiVUUOAGXHxXwZXV50GfBUcypoHnGdm9YKT4ucFMRERKSelPY/jkJnZFKAb0NDMiohcHfUA8LyZ/Rr4F3Bp0Hw20ANYDewALgdw961mdg/wbtDu9+6+/wl3EREpQylLHO4+8CCzzk7Q1oFhB1nP08DTh7FrIiLyA1SUk+MiIlJJKHGIiEgoShwiIhKKEoeIiISixCEiIqEocYiISChKHCIiEooSh4iIhKLEISIioShxiIhIKEocIiISihKHiIiEosQhIiKhKHGIiEgoShwiIhKKEoeIiISixCEiIqEocYiISChKHCIiEooSh4iIhKLEISIioShxiIhIKEocIiISihKHiIiEosQhIiKhlEviMLP1ZvaBmeWb2ZIgVt/MFpjZquC9XhA3M/uTma02s+VmdlJ59FlERCLKc4+ju7vnuHtu8HkU8Jq7twJeCz4DXAi0Cl5XAn8u856KiEhMRTpU1RuYHExPBvrExf/qEYuAumZ2bHl0UEREyi9xODDfzJaa2ZVBrLG7bwQI3o8O4k2ADXHLFgUxEREpB9XLabunu/unZnY0sMDMPiqhrSWI+QGNIgnoSoDmzZsfnl6KiMgBymWPw90/Dd43Ay8DnYFN0UNQwfvmoHkR0Cxu8abApwnWOdHdc909t1GjRqnsvohIlVbmicPMjjCzI6PTwHnACmAmMCRoNgSYEUzPBH4ZXF11GvBV9JCWiIiUvfI4VNUYeNnMott/zt3nmtm7wPNm9mvgX8ClQfvZQA9gNbADuLzsuywiIlFlnjjcfS1wYoL4FuDsBHEHhpVB10REJAkV6XJcERGpBJQ4REQkFCUOEREJRYlDRERCUeIQEZFQlDhERCQUJQ4REQlFiUNEREJR4hARkVCUOEREJBQlDhERCUWJQ0REQlHiEBGRUJTIHSmyAAAFlklEQVQ4REQkFCUOEREJRYlDRERCUeIQEZFQlDhERCQUJQ4REQlFiUNEREJR4hARkVCUOEREJBQlDhERCUWJQ0REQlHiEBGRUJQ4REQklEqTOMzsAjNbaWarzWxUefdHRKSqql7eHUiGmWUAE4BzgSLgXTOb6e4flm/PpLLKGvVqeXehzK1/4KLy7oKkicqyx9EZWO3ua919F5AH9C7nPomIVEmVJXE0ATbEfS4KYiIiUsYqxaEqwBLEvFgDsyuBK4OP281sZcp7lToNgc/LuxPlSONPwfhtzOFeY8ro37/8xv/TZBpVlsRRBDSL+9wU+DS+gbtPBCaWZadSxcyWuHtuefejvGj8Gr/GX7HHX1kOVb0LtDKzbDP7ETAAmFnOfRIRqZIqxR6Hu+8xs2uBeUAG8LS7F5Rzt0REqqRKkTgA3H02MLu8+1FG0uKQ2w+g8VdtGn8FZ+5eeisREZFAZTnHISIiFYQSx2FmZk+b2WYzWxEXq29mC8xsVfBeL4ibmf0pKKOy3MxOiltmSNB+lZkNiYufbGYfBMv8ycyspG2UJTNrZmavm1mhmRWY2Q1VbPw1zWyxmS0Lxn93EM82s3eCvk0NLvDAzGoEn1cH87Pi1jU6iK80s/Pj4glL7xxsG+XBzDLM7H0zm1VS39Jx/Ga2Pvj5zDezJUEs/X7+3V2vw/gCzgROAlbExR4ERgXTo4AxwXQPYA6R+1ROA94J4vWBtcF7vWC6XjBvMdAlWGYOcGFJ2yjjsR8LnBRMHwl8DJxQhcZvQJ1gOhN4JxjX88CAIP4X4Opg+hrgL8H0AGBqMH0CsAyoAWQDa4hcFJIRTLcAfhS0OSFYJuE2yun/wM3Ac8CskvqWjuMH1gMN94ul3c9/ufxgpfsLyKJ44lgJHBtMHwusDKYfBwbu3w4YCDweF388iB0LfBQXj7U72DbK+XuYQaS+WJUbP1AbeA84lcjNXNWDeBdgXjA9D+gSTFcP2hkwGhgdt655wXKxZYP46OBlB9tGOYy7KfAacBYwq6S+pen413Ng4ki7n38dqiobjd19I0DwfnQQP1gplZLiRQniJW2jXASHHToR+au7yow/OEyTD2wGFhD5C/lLd98TNInvc2ycwfyvgAaE/14alLCNsvZH4BZgb/C5pL6l4/gdmG9mSy1SzQLS8Oe/0lyOm6YOVkolbLxCMbM6wIvAje7+dXAYNmHTBLFKPX53/x7IMbO6wMtA20TNgvew40z0h16F+V7M7GJgs7svNbNu0XCCpmk5/sDp7v6pmR0NLDCzj0poW2l//rXHUTY2mdmxAMH75iB+sFIqJcWbJoiXtI0yZWaZRJLGs+7+Uil9S7vxR7n7l8AbRI5d1zWz6B9p8X2OjTOYfxSwlfDfy+clbKMsnQ70MrP1RCpYn0VkD6SqjB93/zR430zkD4fOpOHPvxJH2ZgJRK+MGELk2H80/svg6orTgK+C3cx5wHlmVi+4OuI8IsdsNwLbzOy04GqKX+63rkTbKDNBn54CCt39kbhZVWX8jYI9DcysFnAOUAi8DvRL0Lf4PvcD/tcjB6lnAgOCq46ygVZEToomLL0TLHOwbZQZdx/t7k3dPSvo2/+6++AS+pZW4zezI8zsyOg0kZ/bFaTjz395nEBK5xcwBdgI7CbyF8KviRyDfQ1YFbzXD9oakQdUrQE+AHLj1jMUWB28Lo+L5xL5YVwDjGffTZwJt1HGYz+DyK7zciA/ePWoQuPvCLwfjH8FcEcQb0HkF99qYBpQI4jXDD6vDua3iFvXbcEYVxJcORPEexC5Wm0NcFtcPOE2yvH/QTf2XVVVJcYf9GFZ8CqI9i8df/5157iIiISiQ1UiIhKKEoeIiISixCEiIqEocYiISChKHCIiEooSh4iIhKLEISIioShxiIhIKP8f+3bzQeyVwAAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x739a91149048>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "df_2.groupby(['EMPLOYER'])['BASE SALARY'].plot(kind='hist', legend = True, bins=5)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Merge Titles in main DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/conda3/lib/python3.6/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n",
      "/usr/local/conda3/lib/python3.6/site-packages/ipykernel_launcher.py:9: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "SOFTWARE_ENGINEER                                     14845\n",
       "PRODUCT MANAGER                                         291\n",
       "RESEARCH SCIENTIST                                      280\n",
       "DATA ENGINEER                                           179\n",
       "DATA SCIENTIST                                          177\n",
       "TECHNICAL PROGRAM MANAGER                               173\n",
       "PRODUCTION ENGINEER                                     158\n",
       "DEVELOPER_                                              142\n",
       "PROGRAM MANAGER                                         139\n",
       "HARDWARE ENGINEER                                       133\n",
       "PRODUCT DESIGNER                                        122\n",
       "ENGINEERING MANAGER                                     105\n",
       "TEST ENGINEER                                           104\n",
       "NETWORK ENGINEER                                         93\n",
       "QUANTITATIVE ANALYST                                     91\n",
       "BUSINESS SYSTEMS INTEGRATOR                              90\n",
       "INTERACTION DESIGNER                                     83\n",
       "FRONT END ENGINEER                                       82\n",
       "APPLICATION ENGINEER                                     69\n",
       "FINANCIAL ANALYST                                        55\n",
       "SITE RELIABILITY ENGINEER                                53\n",
       "PRODUCT MARKETING MANAGER                                49\n",
       "BUSINESS ANALYST                                         48\n",
       "UX RESEARCHER                                            45\n",
       "SECURITY ENGINEER                                        42\n",
       "SOLUTIONS ENGINEER                                       41\n",
       "TECHNICAL SOLUTIONS CONSULTANT                           37\n",
       "USER INTERFACE DESIGNER                                  31\n",
       "TECHNICAL SOLUTIONS ENGINEER                             30\n",
       "TECHNICAL ACCOUNT MANAGER                                29\n",
       "                                                      ...  \n",
       "GLOBAL SMB PERFORMANCE DISPLAY EXPERT                     1\n",
       "ASSOCIATE, GOOGLE CAPITAL 1615.20204                      1\n",
       "PRODUCT DESIGNER, SYSTEMS                                 1\n",
       "PRODUCT MANAGER 1615.38165                                1\n",
       "INTERACTION DESIGNER 1615.32454                           1\n",
       "TEST ENGINEER 1615.35881                                  1\n",
       "LOCALIZATION PROGRAM MANAGER                              1\n",
       "PRODUCT MANAGER 1615.37519                                1\n",
       "FINANCIAL AUDITOR (1615.28776)                            1\n",
       "TECHNICAL SOLUTIONS CONSULTANT 1615.18143                 1\n",
       "TREASURY ANALYST 1615.31366                               1\n",
       "STAFF SUPPORT OPERATIONS 1615.12887                       1\n",
       "SALES OPERATIONS ASSOCIATE (1615.36972)                   1\n",
       "UX DESIGNER 1615.10741                                    1\n",
       "HARDWARE ENGINEER 1615.23797                              1\n",
       "PROGRAM MANAGER 1615.28640                                1\n",
       "BUSINESS SYSTEMS INTEGRATOR (1615.16297)                  1\n",
       "QUANTITATIVE BUSINESS ANALYST 1615.9418                   1\n",
       "INTERACTION DESIGNER 1615.37033                           1\n",
       "CUSTOMER SOLUTIONS TOOLS SPECIALIST 1615.8873             1\n",
       "USER EXPERIENCE RESEARCHER 1615.35365                     1\n",
       "TECHNICAL SOLUTIONS CONSULTANT 1615.36520                 1\n",
       "MANAGER, STORE OPERATIONS                                 1\n",
       "STRATEGIST, TRUST AND SAFETY (1615.27982)                 1\n",
       "QUANTITATIVE ANALYST 1615.33256                           1\n",
       "ADVERTISING OPTIMIZATION RESEARCHER (91.10133)            1\n",
       "SITE RELIABILITY ENGINEER - SYSTEMS ENGINEER              1\n",
       "QUANTITATIVE RESEARCHER, ADVERTISING EFFECTIVENESS        1\n",
       "RTP NETWORK POD MANAGER                                   1\n",
       "APPLICATION ENGINEER 1615.32244                           1\n",
       "Name: JOB TITLE, Length: 2899, dtype: int64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#two ways to merge similar titles \n",
    "#method1\n",
    "df_['JOB TITLE'][df_['JOB TITLE'].str.contains('SOFTWARE ENGINEER')] =\"SOFTWARE_ENGINEER\"\n",
    "\n",
    "#method2\n",
    "df_['JOB TITLE']= df_['JOB TITLE'].apply(lambda x: \"MACHINE_LEARNING\" if \"MACHINE LEARNING\" in x else x)\n",
    "\n",
    "##bonus grouping\n",
    "df_['JOB TITLE'][df_['JOB TITLE'].str.contains('DEVELOPER')] =\"DEVELOPER_\"\n",
    "\n",
    "\n",
    "df_['JOB TITLE'].value_counts()"
   ]
  },
  {
   "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>EMPLOYER</th>\n",
       "      <th>JOB TITLE</th>\n",
       "      <th>BASE SALARY</th>\n",
       "      <th>LOCATION</th>\n",
       "      <th>SUBMIT DATE</th>\n",
       "      <th>START DATE</th>\n",
       "      <th>CASE STATUS</th>\n",
       "      <th>STATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1688</th>\n",
       "      <td>GOOGLE INC</td>\n",
       "      <td>MACHINE_LEARNING</td>\n",
       "      <td>155000</td>\n",
       "      <td>MOUNTAIN VIEW, CA</td>\n",
       "      <td>08/17/2016</td>\n",
       "      <td>08/25/2016</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1689</th>\n",
       "      <td>GOOGLE LLC</td>\n",
       "      <td>MACHINE_LEARNING</td>\n",
       "      <td>110000</td>\n",
       "      <td>NEW YORK, NY</td>\n",
       "      <td>11/16/2017</td>\n",
       "      <td>11/23/2017</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>NY</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        EMPLOYER         JOB TITLE  BASE SALARY           LOCATION  \\\n",
       "1688  GOOGLE INC  MACHINE_LEARNING       155000  MOUNTAIN VIEW, CA   \n",
       "1689  GOOGLE LLC  MACHINE_LEARNING       110000       NEW YORK, NY   \n",
       "\n",
       "     SUBMIT DATE  START DATE CASE STATUS STATE  \n",
       "1688  08/17/2016  08/25/2016   CERTIFIED    CA  \n",
       "1689  11/16/2017  11/23/2017   CERTIFIED    NY  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import seaborn as sns\n",
    "sns.set()\n",
    "\n",
    "#filter/sub-set just on a single job description\n",
    "position1 = df_[df_['JOB TITLE'] == 'MACHINE_LEARNING']\n",
    "position1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x739a910656a0>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAD4CAYAAADhNOGaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAF/tJREFUeJzt3XtwVOX9x/HPkhAHaIBIkywzZGgrGbQSham2MFxSNrdKEggEVIhguZUyhaK1InSQUnQELdZGZgQiLVji2FEoOGZbRRNJwFJ1RpkAdqZCuyXUZkNhuWNiNs/vD4eF/WU3LoQTQp7366895zzn5LvfZffDntu6jDFGAABrdbveBQAAri+CAAAsRxAAgOUIAgCwHEEAAJaLv94FXKljx85c9bpJST0VCJy/htXc2OhHOPpxCb0I1xX6kZycGHWZVd8I4uPjrncJnQr9CEc/LqEX4bp6P6wKAgBAawQBAFiOIAAAyxEEAGA5ggAALEcQAIDlHAuCpUuXasSIESooKIi43BijJ598Ujk5OSosLNTBgwedKgUA0AbHgmDSpEnauHFj1OU1NTXy+XzauXOnnnjiCa1YscKpUgAAbXAsCO6++2716dMn6vLKykoVFRXJ5XJp6NChOn36tBoaGpwqBwAQxXW7xYTf75fb7Q5Nu91u+f1+paSktLleUlLPq77Kr/CR169qvRvZG89OaHN5W5ed24h+XNLZe8H7+dq5bkEQ6YfRXC7XV653o9/vo6O1dW+m5OTEdt27qauhH5fQi86pPa9Jp7zXkNvtVn19fWi6vr7+K78NAACuvesWBB6PRzt27JAxRvv27VNiYiJBAADXgWO7hn72s5/pgw8+UCAQ0JgxY7Rw4UI1NzdLkqZOnarMzExVV1crJydHPXr00FNPPeVUKQCANjgWBL/5zW/aXO5yufTLX/7SqT8PAIgRVxYDgOUIAgCwHEEAAJYjCADAcgQBAFiOIAAAyxEEAGA5ggAALEcQAIDlCAIAsBxBAACWIwgAwHIEAQBYjiAAAMsRBABgOYIAACxHEACA5QgCALAcQQAAliMIAMByBAEAWI4gAADLEQQAYDmCAAAsRxAAgOUIAgCwHEEAAJYjCADAcgQBAFiOIAAAyxEEAGA5ggAALOdoENTU1CgvL085OTkqKytrtfyzzz7T9OnTVVRUpMLCQlVXVztZDgAggninNhwMBrVy5Upt2rRJqampmjx5sjwejwYNGhQas27dOt1zzz2aNm2aDh06pB/96EeqqqpyqiQAQASOfSOora3VwIEDlZaWpoSEBOXn56uysjJsjMvl0tmzZyVJZ86cUUpKilPlAACicOwbgd/vl9vtDk2npqaqtrY2bMyCBQs0e/ZslZeX68KFC9q0adNXbjcpqafi4+Oueb1dVXJyYruW24Z+XEIvOh+nXhPHgsAY02qey+UKm/Z6vZo4caJmzZqljz/+WIsXL1ZFRYW6dYv+RSUQOH/Na+3Kjh07E3VZcnJim8ttQz8uoRedU3tek7ZCxLFdQ263W/X19aFpv9/fatfP1q1bdc8990iShg0bpsbGRgUCAadKAgBE4FgQZGRkyOfzqa6uTk1NTfJ6vfJ4PGFj+vfvr71790qSDh8+rMbGRt18881OlQQAiMCxXUPx8fFavny55syZo2AwqOLiYqWnp6u0tFRDhgxRVlaWlixZomXLlmnz5s1yuVxavXp1q91HAABnORYEkpSZmanMzMyweYsWLQo9HjRokP74xz86WQIA4CtwZTEAWI4gAADLEQQAYDmCAAAsRxAAgOUIAgCwHEEAAJYjCADAcgQBAFiOIAAAyxEEAGA5ggAALEcQAIDlCAIAsBxBAACWIwgAwHIEAQBYjiAAAMsRBABgOYIAACxHEACA5QgCALAcQQAAliMIAMByBAEAWI4gAADLxRQEs2fP1rvvvitjjNP1AAA6WExBcN999+mll15Sdna2ysrKFAgEnK4LANBBYgqC3Nxcbd68WS+++KIaGhpUUFCgxYsX68CBA07XBwBw2FUdI+jevbtuuukmPfbYY1q9evW1rgkA0IHiYxm0c+dOlZeX6/jx45o2bZq8Xq969eql5uZm5ebmasmSJU7XCQBwSExBsHXrVs2dO1ejR48OXzk+XsuWLXOkMABAx4hp19CGDRtahcBFHo8n6no1NTXKy8tTTk6OysrKIo7585//rHHjxik/P1+PPPJILOUAAK6hmIJg2rRpOnXqVGj65MmTKikpaXOdYDColStXauPGjfJ6vaqoqNChQ4fCxvh8PpWVlemVV16R1+vVL37xi6t4CgCA9ogpCM6fP68+ffqEpvv27auzZ8+2uU5tba0GDhyotLQ0JSQkKD8/X5WVlWFjXn31VZWUlIS23a9fvyutHwDQTjEFQUtLi86fPx+aPnfunILBYJvr+P1+ud3u0HRqaqr8fn/YGJ/Pp3/961+6//77de+996qmpuZKagcAXAMxHSwuKCjQrFmzNHXqVEnSK6+8ovHjx7e5TqSrkF0uV9h0MBjUv//9b23ZskX19fUqKSlRRUWFevfuHXW7SUk9FR8fF0vZkJScnNiu5bahH5fQi87HqdckpiCYN2+eUlJSVFVVJWOM7r//fhUVFbW5jtvtVn19fWja7/crJSUlbExqaqqGDh2q7t27Ky0tTd/85jfl8/l0xx13RN1uIHA+6jK0duzYmajLkpMT21xuG/pxCb3onNrzmrQVIjEFgSRNnDhREydOjPmPZmRkyOfzqa6uTqmpqfJ6vXr22WfDxmRnZ8vr9WrSpEk6ceKEfD6f0tLSYv4bAID2iykIjh8/ri1btqiurk7Nzc2h+aWlpdE3HB+v5cuXa86cOQoGgyouLlZ6erpKS0s1ZMgQZWVlafTo0Xrvvfc0btw4xcXFafHixUpKSmr/swIAxCymIFi4cKFuueUWjRgxQnFxse+fz8zMVGZmZti8RYsWhR67XC4tXbpUS5cujXmbAIBrK6YgOH36tJ544gmnawEAXAcxnT6anp7e6tRPAEDXEPM3gvHjx2vYsGG66aabQvPbOkYAALgxxHwdQUFBgdO1AACug5iC4EpOGwUA3FhiOkbg8/k0derU0J1GDx48qLVr1zpaGACgY8QUBCtWrND8+fOVmPjllWm33Xab3nzzTUcLAwB0jJiC4MyZMxozZkzoXkHdunVT9+7dHS0MANAxYgqCuLg4ffHFF6Eg8Pv96tbtqn7uGADQycT8wzQLFixQIBDQ2rVrNW3aNM2aNcvp2gAAHSCms4aKioo0YMAAvfvuu7pw4YKefvpp3XXXXU7XBgDoADHfffSuu+7iwx8AuqCYgqC4uLjVj8pI0tatW695QQCAjhVTEDz22GOhx42NjfJ6va1+ZAYAcGOKKQi++93vhk2PGjWKg8UA0EVc1TmgZ8+eVV1d3bWuBQBwHVzxMYKWlhYdPXpUM2fOdLQwAEDHuOJjBHFxcRowYIBSU1MdKwoA0HGu6hgBAKDriCkIhg8fHvH0UWOMXC6X9u7de80LAwB0jJiCYOrUqTp58qTuu+8+GWO0bds2paamaty4cU7XBwBwWExB8OGHH6q8vDw0vWzZMj3wwAOaO3euY4UBADpGTKePNjQ06MSJE6HpEydO6NixY44VBQDoODF9I3jwwQc1YcIEjR07VpJUXV2tefPmOVoYAKBjxBQEJSUl+s53vqMPP/xQxhiVlJRo8ODBTtcGAOgAMd99dMCAAQoGg7r99tudrAcA0MFiOkZQXV2t/Px8LVy4UJK0f/9+/fjHP3a0MABAx4gpCJ5//nlt3bpVvXv3liRlZGToyJEjjhYGAOgYMd90Ljk5OWw6ISHhmhcDAOh4MQVBr1699L///S90dfH777+vxMRERwsDAHSMmA4WP/LII5o7d66OHj2q6dOny+fzad26dU7XBgDoADEFwZ133qk//OEP+uijjyRJw4YNCx0vAADc2L4yCILBoO69915t27ZNmZmZHVETAKADfeUxgri4OCUlJamxsfGKN15TU6O8vDzl5OSorKws6rg333xTgwcP1v79+6/4bwAA2iemXUPf+MY3VFJSory8PPXs2TM0v6SkJOo6wWBQK1eu1KZNm5SamqrJkyfL4/Fo0KBBYePOnj2rLVu26M4777zKpwAAaI+YguDcuXNKT0/XP//5z5g3XFtbq4EDByotLU2SlJ+fr8rKylZBUFpaqjlz5uj3v//9FZQNALhW2gyC1atXa8mSJVq1apXee+89jRw5MuYN+/1+ud3u0HRqaqpqa2vDxnzyySeqr6/X2LFjYw6CpKSeio+Pi7kO2yUnt32a71cttw39uIRedD5OvSZtBsH7778ferxmzZorCgJjTKt5l//KWUtLi1atWqVVq1bFvE1JCgTOX9F42x07dibqsuTkxDaX24Z+XEIvOqf2vCZthUibB4sv/zCP9MHeFrfbrfr6+tC03+9XSkpKaPrcuXP6xz/+oRkzZsjj8Wjfvn2aP38+B4wBoIO1+Y2gqalJhw8fljEm7PFF/39//+UyMjLk8/lUV1en1NRUeb1ePfvss6HliYmJYd84pk+frsWLFysjI6M9zwcAcIXaDILPP/887OcoL3/scrlUWVkZfcPx8Vq+fLnmzJmjYDCo4uJipaenq7S0VEOGDFFWVtY1KB8A0F5tBkFVVVW7Np6ZmdnqIrRFixZFHLtly5Z2/S0AwNWJ+e6jAICuiSAAAMsRBABgOYIAACxHEACA5QgCALAcQQAAliMIAMByBAEAWI4gAADLEQQAYDmCAAAsRxAAgOUIAgCwHEEAAJYjCADAcgQBAFiOIAAAyxEEAGA5ggAALEcQAIDlCAIAsBxBAACWIwgAwHIEAQBYjiAAAMsRBABgOYIAACxHEACA5QgCALAcQQAAliMIAMByjgZBTU2N8vLylJOTo7KyslbLN23apHHjxqmwsFAPPvig/vOf/zhZDgAgAseCIBgMauXKldq4caO8Xq8qKip06NChsDG33Xabtm3bpjfeeEN5eXn69a9/7VQ5AIAoHAuC2tpaDRw4UGlpaUpISFB+fr4qKyvDxgwfPlw9evSQJA0dOlT19fVOlQMAiCLeqQ37/X653e7QdGpqqmpra6OO37p1q8aMGfOV201K6qn4+LhrUqMNkpMT27XcNvTjEnrR+Tj1mjgWBMaYVvNcLlfEsa+//roOHDig8vLyr9xuIHC+3bXZ5NixM1GXJScntrncNvTjEnrRObXnNWkrRBwLArfbHbarx+/3KyUlpdW4v/71r1q/fr3Ky8uVkJDgVDkAgCgcO0aQkZEhn8+nuro6NTU1yev1yuPxhI355JNPtHz5cq1bt079+vVzqhQAQBsc+0YQHx+v5cuXa86cOQoGgyouLlZ6erpKS0s1ZMgQZWVl6ZlnntH58+e1aNEiSVL//v21fv16p0oCAETgWBBIUmZmpjIzM8PmXfzQl6TNmzc7+ecBADHgymIAsBxBAACWIwgAwHIEAQBYjiAAAMsRBABgOYIAACxHEACA5QgCALAcQQAAliMIAMByBAEAWI4gAADLEQQAYDmCAAAsRxAAgOUIAgCwHEEAAJYjCADAcgQBAFiOIAAAyxEEAGA5ggAALEcQAIDlCAIAsBxBAACWIwgAwHIEAQBYjiAAAMsRBABgOYIAACxHEACA5QgCALCco0FQU1OjvLw85eTkqKysrNXypqYmPfTQQ8rJydGUKVN09OhRJ8sBAETgWBAEg0GtXLlSGzdulNfrVUVFhQ4dOhQ25rXXXlPv3r319ttv64c//KHWrFnjVDkAgCgcC4La2loNHDhQaWlpSkhIUH5+viorK8PGVFVVaeLEiZKkvLw87d27V8YYp0oCAEQQ79SG/X6/3G53aDo1NVW1tbWtxvTv3//LQuLjlZiYqEAgoJtvvjnqdpOTE6+6pjeenXDV63ZV7elnV0Q/LunsveD9fO049o0g0v/sXS7XFY8BADjLsSBwu92qr68PTfv9fqWkpLQa89///leS1NzcrDNnzqhv375OlQQAiMCxIMjIyJDP51NdXZ2amprk9Xrl8XjCxng8Hm3fvl2S9NZbb2n48OF8IwCADuYyDh6dra6u1lNPPaVgMKji4mLNnz9fpaWlGjJkiLKystTY2KhHH31Uf//739WnTx8999xzSktLc6ocAEAEjgYBAKDz48piALAcQQAAlrthgmDp0qUaMWKECgoKQvP+8pe/KD8/X7feeqv2798fNn7Dhg3KyclRXl6edu/eHZof7bYXdXV1mjJlinJzc/XQQw+pqalJUue8DUakXjz99NP6wQ9+oMLCQv3kJz/R6dOnQ8u6ci+kyP347W9/q8LCQk2YMEGzZs2S3++X9OUpy08++aRycnJUWFiogwcPhtbZvn27cnNzlZubGzqJQZIOHDigwsJC5eTk6Mknnwyd9nzy5EnNnDlTubm5mjlzpk6dOtVBz7htkfpx0e9+9zsNHjxYJ06ckNT1+xGpF2vXrtXo0aM1YcIETZgwQdXV1aFlXf29EpW5QXzwwQfmwIEDJj8/PzTv0KFD5vDhw+aBBx4wtbW1ofmffvqpKSwsNI2NjebIkSMmKyvLNDc3m+bmZpOVlWWOHDliGhsbTWFhofn000+NMcb89Kc/NRUVFcYYYx5//HHz8ssvG2OMKS8vN48//rgxxpiKigqzaNGijnrKUUXqxe7du80XX3xhjDHmmWeeMc8884wxpuv3wpjI/Thz5kzo8UsvvRSqe9euXWb27NmmpaXFfPzxx2by5MnGGGMCgYDxeDwmEAiYkydPGo/HY06ePGmMMaa4uNh89NFHpqWlxcyePdvs2rXLGGPM008/bTZs2GCMMWbDhg2hnl9vkfphjDGfffaZmTVrlvn+979vjh8/bozp+v2I1Ivnn3/ebNy4sdVYG94r0dww3wjuvvtu9enTJ2zeLbfcom9961utxlZWVio/P18JCQlKS0vTwIEDVVtbG/W2F8YY/e1vf1NeXp4kaeLEiaHbYXTG22BE6sWoUaMUH//lheJDhw4NXcPR1XshRe7H1772tdDjCxcuhE5LrqysVFFRkVwul4YOHarTp0+roaFBe/bs0ciRI9W3b1/16dNHI0eO1O7du9XQ0KCzZ89q2LBhcrlcKioqCvXj4rYkqaioSO+8804HPeO2ReqHJK1atUqPPvpo2CnaXb0f0XoRiQ3vlWhumCC4EpFub+H3+6PODwQC6t27d+iD1O12h3YlRLsNRme2bds2jRkzRpLdvXjuueeUmZmpN954Q4sWLZLUuh8Xn1+sfbq8H8ePHw9dJJmSkhLa3dIZVVZWKiUlRbfeemvYfFv78fLLL6uwsFBLly4N7cKy+b3SJYMgUvK6XK4ruqXFxflXsk5nsG7dOsXFxWn8+PGS7O7Fww8/rOrqahUWFqq8vFzSlffjRnvOkVy4cEHr168PheHlbOzH1KlT9fbbb+v1119XSkqKVq9eLcnu90qXDIJot7eINj8pKUmnT59Wc3OzJKm+vj70P5sb6TYY27dv165du7RmzZrQPzpbe3G5goIC7dy5U1Lrflx8frH26fJ+9OvXTw0NDZKkhoaGNm+WeD0dOXJER48e1YQJE+TxeFRfX69Jkybp2LFjVvbj61//uuLi4tStWzdNmTIldKKJze+VLhkEHo9HXq9XTU1Nqqurk8/n0x133BH1thcul0vf+9739NZbb0n68gP14u0wbpTbYNTU1OjFF1/UunXr1KNHj9B8G3shST6fL/S4qqoqdCzJ4/Fox44dMsZo3759SkxMVEpKikaNGqU9e/bo1KlTOnXqlPbs2aNRo0YpJSVFvXr10r59+2SM0Y4dO5SVlRW2LUlh8zubwYMHa+/evaqqqlJVVZXcbrf+9Kc/KTk52cp+XAwrSXrnnXeUnp4uyd73iqQb56yhhx9+2IwcOdJ8+9vfNqNHjzavvvqq2blzpxk9erS5/fbbzYgRI8ysWbNC41944QWTlZVlcnNzQ2c1GPPlWRK5ubkmKyvLvPDCC6H5R44cMcXFxSY7O9ssXLjQNDY2GmOM+fzzz83ChQtNdna2KS4uNkeOHOm4Jx1FpF5kZ2ebMWPGmPHjx5vx48eHzlgwpmv3wpjI/ViwYIHJz883BQUFZt68eaa+vt4YY0xLS4tZsWKFycrKMgUFBWFnm7322msmOzvbZGdnm61bt4bm19bWmvz8fJOVlWV+9atfmZaWFmOMMSdOnDAzZswwOTk5ZsaMGSYQCHTsE48iUj8uN3bs2NBZQ129H5F68fOf/9wUFBSE/m34/f7Q+K7+XomGW0wAgOW65K4hAEDsCAIAsBxBAACWIwgAwHIEAQBYjiAAAMsRBABguf8DeRHpVfvQNbgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x739a91084c88>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "position1['BASE SALARY'].plot(kind='hist', bins=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x739a910846d8>"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYkAAAD4CAYAAAAZ1BptAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAGP9JREFUeJzt3X1Mlff9//HXkTNStcBBy/HYjtKbtUpWb5qWWILidrrDsQJyo8y0yzK0tkl1NOhqW7qlQXTWJmzW6OKkp03XdMlSdchPji3ooQXJ9GdmY2ldm46uZ+ImB6anYG/0jOP5/UE8vy9f+ZQbQaw+HwkJvK/P+Vyfz0k4r+vuXJclEolEBABAP8aN9QAAAFcvQgIAYERIAACMCAkAgBEhAQAwso71AEZaZ+fZsR4C0K/ExAkKBr8a62EA/UpKiuu3zp4EcIVYrTFjPQRgyAgJAIARIQEAMCIkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIyuuW9cA1dKZuYcffzxR6O6junTU9XU9H9HdR3AN7Fcaw8d4rYcuFot39SgV591jvUwgH5xWw4AwJAREgAAI0ICAGBESAAAjAgJAIARIQEAMCIkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMCIkAAAGA0YEmVlZUpPT1dOTk60tnXrVs2bN095eXnKy8tTY2NjdNmOHTvkcrnkdrt18ODBaL2pqUlut1sul0tVVVXReltbm4qKipSVlaXS0lKFQiFJUigUUmlpqVwul4qKinTy5MkRmTAAYPAGDInCwkJ5PJ5L6sXFxaqpqVFNTY3mz58vSWptbZXX65XX65XH49G6desUDocVDodVUVEhj8cjr9er2tpatba2SpIqKytVXFys+vp6xcfHa9euXZKknTt3Kj4+Xvv371dxcbEqKytHct4AgEEYMCTS0tKUkJAwqM58Pp+ys7MVGxur5ORkpaSkqKWlRS0tLUpJSVFycrJiY2OVnZ0tn8+nSCSiw4cPy+12S5IKCgrk8/kkSQ0NDSooKJAkud1uHTp0SNfY47gB4KpnHe4L//jHP2rPnj2655579OyzzyohIUGBQECzZs2KtpkyZYoCgYAkyeFw9Km3tLQoGAwqPj5eVqs12uZi+0AgoKlTp/YO0mpVXFycgsGgJk2a9I3jSkycIKs1ZrjTAkaV6WHzwNVqWCHx8MMPa+XKlbJYLNqyZYs2bdqkF154od8tfYvFogsXLvRb78/FuqmvgQSDXw3YBhgrnZ1nx3oIQL9MGzDDurrppptuUkxMjMaNG6eioiJ98MEHknr3BNrb26PtAoGA7Ha7sZ6YmKju7m719PRIktrb22W326N9nTp1SpLU09Ojs2fPymazDWe4AIBhGlZIdHR0RH8/cOCA7rrrLkmS0+mU1+tVKBRSW1ub/H6/Zs6cqRkzZsjv96utrU2hUEher1dOp1MWi0Vz5sxRXV2dJKm6ulpOpzPaV3V1tSSprq5ODzzwwKD2JAAAI2fAw01r1qzRkSNHFAwGlZmZqZKSEh05ckQff/yxJOmWW25RRUWFJOmuu+7SQw89pIULFyomJkbPP/+8YmJ6zw88//zzWrFihcLhsBYvXhwNlrVr12r16tV66aWXlJqaqqKiIknSkiVLtHbtWrlcLiUkJGjz5s2j8gYAAMwskWvskiGO+eJqtXxTg1591jnWwwD6NaLnJAAA1wdCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMCIkAAAGBESAAAjQgIAYERIAACMCAkAgBEhAQAwIiQAAEaEBADAiJAAABgREgAAI0ICAGBESAAAjAgJAIARIQEAMCIkAABGlkgkEhnrQYykzs6zYz0EfAuVvNSkL8/1jPUwLtvEG6zaWpo51sPAt1BSUly/desVHgdwVfryXI9efdY5qutISoob9Y2Y5ZsaRrV/XH843AQAMCIkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMBowJAoKytTenq6cnJyLln2yiuvaNq0aTpz5owkKRKJaMOGDXK5XMrNzdXx48ejbaurq5WVlaWsrCxVV1dH6x9++KFyc3Plcrm0YcMGXbzf4Oeff65ly5YpKytLy5YtU1dX12VPFgAwNAOGRGFhoTwezyX1U6dO6S9/+YtuvvnmaK2pqUl+v1/19fVav369ysvLJfV+4G/btk1vvvmmdu7cqW3btkU/9MvLy1VRUaH6+nr5/X41NTVJkqqqqpSenq76+nqlp6erqqpqJOYLABiCAUMiLS1NCQkJl9RfeOEFrV27VhaLJVrz+XzKz8+XxWLR7Nmz1d3drY6ODjU3NysjI0M2m00JCQnKyMjQwYMH1dHRoS+++EL33nuvLBaL8vPz5fP5+vQlSfn5+Tpw4MBIzRkAMEjDulW4z+eT3W7X9OnT+9QDgYAcDkf0b4fDoUAgcEl9ypQp/dYvtpek06dPy263S5Lsdnv0kNZAEhMnyGqNGc60cJ0z3U+fdeB6NuSQ+Prrr/X73/9er7766iXL+nt+kcViGXL9cgSDX13W63H9Gu1nPVyJ50lIPHgLw2PauBjy1U0nTpzQyZMnlZeXJ6fTqfb2dhUWFqqzs1MOh0Pt7e3Rtu3t7bLb7ZfUA4FAv/WL7SVp8uTJ6ujokCR1dHRo0qRJQx0qAOAyDTkkpk2bpkOHDqmhoUENDQ1yOBz685//rKSkJDmdTu3Zs0eRSETHjh1TXFyc7Ha75s6dq+bmZnV1damrq0vNzc2aO3eu7Ha7Jk6cqGPHjikSiWjPnj168MEHJSnal6Q+dQDAlTPg4aY1a9boyJEjCgaDyszMVElJiYqKivptO3/+fDU2Nsrlcmn8+PHauHGjJMlms2nlypVasmSJJGnVqlWy2WySeq9uKisr07lz55SZmanMzN7n8z7++OMqLS3Vrl27NHXqVG3ZsmVEJgwAGDxLpL8TA99iHI/FcCzf1HDNPON6tOeBa9OInZMAAFw/CAkAgBEhAQAwIiQAAEaEBADAiJAAABgREgAAI0ICAGBESAAAjAgJAIARIQEAMCIkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMCIkAAAGBESAAAjQgIAYERIAACMCAkAgBEhAQAwso71AICrwaMn/o8+WfH6qK7jk1HtvdejsTZJziuwJlwvCAlA0iu3LtKrz47uh2tSUpw6O8+O6jo2bWpQxqiuAdcbDjcBAIwICQCAESEBADAiJAAARoQEAMCIkAAAGA0YEmVlZUpPT1dOTk609tJLLyk3N1d5eXlavny5AoGAJCkSiWjDhg1yuVzKzc3V8ePHo6+prq5WVlaWsrKyVF1dHa1/+OGHys3Nlcvl0oYNGxSJRCRJn3/+uZYtW6asrCwtW7ZMXV1dIzZpAMDgDBgShYWF8ng8fWorVqzQ3r17VVNTox/84Af63e9+J0lqamqS3+9XfX291q9fr/Lyckm9H/jbtm3Tm2++qZ07d2rbtm3RD/3y8nJVVFSovr5efr9fTU1NkqSqqiqlp6ervr5e6enpqqqqGsl5AwAGYcCQSEtLU0JCQp/ajTfeGP3966+/lsVikST5fD7l5+fLYrFo9uzZ6u7uVkdHh5qbm5WRkSGbzaaEhARlZGTo4MGD6ujo0BdffKF7771XFotF+fn58vl8ffqSpPz8fB04cGDEJg0AGJxhf+N68+bN2rNnj+Li4vT66723MwgEAnI4HNE2DodDgUDgkvqUKVP6rV9sL0mnT5+W3W6XJNntdp05c2ZQ40pMnCCrNWa408J1LCkpjnUA/8uwQ2L16tVavXq1duzYoTfeeENPPvlk9HzC/2SxWIZcvxzB4FeX9Xpcv0b7lhlX4rYc0ujPA9cm08bFZV/dlJOTo/r6ekm9ewLt7e3RZe3t7bLb7ZfUA4FAv/WL7SVp8uTJ6ujokCR1dHRo0qRJlztUAMAQDSsk/H5/9PeGhgbdcccdkiSn06k9e/YoEono2LFjiouLk91u19y5c9Xc3Kyuri51dXWpublZc+fOld1u18SJE3Xs2DFFIhHt2bNHDz74YJ++JPWpAwCunAEPN61Zs0ZHjhxRMBhUZmamSkpK1NTUpM8++0wWi0W33HKL1q1bJ0maP3++Ghsb5XK5NH78eG3cuFGSZLPZtHLlSi1ZskSStGrVKtlsNkm9VzeVlZXp3LlzyszMVGZmpiTp8ccfV2lpqXbt2qWpU6dqy5Yto/IGAADMLJH+Tgx8i3E8FsOxfFPDNXGr8CsxD1ybRu2cBADg2kVIAACMCAkAgBEhAQAwIiQAAEaEBADAiJAAABgREgAAI0ICAGBESAAAjAgJAIARIQEAMCIkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMCIkAAAGBESAAAjQgIAYERIAACMCAkAgBEhAQAwIiQAAEaEBADAiJAAABgREgAAI+tYDwC4Wizf1DDWQ7hsE2/gXxojyxKJRCJjPYiR1Nl5dqyHAPRr+aYGvfqsc6yHAfQrKSmu3zqHmwAARgOGRFlZmdLT05WTkxOtvfjii1qwYIFyc3O1atUqdXd3R5ft2LFDLpdLbrdbBw8ejNabmprkdrvlcrlUVVUVrbe1tamoqEhZWVkqLS1VKBSSJIVCIZWWlsrlcqmoqEgnT54ckQkDAAZvwJAoLCyUx+PpU8vIyFBtba327t2r2267TTt27JAktba2yuv1yuv1yuPxaN26dQqHwwqHw6qoqJDH45HX61Vtba1aW1slSZWVlSouLlZ9fb3i4+O1a9cuSdLOnTsVHx+v/fv3q7i4WJWVlSM9dwDAAAYMibS0NCUkJPSpzZ07V1Zr7wmy2bNnq729XZLk8/mUnZ2t2NhYJScnKyUlRS0tLWppaVFKSoqSk5MVGxur7Oxs+Xw+RSIRHT58WG63W5JUUFAgn88nSWpoaFBBQYEkye1269ChQ7rGTp8AwFXvsi+F2L17tx566CFJUiAQ0KxZs6LLpkyZokAgIElyOBx96i0tLQoGg4qPj48GjsPhiLYPBAKaOnVq7yCtVsXFxSkYDGrSpEnfOJ7ExAmyWmMud1rAqDCdHASuVpcVEtu3b1dMTIwWLVokSf1u6VssFl24cKHfen8u1k19DSQY/GrANsBY4eo7XK1MGzDDDonq6mq9++67eu2116If3g6HI3roSerdG7Db7ZLUbz0xMVHd3d3q6emR1WpVe3t7tL3D4dCpU6fkcDjU09Ojs2fPymazDXe4AIBhGNYlsE1NTXr55Ze1fft2jR8/Plp3Op3yer0KhUJqa2uT3+/XzJkzNWPGDPn9frW1tSkUCsnr9crpdMpisWjOnDmqq6uT1Bs8Tqcz2ld1dbUkqa6uTg888MCg9iQAACNnwC/TrVmzRkeOHFEwGNTkyZNVUlKiqqoqhUKh6Jb9rFmzVFFRIan3ENTu3bsVExOj5557TvPnz5ckNTY2auPGjQqHw1q8eLGeeOIJSb2XwK5evVpdXV1KTU1VZWWlYmNjdf78ea1du1YfffSREhIStHnzZiUnJw84IXbncbXiy3S4mpkON/GNa+AKISRwNeMb1wCAISMkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMCIkAAAGBESAAAjQgIAYERIAACMCAkAgBEhAQAwIiQAAEaEBADAiJAAABgREgAAI0ICAGBESAAAjAgJAIARIQEAMCIkAABGhAQAwIiQAAAYERIAACNCAgBgREgAAIwICQCAESEBADAiJAAARoQEAMBowJAoKytTenq6cnJyorW33npL2dnZmj59uj744IM+7Xfs2CGXyyW3262DBw9G601NTXK73XK5XKqqqorW29raVFRUpKysLJWWlioUCkmSQqGQSktL5XK5VFRUpJMnT172ZAEAQzNgSBQWFsrj8fSp3X333dq6davS0tL61FtbW+X1euX1euXxeLRu3TqFw2GFw2FVVFTI4/HI6/WqtrZWra2tkqTKykoVFxervr5e8fHx2rVrlyRp586dio+P1/79+1VcXKzKysqRmjMAYJAGDIm0tDQlJCT0qd1555264447Lmnr8/mUnZ2t2NhYJScnKyUlRS0tLWppaVFKSoqSk5MVGxur7Oxs+Xw+RSIRHT58WG63W5JUUFAgn88nSWpoaFBBQYEkye1269ChQ4pEIpc9YQDA4FlHsrNAIKBZs2ZF/54yZYoCgYAkyeFw9Km3tLQoGAwqPj5eVqs12uZi+0AgoKlTp/YO0mpVXFycgsGgJk2a9I1jSEycIKs1ZiSnBfTrnnvu0fHjx4f0Gvtvh7aO73//+/rwww+H9iJgBI1oSPS3pW+xWHThwoV+6/25WDf1NZBg8KsB2wAj4Z13Dg2pfVJSnDo7zw55PcN5DTBUSUlx/dZH9Oomh8Oh9vb26N+BQEB2u91YT0xMVHd3t3p6eiRJ7e3tstvt0b5OnTolSerp6dHZs2dls9lGcrgAgAGMaEg4nU55vV6FQiG1tbXJ7/dr5syZmjFjhvx+v9ra2hQKheT1euV0OmWxWDRnzhzV1dVJkqqrq+V0OqN9VVdXS5Lq6ur0wAMPDGpPAgAwciyRAc4Gr1mzRkeOHFEwGNTkyZNVUlIim82m9evX68yZM4qPj1dqaqpeeeUVSdL27du1e/duxcTE6LnnntP8+fMlSY2Njdq4caPC4bAWL16sJ554QlLvJbCrV69WV1eXUlNTVVlZqdjYWJ0/f15r167VRx99pISEBG3evFnJyckDTohdc1ythnu4CbgSTIebBgyJbxv+CXG1IiRwNbsi5yQAANcWQgIAYERIAACMCAkAgNE1d+IaADBy2JMAABgREgAAI0ICAGBESAAAjAgJAIARIQEAMCIkAABGhASuC6mpqcrLy9OiRYtUUFCg9957r8/y1157TTNmzNDZs///Bnxff/21fvGLXyg3N1c5OTl6+OGH9eWXX/bp7+JPVVXVJes8duyYioqKlJeXp4ceekhbt27ts/yJJ57Q0qVL+9S2bt0avaPy/7Z//35NmzZNn376abR28uRJzZw5U3l5eVq4cKGefvpp/fe//9Xp06fldDrV2dkZbVteXt7vOIFvMqJPpgOuVjfccINqamokSQcPHtRvf/tbvfHGG9HltbW1mjFjhvbv36/CwkJJ0uuvv66bbrpJv/nNbyRJ//jHP/Sd73znkv5MnnnmGW3ZskXTp09XOBzWZ599Fl3W3d2tv/3tb5owYYLa2toGdRv82tpa3Xfffdq3b59KSkqi9VtvvVU1NTUKh8NatmyZ3nrrLS1atEiPPfaYXnzxRVVWVur48eM6evSofvnLXw7yHQN6sSeB684XX3yh+Pj46N8nTpzQV199pdLSUnm93mi9s7NTU6ZMif59xx13KDY2dtDrOXPmjJKSkiRJMTEx+t73vhddVldXpx/+8IfKzs7Wvn37Buzryy+/1Hvvvadf//rXfcb4P8XExGjmzJnR58QvXbpUbW1tOnz4sNavX6/nn38+GnLAYBESuC6cO3dOeXl5WrBggX71q19p5cqV0WW1tbXKzs7W/fffr88++0ynT5+WJC1evFgvv/yyli5dqs2bN8vv91/S38Wf/j7of/azn2nBggVatWqV/vSnP+n8+fPRZV6vVzk5OcrOzlZtbe2A4z9w4IDmzZun22+/XTabTcePH7+kzfnz5/X+++9r3rx5kqRx48apvLxcTz75pG677TalpaUN+v0CLiIkcF24eHjo7bfflsfj0TPPPKOLty3bt2+fsrOzNW7cOLlcLr399tuSes87HDhwQI8++qi6urq0ZMmS6PmAi/1d/Fm4cOEl6/z5z3+u3bt3KyMjQ7W1tVqxYoUk6T//+Y9OnDih++67T7fffrusVqs++eSTbxy/1+tVdna2JGnhwoV9guXEiRPKy8vTnDlzdPPNN2v69OnRZampqbrrrrv0yCOPXMa7h+sZ5yRw3bn33nsVDAZ15swZdXZ2yu/3a/ny5ZKkUCik5ORk/eQnP5EkTZw4UVlZWcrKytK4cePU2NioO++8c9DruvXWW/XII4/oxz/+sdLT0xUMBrVv3z51dXXpwQcflNR7+Mvr9eruu+/ut49gMKjDhw/r73//uywWi8LhsCwWi55++unoOmpqatTR0aGf/vSn8vl80b6l3j0Kng+P4WJPAtedTz/9VOFwWDabTV6vVyUlJWpoaFBDQ4Oam5sVCAT0r3/9S0ePHlVXV5ek3vBobW3VzTffPOj1vPvuu9G9lX/+858aN26c4uPj5fV65fF4ouvcvXv3N56XqKurU35+vt555x01NDSosbFR3/3ud3X06NE+7ex2u5566imuYMKIYk8C14WL5xAkKRKJ6MUXX1RMTIy8Xq9efvnlPm1dLpe8Xq/sdrvKy8slSRcuXND8+fPldrsv6U+S5s2bp6eeeqpPPzU1NXrhhRd0ww03KCYmRpWVlTp16pT+/e9/a/bs2dF2ycnJuvHGG/X+++9LkrZv364//OEP0eUpKSl67LHH+vSdlZWlvXv3XlL/0Y9+pK1bt+qvf/2r7r///uG8VUAfPE8CAGDE4SYAgBEhAQAwIiQAAEaEBADAiJAAABgREgAAI0ICAGD0/wB6hCiAB7f5yAAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x739a90fef278>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "position1['BASE SALARY'].plot(kind='box', legend=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}