diversity_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "diversity = pd.read_csv('data/diversity_school.csv')"
   ]
  },
  {
   "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>name</th>\n",
       "      <th>total_enrollment</th>\n",
       "      <th>state</th>\n",
       "      <th>category</th>\n",
       "      <th>enrollment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Women</td>\n",
       "      <td>134722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>American Indian / Alaska Native</td>\n",
       "      <td>876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Asian</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Black</td>\n",
       "      <td>31455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Hispanic</td>\n",
       "      <td>13984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50650</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</td>\n",
       "      <td>1</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>White</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50651</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</td>\n",
       "      <td>1</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>Two Or More Races</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50652</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</td>\n",
       "      <td>1</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50653</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</td>\n",
       "      <td>1</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>Non-Resident Foreign</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50654</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</td>\n",
       "      <td>1</td>\n",
       "      <td>Iowa</td>\n",
       "      <td>Total Minority</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50655 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name  total_enrollment  \\\n",
       "0                       University of Phoenix-Arizona            195059   \n",
       "1                       University of Phoenix-Arizona            195059   \n",
       "2                       University of Phoenix-Arizona            195059   \n",
       "3                       University of Phoenix-Arizona            195059   \n",
       "4                       University of Phoenix-Arizona            195059   \n",
       "...                                               ...               ...   \n",
       "50650  ITT Technical Institute at Cedar Rapids (Iowa)                 1   \n",
       "50651  ITT Technical Institute at Cedar Rapids (Iowa)                 1   \n",
       "50652  ITT Technical Institute at Cedar Rapids (Iowa)                 1   \n",
       "50653  ITT Technical Institute at Cedar Rapids (Iowa)                 1   \n",
       "50654  ITT Technical Institute at Cedar Rapids (Iowa)                 1   \n",
       "\n",
       "         state                         category  enrollment  \n",
       "0      Arizona                            Women      134722  \n",
       "1      Arizona  American Indian / Alaska Native         876  \n",
       "2      Arizona                            Asian        1959  \n",
       "3      Arizona                            Black       31455  \n",
       "4      Arizona                         Hispanic       13984  \n",
       "...        ...                              ...         ...  \n",
       "50650     Iowa                            White           1  \n",
       "50651     Iowa                Two Or More Races           0  \n",
       "50652     Iowa                          Unknown           0  \n",
       "50653     Iowa             Non-Resident Foreign           0  \n",
       "50654     Iowa                   Total Minority           0  \n",
       "\n",
       "[50655 rows x 5 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "diversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>name</th>\n",
       "      <th>total_enrollment</th>\n",
       "      <th>state</th>\n",
       "      <th>category</th>\n",
       "      <th>enrollment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Women</td>\n",
       "      <td>134722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>American Indian / Alaska Native</td>\n",
       "      <td>876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Asian</td>\n",
       "      <td>1959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Black</td>\n",
       "      <td>31455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>195059</td>\n",
       "      <td>Arizona</td>\n",
       "      <td>Hispanic</td>\n",
       "      <td>13984</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            name  total_enrollment    state  \\\n",
       "0  University of Phoenix-Arizona            195059  Arizona   \n",
       "1  University of Phoenix-Arizona            195059  Arizona   \n",
       "2  University of Phoenix-Arizona            195059  Arizona   \n",
       "3  University of Phoenix-Arizona            195059  Arizona   \n",
       "4  University of Phoenix-Arizona            195059  Arizona   \n",
       "\n",
       "                          category  enrollment  \n",
       "0                            Women      134722  \n",
       "1  American Indian / Alaska Native         876  \n",
       "2                            Asian        1959  \n",
       "3                            Black       31455  \n",
       "4                         Hispanic       13984  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "diversity.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>total_enrollment</th>\n",
       "      <th>enrollment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>50655.000000</td>\n",
       "      <td>50655.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>4386.690771</td>\n",
       "      <td>774.192794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>8217.528150</td>\n",
       "      <td>2545.014538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>391.000000</td>\n",
       "      <td>6.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1391.000000</td>\n",
       "      <td>59.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>4504.000000</td>\n",
       "      <td>379.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>195059.000000</td>\n",
       "      <td>134722.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       total_enrollment     enrollment\n",
       "count      50655.000000   50655.000000\n",
       "mean        4386.690771     774.192794\n",
       "std         8217.528150    2545.014538\n",
       "min            1.000000       0.000000\n",
       "25%          391.000000       6.000000\n",
       "50%         1391.000000      59.000000\n",
       "75%         4504.000000     379.000000\n",
       "max       195059.000000  134722.000000"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "diversity.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['University of Phoenix-Arizona',\n",
       "       'Ivy Tech Community College-Central Indiana', 'Liberty University',\n",
       "       ..., 'Pace Institute',\n",
       "       'ITT Technical Institute at Germantown (Wis.)',\n",
       "       'ITT Technical Institute at Cedar Rapids (Iowa)'], dtype=object)"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "diversity['name'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4575"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(diversity['name'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Women', 'American Indian / Alaska Native', 'Asian', 'Black',\n",
       "       'Hispanic', 'Native Hawaiian / Pacific Islander', 'White',\n",
       "       'Two Or More Races', 'Unknown', 'Non-Resident Foreign',\n",
       "       'Total Minority'], dtype=object)"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "diversity['category'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "colleges = np.array(diversity['name'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4575,)"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colleges.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_diversity = pd.DataFrame(colleges, columns = ['name'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivy Tech Community College-Central Indiana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liberty University</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lone Star College system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Miami Dade College</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         name\n",
       "0               University of Phoenix-Arizona\n",
       "1  Ivy Tech Community College-Central Indiana\n",
       "2                          Liberty University\n",
       "3                    Lone Star College system\n",
       "4                          Miami Dade College"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_diversity.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivy Tech Community College-Central Indiana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liberty University</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lone Star College system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Miami Dade College</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4570</th>\n",
       "      <td>ITT Technical Institute at West Covina (Calif.)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4571</th>\n",
       "      <td>Danville Regional Medical Center School of Hea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4572</th>\n",
       "      <td>Pace Institute</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4573</th>\n",
       "      <td>ITT Technical Institute at Germantown (Wis.)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4574</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4575 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   name\n",
       "0                         University of Phoenix-Arizona\n",
       "1            Ivy Tech Community College-Central Indiana\n",
       "2                                    Liberty University\n",
       "3                              Lone Star College system\n",
       "4                                    Miami Dade College\n",
       "...                                                 ...\n",
       "4570    ITT Technical Institute at West Covina (Calif.)\n",
       "4571  Danville Regional Medical Center School of Hea...\n",
       "4572                                     Pace Institute\n",
       "4573       ITT Technical Institute at Germantown (Wis.)\n",
       "4574     ITT Technical Institute at Cedar Rapids (Iowa)\n",
       "\n",
       "[4575 rows x 1 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_diversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns = ['Women', 'American Indian / Alaska Native', 'Asian', 'Black',\n",
    "       'Hispanic', 'Native Hawaiian / Pacific Islander', 'White',\n",
    "       'Two Or More Races', 'Unknown', 'Non-Resident Foreign',\n",
    "       'Total Minority']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_diversity[columns] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "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>name</th>\n",
       "      <th>Women</th>\n",
       "      <th>American Indian / Alaska Native</th>\n",
       "      <th>Asian</th>\n",
       "      <th>Black</th>\n",
       "      <th>Hispanic</th>\n",
       "      <th>Native Hawaiian / Pacific Islander</th>\n",
       "      <th>White</th>\n",
       "      <th>Two Or More Races</th>\n",
       "      <th>Unknown</th>\n",
       "      <th>Non-Resident Foreign</th>\n",
       "      <th>Total Minority</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivy Tech Community College-Central Indiana</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liberty University</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lone Star College system</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Miami Dade College</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4570</th>\n",
       "      <td>ITT Technical Institute at West Covina (Calif.)</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4571</th>\n",
       "      <td>Danville Regional Medical Center School of Hea...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4572</th>\n",
       "      <td>Pace Institute</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4573</th>\n",
       "      <td>ITT Technical Institute at Germantown (Wis.)</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4574</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4575 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   name  Women  \\\n",
       "0                         University of Phoenix-Arizona    NaN   \n",
       "1            Ivy Tech Community College-Central Indiana    NaN   \n",
       "2                                    Liberty University    NaN   \n",
       "3                              Lone Star College system    NaN   \n",
       "4                                    Miami Dade College    NaN   \n",
       "...                                                 ...    ...   \n",
       "4570    ITT Technical Institute at West Covina (Calif.)    NaN   \n",
       "4571  Danville Regional Medical Center School of Hea...    NaN   \n",
       "4572                                     Pace Institute    NaN   \n",
       "4573       ITT Technical Institute at Germantown (Wis.)    NaN   \n",
       "4574     ITT Technical Institute at Cedar Rapids (Iowa)    NaN   \n",
       "\n",
       "      American Indian / Alaska Native  Asian  Black  Hispanic  \\\n",
       "0                                 NaN    NaN    NaN       NaN   \n",
       "1                                 NaN    NaN    NaN       NaN   \n",
       "2                                 NaN    NaN    NaN       NaN   \n",
       "3                                 NaN    NaN    NaN       NaN   \n",
       "4                                 NaN    NaN    NaN       NaN   \n",
       "...                               ...    ...    ...       ...   \n",
       "4570                              NaN    NaN    NaN       NaN   \n",
       "4571                              NaN    NaN    NaN       NaN   \n",
       "4572                              NaN    NaN    NaN       NaN   \n",
       "4573                              NaN    NaN    NaN       NaN   \n",
       "4574                              NaN    NaN    NaN       NaN   \n",
       "\n",
       "      Native Hawaiian / Pacific Islander  White  Two Or More Races  Unknown  \\\n",
       "0                                    NaN    NaN                NaN      NaN   \n",
       "1                                    NaN    NaN                NaN      NaN   \n",
       "2                                    NaN    NaN                NaN      NaN   \n",
       "3                                    NaN    NaN                NaN      NaN   \n",
       "4                                    NaN    NaN                NaN      NaN   \n",
       "...                                  ...    ...                ...      ...   \n",
       "4570                                 NaN    NaN                NaN      NaN   \n",
       "4571                                 NaN    NaN                NaN      NaN   \n",
       "4572                                 NaN    NaN                NaN      NaN   \n",
       "4573                                 NaN    NaN                NaN      NaN   \n",
       "4574                                 NaN    NaN                NaN      NaN   \n",
       "\n",
       "      Non-Resident Foreign  Total Minority  \n",
       "0                      NaN             NaN  \n",
       "1                      NaN             NaN  \n",
       "2                      NaN             NaN  \n",
       "3                      NaN             NaN  \n",
       "4                      NaN             NaN  \n",
       "...                    ...             ...  \n",
       "4570                   NaN             NaN  \n",
       "4571                   NaN             NaN  \n",
       "4572                   NaN             NaN  \n",
       "4573                   NaN             NaN  \n",
       "4574                   NaN             NaN  \n",
       "\n",
       "[4575 rows x 12 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_diversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index in diversity.index:\n",
    "    category = diversity.iloc[index]['category']\n",
    "    name = diversity.iloc[index]['name']\n",
    "    clean_diversity.loc[clean_diversity['name'] == name, [category]] = diversity.iloc[index]['enrollment']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>name</th>\n",
       "      <th>Women</th>\n",
       "      <th>American Indian / Alaska Native</th>\n",
       "      <th>Asian</th>\n",
       "      <th>Black</th>\n",
       "      <th>Hispanic</th>\n",
       "      <th>Native Hawaiian / Pacific Islander</th>\n",
       "      <th>White</th>\n",
       "      <th>Two Or More Races</th>\n",
       "      <th>Unknown</th>\n",
       "      <th>Non-Resident Foreign</th>\n",
       "      <th>Total Minority</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>134722.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>31455.0</td>\n",
       "      <td>13984.0</td>\n",
       "      <td>1019.0</td>\n",
       "      <td>58209.0</td>\n",
       "      <td>19039.0</td>\n",
       "      <td>65163.0</td>\n",
       "      <td>3355.0</td>\n",
       "      <td>68332.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivy Tech Community College-Central Indiana</td>\n",
       "      <td>53476.0</td>\n",
       "      <td>357.0</td>\n",
       "      <td>1369.0</td>\n",
       "      <td>12370.0</td>\n",
       "      <td>5533.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61498.0</td>\n",
       "      <td>1804.0</td>\n",
       "      <td>8224.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21433.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liberty University</td>\n",
       "      <td>48329.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>856.0</td>\n",
       "      <td>14751.0</td>\n",
       "      <td>1186.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>39062.0</td>\n",
       "      <td>1772.0</td>\n",
       "      <td>22198.0</td>\n",
       "      <td>1036.0</td>\n",
       "      <td>19163.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lone Star College system</td>\n",
       "      <td>41268.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>4198.0</td>\n",
       "      <td>12094.0</td>\n",
       "      <td>23751.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23615.0</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>2273.0</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>42208.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Miami Dade College</td>\n",
       "      <td>38323.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>10722.0</td>\n",
       "      <td>44870.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>4170.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>3388.0</td>\n",
       "      <td>56561.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4570</th>\n",
       "      <td>ITT Technical Institute at West Covina (Calif.)</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.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>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4571</th>\n",
       "      <td>Danville Regional Medical Center School of Hea...</td>\n",
       "      <td>6.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",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4572</th>\n",
       "      <td>Pace Institute</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4573</th>\n",
       "      <td>ITT Technical Institute at Germantown (Wis.)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4574</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</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>1.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",
       "  </tbody>\n",
       "</table>\n",
       "<p>4575 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   name     Women  \\\n",
       "0                         University of Phoenix-Arizona  134722.0   \n",
       "1            Ivy Tech Community College-Central Indiana   53476.0   \n",
       "2                                    Liberty University   48329.0   \n",
       "3                              Lone Star College system   41268.0   \n",
       "4                                    Miami Dade College   38323.0   \n",
       "...                                                 ...       ...   \n",
       "4570    ITT Technical Institute at West Covina (Calif.)       4.0   \n",
       "4571  Danville Regional Medical Center School of Hea...       6.0   \n",
       "4572                                     Pace Institute       2.0   \n",
       "4573       ITT Technical Institute at Germantown (Wis.)       2.0   \n",
       "4574     ITT Technical Institute at Cedar Rapids (Iowa)       0.0   \n",
       "\n",
       "      American Indian / Alaska Native   Asian    Black  Hispanic  \\\n",
       "0                               876.0  1959.0  31455.0   13984.0   \n",
       "1                               357.0  1369.0  12370.0    5533.0   \n",
       "2                               447.0   856.0  14751.0    1186.0   \n",
       "3                               168.0  4198.0  12094.0   23751.0   \n",
       "4                                47.0   655.0  10722.0   44870.0   \n",
       "...                               ...     ...      ...       ...   \n",
       "4570                              0.0     0.0      0.0       8.0   \n",
       "4571                              0.0     0.0      1.0       0.0   \n",
       "4572                              0.0     0.0      1.0       2.0   \n",
       "4573                              0.0     0.0      2.0       0.0   \n",
       "4574                              0.0     0.0      0.0       0.0   \n",
       "\n",
       "      Native Hawaiian / Pacific Islander    White  Two Or More Races  Unknown  \\\n",
       "0                                 1019.0  58209.0            19039.0  65163.0   \n",
       "1                                    0.0  61498.0             1804.0   8224.0   \n",
       "2                                  151.0  39062.0             1772.0  22198.0   \n",
       "3                                    0.0  23615.0             1997.0   2273.0   \n",
       "4                                   41.0   4170.0              226.0   1927.0   \n",
       "...                                  ...      ...                ...      ...   \n",
       "4570                                 0.0      0.0                0.0      0.0   \n",
       "4571                                 0.0      6.0                0.0      0.0   \n",
       "4572                                 0.0      1.0                1.0      0.0   \n",
       "4573                                 0.0      2.0                0.0      0.0   \n",
       "4574                                 0.0      1.0                0.0      0.0   \n",
       "\n",
       "      Non-Resident Foreign  Total Minority  \n",
       "0                   3355.0         68332.0  \n",
       "1                     24.0         21433.0  \n",
       "2                   1036.0         19163.0  \n",
       "3                   1299.0         42208.0  \n",
       "4                   3388.0         56561.0  \n",
       "...                    ...             ...  \n",
       "4570                   0.0             8.0  \n",
       "4571                   0.0             1.0  \n",
       "4572                   0.0             4.0  \n",
       "4573                   0.0             2.0  \n",
       "4574                   0.0             0.0  \n",
       "\n",
       "[4575 rows x 12 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_diversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_diversity['total_enrollment'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>name</th>\n",
       "      <th>Women</th>\n",
       "      <th>American Indian / Alaska Native</th>\n",
       "      <th>Asian</th>\n",
       "      <th>Black</th>\n",
       "      <th>Hispanic</th>\n",
       "      <th>Native Hawaiian / Pacific Islander</th>\n",
       "      <th>White</th>\n",
       "      <th>Two Or More Races</th>\n",
       "      <th>Unknown</th>\n",
       "      <th>Non-Resident Foreign</th>\n",
       "      <th>Total Minority</th>\n",
       "      <th>total_enrollment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>134722.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>31455.0</td>\n",
       "      <td>13984.0</td>\n",
       "      <td>1019.0</td>\n",
       "      <td>58209.0</td>\n",
       "      <td>19039.0</td>\n",
       "      <td>65163.0</td>\n",
       "      <td>3355.0</td>\n",
       "      <td>68332.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivy Tech Community College-Central Indiana</td>\n",
       "      <td>53476.0</td>\n",
       "      <td>357.0</td>\n",
       "      <td>1369.0</td>\n",
       "      <td>12370.0</td>\n",
       "      <td>5533.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61498.0</td>\n",
       "      <td>1804.0</td>\n",
       "      <td>8224.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21433.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liberty University</td>\n",
       "      <td>48329.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>856.0</td>\n",
       "      <td>14751.0</td>\n",
       "      <td>1186.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>39062.0</td>\n",
       "      <td>1772.0</td>\n",
       "      <td>22198.0</td>\n",
       "      <td>1036.0</td>\n",
       "      <td>19163.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lone Star College system</td>\n",
       "      <td>41268.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>4198.0</td>\n",
       "      <td>12094.0</td>\n",
       "      <td>23751.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23615.0</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>2273.0</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>42208.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Miami Dade College</td>\n",
       "      <td>38323.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>10722.0</td>\n",
       "      <td>44870.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>4170.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>3388.0</td>\n",
       "      <td>56561.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4570</th>\n",
       "      <td>ITT Technical Institute at West Covina (Calif.)</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.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>8.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4571</th>\n",
       "      <td>Danville Regional Medical Center School of Hea...</td>\n",
       "      <td>6.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",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4572</th>\n",
       "      <td>Pace Institute</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4573</th>\n",
       "      <td>ITT Technical Institute at Germantown (Wis.)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4574</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</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>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>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4575 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   name     Women  \\\n",
       "0                         University of Phoenix-Arizona  134722.0   \n",
       "1            Ivy Tech Community College-Central Indiana   53476.0   \n",
       "2                                    Liberty University   48329.0   \n",
       "3                              Lone Star College system   41268.0   \n",
       "4                                    Miami Dade College   38323.0   \n",
       "...                                                 ...       ...   \n",
       "4570    ITT Technical Institute at West Covina (Calif.)       4.0   \n",
       "4571  Danville Regional Medical Center School of Hea...       6.0   \n",
       "4572                                     Pace Institute       2.0   \n",
       "4573       ITT Technical Institute at Germantown (Wis.)       2.0   \n",
       "4574     ITT Technical Institute at Cedar Rapids (Iowa)       0.0   \n",
       "\n",
       "      American Indian / Alaska Native   Asian    Black  Hispanic  \\\n",
       "0                               876.0  1959.0  31455.0   13984.0   \n",
       "1                               357.0  1369.0  12370.0    5533.0   \n",
       "2                               447.0   856.0  14751.0    1186.0   \n",
       "3                               168.0  4198.0  12094.0   23751.0   \n",
       "4                                47.0   655.0  10722.0   44870.0   \n",
       "...                               ...     ...      ...       ...   \n",
       "4570                              0.0     0.0      0.0       8.0   \n",
       "4571                              0.0     0.0      1.0       0.0   \n",
       "4572                              0.0     0.0      1.0       2.0   \n",
       "4573                              0.0     0.0      2.0       0.0   \n",
       "4574                              0.0     0.0      0.0       0.0   \n",
       "\n",
       "      Native Hawaiian / Pacific Islander    White  Two Or More Races  Unknown  \\\n",
       "0                                 1019.0  58209.0            19039.0  65163.0   \n",
       "1                                    0.0  61498.0             1804.0   8224.0   \n",
       "2                                  151.0  39062.0             1772.0  22198.0   \n",
       "3                                    0.0  23615.0             1997.0   2273.0   \n",
       "4                                   41.0   4170.0              226.0   1927.0   \n",
       "...                                  ...      ...                ...      ...   \n",
       "4570                                 0.0      0.0                0.0      0.0   \n",
       "4571                                 0.0      6.0                0.0      0.0   \n",
       "4572                                 0.0      1.0                1.0      0.0   \n",
       "4573                                 0.0      2.0                0.0      0.0   \n",
       "4574                                 0.0      1.0                0.0      0.0   \n",
       "\n",
       "      Non-Resident Foreign  Total Minority  total_enrollment  \n",
       "0                   3355.0         68332.0               NaN  \n",
       "1                     24.0         21433.0               NaN  \n",
       "2                   1036.0         19163.0               NaN  \n",
       "3                   1299.0         42208.0               NaN  \n",
       "4                   3388.0         56561.0               NaN  \n",
       "...                    ...             ...               ...  \n",
       "4570                   0.0             8.0               NaN  \n",
       "4571                   0.0             1.0               NaN  \n",
       "4572                   0.0             4.0               NaN  \n",
       "4573                   0.0             2.0               NaN  \n",
       "4574                   0.0             0.0               NaN  \n",
       "\n",
       "[4575 rows x 13 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_diversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index in diversity.index:\n",
    "    name = diversity.iloc[index]['name']\n",
    "    clean_diversity.loc[clean_diversity['name'] == name, ['total_enrollment']] = diversity.iloc[index]['total_enrollment']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "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>name</th>\n",
       "      <th>Women</th>\n",
       "      <th>American Indian / Alaska Native</th>\n",
       "      <th>Asian</th>\n",
       "      <th>Black</th>\n",
       "      <th>Hispanic</th>\n",
       "      <th>Native Hawaiian / Pacific Islander</th>\n",
       "      <th>White</th>\n",
       "      <th>Two Or More Races</th>\n",
       "      <th>Unknown</th>\n",
       "      <th>Non-Resident Foreign</th>\n",
       "      <th>Total Minority</th>\n",
       "      <th>total_enrollment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>University of Phoenix-Arizona</td>\n",
       "      <td>134722.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>1959.0</td>\n",
       "      <td>31455.0</td>\n",
       "      <td>13984.0</td>\n",
       "      <td>1019.0</td>\n",
       "      <td>58209.0</td>\n",
       "      <td>19039.0</td>\n",
       "      <td>65163.0</td>\n",
       "      <td>3355.0</td>\n",
       "      <td>68332.0</td>\n",
       "      <td>195059.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ivy Tech Community College-Central Indiana</td>\n",
       "      <td>53476.0</td>\n",
       "      <td>357.0</td>\n",
       "      <td>1369.0</td>\n",
       "      <td>12370.0</td>\n",
       "      <td>5533.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61498.0</td>\n",
       "      <td>1804.0</td>\n",
       "      <td>8224.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21433.0</td>\n",
       "      <td>91179.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Liberty University</td>\n",
       "      <td>48329.0</td>\n",
       "      <td>447.0</td>\n",
       "      <td>856.0</td>\n",
       "      <td>14751.0</td>\n",
       "      <td>1186.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>39062.0</td>\n",
       "      <td>1772.0</td>\n",
       "      <td>22198.0</td>\n",
       "      <td>1036.0</td>\n",
       "      <td>19163.0</td>\n",
       "      <td>81459.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Lone Star College system</td>\n",
       "      <td>41268.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>4198.0</td>\n",
       "      <td>12094.0</td>\n",
       "      <td>23751.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23615.0</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>2273.0</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>42208.0</td>\n",
       "      <td>69395.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Miami Dade College</td>\n",
       "      <td>38323.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>10722.0</td>\n",
       "      <td>44870.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>4170.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>1927.0</td>\n",
       "      <td>3388.0</td>\n",
       "      <td>56561.0</td>\n",
       "      <td>66046.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4570</th>\n",
       "      <td>ITT Technical Institute at West Covina (Calif.)</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.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>8.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4571</th>\n",
       "      <td>Danville Regional Medical Center School of Hea...</td>\n",
       "      <td>6.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",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4572</th>\n",
       "      <td>Pace Institute</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4573</th>\n",
       "      <td>ITT Technical Institute at Germantown (Wis.)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4574</th>\n",
       "      <td>ITT Technical Institute at Cedar Rapids (Iowa)</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>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",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4575 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   name     Women  \\\n",
       "0                         University of Phoenix-Arizona  134722.0   \n",
       "1            Ivy Tech Community College-Central Indiana   53476.0   \n",
       "2                                    Liberty University   48329.0   \n",
       "3                              Lone Star College system   41268.0   \n",
       "4                                    Miami Dade College   38323.0   \n",
       "...                                                 ...       ...   \n",
       "4570    ITT Technical Institute at West Covina (Calif.)       4.0   \n",
       "4571  Danville Regional Medical Center School of Hea...       6.0   \n",
       "4572                                     Pace Institute       2.0   \n",
       "4573       ITT Technical Institute at Germantown (Wis.)       2.0   \n",
       "4574     ITT Technical Institute at Cedar Rapids (Iowa)       0.0   \n",
       "\n",
       "      American Indian / Alaska Native   Asian    Black  Hispanic  \\\n",
       "0                               876.0  1959.0  31455.0   13984.0   \n",
       "1                               357.0  1369.0  12370.0    5533.0   \n",
       "2                               447.0   856.0  14751.0    1186.0   \n",
       "3                               168.0  4198.0  12094.0   23751.0   \n",
       "4                                47.0   655.0  10722.0   44870.0   \n",
       "...                               ...     ...      ...       ...   \n",
       "4570                              0.0     0.0      0.0       8.0   \n",
       "4571                              0.0     0.0      1.0       0.0   \n",
       "4572                              0.0     0.0      1.0       2.0   \n",
       "4573                              0.0     0.0      2.0       0.0   \n",
       "4574                              0.0     0.0      0.0       0.0   \n",
       "\n",
       "      Native Hawaiian / Pacific Islander    White  Two Or More Races  Unknown  \\\n",
       "0                                 1019.0  58209.0            19039.0  65163.0   \n",
       "1                                    0.0  61498.0             1804.0   8224.0   \n",
       "2                                  151.0  39062.0             1772.0  22198.0   \n",
       "3                                    0.0  23615.0             1997.0   2273.0   \n",
       "4                                   41.0   4170.0              226.0   1927.0   \n",
       "...                                  ...      ...                ...      ...   \n",
       "4570                                 0.0      0.0                0.0      0.0   \n",
       "4571                                 0.0      6.0                0.0      0.0   \n",
       "4572                                 0.0      1.0                1.0      0.0   \n",
       "4573                                 0.0      2.0                0.0      0.0   \n",
       "4574                                 0.0      1.0                0.0      0.0   \n",
       "\n",
       "      Non-Resident Foreign  Total Minority  total_enrollment  \n",
       "0                   3355.0         68332.0          195059.0  \n",
       "1                     24.0         21433.0           91179.0  \n",
       "2                   1036.0         19163.0           81459.0  \n",
       "3                   1299.0         42208.0           69395.0  \n",
       "4                   3388.0         56561.0           66046.0  \n",
       "...                    ...             ...               ...  \n",
       "4570                   0.0             8.0               8.0  \n",
       "4571                   0.0             1.0               7.0  \n",
       "4572                   0.0             4.0               5.0  \n",
       "4573                   0.0             2.0               4.0  \n",
       "4574                   0.0             0.0               1.0  \n",
       "\n",
       "[4575 rows x 13 columns]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clean_diversity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_diversity.to_csv('data/cleaned_diversity_school.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "homl3",
   "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.10.8 | packaged by conda-forge | (main, Nov 22 2022, 08:26:04) [GCC 10.4.0]"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "cb11495483f8bc9329e70cd93d4d6000fab5e0ef74cd85abb85772776aaa6b42"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}