Dataframes.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. Dataframes\n",
    "\n",
    "## 1: Dataframe Basics\n",
    "\n",
    "### The Pandas Library\n",
    "Pandas is an open source library that provides easy-to-use data structures and data analysis tools in Python. This library offers a very useful data structure called the Dataframes.\n",
    "\n",
    "### Dataframes\n",
    "Dataframes is defined as a 2-dimensional labeled data structure with columns of potentially different types according to pydata.org. It is similar to a spreadsheet or SQL table, or a dict of Series objects. \n",
    "\n",
    "#### Description\n",
    "Let us read in a csv file into a dataframe object. The pandas dataframe is so versatile that it can easily read files from url links. \n",
    "\n",
    "You can think of Dataframes to be as important for a Data Scientist as Cutting is for a cook. To be able to learn the various operations is essential for you to be a strong Data Scientist. \n",
    "\n",
    "For example dataset, we shall consider data and code for FiveThirtyEight's story on earnings of college majors. All data is from American Community Survey 2010-2012 Public Use Microdata Series from:\n",
    "\n",
    "http://www.census.gov/acs/www/data_documentation/pums_data/\n",
    "\n",
    "\n",
    "## 1. Exercise\n",
    "#### Instructions\n",
    "Reading into a Dataframe\n",
    "Dataframes are a part of the library called Pandas. One of the versatile features of pandas dataframe is able to read the data from a url by just specifying the link with the command pandas.read_csv()\n",
    "\n",
    "One of the useful commands that is useful to list the first few rows is the head function which takes in number of rows to be listed in the top-down order. \n",
    "List first few rows of the dataframe using the .head() function and assign it to grad_sample. How many rows does the .head() show up?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Import the library\n",
    "import pandas\n",
    "\n",
    "grad_url = \"https://raw.githubusercontent.com/harishkashyap/data/master/college-majors/grad-students.csv\"\n",
    "grad_students = pandas.read_csv(grad_url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2: Row Selection\n",
    "You could see that the column indices were shown in the head() command. The dataframes are indexed by starting index of 0 on both row and column similar to array indexing. Note that the upper bound is excluded from listing in the output. To list rows from 2 to 6 of a column 'Major':\n",
    "\n",
    "grad_students['Major'][1:6]\n",
    "\n",
    "## 2. Exercise\n",
    "\n",
    "Instructions\n",
    "Load rows 2 to 6 of column Major_category and assign it to variable major_category.\n",
    "print out the variable major_category"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3: Column Selection\n",
    "To list multiple columns use double square brackets. For example, to list Major_category, Grad_share you can use:\n",
    "\n",
    "grad_students[['Major_category', 'Grad_share']]\n",
    "\n",
    "## 3. Exercise\n",
    "Instructions\n",
    "List columns of Major_code and Grad_employed for rows 4 to 8 and assign it to the variable, grad_students_sample.\n",
    "print out grad_students_sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Grad_employed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5601</td>\n",
       "      <td>7098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6004</td>\n",
       "      <td>40492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6211</td>\n",
       "      <td>18368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2201</td>\n",
       "      <td>3590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2001</td>\n",
       "      <td>7512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3201</td>\n",
       "      <td>1008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6206</td>\n",
       "      <td>151570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1101</td>\n",
       "      <td>13104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2101</td>\n",
       "      <td>4716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1904</td>\n",
       "      <td>28517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>6005</td>\n",
       "      <td>19059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5701</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2504</td>\n",
       "      <td>4442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1903</td>\n",
       "      <td>35939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5901</td>\n",
       "      <td>20035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2107</td>\n",
       "      <td>9037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>6299</td>\n",
       "      <td>17691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2599</td>\n",
       "      <td>12433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2503</td>\n",
       "      <td>14752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>6099</td>\n",
       "      <td>1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5301</td>\n",
       "      <td>154146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>6203</td>\n",
       "      <td>622357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5503</td>\n",
       "      <td>14584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6212</td>\n",
       "      <td>36227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2106</td>\n",
       "      <td>8554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6204</td>\n",
       "      <td>12659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>6200</td>\n",
       "      <td>457191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6105</td>\n",
       "      <td>37639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2100</td>\n",
       "      <td>60858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1901</td>\n",
       "      <td>212156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>2313</td>\n",
       "      <td>122260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>2418</td>\n",
       "      <td>8567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>5402</td>\n",
       "      <td>12875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>2305</td>\n",
       "      <td>51750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>2308</td>\n",
       "      <td>42043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>3606</td>\n",
       "      <td>66240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>4801</td>\n",
       "      <td>182113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2310</td>\n",
       "      <td>144858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>3602</td>\n",
       "      <td>13071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>3600</td>\n",
       "      <td>898342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>5001</td>\n",
       "      <td>5480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>5003</td>\n",
       "      <td>336838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>3608</td>\n",
       "      <td>50450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>2404</td>\n",
       "      <td>19474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>3501</td>\n",
       "      <td>15651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>3603</td>\n",
       "      <td>32729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>3607</td>\n",
       "      <td>7571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>3609</td>\n",
       "      <td>80607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>5007</td>\n",
       "      <td>168583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>3611</td>\n",
       "      <td>12551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>5201</td>\n",
       "      <td>18993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>3601</td>\n",
       "      <td>109944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>3605</td>\n",
       "      <td>10450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>5008</td>\n",
       "      <td>12263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>6102</td>\n",
       "      <td>145102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>5203</td>\n",
       "      <td>38468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>5202</td>\n",
       "      <td>16612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>6106</td>\n",
       "      <td>78132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>2303</td>\n",
       "      <td>11313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2301</td>\n",
       "      <td>34142</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>173 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Major_code  Grad_employed\n",
       "0          5601           7098\n",
       "1          6004          40492\n",
       "2          6211          18368\n",
       "3          2201           3590\n",
       "4          2001           7512\n",
       "5          3201           1008\n",
       "6          6206         151570\n",
       "7          1101          13104\n",
       "8          2101           4716\n",
       "9          1904          28517\n",
       "10         6005          19059\n",
       "11         5701           1984\n",
       "12         2504           4442\n",
       "13         1903          35939\n",
       "14         5901          20035\n",
       "15         2107           9037\n",
       "16         6299          17691\n",
       "17         2599          12433\n",
       "18         2503          14752\n",
       "19         6099           1100\n",
       "20         5301         154146\n",
       "21         6203         622357\n",
       "22         5503          14584\n",
       "23         6212          36227\n",
       "24         2106           8554\n",
       "25         6204          12659\n",
       "26         6200         457191\n",
       "27         6105          37639\n",
       "28         2100          60858\n",
       "29         1901         212156\n",
       "..          ...            ...\n",
       "143        2313         122260\n",
       "144        2418           8567\n",
       "145        5402          12875\n",
       "146        2305          51750\n",
       "147        2308          42043\n",
       "148        3606          66240\n",
       "149        4801         182113\n",
       "150        2310         144858\n",
       "151        3602          13071\n",
       "152        3600         898342\n",
       "153        5001           5480\n",
       "154        5003         336838\n",
       "155        3608          50450\n",
       "156        2404          19474\n",
       "157        3501          15651\n",
       "158        3603          32729\n",
       "159        3607           7571\n",
       "160        3609          80607\n",
       "161        5007         168583\n",
       "162        3611          12551\n",
       "163        5201          18993\n",
       "164        3601         109944\n",
       "165        3605          10450\n",
       "166        5008          12263\n",
       "167        6102         145102\n",
       "168        5203          38468\n",
       "169        5202          16612\n",
       "170        6106          78132\n",
       "171        2303          11313\n",
       "172        2301          34142\n",
       "\n",
       "[173 rows x 2 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grad_students[['Major_code', 'Grad_employed']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4: Assignments & Comparisons\n",
    "Adding a new column\n",
    "\n",
    "Adding a new column with values is as easy as a variable assignment. To add a new column of percentage of employed grads:\n",
    "\n",
    "grad_students['emp_percent'] = (grad_students.Grad_employed/grad_students.Grad_total) * 100.0\n",
    "Comparisons\n",
    "\n",
    "To determine those rows where sample size is greater than 200,\n",
    "\n",
    "grad_students[grad_students.Grad_sample_size > 200]\n",
    "\n",
    "## 4. Exercise\n",
    "\n",
    "#### Instructions\n",
    "* List the Major Category of all the data where the employment percentage is greater than 80%.\n",
    "* Assign it to the variable major_emp_data and print it out."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Grad_total</th>\n",
       "      <th>Grad_sample_size</th>\n",
       "      <th>Grad_employed</th>\n",
       "      <th>Grad_full_time_year_round</th>\n",
       "      <th>Grad_unemployed</th>\n",
       "      <th>Grad_unemployment_rate</th>\n",
       "      <th>Grad_median</th>\n",
       "      <th>...</th>\n",
       "      <th>Nongrad_employed</th>\n",
       "      <th>Nongrad_full_time_year_round</th>\n",
       "      <th>Nongrad_unemployed</th>\n",
       "      <th>Nongrad_unemployment_rate</th>\n",
       "      <th>Nongrad_median</th>\n",
       "      <th>Nongrad_P25</th>\n",
       "      <th>Nongrad_P75</th>\n",
       "      <th>Grad_share</th>\n",
       "      <th>Grad_premium</th>\n",
       "      <th>emp_percent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2001</td>\n",
       "      <td>COMMUNICATION TECHNOLOGIES</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>9109</td>\n",
       "      <td>171</td>\n",
       "      <td>7512</td>\n",
       "      <td>5622</td>\n",
       "      <td>466</td>\n",
       "      <td>0.058411</td>\n",
       "      <td>57000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43163</td>\n",
       "      <td>34231</td>\n",
       "      <td>3389</td>\n",
       "      <td>0.072800</td>\n",
       "      <td>52000.0</td>\n",
       "      <td>36000</td>\n",
       "      <td>78000.0</td>\n",
       "      <td>0.144753</td>\n",
       "      <td>0.096154</td>\n",
       "      <td>82.467889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2101</td>\n",
       "      <td>COMPUTER PROGRAMMING AND DATA PROCESSING</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>5611</td>\n",
       "      <td>98</td>\n",
       "      <td>4716</td>\n",
       "      <td>3981</td>\n",
       "      <td>119</td>\n",
       "      <td>0.024612</td>\n",
       "      <td>85000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>22024</td>\n",
       "      <td>18381</td>\n",
       "      <td>2222</td>\n",
       "      <td>0.091644</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>40000</td>\n",
       "      <td>85000.0</td>\n",
       "      <td>0.165394</td>\n",
       "      <td>0.416667</td>\n",
       "      <td>84.049189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1904</td>\n",
       "      <td>ADVERTISING AND PUBLIC RELATIONS</td>\n",
       "      <td>Communications &amp; Journalism</td>\n",
       "      <td>33928</td>\n",
       "      <td>688</td>\n",
       "      <td>28517</td>\n",
       "      <td>22523</td>\n",
       "      <td>899</td>\n",
       "      <td>0.030562</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>127832</td>\n",
       "      <td>100330</td>\n",
       "      <td>8706</td>\n",
       "      <td>0.063762</td>\n",
       "      <td>51000.0</td>\n",
       "      <td>37800</td>\n",
       "      <td>78000.0</td>\n",
       "      <td>0.171907</td>\n",
       "      <td>0.176471</td>\n",
       "      <td>84.051521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1903</td>\n",
       "      <td>MASS MEDIA</td>\n",
       "      <td>Communications &amp; Journalism</td>\n",
       "      <td>42915</td>\n",
       "      <td>828</td>\n",
       "      <td>35939</td>\n",
       "      <td>28054</td>\n",
       "      <td>1957</td>\n",
       "      <td>0.051641</td>\n",
       "      <td>57000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>153722</td>\n",
       "      <td>117581</td>\n",
       "      <td>12816</td>\n",
       "      <td>0.076955</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>35000</td>\n",
       "      <td>72000.0</td>\n",
       "      <td>0.184236</td>\n",
       "      <td>0.140000</td>\n",
       "      <td>83.744611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2107</td>\n",
       "      <td>COMPUTER NETWORKING AND TELECOMMUNICATIONS</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>11165</td>\n",
       "      <td>218</td>\n",
       "      <td>9037</td>\n",
       "      <td>7988</td>\n",
       "      <td>803</td>\n",
       "      <td>0.081606</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>41552</td>\n",
       "      <td>34402</td>\n",
       "      <td>2476</td>\n",
       "      <td>0.056237</td>\n",
       "      <td>58000.0</td>\n",
       "      <td>37700</td>\n",
       "      <td>84000.0</td>\n",
       "      <td>0.186266</td>\n",
       "      <td>0.379310</td>\n",
       "      <td>80.940439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2599</td>\n",
       "      <td>MISCELLANEOUS ENGINEERING TECHNOLOGIES</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>14816</td>\n",
       "      <td>315</td>\n",
       "      <td>12433</td>\n",
       "      <td>11146</td>\n",
       "      <td>407</td>\n",
       "      <td>0.031698</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>50092</td>\n",
       "      <td>44199</td>\n",
       "      <td>3316</td>\n",
       "      <td>0.062088</td>\n",
       "      <td>65000.0</td>\n",
       "      <td>43000</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>0.196533</td>\n",
       "      <td>0.230769</td>\n",
       "      <td>83.916037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5301</td>\n",
       "      <td>CRIMINAL JUSTICE AND FIRE PROTECTION</td>\n",
       "      <td>Law &amp; Public Policy</td>\n",
       "      <td>188228</td>\n",
       "      <td>3794</td>\n",
       "      <td>154146</td>\n",
       "      <td>133549</td>\n",
       "      <td>6591</td>\n",
       "      <td>0.041005</td>\n",
       "      <td>68000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>565748</td>\n",
       "      <td>490943</td>\n",
       "      <td>29133</td>\n",
       "      <td>0.048973</td>\n",
       "      <td>52000.0</td>\n",
       "      <td>36000</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.213027</td>\n",
       "      <td>0.307692</td>\n",
       "      <td>81.893236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>6212</td>\n",
       "      <td>MANAGEMENT INFORMATION SYSTEMS AND STATISTICS</td>\n",
       "      <td>Business</td>\n",
       "      <td>41970</td>\n",
       "      <td>963</td>\n",
       "      <td>36227</td>\n",
       "      <td>32121</td>\n",
       "      <td>1459</td>\n",
       "      <td>0.038715</td>\n",
       "      <td>89000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>129179</td>\n",
       "      <td>115177</td>\n",
       "      <td>5690</td>\n",
       "      <td>0.042189</td>\n",
       "      <td>72000.0</td>\n",
       "      <td>50000</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.218503</td>\n",
       "      <td>0.236111</td>\n",
       "      <td>86.316416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2106</td>\n",
       "      <td>COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>10290</td>\n",
       "      <td>194</td>\n",
       "      <td>8554</td>\n",
       "      <td>7581</td>\n",
       "      <td>542</td>\n",
       "      <td>0.059587</td>\n",
       "      <td>81000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>29740</td>\n",
       "      <td>26303</td>\n",
       "      <td>2102</td>\n",
       "      <td>0.066013</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>41600</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>0.222858</td>\n",
       "      <td>0.350000</td>\n",
       "      <td>83.129252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>6204</td>\n",
       "      <td>OPERATIONS LOGISTICS AND E-COMMERCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>15056</td>\n",
       "      <td>335</td>\n",
       "      <td>12659</td>\n",
       "      <td>10861</td>\n",
       "      <td>296</td>\n",
       "      <td>0.022848</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43074</td>\n",
       "      <td>38454</td>\n",
       "      <td>1827</td>\n",
       "      <td>0.040690</td>\n",
       "      <td>66000.0</td>\n",
       "      <td>46800</td>\n",
       "      <td>92000.0</td>\n",
       "      <td>0.224385</td>\n",
       "      <td>0.424242</td>\n",
       "      <td>84.079437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>6105</td>\n",
       "      <td>MEDICAL TECHNOLOGIES TECHNICIANS</td>\n",
       "      <td>Health</td>\n",
       "      <td>47029</td>\n",
       "      <td>942</td>\n",
       "      <td>37639</td>\n",
       "      <td>29892</td>\n",
       "      <td>987</td>\n",
       "      <td>0.025553</td>\n",
       "      <td>76000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>117087</td>\n",
       "      <td>89592</td>\n",
       "      <td>4193</td>\n",
       "      <td>0.034573</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>45900</td>\n",
       "      <td>77000.0</td>\n",
       "      <td>0.227780</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>80.033596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2100</td>\n",
       "      <td>COMPUTER AND INFORMATION SYSTEMS</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>71527</td>\n",
       "      <td>1425</td>\n",
       "      <td>60858</td>\n",
       "      <td>53807</td>\n",
       "      <td>2539</td>\n",
       "      <td>0.040049</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>209994</td>\n",
       "      <td>184959</td>\n",
       "      <td>10439</td>\n",
       "      <td>0.047357</td>\n",
       "      <td>65000.0</td>\n",
       "      <td>45000</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>0.227996</td>\n",
       "      <td>0.230769</td>\n",
       "      <td>85.083954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>6202</td>\n",
       "      <td>ACTUARIAL SCIENCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>2472</td>\n",
       "      <td>56</td>\n",
       "      <td>2020</td>\n",
       "      <td>1725</td>\n",
       "      <td>162</td>\n",
       "      <td>0.074244</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6666</td>\n",
       "      <td>6040</td>\n",
       "      <td>266</td>\n",
       "      <td>0.038373</td>\n",
       "      <td>76000.0</td>\n",
       "      <td>53000</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>0.236103</td>\n",
       "      <td>0.447368</td>\n",
       "      <td>81.715210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2500</td>\n",
       "      <td>ENGINEERING TECHNOLOGIES</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>11724</td>\n",
       "      <td>219</td>\n",
       "      <td>9471</td>\n",
       "      <td>7958</td>\n",
       "      <td>450</td>\n",
       "      <td>0.045358</td>\n",
       "      <td>74000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>29092</td>\n",
       "      <td>25129</td>\n",
       "      <td>1475</td>\n",
       "      <td>0.048255</td>\n",
       "      <td>65000.0</td>\n",
       "      <td>40000</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>0.245704</td>\n",
       "      <td>0.138462</td>\n",
       "      <td>80.783009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2105</td>\n",
       "      <td>INFORMATION SCIENCES</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>25799</td>\n",
       "      <td>551</td>\n",
       "      <td>22403</td>\n",
       "      <td>19028</td>\n",
       "      <td>1179</td>\n",
       "      <td>0.049996</td>\n",
       "      <td>84000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>63354</td>\n",
       "      <td>55946</td>\n",
       "      <td>3333</td>\n",
       "      <td>0.049980</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>48500</td>\n",
       "      <td>96000.0</td>\n",
       "      <td>0.258323</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>86.836699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>4000</td>\n",
       "      <td>MULTI/INTERDISCIPLINARY STUDIES</td>\n",
       "      <td>Interdisciplinary</td>\n",
       "      <td>14405</td>\n",
       "      <td>318</td>\n",
       "      <td>12708</td>\n",
       "      <td>9639</td>\n",
       "      <td>261</td>\n",
       "      <td>0.020125</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>32600</td>\n",
       "      <td>24260</td>\n",
       "      <td>2573</td>\n",
       "      <td>0.073153</td>\n",
       "      <td>44000.0</td>\n",
       "      <td>34200</td>\n",
       "      <td>58000.0</td>\n",
       "      <td>0.259910</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>88.219368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>5102</td>\n",
       "      <td>NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL ...</td>\n",
       "      <td>Physical Sciences</td>\n",
       "      <td>3910</td>\n",
       "      <td>65</td>\n",
       "      <td>3129</td>\n",
       "      <td>2565</td>\n",
       "      <td>28</td>\n",
       "      <td>0.008869</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8699</td>\n",
       "      <td>6701</td>\n",
       "      <td>605</td>\n",
       "      <td>0.065026</td>\n",
       "      <td>64000.0</td>\n",
       "      <td>45000</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>0.261032</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>80.025575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>5403</td>\n",
       "      <td>HUMAN SERVICES AND COMMUNITY ORGANIZATION</td>\n",
       "      <td>Psychology &amp; Social Work</td>\n",
       "      <td>29262</td>\n",
       "      <td>555</td>\n",
       "      <td>23537</td>\n",
       "      <td>18213</td>\n",
       "      <td>1504</td>\n",
       "      <td>0.060061</td>\n",
       "      <td>50100.0</td>\n",
       "      <td>...</td>\n",
       "      <td>58298</td>\n",
       "      <td>43307</td>\n",
       "      <td>4625</td>\n",
       "      <td>0.073503</td>\n",
       "      <td>38700.0</td>\n",
       "      <td>30000</td>\n",
       "      <td>53000.0</td>\n",
       "      <td>0.272542</td>\n",
       "      <td>0.294574</td>\n",
       "      <td>80.435377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>6003</td>\n",
       "      <td>VISUAL AND PERFORMING ARTS</td>\n",
       "      <td>Arts</td>\n",
       "      <td>18324</td>\n",
       "      <td>275</td>\n",
       "      <td>14841</td>\n",
       "      <td>9671</td>\n",
       "      <td>593</td>\n",
       "      <td>0.038422</td>\n",
       "      <td>53000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>36008</td>\n",
       "      <td>21969</td>\n",
       "      <td>3729</td>\n",
       "      <td>0.093842</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>28000</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>0.274016</td>\n",
       "      <td>0.325000</td>\n",
       "      <td>80.992141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>4101</td>\n",
       "      <td>PHYSICAL FITNESS PARKS RECREATION AND LEISURE</td>\n",
       "      <td>Industrial Arts &amp; Consumer Services</td>\n",
       "      <td>119489</td>\n",
       "      <td>2423</td>\n",
       "      <td>103790</td>\n",
       "      <td>80196</td>\n",
       "      <td>2696</td>\n",
       "      <td>0.025318</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>245267</td>\n",
       "      <td>186901</td>\n",
       "      <td>10704</td>\n",
       "      <td>0.041817</td>\n",
       "      <td>45000.0</td>\n",
       "      <td>33700</td>\n",
       "      <td>64000.0</td>\n",
       "      <td>0.286964</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>86.861552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>6207</td>\n",
       "      <td>FINANCE</td>\n",
       "      <td>Business</td>\n",
       "      <td>301650</td>\n",
       "      <td>6319</td>\n",
       "      <td>252242</td>\n",
       "      <td>221486</td>\n",
       "      <td>11635</td>\n",
       "      <td>0.044093</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>615192</td>\n",
       "      <td>528057</td>\n",
       "      <td>28844</td>\n",
       "      <td>0.044786</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>45000</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.287957</td>\n",
       "      <td>0.357143</td>\n",
       "      <td>83.620753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2102</td>\n",
       "      <td>COMPUTER SCIENCE</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>324402</td>\n",
       "      <td>6674</td>\n",
       "      <td>281088</td>\n",
       "      <td>243500</td>\n",
       "      <td>10557</td>\n",
       "      <td>0.036198</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>623930</td>\n",
       "      <td>544970</td>\n",
       "      <td>31060</td>\n",
       "      <td>0.047421</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>52000</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>0.304893</td>\n",
       "      <td>0.187500</td>\n",
       "      <td>86.648048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>1301</td>\n",
       "      <td>ENVIRONMENTAL SCIENCE</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>43612</td>\n",
       "      <td>925</td>\n",
       "      <td>38068</td>\n",
       "      <td>29568</td>\n",
       "      <td>1392</td>\n",
       "      <td>0.035276</td>\n",
       "      <td>68000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>78828</td>\n",
       "      <td>61721</td>\n",
       "      <td>3837</td>\n",
       "      <td>0.046416</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>40000</td>\n",
       "      <td>76000.0</td>\n",
       "      <td>0.315764</td>\n",
       "      <td>0.236364</td>\n",
       "      <td>87.287902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>3604</td>\n",
       "      <td>ECOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>21535</td>\n",
       "      <td>465</td>\n",
       "      <td>17793</td>\n",
       "      <td>13713</td>\n",
       "      <td>677</td>\n",
       "      <td>0.036654</td>\n",
       "      <td>62000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>33531</td>\n",
       "      <td>24530</td>\n",
       "      <td>1665</td>\n",
       "      <td>0.047307</td>\n",
       "      <td>48700.0</td>\n",
       "      <td>33000</td>\n",
       "      <td>74000.0</td>\n",
       "      <td>0.341473</td>\n",
       "      <td>0.273101</td>\n",
       "      <td>82.623636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2407</td>\n",
       "      <td>COMPUTER ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>82102</td>\n",
       "      <td>1806</td>\n",
       "      <td>73147</td>\n",
       "      <td>65371</td>\n",
       "      <td>1592</td>\n",
       "      <td>0.021301</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>119738</td>\n",
       "      <td>106089</td>\n",
       "      <td>6639</td>\n",
       "      <td>0.052533</td>\n",
       "      <td>81000.0</td>\n",
       "      <td>60000</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>0.367557</td>\n",
       "      <td>0.197531</td>\n",
       "      <td>89.092836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>1103</td>\n",
       "      <td>ANIMAL SCIENCES</td>\n",
       "      <td>Agriculture &amp; Natural Resources</td>\n",
       "      <td>56807</td>\n",
       "      <td>1335</td>\n",
       "      <td>47755</td>\n",
       "      <td>39047</td>\n",
       "      <td>596</td>\n",
       "      <td>0.012327</td>\n",
       "      <td>70300.0</td>\n",
       "      <td>...</td>\n",
       "      <td>74896</td>\n",
       "      <td>61629</td>\n",
       "      <td>3101</td>\n",
       "      <td>0.039758</td>\n",
       "      <td>48000.0</td>\n",
       "      <td>32000</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.374427</td>\n",
       "      <td>0.464583</td>\n",
       "      <td>84.065344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>6109</td>\n",
       "      <td>TREATMENT THERAPY PROFESSIONS</td>\n",
       "      <td>Health</td>\n",
       "      <td>142285</td>\n",
       "      <td>2607</td>\n",
       "      <td>123279</td>\n",
       "      <td>91011</td>\n",
       "      <td>2185</td>\n",
       "      <td>0.017415</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>187311</td>\n",
       "      <td>123316</td>\n",
       "      <td>4158</td>\n",
       "      <td>0.021716</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>42000</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>0.377377</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>86.642302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>4005</td>\n",
       "      <td>MATHEMATICS AND COMPUTER SCIENCE</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>4810</td>\n",
       "      <td>103</td>\n",
       "      <td>3880</td>\n",
       "      <td>3045</td>\n",
       "      <td>445</td>\n",
       "      <td>0.102890</td>\n",
       "      <td>98000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5711</td>\n",
       "      <td>5020</td>\n",
       "      <td>150</td>\n",
       "      <td>0.025593</td>\n",
       "      <td>92000.0</td>\n",
       "      <td>53000</td>\n",
       "      <td>136000.0</td>\n",
       "      <td>0.407420</td>\n",
       "      <td>0.065217</td>\n",
       "      <td>80.665281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>6100</td>\n",
       "      <td>GENERAL MEDICAL AND HEALTH SERVICES</td>\n",
       "      <td>Health</td>\n",
       "      <td>64284</td>\n",
       "      <td>1172</td>\n",
       "      <td>54355</td>\n",
       "      <td>42137</td>\n",
       "      <td>1226</td>\n",
       "      <td>0.022058</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69217</td>\n",
       "      <td>50755</td>\n",
       "      <td>3592</td>\n",
       "      <td>0.049335</td>\n",
       "      <td>52000.0</td>\n",
       "      <td>37000</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.416199</td>\n",
       "      <td>0.346154</td>\n",
       "      <td>84.554477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>4001</td>\n",
       "      <td>INTERCULTURAL AND INTERNATIONAL STUDIES</td>\n",
       "      <td>Humanities &amp; Liberal Arts</td>\n",
       "      <td>32549</td>\n",
       "      <td>600</td>\n",
       "      <td>26153</td>\n",
       "      <td>18746</td>\n",
       "      <td>1786</td>\n",
       "      <td>0.063925</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>34373</td>\n",
       "      <td>24209</td>\n",
       "      <td>2680</td>\n",
       "      <td>0.072329</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>32000</td>\n",
       "      <td>72000.0</td>\n",
       "      <td>0.419111</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>80.349627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>6108</td>\n",
       "      <td>PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTR...</td>\n",
       "      <td>Health</td>\n",
       "      <td>152238</td>\n",
       "      <td>2872</td>\n",
       "      <td>124688</td>\n",
       "      <td>97680</td>\n",
       "      <td>3174</td>\n",
       "      <td>0.024824</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>120500</td>\n",
       "      <td>88001</td>\n",
       "      <td>4110</td>\n",
       "      <td>0.032983</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>80000</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>0.467511</td>\n",
       "      <td>0.037383</td>\n",
       "      <td>81.903336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>3701</td>\n",
       "      <td>APPLIED MATHEMATICS</td>\n",
       "      <td>Computers &amp; Mathematics</td>\n",
       "      <td>17075</td>\n",
       "      <td>386</td>\n",
       "      <td>14113</td>\n",
       "      <td>11699</td>\n",
       "      <td>416</td>\n",
       "      <td>0.028632</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>13704</td>\n",
       "      <td>11253</td>\n",
       "      <td>773</td>\n",
       "      <td>0.053395</td>\n",
       "      <td>76000.0</td>\n",
       "      <td>48000</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>0.497074</td>\n",
       "      <td>0.315789</td>\n",
       "      <td>82.653001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2410</td>\n",
       "      <td>ENVIRONMENTAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>11722</td>\n",
       "      <td>252</td>\n",
       "      <td>9387</td>\n",
       "      <td>8183</td>\n",
       "      <td>450</td>\n",
       "      <td>0.045746</td>\n",
       "      <td>81000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8641</td>\n",
       "      <td>7475</td>\n",
       "      <td>304</td>\n",
       "      <td>0.033985</td>\n",
       "      <td>71900.0</td>\n",
       "      <td>55000</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.516228</td>\n",
       "      <td>0.126565</td>\n",
       "      <td>80.080191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>3699</td>\n",
       "      <td>MISCELLANEOUS BIOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>27744</td>\n",
       "      <td>553</td>\n",
       "      <td>22488</td>\n",
       "      <td>17787</td>\n",
       "      <td>597</td>\n",
       "      <td>0.025861</td>\n",
       "      <td>65000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>19978</td>\n",
       "      <td>15600</td>\n",
       "      <td>802</td>\n",
       "      <td>0.038595</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>35000</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.520086</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>81.055363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>5005</td>\n",
       "      <td>GEOSCIENCES</td>\n",
       "      <td>Physical Sciences</td>\n",
       "      <td>9006</td>\n",
       "      <td>204</td>\n",
       "      <td>7443</td>\n",
       "      <td>6200</td>\n",
       "      <td>134</td>\n",
       "      <td>0.017685</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5920</td>\n",
       "      <td>4890</td>\n",
       "      <td>238</td>\n",
       "      <td>0.038649</td>\n",
       "      <td>58000.0</td>\n",
       "      <td>38000</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>0.530295</td>\n",
       "      <td>0.551724</td>\n",
       "      <td>82.644903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>4006</td>\n",
       "      <td>COGNITIVE SCIENCE AND BIOPSYCHOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>5982</td>\n",
       "      <td>118</td>\n",
       "      <td>5032</td>\n",
       "      <td>3879</td>\n",
       "      <td>239</td>\n",
       "      <td>0.045342</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4206</td>\n",
       "      <td>3116</td>\n",
       "      <td>184</td>\n",
       "      <td>0.041913</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>40000</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>0.537080</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>84.119024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>2418</td>\n",
       "      <td>NUCLEAR ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>10520</td>\n",
       "      <td>243</td>\n",
       "      <td>8567</td>\n",
       "      <td>8018</td>\n",
       "      <td>100</td>\n",
       "      <td>0.011538</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6730</td>\n",
       "      <td>6258</td>\n",
       "      <td>144</td>\n",
       "      <td>0.020949</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>65000</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>0.547688</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>81.435361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>5402</td>\n",
       "      <td>PUBLIC POLICY</td>\n",
       "      <td>Law &amp; Public Policy</td>\n",
       "      <td>15284</td>\n",
       "      <td>338</td>\n",
       "      <td>12875</td>\n",
       "      <td>10988</td>\n",
       "      <td>415</td>\n",
       "      <td>0.031226</td>\n",
       "      <td>89000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9478</td>\n",
       "      <td>7456</td>\n",
       "      <td>441</td>\n",
       "      <td>0.044460</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>41800</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>0.556956</td>\n",
       "      <td>0.412698</td>\n",
       "      <td>84.238419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>3600</td>\n",
       "      <td>BIOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>1085977</td>\n",
       "      <td>21994</td>\n",
       "      <td>898342</td>\n",
       "      <td>703347</td>\n",
       "      <td>19368</td>\n",
       "      <td>0.021105</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>512669</td>\n",
       "      <td>394936</td>\n",
       "      <td>28639</td>\n",
       "      <td>0.052907</td>\n",
       "      <td>54000.0</td>\n",
       "      <td>37000</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>0.601913</td>\n",
       "      <td>0.759259</td>\n",
       "      <td>82.722010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>5001</td>\n",
       "      <td>ASTRONOMY AND ASTROPHYSICS</td>\n",
       "      <td>Physical Sciences</td>\n",
       "      <td>6331</td>\n",
       "      <td>136</td>\n",
       "      <td>5480</td>\n",
       "      <td>4548</td>\n",
       "      <td>112</td>\n",
       "      <td>0.020029</td>\n",
       "      <td>96000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2720</td>\n",
       "      <td>2163</td>\n",
       "      <td>298</td>\n",
       "      <td>0.098741</td>\n",
       "      <td>85000.0</td>\n",
       "      <td>56000</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>0.618866</td>\n",
       "      <td>0.129412</td>\n",
       "      <td>86.558206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>3608</td>\n",
       "      <td>PHYSIOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>59363</td>\n",
       "      <td>1155</td>\n",
       "      <td>50450</td>\n",
       "      <td>38252</td>\n",
       "      <td>1078</td>\n",
       "      <td>0.020921</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>25501</td>\n",
       "      <td>18261</td>\n",
       "      <td>1284</td>\n",
       "      <td>0.047937</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>35000</td>\n",
       "      <td>78000.0</td>\n",
       "      <td>0.630301</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>84.985597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>2404</td>\n",
       "      <td>BIOMEDICAL ENGINEERING</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>22155</td>\n",
       "      <td>475</td>\n",
       "      <td>19474</td>\n",
       "      <td>16845</td>\n",
       "      <td>366</td>\n",
       "      <td>0.018448</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9626</td>\n",
       "      <td>8051</td>\n",
       "      <td>547</td>\n",
       "      <td>0.053770</td>\n",
       "      <td>70000.0</td>\n",
       "      <td>48000</td>\n",
       "      <td>104000.0</td>\n",
       "      <td>0.641858</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>87.898894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>3603</td>\n",
       "      <td>MOLECULAR BIOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>37872</td>\n",
       "      <td>875</td>\n",
       "      <td>32729</td>\n",
       "      <td>26944</td>\n",
       "      <td>950</td>\n",
       "      <td>0.028207</td>\n",
       "      <td>85000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>15914</td>\n",
       "      <td>11602</td>\n",
       "      <td>679</td>\n",
       "      <td>0.040921</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>31000</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.648094</td>\n",
       "      <td>0.700000</td>\n",
       "      <td>86.420046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>3607</td>\n",
       "      <td>PHARMACOLOGY</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>8853</td>\n",
       "      <td>168</td>\n",
       "      <td>7571</td>\n",
       "      <td>6238</td>\n",
       "      <td>188</td>\n",
       "      <td>0.024230</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3126</td>\n",
       "      <td>2463</td>\n",
       "      <td>57</td>\n",
       "      <td>0.017908</td>\n",
       "      <td>66000.0</td>\n",
       "      <td>38000</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>0.662699</td>\n",
       "      <td>0.590909</td>\n",
       "      <td>85.519033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>3611</td>\n",
       "      <td>NEUROSCIENCE</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>14429</td>\n",
       "      <td>286</td>\n",
       "      <td>12551</td>\n",
       "      <td>10044</td>\n",
       "      <td>225</td>\n",
       "      <td>0.017611</td>\n",
       "      <td>58000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4802</td>\n",
       "      <td>3580</td>\n",
       "      <td>360</td>\n",
       "      <td>0.069740</td>\n",
       "      <td>40000.0</td>\n",
       "      <td>30000</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>0.673560</td>\n",
       "      <td>0.450000</td>\n",
       "      <td>86.984545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>3601</td>\n",
       "      <td>BIOCHEMICAL SCIENCES</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>128892</td>\n",
       "      <td>2765</td>\n",
       "      <td>109944</td>\n",
       "      <td>90589</td>\n",
       "      <td>2728</td>\n",
       "      <td>0.024212</td>\n",
       "      <td>96000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>43165</td>\n",
       "      <td>34108</td>\n",
       "      <td>2888</td>\n",
       "      <td>0.062710</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>36000</td>\n",
       "      <td>85000.0</td>\n",
       "      <td>0.687637</td>\n",
       "      <td>0.745455</td>\n",
       "      <td>85.299320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>3605</td>\n",
       "      <td>GENETICS</td>\n",
       "      <td>Biology &amp; Life Science</td>\n",
       "      <td>12106</td>\n",
       "      <td>261</td>\n",
       "      <td>10450</td>\n",
       "      <td>9060</td>\n",
       "      <td>207</td>\n",
       "      <td>0.019424</td>\n",
       "      <td>78000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4020</td>\n",
       "      <td>3187</td>\n",
       "      <td>192</td>\n",
       "      <td>0.045584</td>\n",
       "      <td>56000.0</td>\n",
       "      <td>36000</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>0.697310</td>\n",
       "      <td>0.392857</td>\n",
       "      <td>86.320833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>5008</td>\n",
       "      <td>MATERIALS SCIENCE</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>14184</td>\n",
       "      <td>299</td>\n",
       "      <td>12263</td>\n",
       "      <td>9894</td>\n",
       "      <td>273</td>\n",
       "      <td>0.021777</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4619</td>\n",
       "      <td>4001</td>\n",
       "      <td>134</td>\n",
       "      <td>0.028193</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>65000</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>0.715388</td>\n",
       "      <td>0.187500</td>\n",
       "      <td>86.456571</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>48 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Major_code                                              Major  \\\n",
       "4          2001                         COMMUNICATION TECHNOLOGIES   \n",
       "8          2101           COMPUTER PROGRAMMING AND DATA PROCESSING   \n",
       "9          1904                   ADVERTISING AND PUBLIC RELATIONS   \n",
       "13         1903                                         MASS MEDIA   \n",
       "15         2107         COMPUTER NETWORKING AND TELECOMMUNICATIONS   \n",
       "17         2599             MISCELLANEOUS ENGINEERING TECHNOLOGIES   \n",
       "20         5301               CRIMINAL JUSTICE AND FIRE PROTECTION   \n",
       "23         6212      MANAGEMENT INFORMATION SYSTEMS AND STATISTICS   \n",
       "24         2106    COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY   \n",
       "25         6204                OPERATIONS LOGISTICS AND E-COMMERCE   \n",
       "27         6105                   MEDICAL TECHNOLOGIES TECHNICIANS   \n",
       "28         2100                   COMPUTER AND INFORMATION SYSTEMS   \n",
       "30         6202                                  ACTUARIAL SCIENCE   \n",
       "34         2500                           ENGINEERING TECHNOLOGIES   \n",
       "38         2105                               INFORMATION SCIENCES   \n",
       "40         4000                    MULTI/INTERDISCIPLINARY STUDIES   \n",
       "41         5102  NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL ...   \n",
       "45         5403          HUMAN SERVICES AND COMMUNITY ORGANIZATION   \n",
       "46         6003                         VISUAL AND PERFORMING ARTS   \n",
       "50         4101      PHYSICAL FITNESS PARKS RECREATION AND LEISURE   \n",
       "51         6207                                            FINANCE   \n",
       "60         2102                                   COMPUTER SCIENCE   \n",
       "63         1301                              ENVIRONMENTAL SCIENCE   \n",
       "66         3604                                            ECOLOGY   \n",
       "74         2407                               COMPUTER ENGINEERING   \n",
       "79         1103                                    ANIMAL SCIENCES   \n",
       "80         6109                      TREATMENT THERAPY PROFESSIONS   \n",
       "89         4005                   MATHEMATICS AND COMPUTER SCIENCE   \n",
       "92         6100                GENERAL MEDICAL AND HEALTH SERVICES   \n",
       "93         4001            INTERCULTURAL AND INTERNATIONAL STUDIES   \n",
       "117        6108  PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTR...   \n",
       "127        3701                                APPLIED MATHEMATICS   \n",
       "134        2410                          ENVIRONMENTAL ENGINEERING   \n",
       "135        3699                              MISCELLANEOUS BIOLOGY   \n",
       "139        5005                                        GEOSCIENCES   \n",
       "142        4006                COGNITIVE SCIENCE AND BIOPSYCHOLOGY   \n",
       "144        2418                                NUCLEAR ENGINEERING   \n",
       "145        5402                                      PUBLIC POLICY   \n",
       "152        3600                                            BIOLOGY   \n",
       "153        5001                         ASTRONOMY AND ASTROPHYSICS   \n",
       "155        3608                                         PHYSIOLOGY   \n",
       "156        2404                             BIOMEDICAL ENGINEERING   \n",
       "158        3603                                  MOLECULAR BIOLOGY   \n",
       "159        3607                                       PHARMACOLOGY   \n",
       "162        3611                                       NEUROSCIENCE   \n",
       "164        3601                               BIOCHEMICAL SCIENCES   \n",
       "165        3605                                           GENETICS   \n",
       "166        5008                                  MATERIALS SCIENCE   \n",
       "\n",
       "                          Major_category  Grad_total  Grad_sample_size  \\\n",
       "4                Computers & Mathematics        9109               171   \n",
       "8                Computers & Mathematics        5611                98   \n",
       "9            Communications & Journalism       33928               688   \n",
       "13           Communications & Journalism       42915               828   \n",
       "15               Computers & Mathematics       11165               218   \n",
       "17                           Engineering       14816               315   \n",
       "20                   Law & Public Policy      188228              3794   \n",
       "23                              Business       41970               963   \n",
       "24               Computers & Mathematics       10290               194   \n",
       "25                              Business       15056               335   \n",
       "27                                Health       47029               942   \n",
       "28               Computers & Mathematics       71527              1425   \n",
       "30                              Business        2472                56   \n",
       "34                           Engineering       11724               219   \n",
       "38               Computers & Mathematics       25799               551   \n",
       "40                     Interdisciplinary       14405               318   \n",
       "41                     Physical Sciences        3910                65   \n",
       "45              Psychology & Social Work       29262               555   \n",
       "46                                  Arts       18324               275   \n",
       "50   Industrial Arts & Consumer Services      119489              2423   \n",
       "51                              Business      301650              6319   \n",
       "60               Computers & Mathematics      324402              6674   \n",
       "63                Biology & Life Science       43612               925   \n",
       "66                Biology & Life Science       21535               465   \n",
       "74                           Engineering       82102              1806   \n",
       "79       Agriculture & Natural Resources       56807              1335   \n",
       "80                                Health      142285              2607   \n",
       "89               Computers & Mathematics        4810               103   \n",
       "92                                Health       64284              1172   \n",
       "93             Humanities & Liberal Arts       32549               600   \n",
       "117                               Health      152238              2872   \n",
       "127              Computers & Mathematics       17075               386   \n",
       "134                          Engineering       11722               252   \n",
       "135               Biology & Life Science       27744               553   \n",
       "139                    Physical Sciences        9006               204   \n",
       "142               Biology & Life Science        5982               118   \n",
       "144                          Engineering       10520               243   \n",
       "145                  Law & Public Policy       15284               338   \n",
       "152               Biology & Life Science     1085977             21994   \n",
       "153                    Physical Sciences        6331               136   \n",
       "155               Biology & Life Science       59363              1155   \n",
       "156                          Engineering       22155               475   \n",
       "158               Biology & Life Science       37872               875   \n",
       "159               Biology & Life Science        8853               168   \n",
       "162               Biology & Life Science       14429               286   \n",
       "164               Biology & Life Science      128892              2765   \n",
       "165               Biology & Life Science       12106               261   \n",
       "166                          Engineering       14184               299   \n",
       "\n",
       "     Grad_employed  Grad_full_time_year_round  Grad_unemployed  \\\n",
       "4             7512                       5622              466   \n",
       "8             4716                       3981              119   \n",
       "9            28517                      22523              899   \n",
       "13           35939                      28054             1957   \n",
       "15            9037                       7988              803   \n",
       "17           12433                      11146              407   \n",
       "20          154146                     133549             6591   \n",
       "23           36227                      32121             1459   \n",
       "24            8554                       7581              542   \n",
       "25           12659                      10861              296   \n",
       "27           37639                      29892              987   \n",
       "28           60858                      53807             2539   \n",
       "30            2020                       1725              162   \n",
       "34            9471                       7958              450   \n",
       "38           22403                      19028             1179   \n",
       "40           12708                       9639              261   \n",
       "41            3129                       2565               28   \n",
       "45           23537                      18213             1504   \n",
       "46           14841                       9671              593   \n",
       "50          103790                      80196             2696   \n",
       "51          252242                     221486            11635   \n",
       "60          281088                     243500            10557   \n",
       "63           38068                      29568             1392   \n",
       "66           17793                      13713              677   \n",
       "74           73147                      65371             1592   \n",
       "79           47755                      39047              596   \n",
       "80          123279                      91011             2185   \n",
       "89            3880                       3045              445   \n",
       "92           54355                      42137             1226   \n",
       "93           26153                      18746             1786   \n",
       "117         124688                      97680             3174   \n",
       "127          14113                      11699              416   \n",
       "134           9387                       8183              450   \n",
       "135          22488                      17787              597   \n",
       "139           7443                       6200              134   \n",
       "142           5032                       3879              239   \n",
       "144           8567                       8018              100   \n",
       "145          12875                      10988              415   \n",
       "152         898342                     703347            19368   \n",
       "153           5480                       4548              112   \n",
       "155          50450                      38252             1078   \n",
       "156          19474                      16845              366   \n",
       "158          32729                      26944              950   \n",
       "159           7571                       6238              188   \n",
       "162          12551                      10044              225   \n",
       "164         109944                      90589             2728   \n",
       "165          10450                       9060              207   \n",
       "166          12263                       9894              273   \n",
       "\n",
       "     Grad_unemployment_rate  Grad_median     ...       Nongrad_employed  \\\n",
       "4                  0.058411      57000.0     ...                  43163   \n",
       "8                  0.024612      85000.0     ...                  22024   \n",
       "9                  0.030562      60000.0     ...                 127832   \n",
       "13                 0.051641      57000.0     ...                 153722   \n",
       "15                 0.081606      80000.0     ...                  41552   \n",
       "17                 0.031698      80000.0     ...                  50092   \n",
       "20                 0.041005      68000.0     ...                 565748   \n",
       "23                 0.038715      89000.0     ...                 129179   \n",
       "24                 0.059587      81000.0     ...                  29740   \n",
       "25                 0.022848      94000.0     ...                  43074   \n",
       "27                 0.025553      76000.0     ...                 117087   \n",
       "28                 0.040049      80000.0     ...                 209994   \n",
       "30                 0.074244     110000.0     ...                   6666   \n",
       "34                 0.045358      74000.0     ...                  29092   \n",
       "38                 0.049996      84000.0     ...                  63354   \n",
       "40                 0.020125      55000.0     ...                  32600   \n",
       "41                 0.008869      80000.0     ...                   8699   \n",
       "45                 0.060061      50100.0     ...                  58298   \n",
       "46                 0.038422      53000.0     ...                  36008   \n",
       "50                 0.025318      60000.0     ...                 245267   \n",
       "51                 0.044093      95000.0     ...                 615192   \n",
       "60                 0.036198      95000.0     ...                 623930   \n",
       "63                 0.035276      68000.0     ...                  78828   \n",
       "66                 0.036654      62000.0     ...                  33531   \n",
       "74                 0.021301      97000.0     ...                 119738   \n",
       "79                 0.012327      70300.0     ...                  74896   \n",
       "80                 0.017415      70000.0     ...                 187311   \n",
       "89                 0.102890      98000.0     ...                   5711   \n",
       "92                 0.022058      70000.0     ...                  69217   \n",
       "93                 0.063925      70000.0     ...                  34373   \n",
       "117                0.024824     111000.0     ...                 120500   \n",
       "127                0.028632     100000.0     ...                  13704   \n",
       "134                0.045746      81000.0     ...                   8641   \n",
       "135                0.025861      65000.0     ...                  19978   \n",
       "139                0.017685      90000.0     ...                   5920   \n",
       "142                0.045342      95000.0     ...                   4206   \n",
       "144                0.011538     110000.0     ...                   6730   \n",
       "145                0.031226      89000.0     ...                   9478   \n",
       "152                0.021105      95000.0     ...                 512669   \n",
       "153                0.020029      96000.0     ...                   2720   \n",
       "155                0.020921      90000.0     ...                  25501   \n",
       "156                0.018448      90000.0     ...                   9626   \n",
       "158                0.028207      85000.0     ...                  15914   \n",
       "159                0.024230     105000.0     ...                   3126   \n",
       "162                0.017611      58000.0     ...                   4802   \n",
       "164                0.024212      96000.0     ...                  43165   \n",
       "165                0.019424      78000.0     ...                   4020   \n",
       "166                0.021777      95000.0     ...                   4619   \n",
       "\n",
       "     Nongrad_full_time_year_round  Nongrad_unemployed  \\\n",
       "4                           34231                3389   \n",
       "8                           18381                2222   \n",
       "9                          100330                8706   \n",
       "13                         117581               12816   \n",
       "15                          34402                2476   \n",
       "17                          44199                3316   \n",
       "20                         490943               29133   \n",
       "23                         115177                5690   \n",
       "24                          26303                2102   \n",
       "25                          38454                1827   \n",
       "27                          89592                4193   \n",
       "28                         184959               10439   \n",
       "30                           6040                 266   \n",
       "34                          25129                1475   \n",
       "38                          55946                3333   \n",
       "40                          24260                2573   \n",
       "41                           6701                 605   \n",
       "45                          43307                4625   \n",
       "46                          21969                3729   \n",
       "50                         186901               10704   \n",
       "51                         528057               28844   \n",
       "60                         544970               31060   \n",
       "63                          61721                3837   \n",
       "66                          24530                1665   \n",
       "74                         106089                6639   \n",
       "79                          61629                3101   \n",
       "80                         123316                4158   \n",
       "89                           5020                 150   \n",
       "92                          50755                3592   \n",
       "93                          24209                2680   \n",
       "117                         88001                4110   \n",
       "127                         11253                 773   \n",
       "134                          7475                 304   \n",
       "135                         15600                 802   \n",
       "139                          4890                 238   \n",
       "142                          3116                 184   \n",
       "144                          6258                 144   \n",
       "145                          7456                 441   \n",
       "152                        394936               28639   \n",
       "153                          2163                 298   \n",
       "155                         18261                1284   \n",
       "156                          8051                 547   \n",
       "158                         11602                 679   \n",
       "159                          2463                  57   \n",
       "162                          3580                 360   \n",
       "164                         34108                2888   \n",
       "165                          3187                 192   \n",
       "166                          4001                 134   \n",
       "\n",
       "     Nongrad_unemployment_rate  Nongrad_median  Nongrad_P25  Nongrad_P75  \\\n",
       "4                     0.072800         52000.0        36000      78000.0   \n",
       "8                     0.091644         60000.0        40000      85000.0   \n",
       "9                     0.063762         51000.0        37800      78000.0   \n",
       "13                    0.076955         50000.0        35000      72000.0   \n",
       "15                    0.056237         58000.0        37700      84000.0   \n",
       "17                    0.062088         65000.0        43000      90000.0   \n",
       "20                    0.048973         52000.0        36000      75000.0   \n",
       "23                    0.042189         72000.0        50000     100000.0   \n",
       "24                    0.066013         60000.0        41600      80000.0   \n",
       "25                    0.040690         66000.0        46800      92000.0   \n",
       "27                    0.034573         60000.0        45900      77000.0   \n",
       "28                    0.047357         65000.0        45000      90000.0   \n",
       "30                    0.038373         76000.0        53000     125000.0   \n",
       "34                    0.048255         65000.0        40000      94000.0   \n",
       "38                    0.049980         70000.0        48500      96000.0   \n",
       "40                    0.073153         44000.0        34200      58000.0   \n",
       "41                    0.065026         64000.0        45000      80000.0   \n",
       "45                    0.073503         38700.0        30000      53000.0   \n",
       "46                    0.093842         40000.0        28000      60000.0   \n",
       "50                    0.041817         45000.0        33700      64000.0   \n",
       "51                    0.044786         70000.0        45000     100000.0   \n",
       "60                    0.047421         80000.0        52000     106000.0   \n",
       "63                    0.046416         55000.0        40000      76000.0   \n",
       "66                    0.047307         48700.0        33000      74000.0   \n",
       "74                    0.052533         81000.0        60000     110000.0   \n",
       "79                    0.039758         48000.0        32000      75000.0   \n",
       "80                    0.021716         63000.0        42000      80000.0   \n",
       "89                    0.025593         92000.0        53000     136000.0   \n",
       "92                    0.049335         52000.0        37000      75000.0   \n",
       "93                    0.072329         50000.0        32000      72000.0   \n",
       "117                   0.032983        107000.0        80000     125000.0   \n",
       "127                   0.053395         76000.0        48000     110000.0   \n",
       "134                   0.033985         71900.0        55000     100000.0   \n",
       "135                   0.038595         55000.0        35000      75000.0   \n",
       "139                   0.038649         58000.0        38000      80000.0   \n",
       "142                   0.041913         55000.0        40000      93000.0   \n",
       "144                   0.020949        100000.0        65000     130000.0   \n",
       "145                   0.044460         63000.0        41800      94000.0   \n",
       "152                   0.052907         54000.0        37000      80000.0   \n",
       "153                   0.098741         85000.0        56000     109000.0   \n",
       "155                   0.047937         50000.0        35000      78000.0   \n",
       "156                   0.053770         70000.0        48000     104000.0   \n",
       "158                   0.040921         50000.0        31000      75000.0   \n",
       "159                   0.017908         66000.0        38000     105000.0   \n",
       "162                   0.069740         40000.0        30000      79000.0   \n",
       "164                   0.062710         55000.0        36000      85000.0   \n",
       "165                   0.045584         56000.0        36000      90000.0   \n",
       "166                   0.028193         80000.0        65000     103000.0   \n",
       "\n",
       "     Grad_share  Grad_premium  emp_percent  \n",
       "4      0.144753      0.096154    82.467889  \n",
       "8      0.165394      0.416667    84.049189  \n",
       "9      0.171907      0.176471    84.051521  \n",
       "13     0.184236      0.140000    83.744611  \n",
       "15     0.186266      0.379310    80.940439  \n",
       "17     0.196533      0.230769    83.916037  \n",
       "20     0.213027      0.307692    81.893236  \n",
       "23     0.218503      0.236111    86.316416  \n",
       "24     0.222858      0.350000    83.129252  \n",
       "25     0.224385      0.424242    84.079437  \n",
       "27     0.227780      0.266667    80.033596  \n",
       "28     0.227996      0.230769    85.083954  \n",
       "30     0.236103      0.447368    81.715210  \n",
       "34     0.245704      0.138462    80.783009  \n",
       "38     0.258323      0.200000    86.836699  \n",
       "40     0.259910      0.250000    88.219368  \n",
       "41     0.261032      0.250000    80.025575  \n",
       "45     0.272542      0.294574    80.435377  \n",
       "46     0.274016      0.325000    80.992141  \n",
       "50     0.286964      0.333333    86.861552  \n",
       "51     0.287957      0.357143    83.620753  \n",
       "60     0.304893      0.187500    86.648048  \n",
       "63     0.315764      0.236364    87.287902  \n",
       "66     0.341473      0.273101    82.623636  \n",
       "74     0.367557      0.197531    89.092836  \n",
       "79     0.374427      0.464583    84.065344  \n",
       "80     0.377377      0.111111    86.642302  \n",
       "89     0.407420      0.065217    80.665281  \n",
       "92     0.416199      0.346154    84.554477  \n",
       "93     0.419111      0.400000    80.349627  \n",
       "117    0.467511      0.037383    81.903336  \n",
       "127    0.497074      0.315789    82.653001  \n",
       "134    0.516228      0.126565    80.080191  \n",
       "135    0.520086      0.181818    81.055363  \n",
       "139    0.530295      0.551724    82.644903  \n",
       "142    0.537080      0.727273    84.119024  \n",
       "144    0.547688      0.100000    81.435361  \n",
       "145    0.556956      0.412698    84.238419  \n",
       "152    0.601913      0.759259    82.722010  \n",
       "153    0.618866      0.129412    86.558206  \n",
       "155    0.630301      0.800000    84.985597  \n",
       "156    0.641858      0.285714    87.898894  \n",
       "158    0.648094      0.700000    86.420046  \n",
       "159    0.662699      0.590909    85.519033  \n",
       "162    0.673560      0.450000    86.984545  \n",
       "164    0.687637      0.745455    85.299320  \n",
       "165    0.697310      0.392857    86.320833  \n",
       "166    0.715388      0.187500    86.456571  \n",
       "\n",
       "[48 rows x 23 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grad_students['emp_percent'] = (grad_students.Grad_employed/grad_students.Grad_total) * 100.0\n",
    "grad_students[grad_students.emp_percent > 80]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 4. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 5: Statistical Computations\n",
    "Statistical measures such as mean and median can be easily computed on selective values in the dataframe. \n",
    "\n",
    "To compute mean on Grad_employed:\n",
    "\n",
    "grad_students.Grad_employed.mean()\n",
    "To find missing values:\n",
    "\n",
    "grad_students.Grad_employed.isnull()\n",
    "To calculate the sum of each column:\n",
    "\n",
    "grad_students.Grad_employed.sum()\n",
    "To drop a row where one of the Grad_employed is null:\n",
    "\n",
    "grad_students.Grad_employed.dropna(how='all') \n",
    "To fill missing values:\n",
    "\n",
    "without replacement:\n",
    "grad_students.Grad_employed.fillna(value='NA')\n",
    "with replacement:\n",
    "grad_students.Grad_employed.fillna(value='NA', inplace=True)\n",
    "with another value:\n",
    "grad_students.Grad_employed.fillna(grad_students.Grad_employed.min())\n",
    "To see stats of the entire dataframe:\n",
    "\n",
    "grad_students.describe(include='all')\n",
    "\n",
    "## 5. Exercise\n",
    "\n",
    "#### Instructions\n",
    "* Determine the Major for which the Grad_employed is maximum.\n",
    "* Assign it to variable grad_emp_max and print it out."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Use grad_students.Grad_employed.max()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 5. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 6: Advanced operations - Dataframe\n",
    "Dataframe has advanced operations that can be used to filter data. To retrieve data about grad students whose major is engineering and employed percentage is above 80,\n",
    "\n",
    "grad_students[(grad_students.Major_category == 'Engineering') & (grad_students.emp_percent > 80)]\n",
    "Similarly you can use OR with the single symbol |. Note that there are no double parameters for comparison as in other languages such as C.\n",
    "\n",
    "## 6. Exercise\n",
    "\n",
    "#### Instructions\n",
    "* List the grad students who are Major in Art or Graphic Design whose unemployment rate is below 10%. \n",
    "* Assign the result to variable, grad_select_list and print the value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Use | and & to build your command"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 6. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# 7: Index Based Selection\n",
    "Indices can be used just as in arrays or lists when selection is in a sequence instead of multiple disconnected rows/columns. To extract rows 1 to 4 and columns 4 to 7, you can use:\n",
    "\n",
    "grad_students.ix[0:3, 3:7]\n",
    "\n",
    "## 7.Exercise\n",
    "\n",
    "#### Instructions\n",
    "To select all the data in the row or column, you don't need to specify the start and end index numbers, but just the colon. \n",
    "\n",
    "* Filter all rows for columns 2 to 6 and assign to variable grad_row_sample.\n",
    "* Print out the first 5 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Modify code below\n",
    "# grad_row_sample = grad_students.ix[1:6, :]\n",
    "# print(grad_row_sample.head())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 7. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 8: Sorting & Grouping\n",
    "\n",
    "## Sorting\n",
    "To sort a column in a dataframe, you can use sort _index method and specify the column. To sort by sample size in the ascending order in the grad student dataframe:\n",
    "\n",
    "grad_students.sort_index(by='Grad_sample_size')\n",
    "\n",
    "## Grouping\n",
    "You can use groupby extension to group by the elements of the column.\n",
    "\n",
    "grad_students.groupby('Major_category')\n",
    "\n",
    "## 8. Exercise\n",
    "\n",
    "#### Instructions\n",
    "You can use max() function to determine the max of any column. For example to determine the max employed graduates:\n",
    "\n",
    "grad_students.Grad_employed.max()\n",
    "* Can you determine what is the max graduates employed in each Major category?\n",
    "* Assign the result to the variable, grad_cat_max and print it out."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Modify the code below\n",
    "grad_cat_max = ''"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 8. Solution"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "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
}