Student Data for Mechatronics Program KFS University.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40102</td>\n",
       "      <td>Engineering Mechanics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40105</td>\n",
       "      <td>Production Technology 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40106</td>\n",
       "      <td>Engineering Mechanics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40102.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40501</td>\n",
       "      <td>Engineering  Mathematics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40502</td>\n",
       "      <td>Engineering Physics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>40503</td>\n",
       "      <td>Engineering Chemistry</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>40504</td>\n",
       "      <td>Engineering  Mathematics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>40505</td>\n",
       "      <td>Engineering Physics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>40101</td>\n",
       "      <td>CAD 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>40103</td>\n",
       "      <td>CAD 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40101.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>40104</td>\n",
       "      <td>Engineering History</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>40144</td>\n",
       "      <td>Technical English</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>40108</td>\n",
       "      <td>Engineering Mechanics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40106.0</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>40109</td>\n",
       "      <td>Thermodynamics</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>40111</td>\n",
       "      <td>Stress Analysis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>40112</td>\n",
       "      <td>Fluid Mechanics</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>40113</td>\n",
       "      <td>Material</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>40506</td>\n",
       "      <td>Engineering  Mathematics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>40507</td>\n",
       "      <td>Engineering  Mathematics 4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>40203</td>\n",
       "      <td>Electric and electronic circuits</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>40201</td>\n",
       "      <td>Introduction to computer science and programming</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>40204</td>\n",
       "      <td>Logic gates and Microprocessor</td>\n",
       "      <td>1.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>40107</td>\n",
       "      <td>Computer-Aided mechanical Drawing</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>40508</td>\n",
       "      <td>Engineering Physics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>40114</td>\n",
       "      <td>Computer-Aided mechanical Design 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>40111.0</td>\n",
       "      <td>40113.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>40115</td>\n",
       "      <td>Theory of Viberation</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>40116</td>\n",
       "      <td>Theory of Machines</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>40117</td>\n",
       "      <td>Production Technology 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40105.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>40118</td>\n",
       "      <td>Mechatronics Engineering</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40204.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>40119</td>\n",
       "      <td>Computer-Aided mechanical Design 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40114.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>40205</td>\n",
       "      <td>Automatic Control Systems</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40204.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>40202</td>\n",
       "      <td>Algorithms and Data Structure</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>40206</td>\n",
       "      <td>Digital Control Systems NC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>40207</td>\n",
       "      <td>Electrical Motors</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>40208</td>\n",
       "      <td>Sensors and Measurement Instruments</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>40110</td>\n",
       "      <td>Technical Writing</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>40218</td>\n",
       "      <td>Power Electronics</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40207.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>40131</td>\n",
       "      <td>Pneumatic and hydraulic systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>40134</td>\n",
       "      <td>Industrial Automation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40206.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40209</td>\n",
       "      <td>Adapters and Relays</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40130</td>\n",
       "      <td>Simulation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>40121</td>\n",
       "      <td>Mechatronics Systems 1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40209.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0</td>\n",
       "      <td>Humans Rights</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>40129</td>\n",
       "      <td>Advanced Manufacturing Systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40117.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>40216</td>\n",
       "      <td>Computer Vision</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>40145</td>\n",
       "      <td>Industrial Engineering</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40129.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>40217</td>\n",
       "      <td>Artificial Inteligence</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>40135</td>\n",
       "      <td>Mechatronics Systems 2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40134.0</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>40136</td>\n",
       "      <td>Project Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>40146</td>\n",
       "      <td>Quality Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>40147</td>\n",
       "      <td>Engineering Economy</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>40001</td>\n",
       "      <td>Computer and its applications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>50001</td>\n",
       "      <td>Feasibility study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>40145</td>\n",
       "      <td>Communication and presentation skills</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>40147</td>\n",
       "      <td>Environmental Study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                                            course  level  \\\n",
       "0   40102                           Engineering Mechanics 1    0.0   \n",
       "1   40105                           Production Technology 1    0.0   \n",
       "2   40106                           Engineering Mechanics 2    0.0   \n",
       "3   40501                        Engineering  Mathematics 1    0.0   \n",
       "4   40502                             Engineering Physics 1    0.0   \n",
       "5   40503                             Engineering Chemistry    0.0   \n",
       "6   40504                        Engineering  Mathematics 2    0.0   \n",
       "7   40505                             Engineering Physics 2    0.0   \n",
       "8   40101                                             CAD 1    0.0   \n",
       "9   40103                                             CAD 2    0.0   \n",
       "10  40104                               Engineering History    0.0   \n",
       "11  40144                                 Technical English    0.0   \n",
       "12  40108                           Engineering Mechanics 3    1.0   \n",
       "13  40109                                    Thermodynamics    1.0   \n",
       "14  40111                                   Stress Analysis    1.0   \n",
       "15  40112                                   Fluid Mechanics    1.0   \n",
       "16  40113                                         Material     1.0   \n",
       "17  40506                        Engineering  Mathematics 3    1.0   \n",
       "18  40507                        Engineering  Mathematics 4    1.0   \n",
       "19  40203                  Electric and electronic circuits    1.0   \n",
       "20  40201  Introduction to computer science and programming    1.0   \n",
       "21  40204                    Logic gates and Microprocessor    1.0   \n",
       "22  40107                 Computer-Aided mechanical Drawing    1.0   \n",
       "23  40508                             Engineering Physics 3    1.0   \n",
       "24  40114                Computer-Aided mechanical Design 1    2.0   \n",
       "25  40115                              Theory of Viberation    2.0   \n",
       "26  40116                                Theory of Machines    2.0   \n",
       "27  40117                           Production Technology 2    2.0   \n",
       "28  40118                          Mechatronics Engineering    2.0   \n",
       "29  40119                Computer-Aided mechanical Design 2    2.0   \n",
       "30  40205                         Automatic Control Systems    2.0   \n",
       "31  40202                     Algorithms and Data Structure    2.0   \n",
       "32  40206                        Digital Control Systems NC    2.0   \n",
       "33  40207                                 Electrical Motors    2.0   \n",
       "34  40208               Sensors and Measurement Instruments    2.0   \n",
       "35  40110                                 Technical Writing    2.0   \n",
       "36  40218                                 Power Electronics    3.0   \n",
       "37  40131                   Pneumatic and hydraulic systems    3.0   \n",
       "38  40134                             Industrial Automation    3.0   \n",
       "39  40209                               Adapters and Relays    3.0   \n",
       "40  40130                                        Simulation    3.0   \n",
       "41  40121                            Mechatronics Systems 1    3.0   \n",
       "42      0                                     Humans Rights    3.0   \n",
       "43  40129                    Advanced Manufacturing Systems    3.0   \n",
       "44  40216                                   Computer Vision    4.0   \n",
       "45  40145                            Industrial Engineering    4.0   \n",
       "46  40217                            Artificial Inteligence    4.0   \n",
       "47  40135                            Mechatronics Systems 2    4.0   \n",
       "48  40136                                Project Management    4.0   \n",
       "49  40146                                Quality Management    4.0   \n",
       "50  40147                               Engineering Economy    4.0   \n",
       "51  40001                     Computer and its applications    NaN   \n",
       "52  50001                                 Feasibility study    NaN   \n",
       "53  40145             Communication and presentation skills    NaN   \n",
       "54  40147                               Environmental Study    NaN   \n",
       "\n",
       "                       type  hours  if_taken  prerequisite_1  prerequisite_2  \\\n",
       "0   Fundamental Engineering      3      True             NaN             NaN   \n",
       "1       General Engineering      3      True             NaN             NaN   \n",
       "2   Fundamental Engineering      3      True         40102.0             NaN   \n",
       "3             Basic Science      3      True             NaN             NaN   \n",
       "4             Basic Science      3      True             NaN             NaN   \n",
       "5             Basic Science      3      True             NaN             NaN   \n",
       "6             Basic Science      3      True             NaN             NaN   \n",
       "7             Basic Science      3      True             NaN             NaN   \n",
       "8     computer applications      2      True             NaN             NaN   \n",
       "9     computer applications      2      True         40101.0             NaN   \n",
       "10           Social Science      2      True             NaN             NaN   \n",
       "11           Social Science      2      True             NaN             NaN   \n",
       "12  Fundamental Engineering      3      True         40106.0         40504.0   \n",
       "13  Fundamental Engineering      3      True         40504.0         40505.0   \n",
       "14  Fundamental Engineering      3     False         40108.0             NaN   \n",
       "15  Fundamental Engineering      3      True         40502.0         40506.0   \n",
       "16  Fundamental Engineering      3      True         40502.0             NaN   \n",
       "17            Basic Science      3      True             NaN             NaN   \n",
       "18            Basic Science      3      True             NaN             NaN   \n",
       "19  Fundamental Engineering      3      True         40506.0             NaN   \n",
       "20    computer applications      3      True             NaN             NaN   \n",
       "21      General Engineering      3      True         40203.0         40506.0   \n",
       "22    computer applications      2      True         40103.0             NaN   \n",
       "23            Basic Science      2      True             NaN             NaN   \n",
       "24    computer applications      3     False         40103.0         40111.0   \n",
       "25  Fundamental Engineering      3     False         40108.0         40506.0   \n",
       "26  Fundamental Engineering      3      True         40108.0             NaN   \n",
       "27      General Engineering      3      True         40105.0             NaN   \n",
       "28      General Engineering      3      True         40204.0             NaN   \n",
       "29    computer applications      3     False         40114.0             NaN   \n",
       "30  Fundamental Engineering      3      True         40204.0             NaN   \n",
       "31    computer applications      3      True         40201.0             NaN   \n",
       "32      General Engineering      3     False         40205.0             NaN   \n",
       "33  Fundamental Engineering      3     False         40108.0         40203.0   \n",
       "34  Fundamental Engineering      3     False         40203.0             NaN   \n",
       "35           Social Science      2      True             NaN             NaN   \n",
       "36  Fundamental Engineering      3     False         40207.0             NaN   \n",
       "37      General Engineering      3     False         40108.0         40109.0   \n",
       "38      General Engineering      3     False         40118.0         40109.0   \n",
       "39      General Engineering      3     False         40205.0             NaN   \n",
       "40    computer applications      3     False         40108.0         40109.0   \n",
       "41      General Engineering      2     False         40118.0         40208.0   \n",
       "42           Social Science      2      True             NaN             NaN   \n",
       "43      General Engineering      2     False         40118.0         40117.0   \n",
       "44      General Engineering      3      True         40507.0             NaN   \n",
       "45      General Engineering      3     False         40129.0             NaN   \n",
       "46      General Engineering      3     False         40507.0         40201.0   \n",
       "47      General Engineering      2     False         40112.0         40109.0   \n",
       "48      General Engineering      2      True         40506.0             NaN   \n",
       "49      General Engineering      2     False             NaN             NaN   \n",
       "50           Social Science      2      True             NaN             NaN   \n",
       "51          Elective course      2      True             NaN             NaN   \n",
       "52          Elective course      2     False             NaN             NaN   \n",
       "53          Elective course      2      True             NaN             NaN   \n",
       "54          Elective course      2      True             NaN             NaN   \n",
       "\n",
       "    prerequisite_3  prerequisite_4  prerequisite_5  GPA  \n",
       "0              NaN             NaN             NaN  4.0  \n",
       "1              NaN             NaN             NaN  2.7  \n",
       "2              NaN             NaN             NaN  4.0  \n",
       "3              NaN             NaN             NaN  3.3  \n",
       "4              NaN             NaN             NaN  3.7  \n",
       "5              NaN             NaN             NaN  3.7  \n",
       "6              NaN             NaN             NaN  4.0  \n",
       "7              NaN             NaN             NaN  3.7  \n",
       "8              NaN             NaN             NaN  4.0  \n",
       "9              NaN             NaN             NaN  4.0  \n",
       "10             NaN             NaN             NaN  4.0  \n",
       "11             NaN             NaN             NaN  4.0  \n",
       "12             NaN             NaN             NaN  4.0  \n",
       "13             NaN             NaN             NaN  NaN  \n",
       "14             NaN             NaN             NaN  NaN  \n",
       "15             NaN             NaN             NaN  NaN  \n",
       "16             NaN             NaN             NaN  4.0  \n",
       "17             NaN             NaN             NaN  4.0  \n",
       "18             NaN             NaN             NaN  NaN  \n",
       "19             NaN             NaN             NaN  NaN  \n",
       "20             NaN             NaN             NaN  4.0  \n",
       "21         40505.0             NaN             NaN  4.0  \n",
       "22             NaN             NaN             NaN  4.0  \n",
       "23             NaN             NaN             NaN  4.0  \n",
       "24         40113.0             NaN             NaN  NaN  \n",
       "25         40508.0             NaN             NaN  NaN  \n",
       "26             NaN             NaN             NaN  NaN  \n",
       "27             NaN             NaN             NaN  NaN  \n",
       "28             NaN             NaN             NaN  NaN  \n",
       "29             NaN             NaN             NaN  NaN  \n",
       "30             NaN             NaN             NaN  NaN  \n",
       "31             NaN             NaN             NaN  4.0  \n",
       "32             NaN             NaN             NaN  NaN  \n",
       "33             NaN             NaN             NaN  NaN  \n",
       "34             NaN             NaN             NaN  NaN  \n",
       "35             NaN             NaN             NaN  4.0  \n",
       "36             NaN             NaN             NaN  NaN  \n",
       "37         40112.0             NaN             NaN  NaN  \n",
       "38         40112.0         40208.0         40206.0  NaN  \n",
       "39             NaN             NaN             NaN  NaN  \n",
       "40         40112.0         40508.0         40201.0  NaN  \n",
       "41         40209.0             NaN             NaN  NaN  \n",
       "42             NaN             NaN             NaN  4.0  \n",
       "43             NaN             NaN             NaN  NaN  \n",
       "44             NaN             NaN             NaN  NaN  \n",
       "45             NaN             NaN             NaN  NaN  \n",
       "46             NaN             NaN             NaN  NaN  \n",
       "47         40134.0         40118.0         40208.0  NaN  \n",
       "48             NaN             NaN             NaN  2.3  \n",
       "49             NaN             NaN             NaN  NaN  \n",
       "50             NaN             NaN             NaN  4.0  \n",
       "51             NaN             NaN             NaN  3.7  \n",
       "52             NaN             NaN             NaN  NaN  \n",
       "53             NaN             NaN             NaN  4.0  \n",
       "54             NaN             NaN             NaN  NaN  "
      ]
     },
     "execution_count": 187,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.read_csv('Mechatronics_Data.csv')\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-188-6c30ecb977db>:6: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df.code[x]=df.code[x].zfill(5)\n"
     ]
    }
   ],
   "source": [
    "#Now the courses'codes are string\n",
    "df.code=df.code.astype(dtype=str,copy=False,errors='ignore')\n",
    "\n",
    "df.code=df.code.infer_objects()\n",
    "for x in range(0,len(df.code)):\n",
    "    df.code[x]=df.code[x].zfill(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40102</td>\n",
       "      <td>Engineering Mechanics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40105</td>\n",
       "      <td>Production Technology 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40106</td>\n",
       "      <td>Engineering Mechanics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40102.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40501</td>\n",
       "      <td>Engineering  Mathematics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40502</td>\n",
       "      <td>Engineering Physics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>40503</td>\n",
       "      <td>Engineering Chemistry</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>40504</td>\n",
       "      <td>Engineering  Mathematics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>40505</td>\n",
       "      <td>Engineering Physics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>40101</td>\n",
       "      <td>CAD 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>40103</td>\n",
       "      <td>CAD 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40101.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>40104</td>\n",
       "      <td>Engineering History</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>40144</td>\n",
       "      <td>Technical English</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>40108</td>\n",
       "      <td>Engineering Mechanics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40106.0</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>40109</td>\n",
       "      <td>Thermodynamics</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>40111</td>\n",
       "      <td>Stress Analysis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>40112</td>\n",
       "      <td>Fluid Mechanics</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>40113</td>\n",
       "      <td>Material</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>40506</td>\n",
       "      <td>Engineering  Mathematics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>40507</td>\n",
       "      <td>Engineering  Mathematics 4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>40203</td>\n",
       "      <td>Electric and electronic circuits</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>40201</td>\n",
       "      <td>Introduction to computer science and programming</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>40204</td>\n",
       "      <td>Logic gates and Microprocessor</td>\n",
       "      <td>1.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>40107</td>\n",
       "      <td>Computer-Aided mechanical Drawing</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>40508</td>\n",
       "      <td>Engineering Physics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>40114</td>\n",
       "      <td>Computer-Aided mechanical Design 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>40111.0</td>\n",
       "      <td>40113.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>40115</td>\n",
       "      <td>Theory of Viberation</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>40116</td>\n",
       "      <td>Theory of Machines</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>40117</td>\n",
       "      <td>Production Technology 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40105.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>40118</td>\n",
       "      <td>Mechatronics Engineering</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40204.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>40119</td>\n",
       "      <td>Computer-Aided mechanical Design 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40114.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>40205</td>\n",
       "      <td>Automatic Control Systems</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40204.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>40202</td>\n",
       "      <td>Algorithms and Data Structure</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>40206</td>\n",
       "      <td>Digital Control Systems NC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>40207</td>\n",
       "      <td>Electrical Motors</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>40208</td>\n",
       "      <td>Sensors and Measurement Instruments</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>40110</td>\n",
       "      <td>Technical Writing</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>40218</td>\n",
       "      <td>Power Electronics</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40207.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>40131</td>\n",
       "      <td>Pneumatic and hydraulic systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>40134</td>\n",
       "      <td>Industrial Automation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40206.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40209</td>\n",
       "      <td>Adapters and Relays</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40130</td>\n",
       "      <td>Simulation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>40121</td>\n",
       "      <td>Mechatronics Systems 1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40209.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>00000</td>\n",
       "      <td>Humans Rights</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>40129</td>\n",
       "      <td>Advanced Manufacturing Systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40117.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>40216</td>\n",
       "      <td>Computer Vision</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>40145</td>\n",
       "      <td>Industrial Engineering</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40129.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>40217</td>\n",
       "      <td>Artificial Inteligence</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>40135</td>\n",
       "      <td>Mechatronics Systems 2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40134.0</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>40136</td>\n",
       "      <td>Project Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>40146</td>\n",
       "      <td>Quality Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>40147</td>\n",
       "      <td>Engineering Economy</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>40001</td>\n",
       "      <td>Computer and its applications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>50001</td>\n",
       "      <td>Feasibility study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>40145</td>\n",
       "      <td>Communication and presentation skills</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>40147</td>\n",
       "      <td>Environmental Study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                                            course  level  \\\n",
       "0   40102                           Engineering Mechanics 1    0.0   \n",
       "1   40105                           Production Technology 1    0.0   \n",
       "2   40106                           Engineering Mechanics 2    0.0   \n",
       "3   40501                        Engineering  Mathematics 1    0.0   \n",
       "4   40502                             Engineering Physics 1    0.0   \n",
       "5   40503                             Engineering Chemistry    0.0   \n",
       "6   40504                        Engineering  Mathematics 2    0.0   \n",
       "7   40505                             Engineering Physics 2    0.0   \n",
       "8   40101                                             CAD 1    0.0   \n",
       "9   40103                                             CAD 2    0.0   \n",
       "10  40104                               Engineering History    0.0   \n",
       "11  40144                                 Technical English    0.0   \n",
       "12  40108                           Engineering Mechanics 3    1.0   \n",
       "13  40109                                    Thermodynamics    1.0   \n",
       "14  40111                                   Stress Analysis    1.0   \n",
       "15  40112                                   Fluid Mechanics    1.0   \n",
       "16  40113                                         Material     1.0   \n",
       "17  40506                        Engineering  Mathematics 3    1.0   \n",
       "18  40507                        Engineering  Mathematics 4    1.0   \n",
       "19  40203                  Electric and electronic circuits    1.0   \n",
       "20  40201  Introduction to computer science and programming    1.0   \n",
       "21  40204                    Logic gates and Microprocessor    1.0   \n",
       "22  40107                 Computer-Aided mechanical Drawing    1.0   \n",
       "23  40508                             Engineering Physics 3    1.0   \n",
       "24  40114                Computer-Aided mechanical Design 1    2.0   \n",
       "25  40115                              Theory of Viberation    2.0   \n",
       "26  40116                                Theory of Machines    2.0   \n",
       "27  40117                           Production Technology 2    2.0   \n",
       "28  40118                          Mechatronics Engineering    2.0   \n",
       "29  40119                Computer-Aided mechanical Design 2    2.0   \n",
       "30  40205                         Automatic Control Systems    2.0   \n",
       "31  40202                     Algorithms and Data Structure    2.0   \n",
       "32  40206                        Digital Control Systems NC    2.0   \n",
       "33  40207                                 Electrical Motors    2.0   \n",
       "34  40208               Sensors and Measurement Instruments    2.0   \n",
       "35  40110                                 Technical Writing    2.0   \n",
       "36  40218                                 Power Electronics    3.0   \n",
       "37  40131                   Pneumatic and hydraulic systems    3.0   \n",
       "38  40134                             Industrial Automation    3.0   \n",
       "39  40209                               Adapters and Relays    3.0   \n",
       "40  40130                                        Simulation    3.0   \n",
       "41  40121                            Mechatronics Systems 1    3.0   \n",
       "42  00000                                     Humans Rights    3.0   \n",
       "43  40129                    Advanced Manufacturing Systems    3.0   \n",
       "44  40216                                   Computer Vision    4.0   \n",
       "45  40145                            Industrial Engineering    4.0   \n",
       "46  40217                            Artificial Inteligence    4.0   \n",
       "47  40135                            Mechatronics Systems 2    4.0   \n",
       "48  40136                                Project Management    4.0   \n",
       "49  40146                                Quality Management    4.0   \n",
       "50  40147                               Engineering Economy    4.0   \n",
       "51  40001                     Computer and its applications    NaN   \n",
       "52  50001                                 Feasibility study    NaN   \n",
       "53  40145             Communication and presentation skills    NaN   \n",
       "54  40147                               Environmental Study    NaN   \n",
       "\n",
       "                       type  hours  if_taken  prerequisite_1  prerequisite_2  \\\n",
       "0   Fundamental Engineering      3      True             NaN             NaN   \n",
       "1       General Engineering      3      True             NaN             NaN   \n",
       "2   Fundamental Engineering      3      True         40102.0             NaN   \n",
       "3             Basic Science      3      True             NaN             NaN   \n",
       "4             Basic Science      3      True             NaN             NaN   \n",
       "5             Basic Science      3      True             NaN             NaN   \n",
       "6             Basic Science      3      True             NaN             NaN   \n",
       "7             Basic Science      3      True             NaN             NaN   \n",
       "8     computer applications      2      True             NaN             NaN   \n",
       "9     computer applications      2      True         40101.0             NaN   \n",
       "10           Social Science      2      True             NaN             NaN   \n",
       "11           Social Science      2      True             NaN             NaN   \n",
       "12  Fundamental Engineering      3      True         40106.0         40504.0   \n",
       "13  Fundamental Engineering      3      True         40504.0         40505.0   \n",
       "14  Fundamental Engineering      3     False         40108.0             NaN   \n",
       "15  Fundamental Engineering      3      True         40502.0         40506.0   \n",
       "16  Fundamental Engineering      3      True         40502.0             NaN   \n",
       "17            Basic Science      3      True             NaN             NaN   \n",
       "18            Basic Science      3      True             NaN             NaN   \n",
       "19  Fundamental Engineering      3      True         40506.0             NaN   \n",
       "20    computer applications      3      True             NaN             NaN   \n",
       "21      General Engineering      3      True         40203.0         40506.0   \n",
       "22    computer applications      2      True         40103.0             NaN   \n",
       "23            Basic Science      2      True             NaN             NaN   \n",
       "24    computer applications      3     False         40103.0         40111.0   \n",
       "25  Fundamental Engineering      3     False         40108.0         40506.0   \n",
       "26  Fundamental Engineering      3      True         40108.0             NaN   \n",
       "27      General Engineering      3      True         40105.0             NaN   \n",
       "28      General Engineering      3      True         40204.0             NaN   \n",
       "29    computer applications      3     False         40114.0             NaN   \n",
       "30  Fundamental Engineering      3      True         40204.0             NaN   \n",
       "31    computer applications      3      True         40201.0             NaN   \n",
       "32      General Engineering      3     False         40205.0             NaN   \n",
       "33  Fundamental Engineering      3     False         40108.0         40203.0   \n",
       "34  Fundamental Engineering      3     False         40203.0             NaN   \n",
       "35           Social Science      2      True             NaN             NaN   \n",
       "36  Fundamental Engineering      3     False         40207.0             NaN   \n",
       "37      General Engineering      3     False         40108.0         40109.0   \n",
       "38      General Engineering      3     False         40118.0         40109.0   \n",
       "39      General Engineering      3     False         40205.0             NaN   \n",
       "40    computer applications      3     False         40108.0         40109.0   \n",
       "41      General Engineering      2     False         40118.0         40208.0   \n",
       "42           Social Science      2      True             NaN             NaN   \n",
       "43      General Engineering      2     False         40118.0         40117.0   \n",
       "44      General Engineering      3      True         40507.0             NaN   \n",
       "45      General Engineering      3     False         40129.0             NaN   \n",
       "46      General Engineering      3     False         40507.0         40201.0   \n",
       "47      General Engineering      2     False         40112.0         40109.0   \n",
       "48      General Engineering      2      True         40506.0             NaN   \n",
       "49      General Engineering      2     False             NaN             NaN   \n",
       "50           Social Science      2      True             NaN             NaN   \n",
       "51          Elective course      2      True             NaN             NaN   \n",
       "52          Elective course      2     False             NaN             NaN   \n",
       "53          Elective course      2      True             NaN             NaN   \n",
       "54          Elective course      2      True             NaN             NaN   \n",
       "\n",
       "    prerequisite_3  prerequisite_4  prerequisite_5  GPA  \n",
       "0              NaN             NaN             NaN  4.0  \n",
       "1              NaN             NaN             NaN  2.7  \n",
       "2              NaN             NaN             NaN  4.0  \n",
       "3              NaN             NaN             NaN  3.3  \n",
       "4              NaN             NaN             NaN  3.7  \n",
       "5              NaN             NaN             NaN  3.7  \n",
       "6              NaN             NaN             NaN  4.0  \n",
       "7              NaN             NaN             NaN  3.7  \n",
       "8              NaN             NaN             NaN  4.0  \n",
       "9              NaN             NaN             NaN  4.0  \n",
       "10             NaN             NaN             NaN  4.0  \n",
       "11             NaN             NaN             NaN  4.0  \n",
       "12             NaN             NaN             NaN  4.0  \n",
       "13             NaN             NaN             NaN  NaN  \n",
       "14             NaN             NaN             NaN  NaN  \n",
       "15             NaN             NaN             NaN  NaN  \n",
       "16             NaN             NaN             NaN  4.0  \n",
       "17             NaN             NaN             NaN  4.0  \n",
       "18             NaN             NaN             NaN  NaN  \n",
       "19             NaN             NaN             NaN  NaN  \n",
       "20             NaN             NaN             NaN  4.0  \n",
       "21         40505.0             NaN             NaN  4.0  \n",
       "22             NaN             NaN             NaN  4.0  \n",
       "23             NaN             NaN             NaN  4.0  \n",
       "24         40113.0             NaN             NaN  NaN  \n",
       "25         40508.0             NaN             NaN  NaN  \n",
       "26             NaN             NaN             NaN  NaN  \n",
       "27             NaN             NaN             NaN  NaN  \n",
       "28             NaN             NaN             NaN  NaN  \n",
       "29             NaN             NaN             NaN  NaN  \n",
       "30             NaN             NaN             NaN  NaN  \n",
       "31             NaN             NaN             NaN  4.0  \n",
       "32             NaN             NaN             NaN  NaN  \n",
       "33             NaN             NaN             NaN  NaN  \n",
       "34             NaN             NaN             NaN  NaN  \n",
       "35             NaN             NaN             NaN  4.0  \n",
       "36             NaN             NaN             NaN  NaN  \n",
       "37         40112.0             NaN             NaN  NaN  \n",
       "38         40112.0         40208.0         40206.0  NaN  \n",
       "39             NaN             NaN             NaN  NaN  \n",
       "40         40112.0         40508.0         40201.0  NaN  \n",
       "41         40209.0             NaN             NaN  NaN  \n",
       "42             NaN             NaN             NaN  4.0  \n",
       "43             NaN             NaN             NaN  NaN  \n",
       "44             NaN             NaN             NaN  NaN  \n",
       "45             NaN             NaN             NaN  NaN  \n",
       "46             NaN             NaN             NaN  NaN  \n",
       "47         40134.0         40118.0         40208.0  NaN  \n",
       "48             NaN             NaN             NaN  2.3  \n",
       "49             NaN             NaN             NaN  NaN  \n",
       "50             NaN             NaN             NaN  4.0  \n",
       "51             NaN             NaN             NaN  3.7  \n",
       "52             NaN             NaN             NaN  NaN  \n",
       "53             NaN             NaN             NaN  4.0  \n",
       "54             NaN             NaN             NaN  NaN  "
      ]
     },
     "execution_count": 189,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The courses I have taken so far"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df.loc[df.code=='40109','if_taken']= True\n",
    "# df.loc[df.code=='40116','if_taken']= True\n",
    "# df.loc[df.code=='40147','if_taken']= True\n",
    "# df.loc[df.code=='40117','if_taken']= True\n",
    "# df.loc[df.code=='40118','if_taken']= True\n",
    "# df.loc[df.code=='40216','if_taken']= True\n",
    "# df.loc[df.code=='40205','if_taken']= True"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "GPA for each course"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df.loc[df.code =='40102' ,'GPA'] = 3.7\n",
    "# df.loc[df.code =='40105' ,'GPA'] = 3.3\n",
    "# df.loc[df.code =='40106' ,'GPA'] = \n",
    "# df.loc[df.code =='40501' ,'GPA'] = \n",
    "# df.loc[df.code =='40502' ,'GPA'] = \n",
    "# df.loc[df.code =='40503' ,'GPA'] = \n",
    "# df.loc[df.code =='40504' ,'GPA'] = \n",
    "# df.loc[df.code =='40505' ,'GPA'] = "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('last updated data.csv',index=0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The Courses I have taken "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40102</td>\n",
       "      <td>Engineering Mechanics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40105</td>\n",
       "      <td>Production Technology 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40106</td>\n",
       "      <td>Engineering Mechanics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40102.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40501</td>\n",
       "      <td>Engineering  Mathematics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40502</td>\n",
       "      <td>Engineering Physics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>40503</td>\n",
       "      <td>Engineering Chemistry</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>40504</td>\n",
       "      <td>Engineering  Mathematics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>40505</td>\n",
       "      <td>Engineering Physics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>40101</td>\n",
       "      <td>CAD 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>40103</td>\n",
       "      <td>CAD 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40101.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>40104</td>\n",
       "      <td>Engineering History</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>40144</td>\n",
       "      <td>Technical English</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>40108</td>\n",
       "      <td>Engineering Mechanics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40106.0</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>40109</td>\n",
       "      <td>Thermodynamics</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>40112</td>\n",
       "      <td>Fluid Mechanics</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>40113</td>\n",
       "      <td>Material</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>40506</td>\n",
       "      <td>Engineering  Mathematics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>40507</td>\n",
       "      <td>Engineering  Mathematics 4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>40203</td>\n",
       "      <td>Electric and electronic circuits</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>40201</td>\n",
       "      <td>Introduction to computer science and programming</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>40204</td>\n",
       "      <td>Logic gates and Microprocessor</td>\n",
       "      <td>1.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>40107</td>\n",
       "      <td>Computer-Aided mechanical Drawing</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>40508</td>\n",
       "      <td>Engineering Physics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>40116</td>\n",
       "      <td>Theory of Machines</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>40117</td>\n",
       "      <td>Production Technology 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40105.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>40118</td>\n",
       "      <td>Mechatronics Engineering</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40204.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>40205</td>\n",
       "      <td>Automatic Control Systems</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40204.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>40202</td>\n",
       "      <td>Algorithms and Data Structure</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>40110</td>\n",
       "      <td>Technical Writing</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>00000</td>\n",
       "      <td>Humans Rights</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>40216</td>\n",
       "      <td>Computer Vision</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>40136</td>\n",
       "      <td>Project Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>40147</td>\n",
       "      <td>Engineering Economy</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>40001</td>\n",
       "      <td>Computer and its applications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>40145</td>\n",
       "      <td>Communication and presentation skills</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>40147</td>\n",
       "      <td>Environmental Study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                                            course  level  \\\n",
       "0   40102                           Engineering Mechanics 1    0.0   \n",
       "1   40105                           Production Technology 1    0.0   \n",
       "2   40106                           Engineering Mechanics 2    0.0   \n",
       "3   40501                        Engineering  Mathematics 1    0.0   \n",
       "4   40502                             Engineering Physics 1    0.0   \n",
       "5   40503                             Engineering Chemistry    0.0   \n",
       "6   40504                        Engineering  Mathematics 2    0.0   \n",
       "7   40505                             Engineering Physics 2    0.0   \n",
       "8   40101                                             CAD 1    0.0   \n",
       "9   40103                                             CAD 2    0.0   \n",
       "10  40104                               Engineering History    0.0   \n",
       "11  40144                                 Technical English    0.0   \n",
       "12  40108                           Engineering Mechanics 3    1.0   \n",
       "13  40109                                    Thermodynamics    1.0   \n",
       "15  40112                                   Fluid Mechanics    1.0   \n",
       "16  40113                                         Material     1.0   \n",
       "17  40506                        Engineering  Mathematics 3    1.0   \n",
       "18  40507                        Engineering  Mathematics 4    1.0   \n",
       "19  40203                  Electric and electronic circuits    1.0   \n",
       "20  40201  Introduction to computer science and programming    1.0   \n",
       "21  40204                    Logic gates and Microprocessor    1.0   \n",
       "22  40107                 Computer-Aided mechanical Drawing    1.0   \n",
       "23  40508                             Engineering Physics 3    1.0   \n",
       "26  40116                                Theory of Machines    2.0   \n",
       "27  40117                           Production Technology 2    2.0   \n",
       "28  40118                          Mechatronics Engineering    2.0   \n",
       "30  40205                         Automatic Control Systems    2.0   \n",
       "31  40202                     Algorithms and Data Structure    2.0   \n",
       "35  40110                                 Technical Writing    2.0   \n",
       "42  00000                                     Humans Rights    3.0   \n",
       "44  40216                                   Computer Vision    4.0   \n",
       "48  40136                                Project Management    4.0   \n",
       "50  40147                               Engineering Economy    4.0   \n",
       "51  40001                     Computer and its applications    NaN   \n",
       "53  40145             Communication and presentation skills    NaN   \n",
       "54  40147                               Environmental Study    NaN   \n",
       "\n",
       "                       type  hours  if_taken  prerequisite_1  prerequisite_2  \\\n",
       "0   Fundamental Engineering      3      True             NaN             NaN   \n",
       "1       General Engineering      3      True             NaN             NaN   \n",
       "2   Fundamental Engineering      3      True         40102.0             NaN   \n",
       "3             Basic Science      3      True             NaN             NaN   \n",
       "4             Basic Science      3      True             NaN             NaN   \n",
       "5             Basic Science      3      True             NaN             NaN   \n",
       "6             Basic Science      3      True             NaN             NaN   \n",
       "7             Basic Science      3      True             NaN             NaN   \n",
       "8     computer applications      2      True             NaN             NaN   \n",
       "9     computer applications      2      True         40101.0             NaN   \n",
       "10           Social Science      2      True             NaN             NaN   \n",
       "11           Social Science      2      True             NaN             NaN   \n",
       "12  Fundamental Engineering      3      True         40106.0         40504.0   \n",
       "13  Fundamental Engineering      3      True         40504.0         40505.0   \n",
       "15  Fundamental Engineering      3      True         40502.0         40506.0   \n",
       "16  Fundamental Engineering      3      True         40502.0             NaN   \n",
       "17            Basic Science      3      True             NaN             NaN   \n",
       "18            Basic Science      3      True             NaN             NaN   \n",
       "19  Fundamental Engineering      3      True         40506.0             NaN   \n",
       "20    computer applications      3      True             NaN             NaN   \n",
       "21      General Engineering      3      True         40203.0         40506.0   \n",
       "22    computer applications      2      True         40103.0             NaN   \n",
       "23            Basic Science      2      True             NaN             NaN   \n",
       "26  Fundamental Engineering      3      True         40108.0             NaN   \n",
       "27      General Engineering      3      True         40105.0             NaN   \n",
       "28      General Engineering      3      True         40204.0             NaN   \n",
       "30  Fundamental Engineering      3      True         40204.0             NaN   \n",
       "31    computer applications      3      True         40201.0             NaN   \n",
       "35           Social Science      2      True             NaN             NaN   \n",
       "42           Social Science      2      True             NaN             NaN   \n",
       "44      General Engineering      3      True         40507.0             NaN   \n",
       "48      General Engineering      2      True         40506.0             NaN   \n",
       "50           Social Science      2      True             NaN             NaN   \n",
       "51          Elective course      2      True             NaN             NaN   \n",
       "53          Elective course      2      True             NaN             NaN   \n",
       "54          Elective course      2      True             NaN             NaN   \n",
       "\n",
       "    prerequisite_3  prerequisite_4  prerequisite_5  GPA  \n",
       "0              NaN             NaN             NaN  4.0  \n",
       "1              NaN             NaN             NaN  2.7  \n",
       "2              NaN             NaN             NaN  4.0  \n",
       "3              NaN             NaN             NaN  3.3  \n",
       "4              NaN             NaN             NaN  3.7  \n",
       "5              NaN             NaN             NaN  3.7  \n",
       "6              NaN             NaN             NaN  4.0  \n",
       "7              NaN             NaN             NaN  3.7  \n",
       "8              NaN             NaN             NaN  4.0  \n",
       "9              NaN             NaN             NaN  4.0  \n",
       "10             NaN             NaN             NaN  4.0  \n",
       "11             NaN             NaN             NaN  4.0  \n",
       "12             NaN             NaN             NaN  4.0  \n",
       "13             NaN             NaN             NaN  NaN  \n",
       "15             NaN             NaN             NaN  NaN  \n",
       "16             NaN             NaN             NaN  4.0  \n",
       "17             NaN             NaN             NaN  4.0  \n",
       "18             NaN             NaN             NaN  NaN  \n",
       "19             NaN             NaN             NaN  NaN  \n",
       "20             NaN             NaN             NaN  4.0  \n",
       "21         40505.0             NaN             NaN  4.0  \n",
       "22             NaN             NaN             NaN  4.0  \n",
       "23             NaN             NaN             NaN  4.0  \n",
       "26             NaN             NaN             NaN  NaN  \n",
       "27             NaN             NaN             NaN  NaN  \n",
       "28             NaN             NaN             NaN  NaN  \n",
       "30             NaN             NaN             NaN  NaN  \n",
       "31             NaN             NaN             NaN  4.0  \n",
       "35             NaN             NaN             NaN  4.0  \n",
       "42             NaN             NaN             NaN  4.0  \n",
       "44             NaN             NaN             NaN  NaN  \n",
       "48             NaN             NaN             NaN  2.3  \n",
       "50             NaN             NaN             NaN  4.0  \n",
       "51             NaN             NaN             NaN  3.7  \n",
       "53             NaN             NaN             NaN  4.0  \n",
       "54             NaN             NaN             NaN  NaN  "
      ]
     },
     "execution_count": 193,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken=df[df.if_taken==False]\n",
    "df_taken=df[df.if_taken==True]\n",
    "df_taken"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "95"
      ]
     },
     "execution_count": 194,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_taken.hours.sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The courses I have not taken"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>40111</td>\n",
       "      <td>Stress Analysis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>40114</td>\n",
       "      <td>Computer-Aided mechanical Design 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>40111.0</td>\n",
       "      <td>40113.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>40115</td>\n",
       "      <td>Theory of Viberation</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>40119</td>\n",
       "      <td>Computer-Aided mechanical Design 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40114.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>40206</td>\n",
       "      <td>Digital Control Systems NC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>40207</td>\n",
       "      <td>Electrical Motors</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>40208</td>\n",
       "      <td>Sensors and Measurement Instruments</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>40218</td>\n",
       "      <td>Power Electronics</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40207.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>40131</td>\n",
       "      <td>Pneumatic and hydraulic systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>40134</td>\n",
       "      <td>Industrial Automation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40206.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40209</td>\n",
       "      <td>Adapters and Relays</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40130</td>\n",
       "      <td>Simulation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>40121</td>\n",
       "      <td>Mechatronics Systems 1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40209.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>40129</td>\n",
       "      <td>Advanced Manufacturing Systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40117.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>40145</td>\n",
       "      <td>Industrial Engineering</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40129.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>40217</td>\n",
       "      <td>Artificial Inteligence</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>40135</td>\n",
       "      <td>Mechatronics Systems 2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40134.0</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>40146</td>\n",
       "      <td>Quality Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>50001</td>\n",
       "      <td>Feasibility study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                               course  level  \\\n",
       "14  40111                      Stress Analysis    1.0   \n",
       "24  40114   Computer-Aided mechanical Design 1    2.0   \n",
       "25  40115                 Theory of Viberation    2.0   \n",
       "29  40119   Computer-Aided mechanical Design 2    2.0   \n",
       "32  40206           Digital Control Systems NC    2.0   \n",
       "33  40207                    Electrical Motors    2.0   \n",
       "34  40208  Sensors and Measurement Instruments    2.0   \n",
       "36  40218                    Power Electronics    3.0   \n",
       "37  40131      Pneumatic and hydraulic systems    3.0   \n",
       "38  40134                Industrial Automation    3.0   \n",
       "39  40209                  Adapters and Relays    3.0   \n",
       "40  40130                           Simulation    3.0   \n",
       "41  40121               Mechatronics Systems 1    3.0   \n",
       "43  40129       Advanced Manufacturing Systems    3.0   \n",
       "45  40145               Industrial Engineering    4.0   \n",
       "46  40217               Artificial Inteligence    4.0   \n",
       "47  40135               Mechatronics Systems 2    4.0   \n",
       "49  40146                   Quality Management    4.0   \n",
       "52  50001                    Feasibility study    NaN   \n",
       "\n",
       "                       type  hours  if_taken  prerequisite_1  prerequisite_2  \\\n",
       "14  Fundamental Engineering      3     False         40108.0             NaN   \n",
       "24    computer applications      3     False         40103.0         40111.0   \n",
       "25  Fundamental Engineering      3     False         40108.0         40506.0   \n",
       "29    computer applications      3     False         40114.0             NaN   \n",
       "32      General Engineering      3     False         40205.0             NaN   \n",
       "33  Fundamental Engineering      3     False         40108.0         40203.0   \n",
       "34  Fundamental Engineering      3     False         40203.0             NaN   \n",
       "36  Fundamental Engineering      3     False         40207.0             NaN   \n",
       "37      General Engineering      3     False         40108.0         40109.0   \n",
       "38      General Engineering      3     False         40118.0         40109.0   \n",
       "39      General Engineering      3     False         40205.0             NaN   \n",
       "40    computer applications      3     False         40108.0         40109.0   \n",
       "41      General Engineering      2     False         40118.0         40208.0   \n",
       "43      General Engineering      2     False         40118.0         40117.0   \n",
       "45      General Engineering      3     False         40129.0             NaN   \n",
       "46      General Engineering      3     False         40507.0         40201.0   \n",
       "47      General Engineering      2     False         40112.0         40109.0   \n",
       "49      General Engineering      2     False             NaN             NaN   \n",
       "52          Elective course      2     False             NaN             NaN   \n",
       "\n",
       "    prerequisite_3  prerequisite_4  prerequisite_5  GPA  \n",
       "14             NaN             NaN             NaN  NaN  \n",
       "24         40113.0             NaN             NaN  NaN  \n",
       "25         40508.0             NaN             NaN  NaN  \n",
       "29             NaN             NaN             NaN  NaN  \n",
       "32             NaN             NaN             NaN  NaN  \n",
       "33             NaN             NaN             NaN  NaN  \n",
       "34             NaN             NaN             NaN  NaN  \n",
       "36             NaN             NaN             NaN  NaN  \n",
       "37         40112.0             NaN             NaN  NaN  \n",
       "38         40112.0         40208.0         40206.0  NaN  \n",
       "39             NaN             NaN             NaN  NaN  \n",
       "40         40112.0         40508.0         40201.0  NaN  \n",
       "41         40209.0             NaN             NaN  NaN  \n",
       "43             NaN             NaN             NaN  NaN  \n",
       "45             NaN             NaN             NaN  NaN  \n",
       "46             NaN             NaN             NaN  NaN  \n",
       "47         40134.0         40118.0         40208.0  NaN  \n",
       "49             NaN             NaN             NaN  NaN  \n",
       "52             NaN             NaN             NaN  NaN  "
      ]
     },
     "execution_count": 195,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The total Number of hours taken for fundamental Engineering courses EF (required = 42) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 196,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27"
      ]
     },
     "execution_count": 196,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FE_hours=df_taken.groupby('type')['hours'].sum()['Fundamental Engineering']\n",
    "FE_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining hours for Fundamental Engineering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15"
      ]
     },
     "execution_count": 197,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "42-FE_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining courses for FE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>40111</td>\n",
       "      <td>Stress Analysis</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>40115</td>\n",
       "      <td>Theory of Viberation</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>40207</td>\n",
       "      <td>Electrical Motors</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>40208</td>\n",
       "      <td>Sensors and Measurement Instruments</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>40218</td>\n",
       "      <td>Power Electronics</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40207.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                               course  level  \\\n",
       "14  40111                      Stress Analysis    1.0   \n",
       "25  40115                 Theory of Viberation    2.0   \n",
       "33  40207                    Electrical Motors    2.0   \n",
       "34  40208  Sensors and Measurement Instruments    2.0   \n",
       "36  40218                    Power Electronics    3.0   \n",
       "\n",
       "                       type  hours  if_taken  prerequisite_1  prerequisite_2  \\\n",
       "14  Fundamental Engineering      3     False         40108.0             NaN   \n",
       "25  Fundamental Engineering      3     False         40108.0         40506.0   \n",
       "33  Fundamental Engineering      3     False         40108.0         40203.0   \n",
       "34  Fundamental Engineering      3     False         40203.0             NaN   \n",
       "36  Fundamental Engineering      3     False         40207.0             NaN   \n",
       "\n",
       "    prerequisite_3  prerequisite_4  prerequisite_5  GPA  \n",
       "14             NaN             NaN             NaN  NaN  \n",
       "25         40508.0             NaN             NaN  NaN  \n",
       "33             NaN             NaN             NaN  NaN  \n",
       "34             NaN             NaN             NaN  NaN  \n",
       "36             NaN             NaN             NaN  NaN  "
      ]
     },
     "execution_count": 198,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken[df_not_taken.type=='Fundamental Engineering']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The total Number of hours taken for Basic science courses  (required = 23) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "23"
      ]
     },
     "execution_count": 199,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "BS_hours=df_taken.groupby('type')['hours'].sum()['Basic Science']\n",
    "BS_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining hours for Basic Engineering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 200,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "23-BS_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining courses for BS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [code, course, level, type, hours, if_taken, prerequisite_1, prerequisite_2, prerequisite_3, prerequisite_4, prerequisite_5, GPA]\n",
       "Index: []"
      ]
     },
     "execution_count": 201,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken[df_not_taken.type=='Basic Science']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The total Number of hours taken for General Engineering courses  (required = 47) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "17"
      ]
     },
     "execution_count": 202,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GE_hours=df_taken.groupby('type')['hours'].sum()['General Engineering']\n",
    "GE_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining hours for General Engineering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "30"
      ]
     },
     "execution_count": 203,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "47-GE_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining courses for GE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>40206</td>\n",
       "      <td>Digital Control Systems NC</td>\n",
       "      <td>2.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>40131</td>\n",
       "      <td>Pneumatic and hydraulic systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>40134</td>\n",
       "      <td>Industrial Automation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40206.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>40209</td>\n",
       "      <td>Adapters and Relays</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40205.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>40121</td>\n",
       "      <td>Mechatronics Systems 1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>40209.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>40129</td>\n",
       "      <td>Advanced Manufacturing Systems</td>\n",
       "      <td>3.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40117.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>40145</td>\n",
       "      <td>Industrial Engineering</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40129.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>40217</td>\n",
       "      <td>Artificial Inteligence</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40507.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>40135</td>\n",
       "      <td>Mechatronics Systems 2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40134.0</td>\n",
       "      <td>40118.0</td>\n",
       "      <td>40208.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>40146</td>\n",
       "      <td>Quality Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                           course  level                 type  hours  \\\n",
       "32  40206       Digital Control Systems NC    2.0  General Engineering      3   \n",
       "37  40131  Pneumatic and hydraulic systems    3.0  General Engineering      3   \n",
       "38  40134            Industrial Automation    3.0  General Engineering      3   \n",
       "39  40209              Adapters and Relays    3.0  General Engineering      3   \n",
       "41  40121           Mechatronics Systems 1    3.0  General Engineering      2   \n",
       "43  40129   Advanced Manufacturing Systems    3.0  General Engineering      2   \n",
       "45  40145           Industrial Engineering    4.0  General Engineering      3   \n",
       "46  40217           Artificial Inteligence    4.0  General Engineering      3   \n",
       "47  40135           Mechatronics Systems 2    4.0  General Engineering      2   \n",
       "49  40146               Quality Management    4.0  General Engineering      2   \n",
       "\n",
       "    if_taken  prerequisite_1  prerequisite_2  prerequisite_3  prerequisite_4  \\\n",
       "32     False         40205.0             NaN             NaN             NaN   \n",
       "37     False         40108.0         40109.0         40112.0             NaN   \n",
       "38     False         40118.0         40109.0         40112.0         40208.0   \n",
       "39     False         40205.0             NaN             NaN             NaN   \n",
       "41     False         40118.0         40208.0         40209.0             NaN   \n",
       "43     False         40118.0         40117.0             NaN             NaN   \n",
       "45     False         40129.0             NaN             NaN             NaN   \n",
       "46     False         40507.0         40201.0             NaN             NaN   \n",
       "47     False         40112.0         40109.0         40134.0         40118.0   \n",
       "49     False             NaN             NaN             NaN             NaN   \n",
       "\n",
       "    prerequisite_5  GPA  \n",
       "32             NaN  NaN  \n",
       "37             NaN  NaN  \n",
       "38         40206.0  NaN  \n",
       "39             NaN  NaN  \n",
       "41             NaN  NaN  \n",
       "43             NaN  NaN  \n",
       "45             NaN  NaN  \n",
       "46             NaN  NaN  \n",
       "47         40208.0  NaN  \n",
       "49             NaN  NaN  "
      ]
     },
     "execution_count": 204,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken[df_not_taken.type=='General Engineering']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The total Number of hours taken for computer applications courses  (required = 21) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12"
      ]
     },
     "execution_count": 205,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "CS_hours=df_taken.groupby('type')['hours'].sum()['computer applications']\n",
    "CS_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining hours for computer applications"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9"
      ]
     },
     "execution_count": 206,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "21-CS_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining courses for CS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>40114</td>\n",
       "      <td>Computer-Aided mechanical Design 1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>40111.0</td>\n",
       "      <td>40113.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>40119</td>\n",
       "      <td>Computer-Aided mechanical Design 2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40114.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>40130</td>\n",
       "      <td>Simulation</td>\n",
       "      <td>3.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>False</td>\n",
       "      <td>40108.0</td>\n",
       "      <td>40109.0</td>\n",
       "      <td>40112.0</td>\n",
       "      <td>40508.0</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                              course  level                   type  \\\n",
       "24  40114  Computer-Aided mechanical Design 1    2.0  computer applications   \n",
       "29  40119  Computer-Aided mechanical Design 2    2.0  computer applications   \n",
       "40  40130                          Simulation    3.0  computer applications   \n",
       "\n",
       "    hours  if_taken  prerequisite_1  prerequisite_2  prerequisite_3  \\\n",
       "24      3     False         40103.0         40111.0         40113.0   \n",
       "29      3     False         40114.0             NaN             NaN   \n",
       "40      3     False         40108.0         40109.0         40112.0   \n",
       "\n",
       "    prerequisite_4  prerequisite_5  GPA  \n",
       "24             NaN             NaN  NaN  \n",
       "29             NaN             NaN  NaN  \n",
       "40         40508.0         40201.0  NaN  "
      ]
     },
     "execution_count": 207,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken[df_not_taken.type=='computer applications']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The total Number of hours taken for Elective course  (required = 8) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 208,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6"
      ]
     },
     "execution_count": 208,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "EC_hours=df_taken.groupby('type')['hours'].sum()['Elective course']\n",
    "EC_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining hours for Elective course"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 209,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 209,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "8-EC_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining courses for EC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>50001</td>\n",
       "      <td>Feasibility study</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code             course  level             type  hours  if_taken  \\\n",
       "52  50001  Feasibility study    NaN  Elective course      2     False   \n",
       "\n",
       "    prerequisite_1  prerequisite_2  prerequisite_3  prerequisite_4  \\\n",
       "52             NaN             NaN             NaN             NaN   \n",
       "\n",
       "    prerequisite_5  GPA  \n",
       "52             NaN  NaN  "
      ]
     },
     "execution_count": 210,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken[df_not_taken.type=='Elective course']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The total Number of hours taken for Social Science courses  (required = 18) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10"
      ]
     },
     "execution_count": 211,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "SS_hours=df_taken.groupby('type')['hours'].sum()['Social Science']\n",
    "SS_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining hours for Social Science"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8"
      ]
     },
     "execution_count": 212,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "18-SS_hours"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remaining courses for SS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [code, course, level, type, hours, if_taken, prerequisite_1, prerequisite_2, prerequisite_3, prerequisite_4, prerequisite_5, GPA]\n",
       "Index: []"
      ]
     },
     "execution_count": 213,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_not_taken[df_not_taken.type=='Social Science']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# GPA Clculation"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Gathering the courses with final exams(GPA) in a file named (GPA) and displaying them"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 214,
   "metadata": {},
   "outputs": [],
   "source": [
    "GPA = df[df.GPA >0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>course</th>\n",
       "      <th>level</th>\n",
       "      <th>type</th>\n",
       "      <th>hours</th>\n",
       "      <th>if_taken</th>\n",
       "      <th>prerequisite_1</th>\n",
       "      <th>prerequisite_2</th>\n",
       "      <th>prerequisite_3</th>\n",
       "      <th>prerequisite_4</th>\n",
       "      <th>prerequisite_5</th>\n",
       "      <th>GPA</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40102</td>\n",
       "      <td>Engineering Mechanics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>40105</td>\n",
       "      <td>Production Technology 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40106</td>\n",
       "      <td>Engineering Mechanics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40102.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40501</td>\n",
       "      <td>Engineering  Mathematics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>40502</td>\n",
       "      <td>Engineering Physics 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>40503</td>\n",
       "      <td>Engineering Chemistry</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>40504</td>\n",
       "      <td>Engineering  Mathematics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>40505</td>\n",
       "      <td>Engineering Physics 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>40101</td>\n",
       "      <td>CAD 1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>40103</td>\n",
       "      <td>CAD 2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40101.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>40104</td>\n",
       "      <td>Engineering History</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>40144</td>\n",
       "      <td>Technical English</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>40108</td>\n",
       "      <td>Engineering Mechanics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40106.0</td>\n",
       "      <td>40504.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>40113</td>\n",
       "      <td>Material</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Fundamental Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40502.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>40506</td>\n",
       "      <td>Engineering  Mathematics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>40201</td>\n",
       "      <td>Introduction to computer science and programming</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>40204</td>\n",
       "      <td>Logic gates and Microprocessor</td>\n",
       "      <td>1.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40203.0</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>40505.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>40107</td>\n",
       "      <td>Computer-Aided mechanical Drawing</td>\n",
       "      <td>1.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40103.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>40508</td>\n",
       "      <td>Engineering Physics 3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Basic Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>40202</td>\n",
       "      <td>Algorithms and Data Structure</td>\n",
       "      <td>2.0</td>\n",
       "      <td>computer applications</td>\n",
       "      <td>3</td>\n",
       "      <td>True</td>\n",
       "      <td>40201.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>40110</td>\n",
       "      <td>Technical Writing</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>00000</td>\n",
       "      <td>Humans Rights</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>40136</td>\n",
       "      <td>Project Management</td>\n",
       "      <td>4.0</td>\n",
       "      <td>General Engineering</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>40506.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>40147</td>\n",
       "      <td>Engineering Economy</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Social Science</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>40001</td>\n",
       "      <td>Computer and its applications</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>40145</td>\n",
       "      <td>Communication and presentation skills</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Elective course</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     code                                            course  level  \\\n",
       "0   40102                           Engineering Mechanics 1    0.0   \n",
       "1   40105                           Production Technology 1    0.0   \n",
       "2   40106                           Engineering Mechanics 2    0.0   \n",
       "3   40501                        Engineering  Mathematics 1    0.0   \n",
       "4   40502                             Engineering Physics 1    0.0   \n",
       "5   40503                             Engineering Chemistry    0.0   \n",
       "6   40504                        Engineering  Mathematics 2    0.0   \n",
       "7   40505                             Engineering Physics 2    0.0   \n",
       "8   40101                                             CAD 1    0.0   \n",
       "9   40103                                             CAD 2    0.0   \n",
       "10  40104                               Engineering History    0.0   \n",
       "11  40144                                 Technical English    0.0   \n",
       "12  40108                           Engineering Mechanics 3    1.0   \n",
       "16  40113                                         Material     1.0   \n",
       "17  40506                        Engineering  Mathematics 3    1.0   \n",
       "20  40201  Introduction to computer science and programming    1.0   \n",
       "21  40204                    Logic gates and Microprocessor    1.0   \n",
       "22  40107                 Computer-Aided mechanical Drawing    1.0   \n",
       "23  40508                             Engineering Physics 3    1.0   \n",
       "31  40202                     Algorithms and Data Structure    2.0   \n",
       "35  40110                                 Technical Writing    2.0   \n",
       "42  00000                                     Humans Rights    3.0   \n",
       "48  40136                                Project Management    4.0   \n",
       "50  40147                               Engineering Economy    4.0   \n",
       "51  40001                     Computer and its applications    NaN   \n",
       "53  40145             Communication and presentation skills    NaN   \n",
       "\n",
       "                       type  hours  if_taken  prerequisite_1  prerequisite_2  \\\n",
       "0   Fundamental Engineering      3      True             NaN             NaN   \n",
       "1       General Engineering      3      True             NaN             NaN   \n",
       "2   Fundamental Engineering      3      True         40102.0             NaN   \n",
       "3             Basic Science      3      True             NaN             NaN   \n",
       "4             Basic Science      3      True             NaN             NaN   \n",
       "5             Basic Science      3      True             NaN             NaN   \n",
       "6             Basic Science      3      True             NaN             NaN   \n",
       "7             Basic Science      3      True             NaN             NaN   \n",
       "8     computer applications      2      True             NaN             NaN   \n",
       "9     computer applications      2      True         40101.0             NaN   \n",
       "10           Social Science      2      True             NaN             NaN   \n",
       "11           Social Science      2      True             NaN             NaN   \n",
       "12  Fundamental Engineering      3      True         40106.0         40504.0   \n",
       "16  Fundamental Engineering      3      True         40502.0             NaN   \n",
       "17            Basic Science      3      True             NaN             NaN   \n",
       "20    computer applications      3      True             NaN             NaN   \n",
       "21      General Engineering      3      True         40203.0         40506.0   \n",
       "22    computer applications      2      True         40103.0             NaN   \n",
       "23            Basic Science      2      True             NaN             NaN   \n",
       "31    computer applications      3      True         40201.0             NaN   \n",
       "35           Social Science      2      True             NaN             NaN   \n",
       "42           Social Science      2      True             NaN             NaN   \n",
       "48      General Engineering      2      True         40506.0             NaN   \n",
       "50           Social Science      2      True             NaN             NaN   \n",
       "51          Elective course      2      True             NaN             NaN   \n",
       "53          Elective course      2      True             NaN             NaN   \n",
       "\n",
       "    prerequisite_3  prerequisite_4  prerequisite_5  GPA  \n",
       "0              NaN             NaN             NaN  4.0  \n",
       "1              NaN             NaN             NaN  2.7  \n",
       "2              NaN             NaN             NaN  4.0  \n",
       "3              NaN             NaN             NaN  3.3  \n",
       "4              NaN             NaN             NaN  3.7  \n",
       "5              NaN             NaN             NaN  3.7  \n",
       "6              NaN             NaN             NaN  4.0  \n",
       "7              NaN             NaN             NaN  3.7  \n",
       "8              NaN             NaN             NaN  4.0  \n",
       "9              NaN             NaN             NaN  4.0  \n",
       "10             NaN             NaN             NaN  4.0  \n",
       "11             NaN             NaN             NaN  4.0  \n",
       "12             NaN             NaN             NaN  4.0  \n",
       "16             NaN             NaN             NaN  4.0  \n",
       "17             NaN             NaN             NaN  4.0  \n",
       "20             NaN             NaN             NaN  4.0  \n",
       "21         40505.0             NaN             NaN  4.0  \n",
       "22             NaN             NaN             NaN  4.0  \n",
       "23             NaN             NaN             NaN  4.0  \n",
       "31             NaN             NaN             NaN  4.0  \n",
       "35             NaN             NaN             NaN  4.0  \n",
       "42             NaN             NaN             NaN  4.0  \n",
       "48             NaN             NaN             NaN  2.3  \n",
       "50             NaN             NaN             NaN  4.0  \n",
       "51             NaN             NaN             NaN  3.7  \n",
       "53             NaN             NaN             NaN  4.0  "
      ]
     },
     "execution_count": 215,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GPA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 216,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "66"
      ]
     },
     "execution_count": 216,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "GPA.hours.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-217-145537370f43>:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  GPA['GPA x hours']=GPA['hours']*GPA['GPA']\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "3.8075757575757576"
      ]
     },
     "execution_count": 217,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum_hours=GPA.hours.sum()\n",
    "GPA['GPA x hours']=GPA['hours']*GPA['GPA']\n",
    "GPA['GPA x hours'].sum()/sum_hours"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.7 64-bit",
   "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.10.7"
  },
  "vscode": {
   "interpreter": {
    "hash": "fbc768028c3e6ead51d9a200ddcb2ec858ae62844dcd1994729a8279be9b48f2"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}