boilermake.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "colab_type": "text",
        "id": "view-in-github"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/AkshathRaghav/boilermake2023/blob/main/boilermake.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "_wXPAEbmzAKP"
      },
      "outputs": [],
      "source": [
        "import numpy as np \n",
        "import pandas as pd "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "WMje0z1sjx-o",
        "outputId": "badf9146-c299-4ce3-e11f-32828cd066b6"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.8/dist-packages/gdown/parse_url.py:35: UserWarning: You specified a Google Drive link that is not the correct link to download a file. You might want to try `--fuzzy` option or the following url: https://drive.google.com/uc?id=None\n",
            "  warnings.warn(\n",
            "Downloading...\n",
            "From: https://drive.google.com/drive/folders/1M3vtSt4sBwJOADYbszQzEXacRMQz14mK?usp=sharing\n",
            "To: /content/1M3vtSt4sBwJOADYbszQzEXacRMQz14mK?usp=sharing\n",
            "\r0.00B [00:00, ?B/s]\r936kB [00:00, 72.5MB/s]\n"
          ]
        }
      ],
      "source": [
        "!gdown https://drive.google.com/drive/folders/1M3vtSt4sBwJOADYbszQzEXacRMQz14mK?usp=sharing"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FAM5S1Rv7z4w"
      },
      "source": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TtuFgw9bkT4d",
        "outputId": "2ae9ba05-d696-4122-9884-91552c923048"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ],
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "6XO4iwkARW_H"
      },
      "outputs": [],
      "source": [
        "salary = pd.read_csv('/content/drive/MyDrive/boilermake2023/data/salary_potential.csv')\n",
        "main_data = pd.read_csv('/content/drive/MyDrive/boilermake2023/data/College_Data.csv')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 852
        },
        "id": "VwwVo6doR0pl",
        "outputId": "f2b39292-ee34-41ab-8749-d5f534130020"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-a9c372bd-08b1-4dc0-9acd-c4b13fba0abc\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>rank</th>\n",
              "      <th>name</th>\n",
              "      <th>state_name</th>\n",
              "      <th>early_career_pay</th>\n",
              "      <th>mid_career_pay</th>\n",
              "      <th>make_world_better_percent</th>\n",
              "      <th>stem_percent</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Auburn University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>54400</td>\n",
              "      <td>104500</td>\n",
              "      <td>51.0</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>University of Alabama in Huntsville</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>57500</td>\n",
              "      <td>103900</td>\n",
              "      <td>59.0</td>\n",
              "      <td>45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>The University of Alabama</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>52300</td>\n",
              "      <td>97400</td>\n",
              "      <td>50.0</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>Tuskegee University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>54500</td>\n",
              "      <td>93500</td>\n",
              "      <td>61.0</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>Samford University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>48400</td>\n",
              "      <td>90500</td>\n",
              "      <td>52.0</td>\n",
              "      <td>3</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>930</th>\n",
              "      <td>22</td>\n",
              "      <td>Viterbo University</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46800</td>\n",
              "      <td>81900</td>\n",
              "      <td>62.0</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>931</th>\n",
              "      <td>23</td>\n",
              "      <td>Concordia University-Wisconsin</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46700</td>\n",
              "      <td>81600</td>\n",
              "      <td>61.0</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>932</th>\n",
              "      <td>24</td>\n",
              "      <td>University of Wisconsin-Parkside</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46000</td>\n",
              "      <td>81400</td>\n",
              "      <td>47.0</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>933</th>\n",
              "      <td>25</td>\n",
              "      <td>University of Wisconsin-River Falls</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>47100</td>\n",
              "      <td>81300</td>\n",
              "      <td>52.0</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>934</th>\n",
              "      <td>1</td>\n",
              "      <td>University of Wyoming</td>\n",
              "      <td>Wyoming</td>\n",
              "      <td>52400</td>\n",
              "      <td>98800</td>\n",
              "      <td>58.0</td>\n",
              "      <td>25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>935 rows × 7 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a9c372bd-08b1-4dc0-9acd-c4b13fba0abc')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a9c372bd-08b1-4dc0-9acd-c4b13fba0abc button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a9c372bd-08b1-4dc0-9acd-c4b13fba0abc');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "     rank                                 name state_name  early_career_pay  \\\n",
              "0       1                    Auburn University    Alabama             54400   \n",
              "1       2  University of Alabama in Huntsville    Alabama             57500   \n",
              "2       3            The University of Alabama    Alabama             52300   \n",
              "3       4                  Tuskegee University    Alabama             54500   \n",
              "4       5                   Samford University    Alabama             48400   \n",
              "..    ...                                  ...        ...               ...   \n",
              "930    22                   Viterbo University  Wisconsin             46800   \n",
              "931    23       Concordia University-Wisconsin  Wisconsin             46700   \n",
              "932    24     University of Wisconsin-Parkside  Wisconsin             46000   \n",
              "933    25  University of Wisconsin-River Falls  Wisconsin             47100   \n",
              "934     1                University of Wyoming    Wyoming             52400   \n",
              "\n",
              "     mid_career_pay  make_world_better_percent  stem_percent  \n",
              "0            104500                       51.0            31  \n",
              "1            103900                       59.0            45  \n",
              "2             97400                       50.0            15  \n",
              "3             93500                       61.0            30  \n",
              "4             90500                       52.0             3  \n",
              "..              ...                        ...           ...  \n",
              "930           81900                       62.0             3  \n",
              "931           81600                       61.0             9  \n",
              "932           81400                       47.0            17  \n",
              "933           81300                       52.0            14  \n",
              "934           98800                       58.0            25  \n",
              "\n",
              "[935 rows x 7 columns]"
            ]
          },
          "execution_count": 155,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "salary"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 467
        },
        "id": "Tk4KfxgdR12F",
        "outputId": "17987810-1916-443f-f66a-4384779417d9"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-3173bff7-3e0e-4a2b-8bb0-b8fe395f9c49\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>rank</th>\n",
              "      <th>name</th>\n",
              "      <th>state_name</th>\n",
              "      <th>early_career_pay</th>\n",
              "      <th>mid_career_pay</th>\n",
              "      <th>stem_percent</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Auburn University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>54400</td>\n",
              "      <td>104500</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>University of Alabama in Huntsville</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>57500</td>\n",
              "      <td>103900</td>\n",
              "      <td>45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>The University of Alabama</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>52300</td>\n",
              "      <td>97400</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>Tuskegee University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>54500</td>\n",
              "      <td>93500</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>Samford University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>48400</td>\n",
              "      <td>90500</td>\n",
              "      <td>3</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>930</th>\n",
              "      <td>22</td>\n",
              "      <td>Viterbo University</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46800</td>\n",
              "      <td>81900</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>931</th>\n",
              "      <td>23</td>\n",
              "      <td>Concordia University-Wisconsin</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46700</td>\n",
              "      <td>81600</td>\n",
              "      <td>9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>932</th>\n",
              "      <td>24</td>\n",
              "      <td>University of Wisconsin-Parkside</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46000</td>\n",
              "      <td>81400</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>933</th>\n",
              "      <td>25</td>\n",
              "      <td>University of Wisconsin-River Falls</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>47100</td>\n",
              "      <td>81300</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>934</th>\n",
              "      <td>1</td>\n",
              "      <td>University of Wyoming</td>\n",
              "      <td>Wyoming</td>\n",
              "      <td>52400</td>\n",
              "      <td>98800</td>\n",
              "      <td>25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>935 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3173bff7-3e0e-4a2b-8bb0-b8fe395f9c49')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-3173bff7-3e0e-4a2b-8bb0-b8fe395f9c49 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-3173bff7-3e0e-4a2b-8bb0-b8fe395f9c49');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "     rank                                 name state_name  early_career_pay  \\\n",
              "0       1                    Auburn University    Alabama             54400   \n",
              "1       2  University of Alabama in Huntsville    Alabama             57500   \n",
              "2       3            The University of Alabama    Alabama             52300   \n",
              "3       4                  Tuskegee University    Alabama             54500   \n",
              "4       5                   Samford University    Alabama             48400   \n",
              "..    ...                                  ...        ...               ...   \n",
              "930    22                   Viterbo University  Wisconsin             46800   \n",
              "931    23       Concordia University-Wisconsin  Wisconsin             46700   \n",
              "932    24     University of Wisconsin-Parkside  Wisconsin             46000   \n",
              "933    25  University of Wisconsin-River Falls  Wisconsin             47100   \n",
              "934     1                University of Wyoming    Wyoming             52400   \n",
              "\n",
              "     mid_career_pay  stem_percent  \n",
              "0            104500            31  \n",
              "1            103900            45  \n",
              "2             97400            15  \n",
              "3             93500            30  \n",
              "4             90500             3  \n",
              "..              ...           ...  \n",
              "930           81900             3  \n",
              "931           81600             9  \n",
              "932           81400            17  \n",
              "933           81300            14  \n",
              "934           98800            25  \n",
              "\n",
              "[935 rows x 6 columns]"
            ]
          },
          "execution_count": 156,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "salary.drop('make_world_better_percent', axis=1)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 748
        },
        "id": "QTx_4YKMR6-S",
        "outputId": "fdfa4411-660b-49a8-cb8f-a13c276d6f8a"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-7fde6695-0517-4e54-ac0a-e5361257b8d6\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Unnamed: 0</th>\n",
              "      <th>Private</th>\n",
              "      <th>Apps</th>\n",
              "      <th>Accept</th>\n",
              "      <th>Enroll</th>\n",
              "      <th>Top10perc</th>\n",
              "      <th>Top25perc</th>\n",
              "      <th>F.Undergrad</th>\n",
              "      <th>P.Undergrad</th>\n",
              "      <th>Outstate</th>\n",
              "      <th>Room.Board</th>\n",
              "      <th>Books</th>\n",
              "      <th>Personal</th>\n",
              "      <th>PhD</th>\n",
              "      <th>Terminal</th>\n",
              "      <th>S.F.Ratio</th>\n",
              "      <th>perc.alumni</th>\n",
              "      <th>Expend</th>\n",
              "      <th>Grad.Rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Abilene Christian University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1660</td>\n",
              "      <td>1232</td>\n",
              "      <td>721</td>\n",
              "      <td>23</td>\n",
              "      <td>52</td>\n",
              "      <td>2885</td>\n",
              "      <td>537</td>\n",
              "      <td>7440</td>\n",
              "      <td>3300</td>\n",
              "      <td>450</td>\n",
              "      <td>2200</td>\n",
              "      <td>70</td>\n",
              "      <td>78</td>\n",
              "      <td>18.1</td>\n",
              "      <td>12</td>\n",
              "      <td>7041</td>\n",
              "      <td>60</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Adelphi University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2186</td>\n",
              "      <td>1924</td>\n",
              "      <td>512</td>\n",
              "      <td>16</td>\n",
              "      <td>29</td>\n",
              "      <td>2683</td>\n",
              "      <td>1227</td>\n",
              "      <td>12280</td>\n",
              "      <td>6450</td>\n",
              "      <td>750</td>\n",
              "      <td>1500</td>\n",
              "      <td>29</td>\n",
              "      <td>30</td>\n",
              "      <td>12.2</td>\n",
              "      <td>16</td>\n",
              "      <td>10527</td>\n",
              "      <td>56</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Adrian College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1428</td>\n",
              "      <td>1097</td>\n",
              "      <td>336</td>\n",
              "      <td>22</td>\n",
              "      <td>50</td>\n",
              "      <td>1036</td>\n",
              "      <td>99</td>\n",
              "      <td>11250</td>\n",
              "      <td>3750</td>\n",
              "      <td>400</td>\n",
              "      <td>1165</td>\n",
              "      <td>53</td>\n",
              "      <td>66</td>\n",
              "      <td>12.9</td>\n",
              "      <td>30</td>\n",
              "      <td>8735</td>\n",
              "      <td>54</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Agnes Scott College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>417</td>\n",
              "      <td>349</td>\n",
              "      <td>137</td>\n",
              "      <td>60</td>\n",
              "      <td>89</td>\n",
              "      <td>510</td>\n",
              "      <td>63</td>\n",
              "      <td>12960</td>\n",
              "      <td>5450</td>\n",
              "      <td>450</td>\n",
              "      <td>875</td>\n",
              "      <td>92</td>\n",
              "      <td>97</td>\n",
              "      <td>7.7</td>\n",
              "      <td>37</td>\n",
              "      <td>19016</td>\n",
              "      <td>59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Alaska Pacific University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>193</td>\n",
              "      <td>146</td>\n",
              "      <td>55</td>\n",
              "      <td>16</td>\n",
              "      <td>44</td>\n",
              "      <td>249</td>\n",
              "      <td>869</td>\n",
              "      <td>7560</td>\n",
              "      <td>4120</td>\n",
              "      <td>800</td>\n",
              "      <td>1500</td>\n",
              "      <td>76</td>\n",
              "      <td>72</td>\n",
              "      <td>11.9</td>\n",
              "      <td>2</td>\n",
              "      <td>10922</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>772</th>\n",
              "      <td>Worcester State College</td>\n",
              "      <td>No</td>\n",
              "      <td>2197</td>\n",
              "      <td>1515</td>\n",
              "      <td>543</td>\n",
              "      <td>4</td>\n",
              "      <td>26</td>\n",
              "      <td>3089</td>\n",
              "      <td>2029</td>\n",
              "      <td>6797</td>\n",
              "      <td>3900</td>\n",
              "      <td>500</td>\n",
              "      <td>1200</td>\n",
              "      <td>60</td>\n",
              "      <td>60</td>\n",
              "      <td>21.0</td>\n",
              "      <td>14</td>\n",
              "      <td>4469</td>\n",
              "      <td>40</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>773</th>\n",
              "      <td>Xavier University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1959</td>\n",
              "      <td>1805</td>\n",
              "      <td>695</td>\n",
              "      <td>24</td>\n",
              "      <td>47</td>\n",
              "      <td>2849</td>\n",
              "      <td>1107</td>\n",
              "      <td>11520</td>\n",
              "      <td>4960</td>\n",
              "      <td>600</td>\n",
              "      <td>1250</td>\n",
              "      <td>73</td>\n",
              "      <td>75</td>\n",
              "      <td>13.3</td>\n",
              "      <td>31</td>\n",
              "      <td>9189</td>\n",
              "      <td>83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>774</th>\n",
              "      <td>Xavier University of Louisiana</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2097</td>\n",
              "      <td>1915</td>\n",
              "      <td>695</td>\n",
              "      <td>34</td>\n",
              "      <td>61</td>\n",
              "      <td>2793</td>\n",
              "      <td>166</td>\n",
              "      <td>6900</td>\n",
              "      <td>4200</td>\n",
              "      <td>617</td>\n",
              "      <td>781</td>\n",
              "      <td>67</td>\n",
              "      <td>75</td>\n",
              "      <td>14.4</td>\n",
              "      <td>20</td>\n",
              "      <td>8323</td>\n",
              "      <td>49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>775</th>\n",
              "      <td>Yale University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>10705</td>\n",
              "      <td>2453</td>\n",
              "      <td>1317</td>\n",
              "      <td>95</td>\n",
              "      <td>99</td>\n",
              "      <td>5217</td>\n",
              "      <td>83</td>\n",
              "      <td>19840</td>\n",
              "      <td>6510</td>\n",
              "      <td>630</td>\n",
              "      <td>2115</td>\n",
              "      <td>96</td>\n",
              "      <td>96</td>\n",
              "      <td>5.8</td>\n",
              "      <td>49</td>\n",
              "      <td>40386</td>\n",
              "      <td>99</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>776</th>\n",
              "      <td>York College of Pennsylvania</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2989</td>\n",
              "      <td>1855</td>\n",
              "      <td>691</td>\n",
              "      <td>28</td>\n",
              "      <td>63</td>\n",
              "      <td>2988</td>\n",
              "      <td>1726</td>\n",
              "      <td>4990</td>\n",
              "      <td>3560</td>\n",
              "      <td>500</td>\n",
              "      <td>1250</td>\n",
              "      <td>75</td>\n",
              "      <td>75</td>\n",
              "      <td>18.1</td>\n",
              "      <td>28</td>\n",
              "      <td>4509</td>\n",
              "      <td>99</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>777 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7fde6695-0517-4e54-ac0a-e5361257b8d6')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7fde6695-0517-4e54-ac0a-e5361257b8d6 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7fde6695-0517-4e54-ac0a-e5361257b8d6');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "                         Unnamed: 0 Private   Apps  Accept  Enroll  Top10perc  \\\n",
              "0      Abilene Christian University     Yes   1660    1232     721         23   \n",
              "1                Adelphi University     Yes   2186    1924     512         16   \n",
              "2                    Adrian College     Yes   1428    1097     336         22   \n",
              "3               Agnes Scott College     Yes    417     349     137         60   \n",
              "4         Alaska Pacific University     Yes    193     146      55         16   \n",
              "..                              ...     ...    ...     ...     ...        ...   \n",
              "772         Worcester State College      No   2197    1515     543          4   \n",
              "773               Xavier University     Yes   1959    1805     695         24   \n",
              "774  Xavier University of Louisiana     Yes   2097    1915     695         34   \n",
              "775                 Yale University     Yes  10705    2453    1317         95   \n",
              "776    York College of Pennsylvania     Yes   2989    1855     691         28   \n",
              "\n",
              "     Top25perc  F.Undergrad  P.Undergrad  Outstate  Room.Board  Books  \\\n",
              "0           52         2885          537      7440        3300    450   \n",
              "1           29         2683         1227     12280        6450    750   \n",
              "2           50         1036           99     11250        3750    400   \n",
              "3           89          510           63     12960        5450    450   \n",
              "4           44          249          869      7560        4120    800   \n",
              "..         ...          ...          ...       ...         ...    ...   \n",
              "772         26         3089         2029      6797        3900    500   \n",
              "773         47         2849         1107     11520        4960    600   \n",
              "774         61         2793          166      6900        4200    617   \n",
              "775         99         5217           83     19840        6510    630   \n",
              "776         63         2988         1726      4990        3560    500   \n",
              "\n",
              "     Personal  PhD  Terminal  S.F.Ratio  perc.alumni  Expend  Grad.Rate  \n",
              "0        2200   70        78       18.1           12    7041         60  \n",
              "1        1500   29        30       12.2           16   10527         56  \n",
              "2        1165   53        66       12.9           30    8735         54  \n",
              "3         875   92        97        7.7           37   19016         59  \n",
              "4        1500   76        72       11.9            2   10922         15  \n",
              "..        ...  ...       ...        ...          ...     ...        ...  \n",
              "772      1200   60        60       21.0           14    4469         40  \n",
              "773      1250   73        75       13.3           31    9189         83  \n",
              "774       781   67        75       14.4           20    8323         49  \n",
              "775      2115   96        96        5.8           49   40386         99  \n",
              "776      1250   75        75       18.1           28    4509         99  \n",
              "\n",
              "[777 rows x 19 columns]"
            ]
          },
          "execution_count": 157,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "main_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Q1Jj-8xSSJty"
      },
      "outputs": [],
      "source": [
        "main_data.rename(columns = {\"Unnamed: 0\":\"name\"}, inplace=True)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "4mGVJ3KPTBjc"
      },
      "outputs": [],
      "source": [
        "a = salary.iloc[:,1].values.tolist()\n",
        "b = main_data.iloc[:,0].values.tolist()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Di8-W-_TTdqt",
        "outputId": "b04d8d41-219e-4cf3-c7b3-15f51f0947c3"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "419"
            ]
          },
          "execution_count": 160,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "remaining = list(set(b)-set(a))\n",
        "len(remaining)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "T38xWZz7TzSF"
      },
      "outputs": [],
      "source": [
        "for i in remaining: \n",
        "  try: \n",
        "    print(salary[salary['name'] == i].index.tolist()[0])\n",
        "    salary.drop(salary[salary['name'] == i].index.tolist()[0], axis=0,inplace=True)\n",
        "  except:\n",
        "    try: \n",
        "      main_data.drop(main_data[main_data['name'] == i].index.tolist()[0],axis=0,inplace=True)\n",
        "    except: \n",
        "      print(i)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hmmKmGQaXksH",
        "outputId": "c6439c2b-0f95-498f-c580-25afa007058f"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "358"
            ]
          },
          "execution_count": 162,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "len(main_data)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vYQpCb2kZjOV",
        "outputId": "b1c1dba2-f9de-44b0-c163-c577baa69273"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "935"
            ]
          },
          "execution_count": 163,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "len(salary)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "iH3NAqiNZ6Pp",
        "outputId": "9a0ffe00-0b90-4eea-c4a6-9a338c123935"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-e8a63e60-bdd1-4d67-82ef-38e4cf5e9639\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>Private</th>\n",
              "      <th>Apps</th>\n",
              "      <th>Accept</th>\n",
              "      <th>Enroll</th>\n",
              "      <th>Top10perc</th>\n",
              "      <th>Top25perc</th>\n",
              "      <th>F.Undergrad</th>\n",
              "      <th>P.Undergrad</th>\n",
              "      <th>Outstate</th>\n",
              "      <th>Room.Board</th>\n",
              "      <th>Books</th>\n",
              "      <th>Personal</th>\n",
              "      <th>PhD</th>\n",
              "      <th>Terminal</th>\n",
              "      <th>S.F.Ratio</th>\n",
              "      <th>perc.alumni</th>\n",
              "      <th>Expend</th>\n",
              "      <th>Grad.Rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Agnes Scott College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>417</td>\n",
              "      <td>349</td>\n",
              "      <td>137</td>\n",
              "      <td>60</td>\n",
              "      <td>89</td>\n",
              "      <td>510</td>\n",
              "      <td>63</td>\n",
              "      <td>12960</td>\n",
              "      <td>5450</td>\n",
              "      <td>450</td>\n",
              "      <td>875</td>\n",
              "      <td>92</td>\n",
              "      <td>97</td>\n",
              "      <td>7.7</td>\n",
              "      <td>37</td>\n",
              "      <td>19016</td>\n",
              "      <td>59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Alaska Pacific University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>193</td>\n",
              "      <td>146</td>\n",
              "      <td>55</td>\n",
              "      <td>16</td>\n",
              "      <td>44</td>\n",
              "      <td>249</td>\n",
              "      <td>869</td>\n",
              "      <td>7560</td>\n",
              "      <td>4120</td>\n",
              "      <td>800</td>\n",
              "      <td>1500</td>\n",
              "      <td>76</td>\n",
              "      <td>72</td>\n",
              "      <td>11.9</td>\n",
              "      <td>2</td>\n",
              "      <td>10922</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Albertus Magnus College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>353</td>\n",
              "      <td>340</td>\n",
              "      <td>103</td>\n",
              "      <td>17</td>\n",
              "      <td>45</td>\n",
              "      <td>416</td>\n",
              "      <td>230</td>\n",
              "      <td>13290</td>\n",
              "      <td>5720</td>\n",
              "      <td>500</td>\n",
              "      <td>1500</td>\n",
              "      <td>90</td>\n",
              "      <td>93</td>\n",
              "      <td>11.5</td>\n",
              "      <td>26</td>\n",
              "      <td>8861</td>\n",
              "      <td>63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Albion College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1899</td>\n",
              "      <td>1720</td>\n",
              "      <td>489</td>\n",
              "      <td>37</td>\n",
              "      <td>68</td>\n",
              "      <td>1594</td>\n",
              "      <td>32</td>\n",
              "      <td>13868</td>\n",
              "      <td>4826</td>\n",
              "      <td>450</td>\n",
              "      <td>850</td>\n",
              "      <td>89</td>\n",
              "      <td>100</td>\n",
              "      <td>13.7</td>\n",
              "      <td>37</td>\n",
              "      <td>11487</td>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Alma College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1267</td>\n",
              "      <td>1080</td>\n",
              "      <td>385</td>\n",
              "      <td>44</td>\n",
              "      <td>73</td>\n",
              "      <td>1306</td>\n",
              "      <td>28</td>\n",
              "      <td>12572</td>\n",
              "      <td>4552</td>\n",
              "      <td>400</td>\n",
              "      <td>400</td>\n",
              "      <td>79</td>\n",
              "      <td>87</td>\n",
              "      <td>15.3</td>\n",
              "      <td>32</td>\n",
              "      <td>9305</td>\n",
              "      <td>68</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>770</th>\n",
              "      <td>Wofford College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1501</td>\n",
              "      <td>935</td>\n",
              "      <td>273</td>\n",
              "      <td>51</td>\n",
              "      <td>83</td>\n",
              "      <td>1059</td>\n",
              "      <td>34</td>\n",
              "      <td>12680</td>\n",
              "      <td>4150</td>\n",
              "      <td>605</td>\n",
              "      <td>1440</td>\n",
              "      <td>91</td>\n",
              "      <td>92</td>\n",
              "      <td>15.3</td>\n",
              "      <td>42</td>\n",
              "      <td>7875</td>\n",
              "      <td>75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>771</th>\n",
              "      <td>Worcester Polytechnic Institute</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2768</td>\n",
              "      <td>2314</td>\n",
              "      <td>682</td>\n",
              "      <td>49</td>\n",
              "      <td>86</td>\n",
              "      <td>2802</td>\n",
              "      <td>86</td>\n",
              "      <td>15884</td>\n",
              "      <td>5370</td>\n",
              "      <td>530</td>\n",
              "      <td>730</td>\n",
              "      <td>92</td>\n",
              "      <td>94</td>\n",
              "      <td>15.2</td>\n",
              "      <td>34</td>\n",
              "      <td>10774</td>\n",
              "      <td>82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>773</th>\n",
              "      <td>Xavier University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1959</td>\n",
              "      <td>1805</td>\n",
              "      <td>695</td>\n",
              "      <td>24</td>\n",
              "      <td>47</td>\n",
              "      <td>2849</td>\n",
              "      <td>1107</td>\n",
              "      <td>11520</td>\n",
              "      <td>4960</td>\n",
              "      <td>600</td>\n",
              "      <td>1250</td>\n",
              "      <td>73</td>\n",
              "      <td>75</td>\n",
              "      <td>13.3</td>\n",
              "      <td>31</td>\n",
              "      <td>9189</td>\n",
              "      <td>83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>774</th>\n",
              "      <td>Xavier University of Louisiana</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2097</td>\n",
              "      <td>1915</td>\n",
              "      <td>695</td>\n",
              "      <td>34</td>\n",
              "      <td>61</td>\n",
              "      <td>2793</td>\n",
              "      <td>166</td>\n",
              "      <td>6900</td>\n",
              "      <td>4200</td>\n",
              "      <td>617</td>\n",
              "      <td>781</td>\n",
              "      <td>67</td>\n",
              "      <td>75</td>\n",
              "      <td>14.4</td>\n",
              "      <td>20</td>\n",
              "      <td>8323</td>\n",
              "      <td>49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>775</th>\n",
              "      <td>Yale University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>10705</td>\n",
              "      <td>2453</td>\n",
              "      <td>1317</td>\n",
              "      <td>95</td>\n",
              "      <td>99</td>\n",
              "      <td>5217</td>\n",
              "      <td>83</td>\n",
              "      <td>19840</td>\n",
              "      <td>6510</td>\n",
              "      <td>630</td>\n",
              "      <td>2115</td>\n",
              "      <td>96</td>\n",
              "      <td>96</td>\n",
              "      <td>5.8</td>\n",
              "      <td>49</td>\n",
              "      <td>40386</td>\n",
              "      <td>99</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>358 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e8a63e60-bdd1-4d67-82ef-38e4cf5e9639')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-e8a63e60-bdd1-4d67-82ef-38e4cf5e9639 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-e8a63e60-bdd1-4d67-82ef-38e4cf5e9639');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "                                name Private   Apps  Accept  Enroll  \\\n",
              "3                Agnes Scott College     Yes    417     349     137   \n",
              "4          Alaska Pacific University     Yes    193     146      55   \n",
              "6            Albertus Magnus College     Yes    353     340     103   \n",
              "7                     Albion College     Yes   1899    1720     489   \n",
              "13                      Alma College     Yes   1267    1080     385   \n",
              "..                               ...     ...    ...     ...     ...   \n",
              "770                  Wofford College     Yes   1501     935     273   \n",
              "771  Worcester Polytechnic Institute     Yes   2768    2314     682   \n",
              "773                Xavier University     Yes   1959    1805     695   \n",
              "774   Xavier University of Louisiana     Yes   2097    1915     695   \n",
              "775                  Yale University     Yes  10705    2453    1317   \n",
              "\n",
              "     Top10perc  Top25perc  F.Undergrad  P.Undergrad  Outstate  Room.Board  \\\n",
              "3           60         89          510           63     12960        5450   \n",
              "4           16         44          249          869      7560        4120   \n",
              "6           17         45          416          230     13290        5720   \n",
              "7           37         68         1594           32     13868        4826   \n",
              "13          44         73         1306           28     12572        4552   \n",
              "..         ...        ...          ...          ...       ...         ...   \n",
              "770         51         83         1059           34     12680        4150   \n",
              "771         49         86         2802           86     15884        5370   \n",
              "773         24         47         2849         1107     11520        4960   \n",
              "774         34         61         2793          166      6900        4200   \n",
              "775         95         99         5217           83     19840        6510   \n",
              "\n",
              "     Books  Personal  PhD  Terminal  S.F.Ratio  perc.alumni  Expend  Grad.Rate  \n",
              "3      450       875   92        97        7.7           37   19016         59  \n",
              "4      800      1500   76        72       11.9            2   10922         15  \n",
              "6      500      1500   90        93       11.5           26    8861         63  \n",
              "7      450       850   89       100       13.7           37   11487         73  \n",
              "13     400       400   79        87       15.3           32    9305         68  \n",
              "..     ...       ...  ...       ...        ...          ...     ...        ...  \n",
              "770    605      1440   91        92       15.3           42    7875         75  \n",
              "771    530       730   92        94       15.2           34   10774         82  \n",
              "773    600      1250   73        75       13.3           31    9189         83  \n",
              "774    617       781   67        75       14.4           20    8323         49  \n",
              "775    630      2115   96        96        5.8           49   40386         99  \n",
              "\n",
              "[358 rows x 19 columns]"
            ]
          },
          "execution_count": 164,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "main_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QwQ_Okd3aClB",
        "outputId": "0a846e22-1091-4bf1-d428-c1112c019b8a"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "['Lewis-Clark State College',\n",
              " 'Rush University',\n",
              " 'Oregon Health & Science University',\n",
              " 'Pace University-New York',\n",
              " 'Barton College',\n",
              " \"St Mary's College of Maryland\",\n",
              " 'Virginia Polytechnic Institute and State University',\n",
              " 'Colby-Sawyer College',\n",
              " 'University of the Sciences',\n",
              " 'University of New Haven',\n",
              " 'Pacific Northwest College of Art',\n",
              " 'Clark Atlanta University',\n",
              " 'Cleary University',\n",
              " 'The University of Texas Health Science Center at San Antonio',\n",
              " 'Haverford College',\n",
              " 'Clarke University',\n",
              " 'Rice University',\n",
              " 'Baptist Memorial College of Health Sciences',\n",
              " 'Rhode Island School of Design',\n",
              " 'Campbellsville University',\n",
              " 'The University of Tennessee at Knoxville',\n",
              " 'Vermont Technical College',\n",
              " 'Kentucky State University',\n",
              " 'Golden Gate University',\n",
              " 'Indiana University -Purdue U. at Fort Wayne',\n",
              " 'University of Toledo',\n",
              " 'Western New Mexico University',\n",
              " 'Austin Peay State University',\n",
              " 'Oakwood University',\n",
              " 'University of Saint Joseph',\n",
              " 'University of North Carolina Wilmington',\n",
              " 'University of Washington at Tacoma',\n",
              " 'Philander Smith College',\n",
              " 'Southern Wesleyan University',\n",
              " 'University of South Carolina-Columbia',\n",
              " 'South Carolina State University',\n",
              " 'Columbia University in the City of New York',\n",
              " 'Yeshiva University',\n",
              " 'The College of New Jersey',\n",
              " 'Rowan University',\n",
              " 'Johnson C Smith University',\n",
              " 'Berea College',\n",
              " 'United States Military Academy',\n",
              " 'Washburn University',\n",
              " 'University of Providence',\n",
              " 'Florida Agricultural and Mechanical University',\n",
              " 'University of Akron Main Campus',\n",
              " 'Covenant College',\n",
              " 'Pittsburg State University',\n",
              " \"St. Mary's University\",\n",
              " 'Brigham Young University Hawaii',\n",
              " 'University of Maine at Augusta',\n",
              " 'Rutgers University-Camden',\n",
              " 'Bentley University',\n",
              " 'New Jersey City University',\n",
              " 'Manhattan Christian College',\n",
              " 'Saint Francis Medical Center College of Nursing',\n",
              " 'University of Pittsburgh main campus',\n",
              " 'University of Washington at Bothell',\n",
              " 'Kean University',\n",
              " 'Kalamazoo College',\n",
              " 'College of St Joseph',\n",
              " 'University of Arkansas for Medical Sciences',\n",
              " 'Wheeling Jesuit University',\n",
              " 'SUNY Downstate Medical Center',\n",
              " 'Eastern Kentucky University',\n",
              " 'Spring Hill College',\n",
              " 'University of Nevada at Reno',\n",
              " 'University of St Thomas (Minnesota)',\n",
              " 'University of Alabama in Huntsville',\n",
              " 'Central Michigan University',\n",
              " 'University of Sioux Falls',\n",
              " 'Champlain College',\n",
              " 'University of Arkansas at Pine Bluff',\n",
              " 'Dakota Wesleyan University',\n",
              " 'University of California at Los Angeles',\n",
              " 'Savannah College of Art and Design',\n",
              " 'Belhaven University',\n",
              " 'Graceland University-Lamoni',\n",
              " 'Delaware State University',\n",
              " 'Bryant University',\n",
              " 'Cumberland University',\n",
              " 'Eastern Michigan University',\n",
              " 'Morehead State University',\n",
              " 'Shorter University',\n",
              " 'SUNY Maritime College',\n",
              " 'Southwestern Oklahoma State University',\n",
              " 'Stevens-Henager College (Murray, Utah)',\n",
              " 'University of Maryland, Baltimore',\n",
              " 'Brigham Young University-Idaho',\n",
              " 'MCPHS University',\n",
              " 'Bellevue University',\n",
              " 'University of Colorado Denver/Anschutz Medical Campus',\n",
              " 'Johnson & Wales University-Online',\n",
              " 'Towson University',\n",
              " 'Rutgers University at New Brunswick',\n",
              " 'Charter Oak State College',\n",
              " 'Maharishi University of Management',\n",
              " 'Northwestern State University',\n",
              " 'Texas Tech University',\n",
              " 'McDaniel College',\n",
              " 'University of Arkansas at Fort Smith',\n",
              " 'Concord University',\n",
              " 'Saginaw Valley State University',\n",
              " 'Auburn University at Montgomery',\n",
              " 'Bethany College (West Virginia)',\n",
              " 'University of Mount Union',\n",
              " 'University of Holy Cross',\n",
              " 'University of Saint Francis-Fort Wayne',\n",
              " 'Trevecca Nazarene University',\n",
              " 'Faulkner University',\n",
              " 'Birmingham Southern College',\n",
              " 'Augsburg University',\n",
              " 'Mount Mercy University',\n",
              " 'Ottawa University-Online',\n",
              " 'Western New England University',\n",
              " 'Shenandoah University',\n",
              " 'College of Saint Mary',\n",
              " 'Jacksonville University',\n",
              " 'Old Dominion University',\n",
              " 'University of Nebraska at Kearney',\n",
              " 'West Virginia University Institute of Technology',\n",
              " 'University of Louisiana at Monroe',\n",
              " 'The University of Montana-Western',\n",
              " 'Glenville State College',\n",
              " 'University of Michigan at Dearborn',\n",
              " 'Cornell University',\n",
              " 'High Point University',\n",
              " 'Portland State University',\n",
              " 'Minnesota State University at Mankato',\n",
              " 'Randolph College',\n",
              " 'Samuel Merritt University',\n",
              " 'Doane University-Graduate and Professional Studies',\n",
              " 'Thomas More College',\n",
              " 'East Central University',\n",
              " 'Ottawa University-Phoenix',\n",
              " 'Eastern Washington University',\n",
              " 'Oral Roberts University',\n",
              " 'Capitol Technology University',\n",
              " 'Northern State University',\n",
              " 'Maryville University of Saint Louis',\n",
              " 'University of New Orleans',\n",
              " 'Maine Maritime Academy',\n",
              " 'Western Connecticut State University',\n",
              " \"Mount St. Mary's University\",\n",
              " 'University of Wisconsin-La Crosse',\n",
              " 'Northwestern Oklahoma State University',\n",
              " 'Corban University',\n",
              " 'Johnson & Wales University at Denver',\n",
              " 'Wilmington University',\n",
              " 'Concordia University-Wisconsin',\n",
              " 'Monmouth University',\n",
              " 'Manchester University',\n",
              " 'Jacksonville State University',\n",
              " 'Viterbo University',\n",
              " 'Rhode Island College',\n",
              " 'Chaminade University of Honolulu',\n",
              " 'The University of Tennessee at Chattanooga',\n",
              " 'Augusta University',\n",
              " 'Plymouth State University',\n",
              " 'Colorado Christian University',\n",
              " \"St. John's College-Department of Nursing\",\n",
              " 'West Virginia State University',\n",
              " 'Oklahoma City University',\n",
              " 'Colorado Mesa University',\n",
              " 'West Virginia University at Parkersburg',\n",
              " 'Amridge University',\n",
              " 'Lipscomb University',\n",
              " 'University of Arkansas at Little Rock',\n",
              " 'Bloomfield College',\n",
              " 'Columbus State University',\n",
              " 'Franciscan Missionaries of Our Lady University',\n",
              " 'Minot State University',\n",
              " 'Miami University (Ohio)',\n",
              " 'Chadron State College',\n",
              " 'Texas A&M University at Kingsville',\n",
              " \"Saint Peter's University\",\n",
              " 'Weber State University',\n",
              " 'Central Christian College of Kansas',\n",
              " 'Jefferson College of Health Sciences',\n",
              " 'The College of Idaho',\n",
              " 'Western Oregon University',\n",
              " 'New Orleans Baptist Theological Seminary',\n",
              " 'Holy Cross College',\n",
              " 'The University of Findlay',\n",
              " 'Granite State College',\n",
              " 'Southeastern Oklahoma State University',\n",
              " 'Methodist University',\n",
              " 'Lakeview College of Nursing',\n",
              " 'Clarkson College',\n",
              " 'University of California at Santa Barbara',\n",
              " 'University of Arkansas',\n",
              " 'Prescott College',\n",
              " 'Union College (New York)',\n",
              " 'Southern Connecticut State University',\n",
              " 'Western Kentucky University',\n",
              " 'Oklahoma Panhandle State University',\n",
              " 'Wheaton College (Mass.)',\n",
              " 'University of the Cumberlands',\n",
              " 'Augustana University',\n",
              " 'The University of Texas Medical Branch',\n",
              " 'Ferris State University',\n",
              " \"Saint Mary's College of California\",\n",
              " 'Midland University',\n",
              " 'West Liberty University',\n",
              " 'Multnomah University',\n",
              " 'Ohio Valley University',\n",
              " 'University of Colorado Colorado Springs',\n",
              " 'Benedict College',\n",
              " 'Alderson Broaddus University',\n",
              " 'Union College (Nebraska)',\n",
              " 'Polytechnic University of Puerto Rico-Orlando',\n",
              " 'South Dakota School of Mines and Technology',\n",
              " 'Rose-Hulman Institute of Technology',\n",
              " 'The University of Texas Health Science Center at Houston',\n",
              " 'Arkansas State University at Jones Boro',\n",
              " 'Brigham Young University-Provo',\n",
              " 'Western Governors University',\n",
              " 'Bates College',\n",
              " 'Armstrong State University',\n",
              " 'University of South Alabama',\n",
              " 'Missouri State University',\n",
              " 'Missouri University of Science and Technology',\n",
              " 'Walsh College of Accountancy and Business Administration',\n",
              " 'Nebraska Wesleyan University',\n",
              " 'University of Connecticut',\n",
              " 'Kennesaw State University',\n",
              " 'Regis University',\n",
              " 'Middle Tennessee State University',\n",
              " 'Southern Illinois University at Carbondale',\n",
              " 'Felician University',\n",
              " 'Metropolitan State College of Denver',\n",
              " 'University of the Ozarks',\n",
              " 'Ottawa University-Ottawa',\n",
              " 'University of Idaho',\n",
              " 'Wheaton College (Ill.)',\n",
              " 'University of Central Arkansas',\n",
              " 'University of Southern Maine',\n",
              " 'Stockton University',\n",
              " 'Husson University',\n",
              " 'Mount Carmel College of Nursing',\n",
              " 'Western State Colorado University',\n",
              " 'University of Bridgeport',\n",
              " 'Loyola University Maryland',\n",
              " 'University of New Hampshire at Manchester',\n",
              " 'Pomona College',\n",
              " 'Truman State University',\n",
              " 'Troy University',\n",
              " 'Concordia University-Saint Paul',\n",
              " 'Metropolitan State University',\n",
              " 'Southern Adventist University',\n",
              " 'Southeastern Louisiana University',\n",
              " 'Nazarene Bible College',\n",
              " 'University of Louisiana at Lafayette',\n",
              " 'Ohio State University',\n",
              " 'Oklahoma State University Institute of Technology',\n",
              " 'Southern Nazarene University',\n",
              " 'University of South Dakota',\n",
              " 'Unity College',\n",
              " 'The University of Texas at Dallas',\n",
              " 'Barnes-Jewish College Goldfarb School of Nursing',\n",
              " 'University of California at San Diego',\n",
              " 'Asbury University',\n",
              " 'Sierra Nevada College',\n",
              " 'Pennsylvania State University -Harrisburg',\n",
              " 'Bluefield State College',\n",
              " 'Georgia College & State University',\n",
              " 'Bethel College-North Newton',\n",
              " 'Boston College',\n",
              " 'Nebraska Methodist College of Nursing & Allied Health',\n",
              " 'Pennsylvania State University at Erie',\n",
              " 'Thomas Jefferson University',\n",
              " 'New Mexico Highlands University',\n",
              " 'Langston University',\n",
              " 'Frostburg State University',\n",
              " 'University of Iowa',\n",
              " 'Lindenwood University',\n",
              " 'University of Missouri-Columbia',\n",
              " 'Kansas City Art Institute',\n",
              " 'Ball State University',\n",
              " 'Edgewood College',\n",
              " 'The University of Texas at Austin',\n",
              " 'Columbia College (Missouri)',\n",
              " 'Middlebury College',\n",
              " 'Concordia University-Nebraska',\n",
              " 'Limestone College',\n",
              " 'University of Mary Washington',\n",
              " 'University of Nebraska Medical Center',\n",
              " 'Concordia College at Moorhead',\n",
              " 'Marylhurst University',\n",
              " 'Southwestern College (Kansas)',\n",
              " 'Coastal Carolina University',\n",
              " 'Tougaloo College',\n",
              " 'Trinity Bible College and Graduate School',\n",
              " 'Middle Georgia State University',\n",
              " 'Medical University of South Carolina',\n",
              " 'University of West Georgia',\n",
              " 'Polytechnic University of Puerto Rico-Miami',\n",
              " 'Trinity College',\n",
              " 'University of Missouri at Kansas City',\n",
              " 'Southern Arkansas University Main Campus',\n",
              " 'Goldey-Beacom College',\n",
              " 'City University of Seattle',\n",
              " 'Allen College',\n",
              " 'University of Maryland-Baltimore County',\n",
              " \"St Vincent's College\",\n",
              " 'Webb Institute',\n",
              " 'University of Nebraska at Omaha',\n",
              " 'California State Polytechnic University at Pomona',\n",
              " 'Lawrence Technological University',\n",
              " 'Oklahoma Wesleyan University',\n",
              " 'Pennsylvania State University at University Park',\n",
              " 'Bellevue College',\n",
              " 'Avila University',\n",
              " 'Concordia University-Portland',\n",
              " 'University of Houston-Clear Lake',\n",
              " 'University of Oklahoma-Norman Campus',\n",
              " 'North Carolina A & T State University',\n",
              " 'Rutgers University at Newark',\n",
              " 'Colorado State University at Fort Collins',\n",
              " 'Washington Adventist University',\n",
              " 'University of Wisconsin-Oshkosh',\n",
              " 'John Wesley University',\n",
              " 'William Paterson University of New Jersey',\n",
              " 'Alabama State University',\n",
              " 'Maine College of Art',\n",
              " 'Iowa Wesleyan University',\n",
              " 'Eastern New Mexico University-Main Campus',\n",
              " 'Mississippi Valley State University',\n",
              " 'Elon University',\n",
              " 'Minneapolis College of Art and Design',\n",
              " 'University of Maine at Fort Kent',\n",
              " 'University of Hawaii at Hilo',\n",
              " 'University of New Mexico',\n",
              " 'Newman University',\n",
              " 'Northwood University',\n",
              " 'Union College (Kentucky)',\n",
              " 'Rogers State University',\n",
              " 'Indiana University -Purdue U. at Indianapolis',\n",
              " 'Clark College',\n",
              " 'George Fox University',\n",
              " 'Mid-America Christian University',\n",
              " 'Central Baptist College',\n",
              " 'Cleveland State University',\n",
              " 'Boise State University',\n",
              " 'Maryland Institute College of Art',\n",
              " 'University of California at Davis',\n",
              " 'Southern Utah University',\n",
              " 'McNeese State University',\n",
              " 'The College of Wooster',\n",
              " 'Montana Tech of the University of Montana',\n",
              " 'Lake Superior State University',\n",
              " 'Heritage University',\n",
              " 'Carson-Newman University',\n",
              " 'Oregon State University',\n",
              " 'Marian University (Indiana)',\n",
              " 'Kettering College',\n",
              " 'Johnson & Wales University-Providence',\n",
              " 'University of Nevada at Las Vegas',\n",
              " \"Saint Joseph's College of Maine\",\n",
              " 'Stevenson University',\n",
              " 'University of Central Missouri',\n",
              " 'University of North Alabama',\n",
              " 'Cornish College of the Arts',\n",
              " 'Prairie View A&M University',\n",
              " 'University of Minnesota-Twin Cities',\n",
              " 'Grambling State University',\n",
              " 'Fairleigh Dickinson University-Florham Campus',\n",
              " 'Principia College',\n",
              " 'Swarthmore College',\n",
              " 'Virginia Military Institute',\n",
              " 'Whitworth University-Adult Degree Programs',\n",
              " 'Park University',\n",
              " 'Rockhurst University',\n",
              " 'Hawaii Pacific University',\n",
              " 'Shepherd University',\n",
              " 'Saint Johns University',\n",
              " 'Oregon Institute of Technology',\n",
              " 'Montana State University at Billings',\n",
              " 'Bastyr University',\n",
              " 'Oklahoma State University at Stillwater',\n",
              " 'Charles R Drew University of Medicine and Science',\n",
              " 'Arizona Christian University',\n",
              " 'Albany College of Pharmacy and Health Sciences',\n",
              " 'Whitworth University',\n",
              " 'Trine University',\n",
              " 'Linfield College-McMinnville Campus',\n",
              " 'Charleston Southern University',\n",
              " 'Massachusetts Maritime Academy',\n",
              " 'Pfeiffer University',\n",
              " 'Bowie State University',\n",
              " \"Saint Mary's University of Minnesota\",\n",
              " 'Louisiana State University and Agricultural & Mechanical College',\n",
              " 'Salisbury University',\n",
              " 'Stony Brook University',\n",
              " 'Embry-Riddle Aeronautical University at Prescott (Ariz.)',\n",
              " 'Thomas More College of Liberal Arts',\n",
              " 'The University of Texas at Arlington',\n",
              " 'University of Pikeville',\n",
              " 'University of Oklahoma-Health Sciences Center',\n",
              " 'Methodist College',\n",
              " 'University of Mary',\n",
              " 'Athens State University',\n",
              " 'University of Memphis',\n",
              " 'Walla Walla University',\n",
              " 'Wright State University',\n",
              " 'University of Alaska Anchorage',\n",
              " 'New Mexico Institute of Mining and Technology',\n",
              " 'Fisk University',\n",
              " 'Texas A&M University at College Station',\n",
              " 'Stanford University',\n",
              " 'Loyola University New Orleans',\n",
              " 'New England Institute of Technology',\n",
              " 'Marian University (Wisconsin)',\n",
              " 'Georgia Southern University',\n",
              " 'Indiana Institute of Technology',\n",
              " 'University of Alaska Fairbanks',\n",
              " 'Adventist University of Health Sciences',\n",
              " 'Thomas College',\n",
              " 'Cameron University',\n",
              " 'Bellarmine University',\n",
              " 'Lenoir-Rhyne University',\n",
              " 'United States Coast Guard Academy',\n",
              " 'Columbia International University',\n",
              " 'San Jose State University',\n",
              " \"Saint Martin's University\",\n",
              " 'The University of Montana',\n",
              " 'United States Merchant Marine Academy',\n",
              " 'Black Hills State University',\n",
              " 'Westminster College (Utah)',\n",
              " 'Quinnipiac University',\n",
              " 'Franklin Pierce University',\n",
              " 'Salve Regina University',\n",
              " 'Menlo College',\n",
              " 'Anderson University (South Carolina)',\n",
              " 'University of Colorado Boulder',\n",
              " 'William Penn University',\n",
              " 'Northwest Nazarene University',\n",
              " 'The Evergreen State College',\n",
              " 'Northwest University',\n",
              " 'University of Central Oklahoma',\n",
              " 'Henderson State University',\n",
              " 'New College of Florida',\n",
              " 'Carroll University',\n",
              " 'The University of Tampa',\n",
              " 'St Catherine University',\n",
              " 'Idaho State University',\n",
              " 'Queens University of Charlotte',\n",
              " 'Jackson State University',\n",
              " 'University of Wisconsin-River Falls',\n",
              " 'University of Maryland Eastern Shore',\n",
              " 'Westminster College (Missouri)',\n",
              " 'Tennessee State University',\n",
              " 'West Virginia University',\n",
              " 'Utah Valley University',\n",
              " 'Lewis & Clark College',\n",
              " 'Bellin College',\n",
              " 'University of West Alabama',\n",
              " 'Lyon College',\n",
              " 'Texas Tech University Health Sciences Center',\n",
              " 'Doane University-Arts & Sciences',\n",
              " 'St Thomas University',\n",
              " 'University of Maine',\n",
              " 'Louisiana State University at Shreveport',\n",
              " 'Arizona State University',\n",
              " 'Bethel University (Minnesota)',\n",
              " 'University of North Carolina School of the Arts',\n",
              " 'Southern Oregon University',\n",
              " 'Louisiana State University Health Sciences Center-New Orleans',\n",
              " 'Northern Kentucky University',\n",
              " 'Tufts University',\n",
              " 'University of Houston',\n",
              " 'University of Wisconsin at Platteville',\n",
              " 'The College of Saint Scholastica',\n",
              " 'Bethany College (Kansas)',\n",
              " 'Columbia College (South Carolina)',\n",
              " 'Dunwoody College of Technology',\n",
              " 'Union University',\n",
              " 'Franklin and Marshall College',\n",
              " 'Amberton University',\n",
              " 'Clayton  State University',\n",
              " 'Embry-Riddle Aeronautical University - Extended Campus',\n",
              " 'Furman',\n",
              " 'Adams State University',\n",
              " 'Southern University at New Orleans',\n",
              " 'Dakota State University',\n",
              " 'Fort Hays State University',\n",
              " 'Drury University',\n",
              " 'University of South Carolina-Upstate',\n",
              " 'Sterling College',\n",
              " 'College for Creative Studies',\n",
              " 'Rust College',\n",
              " 'Babson College',\n",
              " 'DePaul University',\n",
              " \"The University of Virginia's College at Wise\",\n",
              " 'Florida Atlantic University',\n",
              " 'Southern Vermont College',\n",
              " 'Rivier University',\n",
              " 'Southern New Hampshire University',\n",
              " 'University of Jamestown',\n",
              " 'Tulane University of Louisiana',\n",
              " 'Nova Southeastern University',\n",
              " 'Utah State University',\n",
              " 'Saint Norbert College',\n",
              " 'Kettering University',\n",
              " 'Lynn University',\n",
              " 'Hobart William Smith Colleges',\n",
              " 'The University of Alabama',\n",
              " 'Fairmont State University',\n",
              " 'University of Arkansas at Monticello',\n",
              " 'University of North Georgia',\n",
              " 'Colorado School of Mines',\n",
              " 'Ottawa University-Kansas City',\n",
              " 'University of Saint Mary',\n",
              " 'Missouri Western State University',\n",
              " 'MidAmerica Nazarene University',\n",
              " 'Washington University in St Louis',\n",
              " 'Sewanee-The University of the South',\n",
              " 'Wayne State University',\n",
              " 'New Hope Christian College-Eugene',\n",
              " 'University of Massachusetts at Lowell',\n",
              " 'Friends University',\n",
              " 'William Carey University',\n",
              " 'Cardinal Stritch University',\n",
              " 'St Olaf College',\n",
              " 'Eastern Oregon University',\n",
              " 'North Carolina State University',\n",
              " 'University of Science and Arts of Oklahoma',\n",
              " 'Tennessee Technological University',\n",
              " 'Davis & Elkins College',\n",
              " 'Colorado State University at Pueblo',\n",
              " 'University of Minnesota at Crookston',\n",
              " 'Longwood University',\n",
              " 'Nicholls State University',\n",
              " 'United States Naval Academy',\n",
              " 'Alabama A&M University',\n",
              " 'University of Arizona',\n",
              " 'New England College',\n",
              " 'Northeastern State University',\n",
              " 'Miles College',\n",
              " 'Linfield College-Online and Continuing Education',\n",
              " 'University of Wisconsin-Eau Claire',\n",
              " 'Drexel University',\n",
              " \"The King's University\",\n",
              " 'New Mexico State University at Las Cruces',\n",
              " 'Valdosta State University',\n",
              " 'Montana State University -Northern',\n",
              " 'University of Maryland University College',\n",
              " 'Binghamton University',\n",
              " 'University of Baltimore',\n",
              " 'University of Kentucky',\n",
              " 'Midway University',\n",
              " 'Brescia University',\n",
              " 'University of Wisconsin-Parkside',\n",
              " 'Kentucky Christian University',\n",
              " 'University of Missouri at St. Louis',\n",
              " 'Cooper Union for the Advancement of Science and Art',\n",
              " 'Embry-Riddle Aeronautical University at Daytona Beach (Fla.)',\n",
              " 'Wichita State University',\n",
              " 'Castleton University',\n",
              " 'Independence University',\n",
              " 'The University of Tennessee at Martin',\n",
              " 'California State University Maritime Academy',\n",
              " 'Goddard College',\n",
              " 'Southern University and A&M College',\n",
              " 'California Institute of Technology',\n",
              " 'University of Hawaii-West Oahu',\n",
              " 'Thomas Edison State University',\n",
              " 'Alcorn State University',\n",
              " 'Fairleigh Dickinson University-Metropolitan Campus',\n",
              " 'Notre Dame of Maryland University',\n",
              " 'Citadel Military College of South Carolina',\n",
              " 'Lindsey Wilson College',\n",
              " 'Warner Pacific College',\n",
              " 'Northwest Christian University',\n",
              " 'United States Air Force Academy']"
            ]
          },
          "execution_count": 165,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "b2 = main_data.iloc[:,0].values.tolist()\n",
        "remaining2 = list(set(a)-set(b2))\n",
        "remaining2"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8piw5hGCbPYY",
        "outputId": "c6121550-3101-4869-bbb3-2f6b220e8a16"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "185\n",
            "190\n",
            "672\n",
            "588\n",
            "613\n",
            "361\n",
            "844\n",
            "529\n",
            "703\n",
            "108\n",
            "686\n",
            "165\n",
            "422\n",
            "806\n",
            "705\n",
            "255\n",
            "792\n",
            "771\n",
            "724\n",
            "309\n",
            "773\n",
            "831\n",
            "303\n",
            "77\n",
            "234\n",
            "641\n",
            "563\n",
            "787\n",
            "14\n",
            "111\n",
            "608\n",
            "877\n",
            "53\n",
            "751\n",
            "737\n",
            "741\n",
            "574\n",
            "579\n",
            "540\n",
            "553\n",
            "602\n",
            "304\n",
            "566\n",
            "272\n",
            "495\n",
            "147\n",
            "643\n",
            "171\n",
            "269\n",
            "813\n",
            "173\n",
            "345\n",
            "550\n",
            "384\n",
            "557\n",
            "284\n",
            "207\n",
            "715\n",
            "868\n",
            "555\n",
            "408\n",
            "834\n",
            "37\n",
            "897\n",
            "585\n",
            "296\n",
            "5\n",
            "519\n",
            "428\n",
            "1\n",
            "423\n",
            "762\n",
            "833\n",
            "51\n",
            "765\n",
            "68\n",
            "168\n",
            "457\n",
            "245\n",
            "120\n",
            "722\n",
            "782\n",
            "418\n",
            "301\n",
            "169\n",
            "569\n",
            "654\n",
            "825\n",
            "358\n",
            "180\n",
            "381\n",
            "508\n",
            "85\n",
            "730\n",
            "366\n",
            "537\n",
            "115\n",
            "251\n",
            "330\n",
            "798\n",
            "362\n",
            "50\n",
            "903\n",
            "425\n",
            "12\n",
            "896\n",
            "645\n",
            "323\n",
            "233\n",
            "780\n",
            "20\n",
            "6\n",
            "437\n",
            "257\n",
            "268\n",
            "395\n",
            "858\n",
            "512\n",
            "134\n",
            "854\n",
            "509\n",
            "891\n",
            "315\n",
            "498\n",
            "907\n",
            "406\n",
            "573\n",
            "601\n",
            "683\n",
            "438\n",
            "859\n",
            "55\n",
            "513\n",
            "287\n",
            "665\n",
            "33\n",
            "885\n",
            "657\n",
            "352\n",
            "763\n",
            "482\n",
            "317\n",
            "334\n",
            "112\n",
            "363\n",
            "922\n",
            "666\n",
            "692\n",
            "96\n",
            "122\n",
            "931\n",
            "551\n",
            "230\n",
            "11\n",
            "930\n",
            "729\n",
            "176\n",
            "779\n",
            "160\n",
            "532\n",
            "95\n",
            "195\n",
            "902\n",
            "655\n",
            "93\n",
            "908\n",
            "23\n",
            "775\n",
            "41\n",
            "556\n",
            "172\n",
            "318\n",
            "621\n",
            "625\n",
            "514\n",
            "811\n",
            "545\n",
            "819\n",
            "285\n",
            "851\n",
            "183\n",
            "691\n",
            "333\n",
            "225\n",
            "646\n",
            "533\n",
            "662\n",
            "609\n",
            "203\n",
            "502\n",
            "67\n",
            "35\n",
            "34\n",
            "578\n",
            "117\n",
            "293\n",
            "668\n",
            "400\n",
            "302\n",
            "759\n",
            "801\n",
            "417\n",
            "75\n",
            "511\n",
            "900\n",
            "693\n",
            "906\n",
            "87\n",
            "755\n",
            "893\n",
            "505\n",
            "127\n",
            "757\n",
            "211\n",
            "797\n",
            "40\n",
            "817\n",
            "822\n",
            "336\n",
            "163\n",
            "8\n",
            "475\n",
            "465\n",
            "420\n",
            "510\n",
            "103\n",
            "152\n",
            "86\n",
            "781\n",
            "206\n",
            "544\n",
            "89\n",
            "48\n",
            "264\n",
            "179\n",
            "196\n",
            "45\n",
            "342\n",
            "558\n",
            "343\n",
            "631\n",
            "92\n",
            "110\n",
            "355\n",
            "524\n",
            "66\n",
            "476\n",
            "10\n",
            "441\n",
            "445\n",
            "776\n",
            "325\n",
            "97\n",
            "316\n",
            "633\n",
            "653\n",
            "661\n",
            "760\n",
            "348\n",
            "805\n",
            "469\n",
            "63\n",
            "305\n",
            "518\n",
            "714\n",
            "905\n",
            "167\n",
            "282\n",
            "386\n",
            "503\n",
            "720\n",
            "711\n",
            "564\n",
            "659\n",
            "371\n",
            "238\n",
            "485\n",
            "467\n",
            "486\n",
            "232\n",
            "923\n",
            "795\n",
            "489\n",
            "827\n",
            "517\n",
            "747\n",
            "850\n",
            "501\n",
            "448\n",
            "690\n",
            "271\n",
            "744\n",
            "462\n",
            "623\n",
            "170\n",
            "736\n",
            "162\n",
            "124\n",
            "102\n",
            "473\n",
            "43\n",
            "119\n",
            "878\n",
            "240\n",
            "356\n",
            "113\n",
            "567\n",
            "504\n",
            "74\n",
            "404\n",
            "663\n",
            "708\n",
            "883\n",
            "481\n",
            "685\n",
            "814\n",
            "651\n",
            "596\n",
            "539\n",
            "84\n",
            "360\n",
            "927\n",
            "607\n",
            "554\n",
            "19\n",
            "350\n",
            "260\n",
            "562\n",
            "464\n",
            "595\n",
            "449\n",
            "344\n",
            "177\n",
            "561\n",
            "266\n",
            "419\n",
            "300\n",
            "670\n",
            "224\n",
            "889\n",
            "684\n",
            "669\n",
            "52\n",
            "644\n",
            "182\n",
            "374\n",
            "72\n",
            "824\n",
            "321\n",
            "642\n",
            "490\n",
            "424\n",
            "890\n",
            "789\n",
            "676\n",
            "235\n",
            "637\n",
            "731\n",
            "520\n",
            "340\n",
            "365\n",
            "480\n",
            "17\n",
            "886\n",
            "808\n",
            "429\n",
            "331\n",
            "542\n",
            "202\n",
            "699\n",
            "842\n",
            "884\n",
            "478\n",
            "471\n",
            "174\n",
            "894\n",
            "427\n",
            "673\n",
            "496\n",
            "887\n",
            "652\n",
            "58\n",
            "32\n",
            "565\n",
            "882\n",
            "216\n",
            "682\n",
            "748\n",
            "383\n",
            "612\n",
            "368\n",
            "435\n",
            "312\n",
            "369\n",
            "589\n",
            "28\n",
            "525\n",
            "807\n",
            "306\n",
            "650\n",
            "208\n",
            "620\n",
            "15\n",
            "774\n",
            "876\n",
            "647\n",
            "26\n",
            "559\n",
            "777\n",
            "794\n",
            "57\n",
            "319\n",
            "727\n",
            "916\n",
            "155\n",
            "229\n",
            "25\n",
            "136\n",
            "341\n",
            "660\n",
            "288\n",
            "599\n",
            "99\n",
            "756\n",
            "70\n",
            "880\n",
            "493\n",
            "568\n",
            "766\n",
            "821\n",
            "107\n",
            "527\n",
            "726\n",
            "73\n",
            "753\n",
            "81\n",
            "258\n",
            "184\n",
            "888\n",
            "881\n",
            "658\n",
            "44\n",
            "142\n",
            "924\n",
            "131\n",
            "450\n",
            "181\n",
            "598\n",
            "456\n",
            "933\n",
            "372\n",
            "472\n",
            "785\n",
            "892\n",
            "823\n",
            "681\n",
            "914\n",
            "16\n",
            "49\n",
            "799\n",
            "507\n",
            "145\n",
            "338\n",
            "328\n",
            "30\n",
            "446\n",
            "606\n",
            "687\n",
            "314\n",
            "291\n",
            "382\n",
            "800\n",
            "912\n",
            "443\n",
            "283\n",
            "754\n",
            "433\n",
            "778\n",
            "706\n",
            "815\n",
            "164\n",
            "129\n",
            "734\n",
            "94\n",
            "332\n",
            "761\n",
            "276\n",
            "483\n",
            "740\n",
            "277\n",
            "416\n",
            "463\n",
            "379\n",
            "193\n",
            "863\n",
            "133\n",
            "835\n",
            "528\n",
            "531\n",
            "617\n",
            "311\n",
            "137\n",
            "820\n",
            "921\n",
            "401\n",
            "144\n",
            "586\n",
            "2\n",
            "904\n",
            "46\n",
            "156\n",
            "79\n",
            "273\n",
            "265\n",
            "487\n",
            "278\n",
            "466\n",
            "768\n",
            "412\n",
            "695\n",
            "392\n",
            "281\n",
            "459\n",
            "928\n",
            "430\n",
            "694\n",
            "593\n",
            "671\n",
            "772\n",
            "901\n",
            "88\n",
            "444\n",
            "861\n",
            "324\n",
            "351\n",
            "9\n",
            "29\n",
            "526\n",
            "664\n",
            "24\n",
            "680\n",
            "915\n",
            "704\n",
            "793\n",
            "560\n",
            "166\n",
            "497\n",
            "359\n",
            "584\n",
            "370\n",
            "286\n",
            "308\n",
            "295\n",
            "932\n",
            "307\n",
            "474\n",
            "575\n",
            "123\n",
            "267\n",
            "837\n",
            "826\n",
            "784\n",
            "61\n",
            "836\n",
            "326\n",
            "56\n",
            "178\n",
            "546\n",
            "460\n",
            "552\n",
            "373\n",
            "732\n",
            "310\n",
            "689\n",
            "688\n",
            "80\n"
          ]
        }
      ],
      "source": [
        "for i in remaining2: \n",
        "  try: \n",
        "    print(salary[salary['name'] == i].index.tolist()[0])\n",
        "    salary.drop(salary[salary['name'] == i].index.tolist()[0], axis=0,inplace=True)\n",
        "  except:\n",
        "    try: \n",
        "      main_data.drop(main_data[main_data['name'] == i].index.tolist()[0],axis=0,inplace=True)\n",
        "    except: \n",
        "      print(i)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "zgsgi7bibUoR",
        "outputId": "1dc10588-da23-46d9-ebe6-c68571031eff"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-a2b0c226-e479-4040-a3e4-7a1be5da8028\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>rank</th>\n",
              "      <th>name</th>\n",
              "      <th>state_name</th>\n",
              "      <th>early_career_pay</th>\n",
              "      <th>mid_career_pay</th>\n",
              "      <th>make_world_better_percent</th>\n",
              "      <th>stem_percent</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>Auburn University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>54400</td>\n",
              "      <td>104500</td>\n",
              "      <td>51.0</td>\n",
              "      <td>31</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>Tuskegee University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>54500</td>\n",
              "      <td>93500</td>\n",
              "      <td>61.0</td>\n",
              "      <td>30</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>Samford University</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>48400</td>\n",
              "      <td>90500</td>\n",
              "      <td>52.0</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>8</td>\n",
              "      <td>University of Alabama at Birmingham</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>48600</td>\n",
              "      <td>87200</td>\n",
              "      <td>57.0</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>14</td>\n",
              "      <td>Huntingdon College</td>\n",
              "      <td>Alabama</td>\n",
              "      <td>42400</td>\n",
              "      <td>78900</td>\n",
              "      <td>69.0</td>\n",
              "      <td>14</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>920</th>\n",
              "      <td>12</td>\n",
              "      <td>University of Wisconsin at Whitewater</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>48900</td>\n",
              "      <td>89300</td>\n",
              "      <td>44.0</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>925</th>\n",
              "      <td>17</td>\n",
              "      <td>Beloit College</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>47400</td>\n",
              "      <td>85700</td>\n",
              "      <td>59.0</td>\n",
              "      <td>24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>926</th>\n",
              "      <td>18</td>\n",
              "      <td>Carthage College</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>48900</td>\n",
              "      <td>85400</td>\n",
              "      <td>48.0</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>929</th>\n",
              "      <td>20</td>\n",
              "      <td>Wisconsin Lutheran College</td>\n",
              "      <td>Wisconsin</td>\n",
              "      <td>46200</td>\n",
              "      <td>82500</td>\n",
              "      <td>45.0</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>934</th>\n",
              "      <td>1</td>\n",
              "      <td>University of Wyoming</td>\n",
              "      <td>Wyoming</td>\n",
              "      <td>52400</td>\n",
              "      <td>98800</td>\n",
              "      <td>58.0</td>\n",
              "      <td>25</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>359 rows × 7 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a2b0c226-e479-4040-a3e4-7a1be5da8028')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-a2b0c226-e479-4040-a3e4-7a1be5da8028 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-a2b0c226-e479-4040-a3e4-7a1be5da8028');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "     rank                                   name state_name  early_career_pay  \\\n",
              "0       1                      Auburn University    Alabama             54400   \n",
              "3       4                    Tuskegee University    Alabama             54500   \n",
              "4       5                     Samford University    Alabama             48400   \n",
              "7       8    University of Alabama at Birmingham    Alabama             48600   \n",
              "13     14                     Huntingdon College    Alabama             42400   \n",
              "..    ...                                    ...        ...               ...   \n",
              "920    12  University of Wisconsin at Whitewater  Wisconsin             48900   \n",
              "925    17                         Beloit College  Wisconsin             47400   \n",
              "926    18                       Carthage College  Wisconsin             48900   \n",
              "929    20             Wisconsin Lutheran College  Wisconsin             46200   \n",
              "934     1                  University of Wyoming    Wyoming             52400   \n",
              "\n",
              "     mid_career_pay  make_world_better_percent  stem_percent  \n",
              "0            104500                       51.0            31  \n",
              "3             93500                       61.0            30  \n",
              "4             90500                       52.0             3  \n",
              "7             87200                       57.0            17  \n",
              "13            78900                       69.0            14  \n",
              "..              ...                        ...           ...  \n",
              "920           89300                       44.0             8  \n",
              "925           85700                       59.0            24  \n",
              "926           85400                       48.0            17  \n",
              "929           82500                       45.0            10  \n",
              "934           98800                       58.0            25  \n",
              "\n",
              "[359 rows x 7 columns]"
            ]
          },
          "execution_count": 167,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "salary"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "voQ-2JdodZlO",
        "outputId": "ecf01282-f538-4b4f-e29e-383ec068b30a"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "1"
            ]
          },
          "execution_count": 168,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "\n",
        "a3 = salary.iloc[:,1].values.tolist()\n",
        "b3 = main_data.iloc[:,0].values.tolist()\n",
        "final_remaining = list(set(a3)-set(b3))\n",
        "len(final_remaining)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "Z0jruvadfd_F",
        "outputId": "5ac3ebef-8b18-4494-fa94-d0e36c24c5b0"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-d363a3f6-f8fe-4eb9-80a4-96cbcf4e49a7\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>Private</th>\n",
              "      <th>Apps</th>\n",
              "      <th>Accept</th>\n",
              "      <th>Enroll</th>\n",
              "      <th>Top10perc</th>\n",
              "      <th>Top25perc</th>\n",
              "      <th>F.Undergrad</th>\n",
              "      <th>P.Undergrad</th>\n",
              "      <th>Outstate</th>\n",
              "      <th>Room.Board</th>\n",
              "      <th>Books</th>\n",
              "      <th>Personal</th>\n",
              "      <th>PhD</th>\n",
              "      <th>Terminal</th>\n",
              "      <th>S.F.Ratio</th>\n",
              "      <th>perc.alumni</th>\n",
              "      <th>Expend</th>\n",
              "      <th>Grad.Rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Agnes Scott College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>417</td>\n",
              "      <td>349</td>\n",
              "      <td>137</td>\n",
              "      <td>60</td>\n",
              "      <td>89</td>\n",
              "      <td>510</td>\n",
              "      <td>63</td>\n",
              "      <td>12960</td>\n",
              "      <td>5450</td>\n",
              "      <td>450</td>\n",
              "      <td>875</td>\n",
              "      <td>92</td>\n",
              "      <td>97</td>\n",
              "      <td>7.7</td>\n",
              "      <td>37</td>\n",
              "      <td>19016</td>\n",
              "      <td>59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Alaska Pacific University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>193</td>\n",
              "      <td>146</td>\n",
              "      <td>55</td>\n",
              "      <td>16</td>\n",
              "      <td>44</td>\n",
              "      <td>249</td>\n",
              "      <td>869</td>\n",
              "      <td>7560</td>\n",
              "      <td>4120</td>\n",
              "      <td>800</td>\n",
              "      <td>1500</td>\n",
              "      <td>76</td>\n",
              "      <td>72</td>\n",
              "      <td>11.9</td>\n",
              "      <td>2</td>\n",
              "      <td>10922</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Albertus Magnus College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>353</td>\n",
              "      <td>340</td>\n",
              "      <td>103</td>\n",
              "      <td>17</td>\n",
              "      <td>45</td>\n",
              "      <td>416</td>\n",
              "      <td>230</td>\n",
              "      <td>13290</td>\n",
              "      <td>5720</td>\n",
              "      <td>500</td>\n",
              "      <td>1500</td>\n",
              "      <td>90</td>\n",
              "      <td>93</td>\n",
              "      <td>11.5</td>\n",
              "      <td>26</td>\n",
              "      <td>8861</td>\n",
              "      <td>63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Albion College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1899</td>\n",
              "      <td>1720</td>\n",
              "      <td>489</td>\n",
              "      <td>37</td>\n",
              "      <td>68</td>\n",
              "      <td>1594</td>\n",
              "      <td>32</td>\n",
              "      <td>13868</td>\n",
              "      <td>4826</td>\n",
              "      <td>450</td>\n",
              "      <td>850</td>\n",
              "      <td>89</td>\n",
              "      <td>100</td>\n",
              "      <td>13.7</td>\n",
              "      <td>37</td>\n",
              "      <td>11487</td>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Alma College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1267</td>\n",
              "      <td>1080</td>\n",
              "      <td>385</td>\n",
              "      <td>44</td>\n",
              "      <td>73</td>\n",
              "      <td>1306</td>\n",
              "      <td>28</td>\n",
              "      <td>12572</td>\n",
              "      <td>4552</td>\n",
              "      <td>400</td>\n",
              "      <td>400</td>\n",
              "      <td>79</td>\n",
              "      <td>87</td>\n",
              "      <td>15.3</td>\n",
              "      <td>32</td>\n",
              "      <td>9305</td>\n",
              "      <td>68</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>770</th>\n",
              "      <td>Wofford College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1501</td>\n",
              "      <td>935</td>\n",
              "      <td>273</td>\n",
              "      <td>51</td>\n",
              "      <td>83</td>\n",
              "      <td>1059</td>\n",
              "      <td>34</td>\n",
              "      <td>12680</td>\n",
              "      <td>4150</td>\n",
              "      <td>605</td>\n",
              "      <td>1440</td>\n",
              "      <td>91</td>\n",
              "      <td>92</td>\n",
              "      <td>15.3</td>\n",
              "      <td>42</td>\n",
              "      <td>7875</td>\n",
              "      <td>75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>771</th>\n",
              "      <td>Worcester Polytechnic Institute</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2768</td>\n",
              "      <td>2314</td>\n",
              "      <td>682</td>\n",
              "      <td>49</td>\n",
              "      <td>86</td>\n",
              "      <td>2802</td>\n",
              "      <td>86</td>\n",
              "      <td>15884</td>\n",
              "      <td>5370</td>\n",
              "      <td>530</td>\n",
              "      <td>730</td>\n",
              "      <td>92</td>\n",
              "      <td>94</td>\n",
              "      <td>15.2</td>\n",
              "      <td>34</td>\n",
              "      <td>10774</td>\n",
              "      <td>82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>773</th>\n",
              "      <td>Xavier University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1959</td>\n",
              "      <td>1805</td>\n",
              "      <td>695</td>\n",
              "      <td>24</td>\n",
              "      <td>47</td>\n",
              "      <td>2849</td>\n",
              "      <td>1107</td>\n",
              "      <td>11520</td>\n",
              "      <td>4960</td>\n",
              "      <td>600</td>\n",
              "      <td>1250</td>\n",
              "      <td>73</td>\n",
              "      <td>75</td>\n",
              "      <td>13.3</td>\n",
              "      <td>31</td>\n",
              "      <td>9189</td>\n",
              "      <td>83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>774</th>\n",
              "      <td>Xavier University of Louisiana</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2097</td>\n",
              "      <td>1915</td>\n",
              "      <td>695</td>\n",
              "      <td>34</td>\n",
              "      <td>61</td>\n",
              "      <td>2793</td>\n",
              "      <td>166</td>\n",
              "      <td>6900</td>\n",
              "      <td>4200</td>\n",
              "      <td>617</td>\n",
              "      <td>781</td>\n",
              "      <td>67</td>\n",
              "      <td>75</td>\n",
              "      <td>14.4</td>\n",
              "      <td>20</td>\n",
              "      <td>8323</td>\n",
              "      <td>49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>775</th>\n",
              "      <td>Yale University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>10705</td>\n",
              "      <td>2453</td>\n",
              "      <td>1317</td>\n",
              "      <td>95</td>\n",
              "      <td>99</td>\n",
              "      <td>5217</td>\n",
              "      <td>83</td>\n",
              "      <td>19840</td>\n",
              "      <td>6510</td>\n",
              "      <td>630</td>\n",
              "      <td>2115</td>\n",
              "      <td>96</td>\n",
              "      <td>96</td>\n",
              "      <td>5.8</td>\n",
              "      <td>49</td>\n",
              "      <td>40386</td>\n",
              "      <td>99</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>358 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d363a3f6-f8fe-4eb9-80a4-96cbcf4e49a7')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-d363a3f6-f8fe-4eb9-80a4-96cbcf4e49a7 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-d363a3f6-f8fe-4eb9-80a4-96cbcf4e49a7');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "                                name Private   Apps  Accept  Enroll  \\\n",
              "3                Agnes Scott College     Yes    417     349     137   \n",
              "4          Alaska Pacific University     Yes    193     146      55   \n",
              "6            Albertus Magnus College     Yes    353     340     103   \n",
              "7                     Albion College     Yes   1899    1720     489   \n",
              "13                      Alma College     Yes   1267    1080     385   \n",
              "..                               ...     ...    ...     ...     ...   \n",
              "770                  Wofford College     Yes   1501     935     273   \n",
              "771  Worcester Polytechnic Institute     Yes   2768    2314     682   \n",
              "773                Xavier University     Yes   1959    1805     695   \n",
              "774   Xavier University of Louisiana     Yes   2097    1915     695   \n",
              "775                  Yale University     Yes  10705    2453    1317   \n",
              "\n",
              "     Top10perc  Top25perc  F.Undergrad  P.Undergrad  Outstate  Room.Board  \\\n",
              "3           60         89          510           63     12960        5450   \n",
              "4           16         44          249          869      7560        4120   \n",
              "6           17         45          416          230     13290        5720   \n",
              "7           37         68         1594           32     13868        4826   \n",
              "13          44         73         1306           28     12572        4552   \n",
              "..         ...        ...          ...          ...       ...         ...   \n",
              "770         51         83         1059           34     12680        4150   \n",
              "771         49         86         2802           86     15884        5370   \n",
              "773         24         47         2849         1107     11520        4960   \n",
              "774         34         61         2793          166      6900        4200   \n",
              "775         95         99         5217           83     19840        6510   \n",
              "\n",
              "     Books  Personal  PhD  Terminal  S.F.Ratio  perc.alumni  Expend  Grad.Rate  \n",
              "3      450       875   92        97        7.7           37   19016         59  \n",
              "4      800      1500   76        72       11.9            2   10922         15  \n",
              "6      500      1500   90        93       11.5           26    8861         63  \n",
              "7      450       850   89       100       13.7           37   11487         73  \n",
              "13     400       400   79        87       15.3           32    9305         68  \n",
              "..     ...       ...  ...       ...        ...          ...     ...        ...  \n",
              "770    605      1440   91        92       15.3           42    7875         75  \n",
              "771    530       730   92        94       15.2           34   10774         82  \n",
              "773    600      1250   73        75       13.3           31    9189         83  \n",
              "774    617       781   67        75       14.4           20    8323         49  \n",
              "775    630      2115   96        96        5.8           49   40386         99  \n",
              "\n",
              "[358 rows x 19 columns]"
            ]
          },
          "execution_count": 169,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "main_data.sort_values('name')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "EMhnUpc5hMuo"
      },
      "outputs": [],
      "source": [
        "salary = salary.sort_values('name')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "QtRFRyKqhWja",
        "outputId": "13ddf379-f54f-4eb9-a824-2773368f59d9"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-c93d9fb5-b014-4346-8bc0-d7cf2f31aefe\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>name</th>\n",
              "      <th>Private</th>\n",
              "      <th>Apps</th>\n",
              "      <th>Accept</th>\n",
              "      <th>Enroll</th>\n",
              "      <th>Top10perc</th>\n",
              "      <th>Top25perc</th>\n",
              "      <th>F.Undergrad</th>\n",
              "      <th>P.Undergrad</th>\n",
              "      <th>Outstate</th>\n",
              "      <th>Room.Board</th>\n",
              "      <th>Books</th>\n",
              "      <th>Personal</th>\n",
              "      <th>PhD</th>\n",
              "      <th>Terminal</th>\n",
              "      <th>S.F.Ratio</th>\n",
              "      <th>perc.alumni</th>\n",
              "      <th>Expend</th>\n",
              "      <th>Grad.Rate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Agnes Scott College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>417</td>\n",
              "      <td>349</td>\n",
              "      <td>137</td>\n",
              "      <td>60</td>\n",
              "      <td>89</td>\n",
              "      <td>510</td>\n",
              "      <td>63</td>\n",
              "      <td>12960</td>\n",
              "      <td>5450</td>\n",
              "      <td>450</td>\n",
              "      <td>875</td>\n",
              "      <td>92</td>\n",
              "      <td>97</td>\n",
              "      <td>7.7</td>\n",
              "      <td>37</td>\n",
              "      <td>19016</td>\n",
              "      <td>59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Alaska Pacific University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>193</td>\n",
              "      <td>146</td>\n",
              "      <td>55</td>\n",
              "      <td>16</td>\n",
              "      <td>44</td>\n",
              "      <td>249</td>\n",
              "      <td>869</td>\n",
              "      <td>7560</td>\n",
              "      <td>4120</td>\n",
              "      <td>800</td>\n",
              "      <td>1500</td>\n",
              "      <td>76</td>\n",
              "      <td>72</td>\n",
              "      <td>11.9</td>\n",
              "      <td>2</td>\n",
              "      <td>10922</td>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Albertus Magnus College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>353</td>\n",
              "      <td>340</td>\n",
              "      <td>103</td>\n",
              "      <td>17</td>\n",
              "      <td>45</td>\n",
              "      <td>416</td>\n",
              "      <td>230</td>\n",
              "      <td>13290</td>\n",
              "      <td>5720</td>\n",
              "      <td>500</td>\n",
              "      <td>1500</td>\n",
              "      <td>90</td>\n",
              "      <td>93</td>\n",
              "      <td>11.5</td>\n",
              "      <td>26</td>\n",
              "      <td>8861</td>\n",
              "      <td>63</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Albion College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1899</td>\n",
              "      <td>1720</td>\n",
              "      <td>489</td>\n",
              "      <td>37</td>\n",
              "      <td>68</td>\n",
              "      <td>1594</td>\n",
              "      <td>32</td>\n",
              "      <td>13868</td>\n",
              "      <td>4826</td>\n",
              "      <td>450</td>\n",
              "      <td>850</td>\n",
              "      <td>89</td>\n",
              "      <td>100</td>\n",
              "      <td>13.7</td>\n",
              "      <td>37</td>\n",
              "      <td>11487</td>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Alma College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1267</td>\n",
              "      <td>1080</td>\n",
              "      <td>385</td>\n",
              "      <td>44</td>\n",
              "      <td>73</td>\n",
              "      <td>1306</td>\n",
              "      <td>28</td>\n",
              "      <td>12572</td>\n",
              "      <td>4552</td>\n",
              "      <td>400</td>\n",
              "      <td>400</td>\n",
              "      <td>79</td>\n",
              "      <td>87</td>\n",
              "      <td>15.3</td>\n",
              "      <td>32</td>\n",
              "      <td>9305</td>\n",
              "      <td>68</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>770</th>\n",
              "      <td>Wofford College</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1501</td>\n",
              "      <td>935</td>\n",
              "      <td>273</td>\n",
              "      <td>51</td>\n",
              "      <td>83</td>\n",
              "      <td>1059</td>\n",
              "      <td>34</td>\n",
              "      <td>12680</td>\n",
              "      <td>4150</td>\n",
              "      <td>605</td>\n",
              "      <td>1440</td>\n",
              "      <td>91</td>\n",
              "      <td>92</td>\n",
              "      <td>15.3</td>\n",
              "      <td>42</td>\n",
              "      <td>7875</td>\n",
              "      <td>75</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>771</th>\n",
              "      <td>Worcester Polytechnic Institute</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2768</td>\n",
              "      <td>2314</td>\n",
              "      <td>682</td>\n",
              "      <td>49</td>\n",
              "      <td>86</td>\n",
              "      <td>2802</td>\n",
              "      <td>86</td>\n",
              "      <td>15884</td>\n",
              "      <td>5370</td>\n",
              "      <td>530</td>\n",
              "      <td>730</td>\n",
              "      <td>92</td>\n",
              "      <td>94</td>\n",
              "      <td>15.2</td>\n",
              "      <td>34</td>\n",
              "      <td>10774</td>\n",
              "      <td>82</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>773</th>\n",
              "      <td>Xavier University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1959</td>\n",
              "      <td>1805</td>\n",
              "      <td>695</td>\n",
              "      <td>24</td>\n",
              "      <td>47</td>\n",
              "      <td>2849</td>\n",
              "      <td>1107</td>\n",
              "      <td>11520</td>\n",
              "      <td>4960</td>\n",
              "      <td>600</td>\n",
              "      <td>1250</td>\n",
              "      <td>73</td>\n",
              "      <td>75</td>\n",
              "      <td>13.3</td>\n",
              "      <td>31</td>\n",
              "      <td>9189</td>\n",
              "      <td>83</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>774</th>\n",
              "      <td>Xavier University of Louisiana</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2097</td>\n",
              "      <td>1915</td>\n",
              "      <td>695</td>\n",
              "      <td>34</td>\n",
              "      <td>61</td>\n",
              "      <td>2793</td>\n",
              "      <td>166</td>\n",
              "      <td>6900</td>\n",
              "      <td>4200</td>\n",
              "      <td>617</td>\n",
              "      <td>781</td>\n",
              "      <td>67</td>\n",
              "      <td>75</td>\n",
              "      <td>14.4</td>\n",
              "      <td>20</td>\n",
              "      <td>8323</td>\n",
              "      <td>49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>775</th>\n",
              "      <td>Yale University</td>\n",
              "      <td>Yes</td>\n",
              "      <td>10705</td>\n",
              "      <td>2453</td>\n",
              "      <td>1317</td>\n",
              "      <td>95</td>\n",
              "      <td>99</td>\n",
              "      <td>5217</td>\n",
              "      <td>83</td>\n",
              "      <td>19840</td>\n",
              "      <td>6510</td>\n",
              "      <td>630</td>\n",
              "      <td>2115</td>\n",
              "      <td>96</td>\n",
              "      <td>96</td>\n",
              "      <td>5.8</td>\n",
              "      <td>49</td>\n",
              "      <td>40386</td>\n",
              "      <td>99</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>358 rows × 19 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c93d9fb5-b014-4346-8bc0-d7cf2f31aefe')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c93d9fb5-b014-4346-8bc0-d7cf2f31aefe button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c93d9fb5-b014-4346-8bc0-d7cf2f31aefe');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "                                name Private   Apps  Accept  Enroll  \\\n",
              "3                Agnes Scott College     Yes    417     349     137   \n",
              "4          Alaska Pacific University     Yes    193     146      55   \n",
              "6            Albertus Magnus College     Yes    353     340     103   \n",
              "7                     Albion College     Yes   1899    1720     489   \n",
              "13                      Alma College     Yes   1267    1080     385   \n",
              "..                               ...     ...    ...     ...     ...   \n",
              "770                  Wofford College     Yes   1501     935     273   \n",
              "771  Worcester Polytechnic Institute     Yes   2768    2314     682   \n",
              "773                Xavier University     Yes   1959    1805     695   \n",
              "774   Xavier University of Louisiana     Yes   2097    1915     695   \n",
              "775                  Yale University     Yes  10705    2453    1317   \n",
              "\n",
              "     Top10perc  Top25perc  F.Undergrad  P.Undergrad  Outstate  Room.Board  \\\n",
              "3           60         89          510           63     12960        5450   \n",
              "4           16         44          249          869      7560        4120   \n",
              "6           17         45          416          230     13290        5720   \n",
              "7           37         68         1594           32     13868        4826   \n",
              "13          44         73         1306           28     12572        4552   \n",
              "..         ...        ...          ...          ...       ...         ...   \n",
              "770         51         83         1059           34     12680        4150   \n",
              "771         49         86         2802           86     15884        5370   \n",
              "773         24         47         2849         1107     11520        4960   \n",
              "774         34         61         2793          166      6900        4200   \n",
              "775         95         99         5217           83     19840        6510   \n",
              "\n",
              "     Books  Personal  PhD  Terminal  S.F.Ratio  perc.alumni  Expend  Grad.Rate  \n",
              "3      450       875   92        97        7.7           37   19016         59  \n",
              "4      800      1500   76        72       11.9            2   10922         15  \n",
              "6      500      1500   90        93       11.5           26    8861         63  \n",
              "7      450       850   89       100       13.7           37   11487         73  \n",
              "13     400       400   79        87       15.3           32    9305         68  \n",
              "..     ...       ...  ...       ...        ...          ...     ...        ...  \n",
              "770    605      1440   91        92       15.3           42    7875         75  \n",
              "771    530       730   92        94       15.2           34   10774         82  \n",
              "773    600      1250   73        75       13.3           31    9189         83  \n",
              "774    617       781   67        75       14.4           20    8323         49  \n",
              "775    630      2115   96        96        5.8           49   40386         99  \n",
              "\n",
              "[358 rows x 19 columns]"
            ]
          },
          "execution_count": 171,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "main_data\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 765
        },
        "id": "HRnRsJtglLkH",
        "outputId": "3c4b651d-09bf-47e3-d668-dadd11ff74d9"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-f7d28895-8d00-4aa5-ac97-e65658fa028b\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>rank</th>\n",
              "      <th>name</th>\n",
              "      <th>state_name</th>\n",
              "      <th>early_career_pay</th>\n",
              "      <th>mid_career_pay</th>\n",
              "      <th>make_world_better_percent</th>\n",
              "      <th>stem_percent</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>14</td>\n",
              "      <td>Agnes Scott College</td>\n",
              "      <td>Georgia</td>\n",
              "      <td>46000</td>\n",
              "      <td>83600</td>\n",
              "      <td>57.0</td>\n",
              "      <td>26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>3</td>\n",
              "      <td>Alaska Pacific University</td>\n",
              "      <td>Alaska</td>\n",
              "      <td>50300</td>\n",
              "      <td>90000</td>\n",
              "      <td>67.0</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>116</th>\n",
              "      <td>18</td>\n",
              "      <td>Albertus Magnus College</td>\n",
              "      <td>Connecticut</td>\n",
              "      <td>49700</td>\n",
              "      <td>85900</td>\n",
              "      <td>62.0</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>407</th>\n",
              "      <td>7</td>\n",
              "      <td>Albion College</td>\n",
              "      <td>Michigan</td>\n",
              "      <td>52100</td>\n",
              "      <td>99300</td>\n",
              "      <td>44.0</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>415</th>\n",
              "      <td>15</td>\n",
              "      <td>Alma College</td>\n",
              "      <td>Michigan</td>\n",
              "      <td>48400</td>\n",
              "      <td>89900</td>\n",
              "      <td>52.0</td>\n",
              "      <td>15</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>735</th>\n",
              "      <td>4</td>\n",
              "      <td>Wofford College</td>\n",
              "      <td>South Carolina</td>\n",
              "      <td>51300</td>\n",
              "      <td>96600</td>\n",
              "      <td>51.0</td>\n",
              "      <td>28</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>378</th>\n",
              "      <td>3</td>\n",
              "      <td>Worcester Polytechnic Institute</td>\n",
              "      <td>Massachusetts</td>\n",
              "      <td>73600</td>\n",
              "      <td>135500</td>\n",
              "      <td>47.0</td>\n",
              "      <td>86</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>639</th>\n",
              "      <td>16</td>\n",
              "      <td>Xavier University</td>\n",
              "      <td>Ohio</td>\n",
              "      <td>51800</td>\n",
              "      <td>94000</td>\n",
              "      <td>46.0</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>322</th>\n",
              "      <td>11</td>\n",
              "      <td>Xavier University of Louisiana</td>\n",
              "      <td>Louisiana</td>\n",
              "      <td>46700</td>\n",
              "      <td>88200</td>\n",
              "      <td>63.0</td>\n",
              "      <td>35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>1</td>\n",
              "      <td>Yale University</td>\n",
              "      <td>Connecticut</td>\n",
              "      <td>70300</td>\n",
              "      <td>138300</td>\n",
              "      <td>53.0</td>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>359 rows × 7 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f7d28895-8d00-4aa5-ac97-e65658fa028b')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f7d28895-8d00-4aa5-ac97-e65658fa028b button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f7d28895-8d00-4aa5-ac97-e65658fa028b');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "     rank                             name      state_name  early_career_pay  \\\n",
              "161    14              Agnes Scott College         Georgia             46000   \n",
              "27      3        Alaska Pacific University          Alaska             50300   \n",
              "116    18          Albertus Magnus College     Connecticut             49700   \n",
              "407     7                   Albion College        Michigan             52100   \n",
              "415    15                     Alma College        Michigan             48400   \n",
              "..    ...                              ...             ...               ...   \n",
              "735     4                  Wofford College  South Carolina             51300   \n",
              "378     3  Worcester Polytechnic Institute   Massachusetts             73600   \n",
              "639    16                Xavier University            Ohio             51800   \n",
              "322    11   Xavier University of Louisiana       Louisiana             46700   \n",
              "98      1                  Yale University     Connecticut             70300   \n",
              "\n",
              "     mid_career_pay  make_world_better_percent  stem_percent  \n",
              "161           83600                       57.0            26  \n",
              "27            90000                       67.0             6  \n",
              "116           85900                       62.0             2  \n",
              "407           99300                       44.0            23  \n",
              "415           89900                       52.0            15  \n",
              "..              ...                        ...           ...  \n",
              "735           96600                       51.0            28  \n",
              "378          135500                       47.0            86  \n",
              "639           94000                       46.0             7  \n",
              "322           88200                       63.0            35  \n",
              "98           138300                       53.0            22  \n",
              "\n",
              "[359 rows x 7 columns]"
            ]
          },
          "execution_count": 172,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "salary\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "t9oNBEQxlTi3"
      },
      "outputs": [],
      "source": [
        "main_data.to_csv('/content/drive/MyDrive/boilermake2023/data/main_data.csv', index=False)\n",
        "salary.to_csv('/content/drive/MyDrive/boilermake2023/data/salary_data.csv', index=False)\n",
        "\n",
        "diversity = pd.read_csv(\"/content/drive/MyDrive/boilermake2023/data/cleaned_diversity_school.csv\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "pPZDjKl_mZnG"
      },
      "outputs": [],
      "source": [
        "result = pd.merge(main_data, salary, how=\"left\", on=['name'])\n",
        "final_result = pd.merge(result, diversity, how=\"left\", on=['name'])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "faWC0u8Dm_4Q"
      },
      "outputs": [],
      "source": [
        "final_result.to_csv(\"/content/drive/MyDrive/boilermake2023/data/3dfsMerged.csv\", index=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 227
        },
        "id": "by_S3qw4ntup",
        "outputId": "60b90fdc-a25e-49a0-841c-32ed29418358"
      },
      "outputs": [
        {
          "ename": "UnicodeDecodeError",
          "evalue": "ignored",
          "output_type": "error",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mUnicodeDecodeError\u001b[0m                        Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-145-fd290376f8bd>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mtest\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"/content/finalcollegenames.csv\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    309\u001b[0m                     \u001b[0mstacklevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mstacklevel\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    310\u001b[0m                 )\n\u001b[0;32m--> 311\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    312\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    313\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mwrapper\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36mread_csv\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)\u001b[0m\n\u001b[1;32m    584\u001b[0m     \u001b[0mkwds\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkwds_defaults\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    585\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 586\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    587\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    588\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    480\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    481\u001b[0m     \u001b[0;31m# Create the parser.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 482\u001b[0;31m     \u001b[0mparser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    483\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    484\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[1;32m    809\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"has_index_names\"\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"has_index_names\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    810\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 811\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    812\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    813\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/io/parsers/readers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[0;34m(self, engine)\u001b[0m\n\u001b[1;32m   1038\u001b[0m             )\n\u001b[1;32m   1039\u001b[0m         \u001b[0;31m# error: Too many arguments for \"ParserBase\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1040\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mmapping\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m)\u001b[0m  \u001b[0;31m# type: ignore[call-arg]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1041\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1042\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_failover_to_python\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/io/parsers/c_parser_wrapper.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, src, **kwds)\u001b[0m\n\u001b[1;32m     67\u001b[0m         \u001b[0mkwds\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"dtype\"\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mensure_dtype_objs\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"dtype\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     68\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 69\u001b[0;31m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mparsers\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mTextReader\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhandles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhandle\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     70\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mException\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     71\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhandles\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.__cinit__\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._get_header\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._tokenize_rows\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.8/dist-packages/pandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.raise_parser_error\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;31mUnicodeDecodeError\u001b[0m: 'utf-8' codec can't decode byte 0xed in position 165467: invalid continuation byte"
          ]
        }
      ],
      "source": [
        "test = pd.read_csv(\"/content/finalcollegenames.csv\", encoding=\"\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "4yApt0dXAwAP"
      },
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "colab": {
      "include_colab_link": true,
      "provenance": []
    },
    "kernelspec": {
      "display_name": "homl3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "name": "python",
      "version": "3.10.8 | packaged by conda-forge | (main, Nov 22 2022, 08:26:04) [GCC 10.4.0]"
    },
    "vscode": {
      "interpreter": {
        "hash": "cb11495483f8bc9329e70cd93d4d6000fab5e0ef74cd85abb85772776aaa6b42"
      }
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}