H1B Visa Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "filename = 'data/H-1B_FY14_Q4.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_NUMBER</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>LCA_CASE_SUBMIT</th>\n",
       "      <th>DECISION_DATE</th>\n",
       "      <th>VISA_CLASS</th>\n",
       "      <th>LCA_CASE_EMPLOYMENT_START_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYMENT_END_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYER_NAME</th>\n",
       "      <th>LCA_CASE_EMPLOYER_ADDRESS</th>\n",
       "      <th>LCA_CASE_EMPLOYER_CITY</th>\n",
       "      <th>...</th>\n",
       "      <th>OTHER_WAGE_SOURCE_1</th>\n",
       "      <th>YR_SOURCE_PUB_1</th>\n",
       "      <th>LCA_CASE_WORKLOC2_CITY</th>\n",
       "      <th>LCA_CASE_WORKLOC2_STATE</th>\n",
       "      <th>PW_2</th>\n",
       "      <th>PW_UNIT_2</th>\n",
       "      <th>PW_SOURCE_2</th>\n",
       "      <th>OTHER_WAGE_SOURCE_2</th>\n",
       "      <th>YR_SOURCE_PUB_2</th>\n",
       "      <th>LCA_CASE_NAICS_CODE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>I-200-09106-546545</td>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-01-18 18:05:43</td>\n",
       "      <td>2014-09-29 15:59:50</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>TEXAS STATE UNIVERSITY-SAN MARCOS</td>\n",
       "      <td>601 UNIVERSITY DRIVE</td>\n",
       "      <td>SAN MARCOS</td>\n",
       "      <td>...</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>2013</td>\n",
       "      <td>ST. LOUIS</td>\n",
       "      <td>MO</td>\n",
       "      <td>49566</td>\n",
       "      <td>Year</td>\n",
       "      <td>OES</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>611310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>I-200-09162-143337</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-03-17 11:11:45</td>\n",
       "      <td>2014-03-21 23:11:51</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>2014-09-15</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>EYE SPECIALISTS OF INDIANA, P.C.</td>\n",
       "      <td>1901 N. MERIDIAN ST.</td>\n",
       "      <td>INDIANAPOLIS</td>\n",
       "      <td>...</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>2013</td>\n",
       "      <td>INDIANAPOLIS</td>\n",
       "      <td>IN</td>\n",
       "      <td>64251</td>\n",
       "      <td>Year</td>\n",
       "      <td>Other</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>621320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I-200-09182-550211</td>\n",
       "      <td>DENIED</td>\n",
       "      <td>2014-03-14 17:05:01</td>\n",
       "      <td>2014-03-20 16:59:49</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>2014-04-01</td>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>LHB, INC.</td>\n",
       "      <td>21 WEST SUPERIOR STREET</td>\n",
       "      <td>DULUTH</td>\n",
       "      <td>...</td>\n",
       "      <td>OFLIC ONLINE</td>\n",
       "      <td>2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>541330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I-200-09193-873099</td>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-03-01 12:37:02</td>\n",
       "      <td>2014-03-06 22:03:37</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>2017-08-27</td>\n",
       "      <td>WAM USA, INC.</td>\n",
       "      <td>75 BOULDERBROOK CIRCLE</td>\n",
       "      <td>LAWRENCEVILLE</td>\n",
       "      <td>...</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>2014</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>333922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>I-200-09197-120609</td>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2014-03-10 15:33:41</td>\n",
       "      <td>2014-03-17 10:52:46</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>2014-09-01</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>DFUSE TECHNOLOGIES, INC.</td>\n",
       "      <td>20143 DESERT FOREST DRIVE</td>\n",
       "      <td>ASHBURN</td>\n",
       "      <td>...</td>\n",
       "      <td>OFLC ONLINE DATA CENTER</td>\n",
       "      <td>2013</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>541519</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      LCA_CASE_NUMBER               STATUS     LCA_CASE_SUBMIT  \\\n",
       "0  I-200-09106-546545  CERTIFIED-WITHDRAWN 2013-01-18 18:05:43   \n",
       "1  I-200-09162-143337            CERTIFIED 2014-03-17 11:11:45   \n",
       "2  I-200-09182-550211               DENIED 2014-03-14 17:05:01   \n",
       "3  I-200-09193-873099            CERTIFIED 2014-03-01 12:37:02   \n",
       "4  I-200-09197-120609  CERTIFIED-WITHDRAWN 2014-03-10 15:33:41   \n",
       "\n",
       "        DECISION_DATE VISA_CLASS LCA_CASE_EMPLOYMENT_START_DATE  \\\n",
       "0 2014-09-29 15:59:50       H-1B                     2013-02-01   \n",
       "1 2014-03-21 23:11:51       H-1B                     2014-09-15   \n",
       "2 2014-03-20 16:59:49       H-1B                     2014-04-01   \n",
       "3 2014-03-06 22:03:37       H-1B                     2014-08-28   \n",
       "4 2014-03-17 10:52:46       H-1B                     2014-09-01   \n",
       "\n",
       "  LCA_CASE_EMPLOYMENT_END_DATE             LCA_CASE_EMPLOYER_NAME  \\\n",
       "0                   2016-02-01  TEXAS STATE UNIVERSITY-SAN MARCOS   \n",
       "1                   2017-09-15   EYE SPECIALISTS OF INDIANA, P.C.   \n",
       "2                   2015-04-01                          LHB, INC.   \n",
       "3                   2017-08-27                      WAM USA, INC.   \n",
       "4                   2017-09-01           DFUSE TECHNOLOGIES, INC.   \n",
       "\n",
       "   LCA_CASE_EMPLOYER_ADDRESS LCA_CASE_EMPLOYER_CITY         ...           \\\n",
       "0       601 UNIVERSITY DRIVE             SAN MARCOS         ...            \n",
       "1       1901 N. MERIDIAN ST.           INDIANAPOLIS         ...            \n",
       "2    21 WEST SUPERIOR STREET                 DULUTH         ...            \n",
       "3     75 BOULDERBROOK CIRCLE          LAWRENCEVILLE         ...            \n",
       "4  20143 DESERT FOREST DRIVE                ASHBURN         ...            \n",
       "\n",
       "       OTHER_WAGE_SOURCE_1 YR_SOURCE_PUB_1 LCA_CASE_WORKLOC2_CITY  \\\n",
       "0  OFLC ONLINE DATA CENTER            2013              ST. LOUIS   \n",
       "1  OFLC ONLINE DATA CENTER            2013           INDIANAPOLIS   \n",
       "2             OFLIC ONLINE            2014                    NaN   \n",
       "3  OFLC ONLINE DATA CENTER            2014                    NaN   \n",
       "4  OFLC ONLINE DATA CENTER            2013                    NaN   \n",
       "\n",
       "  LCA_CASE_WORKLOC2_STATE   PW_2  PW_UNIT_2  PW_SOURCE_2  \\\n",
       "0                      MO  49566       Year          OES   \n",
       "1                      IN  64251       Year        Other   \n",
       "2                     NaN    NaN        NaN          NaN   \n",
       "3                     NaN    NaN        NaN          NaN   \n",
       "4                     NaN    NaN        NaN          NaN   \n",
       "\n",
       "       OTHER_WAGE_SOURCE_2          YR_SOURCE_PUB_2  LCA_CASE_NAICS_CODE  \n",
       "0  OFLC ONLINE DATA CENTER  OFLC ONLINE DATA CENTER               611310  \n",
       "1  OFLC ONLINE DATA CENTER  OFLC ONLINE DATA CENTER               621320  \n",
       "2                      NaN                      NaN               541330  \n",
       "3                      NaN                      NaN               333922  \n",
       "4                      NaN                      NaN               541519  \n",
       "\n",
       "[5 rows x 35 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open(filename, 'rb') as f:\n",
    "    df = pd.read_excel(f, sheetname='H-1B_FY2014')\n",
    "df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['LCA_CASE_NUMBER', 'STATUS', 'LCA_CASE_SUBMIT', 'DECISION_DATE',\n",
       "       'VISA_CLASS', 'LCA_CASE_EMPLOYMENT_START_DATE',\n",
       "       'LCA_CASE_EMPLOYMENT_END_DATE', 'LCA_CASE_EMPLOYER_NAME',\n",
       "       'LCA_CASE_EMPLOYER_ADDRESS', 'LCA_CASE_EMPLOYER_CITY',\n",
       "       'LCA_CASE_EMPLOYER_STATE', 'LCA_CASE_EMPLOYER_POSTAL_CODE',\n",
       "       'LCA_CASE_SOC_CODE', 'LCA_CASE_SOC_NAME', 'LCA_CASE_JOB_TITLE',\n",
       "       'LCA_CASE_WAGE_RATE_FROM', 'LCA_CASE_WAGE_RATE_TO',\n",
       "       'LCA_CASE_WAGE_RATE_UNIT', 'FULL_TIME_POS', 'TOTAL_WORKERS',\n",
       "       'LCA_CASE_WORKLOC1_CITY', 'LCA_CASE_WORKLOC1_STATE', 'PW_1',\n",
       "       'PW_UNIT_1', 'PW_SOURCE_1', 'OTHER_WAGE_SOURCE_1', 'YR_SOURCE_PUB_1',\n",
       "       'LCA_CASE_WORKLOC2_CITY', 'LCA_CASE_WORKLOC2_STATE', 'PW_2',\n",
       "       'PW_UNIT_2', 'PW_SOURCE_2', 'OTHER_WAGE_SOURCE_2', 'YR_SOURCE_PUB_2',\n",
       "       'LCA_CASE_NAICS_CODE'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "keep_list = ['STATUS', 'LCA_CASE_SUBMIT', 'DECISION_DATE', \n",
    "             'LCA_CASE_EMPLOYMENT_START_DATE', 'LCA_CASE_EMPLOYMENT_END_DATE',\n",
    "             'LCA_CASE_EMPLOYER_NAME', 'LCA_CASE_EMPLOYER_CITY', 'LCA_CASE_EMPLOYER_STATE',\n",
    "             'LCA_CASE_EMPLOYER_POSTAL_CODE', 'LCA_CASE_SOC_NAME', 'LCA_CASE_JOB_TITLE',\n",
    "             'LCA_CASE_WAGE_RATE_FROM', 'LCA_CASE_WAGE_RATE_TO', 'LCA_CASE_WAGE_RATE_UNIT',\n",
    "             'FULL_TIME_POS', 'TOTAL_WORKERS','LCA_CASE_WORKLOC1_CITY', 'LCA_CASE_WORKLOC1_STATE'] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df = df[keep_list]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_SUBMIT</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STATUS</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>INVALIDATED</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJECTED</th>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DENIED</th>\n",
       "      <td>11938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WITHDRAWN</th>\n",
       "      <td>16069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CERTIFIED-WITHDRAWN</th>\n",
       "      <td>36350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CERTIFIED</th>\n",
       "      <td>455144</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     LCA_CASE_SUBMIT\n",
       "STATUS                              \n",
       "INVALIDATED                        1\n",
       "REJECTED                           2\n",
       "DENIED                         11938\n",
       "WITHDRAWN                      16069\n",
       "CERTIFIED-WITHDRAWN            36350\n",
       "CERTIFIED                     455144"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['STATUS', 'LCA_CASE_SUBMIT']].groupby('STATUS').count().sort('LCA_CASE_SUBMIT')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATUS</th>\n",
       "      <th>LCA_CASE_SUBMIT</th>\n",
       "      <th>DECISION_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYMENT_START_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYMENT_END_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYER_NAME</th>\n",
       "      <th>LCA_CASE_EMPLOYER_CITY</th>\n",
       "      <th>LCA_CASE_EMPLOYER_STATE</th>\n",
       "      <th>LCA_CASE_EMPLOYER_POSTAL_CODE</th>\n",
       "      <th>LCA_CASE_SOC_NAME</th>\n",
       "      <th>LCA_CASE_JOB_TITLE</th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "      <th>LCA_CASE_WAGE_RATE_TO</th>\n",
       "      <th>LCA_CASE_WAGE_RATE_UNIT</th>\n",
       "      <th>FULL_TIME_POS</th>\n",
       "      <th>TOTAL_WORKERS</th>\n",
       "      <th>LCA_CASE_WORKLOC1_CITY</th>\n",
       "      <th>LCA_CASE_WORKLOC1_STATE</th>\n",
       "      <th>DECISION_TIME</th>\n",
       "      <th>DECISION_TIME_DAYS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-01-18 18:05:43</td>\n",
       "      <td>2014-09-29 15:59:50</td>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>2016-02-01</td>\n",
       "      <td>TEXAS STATE UNIVERSITY-SAN MARCOS</td>\n",
       "      <td>SAN MARCOS</td>\n",
       "      <td>TX</td>\n",
       "      <td>78666</td>\n",
       "      <td>Biological Scientists, All Other</td>\n",
       "      <td>POSTDOCTORAL RESEARCH ASSOCIATE</td>\n",
       "      <td>50000</td>\n",
       "      <td>60000</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN MARCOS</td>\n",
       "      <td>TX</td>\n",
       "      <td>618 days 21:54:07</td>\n",
       "      <td>618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-03-17 11:11:45</td>\n",
       "      <td>2014-03-21 23:11:51</td>\n",
       "      <td>2014-09-15</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>EYE SPECIALISTS OF INDIANA, P.C.</td>\n",
       "      <td>INDIANAPOLIS</td>\n",
       "      <td>IN</td>\n",
       "      <td>46202</td>\n",
       "      <td>Optometrists</td>\n",
       "      <td>OPTOMETRIST</td>\n",
       "      <td>65000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>INDIANAPOLIS</td>\n",
       "      <td>IN</td>\n",
       "      <td>4 days 12:00:06</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DENIED</td>\n",
       "      <td>2014-03-14 17:05:01</td>\n",
       "      <td>2014-03-20 16:59:49</td>\n",
       "      <td>2014-04-01</td>\n",
       "      <td>2015-04-01</td>\n",
       "      <td>LHB, INC.</td>\n",
       "      <td>DULUTH</td>\n",
       "      <td>MN</td>\n",
       "      <td>55802</td>\n",
       "      <td>Actors</td>\n",
       "      <td>FOOD SAFETY SCIENTIST</td>\n",
       "      <td>50000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>FARG</td>\n",
       "      <td>WI</td>\n",
       "      <td>5 days 23:54:48</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-03-01 12:37:02</td>\n",
       "      <td>2014-03-06 22:03:37</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>2017-08-27</td>\n",
       "      <td>WAM USA, INC.</td>\n",
       "      <td>LAWRENCEVILLE</td>\n",
       "      <td>GA</td>\n",
       "      <td>30045</td>\n",
       "      <td>Accountants and Auditors</td>\n",
       "      <td>INTERNATIONAL ACCOUNTANT</td>\n",
       "      <td>48000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>LAWRENCEVILLE</td>\n",
       "      <td>GA</td>\n",
       "      <td>5 days 09:26:35</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2014-03-10 15:33:41</td>\n",
       "      <td>2014-03-17 10:52:46</td>\n",
       "      <td>2014-09-01</td>\n",
       "      <td>2017-09-01</td>\n",
       "      <td>DFUSE TECHNOLOGIES, INC.</td>\n",
       "      <td>ASHBURN</td>\n",
       "      <td>VA</td>\n",
       "      <td>20147</td>\n",
       "      <td>Computer Programmers</td>\n",
       "      <td>PROGRAMMER ANALYST</td>\n",
       "      <td>62000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>CA</td>\n",
       "      <td>6 days 19:19:05</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                STATUS     LCA_CASE_SUBMIT       DECISION_DATE  \\\n",
       "0  CERTIFIED-WITHDRAWN 2013-01-18 18:05:43 2014-09-29 15:59:50   \n",
       "1            CERTIFIED 2014-03-17 11:11:45 2014-03-21 23:11:51   \n",
       "2               DENIED 2014-03-14 17:05:01 2014-03-20 16:59:49   \n",
       "3            CERTIFIED 2014-03-01 12:37:02 2014-03-06 22:03:37   \n",
       "4  CERTIFIED-WITHDRAWN 2014-03-10 15:33:41 2014-03-17 10:52:46   \n",
       "\n",
       "  LCA_CASE_EMPLOYMENT_START_DATE LCA_CASE_EMPLOYMENT_END_DATE  \\\n",
       "0                     2013-02-01                   2016-02-01   \n",
       "1                     2014-09-15                   2017-09-15   \n",
       "2                     2014-04-01                   2015-04-01   \n",
       "3                     2014-08-28                   2017-08-27   \n",
       "4                     2014-09-01                   2017-09-01   \n",
       "\n",
       "              LCA_CASE_EMPLOYER_NAME LCA_CASE_EMPLOYER_CITY  \\\n",
       "0  TEXAS STATE UNIVERSITY-SAN MARCOS             SAN MARCOS   \n",
       "1   EYE SPECIALISTS OF INDIANA, P.C.           INDIANAPOLIS   \n",
       "2                          LHB, INC.                 DULUTH   \n",
       "3                      WAM USA, INC.          LAWRENCEVILLE   \n",
       "4           DFUSE TECHNOLOGIES, INC.                ASHBURN   \n",
       "\n",
       "  LCA_CASE_EMPLOYER_STATE LCA_CASE_EMPLOYER_POSTAL_CODE  \\\n",
       "0                      TX                         78666   \n",
       "1                      IN                         46202   \n",
       "2                      MN                         55802   \n",
       "3                      GA                         30045   \n",
       "4                      VA                         20147   \n",
       "\n",
       "                  LCA_CASE_SOC_NAME               LCA_CASE_JOB_TITLE  \\\n",
       "0  Biological Scientists, All Other  POSTDOCTORAL RESEARCH ASSOCIATE   \n",
       "1                      Optometrists                      OPTOMETRIST   \n",
       "2                            Actors            FOOD SAFETY SCIENTIST   \n",
       "3          Accountants and Auditors         INTERNATIONAL ACCOUNTANT   \n",
       "4              Computer Programmers               PROGRAMMER ANALYST   \n",
       "\n",
       "   LCA_CASE_WAGE_RATE_FROM  LCA_CASE_WAGE_RATE_TO LCA_CASE_WAGE_RATE_UNIT  \\\n",
       "0                    50000                  60000                    Year   \n",
       "1                    65000                    NaN                    Year   \n",
       "2                    50000                    NaN                    Year   \n",
       "3                    48000                    NaN                    Year   \n",
       "4                    62000                    NaN                    Year   \n",
       "\n",
       "  FULL_TIME_POS  TOTAL_WORKERS LCA_CASE_WORKLOC1_CITY LCA_CASE_WORKLOC1_STATE  \\\n",
       "0             Y              1             SAN MARCOS                      TX   \n",
       "1             Y              1           INDIANAPOLIS                      IN   \n",
       "2             Y              1                   FARG                      WI   \n",
       "3             Y              1          LAWRENCEVILLE                      GA   \n",
       "4             Y              1               SAN JOSE                      CA   \n",
       "\n",
       "      DECISION_TIME  DECISION_TIME_DAYS  \n",
       "0 618 days 21:54:07                 618  \n",
       "1   4 days 12:00:06                   4  \n",
       "2   5 days 23:54:48                   5  \n",
       "3   5 days 09:26:35                   5  \n",
       "4   6 days 19:19:05                   6  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['DECISION_TIME']=df['DECISION_DATE'] - df['LCA_CASE_SUBMIT']\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    618\n",
       "1      4\n",
       "2      5\n",
       "3      5\n",
       "4      6\n",
       "Name: DECISION_TIME_DAYS, dtype: int64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['DECISION_TIME_DAYS']=df['DECISION_TIME'].dt.days\n",
    "df['DECISION_TIME_DAYS'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "34.52812875358034\n",
      "1747\n",
      "0\n"
     ]
    }
   ],
   "source": [
    "print(df['DECISION_TIME_DAYS'].mean())\n",
    "print(df['DECISION_TIME_DAYS'].max())\n",
    "print(df['DECISION_TIME_DAYS'].min())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DECISION_TIME_DAYS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STATUS</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CERTIFIED</th>\n",
       "      <td>6.365212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CERTIFIED-WITHDRAWN</th>\n",
       "      <td>355.472985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DENIED</th>\n",
       "      <td>6.498241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INVALIDATED</th>\n",
       "      <td>406.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REJECTED</th>\n",
       "      <td>5.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WITHDRAWN</th>\n",
       "      <td>127.013318</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     DECISION_TIME_DAYS\n",
       "STATUS                                 \n",
       "CERTIFIED                      6.365212\n",
       "CERTIFIED-WITHDRAWN          355.472985\n",
       "DENIED                         6.498241\n",
       "INVALIDATED                  406.000000\n",
       "REJECTED                       5.500000\n",
       "WITHDRAWN                    127.013318"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['STATUS', 'DECISION_TIME_DAYS']].groupby('STATUS').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LCA_CASE_WAGE_RATE_UNIT</th>\n",
       "      <th>LCA_CASE_EMPLOYER_STATE</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"29\" valign=\"top\">Bi-Weekly</th>\n",
       "      <th>AK</th>\n",
       "      <td>1908.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AR</th>\n",
       "      <td>1887.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CA</th>\n",
       "      <td>13515.056842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CO</th>\n",
       "      <td>3500.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC</th>\n",
       "      <td>1968.280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>1730.760000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FL</th>\n",
       "      <td>5510.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GA</th>\n",
       "      <td>90314.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IA</th>\n",
       "      <td>44340.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IL</th>\n",
       "      <td>2219.935000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KS</th>\n",
       "      <td>2223.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA</th>\n",
       "      <td>1550.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MA</th>\n",
       "      <td>2707.465714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MD</th>\n",
       "      <td>2281.147500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MI</th>\n",
       "      <td>32189.925000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MN</th>\n",
       "      <td>750.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <td>700.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <td>2042.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NE</th>\n",
       "      <td>2186.540000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NJ</th>\n",
       "      <td>13107.892857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NY</th>\n",
       "      <td>2226.299412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OH</th>\n",
       "      <td>3144.232500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OR</th>\n",
       "      <td>1577.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PA</th>\n",
       "      <td>3900.380000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PR</th>\n",
       "      <td>1875.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>1918.610000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TX</th>\n",
       "      <td>10650.090000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VA</th>\n",
       "      <td>2173.960000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WV</th>\n",
       "      <td>1608.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hour</th>\n",
       "      <th>AK</th>\n",
       "      <td>29.522439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">Year</th>\n",
       "      <th>MO</th>\n",
       "      <td>79066.134913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MP</th>\n",
       "      <td>51587.975062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <td>86261.249084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <td>96205.545385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <td>608064.435165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ND</th>\n",
       "      <td>145318.493178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NE</th>\n",
       "      <td>84164.387974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NH</th>\n",
       "      <td>75265.179628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NJ</th>\n",
       "      <td>75717.263993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NM</th>\n",
       "      <td>82567.005282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NV</th>\n",
       "      <td>83045.687919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NY</th>\n",
       "      <td>92171.440771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OH</th>\n",
       "      <td>77455.763668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OK</th>\n",
       "      <td>74037.068068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OR</th>\n",
       "      <td>87037.238781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PA</th>\n",
       "      <td>84708.392902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PR</th>\n",
       "      <td>64852.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RI</th>\n",
       "      <td>93182.732192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>72136.310687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>112758.429595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TN</th>\n",
       "      <td>76357.396745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TX</th>\n",
       "      <td>77082.297821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UT</th>\n",
       "      <td>77929.545995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VA</th>\n",
       "      <td>74310.720673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VI</th>\n",
       "      <td>49116.465517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VT</th>\n",
       "      <td>83564.872151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WA</th>\n",
       "      <td>100871.221557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WI</th>\n",
       "      <td>84456.195554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WV</th>\n",
       "      <td>122308.886692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WY</th>\n",
       "      <td>99557.731579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>218 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 LCA_CASE_WAGE_RATE_FROM\n",
       "LCA_CASE_WAGE_RATE_UNIT LCA_CASE_EMPLOYER_STATE                         \n",
       "Bi-Weekly               AK                                   1908.000000\n",
       "                        AR                                   1887.000000\n",
       "                        CA                                  13515.056842\n",
       "                        CO                                   3500.000000\n",
       "                        DC                                   1968.280000\n",
       "                        DE                                   1730.760000\n",
       "                        FL                                   5510.222222\n",
       "                        GA                                  90314.000000\n",
       "                        IA                                  44340.000000\n",
       "                        IL                                   2219.935000\n",
       "                        KS                                   2223.000000\n",
       "                        LA                                   1550.000000\n",
       "                        MA                                   2707.465714\n",
       "                        MD                                   2281.147500\n",
       "                        MI                                  32189.925000\n",
       "                        MN                                    750.000000\n",
       "                        MS                                    700.000000\n",
       "                        NC                                   2042.000000\n",
       "                        NE                                   2186.540000\n",
       "                        NJ                                  13107.892857\n",
       "                        NY                                   2226.299412\n",
       "                        OH                                   3144.232500\n",
       "                        OR                                   1577.000000\n",
       "                        PA                                   3900.380000\n",
       "                        PR                                   1875.000000\n",
       "                        SD                                   1918.610000\n",
       "                        TX                                  10650.090000\n",
       "                        VA                                   2173.960000\n",
       "                        WV                                   1608.800000\n",
       "Hour                    AK                                     29.522439\n",
       "...                                                                  ...\n",
       "Year                    MO                                  79066.134913\n",
       "                        MP                                  51587.975062\n",
       "                        MS                                  86261.249084\n",
       "                        MT                                  96205.545385\n",
       "                        NC                                 608064.435165\n",
       "                        ND                                 145318.493178\n",
       "                        NE                                  84164.387974\n",
       "                        NH                                  75265.179628\n",
       "                        NJ                                  75717.263993\n",
       "                        NM                                  82567.005282\n",
       "                        NV                                  83045.687919\n",
       "                        NY                                  92171.440771\n",
       "                        OH                                  77455.763668\n",
       "                        OK                                  74037.068068\n",
       "                        OR                                  87037.238781\n",
       "                        PA                                  84708.392902\n",
       "                        PR                                  64852.500000\n",
       "                        RI                                  93182.732192\n",
       "                        SC                                  72136.310687\n",
       "                        SD                                 112758.429595\n",
       "                        TN                                  76357.396745\n",
       "                        TX                                  77082.297821\n",
       "                        UT                                  77929.545995\n",
       "                        VA                                  74310.720673\n",
       "                        VI                                  49116.465517\n",
       "                        VT                                  83564.872151\n",
       "                        WA                                 100871.221557\n",
       "                        WI                                  84456.195554\n",
       "                        WV                                 122308.886692\n",
       "                        WY                                  99557.731579\n",
       "\n",
       "[218 rows x 1 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['LCA_CASE_EMPLOYER_STATE', 'LCA_CASE_WAGE_RATE_FROM', 'LCA_CASE_WAGE_RATE_UNIT']].groupby(['LCA_CASE_WAGE_RATE_UNIT', 'LCA_CASE_EMPLOYER_STATE']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LCA_CASE_WAGE_RATE_UNIT</th>\n",
       "      <th>LCA_CASE_WORKLOC1_STATE</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">Bi-Weekly</th>\n",
       "      <th>AK</th>\n",
       "      <td>1908.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AR</th>\n",
       "      <td>1887.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CA</th>\n",
       "      <td>13143.342000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CO</th>\n",
       "      <td>3500.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC</th>\n",
       "      <td>1968.280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>1730.760000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FL</th>\n",
       "      <td>5257.527586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GA</th>\n",
       "      <td>90314.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IA</th>\n",
       "      <td>44340.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IL</th>\n",
       "      <td>2219.935000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KS</th>\n",
       "      <td>2168.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KY</th>\n",
       "      <td>2387.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA</th>\n",
       "      <td>1550.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MA</th>\n",
       "      <td>2707.465714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MD</th>\n",
       "      <td>2281.147500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MI</th>\n",
       "      <td>2353.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MN</th>\n",
       "      <td>750.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <td>700.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <td>2042.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NE</th>\n",
       "      <td>2186.540000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NJ</th>\n",
       "      <td>7112.274615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NY</th>\n",
       "      <td>2326.982500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OH</th>\n",
       "      <td>32515.386000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OR</th>\n",
       "      <td>1577.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PA</th>\n",
       "      <td>1720.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PR</th>\n",
       "      <td>1875.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>1918.610000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TX</th>\n",
       "      <td>10650.090000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VA</th>\n",
       "      <td>2173.960000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WV</th>\n",
       "      <td>1608.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">Year</th>\n",
       "      <th>MO</th>\n",
       "      <td>73891.107284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MP</th>\n",
       "      <td>51378.144337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <td>81648.953002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <td>91292.050455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <td>75784.464707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ND</th>\n",
       "      <td>103128.056832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NE</th>\n",
       "      <td>76717.569907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NH</th>\n",
       "      <td>77320.279605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NJ</th>\n",
       "      <td>75069.312643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NM</th>\n",
       "      <td>86121.862409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NV</th>\n",
       "      <td>77938.556778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NY</th>\n",
       "      <td>90539.073858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OH</th>\n",
       "      <td>74358.586525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OK</th>\n",
       "      <td>73517.532287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OR</th>\n",
       "      <td>81853.423984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PA</th>\n",
       "      <td>476561.497285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PR</th>\n",
       "      <td>67374.794866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RI</th>\n",
       "      <td>78585.326026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>70461.631370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>88609.195636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TN</th>\n",
       "      <td>74411.933185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TX</th>\n",
       "      <td>77054.931243</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UT</th>\n",
       "      <td>73624.968382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VA</th>\n",
       "      <td>129562.286963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VI</th>\n",
       "      <td>52342.993714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VT</th>\n",
       "      <td>78470.859414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WA</th>\n",
       "      <td>93002.670364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WI</th>\n",
       "      <td>76231.011915</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WV</th>\n",
       "      <td>112276.273213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WY</th>\n",
       "      <td>108131.356000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>228 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 LCA_CASE_WAGE_RATE_FROM\n",
       "LCA_CASE_WAGE_RATE_UNIT LCA_CASE_WORKLOC1_STATE                         \n",
       "Bi-Weekly               AK                                   1908.000000\n",
       "                        AR                                   1887.000000\n",
       "                        CA                                  13143.342000\n",
       "                        CO                                   3500.000000\n",
       "                        DC                                   1968.280000\n",
       "                        DE                                   1730.760000\n",
       "                        FL                                   5257.527586\n",
       "                        GA                                  90314.000000\n",
       "                        IA                                  44340.000000\n",
       "                        IL                                   2219.935000\n",
       "                        KS                                   2168.333333\n",
       "                        KY                                   2387.000000\n",
       "                        LA                                   1550.000000\n",
       "                        MA                                   2707.465714\n",
       "                        MD                                   2281.147500\n",
       "                        MI                                   2353.850000\n",
       "                        MN                                    750.000000\n",
       "                        MS                                    700.000000\n",
       "                        NC                                   2042.000000\n",
       "                        NE                                   2186.540000\n",
       "                        NJ                                   7112.274615\n",
       "                        NY                                   2326.982500\n",
       "                        OH                                  32515.386000\n",
       "                        OR                                   1577.000000\n",
       "                        PA                                   1720.000000\n",
       "                        PR                                   1875.000000\n",
       "                        SD                                   1918.610000\n",
       "                        TX                                  10650.090000\n",
       "                        VA                                   2173.960000\n",
       "                        WV                                   1608.800000\n",
       "...                                                                  ...\n",
       "Year                    MO                                  73891.107284\n",
       "                        MP                                  51378.144337\n",
       "                        MS                                  81648.953002\n",
       "                        MT                                  91292.050455\n",
       "                        NC                                  75784.464707\n",
       "                        ND                                 103128.056832\n",
       "                        NE                                  76717.569907\n",
       "                        NH                                  77320.279605\n",
       "                        NJ                                  75069.312643\n",
       "                        NM                                  86121.862409\n",
       "                        NV                                  77938.556778\n",
       "                        NY                                  90539.073858\n",
       "                        OH                                  74358.586525\n",
       "                        OK                                  73517.532287\n",
       "                        OR                                  81853.423984\n",
       "                        PA                                 476561.497285\n",
       "                        PR                                  67374.794866\n",
       "                        RI                                  78585.326026\n",
       "                        SC                                  70461.631370\n",
       "                        SD                                  88609.195636\n",
       "                        TN                                  74411.933185\n",
       "                        TX                                  77054.931243\n",
       "                        UT                                  73624.968382\n",
       "                        VA                                 129562.286963\n",
       "                        VI                                  52342.993714\n",
       "                        VT                                  78470.859414\n",
       "                        WA                                  93002.670364\n",
       "                        WI                                  76231.011915\n",
       "                        WV                                 112276.273213\n",
       "                        WY                                 108131.356000\n",
       "\n",
       "[228 rows x 1 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['LCA_CASE_WORKLOC1_STATE', 'LCA_CASE_WAGE_RATE_FROM', 'LCA_CASE_WAGE_RATE_UNIT']].groupby(['LCA_CASE_WAGE_RATE_UNIT', 'LCA_CASE_WORKLOC1_STATE']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LCA_CASE_EMPLOYER_NAME</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>KING TIGER ACADEMY, INC.</th>\n",
       "      <td>18990.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GOLD MEDAL TAEKWONDO ACADEMY USA, LLC.</th>\n",
       "      <td>20000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROCKY MOUNT PREPARATORY SCHOOL</th>\n",
       "      <td>20000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HIGH POINT CLINICAL TRIALS CENTER, LLC</th>\n",
       "      <td>23650.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WESTCHESTER COUNTRY DAY SCHOOL</th>\n",
       "      <td>23700.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ORB INVESTMENTS, LLC</th>\n",
       "      <td>25000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MONTREAT COLLEGE</th>\n",
       "      <td>25250.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAMPER, HUGS, &amp; LUV'S LEARNING CENTER INC.</th>\n",
       "      <td>25800.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GARDNER-WEBB UNIVERSITY</th>\n",
       "      <td>27166.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PERRY, MORRIS &amp; FLOOD, PLLC</th>\n",
       "      <td>27500.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRILLED GINGER VIETNAMESE RESTAURANT INC.</th>\n",
       "      <td>28000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOMETOWN SPORTS AMERICA, INC.</th>\n",
       "      <td>30000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FLORES &amp; ASSOCIATES, LLC</th>\n",
       "      <td>30000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VIETNAMESE EVANGELICAL CHURCH OF NORTH CAROLINA</th>\n",
       "      <td>30000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SMITHFIELD PREMIUM GENETICS INCORPORATED</th>\n",
       "      <td>30573.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PERSONAL HOME CARE OF NORTH CAROLINA, LLC</th>\n",
       "      <td>31000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BERTIE COUNTY SCHOOLS</th>\n",
       "      <td>31560.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>T AND T COMMUNICATION SERVICES, INC</th>\n",
       "      <td>32000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OBXDND3, LLC</th>\n",
       "      <td>32000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COZYROC LLC</th>\n",
       "      <td>32427.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CASAJOY, INC.</th>\n",
       "      <td>32427.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARKET IN THE BOX, INC.</th>\n",
       "      <td>33000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOUNDS AND COLORS, LLC</th>\n",
       "      <td>33290.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MURPHY-BROWN LLC</th>\n",
       "      <td>33502.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ALPHA ACADEMY</th>\n",
       "      <td>33693.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BREVARD COLLEGE</th>\n",
       "      <td>33833.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INTERNATIONAL MONTESSORI SCHOOL</th>\n",
       "      <td>33870.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RICHMOND COUNTY SCHOOLS</th>\n",
       "      <td>34000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHILDREN'S VILLAGE ACADEMY BOARD OF EDUCATION</th>\n",
       "      <td>34000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VELASQUEZ COMMUNICATIONS CORPORATION</th>\n",
       "      <td>34362.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FAIRCHILD INDUSTRIAL PRODUCTS COMPANY</th>\n",
       "      <td>175000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NORDFAB LLC</th>\n",
       "      <td>175000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BETA RENEWABLES USA INC.</th>\n",
       "      <td>175000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BANK OF AMERICA, NA</th>\n",
       "      <td>175000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOLLY WOLLY DOODLE, INC.</th>\n",
       "      <td>175000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HEALTH DECISIONS INC.</th>\n",
       "      <td>180000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WILLIAMSTON HOSPITAL CORPORATION</th>\n",
       "      <td>185000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MOSES CONE PHYSICIAN SERVICES, INC.</th>\n",
       "      <td>189000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>THE MOSES H. CONE MEMORIAL HOSPITAL OPERATING CORP</th>\n",
       "      <td>189000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LEND LEASE US SERVICES, INC.</th>\n",
       "      <td>190000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CUMBERLAND COUNTY HOSPITAL SYSTEM, INC.</th>\n",
       "      <td>191047.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KINSTON CARDIOLOGY ASSOCIATES PA</th>\n",
       "      <td>192296.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BEROE, INC.</th>\n",
       "      <td>200000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ECP SOUTH CAROLINA PA</th>\n",
       "      <td>200000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONE HEALTH</th>\n",
       "      <td>200000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BON WORTH, INC.</th>\n",
       "      <td>202720.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LAZARD ASSET MANAGEMENT LLC</th>\n",
       "      <td>210000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LENOIR PHYSICIANS NETWORK LLC</th>\n",
       "      <td>211432.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SUNTERRACE CASUAL FURNITURE, INC.</th>\n",
       "      <td>216666.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MING YANG WIND POWER USA, INC</th>\n",
       "      <td>221760.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JOHNSTON MEMORIAL HOSPITAL AUTHORITY</th>\n",
       "      <td>224690.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAROMONT MEDICAL GROUP, INC.</th>\n",
       "      <td>225000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ROWAN DIAGNOSTIC CLINIC, PA</th>\n",
       "      <td>240000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHARLOTTE MECKLENBURGE HOSPITAL AUTHORITY</th>\n",
       "      <td>243263.702000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAPITAL GUARDIAN, LLC</th>\n",
       "      <td>250000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DEEPGREEN RESOURCES LLC</th>\n",
       "      <td>263333.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LITýRA CORP.</th>\n",
       "      <td>300000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMWINS GROUP INC</th>\n",
       "      <td>300000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMSOL PHYSICIANS OF OHIO VALLEY PLLC</th>\n",
       "      <td>371300.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBM CORPORATION</th>\n",
       "      <td>3058483.068213</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1019 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    LCA_CASE_WAGE_RATE_FROM\n",
       "LCA_CASE_EMPLOYER_NAME                                                     \n",
       "KING TIGER ACADEMY, INC.                                       18990.000000\n",
       "GOLD MEDAL TAEKWONDO ACADEMY USA, LLC.                         20000.000000\n",
       "ROCKY MOUNT PREPARATORY SCHOOL                                 20000.000000\n",
       "HIGH POINT CLINICAL TRIALS CENTER, LLC                         23650.000000\n",
       "WESTCHESTER COUNTRY DAY SCHOOL                                 23700.000000\n",
       "ORB INVESTMENTS, LLC                                           25000.000000\n",
       "MONTREAT COLLEGE                                               25250.000000\n",
       "PAMPER, HUGS, & LUV'S LEARNING CENTER INC.                     25800.000000\n",
       "GARDNER-WEBB UNIVERSITY                                        27166.666667\n",
       "PERRY, MORRIS & FLOOD, PLLC                                    27500.000000\n",
       "GRILLED GINGER VIETNAMESE RESTAURANT INC.                      28000.000000\n",
       "HOMETOWN SPORTS AMERICA, INC.                                  30000.000000\n",
       "FLORES & ASSOCIATES, LLC                                       30000.000000\n",
       "VIETNAMESE EVANGELICAL CHURCH OF NORTH CAROLINA                30000.000000\n",
       "SMITHFIELD PREMIUM GENETICS INCORPORATED                       30573.000000\n",
       "PERSONAL HOME CARE OF NORTH CAROLINA, LLC                      31000.000000\n",
       "BERTIE COUNTY SCHOOLS                                          31560.000000\n",
       "T AND T COMMUNICATION SERVICES, INC                            32000.000000\n",
       "OBXDND3, LLC                                                   32000.000000\n",
       "COZYROC LLC                                                    32427.000000\n",
       "CASAJOY, INC.                                                  32427.000000\n",
       "MARKET IN THE BOX, INC.                                        33000.000000\n",
       "SOUNDS AND COLORS, LLC                                         33290.000000\n",
       "MURPHY-BROWN LLC                                               33502.538462\n",
       "ALPHA ACADEMY                                                  33693.333333\n",
       "BREVARD COLLEGE                                                33833.000000\n",
       "INTERNATIONAL MONTESSORI SCHOOL                                33870.000000\n",
       "RICHMOND COUNTY SCHOOLS                                        34000.000000\n",
       "CHILDREN'S VILLAGE ACADEMY BOARD OF EDUCATION                  34000.000000\n",
       "VELASQUEZ COMMUNICATIONS CORPORATION                           34362.000000\n",
       "...                                                                     ...\n",
       "FAIRCHILD INDUSTRIAL PRODUCTS COMPANY                         175000.000000\n",
       "NORDFAB LLC                                                   175000.000000\n",
       "BETA RENEWABLES USA INC.                                      175000.000000\n",
       "BANK OF AMERICA, NA                                           175000.000000\n",
       "LOLLY WOLLY DOODLE, INC.                                      175000.000000\n",
       "HEALTH DECISIONS INC.                                         180000.000000\n",
       "WILLIAMSTON HOSPITAL CORPORATION                              185000.000000\n",
       "MOSES CONE PHYSICIAN SERVICES, INC.                           189000.000000\n",
       "THE MOSES H. CONE MEMORIAL HOSPITAL OPERATING CORP            189000.000000\n",
       "LEND LEASE US SERVICES, INC.                                  190000.000000\n",
       "CUMBERLAND COUNTY HOSPITAL SYSTEM, INC.                       191047.000000\n",
       "KINSTON CARDIOLOGY ASSOCIATES PA                              192296.000000\n",
       "BEROE, INC.                                                   200000.000000\n",
       "ECP SOUTH CAROLINA PA                                         200000.000000\n",
       "CONE HEALTH                                                   200000.000000\n",
       "BON WORTH, INC.                                               202720.000000\n",
       "LAZARD ASSET MANAGEMENT LLC                                   210000.000000\n",
       "LENOIR PHYSICIANS NETWORK LLC                                 211432.000000\n",
       "SUNTERRACE CASUAL FURNITURE, INC.                             216666.666667\n",
       "MING YANG WIND POWER USA, INC                                 221760.000000\n",
       "JOHNSTON MEMORIAL HOSPITAL AUTHORITY                          224690.000000\n",
       "CAROMONT MEDICAL GROUP, INC.                                  225000.000000\n",
       "ROWAN DIAGNOSTIC CLINIC, PA                                   240000.000000\n",
       "CHARLOTTE MECKLENBURGE HOSPITAL AUTHORITY                     243263.702000\n",
       "CAPITAL GUARDIAN, LLC                                         250000.000000\n",
       "DEEPGREEN RESOURCES LLC                                       263333.333333\n",
       "LITýRA CORP.                                                  300000.000000\n",
       "AMWINS GROUP INC                                              300000.000000\n",
       "AMSOL PHYSICIANS OF OHIO VALLEY PLLC                          371300.000000\n",
       "IBM CORPORATION                                              3058483.068213\n",
       "\n",
       "[1019 rows x 1 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_subset = df[(df['LCA_CASE_EMPLOYER_STATE']=='NC')&\n",
    "              (df['LCA_CASE_WAGE_RATE_UNIT']=='Year')]\n",
    "df_subset[['LCA_CASE_WAGE_RATE_FROM', 'LCA_CASE_EMPLOYER_NAME']].groupby('LCA_CASE_EMPLOYER_NAME').mean().sort('LCA_CASE_WAGE_RATE_FROM')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATUS</th>\n",
       "      <th>LCA_CASE_SUBMIT</th>\n",
       "      <th>DECISION_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYMENT_START_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYMENT_END_DATE</th>\n",
       "      <th>LCA_CASE_EMPLOYER_NAME</th>\n",
       "      <th>LCA_CASE_EMPLOYER_CITY</th>\n",
       "      <th>LCA_CASE_EMPLOYER_STATE</th>\n",
       "      <th>LCA_CASE_EMPLOYER_POSTAL_CODE</th>\n",
       "      <th>LCA_CASE_SOC_NAME</th>\n",
       "      <th>LCA_CASE_JOB_TITLE</th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "      <th>LCA_CASE_WAGE_RATE_TO</th>\n",
       "      <th>LCA_CASE_WAGE_RATE_UNIT</th>\n",
       "      <th>FULL_TIME_POS</th>\n",
       "      <th>TOTAL_WORKERS</th>\n",
       "      <th>LCA_CASE_WORKLOC1_CITY</th>\n",
       "      <th>LCA_CASE_WORKLOC1_STATE</th>\n",
       "      <th>DECISION_TIME</th>\n",
       "      <th>DECISION_TIME_DAYS</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10966</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2012-06-25 13:18:51</td>\n",
       "      <td>2014-01-06 15:42:01</td>\n",
       "      <td>2012-06-25</td>\n",
       "      <td>2015-06-24</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.206800e+04</td>\n",
       "      <td>105708.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>EAST PEORIA</td>\n",
       "      <td>IL</td>\n",
       "      <td>560 days 02:23:10</td>\n",
       "      <td>560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94500</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-12-20 11:15:26</td>\n",
       "      <td>2014-09-12 16:37:27</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Occupations, All Other</td>\n",
       "      <td>APPLICATION DEVELOPMENT SPECIALIST</td>\n",
       "      <td>5.237400e+04</td>\n",
       "      <td>76700.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>MI</td>\n",
       "      <td>266 days 05:22:01</td>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91039</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-12-17 14:05:11</td>\n",
       "      <td>2014-02-19 09:59:30</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Occupations, All Other</td>\n",
       "      <td>APPLICATION DEVELOPMENT SPECIALIST</td>\n",
       "      <td>5.237400e+04</td>\n",
       "      <td>76700.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>EAST LANSING</td>\n",
       "      <td>MI</td>\n",
       "      <td>63 days 19:54:19</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73091</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-11-22 11:49:06</td>\n",
       "      <td>2013-12-10 09:17:04</td>\n",
       "      <td>2014-05-22</td>\n",
       "      <td>2017-05-21</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Market Research Analysts and Marketing Special...</td>\n",
       "      <td>SOFTWARE PRODUCT MANAGER</td>\n",
       "      <td>5.430000e+04</td>\n",
       "      <td>110100.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ALLEN</td>\n",
       "      <td>TX</td>\n",
       "      <td>17 days 21:27:58</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84781</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2013-12-10 09:14:53</td>\n",
       "      <td>2013-12-16 11:37:40</td>\n",
       "      <td>2014-06-10</td>\n",
       "      <td>2017-06-09</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Market Research Analysts and Marketing Special...</td>\n",
       "      <td>SOFTWARE PRODUCT MANAGER</td>\n",
       "      <td>5.430000e+04</td>\n",
       "      <td>110100.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ALLEN</td>\n",
       "      <td>TX</td>\n",
       "      <td>6 days 02:22:47</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88985</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2013-12-16 11:37:17</td>\n",
       "      <td>2013-12-20 22:00:35</td>\n",
       "      <td>2014-06-16</td>\n",
       "      <td>2017-06-15</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Market Research Analysts and Marketing Special...</td>\n",
       "      <td>SOFTWARE PRODUCT MANAGER</td>\n",
       "      <td>5.430000e+04</td>\n",
       "      <td>110100.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ALLEN</td>\n",
       "      <td>TX</td>\n",
       "      <td>4 days 10:23:18</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367440</th>\n",
       "      <td>DENIED</td>\n",
       "      <td>2014-05-06 12:38:27</td>\n",
       "      <td>2014-05-08 15:47:26</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>2017-10-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SOFTWARE ENGINEER</td>\n",
       "      <td>5.438400e+04</td>\n",
       "      <td>87012.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>CHANTILLY</td>\n",
       "      <td>VA</td>\n",
       "      <td>2 days 03:08:59</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368484</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2014-05-06 12:20:44</td>\n",
       "      <td>2014-05-06 12:39:10</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>2017-10-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SOFTWARE ENGINEER</td>\n",
       "      <td>5.438400e+04</td>\n",
       "      <td>87012.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>CHANTILLY</td>\n",
       "      <td>VA</td>\n",
       "      <td>0 days 00:18:26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426409</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-07-01 11:42:42</td>\n",
       "      <td>2014-07-08 22:00:19</td>\n",
       "      <td>2014-07-23</td>\n",
       "      <td>2017-07-22</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.490000e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>JOHNSON CITY</td>\n",
       "      <td>TN</td>\n",
       "      <td>7 days 10:17:37</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460827</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-08-05 11:48:43</td>\n",
       "      <td>2014-08-12 22:00:51</td>\n",
       "      <td>2014-08-12</td>\n",
       "      <td>2017-08-11</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.490000e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>BENTONVILLE</td>\n",
       "      <td>AR</td>\n",
       "      <td>7 days 10:12:08</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4010</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2011-08-19 09:03:37</td>\n",
       "      <td>2014-07-07 15:44:37</td>\n",
       "      <td>2011-08-19</td>\n",
       "      <td>2014-08-18</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.506800e+04</td>\n",
       "      <td>111792.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>HOUSTON</td>\n",
       "      <td>TX</td>\n",
       "      <td>1053 days 06:41:00</td>\n",
       "      <td>1053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414048</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-19 10:59:11</td>\n",
       "      <td>2014-06-25 22:00:35</td>\n",
       "      <td>2014-06-26</td>\n",
       "      <td>2017-06-25</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>MANAGING CONSULTANT</td>\n",
       "      <td>5.528600e+04</td>\n",
       "      <td>115000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>JOHNSON CITY</td>\n",
       "      <td>TN</td>\n",
       "      <td>6 days 11:01:24</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422082</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-26 11:42:56</td>\n",
       "      <td>2014-07-02 22:01:11</td>\n",
       "      <td>2014-07-03</td>\n",
       "      <td>2017-07-02</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>ADVISORY IT SPECIALIST</td>\n",
       "      <td>5.595200e+04</td>\n",
       "      <td>99400.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>MOORESVILLE</td>\n",
       "      <td>NC</td>\n",
       "      <td>6 days 10:18:15</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460853</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-08-05 11:43:45</td>\n",
       "      <td>2014-08-12 22:00:51</td>\n",
       "      <td>2014-08-12</td>\n",
       "      <td>2017-08-11</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.636800e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>MAUMEE</td>\n",
       "      <td>OH</td>\n",
       "      <td>7 days 10:17:06</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95224</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2013-12-20 11:18:45</td>\n",
       "      <td>2013-12-27 22:00:30</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>SOFTWARE ENGINEER ASSOCIATE</td>\n",
       "      <td>5.645100e+04</td>\n",
       "      <td>66414.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>LINCOLN</td>\n",
       "      <td>NE</td>\n",
       "      <td>7 days 10:41:45</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90998</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-12-17 12:26:12</td>\n",
       "      <td>2014-02-10 13:12:45</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>SOFTWARE ENGINEER ASSOCIATE</td>\n",
       "      <td>5.645100e+04</td>\n",
       "      <td>66414.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>LINCOLN</td>\n",
       "      <td>NE</td>\n",
       "      <td>55 days 00:46:33</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504514</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-09-19 12:59:48</td>\n",
       "      <td>2014-09-25 22:00:24</td>\n",
       "      <td>2014-09-26</td>\n",
       "      <td>2017-09-25</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.715800e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PORTLAND</td>\n",
       "      <td>ME</td>\n",
       "      <td>6 days 09:00:36</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502799</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-09-17 12:25:54</td>\n",
       "      <td>2014-09-23 22:00:51</td>\n",
       "      <td>2014-10-01</td>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.715800e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PORTLAND</td>\n",
       "      <td>ME</td>\n",
       "      <td>6 days 09:34:57</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494418</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-09-09 11:43:32</td>\n",
       "      <td>2014-09-16 22:00:28</td>\n",
       "      <td>2014-10-01</td>\n",
       "      <td>2017-09-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.715800e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>FREEPORT</td>\n",
       "      <td>ME</td>\n",
       "      <td>7 days 10:16:56</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438933</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-07-15 09:22:05</td>\n",
       "      <td>2014-07-22 22:00:47</td>\n",
       "      <td>2014-07-23</td>\n",
       "      <td>2017-07-22</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>ADVISORY APPLICATION DEVELOPER PROGRAMMER SPEC...</td>\n",
       "      <td>5.757400e+04</td>\n",
       "      <td>106400.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>TALLAHASSEE</td>\n",
       "      <td>FL</td>\n",
       "      <td>7 days 12:38:42</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44085</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2013-10-24 00:33:47</td>\n",
       "      <td>2013-10-24 00:37:33</td>\n",
       "      <td>2013-11-01</td>\n",
       "      <td>2016-10-31</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Occupations, All Other</td>\n",
       "      <td>ASSOCIATE PROJECT MANAGER</td>\n",
       "      <td>5.780000e+04</td>\n",
       "      <td>117300.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>MENOMONEE FALLS</td>\n",
       "      <td>WI</td>\n",
       "      <td>0 days 00:03:46</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329798</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-04-02 11:33:07</td>\n",
       "      <td>2014-04-09 22:02:07</td>\n",
       "      <td>2014-04-10</td>\n",
       "      <td>2017-04-09</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.790700e+04</td>\n",
       "      <td>107800.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>BATON ROUGE</td>\n",
       "      <td>LA</td>\n",
       "      <td>7 days 10:29:00</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326576</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-03-31 10:20:39</td>\n",
       "      <td>2014-04-04 22:01:03</td>\n",
       "      <td>2014-04-08</td>\n",
       "      <td>2017-04-07</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.794900e+04</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>TULSA</td>\n",
       "      <td>OK</td>\n",
       "      <td>4 days 11:40:24</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135545</th>\n",
       "      <td>DENIED</td>\n",
       "      <td>2014-02-04 10:35:00</td>\n",
       "      <td>2014-02-06 13:22:31</td>\n",
       "      <td>2014-07-13</td>\n",
       "      <td>2017-07-12</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.830800e+04</td>\n",
       "      <td>127500.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>DALLAS</td>\n",
       "      <td>TX</td>\n",
       "      <td>2 days 02:47:31</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335290</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2014-04-07 12:44:53</td>\n",
       "      <td>2014-04-08 12:17:53</td>\n",
       "      <td>2014-04-15</td>\n",
       "      <td>2017-04-14</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.873900e+04</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ESSEX JUNCTION</td>\n",
       "      <td>VT</td>\n",
       "      <td>0 days 23:33:00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336655</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-04-08 11:40:15</td>\n",
       "      <td>2014-04-14 22:00:58</td>\n",
       "      <td>2014-04-16</td>\n",
       "      <td>2017-04-15</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.873900e+04</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ESSEX JUNCTION</td>\n",
       "      <td>VT</td>\n",
       "      <td>6 days 10:20:43</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408412</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-13 10:58:27</td>\n",
       "      <td>2014-06-20 21:09:19</td>\n",
       "      <td>2014-06-20</td>\n",
       "      <td>2017-06-19</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.929800e+04</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ASHLAND CITY</td>\n",
       "      <td>TN</td>\n",
       "      <td>7 days 10:10:52</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461178</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-08-05 12:02:33</td>\n",
       "      <td>2014-08-12 22:00:51</td>\n",
       "      <td>2014-08-12</td>\n",
       "      <td>2017-08-11</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR CONSULTANT</td>\n",
       "      <td>5.929800e+04</td>\n",
       "      <td>100714.8</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NASHVILLE</td>\n",
       "      <td>TN</td>\n",
       "      <td>7 days 09:58:18</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423550</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-30 09:48:06</td>\n",
       "      <td>2014-07-07 22:00:53</td>\n",
       "      <td>2014-07-07</td>\n",
       "      <td>2017-07-06</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>ADVISORY APPLICATION DEVELOPER PROGRAMMER SPEC...</td>\n",
       "      <td>5.938400e+04</td>\n",
       "      <td>106400.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>TALLAHASSEE</td>\n",
       "      <td>FL</td>\n",
       "      <td>7 days 12:12:47</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191866</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2014-02-27 14:19:20</td>\n",
       "      <td>2014-09-12 16:30:50</td>\n",
       "      <td>2014-08-27</td>\n",
       "      <td>2017-08-26</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Occupations, All Other</td>\n",
       "      <td>STAFF SOFTWARE ENGINEER</td>\n",
       "      <td>5.953000e+04</td>\n",
       "      <td>100100.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PITTSBURGH</td>\n",
       "      <td>PA</td>\n",
       "      <td>197 days 02:11:30</td>\n",
       "      <td>197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90590</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2013-12-17 09:49:54</td>\n",
       "      <td>2013-12-17 09:51:50</td>\n",
       "      <td>2014-06-02</td>\n",
       "      <td>2017-06-01</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Architectural and Engineering Managers</td>\n",
       "      <td>SENIOR DEVELOPMENT MANAGER</td>\n",
       "      <td>1.611600e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>CA</td>\n",
       "      <td>0 days 00:01:56</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91480</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2013-12-17 09:53:29</td>\n",
       "      <td>2013-12-19 10:25:10</td>\n",
       "      <td>2014-06-02</td>\n",
       "      <td>2017-06-01</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Architectural and Engineering Managers</td>\n",
       "      <td>SENIOR DEVELOPMENT MANAGER</td>\n",
       "      <td>1.611600e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>CA</td>\n",
       "      <td>2 days 00:31:41</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380140</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-05-16 10:52:16</td>\n",
       "      <td>2014-05-22 22:00:52</td>\n",
       "      <td>2014-05-26</td>\n",
       "      <td>2017-05-25</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>MANAGING CONSULTANT</td>\n",
       "      <td>1.615188e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>BRADENTON</td>\n",
       "      <td>FL</td>\n",
       "      <td>6 days 11:08:36</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26697</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2013-09-23 09:00:55</td>\n",
       "      <td>2013-10-22 22:00:50</td>\n",
       "      <td>2014-02-28</td>\n",
       "      <td>2017-02-27</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer and Information Systems Managers</td>\n",
       "      <td>MANAGER, INDUSTRY SOLUTIONS SERVICES ENABLEMENT</td>\n",
       "      <td>1.617640e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>DUBLIN</td>\n",
       "      <td>OH</td>\n",
       "      <td>29 days 12:59:55</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377257</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-05-14 10:24:42</td>\n",
       "      <td>2014-05-20 22:01:05</td>\n",
       "      <td>2014-10-19</td>\n",
       "      <td>2017-10-18</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>1.619500e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ENGLEWOOD CLIFFS</td>\n",
       "      <td>NJ</td>\n",
       "      <td>6 days 11:36:23</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23337</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-08-21 12:20:58</td>\n",
       "      <td>2014-07-07 08:36:24</td>\n",
       "      <td>2014-02-19</td>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.620000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>AURORA</td>\n",
       "      <td>IL</td>\n",
       "      <td>319 days 20:15:26</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23310</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-08-21 12:15:33</td>\n",
       "      <td>2014-07-07 08:35:53</td>\n",
       "      <td>2014-02-19</td>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.620000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>OAKBROOK TERRACE</td>\n",
       "      <td>IL</td>\n",
       "      <td>319 days 20:20:20</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23326</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-08-21 12:02:13</td>\n",
       "      <td>2014-07-07 08:35:28</td>\n",
       "      <td>2014-02-19</td>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.620000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>CHICAGO</td>\n",
       "      <td>IL</td>\n",
       "      <td>319 days 20:33:15</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23344</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-08-21 12:26:41</td>\n",
       "      <td>2014-07-07 08:36:52</td>\n",
       "      <td>2014-02-19</td>\n",
       "      <td>2017-02-18</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.620000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>EAGAN</td>\n",
       "      <td>MN</td>\n",
       "      <td>319 days 20:10:11</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160381</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-02-14 13:31:32</td>\n",
       "      <td>2014-02-21 22:12:52</td>\n",
       "      <td>2014-08-01</td>\n",
       "      <td>2017-07-31</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Operations Research Analysts</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>1.649170e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>ATLANTA</td>\n",
       "      <td>GA</td>\n",
       "      <td>7 days 08:41:20</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516686</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-06 16:15:06</td>\n",
       "      <td>2014-06-12 22:00:57</td>\n",
       "      <td>2014-07-01</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer and Information Systems Managers</td>\n",
       "      <td>PROGRAM DIRECTOR, EMERGING SOLUTIONS</td>\n",
       "      <td>1.660670e+05</td>\n",
       "      <td>313200.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN FRANCISCO</td>\n",
       "      <td>CA</td>\n",
       "      <td>6 days 05:45:51</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54863</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2013-11-01 09:30:58</td>\n",
       "      <td>2013-11-07 22:01:20</td>\n",
       "      <td>2014-03-09</td>\n",
       "      <td>2017-03-08</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>SENIOR MANAGEMENT CONSULTANT</td>\n",
       "      <td>1.700000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>HOUSTON</td>\n",
       "      <td>TX</td>\n",
       "      <td>6 days 12:30:22</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102971</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2014-01-07 09:44:02</td>\n",
       "      <td>2014-09-12 17:21:24</td>\n",
       "      <td>2014-07-07</td>\n",
       "      <td>2017-07-06</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>CONSULT IT SPECIALIST</td>\n",
       "      <td>1.700000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>WALTHAM</td>\n",
       "      <td>MA</td>\n",
       "      <td>248 days 07:37:22</td>\n",
       "      <td>248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517020</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-20 12:15:52</td>\n",
       "      <td>2014-06-26 22:00:44</td>\n",
       "      <td>2014-12-06</td>\n",
       "      <td>2016-12-05</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>NORTH AMERICAN PREDICTIVE ANALYTICS SEGMENT LE...</td>\n",
       "      <td>1.726400e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>WALTHAM</td>\n",
       "      <td>MA</td>\n",
       "      <td>6 days 09:44:52</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433146</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-07-09 13:23:45</td>\n",
       "      <td>2014-07-16 22:00:52</td>\n",
       "      <td>2014-12-17</td>\n",
       "      <td>2017-12-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>1.737280e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PISCATAWAY</td>\n",
       "      <td>NJ</td>\n",
       "      <td>7 days 08:37:07</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103517</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-01-07 10:12:44</td>\n",
       "      <td>2014-01-13 22:00:36</td>\n",
       "      <td>2014-07-07</td>\n",
       "      <td>2017-07-06</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Occupations, All Other</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>1.782560e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>DALLAS</td>\n",
       "      <td>TX</td>\n",
       "      <td>6 days 11:47:52</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39521</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2013-10-21 08:09:58</td>\n",
       "      <td>2013-11-04 22:00:40</td>\n",
       "      <td>2013-10-25</td>\n",
       "      <td>2016-10-24</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RESEARCH TRIANGLE PARK</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>1.782564e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>DALLAS</td>\n",
       "      <td>TX</td>\n",
       "      <td>14 days 13:50:42</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95174</th>\n",
       "      <td>CERTIFIED-WITHDRAWN</td>\n",
       "      <td>2013-12-20 10:45:28</td>\n",
       "      <td>2014-09-12 17:22:05</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>STORAGE USER INTERFACE ARCHITECT</td>\n",
       "      <td>1.850556e+05</td>\n",
       "      <td>205004.4</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>CA</td>\n",
       "      <td>266 days 06:36:37</td>\n",
       "      <td>266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91452</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2013-12-17 12:31:19</td>\n",
       "      <td>2013-12-20 10:48:41</td>\n",
       "      <td>2014-06-17</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>STORAGE USER INTERFACE ARCHITECT</td>\n",
       "      <td>1.850556e+05</td>\n",
       "      <td>205004.4</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>SAN JOSE</td>\n",
       "      <td>CA</td>\n",
       "      <td>2 days 22:17:22</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402684</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-09 11:24:43</td>\n",
       "      <td>2014-06-14 21:09:23</td>\n",
       "      <td>2014-12-08</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.900380e+05</td>\n",
       "      <td>254844.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PISCATAWAY</td>\n",
       "      <td>NJ</td>\n",
       "      <td>5 days 09:44:40</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396149</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-03 13:27:49</td>\n",
       "      <td>2014-06-09 22:01:16</td>\n",
       "      <td>2014-11-12</td>\n",
       "      <td>2017-11-11</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Systems Analysts</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.900380e+05</td>\n",
       "      <td>254844.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PISCATAWAY</td>\n",
       "      <td>NJ</td>\n",
       "      <td>6 days 08:33:27</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518750</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-08-25 11:21:00</td>\n",
       "      <td>2014-08-29 22:01:40</td>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.960000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>COSTA MESA</td>\n",
       "      <td>CA</td>\n",
       "      <td>4 days 10:40:40</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518752</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-08-25 11:25:46</td>\n",
       "      <td>2014-08-29 22:01:40</td>\n",
       "      <td>2015-02-01</td>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>1.960000e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PLEASANTON</td>\n",
       "      <td>CA</td>\n",
       "      <td>4 days 10:35:54</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170161</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-02-19 12:52:33</td>\n",
       "      <td>2014-02-25 22:39:13</td>\n",
       "      <td>2014-02-27</td>\n",
       "      <td>2017-02-26</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Software Developers, Applications</td>\n",
       "      <td>ASSOCIATE PARTNER MGR</td>\n",
       "      <td>1.978716e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>CLERMONT</td>\n",
       "      <td>KY</td>\n",
       "      <td>6 days 09:46:40</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395584</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-02 13:50:03</td>\n",
       "      <td>2014-06-06 22:00:53</td>\n",
       "      <td>2014-07-01</td>\n",
       "      <td>2017-06-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer and Information Systems Managers</td>\n",
       "      <td>PROGRAM DIRECTOR AND MANAGER, VIRTUAL ASSISTANT</td>\n",
       "      <td>1.981788e+05</td>\n",
       "      <td>231990.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>YORKTOWN HEIGHTS</td>\n",
       "      <td>NY</td>\n",
       "      <td>4 days 08:10:50</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516622</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-06-05 14:02:44</td>\n",
       "      <td>2014-06-11 22:00:45</td>\n",
       "      <td>2014-07-01</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer and Information Systems Managers</td>\n",
       "      <td>PROGRAM DIRECTOR AND MANAGER, VIRTUAL ASSISTANT</td>\n",
       "      <td>1.987188e+05</td>\n",
       "      <td>231990.0</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>YORKTOWN HEIGHTS</td>\n",
       "      <td>NY</td>\n",
       "      <td>6 days 07:58:01</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94278</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2013-12-19 10:59:31</td>\n",
       "      <td>2013-12-26 22:00:36</td>\n",
       "      <td>2014-06-20</td>\n",
       "      <td>2017-06-19</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>RTP</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Market Research Analysts and Marketing Special...</td>\n",
       "      <td>ASSOCIATE PARTNER</td>\n",
       "      <td>2.000004e+05</td>\n",
       "      <td>250000.8</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>7 days 11:01:05</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349825</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-04-18 13:09:22</td>\n",
       "      <td>2014-04-25 22:00:53</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>2017-08-27</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>2.003760e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>GARRISON</td>\n",
       "      <td>NY</td>\n",
       "      <td>7 days 08:51:31</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349803</th>\n",
       "      <td>CERTIFIED</td>\n",
       "      <td>2014-04-18 13:05:28</td>\n",
       "      <td>2014-04-25 22:00:53</td>\n",
       "      <td>2014-08-28</td>\n",
       "      <td>2017-08-27</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Management Analysts</td>\n",
       "      <td>SENIOR MANAGING CONSULTANT</td>\n",
       "      <td>2.003760e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NEW YORK</td>\n",
       "      <td>NY</td>\n",
       "      <td>7 days 08:55:25</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498763</th>\n",
       "      <td>WITHDRAWN</td>\n",
       "      <td>2014-09-15 15:43:24</td>\n",
       "      <td>2014-09-16 13:19:33</td>\n",
       "      <td>2015-03-15</td>\n",
       "      <td>2018-03-14</td>\n",
       "      <td>IBM CORPORATION</td>\n",
       "      <td>DURHAM</td>\n",
       "      <td>NC</td>\n",
       "      <td>27709</td>\n",
       "      <td>Computer Programmers</td>\n",
       "      <td>SENIOR SOFTWARE ENGINEER</td>\n",
       "      <td>7.278873e+09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Year</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>PHILADELPHIA</td>\n",
       "      <td>PA</td>\n",
       "      <td>0 days 21:36:09</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2457 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     STATUS     LCA_CASE_SUBMIT       DECISION_DATE  \\\n",
       "10966   CERTIFIED-WITHDRAWN 2012-06-25 13:18:51 2014-01-06 15:42:01   \n",
       "94500   CERTIFIED-WITHDRAWN 2013-12-20 11:15:26 2014-09-12 16:37:27   \n",
       "91039   CERTIFIED-WITHDRAWN 2013-12-17 14:05:11 2014-02-19 09:59:30   \n",
       "73091   CERTIFIED-WITHDRAWN 2013-11-22 11:49:06 2013-12-10 09:17:04   \n",
       "84781             WITHDRAWN 2013-12-10 09:14:53 2013-12-16 11:37:40   \n",
       "88985             CERTIFIED 2013-12-16 11:37:17 2013-12-20 22:00:35   \n",
       "367440               DENIED 2014-05-06 12:38:27 2014-05-08 15:47:26   \n",
       "368484            WITHDRAWN 2014-05-06 12:20:44 2014-05-06 12:39:10   \n",
       "426409            CERTIFIED 2014-07-01 11:42:42 2014-07-08 22:00:19   \n",
       "460827            CERTIFIED 2014-08-05 11:48:43 2014-08-12 22:00:51   \n",
       "4010    CERTIFIED-WITHDRAWN 2011-08-19 09:03:37 2014-07-07 15:44:37   \n",
       "414048            CERTIFIED 2014-06-19 10:59:11 2014-06-25 22:00:35   \n",
       "422082            CERTIFIED 2014-06-26 11:42:56 2014-07-02 22:01:11   \n",
       "460853            CERTIFIED 2014-08-05 11:43:45 2014-08-12 22:00:51   \n",
       "95224             CERTIFIED 2013-12-20 11:18:45 2013-12-27 22:00:30   \n",
       "90998   CERTIFIED-WITHDRAWN 2013-12-17 12:26:12 2014-02-10 13:12:45   \n",
       "504514            CERTIFIED 2014-09-19 12:59:48 2014-09-25 22:00:24   \n",
       "502799            CERTIFIED 2014-09-17 12:25:54 2014-09-23 22:00:51   \n",
       "494418            CERTIFIED 2014-09-09 11:43:32 2014-09-16 22:00:28   \n",
       "438933            CERTIFIED 2014-07-15 09:22:05 2014-07-22 22:00:47   \n",
       "44085             WITHDRAWN 2013-10-24 00:33:47 2013-10-24 00:37:33   \n",
       "329798            CERTIFIED 2014-04-02 11:33:07 2014-04-09 22:02:07   \n",
       "326576            CERTIFIED 2014-03-31 10:20:39 2014-04-04 22:01:03   \n",
       "135545               DENIED 2014-02-04 10:35:00 2014-02-06 13:22:31   \n",
       "335290            WITHDRAWN 2014-04-07 12:44:53 2014-04-08 12:17:53   \n",
       "336655            CERTIFIED 2014-04-08 11:40:15 2014-04-14 22:00:58   \n",
       "408412            CERTIFIED 2014-06-13 10:58:27 2014-06-20 21:09:19   \n",
       "461178            CERTIFIED 2014-08-05 12:02:33 2014-08-12 22:00:51   \n",
       "423550            CERTIFIED 2014-06-30 09:48:06 2014-07-07 22:00:53   \n",
       "191866  CERTIFIED-WITHDRAWN 2014-02-27 14:19:20 2014-09-12 16:30:50   \n",
       "...                     ...                 ...                 ...   \n",
       "90590             WITHDRAWN 2013-12-17 09:49:54 2013-12-17 09:51:50   \n",
       "91480             WITHDRAWN 2013-12-17 09:53:29 2013-12-19 10:25:10   \n",
       "380140            CERTIFIED 2014-05-16 10:52:16 2014-05-22 22:00:52   \n",
       "26697             CERTIFIED 2013-09-23 09:00:55 2013-10-22 22:00:50   \n",
       "377257            CERTIFIED 2014-05-14 10:24:42 2014-05-20 22:01:05   \n",
       "23337   CERTIFIED-WITHDRAWN 2013-08-21 12:20:58 2014-07-07 08:36:24   \n",
       "23310   CERTIFIED-WITHDRAWN 2013-08-21 12:15:33 2014-07-07 08:35:53   \n",
       "23326   CERTIFIED-WITHDRAWN 2013-08-21 12:02:13 2014-07-07 08:35:28   \n",
       "23344   CERTIFIED-WITHDRAWN 2013-08-21 12:26:41 2014-07-07 08:36:52   \n",
       "160381            CERTIFIED 2014-02-14 13:31:32 2014-02-21 22:12:52   \n",
       "516686            CERTIFIED 2014-06-06 16:15:06 2014-06-12 22:00:57   \n",
       "54863             CERTIFIED 2013-11-01 09:30:58 2013-11-07 22:01:20   \n",
       "102971  CERTIFIED-WITHDRAWN 2014-01-07 09:44:02 2014-09-12 17:21:24   \n",
       "517020            CERTIFIED 2014-06-20 12:15:52 2014-06-26 22:00:44   \n",
       "433146            CERTIFIED 2014-07-09 13:23:45 2014-07-16 22:00:52   \n",
       "103517            CERTIFIED 2014-01-07 10:12:44 2014-01-13 22:00:36   \n",
       "39521             CERTIFIED 2013-10-21 08:09:58 2013-11-04 22:00:40   \n",
       "95174   CERTIFIED-WITHDRAWN 2013-12-20 10:45:28 2014-09-12 17:22:05   \n",
       "91452             WITHDRAWN 2013-12-17 12:31:19 2013-12-20 10:48:41   \n",
       "402684            CERTIFIED 2014-06-09 11:24:43 2014-06-14 21:09:23   \n",
       "396149            CERTIFIED 2014-06-03 13:27:49 2014-06-09 22:01:16   \n",
       "518750            CERTIFIED 2014-08-25 11:21:00 2014-08-29 22:01:40   \n",
       "518752            CERTIFIED 2014-08-25 11:25:46 2014-08-29 22:01:40   \n",
       "170161            CERTIFIED 2014-02-19 12:52:33 2014-02-25 22:39:13   \n",
       "395584            CERTIFIED 2014-06-02 13:50:03 2014-06-06 22:00:53   \n",
       "516622            CERTIFIED 2014-06-05 14:02:44 2014-06-11 22:00:45   \n",
       "94278             CERTIFIED 2013-12-19 10:59:31 2013-12-26 22:00:36   \n",
       "349825            CERTIFIED 2014-04-18 13:09:22 2014-04-25 22:00:53   \n",
       "349803            CERTIFIED 2014-04-18 13:05:28 2014-04-25 22:00:53   \n",
       "498763            WITHDRAWN 2014-09-15 15:43:24 2014-09-16 13:19:33   \n",
       "\n",
       "       LCA_CASE_EMPLOYMENT_START_DATE LCA_CASE_EMPLOYMENT_END_DATE  \\\n",
       "10966                      2012-06-25                   2015-06-24   \n",
       "94500                      2014-06-17                   2017-06-16   \n",
       "91039                      2014-06-17                   2017-06-16   \n",
       "73091                      2014-05-22                   2017-05-21   \n",
       "84781                      2014-06-10                   2017-06-09   \n",
       "88985                      2014-06-16                   2017-06-15   \n",
       "367440                     2014-10-31                   2017-10-30   \n",
       "368484                     2014-10-31                   2017-10-30   \n",
       "426409                     2014-07-23                   2017-07-22   \n",
       "460827                     2014-08-12                   2017-08-11   \n",
       "4010                       2011-08-19                   2014-08-18   \n",
       "414048                     2014-06-26                   2017-06-25   \n",
       "422082                     2014-07-03                   2017-07-02   \n",
       "460853                     2014-08-12                   2017-08-11   \n",
       "95224                      2014-06-17                   2017-06-16   \n",
       "90998                      2014-06-17                   2017-06-16   \n",
       "504514                     2014-09-26                   2017-09-25   \n",
       "502799                     2014-10-01                   2017-09-30   \n",
       "494418                     2014-10-01                   2017-09-30   \n",
       "438933                     2014-07-23                   2017-07-22   \n",
       "44085                      2013-11-01                   2016-10-31   \n",
       "329798                     2014-04-10                   2017-04-09   \n",
       "326576                     2014-04-08                   2017-04-07   \n",
       "135545                     2014-07-13                   2017-07-12   \n",
       "335290                     2014-04-15                   2017-04-14   \n",
       "336655                     2014-04-16                   2017-04-15   \n",
       "408412                     2014-06-20                   2017-06-19   \n",
       "461178                     2014-08-12                   2017-08-11   \n",
       "423550                     2014-07-07                   2017-07-06   \n",
       "191866                     2014-08-27                   2017-08-26   \n",
       "...                               ...                          ...   \n",
       "90590                      2014-06-02                   2017-06-01   \n",
       "91480                      2014-06-02                   2017-06-01   \n",
       "380140                     2014-05-26                   2017-05-25   \n",
       "26697                      2014-02-28                   2017-02-27   \n",
       "377257                     2014-10-19                   2017-10-18   \n",
       "23337                      2014-02-19                   2017-02-18   \n",
       "23310                      2014-02-19                   2017-02-18   \n",
       "23326                      2014-02-19                   2017-02-18   \n",
       "23344                      2014-02-19                   2017-02-18   \n",
       "160381                     2014-08-01                   2017-07-31   \n",
       "516686                     2014-07-01                   2016-06-30   \n",
       "54863                      2014-03-09                   2017-03-08   \n",
       "102971                     2014-07-07                   2017-07-06   \n",
       "517020                     2014-12-06                   2016-12-05   \n",
       "433146                     2014-12-17                   2017-12-16   \n",
       "103517                     2014-07-07                   2017-07-06   \n",
       "39521                      2013-10-25                   2016-10-24   \n",
       "95174                      2014-06-17                   2017-06-16   \n",
       "91452                      2014-06-17                   2017-06-16   \n",
       "402684                     2014-12-08                   2017-12-07   \n",
       "396149                     2014-11-12                   2017-11-11   \n",
       "518750                     2015-02-01                   2017-01-31   \n",
       "518752                     2015-02-01                   2017-01-31   \n",
       "170161                     2014-02-27                   2017-02-26   \n",
       "395584                     2014-07-01                   2017-06-30   \n",
       "516622                     2014-07-01                   2016-06-30   \n",
       "94278                      2014-06-20                   2017-06-19   \n",
       "349825                     2014-08-28                   2017-08-27   \n",
       "349803                     2014-08-28                   2017-08-27   \n",
       "498763                     2015-03-15                   2018-03-14   \n",
       "\n",
       "       LCA_CASE_EMPLOYER_NAME  LCA_CASE_EMPLOYER_CITY LCA_CASE_EMPLOYER_STATE  \\\n",
       "10966         IBM CORPORATION                     RTP                      NC   \n",
       "94500         IBM CORPORATION                     RTP                      NC   \n",
       "91039         IBM CORPORATION                     RTP                      NC   \n",
       "73091         IBM CORPORATION                     RTP                      NC   \n",
       "84781         IBM CORPORATION                     RTP                      NC   \n",
       "88985         IBM CORPORATION                     RTP                      NC   \n",
       "367440        IBM CORPORATION                     RTP                      NC   \n",
       "368484        IBM CORPORATION                     RTP                      NC   \n",
       "426409        IBM CORPORATION                  DURHAM                      NC   \n",
       "460827        IBM CORPORATION                  DURHAM                      NC   \n",
       "4010          IBM CORPORATION                     RTP                      NC   \n",
       "414048        IBM CORPORATION                     RTP                      NC   \n",
       "422082        IBM CORPORATION                  DURHAM                      NC   \n",
       "460853        IBM CORPORATION                  DURHAM                      NC   \n",
       "95224         IBM CORPORATION                     RTP                      NC   \n",
       "90998         IBM CORPORATION                     RTP                      NC   \n",
       "504514        IBM CORPORATION                  DURHAM                      NC   \n",
       "502799        IBM CORPORATION                  DURHAM                      NC   \n",
       "494418        IBM CORPORATION                  DURHAM                      NC   \n",
       "438933        IBM CORPORATION                  DURHAM                      NC   \n",
       "44085         IBM CORPORATION                     RTP                      NC   \n",
       "329798        IBM CORPORATION                  DURHAM                      NC   \n",
       "326576        IBM CORPORATION                  DURHAM                      NC   \n",
       "135545        IBM CORPORATION                     RTP                      NC   \n",
       "335290        IBM CORPORATION                  DURHAM                      NC   \n",
       "336655        IBM CORPORATION                  DURHAM                      NC   \n",
       "408412        IBM CORPORATION                     RTP                      NC   \n",
       "461178        IBM CORPORATION                  DURHAM                      NC   \n",
       "423550        IBM CORPORATION                  DURHAM                      NC   \n",
       "191866        IBM CORPORATION                     RTP                      NC   \n",
       "...                       ...                     ...                     ...   \n",
       "90590         IBM CORPORATION                     RTP                      NC   \n",
       "91480         IBM CORPORATION                     RTP                      NC   \n",
       "380140        IBM CORPORATION                  DURHAM                      NC   \n",
       "26697         IBM CORPORATION                     RTP                      NC   \n",
       "377257        IBM CORPORATION                  DURHAM                      NC   \n",
       "23337         IBM CORPORATION                     RTP                      NC   \n",
       "23310         IBM CORPORATION                     RTP                      NC   \n",
       "23326         IBM CORPORATION                     RTP                      NC   \n",
       "23344         IBM CORPORATION                     RTP                      NC   \n",
       "160381        IBM CORPORATION                  DURHAM                      NC   \n",
       "516686        IBM CORPORATION                     RTP                      NC   \n",
       "54863         IBM CORPORATION                     RTP                      NC   \n",
       "102971        IBM CORPORATION                     RTP                      NC   \n",
       "517020        IBM CORPORATION                  DURHAM                      NC   \n",
       "433146        IBM CORPORATION                  DURHAM                      NC   \n",
       "103517        IBM CORPORATION                     RTP                      NC   \n",
       "39521         IBM CORPORATION  RESEARCH TRIANGLE PARK                      NC   \n",
       "95174         IBM CORPORATION                     RTP                      NC   \n",
       "91452         IBM CORPORATION                     RTP                      NC   \n",
       "402684        IBM CORPORATION                  DURHAM                      NC   \n",
       "396149        IBM CORPORATION                  DURHAM                      NC   \n",
       "518750        IBM CORPORATION                  DURHAM                      NC   \n",
       "518752        IBM CORPORATION                  DURHAM                      NC   \n",
       "170161        IBM CORPORATION                     RTP                      NC   \n",
       "395584        IBM CORPORATION                     RTP                      NC   \n",
       "516622        IBM CORPORATION                     RTP                      NC   \n",
       "94278         IBM CORPORATION                     RTP                      NC   \n",
       "349825        IBM CORPORATION                  DURHAM                      NC   \n",
       "349803        IBM CORPORATION                  DURHAM                      NC   \n",
       "498763        IBM CORPORATION                  DURHAM                      NC   \n",
       "\n",
       "       LCA_CASE_EMPLOYER_POSTAL_CODE  \\\n",
       "10966                          27709   \n",
       "94500                          27709   \n",
       "91039                          27709   \n",
       "73091                          27709   \n",
       "84781                          27709   \n",
       "88985                          27709   \n",
       "367440                         27709   \n",
       "368484                         27709   \n",
       "426409                         27709   \n",
       "460827                         27709   \n",
       "4010                           27709   \n",
       "414048                         27709   \n",
       "422082                         27709   \n",
       "460853                         27709   \n",
       "95224                          27709   \n",
       "90998                          27709   \n",
       "504514                         27709   \n",
       "502799                         27709   \n",
       "494418                         27709   \n",
       "438933                         27709   \n",
       "44085                          27709   \n",
       "329798                         27709   \n",
       "326576                         27709   \n",
       "135545                         27709   \n",
       "335290                         27709   \n",
       "336655                         27709   \n",
       "408412                         27709   \n",
       "461178                         27709   \n",
       "423550                         27709   \n",
       "191866                         27709   \n",
       "...                              ...   \n",
       "90590                          27709   \n",
       "91480                          27709   \n",
       "380140                         27709   \n",
       "26697                          27709   \n",
       "377257                         27709   \n",
       "23337                          27709   \n",
       "23310                          27709   \n",
       "23326                          27709   \n",
       "23344                          27709   \n",
       "160381                         27709   \n",
       "516686                         27709   \n",
       "54863                          27709   \n",
       "102971                         27709   \n",
       "517020                         27709   \n",
       "433146                         27709   \n",
       "103517                         27709   \n",
       "39521                          27709   \n",
       "95174                          27709   \n",
       "91452                          27709   \n",
       "402684                         27709   \n",
       "396149                         27709   \n",
       "518750                         27709   \n",
       "518752                         27709   \n",
       "170161                         27709   \n",
       "395584                         27709   \n",
       "516622                         27709   \n",
       "94278                          27709   \n",
       "349825                         27709   \n",
       "349803                         27709   \n",
       "498763                         27709   \n",
       "\n",
       "                                        LCA_CASE_SOC_NAME  \\\n",
       "10966                   Software Developers, Applications   \n",
       "94500                     Computer Occupations, All Other   \n",
       "91039                     Computer Occupations, All Other   \n",
       "73091   Market Research Analysts and Marketing Special...   \n",
       "84781   Market Research Analysts and Marketing Special...   \n",
       "88985   Market Research Analysts and Marketing Special...   \n",
       "367440                          Computer Systems Analysts   \n",
       "368484                          Computer Systems Analysts   \n",
       "426409                          Computer Systems Analysts   \n",
       "460827                                Management Analysts   \n",
       "4010                            Computer Systems Analysts   \n",
       "414048                                Management Analysts   \n",
       "422082                                Management Analysts   \n",
       "460853                  Software Developers, Applications   \n",
       "95224                   Software Developers, Applications   \n",
       "90998                   Software Developers, Applications   \n",
       "504514                                Management Analysts   \n",
       "502799                                Management Analysts   \n",
       "494418                                Management Analysts   \n",
       "438933                  Software Developers, Applications   \n",
       "44085                     Computer Occupations, All Other   \n",
       "329798                          Computer Systems Analysts   \n",
       "326576                          Computer Systems Analysts   \n",
       "135545                          Computer Systems Analysts   \n",
       "335290                                Management Analysts   \n",
       "336655                                Management Analysts   \n",
       "408412                          Computer Systems Analysts   \n",
       "461178                          Computer Systems Analysts   \n",
       "423550                  Software Developers, Applications   \n",
       "191866                    Computer Occupations, All Other   \n",
       "...                                                   ...   \n",
       "90590              Architectural and Engineering Managers   \n",
       "91480              Architectural and Engineering Managers   \n",
       "380140                                Management Analysts   \n",
       "26697           Computer and Information Systems Managers   \n",
       "377257                          Computer Systems Analysts   \n",
       "23337                                 Management Analysts   \n",
       "23310                                 Management Analysts   \n",
       "23326                                 Management Analysts   \n",
       "23344                                 Management Analysts   \n",
       "160381                       Operations Research Analysts   \n",
       "516686          Computer and Information Systems Managers   \n",
       "54863                   Software Developers, Applications   \n",
       "102971                                Management Analysts   \n",
       "517020                                Management Analysts   \n",
       "433146                                Management Analysts   \n",
       "103517                    Computer Occupations, All Other   \n",
       "39521                   Software Developers, Applications   \n",
       "95174                   Software Developers, Applications   \n",
       "91452                   Software Developers, Applications   \n",
       "402684                  Software Developers, Applications   \n",
       "396149                          Computer Systems Analysts   \n",
       "518750                  Software Developers, Applications   \n",
       "518752                  Software Developers, Applications   \n",
       "170161                  Software Developers, Applications   \n",
       "395584          Computer and Information Systems Managers   \n",
       "516622          Computer and Information Systems Managers   \n",
       "94278   Market Research Analysts and Marketing Special...   \n",
       "349825                                Management Analysts   \n",
       "349803                                Management Analysts   \n",
       "498763                               Computer Programmers   \n",
       "\n",
       "                                       LCA_CASE_JOB_TITLE  \\\n",
       "10966                                   SENIOR CONSULTANT   \n",
       "94500                  APPLICATION DEVELOPMENT SPECIALIST   \n",
       "91039                  APPLICATION DEVELOPMENT SPECIALIST   \n",
       "73091                            SOFTWARE PRODUCT MANAGER   \n",
       "84781                            SOFTWARE PRODUCT MANAGER   \n",
       "88985                            SOFTWARE PRODUCT MANAGER   \n",
       "367440                                  SOFTWARE ENGINEER   \n",
       "368484                                  SOFTWARE ENGINEER   \n",
       "426409                                  SENIOR CONSULTANT   \n",
       "460827                                  SENIOR CONSULTANT   \n",
       "4010                                    SENIOR CONSULTANT   \n",
       "414048                                MANAGING CONSULTANT   \n",
       "422082                             ADVISORY IT SPECIALIST   \n",
       "460853                                  SENIOR CONSULTANT   \n",
       "95224                         SOFTWARE ENGINEER ASSOCIATE   \n",
       "90998                         SOFTWARE ENGINEER ASSOCIATE   \n",
       "504514                                  SENIOR CONSULTANT   \n",
       "502799                                  SENIOR CONSULTANT   \n",
       "494418                                  SENIOR CONSULTANT   \n",
       "438933  ADVISORY APPLICATION DEVELOPER PROGRAMMER SPEC...   \n",
       "44085                           ASSOCIATE PROJECT MANAGER   \n",
       "329798                                  SENIOR CONSULTANT   \n",
       "326576                                  SENIOR CONSULTANT   \n",
       "135545                                  SENIOR CONSULTANT   \n",
       "335290                                  SENIOR CONSULTANT   \n",
       "336655                                  SENIOR CONSULTANT   \n",
       "408412                                  SENIOR CONSULTANT   \n",
       "461178                                  SENIOR CONSULTANT   \n",
       "423550  ADVISORY APPLICATION DEVELOPER PROGRAMMER SPEC...   \n",
       "191866                            STAFF SOFTWARE ENGINEER   \n",
       "...                                                   ...   \n",
       "90590                          SENIOR DEVELOPMENT MANAGER   \n",
       "91480                          SENIOR DEVELOPMENT MANAGER   \n",
       "380140                                MANAGING CONSULTANT   \n",
       "26697     MANAGER, INDUSTRY SOLUTIONS SERVICES ENABLEMENT   \n",
       "377257                         SENIOR MANAGING CONSULTANT   \n",
       "23337                                   ASSOCIATE PARTNER   \n",
       "23310                                   ASSOCIATE PARTNER   \n",
       "23326                                   ASSOCIATE PARTNER   \n",
       "23344                                   ASSOCIATE PARTNER   \n",
       "160381                         SENIOR MANAGING CONSULTANT   \n",
       "516686               PROGRAM DIRECTOR, EMERGING SOLUTIONS   \n",
       "54863                        SENIOR MANAGEMENT CONSULTANT   \n",
       "102971                              CONSULT IT SPECIALIST   \n",
       "517020  NORTH AMERICAN PREDICTIVE ANALYTICS SEGMENT LE...   \n",
       "433146                         SENIOR MANAGING CONSULTANT   \n",
       "103517                         SENIOR MANAGING CONSULTANT   \n",
       "39521                          SENIOR MANAGING CONSULTANT   \n",
       "95174                    STORAGE USER INTERFACE ARCHITECT   \n",
       "91452                    STORAGE USER INTERFACE ARCHITECT   \n",
       "402684                                  ASSOCIATE PARTNER   \n",
       "396149                                  ASSOCIATE PARTNER   \n",
       "518750                                  ASSOCIATE PARTNER   \n",
       "518752                                  ASSOCIATE PARTNER   \n",
       "170161                              ASSOCIATE PARTNER MGR   \n",
       "395584    PROGRAM DIRECTOR AND MANAGER, VIRTUAL ASSISTANT   \n",
       "516622    PROGRAM DIRECTOR AND MANAGER, VIRTUAL ASSISTANT   \n",
       "94278                                   ASSOCIATE PARTNER   \n",
       "349825                         SENIOR MANAGING CONSULTANT   \n",
       "349803                         SENIOR MANAGING CONSULTANT   \n",
       "498763                           SENIOR SOFTWARE ENGINEER   \n",
       "\n",
       "        LCA_CASE_WAGE_RATE_FROM  LCA_CASE_WAGE_RATE_TO  \\\n",
       "10966              5.206800e+04               105708.0   \n",
       "94500              5.237400e+04                76700.0   \n",
       "91039              5.237400e+04                76700.0   \n",
       "73091              5.430000e+04               110100.0   \n",
       "84781              5.430000e+04               110100.0   \n",
       "88985              5.430000e+04               110100.0   \n",
       "367440             5.438400e+04                87012.0   \n",
       "368484             5.438400e+04                87012.0   \n",
       "426409             5.490000e+04               114000.0   \n",
       "460827             5.490000e+04               114000.0   \n",
       "4010               5.506800e+04               111792.0   \n",
       "414048             5.528600e+04               115000.0   \n",
       "422082             5.595200e+04                99400.0   \n",
       "460853             5.636800e+04               114000.0   \n",
       "95224              5.645100e+04                66414.0   \n",
       "90998              5.645100e+04                66414.0   \n",
       "504514             5.715800e+04               114000.0   \n",
       "502799             5.715800e+04               114000.0   \n",
       "494418             5.715800e+04               114000.0   \n",
       "438933             5.757400e+04               106400.0   \n",
       "44085              5.780000e+04               117300.0   \n",
       "329798             5.790700e+04               107800.0   \n",
       "326576             5.794900e+04               114000.0   \n",
       "135545             5.830800e+04               127500.0   \n",
       "335290             5.873900e+04               108000.0   \n",
       "336655             5.873900e+04               108000.0   \n",
       "408412             5.929800e+04               100000.0   \n",
       "461178             5.929800e+04               100714.8   \n",
       "423550             5.938400e+04               106400.0   \n",
       "191866             5.953000e+04               100100.0   \n",
       "...                         ...                    ...   \n",
       "90590              1.611600e+05                    NaN   \n",
       "91480              1.611600e+05                    NaN   \n",
       "380140             1.615188e+05                    NaN   \n",
       "26697              1.617640e+05                    NaN   \n",
       "377257             1.619500e+05                    NaN   \n",
       "23337              1.620000e+05                    NaN   \n",
       "23310              1.620000e+05                    NaN   \n",
       "23326              1.620000e+05                    NaN   \n",
       "23344              1.620000e+05                    NaN   \n",
       "160381             1.649170e+05                    NaN   \n",
       "516686             1.660670e+05               313200.0   \n",
       "54863              1.700000e+05                    NaN   \n",
       "102971             1.700000e+05                    NaN   \n",
       "517020             1.726400e+05                    NaN   \n",
       "433146             1.737280e+05                    NaN   \n",
       "103517             1.782560e+05                    NaN   \n",
       "39521              1.782564e+05                    NaN   \n",
       "95174              1.850556e+05               205004.4   \n",
       "91452              1.850556e+05               205004.4   \n",
       "402684             1.900380e+05               254844.0   \n",
       "396149             1.900380e+05               254844.0   \n",
       "518750             1.960000e+05                    NaN   \n",
       "518752             1.960000e+05                    NaN   \n",
       "170161             1.978716e+05                    NaN   \n",
       "395584             1.981788e+05               231990.0   \n",
       "516622             1.987188e+05               231990.0   \n",
       "94278              2.000004e+05               250000.8   \n",
       "349825             2.003760e+05                    NaN   \n",
       "349803             2.003760e+05                    NaN   \n",
       "498763             7.278873e+09                    NaN   \n",
       "\n",
       "       LCA_CASE_WAGE_RATE_UNIT FULL_TIME_POS  TOTAL_WORKERS  \\\n",
       "10966                     Year             Y              1   \n",
       "94500                     Year             Y              1   \n",
       "91039                     Year             Y              1   \n",
       "73091                     Year             Y              1   \n",
       "84781                     Year             Y              1   \n",
       "88985                     Year             Y              1   \n",
       "367440                    Year             Y              1   \n",
       "368484                    Year             Y              1   \n",
       "426409                    Year             Y              1   \n",
       "460827                    Year             Y              1   \n",
       "4010                      Year             Y              1   \n",
       "414048                    Year             Y              1   \n",
       "422082                    Year             Y              1   \n",
       "460853                    Year             Y              1   \n",
       "95224                     Year             Y              1   \n",
       "90998                     Year             Y              1   \n",
       "504514                    Year             Y              1   \n",
       "502799                    Year             Y              1   \n",
       "494418                    Year             Y              1   \n",
       "438933                    Year             Y              1   \n",
       "44085                     Year             Y              1   \n",
       "329798                    Year             Y              1   \n",
       "326576                    Year             Y              1   \n",
       "135545                    Year             Y              1   \n",
       "335290                    Year             Y              1   \n",
       "336655                    Year             Y              1   \n",
       "408412                    Year             Y              1   \n",
       "461178                    Year             Y              1   \n",
       "423550                    Year             Y              1   \n",
       "191866                    Year             Y              1   \n",
       "...                        ...           ...            ...   \n",
       "90590                     Year             Y              1   \n",
       "91480                     Year             Y              1   \n",
       "380140                    Year             Y              1   \n",
       "26697                     Year             Y              1   \n",
       "377257                    Year             Y              1   \n",
       "23337                     Year             Y              1   \n",
       "23310                     Year             Y              1   \n",
       "23326                     Year             Y              1   \n",
       "23344                     Year             Y              1   \n",
       "160381                    Year             Y              1   \n",
       "516686                    Year             Y              1   \n",
       "54863                     Year             Y              1   \n",
       "102971                    Year             Y              1   \n",
       "517020                    Year             Y              1   \n",
       "433146                    Year             Y              1   \n",
       "103517                    Year             Y              1   \n",
       "39521                     Year             Y              1   \n",
       "95174                     Year             Y              1   \n",
       "91452                     Year             Y              1   \n",
       "402684                    Year             Y              1   \n",
       "396149                    Year             Y              1   \n",
       "518750                    Year             Y              1   \n",
       "518752                    Year             Y              1   \n",
       "170161                    Year             Y              1   \n",
       "395584                    Year             Y              1   \n",
       "516622                    Year             Y              1   \n",
       "94278                     Year             Y              1   \n",
       "349825                    Year             Y              1   \n",
       "349803                    Year             Y              1   \n",
       "498763                    Year             Y              1   \n",
       "\n",
       "       LCA_CASE_WORKLOC1_CITY LCA_CASE_WORKLOC1_STATE      DECISION_TIME  \\\n",
       "10966             EAST PEORIA                      IL  560 days 02:23:10   \n",
       "94500            EAST LANSING                      MI  266 days 05:22:01   \n",
       "91039            EAST LANSING                      MI   63 days 19:54:19   \n",
       "73091                   ALLEN                      TX   17 days 21:27:58   \n",
       "84781                   ALLEN                      TX    6 days 02:22:47   \n",
       "88985                   ALLEN                      TX    4 days 10:23:18   \n",
       "367440              CHANTILLY                      VA    2 days 03:08:59   \n",
       "368484              CHANTILLY                      VA    0 days 00:18:26   \n",
       "426409           JOHNSON CITY                      TN    7 days 10:17:37   \n",
       "460827            BENTONVILLE                      AR    7 days 10:12:08   \n",
       "4010                  HOUSTON                      TX 1053 days 06:41:00   \n",
       "414048           JOHNSON CITY                      TN    6 days 11:01:24   \n",
       "422082            MOORESVILLE                      NC    6 days 10:18:15   \n",
       "460853                 MAUMEE                      OH    7 days 10:17:06   \n",
       "95224                 LINCOLN                      NE    7 days 10:41:45   \n",
       "90998                 LINCOLN                      NE   55 days 00:46:33   \n",
       "504514               PORTLAND                      ME    6 days 09:00:36   \n",
       "502799               PORTLAND                      ME    6 days 09:34:57   \n",
       "494418               FREEPORT                      ME    7 days 10:16:56   \n",
       "438933            TALLAHASSEE                      FL    7 days 12:38:42   \n",
       "44085         MENOMONEE FALLS                      WI    0 days 00:03:46   \n",
       "329798            BATON ROUGE                      LA    7 days 10:29:00   \n",
       "326576                  TULSA                      OK    4 days 11:40:24   \n",
       "135545                 DALLAS                      TX    2 days 02:47:31   \n",
       "335290         ESSEX JUNCTION                      VT    0 days 23:33:00   \n",
       "336655         ESSEX JUNCTION                      VT    6 days 10:20:43   \n",
       "408412           ASHLAND CITY                      TN    7 days 10:10:52   \n",
       "461178              NASHVILLE                      TN    7 days 09:58:18   \n",
       "423550            TALLAHASSEE                      FL    7 days 12:12:47   \n",
       "191866             PITTSBURGH                      PA  197 days 02:11:30   \n",
       "...                       ...                     ...                ...   \n",
       "90590                SAN JOSE                      CA    0 days 00:01:56   \n",
       "91480                SAN JOSE                      CA    2 days 00:31:41   \n",
       "380140              BRADENTON                      FL    6 days 11:08:36   \n",
       "26697                  DUBLIN                      OH   29 days 12:59:55   \n",
       "377257       ENGLEWOOD CLIFFS                      NJ    6 days 11:36:23   \n",
       "23337                  AURORA                      IL  319 days 20:15:26   \n",
       "23310        OAKBROOK TERRACE                      IL  319 days 20:20:20   \n",
       "23326                 CHICAGO                      IL  319 days 20:33:15   \n",
       "23344                   EAGAN                      MN  319 days 20:10:11   \n",
       "160381                ATLANTA                      GA    7 days 08:41:20   \n",
       "516686          SAN FRANCISCO                      CA    6 days 05:45:51   \n",
       "54863                 HOUSTON                      TX    6 days 12:30:22   \n",
       "102971                WALTHAM                      MA  248 days 07:37:22   \n",
       "517020                WALTHAM                      MA    6 days 09:44:52   \n",
       "433146             PISCATAWAY                      NJ    7 days 08:37:07   \n",
       "103517                 DALLAS                      TX    6 days 11:47:52   \n",
       "39521                  DALLAS                      TX   14 days 13:50:42   \n",
       "95174                SAN JOSE                      CA  266 days 06:36:37   \n",
       "91452                SAN JOSE                      CA    2 days 22:17:22   \n",
       "402684             PISCATAWAY                      NJ    5 days 09:44:40   \n",
       "396149             PISCATAWAY                      NJ    6 days 08:33:27   \n",
       "518750             COSTA MESA                      CA    4 days 10:40:40   \n",
       "518752             PLEASANTON                      CA    4 days 10:35:54   \n",
       "170161               CLERMONT                      KY    6 days 09:46:40   \n",
       "395584       YORKTOWN HEIGHTS                      NY    4 days 08:10:50   \n",
       "516622       YORKTOWN HEIGHTS                      NY    6 days 07:58:01   \n",
       "94278                NEW YORK                      NY    7 days 11:01:05   \n",
       "349825               GARRISON                      NY    7 days 08:51:31   \n",
       "349803               NEW YORK                      NY    7 days 08:55:25   \n",
       "498763           PHILADELPHIA                      PA    0 days 21:36:09   \n",
       "\n",
       "        DECISION_TIME_DAYS  \n",
       "10966                  560  \n",
       "94500                  266  \n",
       "91039                   63  \n",
       "73091                   17  \n",
       "84781                    6  \n",
       "88985                    4  \n",
       "367440                   2  \n",
       "368484                   0  \n",
       "426409                   7  \n",
       "460827                   7  \n",
       "4010                  1053  \n",
       "414048                   6  \n",
       "422082                   6  \n",
       "460853                   7  \n",
       "95224                    7  \n",
       "90998                   55  \n",
       "504514                   6  \n",
       "502799                   6  \n",
       "494418                   7  \n",
       "438933                   7  \n",
       "44085                    0  \n",
       "329798                   7  \n",
       "326576                   4  \n",
       "135545                   2  \n",
       "335290                   0  \n",
       "336655                   6  \n",
       "408412                   7  \n",
       "461178                   7  \n",
       "423550                   7  \n",
       "191866                 197  \n",
       "...                    ...  \n",
       "90590                    0  \n",
       "91480                    2  \n",
       "380140                   6  \n",
       "26697                   29  \n",
       "377257                   6  \n",
       "23337                  319  \n",
       "23310                  319  \n",
       "23326                  319  \n",
       "23344                  319  \n",
       "160381                   7  \n",
       "516686                   6  \n",
       "54863                    6  \n",
       "102971                 248  \n",
       "517020                   6  \n",
       "433146                   7  \n",
       "103517                   6  \n",
       "39521                   14  \n",
       "95174                  266  \n",
       "91452                    2  \n",
       "402684                   5  \n",
       "396149                   6  \n",
       "518750                   4  \n",
       "518752                   4  \n",
       "170161                   6  \n",
       "395584                   4  \n",
       "516622                   6  \n",
       "94278                    7  \n",
       "349825                   7  \n",
       "349803                   7  \n",
       "498763                   0  \n",
       "\n",
       "[2457 rows x 20 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_subset[df_subset['LCA_CASE_EMPLOYER_NAME']=='IBM CORPORATION'].sort('LCA_CASE_WAGE_RATE_FROM')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LCA_CASE_WAGE_RATE_UNIT</th>\n",
       "      <th>LCA_CASE_WORKLOC1_STATE</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"55\" valign=\"top\">Year</th>\n",
       "      <th>VI</th>\n",
       "      <td>51610.234839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MP</th>\n",
       "      <td>52879.854510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PR</th>\n",
       "      <td>66378.588571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GU</th>\n",
       "      <td>69327.901348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>70818.982988</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HI</th>\n",
       "      <td>73049.261671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UT</th>\n",
       "      <td>73207.688339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OH</th>\n",
       "      <td>73372.443270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AR</th>\n",
       "      <td>73456.074070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GA</th>\n",
       "      <td>73672.408519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MI</th>\n",
       "      <td>73675.795573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <td>74327.791460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AL</th>\n",
       "      <td>74394.829380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OK</th>\n",
       "      <td>74412.406558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MO</th>\n",
       "      <td>74480.112513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IN</th>\n",
       "      <td>74701.514668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FL</th>\n",
       "      <td>74712.038789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NJ</th>\n",
       "      <td>74923.493936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IL</th>\n",
       "      <td>75265.452186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TN</th>\n",
       "      <td>75291.594097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KS</th>\n",
       "      <td>75393.330561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AZ</th>\n",
       "      <td>75900.341521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NC</th>\n",
       "      <td>75914.969074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PA</th>\n",
       "      <td>76240.754459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WI</th>\n",
       "      <td>76394.454216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MN</th>\n",
       "      <td>76494.127840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VA</th>\n",
       "      <td>76566.561367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NE</th>\n",
       "      <td>76603.891522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TX</th>\n",
       "      <td>76817.781264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IA</th>\n",
       "      <td>77172.043985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CO</th>\n",
       "      <td>77707.395566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MD</th>\n",
       "      <td>77786.195960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DE</th>\n",
       "      <td>77861.319792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NH</th>\n",
       "      <td>77990.767319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RI</th>\n",
       "      <td>78138.117006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VT</th>\n",
       "      <td>78262.335866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NV</th>\n",
       "      <td>78896.663581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS</th>\n",
       "      <td>79463.486012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CT</th>\n",
       "      <td>79654.936306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KY</th>\n",
       "      <td>81082.598380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC</th>\n",
       "      <td>81176.647684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OR</th>\n",
       "      <td>81688.140585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LA</th>\n",
       "      <td>82139.524468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MA</th>\n",
       "      <td>82365.015418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MT</th>\n",
       "      <td>84332.472637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NM</th>\n",
       "      <td>84345.020031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AK</th>\n",
       "      <td>88153.325283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SD</th>\n",
       "      <td>89019.039516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NY</th>\n",
       "      <td>89501.226400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WA</th>\n",
       "      <td>93037.534446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ME</th>\n",
       "      <td>94568.322059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CA</th>\n",
       "      <td>94798.088536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ND</th>\n",
       "      <td>105427.271087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WV</th>\n",
       "      <td>116963.891133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WY</th>\n",
       "      <td>127041.167907</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 LCA_CASE_WAGE_RATE_FROM\n",
       "LCA_CASE_WAGE_RATE_UNIT LCA_CASE_WORKLOC1_STATE                         \n",
       "Year                    VI                                  51610.234839\n",
       "                        MP                                  52879.854510\n",
       "                        PR                                  66378.588571\n",
       "                        GU                                  69327.901348\n",
       "                        SC                                  70818.982988\n",
       "                        HI                                  73049.261671\n",
       "                        UT                                  73207.688339\n",
       "                        OH                                  73372.443270\n",
       "                        AR                                  73456.074070\n",
       "                        GA                                  73672.408519\n",
       "                        MI                                  73675.795573\n",
       "                        ID                                  74327.791460\n",
       "                        AL                                  74394.829380\n",
       "                        OK                                  74412.406558\n",
       "                        MO                                  74480.112513\n",
       "                        IN                                  74701.514668\n",
       "                        FL                                  74712.038789\n",
       "                        NJ                                  74923.493936\n",
       "                        IL                                  75265.452186\n",
       "                        TN                                  75291.594097\n",
       "                        KS                                  75393.330561\n",
       "                        AZ                                  75900.341521\n",
       "                        NC                                  75914.969074\n",
       "                        PA                                  76240.754459\n",
       "                        WI                                  76394.454216\n",
       "                        MN                                  76494.127840\n",
       "                        VA                                  76566.561367\n",
       "                        NE                                  76603.891522\n",
       "                        TX                                  76817.781264\n",
       "                        IA                                  77172.043985\n",
       "                        CO                                  77707.395566\n",
       "                        MD                                  77786.195960\n",
       "                        DE                                  77861.319792\n",
       "                        NH                                  77990.767319\n",
       "                        RI                                  78138.117006\n",
       "                        VT                                  78262.335866\n",
       "                        NV                                  78896.663581\n",
       "                        MS                                  79463.486012\n",
       "                        CT                                  79654.936306\n",
       "                        KY                                  81082.598380\n",
       "                        DC                                  81176.647684\n",
       "                        OR                                  81688.140585\n",
       "                        LA                                  82139.524468\n",
       "                        MA                                  82365.015418\n",
       "                        MT                                  84332.472637\n",
       "                        NM                                  84345.020031\n",
       "                        AK                                  88153.325283\n",
       "                        SD                                  89019.039516\n",
       "                        NY                                  89501.226400\n",
       "                        WA                                  93037.534446\n",
       "                        ME                                  94568.322059\n",
       "                        CA                                  94798.088536\n",
       "                        ND                                 105427.271087\n",
       "                        WV                                 116963.891133\n",
       "                        WY                                 127041.167907"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['STATUS']=='CERTIFIED')&(df['LCA_CASE_WAGE_RATE_UNIT']=='Year')][['LCA_CASE_WORKLOC1_STATE', 'LCA_CASE_WAGE_RATE_FROM', 'LCA_CASE_WAGE_RATE_UNIT']].groupby(['LCA_CASE_WAGE_RATE_UNIT', 'LCA_CASE_WORKLOC1_STATE']).mean().sort('LCA_CASE_WAGE_RATE_FROM')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>LCA_CASE_WAGE_RATE_FROM</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LCA_CASE_JOB_TITLE</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>OFFICE ASSOCIATE</th>\n",
       "      <td>29120.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROJECT COORDINATOR</th>\n",
       "      <td>39832.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RESEARCH ASSOCIATE</th>\n",
       "      <td>40000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RESEARCH SCIENTIST</th>\n",
       "      <td>40000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POST DOCTORAL RESEARCHER</th>\n",
       "      <td>40811.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POST DOCTORAL SCIENTIST</th>\n",
       "      <td>42000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POSTDOCTORAL RESEARCHER</th>\n",
       "      <td>42006.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POSTDOCTORAL RESEARCH ASSOCIATE</th>\n",
       "      <td>43000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POST DOCTORAL ASSOCIATE</th>\n",
       "      <td>45000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DUAL IMMERSION KINDERGARTEN TEACHER</th>\n",
       "      <td>48982.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ELECTRICAL ENGINEER - JUNIOR</th>\n",
       "      <td>49234.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROGRAMMER ANALYST</th>\n",
       "      <td>50000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COST ANALYST</th>\n",
       "      <td>50000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>COST ENGINEER (ANALYST)</th>\n",
       "      <td>50000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSISTANT RESEARCH SCIENTIST</th>\n",
       "      <td>51789.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INTERIOR DESIGNER</th>\n",
       "      <td>55000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARKETING MANAGER</th>\n",
       "      <td>56000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SOFTWARE ENGINEER</th>\n",
       "      <td>56000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHEMIST 3</th>\n",
       "      <td>56389.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SYSTEMS PROGRAMMER, SENIOR</th>\n",
       "      <td>58356.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SALES ENGINEER</th>\n",
       "      <td>60000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SERVICE ENGINEER</th>\n",
       "      <td>69300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SERVICE ENGINEER - ELECTRICAL</th>\n",
       "      <td>69300.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SENIOR ELECTRICAL ENGINEER</th>\n",
       "      <td>73070.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NETWORK ENGINEER</th>\n",
       "      <td>73542.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROCESS ENGINEER</th>\n",
       "      <td>79035.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEDICAL IMAGING/LINAC ENGINEER</th>\n",
       "      <td>80080.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RESEARCH AND DEVELOPMENT SCIENTIST</th>\n",
       "      <td>81979.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VALIDATION ENGINEER II</th>\n",
       "      <td>82000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NUTRITION RESEARCH SCIENTIST</th>\n",
       "      <td>82560.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MARKETING DIRECTOR</th>\n",
       "      <td>85000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VISUALIZATION SPECIALIST</th>\n",
       "      <td>85008.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSISTANT PROFESSOR</th>\n",
       "      <td>86643.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE RESEARCH SCIENTIST</th>\n",
       "      <td>87000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>VISITING INSTRUCTOR</th>\n",
       "      <td>90000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PRODUCTION ENGINEER I</th>\n",
       "      <td>96000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROJECT ENGINEER 5</th>\n",
       "      <td>99816.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONSULTANT</th>\n",
       "      <td>106500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOSPICE PROGRAM MANAGER</th>\n",
       "      <td>110000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CHIEF EXECUTIVE OFFICER</th>\n",
       "      <td>120000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SR. FIELD PROFESSIONAL - OPTIMIZATION</th>\n",
       "      <td>129645.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (PEDIATRICIAN)</th>\n",
       "      <td>173500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ASSOCIATE PROFESSOR</th>\n",
       "      <td>180000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (INTERNAL MEDICINE)</th>\n",
       "      <td>190000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PEDIATRICIAN</th>\n",
       "      <td>200000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (INTERNIST)</th>\n",
       "      <td>215000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOSPITALIST</th>\n",
       "      <td>220000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (HOSPITALIST)</th>\n",
       "      <td>220000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PROGRAM COORDINATOR</th>\n",
       "      <td>220008.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (INFECTIOUS DISEASE)</th>\n",
       "      <td>225000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HOSPITALIST PHYSICIAN</th>\n",
       "      <td>235200.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN, ORTHOPEDICS</th>\n",
       "      <td>250000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (NEUROLOGIST)</th>\n",
       "      <td>250000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (NEPHROLOGIST)</th>\n",
       "      <td>250000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HEMATOLOGIST/ONCOLOGIST (PHYSICIAN)</th>\n",
       "      <td>320000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN - CARDIOLOGIST</th>\n",
       "      <td>350000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHYSICIAN (CARDIOLOGIST)</th>\n",
       "      <td>505000.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       LCA_CASE_WAGE_RATE_FROM\n",
       "LCA_CASE_JOB_TITLE                                            \n",
       "OFFICE ASSOCIATE                                      29120.00\n",
       "PROJECT COORDINATOR                                   39832.00\n",
       "RESEARCH ASSOCIATE                                    40000.00\n",
       "RESEARCH SCIENTIST                                    40000.00\n",
       "POST DOCTORAL RESEARCHER                              40811.00\n",
       "POST DOCTORAL SCIENTIST                               42000.00\n",
       "POSTDOCTORAL RESEARCHER                               42006.00\n",
       "POSTDOCTORAL RESEARCH ASSOCIATE                       43000.00\n",
       "POST DOCTORAL ASSOCIATE                               45000.00\n",
       "DUAL IMMERSION KINDERGARTEN TEACHER                   48982.00\n",
       "ELECTRICAL ENGINEER - JUNIOR                          49234.00\n",
       "PROGRAMMER ANALYST                                    50000.00\n",
       "COST ANALYST                                          50000.00\n",
       "COST ENGINEER (ANALYST)                               50000.00\n",
       "ASSISTANT RESEARCH SCIENTIST                          51789.00\n",
       "INTERIOR DESIGNER                                     55000.00\n",
       "MARKETING MANAGER                                     56000.00\n",
       "SOFTWARE ENGINEER                                     56000.00\n",
       "CHEMIST 3                                             56389.00\n",
       "SYSTEMS PROGRAMMER, SENIOR                            58356.00\n",
       "SALES ENGINEER                                        60000.00\n",
       "SERVICE ENGINEER                                      69300.00\n",
       "SERVICE ENGINEER - ELECTRICAL                         69300.14\n",
       "SENIOR ELECTRICAL ENGINEER                            73070.00\n",
       "NETWORK ENGINEER                                      73542.00\n",
       "PROCESS ENGINEER                                      79035.00\n",
       "MEDICAL IMAGING/LINAC ENGINEER                        80080.00\n",
       "RESEARCH AND DEVELOPMENT SCIENTIST                    81979.30\n",
       "VALIDATION ENGINEER II                                82000.00\n",
       "NUTRITION RESEARCH SCIENTIST                          82560.00\n",
       "MARKETING DIRECTOR                                    85000.00\n",
       "VISUALIZATION SPECIALIST                              85008.00\n",
       "ASSISTANT PROFESSOR                                   86643.00\n",
       "ASSOCIATE RESEARCH SCIENTIST                          87000.00\n",
       "VISITING INSTRUCTOR                                   90000.00\n",
       "PRODUCTION ENGINEER I                                 96000.00\n",
       "PROJECT ENGINEER 5                                    99816.00\n",
       "CONSULTANT                                           106500.00\n",
       "HOSPICE PROGRAM MANAGER                              110000.00\n",
       "CHIEF EXECUTIVE OFFICER                              120000.00\n",
       "SR. FIELD PROFESSIONAL - OPTIMIZATION                129645.00\n",
       "PHYSICIAN (PEDIATRICIAN)                             173500.00\n",
       "ASSOCIATE PROFESSOR                                  180000.00\n",
       "PHYSICIAN (INTERNAL MEDICINE)                        190000.00\n",
       "PEDIATRICIAN                                         200000.00\n",
       "PHYSICIAN (INTERNIST)                                215000.00\n",
       "HOSPITALIST                                          220000.00\n",
       "PHYSICIAN (HOSPITALIST)                              220000.00\n",
       "PROGRAM COORDINATOR                                  220008.00\n",
       "PHYSICIAN (INFECTIOUS DISEASE)                       225000.00\n",
       "HOSPITALIST PHYSICIAN                                235200.00\n",
       "PHYSICIAN, ORTHOPEDICS                               250000.00\n",
       "PHYSICIAN (NEUROLOGIST)                              250000.00\n",
       "PHYSICIAN (NEPHROLOGIST)                             250000.00\n",
       "HEMATOLOGIST/ONCOLOGIST (PHYSICIAN)                  320000.00\n",
       "PHYSICIAN - CARDIOLOGIST                             350000.00\n",
       "PHYSICIAN (CARDIOLOGIST)                             505000.00"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_subset = df[(df['STATUS']=='CERTIFIED')& (df['LCA_CASE_WORKLOC1_STATE']=='WY') & (df['LCA_CASE_WAGE_RATE_UNIT']=='Year')]\n",
    "df_subset[['LCA_CASE_JOB_TITLE', 'LCA_CASE_WAGE_RATE_FROM']].groupby('LCA_CASE_JOB_TITLE').mean().sort('LCA_CASE_WAGE_RATE_FROM')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATE</th>\n",
       "      <th>TOTAL_COUNT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AK</td>\n",
       "      <td>246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>1781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AR</td>\n",
       "      <td>2329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AZ</td>\n",
       "      <td>7307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA</td>\n",
       "      <td>98525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO</td>\n",
       "      <td>5811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CT</td>\n",
       "      <td>8917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DC</td>\n",
       "      <td>3727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DE</td>\n",
       "      <td>3184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FL</td>\n",
       "      <td>17644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GA</td>\n",
       "      <td>17729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>GU</td>\n",
       "      <td>263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HI</td>\n",
       "      <td>602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IA</td>\n",
       "      <td>3168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ID</td>\n",
       "      <td>609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IL</td>\n",
       "      <td>27412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>IN</td>\n",
       "      <td>5510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>KS</td>\n",
       "      <td>2424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>KY</td>\n",
       "      <td>2170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>LA</td>\n",
       "      <td>1838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MA</td>\n",
       "      <td>19914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MD</td>\n",
       "      <td>9602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ME</td>\n",
       "      <td>714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MH</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MI</td>\n",
       "      <td>13919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MN</td>\n",
       "      <td>8998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MO</td>\n",
       "      <td>6200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>MP</td>\n",
       "      <td>174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>MS</td>\n",
       "      <td>678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>MT</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>NC</td>\n",
       "      <td>13551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>ND</td>\n",
       "      <td>490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NE</td>\n",
       "      <td>1708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NH</td>\n",
       "      <td>1676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NJ</td>\n",
       "      <td>36783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>NM</td>\n",
       "      <td>908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>NV</td>\n",
       "      <td>1231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>NY</td>\n",
       "      <td>48882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>OH</td>\n",
       "      <td>13515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>OK</td>\n",
       "      <td>1846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>OR</td>\n",
       "      <td>4595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PA</td>\n",
       "      <td>19152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>PR</td>\n",
       "      <td>209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>RI</td>\n",
       "      <td>2225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>SC</td>\n",
       "      <td>2085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>SD</td>\n",
       "      <td>281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>TN</td>\n",
       "      <td>4584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>TX</td>\n",
       "      <td>51851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>UT</td>\n",
       "      <td>2369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>VA</td>\n",
       "      <td>15475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>VI</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>VT</td>\n",
       "      <td>362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>WA</td>\n",
       "      <td>17921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>WI</td>\n",
       "      <td>5530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>WV</td>\n",
       "      <td>431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>WY</td>\n",
       "      <td>170</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE  TOTAL_COUNT\n",
       "0     AK          246\n",
       "1     AL         1781\n",
       "2     AR         2329\n",
       "3     AZ         7307\n",
       "4     CA        98525\n",
       "5     CO         5811\n",
       "6     CT         8917\n",
       "7     DC         3727\n",
       "8     DE         3184\n",
       "9     FL        17644\n",
       "10    GA        17729\n",
       "11    GU          263\n",
       "12    HI          602\n",
       "13    IA         3168\n",
       "14    ID          609\n",
       "15    IL        27412\n",
       "16    IN         5510\n",
       "17    KS         2424\n",
       "18    KY         2170\n",
       "19    LA         1838\n",
       "20    MA        19914\n",
       "21    MD         9602\n",
       "22    ME          714\n",
       "23    MH            1\n",
       "24    MI        13919\n",
       "25    MN         8998\n",
       "26    MO         6200\n",
       "27    MP          174\n",
       "28    MS          678\n",
       "29    MT          134\n",
       "30    NC        13551\n",
       "31    ND          490\n",
       "32    NE         1708\n",
       "33    NH         1676\n",
       "34    NJ        36783\n",
       "35    NM          908\n",
       "36    NV         1231\n",
       "37    NY        48882\n",
       "38    OH        13515\n",
       "39    OK         1846\n",
       "40    OR         4595\n",
       "41    PA        19152\n",
       "42    PR          209\n",
       "43    RI         2225\n",
       "44    SC         2085\n",
       "45    SD          281\n",
       "46    TN         4584\n",
       "47    TX        51851\n",
       "48    UT         2369\n",
       "49    VA        15475\n",
       "50    VI           95\n",
       "51    VT          362\n",
       "52    WA        17921\n",
       "53    WI         5530\n",
       "54    WV          431\n",
       "55    WY          170"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_applications_by_state = df[['STATUS', 'LCA_CASE_WORKLOC1_STATE']].groupby('LCA_CASE_WORKLOC1_STATE').count()\n",
    "total_applications_by_state = total_applications_by_state.reset_index()\n",
    "total_applications_by_state.columns = ['STATE', 'TOTAL_COUNT']\n",
    "total_applications_by_state"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATE</th>\n",
       "      <th>ACCEPTED_COUNT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AK</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>1640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AR</td>\n",
       "      <td>2205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AZ</td>\n",
       "      <td>6930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA</td>\n",
       "      <td>93026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO</td>\n",
       "      <td>5463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CT</td>\n",
       "      <td>8528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DC</td>\n",
       "      <td>3485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DE</td>\n",
       "      <td>3086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FL</td>\n",
       "      <td>16463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GA</td>\n",
       "      <td>16880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>GU</td>\n",
       "      <td>229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HI</td>\n",
       "      <td>537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IA</td>\n",
       "      <td>3033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ID</td>\n",
       "      <td>566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IL</td>\n",
       "      <td>26186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>IN</td>\n",
       "      <td>5220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>KS</td>\n",
       "      <td>2255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>KY</td>\n",
       "      <td>2063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>LA</td>\n",
       "      <td>1693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MA</td>\n",
       "      <td>18816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MD</td>\n",
       "      <td>8955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ME</td>\n",
       "      <td>689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MI</td>\n",
       "      <td>13225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MN</td>\n",
       "      <td>8570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MO</td>\n",
       "      <td>5896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MP</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>MS</td>\n",
       "      <td>612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>MT</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NC</td>\n",
       "      <td>12904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>ND</td>\n",
       "      <td>458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>NE</td>\n",
       "      <td>1609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NH</td>\n",
       "      <td>1608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NJ</td>\n",
       "      <td>35071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NM</td>\n",
       "      <td>821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>NV</td>\n",
       "      <td>1149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>NY</td>\n",
       "      <td>45621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>OH</td>\n",
       "      <td>12877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>OK</td>\n",
       "      <td>1716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>OR</td>\n",
       "      <td>4319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PA</td>\n",
       "      <td>18306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PR</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>RI</td>\n",
       "      <td>2150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>SC</td>\n",
       "      <td>1951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>SD</td>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>TN</td>\n",
       "      <td>4376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>TX</td>\n",
       "      <td>49065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>UT</td>\n",
       "      <td>2215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>VA</td>\n",
       "      <td>14699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>VI</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>VT</td>\n",
       "      <td>333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>WA</td>\n",
       "      <td>17161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>WI</td>\n",
       "      <td>5312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>WV</td>\n",
       "      <td>400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>WY</td>\n",
       "      <td>145</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE  ACCEPTED_COUNT\n",
       "0     AK             230\n",
       "1     AL            1640\n",
       "2     AR            2205\n",
       "3     AZ            6930\n",
       "4     CA           93026\n",
       "5     CO            5463\n",
       "6     CT            8528\n",
       "7     DC            3485\n",
       "8     DE            3086\n",
       "9     FL           16463\n",
       "10    GA           16880\n",
       "11    GU             229\n",
       "12    HI             537\n",
       "13    IA            3033\n",
       "14    ID             566\n",
       "15    IL           26186\n",
       "16    IN            5220\n",
       "17    KS            2255\n",
       "18    KY            2063\n",
       "19    LA            1693\n",
       "20    MA           18816\n",
       "21    MD            8955\n",
       "22    ME             689\n",
       "23    MI           13225\n",
       "24    MN            8570\n",
       "25    MO            5896\n",
       "26    MP              99\n",
       "27    MS             612\n",
       "28    MT             121\n",
       "29    NC           12904\n",
       "30    ND             458\n",
       "31    NE            1609\n",
       "32    NH            1608\n",
       "33    NJ           35071\n",
       "34    NM             821\n",
       "35    NV            1149\n",
       "36    NY           45621\n",
       "37    OH           12877\n",
       "38    OK            1716\n",
       "39    OR            4319\n",
       "40    PA           18306\n",
       "41    PR             176\n",
       "42    RI            2150\n",
       "43    SC            1951\n",
       "44    SD             268\n",
       "45    TN            4376\n",
       "46    TX           49065\n",
       "47    UT            2215\n",
       "48    VA           14699\n",
       "49    VI              83\n",
       "50    VT             333\n",
       "51    WA           17161\n",
       "52    WI            5312\n",
       "53    WV             400\n",
       "54    WY             145"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "accepted_applications_by_state = df[(df['STATUS'] == 'CERTIFIED') | (df['STATUS'] == 'CERTIFIED-WITHDRAWN')][['STATUS', 'LCA_CASE_WORKLOC1_STATE']].groupby('LCA_CASE_WORKLOC1_STATE').count()\n",
    "accepted_applications_by_state = accepted_applications_by_state.reset_index()\n",
    "accepted_applications_by_state.columns = ['STATE', 'ACCEPTED_COUNT']\n",
    "accepted_applications_by_state"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATE</th>\n",
       "      <th>TOTAL_COUNT</th>\n",
       "      <th>ACCEPTED_COUNT</th>\n",
       "      <th>ACCEPTANCE_RATE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AK</td>\n",
       "      <td>246</td>\n",
       "      <td>230</td>\n",
       "      <td>0.934959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>1781</td>\n",
       "      <td>1640</td>\n",
       "      <td>0.920831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AR</td>\n",
       "      <td>2329</td>\n",
       "      <td>2205</td>\n",
       "      <td>0.946758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AZ</td>\n",
       "      <td>7307</td>\n",
       "      <td>6930</td>\n",
       "      <td>0.948406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA</td>\n",
       "      <td>98525</td>\n",
       "      <td>93026</td>\n",
       "      <td>0.944187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CO</td>\n",
       "      <td>5811</td>\n",
       "      <td>5463</td>\n",
       "      <td>0.940114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CT</td>\n",
       "      <td>8917</td>\n",
       "      <td>8528</td>\n",
       "      <td>0.956375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DC</td>\n",
       "      <td>3727</td>\n",
       "      <td>3485</td>\n",
       "      <td>0.935068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DE</td>\n",
       "      <td>3184</td>\n",
       "      <td>3086</td>\n",
       "      <td>0.969221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FL</td>\n",
       "      <td>17644</td>\n",
       "      <td>16463</td>\n",
       "      <td>0.933065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GA</td>\n",
       "      <td>17729</td>\n",
       "      <td>16880</td>\n",
       "      <td>0.952112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>GU</td>\n",
       "      <td>263</td>\n",
       "      <td>229</td>\n",
       "      <td>0.870722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HI</td>\n",
       "      <td>602</td>\n",
       "      <td>537</td>\n",
       "      <td>0.892027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IA</td>\n",
       "      <td>3168</td>\n",
       "      <td>3033</td>\n",
       "      <td>0.957386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ID</td>\n",
       "      <td>609</td>\n",
       "      <td>566</td>\n",
       "      <td>0.929392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IL</td>\n",
       "      <td>27412</td>\n",
       "      <td>26186</td>\n",
       "      <td>0.955275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>IN</td>\n",
       "      <td>5510</td>\n",
       "      <td>5220</td>\n",
       "      <td>0.947368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>KS</td>\n",
       "      <td>2424</td>\n",
       "      <td>2255</td>\n",
       "      <td>0.930281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>KY</td>\n",
       "      <td>2170</td>\n",
       "      <td>2063</td>\n",
       "      <td>0.950691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>LA</td>\n",
       "      <td>1838</td>\n",
       "      <td>1693</td>\n",
       "      <td>0.921110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>MA</td>\n",
       "      <td>19914</td>\n",
       "      <td>18816</td>\n",
       "      <td>0.944863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>MD</td>\n",
       "      <td>9602</td>\n",
       "      <td>8955</td>\n",
       "      <td>0.932618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ME</td>\n",
       "      <td>714</td>\n",
       "      <td>689</td>\n",
       "      <td>0.964986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>MI</td>\n",
       "      <td>13919</td>\n",
       "      <td>13225</td>\n",
       "      <td>0.950140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MN</td>\n",
       "      <td>8998</td>\n",
       "      <td>8570</td>\n",
       "      <td>0.952434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>MO</td>\n",
       "      <td>6200</td>\n",
       "      <td>5896</td>\n",
       "      <td>0.950968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MP</td>\n",
       "      <td>174</td>\n",
       "      <td>99</td>\n",
       "      <td>0.568966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>MS</td>\n",
       "      <td>678</td>\n",
       "      <td>612</td>\n",
       "      <td>0.902655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>MT</td>\n",
       "      <td>134</td>\n",
       "      <td>121</td>\n",
       "      <td>0.902985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>NC</td>\n",
       "      <td>13551</td>\n",
       "      <td>12904</td>\n",
       "      <td>0.952254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>ND</td>\n",
       "      <td>490</td>\n",
       "      <td>458</td>\n",
       "      <td>0.934694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>NE</td>\n",
       "      <td>1708</td>\n",
       "      <td>1609</td>\n",
       "      <td>0.942037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NH</td>\n",
       "      <td>1676</td>\n",
       "      <td>1608</td>\n",
       "      <td>0.959427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>NJ</td>\n",
       "      <td>36783</td>\n",
       "      <td>35071</td>\n",
       "      <td>0.953457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NM</td>\n",
       "      <td>908</td>\n",
       "      <td>821</td>\n",
       "      <td>0.904185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>NV</td>\n",
       "      <td>1231</td>\n",
       "      <td>1149</td>\n",
       "      <td>0.933387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>NY</td>\n",
       "      <td>48882</td>\n",
       "      <td>45621</td>\n",
       "      <td>0.933288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>OH</td>\n",
       "      <td>13515</td>\n",
       "      <td>12877</td>\n",
       "      <td>0.952793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>OK</td>\n",
       "      <td>1846</td>\n",
       "      <td>1716</td>\n",
       "      <td>0.929577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>OR</td>\n",
       "      <td>4595</td>\n",
       "      <td>4319</td>\n",
       "      <td>0.939935</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PA</td>\n",
       "      <td>19152</td>\n",
       "      <td>18306</td>\n",
       "      <td>0.955827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PR</td>\n",
       "      <td>209</td>\n",
       "      <td>176</td>\n",
       "      <td>0.842105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>RI</td>\n",
       "      <td>2225</td>\n",
       "      <td>2150</td>\n",
       "      <td>0.966292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>SC</td>\n",
       "      <td>2085</td>\n",
       "      <td>1951</td>\n",
       "      <td>0.935731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>SD</td>\n",
       "      <td>281</td>\n",
       "      <td>268</td>\n",
       "      <td>0.953737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>TN</td>\n",
       "      <td>4584</td>\n",
       "      <td>4376</td>\n",
       "      <td>0.954625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>TX</td>\n",
       "      <td>51851</td>\n",
       "      <td>49065</td>\n",
       "      <td>0.946269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>UT</td>\n",
       "      <td>2369</td>\n",
       "      <td>2215</td>\n",
       "      <td>0.934994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>VA</td>\n",
       "      <td>15475</td>\n",
       "      <td>14699</td>\n",
       "      <td>0.949855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>VI</td>\n",
       "      <td>95</td>\n",
       "      <td>83</td>\n",
       "      <td>0.873684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>VT</td>\n",
       "      <td>362</td>\n",
       "      <td>333</td>\n",
       "      <td>0.919890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>WA</td>\n",
       "      <td>17921</td>\n",
       "      <td>17161</td>\n",
       "      <td>0.957592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>WI</td>\n",
       "      <td>5530</td>\n",
       "      <td>5312</td>\n",
       "      <td>0.960579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>WV</td>\n",
       "      <td>431</td>\n",
       "      <td>400</td>\n",
       "      <td>0.928074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>WY</td>\n",
       "      <td>170</td>\n",
       "      <td>145</td>\n",
       "      <td>0.852941</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   STATE  TOTAL_COUNT  ACCEPTED_COUNT  ACCEPTANCE_RATE\n",
       "0     AK          246             230         0.934959\n",
       "1     AL         1781            1640         0.920831\n",
       "2     AR         2329            2205         0.946758\n",
       "3     AZ         7307            6930         0.948406\n",
       "4     CA        98525           93026         0.944187\n",
       "5     CO         5811            5463         0.940114\n",
       "6     CT         8917            8528         0.956375\n",
       "7     DC         3727            3485         0.935068\n",
       "8     DE         3184            3086         0.969221\n",
       "9     FL        17644           16463         0.933065\n",
       "10    GA        17729           16880         0.952112\n",
       "11    GU          263             229         0.870722\n",
       "12    HI          602             537         0.892027\n",
       "13    IA         3168            3033         0.957386\n",
       "14    ID          609             566         0.929392\n",
       "15    IL        27412           26186         0.955275\n",
       "16    IN         5510            5220         0.947368\n",
       "17    KS         2424            2255         0.930281\n",
       "18    KY         2170            2063         0.950691\n",
       "19    LA         1838            1693         0.921110\n",
       "20    MA        19914           18816         0.944863\n",
       "21    MD         9602            8955         0.932618\n",
       "22    ME          714             689         0.964986\n",
       "23    MI        13919           13225         0.950140\n",
       "24    MN         8998            8570         0.952434\n",
       "25    MO         6200            5896         0.950968\n",
       "26    MP          174              99         0.568966\n",
       "27    MS          678             612         0.902655\n",
       "28    MT          134             121         0.902985\n",
       "29    NC        13551           12904         0.952254\n",
       "30    ND          490             458         0.934694\n",
       "31    NE         1708            1609         0.942037\n",
       "32    NH         1676            1608         0.959427\n",
       "33    NJ        36783           35071         0.953457\n",
       "34    NM          908             821         0.904185\n",
       "35    NV         1231            1149         0.933387\n",
       "36    NY        48882           45621         0.933288\n",
       "37    OH        13515           12877         0.952793\n",
       "38    OK         1846            1716         0.929577\n",
       "39    OR         4595            4319         0.939935\n",
       "40    PA        19152           18306         0.955827\n",
       "41    PR          209             176         0.842105\n",
       "42    RI         2225            2150         0.966292\n",
       "43    SC         2085            1951         0.935731\n",
       "44    SD          281             268         0.953737\n",
       "45    TN         4584            4376         0.954625\n",
       "46    TX        51851           49065         0.946269\n",
       "47    UT         2369            2215         0.934994\n",
       "48    VA        15475           14699         0.949855\n",
       "49    VI           95              83         0.873684\n",
       "50    VT          362             333         0.919890\n",
       "51    WA        17921           17161         0.957592\n",
       "52    WI         5530            5312         0.960579\n",
       "53    WV          431             400         0.928074\n",
       "54    WY          170             145         0.852941"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merge=pd.merge(left=total_applications_by_state, right=accepted_applications_by_state, how='inner', on='STATE')\n",
    "df_merge['ACCEPTANCE_RATE']=df_merge['ACCEPTED_COUNT']/df_merge['TOTAL_COUNT']\n",
    "df_merge"
   ]
  }
 ],
 "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.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}