Data_Scraping_from_the_web.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "# turns off warning messsages\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# to do list\n",
    "# Read all the two pages from the website and store them into a single panda dataframe\n",
    "# Figure out which are grad and undergrad classes.\n",
    "# Display the graduate 12:am classes\n",
    "# Display the gratuate Monday classes\n",
    "# Also ask the user the choice of seeing both graduate and undergraduate classes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Course</th>\n",
       "      <th>Section</th>\n",
       "      <th>Class</th>\n",
       "      <th>Credits</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructor(s)</th>\n",
       "      <th>Time</th>\n",
       "      <th>Day</th>\n",
       "      <th>Room(s)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IDS403</td>\n",
       "      <td>M800</td>\n",
       "      <td>72105</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Startup Sandbox</td>\n",
       "      <td>John DuRoss Liddy</td>\n",
       "      <td>12:00am - 12:00am</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IST256</td>\n",
       "      <td>M800</td>\n",
       "      <td>72106</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Appl.Prog.For Information Syst</td>\n",
       "      <td>Laurie A Ferger</td>\n",
       "      <td>12:00am - 9:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IST359</td>\n",
       "      <td>M800</td>\n",
       "      <td>72107</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Data Base Mgmt Systs</td>\n",
       "      <td>Blythe Scherrer</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IST387</td>\n",
       "      <td>M002</td>\n",
       "      <td>72103</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Applied Data Science</td>\n",
       "      <td>Jeffrey M. Stanton</td>\n",
       "      <td>12:00am - 7:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IST471</td>\n",
       "      <td>M001</td>\n",
       "      <td>70842</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Internship in Info Mgmt &amp; Tech</td>\n",
       "      <td>Susan Monica Bonzi</td>\n",
       "      <td>12:00am - 12:00am</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>IST472</td>\n",
       "      <td>M802</td>\n",
       "      <td>72104</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Coop Educ in Info Mgmt &amp; Tech</td>\n",
       "      <td>Susan Monica Bonzi</td>\n",
       "      <td>12:00am - 12:00am</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>IST511</td>\n",
       "      <td>M400</td>\n",
       "      <td>70827</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Library &amp; Info Prof</td>\n",
       "      <td>Meghan Bremiller</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IST511</td>\n",
       "      <td>M401</td>\n",
       "      <td>70828</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Library &amp; Info Prof</td>\n",
       "      <td>DeAnna R Miller</td>\n",
       "      <td>7:00pm - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>IST511</td>\n",
       "      <td>M402</td>\n",
       "      <td>70847</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Library &amp; Info Prof</td>\n",
       "      <td>Alison J Johnson</td>\n",
       "      <td>9:00pm - 10:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>IST564</td>\n",
       "      <td>M401</td>\n",
       "      <td>70846</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Lib Svces to Students w/Disab</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7:00pm - 8:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>IST600</td>\n",
       "      <td>M001</td>\n",
       "      <td>72295</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Adv Topcs in User Exper UX Des</td>\n",
       "      <td>Ping Zhang</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>IST600</td>\n",
       "      <td>M800</td>\n",
       "      <td>72356</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Info Mgmt- Crtcl Infra Protect</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12:00am - 12:00am</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>IST600</td>\n",
       "      <td>M002</td>\n",
       "      <td>72378</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Rare Book/Spcial Collect. Libr</td>\n",
       "      <td>Alvan M. Bregman</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>BIRD LIBRARY LEMKE ROOM 606B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IST602</td>\n",
       "      <td>M001</td>\n",
       "      <td>70815</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Digital Forensics</td>\n",
       "      <td>Mark M. Pollitt</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThFSa</td>\n",
       "      <td>Hinds Hall 027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IST605</td>\n",
       "      <td>M400</td>\n",
       "      <td>70848</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Reference&amp; Info Literacy Svces</td>\n",
       "      <td>Rebecca Miller Waltz</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>IST605</td>\n",
       "      <td>M402</td>\n",
       "      <td>70877</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Reference&amp; Info Literacy Svces</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>IST612</td>\n",
       "      <td>M400</td>\n",
       "      <td>70849</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Youth Svce inLibrary Info Ctrs</td>\n",
       "      <td>Kori M Gerbig</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>IST614</td>\n",
       "      <td>M400</td>\n",
       "      <td>70829</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Mngmt Prncpls for Info Profess</td>\n",
       "      <td>Paul Brian Gandel</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>IST614</td>\n",
       "      <td>M401</td>\n",
       "      <td>70830</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Mngmt Prncpls for Info Profess</td>\n",
       "      <td>Paul Brian Gandel</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>IST614</td>\n",
       "      <td>M402</td>\n",
       "      <td>70852</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Mngmt Prncpls for Info Profess</td>\n",
       "      <td>Dr. John P. Stinnett</td>\n",
       "      <td>12:00am - 9:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>IST616</td>\n",
       "      <td>M400</td>\n",
       "      <td>70818</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Info Rsces: Organiz &amp; Access</td>\n",
       "      <td>Arden Kirkland</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>IST616</td>\n",
       "      <td>M401</td>\n",
       "      <td>70831</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Info Rsces: Organiz &amp; Access</td>\n",
       "      <td>Arden Kirkland</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>IST618</td>\n",
       "      <td>M400</td>\n",
       "      <td>70819</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Policy</td>\n",
       "      <td>Raed M. Sharif</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>IST618</td>\n",
       "      <td>M401</td>\n",
       "      <td>70833</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Policy</td>\n",
       "      <td>Raed M. Sharif</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>IST618</td>\n",
       "      <td>M402</td>\n",
       "      <td>70850</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Policy</td>\n",
       "      <td>Lauren Britton</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>IST621</td>\n",
       "      <td>M400</td>\n",
       "      <td>70834</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Info Management and Technology</td>\n",
       "      <td>Michael Larche</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>IST623</td>\n",
       "      <td>M400</td>\n",
       "      <td>70835</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Information Security</td>\n",
       "      <td>Joon S. Park</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>IST625</td>\n",
       "      <td>M001</td>\n",
       "      <td>70816</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Enterprise Risk Management</td>\n",
       "      <td>James Enwright</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>IST625</td>\n",
       "      <td>M400</td>\n",
       "      <td>70868</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Enterprise Risk Management</td>\n",
       "      <td>Michael Larche</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>IST636</td>\n",
       "      <td>M400</td>\n",
       "      <td>70853</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Leading Issues/Info Security</td>\n",
       "      <td>Joon S. Park</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>IST639</td>\n",
       "      <td>M001</td>\n",
       "      <td>70843</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Enterprise Technologies</td>\n",
       "      <td>P Douglas Taber</td>\n",
       "      <td>10:00am - 6:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 010  Hinds Hall 011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>IST652</td>\n",
       "      <td>M400</td>\n",
       "      <td>70854</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Scripting for Data Analysis</td>\n",
       "      <td>Dr. Gregory Block</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>IST652</td>\n",
       "      <td>M401</td>\n",
       "      <td>70855</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Scripting for Data Analysis</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12:00am - 10:30am</td>\n",
       "      <td>Sa</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>IST654</td>\n",
       "      <td>M400</td>\n",
       "      <td>70838</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Systems Analysis</td>\n",
       "      <td>Gregory Zink</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>IST659</td>\n",
       "      <td>M400</td>\n",
       "      <td>70839</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Data Admin Concepts &amp; Db Mgmt</td>\n",
       "      <td>Dr. John P. Stinnett</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>IST659</td>\n",
       "      <td>M401</td>\n",
       "      <td>70856</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Data Admin Concepts &amp; Db Mgmt</td>\n",
       "      <td>Dr. John P. Stinnett</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>IST659</td>\n",
       "      <td>M402</td>\n",
       "      <td>70857</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Data Admin Concepts &amp; Db Mgmt</td>\n",
       "      <td>Dale Thompson</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>IST659</td>\n",
       "      <td>M403</td>\n",
       "      <td>70863</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Data Admin Concepts &amp; Db Mgmt</td>\n",
       "      <td>Dale Thompson</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>IST659</td>\n",
       "      <td>M404</td>\n",
       "      <td>70882</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Data Admin Concepts &amp; Db Mgmt</td>\n",
       "      <td>Dr. Gregory Block</td>\n",
       "      <td>12:00am - 5:30pm</td>\n",
       "      <td>Su</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>IST662</td>\n",
       "      <td>M401</td>\n",
       "      <td>70851</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Instr Strgt &amp; Tech/Info Profs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>IST662</td>\n",
       "      <td>M400</td>\n",
       "      <td>70878</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Instr Strgt &amp; Tech/Info Profs</td>\n",
       "      <td>Megan Oakleaf</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>Tu</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>IST664</td>\n",
       "      <td>M400</td>\n",
       "      <td>72511</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Natural Language Processing</td>\n",
       "      <td>Norma Palomino</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>IST664</td>\n",
       "      <td>M401</td>\n",
       "      <td>72566</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Natural Language Processing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12:00am - 8:00pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>IST668</td>\n",
       "      <td>M400</td>\n",
       "      <td>72409</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Litrcy Through Schl Libraries</td>\n",
       "      <td>Sara Kelly Johns</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>Th</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M001</td>\n",
       "      <td>70814</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Jeffrey Saltz</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M400</td>\n",
       "      <td>70840</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Jeffrey Saltz</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>FSaSu</td>\n",
       "      <td>Life Science Building 001  Life Science Buildi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M401</td>\n",
       "      <td>70864</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Gary E Krudys</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M402</td>\n",
       "      <td>70866</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Corey Jackson Jr</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M403</td>\n",
       "      <td>70867</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Mohammed A Syed</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M404</td>\n",
       "      <td>70869</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Abdullah Mamdouh Awaysheh</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>W</td>\n",
       "      <td>Online  Online</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Course Section  Class  Credits                           Title  \\\n",
       "0   IDS403    M800  72105      3.0                 Startup Sandbox   \n",
       "1   IST256    M800  72106      3.0  Appl.Prog.For Information Syst   \n",
       "2   IST359    M800  72107      3.0   Intro to Data Base Mgmt Systs   \n",
       "3   IST387    M002  72103      3.0   Intro to Applied Data Science   \n",
       "4   IST471    M001  70842      3.0  Internship in Info Mgmt & Tech   \n",
       "5   IST472    M802  72104      3.0   Coop Educ in Info Mgmt & Tech   \n",
       "6   IST511    M400  70827      3.0    Intro to Library & Info Prof   \n",
       "7   IST511    M401  70828      3.0    Intro to Library & Info Prof   \n",
       "8   IST511    M402  70847      3.0    Intro to Library & Info Prof   \n",
       "9   IST564    M401  70846      3.0   Lib Svces to Students w/Disab   \n",
       "10  IST600    M001  72295      3.0  Adv Topcs in User Exper UX Des   \n",
       "11  IST600    M800  72356      3.0  Info Mgmt- Crtcl Infra Protect   \n",
       "12  IST600    M002  72378      3.0  Rare Book/Spcial Collect. Libr   \n",
       "13  IST602    M001  70815      3.0               Digital Forensics   \n",
       "14  IST605    M400  70848      3.0  Reference& Info Literacy Svces   \n",
       "15  IST605    M402  70877      3.0  Reference& Info Literacy Svces   \n",
       "16  IST612    M400  70849      3.0  Youth Svce inLibrary Info Ctrs   \n",
       "17  IST614    M400  70829      3.0  Mngmt Prncpls for Info Profess   \n",
       "18  IST614    M401  70830      3.0  Mngmt Prncpls for Info Profess   \n",
       "19  IST614    M402  70852      3.0  Mngmt Prncpls for Info Profess   \n",
       "20  IST616    M400  70818      3.0    Info Rsces: Organiz & Access   \n",
       "21  IST616    M401  70831      3.0    Info Rsces: Organiz & Access   \n",
       "22  IST618    M400  70819      3.0              Information Policy   \n",
       "23  IST618    M401  70833      3.0              Information Policy   \n",
       "24  IST618    M402  70850      3.0              Information Policy   \n",
       "25  IST621    M400  70834      3.0  Info Management and Technology   \n",
       "26  IST623    M400  70835      3.0   Intro to Information Security   \n",
       "27  IST625    M001  70816      3.0      Enterprise Risk Management   \n",
       "28  IST625    M400  70868      3.0      Enterprise Risk Management   \n",
       "29  IST636    M400  70853      3.0    Leading Issues/Info Security   \n",
       "30  IST639    M001  70843      3.0         Enterprise Technologies   \n",
       "31  IST652    M400  70854      3.0     Scripting for Data Analysis   \n",
       "32  IST652    M401  70855      3.0     Scripting for Data Analysis   \n",
       "33  IST654    M400  70838      3.0    Information Systems Analysis   \n",
       "34  IST659    M400  70839      3.0   Data Admin Concepts & Db Mgmt   \n",
       "35  IST659    M401  70856      3.0   Data Admin Concepts & Db Mgmt   \n",
       "36  IST659    M402  70857      3.0   Data Admin Concepts & Db Mgmt   \n",
       "37  IST659    M403  70863      3.0   Data Admin Concepts & Db Mgmt   \n",
       "38  IST659    M404  70882      3.0   Data Admin Concepts & Db Mgmt   \n",
       "39  IST662    M401  70851      3.0   Instr Strgt & Tech/Info Profs   \n",
       "40  IST662    M400  70878      3.0   Instr Strgt & Tech/Info Profs   \n",
       "41  IST664    M400  72511      3.0     Natural Language Processing   \n",
       "42  IST664    M401  72566      3.0     Natural Language Processing   \n",
       "43  IST668    M400  72409      3.0   Litrcy Through Schl Libraries   \n",
       "44  IST687    M001  70814      3.0    Introduction to Data Science   \n",
       "45  IST687    M400  70840      3.0    Introduction to Data Science   \n",
       "46  IST687    M401  70864      3.0    Introduction to Data Science   \n",
       "47  IST687    M402  70866      3.0    Introduction to Data Science   \n",
       "48  IST687    M403  70867      3.0    Introduction to Data Science   \n",
       "49  IST687    M404  70869      3.0    Introduction to Data Science   \n",
       "\n",
       "                Instructor(s)               Time        Day  \\\n",
       "0           John DuRoss Liddy  12:00am - 12:00am        NaN   \n",
       "1             Laurie A Ferger   12:00am - 9:30pm         Th   \n",
       "2             Blythe Scherrer   12:00am - 8:30pm         Tu   \n",
       "3          Jeffrey M. Stanton   12:00am - 7:30pm         Tu   \n",
       "4          Susan Monica Bonzi  12:00am - 12:00am        NaN   \n",
       "5          Susan Monica Bonzi  12:00am - 12:00am        NaN   \n",
       "6            Meghan Bremiller   12:00am - 8:30pm         Tu   \n",
       "7             DeAnna R Miller    7:00pm - 8:30pm          W   \n",
       "8            Alison J Johnson   9:00pm - 10:30pm          M   \n",
       "9                         NaN    7:00pm - 8:30pm         Th   \n",
       "10                 Ping Zhang    9:00am - 5:00pm    MTuWThF   \n",
       "11                        NaN  12:00am - 12:00am        NaN   \n",
       "12           Alvan M. Bregman    9:00am - 5:00pm    MTuWThF   \n",
       "13            Mark M. Pollitt    9:00am - 5:00pm  MTuWThFSa   \n",
       "14       Rebecca Miller Waltz   12:00am - 8:30pm          W   \n",
       "15                        NaN  12:00am - 10:30pm         Tu   \n",
       "16              Kori M Gerbig   12:00am - 8:30pm          W   \n",
       "17          Paul Brian Gandel  12:00am - 10:30pm          W   \n",
       "18          Paul Brian Gandel  12:00am - 10:30pm         Th   \n",
       "19       Dr. John P. Stinnett   12:00am - 9:30pm          M   \n",
       "20             Arden Kirkland   12:00am - 8:30pm         Th   \n",
       "21             Arden Kirkland  12:00am - 10:30pm         Tu   \n",
       "22             Raed M. Sharif   12:00am - 8:30pm          W   \n",
       "23             Raed M. Sharif  12:00am - 10:30pm          W   \n",
       "24             Lauren Britton   12:00am - 8:30pm          M   \n",
       "25             Michael Larche  12:00am - 10:30pm         Tu   \n",
       "26               Joon S. Park   12:00am - 8:30pm          W   \n",
       "27             James Enwright    9:00am - 5:00pm    MTuWThF   \n",
       "28             Michael Larche   12:00am - 8:30pm         Tu   \n",
       "29               Joon S. Park  12:00am - 10:30pm          W   \n",
       "30            P Douglas Taber   10:00am - 6:00pm    MTuWThF   \n",
       "31          Dr. Gregory Block   12:00am - 8:30pm         Th   \n",
       "32                        NaN  12:00am - 10:30am         Sa   \n",
       "33               Gregory Zink   12:00am - 8:30pm          M   \n",
       "34       Dr. John P. Stinnett   12:00am - 8:30pm         Tu   \n",
       "35       Dr. John P. Stinnett  12:00am - 10:30pm         Tu   \n",
       "36              Dale Thompson   12:00am - 8:30pm          W   \n",
       "37              Dale Thompson   12:00am - 8:30pm         Th   \n",
       "38          Dr. Gregory Block   12:00am - 5:30pm         Su   \n",
       "39                        NaN   12:00am - 8:30pm         Tu   \n",
       "40              Megan Oakleaf  12:00am - 10:30pm         Tu   \n",
       "41             Norma Palomino   12:00am - 8:30pm          W   \n",
       "42                        NaN   12:00am - 8:00pm          W   \n",
       "43           Sara Kelly Johns   12:00am - 8:30pm         Th   \n",
       "44              Jeffrey Saltz    9:00am - 5:00pm    MTuWThF   \n",
       "45              Jeffrey Saltz    9:00am - 5:00pm      FSaSu   \n",
       "46              Gary E Krudys  12:00am - 10:30pm          M   \n",
       "47           Corey Jackson Jr  12:00am - 10:30pm          W   \n",
       "48            Mohammed A Syed  12:00am - 10:30pm          M   \n",
       "49  Abdullah Mamdouh Awaysheh   12:00am - 8:30pm          W   \n",
       "\n",
       "                                              Room(s)  \n",
       "0                                              Online  \n",
       "1                                      Online  Online  \n",
       "2                                      Online  Online  \n",
       "3                                      Online  Online  \n",
       "4                                              Online  \n",
       "5                                              Online  \n",
       "6                                      Online  Online  \n",
       "7                                              Online  \n",
       "8                                              Online  \n",
       "9                                              Online  \n",
       "10                                     Hinds Hall 117  \n",
       "11                                                NaN  \n",
       "12                       BIRD LIBRARY LEMKE ROOM 606B  \n",
       "13                                     Hinds Hall 027  \n",
       "14                                     Online  Online  \n",
       "15                                     Online  Online  \n",
       "16                                     Online  Online  \n",
       "17                                     Online  Online  \n",
       "18                                     Online  Online  \n",
       "19                                     Online  Online  \n",
       "20                                     Online  Online  \n",
       "21                                     Online  Online  \n",
       "22                                     Online  Online  \n",
       "23                                     Online  Online  \n",
       "24                                     Online  Online  \n",
       "25                                     Online  Online  \n",
       "26                                     Online  Online  \n",
       "27                                     Hinds Hall 018  \n",
       "28                                     Online  Online  \n",
       "29                                     Online  Online  \n",
       "30                     Hinds Hall 010  Hinds Hall 011  \n",
       "31                                     Online  Online  \n",
       "32                                     Online  Online  \n",
       "33                                     Online  Online  \n",
       "34                                     Online  Online  \n",
       "35                                     Online  Online  \n",
       "36                                     Online  Online  \n",
       "37                                     Online  Online  \n",
       "38                                     Online  Online  \n",
       "39                                     Online  Online  \n",
       "40                                     Online  Online  \n",
       "41                                     Online  Online  \n",
       "42                                     Online  Online  \n",
       "43                                     Online  Online  \n",
       "44                                     Hinds Hall 018  \n",
       "45  Life Science Building 001  Life Science Buildi...  \n",
       "46                                     Online  Online  \n",
       "47                                     Online  Online  \n",
       "48                                     Online  Online  \n",
       "49                                     Online  Online  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "website = 'https://ischool.syr.edu/classes/?page=1'\n",
    "datalist = pd.read_html(website)\n",
    "datalist[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_classes_from_website():\n",
    "    classes = pd.DataFrame()\n",
    "    for num in range(1, 3):\n",
    "        website = 'https://ischool.syr.edu/classes/?page=' + str(num)\n",
    "        datalist = pd.read_html(website)\n",
    "        classes = classes.append(datalist[0])\n",
    "    classes.coloumns =['Course', 'Section', 'Class', 'Credits', 'Title', 'Instructor', 'Time', 'Day', 'Room']\n",
    "    return classes\n",
    "\n",
    "def engineer_grad_undergrad(classes):\n",
    "    classes['CourseNum'] = classes['Course'].str[3:]\n",
    "    classes['Type'] = 'None'\n",
    "    classes['Type'][classes['CourseNum'].astype(int)>=500] = 'G'\n",
    "    classes['Type'][classes['CourseNum'].astype(int)<500] = 'U'\n",
    "    return classes\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Do you want 12:00Am class of Monday class? Please enter either 12 or M or U or G, to ger started  ? Or do you want to just see the undergrad or graduate classM\n"
     ]
    },
    {
     "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>Course</th>\n",
       "      <th>Section</th>\n",
       "      <th>Class</th>\n",
       "      <th>Credits</th>\n",
       "      <th>Title</th>\n",
       "      <th>Instructor(s)</th>\n",
       "      <th>Time</th>\n",
       "      <th>Day</th>\n",
       "      <th>Room(s)</th>\n",
       "      <th>CourseNum</th>\n",
       "      <th>Type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>IST511</td>\n",
       "      <td>M402</td>\n",
       "      <td>70847</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Intro to Library &amp; Info Prof</td>\n",
       "      <td>Alison J Johnson</td>\n",
       "      <td>9:00pm - 10:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online</td>\n",
       "      <td>511</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>IST600</td>\n",
       "      <td>M001</td>\n",
       "      <td>72295</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Adv Topcs in User Exper UX Des</td>\n",
       "      <td>Ping Zhang</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 117</td>\n",
       "      <td>600</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>IST600</td>\n",
       "      <td>M002</td>\n",
       "      <td>72378</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Rare Book/Spcial Collect. Libr</td>\n",
       "      <td>Alvan M. Bregman</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>BIRD LIBRARY LEMKE ROOM 606B</td>\n",
       "      <td>600</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IST602</td>\n",
       "      <td>M001</td>\n",
       "      <td>70815</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Digital Forensics</td>\n",
       "      <td>Mark M. Pollitt</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThFSa</td>\n",
       "      <td>Hinds Hall 027</td>\n",
       "      <td>602</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>IST614</td>\n",
       "      <td>M402</td>\n",
       "      <td>70852</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Mngmt Prncpls for Info Profess</td>\n",
       "      <td>Dr. John P. Stinnett</td>\n",
       "      <td>12:00am - 9:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>614</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>IST618</td>\n",
       "      <td>M402</td>\n",
       "      <td>70850</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Policy</td>\n",
       "      <td>Lauren Britton</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>618</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>IST625</td>\n",
       "      <td>M001</td>\n",
       "      <td>70816</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Enterprise Risk Management</td>\n",
       "      <td>James Enwright</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 018</td>\n",
       "      <td>625</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>IST639</td>\n",
       "      <td>M001</td>\n",
       "      <td>70843</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Enterprise Technologies</td>\n",
       "      <td>P Douglas Taber</td>\n",
       "      <td>10:00am - 6:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 010  Hinds Hall 011</td>\n",
       "      <td>639</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>IST654</td>\n",
       "      <td>M400</td>\n",
       "      <td>70838</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Systems Analysis</td>\n",
       "      <td>Gregory Zink</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>654</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M001</td>\n",
       "      <td>70814</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Jeffrey Saltz</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 018</td>\n",
       "      <td>687</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M401</td>\n",
       "      <td>70864</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Gary E Krudys</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>687</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M403</td>\n",
       "      <td>70867</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Mohammed A Syed</td>\n",
       "      <td>12:00am - 10:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>687</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IST687</td>\n",
       "      <td>M405</td>\n",
       "      <td>70884</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Introduction to Data Science</td>\n",
       "      <td>Tin T Hoang</td>\n",
       "      <td>12:00am - 8:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>687</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IST704</td>\n",
       "      <td>M001</td>\n",
       "      <td>72110</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Applied Info Security</td>\n",
       "      <td>Mark M. Pollitt</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 027</td>\n",
       "      <td>704</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IST707</td>\n",
       "      <td>M001</td>\n",
       "      <td>72111</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Data Analytics</td>\n",
       "      <td>Frank Jr Marullo</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 010</td>\n",
       "      <td>707</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>IST718</td>\n",
       "      <td>M001</td>\n",
       "      <td>70811</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Big Data Analytics</td>\n",
       "      <td>Daniel E. Acuna</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 021</td>\n",
       "      <td>718</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>IST718</td>\n",
       "      <td>M402</td>\n",
       "      <td>72415</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Big Data Analytics</td>\n",
       "      <td>Jillian K Lando</td>\n",
       "      <td>12:00am - 7:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>718</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IST719</td>\n",
       "      <td>M001</td>\n",
       "      <td>70844</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Information Visualization</td>\n",
       "      <td>Frank Jr Marullo</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 010</td>\n",
       "      <td>719</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>IST736</td>\n",
       "      <td>M001</td>\n",
       "      <td>72112</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Text Mining</td>\n",
       "      <td>Bei Yu</td>\n",
       "      <td>9:00am - 5:00pm</td>\n",
       "      <td>MTuWThF</td>\n",
       "      <td>Hinds Hall 013</td>\n",
       "      <td>736</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>IST777</td>\n",
       "      <td>M400</td>\n",
       "      <td>72517</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Statistical Methods in IST</td>\n",
       "      <td>Jeffrey M. Stanton</td>\n",
       "      <td>12:00am - 7:30pm</td>\n",
       "      <td>M</td>\n",
       "      <td>Online  Online</td>\n",
       "      <td>777</td>\n",
       "      <td>G</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Course Section  Class  Credits                           Title  \\\n",
       "8   IST511    M402  70847      3.0    Intro to Library & Info Prof   \n",
       "10  IST600    M001  72295      3.0  Adv Topcs in User Exper UX Des   \n",
       "12  IST600    M002  72378      3.0  Rare Book/Spcial Collect. Libr   \n",
       "13  IST602    M001  70815      3.0               Digital Forensics   \n",
       "19  IST614    M402  70852      3.0  Mngmt Prncpls for Info Profess   \n",
       "24  IST618    M402  70850      3.0              Information Policy   \n",
       "27  IST625    M001  70816      3.0      Enterprise Risk Management   \n",
       "30  IST639    M001  70843      3.0         Enterprise Technologies   \n",
       "33  IST654    M400  70838      3.0    Information Systems Analysis   \n",
       "44  IST687    M001  70814      3.0    Introduction to Data Science   \n",
       "46  IST687    M401  70864      3.0    Introduction to Data Science   \n",
       "48  IST687    M403  70867      3.0    Introduction to Data Science   \n",
       "0   IST687    M405  70884      3.0    Introduction to Data Science   \n",
       "3   IST704    M001  72110      3.0           Applied Info Security   \n",
       "4   IST707    M001  72111      3.0                  Data Analytics   \n",
       "9   IST718    M001  70811      3.0              Big Data Analytics   \n",
       "12  IST718    M402  72415      3.0              Big Data Analytics   \n",
       "13  IST719    M001  70844      3.0       Information Visualization   \n",
       "18  IST736    M001  72112      3.0                     Text Mining   \n",
       "22  IST777    M400  72517      3.0      Statistical Methods in IST   \n",
       "\n",
       "           Instructor(s)               Time        Day  \\\n",
       "8       Alison J Johnson   9:00pm - 10:30pm          M   \n",
       "10            Ping Zhang    9:00am - 5:00pm    MTuWThF   \n",
       "12      Alvan M. Bregman    9:00am - 5:00pm    MTuWThF   \n",
       "13       Mark M. Pollitt    9:00am - 5:00pm  MTuWThFSa   \n",
       "19  Dr. John P. Stinnett   12:00am - 9:30pm          M   \n",
       "24        Lauren Britton   12:00am - 8:30pm          M   \n",
       "27        James Enwright    9:00am - 5:00pm    MTuWThF   \n",
       "30       P Douglas Taber   10:00am - 6:00pm    MTuWThF   \n",
       "33          Gregory Zink   12:00am - 8:30pm          M   \n",
       "44         Jeffrey Saltz    9:00am - 5:00pm    MTuWThF   \n",
       "46         Gary E Krudys  12:00am - 10:30pm          M   \n",
       "48       Mohammed A Syed  12:00am - 10:30pm          M   \n",
       "0            Tin T Hoang   12:00am - 8:30pm          M   \n",
       "3        Mark M. Pollitt    9:00am - 5:00pm    MTuWThF   \n",
       "4       Frank Jr Marullo    9:00am - 5:00pm    MTuWThF   \n",
       "9        Daniel E. Acuna    9:00am - 5:00pm    MTuWThF   \n",
       "12       Jillian K Lando   12:00am - 7:30pm          M   \n",
       "13      Frank Jr Marullo    9:00am - 5:00pm    MTuWThF   \n",
       "18                Bei Yu    9:00am - 5:00pm    MTuWThF   \n",
       "22    Jeffrey M. Stanton   12:00am - 7:30pm          M   \n",
       "\n",
       "                           Room(s) CourseNum Type  \n",
       "8                           Online       511    G  \n",
       "10                  Hinds Hall 117       600    G  \n",
       "12    BIRD LIBRARY LEMKE ROOM 606B       600    G  \n",
       "13                  Hinds Hall 027       602    G  \n",
       "19                  Online  Online       614    G  \n",
       "24                  Online  Online       618    G  \n",
       "27                  Hinds Hall 018       625    G  \n",
       "30  Hinds Hall 010  Hinds Hall 011       639    G  \n",
       "33                  Online  Online       654    G  \n",
       "44                  Hinds Hall 018       687    G  \n",
       "46                  Online  Online       687    G  \n",
       "48                  Online  Online       687    G  \n",
       "0                   Online  Online       687    G  \n",
       "3                   Hinds Hall 027       704    G  \n",
       "4                   Hinds Hall 010       707    G  \n",
       "9                   Hinds Hall 021       718    G  \n",
       "12                  Online  Online       718    G  \n",
       "13                  Hinds Hall 010       719    G  \n",
       "18                  Hinds Hall 013       736    G  \n",
       "22                  Online  Online       777    G  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = \"\"\n",
    "classes = get_classes_from_website()\n",
    "classes = engineer_grad_undergrad(classes)\n",
    "\n",
    "ugrad = classes[classes['Type'] == 'G']\n",
    "choice = input(\"Do you want 12:00Am class of Monday class? Please enter either 12 or M or U or G, to ger started  ? Or do you want to just see the undergrad or graduate class\").upper()\n",
    "if choice == '12':\n",
    "    df = ugrad[ugrad['Time'].str.find(\"12:00am\") >= 0]\n",
    "elif choice == 'M':\n",
    "    df = ugrad[ugrad['Day'].str.find(\"M\") >= 0]\n",
    "elif choice == 'U':\n",
    "    df = classes[classes['Type'] == 'U']\n",
    "elif choice == 'G':\n",
    "    df = classes[classes['Type'] == 'G']\n",
    "else:\n",
    "    print(\"Please read the above instructions\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}