make_submission.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:18.972791Z",
     "iopub.status.busy": "2022-03-25T17:33:18.972341Z",
     "iopub.status.idle": "2022-03-25T17:33:18.977222Z",
     "shell.execute_reply": "2022-03-25T17:33:18.976406Z",
     "shell.execute_reply.started": "2022-03-25T17:33:18.972747Z"
    },
    "id": "_6J1XDUvR9--"
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "from datetime import datetime\n",
    "import joblib\n",
    "import math"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "PLO22eVnYhnF",
    "outputId": "3791e388-e82f-4e44-c65c-08b8bb6393e6"
   },
   "outputs": [],
   "source": [
    "model = joblib.load(\"model_cat_4.joblib\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.042176Z",
     "iopub.status.busy": "2022-03-25T17:33:19.041434Z",
     "iopub.status.idle": "2022-03-25T17:33:19.119001Z",
     "shell.execute_reply": "2022-03-25T17:33:19.118342Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.042130Z"
    },
    "id": "W__SvVCXR9--"
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv('test.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 423
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.121148Z",
     "iopub.status.busy": "2022-03-25T17:33:19.120626Z",
     "iopub.status.idle": "2022-03-25T17:33:19.135330Z",
     "shell.execute_reply": "2022-03-25T17:33:19.134241Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.121108Z"
    },
    "id": "d6iXJ3abR9-_",
    "outputId": "243eb19d-8b4c-4ee8-f0d9-73c8dca83058"
   },
   "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>Id</th>\n",
       "      <th>Timestep</th>\n",
       "      <th>Course</th>\n",
       "      <th>Faculty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>KA26197</td>\n",
       "      <td>Prof. Judah Jenkins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>TW19052</td>\n",
       "      <td>Prof. Cooper Floyd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>FP16950</td>\n",
       "      <td>Prof. Carter Harding</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>HY25227</td>\n",
       "      <td>Prof. Sarah Kane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>VS22092</td>\n",
       "      <td>Prof. Martin Reyes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>9995</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>KN14962</td>\n",
       "      <td>Prof. Ricardo Stuart</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>9996</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>KV13591</td>\n",
       "      <td>Prof. Aiyana Mcbride</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>9997</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>MK15674</td>\n",
       "      <td>Prof. Kody Aguirre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>9998</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>NW16681</td>\n",
       "      <td>Prof. Rishi Fowler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>9999</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>QY25453</td>\n",
       "      <td>Prof. Casey Sawyer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Id       Timestep   Course               Faculty\n",
       "0        0  AY1990-AY1991  KA26197   Prof. Judah Jenkins\n",
       "1        1  AY1990-AY1991  TW19052    Prof. Cooper Floyd\n",
       "2        2  AY1990-AY1991  FP16950  Prof. Carter Harding\n",
       "3        3  AY1990-AY1991  HY25227      Prof. Sarah Kane\n",
       "4        4  AY1990-AY1991  VS22092    Prof. Martin Reyes\n",
       "...    ...            ...      ...                   ...\n",
       "9995  9995  AY2009-AY2010  KN14962  Prof. Ricardo Stuart\n",
       "9996  9996  AY2009-AY2010  KV13591  Prof. Aiyana Mcbride\n",
       "9997  9997  AY2009-AY2010  MK15674    Prof. Kody Aguirre\n",
       "9998  9998  AY2009-AY2010  NW16681    Prof. Rishi Fowler\n",
       "9999  9999  AY2009-AY2010  QY25453    Prof. Casey Sawyer\n",
       "\n",
       "[10000 rows x 4 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.168429Z",
     "iopub.status.busy": "2022-03-25T17:33:19.168027Z",
     "iopub.status.idle": "2022-03-25T17:33:19.191601Z",
     "shell.execute_reply": "2022-03-25T17:33:19.190689Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.168391Z"
    },
    "id": "at2beOuCR9-_",
    "outputId": "5a1d2414-874e-418f-bc25-f695e15fc601"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10000 entries, 0 to 9999\n",
      "Data columns (total 4 columns):\n",
      " #   Column    Non-Null Count  Dtype \n",
      "---  ------    --------------  ----- \n",
      " 0   Id        10000 non-null  int64 \n",
      " 1   Timestep  10000 non-null  object\n",
      " 2   Course    10000 non-null  object\n",
      " 3   Faculty   10000 non-null  object\n",
      "dtypes: int64(1), object(3)\n",
      "memory usage: 312.6+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.228499Z",
     "iopub.status.busy": "2022-03-25T17:33:19.227712Z",
     "iopub.status.idle": "2022-03-25T17:33:19.241013Z",
     "shell.execute_reply": "2022-03-25T17:33:19.240148Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.228447Z"
    },
    "id": "ic4Kgg5iR9_A",
    "outputId": "7a190bbb-61eb-4c00-d687-e4c3744d4dab"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SB29827    20\n",
       "QU15654    20\n",
       "QZ15242    20\n",
       "NO21170    19\n",
       "JT20238    19\n",
       "           ..\n",
       "OR19912    11\n",
       "XS19457    11\n",
       "HE28500    11\n",
       "EG21029    10\n",
       "IC16913    10\n",
       "Name: Course, Length: 656, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Course'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.348046Z",
     "iopub.status.busy": "2022-03-25T17:33:19.347572Z",
     "iopub.status.idle": "2022-03-25T17:33:19.360786Z",
     "shell.execute_reply": "2022-03-25T17:33:19.359914Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.348002Z"
    },
    "id": "fAnk3fvUR9_A",
    "outputId": "2b6be0cb-b7de-4990-e928-2d6a05db162c"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Prof. Alia Simon           33\n",
       "Prof. Luna Jensen          32\n",
       "Prof. Jaelynn Alexander    32\n",
       "Prof. Kamron Barker        31\n",
       "Prof. Lawson Robinson      30\n",
       "                           ..\n",
       "Prof. Dexter Bolton        10\n",
       "Prof. Rishi Fowler         10\n",
       "Prof. Kennedy Sweeney      10\n",
       "Prof. Fletcher Caldwell    10\n",
       "Prof. Junior Carson         9\n",
       "Name: Faculty, Length: 560, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Faculty'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.380369Z",
     "iopub.status.busy": "2022-03-25T17:33:19.379567Z",
     "iopub.status.idle": "2022-03-25T17:33:19.386462Z",
     "shell.execute_reply": "2022-03-25T17:33:19.385484Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.380325Z"
    },
    "id": "ji-FxgVDR9_B",
    "outputId": "134f90a3-2f53-40ef-9cb9-58ef0f5e67dc"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(df['Timestep'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.516810Z",
     "iopub.status.busy": "2022-03-25T17:33:19.515992Z",
     "iopub.status.idle": "2022-03-25T17:33:19.574456Z",
     "shell.execute_reply": "2022-03-25T17:33:19.573646Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.516770Z"
    },
    "id": "4y4MH5uFR9_B"
   },
   "outputs": [],
   "source": [
    "df['Year'] = df['Timestep'].apply(lambda x: int(x[2:6]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 487
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.593610Z",
     "iopub.status.busy": "2022-03-25T17:33:19.592864Z",
     "iopub.status.idle": "2022-03-25T17:33:19.945635Z",
     "shell.execute_reply": "2022-03-25T17:33:19.945080Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.593572Z"
    },
    "id": "MnXJo-hhR9_C",
    "outputId": "76f3aadb-079c-40e3-d3b6-40b639ea200e"
   },
   "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>AB18023</th>\n",
       "      <th>AB20928</th>\n",
       "      <th>AB25695</th>\n",
       "      <th>AD18559</th>\n",
       "      <th>AD21894</th>\n",
       "      <th>AJ19783</th>\n",
       "      <th>AL19784</th>\n",
       "      <th>AL28154</th>\n",
       "      <th>AM18690</th>\n",
       "      <th>AN11745</th>\n",
       "      <th>...</th>\n",
       "      <th>ZS11345</th>\n",
       "      <th>ZS16168</th>\n",
       "      <th>ZS29879</th>\n",
       "      <th>ZU20965</th>\n",
       "      <th>ZU29326</th>\n",
       "      <th>ZV18131</th>\n",
       "      <th>ZV23833</th>\n",
       "      <th>ZW13749</th>\n",
       "      <th>ZX11344</th>\n",
       "      <th>ZZ23306</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 656 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      AB18023  AB20928  AB25695  AD18559  AD21894  AJ19783  AL19784  AL28154  \\\n",
       "0           0        0        0        0        0        0        0        0   \n",
       "1           0        0        0        0        0        0        0        0   \n",
       "2           0        0        0        0        0        0        0        0   \n",
       "3           0        0        0        0        0        0        0        0   \n",
       "4           0        0        0        0        0        0        0        0   \n",
       "...       ...      ...      ...      ...      ...      ...      ...      ...   \n",
       "9995        0        0        0        0        0        0        0        0   \n",
       "9996        0        0        0        0        0        0        0        0   \n",
       "9997        0        0        0        0        0        0        0        0   \n",
       "9998        0        0        0        0        0        0        0        0   \n",
       "9999        0        0        0        0        0        0        0        0   \n",
       "\n",
       "      AM18690  AN11745  ...  ZS11345  ZS16168  ZS29879  ZU20965  ZU29326  \\\n",
       "0           0        0  ...        0        0        0        0        0   \n",
       "1           0        0  ...        0        0        0        0        0   \n",
       "2           0        0  ...        0        0        0        0        0   \n",
       "3           0        0  ...        0        0        0        0        0   \n",
       "4           0        0  ...        0        0        0        0        0   \n",
       "...       ...      ...  ...      ...      ...      ...      ...      ...   \n",
       "9995        0        0  ...        0        0        0        0        0   \n",
       "9996        0        0  ...        0        0        0        0        0   \n",
       "9997        0        0  ...        0        0        0        0        0   \n",
       "9998        0        0  ...        0        0        0        0        0   \n",
       "9999        0        0  ...        0        0        0        0        0   \n",
       "\n",
       "      ZV18131  ZV23833  ZW13749  ZX11344  ZZ23306  \n",
       "0           0        0        0        0        0  \n",
       "1           0        0        0        0        0  \n",
       "2           0        0        0        0        0  \n",
       "3           0        0        0        0        0  \n",
       "4           0        0        0        0        0  \n",
       "...       ...      ...      ...      ...      ...  \n",
       "9995        0        0        0        0        0  \n",
       "9996        0        0        0        0        0  \n",
       "9997        0        0        0        0        0  \n",
       "9998        0        0        0        0        0  \n",
       "9999        0        0        0        0        0  \n",
       "\n",
       "[10000 rows x 656 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Course_dummies = pd.get_dummies(df['Course'])\n",
    "Course_dummies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 834
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:19.947334Z",
     "iopub.status.busy": "2022-03-25T17:33:19.946725Z",
     "iopub.status.idle": "2022-03-25T17:33:20.132212Z",
     "shell.execute_reply": "2022-03-25T17:33:20.131338Z",
     "shell.execute_reply.started": "2022-03-25T17:33:19.947286Z"
    },
    "id": "j2V-LBOtR9_C",
    "outputId": "dc4f1ede-1622-4342-8e6a-7685ca5f2c88"
   },
   "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>Id</th>\n",
       "      <th>Timestep</th>\n",
       "      <th>Course</th>\n",
       "      <th>Faculty</th>\n",
       "      <th>Year</th>\n",
       "      <th>AB18023</th>\n",
       "      <th>AB20928</th>\n",
       "      <th>AB25695</th>\n",
       "      <th>AD18559</th>\n",
       "      <th>AD21894</th>\n",
       "      <th>...</th>\n",
       "      <th>ZR13208</th>\n",
       "      <th>ZS11345</th>\n",
       "      <th>ZS16168</th>\n",
       "      <th>ZS29879</th>\n",
       "      <th>ZU20965</th>\n",
       "      <th>ZU29326</th>\n",
       "      <th>ZV18131</th>\n",
       "      <th>ZV23833</th>\n",
       "      <th>ZW13749</th>\n",
       "      <th>ZX11344</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>KA26197</td>\n",
       "      <td>Prof. Judah Jenkins</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>TW19052</td>\n",
       "      <td>Prof. Cooper Floyd</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>FP16950</td>\n",
       "      <td>Prof. Carter Harding</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>HY25227</td>\n",
       "      <td>Prof. Sarah Kane</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>VS22092</td>\n",
       "      <td>Prof. Martin Reyes</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>9995</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>KN14962</td>\n",
       "      <td>Prof. Ricardo Stuart</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>9996</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>KV13591</td>\n",
       "      <td>Prof. Aiyana Mcbride</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>9997</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>MK15674</td>\n",
       "      <td>Prof. Kody Aguirre</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>9998</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>NW16681</td>\n",
       "      <td>Prof. Rishi Fowler</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>9999</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>QY25453</td>\n",
       "      <td>Prof. Casey Sawyer</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 660 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Id       Timestep   Course               Faculty  Year  AB18023  \\\n",
       "0        0  AY1990-AY1991  KA26197   Prof. Judah Jenkins  1990        0   \n",
       "1        1  AY1990-AY1991  TW19052    Prof. Cooper Floyd  1990        0   \n",
       "2        2  AY1990-AY1991  FP16950  Prof. Carter Harding  1990        0   \n",
       "3        3  AY1990-AY1991  HY25227      Prof. Sarah Kane  1990        0   \n",
       "4        4  AY1990-AY1991  VS22092    Prof. Martin Reyes  1990        0   \n",
       "...    ...            ...      ...                   ...   ...      ...   \n",
       "9995  9995  AY2009-AY2010  KN14962  Prof. Ricardo Stuart  2009        0   \n",
       "9996  9996  AY2009-AY2010  KV13591  Prof. Aiyana Mcbride  2009        0   \n",
       "9997  9997  AY2009-AY2010  MK15674    Prof. Kody Aguirre  2009        0   \n",
       "9998  9998  AY2009-AY2010  NW16681    Prof. Rishi Fowler  2009        0   \n",
       "9999  9999  AY2009-AY2010  QY25453    Prof. Casey Sawyer  2009        0   \n",
       "\n",
       "      AB20928  AB25695  AD18559  AD21894  ...  ZR13208  ZS11345  ZS16168  \\\n",
       "0           0        0        0        0  ...        0        0        0   \n",
       "1           0        0        0        0  ...        0        0        0   \n",
       "2           0        0        0        0  ...        0        0        0   \n",
       "3           0        0        0        0  ...        0        0        0   \n",
       "4           0        0        0        0  ...        0        0        0   \n",
       "...       ...      ...      ...      ...  ...      ...      ...      ...   \n",
       "9995        0        0        0        0  ...        0        0        0   \n",
       "9996        0        0        0        0  ...        0        0        0   \n",
       "9997        0        0        0        0  ...        0        0        0   \n",
       "9998        0        0        0        0  ...        0        0        0   \n",
       "9999        0        0        0        0  ...        0        0        0   \n",
       "\n",
       "      ZS29879  ZU20965  ZU29326  ZV18131  ZV23833  ZW13749  ZX11344  \n",
       "0           0        0        0        0        0        0        0  \n",
       "1           0        0        0        0        0        0        0  \n",
       "2           0        0        0        0        0        0        0  \n",
       "3           0        0        0        0        0        0        0  \n",
       "4           0        0        0        0        0        0        0  \n",
       "...       ...      ...      ...      ...      ...      ...      ...  \n",
       "9995        0        0        0        0        0        0        0  \n",
       "9996        0        0        0        0        0        0        0  \n",
       "9997        0        0        0        0        0        0        0  \n",
       "9998        0        0        0        0        0        0        0  \n",
       "9999        0        0        0        0        0        0        0  \n",
       "\n",
       "[10000 rows x 660 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.concat([df, Course_dummies.drop('ZZ23306', axis = 'columns')], axis='columns')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 522
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:20.133420Z",
     "iopub.status.busy": "2022-03-25T17:33:20.133222Z",
     "iopub.status.idle": "2022-03-25T17:33:20.441733Z",
     "shell.execute_reply": "2022-03-25T17:33:20.440963Z",
     "shell.execute_reply.started": "2022-03-25T17:33:20.133397Z"
    },
    "id": "xOpQ3t18R9_D",
    "outputId": "59249b9c-1d48-481e-b32e-8fb662e3f658"
   },
   "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>Prof. Aaliyah Cline</th>\n",
       "      <th>Prof. Adelaide Holt</th>\n",
       "      <th>Prof. Adelyn Velasquez</th>\n",
       "      <th>Prof. Aden Mcgrath</th>\n",
       "      <th>Prof. Adison Lucas</th>\n",
       "      <th>Prof. Adrian Mathews</th>\n",
       "      <th>Prof. Adriana Anthony</th>\n",
       "      <th>Prof. Adrianna Frank</th>\n",
       "      <th>Prof. Adyson Guerrero</th>\n",
       "      <th>Prof. Aedan King</th>\n",
       "      <th>...</th>\n",
       "      <th>Prof. Warren Wall</th>\n",
       "      <th>Prof. Willow Moon</th>\n",
       "      <th>Prof. Wilson Hutchinson</th>\n",
       "      <th>Prof. Yael Powell</th>\n",
       "      <th>Prof. Yosef Becker</th>\n",
       "      <th>Prof. Yurem Horton</th>\n",
       "      <th>Prof. Zain Cox</th>\n",
       "      <th>Prof. Zara Le</th>\n",
       "      <th>Prof. Zion Mcgee</th>\n",
       "      <th>Prof. Zoie Mueller</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 560 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Prof. Aaliyah Cline  Prof. Adelaide Holt  Prof. Adelyn Velasquez  \\\n",
       "0                       0                    0                       0   \n",
       "1                       0                    0                       0   \n",
       "2                       0                    0                       0   \n",
       "3                       0                    0                       0   \n",
       "4                       0                    0                       0   \n",
       "...                   ...                  ...                     ...   \n",
       "9995                    0                    0                       0   \n",
       "9996                    0                    0                       0   \n",
       "9997                    0                    0                       0   \n",
       "9998                    0                    0                       0   \n",
       "9999                    0                    0                       0   \n",
       "\n",
       "      Prof. Aden Mcgrath  Prof. Adison Lucas  Prof. Adrian Mathews  \\\n",
       "0                      0                   0                     0   \n",
       "1                      0                   0                     0   \n",
       "2                      0                   0                     0   \n",
       "3                      0                   0                     0   \n",
       "4                      0                   0                     0   \n",
       "...                  ...                 ...                   ...   \n",
       "9995                   0                   0                     0   \n",
       "9996                   0                   0                     0   \n",
       "9997                   0                   0                     0   \n",
       "9998                   0                   0                     0   \n",
       "9999                   0                   0                     0   \n",
       "\n",
       "      Prof. Adriana Anthony  Prof. Adrianna Frank  Prof. Adyson Guerrero  \\\n",
       "0                         0                     0                      0   \n",
       "1                         0                     0                      0   \n",
       "2                         0                     0                      0   \n",
       "3                         0                     0                      0   \n",
       "4                         0                     0                      0   \n",
       "...                     ...                   ...                    ...   \n",
       "9995                      0                     0                      0   \n",
       "9996                      0                     0                      0   \n",
       "9997                      0                     0                      0   \n",
       "9998                      0                     0                      0   \n",
       "9999                      0                     0                      0   \n",
       "\n",
       "      Prof. Aedan King  ...  Prof. Warren Wall  Prof. Willow Moon  \\\n",
       "0                    0  ...                  0                  0   \n",
       "1                    0  ...                  0                  0   \n",
       "2                    0  ...                  0                  0   \n",
       "3                    0  ...                  0                  0   \n",
       "4                    0  ...                  0                  0   \n",
       "...                ...  ...                ...                ...   \n",
       "9995                 0  ...                  0                  0   \n",
       "9996                 0  ...                  0                  0   \n",
       "9997                 0  ...                  0                  0   \n",
       "9998                 0  ...                  0                  0   \n",
       "9999                 0  ...                  0                  0   \n",
       "\n",
       "      Prof. Wilson Hutchinson  Prof. Yael Powell  Prof. Yosef Becker  \\\n",
       "0                           0                  0                   0   \n",
       "1                           0                  0                   0   \n",
       "2                           0                  0                   0   \n",
       "3                           0                  0                   0   \n",
       "4                           0                  0                   0   \n",
       "...                       ...                ...                 ...   \n",
       "9995                        0                  0                   0   \n",
       "9996                        0                  0                   0   \n",
       "9997                        0                  0                   0   \n",
       "9998                        0                  0                   0   \n",
       "9999                        0                  0                   0   \n",
       "\n",
       "      Prof. Yurem Horton  Prof. Zain Cox  Prof. Zara Le  Prof. Zion Mcgee  \\\n",
       "0                      0               0              0                 0   \n",
       "1                      0               0              0                 0   \n",
       "2                      0               0              0                 0   \n",
       "3                      0               0              0                 0   \n",
       "4                      0               0              0                 0   \n",
       "...                  ...             ...            ...               ...   \n",
       "9995                   0               0              0                 0   \n",
       "9996                   0               0              0                 0   \n",
       "9997                   0               0              0                 0   \n",
       "9998                   0               0              0                 0   \n",
       "9999                   0               0              0                 0   \n",
       "\n",
       "      Prof. Zoie Mueller  \n",
       "0                      0  \n",
       "1                      0  \n",
       "2                      0  \n",
       "3                      0  \n",
       "4                      0  \n",
       "...                  ...  \n",
       "9995                   0  \n",
       "9996                   0  \n",
       "9997                   0  \n",
       "9998                   0  \n",
       "9999                   0  \n",
       "\n",
       "[10000 rows x 560 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Faculty_dummies = pd.get_dummies(df['Faculty'])\n",
    "Faculty_dummies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 870
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:33:20.443465Z",
     "iopub.status.busy": "2022-03-25T17:33:20.443261Z",
     "iopub.status.idle": "2022-03-25T17:33:20.635573Z",
     "shell.execute_reply": "2022-03-25T17:33:20.634888Z",
     "shell.execute_reply.started": "2022-03-25T17:33:20.443441Z"
    },
    "id": "t-IQunIaR9_D",
    "outputId": "5a877c67-c42e-4ec0-dbe2-bffda94f3750"
   },
   "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>Id</th>\n",
       "      <th>Timestep</th>\n",
       "      <th>Course</th>\n",
       "      <th>Faculty</th>\n",
       "      <th>Year</th>\n",
       "      <th>AB18023</th>\n",
       "      <th>AB20928</th>\n",
       "      <th>AB25695</th>\n",
       "      <th>AD18559</th>\n",
       "      <th>AD21894</th>\n",
       "      <th>...</th>\n",
       "      <th>Prof. Wade Taylor</th>\n",
       "      <th>Prof. Warren Wall</th>\n",
       "      <th>Prof. Willow Moon</th>\n",
       "      <th>Prof. Wilson Hutchinson</th>\n",
       "      <th>Prof. Yael Powell</th>\n",
       "      <th>Prof. Yosef Becker</th>\n",
       "      <th>Prof. Yurem Horton</th>\n",
       "      <th>Prof. Zain Cox</th>\n",
       "      <th>Prof. Zara Le</th>\n",
       "      <th>Prof. Zion Mcgee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>KA26197</td>\n",
       "      <td>Prof. Judah Jenkins</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>TW19052</td>\n",
       "      <td>Prof. Cooper Floyd</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>FP16950</td>\n",
       "      <td>Prof. Carter Harding</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>HY25227</td>\n",
       "      <td>Prof. Sarah Kane</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>AY1990-AY1991</td>\n",
       "      <td>VS22092</td>\n",
       "      <td>Prof. Martin Reyes</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>9995</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>KN14962</td>\n",
       "      <td>Prof. Ricardo Stuart</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>9996</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>KV13591</td>\n",
       "      <td>Prof. Aiyana Mcbride</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>9997</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>MK15674</td>\n",
       "      <td>Prof. Kody Aguirre</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>9998</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>NW16681</td>\n",
       "      <td>Prof. Rishi Fowler</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>9999</td>\n",
       "      <td>AY2009-AY2010</td>\n",
       "      <td>QY25453</td>\n",
       "      <td>Prof. Casey Sawyer</td>\n",
       "      <td>2009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 1219 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Id       Timestep   Course               Faculty  Year  AB18023  \\\n",
       "0        0  AY1990-AY1991  KA26197   Prof. Judah Jenkins  1990        0   \n",
       "1        1  AY1990-AY1991  TW19052    Prof. Cooper Floyd  1990        0   \n",
       "2        2  AY1990-AY1991  FP16950  Prof. Carter Harding  1990        0   \n",
       "3        3  AY1990-AY1991  HY25227      Prof. Sarah Kane  1990        0   \n",
       "4        4  AY1990-AY1991  VS22092    Prof. Martin Reyes  1990        0   \n",
       "...    ...            ...      ...                   ...   ...      ...   \n",
       "9995  9995  AY2009-AY2010  KN14962  Prof. Ricardo Stuart  2009        0   \n",
       "9996  9996  AY2009-AY2010  KV13591  Prof. Aiyana Mcbride  2009        0   \n",
       "9997  9997  AY2009-AY2010  MK15674    Prof. Kody Aguirre  2009        0   \n",
       "9998  9998  AY2009-AY2010  NW16681    Prof. Rishi Fowler  2009        0   \n",
       "9999  9999  AY2009-AY2010  QY25453    Prof. Casey Sawyer  2009        0   \n",
       "\n",
       "      AB20928  AB25695  AD18559  AD21894  ...  Prof. Wade Taylor  \\\n",
       "0           0        0        0        0  ...                  0   \n",
       "1           0        0        0        0  ...                  0   \n",
       "2           0        0        0        0  ...                  0   \n",
       "3           0        0        0        0  ...                  0   \n",
       "4           0        0        0        0  ...                  0   \n",
       "...       ...      ...      ...      ...  ...                ...   \n",
       "9995        0        0        0        0  ...                  0   \n",
       "9996        0        0        0        0  ...                  0   \n",
       "9997        0        0        0        0  ...                  0   \n",
       "9998        0        0        0        0  ...                  0   \n",
       "9999        0        0        0        0  ...                  0   \n",
       "\n",
       "      Prof. Warren Wall  Prof. Willow Moon  Prof. Wilson Hutchinson  \\\n",
       "0                     0                  0                        0   \n",
       "1                     0                  0                        0   \n",
       "2                     0                  0                        0   \n",
       "3                     0                  0                        0   \n",
       "4                     0                  0                        0   \n",
       "...                 ...                ...                      ...   \n",
       "9995                  0                  0                        0   \n",
       "9996                  0                  0                        0   \n",
       "9997                  0                  0                        0   \n",
       "9998                  0                  0                        0   \n",
       "9999                  0                  0                        0   \n",
       "\n",
       "      Prof. Yael Powell  Prof. Yosef Becker  Prof. Yurem Horton  \\\n",
       "0                     0                   0                   0   \n",
       "1                     0                   0                   0   \n",
       "2                     0                   0                   0   \n",
       "3                     0                   0                   0   \n",
       "4                     0                   0                   0   \n",
       "...                 ...                 ...                 ...   \n",
       "9995                  0                   0                   0   \n",
       "9996                  0                   0                   0   \n",
       "9997                  0                   0                   0   \n",
       "9998                  0                   0                   0   \n",
       "9999                  0                   0                   0   \n",
       "\n",
       "      Prof. Zain Cox  Prof. Zara Le  Prof. Zion Mcgee  \n",
       "0                  0              0                 0  \n",
       "1                  0              0                 0  \n",
       "2                  0              0                 0  \n",
       "3                  0              0                 0  \n",
       "4                  0              0                 0  \n",
       "...              ...            ...               ...  \n",
       "9995               0              0                 0  \n",
       "9996               0              0                 0  \n",
       "9997               0              0                 0  \n",
       "9998               0              0                 0  \n",
       "9999               0              0                 0  \n",
       "\n",
       "[10000 rows x 1219 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.concat([df, Faculty_dummies.drop('Prof. Zoie Mueller', axis = 'columns')], axis='columns')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-03-25T17:35:25.019654Z",
     "iopub.status.busy": "2022-03-25T17:35:25.019374Z",
     "iopub.status.idle": "2022-03-25T17:35:25.073672Z",
     "shell.execute_reply": "2022-03-25T17:35:25.073053Z",
     "shell.execute_reply.started": "2022-03-25T17:35:25.019624Z"
    },
    "id": "hzXIuwkCR9_D"
   },
   "outputs": [],
   "source": [
    "min_year = min(df['Year'])\n",
    "max_year = max(df['Year'])\n",
    "\n",
    "df['Year_'] = df['Year'].apply(lambda x: ( x - min_year ) / ( max_year - min_year ))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "execution": {
     "iopub.execute_input": "2022-03-25T17:35:29.881514Z",
     "iopub.status.busy": "2022-03-25T17:35:29.881071Z",
     "iopub.status.idle": "2022-03-25T17:35:29.889699Z",
     "shell.execute_reply": "2022-03-25T17:35:29.888806Z",
     "shell.execute_reply.started": "2022-03-25T17:35:29.881471Z"
    },
    "id": "_iAe2jdGR9_E",
    "outputId": "afc8c655-0bee-4da4-dd28-7dcfb8cce239"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Id                      int64\n",
       "Timestep               object\n",
       "Course                 object\n",
       "Faculty                object\n",
       "Year                    int64\n",
       "                       ...   \n",
       "Prof. Yurem Horton      uint8\n",
       "Prof. Zain Cox          uint8\n",
       "Prof. Zara Le           uint8\n",
       "Prof. Zion Mcgee        uint8\n",
       "Year_                 float64\n",
       "Length: 1220, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2022-03-25T17:35:34.613742Z",
     "iopub.status.busy": "2022-03-25T17:35:34.613112Z",
     "iopub.status.idle": "2022-03-25T17:35:34.923464Z",
     "shell.execute_reply": "2022-03-25T17:35:34.922694Z",
     "shell.execute_reply.started": "2022-03-25T17:35:34.613694Z"
    },
    "id": "eVgi5rMQR9_E"
   },
   "outputs": [],
   "source": [
    "x = df.drop(['Id', 'Timestep', 'Course', 'Faculty', 'Year_'], axis = 'columns')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "A2Sa_-mXXV03",
    "outputId": "6e78ced5-0c70-4985-929a-5b4df896e4ae"
   },
   "outputs": [],
   "source": [
    "y_pred = model.predict(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "id": "LIX1lpa_YwoX"
   },
   "outputs": [],
   "source": [
    "df['Predicted'] = y_pred+25"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "id": "rCKgvfYCYxPl"
   },
   "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>Id</th>\n",
       "      <th>Predicted</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>766.140590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>438.477667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>586.860850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>411.068904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1045.373388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>9995</td>\n",
       "      <td>1015.309849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>9996</td>\n",
       "      <td>963.902811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>9997</td>\n",
       "      <td>460.110281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>9998</td>\n",
       "      <td>733.147405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>9999</td>\n",
       "      <td>400.299191</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10000 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Id    Predicted\n",
       "0        0   766.140590\n",
       "1        1   438.477667\n",
       "2        2   586.860850\n",
       "3        3   411.068904\n",
       "4        4  1045.373388\n",
       "...    ...          ...\n",
       "9995  9995  1015.309849\n",
       "9996  9996   963.902811\n",
       "9997  9997   460.110281\n",
       "9998  9998   733.147405\n",
       "9999  9999   400.299191\n",
       "\n",
       "[10000 rows x 2 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_submission = df[['Id', 'Predicted']]\n",
    "df_submission"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "id": "LER-wKITbEJp"
   },
   "outputs": [],
   "source": [
    "df_submission.to_csv(\"submission_best.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "id": "6p4F5nO1bRRa"
   },
   "outputs": [],
   "source": [
    "for i in df_submission['Predicted']:\n",
    "    if i < 0:\n",
    "        print(i)"
   ]
  }
 ],
 "metadata": {
  "accelerator": "GPU",
  "colab": {
   "name": "Copy of pray-hack.ipynb",
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}