Python_Cafe_102.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "college = pd.read_csv('C:\\Anaconda\\data\\college.csv', index_col='INSTNM') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>0.0333</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0024</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>0.0138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>0.5922</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.0283</td>\n",
       "      <td>0.0518</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0368</td>\n",
       "      <td>0.0179</td>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>0.2990</td>\n",
       "      <td>0.4192</td>\n",
       "      <td>0.0069</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.2715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>0.6988</td>\n",
       "      <td>0.1255</td>\n",
       "      <td>0.0382</td>\n",
       "      <td>0.0376</td>\n",
       "      <td>0.0143</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0172</td>\n",
       "      <td>0.0332</td>\n",
       "      <td>0.0350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>0.0158</td>\n",
       "      <td>0.9208</td>\n",
       "      <td>0.0121</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0098</td>\n",
       "      <td>0.0243</td>\n",
       "      <td>0.0137</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     UGDS_WHITE  UGDS_BLACK  UGDS_HISP  \\\n",
       "INSTNM                                                                   \n",
       "Alabama A & M University                 0.0333      0.9353     0.0055   \n",
       "University of Alabama at Birmingham      0.5922      0.2600     0.0283   \n",
       "Amridge University                       0.2990      0.4192     0.0069   \n",
       "University of Alabama in Huntsville      0.6988      0.1255     0.0382   \n",
       "Alabama State University                 0.0158      0.9208     0.0121   \n",
       "\n",
       "                                     UGDS_ASIAN  UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                  \n",
       "Alabama A & M University                 0.0019     0.0024     0.0019   \n",
       "University of Alabama at Birmingham      0.0518     0.0022     0.0007   \n",
       "Amridge University                       0.0034     0.0000     0.0000   \n",
       "University of Alabama in Huntsville      0.0376     0.0143     0.0002   \n",
       "Alabama State University                 0.0019     0.0010     0.0006   \n",
       "\n",
       "                                     UGDS_2MOR  UGDS_NRA  UGDS_UNKN  \n",
       "INSTNM                                                               \n",
       "Alabama A & M University                0.0000    0.0059     0.0138  \n",
       "University of Alabama at Birmingham     0.0368    0.0179     0.0100  \n",
       "Amridge University                      0.0000    0.0000     0.2715  \n",
       "University of Alabama in Huntsville     0.0172    0.0332     0.0350  \n",
       "Alabama State University                0.0098    0.0243     0.0137  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "To successfully use an operator with a DataFrame, first select homogeneous data. For this\n",
    "recipe, we will select all the columns that begin with UGDS_. These columns represent the\n",
    "fraction of undergraduate students by race. To get started, we import the data and use the\n",
    "institution name as the label for our index, and then select the columns we desire with the\n",
    "filter method:'''\n",
    "college_ugds_ = college.filter(like='UGDS_')\n",
    "college_ugds_.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>3.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>59.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>30.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>70.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>2.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The University of Alabama</th>\n",
       "      <td>78.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central Alabama Community College</th>\n",
       "      <td>73.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Athens State University</th>\n",
       "      <td>78.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University at Montgomery</th>\n",
       "      <td>53.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University</th>\n",
       "      <td>85.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Birmingham Southern College</th>\n",
       "      <td>80.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chattahoochee Valley Community College</th>\n",
       "      <td>47.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concordia College Alabama</th>\n",
       "      <td>3.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South University-Montgomery</th>\n",
       "      <td>30.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Enterprise State Community College</th>\n",
       "      <td>64.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>James H Faulkner State Community College</th>\n",
       "      <td>70.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Faulkner University</th>\n",
       "      <td>39.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gadsden State Community College</th>\n",
       "      <td>69.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Beginning College of Cosmetology</th>\n",
       "      <td>90.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Dothan</th>\n",
       "      <td>63.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Hanceville</th>\n",
       "      <td>86.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Selma</th>\n",
       "      <td>20.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Herzing University-Birmingham</th>\n",
       "      <td>35.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Huntingdon College</th>\n",
       "      <td>64.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heritage Christian University</th>\n",
       "      <td>74.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J F Drake State Community and Technical College</th>\n",
       "      <td>33.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jacksonville State University</th>\n",
       "      <td>68.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson Davis Community College</th>\n",
       "      <td>59.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson State Community College</th>\n",
       "      <td>67.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>John C Calhoun State Community College</th>\n",
       "      <td>65.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Lawrenceville</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Piscataway</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Utah County Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L'esprit Academy - Royal Oak</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Career Institute - Jersey City Branch</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Cobb Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Morrow Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Roswell Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Douglasville Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Lithonia Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Savannah Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Augusta Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Columbus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Columbia Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Charleston Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Irving</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Katy</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Northwest Houston</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Plano</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Cedar Hill</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-North Dallas</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-San Antonio</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Stafford</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WestMed College - Merced</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vantage College</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAE Institute of Technology  San Francisco</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rasmussen College - Overland Park</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Personal Training Institute of Cleveland</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bay Area Medical Academy - San Jose Satellite Location</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Excel Learning Center-San Antonio South</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7535 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    UGDS_WHITE  UGDS_BLACK  \\\n",
       "INSTNM                                                                       \n",
       "Alabama A & M University                                   3.0        94.0   \n",
       "University of Alabama at Birmingham                       59.0        26.0   \n",
       "Amridge University                                        30.0        42.0   \n",
       "University of Alabama in Huntsville                       70.0        13.0   \n",
       "Alabama State University                                   2.0        92.0   \n",
       "The University of Alabama                                 78.0        11.0   \n",
       "Central Alabama Community College                         73.0        26.0   \n",
       "Athens State University                                   78.0        12.0   \n",
       "Auburn University at Montgomery                           53.0        34.0   \n",
       "Auburn University                                         85.0         7.0   \n",
       "Birmingham Southern College                               80.0        11.0   \n",
       "Chattahoochee Valley Community College                    47.0        44.0   \n",
       "Concordia College Alabama                                  3.0        88.0   \n",
       "South University-Montgomery                               30.0        61.0   \n",
       "Enterprise State Community College                        64.0        24.0   \n",
       "James H Faulkner State Community College                  70.0        23.0   \n",
       "Faulkner University                                       39.0        51.0   \n",
       "Gadsden State Community College                           69.0        21.0   \n",
       "New Beginning College of Cosmetology                      90.0         3.0   \n",
       "George C Wallace State Community College-Dothan           63.0        32.0   \n",
       "George C Wallace State Community College-Hancev...        86.0         6.0   \n",
       "George C Wallace State Community College-Selma            20.0        74.0   \n",
       "Herzing University-Birmingham                             35.0        53.0   \n",
       "Huntingdon College                                        64.0        20.0   \n",
       "Heritage Christian University                             74.0        11.0   \n",
       "J F Drake State Community and Technical College           33.0        60.0   \n",
       "Jacksonville State University                             68.0        24.0   \n",
       "Jefferson Davis Community College                         59.0        30.0   \n",
       "Jefferson State Community College                         67.0        22.0   \n",
       "John C Calhoun State Community College                    65.0        19.0   \n",
       "...                                                        ...         ...   \n",
       "Strayer University-Lawrenceville                           NaN         NaN   \n",
       "Strayer University-Piscataway                              NaN         NaN   \n",
       "Utah County Campus                                         NaN         NaN   \n",
       "L'esprit Academy - Royal Oak                               NaN         NaN   \n",
       "National Career Institute - Jersey City Branch             NaN         NaN   \n",
       "Strayer University-Cobb Campus                             NaN         NaN   \n",
       "Strayer University-Morrow Campus                           NaN         NaN   \n",
       "Strayer University-Roswell Campus                          NaN         NaN   \n",
       "Strayer University-Douglasville Campus                     NaN         NaN   \n",
       "Strayer University-Lithonia Campus                         NaN         NaN   \n",
       "Strayer University-Savannah Campus                         NaN         NaN   \n",
       "Strayer University-Augusta Campus                          NaN         NaN   \n",
       "Strayer University-Columbus                                NaN         NaN   \n",
       "Strayer University-Columbia Campus                         NaN         NaN   \n",
       "Strayer University-Charleston Campus                       NaN         NaN   \n",
       "Strayer University-Irving                                  NaN         NaN   \n",
       "Strayer University-Katy                                    NaN         NaN   \n",
       "Strayer University-Northwest Houston                       NaN         NaN   \n",
       "Strayer University-Plano                                   NaN         NaN   \n",
       "Strayer University-Cedar Hill                              NaN         NaN   \n",
       "Strayer University-North Dallas                            NaN         NaN   \n",
       "Strayer University-San Antonio                             NaN         NaN   \n",
       "Strayer University-Stafford                                NaN         NaN   \n",
       "WestMed College - Merced                                   NaN         NaN   \n",
       "Vantage College                                            NaN         NaN   \n",
       "SAE Institute of Technology  San Francisco                 NaN         NaN   \n",
       "Rasmussen College - Overland Park                          NaN         NaN   \n",
       "National Personal Training Institute of Cleveland          NaN         NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...         NaN         NaN   \n",
       "Excel Learning Center-San Antonio South                    NaN         NaN   \n",
       "\n",
       "                                                    UGDS_HISP  UGDS_ASIAN  \\\n",
       "INSTNM                                                                      \n",
       "Alabama A & M University                                  1.0         0.0   \n",
       "University of Alabama at Birmingham                       3.0         5.0   \n",
       "Amridge University                                        1.0         0.0   \n",
       "University of Alabama in Huntsville                       4.0         4.0   \n",
       "Alabama State University                                  1.0         0.0   \n",
       "The University of Alabama                                 3.0         1.0   \n",
       "Central Alabama Community College                         0.0         0.0   \n",
       "Athens State University                                   2.0         1.0   \n",
       "Auburn University at Montgomery                           1.0         2.0   \n",
       "Auburn University                                         2.0         2.0   \n",
       "Birmingham Southern College                               2.0         5.0   \n",
       "Chattahoochee Valley Community College                    5.0         1.0   \n",
       "Concordia College Alabama                                 4.0         1.0   \n",
       "South University-Montgomery                               2.0         2.0   \n",
       "Enterprise State Community College                        5.0         2.0   \n",
       "James H Faulkner State Community College                  3.0         1.0   \n",
       "Faulkner University                                       3.0         0.0   \n",
       "Gadsden State Community College                           3.0         0.0   \n",
       "New Beginning College of Cosmetology                      7.0         0.0   \n",
       "George C Wallace State Community College-Dothan           2.0         1.0   \n",
       "George C Wallace State Community College-Hancev...        4.0         1.0   \n",
       "George C Wallace State Community College-Selma            0.0         0.0   \n",
       "Herzing University-Birmingham                             2.0         1.0   \n",
       "Huntingdon College                                        3.0         1.0   \n",
       "Heritage Christian University                             5.0         0.0   \n",
       "J F Drake State Community and Technical College           2.0         1.0   \n",
       "Jacksonville State University                             1.0         1.0   \n",
       "Jefferson Davis Community College                         1.0         3.0   \n",
       "Jefferson State Community College                         5.0         2.0   \n",
       "John C Calhoun State Community College                    4.0         3.0   \n",
       "...                                                       ...         ...   \n",
       "Strayer University-Lawrenceville                          NaN         NaN   \n",
       "Strayer University-Piscataway                             NaN         NaN   \n",
       "Utah County Campus                                        NaN         NaN   \n",
       "L'esprit Academy - Royal Oak                              NaN         NaN   \n",
       "National Career Institute - Jersey City Branch            NaN         NaN   \n",
       "Strayer University-Cobb Campus                            NaN         NaN   \n",
       "Strayer University-Morrow Campus                          NaN         NaN   \n",
       "Strayer University-Roswell Campus                         NaN         NaN   \n",
       "Strayer University-Douglasville Campus                    NaN         NaN   \n",
       "Strayer University-Lithonia Campus                        NaN         NaN   \n",
       "Strayer University-Savannah Campus                        NaN         NaN   \n",
       "Strayer University-Augusta Campus                         NaN         NaN   \n",
       "Strayer University-Columbus                               NaN         NaN   \n",
       "Strayer University-Columbia Campus                        NaN         NaN   \n",
       "Strayer University-Charleston Campus                      NaN         NaN   \n",
       "Strayer University-Irving                                 NaN         NaN   \n",
       "Strayer University-Katy                                   NaN         NaN   \n",
       "Strayer University-Northwest Houston                      NaN         NaN   \n",
       "Strayer University-Plano                                  NaN         NaN   \n",
       "Strayer University-Cedar Hill                             NaN         NaN   \n",
       "Strayer University-North Dallas                           NaN         NaN   \n",
       "Strayer University-San Antonio                            NaN         NaN   \n",
       "Strayer University-Stafford                               NaN         NaN   \n",
       "WestMed College - Merced                                  NaN         NaN   \n",
       "Vantage College                                           NaN         NaN   \n",
       "SAE Institute of Technology  San Francisco                NaN         NaN   \n",
       "Rasmussen College - Overland Park                         NaN         NaN   \n",
       "National Personal Training Institute of Cleveland         NaN         NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN         NaN   \n",
       "Excel Learning Center-San Antonio South                   NaN         NaN   \n",
       "\n",
       "                                                    UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                     \n",
       "Alabama A & M University                                  0.0        0.0   \n",
       "University of Alabama at Birmingham                       0.0        0.0   \n",
       "Amridge University                                        0.0        0.0   \n",
       "University of Alabama in Huntsville                       1.0        0.0   \n",
       "Alabama State University                                  0.0        0.0   \n",
       "The University of Alabama                                 0.0        0.0   \n",
       "Central Alabama Community College                         0.0        0.0   \n",
       "Athens State University                                   2.0        0.0   \n",
       "Auburn University at Montgomery                           0.0        0.0   \n",
       "Auburn University                                         1.0        0.0   \n",
       "Birmingham Southern College                               1.0        0.0   \n",
       "Chattahoochee Valley Community College                    0.0        0.0   \n",
       "Concordia College Alabama                                 0.0        0.0   \n",
       "South University-Montgomery                               2.0        1.0   \n",
       "Enterprise State Community College                        1.0        0.0   \n",
       "James H Faulkner State Community College                  2.0        0.0   \n",
       "Faulkner University                                       1.0        0.0   \n",
       "Gadsden State Community College                           1.0        0.0   \n",
       "New Beginning College of Cosmetology                      0.0        0.0   \n",
       "George C Wallace State Community College-Dothan           0.0        0.0   \n",
       "George C Wallace State Community College-Hancev...        1.0        0.0   \n",
       "George C Wallace State Community College-Selma            0.0        0.0   \n",
       "Herzing University-Birmingham                             0.0        0.0   \n",
       "Huntingdon College                                        1.0        0.0   \n",
       "Heritage Christian University                             3.0        2.0   \n",
       "J F Drake State Community and Technical College           1.0        0.0   \n",
       "Jacksonville State University                             1.0        0.0   \n",
       "Jefferson Davis Community College                         3.0        0.0   \n",
       "Jefferson State Community College                         0.0        0.0   \n",
       "John C Calhoun State Community College                    2.0        0.0   \n",
       "...                                                       ...        ...   \n",
       "Strayer University-Lawrenceville                          NaN        NaN   \n",
       "Strayer University-Piscataway                             NaN        NaN   \n",
       "Utah County Campus                                        NaN        NaN   \n",
       "L'esprit Academy - Royal Oak                              NaN        NaN   \n",
       "National Career Institute - Jersey City Branch            NaN        NaN   \n",
       "Strayer University-Cobb Campus                            NaN        NaN   \n",
       "Strayer University-Morrow Campus                          NaN        NaN   \n",
       "Strayer University-Roswell Campus                         NaN        NaN   \n",
       "Strayer University-Douglasville Campus                    NaN        NaN   \n",
       "Strayer University-Lithonia Campus                        NaN        NaN   \n",
       "Strayer University-Savannah Campus                        NaN        NaN   \n",
       "Strayer University-Augusta Campus                         NaN        NaN   \n",
       "Strayer University-Columbus                               NaN        NaN   \n",
       "Strayer University-Columbia Campus                        NaN        NaN   \n",
       "Strayer University-Charleston Campus                      NaN        NaN   \n",
       "Strayer University-Irving                                 NaN        NaN   \n",
       "Strayer University-Katy                                   NaN        NaN   \n",
       "Strayer University-Northwest Houston                      NaN        NaN   \n",
       "Strayer University-Plano                                  NaN        NaN   \n",
       "Strayer University-Cedar Hill                             NaN        NaN   \n",
       "Strayer University-North Dallas                           NaN        NaN   \n",
       "Strayer University-San Antonio                            NaN        NaN   \n",
       "Strayer University-Stafford                               NaN        NaN   \n",
       "WestMed College - Merced                                  NaN        NaN   \n",
       "Vantage College                                           NaN        NaN   \n",
       "SAE Institute of Technology  San Francisco                NaN        NaN   \n",
       "Rasmussen College - Overland Park                         NaN        NaN   \n",
       "National Personal Training Institute of Cleveland         NaN        NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN        NaN   \n",
       "Excel Learning Center-San Antonio South                   NaN        NaN   \n",
       "\n",
       "                                                    UGDS_2MOR  UGDS_NRA  \\\n",
       "INSTNM                                                                    \n",
       "Alabama A & M University                                  0.0       1.0   \n",
       "University of Alabama at Birmingham                       4.0       2.0   \n",
       "Amridge University                                        0.0       0.0   \n",
       "University of Alabama in Huntsville                       2.0       3.0   \n",
       "Alabama State University                                  1.0       2.0   \n",
       "The University of Alabama                                 3.0       3.0   \n",
       "Central Alabama Community College                         0.0       0.0   \n",
       "Athens State University                                   2.0       1.0   \n",
       "Auburn University at Montgomery                           3.0       4.0   \n",
       "Auburn University                                         0.0       1.0   \n",
       "Birmingham Southern College                               1.0       0.0   \n",
       "Chattahoochee Valley Community College                    2.0       0.0   \n",
       "Concordia College Alabama                                 0.0       5.0   \n",
       "South University-Montgomery                               0.0       0.0   \n",
       "Enterprise State Community College                        3.0       0.0   \n",
       "James H Faulkner State Community College                  2.0       0.0   \n",
       "Faulkner University                                       2.0       2.0   \n",
       "Gadsden State Community College                           2.0       2.0   \n",
       "New Beginning College of Cosmetology                      0.0       0.0   \n",
       "George C Wallace State Community College-Dothan           1.0       0.0   \n",
       "George C Wallace State Community College-Hancev...        0.0       1.0   \n",
       "George C Wallace State Community College-Selma            0.0       0.0   \n",
       "Herzing University-Birmingham                             6.0       0.0   \n",
       "Huntingdon College                                        3.0       1.0   \n",
       "Heritage Christian University                             0.0       2.0   \n",
       "J F Drake State Community and Technical College           2.0       0.0   \n",
       "Jacksonville State University                             0.0       2.0   \n",
       "Jefferson Davis Community College                         2.0       0.0   \n",
       "Jefferson State Community College                         3.0       1.0   \n",
       "John C Calhoun State Community College                    4.0       1.0   \n",
       "...                                                       ...       ...   \n",
       "Strayer University-Lawrenceville                          NaN       NaN   \n",
       "Strayer University-Piscataway                             NaN       NaN   \n",
       "Utah County Campus                                        NaN       NaN   \n",
       "L'esprit Academy - Royal Oak                              NaN       NaN   \n",
       "National Career Institute - Jersey City Branch            NaN       NaN   \n",
       "Strayer University-Cobb Campus                            NaN       NaN   \n",
       "Strayer University-Morrow Campus                          NaN       NaN   \n",
       "Strayer University-Roswell Campus                         NaN       NaN   \n",
       "Strayer University-Douglasville Campus                    NaN       NaN   \n",
       "Strayer University-Lithonia Campus                        NaN       NaN   \n",
       "Strayer University-Savannah Campus                        NaN       NaN   \n",
       "Strayer University-Augusta Campus                         NaN       NaN   \n",
       "Strayer University-Columbus                               NaN       NaN   \n",
       "Strayer University-Columbia Campus                        NaN       NaN   \n",
       "Strayer University-Charleston Campus                      NaN       NaN   \n",
       "Strayer University-Irving                                 NaN       NaN   \n",
       "Strayer University-Katy                                   NaN       NaN   \n",
       "Strayer University-Northwest Houston                      NaN       NaN   \n",
       "Strayer University-Plano                                  NaN       NaN   \n",
       "Strayer University-Cedar Hill                             NaN       NaN   \n",
       "Strayer University-North Dallas                           NaN       NaN   \n",
       "Strayer University-San Antonio                            NaN       NaN   \n",
       "Strayer University-Stafford                               NaN       NaN   \n",
       "WestMed College - Merced                                  NaN       NaN   \n",
       "Vantage College                                           NaN       NaN   \n",
       "SAE Institute of Technology  San Francisco                NaN       NaN   \n",
       "Rasmussen College - Overland Park                         NaN       NaN   \n",
       "National Personal Training Institute of Cleveland         NaN       NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN       NaN   \n",
       "Excel Learning Center-San Antonio South                   NaN       NaN   \n",
       "\n",
       "                                                    UGDS_UNKN  \n",
       "INSTNM                                                         \n",
       "Alabama A & M University                                  1.0  \n",
       "University of Alabama at Birmingham                       1.0  \n",
       "Amridge University                                       27.0  \n",
       "University of Alabama in Huntsville                       4.0  \n",
       "Alabama State University                                  1.0  \n",
       "The University of Alabama                                 0.0  \n",
       "Central Alabama Community College                         0.0  \n",
       "Athens State University                                   3.0  \n",
       "Auburn University at Montgomery                           2.0  \n",
       "Auburn University                                         1.0  \n",
       "Birmingham Southern College                               1.0  \n",
       "Chattahoochee Valley Community College                    1.0  \n",
       "Concordia College Alabama                                 0.0  \n",
       "South University-Montgomery                               3.0  \n",
       "Enterprise State Community College                        1.0  \n",
       "James H Faulkner State Community College                  0.0  \n",
       "Faulkner University                                       3.0  \n",
       "Gadsden State Community College                           2.0  \n",
       "New Beginning College of Cosmetology                      0.0  \n",
       "George C Wallace State Community College-Dothan           0.0  \n",
       "George C Wallace State Community College-Hancev...        2.0  \n",
       "George C Wallace State Community College-Selma            4.0  \n",
       "Herzing University-Birmingham                             4.0  \n",
       "Huntingdon College                                        8.0  \n",
       "Heritage Christian University                             3.0  \n",
       "J F Drake State Community and Technical College           1.0  \n",
       "Jacksonville State University                             3.0  \n",
       "Jefferson Davis Community College                         4.0  \n",
       "Jefferson State Community College                         0.0  \n",
       "John C Calhoun State Community College                    2.0  \n",
       "...                                                       ...  \n",
       "Strayer University-Lawrenceville                          NaN  \n",
       "Strayer University-Piscataway                             NaN  \n",
       "Utah County Campus                                        NaN  \n",
       "L'esprit Academy - Royal Oak                              NaN  \n",
       "National Career Institute - Jersey City Branch            NaN  \n",
       "Strayer University-Cobb Campus                            NaN  \n",
       "Strayer University-Morrow Campus                          NaN  \n",
       "Strayer University-Roswell Campus                         NaN  \n",
       "Strayer University-Douglasville Campus                    NaN  \n",
       "Strayer University-Lithonia Campus                        NaN  \n",
       "Strayer University-Savannah Campus                        NaN  \n",
       "Strayer University-Augusta Campus                         NaN  \n",
       "Strayer University-Columbus                               NaN  \n",
       "Strayer University-Columbia Campus                        NaN  \n",
       "Strayer University-Charleston Campus                      NaN  \n",
       "Strayer University-Irving                                 NaN  \n",
       "Strayer University-Katy                                   NaN  \n",
       "Strayer University-Northwest Houston                      NaN  \n",
       "Strayer University-Plano                                  NaN  \n",
       "Strayer University-Cedar Hill                             NaN  \n",
       "Strayer University-North Dallas                           NaN  \n",
       "Strayer University-San Antonio                            NaN  \n",
       "Strayer University-Stafford                               NaN  \n",
       "WestMed College - Merced                                  NaN  \n",
       "Vantage College                                           NaN  \n",
       "SAE Institute of Technology  San Francisco                NaN  \n",
       "Rasmussen College - Overland Park                         NaN  \n",
       "National Personal Training Institute of Cleveland         NaN  \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN  \n",
       "Excel Learning Center-San Antonio South                   NaN  \n",
       "\n",
       "[7535 rows x 9 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''Mathematically, adding .005 should be enough so that the floor division in the next step\n",
    "correctly rounds to the nearest whole percentage. The trouble appears because of the\n",
    "inexactness of floating point numbers:\n",
    ">>> .045 + .005\n",
    "0.049999999999999996\n",
    "There is an extra .00001 added to each number to ensure that the floating point\n",
    "representation has the first four digits the same as the actual value. This works because the\n",
    "maximum precision of all the points in the dataset is four decimal places.'''\n",
    "\n",
    "college_ugds_ + .00501\n",
    "# Use the floor division operator, //, to round to the nearest whole number percentage:\n",
    "(college_ugds_ + .00501) // .01\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>0.03</td>\n",
       "      <td>0.94</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>0.59</td>\n",
       "      <td>0.26</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>0.30</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>0.70</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>0.02</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     UGDS_WHITE  UGDS_BLACK  UGDS_HISP  \\\n",
       "INSTNM                                                                   \n",
       "Alabama A & M University                   0.03        0.94       0.01   \n",
       "University of Alabama at Birmingham        0.59        0.26       0.03   \n",
       "Amridge University                         0.30        0.42       0.01   \n",
       "University of Alabama in Huntsville        0.70        0.13       0.04   \n",
       "Alabama State University                   0.02        0.92       0.01   \n",
       "\n",
       "                                     UGDS_ASIAN  UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                  \n",
       "Alabama A & M University                   0.00       0.00        0.0   \n",
       "University of Alabama at Birmingham        0.05       0.00        0.0   \n",
       "Amridge University                         0.00       0.00        0.0   \n",
       "University of Alabama in Huntsville        0.04       0.01        0.0   \n",
       "Alabama State University                   0.00       0.00        0.0   \n",
       "\n",
       "                                     UGDS_2MOR  UGDS_NRA  UGDS_UNKN  \n",
       "INSTNM                                                               \n",
       "Alabama A & M University                  0.00      0.01       0.01  \n",
       "University of Alabama at Birmingham       0.04      0.02       0.01  \n",
       "Amridge University                        0.00      0.00       0.27  \n",
       "University of Alabama in Huntsville       0.02      0.03       0.04  \n",
       "Alabama State University                  0.01      0.02       0.01  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''we reproduce the previous steps with the round method. Before we can do this,\n",
    "we must again add an extra .00001 to each DataFrame value for a different reason from\n",
    "step 1. NumPy and Python 3 round numbers that are exactly halfway between either side to\n",
    "the even number.\n",
    "'''\n",
    "college_ugds_op_round = (college_ugds_ + .00501) // .01 / 100\n",
    "college_ugds_op_round.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "'''Now use the round DataFrame method to do the rounding automatically for us.\n",
    "NumPy rounds numbers that are exactly halfway between either side to the even\n",
    "side. Due to this, we add a small fraction before rounding:'''\n",
    "college_ugds_round = (college_ugds_ + .00001).round(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Use the equals DataFrame method to test the equality of two DataFrames:\n",
    "college_ugds_op_round.equals(college_ugds_round)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\nJust as with Series, DataFrames have method equivalents of the operators. You may replace\\nthe operators with their method equivalents:\\ncollege_ugds_op_round_methods = college_ugds_.add(.00501) .floordiv(.01) .div(100)\\ncollege_ugds_op_round_methods.equals(college_ugds_op_round)'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "Just as with Series, DataFrames have method equivalents of the operators. You may replace\n",
    "the operators with their method equivalents:\n",
    "college_ugds_op_round_methods = college_ugds_.add(.00501) \\\n",
    ".floordiv(.01) \\\n",
    ".div(100)\n",
    "college_ugds_op_round_methods.equals(college_ugds_op_round)'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "False\n",
      "False\n",
      "False\n",
      "True\n"
     ]
    }
   ],
   "source": [
    "'''Comparing missing values\n",
    "Pandas uses the NumPy NaN (np.nan) object to represent a missing value. This is an\n",
    "unusual object, as it is not equal to itself. Even Python's None object evaluates as True when\n",
    "compared to itself:\n",
    "All other comparisons against np.nan also return False, except not equal to:\n",
    "SQL-ben is ez a NULL értékek működése.\n",
    "'''\n",
    "import numpy as np\n",
    "print(np.nan == np.nan)\n",
    "\n",
    "print(np.nan > 5)\n",
    "\n",
    "print(5 > np.nan)\n",
    "\n",
    "print(np.nan != 5)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "'''Series and DataFrames use the equals operator, ==, to make element-by-element\n",
    "comparisons that return an object of the same size.\n",
    "'''\n",
    "college = pd.read_csv('C:\\Anaconda\\data\\college.csv', index_col='INSTNM')\n",
    "college_ugds_ = college.filter(like='UGDS_')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The University of Alabama</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central Alabama Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Athens State University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University at Montgomery</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Birmingham Southern College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chattahoochee Valley Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concordia College Alabama</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South University-Montgomery</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Enterprise State Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>James H Faulkner State Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Faulkner University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gadsden State Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Beginning College of Cosmetology</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Dothan</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Hanceville</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Selma</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Herzing University-Birmingham</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Huntingdon College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heritage Christian University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J F Drake State Community and Technical College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jacksonville State University</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson Davis Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson State Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>John C Calhoun State Community College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Lawrenceville</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Piscataway</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Utah County Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L'esprit Academy - Royal Oak</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Career Institute - Jersey City Branch</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Cobb Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Morrow Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Roswell Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Douglasville Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Lithonia Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Savannah Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Augusta Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Columbus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Columbia Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Charleston Campus</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Irving</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Katy</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Northwest Houston</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Plano</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Cedar Hill</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-North Dallas</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-San Antonio</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Stafford</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WestMed College - Merced</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vantage College</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAE Institute of Technology  San Francisco</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rasmussen College - Overland Park</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Personal Training Institute of Cleveland</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bay Area Medical Academy - San Jose Satellite Location</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Excel Learning Center-San Antonio South</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7535 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    UGDS_WHITE  UGDS_BLACK  \\\n",
       "INSTNM                                                                       \n",
       "Alabama A & M University                                 False       False   \n",
       "University of Alabama at Birmingham                      False       False   \n",
       "Amridge University                                       False       False   \n",
       "University of Alabama in Huntsville                      False       False   \n",
       "Alabama State University                                 False       False   \n",
       "The University of Alabama                                False       False   \n",
       "Central Alabama Community College                        False       False   \n",
       "Athens State University                                  False       False   \n",
       "Auburn University at Montgomery                          False       False   \n",
       "Auburn University                                        False       False   \n",
       "Birmingham Southern College                              False       False   \n",
       "Chattahoochee Valley Community College                   False       False   \n",
       "Concordia College Alabama                                False       False   \n",
       "South University-Montgomery                              False       False   \n",
       "Enterprise State Community College                       False       False   \n",
       "James H Faulkner State Community College                 False       False   \n",
       "Faulkner University                                      False       False   \n",
       "Gadsden State Community College                          False       False   \n",
       "New Beginning College of Cosmetology                     False       False   \n",
       "George C Wallace State Community College-Dothan          False       False   \n",
       "George C Wallace State Community College-Hancev...       False       False   \n",
       "George C Wallace State Community College-Selma           False       False   \n",
       "Herzing University-Birmingham                            False       False   \n",
       "Huntingdon College                                       False       False   \n",
       "Heritage Christian University                            False       False   \n",
       "J F Drake State Community and Technical College          False       False   \n",
       "Jacksonville State University                            False       False   \n",
       "Jefferson Davis Community College                        False       False   \n",
       "Jefferson State Community College                        False       False   \n",
       "John C Calhoun State Community College                   False       False   \n",
       "...                                                        ...         ...   \n",
       "Strayer University-Lawrenceville                         False       False   \n",
       "Strayer University-Piscataway                            False       False   \n",
       "Utah County Campus                                       False       False   \n",
       "L'esprit Academy - Royal Oak                             False       False   \n",
       "National Career Institute - Jersey City Branch           False       False   \n",
       "Strayer University-Cobb Campus                           False       False   \n",
       "Strayer University-Morrow Campus                         False       False   \n",
       "Strayer University-Roswell Campus                        False       False   \n",
       "Strayer University-Douglasville Campus                   False       False   \n",
       "Strayer University-Lithonia Campus                       False       False   \n",
       "Strayer University-Savannah Campus                       False       False   \n",
       "Strayer University-Augusta Campus                        False       False   \n",
       "Strayer University-Columbus                              False       False   \n",
       "Strayer University-Columbia Campus                       False       False   \n",
       "Strayer University-Charleston Campus                     False       False   \n",
       "Strayer University-Irving                                False       False   \n",
       "Strayer University-Katy                                  False       False   \n",
       "Strayer University-Northwest Houston                     False       False   \n",
       "Strayer University-Plano                                 False       False   \n",
       "Strayer University-Cedar Hill                            False       False   \n",
       "Strayer University-North Dallas                          False       False   \n",
       "Strayer University-San Antonio                           False       False   \n",
       "Strayer University-Stafford                              False       False   \n",
       "WestMed College - Merced                                 False       False   \n",
       "Vantage College                                          False       False   \n",
       "SAE Institute of Technology  San Francisco               False       False   \n",
       "Rasmussen College - Overland Park                        False       False   \n",
       "National Personal Training Institute of Cleveland        False       False   \n",
       "Bay Area Medical Academy - San Jose Satellite L...       False       False   \n",
       "Excel Learning Center-San Antonio South                  False       False   \n",
       "\n",
       "                                                    UGDS_HISP  UGDS_ASIAN  \\\n",
       "INSTNM                                                                      \n",
       "Alabama A & M University                                False        True   \n",
       "University of Alabama at Birmingham                     False       False   \n",
       "Amridge University                                      False       False   \n",
       "University of Alabama in Huntsville                     False       False   \n",
       "Alabama State University                                False        True   \n",
       "The University of Alabama                               False       False   \n",
       "Central Alabama Community College                       False       False   \n",
       "Athens State University                                 False       False   \n",
       "Auburn University at Montgomery                         False       False   \n",
       "Auburn University                                       False       False   \n",
       "Birmingham Southern College                             False       False   \n",
       "Chattahoochee Valley Community College                  False       False   \n",
       "Concordia College Alabama                               False       False   \n",
       "South University-Montgomery                             False       False   \n",
       "Enterprise State Community College                      False       False   \n",
       "James H Faulkner State Community College                False       False   \n",
       "Faulkner University                                     False       False   \n",
       "Gadsden State Community College                         False       False   \n",
       "New Beginning College of Cosmetology                    False       False   \n",
       "George C Wallace State Community College-Dothan         False       False   \n",
       "George C Wallace State Community College-Hancev...      False       False   \n",
       "George C Wallace State Community College-Selma          False       False   \n",
       "Herzing University-Birmingham                           False       False   \n",
       "Huntingdon College                                      False       False   \n",
       "Heritage Christian University                           False       False   \n",
       "J F Drake State Community and Technical College         False       False   \n",
       "Jacksonville State University                           False       False   \n",
       "Jefferson Davis Community College                       False       False   \n",
       "Jefferson State Community College                       False       False   \n",
       "John C Calhoun State Community College                  False       False   \n",
       "...                                                       ...         ...   \n",
       "Strayer University-Lawrenceville                        False       False   \n",
       "Strayer University-Piscataway                           False       False   \n",
       "Utah County Campus                                      False       False   \n",
       "L'esprit Academy - Royal Oak                            False       False   \n",
       "National Career Institute - Jersey City Branch          False       False   \n",
       "Strayer University-Cobb Campus                          False       False   \n",
       "Strayer University-Morrow Campus                        False       False   \n",
       "Strayer University-Roswell Campus                       False       False   \n",
       "Strayer University-Douglasville Campus                  False       False   \n",
       "Strayer University-Lithonia Campus                      False       False   \n",
       "Strayer University-Savannah Campus                      False       False   \n",
       "Strayer University-Augusta Campus                       False       False   \n",
       "Strayer University-Columbus                             False       False   \n",
       "Strayer University-Columbia Campus                      False       False   \n",
       "Strayer University-Charleston Campus                    False       False   \n",
       "Strayer University-Irving                               False       False   \n",
       "Strayer University-Katy                                 False       False   \n",
       "Strayer University-Northwest Houston                    False       False   \n",
       "Strayer University-Plano                                False       False   \n",
       "Strayer University-Cedar Hill                           False       False   \n",
       "Strayer University-North Dallas                         False       False   \n",
       "Strayer University-San Antonio                          False       False   \n",
       "Strayer University-Stafford                             False       False   \n",
       "WestMed College - Merced                                False       False   \n",
       "Vantage College                                         False       False   \n",
       "SAE Institute of Technology  San Francisco              False       False   \n",
       "Rasmussen College - Overland Park                       False       False   \n",
       "National Personal Training Institute of Cleveland       False       False   \n",
       "Bay Area Medical Academy - San Jose Satellite L...      False       False   \n",
       "Excel Learning Center-San Antonio South                 False       False   \n",
       "\n",
       "                                                    UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                     \n",
       "Alabama A & M University                                False       True   \n",
       "University of Alabama at Birmingham                     False      False   \n",
       "Amridge University                                      False      False   \n",
       "University of Alabama in Huntsville                     False      False   \n",
       "Alabama State University                                False      False   \n",
       "The University of Alabama                               False      False   \n",
       "Central Alabama Community College                       False      False   \n",
       "Athens State University                                 False      False   \n",
       "Auburn University at Montgomery                         False      False   \n",
       "Auburn University                                       False      False   \n",
       "Birmingham Southern College                             False      False   \n",
       "Chattahoochee Valley Community College                  False      False   \n",
       "Concordia College Alabama                               False      False   \n",
       "South University-Montgomery                             False      False   \n",
       "Enterprise State Community College                      False      False   \n",
       "James H Faulkner State Community College                False      False   \n",
       "Faulkner University                                     False      False   \n",
       "Gadsden State Community College                         False      False   \n",
       "New Beginning College of Cosmetology                    False      False   \n",
       "George C Wallace State Community College-Dothan         False      False   \n",
       "George C Wallace State Community College-Hancev...      False      False   \n",
       "George C Wallace State Community College-Selma          False      False   \n",
       "Herzing University-Birmingham                           False      False   \n",
       "Huntingdon College                                      False      False   \n",
       "Heritage Christian University                           False      False   \n",
       "J F Drake State Community and Technical College         False      False   \n",
       "Jacksonville State University                           False      False   \n",
       "Jefferson Davis Community College                       False      False   \n",
       "Jefferson State Community College                       False      False   \n",
       "John C Calhoun State Community College                  False      False   \n",
       "...                                                       ...        ...   \n",
       "Strayer University-Lawrenceville                        False      False   \n",
       "Strayer University-Piscataway                           False      False   \n",
       "Utah County Campus                                      False      False   \n",
       "L'esprit Academy - Royal Oak                            False      False   \n",
       "National Career Institute - Jersey City Branch          False      False   \n",
       "Strayer University-Cobb Campus                          False      False   \n",
       "Strayer University-Morrow Campus                        False      False   \n",
       "Strayer University-Roswell Campus                       False      False   \n",
       "Strayer University-Douglasville Campus                  False      False   \n",
       "Strayer University-Lithonia Campus                      False      False   \n",
       "Strayer University-Savannah Campus                      False      False   \n",
       "Strayer University-Augusta Campus                       False      False   \n",
       "Strayer University-Columbus                             False      False   \n",
       "Strayer University-Columbia Campus                      False      False   \n",
       "Strayer University-Charleston Campus                    False      False   \n",
       "Strayer University-Irving                               False      False   \n",
       "Strayer University-Katy                                 False      False   \n",
       "Strayer University-Northwest Houston                    False      False   \n",
       "Strayer University-Plano                                False      False   \n",
       "Strayer University-Cedar Hill                           False      False   \n",
       "Strayer University-North Dallas                         False      False   \n",
       "Strayer University-San Antonio                          False      False   \n",
       "Strayer University-Stafford                             False      False   \n",
       "WestMed College - Merced                                False      False   \n",
       "Vantage College                                         False      False   \n",
       "SAE Institute of Technology  San Francisco              False      False   \n",
       "Rasmussen College - Overland Park                       False      False   \n",
       "National Personal Training Institute of Cleveland       False      False   \n",
       "Bay Area Medical Academy - San Jose Satellite L...      False      False   \n",
       "Excel Learning Center-San Antonio South                 False      False   \n",
       "\n",
       "                                                    UGDS_2MOR  UGDS_NRA  \\\n",
       "INSTNM                                                                    \n",
       "Alabama A & M University                                False     False   \n",
       "University of Alabama at Birmingham                     False     False   \n",
       "Amridge University                                      False     False   \n",
       "University of Alabama in Huntsville                     False     False   \n",
       "Alabama State University                                False     False   \n",
       "The University of Alabama                               False     False   \n",
       "Central Alabama Community College                       False     False   \n",
       "Athens State University                                 False     False   \n",
       "Auburn University at Montgomery                         False     False   \n",
       "Auburn University                                       False     False   \n",
       "Birmingham Southern College                             False     False   \n",
       "Chattahoochee Valley Community College                  False     False   \n",
       "Concordia College Alabama                               False     False   \n",
       "South University-Montgomery                             False      True   \n",
       "Enterprise State Community College                      False     False   \n",
       "James H Faulkner State Community College                False     False   \n",
       "Faulkner University                                     False     False   \n",
       "Gadsden State Community College                         False     False   \n",
       "New Beginning College of Cosmetology                    False     False   \n",
       "George C Wallace State Community College-Dothan         False     False   \n",
       "George C Wallace State Community College-Hancev...      False     False   \n",
       "George C Wallace State Community College-Selma          False     False   \n",
       "Herzing University-Birmingham                           False     False   \n",
       "Huntingdon College                                      False     False   \n",
       "Heritage Christian University                           False     False   \n",
       "J F Drake State Community and Technical College         False     False   \n",
       "Jacksonville State University                           False     False   \n",
       "Jefferson Davis Community College                       False     False   \n",
       "Jefferson State Community College                       False     False   \n",
       "John C Calhoun State Community College                  False     False   \n",
       "...                                                       ...       ...   \n",
       "Strayer University-Lawrenceville                        False     False   \n",
       "Strayer University-Piscataway                           False     False   \n",
       "Utah County Campus                                      False     False   \n",
       "L'esprit Academy - Royal Oak                            False     False   \n",
       "National Career Institute - Jersey City Branch          False     False   \n",
       "Strayer University-Cobb Campus                          False     False   \n",
       "Strayer University-Morrow Campus                        False     False   \n",
       "Strayer University-Roswell Campus                       False     False   \n",
       "Strayer University-Douglasville Campus                  False     False   \n",
       "Strayer University-Lithonia Campus                      False     False   \n",
       "Strayer University-Savannah Campus                      False     False   \n",
       "Strayer University-Augusta Campus                       False     False   \n",
       "Strayer University-Columbus                             False     False   \n",
       "Strayer University-Columbia Campus                      False     False   \n",
       "Strayer University-Charleston Campus                    False     False   \n",
       "Strayer University-Irving                               False     False   \n",
       "Strayer University-Katy                                 False     False   \n",
       "Strayer University-Northwest Houston                    False     False   \n",
       "Strayer University-Plano                                False     False   \n",
       "Strayer University-Cedar Hill                           False     False   \n",
       "Strayer University-North Dallas                         False     False   \n",
       "Strayer University-San Antonio                          False     False   \n",
       "Strayer University-Stafford                             False     False   \n",
       "WestMed College - Merced                                False     False   \n",
       "Vantage College                                         False     False   \n",
       "SAE Institute of Technology  San Francisco              False     False   \n",
       "Rasmussen College - Overland Park                       False     False   \n",
       "National Personal Training Institute of Cleveland       False     False   \n",
       "Bay Area Medical Academy - San Jose Satellite L...      False     False   \n",
       "Excel Learning Center-San Antonio South                 False     False   \n",
       "\n",
       "                                                    UGDS_UNKN  \n",
       "INSTNM                                                         \n",
       "Alabama A & M University                                False  \n",
       "University of Alabama at Birmingham                     False  \n",
       "Amridge University                                      False  \n",
       "University of Alabama in Huntsville                     False  \n",
       "Alabama State University                                False  \n",
       "The University of Alabama                               False  \n",
       "Central Alabama Community College                        True  \n",
       "Athens State University                                 False  \n",
       "Auburn University at Montgomery                         False  \n",
       "Auburn University                                       False  \n",
       "Birmingham Southern College                             False  \n",
       "Chattahoochee Valley Community College                  False  \n",
       "Concordia College Alabama                               False  \n",
       "South University-Montgomery                             False  \n",
       "Enterprise State Community College                      False  \n",
       "James H Faulkner State Community College                False  \n",
       "Faulkner University                                     False  \n",
       "Gadsden State Community College                         False  \n",
       "New Beginning College of Cosmetology                    False  \n",
       "George C Wallace State Community College-Dothan         False  \n",
       "George C Wallace State Community College-Hancev...      False  \n",
       "George C Wallace State Community College-Selma          False  \n",
       "Herzing University-Birmingham                           False  \n",
       "Huntingdon College                                      False  \n",
       "Heritage Christian University                           False  \n",
       "J F Drake State Community and Technical College         False  \n",
       "Jacksonville State University                           False  \n",
       "Jefferson Davis Community College                       False  \n",
       "Jefferson State Community College                       False  \n",
       "John C Calhoun State Community College                  False  \n",
       "...                                                       ...  \n",
       "Strayer University-Lawrenceville                        False  \n",
       "Strayer University-Piscataway                           False  \n",
       "Utah County Campus                                      False  \n",
       "L'esprit Academy - Royal Oak                            False  \n",
       "National Career Institute - Jersey City Branch          False  \n",
       "Strayer University-Cobb Campus                          False  \n",
       "Strayer University-Morrow Campus                        False  \n",
       "Strayer University-Roswell Campus                       False  \n",
       "Strayer University-Douglasville Campus                  False  \n",
       "Strayer University-Lithonia Campus                      False  \n",
       "Strayer University-Savannah Campus                      False  \n",
       "Strayer University-Augusta Campus                       False  \n",
       "Strayer University-Columbus                             False  \n",
       "Strayer University-Columbia Campus                      False  \n",
       "Strayer University-Charleston Campus                    False  \n",
       "Strayer University-Irving                               False  \n",
       "Strayer University-Katy                                 False  \n",
       "Strayer University-Northwest Houston                    False  \n",
       "Strayer University-Plano                                False  \n",
       "Strayer University-Cedar Hill                           False  \n",
       "Strayer University-North Dallas                         False  \n",
       "Strayer University-San Antonio                          False  \n",
       "Strayer University-Stafford                             False  \n",
       "WestMed College - Merced                                False  \n",
       "Vantage College                                         False  \n",
       "SAE Institute of Technology  San Francisco              False  \n",
       "Rasmussen College - Overland Park                       False  \n",
       "National Personal Training Institute of Cleveland       False  \n",
       "Bay Area Medical Academy - San Jose Satellite L...      False  \n",
       "Excel Learning Center-San Antonio South                 False  \n",
       "\n",
       "[7535 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To get an idea of how the equals operator works, let's compare each element to a scalar value:\n",
    "college_ugds_ == .0019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     UGDS_WHITE  UGDS_BLACK  UGDS_HISP  \\\n",
       "INSTNM                                                                   \n",
       "Alabama A & M University                   True        True       True   \n",
       "University of Alabama at Birmingham        True        True       True   \n",
       "Amridge University                         True        True       True   \n",
       "University of Alabama in Huntsville        True        True       True   \n",
       "Alabama State University                   True        True       True   \n",
       "\n",
       "                                     UGDS_ASIAN  UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                  \n",
       "Alabama A & M University                   True       True       True   \n",
       "University of Alabama at Birmingham        True       True       True   \n",
       "Amridge University                         True       True       True   \n",
       "University of Alabama in Huntsville        True       True       True   \n",
       "Alabama State University                   True       True       True   \n",
       "\n",
       "                                     UGDS_2MOR  UGDS_NRA  UGDS_UNKN  \n",
       "INSTNM                                                               \n",
       "Alabama A & M University                  True      True       True  \n",
       "University of Alabama at Birmingham       True      True       True  \n",
       "Amridge University                        True      True       True  \n",
       "University of Alabama in Huntsville       True      True       True  \n",
       "Alabama State University                  True      True       True  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "college_self_compare = college_ugds_ == college_ugds_\n",
    "college_self_compare.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE    False\n",
       "UGDS_BLACK    False\n",
       "UGDS_HISP     False\n",
       "UGDS_ASIAN    False\n",
       "UGDS_AIAN     False\n",
       "UGDS_NHPI     False\n",
       "UGDS_2MOR     False\n",
       "UGDS_NRA      False\n",
       "UGDS_UNKN     False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Using the all method to determine if each column contains only True values yields an unexpected result:\n",
    "college_self_compare.all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE    661\n",
       "UGDS_BLACK    661\n",
       "UGDS_HISP     661\n",
       "UGDS_ASIAN    661\n",
       "UGDS_AIAN     661\n",
       "UGDS_NHPI     661\n",
       "UGDS_2MOR     661\n",
       "UGDS_NRA      661\n",
       "UGDS_UNKN     661\n",
       "dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The primary way to count missing values uses the isnull method:\n",
    "college_ugds_.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''The correct way to compare two entire DataFrames with one another is not with\n",
    "the equals operator but with the equals method:'''\n",
    "college_ugds_.equals(college_ugds_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Many DataFrame methods have an axis parameter. This important parameter controls the\\ndirection in which the operation takes place. Axis parameters can only be one of two values,\\neither 0 or 1, and are aliased respectively as the strings index and columns.\\nNearly all DataFrame methods default the axis parameter to 0/index.  '"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Transposing the direction of a DataFrame operation\n",
    "'''Many DataFrame methods have an axis parameter. This important parameter controls the\n",
    "direction in which the operation takes place. Axis parameters can only be one of two values,\n",
    "either 0 or 1, and are aliased respectively as the strings index and columns.\n",
    "Nearly all DataFrame methods default the axis parameter to 0/index.  '''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>0.0333</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0024</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>0.0138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>0.5922</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.0283</td>\n",
       "      <td>0.0518</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0368</td>\n",
       "      <td>0.0179</td>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>0.2990</td>\n",
       "      <td>0.4192</td>\n",
       "      <td>0.0069</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.2715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>0.6988</td>\n",
       "      <td>0.1255</td>\n",
       "      <td>0.0382</td>\n",
       "      <td>0.0376</td>\n",
       "      <td>0.0143</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0172</td>\n",
       "      <td>0.0332</td>\n",
       "      <td>0.0350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>0.0158</td>\n",
       "      <td>0.9208</td>\n",
       "      <td>0.0121</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0098</td>\n",
       "      <td>0.0243</td>\n",
       "      <td>0.0137</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     UGDS_WHITE  UGDS_BLACK  UGDS_HISP  \\\n",
       "INSTNM                                                                   \n",
       "Alabama A & M University                 0.0333      0.9353     0.0055   \n",
       "University of Alabama at Birmingham      0.5922      0.2600     0.0283   \n",
       "Amridge University                       0.2990      0.4192     0.0069   \n",
       "University of Alabama in Huntsville      0.6988      0.1255     0.0382   \n",
       "Alabama State University                 0.0158      0.9208     0.0121   \n",
       "\n",
       "                                     UGDS_ASIAN  UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                  \n",
       "Alabama A & M University                 0.0019     0.0024     0.0019   \n",
       "University of Alabama at Birmingham      0.0518     0.0022     0.0007   \n",
       "Amridge University                       0.0034     0.0000     0.0000   \n",
       "University of Alabama in Huntsville      0.0376     0.0143     0.0002   \n",
       "Alabama State University                 0.0019     0.0010     0.0006   \n",
       "\n",
       "                                     UGDS_2MOR  UGDS_NRA  UGDS_UNKN  \n",
       "INSTNM                                                               \n",
       "Alabama A & M University                0.0000    0.0059     0.0138  \n",
       "University of Alabama at Birmingham     0.0368    0.0179     0.0100  \n",
       "Amridge University                      0.0000    0.0000     0.2715  \n",
       "University of Alabama in Huntsville     0.0172    0.0332     0.0350  \n",
       "Alabama State University                0.0098    0.0243     0.0137  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "college = pd.read_csv('C:\\Anaconda\\data\\college.csv', index_col='INSTNM')\n",
    "college_ugds_ = college.filter(like='UGDS_')\n",
    "college_ugds_.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE    6874\n",
       "UGDS_BLACK    6874\n",
       "UGDS_HISP     6874\n",
       "UGDS_ASIAN    6874\n",
       "UGDS_AIAN     6874\n",
       "UGDS_NHPI     6874\n",
       "UGDS_2MOR     6874\n",
       "UGDS_NRA      6874\n",
       "UGDS_UNKN     6874\n",
       "dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The count method returns the number of non-missing values. By default, its axis parameter is set to 0:\n",
    "college_ugds_.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Alabama A & M University               9\n",
       "University of Alabama at Birmingham    9\n",
       "Amridge University                     9\n",
       "University of Alabama in Huntsville    9\n",
       "Alabama State University               9\n",
       "dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''Changing the axis parameter to 1/columns transposes the operation so that each\n",
    "row of data has a count of its non-missing values:'''\n",
    "college_ugds_.count(axis='columns').head()\n",
    "# Ez így nem értékes, mert csak azt mondja meg, hogy hány oszlop van."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Alabama A & M University               1.0000\n",
       "University of Alabama at Birmingham    0.9999\n",
       "Amridge University                     1.0000\n",
       "University of Alabama in Huntsville    1.0000\n",
       "Alabama State University               1.0000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Each row of percentages should add up to 1. The sum method may be used to verify this:\n",
    "college_ugds_.sum(axis='columns').head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE    0.55570\n",
       "UGDS_BLACK    0.10005\n",
       "UGDS_HISP     0.07140\n",
       "UGDS_ASIAN    0.01290\n",
       "UGDS_AIAN     0.00260\n",
       "UGDS_NHPI     0.00000\n",
       "UGDS_2MOR     0.01750\n",
       "UGDS_NRA      0.00000\n",
       "UGDS_UNKN     0.01430\n",
       "dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To get an idea of the distribution of each column, the median method can be used:\n",
    "college_ugds_.median(axis='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Alabama A & M University               0.0055\n",
       "University of Alabama at Birmingham    0.0283\n",
       "Amridge University                     0.0034\n",
       "University of Alabama in Huntsville    0.0350\n",
       "Alabama State University               0.0121\n",
       "dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "college_ugds_.median(axis='columns').head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>0.0333</td>\n",
       "      <td>0.9686</td>\n",
       "      <td>0.9741</td>\n",
       "      <td>0.9760</td>\n",
       "      <td>0.9784</td>\n",
       "      <td>0.9803</td>\n",
       "      <td>0.9803</td>\n",
       "      <td>0.9862</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>0.5922</td>\n",
       "      <td>0.8522</td>\n",
       "      <td>0.8805</td>\n",
       "      <td>0.9323</td>\n",
       "      <td>0.9345</td>\n",
       "      <td>0.9352</td>\n",
       "      <td>0.9720</td>\n",
       "      <td>0.9899</td>\n",
       "      <td>0.9999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>0.2990</td>\n",
       "      <td>0.7182</td>\n",
       "      <td>0.7251</td>\n",
       "      <td>0.7285</td>\n",
       "      <td>0.7285</td>\n",
       "      <td>0.7285</td>\n",
       "      <td>0.7285</td>\n",
       "      <td>0.7285</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>0.6988</td>\n",
       "      <td>0.8243</td>\n",
       "      <td>0.8625</td>\n",
       "      <td>0.9001</td>\n",
       "      <td>0.9144</td>\n",
       "      <td>0.9146</td>\n",
       "      <td>0.9318</td>\n",
       "      <td>0.9650</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>0.0158</td>\n",
       "      <td>0.9366</td>\n",
       "      <td>0.9487</td>\n",
       "      <td>0.9506</td>\n",
       "      <td>0.9516</td>\n",
       "      <td>0.9522</td>\n",
       "      <td>0.9620</td>\n",
       "      <td>0.9863</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     UGDS_WHITE  UGDS_BLACK  UGDS_HISP  \\\n",
       "INSTNM                                                                   \n",
       "Alabama A & M University                 0.0333      0.9686     0.9741   \n",
       "University of Alabama at Birmingham      0.5922      0.8522     0.8805   \n",
       "Amridge University                       0.2990      0.7182     0.7251   \n",
       "University of Alabama in Huntsville      0.6988      0.8243     0.8625   \n",
       "Alabama State University                 0.0158      0.9366     0.9487   \n",
       "\n",
       "                                     UGDS_ASIAN  UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                  \n",
       "Alabama A & M University                 0.9760     0.9784     0.9803   \n",
       "University of Alabama at Birmingham      0.9323     0.9345     0.9352   \n",
       "Amridge University                       0.7285     0.7285     0.7285   \n",
       "University of Alabama in Huntsville      0.9001     0.9144     0.9146   \n",
       "Alabama State University                 0.9506     0.9516     0.9522   \n",
       "\n",
       "                                     UGDS_2MOR  UGDS_NRA  UGDS_UNKN  \n",
       "INSTNM                                                               \n",
       "Alabama A & M University                0.9803    0.9862     1.0000  \n",
       "University of Alabama at Birmingham     0.9720    0.9899     0.9999  \n",
       "Amridge University                      0.7285    0.7285     1.0000  \n",
       "University of Alabama in Huntsville     0.9318    0.9650     1.0000  \n",
       "Alabama State University                0.9620    0.9863     1.0000  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "The cumsum method with axis=1 accumulates the race percentages across each row. It\n",
    "gives a slightly different view of the data. For example, it is very easy to see the exact\n",
    "percentage of white, black, and Hispanic together for each school:'''\n",
    "  # Tehát a következő esetünkben balról jobbra kumulálunk. Ennek van értelme, soronként jelen esetben nem lenne.\n",
    "college_ugds_cumsum = college_ugds_.cumsum(axis=1)\n",
    "college_ugds_cumsum.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Diversity Index</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>School</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Rutgers University--Newark  Newark, NJ</th>\n",
       "      <td>0.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andrews University  Berrien Springs, MI</th>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stanford University  Stanford, CA</th>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Houston  Houston, TX</th>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Nevada--Las Vegas  Las Vegas, NV</th>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Diversity Index\n",
       "School                                                         \n",
       "Rutgers University--Newark  Newark, NJ                     0.76\n",
       "Andrews University  Berrien Springs, MI                    0.74\n",
       "Stanford University  Stanford, CA                          0.74\n",
       "University of Houston  Houston, TX                         0.74\n",
       "University of Nevada--Las Vegas  Las Vegas, NV             0.74"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Determining college campus diversity\n",
    "# És így hivatkozunk GitHub tartalomra.\n",
    "# Ez a forrásfile az eredmény lesz, ezt fogjuk előállítani a következő lépésekben:\n",
    "collegediv = pd.read_csv('https://raw.githubusercontent.com/DatasRev/source-files/master/csv/college_diversity.csv', index_col='School')\n",
    "collegediv.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>0.0333</td>\n",
       "      <td>0.9353</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0024</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>0.0138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>0.5922</td>\n",
       "      <td>0.2600</td>\n",
       "      <td>0.0283</td>\n",
       "      <td>0.0518</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0368</td>\n",
       "      <td>0.0179</td>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>0.2990</td>\n",
       "      <td>0.4192</td>\n",
       "      <td>0.0069</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.2715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>0.6988</td>\n",
       "      <td>0.1255</td>\n",
       "      <td>0.0382</td>\n",
       "      <td>0.0376</td>\n",
       "      <td>0.0143</td>\n",
       "      <td>0.0002</td>\n",
       "      <td>0.0172</td>\n",
       "      <td>0.0332</td>\n",
       "      <td>0.0350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>0.0158</td>\n",
       "      <td>0.9208</td>\n",
       "      <td>0.0121</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0098</td>\n",
       "      <td>0.0243</td>\n",
       "      <td>0.0137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The University of Alabama</th>\n",
       "      <td>0.7825</td>\n",
       "      <td>0.1119</td>\n",
       "      <td>0.0348</td>\n",
       "      <td>0.0106</td>\n",
       "      <td>0.0038</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>0.0261</td>\n",
       "      <td>0.0268</td>\n",
       "      <td>0.0026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central Alabama Community College</th>\n",
       "      <td>0.7255</td>\n",
       "      <td>0.2613</td>\n",
       "      <td>0.0044</td>\n",
       "      <td>0.0025</td>\n",
       "      <td>0.0044</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Athens State University</th>\n",
       "      <td>0.7823</td>\n",
       "      <td>0.1200</td>\n",
       "      <td>0.0191</td>\n",
       "      <td>0.0053</td>\n",
       "      <td>0.0157</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>0.0174</td>\n",
       "      <td>0.0057</td>\n",
       "      <td>0.0334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University at Montgomery</th>\n",
       "      <td>0.5328</td>\n",
       "      <td>0.3376</td>\n",
       "      <td>0.0074</td>\n",
       "      <td>0.0221</td>\n",
       "      <td>0.0044</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>0.0297</td>\n",
       "      <td>0.0397</td>\n",
       "      <td>0.0246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University</th>\n",
       "      <td>0.8507</td>\n",
       "      <td>0.0704</td>\n",
       "      <td>0.0248</td>\n",
       "      <td>0.0227</td>\n",
       "      <td>0.0074</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Birmingham Southern College</th>\n",
       "      <td>0.7983</td>\n",
       "      <td>0.1102</td>\n",
       "      <td>0.0195</td>\n",
       "      <td>0.0517</td>\n",
       "      <td>0.0102</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0051</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chattahoochee Valley Community College</th>\n",
       "      <td>0.4661</td>\n",
       "      <td>0.4372</td>\n",
       "      <td>0.0492</td>\n",
       "      <td>0.0127</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>0.0035</td>\n",
       "      <td>0.0151</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concordia College Alabama</th>\n",
       "      <td>0.0280</td>\n",
       "      <td>0.8758</td>\n",
       "      <td>0.0373</td>\n",
       "      <td>0.0093</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0031</td>\n",
       "      <td>0.0466</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South University-Montgomery</th>\n",
       "      <td>0.3046</td>\n",
       "      <td>0.6054</td>\n",
       "      <td>0.0153</td>\n",
       "      <td>0.0153</td>\n",
       "      <td>0.0153</td>\n",
       "      <td>0.0096</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0019</td>\n",
       "      <td>0.0326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Enterprise State Community College</th>\n",
       "      <td>0.6408</td>\n",
       "      <td>0.2435</td>\n",
       "      <td>0.0509</td>\n",
       "      <td>0.0202</td>\n",
       "      <td>0.0081</td>\n",
       "      <td>0.0029</td>\n",
       "      <td>0.0254</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>0.0069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>James H Faulkner State Community College</th>\n",
       "      <td>0.6979</td>\n",
       "      <td>0.2259</td>\n",
       "      <td>0.0320</td>\n",
       "      <td>0.0084</td>\n",
       "      <td>0.0177</td>\n",
       "      <td>0.0014</td>\n",
       "      <td>0.0152</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.0009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Faulkner University</th>\n",
       "      <td>0.3874</td>\n",
       "      <td>0.5137</td>\n",
       "      <td>0.0258</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>0.0063</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0173</td>\n",
       "      <td>0.0182</td>\n",
       "      <td>0.0258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gadsden State Community College</th>\n",
       "      <td>0.6921</td>\n",
       "      <td>0.2076</td>\n",
       "      <td>0.0305</td>\n",
       "      <td>0.0047</td>\n",
       "      <td>0.0128</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>0.0185</td>\n",
       "      <td>0.0150</td>\n",
       "      <td>0.0169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Beginning College of Cosmetology</th>\n",
       "      <td>0.8957</td>\n",
       "      <td>0.0348</td>\n",
       "      <td>0.0696</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Dothan</th>\n",
       "      <td>0.6273</td>\n",
       "      <td>0.3240</td>\n",
       "      <td>0.0221</td>\n",
       "      <td>0.0072</td>\n",
       "      <td>0.0049</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>0.0126</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Hanceville</th>\n",
       "      <td>0.8630</td>\n",
       "      <td>0.0612</td>\n",
       "      <td>0.0362</td>\n",
       "      <td>0.0065</td>\n",
       "      <td>0.0089</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>0.0183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Selma</th>\n",
       "      <td>0.1956</td>\n",
       "      <td>0.7449</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>0.0040</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0033</td>\n",
       "      <td>0.0040</td>\n",
       "      <td>0.0443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Herzing University-Birmingham</th>\n",
       "      <td>0.3543</td>\n",
       "      <td>0.5265</td>\n",
       "      <td>0.0166</td>\n",
       "      <td>0.0066</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0563</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Huntingdon College</th>\n",
       "      <td>0.6388</td>\n",
       "      <td>0.1993</td>\n",
       "      <td>0.0252</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>0.0122</td>\n",
       "      <td>0.0017</td>\n",
       "      <td>0.0261</td>\n",
       "      <td>0.0061</td>\n",
       "      <td>0.0827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heritage Christian University</th>\n",
       "      <td>0.7419</td>\n",
       "      <td>0.1129</td>\n",
       "      <td>0.0484</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0323</td>\n",
       "      <td>0.0161</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0161</td>\n",
       "      <td>0.0323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J F Drake State Community and Technical College</th>\n",
       "      <td>0.3337</td>\n",
       "      <td>0.5965</td>\n",
       "      <td>0.0246</td>\n",
       "      <td>0.0082</td>\n",
       "      <td>0.0113</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>0.0185</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jacksonville State University</th>\n",
       "      <td>0.6834</td>\n",
       "      <td>0.2382</td>\n",
       "      <td>0.0132</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>0.0072</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0234</td>\n",
       "      <td>0.0280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson Davis Community College</th>\n",
       "      <td>0.5857</td>\n",
       "      <td>0.2982</td>\n",
       "      <td>0.0077</td>\n",
       "      <td>0.0252</td>\n",
       "      <td>0.0252</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0184</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson State Community College</th>\n",
       "      <td>0.6696</td>\n",
       "      <td>0.2246</td>\n",
       "      <td>0.0486</td>\n",
       "      <td>0.0183</td>\n",
       "      <td>0.0024</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>0.0301</td>\n",
       "      <td>0.0054</td>\n",
       "      <td>0.0001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>John C Calhoun State Community College</th>\n",
       "      <td>0.6528</td>\n",
       "      <td>0.1940</td>\n",
       "      <td>0.0435</td>\n",
       "      <td>0.0257</td>\n",
       "      <td>0.0182</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>0.0428</td>\n",
       "      <td>0.0062</td>\n",
       "      <td>0.0162</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Lawrenceville</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Piscataway</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Utah County Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>L'esprit Academy - Royal Oak</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Career Institute - Jersey City Branch</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Cobb Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Morrow Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Roswell Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Douglasville Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Lithonia Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Savannah Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Augusta Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Columbus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Columbia Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Charleston Campus</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Irving</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Katy</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Northwest Houston</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Plano</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Cedar Hill</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-North Dallas</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-San Antonio</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strayer University-Stafford</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WestMed College - Merced</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vantage College</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAE Institute of Technology  San Francisco</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rasmussen College - Overland Park</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Personal Training Institute of Cleveland</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bay Area Medical Academy - San Jose Satellite Location</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Excel Learning Center-San Antonio South</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7535 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    UGDS_WHITE  UGDS_BLACK  \\\n",
       "INSTNM                                                                       \n",
       "Alabama A & M University                                0.0333      0.9353   \n",
       "University of Alabama at Birmingham                     0.5922      0.2600   \n",
       "Amridge University                                      0.2990      0.4192   \n",
       "University of Alabama in Huntsville                     0.6988      0.1255   \n",
       "Alabama State University                                0.0158      0.9208   \n",
       "The University of Alabama                               0.7825      0.1119   \n",
       "Central Alabama Community College                       0.7255      0.2613   \n",
       "Athens State University                                 0.7823      0.1200   \n",
       "Auburn University at Montgomery                         0.5328      0.3376   \n",
       "Auburn University                                       0.8507      0.0704   \n",
       "Birmingham Southern College                             0.7983      0.1102   \n",
       "Chattahoochee Valley Community College                  0.4661      0.4372   \n",
       "Concordia College Alabama                               0.0280      0.8758   \n",
       "South University-Montgomery                             0.3046      0.6054   \n",
       "Enterprise State Community College                      0.6408      0.2435   \n",
       "James H Faulkner State Community College                0.6979      0.2259   \n",
       "Faulkner University                                     0.3874      0.5137   \n",
       "Gadsden State Community College                         0.6921      0.2076   \n",
       "New Beginning College of Cosmetology                    0.8957      0.0348   \n",
       "George C Wallace State Community College-Dothan         0.6273      0.3240   \n",
       "George C Wallace State Community College-Hancev...      0.8630      0.0612   \n",
       "George C Wallace State Community College-Selma          0.1956      0.7449   \n",
       "Herzing University-Birmingham                           0.3543      0.5265   \n",
       "Huntingdon College                                      0.6388      0.1993   \n",
       "Heritage Christian University                           0.7419      0.1129   \n",
       "J F Drake State Community and Technical College         0.3337      0.5965   \n",
       "Jacksonville State University                           0.6834      0.2382   \n",
       "Jefferson Davis Community College                       0.5857      0.2982   \n",
       "Jefferson State Community College                       0.6696      0.2246   \n",
       "John C Calhoun State Community College                  0.6528      0.1940   \n",
       "...                                                        ...         ...   \n",
       "Strayer University-Lawrenceville                           NaN         NaN   \n",
       "Strayer University-Piscataway                              NaN         NaN   \n",
       "Utah County Campus                                         NaN         NaN   \n",
       "L'esprit Academy - Royal Oak                               NaN         NaN   \n",
       "National Career Institute - Jersey City Branch             NaN         NaN   \n",
       "Strayer University-Cobb Campus                             NaN         NaN   \n",
       "Strayer University-Morrow Campus                           NaN         NaN   \n",
       "Strayer University-Roswell Campus                          NaN         NaN   \n",
       "Strayer University-Douglasville Campus                     NaN         NaN   \n",
       "Strayer University-Lithonia Campus                         NaN         NaN   \n",
       "Strayer University-Savannah Campus                         NaN         NaN   \n",
       "Strayer University-Augusta Campus                          NaN         NaN   \n",
       "Strayer University-Columbus                                NaN         NaN   \n",
       "Strayer University-Columbia Campus                         NaN         NaN   \n",
       "Strayer University-Charleston Campus                       NaN         NaN   \n",
       "Strayer University-Irving                                  NaN         NaN   \n",
       "Strayer University-Katy                                    NaN         NaN   \n",
       "Strayer University-Northwest Houston                       NaN         NaN   \n",
       "Strayer University-Plano                                   NaN         NaN   \n",
       "Strayer University-Cedar Hill                              NaN         NaN   \n",
       "Strayer University-North Dallas                            NaN         NaN   \n",
       "Strayer University-San Antonio                             NaN         NaN   \n",
       "Strayer University-Stafford                                NaN         NaN   \n",
       "WestMed College - Merced                                   NaN         NaN   \n",
       "Vantage College                                            NaN         NaN   \n",
       "SAE Institute of Technology  San Francisco                 NaN         NaN   \n",
       "Rasmussen College - Overland Park                          NaN         NaN   \n",
       "National Personal Training Institute of Cleveland          NaN         NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...         NaN         NaN   \n",
       "Excel Learning Center-San Antonio South                    NaN         NaN   \n",
       "\n",
       "                                                    UGDS_HISP  UGDS_ASIAN  \\\n",
       "INSTNM                                                                      \n",
       "Alabama A & M University                               0.0055      0.0019   \n",
       "University of Alabama at Birmingham                    0.0283      0.0518   \n",
       "Amridge University                                     0.0069      0.0034   \n",
       "University of Alabama in Huntsville                    0.0382      0.0376   \n",
       "Alabama State University                               0.0121      0.0019   \n",
       "The University of Alabama                              0.0348      0.0106   \n",
       "Central Alabama Community College                      0.0044      0.0025   \n",
       "Athens State University                                0.0191      0.0053   \n",
       "Auburn University at Montgomery                        0.0074      0.0221   \n",
       "Auburn University                                      0.0248      0.0227   \n",
       "Birmingham Southern College                            0.0195      0.0517   \n",
       "Chattahoochee Valley Community College                 0.0492      0.0127   \n",
       "Concordia College Alabama                              0.0373      0.0093   \n",
       "South University-Montgomery                            0.0153      0.0153   \n",
       "Enterprise State Community College                     0.0509      0.0202   \n",
       "James H Faulkner State Community College               0.0320      0.0084   \n",
       "Faulkner University                                    0.0258      0.0042   \n",
       "Gadsden State Community College                        0.0305      0.0047   \n",
       "New Beginning College of Cosmetology                   0.0696      0.0000   \n",
       "George C Wallace State Community College-Dothan        0.0221      0.0072   \n",
       "George C Wallace State Community College-Hancev...     0.0362      0.0065   \n",
       "George C Wallace State Community College-Selma         0.0026      0.0040   \n",
       "Herzing University-Birmingham                          0.0166      0.0066   \n",
       "Huntingdon College                                     0.0252      0.0078   \n",
       "Heritage Christian University                          0.0484      0.0000   \n",
       "J F Drake State Community and Technical College        0.0246      0.0082   \n",
       "Jacksonville State University                          0.0132      0.0055   \n",
       "Jefferson Davis Community College                      0.0077      0.0252   \n",
       "Jefferson State Community College                      0.0486      0.0183   \n",
       "John C Calhoun State Community College                 0.0435      0.0257   \n",
       "...                                                       ...         ...   \n",
       "Strayer University-Lawrenceville                          NaN         NaN   \n",
       "Strayer University-Piscataway                             NaN         NaN   \n",
       "Utah County Campus                                        NaN         NaN   \n",
       "L'esprit Academy - Royal Oak                              NaN         NaN   \n",
       "National Career Institute - Jersey City Branch            NaN         NaN   \n",
       "Strayer University-Cobb Campus                            NaN         NaN   \n",
       "Strayer University-Morrow Campus                          NaN         NaN   \n",
       "Strayer University-Roswell Campus                         NaN         NaN   \n",
       "Strayer University-Douglasville Campus                    NaN         NaN   \n",
       "Strayer University-Lithonia Campus                        NaN         NaN   \n",
       "Strayer University-Savannah Campus                        NaN         NaN   \n",
       "Strayer University-Augusta Campus                         NaN         NaN   \n",
       "Strayer University-Columbus                               NaN         NaN   \n",
       "Strayer University-Columbia Campus                        NaN         NaN   \n",
       "Strayer University-Charleston Campus                      NaN         NaN   \n",
       "Strayer University-Irving                                 NaN         NaN   \n",
       "Strayer University-Katy                                   NaN         NaN   \n",
       "Strayer University-Northwest Houston                      NaN         NaN   \n",
       "Strayer University-Plano                                  NaN         NaN   \n",
       "Strayer University-Cedar Hill                             NaN         NaN   \n",
       "Strayer University-North Dallas                           NaN         NaN   \n",
       "Strayer University-San Antonio                            NaN         NaN   \n",
       "Strayer University-Stafford                               NaN         NaN   \n",
       "WestMed College - Merced                                  NaN         NaN   \n",
       "Vantage College                                           NaN         NaN   \n",
       "SAE Institute of Technology  San Francisco                NaN         NaN   \n",
       "Rasmussen College - Overland Park                         NaN         NaN   \n",
       "National Personal Training Institute of Cleveland         NaN         NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN         NaN   \n",
       "Excel Learning Center-San Antonio South                   NaN         NaN   \n",
       "\n",
       "                                                    UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                     \n",
       "Alabama A & M University                               0.0024     0.0019   \n",
       "University of Alabama at Birmingham                    0.0022     0.0007   \n",
       "Amridge University                                     0.0000     0.0000   \n",
       "University of Alabama in Huntsville                    0.0143     0.0002   \n",
       "Alabama State University                               0.0010     0.0006   \n",
       "The University of Alabama                              0.0038     0.0009   \n",
       "Central Alabama Community College                      0.0044     0.0000   \n",
       "Athens State University                                0.0157     0.0010   \n",
       "Auburn University at Montgomery                        0.0044     0.0016   \n",
       "Auburn University                                      0.0074     0.0000   \n",
       "Birmingham Southern College                            0.0102     0.0000   \n",
       "Chattahoochee Valley Community College                 0.0023     0.0035   \n",
       "Concordia College Alabama                              0.0000     0.0000   \n",
       "South University-Montgomery                            0.0153     0.0096   \n",
       "Enterprise State Community College                     0.0081     0.0029   \n",
       "James H Faulkner State Community College               0.0177     0.0014   \n",
       "Faulkner University                                    0.0063     0.0013   \n",
       "Gadsden State Community College                        0.0128     0.0018   \n",
       "New Beginning College of Cosmetology                   0.0000     0.0000   \n",
       "George C Wallace State Community College-Dothan        0.0049     0.0009   \n",
       "George C Wallace State Community College-Hancev...     0.0089     0.0000   \n",
       "George C Wallace State Community College-Selma         0.0013     0.0000   \n",
       "Herzing University-Birmingham                          0.0000     0.0000   \n",
       "Huntingdon College                                     0.0122     0.0017   \n",
       "Heritage Christian University                          0.0323     0.0161   \n",
       "J F Drake State Community and Technical College        0.0113     0.0010   \n",
       "Jacksonville State University                          0.0072     0.0010   \n",
       "Jefferson Davis Community College                      0.0252     0.0000   \n",
       "Jefferson State Community College                      0.0024     0.0008   \n",
       "John C Calhoun State Community College                 0.0182     0.0006   \n",
       "...                                                       ...        ...   \n",
       "Strayer University-Lawrenceville                          NaN        NaN   \n",
       "Strayer University-Piscataway                             NaN        NaN   \n",
       "Utah County Campus                                        NaN        NaN   \n",
       "L'esprit Academy - Royal Oak                              NaN        NaN   \n",
       "National Career Institute - Jersey City Branch            NaN        NaN   \n",
       "Strayer University-Cobb Campus                            NaN        NaN   \n",
       "Strayer University-Morrow Campus                          NaN        NaN   \n",
       "Strayer University-Roswell Campus                         NaN        NaN   \n",
       "Strayer University-Douglasville Campus                    NaN        NaN   \n",
       "Strayer University-Lithonia Campus                        NaN        NaN   \n",
       "Strayer University-Savannah Campus                        NaN        NaN   \n",
       "Strayer University-Augusta Campus                         NaN        NaN   \n",
       "Strayer University-Columbus                               NaN        NaN   \n",
       "Strayer University-Columbia Campus                        NaN        NaN   \n",
       "Strayer University-Charleston Campus                      NaN        NaN   \n",
       "Strayer University-Irving                                 NaN        NaN   \n",
       "Strayer University-Katy                                   NaN        NaN   \n",
       "Strayer University-Northwest Houston                      NaN        NaN   \n",
       "Strayer University-Plano                                  NaN        NaN   \n",
       "Strayer University-Cedar Hill                             NaN        NaN   \n",
       "Strayer University-North Dallas                           NaN        NaN   \n",
       "Strayer University-San Antonio                            NaN        NaN   \n",
       "Strayer University-Stafford                               NaN        NaN   \n",
       "WestMed College - Merced                                  NaN        NaN   \n",
       "Vantage College                                           NaN        NaN   \n",
       "SAE Institute of Technology  San Francisco                NaN        NaN   \n",
       "Rasmussen College - Overland Park                         NaN        NaN   \n",
       "National Personal Training Institute of Cleveland         NaN        NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN        NaN   \n",
       "Excel Learning Center-San Antonio South                   NaN        NaN   \n",
       "\n",
       "                                                    UGDS_2MOR  UGDS_NRA  \\\n",
       "INSTNM                                                                    \n",
       "Alabama A & M University                               0.0000    0.0059   \n",
       "University of Alabama at Birmingham                    0.0368    0.0179   \n",
       "Amridge University                                     0.0000    0.0000   \n",
       "University of Alabama in Huntsville                    0.0172    0.0332   \n",
       "Alabama State University                               0.0098    0.0243   \n",
       "The University of Alabama                              0.0261    0.0268   \n",
       "Central Alabama Community College                      0.0000    0.0000   \n",
       "Athens State University                                0.0174    0.0057   \n",
       "Auburn University at Montgomery                        0.0297    0.0397   \n",
       "Auburn University                                      0.0000    0.0100   \n",
       "Birmingham Southern College                            0.0051    0.0000   \n",
       "Chattahoochee Valley Community College                 0.0151    0.0000   \n",
       "Concordia College Alabama                              0.0031    0.0466   \n",
       "South University-Montgomery                            0.0000    0.0019   \n",
       "Enterprise State Community College                     0.0254    0.0012   \n",
       "James H Faulkner State Community College               0.0152    0.0007   \n",
       "Faulkner University                                    0.0173    0.0182   \n",
       "Gadsden State Community College                        0.0185    0.0150   \n",
       "New Beginning College of Cosmetology                   0.0000    0.0000   \n",
       "George C Wallace State Community College-Dothan        0.0126    0.0000   \n",
       "George C Wallace State Community College-Hancev...     0.0000    0.0059   \n",
       "George C Wallace State Community College-Selma         0.0033    0.0040   \n",
       "Herzing University-Birmingham                          0.0563    0.0000   \n",
       "Huntingdon College                                     0.0261    0.0061   \n",
       "Heritage Christian University                          0.0000    0.0161   \n",
       "J F Drake State Community and Technical College        0.0185    0.0000   \n",
       "Jacksonville State University                          0.0000    0.0234   \n",
       "Jefferson Davis Community College                      0.0184    0.0000   \n",
       "Jefferson State Community College                      0.0301    0.0054   \n",
       "John C Calhoun State Community College                 0.0428    0.0062   \n",
       "...                                                       ...       ...   \n",
       "Strayer University-Lawrenceville                          NaN       NaN   \n",
       "Strayer University-Piscataway                             NaN       NaN   \n",
       "Utah County Campus                                        NaN       NaN   \n",
       "L'esprit Academy - Royal Oak                              NaN       NaN   \n",
       "National Career Institute - Jersey City Branch            NaN       NaN   \n",
       "Strayer University-Cobb Campus                            NaN       NaN   \n",
       "Strayer University-Morrow Campus                          NaN       NaN   \n",
       "Strayer University-Roswell Campus                         NaN       NaN   \n",
       "Strayer University-Douglasville Campus                    NaN       NaN   \n",
       "Strayer University-Lithonia Campus                        NaN       NaN   \n",
       "Strayer University-Savannah Campus                        NaN       NaN   \n",
       "Strayer University-Augusta Campus                         NaN       NaN   \n",
       "Strayer University-Columbus                               NaN       NaN   \n",
       "Strayer University-Columbia Campus                        NaN       NaN   \n",
       "Strayer University-Charleston Campus                      NaN       NaN   \n",
       "Strayer University-Irving                                 NaN       NaN   \n",
       "Strayer University-Katy                                   NaN       NaN   \n",
       "Strayer University-Northwest Houston                      NaN       NaN   \n",
       "Strayer University-Plano                                  NaN       NaN   \n",
       "Strayer University-Cedar Hill                             NaN       NaN   \n",
       "Strayer University-North Dallas                           NaN       NaN   \n",
       "Strayer University-San Antonio                            NaN       NaN   \n",
       "Strayer University-Stafford                               NaN       NaN   \n",
       "WestMed College - Merced                                  NaN       NaN   \n",
       "Vantage College                                           NaN       NaN   \n",
       "SAE Institute of Technology  San Francisco                NaN       NaN   \n",
       "Rasmussen College - Overland Park                         NaN       NaN   \n",
       "National Personal Training Institute of Cleveland         NaN       NaN   \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN       NaN   \n",
       "Excel Learning Center-San Antonio South                   NaN       NaN   \n",
       "\n",
       "                                                    UGDS_UNKN  \n",
       "INSTNM                                                         \n",
       "Alabama A & M University                               0.0138  \n",
       "University of Alabama at Birmingham                    0.0100  \n",
       "Amridge University                                     0.2715  \n",
       "University of Alabama in Huntsville                    0.0350  \n",
       "Alabama State University                               0.0137  \n",
       "The University of Alabama                              0.0026  \n",
       "Central Alabama Community College                      0.0019  \n",
       "Athens State University                                0.0334  \n",
       "Auburn University at Montgomery                        0.0246  \n",
       "Auburn University                                      0.0140  \n",
       "Birmingham Southern College                            0.0051  \n",
       "Chattahoochee Valley Community College                 0.0139  \n",
       "Concordia College Alabama                              0.0000  \n",
       "South University-Montgomery                            0.0326  \n",
       "Enterprise State Community College                     0.0069  \n",
       "James H Faulkner State Community College               0.0009  \n",
       "Faulkner University                                    0.0258  \n",
       "Gadsden State Community College                        0.0169  \n",
       "New Beginning College of Cosmetology                   0.0000  \n",
       "George C Wallace State Community College-Dothan        0.0009  \n",
       "George C Wallace State Community College-Hancev...     0.0183  \n",
       "George C Wallace State Community College-Selma         0.0443  \n",
       "Herzing University-Birmingham                          0.0397  \n",
       "Huntingdon College                                     0.0827  \n",
       "Heritage Christian University                          0.0323  \n",
       "J F Drake State Community and Technical College        0.0062  \n",
       "Jacksonville State University                          0.0280  \n",
       "Jefferson Davis Community College                      0.0397  \n",
       "Jefferson State Community College                      0.0001  \n",
       "John C Calhoun State Community College                 0.0162  \n",
       "...                                                       ...  \n",
       "Strayer University-Lawrenceville                          NaN  \n",
       "Strayer University-Piscataway                             NaN  \n",
       "Utah County Campus                                        NaN  \n",
       "L'esprit Academy - Royal Oak                              NaN  \n",
       "National Career Institute - Jersey City Branch            NaN  \n",
       "Strayer University-Cobb Campus                            NaN  \n",
       "Strayer University-Morrow Campus                          NaN  \n",
       "Strayer University-Roswell Campus                         NaN  \n",
       "Strayer University-Douglasville Campus                    NaN  \n",
       "Strayer University-Lithonia Campus                        NaN  \n",
       "Strayer University-Savannah Campus                        NaN  \n",
       "Strayer University-Augusta Campus                         NaN  \n",
       "Strayer University-Columbus                               NaN  \n",
       "Strayer University-Columbia Campus                        NaN  \n",
       "Strayer University-Charleston Campus                      NaN  \n",
       "Strayer University-Irving                                 NaN  \n",
       "Strayer University-Katy                                   NaN  \n",
       "Strayer University-Northwest Houston                      NaN  \n",
       "Strayer University-Plano                                  NaN  \n",
       "Strayer University-Cedar Hill                             NaN  \n",
       "Strayer University-North Dallas                           NaN  \n",
       "Strayer University-San Antonio                            NaN  \n",
       "Strayer University-Stafford                               NaN  \n",
       "WestMed College - Merced                                  NaN  \n",
       "Vantage College                                           NaN  \n",
       "SAE Institute of Technology  San Francisco                NaN  \n",
       "Rasmussen College - Overland Park                         NaN  \n",
       "National Personal Training Institute of Cleveland         NaN  \n",
       "Bay Area Medical Academy - San Jose Satellite L...        NaN  \n",
       "Excel Learning Center-San Antonio South                   NaN  \n",
       "\n",
       "[7535 rows x 9 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "college_ugds_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE   NaN\n",
       "UGDS_BLACK   NaN\n",
       "UGDS_HISP    NaN\n",
       "UGDS_ASIAN   NaN\n",
       "UGDS_AIAN    NaN\n",
       "UGDS_NHPI    NaN\n",
       "UGDS_2MOR    NaN\n",
       "UGDS_NRA     NaN\n",
       "UGDS_UNKN    NaN\n",
       "Name: Excel Learning Center-San Antonio South, dtype: float64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "college_ugds_.loc['Excel Learning Center-San Antonio South']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Excel Learning Center-San Antonio South         9\n",
       "Philadelphia College of Osteopathic Medicine    9\n",
       "Assemblies of God Theological Seminary          9\n",
       "Episcopal Divinity School                       9\n",
       "Phillips Graduate Institute                     9\n",
       "dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# colleges that are missing all their race columns\n",
    "college_ugds_.isnull()\\\n",
    ".sum(axis=1)\\\n",
    ".sort_values(ascending=False)\\\n",
    ".head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE    0\n",
       "UGDS_BLACK    0\n",
       "UGDS_HISP     0\n",
       "UGDS_ASIAN    0\n",
       "UGDS_AIAN     0\n",
       "UGDS_NHPI     0\n",
       "UGDS_2MOR     0\n",
       "UGDS_NRA      0\n",
       "UGDS_UNKN     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Use the dropna method to drop all rows that have all nine race percentages\n",
    "college_ugds_ = college_ugds_.dropna(how='all')\n",
    "# We can then count the remaining missing values:   There are no missing values left in the dataset.\n",
    "college_ugds_.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "UGDS_WHITE    0\n",
       "UGDS_BLACK    0\n",
       "UGDS_HISP     0\n",
       "UGDS_ASIAN    0\n",
       "UGDS_AIAN     0\n",
       "UGDS_NHPI     0\n",
       "UGDS_2MOR     0\n",
       "UGDS_NRA      0\n",
       "UGDS_UNKN     0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "Now that we have seen the colleges that are missing all their race columns, we\n",
    "can use the dropna method to drop all rows that have all nine race percentages\n",
    "missing. We can then count the remaining missing values:'''\n",
    "\n",
    "college_ugds_ = college_ugds_.dropna(how='all')\n",
    "college_ugds_.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Alabama A &amp; M University</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama at Birmingham</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amridge University</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Alabama in Huntsville</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alabama State University</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The University of Alabama</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central Alabama Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Athens State University</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University at Montgomery</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Auburn University</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Birmingham Southern College</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chattahoochee Valley Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Concordia College Alabama</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South University-Montgomery</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Enterprise State Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>James H Faulkner State Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Faulkner University</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gadsden State Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Beginning College of Cosmetology</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Dothan</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Hanceville</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>George C Wallace State Community College-Selma</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Herzing University-Birmingham</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Huntingdon College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heritage Christian University</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>J F Drake State Community and Technical College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jacksonville State University</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson Davis Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jefferson State Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>John C Calhoun State Community College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tint School of Makeup &amp; Cosmetology-Seattle</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Centro de Estudios Multidisciplinarios-Mayaguez</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heritage College-Cleveland</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aveda Institute-Phoenix</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of North Texas at Dallas</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BridgeValley Community &amp; Technical College</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Northwest College-Medford</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Virginia College-Fort Pierce</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Houston Training Schools-Gessner</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Empire Beauty School-Buffalo</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Paul Mitchell the School-Toledo</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MJ's Barber Academy</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Trine University-Arizona Regional Campus</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Regency Beauty Institute-Gaithersburg</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Georgia Military College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Horizons Medical Institute-Winder</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAE Institute of Technology-Chicago</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Beau Monde College of Hair Design-Beau Monde Academy of Cosmetology</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fayette Beauty Academy-Ritz Beauty Academy</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fountain of Youth Academy of Cosmetology</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MCI Institute of Technology-Boca Raton</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Coast University-Miami</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National American University-Houston</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aparicio-Levy Technical College</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fred D. Learey Technical College</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hollywood Institute of Beauty Careers-West Palm Beach</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hollywood Institute of Beauty Careers-Casselberry</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Coachella Valley Beauty College-Beaumont</th>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dewey University-Mayaguez</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Coastal Pines Technical College</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6874 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    UGDS_WHITE  UGDS_BLACK  \\\n",
       "INSTNM                                                                       \n",
       "Alabama A & M University                                 False        True   \n",
       "University of Alabama at Birmingham                       True        True   \n",
       "Amridge University                                        True        True   \n",
       "University of Alabama in Huntsville                       True       False   \n",
       "Alabama State University                                 False        True   \n",
       "The University of Alabama                                 True       False   \n",
       "Central Alabama Community College                         True        True   \n",
       "Athens State University                                   True       False   \n",
       "Auburn University at Montgomery                           True        True   \n",
       "Auburn University                                         True       False   \n",
       "Birmingham Southern College                               True       False   \n",
       "Chattahoochee Valley Community College                    True        True   \n",
       "Concordia College Alabama                                False        True   \n",
       "South University-Montgomery                               True        True   \n",
       "Enterprise State Community College                        True        True   \n",
       "James H Faulkner State Community College                  True        True   \n",
       "Faulkner University                                       True        True   \n",
       "Gadsden State Community College                           True        True   \n",
       "New Beginning College of Cosmetology                      True       False   \n",
       "George C Wallace State Community College-Dothan           True        True   \n",
       "George C Wallace State Community College-Hancev...        True       False   \n",
       "George C Wallace State Community College-Selma            True        True   \n",
       "Herzing University-Birmingham                             True        True   \n",
       "Huntingdon College                                        True        True   \n",
       "Heritage Christian University                             True       False   \n",
       "J F Drake State Community and Technical College           True        True   \n",
       "Jacksonville State University                             True        True   \n",
       "Jefferson Davis Community College                         True        True   \n",
       "Jefferson State Community College                         True        True   \n",
       "John C Calhoun State Community College                    True        True   \n",
       "...                                                        ...         ...   \n",
       "Tint School of Makeup & Cosmetology-Seattle               True       False   \n",
       "Centro de Estudios Multidisciplinarios-Mayaguez          False       False   \n",
       "Heritage College-Cleveland                                True        True   \n",
       "Aveda Institute-Phoenix                                   True       False   \n",
       "University of North Texas at Dallas                      False        True   \n",
       "BridgeValley Community & Technical College                True       False   \n",
       "Northwest College-Medford                                 True       False   \n",
       "Virginia College-Fort Pierce                              True        True   \n",
       "Houston Training Schools-Gessner                         False       False   \n",
       "Empire Beauty School-Buffalo                              True        True   \n",
       "Paul Mitchell the School-Toledo                           True        True   \n",
       "MJ's Barber Academy                                      False        True   \n",
       "Trine University-Arizona Regional Campus                  True       False   \n",
       "Regency Beauty Institute-Gaithersburg                     True        True   \n",
       "Georgia Military College                                  True        True   \n",
       "New Horizons Medical Institute-Winder                     True        True   \n",
       "SAE Institute of Technology-Chicago                       True        True   \n",
       "Beau Monde College of Hair Design-Beau Monde Ac...        True       False   \n",
       "Fayette Beauty Academy-Ritz Beauty Academy               False        True   \n",
       "Fountain of Youth Academy of Cosmetology                  True       False   \n",
       "MCI Institute of Technology-Boca Raton                   False        True   \n",
       "West Coast University-Miami                               True        True   \n",
       "National American University-Houston                      True        True   \n",
       "Aparicio-Levy Technical College                           True       False   \n",
       "Fred D. Learey Technical College                          True       False   \n",
       "Hollywood Institute of Beauty Careers-West Palm...        True        True   \n",
       "Hollywood Institute of Beauty Careers-Casselberry        False        True   \n",
       "Coachella Valley Beauty College-Beaumont                  True       False   \n",
       "Dewey University-Mayaguez                                False       False   \n",
       "Coastal Pines Technical College                           True        True   \n",
       "\n",
       "                                                    UGDS_HISP  UGDS_ASIAN  \\\n",
       "INSTNM                                                                      \n",
       "Alabama A & M University                                False       False   \n",
       "University of Alabama at Birmingham                     False       False   \n",
       "Amridge University                                      False       False   \n",
       "University of Alabama in Huntsville                     False       False   \n",
       "Alabama State University                                False       False   \n",
       "The University of Alabama                               False       False   \n",
       "Central Alabama Community College                       False       False   \n",
       "Athens State University                                 False       False   \n",
       "Auburn University at Montgomery                         False       False   \n",
       "Auburn University                                       False       False   \n",
       "Birmingham Southern College                             False       False   \n",
       "Chattahoochee Valley Community College                  False       False   \n",
       "Concordia College Alabama                               False       False   \n",
       "South University-Montgomery                             False       False   \n",
       "Enterprise State Community College                      False       False   \n",
       "James H Faulkner State Community College                False       False   \n",
       "Faulkner University                                     False       False   \n",
       "Gadsden State Community College                         False       False   \n",
       "New Beginning College of Cosmetology                    False       False   \n",
       "George C Wallace State Community College-Dothan         False       False   \n",
       "George C Wallace State Community College-Hancev...      False       False   \n",
       "George C Wallace State Community College-Selma          False       False   \n",
       "Herzing University-Birmingham                           False       False   \n",
       "Huntingdon College                                      False       False   \n",
       "Heritage Christian University                           False       False   \n",
       "J F Drake State Community and Technical College         False       False   \n",
       "Jacksonville State University                           False       False   \n",
       "Jefferson Davis Community College                       False       False   \n",
       "Jefferson State Community College                       False       False   \n",
       "John C Calhoun State Community College                  False       False   \n",
       "...                                                       ...         ...   \n",
       "Tint School of Makeup & Cosmetology-Seattle              True       False   \n",
       "Centro de Estudios Multidisciplinarios-Mayaguez          True       False   \n",
       "Heritage College-Cleveland                              False       False   \n",
       "Aveda Institute-Phoenix                                  True       False   \n",
       "University of North Texas at Dallas                      True       False   \n",
       "BridgeValley Community & Technical College              False       False   \n",
       "Northwest College-Medford                                True       False   \n",
       "Virginia College-Fort Pierce                            False       False   \n",
       "Houston Training Schools-Gessner                         True       False   \n",
       "Empire Beauty School-Buffalo                            False       False   \n",
       "Paul Mitchell the School-Toledo                         False       False   \n",
       "MJ's Barber Academy                                     False       False   \n",
       "Trine University-Arizona Regional Campus                 True       False   \n",
       "Regency Beauty Institute-Gaithersburg                    True       False   \n",
       "Georgia Military College                                False       False   \n",
       "New Horizons Medical Institute-Winder                   False       False   \n",
       "SAE Institute of Technology-Chicago                      True       False   \n",
       "Beau Monde College of Hair Design-Beau Monde Ac...       True       False   \n",
       "Fayette Beauty Academy-Ritz Beauty Academy              False       False   \n",
       "Fountain of Youth Academy of Cosmetology                False       False   \n",
       "MCI Institute of Technology-Boca Raton                   True       False   \n",
       "West Coast University-Miami                              True       False   \n",
       "National American University-Houston                    False       False   \n",
       "Aparicio-Levy Technical College                          True       False   \n",
       "Fred D. Learey Technical College                         True       False   \n",
       "Hollywood Institute of Beauty Careers-West Palm...       True       False   \n",
       "Hollywood Institute of Beauty Careers-Casselberry        True       False   \n",
       "Coachella Valley Beauty College-Beaumont                 True       False   \n",
       "Dewey University-Mayaguez                                True       False   \n",
       "Coastal Pines Technical College                         False       False   \n",
       "\n",
       "                                                    UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                     \n",
       "Alabama A & M University                                False      False   \n",
       "University of Alabama at Birmingham                     False      False   \n",
       "Amridge University                                      False      False   \n",
       "University of Alabama in Huntsville                     False      False   \n",
       "Alabama State University                                False      False   \n",
       "The University of Alabama                               False      False   \n",
       "Central Alabama Community College                       False      False   \n",
       "Athens State University                                 False      False   \n",
       "Auburn University at Montgomery                         False      False   \n",
       "Auburn University                                       False      False   \n",
       "Birmingham Southern College                             False      False   \n",
       "Chattahoochee Valley Community College                  False      False   \n",
       "Concordia College Alabama                               False      False   \n",
       "South University-Montgomery                             False      False   \n",
       "Enterprise State Community College                      False      False   \n",
       "James H Faulkner State Community College                False      False   \n",
       "Faulkner University                                     False      False   \n",
       "Gadsden State Community College                         False      False   \n",
       "New Beginning College of Cosmetology                    False      False   \n",
       "George C Wallace State Community College-Dothan         False      False   \n",
       "George C Wallace State Community College-Hancev...      False      False   \n",
       "George C Wallace State Community College-Selma          False      False   \n",
       "Herzing University-Birmingham                           False      False   \n",
       "Huntingdon College                                      False      False   \n",
       "Heritage Christian University                           False      False   \n",
       "J F Drake State Community and Technical College         False      False   \n",
       "Jacksonville State University                           False      False   \n",
       "Jefferson Davis Community College                       False      False   \n",
       "Jefferson State Community College                       False      False   \n",
       "John C Calhoun State Community College                  False      False   \n",
       "...                                                       ...        ...   \n",
       "Tint School of Makeup & Cosmetology-Seattle             False      False   \n",
       "Centro de Estudios Multidisciplinarios-Mayaguez         False      False   \n",
       "Heritage College-Cleveland                              False      False   \n",
       "Aveda Institute-Phoenix                                 False      False   \n",
       "University of North Texas at Dallas                     False      False   \n",
       "BridgeValley Community & Technical College              False      False   \n",
       "Northwest College-Medford                               False      False   \n",
       "Virginia College-Fort Pierce                            False      False   \n",
       "Houston Training Schools-Gessner                        False      False   \n",
       "Empire Beauty School-Buffalo                            False      False   \n",
       "Paul Mitchell the School-Toledo                         False       True   \n",
       "MJ's Barber Academy                                     False      False   \n",
       "Trine University-Arizona Regional Campus                False      False   \n",
       "Regency Beauty Institute-Gaithersburg                   False      False   \n",
       "Georgia Military College                                False      False   \n",
       "New Horizons Medical Institute-Winder                   False      False   \n",
       "SAE Institute of Technology-Chicago                     False      False   \n",
       "Beau Monde College of Hair Design-Beau Monde Ac...      False      False   \n",
       "Fayette Beauty Academy-Ritz Beauty Academy              False      False   \n",
       "Fountain of Youth Academy of Cosmetology                False      False   \n",
       "MCI Institute of Technology-Boca Raton                  False      False   \n",
       "West Coast University-Miami                             False      False   \n",
       "National American University-Houston                    False      False   \n",
       "Aparicio-Levy Technical College                         False      False   \n",
       "Fred D. Learey Technical College                        False      False   \n",
       "Hollywood Institute of Beauty Careers-West Palm...      False      False   \n",
       "Hollywood Institute of Beauty Careers-Casselberry       False      False   \n",
       "Coachella Valley Beauty College-Beaumont                False      False   \n",
       "Dewey University-Mayaguez                               False      False   \n",
       "Coastal Pines Technical College                         False      False   \n",
       "\n",
       "                                                    UGDS_2MOR  UGDS_NRA  \\\n",
       "INSTNM                                                                    \n",
       "Alabama A & M University                                False     False   \n",
       "University of Alabama at Birmingham                     False     False   \n",
       "Amridge University                                      False     False   \n",
       "University of Alabama in Huntsville                     False     False   \n",
       "Alabama State University                                False     False   \n",
       "The University of Alabama                               False     False   \n",
       "Central Alabama Community College                       False     False   \n",
       "Athens State University                                 False     False   \n",
       "Auburn University at Montgomery                         False     False   \n",
       "Auburn University                                       False     False   \n",
       "Birmingham Southern College                             False     False   \n",
       "Chattahoochee Valley Community College                  False     False   \n",
       "Concordia College Alabama                               False     False   \n",
       "South University-Montgomery                             False     False   \n",
       "Enterprise State Community College                      False     False   \n",
       "James H Faulkner State Community College                False     False   \n",
       "Faulkner University                                     False     False   \n",
       "Gadsden State Community College                         False     False   \n",
       "New Beginning College of Cosmetology                    False     False   \n",
       "George C Wallace State Community College-Dothan         False     False   \n",
       "George C Wallace State Community College-Hancev...      False     False   \n",
       "George C Wallace State Community College-Selma          False     False   \n",
       "Herzing University-Birmingham                           False     False   \n",
       "Huntingdon College                                      False     False   \n",
       "Heritage Christian University                           False     False   \n",
       "J F Drake State Community and Technical College         False     False   \n",
       "Jacksonville State University                           False     False   \n",
       "Jefferson Davis Community College                       False     False   \n",
       "Jefferson State Community College                       False     False   \n",
       "John C Calhoun State Community College                  False     False   \n",
       "...                                                       ...       ...   \n",
       "Tint School of Makeup & Cosmetology-Seattle             False     False   \n",
       "Centro de Estudios Multidisciplinarios-Mayaguez         False     False   \n",
       "Heritage College-Cleveland                              False     False   \n",
       "Aveda Institute-Phoenix                                 False     False   \n",
       "University of North Texas at Dallas                     False     False   \n",
       "BridgeValley Community & Technical College              False     False   \n",
       "Northwest College-Medford                               False     False   \n",
       "Virginia College-Fort Pierce                            False     False   \n",
       "Houston Training Schools-Gessner                        False     False   \n",
       "Empire Beauty School-Buffalo                            False     False   \n",
       "Paul Mitchell the School-Toledo                         False     False   \n",
       "MJ's Barber Academy                                     False     False   \n",
       "Trine University-Arizona Regional Campus                False     False   \n",
       "Regency Beauty Institute-Gaithersburg                    True     False   \n",
       "Georgia Military College                                False     False   \n",
       "New Horizons Medical Institute-Winder                   False     False   \n",
       "SAE Institute of Technology-Chicago                     False     False   \n",
       "Beau Monde College of Hair Design-Beau Monde Ac...      False     False   \n",
       "Fayette Beauty Academy-Ritz Beauty Academy              False     False   \n",
       "Fountain of Youth Academy of Cosmetology                False     False   \n",
       "MCI Institute of Technology-Boca Raton                  False     False   \n",
       "West Coast University-Miami                             False     False   \n",
       "National American University-Houston                    False     False   \n",
       "Aparicio-Levy Technical College                         False     False   \n",
       "Fred D. Learey Technical College                        False     False   \n",
       "Hollywood Institute of Beauty Careers-West Palm...      False     False   \n",
       "Hollywood Institute of Beauty Careers-Casselberry       False     False   \n",
       "Coachella Valley Beauty College-Beaumont                False     False   \n",
       "Dewey University-Mayaguez                               False     False   \n",
       "Coastal Pines Technical College                         False     False   \n",
       "\n",
       "                                                    UGDS_UNKN  \n",
       "INSTNM                                                         \n",
       "Alabama A & M University                                False  \n",
       "University of Alabama at Birmingham                     False  \n",
       "Amridge University                                       True  \n",
       "University of Alabama in Huntsville                     False  \n",
       "Alabama State University                                False  \n",
       "The University of Alabama                               False  \n",
       "Central Alabama Community College                       False  \n",
       "Athens State University                                 False  \n",
       "Auburn University at Montgomery                         False  \n",
       "Auburn University                                       False  \n",
       "Birmingham Southern College                             False  \n",
       "Chattahoochee Valley Community College                  False  \n",
       "Concordia College Alabama                               False  \n",
       "South University-Montgomery                             False  \n",
       "Enterprise State Community College                      False  \n",
       "James H Faulkner State Community College                False  \n",
       "Faulkner University                                     False  \n",
       "Gadsden State Community College                         False  \n",
       "New Beginning College of Cosmetology                    False  \n",
       "George C Wallace State Community College-Dothan         False  \n",
       "George C Wallace State Community College-Hancev...      False  \n",
       "George C Wallace State Community College-Selma          False  \n",
       "Herzing University-Birmingham                           False  \n",
       "Huntingdon College                                      False  \n",
       "Heritage Christian University                           False  \n",
       "J F Drake State Community and Technical College         False  \n",
       "Jacksonville State University                           False  \n",
       "Jefferson Davis Community College                       False  \n",
       "Jefferson State Community College                       False  \n",
       "John C Calhoun State Community College                  False  \n",
       "...                                                       ...  \n",
       "Tint School of Makeup & Cosmetology-Seattle             False  \n",
       "Centro de Estudios Multidisciplinarios-Mayaguez         False  \n",
       "Heritage College-Cleveland                              False  \n",
       "Aveda Institute-Phoenix                                 False  \n",
       "University of North Texas at Dallas                     False  \n",
       "BridgeValley Community & Technical College              False  \n",
       "Northwest College-Medford                               False  \n",
       "Virginia College-Fort Pierce                            False  \n",
       "Houston Training Schools-Gessner                        False  \n",
       "Empire Beauty School-Buffalo                            False  \n",
       "Paul Mitchell the School-Toledo                         False  \n",
       "MJ's Barber Academy                                     False  \n",
       "Trine University-Arizona Regional Campus                False  \n",
       "Regency Beauty Institute-Gaithersburg                   False  \n",
       "Georgia Military College                                False  \n",
       "New Horizons Medical Institute-Winder                   False  \n",
       "SAE Institute of Technology-Chicago                     False  \n",
       "Beau Monde College of Hair Design-Beau Monde Ac...      False  \n",
       "Fayette Beauty Academy-Ritz Beauty Academy              False  \n",
       "Fountain of Youth Academy of Cosmetology                False  \n",
       "MCI Institute of Technology-Boca Raton                  False  \n",
       "West Coast University-Miami                             False  \n",
       "National American University-Houston                    False  \n",
       "Aparicio-Levy Technical College                         False  \n",
       "Fred D. Learey Technical College                         True  \n",
       "Hollywood Institute of Beauty Careers-West Palm...      False  \n",
       "Hollywood Institute of Beauty Careers-Casselberry       False  \n",
       "Coachella Valley Beauty College-Beaumont                False  \n",
       "Dewey University-Mayaguez                               False  \n",
       "Coastal Pines Technical College                         False  \n",
       "\n",
       "[6874 rows x 9 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "''' There are no missing values left in the dataset. We can now calculate our\n",
    "diversity metric. To get started, we will use the greater than or equal DataFrame\n",
    "method, ge, to convert each value to a boolean:'''\n",
    "college_ugds_.ge(.15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Alabama A & M University               1\n",
       "University of Alabama at Birmingham    2\n",
       "Amridge University                     3\n",
       "University of Alabama in Huntsville    1\n",
       "Alabama State University               1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''From here, we can use the sum method to count the True values for each college.\n",
    "Notice that a Series is returned:'''\n",
    "diversity_metric = college_ugds_.ge(.15).sum(axis='columns')\n",
    "diversity_metric.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    3042\n",
       "2    2884\n",
       "3     876\n",
       "4      63\n",
       "0       7\n",
       "5       2\n",
       "dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To get an idea of the distribution, let's use the value_counts method on this Series:\n",
    "''' Tehát 3042 olyan iskola van, ahol csak egy olyan kisebbség van, amelynek aránya megaladja a 15%-ot'''\n",
    "diversity_metric.value_counts()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Regency Beauty Institute-Austin          5\n",
       "Central Texas Beauty College-Temple      5\n",
       "Sullivan and Cogliano Training Center    4\n",
       "Ambria College of Nursing                4\n",
       "Berkeley College-New York                4\n",
       "dtype: int64"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# És csak Két olyan iskola, ahol 5 kisebbség van, amelyek aránya egyenként meghaladja a 15%-ot.\n",
    "diversity_metric.sort_values(ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Regency Beauty Institute-Austin</th>\n",
       "      <td>0.1867</td>\n",
       "      <td>0.2133</td>\n",
       "      <td>0.1600</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1733</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.2667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central Texas Beauty College-Temple</th>\n",
       "      <td>0.1616</td>\n",
       "      <td>0.2323</td>\n",
       "      <td>0.2626</td>\n",
       "      <td>0.0202</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1717</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1515</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     UGDS_WHITE  UGDS_BLACK  UGDS_HISP  \\\n",
       "INSTNM                                                                   \n",
       "Regency Beauty Institute-Austin          0.1867      0.2133     0.1600   \n",
       "Central Texas Beauty College-Temple      0.1616      0.2323     0.2626   \n",
       "\n",
       "                                     UGDS_ASIAN  UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                  \n",
       "Regency Beauty Institute-Austin          0.0000        0.0        0.0   \n",
       "Central Texas Beauty College-Temple      0.0202        0.0        0.0   \n",
       "\n",
       "                                     UGDS_2MOR  UGDS_NRA  UGDS_UNKN  \n",
       "INSTNM                                                               \n",
       "Regency Beauty Institute-Austin         0.1733       0.0     0.2667  \n",
       "Central Texas Beauty College-Temple     0.1717       0.0     0.1515  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''It seems a little suspicious that schools can be that diverse. Let's look at the raw\n",
    "percentages from these top two schools. The .loc indexer is used to specifically\n",
    "select based on the index label:\n",
    "It appears that several categories were aggregated into the unknown and two or\n",
    "more races column. Regardless of this, they both appear to be quite diverse.'''\n",
    "college_ugds_.loc[['Regency Beauty Institute-Austin','Central Texas Beauty College-Temple']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "INSTNM\n",
       "Dewey University-Manati                               1.0\n",
       "Yeshiva and Kollel Harbotzas Torah                    1.0\n",
       "Mr Leon's School of Hair Design-Lewiston              1.0\n",
       "Dewey University-Bayamon                              1.0\n",
       "Shepherds Theological Seminary                        1.0\n",
       "Yeshiva Gedolah Kesser Torah                          1.0\n",
       "Monteclaro Escuela de Hoteleria y Artes Culinarias    1.0\n",
       "Yeshiva Shaar Hatorah                                 1.0\n",
       "Bais Medrash Elyon                                    1.0\n",
       "Yeshiva of Nitra Rabbinical College                   1.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''Alternatively, we can find the schools that are least diverse by ordering them by their\n",
    "maximum race percentage:'''\n",
    "college_ugds_.max(axis=1).sort_values(ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''We can also determine if any school has all nine race categories exceeding 1%:'''\n",
    "(college_ugds_ > .01).all(axis=1).any()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UGDS_WHITE</th>\n",
       "      <th>UGDS_BLACK</th>\n",
       "      <th>UGDS_HISP</th>\n",
       "      <th>UGDS_ASIAN</th>\n",
       "      <th>UGDS_AIAN</th>\n",
       "      <th>UGDS_NHPI</th>\n",
       "      <th>UGDS_2MOR</th>\n",
       "      <th>UGDS_NRA</th>\n",
       "      <th>UGDS_UNKN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>INSTNM</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>John F. Kennedy University</th>\n",
       "      <td>0.3665</td>\n",
       "      <td>0.1554</td>\n",
       "      <td>0.2590</td>\n",
       "      <td>0.0837</td>\n",
       "      <td>0.0159</td>\n",
       "      <td>0.0120</td>\n",
       "      <td>0.0359</td>\n",
       "      <td>0.0319</td>\n",
       "      <td>0.0398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National Holistic Institute</th>\n",
       "      <td>0.4122</td>\n",
       "      <td>0.0933</td>\n",
       "      <td>0.1889</td>\n",
       "      <td>0.0689</td>\n",
       "      <td>0.0111</td>\n",
       "      <td>0.0278</td>\n",
       "      <td>0.1522</td>\n",
       "      <td>0.0267</td>\n",
       "      <td>0.0189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Santa Fe University of Art and Design</th>\n",
       "      <td>0.4529</td>\n",
       "      <td>0.0703</td>\n",
       "      <td>0.2765</td>\n",
       "      <td>0.0191</td>\n",
       "      <td>0.0250</td>\n",
       "      <td>0.0179</td>\n",
       "      <td>0.0751</td>\n",
       "      <td>0.0501</td>\n",
       "      <td>0.0131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eastern Oregon University</th>\n",
       "      <td>0.7611</td>\n",
       "      <td>0.0294</td>\n",
       "      <td>0.0624</td>\n",
       "      <td>0.0207</td>\n",
       "      <td>0.0254</td>\n",
       "      <td>0.0113</td>\n",
       "      <td>0.0133</td>\n",
       "      <td>0.0150</td>\n",
       "      <td>0.0614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New Hope Christian College-Eugene</th>\n",
       "      <td>0.6111</td>\n",
       "      <td>0.0370</td>\n",
       "      <td>0.0864</td>\n",
       "      <td>0.0370</td>\n",
       "      <td>0.0123</td>\n",
       "      <td>0.0432</td>\n",
       "      <td>0.0926</td>\n",
       "      <td>0.0247</td>\n",
       "      <td>0.0556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Salt Lake Community College</th>\n",
       "      <td>0.6888</td>\n",
       "      <td>0.0248</td>\n",
       "      <td>0.1612</td>\n",
       "      <td>0.0405</td>\n",
       "      <td>0.0104</td>\n",
       "      <td>0.0128</td>\n",
       "      <td>0.0256</td>\n",
       "      <td>0.0132</td>\n",
       "      <td>0.0227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Northwest University</th>\n",
       "      <td>0.6827</td>\n",
       "      <td>0.0447</td>\n",
       "      <td>0.0853</td>\n",
       "      <td>0.0475</td>\n",
       "      <td>0.0124</td>\n",
       "      <td>0.0165</td>\n",
       "      <td>0.0447</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>0.0461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Puget Sound Community College</th>\n",
       "      <td>0.6351</td>\n",
       "      <td>0.0322</td>\n",
       "      <td>0.0850</td>\n",
       "      <td>0.0509</td>\n",
       "      <td>0.0125</td>\n",
       "      <td>0.0102</td>\n",
       "      <td>0.0926</td>\n",
       "      <td>0.0112</td>\n",
       "      <td>0.0706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fashion Institute of Design &amp; Merchandising-San Diego</th>\n",
       "      <td>0.3732</td>\n",
       "      <td>0.0352</td>\n",
       "      <td>0.3732</td>\n",
       "      <td>0.0775</td>\n",
       "      <td>0.0141</td>\n",
       "      <td>0.0282</td>\n",
       "      <td>0.0141</td>\n",
       "      <td>0.0352</td>\n",
       "      <td>0.0493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Northwest College of Art &amp; Design</th>\n",
       "      <td>0.5851</td>\n",
       "      <td>0.0213</td>\n",
       "      <td>0.0957</td>\n",
       "      <td>0.0213</td>\n",
       "      <td>0.0426</td>\n",
       "      <td>0.0213</td>\n",
       "      <td>0.0851</td>\n",
       "      <td>0.0106</td>\n",
       "      <td>0.1170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>University of Washington-Tacoma Campus</th>\n",
       "      <td>0.4488</td>\n",
       "      <td>0.0768</td>\n",
       "      <td>0.1032</td>\n",
       "      <td>0.1703</td>\n",
       "      <td>0.0111</td>\n",
       "      <td>0.0169</td>\n",
       "      <td>0.0755</td>\n",
       "      <td>0.0444</td>\n",
       "      <td>0.0531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States University</th>\n",
       "      <td>0.1168</td>\n",
       "      <td>0.2482</td>\n",
       "      <td>0.2372</td>\n",
       "      <td>0.0839</td>\n",
       "      <td>0.0109</td>\n",
       "      <td>0.0401</td>\n",
       "      <td>0.0657</td>\n",
       "      <td>0.0219</td>\n",
       "      <td>0.1752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Access Careers</th>\n",
       "      <td>0.0769</td>\n",
       "      <td>0.5839</td>\n",
       "      <td>0.0559</td>\n",
       "      <td>0.0140</td>\n",
       "      <td>0.0280</td>\n",
       "      <td>0.0140</td>\n",
       "      <td>0.0804</td>\n",
       "      <td>0.0315</td>\n",
       "      <td>0.1154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DeVry University-Nevada</th>\n",
       "      <td>0.3986</td>\n",
       "      <td>0.1856</td>\n",
       "      <td>0.2165</td>\n",
       "      <td>0.0928</td>\n",
       "      <td>0.0103</td>\n",
       "      <td>0.0206</td>\n",
       "      <td>0.0344</td>\n",
       "      <td>0.0172</td>\n",
       "      <td>0.0241</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    UGDS_WHITE  UGDS_BLACK  \\\n",
       "INSTNM                                                                       \n",
       "John F. Kennedy University                              0.3665      0.1554   \n",
       "National Holistic Institute                             0.4122      0.0933   \n",
       "Santa Fe University of Art and Design                   0.4529      0.0703   \n",
       "Eastern Oregon University                               0.7611      0.0294   \n",
       "New Hope Christian College-Eugene                       0.6111      0.0370   \n",
       "Salt Lake Community College                             0.6888      0.0248   \n",
       "Northwest University                                    0.6827      0.0447   \n",
       "South Puget Sound Community College                     0.6351      0.0322   \n",
       "Fashion Institute of Design & Merchandising-San...      0.3732      0.0352   \n",
       "Northwest College of Art & Design                       0.5851      0.0213   \n",
       "University of Washington-Tacoma Campus                  0.4488      0.0768   \n",
       "United States University                                0.1168      0.2482   \n",
       "Access Careers                                          0.0769      0.5839   \n",
       "DeVry University-Nevada                                 0.3986      0.1856   \n",
       "\n",
       "                                                    UGDS_HISP  UGDS_ASIAN  \\\n",
       "INSTNM                                                                      \n",
       "John F. Kennedy University                             0.2590      0.0837   \n",
       "National Holistic Institute                            0.1889      0.0689   \n",
       "Santa Fe University of Art and Design                  0.2765      0.0191   \n",
       "Eastern Oregon University                              0.0624      0.0207   \n",
       "New Hope Christian College-Eugene                      0.0864      0.0370   \n",
       "Salt Lake Community College                            0.1612      0.0405   \n",
       "Northwest University                                   0.0853      0.0475   \n",
       "South Puget Sound Community College                    0.0850      0.0509   \n",
       "Fashion Institute of Design & Merchandising-San...     0.3732      0.0775   \n",
       "Northwest College of Art & Design                      0.0957      0.0213   \n",
       "University of Washington-Tacoma Campus                 0.1032      0.1703   \n",
       "United States University                               0.2372      0.0839   \n",
       "Access Careers                                         0.0559      0.0140   \n",
       "DeVry University-Nevada                                0.2165      0.0928   \n",
       "\n",
       "                                                    UGDS_AIAN  UGDS_NHPI  \\\n",
       "INSTNM                                                                     \n",
       "John F. Kennedy University                             0.0159     0.0120   \n",
       "National Holistic Institute                            0.0111     0.0278   \n",
       "Santa Fe University of Art and Design                  0.0250     0.0179   \n",
       "Eastern Oregon University                              0.0254     0.0113   \n",
       "New Hope Christian College-Eugene                      0.0123     0.0432   \n",
       "Salt Lake Community College                            0.0104     0.0128   \n",
       "Northwest University                                   0.0124     0.0165   \n",
       "South Puget Sound Community College                    0.0125     0.0102   \n",
       "Fashion Institute of Design & Merchandising-San...     0.0141     0.0282   \n",
       "Northwest College of Art & Design                      0.0426     0.0213   \n",
       "University of Washington-Tacoma Campus                 0.0111     0.0169   \n",
       "United States University                               0.0109     0.0401   \n",
       "Access Careers                                         0.0280     0.0140   \n",
       "DeVry University-Nevada                                0.0103     0.0206   \n",
       "\n",
       "                                                    UGDS_2MOR  UGDS_NRA  \\\n",
       "INSTNM                                                                    \n",
       "John F. Kennedy University                             0.0359    0.0319   \n",
       "National Holistic Institute                            0.1522    0.0267   \n",
       "Santa Fe University of Art and Design                  0.0751    0.0501   \n",
       "Eastern Oregon University                              0.0133    0.0150   \n",
       "New Hope Christian College-Eugene                      0.0926    0.0247   \n",
       "Salt Lake Community College                            0.0256    0.0132   \n",
       "Northwest University                                   0.0447    0.0200   \n",
       "South Puget Sound Community College                    0.0926    0.0112   \n",
       "Fashion Institute of Design & Merchandising-San...     0.0141    0.0352   \n",
       "Northwest College of Art & Design                      0.0851    0.0106   \n",
       "University of Washington-Tacoma Campus                 0.0755    0.0444   \n",
       "United States University                               0.0657    0.0219   \n",
       "Access Careers                                         0.0804    0.0315   \n",
       "DeVry University-Nevada                                0.0344    0.0172   \n",
       "\n",
       "                                                    UGDS_UNKN  \n",
       "INSTNM                                                         \n",
       "John F. Kennedy University                             0.0398  \n",
       "National Holistic Institute                            0.0189  \n",
       "Santa Fe University of Art and Design                  0.0131  \n",
       "Eastern Oregon University                              0.0614  \n",
       "New Hope Christian College-Eugene                      0.0556  \n",
       "Salt Lake Community College                            0.0227  \n",
       "Northwest University                                   0.0461  \n",
       "South Puget Sound Community College                    0.0706  \n",
       "Fashion Institute of Design & Merchandising-San...     0.0493  \n",
       "Northwest College of Art & Design                      0.1170  \n",
       "University of Washington-Tacoma Campus                 0.0531  \n",
       "United States University                               0.1752  \n",
       "Access Careers                                         0.1154  \n",
       "DeVry University-Nevada                                0.0241  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "college_ugds_[(college_ugds_ > .01).all(axis=1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}