Summarizing+Data+Basics.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Summarizing Data Basics\n",
    "\n",
    "In this notebook, we'll use [all-ages.csv](all-ages.csv) and [recent-grads.csv](recent-grads.csv) datasets to do some minor data analysis, mainly summarizing and statistics. The datasets are derived from the 2010-2012 American Community Surveys."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Loading data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Loading the datasets\n",
    "grads = pd.read_csv(\"recent-grads.csv\")\n",
    "ages = pd.read_csv(\"all-ages.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Rank</th>\n",
       "      <th>Major_code</th>\n",
       "      <th>Major</th>\n",
       "      <th>Major_category</th>\n",
       "      <th>Total</th>\n",
       "      <th>Sample_size</th>\n",
       "      <th>Men</th>\n",
       "      <th>Women</th>\n",
       "      <th>ShareWomen</th>\n",
       "      <th>Employed</th>\n",
       "      <th>...</th>\n",
       "      <th>Part_time</th>\n",
       "      <th>Full_time_year_round</th>\n",
       "      <th>Unemployed</th>\n",
       "      <th>Unemployment_rate</th>\n",
       "      <th>Median</th>\n",
       "      <th>P25th</th>\n",
       "      <th>P75th</th>\n",
       "      <th>College_jobs</th>\n",
       "      <th>Non_college_jobs</th>\n",
       "      <th>Low_wage_jobs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2419</td>\n",
       "      <td>PETROLEUM ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>2339</td>\n",
       "      <td>36</td>\n",
       "      <td>2057</td>\n",
       "      <td>282</td>\n",
       "      <td>0.120564</td>\n",
       "      <td>1976</td>\n",
       "      <td>...</td>\n",
       "      <td>270</td>\n",
       "      <td>1207</td>\n",
       "      <td>37</td>\n",
       "      <td>0.018381</td>\n",
       "      <td>110000</td>\n",
       "      <td>95000</td>\n",
       "      <td>125000</td>\n",
       "      <td>1534</td>\n",
       "      <td>364</td>\n",
       "      <td>193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2416</td>\n",
       "      <td>MINING AND MINERAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>756</td>\n",
       "      <td>7</td>\n",
       "      <td>679</td>\n",
       "      <td>77</td>\n",
       "      <td>0.101852</td>\n",
       "      <td>640</td>\n",
       "      <td>...</td>\n",
       "      <td>170</td>\n",
       "      <td>388</td>\n",
       "      <td>85</td>\n",
       "      <td>0.117241</td>\n",
       "      <td>75000</td>\n",
       "      <td>55000</td>\n",
       "      <td>90000</td>\n",
       "      <td>350</td>\n",
       "      <td>257</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>2415</td>\n",
       "      <td>METALLURGICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>856</td>\n",
       "      <td>3</td>\n",
       "      <td>725</td>\n",
       "      <td>131</td>\n",
       "      <td>0.153037</td>\n",
       "      <td>648</td>\n",
       "      <td>...</td>\n",
       "      <td>133</td>\n",
       "      <td>340</td>\n",
       "      <td>16</td>\n",
       "      <td>0.024096</td>\n",
       "      <td>73000</td>\n",
       "      <td>50000</td>\n",
       "      <td>105000</td>\n",
       "      <td>456</td>\n",
       "      <td>176</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>2417</td>\n",
       "      <td>NAVAL ARCHITECTURE AND MARINE ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>1258</td>\n",
       "      <td>16</td>\n",
       "      <td>1123</td>\n",
       "      <td>135</td>\n",
       "      <td>0.107313</td>\n",
       "      <td>758</td>\n",
       "      <td>...</td>\n",
       "      <td>150</td>\n",
       "      <td>692</td>\n",
       "      <td>40</td>\n",
       "      <td>0.050125</td>\n",
       "      <td>70000</td>\n",
       "      <td>43000</td>\n",
       "      <td>80000</td>\n",
       "      <td>529</td>\n",
       "      <td>102</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>2405</td>\n",
       "      <td>CHEMICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>32260</td>\n",
       "      <td>289</td>\n",
       "      <td>21239</td>\n",
       "      <td>11021</td>\n",
       "      <td>0.341631</td>\n",
       "      <td>25694</td>\n",
       "      <td>...</td>\n",
       "      <td>5180</td>\n",
       "      <td>16697</td>\n",
       "      <td>1672</td>\n",
       "      <td>0.061098</td>\n",
       "      <td>65000</td>\n",
       "      <td>50000</td>\n",
       "      <td>75000</td>\n",
       "      <td>18314</td>\n",
       "      <td>4440</td>\n",
       "      <td>972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>2418</td>\n",
       "      <td>NUCLEAR ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>2573</td>\n",
       "      <td>17</td>\n",
       "      <td>2200</td>\n",
       "      <td>373</td>\n",
       "      <td>0.144967</td>\n",
       "      <td>1857</td>\n",
       "      <td>...</td>\n",
       "      <td>264</td>\n",
       "      <td>1449</td>\n",
       "      <td>400</td>\n",
       "      <td>0.177226</td>\n",
       "      <td>65000</td>\n",
       "      <td>50000</td>\n",
       "      <td>102000</td>\n",
       "      <td>1142</td>\n",
       "      <td>657</td>\n",
       "      <td>244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>6202</td>\n",
       "      <td>ACTUARIAL SCIENCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>3777</td>\n",
       "      <td>51</td>\n",
       "      <td>832</td>\n",
       "      <td>960</td>\n",
       "      <td>0.535714</td>\n",
       "      <td>2912</td>\n",
       "      <td>...</td>\n",
       "      <td>296</td>\n",
       "      <td>2482</td>\n",
       "      <td>308</td>\n",
       "      <td>0.095652</td>\n",
       "      <td>62000</td>\n",
       "      <td>53000</td>\n",
       "      <td>72000</td>\n",
       "      <td>1768</td>\n",
       "      <td>314</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>5001</td>\n",
       "      <td>ASTRONOMY AND ASTROPHYSICS</td>\n",
       "      <td>Physical Sciences</td>\n",
       "      <td>1792</td>\n",
       "      <td>10</td>\n",
       "      <td>2110</td>\n",
       "      <td>1667</td>\n",
       "      <td>0.441356</td>\n",
       "      <td>1526</td>\n",
       "      <td>...</td>\n",
       "      <td>553</td>\n",
       "      <td>827</td>\n",
       "      <td>33</td>\n",
       "      <td>0.021167</td>\n",
       "      <td>62000</td>\n",
       "      <td>31500</td>\n",
       "      <td>109000</td>\n",
       "      <td>972</td>\n",
       "      <td>500</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>2414</td>\n",
       "      <td>MECHANICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>91227</td>\n",
       "      <td>1029</td>\n",
       "      <td>12953</td>\n",
       "      <td>2105</td>\n",
       "      <td>0.139793</td>\n",
       "      <td>76442</td>\n",
       "      <td>...</td>\n",
       "      <td>13101</td>\n",
       "      <td>54639</td>\n",
       "      <td>4650</td>\n",
       "      <td>0.057342</td>\n",
       "      <td>60000</td>\n",
       "      <td>48000</td>\n",
       "      <td>70000</td>\n",
       "      <td>52844</td>\n",
       "      <td>16384</td>\n",
       "      <td>3253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>2408</td>\n",
       "      <td>ELECTRICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>81527</td>\n",
       "      <td>631</td>\n",
       "      <td>8407</td>\n",
       "      <td>6548</td>\n",
       "      <td>0.437847</td>\n",
       "      <td>61928</td>\n",
       "      <td>...</td>\n",
       "      <td>12695</td>\n",
       "      <td>41413</td>\n",
       "      <td>3895</td>\n",
       "      <td>0.059174</td>\n",
       "      <td>60000</td>\n",
       "      <td>45000</td>\n",
       "      <td>72000</td>\n",
       "      <td>45829</td>\n",
       "      <td>10874</td>\n",
       "      <td>3170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>2407</td>\n",
       "      <td>COMPUTER ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>41542</td>\n",
       "      <td>399</td>\n",
       "      <td>33258</td>\n",
       "      <td>8284</td>\n",
       "      <td>0.199413</td>\n",
       "      <td>32506</td>\n",
       "      <td>...</td>\n",
       "      <td>5146</td>\n",
       "      <td>23621</td>\n",
       "      <td>2275</td>\n",
       "      <td>0.065409</td>\n",
       "      <td>60000</td>\n",
       "      <td>45000</td>\n",
       "      <td>75000</td>\n",
       "      <td>23694</td>\n",
       "      <td>5721</td>\n",
       "      <td>980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>2401</td>\n",
       "      <td>AEROSPACE ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>15058</td>\n",
       "      <td>147</td>\n",
       "      <td>65511</td>\n",
       "      <td>16016</td>\n",
       "      <td>0.196450</td>\n",
       "      <td>11391</td>\n",
       "      <td>...</td>\n",
       "      <td>2724</td>\n",
       "      <td>8790</td>\n",
       "      <td>794</td>\n",
       "      <td>0.065162</td>\n",
       "      <td>60000</td>\n",
       "      <td>42000</td>\n",
       "      <td>70000</td>\n",
       "      <td>8184</td>\n",
       "      <td>2425</td>\n",
       "      <td>372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>2404</td>\n",
       "      <td>BIOMEDICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>14955</td>\n",
       "      <td>79</td>\n",
       "      <td>80320</td>\n",
       "      <td>10907</td>\n",
       "      <td>0.119559</td>\n",
       "      <td>10047</td>\n",
       "      <td>...</td>\n",
       "      <td>2694</td>\n",
       "      <td>5986</td>\n",
       "      <td>1019</td>\n",
       "      <td>0.092084</td>\n",
       "      <td>60000</td>\n",
       "      <td>36000</td>\n",
       "      <td>70000</td>\n",
       "      <td>6439</td>\n",
       "      <td>2471</td>\n",
       "      <td>789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>5008</td>\n",
       "      <td>MATERIALS SCIENCE</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>4279</td>\n",
       "      <td>22</td>\n",
       "      <td>2949</td>\n",
       "      <td>1330</td>\n",
       "      <td>0.310820</td>\n",
       "      <td>3307</td>\n",
       "      <td>...</td>\n",
       "      <td>878</td>\n",
       "      <td>1967</td>\n",
       "      <td>78</td>\n",
       "      <td>0.023043</td>\n",
       "      <td>60000</td>\n",
       "      <td>39000</td>\n",
       "      <td>65000</td>\n",
       "      <td>2626</td>\n",
       "      <td>391</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>2409</td>\n",
       "      <td>ENGINEERING MECHANICS PHYSICS AND SCIENCE</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>4321</td>\n",
       "      <td>30</td>\n",
       "      <td>3526</td>\n",
       "      <td>795</td>\n",
       "      <td>0.183985</td>\n",
       "      <td>3608</td>\n",
       "      <td>...</td>\n",
       "      <td>811</td>\n",
       "      <td>2004</td>\n",
       "      <td>23</td>\n",
       "      <td>0.006334</td>\n",
       "      <td>58000</td>\n",
       "      <td>25000</td>\n",
       "      <td>74000</td>\n",
       "      <td>2439</td>\n",
       "      <td>947</td>\n",
       "      <td>263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>2402</td>\n",
       "      <td>BIOLOGICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>8925</td>\n",
       "      <td>55</td>\n",
       "      <td>6062</td>\n",
       "      <td>2863</td>\n",
       "      <td>0.320784</td>\n",
       "      <td>6170</td>\n",
       "      <td>...</td>\n",
       "      <td>1983</td>\n",
       "      <td>3413</td>\n",
       "      <td>589</td>\n",
       "      <td>0.087143</td>\n",
       "      <td>57100</td>\n",
       "      <td>40000</td>\n",
       "      <td>76000</td>\n",
       "      <td>3603</td>\n",
       "      <td>1595</td>\n",
       "      <td>524</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>2412</td>\n",
       "      <td>INDUSTRIAL AND MANUFACTURING ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>18968</td>\n",
       "      <td>183</td>\n",
       "      <td>12453</td>\n",
       "      <td>6515</td>\n",
       "      <td>0.343473</td>\n",
       "      <td>15604</td>\n",
       "      <td>...</td>\n",
       "      <td>2243</td>\n",
       "      <td>11326</td>\n",
       "      <td>699</td>\n",
       "      <td>0.042876</td>\n",
       "      <td>57000</td>\n",
       "      <td>37900</td>\n",
       "      <td>67000</td>\n",
       "      <td>8306</td>\n",
       "      <td>3235</td>\n",
       "      <td>640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>2400</td>\n",
       "      <td>GENERAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>61152</td>\n",
       "      <td>425</td>\n",
       "      <td>45683</td>\n",
       "      <td>15469</td>\n",
       "      <td>0.252960</td>\n",
       "      <td>44931</td>\n",
       "      <td>...</td>\n",
       "      <td>7199</td>\n",
       "      <td>33540</td>\n",
       "      <td>2859</td>\n",
       "      <td>0.059824</td>\n",
       "      <td>56000</td>\n",
       "      <td>36000</td>\n",
       "      <td>69000</td>\n",
       "      <td>26898</td>\n",
       "      <td>11734</td>\n",
       "      <td>3192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>2403</td>\n",
       "      <td>ARCHITECTURAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>2825</td>\n",
       "      <td>26</td>\n",
       "      <td>1835</td>\n",
       "      <td>990</td>\n",
       "      <td>0.350442</td>\n",
       "      <td>2575</td>\n",
       "      <td>...</td>\n",
       "      <td>343</td>\n",
       "      <td>1848</td>\n",
       "      <td>170</td>\n",
       "      <td>0.061931</td>\n",
       "      <td>54000</td>\n",
       "      <td>38000</td>\n",
       "      <td>65000</td>\n",
       "      <td>1665</td>\n",
       "      <td>649</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>3201</td>\n",
       "      <td>COURT REPORTING</td>\n",
       "      <td>Law &amp; Public Policy</td>\n",
       "      <td>1148</td>\n",
       "      <td>14</td>\n",
       "      <td>877</td>\n",
       "      <td>271</td>\n",
       "      <td>0.236063</td>\n",
       "      <td>930</td>\n",
       "      <td>...</td>\n",
       "      <td>223</td>\n",
       "      <td>808</td>\n",
       "      <td>11</td>\n",
       "      <td>0.011690</td>\n",
       "      <td>54000</td>\n",
       "      <td>50000</td>\n",
       "      <td>54000</td>\n",
       "      <td>402</td>\n",
       "      <td>528</td>\n",
       "      <td>144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>2102</td>\n",
       "      <td>COMPUTER SCIENCE</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>128319</td>\n",
       "      <td>1196</td>\n",
       "      <td>1837</td>\n",
       "      <td>2524</td>\n",
       "      <td>0.578766</td>\n",
       "      <td>102087</td>\n",
       "      <td>...</td>\n",
       "      <td>18726</td>\n",
       "      <td>70932</td>\n",
       "      <td>6884</td>\n",
       "      <td>0.063173</td>\n",
       "      <td>53000</td>\n",
       "      <td>39000</td>\n",
       "      <td>70000</td>\n",
       "      <td>68622</td>\n",
       "      <td>25667</td>\n",
       "      <td>5144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>1104</td>\n",
       "      <td>FOOD SCIENCE</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>4361</td>\n",
       "      <td>36</td>\n",
       "      <td>99743</td>\n",
       "      <td>28576</td>\n",
       "      <td>0.222695</td>\n",
       "      <td>3149</td>\n",
       "      <td>...</td>\n",
       "      <td>1121</td>\n",
       "      <td>1735</td>\n",
       "      <td>338</td>\n",
       "      <td>0.096931</td>\n",
       "      <td>53000</td>\n",
       "      <td>32000</td>\n",
       "      <td>70000</td>\n",
       "      <td>1183</td>\n",
       "      <td>1274</td>\n",
       "      <td>485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>2502</td>\n",
       "      <td>ELECTRICAL ENGINEERING TECHNOLOGY</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>11565</td>\n",
       "      <td>97</td>\n",
       "      <td>2020</td>\n",
       "      <td>973</td>\n",
       "      <td>0.325092</td>\n",
       "      <td>8587</td>\n",
       "      <td>...</td>\n",
       "      <td>1873</td>\n",
       "      <td>5681</td>\n",
       "      <td>824</td>\n",
       "      <td>0.087557</td>\n",
       "      <td>52000</td>\n",
       "      <td>35000</td>\n",
       "      <td>60000</td>\n",
       "      <td>5126</td>\n",
       "      <td>2686</td>\n",
       "      <td>696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>2413</td>\n",
       "      <td>MATERIALS ENGINEERING AND MATERIALS SCIENCE</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>2993</td>\n",
       "      <td>22</td>\n",
       "      <td>8181</td>\n",
       "      <td>3384</td>\n",
       "      <td>0.292607</td>\n",
       "      <td>2449</td>\n",
       "      <td>...</td>\n",
       "      <td>1040</td>\n",
       "      <td>1151</td>\n",
       "      <td>70</td>\n",
       "      <td>0.027789</td>\n",
       "      <td>52000</td>\n",
       "      <td>35000</td>\n",
       "      <td>62000</td>\n",
       "      <td>1911</td>\n",
       "      <td>305</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>6212</td>\n",
       "      <td>MANAGEMENT INFORMATION SYSTEMS AND STATISTICS</td>\n",
       "      <td>Business</td>\n",
       "      <td>18713</td>\n",
       "      <td>278</td>\n",
       "      <td>13496</td>\n",
       "      <td>5217</td>\n",
       "      <td>0.278790</td>\n",
       "      <td>16413</td>\n",
       "      <td>...</td>\n",
       "      <td>2420</td>\n",
       "      <td>13017</td>\n",
       "      <td>1015</td>\n",
       "      <td>0.058240</td>\n",
       "      <td>51000</td>\n",
       "      <td>38000</td>\n",
       "      <td>60000</td>\n",
       "      <td>6342</td>\n",
       "      <td>5741</td>\n",
       "      <td>708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>2406</td>\n",
       "      <td>CIVIL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>53153</td>\n",
       "      <td>565</td>\n",
       "      <td>41081</td>\n",
       "      <td>12072</td>\n",
       "      <td>0.227118</td>\n",
       "      <td>43041</td>\n",
       "      <td>...</td>\n",
       "      <td>10080</td>\n",
       "      <td>29196</td>\n",
       "      <td>3270</td>\n",
       "      <td>0.070610</td>\n",
       "      <td>50000</td>\n",
       "      <td>40000</td>\n",
       "      <td>60000</td>\n",
       "      <td>28526</td>\n",
       "      <td>9356</td>\n",
       "      <td>2899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>5601</td>\n",
       "      <td>CONSTRUCTION SERVICES</td>\n",
       "      <td>Industrial Arts &amp; Consumer Services</td>\n",
       "      <td>18498</td>\n",
       "      <td>295</td>\n",
       "      <td>2662</td>\n",
       "      <td>1385</td>\n",
       "      <td>0.342229</td>\n",
       "      <td>16318</td>\n",
       "      <td>...</td>\n",
       "      <td>1751</td>\n",
       "      <td>12313</td>\n",
       "      <td>1042</td>\n",
       "      <td>0.060023</td>\n",
       "      <td>50000</td>\n",
       "      <td>36000</td>\n",
       "      <td>60000</td>\n",
       "      <td>3275</td>\n",
       "      <td>5351</td>\n",
       "      <td>703</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>6204</td>\n",
       "      <td>OPERATIONS LOGISTICS AND E-COMMERCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>11732</td>\n",
       "      <td>156</td>\n",
       "      <td>488</td>\n",
       "      <td>232</td>\n",
       "      <td>0.322222</td>\n",
       "      <td>10027</td>\n",
       "      <td>...</td>\n",
       "      <td>1183</td>\n",
       "      <td>7724</td>\n",
       "      <td>504</td>\n",
       "      <td>0.047859</td>\n",
       "      <td>50000</td>\n",
       "      <td>40000</td>\n",
       "      <td>60000</td>\n",
       "      <td>1466</td>\n",
       "      <td>3629</td>\n",
       "      <td>285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>2499</td>\n",
       "      <td>MISCELLANEOUS ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>9133</td>\n",
       "      <td>118</td>\n",
       "      <td>7398</td>\n",
       "      <td>1735</td>\n",
       "      <td>0.189970</td>\n",
       "      <td>7428</td>\n",
       "      <td>...</td>\n",
       "      <td>1662</td>\n",
       "      <td>5476</td>\n",
       "      <td>597</td>\n",
       "      <td>0.074393</td>\n",
       "      <td>50000</td>\n",
       "      <td>39000</td>\n",
       "      <td>65000</td>\n",
       "      <td>3445</td>\n",
       "      <td>2426</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>5402</td>\n",
       "      <td>PUBLIC POLICY</td>\n",
       "      <td>Law &amp; Public Policy</td>\n",
       "      <td>5978</td>\n",
       "      <td>55</td>\n",
       "      <td>2695</td>\n",
       "      <td>905</td>\n",
       "      <td>0.251389</td>\n",
       "      <td>4547</td>\n",
       "      <td>...</td>\n",
       "      <td>1306</td>\n",
       "      <td>2776</td>\n",
       "      <td>670</td>\n",
       "      <td>0.128426</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>70000</td>\n",
       "      <td>1550</td>\n",
       "      <td>1871</td>\n",
       "      <td>340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>1105</td>\n",
       "      <td>PLANT SCIENCE AND AGRONOMY</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>7416</td>\n",
       "      <td>110</td>\n",
       "      <td>5079</td>\n",
       "      <td>7841</td>\n",
       "      <td>0.606889</td>\n",
       "      <td>6594</td>\n",
       "      <td>...</td>\n",
       "      <td>1246</td>\n",
       "      <td>4522</td>\n",
       "      <td>314</td>\n",
       "      <td>0.045455</td>\n",
       "      <td>32000</td>\n",
       "      <td>22900</td>\n",
       "      <td>40000</td>\n",
       "      <td>2089</td>\n",
       "      <td>3545</td>\n",
       "      <td>1231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>145</td>\n",
       "      <td>2308</td>\n",
       "      <td>SCIENCE AND COMPUTER TEACHER EDUCATION</td>\n",
       "      <td>Education</td>\n",
       "      <td>6483</td>\n",
       "      <td>59</td>\n",
       "      <td>22357</td>\n",
       "      <td>16404</td>\n",
       "      <td>0.423209</td>\n",
       "      <td>5362</td>\n",
       "      <td>...</td>\n",
       "      <td>1227</td>\n",
       "      <td>3247</td>\n",
       "      <td>266</td>\n",
       "      <td>0.047264</td>\n",
       "      <td>32000</td>\n",
       "      <td>28000</td>\n",
       "      <td>39000</td>\n",
       "      <td>4214</td>\n",
       "      <td>1106</td>\n",
       "      <td>591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>146</td>\n",
       "      <td>5200</td>\n",
       "      <td>PSYCHOLOGY</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>393735</td>\n",
       "      <td>2584</td>\n",
       "      <td>86648</td>\n",
       "      <td>307087</td>\n",
       "      <td>0.779933</td>\n",
       "      <td>307933</td>\n",
       "      <td>...</td>\n",
       "      <td>115172</td>\n",
       "      <td>174438</td>\n",
       "      <td>28169</td>\n",
       "      <td>0.083811</td>\n",
       "      <td>31500</td>\n",
       "      <td>24000</td>\n",
       "      <td>41000</td>\n",
       "      <td>125148</td>\n",
       "      <td>141860</td>\n",
       "      <td>48207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>147</td>\n",
       "      <td>6002</td>\n",
       "      <td>MUSIC</td>\n",
       "      <td>Arts</td>\n",
       "      <td>60633</td>\n",
       "      <td>419</td>\n",
       "      <td>15670</td>\n",
       "      <td>12543</td>\n",
       "      <td>0.444582</td>\n",
       "      <td>47662</td>\n",
       "      <td>...</td>\n",
       "      <td>24943</td>\n",
       "      <td>21425</td>\n",
       "      <td>3918</td>\n",
       "      <td>0.075960</td>\n",
       "      <td>31000</td>\n",
       "      <td>22300</td>\n",
       "      <td>42000</td>\n",
       "      <td>13752</td>\n",
       "      <td>28786</td>\n",
       "      <td>9286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>148</td>\n",
       "      <td>2306</td>\n",
       "      <td>PHYSICAL AND HEALTH EDUCATION TEACHING</td>\n",
       "      <td>Education</td>\n",
       "      <td>28213</td>\n",
       "      <td>259</td>\n",
       "      <td>29909</td>\n",
       "      <td>30724</td>\n",
       "      <td>0.506721</td>\n",
       "      <td>23794</td>\n",
       "      <td>...</td>\n",
       "      <td>7230</td>\n",
       "      <td>13651</td>\n",
       "      <td>1920</td>\n",
       "      <td>0.074667</td>\n",
       "      <td>31000</td>\n",
       "      <td>24000</td>\n",
       "      <td>40000</td>\n",
       "      <td>12777</td>\n",
       "      <td>9328</td>\n",
       "      <td>2042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>149</td>\n",
       "      <td>6006</td>\n",
       "      <td>ART HISTORY AND CRITICISM</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>21030</td>\n",
       "      <td>204</td>\n",
       "      <td>3240</td>\n",
       "      <td>17790</td>\n",
       "      <td>0.845934</td>\n",
       "      <td>17579</td>\n",
       "      <td>...</td>\n",
       "      <td>6140</td>\n",
       "      <td>9965</td>\n",
       "      <td>1128</td>\n",
       "      <td>0.060298</td>\n",
       "      <td>31000</td>\n",
       "      <td>23000</td>\n",
       "      <td>40000</td>\n",
       "      <td>5139</td>\n",
       "      <td>9738</td>\n",
       "      <td>3426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>150</td>\n",
       "      <td>6000</td>\n",
       "      <td>FINE ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>74440</td>\n",
       "      <td>623</td>\n",
       "      <td>24786</td>\n",
       "      <td>49654</td>\n",
       "      <td>0.667034</td>\n",
       "      <td>59679</td>\n",
       "      <td>...</td>\n",
       "      <td>23656</td>\n",
       "      <td>31877</td>\n",
       "      <td>5486</td>\n",
       "      <td>0.084186</td>\n",
       "      <td>30500</td>\n",
       "      <td>21000</td>\n",
       "      <td>41000</td>\n",
       "      <td>20792</td>\n",
       "      <td>32725</td>\n",
       "      <td>11880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>151</td>\n",
       "      <td>2901</td>\n",
       "      <td>FAMILY AND CONSUMER SCIENCES</td>\n",
       "      <td>Industrial Arts &amp; Consumer Services</td>\n",
       "      <td>58001</td>\n",
       "      <td>518</td>\n",
       "      <td>5347</td>\n",
       "      <td>16226</td>\n",
       "      <td>0.752144</td>\n",
       "      <td>46624</td>\n",
       "      <td>...</td>\n",
       "      <td>15872</td>\n",
       "      <td>26906</td>\n",
       "      <td>3355</td>\n",
       "      <td>0.067128</td>\n",
       "      <td>30000</td>\n",
       "      <td>22900</td>\n",
       "      <td>40000</td>\n",
       "      <td>20985</td>\n",
       "      <td>20133</td>\n",
       "      <td>5248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>152</td>\n",
       "      <td>5404</td>\n",
       "      <td>SOCIAL WORK</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>53552</td>\n",
       "      <td>374</td>\n",
       "      <td>2734</td>\n",
       "      <td>11709</td>\n",
       "      <td>0.810704</td>\n",
       "      <td>45038</td>\n",
       "      <td>...</td>\n",
       "      <td>13481</td>\n",
       "      <td>27588</td>\n",
       "      <td>3329</td>\n",
       "      <td>0.068828</td>\n",
       "      <td>30000</td>\n",
       "      <td>25000</td>\n",
       "      <td>35000</td>\n",
       "      <td>27449</td>\n",
       "      <td>14416</td>\n",
       "      <td>4344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>153</td>\n",
       "      <td>1103</td>\n",
       "      <td>ANIMAL SCIENCES</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>21573</td>\n",
       "      <td>255</td>\n",
       "      <td>5166</td>\n",
       "      <td>52835</td>\n",
       "      <td>0.910933</td>\n",
       "      <td>17112</td>\n",
       "      <td>...</td>\n",
       "      <td>5353</td>\n",
       "      <td>10824</td>\n",
       "      <td>917</td>\n",
       "      <td>0.050862</td>\n",
       "      <td>30000</td>\n",
       "      <td>22000</td>\n",
       "      <td>40000</td>\n",
       "      <td>5443</td>\n",
       "      <td>9571</td>\n",
       "      <td>2125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>154</td>\n",
       "      <td>6003</td>\n",
       "      <td>VISUAL AND PERFORMING ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>16250</td>\n",
       "      <td>132</td>\n",
       "      <td>2013</td>\n",
       "      <td>4639</td>\n",
       "      <td>0.697384</td>\n",
       "      <td>12870</td>\n",
       "      <td>...</td>\n",
       "      <td>6253</td>\n",
       "      <td>6322</td>\n",
       "      <td>1465</td>\n",
       "      <td>0.102197</td>\n",
       "      <td>30000</td>\n",
       "      <td>22000</td>\n",
       "      <td>40000</td>\n",
       "      <td>3849</td>\n",
       "      <td>7635</td>\n",
       "      <td>2840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>155</td>\n",
       "      <td>2312</td>\n",
       "      <td>TEACHER EDUCATION: MULTIPLE LEVELS</td>\n",
       "      <td>Education</td>\n",
       "      <td>14443</td>\n",
       "      <td>142</td>\n",
       "      <td>1936</td>\n",
       "      <td>7692</td>\n",
       "      <td>0.798920</td>\n",
       "      <td>13076</td>\n",
       "      <td>...</td>\n",
       "      <td>2214</td>\n",
       "      <td>8457</td>\n",
       "      <td>496</td>\n",
       "      <td>0.036546</td>\n",
       "      <td>30000</td>\n",
       "      <td>24000</td>\n",
       "      <td>37000</td>\n",
       "      <td>10766</td>\n",
       "      <td>1949</td>\n",
       "      <td>722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>156</td>\n",
       "      <td>5299</td>\n",
       "      <td>MISCELLANEOUS PSYCHOLOGY</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>9628</td>\n",
       "      <td>60</td>\n",
       "      <td>885</td>\n",
       "      <td>8489</td>\n",
       "      <td>0.905590</td>\n",
       "      <td>7653</td>\n",
       "      <td>...</td>\n",
       "      <td>3221</td>\n",
       "      <td>3838</td>\n",
       "      <td>419</td>\n",
       "      <td>0.051908</td>\n",
       "      <td>30000</td>\n",
       "      <td>20800</td>\n",
       "      <td>40000</td>\n",
       "      <td>2960</td>\n",
       "      <td>3948</td>\n",
       "      <td>1650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>157</td>\n",
       "      <td>5403</td>\n",
       "      <td>HUMAN SERVICES AND COMMUNITY ORGANIZATION</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>9374</td>\n",
       "      <td>89</td>\n",
       "      <td>5137</td>\n",
       "      <td>48415</td>\n",
       "      <td>0.904075</td>\n",
       "      <td>8294</td>\n",
       "      <td>...</td>\n",
       "      <td>2405</td>\n",
       "      <td>5061</td>\n",
       "      <td>326</td>\n",
       "      <td>0.037819</td>\n",
       "      <td>30000</td>\n",
       "      <td>24000</td>\n",
       "      <td>35000</td>\n",
       "      <td>2878</td>\n",
       "      <td>4595</td>\n",
       "      <td>724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>158</td>\n",
       "      <td>3402</td>\n",
       "      <td>HUMANITIES</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>6652</td>\n",
       "      <td>49</td>\n",
       "      <td>4133</td>\n",
       "      <td>12117</td>\n",
       "      <td>0.745662</td>\n",
       "      <td>5052</td>\n",
       "      <td>...</td>\n",
       "      <td>2225</td>\n",
       "      <td>2661</td>\n",
       "      <td>372</td>\n",
       "      <td>0.068584</td>\n",
       "      <td>30000</td>\n",
       "      <td>20000</td>\n",
       "      <td>49000</td>\n",
       "      <td>1168</td>\n",
       "      <td>3354</td>\n",
       "      <td>1141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>159</td>\n",
       "      <td>4901</td>\n",
       "      <td>THEOLOGY AND RELIGIOUS VOCATIONS</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>30207</td>\n",
       "      <td>310</td>\n",
       "      <td>404</td>\n",
       "      <td>1084</td>\n",
       "      <td>0.728495</td>\n",
       "      <td>24202</td>\n",
       "      <td>...</td>\n",
       "      <td>8767</td>\n",
       "      <td>13944</td>\n",
       "      <td>1617</td>\n",
       "      <td>0.062628</td>\n",
       "      <td>29000</td>\n",
       "      <td>22000</td>\n",
       "      <td>38000</td>\n",
       "      <td>9927</td>\n",
       "      <td>12037</td>\n",
       "      <td>3304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>160</td>\n",
       "      <td>6007</td>\n",
       "      <td>STUDIO ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>16977</td>\n",
       "      <td>182</td>\n",
       "      <td>4364</td>\n",
       "      <td>6146</td>\n",
       "      <td>0.584776</td>\n",
       "      <td>13908</td>\n",
       "      <td>...</td>\n",
       "      <td>5673</td>\n",
       "      <td>7413</td>\n",
       "      <td>1368</td>\n",
       "      <td>0.089552</td>\n",
       "      <td>29000</td>\n",
       "      <td>19200</td>\n",
       "      <td>38300</td>\n",
       "      <td>3948</td>\n",
       "      <td>8707</td>\n",
       "      <td>3586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>161</td>\n",
       "      <td>2201</td>\n",
       "      <td>COSMETOLOGY SERVICES AND CULINARY ARTS</td>\n",
       "      <td>Industrial Arts &amp; Consumer Services</td>\n",
       "      <td>10510</td>\n",
       "      <td>117</td>\n",
       "      <td>18616</td>\n",
       "      <td>11591</td>\n",
       "      <td>0.383719</td>\n",
       "      <td>8650</td>\n",
       "      <td>...</td>\n",
       "      <td>2064</td>\n",
       "      <td>5949</td>\n",
       "      <td>510</td>\n",
       "      <td>0.055677</td>\n",
       "      <td>29000</td>\n",
       "      <td>20000</td>\n",
       "      <td>36000</td>\n",
       "      <td>563</td>\n",
       "      <td>7384</td>\n",
       "      <td>3163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>162</td>\n",
       "      <td>1199</td>\n",
       "      <td>MISCELLANEOUS AGRICULTURE</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>1488</td>\n",
       "      <td>24</td>\n",
       "      <td>4754</td>\n",
       "      <td>12223</td>\n",
       "      <td>0.719974</td>\n",
       "      <td>1290</td>\n",
       "      <td>...</td>\n",
       "      <td>335</td>\n",
       "      <td>936</td>\n",
       "      <td>82</td>\n",
       "      <td>0.059767</td>\n",
       "      <td>29000</td>\n",
       "      <td>23000</td>\n",
       "      <td>42100</td>\n",
       "      <td>483</td>\n",
       "      <td>626</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>163</td>\n",
       "      <td>5502</td>\n",
       "      <td>ANTHROPOLOGY AND ARCHEOLOGY</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>38844</td>\n",
       "      <td>247</td>\n",
       "      <td>1167</td>\n",
       "      <td>36422</td>\n",
       "      <td>0.968954</td>\n",
       "      <td>29633</td>\n",
       "      <td>...</td>\n",
       "      <td>14515</td>\n",
       "      <td>13232</td>\n",
       "      <td>3395</td>\n",
       "      <td>0.102792</td>\n",
       "      <td>28000</td>\n",
       "      <td>20000</td>\n",
       "      <td>38000</td>\n",
       "      <td>9805</td>\n",
       "      <td>16693</td>\n",
       "      <td>6866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>164</td>\n",
       "      <td>6102</td>\n",
       "      <td>COMMUNICATION DISORDERS SCIENCES AND SERVICES</td>\n",
       "      <td>Health</td>\n",
       "      <td>38279</td>\n",
       "      <td>95</td>\n",
       "      <td>11376</td>\n",
       "      <td>27468</td>\n",
       "      <td>0.707136</td>\n",
       "      <td>29763</td>\n",
       "      <td>...</td>\n",
       "      <td>13862</td>\n",
       "      <td>14460</td>\n",
       "      <td>1487</td>\n",
       "      <td>0.047584</td>\n",
       "      <td>28000</td>\n",
       "      <td>20000</td>\n",
       "      <td>40000</td>\n",
       "      <td>19957</td>\n",
       "      <td>9404</td>\n",
       "      <td>5125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>165</td>\n",
       "      <td>2307</td>\n",
       "      <td>EARLY CHILDHOOD EDUCATION</td>\n",
       "      <td>Education</td>\n",
       "      <td>37589</td>\n",
       "      <td>342</td>\n",
       "      <td>1225</td>\n",
       "      <td>37054</td>\n",
       "      <td>0.967998</td>\n",
       "      <td>32551</td>\n",
       "      <td>...</td>\n",
       "      <td>7001</td>\n",
       "      <td>20748</td>\n",
       "      <td>1360</td>\n",
       "      <td>0.040105</td>\n",
       "      <td>28000</td>\n",
       "      <td>21000</td>\n",
       "      <td>35000</td>\n",
       "      <td>23515</td>\n",
       "      <td>7705</td>\n",
       "      <td>2868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>166</td>\n",
       "      <td>2603</td>\n",
       "      <td>OTHER FOREIGN LANGUAGES</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>11204</td>\n",
       "      <td>56</td>\n",
       "      <td>3472</td>\n",
       "      <td>7732</td>\n",
       "      <td>0.690111</td>\n",
       "      <td>7052</td>\n",
       "      <td>...</td>\n",
       "      <td>3685</td>\n",
       "      <td>3214</td>\n",
       "      <td>846</td>\n",
       "      <td>0.107116</td>\n",
       "      <td>27500</td>\n",
       "      <td>22900</td>\n",
       "      <td>38000</td>\n",
       "      <td>2326</td>\n",
       "      <td>3703</td>\n",
       "      <td>1115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>167</td>\n",
       "      <td>6001</td>\n",
       "      <td>DRAMA AND THEATER ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>43249</td>\n",
       "      <td>357</td>\n",
       "      <td>7022</td>\n",
       "      <td>11931</td>\n",
       "      <td>0.629505</td>\n",
       "      <td>36165</td>\n",
       "      <td>...</td>\n",
       "      <td>15994</td>\n",
       "      <td>16891</td>\n",
       "      <td>3040</td>\n",
       "      <td>0.077541</td>\n",
       "      <td>27000</td>\n",
       "      <td>19200</td>\n",
       "      <td>35000</td>\n",
       "      <td>6994</td>\n",
       "      <td>25313</td>\n",
       "      <td>11068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>168</td>\n",
       "      <td>3302</td>\n",
       "      <td>COMPOSITION AND RHETORIC</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>18953</td>\n",
       "      <td>151</td>\n",
       "      <td>14440</td>\n",
       "      <td>28809</td>\n",
       "      <td>0.666119</td>\n",
       "      <td>15053</td>\n",
       "      <td>...</td>\n",
       "      <td>6612</td>\n",
       "      <td>7832</td>\n",
       "      <td>1340</td>\n",
       "      <td>0.081742</td>\n",
       "      <td>27000</td>\n",
       "      <td>20000</td>\n",
       "      <td>35000</td>\n",
       "      <td>4855</td>\n",
       "      <td>8100</td>\n",
       "      <td>3466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>169</td>\n",
       "      <td>3609</td>\n",
       "      <td>ZOOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>8409</td>\n",
       "      <td>47</td>\n",
       "      <td>3050</td>\n",
       "      <td>5359</td>\n",
       "      <td>0.637293</td>\n",
       "      <td>6259</td>\n",
       "      <td>...</td>\n",
       "      <td>2190</td>\n",
       "      <td>3602</td>\n",
       "      <td>304</td>\n",
       "      <td>0.046320</td>\n",
       "      <td>26000</td>\n",
       "      <td>20000</td>\n",
       "      <td>39000</td>\n",
       "      <td>2771</td>\n",
       "      <td>2947</td>\n",
       "      <td>743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>170</td>\n",
       "      <td>5201</td>\n",
       "      <td>EDUCATIONAL PSYCHOLOGY</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>2854</td>\n",
       "      <td>7</td>\n",
       "      <td>522</td>\n",
       "      <td>2332</td>\n",
       "      <td>0.817099</td>\n",
       "      <td>2125</td>\n",
       "      <td>...</td>\n",
       "      <td>572</td>\n",
       "      <td>1211</td>\n",
       "      <td>148</td>\n",
       "      <td>0.065112</td>\n",
       "      <td>25000</td>\n",
       "      <td>24000</td>\n",
       "      <td>34000</td>\n",
       "      <td>1488</td>\n",
       "      <td>615</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>171</td>\n",
       "      <td>5202</td>\n",
       "      <td>CLINICAL PSYCHOLOGY</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>2838</td>\n",
       "      <td>13</td>\n",
       "      <td>568</td>\n",
       "      <td>2270</td>\n",
       "      <td>0.799859</td>\n",
       "      <td>2101</td>\n",
       "      <td>...</td>\n",
       "      <td>648</td>\n",
       "      <td>1293</td>\n",
       "      <td>368</td>\n",
       "      <td>0.149048</td>\n",
       "      <td>25000</td>\n",
       "      <td>25000</td>\n",
       "      <td>40000</td>\n",
       "      <td>986</td>\n",
       "      <td>870</td>\n",
       "      <td>622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>172</td>\n",
       "      <td>5203</td>\n",
       "      <td>COUNSELING PSYCHOLOGY</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>4626</td>\n",
       "      <td>21</td>\n",
       "      <td>931</td>\n",
       "      <td>3695</td>\n",
       "      <td>0.798746</td>\n",
       "      <td>3777</td>\n",
       "      <td>...</td>\n",
       "      <td>965</td>\n",
       "      <td>2738</td>\n",
       "      <td>214</td>\n",
       "      <td>0.053621</td>\n",
       "      <td>23400</td>\n",
       "      <td>19200</td>\n",
       "      <td>26000</td>\n",
       "      <td>2403</td>\n",
       "      <td>1245</td>\n",
       "      <td>308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>173</td>\n",
       "      <td>3501</td>\n",
       "      <td>LIBRARY SCIENCE</td>\n",
       "      <td>Education</td>\n",
       "      <td>1098</td>\n",
       "      <td>2</td>\n",
       "      <td>134</td>\n",
       "      <td>964</td>\n",
       "      <td>0.877960</td>\n",
       "      <td>742</td>\n",
       "      <td>...</td>\n",
       "      <td>237</td>\n",
       "      <td>410</td>\n",
       "      <td>87</td>\n",
       "      <td>0.104946</td>\n",
       "      <td>22000</td>\n",
       "      <td>20000</td>\n",
       "      <td>22000</td>\n",
       "      <td>288</td>\n",
       "      <td>338</td>\n",
       "      <td>192</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>173 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Rank  Major_code                                          Major  \\\n",
       "0       1        2419                          PETROLEUM ENGINEERING   \n",
       "1       2        2416                 MINING AND MINERAL ENGINEERING   \n",
       "2       3        2415                      METALLURGICAL ENGINEERING   \n",
       "3       4        2417      NAVAL ARCHITECTURE AND MARINE ENGINEERING   \n",
       "4       5        2405                           CHEMICAL ENGINEERING   \n",
       "5       6        2418                            NUCLEAR ENGINEERING   \n",
       "6       7        6202                              ACTUARIAL SCIENCE   \n",
       "7       8        5001                     ASTRONOMY AND ASTROPHYSICS   \n",
       "8       9        2414                         MECHANICAL ENGINEERING   \n",
       "9      10        2408                         ELECTRICAL ENGINEERING   \n",
       "10     11        2407                           COMPUTER ENGINEERING   \n",
       "11     12        2401                          AEROSPACE ENGINEERING   \n",
       "12     13        2404                         BIOMEDICAL ENGINEERING   \n",
       "13     14        5008                              MATERIALS SCIENCE   \n",
       "14     15        2409      ENGINEERING MECHANICS PHYSICS AND SCIENCE   \n",
       "15     16        2402                         BIOLOGICAL ENGINEERING   \n",
       "16     17        2412       INDUSTRIAL AND MANUFACTURING ENGINEERING   \n",
       "17     18        2400                            GENERAL ENGINEERING   \n",
       "18     19        2403                      ARCHITECTURAL ENGINEERING   \n",
       "19     20        3201                                COURT REPORTING   \n",
       "20     21        2102                               COMPUTER SCIENCE   \n",
       "21     22        1104                                   FOOD SCIENCE   \n",
       "22     23        2502              ELECTRICAL ENGINEERING TECHNOLOGY   \n",
       "23     24        2413    MATERIALS ENGINEERING AND MATERIALS SCIENCE   \n",
       "24     25        6212  MANAGEMENT INFORMATION SYSTEMS AND STATISTICS   \n",
       "25     26        2406                              CIVIL ENGINEERING   \n",
       "26     27        5601                          CONSTRUCTION SERVICES   \n",
       "27     28        6204            OPERATIONS LOGISTICS AND E-COMMERCE   \n",
       "28     29        2499                      MISCELLANEOUS ENGINEERING   \n",
       "29     30        5402                                  PUBLIC POLICY   \n",
       "..    ...         ...                                            ...   \n",
       "143   144        1105                     PLANT SCIENCE AND AGRONOMY   \n",
       "144   145        2308         SCIENCE AND COMPUTER TEACHER EDUCATION   \n",
       "145   146        5200                                     PSYCHOLOGY   \n",
       "146   147        6002                                          MUSIC   \n",
       "147   148        2306         PHYSICAL AND HEALTH EDUCATION TEACHING   \n",
       "148   149        6006                      ART HISTORY AND CRITICISM   \n",
       "149   150        6000                                      FINE ARTS   \n",
       "150   151        2901                   FAMILY AND CONSUMER SCIENCES   \n",
       "151   152        5404                                    SOCIAL WORK   \n",
       "152   153        1103                                ANIMAL SCIENCES   \n",
       "153   154        6003                     VISUAL AND PERFORMING ARTS   \n",
       "154   155        2312             TEACHER EDUCATION: MULTIPLE LEVELS   \n",
       "155   156        5299                       MISCELLANEOUS PSYCHOLOGY   \n",
       "156   157        5403      HUMAN SERVICES AND COMMUNITY ORGANIZATION   \n",
       "157   158        3402                                     HUMANITIES   \n",
       "158   159        4901               THEOLOGY AND RELIGIOUS VOCATIONS   \n",
       "159   160        6007                                    STUDIO ARTS   \n",
       "160   161        2201         COSMETOLOGY SERVICES AND CULINARY ARTS   \n",
       "161   162        1199                      MISCELLANEOUS AGRICULTURE   \n",
       "162   163        5502                    ANTHROPOLOGY AND ARCHEOLOGY   \n",
       "163   164        6102  COMMUNICATION DISORDERS SCIENCES AND SERVICES   \n",
       "164   165        2307                      EARLY CHILDHOOD EDUCATION   \n",
       "165   166        2603                        OTHER FOREIGN LANGUAGES   \n",
       "166   167        6001                         DRAMA AND THEATER ARTS   \n",
       "167   168        3302                       COMPOSITION AND RHETORIC   \n",
       "168   169        3609                                        ZOOLOGY   \n",
       "169   170        5201                         EDUCATIONAL PSYCHOLOGY   \n",
       "170   171        5202                            CLINICAL PSYCHOLOGY   \n",
       "171   172        5203                          COUNSELING PSYCHOLOGY   \n",
       "172   173        3501                                LIBRARY SCIENCE   \n",
       "\n",
       "                          Major_category   Total  Sample_size    Men   Women  \\\n",
       "0                            Engineering    2339           36   2057     282   \n",
       "1                            Engineering     756            7    679      77   \n",
       "2                            Engineering     856            3    725     131   \n",
       "3                            Engineering    1258           16   1123     135   \n",
       "4                            Engineering   32260          289  21239   11021   \n",
       "5                            Engineering    2573           17   2200     373   \n",
       "6                               Business    3777           51    832     960   \n",
       "7                      Physical Sciences    1792           10   2110    1667   \n",
       "8                            Engineering   91227         1029  12953    2105   \n",
       "9                            Engineering   81527          631   8407    6548   \n",
       "10                           Engineering   41542          399  33258    8284   \n",
       "11                           Engineering   15058          147  65511   16016   \n",
       "12                           Engineering   14955           79  80320   10907   \n",
       "13                           Engineering    4279           22   2949    1330   \n",
       "14                           Engineering    4321           30   3526     795   \n",
       "15                           Engineering    8925           55   6062    2863   \n",
       "16                           Engineering   18968          183  12453    6515   \n",
       "17                           Engineering   61152          425  45683   15469   \n",
       "18                           Engineering    2825           26   1835     990   \n",
       "19                   Law & Public Policy    1148           14    877     271   \n",
       "20               Computers & Mathematics  128319         1196   1837    2524   \n",
       "21       Agriculture & Natural Resources    4361           36  99743   28576   \n",
       "22                           Engineering   11565           97   2020     973   \n",
       "23                           Engineering    2993           22   8181    3384   \n",
       "24                              Business   18713          278  13496    5217   \n",
       "25                           Engineering   53153          565  41081   12072   \n",
       "26   Industrial Arts & Consumer Services   18498          295   2662    1385   \n",
       "27                              Business   11732          156    488     232   \n",
       "28                           Engineering    9133          118   7398    1735   \n",
       "29                   Law & Public Policy    5978           55   2695     905   \n",
       "..                                   ...     ...          ...    ...     ...   \n",
       "143      Agriculture & Natural Resources    7416          110   5079    7841   \n",
       "144                            Education    6483           59  22357   16404   \n",
       "145             Psychology & Social Work  393735         2584  86648  307087   \n",
       "146                                 Arts   60633          419  15670   12543   \n",
       "147                            Education   28213          259  29909   30724   \n",
       "148            Humanities & Liberal Arts   21030          204   3240   17790   \n",
       "149                                 Arts   74440          623  24786   49654   \n",
       "150  Industrial Arts & Consumer Services   58001          518   5347   16226   \n",
       "151             Psychology & Social Work   53552          374   2734   11709   \n",
       "152      Agriculture & Natural Resources   21573          255   5166   52835   \n",
       "153                                 Arts   16250          132   2013    4639   \n",
       "154                            Education   14443          142   1936    7692   \n",
       "155             Psychology & Social Work    9628           60    885    8489   \n",
       "156             Psychology & Social Work    9374           89   5137   48415   \n",
       "157            Humanities & Liberal Arts    6652           49   4133   12117   \n",
       "158            Humanities & Liberal Arts   30207          310    404    1084   \n",
       "159                                 Arts   16977          182   4364    6146   \n",
       "160  Industrial Arts & Consumer Services   10510          117  18616   11591   \n",
       "161      Agriculture & Natural Resources    1488           24   4754   12223   \n",
       "162            Humanities & Liberal Arts   38844          247   1167   36422   \n",
       "163                               Health   38279           95  11376   27468   \n",
       "164                            Education   37589          342   1225   37054   \n",
       "165            Humanities & Liberal Arts   11204           56   3472    7732   \n",
       "166                                 Arts   43249          357   7022   11931   \n",
       "167            Humanities & Liberal Arts   18953          151  14440   28809   \n",
       "168               Biology & Life Science    8409           47   3050    5359   \n",
       "169             Psychology & Social Work    2854            7    522    2332   \n",
       "170             Psychology & Social Work    2838           13    568    2270   \n",
       "171             Psychology & Social Work    4626           21    931    3695   \n",
       "172                            Education    1098            2    134     964   \n",
       "\n",
       "     ShareWomen  Employed      ...        Part_time  Full_time_year_round  \\\n",
       "0      0.120564      1976      ...              270                  1207   \n",
       "1      0.101852       640      ...              170                   388   \n",
       "2      0.153037       648      ...              133                   340   \n",
       "3      0.107313       758      ...              150                   692   \n",
       "4      0.341631     25694      ...             5180                 16697   \n",
       "5      0.144967      1857      ...              264                  1449   \n",
       "6      0.535714      2912      ...              296                  2482   \n",
       "7      0.441356      1526      ...              553                   827   \n",
       "8      0.139793     76442      ...            13101                 54639   \n",
       "9      0.437847     61928      ...            12695                 41413   \n",
       "10     0.199413     32506      ...             5146                 23621   \n",
       "11     0.196450     11391      ...             2724                  8790   \n",
       "12     0.119559     10047      ...             2694                  5986   \n",
       "13     0.310820      3307      ...              878                  1967   \n",
       "14     0.183985      3608      ...              811                  2004   \n",
       "15     0.320784      6170      ...             1983                  3413   \n",
       "16     0.343473     15604      ...             2243                 11326   \n",
       "17     0.252960     44931      ...             7199                 33540   \n",
       "18     0.350442      2575      ...              343                  1848   \n",
       "19     0.236063       930      ...              223                   808   \n",
       "20     0.578766    102087      ...            18726                 70932   \n",
       "21     0.222695      3149      ...             1121                  1735   \n",
       "22     0.325092      8587      ...             1873                  5681   \n",
       "23     0.292607      2449      ...             1040                  1151   \n",
       "24     0.278790     16413      ...             2420                 13017   \n",
       "25     0.227118     43041      ...            10080                 29196   \n",
       "26     0.342229     16318      ...             1751                 12313   \n",
       "27     0.322222     10027      ...             1183                  7724   \n",
       "28     0.189970      7428      ...             1662                  5476   \n",
       "29     0.251389      4547      ...             1306                  2776   \n",
       "..          ...       ...      ...              ...                   ...   \n",
       "143    0.606889      6594      ...             1246                  4522   \n",
       "144    0.423209      5362      ...             1227                  3247   \n",
       "145    0.779933    307933      ...           115172                174438   \n",
       "146    0.444582     47662      ...            24943                 21425   \n",
       "147    0.506721     23794      ...             7230                 13651   \n",
       "148    0.845934     17579      ...             6140                  9965   \n",
       "149    0.667034     59679      ...            23656                 31877   \n",
       "150    0.752144     46624      ...            15872                 26906   \n",
       "151    0.810704     45038      ...            13481                 27588   \n",
       "152    0.910933     17112      ...             5353                 10824   \n",
       "153    0.697384     12870      ...             6253                  6322   \n",
       "154    0.798920     13076      ...             2214                  8457   \n",
       "155    0.905590      7653      ...             3221                  3838   \n",
       "156    0.904075      8294      ...             2405                  5061   \n",
       "157    0.745662      5052      ...             2225                  2661   \n",
       "158    0.728495     24202      ...             8767                 13944   \n",
       "159    0.584776     13908      ...             5673                  7413   \n",
       "160    0.383719      8650      ...             2064                  5949   \n",
       "161    0.719974      1290      ...              335                   936   \n",
       "162    0.968954     29633      ...            14515                 13232   \n",
       "163    0.707136     29763      ...            13862                 14460   \n",
       "164    0.967998     32551      ...             7001                 20748   \n",
       "165    0.690111      7052      ...             3685                  3214   \n",
       "166    0.629505     36165      ...            15994                 16891   \n",
       "167    0.666119     15053      ...             6612                  7832   \n",
       "168    0.637293      6259      ...             2190                  3602   \n",
       "169    0.817099      2125      ...              572                  1211   \n",
       "170    0.799859      2101      ...              648                  1293   \n",
       "171    0.798746      3777      ...              965                  2738   \n",
       "172    0.877960       742      ...              237                   410   \n",
       "\n",
       "     Unemployed  Unemployment_rate  Median  P25th   P75th  College_jobs  \\\n",
       "0            37           0.018381  110000  95000  125000          1534   \n",
       "1            85           0.117241   75000  55000   90000           350   \n",
       "2            16           0.024096   73000  50000  105000           456   \n",
       "3            40           0.050125   70000  43000   80000           529   \n",
       "4          1672           0.061098   65000  50000   75000         18314   \n",
       "5           400           0.177226   65000  50000  102000          1142   \n",
       "6           308           0.095652   62000  53000   72000          1768   \n",
       "7            33           0.021167   62000  31500  109000           972   \n",
       "8          4650           0.057342   60000  48000   70000         52844   \n",
       "9          3895           0.059174   60000  45000   72000         45829   \n",
       "10         2275           0.065409   60000  45000   75000         23694   \n",
       "11          794           0.065162   60000  42000   70000          8184   \n",
       "12         1019           0.092084   60000  36000   70000          6439   \n",
       "13           78           0.023043   60000  39000   65000          2626   \n",
       "14           23           0.006334   58000  25000   74000          2439   \n",
       "15          589           0.087143   57100  40000   76000          3603   \n",
       "16          699           0.042876   57000  37900   67000          8306   \n",
       "17         2859           0.059824   56000  36000   69000         26898   \n",
       "18          170           0.061931   54000  38000   65000          1665   \n",
       "19           11           0.011690   54000  50000   54000           402   \n",
       "20         6884           0.063173   53000  39000   70000         68622   \n",
       "21          338           0.096931   53000  32000   70000          1183   \n",
       "22          824           0.087557   52000  35000   60000          5126   \n",
       "23           70           0.027789   52000  35000   62000          1911   \n",
       "24         1015           0.058240   51000  38000   60000          6342   \n",
       "25         3270           0.070610   50000  40000   60000         28526   \n",
       "26         1042           0.060023   50000  36000   60000          3275   \n",
       "27          504           0.047859   50000  40000   60000          1466   \n",
       "28          597           0.074393   50000  39000   65000          3445   \n",
       "29          670           0.128426   50000  35000   70000          1550   \n",
       "..          ...                ...     ...    ...     ...           ...   \n",
       "143         314           0.045455   32000  22900   40000          2089   \n",
       "144         266           0.047264   32000  28000   39000          4214   \n",
       "145       28169           0.083811   31500  24000   41000        125148   \n",
       "146        3918           0.075960   31000  22300   42000         13752   \n",
       "147        1920           0.074667   31000  24000   40000         12777   \n",
       "148        1128           0.060298   31000  23000   40000          5139   \n",
       "149        5486           0.084186   30500  21000   41000         20792   \n",
       "150        3355           0.067128   30000  22900   40000         20985   \n",
       "151        3329           0.068828   30000  25000   35000         27449   \n",
       "152         917           0.050862   30000  22000   40000          5443   \n",
       "153        1465           0.102197   30000  22000   40000          3849   \n",
       "154         496           0.036546   30000  24000   37000         10766   \n",
       "155         419           0.051908   30000  20800   40000          2960   \n",
       "156         326           0.037819   30000  24000   35000          2878   \n",
       "157         372           0.068584   30000  20000   49000          1168   \n",
       "158        1617           0.062628   29000  22000   38000          9927   \n",
       "159        1368           0.089552   29000  19200   38300          3948   \n",
       "160         510           0.055677   29000  20000   36000           563   \n",
       "161          82           0.059767   29000  23000   42100           483   \n",
       "162        3395           0.102792   28000  20000   38000          9805   \n",
       "163        1487           0.047584   28000  20000   40000         19957   \n",
       "164        1360           0.040105   28000  21000   35000         23515   \n",
       "165         846           0.107116   27500  22900   38000          2326   \n",
       "166        3040           0.077541   27000  19200   35000          6994   \n",
       "167        1340           0.081742   27000  20000   35000          4855   \n",
       "168         304           0.046320   26000  20000   39000          2771   \n",
       "169         148           0.065112   25000  24000   34000          1488   \n",
       "170         368           0.149048   25000  25000   40000           986   \n",
       "171         214           0.053621   23400  19200   26000          2403   \n",
       "172          87           0.104946   22000  20000   22000           288   \n",
       "\n",
       "     Non_college_jobs  Low_wage_jobs  \n",
       "0                 364            193  \n",
       "1                 257             50  \n",
       "2                 176              0  \n",
       "3                 102              0  \n",
       "4                4440            972  \n",
       "5                 657            244  \n",
       "6                 314            259  \n",
       "7                 500            220  \n",
       "8               16384           3253  \n",
       "9               10874           3170  \n",
       "10               5721            980  \n",
       "11               2425            372  \n",
       "12               2471            789  \n",
       "13                391             81  \n",
       "14                947            263  \n",
       "15               1595            524  \n",
       "16               3235            640  \n",
       "17              11734           3192  \n",
       "18                649            137  \n",
       "19                528            144  \n",
       "20              25667           5144  \n",
       "21               1274            485  \n",
       "22               2686            696  \n",
       "23                305             70  \n",
       "24               5741            708  \n",
       "25               9356           2899  \n",
       "26               5351            703  \n",
       "27               3629            285  \n",
       "28               2426            365  \n",
       "29               1871            340  \n",
       "..                ...            ...  \n",
       "143              3545           1231  \n",
       "144              1106            591  \n",
       "145            141860          48207  \n",
       "146             28786           9286  \n",
       "147              9328           2042  \n",
       "148              9738           3426  \n",
       "149             32725          11880  \n",
       "150             20133           5248  \n",
       "151             14416           4344  \n",
       "152              9571           2125  \n",
       "153              7635           2840  \n",
       "154              1949            722  \n",
       "155              3948           1650  \n",
       "156              4595            724  \n",
       "157              3354           1141  \n",
       "158             12037           3304  \n",
       "159              8707           3586  \n",
       "160              7384           3163  \n",
       "161               626             31  \n",
       "162             16693           6866  \n",
       "163              9404           5125  \n",
       "164              7705           2868  \n",
       "165              3703           1115  \n",
       "166             25313          11068  \n",
       "167              8100           3466  \n",
       "168              2947            743  \n",
       "169               615             82  \n",
       "170               870            622  \n",
       "171              1245            308  \n",
       "172               338            192  \n",
       "\n",
       "[173 rows x 21 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Let's have a look at them\n",
    "\n",
    "grads"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Major_code</th>\n",
       "      <th>Major</th>\n",
       "      <th>Major_category</th>\n",
       "      <th>Total</th>\n",
       "      <th>Employed</th>\n",
       "      <th>Employed_full_time_year_round</th>\n",
       "      <th>Unemployed</th>\n",
       "      <th>Unemployment_rate</th>\n",
       "      <th>Median</th>\n",
       "      <th>P25th</th>\n",
       "      <th>P75th</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1100</td>\n",
       "      <td>GENERAL AGRICULTURE</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>128148</td>\n",
       "      <td>90245</td>\n",
       "      <td>74078</td>\n",
       "      <td>2423</td>\n",
       "      <td>0.026147</td>\n",
       "      <td>50000</td>\n",
       "      <td>34000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1101</td>\n",
       "      <td>AGRICULTURE PRODUCTION AND MANAGEMENT</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>95326</td>\n",
       "      <td>76865</td>\n",
       "      <td>64240</td>\n",
       "      <td>2266</td>\n",
       "      <td>0.028636</td>\n",
       "      <td>54000</td>\n",
       "      <td>36000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1102</td>\n",
       "      <td>AGRICULTURAL ECONOMICS</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>33955</td>\n",
       "      <td>26321</td>\n",
       "      <td>22810</td>\n",
       "      <td>821</td>\n",
       "      <td>0.030248</td>\n",
       "      <td>63000</td>\n",
       "      <td>40000</td>\n",
       "      <td>98000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1103</td>\n",
       "      <td>ANIMAL SCIENCES</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>103549</td>\n",
       "      <td>81177</td>\n",
       "      <td>64937</td>\n",
       "      <td>3619</td>\n",
       "      <td>0.042679</td>\n",
       "      <td>46000</td>\n",
       "      <td>30000</td>\n",
       "      <td>72000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1104</td>\n",
       "      <td>FOOD SCIENCE</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>24280</td>\n",
       "      <td>17281</td>\n",
       "      <td>12722</td>\n",
       "      <td>894</td>\n",
       "      <td>0.049188</td>\n",
       "      <td>62000</td>\n",
       "      <td>38500</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1105</td>\n",
       "      <td>PLANT SCIENCE AND AGRONOMY</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>79409</td>\n",
       "      <td>63043</td>\n",
       "      <td>51077</td>\n",
       "      <td>2070</td>\n",
       "      <td>0.031791</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1106</td>\n",
       "      <td>SOIL SCIENCE</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>6586</td>\n",
       "      <td>4926</td>\n",
       "      <td>4042</td>\n",
       "      <td>264</td>\n",
       "      <td>0.050867</td>\n",
       "      <td>63000</td>\n",
       "      <td>39400</td>\n",
       "      <td>88000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1199</td>\n",
       "      <td>MISCELLANEOUS AGRICULTURE</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>8549</td>\n",
       "      <td>6392</td>\n",
       "      <td>5074</td>\n",
       "      <td>261</td>\n",
       "      <td>0.039230</td>\n",
       "      <td>52000</td>\n",
       "      <td>35000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1301</td>\n",
       "      <td>ENVIRONMENTAL SCIENCE</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>106106</td>\n",
       "      <td>87602</td>\n",
       "      <td>65238</td>\n",
       "      <td>4736</td>\n",
       "      <td>0.051290</td>\n",
       "      <td>52000</td>\n",
       "      <td>38000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1302</td>\n",
       "      <td>FORESTRY</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>69447</td>\n",
       "      <td>48228</td>\n",
       "      <td>39613</td>\n",
       "      <td>2144</td>\n",
       "      <td>0.042563</td>\n",
       "      <td>58000</td>\n",
       "      <td>40500</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1303</td>\n",
       "      <td>NATURAL RESOURCES MANAGEMENT</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>83188</td>\n",
       "      <td>65937</td>\n",
       "      <td>50595</td>\n",
       "      <td>3789</td>\n",
       "      <td>0.054341</td>\n",
       "      <td>52000</td>\n",
       "      <td>37100</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1401</td>\n",
       "      <td>ARCHITECTURE</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>294692</td>\n",
       "      <td>216770</td>\n",
       "      <td>163020</td>\n",
       "      <td>20394</td>\n",
       "      <td>0.085991</td>\n",
       "      <td>63000</td>\n",
       "      <td>40400</td>\n",
       "      <td>93500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1501</td>\n",
       "      <td>AREA ETHNIC AND CIVILIZATION STUDIES</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>103740</td>\n",
       "      <td>75798</td>\n",
       "      <td>50530</td>\n",
       "      <td>5525</td>\n",
       "      <td>0.067939</td>\n",
       "      <td>46000</td>\n",
       "      <td>32000</td>\n",
       "      <td>71000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1901</td>\n",
       "      <td>COMMUNICATIONS</td>\n",
       "      <td>Communications &amp; Journalism</td>\n",
       "      <td>987676</td>\n",
       "      <td>790696</td>\n",
       "      <td>595739</td>\n",
       "      <td>54390</td>\n",
       "      <td>0.064360</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1902</td>\n",
       "      <td>JOURNALISM</td>\n",
       "      <td>Communications &amp; Journalism</td>\n",
       "      <td>418104</td>\n",
       "      <td>314438</td>\n",
       "      <td>235407</td>\n",
       "      <td>20754</td>\n",
       "      <td>0.061917</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1903</td>\n",
       "      <td>MASS MEDIA</td>\n",
       "      <td>Communications &amp; Journalism</td>\n",
       "      <td>211213</td>\n",
       "      <td>170474</td>\n",
       "      <td>125489</td>\n",
       "      <td>15431</td>\n",
       "      <td>0.083005</td>\n",
       "      <td>48000</td>\n",
       "      <td>32000</td>\n",
       "      <td>70000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1904</td>\n",
       "      <td>ADVERTISING AND PUBLIC RELATIONS</td>\n",
       "      <td>Communications &amp; Journalism</td>\n",
       "      <td>186829</td>\n",
       "      <td>147433</td>\n",
       "      <td>111552</td>\n",
       "      <td>10624</td>\n",
       "      <td>0.067216</td>\n",
       "      <td>50000</td>\n",
       "      <td>34000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2001</td>\n",
       "      <td>COMMUNICATION TECHNOLOGIES</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>62141</td>\n",
       "      <td>49609</td>\n",
       "      <td>37261</td>\n",
       "      <td>4609</td>\n",
       "      <td>0.085009</td>\n",
       "      <td>50000</td>\n",
       "      <td>34500</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2100</td>\n",
       "      <td>COMPUTER AND INFORMATION SYSTEMS</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>253782</td>\n",
       "      <td>218248</td>\n",
       "      <td>189950</td>\n",
       "      <td>11945</td>\n",
       "      <td>0.051891</td>\n",
       "      <td>65000</td>\n",
       "      <td>45000</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2101</td>\n",
       "      <td>COMPUTER PROGRAMMING AND DATA PROCESSING</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>29317</td>\n",
       "      <td>22828</td>\n",
       "      <td>18747</td>\n",
       "      <td>2265</td>\n",
       "      <td>0.090264</td>\n",
       "      <td>60000</td>\n",
       "      <td>40000</td>\n",
       "      <td>85000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2102</td>\n",
       "      <td>COMPUTER SCIENCE</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>783292</td>\n",
       "      <td>656372</td>\n",
       "      <td>561052</td>\n",
       "      <td>34196</td>\n",
       "      <td>0.049519</td>\n",
       "      <td>78000</td>\n",
       "      <td>51000</td>\n",
       "      <td>105000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2105</td>\n",
       "      <td>INFORMATION SCIENCES</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>77805</td>\n",
       "      <td>66393</td>\n",
       "      <td>57604</td>\n",
       "      <td>3704</td>\n",
       "      <td>0.052841</td>\n",
       "      <td>68000</td>\n",
       "      <td>46200</td>\n",
       "      <td>95000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2106</td>\n",
       "      <td>COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>39362</td>\n",
       "      <td>32366</td>\n",
       "      <td>28156</td>\n",
       "      <td>2626</td>\n",
       "      <td>0.075046</td>\n",
       "      <td>55000</td>\n",
       "      <td>40000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2107</td>\n",
       "      <td>COMPUTER NETWORKING AND TELECOMMUNICATIONS</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>51771</td>\n",
       "      <td>44071</td>\n",
       "      <td>35954</td>\n",
       "      <td>2748</td>\n",
       "      <td>0.058694</td>\n",
       "      <td>55000</td>\n",
       "      <td>36000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2201</td>\n",
       "      <td>COSMETOLOGY SERVICES AND CULINARY ARTS</td>\n",
       "      <td>Industrial Arts &amp; Consumer Services</td>\n",
       "      <td>42325</td>\n",
       "      <td>33388</td>\n",
       "      <td>25780</td>\n",
       "      <td>1941</td>\n",
       "      <td>0.054941</td>\n",
       "      <td>40000</td>\n",
       "      <td>26200</td>\n",
       "      <td>60000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2300</td>\n",
       "      <td>GENERAL EDUCATION</td>\n",
       "      <td>Education</td>\n",
       "      <td>1438867</td>\n",
       "      <td>843693</td>\n",
       "      <td>591863</td>\n",
       "      <td>38742</td>\n",
       "      <td>0.043904</td>\n",
       "      <td>43000</td>\n",
       "      <td>32000</td>\n",
       "      <td>59000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2301</td>\n",
       "      <td>EDUCATIONAL ADMINISTRATION AND SUPERVISION</td>\n",
       "      <td>Education</td>\n",
       "      <td>4037</td>\n",
       "      <td>3113</td>\n",
       "      <td>2468</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>58000</td>\n",
       "      <td>44750</td>\n",
       "      <td>79000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2303</td>\n",
       "      <td>SCHOOL STUDENT COUNSELING</td>\n",
       "      <td>Education</td>\n",
       "      <td>2396</td>\n",
       "      <td>1492</td>\n",
       "      <td>1093</td>\n",
       "      <td>169</td>\n",
       "      <td>0.101746</td>\n",
       "      <td>41000</td>\n",
       "      <td>33200</td>\n",
       "      <td>50000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2304</td>\n",
       "      <td>ELEMENTARY EDUCATION</td>\n",
       "      <td>Education</td>\n",
       "      <td>1446701</td>\n",
       "      <td>819393</td>\n",
       "      <td>501786</td>\n",
       "      <td>32685</td>\n",
       "      <td>0.038359</td>\n",
       "      <td>40000</td>\n",
       "      <td>31000</td>\n",
       "      <td>50000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2305</td>\n",
       "      <td>MATHEMATICS TEACHER EDUCATION</td>\n",
       "      <td>Education</td>\n",
       "      <td>68808</td>\n",
       "      <td>47203</td>\n",
       "      <td>29494</td>\n",
       "      <td>1610</td>\n",
       "      <td>0.032983</td>\n",
       "      <td>43000</td>\n",
       "      <td>34000</td>\n",
       "      <td>60000.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>6005</td>\n",
       "      <td>FILM VIDEO AND PHOTOGRAPHIC ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>133508</td>\n",
       "      <td>107651</td>\n",
       "      <td>69303</td>\n",
       "      <td>10080</td>\n",
       "      <td>0.085619</td>\n",
       "      <td>47000</td>\n",
       "      <td>30000</td>\n",
       "      <td>70000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>6006</td>\n",
       "      <td>ART HISTORY AND CRITICISM</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>90852</td>\n",
       "      <td>61295</td>\n",
       "      <td>38989</td>\n",
       "      <td>4185</td>\n",
       "      <td>0.063913</td>\n",
       "      <td>44500</td>\n",
       "      <td>30000</td>\n",
       "      <td>70000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>6007</td>\n",
       "      <td>STUDIO ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>81008</td>\n",
       "      <td>58799</td>\n",
       "      <td>36943</td>\n",
       "      <td>5372</td>\n",
       "      <td>0.083714</td>\n",
       "      <td>37600</td>\n",
       "      <td>24900</td>\n",
       "      <td>58000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>6099</td>\n",
       "      <td>MISCELLANEOUS FINE ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>8511</td>\n",
       "      <td>6431</td>\n",
       "      <td>3802</td>\n",
       "      <td>1190</td>\n",
       "      <td>0.156147</td>\n",
       "      <td>45000</td>\n",
       "      <td>30000</td>\n",
       "      <td>60000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>6100</td>\n",
       "      <td>GENERAL MEDICAL AND HEALTH SERVICES</td>\n",
       "      <td>Health</td>\n",
       "      <td>104516</td>\n",
       "      <td>78198</td>\n",
       "      <td>53746</td>\n",
       "      <td>4525</td>\n",
       "      <td>0.054701</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>73000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>6102</td>\n",
       "      <td>COMMUNICATION DISORDERS SCIENCES AND SERVICES</td>\n",
       "      <td>Health</td>\n",
       "      <td>74977</td>\n",
       "      <td>49393</td>\n",
       "      <td>26085</td>\n",
       "      <td>2407</td>\n",
       "      <td>0.046467</td>\n",
       "      <td>42000</td>\n",
       "      <td>30000</td>\n",
       "      <td>60000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>6103</td>\n",
       "      <td>HEALTH AND MEDICAL ADMINISTRATIVE SERVICES</td>\n",
       "      <td>Health</td>\n",
       "      <td>108510</td>\n",
       "      <td>85360</td>\n",
       "      <td>67294</td>\n",
       "      <td>5160</td>\n",
       "      <td>0.057004</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>6104</td>\n",
       "      <td>MEDICAL ASSISTING SERVICES</td>\n",
       "      <td>Health</td>\n",
       "      <td>64316</td>\n",
       "      <td>51279</td>\n",
       "      <td>25118</td>\n",
       "      <td>1660</td>\n",
       "      <td>0.031357</td>\n",
       "      <td>55000</td>\n",
       "      <td>37000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>6105</td>\n",
       "      <td>MEDICAL TECHNOLOGIES TECHNICIANS</td>\n",
       "      <td>Health</td>\n",
       "      <td>164990</td>\n",
       "      <td>121479</td>\n",
       "      <td>92128</td>\n",
       "      <td>4564</td>\n",
       "      <td>0.036210</td>\n",
       "      <td>60000</td>\n",
       "      <td>45000</td>\n",
       "      <td>76000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>6106</td>\n",
       "      <td>HEALTH AND MEDICAL PREPARATORY PROGRAMS</td>\n",
       "      <td>Health</td>\n",
       "      <td>32514</td>\n",
       "      <td>19009</td>\n",
       "      <td>13147</td>\n",
       "      <td>1431</td>\n",
       "      <td>0.070010</td>\n",
       "      <td>50000</td>\n",
       "      <td>34000</td>\n",
       "      <td>85000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>6107</td>\n",
       "      <td>NURSING</td>\n",
       "      <td>Health</td>\n",
       "      <td>1769892</td>\n",
       "      <td>1325711</td>\n",
       "      <td>947546</td>\n",
       "      <td>36503</td>\n",
       "      <td>0.026797</td>\n",
       "      <td>62000</td>\n",
       "      <td>48000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>6108</td>\n",
       "      <td>PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTR...</td>\n",
       "      <td>Health</td>\n",
       "      <td>180084</td>\n",
       "      <td>124058</td>\n",
       "      <td>89234</td>\n",
       "      <td>4414</td>\n",
       "      <td>0.034358</td>\n",
       "      <td>106000</td>\n",
       "      <td>78000</td>\n",
       "      <td>125000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>6109</td>\n",
       "      <td>TREATMENT THERAPY PROFESSIONS</td>\n",
       "      <td>Health</td>\n",
       "      <td>252138</td>\n",
       "      <td>199174</td>\n",
       "      <td>128115</td>\n",
       "      <td>5378</td>\n",
       "      <td>0.026292</td>\n",
       "      <td>61000</td>\n",
       "      <td>40000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>6110</td>\n",
       "      <td>COMMUNITY AND PUBLIC HEALTH</td>\n",
       "      <td>Health</td>\n",
       "      <td>56741</td>\n",
       "      <td>42543</td>\n",
       "      <td>28912</td>\n",
       "      <td>3032</td>\n",
       "      <td>0.066528</td>\n",
       "      <td>47000</td>\n",
       "      <td>32800</td>\n",
       "      <td>70000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>6199</td>\n",
       "      <td>MISCELLANEOUS HEALTH MEDICAL PROFESSIONS</td>\n",
       "      <td>Health</td>\n",
       "      <td>77647</td>\n",
       "      <td>52610</td>\n",
       "      <td>35676</td>\n",
       "      <td>2978</td>\n",
       "      <td>0.053573</td>\n",
       "      <td>45000</td>\n",
       "      <td>32000</td>\n",
       "      <td>62000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>6200</td>\n",
       "      <td>GENERAL BUSINESS</td>\n",
       "      <td>Business</td>\n",
       "      <td>2148712</td>\n",
       "      <td>1580978</td>\n",
       "      <td>1304646</td>\n",
       "      <td>85626</td>\n",
       "      <td>0.051378</td>\n",
       "      <td>60000</td>\n",
       "      <td>40000</td>\n",
       "      <td>95000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>6201</td>\n",
       "      <td>ACCOUNTING</td>\n",
       "      <td>Business</td>\n",
       "      <td>1779219</td>\n",
       "      <td>1335825</td>\n",
       "      <td>1095027</td>\n",
       "      <td>75379</td>\n",
       "      <td>0.053415</td>\n",
       "      <td>65000</td>\n",
       "      <td>42500</td>\n",
       "      <td>100000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>6202</td>\n",
       "      <td>ACTUARIAL SCIENCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>9763</td>\n",
       "      <td>7846</td>\n",
       "      <td>6880</td>\n",
       "      <td>466</td>\n",
       "      <td>0.056064</td>\n",
       "      <td>72000</td>\n",
       "      <td>53000</td>\n",
       "      <td>115000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>6203</td>\n",
       "      <td>BUSINESS MANAGEMENT AND ADMINISTRATION</td>\n",
       "      <td>Business</td>\n",
       "      <td>3123510</td>\n",
       "      <td>2354398</td>\n",
       "      <td>1939384</td>\n",
       "      <td>147261</td>\n",
       "      <td>0.058865</td>\n",
       "      <td>58000</td>\n",
       "      <td>39500</td>\n",
       "      <td>86000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>6204</td>\n",
       "      <td>OPERATIONS LOGISTICS AND E-COMMERCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>57200</td>\n",
       "      <td>47341</td>\n",
       "      <td>41104</td>\n",
       "      <td>2141</td>\n",
       "      <td>0.043268</td>\n",
       "      <td>65000</td>\n",
       "      <td>45000</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>6205</td>\n",
       "      <td>BUSINESS ECONOMICS</td>\n",
       "      <td>Business</td>\n",
       "      <td>75547</td>\n",
       "      <td>57983</td>\n",
       "      <td>48471</td>\n",
       "      <td>3816</td>\n",
       "      <td>0.061749</td>\n",
       "      <td>65000</td>\n",
       "      <td>45000</td>\n",
       "      <td>100000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>6206</td>\n",
       "      <td>MARKETING AND MARKETING RESEARCH</td>\n",
       "      <td>Business</td>\n",
       "      <td>1114624</td>\n",
       "      <td>890125</td>\n",
       "      <td>704912</td>\n",
       "      <td>51839</td>\n",
       "      <td>0.055033</td>\n",
       "      <td>56000</td>\n",
       "      <td>38500</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>6207</td>\n",
       "      <td>FINANCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>816548</td>\n",
       "      <td>670681</td>\n",
       "      <td>561073</td>\n",
       "      <td>34166</td>\n",
       "      <td>0.048473</td>\n",
       "      <td>65000</td>\n",
       "      <td>45000</td>\n",
       "      <td>100000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>6209</td>\n",
       "      <td>HUMAN RESOURCES AND PERSONNEL MANAGEMENT</td>\n",
       "      <td>Business</td>\n",
       "      <td>187274</td>\n",
       "      <td>142879</td>\n",
       "      <td>116466</td>\n",
       "      <td>9241</td>\n",
       "      <td>0.060748</td>\n",
       "      <td>54000</td>\n",
       "      <td>38000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>6210</td>\n",
       "      <td>INTERNATIONAL BUSINESS</td>\n",
       "      <td>Business</td>\n",
       "      <td>86064</td>\n",
       "      <td>66453</td>\n",
       "      <td>51012</td>\n",
       "      <td>5106</td>\n",
       "      <td>0.071354</td>\n",
       "      <td>54000</td>\n",
       "      <td>38600</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>6211</td>\n",
       "      <td>HOSPITALITY MANAGEMENT</td>\n",
       "      <td>Business</td>\n",
       "      <td>200854</td>\n",
       "      <td>163393</td>\n",
       "      <td>122499</td>\n",
       "      <td>8862</td>\n",
       "      <td>0.051447</td>\n",
       "      <td>49000</td>\n",
       "      <td>33000</td>\n",
       "      <td>70000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>6212</td>\n",
       "      <td>MANAGEMENT INFORMATION SYSTEMS AND STATISTICS</td>\n",
       "      <td>Business</td>\n",
       "      <td>156673</td>\n",
       "      <td>134478</td>\n",
       "      <td>118249</td>\n",
       "      <td>6186</td>\n",
       "      <td>0.043977</td>\n",
       "      <td>72000</td>\n",
       "      <td>50000</td>\n",
       "      <td>100000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>6299</td>\n",
       "      <td>MISCELLANEOUS BUSINESS &amp; MEDICAL ADMINISTRATION</td>\n",
       "      <td>Business</td>\n",
       "      <td>102753</td>\n",
       "      <td>77471</td>\n",
       "      <td>61603</td>\n",
       "      <td>4308</td>\n",
       "      <td>0.052679</td>\n",
       "      <td>53000</td>\n",
       "      <td>36000</td>\n",
       "      <td>83000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>6402</td>\n",
       "      <td>HISTORY</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>712509</td>\n",
       "      <td>478416</td>\n",
       "      <td>354163</td>\n",
       "      <td>33725</td>\n",
       "      <td>0.065851</td>\n",
       "      <td>50000</td>\n",
       "      <td>35000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>6403</td>\n",
       "      <td>UNITED STATES HISTORY</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>17746</td>\n",
       "      <td>11887</td>\n",
       "      <td>8204</td>\n",
       "      <td>943</td>\n",
       "      <td>0.073500</td>\n",
       "      <td>50000</td>\n",
       "      <td>39000</td>\n",
       "      <td>81000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>173 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Major_code                                              Major  \\\n",
       "0          1100                                GENERAL AGRICULTURE   \n",
       "1          1101              AGRICULTURE PRODUCTION AND MANAGEMENT   \n",
       "2          1102                             AGRICULTURAL ECONOMICS   \n",
       "3          1103                                    ANIMAL SCIENCES   \n",
       "4          1104                                       FOOD SCIENCE   \n",
       "5          1105                         PLANT SCIENCE AND AGRONOMY   \n",
       "6          1106                                       SOIL SCIENCE   \n",
       "7          1199                          MISCELLANEOUS AGRICULTURE   \n",
       "8          1301                              ENVIRONMENTAL SCIENCE   \n",
       "9          1302                                           FORESTRY   \n",
       "10         1303                       NATURAL RESOURCES MANAGEMENT   \n",
       "11         1401                                       ARCHITECTURE   \n",
       "12         1501               AREA ETHNIC AND CIVILIZATION STUDIES   \n",
       "13         1901                                     COMMUNICATIONS   \n",
       "14         1902                                         JOURNALISM   \n",
       "15         1903                                         MASS MEDIA   \n",
       "16         1904                   ADVERTISING AND PUBLIC RELATIONS   \n",
       "17         2001                         COMMUNICATION TECHNOLOGIES   \n",
       "18         2100                   COMPUTER AND INFORMATION SYSTEMS   \n",
       "19         2101           COMPUTER PROGRAMMING AND DATA PROCESSING   \n",
       "20         2102                                   COMPUTER SCIENCE   \n",
       "21         2105                               INFORMATION SCIENCES   \n",
       "22         2106    COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY   \n",
       "23         2107         COMPUTER NETWORKING AND TELECOMMUNICATIONS   \n",
       "24         2201             COSMETOLOGY SERVICES AND CULINARY ARTS   \n",
       "25         2300                                  GENERAL EDUCATION   \n",
       "26         2301         EDUCATIONAL ADMINISTRATION AND SUPERVISION   \n",
       "27         2303                          SCHOOL STUDENT COUNSELING   \n",
       "28         2304                               ELEMENTARY EDUCATION   \n",
       "29         2305                      MATHEMATICS TEACHER EDUCATION   \n",
       "..          ...                                                ...   \n",
       "143        6005                   FILM VIDEO AND PHOTOGRAPHIC ARTS   \n",
       "144        6006                          ART HISTORY AND CRITICISM   \n",
       "145        6007                                        STUDIO ARTS   \n",
       "146        6099                            MISCELLANEOUS FINE ARTS   \n",
       "147        6100                GENERAL MEDICAL AND HEALTH SERVICES   \n",
       "148        6102      COMMUNICATION DISORDERS SCIENCES AND SERVICES   \n",
       "149        6103         HEALTH AND MEDICAL ADMINISTRATIVE SERVICES   \n",
       "150        6104                         MEDICAL ASSISTING SERVICES   \n",
       "151        6105                   MEDICAL TECHNOLOGIES TECHNICIANS   \n",
       "152        6106            HEALTH AND MEDICAL PREPARATORY PROGRAMS   \n",
       "153        6107                                            NURSING   \n",
       "154        6108  PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTR...   \n",
       "155        6109                      TREATMENT THERAPY PROFESSIONS   \n",
       "156        6110                        COMMUNITY AND PUBLIC HEALTH   \n",
       "157        6199           MISCELLANEOUS HEALTH MEDICAL PROFESSIONS   \n",
       "158        6200                                   GENERAL BUSINESS   \n",
       "159        6201                                         ACCOUNTING   \n",
       "160        6202                                  ACTUARIAL SCIENCE   \n",
       "161        6203             BUSINESS MANAGEMENT AND ADMINISTRATION   \n",
       "162        6204                OPERATIONS LOGISTICS AND E-COMMERCE   \n",
       "163        6205                                 BUSINESS ECONOMICS   \n",
       "164        6206                   MARKETING AND MARKETING RESEARCH   \n",
       "165        6207                                            FINANCE   \n",
       "166        6209           HUMAN RESOURCES AND PERSONNEL MANAGEMENT   \n",
       "167        6210                             INTERNATIONAL BUSINESS   \n",
       "168        6211                             HOSPITALITY MANAGEMENT   \n",
       "169        6212      MANAGEMENT INFORMATION SYSTEMS AND STATISTICS   \n",
       "170        6299    MISCELLANEOUS BUSINESS & MEDICAL ADMINISTRATION   \n",
       "171        6402                                            HISTORY   \n",
       "172        6403                              UNITED STATES HISTORY   \n",
       "\n",
       "                          Major_category    Total  Employed  \\\n",
       "0        Agriculture & Natural Resources   128148     90245   \n",
       "1        Agriculture & Natural Resources    95326     76865   \n",
       "2        Agriculture & Natural Resources    33955     26321   \n",
       "3        Agriculture & Natural Resources   103549     81177   \n",
       "4        Agriculture & Natural Resources    24280     17281   \n",
       "5        Agriculture & Natural Resources    79409     63043   \n",
       "6        Agriculture & Natural Resources     6586      4926   \n",
       "7        Agriculture & Natural Resources     8549      6392   \n",
       "8                 Biology & Life Science   106106     87602   \n",
       "9        Agriculture & Natural Resources    69447     48228   \n",
       "10       Agriculture & Natural Resources    83188     65937   \n",
       "11                           Engineering   294692    216770   \n",
       "12             Humanities & Liberal Arts   103740     75798   \n",
       "13           Communications & Journalism   987676    790696   \n",
       "14           Communications & Journalism   418104    314438   \n",
       "15           Communications & Journalism   211213    170474   \n",
       "16           Communications & Journalism   186829    147433   \n",
       "17               Computers & Mathematics    62141     49609   \n",
       "18               Computers & Mathematics   253782    218248   \n",
       "19               Computers & Mathematics    29317     22828   \n",
       "20               Computers & Mathematics   783292    656372   \n",
       "21               Computers & Mathematics    77805     66393   \n",
       "22               Computers & Mathematics    39362     32366   \n",
       "23               Computers & Mathematics    51771     44071   \n",
       "24   Industrial Arts & Consumer Services    42325     33388   \n",
       "25                             Education  1438867    843693   \n",
       "26                             Education     4037      3113   \n",
       "27                             Education     2396      1492   \n",
       "28                             Education  1446701    819393   \n",
       "29                             Education    68808     47203   \n",
       "..                                   ...      ...       ...   \n",
       "143                                 Arts   133508    107651   \n",
       "144            Humanities & Liberal Arts    90852     61295   \n",
       "145                                 Arts    81008     58799   \n",
       "146                                 Arts     8511      6431   \n",
       "147                               Health   104516     78198   \n",
       "148                               Health    74977     49393   \n",
       "149                               Health   108510     85360   \n",
       "150                               Health    64316     51279   \n",
       "151                               Health   164990    121479   \n",
       "152                               Health    32514     19009   \n",
       "153                               Health  1769892   1325711   \n",
       "154                               Health   180084    124058   \n",
       "155                               Health   252138    199174   \n",
       "156                               Health    56741     42543   \n",
       "157                               Health    77647     52610   \n",
       "158                             Business  2148712   1580978   \n",
       "159                             Business  1779219   1335825   \n",
       "160                             Business     9763      7846   \n",
       "161                             Business  3123510   2354398   \n",
       "162                             Business    57200     47341   \n",
       "163                             Business    75547     57983   \n",
       "164                             Business  1114624    890125   \n",
       "165                             Business   816548    670681   \n",
       "166                             Business   187274    142879   \n",
       "167                             Business    86064     66453   \n",
       "168                             Business   200854    163393   \n",
       "169                             Business   156673    134478   \n",
       "170                             Business   102753     77471   \n",
       "171            Humanities & Liberal Arts   712509    478416   \n",
       "172            Humanities & Liberal Arts    17746     11887   \n",
       "\n",
       "     Employed_full_time_year_round  Unemployed  Unemployment_rate  Median  \\\n",
       "0                            74078        2423           0.026147   50000   \n",
       "1                            64240        2266           0.028636   54000   \n",
       "2                            22810         821           0.030248   63000   \n",
       "3                            64937        3619           0.042679   46000   \n",
       "4                            12722         894           0.049188   62000   \n",
       "5                            51077        2070           0.031791   50000   \n",
       "6                             4042         264           0.050867   63000   \n",
       "7                             5074         261           0.039230   52000   \n",
       "8                            65238        4736           0.051290   52000   \n",
       "9                            39613        2144           0.042563   58000   \n",
       "10                           50595        3789           0.054341   52000   \n",
       "11                          163020       20394           0.085991   63000   \n",
       "12                           50530        5525           0.067939   46000   \n",
       "13                          595739       54390           0.064360   50000   \n",
       "14                          235407       20754           0.061917   50000   \n",
       "15                          125489       15431           0.083005   48000   \n",
       "16                          111552       10624           0.067216   50000   \n",
       "17                           37261        4609           0.085009   50000   \n",
       "18                          189950       11945           0.051891   65000   \n",
       "19                           18747        2265           0.090264   60000   \n",
       "20                          561052       34196           0.049519   78000   \n",
       "21                           57604        3704           0.052841   68000   \n",
       "22                           28156        2626           0.075046   55000   \n",
       "23                           35954        2748           0.058694   55000   \n",
       "24                           25780        1941           0.054941   40000   \n",
       "25                          591863       38742           0.043904   43000   \n",
       "26                            2468           0           0.000000   58000   \n",
       "27                            1093         169           0.101746   41000   \n",
       "28                          501786       32685           0.038359   40000   \n",
       "29                           29494        1610           0.032983   43000   \n",
       "..                             ...         ...                ...     ...   \n",
       "143                          69303       10080           0.085619   47000   \n",
       "144                          38989        4185           0.063913   44500   \n",
       "145                          36943        5372           0.083714   37600   \n",
       "146                           3802        1190           0.156147   45000   \n",
       "147                          53746        4525           0.054701   50000   \n",
       "148                          26085        2407           0.046467   42000   \n",
       "149                          67294        5160           0.057004   50000   \n",
       "150                          25118        1660           0.031357   55000   \n",
       "151                          92128        4564           0.036210   60000   \n",
       "152                          13147        1431           0.070010   50000   \n",
       "153                         947546       36503           0.026797   62000   \n",
       "154                          89234        4414           0.034358  106000   \n",
       "155                         128115        5378           0.026292   61000   \n",
       "156                          28912        3032           0.066528   47000   \n",
       "157                          35676        2978           0.053573   45000   \n",
       "158                        1304646       85626           0.051378   60000   \n",
       "159                        1095027       75379           0.053415   65000   \n",
       "160                           6880         466           0.056064   72000   \n",
       "161                        1939384      147261           0.058865   58000   \n",
       "162                          41104        2141           0.043268   65000   \n",
       "163                          48471        3816           0.061749   65000   \n",
       "164                         704912       51839           0.055033   56000   \n",
       "165                         561073       34166           0.048473   65000   \n",
       "166                         116466        9241           0.060748   54000   \n",
       "167                          51012        5106           0.071354   54000   \n",
       "168                         122499        8862           0.051447   49000   \n",
       "169                         118249        6186           0.043977   72000   \n",
       "170                          61603        4308           0.052679   53000   \n",
       "171                         354163       33725           0.065851   50000   \n",
       "172                           8204         943           0.073500   50000   \n",
       "\n",
       "     P25th     P75th  \n",
       "0    34000   80000.0  \n",
       "1    36000   80000.0  \n",
       "2    40000   98000.0  \n",
       "3    30000   72000.0  \n",
       "4    38500   90000.0  \n",
       "5    35000   75000.0  \n",
       "6    39400   88000.0  \n",
       "7    35000   75000.0  \n",
       "8    38000   75000.0  \n",
       "9    40500   80000.0  \n",
       "10   37100   75000.0  \n",
       "11   40400   93500.0  \n",
       "12   32000   71000.0  \n",
       "13   35000   80000.0  \n",
       "14   35000   80000.0  \n",
       "15   32000   70000.0  \n",
       "16   34000   75000.0  \n",
       "17   34500   75000.0  \n",
       "18   45000   90000.0  \n",
       "19   40000   85000.0  \n",
       "20   51000  105000.0  \n",
       "21   46200   95000.0  \n",
       "22   40000   80000.0  \n",
       "23   36000   80000.0  \n",
       "24   26200   60000.0  \n",
       "25   32000   59000.0  \n",
       "26   44750   79000.0  \n",
       "27   33200   50000.0  \n",
       "28   31000   50000.0  \n",
       "29   34000   60000.0  \n",
       "..     ...       ...  \n",
       "143  30000   70000.0  \n",
       "144  30000   70000.0  \n",
       "145  24900   58000.0  \n",
       "146  30000   60000.0  \n",
       "147  35000   73000.0  \n",
       "148  30000   60000.0  \n",
       "149  35000   75000.0  \n",
       "150  37000   75000.0  \n",
       "151  45000   76000.0  \n",
       "152  34000   85000.0  \n",
       "153  48000   80000.0  \n",
       "154  78000  125000.0  \n",
       "155  40000   80000.0  \n",
       "156  32800   70000.0  \n",
       "157  32000   62000.0  \n",
       "158  40000   95000.0  \n",
       "159  42500  100000.0  \n",
       "160  53000  115000.0  \n",
       "161  39500   86000.0  \n",
       "162  45000   90000.0  \n",
       "163  45000  100000.0  \n",
       "164  38500   90000.0  \n",
       "165  45000  100000.0  \n",
       "166  38000   80000.0  \n",
       "167  38600   80000.0  \n",
       "168  33000   70000.0  \n",
       "169  50000  100000.0  \n",
       "170  36000   83000.0  \n",
       "171  35000   80000.0  \n",
       "172  39000   81000.0  \n",
       "\n",
       "[173 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ages"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Summarize the total number of grads under each major category"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Agriculture & Natural Resources': 79981,\n",
       " 'Arts': 357130,\n",
       " 'Biology & Life Science': 453862,\n",
       " 'Business': 1302376,\n",
       " 'Communications & Journalism': 392601,\n",
       " 'Computers & Mathematics': 299008,\n",
       " 'Education': 559129,\n",
       " 'Engineering': 537583,\n",
       " 'Health': 463230,\n",
       " 'Humanities & Liberal Arts': 713468,\n",
       " 'Industrial Arts & Consumer Services': 229792,\n",
       " 'Interdisciplinary': 12296,\n",
       " 'Law & Public Policy': 179107,\n",
       " 'Physical Sciences': 185479,\n",
       " 'Psychology & Social Work': 481007,\n",
       " 'Social Science': 529966}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To get the unique values of certain column (Series) in DataFrame\n",
    "unique_grads = grads[\"Major_category\"].unique()\n",
    "\n",
    "# We may loop over those values in order to get the sum for each catagory\n",
    "# this is for \"Engineering\"\n",
    "engineerings = grads[grads[\"Major_category\"] == grads[\"Major_category\"].unique()[0]][\"Total\"].sum() \n",
    "\n",
    "# Let's do this in more effective way, and have it inside a dictionary\n",
    "majors = dict()\n",
    "\n",
    "for major in grads[\"Major_category\"].unique():\n",
    "    majors[major] = grads[grads[\"Major_category\"] == major][\"Total\"].sum()\n",
    "    \n",
    "majors"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Let's find out low paid jobs rate %"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.09852546076122913"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "low_wage = grads[\"Low_wage_jobs\"].sum() / grads[\"Total\"].sum()\n",
    "low_wage"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Let's compare the unemployment rate for both grads and other dataset ages (which is all population)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "majors = grads[\"Major\"].unique()\n",
    "\n",
    "lower_count = 0\n",
    "\n",
    "for m in majors:\n",
    "    x = grads[grads[\"Major\"] == m]\n",
    "    \n",
    "    if grads[grads[\"Major\"] == m].iloc[0][\"Unemployment_rate\"] < ages[ages[\"Major\"] == m].iloc[0][\"Unemployment_rate\"]:\n",
    "        lower_count+= 1\n",
    "        \n",
    "lower_count"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Let's get stats for the ages DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Major_code</th>\n",
       "      <th>Total</th>\n",
       "      <th>Employed</th>\n",
       "      <th>Employed_full_time_year_round</th>\n",
       "      <th>Unemployed</th>\n",
       "      <th>Unemployment_rate</th>\n",
       "      <th>Median</th>\n",
       "      <th>P25th</th>\n",
       "      <th>P75th</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>173.000000</td>\n",
       "      <td>1.730000e+02</td>\n",
       "      <td>1.730000e+02</td>\n",
       "      <td>1.730000e+02</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>173.000000</td>\n",
       "      <td>173.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>3879.815029</td>\n",
       "      <td>2.302566e+05</td>\n",
       "      <td>1.661620e+05</td>\n",
       "      <td>1.263078e+05</td>\n",
       "      <td>9725.034682</td>\n",
       "      <td>0.057355</td>\n",
       "      <td>56816.184971</td>\n",
       "      <td>38697.109827</td>\n",
       "      <td>82506.358382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1687.753140</td>\n",
       "      <td>4.220685e+05</td>\n",
       "      <td>3.073244e+05</td>\n",
       "      <td>2.424254e+05</td>\n",
       "      <td>18022.040192</td>\n",
       "      <td>0.019177</td>\n",
       "      <td>14706.226865</td>\n",
       "      <td>9414.524761</td>\n",
       "      <td>20805.330126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1100.000000</td>\n",
       "      <td>2.396000e+03</td>\n",
       "      <td>1.492000e+03</td>\n",
       "      <td>1.093000e+03</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>35000.000000</td>\n",
       "      <td>24900.000000</td>\n",
       "      <td>45800.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2403.000000</td>\n",
       "      <td>2.428000e+04</td>\n",
       "      <td>1.728100e+04</td>\n",
       "      <td>1.272200e+04</td>\n",
       "      <td>1101.000000</td>\n",
       "      <td>0.046261</td>\n",
       "      <td>46000.000000</td>\n",
       "      <td>32000.000000</td>\n",
       "      <td>70000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>3608.000000</td>\n",
       "      <td>7.579100e+04</td>\n",
       "      <td>5.656400e+04</td>\n",
       "      <td>3.961300e+04</td>\n",
       "      <td>3619.000000</td>\n",
       "      <td>0.054719</td>\n",
       "      <td>53000.000000</td>\n",
       "      <td>36000.000000</td>\n",
       "      <td>80000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>5503.000000</td>\n",
       "      <td>2.057630e+05</td>\n",
       "      <td>1.428790e+05</td>\n",
       "      <td>1.110250e+05</td>\n",
       "      <td>8862.000000</td>\n",
       "      <td>0.069043</td>\n",
       "      <td>65000.000000</td>\n",
       "      <td>42000.000000</td>\n",
       "      <td>95000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>6403.000000</td>\n",
       "      <td>3.123510e+06</td>\n",
       "      <td>2.354398e+06</td>\n",
       "      <td>1.939384e+06</td>\n",
       "      <td>147261.000000</td>\n",
       "      <td>0.156147</td>\n",
       "      <td>125000.000000</td>\n",
       "      <td>78000.000000</td>\n",
       "      <td>210000.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Major_code         Total      Employed  Employed_full_time_year_round  \\\n",
       "count   173.000000  1.730000e+02  1.730000e+02                   1.730000e+02   \n",
       "mean   3879.815029  2.302566e+05  1.661620e+05                   1.263078e+05   \n",
       "std    1687.753140  4.220685e+05  3.073244e+05                   2.424254e+05   \n",
       "min    1100.000000  2.396000e+03  1.492000e+03                   1.093000e+03   \n",
       "25%    2403.000000  2.428000e+04  1.728100e+04                   1.272200e+04   \n",
       "50%    3608.000000  7.579100e+04  5.656400e+04                   3.961300e+04   \n",
       "75%    5503.000000  2.057630e+05  1.428790e+05                   1.110250e+05   \n",
       "max    6403.000000  3.123510e+06  2.354398e+06                   1.939384e+06   \n",
       "\n",
       "          Unemployed  Unemployment_rate         Median         P25th  \\\n",
       "count     173.000000         173.000000     173.000000    173.000000   \n",
       "mean     9725.034682           0.057355   56816.184971  38697.109827   \n",
       "std     18022.040192           0.019177   14706.226865   9414.524761   \n",
       "min         0.000000           0.000000   35000.000000  24900.000000   \n",
       "25%      1101.000000           0.046261   46000.000000  32000.000000   \n",
       "50%      3619.000000           0.054719   53000.000000  36000.000000   \n",
       "75%      8862.000000           0.069043   65000.000000  42000.000000   \n",
       "max    147261.000000           0.156147  125000.000000  78000.000000   \n",
       "\n",
       "               P75th  \n",
       "count     173.000000  \n",
       "mean    82506.358382  \n",
       "std     20805.330126  \n",
       "min     45800.000000  \n",
       "25%     70000.000000  \n",
       "50%     80000.000000  \n",
       "75%     95000.000000  \n",
       "max    210000.000000  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ages.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### \"Total\" column from ages DataFrame sum calue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "39834398"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ages.Total.sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "#### Get random sample from ages DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Major_code</th>\n",
       "      <th>Major</th>\n",
       "      <th>Major_category</th>\n",
       "      <th>Total</th>\n",
       "      <th>Employed</th>\n",
       "      <th>Employed_full_time_year_round</th>\n",
       "      <th>Unemployed</th>\n",
       "      <th>Unemployment_rate</th>\n",
       "      <th>Median</th>\n",
       "      <th>P25th</th>\n",
       "      <th>P75th</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>6206</td>\n",
       "      <td>MARKETING AND MARKETING RESEARCH</td>\n",
       "      <td>Business</td>\n",
       "      <td>1114624</td>\n",
       "      <td>890125</td>\n",
       "      <td>704912</td>\n",
       "      <td>51839</td>\n",
       "      <td>0.055033</td>\n",
       "      <td>56000</td>\n",
       "      <td>38500</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>3402</td>\n",
       "      <td>HUMANITIES</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>46188</td>\n",
       "      <td>29971</td>\n",
       "      <td>19460</td>\n",
       "      <td>2530</td>\n",
       "      <td>0.077844</td>\n",
       "      <td>46700</td>\n",
       "      <td>30000</td>\n",
       "      <td>70000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>3801</td>\n",
       "      <td>MILITARY TECHNOLOGIES</td>\n",
       "      <td>Industrial Arts &amp; Consumer Services</td>\n",
       "      <td>4315</td>\n",
       "      <td>1650</td>\n",
       "      <td>1708</td>\n",
       "      <td>187</td>\n",
       "      <td>0.101796</td>\n",
       "      <td>64000</td>\n",
       "      <td>39750</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1101</td>\n",
       "      <td>AGRICULTURE PRODUCTION AND MANAGEMENT</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>95326</td>\n",
       "      <td>76865</td>\n",
       "      <td>64240</td>\n",
       "      <td>2266</td>\n",
       "      <td>0.028636</td>\n",
       "      <td>54000</td>\n",
       "      <td>36000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1301</td>\n",
       "      <td>ENVIRONMENTAL SCIENCE</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>106106</td>\n",
       "      <td>87602</td>\n",
       "      <td>65238</td>\n",
       "      <td>4736</td>\n",
       "      <td>0.051290</td>\n",
       "      <td>52000</td>\n",
       "      <td>38000</td>\n",
       "      <td>75000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>5200</td>\n",
       "      <td>PSYCHOLOGY</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>1484075</td>\n",
       "      <td>1055854</td>\n",
       "      <td>736817</td>\n",
       "      <td>79066</td>\n",
       "      <td>0.069667</td>\n",
       "      <td>45000</td>\n",
       "      <td>31000</td>\n",
       "      <td>68000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>5599</td>\n",
       "      <td>MISCELLANEOUS SOCIAL SCIENCES</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>15882</td>\n",
       "      <td>12307</td>\n",
       "      <td>9444</td>\n",
       "      <td>708</td>\n",
       "      <td>0.054399</td>\n",
       "      <td>52000</td>\n",
       "      <td>40000</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>3302</td>\n",
       "      <td>COMPOSITION AND RHETORIC</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>59211</td>\n",
       "      <td>44913</td>\n",
       "      <td>29628</td>\n",
       "      <td>3569</td>\n",
       "      <td>0.073615</td>\n",
       "      <td>40000</td>\n",
       "      <td>28800</td>\n",
       "      <td>65000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>6001</td>\n",
       "      <td>DRAMA AND THEATER ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>174817</td>\n",
       "      <td>135071</td>\n",
       "      <td>81519</td>\n",
       "      <td>11789</td>\n",
       "      <td>0.080274</td>\n",
       "      <td>42000</td>\n",
       "      <td>29000</td>\n",
       "      <td>62000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2403</td>\n",
       "      <td>ARCHITECTURAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>19587</td>\n",
       "      <td>13713</td>\n",
       "      <td>11180</td>\n",
       "      <td>1017</td>\n",
       "      <td>0.069043</td>\n",
       "      <td>78000</td>\n",
       "      <td>50000</td>\n",
       "      <td>102000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Major_code                                  Major  \\\n",
       "164        6206       MARKETING AND MARKETING RESEARCH   \n",
       "76         3402                             HUMANITIES   \n",
       "93         3801                  MILITARY TECHNOLOGIES   \n",
       "1          1101  AGRICULTURE PRODUCTION AND MANAGEMENT   \n",
       "8          1301                  ENVIRONMENTAL SCIENCE   \n",
       "114        5200                             PSYCHOLOGY   \n",
       "134        5599          MISCELLANEOUS SOCIAL SCIENCES   \n",
       "74         3302               COMPOSITION AND RHETORIC   \n",
       "139        6001                 DRAMA AND THEATER ARTS   \n",
       "43         2403              ARCHITECTURAL ENGINEERING   \n",
       "\n",
       "                          Major_category    Total  Employed  \\\n",
       "164                             Business  1114624    890125   \n",
       "76             Humanities & Liberal Arts    46188     29971   \n",
       "93   Industrial Arts & Consumer Services     4315      1650   \n",
       "1        Agriculture & Natural Resources    95326     76865   \n",
       "8                 Biology & Life Science   106106     87602   \n",
       "114             Psychology & Social Work  1484075   1055854   \n",
       "134                       Social Science    15882     12307   \n",
       "74             Humanities & Liberal Arts    59211     44913   \n",
       "139                                 Arts   174817    135071   \n",
       "43                           Engineering    19587     13713   \n",
       "\n",
       "     Employed_full_time_year_round  Unemployed  Unemployment_rate  Median  \\\n",
       "164                         704912       51839           0.055033   56000   \n",
       "76                           19460        2530           0.077844   46700   \n",
       "93                            1708         187           0.101796   64000   \n",
       "1                            64240        2266           0.028636   54000   \n",
       "8                            65238        4736           0.051290   52000   \n",
       "114                         736817       79066           0.069667   45000   \n",
       "134                           9444         708           0.054399   52000   \n",
       "74                           29628        3569           0.073615   40000   \n",
       "139                          81519       11789           0.080274   42000   \n",
       "43                           11180        1017           0.069043   78000   \n",
       "\n",
       "     P25th     P75th  \n",
       "164  38500   90000.0  \n",
       "76   30000   70000.0  \n",
       "93   39750   90000.0  \n",
       "1    36000   80000.0  \n",
       "8    38000   75000.0  \n",
       "114  31000   68000.0  \n",
       "134  40000   80000.0  \n",
       "74   28800   65000.0  \n",
       "139  29000   62000.0  \n",
       "43   50000  102000.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ages.sample(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "---\n",
    "### That's it!\n",
    "\n",
    "Prepared by Issam Hijazi\n",
    "\n",
    "https://ae.linkedin.com/in/ihijazi\n",
    "\n",
    "@iHijazi"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}