degree plan course table creation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "catalog_file = 'data/DATA LABELED LINK.csv'\n",
    "all_courses_file = 'course codes.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "catalog = pd.read_csv(catalog_file)\n",
    "all_courses = pd.read_csv(all_courses_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "catalog['Updated File Name'] = 'updated ' + catalog['Course File Name']\n",
    "main_table = pd.DataFrame(catalog[['Title','Updated File Name']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['COMM 1311', 'RHET 1302', 'MATH 1306', ..., 'MATH 3303',\n",
       "       'MATH 3305', 'MATH 3307'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cols = all_courses.to_numpy().flatten()\n",
    "# pd.concat([main_table, pd.Series(cols)])\n",
    "cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Updated File Name</th>\n",
       "      <th>Count</th>\n",
       "      <th>COMM 1311</th>\n",
       "      <th>RHET 1302</th>\n",
       "      <th>MATH 1306</th>\n",
       "      <th>MATH 1314</th>\n",
       "      <th>AMS 2300</th>\n",
       "      <th>AMS 2341</th>\n",
       "      <th>HUMA 1301</th>\n",
       "      <th>...</th>\n",
       "      <th>ECON 4362</th>\n",
       "      <th>ECON 4382</th>\n",
       "      <th>PSCI 4354</th>\n",
       "      <th>PSCI 4V99</th>\n",
       "      <th>PSCI 3327</th>\n",
       "      <th>PSCI 4364</th>\n",
       "      <th>MATH 2312</th>\n",
       "      <th>MATH 3303</th>\n",
       "      <th>MATH 3305</th>\n",
       "      <th>MATH 3307</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bachelor of Arts in American Studies</td>\n",
       "      <td>updated courses/Bachelor of Arts in American S...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bachelor of Science in Healthcare Studies</td>\n",
       "      <td>updated courses/Bachelor of Science in Healthc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bachelor of Arts and Bachelor of Science in In...</td>\n",
       "      <td>updated courses/Bachelor of Arts and Bachelor ...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bachelor of Arts in Arts, Technology, and Emer...</td>\n",
       "      <td>updated courses/Bachelor of Arts in Arts, Tech...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bachelor of Science in Cognitive Science</td>\n",
       "      <td>updated courses/Bachelor of Science in Cogniti...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>136</th>\n",
       "      <td>Master of Arts in Visual and Performing Arts</td>\n",
       "      <td>updated courses/Master of Arts in Visual and P...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Doctor of Philosophy in Visual and Performing ...</td>\n",
       "      <td>updated courses/Doctor of Philosophy in Visual...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Master of Science in Leadership and Organizati...</td>\n",
       "      <td>updated courses/Master of Science in Leadershi...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Bachelor of Science in Business Analytics</td>\n",
       "      <td>updated courses/Bachelor of Science in Busines...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>School of Interdisciplinary Studies</td>\n",
       "      <td>updated courses/School of Interdisciplinary St...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 2113 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "0                 Bachelor of Arts in American Studies   \n",
       "1            Bachelor of Science in Healthcare Studies   \n",
       "2    Bachelor of Arts and Bachelor of Science in In...   \n",
       "3    Bachelor of Arts in Arts, Technology, and Emer...   \n",
       "4             Bachelor of Science in Cognitive Science   \n",
       "..                                                 ...   \n",
       "136       Master of Arts in Visual and Performing Arts   \n",
       "137  Doctor of Philosophy in Visual and Performing ...   \n",
       "138  Master of Science in Leadership and Organizati...   \n",
       "139          Bachelor of Science in Business Analytics   \n",
       "140                School of Interdisciplinary Studies   \n",
       "\n",
       "                                     Updated File Name  Count  COMM 1311  \\\n",
       "0    updated courses/Bachelor of Arts in American S...    0.0        0.0   \n",
       "1    updated courses/Bachelor of Science in Healthc...    0.0        0.0   \n",
       "2    updated courses/Bachelor of Arts and Bachelor ...    0.0        0.0   \n",
       "3    updated courses/Bachelor of Arts in Arts, Tech...    0.0        0.0   \n",
       "4    updated courses/Bachelor of Science in Cogniti...    0.0        0.0   \n",
       "..                                                 ...    ...        ...   \n",
       "136  updated courses/Master of Arts in Visual and P...    0.0        0.0   \n",
       "137  updated courses/Doctor of Philosophy in Visual...    0.0        0.0   \n",
       "138  updated courses/Master of Science in Leadershi...    0.0        0.0   \n",
       "139  updated courses/Bachelor of Science in Busines...    0.0        0.0   \n",
       "140  updated courses/School of Interdisciplinary St...    0.0        0.0   \n",
       "\n",
       "     RHET 1302  MATH 1306  MATH 1314  AMS 2300  AMS 2341  HUMA 1301  ...  \\\n",
       "0          0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "1          0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "2          0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "3          0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "4          0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "..         ...        ...        ...       ...       ...        ...  ...   \n",
       "136        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "137        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "138        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "139        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "140        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "\n",
       "     ECON 4362  ECON 4382  PSCI 4354  PSCI 4V99  PSCI 3327  PSCI 4364  \\\n",
       "0          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "1          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "2          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "3          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "4          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "..         ...        ...        ...        ...        ...        ...   \n",
       "136        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "137        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "138        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "139        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "140        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "\n",
       "     MATH 2312  MATH 3303  MATH 3305  MATH 3307  \n",
       "0          0.0        0.0        0.0        0.0  \n",
       "1          0.0        0.0        0.0        0.0  \n",
       "2          0.0        0.0        0.0        0.0  \n",
       "3          0.0        0.0        0.0        0.0  \n",
       "4          0.0        0.0        0.0        0.0  \n",
       "..         ...        ...        ...        ...  \n",
       "136        0.0        0.0        0.0        0.0  \n",
       "137        0.0        0.0        0.0        0.0  \n",
       "138        0.0        0.0        0.0        0.0  \n",
       "139        0.0        0.0        0.0        0.0  \n",
       "140        0.0        0.0        0.0        0.0  \n",
       "\n",
       "[141 rows x 2113 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_table = catalog.reindex(columns=['Title', 'Updated File Name'] + ['Count'] + cols.tolist())\n",
    "main_table = main_table.fillna(0)\n",
    "main_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "updated courses/Bachelor of Arts in Arts, Technology, and Emerging Communication.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts / Bachelor of Science in International Political Economy.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts in Visual and Performing Arts.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts / Bachelor of Science in Chemistry.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts / Bachelor of Science in Mathematics.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts / Bachelor of Science in Physics.csv did not read any inputs.\n",
      "updated courses/Bachelor of Science in Data Science.csv did not read any inputs.\n",
      "updated courses/Bachelor of Science in Data Science.csv did not read any inputs.\n",
      "updated courses/Master of Science in Speech-Language Pathology.csv did not read any inputs.\n",
      "updated courses/Master of Arts in Interdisciplinary Studies.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts / Bachelor of Science in Economics.csv did not read any inputs.\n",
      "updated courses/Bachelor of Arts / Bachelor of Science in Biology.csv did not read any inputs.\n",
      "updated courses/Master of Science in Leadership and Organizational Development.csv did not read any inputs.\n"
     ]
    }
   ],
   "source": [
    "for i, file_name in enumerate(main_table['Updated File Name']):\n",
    "    count = 0\n",
    "    try:\n",
    "        for c in pd.read_csv(file_name)['Course Code']:\n",
    "            main_table.loc[i, c] = 1\n",
    "            count += 1\n",
    "    except:\n",
    "        print(file_name + ' did not read any inputs.')\n",
    "    main_table.loc[i, 'Count'] = count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Updated File Name</th>\n",
       "      <th>Count</th>\n",
       "      <th>COMM 1311</th>\n",
       "      <th>RHET 1302</th>\n",
       "      <th>MATH 1306</th>\n",
       "      <th>MATH 1314</th>\n",
       "      <th>AMS 2300</th>\n",
       "      <th>AMS 2341</th>\n",
       "      <th>HUMA 1301</th>\n",
       "      <th>...</th>\n",
       "      <th>ECON 4362</th>\n",
       "      <th>ECON 4382</th>\n",
       "      <th>PSCI 4354</th>\n",
       "      <th>PSCI 4V99</th>\n",
       "      <th>PSCI 3327</th>\n",
       "      <th>PSCI 4364</th>\n",
       "      <th>MATH 2312</th>\n",
       "      <th>MATH 3303</th>\n",
       "      <th>MATH 3305</th>\n",
       "      <th>MATH 3307</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bachelor of Arts in American Studies</td>\n",
       "      <td>updated courses/Bachelor of Arts in American S...</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bachelor of Science in Healthcare Studies</td>\n",
       "      <td>updated courses/Bachelor of Science in Healthc...</td>\n",
       "      <td>93.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bachelor of Arts and Bachelor of Science in In...</td>\n",
       "      <td>updated courses/Bachelor of Arts and Bachelor ...</td>\n",
       "      <td>47.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bachelor of Arts in Arts, Technology, and Emer...</td>\n",
       "      <td>updated courses/Bachelor of Arts in Arts, Tech...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bachelor of Science in Cognitive Science</td>\n",
       "      <td>updated courses/Bachelor of Science in Cogniti...</td>\n",
       "      <td>75.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>136</th>\n",
       "      <td>Master of Arts in Visual and Performing Arts</td>\n",
       "      <td>updated courses/Master of Arts in Visual and P...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>Doctor of Philosophy in Visual and Performing ...</td>\n",
       "      <td>updated courses/Doctor of Philosophy in Visual...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>Master of Science in Leadership and Organizati...</td>\n",
       "      <td>updated courses/Master of Science in Leadershi...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Bachelor of Science in Business Analytics</td>\n",
       "      <td>updated courses/Bachelor of Science in Busines...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>School of Interdisciplinary Studies</td>\n",
       "      <td>updated courses/School of Interdisciplinary St...</td>\n",
       "      <td>438.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 2113 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Title  \\\n",
       "0                 Bachelor of Arts in American Studies   \n",
       "1            Bachelor of Science in Healthcare Studies   \n",
       "2    Bachelor of Arts and Bachelor of Science in In...   \n",
       "3    Bachelor of Arts in Arts, Technology, and Emer...   \n",
       "4             Bachelor of Science in Cognitive Science   \n",
       "..                                                 ...   \n",
       "136       Master of Arts in Visual and Performing Arts   \n",
       "137  Doctor of Philosophy in Visual and Performing ...   \n",
       "138  Master of Science in Leadership and Organizati...   \n",
       "139          Bachelor of Science in Business Analytics   \n",
       "140                School of Interdisciplinary Studies   \n",
       "\n",
       "                                     Updated File Name  Count  COMM 1311  \\\n",
       "0    updated courses/Bachelor of Arts in American S...   26.0        1.0   \n",
       "1    updated courses/Bachelor of Science in Healthc...   93.0        1.0   \n",
       "2    updated courses/Bachelor of Arts and Bachelor ...   47.0        1.0   \n",
       "3    updated courses/Bachelor of Arts in Arts, Tech...    0.0        0.0   \n",
       "4    updated courses/Bachelor of Science in Cogniti...   75.0        1.0   \n",
       "..                                                 ...    ...        ...   \n",
       "136  updated courses/Master of Arts in Visual and P...   11.0        0.0   \n",
       "137  updated courses/Doctor of Philosophy in Visual...   11.0        0.0   \n",
       "138  updated courses/Master of Science in Leadershi...    0.0        0.0   \n",
       "139  updated courses/Bachelor of Science in Busines...   70.0        0.0   \n",
       "140  updated courses/School of Interdisciplinary St...  438.0        1.0   \n",
       "\n",
       "     RHET 1302  MATH 1306  MATH 1314  AMS 2300  AMS 2341  HUMA 1301  ...  \\\n",
       "0          1.0        1.0        1.0       1.0       1.0        1.0  ...   \n",
       "1          1.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "2          1.0        1.0        1.0       1.0       1.0        1.0  ...   \n",
       "3          0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "4          1.0        0.0        0.0       0.0       0.0        1.0  ...   \n",
       "..         ...        ...        ...       ...       ...        ...  ...   \n",
       "136        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "137        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "138        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "139        0.0        0.0        0.0       0.0       0.0        0.0  ...   \n",
       "140        1.0        0.0        1.0       1.0       1.0        1.0  ...   \n",
       "\n",
       "     ECON 4362  ECON 4382  PSCI 4354  PSCI 4V99  PSCI 3327  PSCI 4364  \\\n",
       "0          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "1          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "2          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "3          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "4          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "..         ...        ...        ...        ...        ...        ...   \n",
       "136        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "137        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "138        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "139        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "140        1.0        1.0        1.0        1.0        1.0        1.0   \n",
       "\n",
       "     MATH 2312  MATH 3303  MATH 3305  MATH 3307  \n",
       "0          0.0        0.0        0.0        0.0  \n",
       "1          0.0        0.0        0.0        0.0  \n",
       "2          0.0        0.0        0.0        0.0  \n",
       "3          0.0        0.0        0.0        0.0  \n",
       "4          0.0        0.0        0.0        0.0  \n",
       "..         ...        ...        ...        ...  \n",
       "136        0.0        0.0        0.0        0.0  \n",
       "137        0.0        0.0        0.0        0.0  \n",
       "138        0.0        0.0        0.0        0.0  \n",
       "139        0.0        0.0        0.0        0.0  \n",
       "140        1.0        1.0        1.0        1.0  \n",
       "\n",
       "[141 rows x 2113 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>COMM 1311</th>\n",
       "      <th>RHET 1302</th>\n",
       "      <th>MATH 1306</th>\n",
       "      <th>MATH 1314</th>\n",
       "      <th>AMS 2300</th>\n",
       "      <th>AMS 2341</th>\n",
       "      <th>HUMA 1301</th>\n",
       "      <th>ARTS 1301</th>\n",
       "      <th>FILM 2332</th>\n",
       "      <th>HIST 1301</th>\n",
       "      <th>...</th>\n",
       "      <th>ECON 4362</th>\n",
       "      <th>ECON 4382</th>\n",
       "      <th>PSCI 4354</th>\n",
       "      <th>PSCI 4V99</th>\n",
       "      <th>PSCI 3327</th>\n",
       "      <th>PSCI 4364</th>\n",
       "      <th>MATH 2312</th>\n",
       "      <th>MATH 3303</th>\n",
       "      <th>MATH 3305</th>\n",
       "      <th>MATH 3307</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>136</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>141 rows × 2110 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     COMM 1311  RHET 1302  MATH 1306  MATH 1314  AMS 2300  AMS 2341  \\\n",
       "0          1.0        1.0        1.0        1.0       1.0       1.0   \n",
       "1          1.0        1.0        0.0        0.0       0.0       0.0   \n",
       "2          1.0        1.0        1.0        1.0       1.0       1.0   \n",
       "3          0.0        0.0        0.0        0.0       0.0       0.0   \n",
       "4          1.0        1.0        0.0        0.0       0.0       0.0   \n",
       "..         ...        ...        ...        ...       ...       ...   \n",
       "136        0.0        0.0        0.0        0.0       0.0       0.0   \n",
       "137        0.0        0.0        0.0        0.0       0.0       0.0   \n",
       "138        0.0        0.0        0.0        0.0       0.0       0.0   \n",
       "139        0.0        0.0        0.0        0.0       0.0       0.0   \n",
       "140        1.0        1.0        0.0        1.0       1.0       1.0   \n",
       "\n",
       "     HUMA 1301  ARTS 1301  FILM 2332  HIST 1301  ...  ECON 4362  ECON 4382  \\\n",
       "0          1.0        1.0        1.0        1.0  ...        0.0        0.0   \n",
       "1          0.0        1.0        0.0        0.0  ...        0.0        0.0   \n",
       "2          1.0        1.0        0.0        0.0  ...        0.0        0.0   \n",
       "3          0.0        0.0        0.0        0.0  ...        0.0        0.0   \n",
       "4          1.0        1.0        1.0        1.0  ...        0.0        0.0   \n",
       "..         ...        ...        ...        ...  ...        ...        ...   \n",
       "136        0.0        0.0        0.0        0.0  ...        0.0        0.0   \n",
       "137        0.0        0.0        0.0        0.0  ...        0.0        0.0   \n",
       "138        0.0        0.0        0.0        0.0  ...        0.0        0.0   \n",
       "139        0.0        0.0        0.0        0.0  ...        0.0        0.0   \n",
       "140        1.0        1.0        0.0        1.0  ...        1.0        1.0   \n",
       "\n",
       "     PSCI 4354  PSCI 4V99  PSCI 3327  PSCI 4364  MATH 2312  MATH 3303  \\\n",
       "0          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "1          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "2          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "3          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "4          0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "..         ...        ...        ...        ...        ...        ...   \n",
       "136        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "137        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "138        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "139        0.0        0.0        0.0        0.0        0.0        0.0   \n",
       "140        1.0        1.0        1.0        1.0        1.0        1.0   \n",
       "\n",
       "     MATH 3305  MATH 3307  \n",
       "0          0.0        0.0  \n",
       "1          0.0        0.0  \n",
       "2          0.0        0.0  \n",
       "3          0.0        0.0  \n",
       "4          0.0        0.0  \n",
       "..         ...        ...  \n",
       "136        0.0        0.0  \n",
       "137        0.0        0.0  \n",
       "138        0.0        0.0  \n",
       "139        0.0        0.0  \n",
       "140        1.0        1.0  \n",
       "\n",
       "[141 rows x 2110 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# excluding first two columns\n",
    "course_values_only = main_table.loc[:, ~main_table.columns.isin(['Title', 'Updated File Name', 'Count'])]\n",
    "course_values_only"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "for r in course_values_only:\n",
    "    if(not r):\n",
    "        print(r)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 64-bit (windows store)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "780937d7eb87e339692ba01770ab5190c03a402a2a1727e6b73b0b71c3bc584b"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}