microproject-world-university-rankings.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1 style=\"text-align: center\">\n",
    "<div style=\"color: #DD3403; font-size: 60%\">Data Science DISCOVERY MicroProject</div>\n",
    "<span style=\"\">MicroProject: World University Rankings</span>\n",
    "<div style=\"font-size: 60%;\"><a href=\"https://discovery.cs.illinois.edu/microproject/world-university-rankings/\">https://discovery.cs.illinois.edu/microproject/world-university-rankings/</a></div>\n",
    "</h1>\n",
    "\n",
    "<hr style=\"color: #DD3403;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data Source: The Times Higher Education\n",
    "\n",
    "There are hundreds of organizations that rank universities, including US News and World Report, QS World University Rankings, Times Higher Education (THE), and many others.\n",
    "\n",
    "The Times Higher Education (THE) provides a clean, well-documented CSV that includes their rankings based on the \"performance data on universities for students and their families, academics, university leaders, governments and industry\".  Their 2020 dataset includes almost 1,400 universities across 92 countries and includes 13 performance indicators that measure an institution’s performance across teaching, research, knowledge transfer and international outlook.  Their website with additional details on this dataset is found here: https://www.timeshighereducation.com/content/world-university-rankings\n",
    "\n",
    "In this MicroProject, you will explore basic DataFrame operations on the Times Higher Education university rankings."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"color: #DD3403;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importing the World University Rank Dataset\n",
    "\n",
    "To use the `pandas` library, we must **import** it into your notebook. import pandas as `pd` in the following cell:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Use panda's `read_csv` function to read the `World_University_Rank_2020.csv` and create a DataFrame called `df`."
   ]
  },
  {
   "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>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>University of Oxford</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>20664</td>\n",
       "      <td>11.2</td>\n",
       "      <td>41%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>90.5</td>\n",
       "      <td>99.6</td>\n",
       "      <td>98.4</td>\n",
       "      <td>65.5</td>\n",
       "      <td>96.4</td>\n",
       "      <td>95.4</td>\n",
       "      <td>95.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>California Institute of Technology</td>\n",
       "      <td>United States</td>\n",
       "      <td>2240</td>\n",
       "      <td>6.4</td>\n",
       "      <td>30%</td>\n",
       "      <td>34%</td>\n",
       "      <td>66%</td>\n",
       "      <td>92.1</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.9</td>\n",
       "      <td>88.0</td>\n",
       "      <td>82.5</td>\n",
       "      <td>94.5</td>\n",
       "      <td>94.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>University of Cambridge</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>18978</td>\n",
       "      <td>10.9</td>\n",
       "      <td>37%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>91.4</td>\n",
       "      <td>98.7</td>\n",
       "      <td>95.8</td>\n",
       "      <td>59.3</td>\n",
       "      <td>95.0</td>\n",
       "      <td>94.4</td>\n",
       "      <td>94.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Stanford University</td>\n",
       "      <td>United States</td>\n",
       "      <td>16135</td>\n",
       "      <td>7.3</td>\n",
       "      <td>23%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>92.8</td>\n",
       "      <td>96.4</td>\n",
       "      <td>99.9</td>\n",
       "      <td>66.2</td>\n",
       "      <td>79.5</td>\n",
       "      <td>94.3</td>\n",
       "      <td>94.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Massachusetts Institute of Technology</td>\n",
       "      <td>United States</td>\n",
       "      <td>11247</td>\n",
       "      <td>8.6</td>\n",
       "      <td>34%</td>\n",
       "      <td>39%</td>\n",
       "      <td>61%</td>\n",
       "      <td>90.5</td>\n",
       "      <td>92.4</td>\n",
       "      <td>99.5</td>\n",
       "      <td>86.9</td>\n",
       "      <td>89.0</td>\n",
       "      <td>93.6</td>\n",
       "      <td>93.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1391</th>\n",
       "      <td>531</td>\n",
       "      <td>Cear� State University</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>20174</td>\n",
       "      <td>17.8</td>\n",
       "      <td>0%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>16.2</td>\n",
       "      <td>8.3</td>\n",
       "      <td>6.1</td>\n",
       "      <td>35.6</td>\n",
       "      <td>16.3</td>\n",
       "      <td>11.3</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1392</th>\n",
       "      <td>532</td>\n",
       "      <td>Pontifical Catholic University of Minas Gerais</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>34101</td>\n",
       "      <td>21.3</td>\n",
       "      <td>0%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>15.3</td>\n",
       "      <td>7.7</td>\n",
       "      <td>6.7</td>\n",
       "      <td>35.1</td>\n",
       "      <td>19.4</td>\n",
       "      <td>11.2</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1393</th>\n",
       "      <td>533</td>\n",
       "      <td>Bashkir State University</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>15236</td>\n",
       "      <td>11.1</td>\n",
       "      <td>3%</td>\n",
       "      <td>63%</td>\n",
       "      <td>37%</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>4.5</td>\n",
       "      <td>36.9</td>\n",
       "      <td>16.7</td>\n",
       "      <td>11.1</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>534</td>\n",
       "      <td>University of Caxias do Sul</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>17101</td>\n",
       "      <td>24.9</td>\n",
       "      <td>0%</td>\n",
       "      <td>54%</td>\n",
       "      <td>46%</td>\n",
       "      <td>13.8</td>\n",
       "      <td>7.8</td>\n",
       "      <td>7.6</td>\n",
       "      <td>35.0</td>\n",
       "      <td>17.7</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>535</td>\n",
       "      <td>Tokyo Denki University</td>\n",
       "      <td>Japan</td>\n",
       "      <td>9285</td>\n",
       "      <td>25.6</td>\n",
       "      <td>2%</td>\n",
       "      <td>12%</td>\n",
       "      <td>88%</td>\n",
       "      <td>15.2</td>\n",
       "      <td>9.3</td>\n",
       "      <td>3.4</td>\n",
       "      <td>39.6</td>\n",
       "      <td>17.7</td>\n",
       "      <td>10.7</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1396 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Score_Rank                                      University  \\\n",
       "0              1                            University of Oxford   \n",
       "1              2              California Institute of Technology   \n",
       "2              3                         University of Cambridge   \n",
       "3              4                             Stanford University   \n",
       "4              5           Massachusetts Institute of Technology   \n",
       "...          ...                                             ...   \n",
       "1391         531                          Cear� State University   \n",
       "1392         532  Pontifical Catholic University of Minas Gerais   \n",
       "1393         533                        Bashkir State University   \n",
       "1394         534                     University of Caxias do Sul   \n",
       "1395         535                          Tokyo Denki University   \n",
       "\n",
       "                 Country  Number_students  Numb_students_per_Staff  \\\n",
       "0         United Kingdom            20664                     11.2   \n",
       "1          United States             2240                      6.4   \n",
       "2         United Kingdom            18978                     10.9   \n",
       "3          United States            16135                      7.3   \n",
       "4          United States            11247                      8.6   \n",
       "...                  ...              ...                      ...   \n",
       "1391              Brazil            20174                     17.8   \n",
       "1392              Brazil            34101                     21.3   \n",
       "1393  Russian Federation            15236                     11.1   \n",
       "1394              Brazil            17101                     24.9   \n",
       "1395               Japan             9285                     25.6   \n",
       "\n",
       "     International_Students Percentage_Female Percentage_Male  Teaching  \\\n",
       "0                       41%               46%             54%      90.5   \n",
       "1                       30%               34%             66%      92.1   \n",
       "2                       37%               47%             53%      91.4   \n",
       "3                       23%               43%             57%      92.8   \n",
       "4                       34%               39%             61%      90.5   \n",
       "...                     ...               ...             ...       ...   \n",
       "1391                     0%               55%             45%      16.2   \n",
       "1392                     0%               57%             43%      15.3   \n",
       "1393                     3%               63%             37%      17.0   \n",
       "1394                     0%               54%             46%      13.8   \n",
       "1395                     2%               12%             88%      15.2   \n",
       "\n",
       "      Research  Citations  Industry_Income  International_Outlook  \\\n",
       "0         99.6       98.4             65.5                   96.4   \n",
       "1         97.2       97.9             88.0                   82.5   \n",
       "2         98.7       95.8             59.3                   95.0   \n",
       "3         96.4       99.9             66.2                   79.5   \n",
       "4         92.4       99.5             86.9                   89.0   \n",
       "...        ...        ...              ...                    ...   \n",
       "1391       8.3        6.1             35.6                   16.3   \n",
       "1392       7.7        6.7             35.1                   19.4   \n",
       "1393       8.1        4.5             36.9                   16.7   \n",
       "1394       7.8        7.6             35.0                   17.7   \n",
       "1395       9.3        3.4             39.6                   17.7   \n",
       "\n",
       "      Score_Result Overall_Ranking  \n",
       "0             95.4           95.40  \n",
       "1             94.5           94.50  \n",
       "2             94.4           94.40  \n",
       "3             94.3           94.30  \n",
       "4             93.6           93.60  \n",
       "...            ...             ...  \n",
       "1391          11.3       10.7�22.1  \n",
       "1392          11.2       10.7�22.1  \n",
       "1393          11.1       10.7�22.1  \n",
       "1394          11.0       10.7�22.1  \n",
       "1395          10.7       10.7�22.1  \n",
       "\n",
       "[1396 rows x 15 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('World_University_Rank_2020.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "🎉 All Tests Passed! 🎉\n"
     ]
    }
   ],
   "source": [
    "### TEST CASE for Importing the World University Rank Dataset\n",
    "#\n",
    "# What is this cell?\n",
    "# - This cell contains test cases for the MicroProject. Even though you can modify this\n",
    "#   cell, you should treat it like it's a read-only cell since it will be replaced with\n",
    "#   a fresh version when your code is checked.\n",
    "#\n",
    "# - If this cell runs without any error in the output, you PASSED all test cases!\n",
    "#   We try and make these test cases as useful and complete as possible, but there is\n",
    "#   a chance your code may be incorrect even though you pass the test cases (these\n",
    "#   tests should be seen as a way to give you confidence that code you believe is\n",
    "#   actually correct, not as a robust check to catch all possible errors).\n",
    "#\n",
    "# - If this cell results in any errors, check you previous cells, make changes, and\n",
    "#   RE-RUN your code and then re-run this cell.  Keep repeating this until the cell\n",
    "#   passed with no errors! :)\n",
    "\n",
    "tada = \"\\N{PARTY POPPER}\"\n",
    "\n",
    "assert(\"df\" in vars()), \"Make sure to name the dataframe df\"\n",
    "assert(df[\"University\"].iloc[0] == \"University of Oxford\")\n",
    "assert(df[\"University\"].iloc[1392] == \"Pontifical Catholic University of Minas Gerais\")\n",
    "assert(\"University\" in df)\n",
    "assert(\"Score\" not in df)\n",
    "print(f\"{tada} All Tests Passed! {tada}\") "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"color: #DD3403;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Puzzle 1: Rankings with the United States\n",
    "\n",
    "In this dataset, each row represents one university.  In the dataset, find the variable that encodes where the university is located.\n",
    "\n",
    "Create one new DataFrame, `df_united_states` , that only contains universities located in the United States:"
   ]
  },
  {
   "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>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>California Institute of Technology</td>\n",
       "      <td>United States</td>\n",
       "      <td>2240</td>\n",
       "      <td>6.4</td>\n",
       "      <td>30%</td>\n",
       "      <td>34%</td>\n",
       "      <td>66%</td>\n",
       "      <td>92.1</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.9</td>\n",
       "      <td>88.0</td>\n",
       "      <td>82.5</td>\n",
       "      <td>94.5</td>\n",
       "      <td>94.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Stanford University</td>\n",
       "      <td>United States</td>\n",
       "      <td>16135</td>\n",
       "      <td>7.3</td>\n",
       "      <td>23%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>92.8</td>\n",
       "      <td>96.4</td>\n",
       "      <td>99.9</td>\n",
       "      <td>66.2</td>\n",
       "      <td>79.5</td>\n",
       "      <td>94.3</td>\n",
       "      <td>94.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Massachusetts Institute of Technology</td>\n",
       "      <td>United States</td>\n",
       "      <td>11247</td>\n",
       "      <td>8.6</td>\n",
       "      <td>34%</td>\n",
       "      <td>39%</td>\n",
       "      <td>61%</td>\n",
       "      <td>90.5</td>\n",
       "      <td>92.4</td>\n",
       "      <td>99.5</td>\n",
       "      <td>86.9</td>\n",
       "      <td>89.0</td>\n",
       "      <td>93.6</td>\n",
       "      <td>93.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Princeton University</td>\n",
       "      <td>United States</td>\n",
       "      <td>7983</td>\n",
       "      <td>8.1</td>\n",
       "      <td>25%</td>\n",
       "      <td>45%</td>\n",
       "      <td>55%</td>\n",
       "      <td>90.3</td>\n",
       "      <td>96.3</td>\n",
       "      <td>98.8</td>\n",
       "      <td>58.6</td>\n",
       "      <td>81.1</td>\n",
       "      <td>93.2</td>\n",
       "      <td>93.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Harvard University</td>\n",
       "      <td>United States</td>\n",
       "      <td>20823</td>\n",
       "      <td>9.2</td>\n",
       "      <td>24%</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>89.2</td>\n",
       "      <td>98.6</td>\n",
       "      <td>99.1</td>\n",
       "      <td>47.3</td>\n",
       "      <td>76.3</td>\n",
       "      <td>93.0</td>\n",
       "      <td>93.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011</th>\n",
       "      <td>428</td>\n",
       "      <td>Oakland University</td>\n",
       "      <td>United States</td>\n",
       "      <td>15887</td>\n",
       "      <td>18.9</td>\n",
       "      <td>4%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>25.5</td>\n",
       "      <td>12.7</td>\n",
       "      <td>24.5</td>\n",
       "      <td>35.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>21.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015</th>\n",
       "      <td>429</td>\n",
       "      <td>California State University, Long Beach</td>\n",
       "      <td>United States</td>\n",
       "      <td>30595</td>\n",
       "      <td>19.7</td>\n",
       "      <td>4%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>23.1</td>\n",
       "      <td>10.1</td>\n",
       "      <td>27.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>37.3</td>\n",
       "      <td>21.8</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>437</td>\n",
       "      <td>University of North Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>12132</td>\n",
       "      <td>17.7</td>\n",
       "      <td>2%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>24.8</td>\n",
       "      <td>10.5</td>\n",
       "      <td>25.7</td>\n",
       "      <td>34.6</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>438</td>\n",
       "      <td>Texas State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>31893</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>17.4</td>\n",
       "      <td>14.3</td>\n",
       "      <td>27.3</td>\n",
       "      <td>36.4</td>\n",
       "      <td>30.4</td>\n",
       "      <td>20.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>477</td>\n",
       "      <td>University of North Carolina Wilmington</td>\n",
       "      <td>United States</td>\n",
       "      <td>14791</td>\n",
       "      <td>19.6</td>\n",
       "      <td>2%</td>\n",
       "      <td>62%</td>\n",
       "      <td>38%</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.7</td>\n",
       "      <td>23.3</td>\n",
       "      <td>35.1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>16.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>172 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Score_Rank                               University        Country  \\\n",
       "1              2       California Institute of Technology  United States   \n",
       "3              4                      Stanford University  United States   \n",
       "4              5    Massachusetts Institute of Technology  United States   \n",
       "5              6                     Princeton University  United States   \n",
       "6              7                       Harvard University  United States   \n",
       "...          ...                                      ...            ...   \n",
       "1011         428                       Oakland University  United States   \n",
       "1015         429  California State University, Long Beach  United States   \n",
       "1048         437              University of North Florida  United States   \n",
       "1052         438                   Texas State University  United States   \n",
       "1212         477  University of North Carolina Wilmington  United States   \n",
       "\n",
       "      Number_students  Numb_students_per_Staff International_Students  \\\n",
       "1                2240                      6.4                    30%   \n",
       "3               16135                      7.3                    23%   \n",
       "4               11247                      8.6                    34%   \n",
       "5                7983                      8.1                    25%   \n",
       "6               20823                      9.2                    24%   \n",
       "...               ...                      ...                    ...   \n",
       "1011            15887                     18.9                     4%   \n",
       "1015            30595                     19.7                     4%   \n",
       "1048            12132                     17.7                     2%   \n",
       "1052            31893                     19.1                     1%   \n",
       "1212            14791                     19.6                     2%   \n",
       "\n",
       "     Percentage_Female Percentage_Male  Teaching  Research  Citations  \\\n",
       "1                  34%             66%      92.1      97.2       97.9   \n",
       "3                  43%             57%      92.8      96.4       99.9   \n",
       "4                  39%             61%      90.5      92.4       99.5   \n",
       "5                  45%             55%      90.3      96.3       98.8   \n",
       "6                  49%             51%      89.2      98.6       99.1   \n",
       "...                ...             ...       ...       ...        ...   \n",
       "1011               57%             43%      25.5      12.7       24.5   \n",
       "1015               58%             42%      23.1      10.1       27.3   \n",
       "1048               57%             43%      24.8      10.5       25.7   \n",
       "1052               58%             42%      17.4      14.3       27.3   \n",
       "1212               62%             38%      15.9       7.7       23.3   \n",
       "\n",
       "      Industry_Income  International_Outlook  Score_Result Overall_Ranking  \n",
       "1                88.0                   82.5          94.5           94.50  \n",
       "3                66.2                   79.5          94.3           94.30  \n",
       "4                86.9                   89.0          93.6           93.60  \n",
       "5                58.6                   81.1          93.2           93.20  \n",
       "6                47.3                   76.3          93.0           93.00  \n",
       "...               ...                    ...           ...             ...  \n",
       "1011             35.3                   28.9          21.9       10.7�22.1  \n",
       "1015             35.9                   37.3          21.8       10.7�22.1  \n",
       "1048             34.6                   24.0          21.0       10.7�22.1  \n",
       "1052             36.4                   30.4          20.9       10.7�22.1  \n",
       "1212             35.1                   26.5          16.9       10.7�22.1  \n",
       "\n",
       "[172 rows x 15 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_united_states = df[df[\"Country\"]==\"United States\"]\n",
    "df_US = df_united_states\n",
    "df_united_states"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "🎉 All Tests Passed! 🎉\n"
     ]
    }
   ],
   "source": [
    "### TEST CASE for Puzzle 1: Rankings with the United States\n",
    "#\n",
    "# What is this cell?\n",
    "# - This cell contains test cases for the MicroProject. Even though you can modify this\n",
    "#   cell, you should treat it like it's a read-only cell since it will be replaced with\n",
    "#   a fresh version when your code is checked.\n",
    "#\n",
    "# - If this cell runs without any error in the output, you PASSED all test cases!\n",
    "#   We try and make these test cases as useful and complete as possible, but there is\n",
    "#   a chance your code may be incorrect even though you pass the test cases (these\n",
    "#   tests should be seen as a way to give you confidence that code you believe is\n",
    "#   actually correct, not as a robust check to catch all possible errors).\n",
    "#\n",
    "# - If this cell results in any errors, check you previous cells, make changes, and\n",
    "#   RE-RUN your code and then re-run this cell.  Keep repeating this until the cell\n",
    "#   passed with no errors! :)\n",
    "\n",
    "tada = \"\\N{PARTY POPPER}\"\n",
    "\n",
    "assert(df.iloc[47][\"University\"] == \"University of Illinois at Urbana-Champaign\")\n",
    "assert(df.iloc[47][\"Number_students\"] == 44916)\n",
    "\n",
    "assert('df_US' in vars()), \"Make sure to name the dataframe df_united_states.\"\n",
    "assert(len(df_US) == 172), \"It looks like you did not subset df_united_states to only universities located in the United States.\"\n",
    "assert(df_US[\"University\"].iloc[0] == \"California Institute of Technology\")\n",
    "assert(df_US[\"Number_students\"].iloc[171] == 14791)\n",
    "\n",
    "print(f\"{tada} All Tests Passed! {tada}\") "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Exploring Indexes"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "By default, pandas creates an **index** column that starts with the index `0` and indexes each row with an increasing number.  The Top University in the original dataset, Oxford, has an index of 0.  You can view that by running the cell below, that displays the data for the university at index (or `loc`) `0`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Score_Rank                                    1\n",
       "University                 University of Oxford\n",
       "Country                          United Kingdom\n",
       "Number_students                           20664\n",
       "Numb_students_per_Staff                    11.2\n",
       "International_Students                      41%\n",
       "Percentage_Female                           46%\n",
       "Percentage_Male                             54%\n",
       "Teaching                                   90.5\n",
       "Research                                   99.6\n",
       "Citations                                  98.4\n",
       "Industry_Income                            65.5\n",
       "International_Outlook                      96.4\n",
       "Score_Result                               95.4\n",
       "Overall_Ranking                           95.40\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find the row with the index `0` in the DataFrame `df`:\n",
    "df.loc[0]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Your new dataset `df_US` still has the original index values since it is a subset of `df`.  **You will get a `KeyError`** when you try and find the `index` `0` since you removed when you selected only the universities in the United States:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Score_Rank                                                  2\n",
       "University                 California Institute of Technology\n",
       "Country                                         United States\n",
       "Number_students                                          2240\n",
       "Numb_students_per_Staff                                   6.4\n",
       "International_Students                                    30%\n",
       "Percentage_Female                                         34%\n",
       "Percentage_Male                                           66%\n",
       "Teaching                                                 92.1\n",
       "Research                                                 97.2\n",
       "Citations                                                97.9\n",
       "Industry_Income                                          88.0\n",
       "International_Outlook                                    82.5\n",
       "Score_Result                                             94.5\n",
       "Overall_Ranking                                         94.50\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# First, find the row with the index `0` in the DataFrame `df_US`:\n",
    "# (It does not exist, since it's not in the United States, so you should get an error!)\n",
    "# (Continue to the next part to find to then come back and fix the error. :))\n",
    "df_US.loc[1]"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Fix The Error\n",
    "\n",
    "In the above cell, fix the error my looking for the first index that is in the `df_US` DataFrame -- that's index #1, or CalTech.\n",
    "\n",
    "Fix it and re-run the cell before you continue to the next puzzle. :)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"color: #DD3403; border-style: dashed;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Puzzle 1.2: Re-indexing the Universities in the United States\n",
    "\n",
    "Use `df_US.reset_index()` to have pandas **regenerated** the indexes for `df_US`.  Python will:\n",
    "- Replace all of the existing index values in `df_US` with a new index,\n",
    "- This new index will start with `0` and number each row one-by-one as if you imported it as a new dataset\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>index</th>\n",
       "      <th>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>California Institute of Technology</td>\n",
       "      <td>United States</td>\n",
       "      <td>2240</td>\n",
       "      <td>6.4</td>\n",
       "      <td>30%</td>\n",
       "      <td>34%</td>\n",
       "      <td>66%</td>\n",
       "      <td>92.1</td>\n",
       "      <td>97.2</td>\n",
       "      <td>97.9</td>\n",
       "      <td>88.0</td>\n",
       "      <td>82.5</td>\n",
       "      <td>94.5</td>\n",
       "      <td>94.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>Stanford University</td>\n",
       "      <td>United States</td>\n",
       "      <td>16135</td>\n",
       "      <td>7.3</td>\n",
       "      <td>23%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>92.8</td>\n",
       "      <td>96.4</td>\n",
       "      <td>99.9</td>\n",
       "      <td>66.2</td>\n",
       "      <td>79.5</td>\n",
       "      <td>94.3</td>\n",
       "      <td>94.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Massachusetts Institute of Technology</td>\n",
       "      <td>United States</td>\n",
       "      <td>11247</td>\n",
       "      <td>8.6</td>\n",
       "      <td>34%</td>\n",
       "      <td>39%</td>\n",
       "      <td>61%</td>\n",
       "      <td>90.5</td>\n",
       "      <td>92.4</td>\n",
       "      <td>99.5</td>\n",
       "      <td>86.9</td>\n",
       "      <td>89.0</td>\n",
       "      <td>93.6</td>\n",
       "      <td>93.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>Princeton University</td>\n",
       "      <td>United States</td>\n",
       "      <td>7983</td>\n",
       "      <td>8.1</td>\n",
       "      <td>25%</td>\n",
       "      <td>45%</td>\n",
       "      <td>55%</td>\n",
       "      <td>90.3</td>\n",
       "      <td>96.3</td>\n",
       "      <td>98.8</td>\n",
       "      <td>58.6</td>\n",
       "      <td>81.1</td>\n",
       "      <td>93.2</td>\n",
       "      <td>93.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>Harvard University</td>\n",
       "      <td>United States</td>\n",
       "      <td>20823</td>\n",
       "      <td>9.2</td>\n",
       "      <td>24%</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>89.2</td>\n",
       "      <td>98.6</td>\n",
       "      <td>99.1</td>\n",
       "      <td>47.3</td>\n",
       "      <td>76.3</td>\n",
       "      <td>93.0</td>\n",
       "      <td>93.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>1011</td>\n",
       "      <td>428</td>\n",
       "      <td>Oakland University</td>\n",
       "      <td>United States</td>\n",
       "      <td>15887</td>\n",
       "      <td>18.9</td>\n",
       "      <td>4%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>25.5</td>\n",
       "      <td>12.7</td>\n",
       "      <td>24.5</td>\n",
       "      <td>35.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>21.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>1015</td>\n",
       "      <td>429</td>\n",
       "      <td>California State University, Long Beach</td>\n",
       "      <td>United States</td>\n",
       "      <td>30595</td>\n",
       "      <td>19.7</td>\n",
       "      <td>4%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>23.1</td>\n",
       "      <td>10.1</td>\n",
       "      <td>27.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>37.3</td>\n",
       "      <td>21.8</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>1048</td>\n",
       "      <td>437</td>\n",
       "      <td>University of North Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>12132</td>\n",
       "      <td>17.7</td>\n",
       "      <td>2%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>24.8</td>\n",
       "      <td>10.5</td>\n",
       "      <td>25.7</td>\n",
       "      <td>34.6</td>\n",
       "      <td>24.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>1052</td>\n",
       "      <td>438</td>\n",
       "      <td>Texas State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>31893</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>17.4</td>\n",
       "      <td>14.3</td>\n",
       "      <td>27.3</td>\n",
       "      <td>36.4</td>\n",
       "      <td>30.4</td>\n",
       "      <td>20.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>1212</td>\n",
       "      <td>477</td>\n",
       "      <td>University of North Carolina Wilmington</td>\n",
       "      <td>United States</td>\n",
       "      <td>14791</td>\n",
       "      <td>19.6</td>\n",
       "      <td>2%</td>\n",
       "      <td>62%</td>\n",
       "      <td>38%</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.7</td>\n",
       "      <td>23.3</td>\n",
       "      <td>35.1</td>\n",
       "      <td>26.5</td>\n",
       "      <td>16.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>172 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  Score_Rank                               University  \\\n",
       "0        1           2       California Institute of Technology   \n",
       "1        3           4                      Stanford University   \n",
       "2        4           5    Massachusetts Institute of Technology   \n",
       "3        5           6                     Princeton University   \n",
       "4        6           7                       Harvard University   \n",
       "..     ...         ...                                      ...   \n",
       "167   1011         428                       Oakland University   \n",
       "168   1015         429  California State University, Long Beach   \n",
       "169   1048         437              University of North Florida   \n",
       "170   1052         438                   Texas State University   \n",
       "171   1212         477  University of North Carolina Wilmington   \n",
       "\n",
       "           Country  Number_students  Numb_students_per_Staff  \\\n",
       "0    United States             2240                      6.4   \n",
       "1    United States            16135                      7.3   \n",
       "2    United States            11247                      8.6   \n",
       "3    United States             7983                      8.1   \n",
       "4    United States            20823                      9.2   \n",
       "..             ...              ...                      ...   \n",
       "167  United States            15887                     18.9   \n",
       "168  United States            30595                     19.7   \n",
       "169  United States            12132                     17.7   \n",
       "170  United States            31893                     19.1   \n",
       "171  United States            14791                     19.6   \n",
       "\n",
       "    International_Students Percentage_Female Percentage_Male  Teaching  \\\n",
       "0                      30%               34%             66%      92.1   \n",
       "1                      23%               43%             57%      92.8   \n",
       "2                      34%               39%             61%      90.5   \n",
       "3                      25%               45%             55%      90.3   \n",
       "4                      24%               49%             51%      89.2   \n",
       "..                     ...               ...             ...       ...   \n",
       "167                     4%               57%             43%      25.5   \n",
       "168                     4%               58%             42%      23.1   \n",
       "169                     2%               57%             43%      24.8   \n",
       "170                     1%               58%             42%      17.4   \n",
       "171                     2%               62%             38%      15.9   \n",
       "\n",
       "     Research  Citations  Industry_Income  International_Outlook  \\\n",
       "0        97.2       97.9             88.0                   82.5   \n",
       "1        96.4       99.9             66.2                   79.5   \n",
       "2        92.4       99.5             86.9                   89.0   \n",
       "3        96.3       98.8             58.6                   81.1   \n",
       "4        98.6       99.1             47.3                   76.3   \n",
       "..        ...        ...              ...                    ...   \n",
       "167      12.7       24.5             35.3                   28.9   \n",
       "168      10.1       27.3             35.9                   37.3   \n",
       "169      10.5       25.7             34.6                   24.0   \n",
       "170      14.3       27.3             36.4                   30.4   \n",
       "171       7.7       23.3             35.1                   26.5   \n",
       "\n",
       "     Score_Result Overall_Ranking  \n",
       "0            94.5           94.50  \n",
       "1            94.3           94.30  \n",
       "2            93.6           93.60  \n",
       "3            93.2           93.20  \n",
       "4            93.0           93.00  \n",
       "..            ...             ...  \n",
       "167          21.9       10.7�22.1  \n",
       "168          21.8       10.7�22.1  \n",
       "169          21.0       10.7�22.1  \n",
       "170          20.9       10.7�22.1  \n",
       "171          16.9       10.7�22.1  \n",
       "\n",
       "[172 rows x 16 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_US = df_US.reset_index()\n",
    "df_US"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "🎉 All Tests Passed! 🎉\n"
     ]
    }
   ],
   "source": [
    "### TEST CASE for Puzzle 1.2: Re-indexing the Universities in the United States\n",
    "#\n",
    "# What is this cell?\n",
    "# - This cell contains test cases for the MicroProject. Even though you can modify this\n",
    "#   cell, you should treat it like it's a read-only cell since it will be replaced with\n",
    "#   a fresh version when your code is checked.\n",
    "#\n",
    "# - If this cell runs without any error in the output, you PASSED all test cases!\n",
    "#   We try and make these test cases as useful and complete as possible, but there is\n",
    "#   a chance your code may be incorrect even though you pass the test cases (these\n",
    "#   tests should be seen as a way to give you confidence that code you believe is\n",
    "#   actually correct, not as a robust check to catch all possible errors).\n",
    "#\n",
    "# - If this cell results in any errors, check you previous cells, make changes, and\n",
    "#   RE-RUN your code and then re-run this cell.  Keep repeating this until the cell\n",
    "#   passed with no errors! :)\n",
    "\n",
    "tada = \"\\N{PARTY POPPER}\"\n",
    "assert(df_US[\"University\"].loc[0] == \"California Institute of Technology\")\n",
    "print(f\"{tada} All Tests Passed! {tada}\") "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"color: #DD3403;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Puzzle 2: Large Universities in the United States\n",
    "\n",
    "Examine the dataset to find the variable that stores the number of students that attends each university, then create a subset of the DataFrame called `df_US_large` that contains all universities in the United States that have over 30,000 students:"
   ]
  },
  {
   "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>index</th>\n",
       "      <th>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>University of California, Berkeley</td>\n",
       "      <td>United States</td>\n",
       "      <td>41081</td>\n",
       "      <td>13.7</td>\n",
       "      <td>17%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>83.0</td>\n",
       "      <td>90.6</td>\n",
       "      <td>99.2</td>\n",
       "      <td>46.1</td>\n",
       "      <td>70.4</td>\n",
       "      <td>88.3</td>\n",
       "      <td>88.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>University of California, Los Angeles</td>\n",
       "      <td>United States</td>\n",
       "      <td>41066</td>\n",
       "      <td>9.4</td>\n",
       "      <td>17%</td>\n",
       "      <td>54%</td>\n",
       "      <td>46%</td>\n",
       "      <td>83.1</td>\n",
       "      <td>88.6</td>\n",
       "      <td>97.3</td>\n",
       "      <td>51.3</td>\n",
       "      <td>64.1</td>\n",
       "      <td>86.8</td>\n",
       "      <td>86.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>University of Michigan-Ann Arbor</td>\n",
       "      <td>United States</td>\n",
       "      <td>42982</td>\n",
       "      <td>8.3</td>\n",
       "      <td>17%</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>79.4</td>\n",
       "      <td>86.1</td>\n",
       "      <td>94.9</td>\n",
       "      <td>47.7</td>\n",
       "      <td>59.2</td>\n",
       "      <td>83.8</td>\n",
       "      <td>83.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>University of Washington</td>\n",
       "      <td>United States</td>\n",
       "      <td>45692</td>\n",
       "      <td>11.1</td>\n",
       "      <td>16%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>72.2</td>\n",
       "      <td>82.2</td>\n",
       "      <td>98.6</td>\n",
       "      <td>47.5</td>\n",
       "      <td>60.4</td>\n",
       "      <td>81.6</td>\n",
       "      <td>81.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>28</td>\n",
       "      <td>27</td>\n",
       "      <td>New York University</td>\n",
       "      <td>United States</td>\n",
       "      <td>44466</td>\n",
       "      <td>8.9</td>\n",
       "      <td>33%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>76.8</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>65.4</td>\n",
       "      <td>81.1</td>\n",
       "      <td>81.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>30</td>\n",
       "      <td>29</td>\n",
       "      <td>University of California, San Diego</td>\n",
       "      <td>United States</td>\n",
       "      <td>33579</td>\n",
       "      <td>13.0</td>\n",
       "      <td>23%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>62.6</td>\n",
       "      <td>78.9</td>\n",
       "      <td>97.7</td>\n",
       "      <td>90.3</td>\n",
       "      <td>63.7</td>\n",
       "      <td>78.8</td>\n",
       "      <td>78.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>39</td>\n",
       "      <td>34</td>\n",
       "      <td>University of Texas at Austin</td>\n",
       "      <td>United States</td>\n",
       "      <td>49165</td>\n",
       "      <td>17.2</td>\n",
       "      <td>10%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>68.2</td>\n",
       "      <td>76.2</td>\n",
       "      <td>93.2</td>\n",
       "      <td>46.6</td>\n",
       "      <td>39.1</td>\n",
       "      <td>75.4</td>\n",
       "      <td>75.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>47</td>\n",
       "      <td>41</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>United States</td>\n",
       "      <td>44916</td>\n",
       "      <td>17.9</td>\n",
       "      <td>24%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>63.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>84.4</td>\n",
       "      <td>47.9</td>\n",
       "      <td>54.3</td>\n",
       "      <td>73.0</td>\n",
       "      <td>72.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>50</td>\n",
       "      <td>44</td>\n",
       "      <td>University of Wisconsin-Madison</td>\n",
       "      <td>United States</td>\n",
       "      <td>39154</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>68.8</td>\n",
       "      <td>70.3</td>\n",
       "      <td>85.3</td>\n",
       "      <td>46.3</td>\n",
       "      <td>47.4</td>\n",
       "      <td>72.0</td>\n",
       "      <td>72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>University of North Carolina at Chapel Hill</td>\n",
       "      <td>United States</td>\n",
       "      <td>35419</td>\n",
       "      <td>9.4</td>\n",
       "      <td>8%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>59.7</td>\n",
       "      <td>63.2</td>\n",
       "      <td>96.9</td>\n",
       "      <td>43.9</td>\n",
       "      <td>38.0</td>\n",
       "      <td>69.9</td>\n",
       "      <td>69.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>54</td>\n",
       "      <td>48</td>\n",
       "      <td>University of California, Davis</td>\n",
       "      <td>United States</td>\n",
       "      <td>39164</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>62.4</td>\n",
       "      <td>66.9</td>\n",
       "      <td>83.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>62.4</td>\n",
       "      <td>69.7</td>\n",
       "      <td>69.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>62</td>\n",
       "      <td>53</td>\n",
       "      <td>University of Southern California</td>\n",
       "      <td>United States</td>\n",
       "      <td>36929</td>\n",
       "      <td>11.7</td>\n",
       "      <td>25%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>54.7</td>\n",
       "      <td>59.3</td>\n",
       "      <td>93.1</td>\n",
       "      <td>39.7</td>\n",
       "      <td>66.2</td>\n",
       "      <td>68.1</td>\n",
       "      <td>68.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>Ohio State University (Main campus)</td>\n",
       "      <td>United States</td>\n",
       "      <td>54372</td>\n",
       "      <td>12.5</td>\n",
       "      <td>13%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>57.5</td>\n",
       "      <td>56.1</td>\n",
       "      <td>87.3</td>\n",
       "      <td>53.3</td>\n",
       "      <td>59.5</td>\n",
       "      <td>66.1</td>\n",
       "      <td>66.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>77</td>\n",
       "      <td>65</td>\n",
       "      <td>Penn State (Main campus)</td>\n",
       "      <td>United States</td>\n",
       "      <td>46204</td>\n",
       "      <td>15.3</td>\n",
       "      <td>16%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>55.2</td>\n",
       "      <td>67.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>52.1</td>\n",
       "      <td>47.4</td>\n",
       "      <td>64.3</td>\n",
       "      <td>64.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>78</td>\n",
       "      <td>66</td>\n",
       "      <td>University of Minnesota</td>\n",
       "      <td>United States</td>\n",
       "      <td>61120</td>\n",
       "      <td>12.4</td>\n",
       "      <td>11%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>55.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>82.7</td>\n",
       "      <td>78.2</td>\n",
       "      <td>40.2</td>\n",
       "      <td>64.1</td>\n",
       "      <td>64.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>83</td>\n",
       "      <td>68</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>44789</td>\n",
       "      <td>16.5</td>\n",
       "      <td>16%</td>\n",
       "      <td>51%</td>\n",
       "      <td>49%</td>\n",
       "      <td>56.6</td>\n",
       "      <td>57.4</td>\n",
       "      <td>80.0</td>\n",
       "      <td>37.8</td>\n",
       "      <td>63.3</td>\n",
       "      <td>63.9</td>\n",
       "      <td>63.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>87</td>\n",
       "      <td>71</td>\n",
       "      <td>Purdue University West Lafayette</td>\n",
       "      <td>United States</td>\n",
       "      <td>40451</td>\n",
       "      <td>15.7</td>\n",
       "      <td>23%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>57.5</td>\n",
       "      <td>66.4</td>\n",
       "      <td>63.0</td>\n",
       "      <td>64.3</td>\n",
       "      <td>72.0</td>\n",
       "      <td>63.1</td>\n",
       "      <td>63.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>90</td>\n",
       "      <td>73</td>\n",
       "      <td>University of Maryland, College Park</td>\n",
       "      <td>United States</td>\n",
       "      <td>33108</td>\n",
       "      <td>16.6</td>\n",
       "      <td>11%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52%</td>\n",
       "      <td>46.9</td>\n",
       "      <td>59.1</td>\n",
       "      <td>89.6</td>\n",
       "      <td>39.2</td>\n",
       "      <td>41.2</td>\n",
       "      <td>62.8</td>\n",
       "      <td>62.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>95</td>\n",
       "      <td>77</td>\n",
       "      <td>University of California, Irvine</td>\n",
       "      <td>United States</td>\n",
       "      <td>32706</td>\n",
       "      <td>16.5</td>\n",
       "      <td>26%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>43.3</td>\n",
       "      <td>46.5</td>\n",
       "      <td>94.9</td>\n",
       "      <td>58.9</td>\n",
       "      <td>71.9</td>\n",
       "      <td>62.3</td>\n",
       "      <td>62.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>103</td>\n",
       "      <td>81</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>United States</td>\n",
       "      <td>39124</td>\n",
       "      <td>18.4</td>\n",
       "      <td>10%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52.6</td>\n",
       "      <td>53.7</td>\n",
       "      <td>85.3</td>\n",
       "      <td>52.7</td>\n",
       "      <td>40.2</td>\n",
       "      <td>61.8</td>\n",
       "      <td>61.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>123</td>\n",
       "      <td>94</td>\n",
       "      <td>University of Colorado Boulder</td>\n",
       "      <td>United States</td>\n",
       "      <td>33186</td>\n",
       "      <td>16.3</td>\n",
       "      <td>11%</td>\n",
       "      <td>44%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44.8</td>\n",
       "      <td>45.6</td>\n",
       "      <td>93.1</td>\n",
       "      <td>41.7</td>\n",
       "      <td>47.3</td>\n",
       "      <td>59.6</td>\n",
       "      <td>59.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>133</td>\n",
       "      <td>101</td>\n",
       "      <td>Indiana University</td>\n",
       "      <td>United States</td>\n",
       "      <td>66872</td>\n",
       "      <td>13.6</td>\n",
       "      <td>15%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>50.8</td>\n",
       "      <td>49.7</td>\n",
       "      <td>76.7</td>\n",
       "      <td>49.8</td>\n",
       "      <td>53.5</td>\n",
       "      <td>58.4</td>\n",
       "      <td>58.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>154</td>\n",
       "      <td>111</td>\n",
       "      <td>Arizona State University (Tempe)</td>\n",
       "      <td>United States</td>\n",
       "      <td>46683</td>\n",
       "      <td>21.1</td>\n",
       "      <td>21%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>39.3</td>\n",
       "      <td>50.7</td>\n",
       "      <td>81.6</td>\n",
       "      <td>38.5</td>\n",
       "      <td>61.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>57.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>169</td>\n",
       "      <td>117</td>\n",
       "      <td>Rutgers, the State University of New Jersey</td>\n",
       "      <td>United States</td>\n",
       "      <td>44801</td>\n",
       "      <td>11.2</td>\n",
       "      <td>17%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>47.8</td>\n",
       "      <td>48.5</td>\n",
       "      <td>73.9</td>\n",
       "      <td>41.1</td>\n",
       "      <td>51.5</td>\n",
       "      <td>56.0</td>\n",
       "      <td>56.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>174</td>\n",
       "      <td>121</td>\n",
       "      <td>University of Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>46642</td>\n",
       "      <td>16.8</td>\n",
       "      <td>10%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>54.0</td>\n",
       "      <td>53.8</td>\n",
       "      <td>61.9</td>\n",
       "      <td>57.9</td>\n",
       "      <td>40.0</td>\n",
       "      <td>55.4</td>\n",
       "      <td>55.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>177</td>\n",
       "      <td>122</td>\n",
       "      <td>Texas A&amp;M University</td>\n",
       "      <td>United States</td>\n",
       "      <td>60818</td>\n",
       "      <td>24.8</td>\n",
       "      <td>8%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>49.3</td>\n",
       "      <td>54.8</td>\n",
       "      <td>62.8</td>\n",
       "      <td>45.3</td>\n",
       "      <td>54.3</td>\n",
       "      <td>55.3</td>\n",
       "      <td>55.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>209</td>\n",
       "      <td>137</td>\n",
       "      <td>University of Massachusetts</td>\n",
       "      <td>United States</td>\n",
       "      <td>61204</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52%</td>\n",
       "      <td>38.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>87.0</td>\n",
       "      <td>49.9</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.9</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>217</td>\n",
       "      <td>144</td>\n",
       "      <td>University of South Florida (Tampa)</td>\n",
       "      <td>United States</td>\n",
       "      <td>33885</td>\n",
       "      <td>18.9</td>\n",
       "      <td>14%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>30.5</td>\n",
       "      <td>34.2</td>\n",
       "      <td>87.3</td>\n",
       "      <td>89.0</td>\n",
       "      <td>54.7</td>\n",
       "      <td>51.9</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>220</td>\n",
       "      <td>146</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>United States</td>\n",
       "      <td>30365</td>\n",
       "      <td>14.2</td>\n",
       "      <td>8%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>39.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>86.4</td>\n",
       "      <td>48.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>51.7</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>243</td>\n",
       "      <td>157</td>\n",
       "      <td>Virginia Polytechnic Institute and State Unive...</td>\n",
       "      <td>United States</td>\n",
       "      <td>32838</td>\n",
       "      <td>18.3</td>\n",
       "      <td>14%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>37.5</td>\n",
       "      <td>42.3</td>\n",
       "      <td>70.9</td>\n",
       "      <td>47.5</td>\n",
       "      <td>54.0</td>\n",
       "      <td>50.4</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>277</td>\n",
       "      <td>175</td>\n",
       "      <td>Florida State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>38520</td>\n",
       "      <td>24.1</td>\n",
       "      <td>7%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>38.0</td>\n",
       "      <td>40.1</td>\n",
       "      <td>69.2</td>\n",
       "      <td>39.4</td>\n",
       "      <td>43.5</td>\n",
       "      <td>48.4</td>\n",
       "      <td>46.9�50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>310</td>\n",
       "      <td>194</td>\n",
       "      <td>North Carolina State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>30231</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15%</td>\n",
       "      <td>45%</td>\n",
       "      <td>55%</td>\n",
       "      <td>36.7</td>\n",
       "      <td>35.3</td>\n",
       "      <td>64.7</td>\n",
       "      <td>43.2</td>\n",
       "      <td>57.8</td>\n",
       "      <td>46.4</td>\n",
       "      <td>44.5�46.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>312</td>\n",
       "      <td>195</td>\n",
       "      <td>Temple University</td>\n",
       "      <td>United States</td>\n",
       "      <td>35814</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>39.3</td>\n",
       "      <td>23.5</td>\n",
       "      <td>79.3</td>\n",
       "      <td>34.4</td>\n",
       "      <td>37.7</td>\n",
       "      <td>46.3</td>\n",
       "      <td>44.5�46.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>393</td>\n",
       "      <td>230</td>\n",
       "      <td>University of Connecticut</td>\n",
       "      <td>United States</td>\n",
       "      <td>32446</td>\n",
       "      <td>15.2</td>\n",
       "      <td>9%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>36.5</td>\n",
       "      <td>29.7</td>\n",
       "      <td>60.6</td>\n",
       "      <td>37.9</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.7</td>\n",
       "      <td>42.4�44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>400</td>\n",
       "      <td>233</td>\n",
       "      <td>Iowa State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>32469</td>\n",
       "      <td>18.8</td>\n",
       "      <td>12%</td>\n",
       "      <td>44%</td>\n",
       "      <td>56%</td>\n",
       "      <td>29.5</td>\n",
       "      <td>33.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>49.6</td>\n",
       "      <td>56.7</td>\n",
       "      <td>42.4</td>\n",
       "      <td>42.4�44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>403</td>\n",
       "      <td>234</td>\n",
       "      <td>University of Georgia</td>\n",
       "      <td>United States</td>\n",
       "      <td>35164</td>\n",
       "      <td>16.3</td>\n",
       "      <td>7%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>34.9</td>\n",
       "      <td>35.8</td>\n",
       "      <td>55.8</td>\n",
       "      <td>37.2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>42.3</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>431</td>\n",
       "      <td>246</td>\n",
       "      <td>University of Alabama</td>\n",
       "      <td>United States</td>\n",
       "      <td>35120</td>\n",
       "      <td>22.5</td>\n",
       "      <td>4%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>26.9</td>\n",
       "      <td>22.4</td>\n",
       "      <td>77.4</td>\n",
       "      <td>35.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>41.1</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>440</td>\n",
       "      <td>248</td>\n",
       "      <td>University of South Carolina-Columbia</td>\n",
       "      <td>United States</td>\n",
       "      <td>32291</td>\n",
       "      <td>16.2</td>\n",
       "      <td>5%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>33.2</td>\n",
       "      <td>25.5</td>\n",
       "      <td>63.7</td>\n",
       "      <td>36.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>40.9</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>478</td>\n",
       "      <td>262</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>United States</td>\n",
       "      <td>44128</td>\n",
       "      <td>25.7</td>\n",
       "      <td>9%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>33.6</td>\n",
       "      <td>25.9</td>\n",
       "      <td>58.0</td>\n",
       "      <td>36.8</td>\n",
       "      <td>42.5</td>\n",
       "      <td>39.4</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>507</td>\n",
       "      <td>271</td>\n",
       "      <td>Florida International University</td>\n",
       "      <td>United States</td>\n",
       "      <td>34203</td>\n",
       "      <td>23.8</td>\n",
       "      <td>8%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>30.4</td>\n",
       "      <td>22.6</td>\n",
       "      <td>62.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>39.7</td>\n",
       "      <td>38.5</td>\n",
       "      <td>35.3�38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>558</td>\n",
       "      <td>290</td>\n",
       "      <td>San Diego State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>30799</td>\n",
       "      <td>30.5</td>\n",
       "      <td>8%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>23.7</td>\n",
       "      <td>24.4</td>\n",
       "      <td>62.0</td>\n",
       "      <td>35.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>36.5</td>\n",
       "      <td>35.3�38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>609</td>\n",
       "      <td>304</td>\n",
       "      <td>University of Central Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>56228</td>\n",
       "      <td>35.3</td>\n",
       "      <td>4%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>26.5</td>\n",
       "      <td>28.7</td>\n",
       "      <td>49.7</td>\n",
       "      <td>42.6</td>\n",
       "      <td>32.9</td>\n",
       "      <td>35.0</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>638</td>\n",
       "      <td>314</td>\n",
       "      <td>Texas Tech University</td>\n",
       "      <td>United States</td>\n",
       "      <td>33015</td>\n",
       "      <td>20.6</td>\n",
       "      <td>9%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>30.8</td>\n",
       "      <td>20.9</td>\n",
       "      <td>46.5</td>\n",
       "      <td>36.2</td>\n",
       "      <td>48.4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>1015</td>\n",
       "      <td>429</td>\n",
       "      <td>California State University, Long Beach</td>\n",
       "      <td>United States</td>\n",
       "      <td>30595</td>\n",
       "      <td>19.7</td>\n",
       "      <td>4%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>23.1</td>\n",
       "      <td>10.1</td>\n",
       "      <td>27.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>37.3</td>\n",
       "      <td>21.8</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>1052</td>\n",
       "      <td>438</td>\n",
       "      <td>Texas State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>31893</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>17.4</td>\n",
       "      <td>14.3</td>\n",
       "      <td>27.3</td>\n",
       "      <td>36.4</td>\n",
       "      <td>30.4</td>\n",
       "      <td>20.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     index  Score_Rank                                         University  \\\n",
       "9       12          13                 University of California, Berkeley   \n",
       "11      16          16              University of California, Los Angeles   \n",
       "14      20          20                   University of Michigan-Ann Arbor   \n",
       "16      25          25                           University of Washington   \n",
       "18      28          27                                New York University   \n",
       "19      30          29                University of California, San Diego   \n",
       "21      39          34                      University of Texas at Austin   \n",
       "22      47          41         University of Illinois at Urbana-Champaign   \n",
       "23      50          44                    University of Wisconsin-Madison   \n",
       "26      53          47        University of North Carolina at Chapel Hill   \n",
       "27      54          48                    University of California, Davis   \n",
       "30      62          53                  University of Southern California   \n",
       "31      69          59                Ohio State University (Main campus)   \n",
       "32      77          65                           Penn State (Main campus)   \n",
       "33      78          66                            University of Minnesota   \n",
       "35      83          68                          Michigan State University   \n",
       "36      87          71                   Purdue University West Lafayette   \n",
       "37      90          73               University of Maryland, College Park   \n",
       "39      95          77                   University of California, Irvine   \n",
       "41     103          81                              University of Arizona   \n",
       "47     123          94                     University of Colorado Boulder   \n",
       "48     133         101                                 Indiana University   \n",
       "50     154         111                   Arizona State University (Tempe)   \n",
       "52     169         117        Rutgers, the State University of New Jersey   \n",
       "56     174         121                              University of Florida   \n",
       "57     177         122                               Texas A&M University   \n",
       "60     209         137                        University of Massachusetts   \n",
       "61     217         144                University of South Florida (Tampa)   \n",
       "62     220         146                                 University of Utah   \n",
       "68     243         157  Virginia Polytechnic Institute and State Unive...   \n",
       "76     277         175                           Florida State University   \n",
       "83     310         194                    North Carolina State University   \n",
       "84     312         195                                  Temple University   \n",
       "99     393         230                          University of Connecticut   \n",
       "102    400         233                              Iowa State University   \n",
       "103    403         234                              University of Georgia   \n",
       "110    431         246                              University of Alabama   \n",
       "113    440         248              University of South Carolina-Columbia   \n",
       "115    478         262                              University of Houston   \n",
       "122    507         271                   Florida International University   \n",
       "127    558         290                         San Diego State University   \n",
       "135    609         304                      University of Central Florida   \n",
       "140    638         314                              Texas Tech University   \n",
       "168   1015         429            California State University, Long Beach   \n",
       "170   1052         438                             Texas State University   \n",
       "\n",
       "           Country  Number_students  Numb_students_per_Staff  \\\n",
       "9    United States            41081                     13.7   \n",
       "11   United States            41066                      9.4   \n",
       "14   United States            42982                      8.3   \n",
       "16   United States            45692                     11.1   \n",
       "18   United States            44466                      8.9   \n",
       "19   United States            33579                     13.0   \n",
       "21   United States            49165                     17.2   \n",
       "22   United States            44916                     17.9   \n",
       "23   United States            39154                     10.0   \n",
       "26   United States            35419                      9.4   \n",
       "27   United States            39164                     12.0   \n",
       "30   United States            36929                     11.7   \n",
       "31   United States            54372                     12.5   \n",
       "32   United States            46204                     15.3   \n",
       "33   United States            61120                     12.4   \n",
       "35   United States            44789                     16.5   \n",
       "36   United States            40451                     15.7   \n",
       "37   United States            33108                     16.6   \n",
       "39   United States            32706                     16.5   \n",
       "41   United States            39124                     18.4   \n",
       "47   United States            33186                     16.3   \n",
       "48   United States            66872                     13.6   \n",
       "50   United States            46683                     21.1   \n",
       "52   United States            44801                     11.2   \n",
       "56   United States            46642                     16.8   \n",
       "57   United States            60818                     24.8   \n",
       "60   United States            61204                     13.0   \n",
       "61   United States            33885                     18.9   \n",
       "62   United States            30365                     14.2   \n",
       "68   United States            32838                     18.3   \n",
       "76   United States            38520                     24.1   \n",
       "83   United States            30231                     12.5   \n",
       "84   United States            35814                     13.0   \n",
       "99   United States            32446                     15.2   \n",
       "102  United States            32469                     18.8   \n",
       "103  United States            35164                     16.3   \n",
       "110  United States            35120                     22.5   \n",
       "113  United States            32291                     16.2   \n",
       "115  United States            44128                     25.7   \n",
       "122  United States            34203                     23.8   \n",
       "127  United States            30799                     30.5   \n",
       "135  United States            56228                     35.3   \n",
       "140  United States            33015                     20.6   \n",
       "168  United States            30595                     19.7   \n",
       "170  United States            31893                     19.1   \n",
       "\n",
       "    International_Students Percentage_Female Percentage_Male  Teaching  \\\n",
       "9                      17%               50%             50%      83.0   \n",
       "11                     17%               54%             46%      83.1   \n",
       "14                     17%               49%             51%      79.4   \n",
       "16                     16%               53%             47%      72.2   \n",
       "18                     33%               57%             43%      76.8   \n",
       "19                     23%               46%             54%      62.6   \n",
       "21                     10%               52%             48%      68.2   \n",
       "22                     24%               47%             53%      63.2   \n",
       "23                     13%                0%              0%      68.8   \n",
       "26                      8%               57%             43%      59.7   \n",
       "27                     14%               58%             42%      62.4   \n",
       "30                     25%               53%             47%      54.7   \n",
       "31                     13%               50%             50%      57.5   \n",
       "32                     16%               46%             54%      55.2   \n",
       "33                     11%               52%             48%      55.2   \n",
       "35                     16%               51%             49%      56.6   \n",
       "36                     23%               43%             57%      57.5   \n",
       "37                     11%               48%             52%      46.9   \n",
       "39                     26%               52%             48%      43.3   \n",
       "41                     10%               52%             48%      52.6   \n",
       "47                     11%               44%             56%      44.8   \n",
       "48                     15%               52%             48%      50.8   \n",
       "50                     21%               43%             57%      39.3   \n",
       "52                     17%               52%             48%      47.8   \n",
       "56                     10%               55%             45%      54.0   \n",
       "57                      8%               47%             53%      49.3   \n",
       "60                     15%               48%             52%      38.5   \n",
       "61                     14%                0%              0%      30.5   \n",
       "62                      8%               47%             53%      39.0   \n",
       "68                     14%               43%             57%      37.5   \n",
       "76                      7%               56%             44%      38.0   \n",
       "83                     15%               45%             55%      36.7   \n",
       "84                      9%               53%             47%      39.3   \n",
       "99                      9%               53%             47%      36.5   \n",
       "102                    12%               44%             56%      29.5   \n",
       "103                     7%               57%             43%      34.9   \n",
       "110                     4%               56%             44%      26.9   \n",
       "113                     5%               55%             45%      33.2   \n",
       "115                     9%               50%             50%      33.6   \n",
       "122                     8%               57%             43%      30.4   \n",
       "127                     8%               55%             45%      23.7   \n",
       "135                     4%               56%             44%      26.5   \n",
       "140                     9%               46%             54%      30.8   \n",
       "168                     4%               58%             42%      23.1   \n",
       "170                     1%               58%             42%      17.4   \n",
       "\n",
       "     Research  Citations  Industry_Income  International_Outlook  \\\n",
       "9        90.6       99.2             46.1                   70.4   \n",
       "11       88.6       97.3             51.3                   64.1   \n",
       "14       86.1       94.9             47.7                   59.2   \n",
       "16       82.2       98.6             47.5                   60.4   \n",
       "18       77.5       96.5             38.7                   65.4   \n",
       "19       78.9       97.7             90.3                   63.7   \n",
       "21       76.2       93.2             46.6                   39.1   \n",
       "22       78.0       84.4             47.9                   54.3   \n",
       "23       70.3       85.3             46.3                   47.4   \n",
       "26       63.2       96.9             43.9                   38.0   \n",
       "27       66.9       83.2             51.4                   62.4   \n",
       "30       59.3       93.1             39.7                   66.2   \n",
       "31       56.1       87.3             53.3                   59.5   \n",
       "32       67.1       75.7             52.1                   47.4   \n",
       "33       59.3       82.7             78.2                   40.2   \n",
       "35       57.4       80.0             37.8                   63.3   \n",
       "36       66.4       63.0             64.3                   72.0   \n",
       "37       59.1       89.6             39.2                   41.2   \n",
       "39       46.5       94.9             58.9                   71.9   \n",
       "41       53.7       85.3             52.7                   40.2   \n",
       "47       45.6       93.1             41.7                   47.3   \n",
       "48       49.7       76.7             49.8                   53.5   \n",
       "50       50.7       81.6             38.5                   61.8   \n",
       "52       48.5       73.9             41.1                   51.5   \n",
       "56       53.8       61.9             57.9                   40.0   \n",
       "57       54.8       62.8             45.3                   54.3   \n",
       "60       31.1       87.0             49.9                   61.7   \n",
       "61       34.2       87.3             89.0                   54.7   \n",
       "62       34.7       86.4             48.3                   33.0   \n",
       "68       42.3       70.9             47.5                   54.0   \n",
       "76       40.1       69.2             39.4                   43.5   \n",
       "83       35.3       64.7             43.2                   57.8   \n",
       "84       23.5       79.3             34.4                   37.7   \n",
       "99       29.7       60.6             37.9                   49.0   \n",
       "102      33.0       60.5             49.6                   56.7   \n",
       "103      35.8       55.8             37.2                   46.0   \n",
       "110      22.4       77.4             35.3                   28.9   \n",
       "113      25.5       63.7             36.2                   43.2   \n",
       "115      25.9       58.0             36.8                   42.5   \n",
       "122      22.6       62.3             38.0                   39.7   \n",
       "127      24.4       62.0             35.1                   33.9   \n",
       "135      28.7       49.7             42.6                   32.9   \n",
       "140      20.9       46.5             36.2                   48.4   \n",
       "168      10.1       27.3             35.9                   37.3   \n",
       "170      14.3       27.3             36.4                   30.4   \n",
       "\n",
       "     Score_Result Overall_Ranking  \n",
       "9            88.3           88.30  \n",
       "11           86.8           86.80  \n",
       "14           83.8           83.80  \n",
       "16           81.6           81.60  \n",
       "18           81.1           81.10  \n",
       "19           78.8           78.80  \n",
       "21           75.4           75.40  \n",
       "22           73.0           72.90  \n",
       "23           72.0           72.00  \n",
       "26           69.9           69.90  \n",
       "27           69.7           69.70  \n",
       "30           68.1           68.10  \n",
       "31           66.1           66.10  \n",
       "32           64.3           64.20  \n",
       "33           64.1           64.10  \n",
       "35           63.9           63.90  \n",
       "36           63.1           63.10  \n",
       "37           62.8           62.70  \n",
       "39           62.3           62.30  \n",
       "41           61.8           61.80  \n",
       "47           59.6           59.60  \n",
       "48           58.4           58.40  \n",
       "50           57.1           57.10  \n",
       "52           56.0           56.00  \n",
       "56           55.4           55.40  \n",
       "57           55.3           55.30  \n",
       "60           52.9       50.1�53.7  \n",
       "61           51.9       50.1�53.7  \n",
       "62           51.7       50.1�53.7  \n",
       "68           50.4       50.1�53.7  \n",
       "76           48.4       46.9�50.0  \n",
       "83           46.4       44.5�46.8  \n",
       "84           46.3       44.5�46.8  \n",
       "99           42.7       42.4�44.4  \n",
       "102          42.4       42.4�44.4  \n",
       "103          42.3       38.8�42.3  \n",
       "110          41.1       38.8�42.3  \n",
       "113          40.9       38.8�42.3  \n",
       "115          39.4       38.8�42.3  \n",
       "122          38.5       35.3�38.7  \n",
       "127          36.5       35.3�38.7  \n",
       "135          35.0       28.3�35.2  \n",
       "140          34.0       28.3�35.2  \n",
       "168          21.8       10.7�22.1  \n",
       "170          20.9       10.7�22.1  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_US_large = df_US[df_US.Number_students>=30000]\n",
    "df_US_large"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "🎉 All Tests Passed! 🎉\n"
     ]
    }
   ],
   "source": [
    "### TEST CASE for Puzzle 2: Large Universities in the United States\n",
    "#\n",
    "# What is this cell?\n",
    "# - This cell contains test cases for the MicroProject. Even though you can modify this\n",
    "#   cell, you should treat it like it's a read-only cell since it will be replaced with\n",
    "#   a fresh version when your code is checked.\n",
    "#\n",
    "# - If this cell runs without any error in the output, you PASSED all test cases!\n",
    "#   We try and make these test cases as useful and complete as possible, but there is\n",
    "#   a chance your code may be incorrect even though you pass the test cases (these\n",
    "#   tests should be seen as a way to give you confidence that code you believe is\n",
    "#   actually correct, not as a robust check to catch all possible errors).\n",
    "#\n",
    "# - If this cell results in any errors, check you previous cells, make changes, and\n",
    "#   RE-RUN your code and then re-run this cell.  Keep repeating this until the cell\n",
    "#   passed with no errors! :)\n",
    "\n",
    "tada = \"\\N{PARTY POPPER}\"\n",
    "\n",
    "assert('df_US_large' in vars()), \"Make sure to name the dataframe df_less_than_10000.\"\n",
    "assert(len(df_US_large) == 45), \"It looks like you did not subset df_less_than_10000 to only universities with less than 10000 students.\"\n",
    "assert(df_US_large[\"University\"].iloc[7] == \"University of Illinois at Urbana-Champaign\")\n",
    "print(f\"{tada} All Tests Passed! {tada}\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Puzzle 2.2: Using the index to store a US_Large_Ranking\n",
    "\n",
    "In the DataFrame, the provided list has a `Score_Rank` column.  We want to add a `US_Large_Rank` to create a ranking of just large schools in the United States.  There are several ways to do this, but one of the easiest is to use the `reset_index()` function.\n",
    "\n",
    "- Since the list is already sorted, we know the first university in `df_US_large` is the top university (Rank #1).  The second row is Rank #2, and so on.\n",
    "- If we use `reset_index`, pandas will re-index the rows starting from zero.  The first entry is Rank #1, but index 0, so we'd just need to add one to all the index values!\n",
    "\n",
    "Complete the following two steps:\n",
    "- Use `reset_index()` to reset the index values of `df_US_large`,\n",
    "- Then, create a new column in `df_US_large` called `\"US_Large_Rank\"` that has the value of `df_US_large.index + 1`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>University of California, Berkeley</td>\n",
       "      <td>United States</td>\n",
       "      <td>41081</td>\n",
       "      <td>13.7</td>\n",
       "      <td>17%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>83.0</td>\n",
       "      <td>90.6</td>\n",
       "      <td>99.2</td>\n",
       "      <td>46.1</td>\n",
       "      <td>70.4</td>\n",
       "      <td>88.3</td>\n",
       "      <td>88.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>University of California, Los Angeles</td>\n",
       "      <td>United States</td>\n",
       "      <td>41066</td>\n",
       "      <td>9.4</td>\n",
       "      <td>17%</td>\n",
       "      <td>54%</td>\n",
       "      <td>46%</td>\n",
       "      <td>83.1</td>\n",
       "      <td>88.6</td>\n",
       "      <td>97.3</td>\n",
       "      <td>51.3</td>\n",
       "      <td>64.1</td>\n",
       "      <td>86.8</td>\n",
       "      <td>86.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>University of Michigan-Ann Arbor</td>\n",
       "      <td>United States</td>\n",
       "      <td>42982</td>\n",
       "      <td>8.3</td>\n",
       "      <td>17%</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>79.4</td>\n",
       "      <td>86.1</td>\n",
       "      <td>94.9</td>\n",
       "      <td>47.7</td>\n",
       "      <td>59.2</td>\n",
       "      <td>83.8</td>\n",
       "      <td>83.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>University of Washington</td>\n",
       "      <td>United States</td>\n",
       "      <td>45692</td>\n",
       "      <td>11.1</td>\n",
       "      <td>16%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>72.2</td>\n",
       "      <td>82.2</td>\n",
       "      <td>98.6</td>\n",
       "      <td>47.5</td>\n",
       "      <td>60.4</td>\n",
       "      <td>81.6</td>\n",
       "      <td>81.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18</td>\n",
       "      <td>28</td>\n",
       "      <td>27</td>\n",
       "      <td>New York University</td>\n",
       "      <td>United States</td>\n",
       "      <td>44466</td>\n",
       "      <td>8.9</td>\n",
       "      <td>33%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>76.8</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>65.4</td>\n",
       "      <td>81.1</td>\n",
       "      <td>81.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>29</td>\n",
       "      <td>University of California, San Diego</td>\n",
       "      <td>United States</td>\n",
       "      <td>33579</td>\n",
       "      <td>13.0</td>\n",
       "      <td>23%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>62.6</td>\n",
       "      <td>78.9</td>\n",
       "      <td>97.7</td>\n",
       "      <td>90.3</td>\n",
       "      <td>63.7</td>\n",
       "      <td>78.8</td>\n",
       "      <td>78.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>21</td>\n",
       "      <td>39</td>\n",
       "      <td>34</td>\n",
       "      <td>University of Texas at Austin</td>\n",
       "      <td>United States</td>\n",
       "      <td>49165</td>\n",
       "      <td>17.2</td>\n",
       "      <td>10%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>68.2</td>\n",
       "      <td>76.2</td>\n",
       "      <td>93.2</td>\n",
       "      <td>46.6</td>\n",
       "      <td>39.1</td>\n",
       "      <td>75.4</td>\n",
       "      <td>75.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22</td>\n",
       "      <td>47</td>\n",
       "      <td>41</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>United States</td>\n",
       "      <td>44916</td>\n",
       "      <td>17.9</td>\n",
       "      <td>24%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>63.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>84.4</td>\n",
       "      <td>47.9</td>\n",
       "      <td>54.3</td>\n",
       "      <td>73.0</td>\n",
       "      <td>72.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>23</td>\n",
       "      <td>50</td>\n",
       "      <td>44</td>\n",
       "      <td>University of Wisconsin-Madison</td>\n",
       "      <td>United States</td>\n",
       "      <td>39154</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>68.8</td>\n",
       "      <td>70.3</td>\n",
       "      <td>85.3</td>\n",
       "      <td>46.3</td>\n",
       "      <td>47.4</td>\n",
       "      <td>72.0</td>\n",
       "      <td>72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>26</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>University of North Carolina at Chapel Hill</td>\n",
       "      <td>United States</td>\n",
       "      <td>35419</td>\n",
       "      <td>9.4</td>\n",
       "      <td>8%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>59.7</td>\n",
       "      <td>63.2</td>\n",
       "      <td>96.9</td>\n",
       "      <td>43.9</td>\n",
       "      <td>38.0</td>\n",
       "      <td>69.9</td>\n",
       "      <td>69.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>27</td>\n",
       "      <td>54</td>\n",
       "      <td>48</td>\n",
       "      <td>University of California, Davis</td>\n",
       "      <td>United States</td>\n",
       "      <td>39164</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>62.4</td>\n",
       "      <td>66.9</td>\n",
       "      <td>83.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>62.4</td>\n",
       "      <td>69.7</td>\n",
       "      <td>69.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>30</td>\n",
       "      <td>62</td>\n",
       "      <td>53</td>\n",
       "      <td>University of Southern California</td>\n",
       "      <td>United States</td>\n",
       "      <td>36929</td>\n",
       "      <td>11.7</td>\n",
       "      <td>25%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>54.7</td>\n",
       "      <td>59.3</td>\n",
       "      <td>93.1</td>\n",
       "      <td>39.7</td>\n",
       "      <td>66.2</td>\n",
       "      <td>68.1</td>\n",
       "      <td>68.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>31</td>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>Ohio State University (Main campus)</td>\n",
       "      <td>United States</td>\n",
       "      <td>54372</td>\n",
       "      <td>12.5</td>\n",
       "      <td>13%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>57.5</td>\n",
       "      <td>56.1</td>\n",
       "      <td>87.3</td>\n",
       "      <td>53.3</td>\n",
       "      <td>59.5</td>\n",
       "      <td>66.1</td>\n",
       "      <td>66.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>32</td>\n",
       "      <td>77</td>\n",
       "      <td>65</td>\n",
       "      <td>Penn State (Main campus)</td>\n",
       "      <td>United States</td>\n",
       "      <td>46204</td>\n",
       "      <td>15.3</td>\n",
       "      <td>16%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>55.2</td>\n",
       "      <td>67.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>52.1</td>\n",
       "      <td>47.4</td>\n",
       "      <td>64.3</td>\n",
       "      <td>64.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>33</td>\n",
       "      <td>78</td>\n",
       "      <td>66</td>\n",
       "      <td>University of Minnesota</td>\n",
       "      <td>United States</td>\n",
       "      <td>61120</td>\n",
       "      <td>12.4</td>\n",
       "      <td>11%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>55.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>82.7</td>\n",
       "      <td>78.2</td>\n",
       "      <td>40.2</td>\n",
       "      <td>64.1</td>\n",
       "      <td>64.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>35</td>\n",
       "      <td>83</td>\n",
       "      <td>68</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>44789</td>\n",
       "      <td>16.5</td>\n",
       "      <td>16%</td>\n",
       "      <td>51%</td>\n",
       "      <td>49%</td>\n",
       "      <td>56.6</td>\n",
       "      <td>57.4</td>\n",
       "      <td>80.0</td>\n",
       "      <td>37.8</td>\n",
       "      <td>63.3</td>\n",
       "      <td>63.9</td>\n",
       "      <td>63.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>36</td>\n",
       "      <td>87</td>\n",
       "      <td>71</td>\n",
       "      <td>Purdue University West Lafayette</td>\n",
       "      <td>United States</td>\n",
       "      <td>40451</td>\n",
       "      <td>15.7</td>\n",
       "      <td>23%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>57.5</td>\n",
       "      <td>66.4</td>\n",
       "      <td>63.0</td>\n",
       "      <td>64.3</td>\n",
       "      <td>72.0</td>\n",
       "      <td>63.1</td>\n",
       "      <td>63.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>37</td>\n",
       "      <td>90</td>\n",
       "      <td>73</td>\n",
       "      <td>University of Maryland, College Park</td>\n",
       "      <td>United States</td>\n",
       "      <td>33108</td>\n",
       "      <td>16.6</td>\n",
       "      <td>11%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52%</td>\n",
       "      <td>46.9</td>\n",
       "      <td>59.1</td>\n",
       "      <td>89.6</td>\n",
       "      <td>39.2</td>\n",
       "      <td>41.2</td>\n",
       "      <td>62.8</td>\n",
       "      <td>62.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>39</td>\n",
       "      <td>95</td>\n",
       "      <td>77</td>\n",
       "      <td>University of California, Irvine</td>\n",
       "      <td>United States</td>\n",
       "      <td>32706</td>\n",
       "      <td>16.5</td>\n",
       "      <td>26%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>43.3</td>\n",
       "      <td>46.5</td>\n",
       "      <td>94.9</td>\n",
       "      <td>58.9</td>\n",
       "      <td>71.9</td>\n",
       "      <td>62.3</td>\n",
       "      <td>62.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>41</td>\n",
       "      <td>103</td>\n",
       "      <td>81</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>United States</td>\n",
       "      <td>39124</td>\n",
       "      <td>18.4</td>\n",
       "      <td>10%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52.6</td>\n",
       "      <td>53.7</td>\n",
       "      <td>85.3</td>\n",
       "      <td>52.7</td>\n",
       "      <td>40.2</td>\n",
       "      <td>61.8</td>\n",
       "      <td>61.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>47</td>\n",
       "      <td>123</td>\n",
       "      <td>94</td>\n",
       "      <td>University of Colorado Boulder</td>\n",
       "      <td>United States</td>\n",
       "      <td>33186</td>\n",
       "      <td>16.3</td>\n",
       "      <td>11%</td>\n",
       "      <td>44%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44.8</td>\n",
       "      <td>45.6</td>\n",
       "      <td>93.1</td>\n",
       "      <td>41.7</td>\n",
       "      <td>47.3</td>\n",
       "      <td>59.6</td>\n",
       "      <td>59.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>48</td>\n",
       "      <td>133</td>\n",
       "      <td>101</td>\n",
       "      <td>Indiana University</td>\n",
       "      <td>United States</td>\n",
       "      <td>66872</td>\n",
       "      <td>13.6</td>\n",
       "      <td>15%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>50.8</td>\n",
       "      <td>49.7</td>\n",
       "      <td>76.7</td>\n",
       "      <td>49.8</td>\n",
       "      <td>53.5</td>\n",
       "      <td>58.4</td>\n",
       "      <td>58.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>50</td>\n",
       "      <td>154</td>\n",
       "      <td>111</td>\n",
       "      <td>Arizona State University (Tempe)</td>\n",
       "      <td>United States</td>\n",
       "      <td>46683</td>\n",
       "      <td>21.1</td>\n",
       "      <td>21%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>39.3</td>\n",
       "      <td>50.7</td>\n",
       "      <td>81.6</td>\n",
       "      <td>38.5</td>\n",
       "      <td>61.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>57.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>52</td>\n",
       "      <td>169</td>\n",
       "      <td>117</td>\n",
       "      <td>Rutgers, the State University of New Jersey</td>\n",
       "      <td>United States</td>\n",
       "      <td>44801</td>\n",
       "      <td>11.2</td>\n",
       "      <td>17%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>47.8</td>\n",
       "      <td>48.5</td>\n",
       "      <td>73.9</td>\n",
       "      <td>41.1</td>\n",
       "      <td>51.5</td>\n",
       "      <td>56.0</td>\n",
       "      <td>56.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>56</td>\n",
       "      <td>174</td>\n",
       "      <td>121</td>\n",
       "      <td>University of Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>46642</td>\n",
       "      <td>16.8</td>\n",
       "      <td>10%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>54.0</td>\n",
       "      <td>53.8</td>\n",
       "      <td>61.9</td>\n",
       "      <td>57.9</td>\n",
       "      <td>40.0</td>\n",
       "      <td>55.4</td>\n",
       "      <td>55.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>57</td>\n",
       "      <td>177</td>\n",
       "      <td>122</td>\n",
       "      <td>Texas A&amp;M University</td>\n",
       "      <td>United States</td>\n",
       "      <td>60818</td>\n",
       "      <td>24.8</td>\n",
       "      <td>8%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>49.3</td>\n",
       "      <td>54.8</td>\n",
       "      <td>62.8</td>\n",
       "      <td>45.3</td>\n",
       "      <td>54.3</td>\n",
       "      <td>55.3</td>\n",
       "      <td>55.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>60</td>\n",
       "      <td>209</td>\n",
       "      <td>137</td>\n",
       "      <td>University of Massachusetts</td>\n",
       "      <td>United States</td>\n",
       "      <td>61204</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52%</td>\n",
       "      <td>38.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>87.0</td>\n",
       "      <td>49.9</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.9</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>61</td>\n",
       "      <td>217</td>\n",
       "      <td>144</td>\n",
       "      <td>University of South Florida (Tampa)</td>\n",
       "      <td>United States</td>\n",
       "      <td>33885</td>\n",
       "      <td>18.9</td>\n",
       "      <td>14%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>30.5</td>\n",
       "      <td>34.2</td>\n",
       "      <td>87.3</td>\n",
       "      <td>89.0</td>\n",
       "      <td>54.7</td>\n",
       "      <td>51.9</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>62</td>\n",
       "      <td>220</td>\n",
       "      <td>146</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>United States</td>\n",
       "      <td>30365</td>\n",
       "      <td>14.2</td>\n",
       "      <td>8%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>39.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>86.4</td>\n",
       "      <td>48.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>51.7</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>68</td>\n",
       "      <td>243</td>\n",
       "      <td>157</td>\n",
       "      <td>Virginia Polytechnic Institute and State Unive...</td>\n",
       "      <td>United States</td>\n",
       "      <td>32838</td>\n",
       "      <td>18.3</td>\n",
       "      <td>14%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>37.5</td>\n",
       "      <td>42.3</td>\n",
       "      <td>70.9</td>\n",
       "      <td>47.5</td>\n",
       "      <td>54.0</td>\n",
       "      <td>50.4</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>76</td>\n",
       "      <td>277</td>\n",
       "      <td>175</td>\n",
       "      <td>Florida State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>38520</td>\n",
       "      <td>24.1</td>\n",
       "      <td>7%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>38.0</td>\n",
       "      <td>40.1</td>\n",
       "      <td>69.2</td>\n",
       "      <td>39.4</td>\n",
       "      <td>43.5</td>\n",
       "      <td>48.4</td>\n",
       "      <td>46.9�50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>83</td>\n",
       "      <td>310</td>\n",
       "      <td>194</td>\n",
       "      <td>North Carolina State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>30231</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15%</td>\n",
       "      <td>45%</td>\n",
       "      <td>55%</td>\n",
       "      <td>36.7</td>\n",
       "      <td>35.3</td>\n",
       "      <td>64.7</td>\n",
       "      <td>43.2</td>\n",
       "      <td>57.8</td>\n",
       "      <td>46.4</td>\n",
       "      <td>44.5�46.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>84</td>\n",
       "      <td>312</td>\n",
       "      <td>195</td>\n",
       "      <td>Temple University</td>\n",
       "      <td>United States</td>\n",
       "      <td>35814</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>39.3</td>\n",
       "      <td>23.5</td>\n",
       "      <td>79.3</td>\n",
       "      <td>34.4</td>\n",
       "      <td>37.7</td>\n",
       "      <td>46.3</td>\n",
       "      <td>44.5�46.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>99</td>\n",
       "      <td>393</td>\n",
       "      <td>230</td>\n",
       "      <td>University of Connecticut</td>\n",
       "      <td>United States</td>\n",
       "      <td>32446</td>\n",
       "      <td>15.2</td>\n",
       "      <td>9%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>36.5</td>\n",
       "      <td>29.7</td>\n",
       "      <td>60.6</td>\n",
       "      <td>37.9</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.7</td>\n",
       "      <td>42.4�44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>102</td>\n",
       "      <td>400</td>\n",
       "      <td>233</td>\n",
       "      <td>Iowa State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>32469</td>\n",
       "      <td>18.8</td>\n",
       "      <td>12%</td>\n",
       "      <td>44%</td>\n",
       "      <td>56%</td>\n",
       "      <td>29.5</td>\n",
       "      <td>33.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>49.6</td>\n",
       "      <td>56.7</td>\n",
       "      <td>42.4</td>\n",
       "      <td>42.4�44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>103</td>\n",
       "      <td>403</td>\n",
       "      <td>234</td>\n",
       "      <td>University of Georgia</td>\n",
       "      <td>United States</td>\n",
       "      <td>35164</td>\n",
       "      <td>16.3</td>\n",
       "      <td>7%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>34.9</td>\n",
       "      <td>35.8</td>\n",
       "      <td>55.8</td>\n",
       "      <td>37.2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>42.3</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>110</td>\n",
       "      <td>431</td>\n",
       "      <td>246</td>\n",
       "      <td>University of Alabama</td>\n",
       "      <td>United States</td>\n",
       "      <td>35120</td>\n",
       "      <td>22.5</td>\n",
       "      <td>4%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>26.9</td>\n",
       "      <td>22.4</td>\n",
       "      <td>77.4</td>\n",
       "      <td>35.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>41.1</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>113</td>\n",
       "      <td>440</td>\n",
       "      <td>248</td>\n",
       "      <td>University of South Carolina-Columbia</td>\n",
       "      <td>United States</td>\n",
       "      <td>32291</td>\n",
       "      <td>16.2</td>\n",
       "      <td>5%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>33.2</td>\n",
       "      <td>25.5</td>\n",
       "      <td>63.7</td>\n",
       "      <td>36.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>40.9</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>115</td>\n",
       "      <td>478</td>\n",
       "      <td>262</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>United States</td>\n",
       "      <td>44128</td>\n",
       "      <td>25.7</td>\n",
       "      <td>9%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>33.6</td>\n",
       "      <td>25.9</td>\n",
       "      <td>58.0</td>\n",
       "      <td>36.8</td>\n",
       "      <td>42.5</td>\n",
       "      <td>39.4</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>122</td>\n",
       "      <td>507</td>\n",
       "      <td>271</td>\n",
       "      <td>Florida International University</td>\n",
       "      <td>United States</td>\n",
       "      <td>34203</td>\n",
       "      <td>23.8</td>\n",
       "      <td>8%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>30.4</td>\n",
       "      <td>22.6</td>\n",
       "      <td>62.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>39.7</td>\n",
       "      <td>38.5</td>\n",
       "      <td>35.3�38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>127</td>\n",
       "      <td>558</td>\n",
       "      <td>290</td>\n",
       "      <td>San Diego State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>30799</td>\n",
       "      <td>30.5</td>\n",
       "      <td>8%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>23.7</td>\n",
       "      <td>24.4</td>\n",
       "      <td>62.0</td>\n",
       "      <td>35.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>36.5</td>\n",
       "      <td>35.3�38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>135</td>\n",
       "      <td>609</td>\n",
       "      <td>304</td>\n",
       "      <td>University of Central Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>56228</td>\n",
       "      <td>35.3</td>\n",
       "      <td>4%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>26.5</td>\n",
       "      <td>28.7</td>\n",
       "      <td>49.7</td>\n",
       "      <td>42.6</td>\n",
       "      <td>32.9</td>\n",
       "      <td>35.0</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>140</td>\n",
       "      <td>638</td>\n",
       "      <td>314</td>\n",
       "      <td>Texas Tech University</td>\n",
       "      <td>United States</td>\n",
       "      <td>33015</td>\n",
       "      <td>20.6</td>\n",
       "      <td>9%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>30.8</td>\n",
       "      <td>20.9</td>\n",
       "      <td>46.5</td>\n",
       "      <td>36.2</td>\n",
       "      <td>48.4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>168</td>\n",
       "      <td>1015</td>\n",
       "      <td>429</td>\n",
       "      <td>California State University, Long Beach</td>\n",
       "      <td>United States</td>\n",
       "      <td>30595</td>\n",
       "      <td>19.7</td>\n",
       "      <td>4%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>23.1</td>\n",
       "      <td>10.1</td>\n",
       "      <td>27.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>37.3</td>\n",
       "      <td>21.8</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>170</td>\n",
       "      <td>1052</td>\n",
       "      <td>438</td>\n",
       "      <td>Texas State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>31893</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>17.4</td>\n",
       "      <td>14.3</td>\n",
       "      <td>27.3</td>\n",
       "      <td>36.4</td>\n",
       "      <td>30.4</td>\n",
       "      <td>20.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    level_0  index  Score_Rank  \\\n",
       "0         9     12          13   \n",
       "1        11     16          16   \n",
       "2        14     20          20   \n",
       "3        16     25          25   \n",
       "4        18     28          27   \n",
       "5        19     30          29   \n",
       "6        21     39          34   \n",
       "7        22     47          41   \n",
       "8        23     50          44   \n",
       "9        26     53          47   \n",
       "10       27     54          48   \n",
       "11       30     62          53   \n",
       "12       31     69          59   \n",
       "13       32     77          65   \n",
       "14       33     78          66   \n",
       "15       35     83          68   \n",
       "16       36     87          71   \n",
       "17       37     90          73   \n",
       "18       39     95          77   \n",
       "19       41    103          81   \n",
       "20       47    123          94   \n",
       "21       48    133         101   \n",
       "22       50    154         111   \n",
       "23       52    169         117   \n",
       "24       56    174         121   \n",
       "25       57    177         122   \n",
       "26       60    209         137   \n",
       "27       61    217         144   \n",
       "28       62    220         146   \n",
       "29       68    243         157   \n",
       "30       76    277         175   \n",
       "31       83    310         194   \n",
       "32       84    312         195   \n",
       "33       99    393         230   \n",
       "34      102    400         233   \n",
       "35      103    403         234   \n",
       "36      110    431         246   \n",
       "37      113    440         248   \n",
       "38      115    478         262   \n",
       "39      122    507         271   \n",
       "40      127    558         290   \n",
       "41      135    609         304   \n",
       "42      140    638         314   \n",
       "43      168   1015         429   \n",
       "44      170   1052         438   \n",
       "\n",
       "                                           University        Country  \\\n",
       "0                  University of California, Berkeley  United States   \n",
       "1               University of California, Los Angeles  United States   \n",
       "2                    University of Michigan-Ann Arbor  United States   \n",
       "3                            University of Washington  United States   \n",
       "4                                 New York University  United States   \n",
       "5                 University of California, San Diego  United States   \n",
       "6                       University of Texas at Austin  United States   \n",
       "7          University of Illinois at Urbana-Champaign  United States   \n",
       "8                     University of Wisconsin-Madison  United States   \n",
       "9         University of North Carolina at Chapel Hill  United States   \n",
       "10                    University of California, Davis  United States   \n",
       "11                  University of Southern California  United States   \n",
       "12                Ohio State University (Main campus)  United States   \n",
       "13                           Penn State (Main campus)  United States   \n",
       "14                            University of Minnesota  United States   \n",
       "15                          Michigan State University  United States   \n",
       "16                   Purdue University West Lafayette  United States   \n",
       "17               University of Maryland, College Park  United States   \n",
       "18                   University of California, Irvine  United States   \n",
       "19                              University of Arizona  United States   \n",
       "20                     University of Colorado Boulder  United States   \n",
       "21                                 Indiana University  United States   \n",
       "22                   Arizona State University (Tempe)  United States   \n",
       "23        Rutgers, the State University of New Jersey  United States   \n",
       "24                              University of Florida  United States   \n",
       "25                               Texas A&M University  United States   \n",
       "26                        University of Massachusetts  United States   \n",
       "27                University of South Florida (Tampa)  United States   \n",
       "28                                 University of Utah  United States   \n",
       "29  Virginia Polytechnic Institute and State Unive...  United States   \n",
       "30                           Florida State University  United States   \n",
       "31                    North Carolina State University  United States   \n",
       "32                                  Temple University  United States   \n",
       "33                          University of Connecticut  United States   \n",
       "34                              Iowa State University  United States   \n",
       "35                              University of Georgia  United States   \n",
       "36                              University of Alabama  United States   \n",
       "37              University of South Carolina-Columbia  United States   \n",
       "38                              University of Houston  United States   \n",
       "39                   Florida International University  United States   \n",
       "40                         San Diego State University  United States   \n",
       "41                      University of Central Florida  United States   \n",
       "42                              Texas Tech University  United States   \n",
       "43            California State University, Long Beach  United States   \n",
       "44                             Texas State University  United States   \n",
       "\n",
       "    Number_students  Numb_students_per_Staff International_Students  \\\n",
       "0             41081                     13.7                    17%   \n",
       "1             41066                      9.4                    17%   \n",
       "2             42982                      8.3                    17%   \n",
       "3             45692                     11.1                    16%   \n",
       "4             44466                      8.9                    33%   \n",
       "5             33579                     13.0                    23%   \n",
       "6             49165                     17.2                    10%   \n",
       "7             44916                     17.9                    24%   \n",
       "8             39154                     10.0                    13%   \n",
       "9             35419                      9.4                     8%   \n",
       "10            39164                     12.0                    14%   \n",
       "11            36929                     11.7                    25%   \n",
       "12            54372                     12.5                    13%   \n",
       "13            46204                     15.3                    16%   \n",
       "14            61120                     12.4                    11%   \n",
       "15            44789                     16.5                    16%   \n",
       "16            40451                     15.7                    23%   \n",
       "17            33108                     16.6                    11%   \n",
       "18            32706                     16.5                    26%   \n",
       "19            39124                     18.4                    10%   \n",
       "20            33186                     16.3                    11%   \n",
       "21            66872                     13.6                    15%   \n",
       "22            46683                     21.1                    21%   \n",
       "23            44801                     11.2                    17%   \n",
       "24            46642                     16.8                    10%   \n",
       "25            60818                     24.8                     8%   \n",
       "26            61204                     13.0                    15%   \n",
       "27            33885                     18.9                    14%   \n",
       "28            30365                     14.2                     8%   \n",
       "29            32838                     18.3                    14%   \n",
       "30            38520                     24.1                     7%   \n",
       "31            30231                     12.5                    15%   \n",
       "32            35814                     13.0                     9%   \n",
       "33            32446                     15.2                     9%   \n",
       "34            32469                     18.8                    12%   \n",
       "35            35164                     16.3                     7%   \n",
       "36            35120                     22.5                     4%   \n",
       "37            32291                     16.2                     5%   \n",
       "38            44128                     25.7                     9%   \n",
       "39            34203                     23.8                     8%   \n",
       "40            30799                     30.5                     8%   \n",
       "41            56228                     35.3                     4%   \n",
       "42            33015                     20.6                     9%   \n",
       "43            30595                     19.7                     4%   \n",
       "44            31893                     19.1                     1%   \n",
       "\n",
       "   Percentage_Female Percentage_Male  Teaching  Research  Citations  \\\n",
       "0                50%             50%      83.0      90.6       99.2   \n",
       "1                54%             46%      83.1      88.6       97.3   \n",
       "2                49%             51%      79.4      86.1       94.9   \n",
       "3                53%             47%      72.2      82.2       98.6   \n",
       "4                57%             43%      76.8      77.5       96.5   \n",
       "5                46%             54%      62.6      78.9       97.7   \n",
       "6                52%             48%      68.2      76.2       93.2   \n",
       "7                47%             53%      63.2      78.0       84.4   \n",
       "8                 0%              0%      68.8      70.3       85.3   \n",
       "9                57%             43%      59.7      63.2       96.9   \n",
       "10               58%             42%      62.4      66.9       83.2   \n",
       "11               53%             47%      54.7      59.3       93.1   \n",
       "12               50%             50%      57.5      56.1       87.3   \n",
       "13               46%             54%      55.2      67.1       75.7   \n",
       "14               52%             48%      55.2      59.3       82.7   \n",
       "15               51%             49%      56.6      57.4       80.0   \n",
       "16               43%             57%      57.5      66.4       63.0   \n",
       "17               48%             52%      46.9      59.1       89.6   \n",
       "18               52%             48%      43.3      46.5       94.9   \n",
       "19               52%             48%      52.6      53.7       85.3   \n",
       "20               44%             56%      44.8      45.6       93.1   \n",
       "21               52%             48%      50.8      49.7       76.7   \n",
       "22               43%             57%      39.3      50.7       81.6   \n",
       "23               52%             48%      47.8      48.5       73.9   \n",
       "24               55%             45%      54.0      53.8       61.9   \n",
       "25               47%             53%      49.3      54.8       62.8   \n",
       "26               48%             52%      38.5      31.1       87.0   \n",
       "27                0%              0%      30.5      34.2       87.3   \n",
       "28               47%             53%      39.0      34.7       86.4   \n",
       "29               43%             57%      37.5      42.3       70.9   \n",
       "30               56%             44%      38.0      40.1       69.2   \n",
       "31               45%             55%      36.7      35.3       64.7   \n",
       "32               53%             47%      39.3      23.5       79.3   \n",
       "33               53%             47%      36.5      29.7       60.6   \n",
       "34               44%             56%      29.5      33.0       60.5   \n",
       "35               57%             43%      34.9      35.8       55.8   \n",
       "36               56%             44%      26.9      22.4       77.4   \n",
       "37               55%             45%      33.2      25.5       63.7   \n",
       "38               50%             50%      33.6      25.9       58.0   \n",
       "39               57%             43%      30.4      22.6       62.3   \n",
       "40               55%             45%      23.7      24.4       62.0   \n",
       "41               56%             44%      26.5      28.7       49.7   \n",
       "42               46%             54%      30.8      20.9       46.5   \n",
       "43               58%             42%      23.1      10.1       27.3   \n",
       "44               58%             42%      17.4      14.3       27.3   \n",
       "\n",
       "    Industry_Income  International_Outlook  Score_Result Overall_Ranking  \n",
       "0              46.1                   70.4          88.3           88.30  \n",
       "1              51.3                   64.1          86.8           86.80  \n",
       "2              47.7                   59.2          83.8           83.80  \n",
       "3              47.5                   60.4          81.6           81.60  \n",
       "4              38.7                   65.4          81.1           81.10  \n",
       "5              90.3                   63.7          78.8           78.80  \n",
       "6              46.6                   39.1          75.4           75.40  \n",
       "7              47.9                   54.3          73.0           72.90  \n",
       "8              46.3                   47.4          72.0           72.00  \n",
       "9              43.9                   38.0          69.9           69.90  \n",
       "10             51.4                   62.4          69.7           69.70  \n",
       "11             39.7                   66.2          68.1           68.10  \n",
       "12             53.3                   59.5          66.1           66.10  \n",
       "13             52.1                   47.4          64.3           64.20  \n",
       "14             78.2                   40.2          64.1           64.10  \n",
       "15             37.8                   63.3          63.9           63.90  \n",
       "16             64.3                   72.0          63.1           63.10  \n",
       "17             39.2                   41.2          62.8           62.70  \n",
       "18             58.9                   71.9          62.3           62.30  \n",
       "19             52.7                   40.2          61.8           61.80  \n",
       "20             41.7                   47.3          59.6           59.60  \n",
       "21             49.8                   53.5          58.4           58.40  \n",
       "22             38.5                   61.8          57.1           57.10  \n",
       "23             41.1                   51.5          56.0           56.00  \n",
       "24             57.9                   40.0          55.4           55.40  \n",
       "25             45.3                   54.3          55.3           55.30  \n",
       "26             49.9                   61.7          52.9       50.1�53.7  \n",
       "27             89.0                   54.7          51.9       50.1�53.7  \n",
       "28             48.3                   33.0          51.7       50.1�53.7  \n",
       "29             47.5                   54.0          50.4       50.1�53.7  \n",
       "30             39.4                   43.5          48.4       46.9�50.0  \n",
       "31             43.2                   57.8          46.4       44.5�46.8  \n",
       "32             34.4                   37.7          46.3       44.5�46.8  \n",
       "33             37.9                   49.0          42.7       42.4�44.4  \n",
       "34             49.6                   56.7          42.4       42.4�44.4  \n",
       "35             37.2                   46.0          42.3       38.8�42.3  \n",
       "36             35.3                   28.9          41.1       38.8�42.3  \n",
       "37             36.2                   43.2          40.9       38.8�42.3  \n",
       "38             36.8                   42.5          39.4       38.8�42.3  \n",
       "39             38.0                   39.7          38.5       35.3�38.7  \n",
       "40             35.1                   33.9          36.5       35.3�38.7  \n",
       "41             42.6                   32.9          35.0       28.3�35.2  \n",
       "42             36.2                   48.4          34.0       28.3�35.2  \n",
       "43             35.9                   37.3          21.8       10.7�22.1  \n",
       "44             36.4                   30.4          20.9       10.7�22.1  "
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Step 1: Reset the index of df_US_large (if needed, see Puzzle 1.2 to refresh how you can do this):\n",
    "df_US_large=df_US_large.reset_index()\n",
    "df_US_large"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>level_0</th>\n",
       "      <th>index</th>\n",
       "      <th>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "      <th>US_Large_Rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>University of California, Berkeley</td>\n",
       "      <td>United States</td>\n",
       "      <td>41081</td>\n",
       "      <td>13.7</td>\n",
       "      <td>17%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>83.0</td>\n",
       "      <td>90.6</td>\n",
       "      <td>99.2</td>\n",
       "      <td>46.1</td>\n",
       "      <td>70.4</td>\n",
       "      <td>88.3</td>\n",
       "      <td>88.30</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>University of California, Los Angeles</td>\n",
       "      <td>United States</td>\n",
       "      <td>41066</td>\n",
       "      <td>9.4</td>\n",
       "      <td>17%</td>\n",
       "      <td>54%</td>\n",
       "      <td>46%</td>\n",
       "      <td>83.1</td>\n",
       "      <td>88.6</td>\n",
       "      <td>97.3</td>\n",
       "      <td>51.3</td>\n",
       "      <td>64.1</td>\n",
       "      <td>86.8</td>\n",
       "      <td>86.80</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>University of Michigan-Ann Arbor</td>\n",
       "      <td>United States</td>\n",
       "      <td>42982</td>\n",
       "      <td>8.3</td>\n",
       "      <td>17%</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>79.4</td>\n",
       "      <td>86.1</td>\n",
       "      <td>94.9</td>\n",
       "      <td>47.7</td>\n",
       "      <td>59.2</td>\n",
       "      <td>83.8</td>\n",
       "      <td>83.80</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>University of Washington</td>\n",
       "      <td>United States</td>\n",
       "      <td>45692</td>\n",
       "      <td>11.1</td>\n",
       "      <td>16%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>72.2</td>\n",
       "      <td>82.2</td>\n",
       "      <td>98.6</td>\n",
       "      <td>47.5</td>\n",
       "      <td>60.4</td>\n",
       "      <td>81.6</td>\n",
       "      <td>81.60</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18</td>\n",
       "      <td>28</td>\n",
       "      <td>27</td>\n",
       "      <td>New York University</td>\n",
       "      <td>United States</td>\n",
       "      <td>44466</td>\n",
       "      <td>8.9</td>\n",
       "      <td>33%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>76.8</td>\n",
       "      <td>77.5</td>\n",
       "      <td>96.5</td>\n",
       "      <td>38.7</td>\n",
       "      <td>65.4</td>\n",
       "      <td>81.1</td>\n",
       "      <td>81.10</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>29</td>\n",
       "      <td>University of California, San Diego</td>\n",
       "      <td>United States</td>\n",
       "      <td>33579</td>\n",
       "      <td>13.0</td>\n",
       "      <td>23%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>62.6</td>\n",
       "      <td>78.9</td>\n",
       "      <td>97.7</td>\n",
       "      <td>90.3</td>\n",
       "      <td>63.7</td>\n",
       "      <td>78.8</td>\n",
       "      <td>78.80</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>21</td>\n",
       "      <td>39</td>\n",
       "      <td>34</td>\n",
       "      <td>University of Texas at Austin</td>\n",
       "      <td>United States</td>\n",
       "      <td>49165</td>\n",
       "      <td>17.2</td>\n",
       "      <td>10%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>68.2</td>\n",
       "      <td>76.2</td>\n",
       "      <td>93.2</td>\n",
       "      <td>46.6</td>\n",
       "      <td>39.1</td>\n",
       "      <td>75.4</td>\n",
       "      <td>75.40</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22</td>\n",
       "      <td>47</td>\n",
       "      <td>41</td>\n",
       "      <td>University of Illinois at Urbana-Champaign</td>\n",
       "      <td>United States</td>\n",
       "      <td>44916</td>\n",
       "      <td>17.9</td>\n",
       "      <td>24%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>63.2</td>\n",
       "      <td>78.0</td>\n",
       "      <td>84.4</td>\n",
       "      <td>47.9</td>\n",
       "      <td>54.3</td>\n",
       "      <td>73.0</td>\n",
       "      <td>72.90</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>23</td>\n",
       "      <td>50</td>\n",
       "      <td>44</td>\n",
       "      <td>University of Wisconsin-Madison</td>\n",
       "      <td>United States</td>\n",
       "      <td>39154</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>68.8</td>\n",
       "      <td>70.3</td>\n",
       "      <td>85.3</td>\n",
       "      <td>46.3</td>\n",
       "      <td>47.4</td>\n",
       "      <td>72.0</td>\n",
       "      <td>72.00</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>26</td>\n",
       "      <td>53</td>\n",
       "      <td>47</td>\n",
       "      <td>University of North Carolina at Chapel Hill</td>\n",
       "      <td>United States</td>\n",
       "      <td>35419</td>\n",
       "      <td>9.4</td>\n",
       "      <td>8%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>59.7</td>\n",
       "      <td>63.2</td>\n",
       "      <td>96.9</td>\n",
       "      <td>43.9</td>\n",
       "      <td>38.0</td>\n",
       "      <td>69.9</td>\n",
       "      <td>69.90</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>27</td>\n",
       "      <td>54</td>\n",
       "      <td>48</td>\n",
       "      <td>University of California, Davis</td>\n",
       "      <td>United States</td>\n",
       "      <td>39164</td>\n",
       "      <td>12.0</td>\n",
       "      <td>14%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>62.4</td>\n",
       "      <td>66.9</td>\n",
       "      <td>83.2</td>\n",
       "      <td>51.4</td>\n",
       "      <td>62.4</td>\n",
       "      <td>69.7</td>\n",
       "      <td>69.70</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>30</td>\n",
       "      <td>62</td>\n",
       "      <td>53</td>\n",
       "      <td>University of Southern California</td>\n",
       "      <td>United States</td>\n",
       "      <td>36929</td>\n",
       "      <td>11.7</td>\n",
       "      <td>25%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>54.7</td>\n",
       "      <td>59.3</td>\n",
       "      <td>93.1</td>\n",
       "      <td>39.7</td>\n",
       "      <td>66.2</td>\n",
       "      <td>68.1</td>\n",
       "      <td>68.10</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>31</td>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>Ohio State University (Main campus)</td>\n",
       "      <td>United States</td>\n",
       "      <td>54372</td>\n",
       "      <td>12.5</td>\n",
       "      <td>13%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>57.5</td>\n",
       "      <td>56.1</td>\n",
       "      <td>87.3</td>\n",
       "      <td>53.3</td>\n",
       "      <td>59.5</td>\n",
       "      <td>66.1</td>\n",
       "      <td>66.10</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>32</td>\n",
       "      <td>77</td>\n",
       "      <td>65</td>\n",
       "      <td>Penn State (Main campus)</td>\n",
       "      <td>United States</td>\n",
       "      <td>46204</td>\n",
       "      <td>15.3</td>\n",
       "      <td>16%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>55.2</td>\n",
       "      <td>67.1</td>\n",
       "      <td>75.7</td>\n",
       "      <td>52.1</td>\n",
       "      <td>47.4</td>\n",
       "      <td>64.3</td>\n",
       "      <td>64.20</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>33</td>\n",
       "      <td>78</td>\n",
       "      <td>66</td>\n",
       "      <td>University of Minnesota</td>\n",
       "      <td>United States</td>\n",
       "      <td>61120</td>\n",
       "      <td>12.4</td>\n",
       "      <td>11%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>55.2</td>\n",
       "      <td>59.3</td>\n",
       "      <td>82.7</td>\n",
       "      <td>78.2</td>\n",
       "      <td>40.2</td>\n",
       "      <td>64.1</td>\n",
       "      <td>64.10</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>35</td>\n",
       "      <td>83</td>\n",
       "      <td>68</td>\n",
       "      <td>Michigan State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>44789</td>\n",
       "      <td>16.5</td>\n",
       "      <td>16%</td>\n",
       "      <td>51%</td>\n",
       "      <td>49%</td>\n",
       "      <td>56.6</td>\n",
       "      <td>57.4</td>\n",
       "      <td>80.0</td>\n",
       "      <td>37.8</td>\n",
       "      <td>63.3</td>\n",
       "      <td>63.9</td>\n",
       "      <td>63.90</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>36</td>\n",
       "      <td>87</td>\n",
       "      <td>71</td>\n",
       "      <td>Purdue University West Lafayette</td>\n",
       "      <td>United States</td>\n",
       "      <td>40451</td>\n",
       "      <td>15.7</td>\n",
       "      <td>23%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>57.5</td>\n",
       "      <td>66.4</td>\n",
       "      <td>63.0</td>\n",
       "      <td>64.3</td>\n",
       "      <td>72.0</td>\n",
       "      <td>63.1</td>\n",
       "      <td>63.10</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>37</td>\n",
       "      <td>90</td>\n",
       "      <td>73</td>\n",
       "      <td>University of Maryland, College Park</td>\n",
       "      <td>United States</td>\n",
       "      <td>33108</td>\n",
       "      <td>16.6</td>\n",
       "      <td>11%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52%</td>\n",
       "      <td>46.9</td>\n",
       "      <td>59.1</td>\n",
       "      <td>89.6</td>\n",
       "      <td>39.2</td>\n",
       "      <td>41.2</td>\n",
       "      <td>62.8</td>\n",
       "      <td>62.70</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>39</td>\n",
       "      <td>95</td>\n",
       "      <td>77</td>\n",
       "      <td>University of California, Irvine</td>\n",
       "      <td>United States</td>\n",
       "      <td>32706</td>\n",
       "      <td>16.5</td>\n",
       "      <td>26%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>43.3</td>\n",
       "      <td>46.5</td>\n",
       "      <td>94.9</td>\n",
       "      <td>58.9</td>\n",
       "      <td>71.9</td>\n",
       "      <td>62.3</td>\n",
       "      <td>62.30</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>41</td>\n",
       "      <td>103</td>\n",
       "      <td>81</td>\n",
       "      <td>University of Arizona</td>\n",
       "      <td>United States</td>\n",
       "      <td>39124</td>\n",
       "      <td>18.4</td>\n",
       "      <td>10%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52.6</td>\n",
       "      <td>53.7</td>\n",
       "      <td>85.3</td>\n",
       "      <td>52.7</td>\n",
       "      <td>40.2</td>\n",
       "      <td>61.8</td>\n",
       "      <td>61.80</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>47</td>\n",
       "      <td>123</td>\n",
       "      <td>94</td>\n",
       "      <td>University of Colorado Boulder</td>\n",
       "      <td>United States</td>\n",
       "      <td>33186</td>\n",
       "      <td>16.3</td>\n",
       "      <td>11%</td>\n",
       "      <td>44%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44.8</td>\n",
       "      <td>45.6</td>\n",
       "      <td>93.1</td>\n",
       "      <td>41.7</td>\n",
       "      <td>47.3</td>\n",
       "      <td>59.6</td>\n",
       "      <td>59.60</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>48</td>\n",
       "      <td>133</td>\n",
       "      <td>101</td>\n",
       "      <td>Indiana University</td>\n",
       "      <td>United States</td>\n",
       "      <td>66872</td>\n",
       "      <td>13.6</td>\n",
       "      <td>15%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>50.8</td>\n",
       "      <td>49.7</td>\n",
       "      <td>76.7</td>\n",
       "      <td>49.8</td>\n",
       "      <td>53.5</td>\n",
       "      <td>58.4</td>\n",
       "      <td>58.40</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>50</td>\n",
       "      <td>154</td>\n",
       "      <td>111</td>\n",
       "      <td>Arizona State University (Tempe)</td>\n",
       "      <td>United States</td>\n",
       "      <td>46683</td>\n",
       "      <td>21.1</td>\n",
       "      <td>21%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>39.3</td>\n",
       "      <td>50.7</td>\n",
       "      <td>81.6</td>\n",
       "      <td>38.5</td>\n",
       "      <td>61.8</td>\n",
       "      <td>57.1</td>\n",
       "      <td>57.10</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>52</td>\n",
       "      <td>169</td>\n",
       "      <td>117</td>\n",
       "      <td>Rutgers, the State University of New Jersey</td>\n",
       "      <td>United States</td>\n",
       "      <td>44801</td>\n",
       "      <td>11.2</td>\n",
       "      <td>17%</td>\n",
       "      <td>52%</td>\n",
       "      <td>48%</td>\n",
       "      <td>47.8</td>\n",
       "      <td>48.5</td>\n",
       "      <td>73.9</td>\n",
       "      <td>41.1</td>\n",
       "      <td>51.5</td>\n",
       "      <td>56.0</td>\n",
       "      <td>56.00</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>56</td>\n",
       "      <td>174</td>\n",
       "      <td>121</td>\n",
       "      <td>University of Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>46642</td>\n",
       "      <td>16.8</td>\n",
       "      <td>10%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>54.0</td>\n",
       "      <td>53.8</td>\n",
       "      <td>61.9</td>\n",
       "      <td>57.9</td>\n",
       "      <td>40.0</td>\n",
       "      <td>55.4</td>\n",
       "      <td>55.40</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>57</td>\n",
       "      <td>177</td>\n",
       "      <td>122</td>\n",
       "      <td>Texas A&amp;M University</td>\n",
       "      <td>United States</td>\n",
       "      <td>60818</td>\n",
       "      <td>24.8</td>\n",
       "      <td>8%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>49.3</td>\n",
       "      <td>54.8</td>\n",
       "      <td>62.8</td>\n",
       "      <td>45.3</td>\n",
       "      <td>54.3</td>\n",
       "      <td>55.3</td>\n",
       "      <td>55.30</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>60</td>\n",
       "      <td>209</td>\n",
       "      <td>137</td>\n",
       "      <td>University of Massachusetts</td>\n",
       "      <td>United States</td>\n",
       "      <td>61204</td>\n",
       "      <td>13.0</td>\n",
       "      <td>15%</td>\n",
       "      <td>48%</td>\n",
       "      <td>52%</td>\n",
       "      <td>38.5</td>\n",
       "      <td>31.1</td>\n",
       "      <td>87.0</td>\n",
       "      <td>49.9</td>\n",
       "      <td>61.7</td>\n",
       "      <td>52.9</td>\n",
       "      <td>50.1�53.7</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>61</td>\n",
       "      <td>217</td>\n",
       "      <td>144</td>\n",
       "      <td>University of South Florida (Tampa)</td>\n",
       "      <td>United States</td>\n",
       "      <td>33885</td>\n",
       "      <td>18.9</td>\n",
       "      <td>14%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>30.5</td>\n",
       "      <td>34.2</td>\n",
       "      <td>87.3</td>\n",
       "      <td>89.0</td>\n",
       "      <td>54.7</td>\n",
       "      <td>51.9</td>\n",
       "      <td>50.1�53.7</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>62</td>\n",
       "      <td>220</td>\n",
       "      <td>146</td>\n",
       "      <td>University of Utah</td>\n",
       "      <td>United States</td>\n",
       "      <td>30365</td>\n",
       "      <td>14.2</td>\n",
       "      <td>8%</td>\n",
       "      <td>47%</td>\n",
       "      <td>53%</td>\n",
       "      <td>39.0</td>\n",
       "      <td>34.7</td>\n",
       "      <td>86.4</td>\n",
       "      <td>48.3</td>\n",
       "      <td>33.0</td>\n",
       "      <td>51.7</td>\n",
       "      <td>50.1�53.7</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>68</td>\n",
       "      <td>243</td>\n",
       "      <td>157</td>\n",
       "      <td>Virginia Polytechnic Institute and State Unive...</td>\n",
       "      <td>United States</td>\n",
       "      <td>32838</td>\n",
       "      <td>18.3</td>\n",
       "      <td>14%</td>\n",
       "      <td>43%</td>\n",
       "      <td>57%</td>\n",
       "      <td>37.5</td>\n",
       "      <td>42.3</td>\n",
       "      <td>70.9</td>\n",
       "      <td>47.5</td>\n",
       "      <td>54.0</td>\n",
       "      <td>50.4</td>\n",
       "      <td>50.1�53.7</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>76</td>\n",
       "      <td>277</td>\n",
       "      <td>175</td>\n",
       "      <td>Florida State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>38520</td>\n",
       "      <td>24.1</td>\n",
       "      <td>7%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>38.0</td>\n",
       "      <td>40.1</td>\n",
       "      <td>69.2</td>\n",
       "      <td>39.4</td>\n",
       "      <td>43.5</td>\n",
       "      <td>48.4</td>\n",
       "      <td>46.9�50.0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>83</td>\n",
       "      <td>310</td>\n",
       "      <td>194</td>\n",
       "      <td>North Carolina State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>30231</td>\n",
       "      <td>12.5</td>\n",
       "      <td>15%</td>\n",
       "      <td>45%</td>\n",
       "      <td>55%</td>\n",
       "      <td>36.7</td>\n",
       "      <td>35.3</td>\n",
       "      <td>64.7</td>\n",
       "      <td>43.2</td>\n",
       "      <td>57.8</td>\n",
       "      <td>46.4</td>\n",
       "      <td>44.5�46.8</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>84</td>\n",
       "      <td>312</td>\n",
       "      <td>195</td>\n",
       "      <td>Temple University</td>\n",
       "      <td>United States</td>\n",
       "      <td>35814</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>39.3</td>\n",
       "      <td>23.5</td>\n",
       "      <td>79.3</td>\n",
       "      <td>34.4</td>\n",
       "      <td>37.7</td>\n",
       "      <td>46.3</td>\n",
       "      <td>44.5�46.8</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>99</td>\n",
       "      <td>393</td>\n",
       "      <td>230</td>\n",
       "      <td>University of Connecticut</td>\n",
       "      <td>United States</td>\n",
       "      <td>32446</td>\n",
       "      <td>15.2</td>\n",
       "      <td>9%</td>\n",
       "      <td>53%</td>\n",
       "      <td>47%</td>\n",
       "      <td>36.5</td>\n",
       "      <td>29.7</td>\n",
       "      <td>60.6</td>\n",
       "      <td>37.9</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.7</td>\n",
       "      <td>42.4�44.4</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>102</td>\n",
       "      <td>400</td>\n",
       "      <td>233</td>\n",
       "      <td>Iowa State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>32469</td>\n",
       "      <td>18.8</td>\n",
       "      <td>12%</td>\n",
       "      <td>44%</td>\n",
       "      <td>56%</td>\n",
       "      <td>29.5</td>\n",
       "      <td>33.0</td>\n",
       "      <td>60.5</td>\n",
       "      <td>49.6</td>\n",
       "      <td>56.7</td>\n",
       "      <td>42.4</td>\n",
       "      <td>42.4�44.4</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>103</td>\n",
       "      <td>403</td>\n",
       "      <td>234</td>\n",
       "      <td>University of Georgia</td>\n",
       "      <td>United States</td>\n",
       "      <td>35164</td>\n",
       "      <td>16.3</td>\n",
       "      <td>7%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>34.9</td>\n",
       "      <td>35.8</td>\n",
       "      <td>55.8</td>\n",
       "      <td>37.2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>42.3</td>\n",
       "      <td>38.8�42.3</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>110</td>\n",
       "      <td>431</td>\n",
       "      <td>246</td>\n",
       "      <td>University of Alabama</td>\n",
       "      <td>United States</td>\n",
       "      <td>35120</td>\n",
       "      <td>22.5</td>\n",
       "      <td>4%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>26.9</td>\n",
       "      <td>22.4</td>\n",
       "      <td>77.4</td>\n",
       "      <td>35.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>41.1</td>\n",
       "      <td>38.8�42.3</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>113</td>\n",
       "      <td>440</td>\n",
       "      <td>248</td>\n",
       "      <td>University of South Carolina-Columbia</td>\n",
       "      <td>United States</td>\n",
       "      <td>32291</td>\n",
       "      <td>16.2</td>\n",
       "      <td>5%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>33.2</td>\n",
       "      <td>25.5</td>\n",
       "      <td>63.7</td>\n",
       "      <td>36.2</td>\n",
       "      <td>43.2</td>\n",
       "      <td>40.9</td>\n",
       "      <td>38.8�42.3</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>115</td>\n",
       "      <td>478</td>\n",
       "      <td>262</td>\n",
       "      <td>University of Houston</td>\n",
       "      <td>United States</td>\n",
       "      <td>44128</td>\n",
       "      <td>25.7</td>\n",
       "      <td>9%</td>\n",
       "      <td>50%</td>\n",
       "      <td>50%</td>\n",
       "      <td>33.6</td>\n",
       "      <td>25.9</td>\n",
       "      <td>58.0</td>\n",
       "      <td>36.8</td>\n",
       "      <td>42.5</td>\n",
       "      <td>39.4</td>\n",
       "      <td>38.8�42.3</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>122</td>\n",
       "      <td>507</td>\n",
       "      <td>271</td>\n",
       "      <td>Florida International University</td>\n",
       "      <td>United States</td>\n",
       "      <td>34203</td>\n",
       "      <td>23.8</td>\n",
       "      <td>8%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>30.4</td>\n",
       "      <td>22.6</td>\n",
       "      <td>62.3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>39.7</td>\n",
       "      <td>38.5</td>\n",
       "      <td>35.3�38.7</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>127</td>\n",
       "      <td>558</td>\n",
       "      <td>290</td>\n",
       "      <td>San Diego State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>30799</td>\n",
       "      <td>30.5</td>\n",
       "      <td>8%</td>\n",
       "      <td>55%</td>\n",
       "      <td>45%</td>\n",
       "      <td>23.7</td>\n",
       "      <td>24.4</td>\n",
       "      <td>62.0</td>\n",
       "      <td>35.1</td>\n",
       "      <td>33.9</td>\n",
       "      <td>36.5</td>\n",
       "      <td>35.3�38.7</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>135</td>\n",
       "      <td>609</td>\n",
       "      <td>304</td>\n",
       "      <td>University of Central Florida</td>\n",
       "      <td>United States</td>\n",
       "      <td>56228</td>\n",
       "      <td>35.3</td>\n",
       "      <td>4%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>26.5</td>\n",
       "      <td>28.7</td>\n",
       "      <td>49.7</td>\n",
       "      <td>42.6</td>\n",
       "      <td>32.9</td>\n",
       "      <td>35.0</td>\n",
       "      <td>28.3�35.2</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>140</td>\n",
       "      <td>638</td>\n",
       "      <td>314</td>\n",
       "      <td>Texas Tech University</td>\n",
       "      <td>United States</td>\n",
       "      <td>33015</td>\n",
       "      <td>20.6</td>\n",
       "      <td>9%</td>\n",
       "      <td>46%</td>\n",
       "      <td>54%</td>\n",
       "      <td>30.8</td>\n",
       "      <td>20.9</td>\n",
       "      <td>46.5</td>\n",
       "      <td>36.2</td>\n",
       "      <td>48.4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>28.3�35.2</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>168</td>\n",
       "      <td>1015</td>\n",
       "      <td>429</td>\n",
       "      <td>California State University, Long Beach</td>\n",
       "      <td>United States</td>\n",
       "      <td>30595</td>\n",
       "      <td>19.7</td>\n",
       "      <td>4%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>23.1</td>\n",
       "      <td>10.1</td>\n",
       "      <td>27.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>37.3</td>\n",
       "      <td>21.8</td>\n",
       "      <td>10.7�22.1</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>170</td>\n",
       "      <td>1052</td>\n",
       "      <td>438</td>\n",
       "      <td>Texas State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>31893</td>\n",
       "      <td>19.1</td>\n",
       "      <td>1%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>17.4</td>\n",
       "      <td>14.3</td>\n",
       "      <td>27.3</td>\n",
       "      <td>36.4</td>\n",
       "      <td>30.4</td>\n",
       "      <td>20.9</td>\n",
       "      <td>10.7�22.1</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    level_0  index  Score_Rank  \\\n",
       "0         9     12          13   \n",
       "1        11     16          16   \n",
       "2        14     20          20   \n",
       "3        16     25          25   \n",
       "4        18     28          27   \n",
       "5        19     30          29   \n",
       "6        21     39          34   \n",
       "7        22     47          41   \n",
       "8        23     50          44   \n",
       "9        26     53          47   \n",
       "10       27     54          48   \n",
       "11       30     62          53   \n",
       "12       31     69          59   \n",
       "13       32     77          65   \n",
       "14       33     78          66   \n",
       "15       35     83          68   \n",
       "16       36     87          71   \n",
       "17       37     90          73   \n",
       "18       39     95          77   \n",
       "19       41    103          81   \n",
       "20       47    123          94   \n",
       "21       48    133         101   \n",
       "22       50    154         111   \n",
       "23       52    169         117   \n",
       "24       56    174         121   \n",
       "25       57    177         122   \n",
       "26       60    209         137   \n",
       "27       61    217         144   \n",
       "28       62    220         146   \n",
       "29       68    243         157   \n",
       "30       76    277         175   \n",
       "31       83    310         194   \n",
       "32       84    312         195   \n",
       "33       99    393         230   \n",
       "34      102    400         233   \n",
       "35      103    403         234   \n",
       "36      110    431         246   \n",
       "37      113    440         248   \n",
       "38      115    478         262   \n",
       "39      122    507         271   \n",
       "40      127    558         290   \n",
       "41      135    609         304   \n",
       "42      140    638         314   \n",
       "43      168   1015         429   \n",
       "44      170   1052         438   \n",
       "\n",
       "                                           University        Country  \\\n",
       "0                  University of California, Berkeley  United States   \n",
       "1               University of California, Los Angeles  United States   \n",
       "2                    University of Michigan-Ann Arbor  United States   \n",
       "3                            University of Washington  United States   \n",
       "4                                 New York University  United States   \n",
       "5                 University of California, San Diego  United States   \n",
       "6                       University of Texas at Austin  United States   \n",
       "7          University of Illinois at Urbana-Champaign  United States   \n",
       "8                     University of Wisconsin-Madison  United States   \n",
       "9         University of North Carolina at Chapel Hill  United States   \n",
       "10                    University of California, Davis  United States   \n",
       "11                  University of Southern California  United States   \n",
       "12                Ohio State University (Main campus)  United States   \n",
       "13                           Penn State (Main campus)  United States   \n",
       "14                            University of Minnesota  United States   \n",
       "15                          Michigan State University  United States   \n",
       "16                   Purdue University West Lafayette  United States   \n",
       "17               University of Maryland, College Park  United States   \n",
       "18                   University of California, Irvine  United States   \n",
       "19                              University of Arizona  United States   \n",
       "20                     University of Colorado Boulder  United States   \n",
       "21                                 Indiana University  United States   \n",
       "22                   Arizona State University (Tempe)  United States   \n",
       "23        Rutgers, the State University of New Jersey  United States   \n",
       "24                              University of Florida  United States   \n",
       "25                               Texas A&M University  United States   \n",
       "26                        University of Massachusetts  United States   \n",
       "27                University of South Florida (Tampa)  United States   \n",
       "28                                 University of Utah  United States   \n",
       "29  Virginia Polytechnic Institute and State Unive...  United States   \n",
       "30                           Florida State University  United States   \n",
       "31                    North Carolina State University  United States   \n",
       "32                                  Temple University  United States   \n",
       "33                          University of Connecticut  United States   \n",
       "34                              Iowa State University  United States   \n",
       "35                              University of Georgia  United States   \n",
       "36                              University of Alabama  United States   \n",
       "37              University of South Carolina-Columbia  United States   \n",
       "38                              University of Houston  United States   \n",
       "39                   Florida International University  United States   \n",
       "40                         San Diego State University  United States   \n",
       "41                      University of Central Florida  United States   \n",
       "42                              Texas Tech University  United States   \n",
       "43            California State University, Long Beach  United States   \n",
       "44                             Texas State University  United States   \n",
       "\n",
       "    Number_students  Numb_students_per_Staff International_Students  \\\n",
       "0             41081                     13.7                    17%   \n",
       "1             41066                      9.4                    17%   \n",
       "2             42982                      8.3                    17%   \n",
       "3             45692                     11.1                    16%   \n",
       "4             44466                      8.9                    33%   \n",
       "5             33579                     13.0                    23%   \n",
       "6             49165                     17.2                    10%   \n",
       "7             44916                     17.9                    24%   \n",
       "8             39154                     10.0                    13%   \n",
       "9             35419                      9.4                     8%   \n",
       "10            39164                     12.0                    14%   \n",
       "11            36929                     11.7                    25%   \n",
       "12            54372                     12.5                    13%   \n",
       "13            46204                     15.3                    16%   \n",
       "14            61120                     12.4                    11%   \n",
       "15            44789                     16.5                    16%   \n",
       "16            40451                     15.7                    23%   \n",
       "17            33108                     16.6                    11%   \n",
       "18            32706                     16.5                    26%   \n",
       "19            39124                     18.4                    10%   \n",
       "20            33186                     16.3                    11%   \n",
       "21            66872                     13.6                    15%   \n",
       "22            46683                     21.1                    21%   \n",
       "23            44801                     11.2                    17%   \n",
       "24            46642                     16.8                    10%   \n",
       "25            60818                     24.8                     8%   \n",
       "26            61204                     13.0                    15%   \n",
       "27            33885                     18.9                    14%   \n",
       "28            30365                     14.2                     8%   \n",
       "29            32838                     18.3                    14%   \n",
       "30            38520                     24.1                     7%   \n",
       "31            30231                     12.5                    15%   \n",
       "32            35814                     13.0                     9%   \n",
       "33            32446                     15.2                     9%   \n",
       "34            32469                     18.8                    12%   \n",
       "35            35164                     16.3                     7%   \n",
       "36            35120                     22.5                     4%   \n",
       "37            32291                     16.2                     5%   \n",
       "38            44128                     25.7                     9%   \n",
       "39            34203                     23.8                     8%   \n",
       "40            30799                     30.5                     8%   \n",
       "41            56228                     35.3                     4%   \n",
       "42            33015                     20.6                     9%   \n",
       "43            30595                     19.7                     4%   \n",
       "44            31893                     19.1                     1%   \n",
       "\n",
       "   Percentage_Female Percentage_Male  Teaching  Research  Citations  \\\n",
       "0                50%             50%      83.0      90.6       99.2   \n",
       "1                54%             46%      83.1      88.6       97.3   \n",
       "2                49%             51%      79.4      86.1       94.9   \n",
       "3                53%             47%      72.2      82.2       98.6   \n",
       "4                57%             43%      76.8      77.5       96.5   \n",
       "5                46%             54%      62.6      78.9       97.7   \n",
       "6                52%             48%      68.2      76.2       93.2   \n",
       "7                47%             53%      63.2      78.0       84.4   \n",
       "8                 0%              0%      68.8      70.3       85.3   \n",
       "9                57%             43%      59.7      63.2       96.9   \n",
       "10               58%             42%      62.4      66.9       83.2   \n",
       "11               53%             47%      54.7      59.3       93.1   \n",
       "12               50%             50%      57.5      56.1       87.3   \n",
       "13               46%             54%      55.2      67.1       75.7   \n",
       "14               52%             48%      55.2      59.3       82.7   \n",
       "15               51%             49%      56.6      57.4       80.0   \n",
       "16               43%             57%      57.5      66.4       63.0   \n",
       "17               48%             52%      46.9      59.1       89.6   \n",
       "18               52%             48%      43.3      46.5       94.9   \n",
       "19               52%             48%      52.6      53.7       85.3   \n",
       "20               44%             56%      44.8      45.6       93.1   \n",
       "21               52%             48%      50.8      49.7       76.7   \n",
       "22               43%             57%      39.3      50.7       81.6   \n",
       "23               52%             48%      47.8      48.5       73.9   \n",
       "24               55%             45%      54.0      53.8       61.9   \n",
       "25               47%             53%      49.3      54.8       62.8   \n",
       "26               48%             52%      38.5      31.1       87.0   \n",
       "27                0%              0%      30.5      34.2       87.3   \n",
       "28               47%             53%      39.0      34.7       86.4   \n",
       "29               43%             57%      37.5      42.3       70.9   \n",
       "30               56%             44%      38.0      40.1       69.2   \n",
       "31               45%             55%      36.7      35.3       64.7   \n",
       "32               53%             47%      39.3      23.5       79.3   \n",
       "33               53%             47%      36.5      29.7       60.6   \n",
       "34               44%             56%      29.5      33.0       60.5   \n",
       "35               57%             43%      34.9      35.8       55.8   \n",
       "36               56%             44%      26.9      22.4       77.4   \n",
       "37               55%             45%      33.2      25.5       63.7   \n",
       "38               50%             50%      33.6      25.9       58.0   \n",
       "39               57%             43%      30.4      22.6       62.3   \n",
       "40               55%             45%      23.7      24.4       62.0   \n",
       "41               56%             44%      26.5      28.7       49.7   \n",
       "42               46%             54%      30.8      20.9       46.5   \n",
       "43               58%             42%      23.1      10.1       27.3   \n",
       "44               58%             42%      17.4      14.3       27.3   \n",
       "\n",
       "    Industry_Income  International_Outlook  Score_Result Overall_Ranking  \\\n",
       "0              46.1                   70.4          88.3           88.30   \n",
       "1              51.3                   64.1          86.8           86.80   \n",
       "2              47.7                   59.2          83.8           83.80   \n",
       "3              47.5                   60.4          81.6           81.60   \n",
       "4              38.7                   65.4          81.1           81.10   \n",
       "5              90.3                   63.7          78.8           78.80   \n",
       "6              46.6                   39.1          75.4           75.40   \n",
       "7              47.9                   54.3          73.0           72.90   \n",
       "8              46.3                   47.4          72.0           72.00   \n",
       "9              43.9                   38.0          69.9           69.90   \n",
       "10             51.4                   62.4          69.7           69.70   \n",
       "11             39.7                   66.2          68.1           68.10   \n",
       "12             53.3                   59.5          66.1           66.10   \n",
       "13             52.1                   47.4          64.3           64.20   \n",
       "14             78.2                   40.2          64.1           64.10   \n",
       "15             37.8                   63.3          63.9           63.90   \n",
       "16             64.3                   72.0          63.1           63.10   \n",
       "17             39.2                   41.2          62.8           62.70   \n",
       "18             58.9                   71.9          62.3           62.30   \n",
       "19             52.7                   40.2          61.8           61.80   \n",
       "20             41.7                   47.3          59.6           59.60   \n",
       "21             49.8                   53.5          58.4           58.40   \n",
       "22             38.5                   61.8          57.1           57.10   \n",
       "23             41.1                   51.5          56.0           56.00   \n",
       "24             57.9                   40.0          55.4           55.40   \n",
       "25             45.3                   54.3          55.3           55.30   \n",
       "26             49.9                   61.7          52.9       50.1�53.7   \n",
       "27             89.0                   54.7          51.9       50.1�53.7   \n",
       "28             48.3                   33.0          51.7       50.1�53.7   \n",
       "29             47.5                   54.0          50.4       50.1�53.7   \n",
       "30             39.4                   43.5          48.4       46.9�50.0   \n",
       "31             43.2                   57.8          46.4       44.5�46.8   \n",
       "32             34.4                   37.7          46.3       44.5�46.8   \n",
       "33             37.9                   49.0          42.7       42.4�44.4   \n",
       "34             49.6                   56.7          42.4       42.4�44.4   \n",
       "35             37.2                   46.0          42.3       38.8�42.3   \n",
       "36             35.3                   28.9          41.1       38.8�42.3   \n",
       "37             36.2                   43.2          40.9       38.8�42.3   \n",
       "38             36.8                   42.5          39.4       38.8�42.3   \n",
       "39             38.0                   39.7          38.5       35.3�38.7   \n",
       "40             35.1                   33.9          36.5       35.3�38.7   \n",
       "41             42.6                   32.9          35.0       28.3�35.2   \n",
       "42             36.2                   48.4          34.0       28.3�35.2   \n",
       "43             35.9                   37.3          21.8       10.7�22.1   \n",
       "44             36.4                   30.4          20.9       10.7�22.1   \n",
       "\n",
       "    US_Large_Rank  \n",
       "0               1  \n",
       "1               2  \n",
       "2               3  \n",
       "3               4  \n",
       "4               5  \n",
       "5               6  \n",
       "6               7  \n",
       "7               8  \n",
       "8               9  \n",
       "9              10  \n",
       "10             11  \n",
       "11             12  \n",
       "12             13  \n",
       "13             14  \n",
       "14             15  \n",
       "15             16  \n",
       "16             17  \n",
       "17             18  \n",
       "18             19  \n",
       "19             20  \n",
       "20             21  \n",
       "21             22  \n",
       "22             23  \n",
       "23             24  \n",
       "24             25  \n",
       "25             26  \n",
       "26             27  \n",
       "27             28  \n",
       "28             29  \n",
       "29             30  \n",
       "30             31  \n",
       "31             32  \n",
       "32             33  \n",
       "33             34  \n",
       "34             35  \n",
       "35             36  \n",
       "36             37  \n",
       "37             38  \n",
       "38             39  \n",
       "39             40  \n",
       "40             41  \n",
       "41             42  \n",
       "42             43  \n",
       "43             44  \n",
       "44             45  "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Step 2: Create a new column in df_US_large:\n",
    "df_US_large[\"US_Large_Rank\"]=df_US_large.index+1\n",
    "df_US_large"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "🎉 All Tests Passed! 🎉\n"
     ]
    }
   ],
   "source": [
    "### TEST CASE for Puzzle 2.2: Using the index to store a US_Large_Ranking\n",
    "#\n",
    "# What is this cell?\n",
    "# - This cell contains test cases for the MicroProject. Even though you can modify this\n",
    "#   cell, you should treat it like it's a read-only cell since it will be replaced with\n",
    "#   a fresh version when your code is checked.\n",
    "#\n",
    "# - If this cell runs without any error in the output, you PASSED all test cases!\n",
    "#   We try and make these test cases as useful and complete as possible, but there is\n",
    "#   a chance your code may be incorrect even though you pass the test cases (these\n",
    "#   tests should be seen as a way to give you confidence that code you believe is\n",
    "#   actually correct, not as a robust check to catch all possible errors).\n",
    "#\n",
    "# - If this cell results in any errors, check you previous cells, make changes, and\n",
    "#   RE-RUN your code and then re-run this cell.  Keep repeating this until the cell\n",
    "#   passed with no errors! :)\n",
    "\n",
    "tada = \"\\N{PARTY POPPER}\"\n",
    "\n",
    "assert(\"US_large_rank\" in df_US_large or \"US_Large_Rank\" in df_US_large)\n",
    "assert(df_US_large.loc[0][0] == df_US_large.iloc[0][0])\n",
    "\n",
    "if \"US_large_rank\" in df_US_large:\n",
    "  assert(df_US_large.loc[0][\"US_large_rank\"] == 1)\n",
    "else:\n",
    "  assert(df_US_large.loc[0][\"US_Large_Rank\"] == 1)\n",
    "\n",
    "print(f\"{tada} All Tests Passed! {tada}\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"color: #DD3403;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Puzzle 3: Creating Random Subsets\n",
    "\n",
    "Instead of focusing on just a subset of a DataFrame, researchers often need to look at a random sample of a DataFrame.\n",
    "\n",
    "Returning to the original dataset of nearly 1,400 universities, create one new DataFrame, `df_random_15` , that gives us a random sample of 15 rows in the dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "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>Score_Rank</th>\n",
       "      <th>University</th>\n",
       "      <th>Country</th>\n",
       "      <th>Number_students</th>\n",
       "      <th>Numb_students_per_Staff</th>\n",
       "      <th>International_Students</th>\n",
       "      <th>Percentage_Female</th>\n",
       "      <th>Percentage_Male</th>\n",
       "      <th>Teaching</th>\n",
       "      <th>Research</th>\n",
       "      <th>Citations</th>\n",
       "      <th>Industry_Income</th>\n",
       "      <th>International_Outlook</th>\n",
       "      <th>Score_Result</th>\n",
       "      <th>Overall_Ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>632</th>\n",
       "      <td>312</td>\n",
       "      <td>University of Nantes</td>\n",
       "      <td>France</td>\n",
       "      <td>37078</td>\n",
       "      <td>24.7</td>\n",
       "      <td>11%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>19.8</td>\n",
       "      <td>21.0</td>\n",
       "      <td>57.4</td>\n",
       "      <td>39.5</td>\n",
       "      <td>50.4</td>\n",
       "      <td>34.2</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>152</td>\n",
       "      <td>University of Dundee</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12122</td>\n",
       "      <td>17.6</td>\n",
       "      <td>22%</td>\n",
       "      <td>63%</td>\n",
       "      <td>37%</td>\n",
       "      <td>24.8</td>\n",
       "      <td>31.2</td>\n",
       "      <td>90.5</td>\n",
       "      <td>46.5</td>\n",
       "      <td>80.4</td>\n",
       "      <td>51.1</td>\n",
       "      <td>50.1�53.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>276</td>\n",
       "      <td>University of the West of Scotland</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>11730</td>\n",
       "      <td>22.4</td>\n",
       "      <td>21%</td>\n",
       "      <td>59%</td>\n",
       "      <td>41%</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.9</td>\n",
       "      <td>76.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>74.6</td>\n",
       "      <td>37.9</td>\n",
       "      <td>35.3�38.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>213</td>\n",
       "      <td>University of Denver</td>\n",
       "      <td>United States</td>\n",
       "      <td>9535</td>\n",
       "      <td>13.0</td>\n",
       "      <td>9%</td>\n",
       "      <td>57%</td>\n",
       "      <td>43%</td>\n",
       "      <td>40.5</td>\n",
       "      <td>22.3</td>\n",
       "      <td>75.4</td>\n",
       "      <td>35.8</td>\n",
       "      <td>27.8</td>\n",
       "      <td>44.4</td>\n",
       "      <td>42.4�44.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>354</td>\n",
       "      <td>Kindai University</td>\n",
       "      <td>Japan</td>\n",
       "      <td>33125</td>\n",
       "      <td>13.6</td>\n",
       "      <td>2%</td>\n",
       "      <td>30%</td>\n",
       "      <td>70%</td>\n",
       "      <td>20.1</td>\n",
       "      <td>11.4</td>\n",
       "      <td>58.4</td>\n",
       "      <td>38.8</td>\n",
       "      <td>23.0</td>\n",
       "      <td>29.7</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>337</td>\n",
       "      <td>�bo Akademi University</td>\n",
       "      <td>Finland</td>\n",
       "      <td>5295</td>\n",
       "      <td>17.5</td>\n",
       "      <td>16%</td>\n",
       "      <td>0%</td>\n",
       "      <td>0%</td>\n",
       "      <td>22.6</td>\n",
       "      <td>29.2</td>\n",
       "      <td>33.1</td>\n",
       "      <td>38.5</td>\n",
       "      <td>66.9</td>\n",
       "      <td>31.5</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1166</th>\n",
       "      <td>466</td>\n",
       "      <td>Universit� Hassan II de Casablanca</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>110125</td>\n",
       "      <td>27.8</td>\n",
       "      <td>2%</td>\n",
       "      <td>54%</td>\n",
       "      <td>46%</td>\n",
       "      <td>15.9</td>\n",
       "      <td>7.6</td>\n",
       "      <td>24.8</td>\n",
       "      <td>36.4</td>\n",
       "      <td>34.4</td>\n",
       "      <td>18.0</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>175</td>\n",
       "      <td>Florida State University</td>\n",
       "      <td>United States</td>\n",
       "      <td>38520</td>\n",
       "      <td>24.1</td>\n",
       "      <td>7%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>38.0</td>\n",
       "      <td>40.1</td>\n",
       "      <td>69.2</td>\n",
       "      <td>39.4</td>\n",
       "      <td>43.5</td>\n",
       "      <td>48.4</td>\n",
       "      <td>46.9�50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>868</th>\n",
       "      <td>386</td>\n",
       "      <td>Shanghai University</td>\n",
       "      <td>China</td>\n",
       "      <td>36637</td>\n",
       "      <td>11.3</td>\n",
       "      <td>6%</td>\n",
       "      <td>49%</td>\n",
       "      <td>51%</td>\n",
       "      <td>21.2</td>\n",
       "      <td>24.8</td>\n",
       "      <td>29.6</td>\n",
       "      <td>60.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>26.5</td>\n",
       "      <td>22.2�28.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>119</td>\n",
       "      <td>University of Alabama at Birmingham</td>\n",
       "      <td>United States</td>\n",
       "      <td>16927</td>\n",
       "      <td>16.7</td>\n",
       "      <td>6%</td>\n",
       "      <td>62%</td>\n",
       "      <td>38%</td>\n",
       "      <td>39.2</td>\n",
       "      <td>33.6</td>\n",
       "      <td>97.3</td>\n",
       "      <td>74.8</td>\n",
       "      <td>37.4</td>\n",
       "      <td>55.7</td>\n",
       "      <td>55.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1198</th>\n",
       "      <td>475</td>\n",
       "      <td>University of the Andes, Chile</td>\n",
       "      <td>Chile</td>\n",
       "      <td>8402</td>\n",
       "      <td>14.4</td>\n",
       "      <td>2%</td>\n",
       "      <td>59%</td>\n",
       "      <td>41%</td>\n",
       "      <td>16.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>15.6</td>\n",
       "      <td>34.6</td>\n",
       "      <td>47.8</td>\n",
       "      <td>17.1</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>178</td>\n",
       "      <td>Macau University of Science and Technology</td>\n",
       "      <td>Macao</td>\n",
       "      <td>9924</td>\n",
       "      <td>24.4</td>\n",
       "      <td>79%</td>\n",
       "      <td>56%</td>\n",
       "      <td>44%</td>\n",
       "      <td>27.1</td>\n",
       "      <td>22.4</td>\n",
       "      <td>83.0</td>\n",
       "      <td>34.8</td>\n",
       "      <td>99.6</td>\n",
       "      <td>48.1</td>\n",
       "      <td>46.9�50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>333</td>\n",
       "      <td>University of Tours</td>\n",
       "      <td>France</td>\n",
       "      <td>27285</td>\n",
       "      <td>21.2</td>\n",
       "      <td>11%</td>\n",
       "      <td>60%</td>\n",
       "      <td>40%</td>\n",
       "      <td>30.2</td>\n",
       "      <td>12.5</td>\n",
       "      <td>48.5</td>\n",
       "      <td>35.7</td>\n",
       "      <td>48.8</td>\n",
       "      <td>31.9</td>\n",
       "      <td>28.3�35.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>241</td>\n",
       "      <td>University of Missouri-St Louis</td>\n",
       "      <td>United States</td>\n",
       "      <td>7019</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6%</td>\n",
       "      <td>58%</td>\n",
       "      <td>42%</td>\n",
       "      <td>30.0</td>\n",
       "      <td>24.7</td>\n",
       "      <td>70.3</td>\n",
       "      <td>40.4</td>\n",
       "      <td>40.6</td>\n",
       "      <td>41.6</td>\n",
       "      <td>38.8�42.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1369</th>\n",
       "      <td>519</td>\n",
       "      <td>Tamil Nadu Agricultural University</td>\n",
       "      <td>India</td>\n",
       "      <td>6279</td>\n",
       "      <td>7.6</td>\n",
       "      <td>0%</td>\n",
       "      <td>62%</td>\n",
       "      <td>38%</td>\n",
       "      <td>23.5</td>\n",
       "      <td>8.9</td>\n",
       "      <td>2.7</td>\n",
       "      <td>40.5</td>\n",
       "      <td>14.8</td>\n",
       "      <td>12.7</td>\n",
       "      <td>10.7�22.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Score_Rank                                  University         Country  \\\n",
       "632          312                        University of Nantes          France   \n",
       "232          152                        University of Dundee  United Kingdom   \n",
       "525          276          University of the West of Scotland  United Kingdom   \n",
       "350          213                        University of Denver   United States   \n",
       "752          354                           Kindai University           Japan   \n",
       "700          337                      �bo Akademi University         Finland   \n",
       "1166         466          Universit� Hassan II de Casablanca         Morocco   \n",
       "277          175                    Florida State University   United States   \n",
       "868          386                         Shanghai University           China   \n",
       "171          119         University of Alabama at Birmingham   United States   \n",
       "1198         475              University of the Andes, Chile           Chile   \n",
       "283          178  Macau University of Science and Technology           Macao   \n",
       "691          333                         University of Tours          France   \n",
       "419          241             University of Missouri-St Louis   United States   \n",
       "1369         519          Tamil Nadu Agricultural University           India   \n",
       "\n",
       "      Number_students  Numb_students_per_Staff International_Students  \\\n",
       "632             37078                     24.7                    11%   \n",
       "232             12122                     17.6                    22%   \n",
       "525             11730                     22.4                    21%   \n",
       "350              9535                     13.0                     9%   \n",
       "752             33125                     13.6                     2%   \n",
       "700              5295                     17.5                    16%   \n",
       "1166           110125                     27.8                     2%   \n",
       "277             38520                     24.1                     7%   \n",
       "868             36637                     11.3                     6%   \n",
       "171             16927                     16.7                     6%   \n",
       "1198             8402                     14.4                     2%   \n",
       "283              9924                     24.4                    79%   \n",
       "691             27285                     21.2                    11%   \n",
       "419              7019                     16.0                     6%   \n",
       "1369             6279                      7.6                     0%   \n",
       "\n",
       "     Percentage_Female Percentage_Male  Teaching  Research  Citations  \\\n",
       "632                56%             44%      19.8      21.0       57.4   \n",
       "232                63%             37%      24.8      31.2       90.5   \n",
       "525                59%             41%      13.9      13.9       76.8   \n",
       "350                57%             43%      40.5      22.3       75.4   \n",
       "752                30%             70%      20.1      11.4       58.4   \n",
       "700                 0%              0%      22.6      29.2       33.1   \n",
       "1166               54%             46%      15.9       7.6       24.8   \n",
       "277                56%             44%      38.0      40.1       69.2   \n",
       "868                49%             51%      21.2      24.8       29.6   \n",
       "171                62%             38%      39.2      33.6       97.3   \n",
       "1198               59%             41%      16.1      10.5       15.6   \n",
       "283                56%             44%      27.1      22.4       83.0   \n",
       "691                60%             40%      30.2      12.5       48.5   \n",
       "419                58%             42%      30.0      24.7       70.3   \n",
       "1369               62%             38%      23.5       8.9        2.7   \n",
       "\n",
       "      Industry_Income  International_Outlook  Score_Result Overall_Ranking  \n",
       "632              39.5                   50.4          34.2       28.3�35.2  \n",
       "232              46.5                   80.4          51.1       50.1�53.7  \n",
       "525              35.0                   74.6          37.9       35.3�38.7  \n",
       "350              35.8                   27.8          44.4       42.4�44.4  \n",
       "752              38.8                   23.0          29.7       28.3�35.2  \n",
       "700              38.5                   66.9          31.5       28.3�35.2  \n",
       "1166             36.4                   34.4          18.0       10.7�22.1  \n",
       "277              39.4                   43.5          48.4       46.9�50.0  \n",
       "868              60.0                   31.0          26.5       22.2�28.2  \n",
       "171              74.8                   37.4          55.7           55.70  \n",
       "1198             34.6                   47.8          17.1       10.7�22.1  \n",
       "283              34.8                   99.6          48.1       46.9�50.0  \n",
       "691              35.7                   48.8          31.9       28.3�35.2  \n",
       "419              40.4                   40.6          41.6       38.8�42.3  \n",
       "1369             40.5                   14.8          12.7       10.7�22.1  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_random_15 = df.sample(n=15)\n",
    "df_random_15"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "🎉 All Tests Passed! 🎉\n"
     ]
    }
   ],
   "source": [
    "### TEST CASE for Puzzle 3: Creating Random Subsets\n",
    "#\n",
    "# What is this cell?\n",
    "# - This cell contains test cases for the MicroProject. Even though you can modify this\n",
    "#   cell, you should treat it like it's a read-only cell since it will be replaced with\n",
    "#   a fresh version when your code is checked.\n",
    "#\n",
    "# - If this cell runs without any error in the output, you PASSED all test cases!\n",
    "#   We try and make these test cases as useful and complete as possible, but there is\n",
    "#   a chance your code may be incorrect even though you pass the test cases (these\n",
    "#   tests should be seen as a way to give you confidence that code you believe is\n",
    "#   actually correct, not as a robust check to catch all possible errors).\n",
    "#\n",
    "# - If this cell results in any errors, check you previous cells, make changes, and\n",
    "#   RE-RUN your code and then re-run this cell.  Keep repeating this until the cell\n",
    "#   passed with no errors! :)\n",
    "\n",
    "tada = \"\\N{PARTY POPPER}\"\n",
    "\n",
    "assert('df_random_15' in vars()), \"Make sure to name the dataframe df_random_15.\"\n",
    "assert(len(df_random_15) == 15), \"It looks like you did not sample exactly 15 rows.\"\n",
    "assert(len(df_random_15[df_random_15.Country != \"United States\"]) > 0), \"Make sure to sample from the full dataset stored in `df`\"\n",
    "print(f\"{tada} All Tests Passed! {tada}\") "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"color: #DD3403;\">"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Submission\n",
    "\n",
    "You're almost done!  All you need to do is to commit your lab to GitHub and run the GitHub Actions Grader:\n",
    "\n",
    "1.  ⚠️ **Make certain to save your work.** ⚠️ To do this, go to **File => Save All**\n",
    "\n",
    "2.  After you have saved, exit this notebook and return to https://discovery.cs.illinois.edu/microproject/world-university-rankings/ and complete the section **\"Commit and Grade Your Notebook\"**.\n",
    "\n",
    "3. If you see a 100% grade result on your GitHub Action, you've completed this MicroProject! 🎉\n"
   ]
  }
 ],
 "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.11.5"
  },
  "vscode": {
   "interpreter": {
    "hash": "369f2c481f4da34e4445cda3fffd2e751bd1c4d706f27375911949ba6bb62e1c"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}