monmouth.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "monmouth.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    },
    "accelerator": "GPU"
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "4dQZRVfxvSks"
      },
      "source": [
        "Based on when the students sign in, we predict when is a good time for tutoring. This is based on past data and not having tutor time during the specific classes they seek help in"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_UV8xUJTqKMu"
      },
      "source": [
        "# artificial neural network "
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tx4HntR3rO-M"
      },
      "source": [
        "# commonly used modules\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import matplotlib.pyplot as plt\n",
        "\n",
        "# datetime\n",
        "import datetime\n",
        "\n",
        "# import tensorflow and tf.keras\n",
        "import tensorflow as tf\n",
        "from tensorflow import keras\n",
        "from tensorflow.keras.layers import Conv2D, MaxPooling2D, Dropout, Flatten, Dense\n",
        "\n",
        "# import scikit\n",
        "import sklearn.model_selection as sk\n"
      ],
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "H7F1hhsjOtJX",
        "outputId": "75f2ea0b-b59c-4b22-e721-f7f7872a5748"
      },
      "source": [
        "today = datetime.date.today()\n",
        "print ('today:  ', today)\n",
        "print ('ctime:  ', today.ctime())\n",
        "print ('tuple:  ', today.timetuple())\n",
        "print ('ordinal:', today.toordinal())\n",
        "print ('Year:   ', today.year)\n",
        "print ('Mon:    ', today.month)\n",
        "print ('Day :   ', today.day)"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "today:   2021-06-11\n",
            "ctime:   Fri Jun 11 00:00:00 2021\n",
            "tuple:   time.struct_time(tm_year=2021, tm_mon=6, tm_mday=11, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=4, tm_yday=162, tm_isdst=-1)\n",
            "ordinal: 737952\n",
            "Year:    2021\n",
            "Mon:     6\n",
            "Day :    11\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hI3Pun9RrRrN",
        "outputId": "cdbd7a20-e107-401b-a8c7-97cb360b0941"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount(\"/content/drive\")"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "irIFnFQnrZ-H",
        "outputId": "5058f3a1-515e-460f-fd94-e80c604e9fa3"
      },
      "source": [
        "students = pd.DataFrame(pd.read_excel(\"/content/drive/My Drive/Monmouth AI Research/student_dataset.xlsx\")) \n",
        "students = students.drop(\"Name\", axis=1)\n",
        "students = students.drop(\"Topic\", axis=1)\n",
        "students"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Date</th>\n",
              "      <th>Time</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>7</td>\n",
              "      <td>2</td>\n",
              "      <td>11:07:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>7</td>\n",
              "      <td>2</td>\n",
              "      <td>10:57:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>16:20:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>11</td>\n",
              "      <td>3</td>\n",
              "      <td>15:48:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>15:46:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>9</td>\n",
              "      <td>3</td>\n",
              "      <td>14:35:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>14:28:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>14:27:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>9</td>\n",
              "      <td>3</td>\n",
              "      <td>14:26:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>13:47:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>12</td>\n",
              "      <td>3</td>\n",
              "      <td>13:26:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>13:25:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>13</td>\n",
              "      <td>6</td>\n",
              "      <td>22:11:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>22:09:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>16:50:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>12</td>\n",
              "      <td>5</td>\n",
              "      <td>16:50:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>15:52:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>12</td>\n",
              "      <td>5</td>\n",
              "      <td>15:32:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>15:23:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>15:23:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>11</td>\n",
              "      <td>5</td>\n",
              "      <td>14:11:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>11:29:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>15:11:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>8</td>\n",
              "      <td>5</td>\n",
              "      <td>16:32:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>16:18:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>9</td>\n",
              "      <td>5</td>\n",
              "      <td>12:28:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>9</td>\n",
              "      <td>2</td>\n",
              "      <td>12:45:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>11</td>\n",
              "      <td>2</td>\n",
              "      <td>16:25:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>7</td>\n",
              "      <td>2</td>\n",
              "      <td>16:25:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>9</td>\n",
              "      <td>2</td>\n",
              "      <td>16:25:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>17:59:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>8</td>\n",
              "      <td>3</td>\n",
              "      <td>13:22:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>9</td>\n",
              "      <td>3</td>\n",
              "      <td>13:22:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>13</td>\n",
              "      <td>3</td>\n",
              "      <td>13:22:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    Course  Date      Time\n",
              "0        7     2  11:07:00\n",
              "1        7     2  10:57:00\n",
              "2        1     3  16:20:00\n",
              "3       11     3  15:48:00\n",
              "4        0     3  15:46:00\n",
              "5        9     3  14:35:00\n",
              "6        8     3  14:28:00\n",
              "7        8     3  14:27:00\n",
              "8        9     3  14:26:00\n",
              "9        8     3  13:47:00\n",
              "10      12     3  13:26:00\n",
              "11       0     3  13:25:00\n",
              "12      13     6  22:11:00\n",
              "13       8     6  22:09:00\n",
              "14       8     5  16:50:00\n",
              "15      12     5  16:50:00\n",
              "16       0     5  15:52:00\n",
              "17      12     5  15:32:00\n",
              "18       8     5  15:23:00\n",
              "19       8     5  15:23:00\n",
              "20      11     5  14:11:00\n",
              "21      10     5  11:29:00\n",
              "22       9     4  15:11:00\n",
              "23       8     5  16:32:00\n",
              "24      10     5  16:18:00\n",
              "25       9     5  12:28:00\n",
              "26       9     2  12:45:00\n",
              "27      11     2  16:25:00\n",
              "28       7     2  16:25:00\n",
              "29       9     2  16:25:00\n",
              "30       8     3  17:59:00\n",
              "31       8     3  13:22:00\n",
              "32       9     3  13:22:00\n",
              "33      13     3  13:22:00"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JgaOO_ggpVOK",
        "outputId": "7800078e-d63b-4f0f-b943-ac46b272b2cb"
      },
      "source": [
        "students['Time'] = students['Time'].astype(str)\n",
        "students['Time'] = students['Time'].replace(\":\",\"\", regex=True)\n",
        "\n",
        "students['Time'] = students['Time'].astype(float)\n",
        "students['Time'] \n",
        "students.dtypes"
      ],
      "execution_count": 50,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Course      int64\n",
              "Date        int64\n",
              "Time      float64\n",
              "dtype: object"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 203
        },
        "id": "N6vVXCGJui11",
        "outputId": "60500c0b-ab5e-46f1-fe97-36143c789126"
      },
      "source": [
        "students.head()"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Date</th>\n",
              "      <th>Time</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>7</td>\n",
              "      <td>2</td>\n",
              "      <td>110700.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>7</td>\n",
              "      <td>2</td>\n",
              "      <td>105700.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>162000.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>11</td>\n",
              "      <td>3</td>\n",
              "      <td>154800.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>154600.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Course  Date      Time\n",
              "0       7     2  110700.0\n",
              "1       7     2  105700.0\n",
              "2       1     3  162000.0\n",
              "3      11     3  154800.0\n",
              "4       0     3  154600.0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "edxReD4WKwlp",
        "outputId": "a8afc00c-470f-4781-ffe2-5c69a143e4f1"
      },
      "source": [
        "courses = pd.DataFrame(pd.read_excel(\"/content/drive/My Drive/Monmouth AI Research/course_dataset.xlsx\"))\n",
        "courses"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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 Title</th>\n",
              "      <th>Day</th>\n",
              "      <th>Time</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>IT 102</td>\n",
              "      <td>Monday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>IT 102</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>10:05-11:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>IT 102</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>IT 102</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>IT 102</td>\n",
              "      <td>Friday</td>\n",
              "      <td>10:05-11:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>IT 102</td>\n",
              "      <td>Friday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>IT 103</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>16:30-17:50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>IT 103</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>16:30-17:50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>IT 200</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>10:05-11:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>IT 200</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>IT 200</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>8:30-9:50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>IT 200</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>IT 250</td>\n",
              "      <td>Monday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>IT 250</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>11:40-13:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>IT 250</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>IT 300</td>\n",
              "      <td>Monday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>IT 300</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>IT 300</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>IT 450</td>\n",
              "      <td>Monday</td>\n",
              "      <td>10:05-11:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>IT 450</td>\n",
              "      <td>Monday</td>\n",
              "      <td>19:40-21:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>IT 450</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>19:40-21:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>CS 104</td>\n",
              "      <td>Monday</td>\n",
              "      <td>11:40-13:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>CS 104</td>\n",
              "      <td>Monday</td>\n",
              "      <td>16:40-17:50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>CS 104</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>CS 104</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>11:40-13:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>CS 104</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>16:40-17:50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>CS 104</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>11:40-13:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>CS 175</td>\n",
              "      <td>Monday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>CS 175</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>CS 176</td>\n",
              "      <td>Monday</td>\n",
              "      <td>10:05-11:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>CS 176</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>CS 176</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>10:05-11:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>CS 176</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>CS 205</td>\n",
              "      <td>Monday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>CS 205</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>18:05-19:25</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>CS 414</td>\n",
              "      <td>Monday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>CS 414</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>13:15-14:35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>CS 432</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>11:40-13:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>CS 432</td>\n",
              "      <td>Friday</td>\n",
              "      <td>11:40-13:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>CS 438</td>\n",
              "      <td>Monday</td>\n",
              "      <td>16:30-17:50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>CS 438</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>16:30-17:50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Course Title        Day         Time\n",
              "0        IT 102     Monday  18:05-19:25\n",
              "1        IT 102  Wednesday  10:05-11:25\n",
              "2        IT 102  Wednesday  13:15-14:35\n",
              "3        IT 102  Wednesday  18:05-19:25\n",
              "4        IT 102     Friday  10:05-11:25\n",
              "5        IT 102     Friday  13:15-14:35\n",
              "6        IT 103    Tuesday  16:30-17:50\n",
              "7        IT 103   Thursday  16:30-17:50\n",
              "8        IT 200    Tuesday  10:05-11:25\n",
              "9        IT 200    Tuesday  18:05-19:25\n",
              "10       IT 200   Thursday    8:30-9:50\n",
              "11       IT 200   Thursday  18:05-19:25\n",
              "12       IT 250     Monday  18:05-19:25\n",
              "13       IT 250  Wednesday  11:40-13:00\n",
              "14       IT 250  Wednesday  18:05-19:25\n",
              "15       IT 300     Monday  13:15-14:35\n",
              "16       IT 300    Tuesday  18:05-19:25\n",
              "17       IT 300   Thursday  13:15-14:35\n",
              "18       IT 450     Monday  10:05-11:25\n",
              "19       IT 450     Monday  19:40-21:00\n",
              "20       IT 450  Wednesday  19:40-21:00\n",
              "21       CS 104     Monday  11:40-13:00\n",
              "22       CS 104     Monday  16:40-17:50\n",
              "23       CS 104    Tuesday  13:15-14:35\n",
              "24       CS 104  Wednesday  11:40-13:00\n",
              "25       CS 104  Wednesday  16:40-17:50\n",
              "26       CS 104   Thursday  11:40-13:00\n",
              "27       CS 175     Monday  18:05-19:25\n",
              "28       CS 175  Wednesday  18:05-19:25\n",
              "29       CS 176     Monday  10:05-11:25\n",
              "30       CS 176    Tuesday  18:05-19:25\n",
              "31       CS 176   Thursday  10:05-11:25\n",
              "32       CS 176   Thursday  18:05-19:25\n",
              "33       CS 205     Monday  18:05-19:25\n",
              "34       CS 205  Wednesday  18:05-19:25\n",
              "35       CS 414     Monday  13:15-14:35\n",
              "36       CS 414   Thursday  13:15-14:35\n",
              "37       CS 432    Tuesday  11:40-13:00\n",
              "38       CS 432     Friday  11:40-13:00\n",
              "39       CS 438     Monday  16:30-17:50\n",
              "40       CS 438  Wednesday  16:30-17:50"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 59
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C8dxKmx7vmOs"
      },
      "source": [
        "# possibly would need a start and end time for each class, and do\n",
        "# for i not in range(start_time, end_time):\n",
        "  # pick a random time based on AI model"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UsprknhGPgKO",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 195
        },
        "outputId": "9feb5e79-ae0a-4671-bb67-1404b62caf35"
      },
      "source": [
        "courses_csv = pd.DataFrame(pd.read_csv(\"/content/drive/My Drive/Monmouth AI Research/course_dataset.csv\", sep=',', header=None))\n",
        "courses_csv"
      ],
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>11</th>\n",
              "      <th>12</th>\n",
              "      <th>13</th>\n",
              "      <th>14</th>\n",
              "      <th>15</th>\n",
              "      <th>16</th>\n",
              "      <th>17</th>\n",
              "      <th>18</th>\n",
              "      <th>19</th>\n",
              "      <th>20</th>\n",
              "      <th>21</th>\n",
              "      <th>22</th>\n",
              "      <th>23</th>\n",
              "      <th>24</th>\n",
              "      <th>25</th>\n",
              "      <th>26</th>\n",
              "      <th>27</th>\n",
              "      <th>28</th>\n",
              "      <th>29</th>\n",
              "      <th>30</th>\n",
              "      <th>31</th>\n",
              "      <th>32</th>\n",
              "      <th>33</th>\n",
              "      <th>34</th>\n",
              "      <th>35</th>\n",
              "      <th>36</th>\n",
              "      <th>37</th>\n",
              "      <th>38</th>\n",
              "      <th>39</th>\n",
              "      <th>40</th>\n",
              "      <th>41</th>\n",
              "      <th>42</th>\n",
              "      <th>43</th>\n",
              "      <th>44</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Course Title</td>\n",
              "      <td>IT 102</td>\n",
              "      <td>IT 102</td>\n",
              "      <td>IT 102</td>\n",
              "      <td>IT 102</td>\n",
              "      <td>IT 102</td>\n",
              "      <td>IT 102</td>\n",
              "      <td>IT 103</td>\n",
              "      <td>IT 103</td>\n",
              "      <td>IT 200</td>\n",
              "      <td>IT 200</td>\n",
              "      <td>IT 200</td>\n",
              "      <td>IT 200</td>\n",
              "      <td>IT 250</td>\n",
              "      <td>IT 250</td>\n",
              "      <td>IT 250</td>\n",
              "      <td>IT 300</td>\n",
              "      <td>IT 300</td>\n",
              "      <td>IT 300</td>\n",
              "      <td>IT 450</td>\n",
              "      <td>IT 450</td>\n",
              "      <td>IT 450</td>\n",
              "      <td>CS 104</td>\n",
              "      <td>CS 104</td>\n",
              "      <td>CS 104</td>\n",
              "      <td>CS 104</td>\n",
              "      <td>CS 104</td>\n",
              "      <td>CS 104</td>\n",
              "      <td>CS 175</td>\n",
              "      <td>CS 175</td>\n",
              "      <td>CS 176</td>\n",
              "      <td>CS 176</td>\n",
              "      <td>CS 176</td>\n",
              "      <td>CS 176</td>\n",
              "      <td>CS 205</td>\n",
              "      <td>CS 205</td>\n",
              "      <td>CS 414</td>\n",
              "      <td>CS 414</td>\n",
              "      <td>CS 432</td>\n",
              "      <td>CS 432</td>\n",
              "      <td>CS 438</td>\n",
              "      <td>CS 438</td>\n",
              "      <td>CS 432</td>\n",
              "      <td>CS 438</td>\n",
              "      <td>CS 438</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Day</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Thursday</td>\n",
              "      <td>Tuesday</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "      <td>Friday</td>\n",
              "      <td>Monday</td>\n",
              "      <td>Wednesday</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Time</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>10:05-11:25</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>10:05-11:25</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>16:30-17:50</td>\n",
              "      <td>16:30-17:50</td>\n",
              "      <td>10:05-11:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>8:30-9:50</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>10:05-11:25</td>\n",
              "      <td>19:40-21:00</td>\n",
              "      <td>19:40-21:00</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>16:40-17:50</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>16:40-17:50</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>10:05-11:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>10:05-11:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>18:05-19:25</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>13:15-14:35</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>16:30-17:50</td>\n",
              "      <td>16:30-17:50</td>\n",
              "      <td>11:40-13:00</td>\n",
              "      <td>16:30-17:50</td>\n",
              "      <td>16:30-17:50</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "             0            1   ...           43           44\n",
              "0  Course Title       IT 102  ...       CS 438       CS 438\n",
              "1           Day       Monday  ...       Monday    Wednesday\n",
              "2          Time  18:05-19:25  ...  16:30-17:50  16:30-17:50\n",
              "\n",
              "[3 rows x 45 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 52
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "D228Lv8TrkiH"
      },
      "source": [
        "input_layer = tf.keras.layers.Dense(500) \n",
        "layer1 = tf.keras.layers.Dense(10) \n",
        "layer2 = tf.keras.layers.Dense(10) \n",
        "final_layer = tf.keras.layers.Dense(240)"
      ],
      "execution_count": 53,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "a1Uk0t3j3I_4",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3a24659e-e62b-4b84-97a1-1b9832f2ee2f"
      },
      "source": [
        "strategy = tf.distribute.MirroredStrategy()\n",
        "with strategy.scope():\n",
        "  model = tf.keras.Sequential([\n",
        "    tf.keras.layers.Dense(3),\n",
        "    tf.keras.layers.Dense(500),\n",
        "    tf.keras.layers.Dense(64),\n",
        "    tf.keras.layers.Dense(10, activation='relu')\n",
        "  ])\n",
        "  optimizer = tf.keras.optimizers.Adam()\n",
        "  checkpoint = tf.train.Checkpoint(optimizer=optimizer, model=model)"
      ],
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "WARNING:tensorflow:Collective ops is not configured at program startup. Some performance features may not be enabled.\n",
            "INFO:tensorflow:Using MirroredStrategy with devices ('/job:localhost/replica:0/task:0/device:GPU:0',)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "z16iXu29Cq-j"
      },
      "source": [
        "X = students.iloc[:, 0].values\n",
        "Y = students.iloc[:, 1:2].values"
      ],
      "execution_count": 55,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DyrbmZ9SEWNt"
      },
      "source": [
        "from sklearn.model_selection import train_test_split\n",
        "X_train, X_test, Y_train, Y_test = train_test_split(X, Y, test_size = 0.33, random_state = 42)"
      ],
      "execution_count": 57,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tge7TAon_MTw"
      },
      "source": [
        "X_train, X_test, y_train, y_test = sk.train_test_split(features,labels,test_size=0.20, random_state = 42)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3m9VV3bv_PUE",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 131
        },
        "outputId": "59acd34e-464e-4d4c-b05b-18fabae0906e"
      },
      "source": [
        "X_train, X_test, y_train, y_test = \n",
        "sk.train_test_split(features,labels,test_size=0.33, random_state = 42)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "SyntaxError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-123-96ca6631d9fe>\"\u001b[0;36m, line \u001b[0;32m1\u001b[0m\n\u001b[0;31m    X_train, X_test, y_train, y_test =\u001b[0m\n\u001b[0m                                       ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n"
          ]
        }
      ]
    }
  ]
}