company-jobs.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:1fa3dc48ad8282dea2cdebab5aa20aa1c069ee2c953974d000149be72b5bbff0"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "import numpy as np\n",
      "from geopy.geocoders import Nominatim\n",
      "import csv"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 20
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "companies = ['apple', 'facebook', 'amazon']"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "jobs_df = pd.DataFrame()\n",
      "for company in companies:\n",
      "    df = pd.read_csv('data/' + company + '.csv')\n",
      "    df['company'] = company\n",
      "    jobs_df = jobs_df.append(df)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "jobs_df.describe()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>job_id</th>\n",
        "      <th>title</th>\n",
        "      <th>department</th>\n",
        "      <th>location</th>\n",
        "      <th>date_posted</th>\n",
        "      <th>time_scraped</th>\n",
        "      <th>url</th>\n",
        "      <th>company_intro</th>\n",
        "      <th>role_description</th>\n",
        "      <th>listings</th>\n",
        "      <th>company</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>count</th>\n",
        "      <td>6818</td>\n",
        "      <td>6818</td>\n",
        "      <td>6818</td>\n",
        "      <td>6818</td>\n",
        "      <td>6739</td>\n",
        "      <td>6818</td>\n",
        "      <td>6818</td>\n",
        "      <td>79</td>\n",
        "      <td>6816</td>\n",
        "      <td>6818</td>\n",
        "      <td>6818</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>unique</th>\n",
        "      <td>6818</td>\n",
        "      <td>3754</td>\n",
        "      <td>58</td>\n",
        "      <td>165</td>\n",
        "      <td>581</td>\n",
        "      <td>6818</td>\n",
        "      <td>6818</td>\n",
        "      <td>4</td>\n",
        "      <td>5212</td>\n",
        "      <td>5557</td>\n",
        "      <td>3</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>top</th>\n",
        "      <td>smsd_24239457_fs</td>\n",
        "      <td>Software Development Engineer</td>\n",
        "      <td>Software Development</td>\n",
        "      <td>US, WA, Seattle</td>\n",
        "      <td>2017-01-31</td>\n",
        "      <td>2017-02-13 12:40:48.983445</td>\n",
        "      <td>https://www.amazon.jobs/en/jobs/490759</td>\n",
        "      <td>Facebook's mission is to give people the power...</td>\n",
        "      <td>Imagine what you could do here. At Apple, grea...</td>\n",
        "      <td>[{\"elements\": [\"\\u00b7 5+ years of software de...</td>\n",
        "      <td>amazon</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>freq</th>\n",
        "      <td>1</td>\n",
        "      <td>640</td>\n",
        "      <td>2583</td>\n",
        "      <td>4345</td>\n",
        "      <td>97</td>\n",
        "      <td>1</td>\n",
        "      <td>1</td>\n",
        "      <td>74</td>\n",
        "      <td>34</td>\n",
        "      <td>16</td>\n",
        "      <td>5862</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 4,
       "text": [
        "                  job_id                          title            department  \\\n",
        "count               6818                           6818                  6818   \n",
        "unique              6818                           3754                    58   \n",
        "top     smsd_24239457_fs  Software Development Engineer  Software Development   \n",
        "freq                   1                            640                  2583   \n",
        "\n",
        "               location date_posted                time_scraped  \\\n",
        "count              6818        6739                        6818   \n",
        "unique              165         581                        6818   \n",
        "top     US, WA, Seattle  2017-01-31  2017-02-13 12:40:48.983445   \n",
        "freq               4345          97                           1   \n",
        "\n",
        "                                           url  \\\n",
        "count                                     6818   \n",
        "unique                                    6818   \n",
        "top     https://www.amazon.jobs/en/jobs/490759   \n",
        "freq                                         1   \n",
        "\n",
        "                                            company_intro  \\\n",
        "count                                                  79   \n",
        "unique                                                  4   \n",
        "top     Facebook's mission is to give people the power...   \n",
        "freq                                                   74   \n",
        "\n",
        "                                         role_description  \\\n",
        "count                                                6816   \n",
        "unique                                               5212   \n",
        "top     Imagine what you could do here. At Apple, grea...   \n",
        "freq                                                   34   \n",
        "\n",
        "                                                 listings company  \n",
        "count                                                6818    6818  \n",
        "unique                                               5557       3  \n",
        "top     [{\"elements\": [\"\\u00b7 5+ years of software de...  amazon  \n",
        "freq                                                   16    5862  "
       ]
      }
     ],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "jobs_df.groupby('company')['company'].agg('count')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "company\n",
        "amazon      5862\n",
        "apple        877\n",
        "facebook      79\n",
        "Name: company, dtype: int64"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "job_to_locate = jobs_df[['job_id', 'company', 'location']]\n",
      "# Facebook jobs have more than one location, separated by |, so we should count them as multiple positions\n",
      "indices = []\n",
      "new_col = []\n",
      "for index in xrange(len(job_to_locate)):\n",
      "    for location in job_to_locate.iloc[index, :]['location'].split('|'):\n",
      "        new_col.append(location)\n",
      "        indices.append(index)\n",
      "job_to_locate = job_to_locate.drop('location')\n",
      "job_to_locate = job_to_locate.iloc[indices, :]\n",
      "job_to_locate['location'] = new_col"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "len(jobs_df)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": [
        "6818"
       ]
      }
     ],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "len(job_to_locate)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "6831"
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "geolocator = Nominatim()\n",
      "# def get_location(location_str):\n",
      "#     location = geolocator.geocode(location_str)\n",
      "#     return\n",
      "locations = job_to_locate[['location']].drop_duplicates()\n",
      "locations['geolocation'] = locations['location'].apply(geolocator.geocode)\n",
      "mask = locations['geolocation'].isnull()\n",
      "locations[mask]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>SF - Corporate, California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>705</th>\n",
        "      <td>Santa Clara (FMK), California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1448</th>\n",
        "      <td>US, OR, Virtual Location - Oregon</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4724</th>\n",
        "      <td>US, MO, Virtual Location - Missouri</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5256</th>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5304</th>\n",
        "      <td>US, PA, Virtual Location - Pennsylvani</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5355</th>\n",
        "      <td>US, NC, Virtual Contact Center-NC</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5409</th>\n",
        "      <td>US, OH, Virtual Location - Ohio</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5457</th>\n",
        "      <td>US, FL, Virtual Location - Florida</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5689</th>\n",
        "      <td>US, TX, Virtual Location - Texas</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 9,
       "text": [
        "                                    location geolocation\n",
        "14                SF - Corporate, California        None\n",
        "705            Santa Clara (FMK), California        None\n",
        "1448       US, OR, Virtual Location - Oregon        None\n",
        "4724     US, MO, Virtual Location - Missouri        None\n",
        "5256  US, MA, Virtual Location - Massachuset        None\n",
        "5304  US, PA, Virtual Location - Pennsylvani        None\n",
        "5355       US, NC, Virtual Contact Center-NC        None\n",
        "5409         US, OH, Virtual Location - Ohio        None\n",
        "5457      US, FL, Virtual Location - Florida        None\n",
        "5689        US, TX, Virtual Location - Texas        None"
       ]
      }
     ],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "locations.loc[mask, 'geolocation'] = locations.loc[mask, 'location']\\\n",
      "    .apply(lambda x: geolocator.geocode(x.replace('Virtual Location - ', '')))\n",
      "mask = locations['geolocation'].isnull()\n",
      "locations[mask]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>SF - Corporate, California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>705</th>\n",
        "      <td>Santa Clara (FMK), California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5256</th>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5355</th>\n",
        "      <td>US, NC, Virtual Contact Center-NC</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 10,
       "text": [
        "                                    location geolocation\n",
        "14                SF - Corporate, California        None\n",
        "705            Santa Clara (FMK), California        None\n",
        "5256  US, MA, Virtual Location - Massachuset        None\n",
        "5355       US, NC, Virtual Contact Center-NC        None"
       ]
      }
     ],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "locations.loc[mask, 'geolocation'] = locations.loc[mask, 'location']\\\n",
      "    .apply(lambda x: geolocator.geocode(x.replace(', Virtual Contact Center-NC', '')))\n",
      "mask = locations['geolocation'].isnull()\n",
      "locations[mask]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>SF - Corporate, California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>705</th>\n",
        "      <td>Santa Clara (FMK), California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5256</th>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 11,
       "text": [
        "                                    location geolocation\n",
        "14                SF - Corporate, California        None\n",
        "705            Santa Clara (FMK), California        None\n",
        "5256  US, MA, Virtual Location - Massachuset        None"
       ]
      }
     ],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "locations.loc[mask, 'geolocation'] = locations.loc[mask, 'location']\\\n",
      "    .apply(lambda x: geolocator.geocode(x.replace(' (FMK)', '')))\n",
      "mask = locations['geolocation'].isnull()\n",
      "locations[mask]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>SF - Corporate, California</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5256</th>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 12,
       "text": [
        "                                    location geolocation\n",
        "14                SF - Corporate, California        None\n",
        "5256  US, MA, Virtual Location - Massachuset        None"
       ]
      }
     ],
     "prompt_number": 12
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "locations.loc[mask, 'geolocation'] = locations.loc[mask, 'location']\\\n",
      "    .apply(lambda x: geolocator.geocode(x.replace(' - Corporate', '')))\n",
      "mask = locations['geolocation'].isnull()\n",
      "locations[mask]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>5256</th>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>None</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 13,
       "text": [
        "                                    location geolocation\n",
        "5256  US, MA, Virtual Location - Massachuset        None"
       ]
      }
     ],
     "prompt_number": 13
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "locations.loc[mask, 'geolocation'] = locations.loc[mask, 'location']\\\n",
      "    .apply(lambda x: geolocator.geocode(x.replace(', Virtual Location - Massachuset', '')))\n",
      "mask = locations['geolocation'].isnull()\n",
      "locations[mask]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 14,
       "text": [
        "Empty DataFrame\n",
        "Columns: [location, geolocation]\n",
        "Index: []"
       ]
      }
     ],
     "prompt_number": 14
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "job_to_locate = job_to_locate.merge(locations, on='location')\n",
      "job_to_locate"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>job_id</th>\n",
        "      <th>company</th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>53231338</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>50676238</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>50676236</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>42551457</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>50065236</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>45857498</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>54756000</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td>53403099</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td>54667232</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9</th>\n",
        "      <td>51446225</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td>54755748</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td>54755651</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td>54755912</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td>52559478</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>55344475</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td>55344304</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td>51250082</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td>46702013</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td>54281129</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td>53599665</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td>55391420</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td>54856429</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td>54536193</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td>54536192</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td>44820647</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td>55358769</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td>53940748</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td>53617152</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td>51373532</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td>54906760</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6801</th>\n",
        "      <td>mo_24695525_qm</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MA, Fall River</td>\n",
        "      <td>(Fall River, Bristol County, Massachusetts, Un...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6802</th>\n",
        "      <td>mo_24672838_e9</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MA, Fall River</td>\n",
        "      <td>(Fall River, Bristol County, Massachusetts, Un...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6803</th>\n",
        "      <td>mo_24695524_fp</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CT, Windsor</td>\n",
        "      <td>(Windsor, Town of Windsor, Hartford County, Co...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6804</th>\n",
        "      <td>mo_24675495_7c</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CT, Windsor</td>\n",
        "      <td>(Windsor, Town of Windsor, Hartford County, Co...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6805</th>\n",
        "      <td>mo_24672411_6s</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CT, Windsor</td>\n",
        "      <td>(Windsor, Town of Windsor, Hartford County, Co...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6806</th>\n",
        "      <td>mo_24695522_x6</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, NJ, Florence</td>\n",
        "      <td>(Florence, Camden County, New Jersey, United S...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6807</th>\n",
        "      <td>mo_24646993_bh</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CA, Newark</td>\n",
        "      <td>(Newark, Alameda County, California, United St...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6808</th>\n",
        "      <td>mo_24767782_z4</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CA, Newark</td>\n",
        "      <td>(Newark, Alameda County, California, United St...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6809</th>\n",
        "      <td>mo_24646975_ke</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, KS, Lenexa</td>\n",
        "      <td>(Lenexa, Johnson County, Kansas, United States...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6810</th>\n",
        "      <td>mo_24754715_f0</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, KS, Lenexa</td>\n",
        "      <td>(Lenexa, Johnson County, Kansas, United States...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6811</th>\n",
        "      <td>mo_24776356_od</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MD, North East</td>\n",
        "      <td>(North East, Cecil County, Maryland, United St...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6812</th>\n",
        "      <td>mo_24776347_5a</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MD, North East</td>\n",
        "      <td>(North East, Cecil County, Maryland, United St...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6813</th>\n",
        "      <td>mo_24674142_6p</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, NV, Reno</td>\n",
        "      <td>(Reno, Washoe County, Nevada, United States of...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6814</th>\n",
        "      <td>mo_24652476_9i</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CA, Redlands</td>\n",
        "      <td>(Redlands, San Bernardino County, California, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6815</th>\n",
        "      <td>fa_24567513_20</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Kennesaw</td>\n",
        "      <td>(Kennesaw, Cobb County, Georgia, United States...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6816</th>\n",
        "      <td>fa_24584766_e3</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>(Massachusetts, United States of America, (42....</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6817</th>\n",
        "      <td>mps_24746775_ax</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, PA, Virtual Location - Pennsylvani</td>\n",
        "      <td>(College Heights, Berks County, Pennsylvania, ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6818</th>\n",
        "      <td>ps_24621618_2i</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, OH, Cincinnati</td>\n",
        "      <td>(Cincinnati, Hamilton County, Ohio, United Sta...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6819</th>\n",
        "      <td>msa_24767750_2y</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, OH, Cincinnati</td>\n",
        "      <td>(Cincinnati, Hamilton County, Ohio, United Sta...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6820</th>\n",
        "      <td>smpp_24697087_k3</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6821</th>\n",
        "      <td>sa_24766415_os</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6822</th>\n",
        "      <td>sa_24766414_t7</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6823</th>\n",
        "      <td>sa_24565842_nz</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6824</th>\n",
        "      <td>ps_24758426_9i</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6825</th>\n",
        "      <td>msa_24766694_ys</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6826</th>\n",
        "      <td>tpm_24737502_1n</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, NC, Virtual Contact Center-NC</td>\n",
        "      <td>(North Carolina, United States of America, (35...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6827</th>\n",
        "      <td>mtpm_24747104_9h</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, OH, Virtual Location - Ohio</td>\n",
        "      <td>(North Condit, Delaware County, Ohio, United S...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6828</th>\n",
        "      <td>smtb_24704731_gf</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, FL, Virtual Location - Florida</td>\n",
        "      <td>(Florida, Eustis, Lake County, Florida, 32726,...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6829</th>\n",
        "      <td>ps_24768873_qt</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, TX, Virtual Location - Texas</td>\n",
        "      <td>(Texas, Arlington, Tarrant County, Texas, Unit...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6830</th>\n",
        "      <td>msa_24744654_3n</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CO, Denver</td>\n",
        "      <td>(Denver, Denver County, Colorado, United State...</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>6831 rows \u00d7 4 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 15,
       "text": [
        "                job_id company                                location  \\\n",
        "0             53231338   apple          Santa Clara Valley, California   \n",
        "1             50676238   apple          Santa Clara Valley, California   \n",
        "2             50676236   apple          Santa Clara Valley, California   \n",
        "3             42551457   apple          Santa Clara Valley, California   \n",
        "4             50065236   apple          Santa Clara Valley, California   \n",
        "5             45857498   apple          Santa Clara Valley, California   \n",
        "6             54756000   apple          Santa Clara Valley, California   \n",
        "7             53403099   apple          Santa Clara Valley, California   \n",
        "8             54667232   apple          Santa Clara Valley, California   \n",
        "9             51446225   apple          Santa Clara Valley, California   \n",
        "10            54755748   apple          Santa Clara Valley, California   \n",
        "11            54755651   apple          Santa Clara Valley, California   \n",
        "12            54755912   apple          Santa Clara Valley, California   \n",
        "13            52559478   apple          Santa Clara Valley, California   \n",
        "14            55344475   apple          Santa Clara Valley, California   \n",
        "15            55344304   apple          Santa Clara Valley, California   \n",
        "16            51250082   apple          Santa Clara Valley, California   \n",
        "17            46702013   apple          Santa Clara Valley, California   \n",
        "18            54281129   apple          Santa Clara Valley, California   \n",
        "19            53599665   apple          Santa Clara Valley, California   \n",
        "20            55391420   apple          Santa Clara Valley, California   \n",
        "21            54856429   apple          Santa Clara Valley, California   \n",
        "22            54536193   apple          Santa Clara Valley, California   \n",
        "23            54536192   apple          Santa Clara Valley, California   \n",
        "24            44820647   apple          Santa Clara Valley, California   \n",
        "25            55358769   apple          Santa Clara Valley, California   \n",
        "26            53940748   apple          Santa Clara Valley, California   \n",
        "27            53617152   apple          Santa Clara Valley, California   \n",
        "28            51373532   apple          Santa Clara Valley, California   \n",
        "29            54906760   apple          Santa Clara Valley, California   \n",
        "...                ...     ...                                     ...   \n",
        "6801    mo_24695525_qm  amazon                      US, MA, Fall River   \n",
        "6802    mo_24672838_e9  amazon                      US, MA, Fall River   \n",
        "6803    mo_24695524_fp  amazon                         US, CT, Windsor   \n",
        "6804    mo_24675495_7c  amazon                         US, CT, Windsor   \n",
        "6805    mo_24672411_6s  amazon                         US, CT, Windsor   \n",
        "6806    mo_24695522_x6  amazon                        US, NJ, Florence   \n",
        "6807    mo_24646993_bh  amazon                          US, CA, Newark   \n",
        "6808    mo_24767782_z4  amazon                          US, CA, Newark   \n",
        "6809    mo_24646975_ke  amazon                          US, KS, Lenexa   \n",
        "6810    mo_24754715_f0  amazon                          US, KS, Lenexa   \n",
        "6811    mo_24776356_od  amazon                      US, MD, North East   \n",
        "6812    mo_24776347_5a  amazon                      US, MD, North East   \n",
        "6813    mo_24674142_6p  amazon                            US, NV, Reno   \n",
        "6814    mo_24652476_9i  amazon                        US, CA, Redlands   \n",
        "6815    fa_24567513_20  amazon                        US, GA, Kennesaw   \n",
        "6816    fa_24584766_e3  amazon  US, MA, Virtual Location - Massachuset   \n",
        "6817   mps_24746775_ax  amazon  US, PA, Virtual Location - Pennsylvani   \n",
        "6818    ps_24621618_2i  amazon                      US, OH, Cincinnati   \n",
        "6819   msa_24767750_2y  amazon                      US, OH, Cincinnati   \n",
        "6820  smpp_24697087_k3  amazon                         US, GA, Atlanta   \n",
        "6821    sa_24766415_os  amazon                         US, GA, Atlanta   \n",
        "6822    sa_24766414_t7  amazon                         US, GA, Atlanta   \n",
        "6823    sa_24565842_nz  amazon                         US, GA, Atlanta   \n",
        "6824    ps_24758426_9i  amazon                         US, GA, Atlanta   \n",
        "6825   msa_24766694_ys  amazon                         US, GA, Atlanta   \n",
        "6826   tpm_24737502_1n  amazon       US, NC, Virtual Contact Center-NC   \n",
        "6827  mtpm_24747104_9h  amazon         US, OH, Virtual Location - Ohio   \n",
        "6828  smtb_24704731_gf  amazon      US, FL, Virtual Location - Florida   \n",
        "6829    ps_24768873_qt  amazon        US, TX, Virtual Location - Texas   \n",
        "6830   msa_24744654_3n  amazon                          US, CO, Denver   \n",
        "\n",
        "                                            geolocation  \n",
        "0     (Santa Clara, Santa Clara County, California, ...  \n",
        "1     (Santa Clara, Santa Clara County, California, ...  \n",
        "2     (Santa Clara, Santa Clara County, California, ...  \n",
        "3     (Santa Clara, Santa Clara County, California, ...  \n",
        "4     (Santa Clara, Santa Clara County, California, ...  \n",
        "5     (Santa Clara, Santa Clara County, California, ...  \n",
        "6     (Santa Clara, Santa Clara County, California, ...  \n",
        "7     (Santa Clara, Santa Clara County, California, ...  \n",
        "8     (Santa Clara, Santa Clara County, California, ...  \n",
        "9     (Santa Clara, Santa Clara County, California, ...  \n",
        "10    (Santa Clara, Santa Clara County, California, ...  \n",
        "11    (Santa Clara, Santa Clara County, California, ...  \n",
        "12    (Santa Clara, Santa Clara County, California, ...  \n",
        "13    (Santa Clara, Santa Clara County, California, ...  \n",
        "14    (Santa Clara, Santa Clara County, California, ...  \n",
        "15    (Santa Clara, Santa Clara County, California, ...  \n",
        "16    (Santa Clara, Santa Clara County, California, ...  \n",
        "17    (Santa Clara, Santa Clara County, California, ...  \n",
        "18    (Santa Clara, Santa Clara County, California, ...  \n",
        "19    (Santa Clara, Santa Clara County, California, ...  \n",
        "20    (Santa Clara, Santa Clara County, California, ...  \n",
        "21    (Santa Clara, Santa Clara County, California, ...  \n",
        "22    (Santa Clara, Santa Clara County, California, ...  \n",
        "23    (Santa Clara, Santa Clara County, California, ...  \n",
        "24    (Santa Clara, Santa Clara County, California, ...  \n",
        "25    (Santa Clara, Santa Clara County, California, ...  \n",
        "26    (Santa Clara, Santa Clara County, California, ...  \n",
        "27    (Santa Clara, Santa Clara County, California, ...  \n",
        "28    (Santa Clara, Santa Clara County, California, ...  \n",
        "29    (Santa Clara, Santa Clara County, California, ...  \n",
        "...                                                 ...  \n",
        "6801  (Fall River, Bristol County, Massachusetts, Un...  \n",
        "6802  (Fall River, Bristol County, Massachusetts, Un...  \n",
        "6803  (Windsor, Town of Windsor, Hartford County, Co...  \n",
        "6804  (Windsor, Town of Windsor, Hartford County, Co...  \n",
        "6805  (Windsor, Town of Windsor, Hartford County, Co...  \n",
        "6806  (Florence, Camden County, New Jersey, United S...  \n",
        "6807  (Newark, Alameda County, California, United St...  \n",
        "6808  (Newark, Alameda County, California, United St...  \n",
        "6809  (Lenexa, Johnson County, Kansas, United States...  \n",
        "6810  (Lenexa, Johnson County, Kansas, United States...  \n",
        "6811  (North East, Cecil County, Maryland, United St...  \n",
        "6812  (North East, Cecil County, Maryland, United St...  \n",
        "6813  (Reno, Washoe County, Nevada, United States of...  \n",
        "6814  (Redlands, San Bernardino County, California, ...  \n",
        "6815  (Kennesaw, Cobb County, Georgia, United States...  \n",
        "6816  (Massachusetts, United States of America, (42....  \n",
        "6817  (College Heights, Berks County, Pennsylvania, ...  \n",
        "6818  (Cincinnati, Hamilton County, Ohio, United Sta...  \n",
        "6819  (Cincinnati, Hamilton County, Ohio, United Sta...  \n",
        "6820  (Atlanta, Fulton County, Georgia, United State...  \n",
        "6821  (Atlanta, Fulton County, Georgia, United State...  \n",
        "6822  (Atlanta, Fulton County, Georgia, United State...  \n",
        "6823  (Atlanta, Fulton County, Georgia, United State...  \n",
        "6824  (Atlanta, Fulton County, Georgia, United State...  \n",
        "6825  (Atlanta, Fulton County, Georgia, United State...  \n",
        "6826  (North Carolina, United States of America, (35...  \n",
        "6827  (North Condit, Delaware County, Ohio, United S...  \n",
        "6828  (Florida, Eustis, Lake County, Florida, 32726,...  \n",
        "6829  (Texas, Arlington, Tarrant County, Texas, Unit...  \n",
        "6830  (Denver, Denver County, Colorado, United State...  \n",
        "\n",
        "[6831 rows x 4 columns]"
       ]
      }
     ],
     "prompt_number": 15
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "job_to_locate['longitude'] = job_to_locate['geolocation'].apply(lambda x: x.longitude)\n",
      "job_to_locate['latitude'] = job_to_locate['geolocation'].apply(lambda x: x.latitude)\n",
      "job_to_locate"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>job_id</th>\n",
        "      <th>company</th>\n",
        "      <th>location</th>\n",
        "      <th>geolocation</th>\n",
        "      <th>longitude</th>\n",
        "      <th>latitude</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>53231338</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>50676238</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>50676236</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>42551457</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td>50065236</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td>45857498</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6</th>\n",
        "      <td>54756000</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7</th>\n",
        "      <td>53403099</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8</th>\n",
        "      <td>54667232</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9</th>\n",
        "      <td>51446225</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10</th>\n",
        "      <td>54755748</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11</th>\n",
        "      <td>54755651</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12</th>\n",
        "      <td>54755912</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13</th>\n",
        "      <td>52559478</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14</th>\n",
        "      <td>55344475</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15</th>\n",
        "      <td>55344304</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16</th>\n",
        "      <td>51250082</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17</th>\n",
        "      <td>46702013</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18</th>\n",
        "      <td>54281129</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19</th>\n",
        "      <td>53599665</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20</th>\n",
        "      <td>55391420</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21</th>\n",
        "      <td>54856429</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22</th>\n",
        "      <td>54536193</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23</th>\n",
        "      <td>54536192</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24</th>\n",
        "      <td>44820647</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25</th>\n",
        "      <td>55358769</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26</th>\n",
        "      <td>53940748</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27</th>\n",
        "      <td>53617152</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28</th>\n",
        "      <td>51373532</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29</th>\n",
        "      <td>54906760</td>\n",
        "      <td>apple</td>\n",
        "      <td>Santa Clara Valley, California</td>\n",
        "      <td>(Santa Clara, Santa Clara County, California, ...</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>37.354113</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",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6801</th>\n",
        "      <td>mo_24695525_qm</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MA, Fall River</td>\n",
        "      <td>(Fall River, Bristol County, Massachusetts, Un...</td>\n",
        "      <td>-71.154637</td>\n",
        "      <td>41.701064</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6802</th>\n",
        "      <td>mo_24672838_e9</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MA, Fall River</td>\n",
        "      <td>(Fall River, Bristol County, Massachusetts, Un...</td>\n",
        "      <td>-71.154637</td>\n",
        "      <td>41.701064</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6803</th>\n",
        "      <td>mo_24695524_fp</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CT, Windsor</td>\n",
        "      <td>(Windsor, Town of Windsor, Hartford County, Co...</td>\n",
        "      <td>-72.643702</td>\n",
        "      <td>41.852598</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6804</th>\n",
        "      <td>mo_24675495_7c</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CT, Windsor</td>\n",
        "      <td>(Windsor, Town of Windsor, Hartford County, Co...</td>\n",
        "      <td>-72.643702</td>\n",
        "      <td>41.852598</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6805</th>\n",
        "      <td>mo_24672411_6s</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CT, Windsor</td>\n",
        "      <td>(Windsor, Town of Windsor, Hartford County, Co...</td>\n",
        "      <td>-72.643702</td>\n",
        "      <td>41.852598</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6806</th>\n",
        "      <td>mo_24695522_x6</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, NJ, Florence</td>\n",
        "      <td>(Florence, Camden County, New Jersey, United S...</td>\n",
        "      <td>-74.918220</td>\n",
        "      <td>39.734282</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6807</th>\n",
        "      <td>mo_24646993_bh</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CA, Newark</td>\n",
        "      <td>(Newark, Alameda County, California, United St...</td>\n",
        "      <td>-122.040240</td>\n",
        "      <td>37.529659</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6808</th>\n",
        "      <td>mo_24767782_z4</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CA, Newark</td>\n",
        "      <td>(Newark, Alameda County, California, United St...</td>\n",
        "      <td>-122.040240</td>\n",
        "      <td>37.529659</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6809</th>\n",
        "      <td>mo_24646975_ke</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, KS, Lenexa</td>\n",
        "      <td>(Lenexa, Johnson County, Kansas, United States...</td>\n",
        "      <td>-94.733734</td>\n",
        "      <td>38.953669</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6810</th>\n",
        "      <td>mo_24754715_f0</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, KS, Lenexa</td>\n",
        "      <td>(Lenexa, Johnson County, Kansas, United States...</td>\n",
        "      <td>-94.733734</td>\n",
        "      <td>38.953669</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6811</th>\n",
        "      <td>mo_24776356_od</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MD, North East</td>\n",
        "      <td>(North East, Cecil County, Maryland, United St...</td>\n",
        "      <td>-75.941333</td>\n",
        "      <td>39.600113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6812</th>\n",
        "      <td>mo_24776347_5a</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MD, North East</td>\n",
        "      <td>(North East, Cecil County, Maryland, United St...</td>\n",
        "      <td>-75.941333</td>\n",
        "      <td>39.600113</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6813</th>\n",
        "      <td>mo_24674142_6p</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, NV, Reno</td>\n",
        "      <td>(Reno, Washoe County, Nevada, United States of...</td>\n",
        "      <td>-119.813674</td>\n",
        "      <td>39.529270</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6814</th>\n",
        "      <td>mo_24652476_9i</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CA, Redlands</td>\n",
        "      <td>(Redlands, San Bernardino County, California, ...</td>\n",
        "      <td>-117.248984</td>\n",
        "      <td>34.069909</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6815</th>\n",
        "      <td>fa_24567513_20</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Kennesaw</td>\n",
        "      <td>(Kennesaw, Cobb County, Georgia, United States...</td>\n",
        "      <td>-84.615490</td>\n",
        "      <td>34.023434</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6816</th>\n",
        "      <td>fa_24584766_e3</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, MA, Virtual Location - Massachuset</td>\n",
        "      <td>(Massachusetts, United States of America, (42....</td>\n",
        "      <td>-72.032366</td>\n",
        "      <td>42.378877</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6817</th>\n",
        "      <td>mps_24746775_ax</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, PA, Virtual Location - Pennsylvani</td>\n",
        "      <td>(College Heights, Berks County, Pennsylvania, ...</td>\n",
        "      <td>-75.899320</td>\n",
        "      <td>40.361403</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6818</th>\n",
        "      <td>ps_24621618_2i</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, OH, Cincinnati</td>\n",
        "      <td>(Cincinnati, Hamilton County, Ohio, United Sta...</td>\n",
        "      <td>-84.512460</td>\n",
        "      <td>39.101454</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6819</th>\n",
        "      <td>msa_24767750_2y</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, OH, Cincinnati</td>\n",
        "      <td>(Cincinnati, Hamilton County, Ohio, United Sta...</td>\n",
        "      <td>-84.512460</td>\n",
        "      <td>39.101454</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6820</th>\n",
        "      <td>smpp_24697087_k3</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "      <td>-84.390185</td>\n",
        "      <td>33.749099</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6821</th>\n",
        "      <td>sa_24766415_os</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "      <td>-84.390185</td>\n",
        "      <td>33.749099</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6822</th>\n",
        "      <td>sa_24766414_t7</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "      <td>-84.390185</td>\n",
        "      <td>33.749099</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6823</th>\n",
        "      <td>sa_24565842_nz</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "      <td>-84.390185</td>\n",
        "      <td>33.749099</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6824</th>\n",
        "      <td>ps_24758426_9i</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "      <td>-84.390185</td>\n",
        "      <td>33.749099</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6825</th>\n",
        "      <td>msa_24766694_ys</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, GA, Atlanta</td>\n",
        "      <td>(Atlanta, Fulton County, Georgia, United State...</td>\n",
        "      <td>-84.390185</td>\n",
        "      <td>33.749099</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6826</th>\n",
        "      <td>tpm_24737502_1n</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, NC, Virtual Contact Center-NC</td>\n",
        "      <td>(North Carolina, United States of America, (35...</td>\n",
        "      <td>-79.039292</td>\n",
        "      <td>35.672964</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6827</th>\n",
        "      <td>mtpm_24747104_9h</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, OH, Virtual Location - Ohio</td>\n",
        "      <td>(North Condit, Delaware County, Ohio, United S...</td>\n",
        "      <td>-82.790105</td>\n",
        "      <td>40.276664</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6828</th>\n",
        "      <td>smtb_24704731_gf</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, FL, Virtual Location - Florida</td>\n",
        "      <td>(Florida, Eustis, Lake County, Florida, 32726,...</td>\n",
        "      <td>-81.695625</td>\n",
        "      <td>28.875474</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6829</th>\n",
        "      <td>ps_24768873_qt</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, TX, Virtual Location - Texas</td>\n",
        "      <td>(Texas, Arlington, Tarrant County, Texas, Unit...</td>\n",
        "      <td>-97.071368</td>\n",
        "      <td>32.756306</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6830</th>\n",
        "      <td>msa_24744654_3n</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, CO, Denver</td>\n",
        "      <td>(Denver, Denver County, Colorado, United State...</td>\n",
        "      <td>-104.984703</td>\n",
        "      <td>39.739154</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>6831 rows \u00d7 6 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 16,
       "text": [
        "                job_id company                                location  \\\n",
        "0             53231338   apple          Santa Clara Valley, California   \n",
        "1             50676238   apple          Santa Clara Valley, California   \n",
        "2             50676236   apple          Santa Clara Valley, California   \n",
        "3             42551457   apple          Santa Clara Valley, California   \n",
        "4             50065236   apple          Santa Clara Valley, California   \n",
        "5             45857498   apple          Santa Clara Valley, California   \n",
        "6             54756000   apple          Santa Clara Valley, California   \n",
        "7             53403099   apple          Santa Clara Valley, California   \n",
        "8             54667232   apple          Santa Clara Valley, California   \n",
        "9             51446225   apple          Santa Clara Valley, California   \n",
        "10            54755748   apple          Santa Clara Valley, California   \n",
        "11            54755651   apple          Santa Clara Valley, California   \n",
        "12            54755912   apple          Santa Clara Valley, California   \n",
        "13            52559478   apple          Santa Clara Valley, California   \n",
        "14            55344475   apple          Santa Clara Valley, California   \n",
        "15            55344304   apple          Santa Clara Valley, California   \n",
        "16            51250082   apple          Santa Clara Valley, California   \n",
        "17            46702013   apple          Santa Clara Valley, California   \n",
        "18            54281129   apple          Santa Clara Valley, California   \n",
        "19            53599665   apple          Santa Clara Valley, California   \n",
        "20            55391420   apple          Santa Clara Valley, California   \n",
        "21            54856429   apple          Santa Clara Valley, California   \n",
        "22            54536193   apple          Santa Clara Valley, California   \n",
        "23            54536192   apple          Santa Clara Valley, California   \n",
        "24            44820647   apple          Santa Clara Valley, California   \n",
        "25            55358769   apple          Santa Clara Valley, California   \n",
        "26            53940748   apple          Santa Clara Valley, California   \n",
        "27            53617152   apple          Santa Clara Valley, California   \n",
        "28            51373532   apple          Santa Clara Valley, California   \n",
        "29            54906760   apple          Santa Clara Valley, California   \n",
        "...                ...     ...                                     ...   \n",
        "6801    mo_24695525_qm  amazon                      US, MA, Fall River   \n",
        "6802    mo_24672838_e9  amazon                      US, MA, Fall River   \n",
        "6803    mo_24695524_fp  amazon                         US, CT, Windsor   \n",
        "6804    mo_24675495_7c  amazon                         US, CT, Windsor   \n",
        "6805    mo_24672411_6s  amazon                         US, CT, Windsor   \n",
        "6806    mo_24695522_x6  amazon                        US, NJ, Florence   \n",
        "6807    mo_24646993_bh  amazon                          US, CA, Newark   \n",
        "6808    mo_24767782_z4  amazon                          US, CA, Newark   \n",
        "6809    mo_24646975_ke  amazon                          US, KS, Lenexa   \n",
        "6810    mo_24754715_f0  amazon                          US, KS, Lenexa   \n",
        "6811    mo_24776356_od  amazon                      US, MD, North East   \n",
        "6812    mo_24776347_5a  amazon                      US, MD, North East   \n",
        "6813    mo_24674142_6p  amazon                            US, NV, Reno   \n",
        "6814    mo_24652476_9i  amazon                        US, CA, Redlands   \n",
        "6815    fa_24567513_20  amazon                        US, GA, Kennesaw   \n",
        "6816    fa_24584766_e3  amazon  US, MA, Virtual Location - Massachuset   \n",
        "6817   mps_24746775_ax  amazon  US, PA, Virtual Location - Pennsylvani   \n",
        "6818    ps_24621618_2i  amazon                      US, OH, Cincinnati   \n",
        "6819   msa_24767750_2y  amazon                      US, OH, Cincinnati   \n",
        "6820  smpp_24697087_k3  amazon                         US, GA, Atlanta   \n",
        "6821    sa_24766415_os  amazon                         US, GA, Atlanta   \n",
        "6822    sa_24766414_t7  amazon                         US, GA, Atlanta   \n",
        "6823    sa_24565842_nz  amazon                         US, GA, Atlanta   \n",
        "6824    ps_24758426_9i  amazon                         US, GA, Atlanta   \n",
        "6825   msa_24766694_ys  amazon                         US, GA, Atlanta   \n",
        "6826   tpm_24737502_1n  amazon       US, NC, Virtual Contact Center-NC   \n",
        "6827  mtpm_24747104_9h  amazon         US, OH, Virtual Location - Ohio   \n",
        "6828  smtb_24704731_gf  amazon      US, FL, Virtual Location - Florida   \n",
        "6829    ps_24768873_qt  amazon        US, TX, Virtual Location - Texas   \n",
        "6830   msa_24744654_3n  amazon                          US, CO, Denver   \n",
        "\n",
        "                                            geolocation   longitude   latitude  \n",
        "0     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "1     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "2     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "3     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "4     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "5     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "6     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "7     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "8     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "9     (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "10    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "11    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "12    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "13    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "14    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "15    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "16    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "17    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "18    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "19    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "20    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "21    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "22    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "23    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "24    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "25    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "26    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "27    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "28    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "29    (Santa Clara, Santa Clara County, California, ... -121.955174  37.354113  \n",
        "...                                                 ...         ...        ...  \n",
        "6801  (Fall River, Bristol County, Massachusetts, Un...  -71.154637  41.701064  \n",
        "6802  (Fall River, Bristol County, Massachusetts, Un...  -71.154637  41.701064  \n",
        "6803  (Windsor, Town of Windsor, Hartford County, Co...  -72.643702  41.852598  \n",
        "6804  (Windsor, Town of Windsor, Hartford County, Co...  -72.643702  41.852598  \n",
        "6805  (Windsor, Town of Windsor, Hartford County, Co...  -72.643702  41.852598  \n",
        "6806  (Florence, Camden County, New Jersey, United S...  -74.918220  39.734282  \n",
        "6807  (Newark, Alameda County, California, United St... -122.040240  37.529659  \n",
        "6808  (Newark, Alameda County, California, United St... -122.040240  37.529659  \n",
        "6809  (Lenexa, Johnson County, Kansas, United States...  -94.733734  38.953669  \n",
        "6810  (Lenexa, Johnson County, Kansas, United States...  -94.733734  38.953669  \n",
        "6811  (North East, Cecil County, Maryland, United St...  -75.941333  39.600113  \n",
        "6812  (North East, Cecil County, Maryland, United St...  -75.941333  39.600113  \n",
        "6813  (Reno, Washoe County, Nevada, United States of... -119.813674  39.529270  \n",
        "6814  (Redlands, San Bernardino County, California, ... -117.248984  34.069909  \n",
        "6815  (Kennesaw, Cobb County, Georgia, United States...  -84.615490  34.023434  \n",
        "6816  (Massachusetts, United States of America, (42....  -72.032366  42.378877  \n",
        "6817  (College Heights, Berks County, Pennsylvania, ...  -75.899320  40.361403  \n",
        "6818  (Cincinnati, Hamilton County, Ohio, United Sta...  -84.512460  39.101454  \n",
        "6819  (Cincinnati, Hamilton County, Ohio, United Sta...  -84.512460  39.101454  \n",
        "6820  (Atlanta, Fulton County, Georgia, United State...  -84.390185  33.749099  \n",
        "6821  (Atlanta, Fulton County, Georgia, United State...  -84.390185  33.749099  \n",
        "6822  (Atlanta, Fulton County, Georgia, United State...  -84.390185  33.749099  \n",
        "6823  (Atlanta, Fulton County, Georgia, United State...  -84.390185  33.749099  \n",
        "6824  (Atlanta, Fulton County, Georgia, United State...  -84.390185  33.749099  \n",
        "6825  (Atlanta, Fulton County, Georgia, United State...  -84.390185  33.749099  \n",
        "6826  (North Carolina, United States of America, (35...  -79.039292  35.672964  \n",
        "6827  (North Condit, Delaware County, Ohio, United S...  -82.790105  40.276664  \n",
        "6828  (Florida, Eustis, Lake County, Florida, 32726,...  -81.695625  28.875474  \n",
        "6829  (Texas, Arlington, Tarrant County, Texas, Unit...  -97.071368  32.756306  \n",
        "6830  (Denver, Denver County, Colorado, United State... -104.984703  39.739154  \n",
        "\n",
        "[6831 rows x 6 columns]"
       ]
      }
     ],
     "prompt_number": 16
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "job_to_locate = job_to_locate.drop('geolocation', axis = 1)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 18
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "job_to_locate.describe(include = 'all')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>job_id</th>\n",
        "      <th>company</th>\n",
        "      <th>location</th>\n",
        "      <th>longitude</th>\n",
        "      <th>latitude</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>count</th>\n",
        "      <td>6831</td>\n",
        "      <td>6831</td>\n",
        "      <td>6831</td>\n",
        "      <td>6831.000000</td>\n",
        "      <td>6831.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>unique</th>\n",
        "      <td>6818</td>\n",
        "      <td>3</td>\n",
        "      <td>161</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>top</th>\n",
        "      <td>a0I1200000JXqq0EAD</td>\n",
        "      <td>amazon</td>\n",
        "      <td>US, WA, Seattle</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>freq</th>\n",
        "      <td>3</td>\n",
        "      <td>5862</td>\n",
        "      <td>4345</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>mean</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>-116.203632</td>\n",
        "      <td>44.155395</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>std</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>14.998902</td>\n",
        "      <td>4.973678</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>min</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>-122.880185</td>\n",
        "      <td>25.774266</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25%</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>-122.330062</td>\n",
        "      <td>38.969532</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>50%</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>-122.330062</td>\n",
        "      <td>47.603832</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>75%</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>-121.955174</td>\n",
        "      <td>47.603832</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>max</th>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>-6.260273</td>\n",
        "      <td>61.066692</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 19,
       "text": [
        "                    job_id company         location    longitude     latitude\n",
        "count                 6831    6831             6831  6831.000000  6831.000000\n",
        "unique                6818       3              161          NaN          NaN\n",
        "top     a0I1200000JXqq0EAD  amazon  US, WA, Seattle          NaN          NaN\n",
        "freq                     3    5862             4345          NaN          NaN\n",
        "mean                   NaN     NaN              NaN  -116.203632    44.155395\n",
        "std                    NaN     NaN              NaN    14.998902     4.973678\n",
        "min                    NaN     NaN              NaN  -122.880185    25.774266\n",
        "25%                    NaN     NaN              NaN  -122.330062    38.969532\n",
        "50%                    NaN     NaN              NaN  -122.330062    47.603832\n",
        "75%                    NaN     NaN              NaN  -121.955174    47.603832\n",
        "max                    NaN     NaN              NaN    -6.260273    61.066692"
       ]
      }
     ],
     "prompt_number": 19
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "job_to_locate.to_csv('data/company_job_locations.csv', index = False, quoting = csv.QUOTE_MINIMAL)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 21
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}