Scrapping EEE course.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Web Scrapping\n",
    "Source: http://www.eee.ntu.edu.sg/programmes/CurrentStudents/undergraduate/undergraduatefull-time/Pages/CoursesCatalogue.aspx\n",
    "References: https://towardsdatascience.com/how-to-web-scrape-with-python-in-4-minutes-bc49186a8460, https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Import Library and Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import urllib.request\n",
    "import time\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url =\"http://www.eee.ntu.edu.sg/programmes/CurrentStudents/undergraduate/undergraduatefull-time/Pages/CoursesCatalogue.aspx\"\n",
    "response = requests.get(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(response.text,\"html.parser\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "After inspect the html element, it's found that all data are inside 'td' tags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "list_course = soup.find_all('td')\n",
    "final = [txt.find_all(text=True) for txt in list_course]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "662"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(final)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Normalize data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['EE0002 '],\n",
       " ['Engineers and Society *'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE0005'],\n",
       " ['Introduction to Data Science and AI'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE0040'],\n",
       " ['Engineers and Society *'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE1002 '],\n",
       " ['Physics Foundation for Electrical & Electronic Engineering'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE1003 '],\n",
       " ['Introduction to Materials for Electronics'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' ', 'EE1005 '],\n",
       " ['From Computational Thinking to Programming'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' ', 'EE1071 '],\n",
       " ['Introduction to EEE Laboratories'],\n",
       " ['C'],\n",
       " ['1'],\n",
       " ['\\u200b'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2001 '],\n",
       " ['Circuit Analysis'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2002 '],\n",
       " ['Analog Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2003 '],\n",
       " ['Semiconductor Fundamentals'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2004'],\n",
       " ['Digital Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2006 '],\n",
       " ['Engineering Mathematics I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2007 '],\n",
       " ['Engineering Mathematics I', 'I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2008 '],\n",
       " ['Data Structures and Algorithms'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2010 '],\n",
       " ['Signals and Systems'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE2073 '],\n",
       " ['Introduction to EEE Design & Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE3001 '],\n",
       " ['Engineering Electromagnetics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3002 '],\n",
       " ['Microprocessors'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3010 '],\n",
       " ['Electrical Devices and Machines'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE3011 '],\n",
       " ['Modelling and Control'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE3012 '],\n",
       " ['Communication Principles'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3013'],\n",
       " ['Semiconductor Devices and Processing'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3014 '],\n",
       " ['Digital Signal Processing'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3015 '],\n",
       " ['Power Systems & Protection'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3017 '],\n",
       " ['Computer Communications'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE3018'],\n",
       " ['Introduction to Photonics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE3019'],\n",
       " ['Integrated Electronics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3080 '],\n",
       " ['Design & Innovation Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3179'],\n",
       " ['Professional Internship *'],\n",
       " ['C'],\n",
       " ['8'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3279'],\n",
       " ['Professional Internship *'],\n",
       " ['C'],\n",
       " ['10'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4001'],\n",
       " ['Software Engineering'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4080'],\n",
       " ['Final Year Project *'],\n",
       " ['C'],\n",
       " ['8'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4105'],\n",
       " ['Cellular Communication System Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4109 '],\n",
       " ['Wireless System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4110 '],\n",
       " ['Optical Communication System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4152'],\n",
       " ['Digital Communications *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4153 '],\n",
       " ['Telecommunication System *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4188', '\\u200b'],\n",
       " ['Wireless Communications *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4190'],\n",
       " ['Introduction to Modern Radar'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4207'],\n",
       " ['Control Engineering Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4208'],\n",
       " ['Intelligent Systems Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4265 '],\n",
       " ['Process Control Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4266'],\n",
       " ['Computer Vision'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' ', 'EE4268 '],\n",
       " ['Robotics and Automation'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4273 '],\n",
       " ['Digital Control Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4285 '],\n",
       " ['Computational Intelligence'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4303 '],\n",
       " ['Mixed-Signal IC Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4304'],\n",
       " ['Radio Frequency Integrated System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4305'],\n",
       " ['Digital Design with HDL'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4340'],\n",
       " ['VLSI Sytems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4341'],\n",
       " ['Advanced Analog Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4343', '\\u200b'],\n",
       " ['Radio Frequency Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4344 '],\n",
       " ['Analysis and Design of Integrated Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4413'],\n",
       " ['DSP System Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4455'],\n",
       " ['Embedded Systems *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4475 '],\n",
       " ['Audio Signal Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4476 '],\n",
       " ['Image Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4478 '],\n",
       " ['Digital Video Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4483'],\n",
       " ['Artifical Intelligence and Data Mining'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4490'],\n",
       " ['Multimedia Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4503 '],\n",
       " ['Power Engineering Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4504'],\n",
       " ['Design of Clean Energy Systems'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4530'],\n",
       " ['Power System Analysis and Control'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4532 '],\n",
       " ['Power Electronics and Drives'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4534 '],\n",
       " ['Modern Distribution Systems with Renewable Res.'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4613'],\n",
       " ['CMOS Process and Device Simulation'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4614'],\n",
       " ['Device Parameter Extraction & Layout Implement.'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4645'],\n",
       " ['Microfabrication Engineering'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4646'],\n",
       " ['VLSI Technology'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4647'],\n",
       " ['Microelectronic Devices'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4694'],\n",
       " ['IC Reliability and Failure Analysis'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4717 '],\n",
       " ['Web Application Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4718 '],\n",
       " ['Enterprise Network Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4756'],\n",
       " ['Computer Architecture *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4758'],\n",
       " ['Information Security'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4761'],\n",
       " ['Computer Networking *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4791 '],\n",
       " ['Database Systems *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4838'],\n",
       " ['Laser Engineering and Applications'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4840'],\n",
       " ['Biophotonics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4901'],\n",
       " ['Biomedical Control System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4902'],\n",
       " ['Design of Medical Information Processing Systems'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4903'],\n",
       " ['Physiological Systems Analysis'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4904 '],\n",
       " ['Biomedical Instrumentation'],\n",
       " ['PE', ' ', ' ', ' ', ' ', ' '],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8061'],\n",
       " ['Innovation and Technology Management'],\n",
       " ['BM / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8064 '],\n",
       " ['Intellectual Property for Electronic Engineers'],\n",
       " ['BM / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8084'],\n",
       " ['Cyber Security'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE8085 ', '\\u200b'],\n",
       " ['Electrification for The Built Environment'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE8086'],\n",
       " ['Astronomy - Stars, Galaxies and Cosmology'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE8087'],\n",
       " ['Living with Mathematics'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8092'],\n",
       " ['Digital Lifestyle'],\n",
       " ['STS / UE ', ' '],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8093'],\n",
       " ['Energy Devices for Sustainable Urban Environment\\xa0 '],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8094'],\n",
       " ['Impact Of Electromagnetic Radiation\\xa0On Humans'],\n",
       " ['STS /\\xa0UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE8095', '\\u200b'],\n",
       " ['Innovation and Commercialization'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8097 '],\n",
       " ['Introduction\\xa0to Spacecraft Design'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['\\u200b'],\n",
       " ['Y'],\n",
       " ['IM1001', '\\u200b'],\n",
       " ['Data Structures and Algorithms'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM1002'],\n",
       " ['Analog Electronics'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'IM1003'],\n",
       " ['Object-Oriented Programming'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' IM1004', ' '],\n",
       " ['Digital Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM2001 '],\n",
       " ['Software Engineering'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'IM2002'],\n",
       " ['Microprocessors'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'IM2003'],\n",
       " ['Computer Communications'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' ', 'IM2004'],\n",
       " ['Signals and Systems'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' ', 'IM2006'],\n",
       " ['Engineering Mathematics I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2007'],\n",
       " ['Engineering Mathematics II'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2073'],\n",
       " ['Introduction to Design & Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM3001'],\n",
       " ['Digital Signal Processing'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM3002'],\n",
       " ['Communication Principles'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM3003'],\n",
       " ['Information Security'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM3080'],\n",
       " ['Design & Innovation Project *'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y']]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "core_data=final[4:len(final)-4]\n",
    "core_data[13]=core_data[1]\n",
    "core_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['EE0002 '],\n",
       " ['Engineers and Society *'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE0005'],\n",
       " ['Introduction to Data Science and AI'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE0040'],\n",
       " ['Engineers and Society *'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE1002 '],\n",
       " ['Physics Foundation for Electrical & Electronic Engineering'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE1003 '],\n",
       " ['Introduction to Materials for Electronics'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' ', 'EE1005 '],\n",
       " ['From Computational Thinking to Programming'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' ', 'EE1071 '],\n",
       " ['Introduction to EEE Laboratories'],\n",
       " ['C'],\n",
       " ['1'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2001 '],\n",
       " ['Circuit Analysis'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2002 '],\n",
       " ['Analog Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2003 '],\n",
       " ['Semiconductor Fundamentals'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2004'],\n",
       " ['Digital Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2006 '],\n",
       " ['Engineering Mathematics I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2007 '],\n",
       " ['Engineering Mathematics I', 'I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2008 '],\n",
       " ['Data Structures and Algorithms'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE2010 '],\n",
       " ['Signals and Systems'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE2073 '],\n",
       " ['Introduction to EEE Design & Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE3001 '],\n",
       " ['Engineering Electromagnetics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3002 '],\n",
       " ['Microprocessors'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3010 '],\n",
       " ['Electrical Devices and Machines'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE3011 '],\n",
       " ['Modelling and Control'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE3012 '],\n",
       " ['Communication Principles'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3013'],\n",
       " ['Semiconductor Devices and Processing'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3014 '],\n",
       " ['Digital Signal Processing'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3015 '],\n",
       " ['Power Systems & Protection'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3017 '],\n",
       " ['Computer Communications'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE3018'],\n",
       " ['Introduction to Photonics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE3019'],\n",
       " ['Integrated Electronics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3080 '],\n",
       " ['Design & Innovation Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3179'],\n",
       " ['Professional Internship *'],\n",
       " ['C'],\n",
       " ['8'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3279'],\n",
       " ['Professional Internship *'],\n",
       " ['C'],\n",
       " ['10'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4001'],\n",
       " ['Software Engineering'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4080'],\n",
       " ['Final Year Project *'],\n",
       " ['C'],\n",
       " ['8'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4105'],\n",
       " ['Cellular Communication System Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4109 '],\n",
       " ['Wireless System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4110 '],\n",
       " ['Optical Communication System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4152'],\n",
       " ['Digital Communications *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4153 '],\n",
       " ['Telecommunication System *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4188', '\\u200b'],\n",
       " ['Wireless Communications *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4190'],\n",
       " ['Introduction to Modern Radar'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4207'],\n",
       " ['Control Engineering Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4208'],\n",
       " ['Intelligent Systems Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4265 '],\n",
       " ['Process Control Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4266'],\n",
       " ['Computer Vision'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' ', 'EE4268 '],\n",
       " ['Robotics and Automation'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4273 '],\n",
       " ['Digital Control Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4285 '],\n",
       " ['Computational Intelligence'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4303 '],\n",
       " ['Mixed-Signal IC Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4304'],\n",
       " ['Radio Frequency Integrated System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4305'],\n",
       " ['Digital Design with HDL'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4340'],\n",
       " ['VLSI Sytems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4341'],\n",
       " ['Advanced Analog Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4343', '\\u200b'],\n",
       " ['Radio Frequency Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4344 '],\n",
       " ['Analysis and Design of Integrated Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4413'],\n",
       " ['DSP System Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4455'],\n",
       " ['Embedded Systems *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4475 '],\n",
       " ['Audio Signal Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4476 '],\n",
       " ['Image Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4478 '],\n",
       " ['Digital Video Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4483'],\n",
       " ['Artifical Intelligence and Data Mining'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4490'],\n",
       " ['Multimedia Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4503 '],\n",
       " ['Power Engineering Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4504'],\n",
       " ['Design of Clean Energy Systems'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4530'],\n",
       " ['Power System Analysis and Control'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4532 '],\n",
       " ['Power Electronics and Drives'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4534 '],\n",
       " ['Modern Distribution Systems with Renewable Res.'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4613'],\n",
       " ['CMOS Process and Device Simulation'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4614'],\n",
       " ['Device Parameter Extraction & Layout Implement.'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4645'],\n",
       " ['Microfabrication Engineering'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4646'],\n",
       " ['VLSI Technology'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4647'],\n",
       " ['Microelectronic Devices'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4694'],\n",
       " ['IC Reliability and Failure Analysis'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4717 '],\n",
       " ['Web Application Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4718 '],\n",
       " ['Enterprise Network Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4756'],\n",
       " ['Computer Architecture *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4758'],\n",
       " ['Information Security'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4761'],\n",
       " ['Computer Networking *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4791 '],\n",
       " ['Database Systems *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4838'],\n",
       " ['Laser Engineering and Applications'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4840'],\n",
       " ['Biophotonics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE4901'],\n",
       " ['Biomedical Control System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE4902'],\n",
       " ['Design of Medical Information Processing Systems'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4903'],\n",
       " ['Physiological Systems Analysis'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4904 '],\n",
       " ['Biomedical Instrumentation'],\n",
       " ['PE', ' ', ' ', ' ', ' ', ' '],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8061'],\n",
       " ['Innovation and Technology Management'],\n",
       " ['BM / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8064 '],\n",
       " ['Intellectual Property for Electronic Engineers'],\n",
       " ['BM / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8084'],\n",
       " ['Cyber Security'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE8085 ', '\\u200b'],\n",
       " ['Electrification for The Built Environment'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'EE8086'],\n",
       " ['Astronomy - Stars, Galaxies and Cosmology'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE8087'],\n",
       " ['Living with Mathematics'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8092'],\n",
       " ['Digital Lifestyle'],\n",
       " ['STS / UE ', ' '],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8093'],\n",
       " ['Energy Devices for Sustainable Urban Environment\\xa0 '],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'EE8094'],\n",
       " ['Impact Of Electromagnetic Radiation\\xa0On Humans'],\n",
       " ['STS /\\xa0UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE8095', '\\u200b'],\n",
       " ['Innovation and Commercialization'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8097 '],\n",
       " ['Introduction\\xa0to Spacecraft Design'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM1001', '\\u200b'],\n",
       " ['Data Structures and Algorithms'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM1002'],\n",
       " ['Analog Electronics'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['\\u200b', 'IM1003'],\n",
       " ['Object-Oriented Programming'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' IM1004', ' '],\n",
       " ['Digital Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM2001 '],\n",
       " ['Software Engineering'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['\\u200b', 'IM2002'],\n",
       " ['Microprocessors'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['\\u200b', 'IM2003'],\n",
       " ['Computer Communications'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' ', 'IM2004'],\n",
       " ['Signals and Systems'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' ', 'IM2006'],\n",
       " ['Engineering Mathematics I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2007'],\n",
       " ['Engineering Mathematics II'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2073'],\n",
       " ['Introduction to Design & Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM3001'],\n",
       " ['Digital Signal Processing'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM3002'],\n",
       " ['Communication Principles'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM3003'],\n",
       " ['Information Security'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM3080'],\n",
       " ['Design & Innovation Project *'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y']]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in range (len(core_data)):\n",
    "    if core_data[i]==['\\u200b']:\n",
    "        core_data[i]=['']\n",
    "        \n",
    "for i in range (len(core_data)):\n",
    "    if core_data[i]==['']:\n",
    "        core_data[i]=[]\n",
    "core_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "core_data_copy=core_data.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['EE0002 '],\n",
       " ['Engineers and Society *'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE0005'],\n",
       " ['Introduction to Data Science and AI'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE0040'],\n",
       " ['Engineers and Society *'],\n",
       " ['GC'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE1002 '],\n",
       " ['Physics Foundation for Electrical & Electronic Engineering'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE1003 '],\n",
       " ['Introduction to Materials for Electronics'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE1005 '],\n",
       " ['From Computational Thinking to Programming'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE1071 '],\n",
       " ['Introduction to EEE Laboratories'],\n",
       " ['C'],\n",
       " ['1'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE2001 '],\n",
       " ['Circuit Analysis'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2002 '],\n",
       " ['Analog Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2003 '],\n",
       " ['Semiconductor Fundamentals'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2004'],\n",
       " ['Digital Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2006 '],\n",
       " ['Engineering Mathematics I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2007 '],\n",
       " ['Engineering Mathematics I', 'I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2008 '],\n",
       " ['Data Structures and Algorithms'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE2010 '],\n",
       " ['Signals and Systems'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE2073 '],\n",
       " ['Introduction to EEE Design & Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3001 '],\n",
       " ['Engineering Electromagnetics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3002 '],\n",
       " ['Microprocessors'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3010 '],\n",
       " ['Electrical Devices and Machines'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE3011 '],\n",
       " ['Modelling and Control'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3012 '],\n",
       " ['Communication Principles'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3013'],\n",
       " ['Semiconductor Devices and Processing'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3014 '],\n",
       " ['Digital Signal Processing'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3015 '],\n",
       " ['Power Systems & Protection'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3017 '],\n",
       " ['Computer Communications'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3018'],\n",
       " ['Introduction to Photonics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE3019'],\n",
       " ['Integrated Electronics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3080 '],\n",
       " ['Design & Innovation Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3179'],\n",
       " ['Professional Internship *'],\n",
       " ['C'],\n",
       " ['8'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE3279'],\n",
       " ['Professional Internship *'],\n",
       " ['C'],\n",
       " ['10'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4001'],\n",
       " ['Software Engineering'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4080'],\n",
       " ['Final Year Project *'],\n",
       " ['C'],\n",
       " ['8'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE4105'],\n",
       " ['Cellular Communication System Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4109 '],\n",
       " ['Wireless System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4110 '],\n",
       " ['Optical Communication System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4152'],\n",
       " ['Digital Communications *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4153 '],\n",
       " ['Telecommunication System *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4188'],\n",
       " ['Wireless Communications *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4190'],\n",
       " ['Introduction to Modern Radar'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4207'],\n",
       " ['Control Engineering Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4208'],\n",
       " ['Intelligent Systems Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4265 '],\n",
       " ['Process Control Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4266'],\n",
       " ['Computer Vision'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4268 '],\n",
       " ['Robotics and Automation'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4273 '],\n",
       " ['Digital Control Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4285 '],\n",
       " ['Computational Intelligence'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4303 '],\n",
       " ['Mixed-Signal IC Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4304'],\n",
       " ['Radio Frequency Integrated System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4305'],\n",
       " ['Digital Design with HDL'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4340'],\n",
       " ['VLSI Sytems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4341'],\n",
       " ['Advanced Analog Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4343'],\n",
       " ['Radio Frequency Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4344 '],\n",
       " ['Analysis and Design of Integrated Circuits'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4413'],\n",
       " ['DSP System Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4455'],\n",
       " ['Embedded Systems *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4475 '],\n",
       " ['Audio Signal Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4476 '],\n",
       " ['Image Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4478 '],\n",
       " ['Digital Video Processing *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4483'],\n",
       " ['Artifical Intelligence and Data Mining'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4490'],\n",
       " ['Multimedia Systems'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4503 '],\n",
       " ['Power Engineering Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4504'],\n",
       " ['Design of Clean Energy Systems'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4530'],\n",
       " ['Power System Analysis and Control'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4532 '],\n",
       " ['Power Electronics and Drives'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4534 '],\n",
       " ['Modern Distribution Systems with Renewable Res.'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4613'],\n",
       " ['CMOS Process and Device Simulation'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4614'],\n",
       " ['Device Parameter Extraction & Layout Implement.'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4645'],\n",
       " ['Microfabrication Engineering'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4646'],\n",
       " ['VLSI Technology'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4647'],\n",
       " ['Microelectronic Devices'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4694'],\n",
       " ['IC Reliability and Failure Analysis'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4717 '],\n",
       " ['Web Application Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4718 '],\n",
       " ['Enterprise Network Design *'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4756'],\n",
       " ['Computer Architecture *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4758'],\n",
       " ['Information Security'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4761'],\n",
       " ['Computer Networking *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4791 '],\n",
       " ['Database Systems *'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4838'],\n",
       " ['Laser Engineering and Applications'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4840'],\n",
       " ['Biophotonics'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE4901'],\n",
       " ['Biomedical Control System Design'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE4902'],\n",
       " ['Design of Medical Information Processing Systems'],\n",
       " ['PE'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' EE4903'],\n",
       " ['Physiological Systems Analysis'],\n",
       " ['PE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " [' EE4904 '],\n",
       " ['Biomedical Instrumentation'],\n",
       " ['PE', ' ', ' ', ' ', ' '],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8061'],\n",
       " ['Innovation and Technology Management'],\n",
       " ['BM / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8064 '],\n",
       " ['Intellectual Property for Electronic Engineers'],\n",
       " ['BM / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8084'],\n",
       " ['Cyber Security'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE8085 '],\n",
       " ['Electrification for The Built Environment'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8086'],\n",
       " ['Astronomy - Stars, Galaxies and Cosmology'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " [' EE8087'],\n",
       " ['Living with Mathematics'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8092'],\n",
       " ['Digital Lifestyle'],\n",
       " ['STS / UE '],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8093'],\n",
       " ['Energy Devices for Sustainable Urban Environment\\xa0 '],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['EE8094'],\n",
       " ['Impact Of Electromagnetic Radiation\\xa0On Humans'],\n",
       " ['STS /\\xa0UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['EE8095'],\n",
       " ['Innovation and Commercialization'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['EE8097 '],\n",
       " ['Introduction\\xa0to Spacecraft Design'],\n",
       " ['STS / UE'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM1001'],\n",
       " ['Data Structures and Algorithms'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM1002'],\n",
       " ['Analog Electronics'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM1003'],\n",
       " ['Object-Oriented Programming'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " [],\n",
       " ['Y'],\n",
       " [' IM1004'],\n",
       " ['Digital Electronics'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM2001 '],\n",
       " ['Software Engineering'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2002'],\n",
       " ['Microprocessors'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM2003'],\n",
       " ['Computer Communications'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2004'],\n",
       " ['Signals and Systems'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM2006'],\n",
       " ['Engineering Mathematics I'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2007'],\n",
       " ['Engineering Mathematics II'],\n",
       " ['C'],\n",
       " ['4'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM2073'],\n",
       " ['Introduction to Design & Project'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " [],\n",
       " ['Y'],\n",
       " ['IM3001'],\n",
       " ['Digital Signal Processing'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM3002'],\n",
       " ['Communication Principles'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " ['Y'],\n",
       " ['IM3003'],\n",
       " ['Information Security'],\n",
       " ['C'],\n",
       " ['3'],\n",
       " ['Y'],\n",
       " [],\n",
       " ['IM3080'],\n",
       " ['Design & Innovation Project *'],\n",
       " ['C'],\n",
       " ['2'],\n",
       " ['Y'],\n",
       " ['Y']]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in range (len(core_data_copy)):\n",
    "    if '\\u200b' in core_data_copy[i]:\n",
    "        core_data_copy[i].pop(core_data_copy[i].index('\\u200b'))\n",
    "\n",
    "for i in range (len(core_data_copy)):\n",
    "    if ' ' in core_data_copy[i]:\n",
    "        core_data_copy[i].pop(core_data_copy[i].index(' '))\n",
    "core_data_copy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "core_value=[]\n",
    "for i in core_data_copy:\n",
    "    try:\n",
    "        core_value.append(i[0])\n",
    "    except:\n",
    "        core_value.append('')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['EE0002 ',\n",
       " 'Engineers and Society *',\n",
       " 'GC',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE0005',\n",
       " 'Introduction to Data Science and AI',\n",
       " 'GC',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE0040',\n",
       " 'Engineers and Society *',\n",
       " 'GC',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " ' EE1002 ',\n",
       " 'Physics Foundation for Electrical & Electronic Engineering',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE1003 ',\n",
       " 'Introduction to Materials for Electronics',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE1005 ',\n",
       " 'From Computational Thinking to Programming',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE1071 ',\n",
       " 'Introduction to EEE Laboratories',\n",
       " 'C',\n",
       " '1',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE2001 ',\n",
       " 'Circuit Analysis',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2002 ',\n",
       " 'Analog Electronics',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2003 ',\n",
       " 'Semiconductor Fundamentals',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2004',\n",
       " 'Digital Electronics',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2006 ',\n",
       " 'Engineering Mathematics I',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2007 ',\n",
       " 'Engineering Mathematics I',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2008 ',\n",
       " 'Data Structures and Algorithms',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE2010 ',\n",
       " 'Signals and Systems',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " ' EE2073 ',\n",
       " 'Introduction to EEE Design & Project',\n",
       " 'C',\n",
       " '2',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3001 ',\n",
       " 'Engineering Electromagnetics',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3002 ',\n",
       " 'Microprocessors',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3010 ',\n",
       " 'Electrical Devices and Machines',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " ' EE3011 ',\n",
       " 'Modelling and Control',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3012 ',\n",
       " 'Communication Principles',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3013',\n",
       " 'Semiconductor Devices and Processing',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3014 ',\n",
       " 'Digital Signal Processing',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3015 ',\n",
       " 'Power Systems & Protection',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3017 ',\n",
       " 'Computer Communications',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3018',\n",
       " 'Introduction to Photonics',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE3019',\n",
       " 'Integrated Electronics',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3080 ',\n",
       " 'Design & Innovation Project',\n",
       " 'C',\n",
       " '2',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3179',\n",
       " 'Professional Internship *',\n",
       " 'C',\n",
       " '8',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE3279',\n",
       " 'Professional Internship *',\n",
       " 'C',\n",
       " '10',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE4001',\n",
       " 'Software Engineering',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE4080',\n",
       " 'Final Year Project *',\n",
       " 'C',\n",
       " '8',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE4105',\n",
       " 'Cellular Communication System Design *',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4109 ',\n",
       " 'Wireless System Design',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4110 ',\n",
       " 'Optical Communication System Design',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4152',\n",
       " 'Digital Communications *',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4153 ',\n",
       " 'Telecommunication System *',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4188',\n",
       " 'Wireless Communications *',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4190',\n",
       " 'Introduction to Modern Radar',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4207',\n",
       " 'Control Engineering Design',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4208',\n",
       " 'Intelligent Systems Design',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4265 ',\n",
       " 'Process Control Systems',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " ' EE4266',\n",
       " 'Computer Vision',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4268 ',\n",
       " 'Robotics and Automation',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4273 ',\n",
       " 'Digital Control Systems',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4285 ',\n",
       " 'Computational Intelligence',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4303 ',\n",
       " 'Mixed-Signal IC Design',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4304',\n",
       " 'Radio Frequency Integrated System Design',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4305',\n",
       " 'Digital Design with HDL',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " ' EE4340',\n",
       " 'VLSI Sytems',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4341',\n",
       " 'Advanced Analog Circuits',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4343',\n",
       " 'Radio Frequency Circuits',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4344 ',\n",
       " 'Analysis and Design of Integrated Circuits',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4413',\n",
       " 'DSP System Design *',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4455',\n",
       " 'Embedded Systems *',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4475 ',\n",
       " 'Audio Signal Processing *',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4476 ',\n",
       " 'Image Processing *',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " ' EE4478 ',\n",
       " 'Digital Video Processing *',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " ' EE4483',\n",
       " 'Artifical Intelligence and Data Mining',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4490',\n",
       " 'Multimedia Systems',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " ' EE4503 ',\n",
       " 'Power Engineering Design',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4504',\n",
       " 'Design of Clean Energy Systems',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4530',\n",
       " 'Power System Analysis and Control',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " ' EE4532 ',\n",
       " 'Power Electronics and Drives',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4534 ',\n",
       " 'Modern Distribution Systems with Renewable Res.',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4613',\n",
       " 'CMOS Process and Device Simulation',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4614',\n",
       " 'Device Parameter Extraction & Layout Implement.',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4645',\n",
       " 'Microfabrication Engineering',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4646',\n",
       " 'VLSI Technology',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4647',\n",
       " 'Microelectronic Devices',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4694',\n",
       " 'IC Reliability and Failure Analysis',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4717 ',\n",
       " 'Web Application Design *',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4718 ',\n",
       " 'Enterprise Network Design *',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4756',\n",
       " 'Computer Architecture *',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4758',\n",
       " 'Information Security',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4761',\n",
       " 'Computer Networking *',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4791 ',\n",
       " 'Database Systems *',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " ' EE4838',\n",
       " 'Laser Engineering and Applications',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4840',\n",
       " 'Biophotonics',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE4901',\n",
       " 'Biomedical Control System Design',\n",
       " 'PE',\n",
       " '2',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE4902',\n",
       " 'Design of Medical Information Processing Systems',\n",
       " 'PE',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " ' EE4903',\n",
       " 'Physiological Systems Analysis',\n",
       " 'PE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " ' EE4904 ',\n",
       " 'Biomedical Instrumentation',\n",
       " 'PE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE8061',\n",
       " 'Innovation and Technology Management',\n",
       " 'BM / UE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE8064 ',\n",
       " 'Intellectual Property for Electronic Engineers',\n",
       " 'BM / UE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE8084',\n",
       " 'Cyber Security',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE8085 ',\n",
       " 'Electrification for The Built Environment',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE8086',\n",
       " 'Astronomy - Stars, Galaxies and Cosmology',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " ' EE8087',\n",
       " 'Living with Mathematics',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE8092',\n",
       " 'Digital Lifestyle',\n",
       " 'STS / UE ',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE8093',\n",
       " 'Energy Devices for Sustainable Urban Environment\\xa0 ',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'EE8094',\n",
       " 'Impact Of Electromagnetic Radiation\\xa0On Humans',\n",
       " 'STS /\\xa0UE',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'EE8095',\n",
       " 'Innovation and Commercialization',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'EE8097 ',\n",
       " 'Introduction\\xa0to Spacecraft Design',\n",
       " 'STS / UE',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'IM1001',\n",
       " 'Data Structures and Algorithms',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM1002',\n",
       " 'Analog Electronics',\n",
       " 'C',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " 'IM1003',\n",
       " 'Object-Oriented Programming',\n",
       " 'C',\n",
       " '3',\n",
       " '',\n",
       " 'Y',\n",
       " ' IM1004',\n",
       " 'Digital Electronics',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " '',\n",
       " 'IM2001 ',\n",
       " 'Software Engineering',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM2002',\n",
       " 'Microprocessors',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " '',\n",
       " 'IM2003',\n",
       " 'Computer Communications',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM2004',\n",
       " 'Signals and Systems',\n",
       " 'C',\n",
       " '4',\n",
       " '',\n",
       " 'Y',\n",
       " 'IM2006',\n",
       " 'Engineering Mathematics I',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM2007',\n",
       " 'Engineering Mathematics II',\n",
       " 'C',\n",
       " '4',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM2073',\n",
       " 'Introduction to Design & Project',\n",
       " 'C',\n",
       " '2',\n",
       " '',\n",
       " 'Y',\n",
       " 'IM3001',\n",
       " 'Digital Signal Processing',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM3002',\n",
       " 'Communication Principles',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " 'Y',\n",
       " 'IM3003',\n",
       " 'Information Security',\n",
       " 'C',\n",
       " '3',\n",
       " 'Y',\n",
       " '',\n",
       " 'IM3080',\n",
       " 'Design & Innovation Project *',\n",
       " 'C',\n",
       " '2',\n",
       " 'Y',\n",
       " 'Y']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "core_value"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Convert to Excel file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['EE0002 ', 'Engineers and Society *', 'GC', '3', 'Y', 'Y'],\n",
       "       ['EE0005', 'Introduction to Data Science and AI', 'GC', '3', 'Y',\n",
       "        'Y'],\n",
       "       ['EE0040', 'Engineers and Society *', 'GC', '3', 'Y', 'Y'],\n",
       "       [' EE1002 ',\n",
       "        'Physics Foundation for Electrical & Electronic Engineering',\n",
       "        'C', '4', 'Y', 'Y'],\n",
       "       ['EE1003 ', 'Introduction to Materials for Electronics', 'C', '3',\n",
       "        'Y', 'Y'],\n",
       "       ['EE1005 ', 'From Computational Thinking to Programming', 'C',\n",
       "        '3', 'Y', 'Y'],\n",
       "       ['EE1071 ', 'Introduction to EEE Laboratories', 'C', '1', '', 'Y'],\n",
       "       ['EE2001 ', 'Circuit Analysis', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2002 ', 'Analog Electronics', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2003 ', 'Semiconductor Fundamentals', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2004', 'Digital Electronics', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2006 ', 'Engineering Mathematics I', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2007 ', 'Engineering Mathematics I', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2008 ', 'Data Structures and Algorithms', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE2010 ', 'Signals and Systems', 'C', '4', 'Y', 'Y'],\n",
       "       [' EE2073 ', 'Introduction to EEE Design & Project', 'C', '2',\n",
       "        'Y', 'Y'],\n",
       "       ['EE3001 ', 'Engineering Electromagnetics', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE3002 ', 'Microprocessors', 'C', '4', 'Y', 'Y'],\n",
       "       ['EE3010 ', 'Electrical Devices and Machines', 'PE', '3', 'Y',\n",
       "        'Y'],\n",
       "       [' EE3011 ', 'Modelling and Control', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE3012 ', 'Communication Principles', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE3013', 'Semiconductor Devices and Processing', 'PE', '3', 'Y',\n",
       "        'Y'],\n",
       "       ['EE3014 ', 'Digital Signal Processing', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE3015 ', 'Power Systems & Protection', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE3017 ', 'Computer Communications', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE3018', 'Introduction to Photonics', 'PE', '3', 'Y', ''],\n",
       "       ['EE3019', 'Integrated Electronics', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE3080 ', 'Design & Innovation Project', 'C', '2', 'Y', 'Y'],\n",
       "       ['EE3179', 'Professional Internship *', 'C', '8', 'Y', 'Y'],\n",
       "       ['EE3279', 'Professional Internship *', 'C', '10', 'Y', 'Y'],\n",
       "       ['EE4001', 'Software Engineering', 'PE', '3', 'Y', 'Y'],\n",
       "       ['EE4080', 'Final Year Project *', 'C', '8', 'Y', 'Y'],\n",
       "       ['EE4105', 'Cellular Communication System Design *', 'PE', '2',\n",
       "        '', 'Y'],\n",
       "       ['EE4109 ', 'Wireless System Design', 'PE', '2', '', 'Y'],\n",
       "       ['EE4110 ', 'Optical Communication System Design', 'PE', '2', 'Y',\n",
       "        ''],\n",
       "       ['EE4152', 'Digital Communications *', 'PE', '3', 'Y', ''],\n",
       "       ['EE4153 ', 'Telecommunication System *', 'PE', '3', '', 'Y'],\n",
       "       ['EE4188', 'Wireless Communications *', 'PE', '3', 'Y', ''],\n",
       "       ['EE4190', 'Introduction to Modern Radar', 'PE', '3', 'Y', ''],\n",
       "       ['EE4207', 'Control Engineering Design', 'PE', '2', 'Y', ''],\n",
       "       ['EE4208', 'Intelligent Systems Design', 'PE', '2', '', 'Y'],\n",
       "       ['EE4265 ', 'Process Control Systems', 'PE', '3', 'Y', ''],\n",
       "       [' EE4266', 'Computer Vision', 'PE', '3', 'Y', ''],\n",
       "       ['EE4268 ', 'Robotics and Automation', 'PE', '3', 'Y', ''],\n",
       "       ['EE4273 ', 'Digital Control Systems', 'PE', '3', '', 'Y'],\n",
       "       ['EE4285 ', 'Computational Intelligence', 'PE', '3', '', 'Y'],\n",
       "       ['EE4303 ', 'Mixed-Signal IC Design', 'PE', '2', 'Y', ''],\n",
       "       ['EE4304', 'Radio Frequency Integrated System Design', 'PE', '2',\n",
       "        '', 'Y'],\n",
       "       ['EE4305', 'Digital Design with HDL', 'PE', '2', 'Y', ''],\n",
       "       [' EE4340', 'VLSI Sytems', 'PE', '3', 'Y', ''],\n",
       "       ['EE4341', 'Advanced Analog Circuits', 'PE', '3', 'Y', ''],\n",
       "       ['EE4343', 'Radio Frequency Circuits', 'PE', '3', '', 'Y'],\n",
       "       ['EE4344 ', 'Analysis and Design of Integrated Circuits', 'PE',\n",
       "        '3', '', 'Y'],\n",
       "       ['EE4413', 'DSP System Design *', 'PE', '2', 'Y', ''],\n",
       "       ['EE4455', 'Embedded Systems *', 'PE', '3', '', 'Y'],\n",
       "       ['EE4475 ', 'Audio Signal Processing *', 'PE', '3', 'Y', ''],\n",
       "       ['EE4476 ', 'Image Processing *', 'PE', '3', 'Y', ''],\n",
       "       [' EE4478 ', 'Digital Video Processing *', 'PE', '3', '', 'Y'],\n",
       "       [' EE4483', 'Artifical Intelligence and Data Mining', 'PE', '3',\n",
       "        'Y', ''],\n",
       "       ['EE4490', 'Multimedia Systems', 'PE', '3', '', 'Y'],\n",
       "       [' EE4503 ', 'Power Engineering Design', 'PE', '2', 'Y', ''],\n",
       "       ['EE4504', 'Design of Clean Energy Systems', 'PE', '2', '', 'Y'],\n",
       "       ['EE4530', 'Power System Analysis and Control', 'PE', '3', 'Y',\n",
       "        ''],\n",
       "       [' EE4532 ', 'Power Electronics and Drives', 'PE', '3', 'Y', ''],\n",
       "       ['EE4534 ', 'Modern Distribution Systems with Renewable Res.',\n",
       "        'PE', '3', '', 'Y'],\n",
       "       ['EE4613', 'CMOS Process and Device Simulation', 'PE', '2', 'Y',\n",
       "        ''],\n",
       "       ['EE4614', 'Device Parameter Extraction & Layout Implement.',\n",
       "        'PE', '2', '', 'Y'],\n",
       "       ['EE4645', 'Microfabrication Engineering', 'PE', '3', '', 'Y'],\n",
       "       ['EE4646', 'VLSI Technology', 'PE', '3', 'Y', ''],\n",
       "       ['EE4647', 'Microelectronic Devices', 'PE', '3', 'Y', ''],\n",
       "       ['EE4694', 'IC Reliability and Failure Analysis', 'PE', '3', '',\n",
       "        'Y'],\n",
       "       ['EE4717 ', 'Web Application Design *', 'PE', '2', 'Y', ''],\n",
       "       ['EE4718 ', 'Enterprise Network Design *', 'PE', '2', '', 'Y'],\n",
       "       ['EE4756', 'Computer Architecture *', 'PE', '3', '', 'Y'],\n",
       "       ['EE4758', 'Information Security', 'PE', '3', 'Y', ''],\n",
       "       ['EE4761', 'Computer Networking *', 'PE', '3', 'Y', ''],\n",
       "       ['EE4791 ', 'Database Systems *', 'PE', '3', '', 'Y'],\n",
       "       [' EE4838', 'Laser Engineering and Applications', 'PE', '3', '',\n",
       "        'Y'],\n",
       "       ['EE4840', 'Biophotonics', 'PE', '3', '', 'Y'],\n",
       "       ['EE4901', 'Biomedical Control System Design', 'PE', '2', 'Y', ''],\n",
       "       ['EE4902', 'Design of Medical Information Processing Systems',\n",
       "        'PE', '2', '', 'Y'],\n",
       "       [' EE4903', 'Physiological Systems Analysis', 'PE', '3', 'Y', ''],\n",
       "       [' EE4904 ', 'Biomedical Instrumentation', 'PE', '3', '', 'Y'],\n",
       "       ['EE8061', 'Innovation and Technology Management', 'BM / UE', '3',\n",
       "        'Y', ''],\n",
       "       ['EE8064 ', 'Intellectual Property for Electronic Engineers',\n",
       "        'BM / UE', '3', '', 'Y'],\n",
       "       ['EE8084', 'Cyber Security', 'STS / UE', '3', 'Y', 'Y'],\n",
       "       ['EE8085 ', 'Electrification for The Built Environment',\n",
       "        'STS / UE', '3', 'Y', ''],\n",
       "       ['EE8086', 'Astronomy - Stars, Galaxies and Cosmology',\n",
       "        'STS / UE', '3', 'Y', 'Y'],\n",
       "       [' EE8087', 'Living with Mathematics', 'STS / UE', '3', '', 'Y'],\n",
       "       ['EE8092', 'Digital Lifestyle', 'STS / UE ', '3', '', 'Y'],\n",
       "       ['EE8093',\n",
       "        'Energy Devices for Sustainable Urban Environment\\xa0 ',\n",
       "        'STS / UE', '3', '', 'Y'],\n",
       "       ['EE8094', 'Impact Of Electromagnetic Radiation\\xa0On Humans',\n",
       "        'STS /\\xa0UE', '3', 'Y', 'Y'],\n",
       "       ['EE8095', 'Innovation and Commercialization', 'STS / UE', '3',\n",
       "        'Y', ''],\n",
       "       ['EE8097 ', 'Introduction\\xa0to Spacecraft Design', 'STS / UE',\n",
       "        '3', '', 'Y'],\n",
       "       ['IM1001', 'Data Structures and Algorithms', 'C', '4', 'Y', 'Y'],\n",
       "       ['IM1002', 'Analog Electronics', 'C', '3', '', 'Y'],\n",
       "       ['IM1003', 'Object-Oriented Programming', 'C', '3', '', 'Y'],\n",
       "       [' IM1004', 'Digital Electronics', 'C', '4', 'Y', ''],\n",
       "       ['IM2001 ', 'Software Engineering', 'C', '3', 'Y', 'Y'],\n",
       "       ['IM2002', 'Microprocessors', 'C', '4', 'Y', ''],\n",
       "       ['IM2003', 'Computer Communications', 'C', '3', 'Y', 'Y'],\n",
       "       ['IM2004', 'Signals and Systems', 'C', '4', '', 'Y'],\n",
       "       ['IM2006', 'Engineering Mathematics I', 'C', '4', 'Y', 'Y'],\n",
       "       ['IM2007', 'Engineering Mathematics II', 'C', '4', 'Y', 'Y'],\n",
       "       ['IM2073', 'Introduction to Design & Project', 'C', '2', '', 'Y'],\n",
       "       ['IM3001', 'Digital Signal Processing', 'C', '3', 'Y', 'Y'],\n",
       "       ['IM3002', 'Communication Principles', 'C', '3', 'Y', 'Y'],\n",
       "       ['IM3003', 'Information Security', 'C', '3', 'Y', ''],\n",
       "       ['IM3080', 'Design & Innovation Project *', 'C', '2', 'Y', 'Y']],\n",
       "      dtype='<U58')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "value=np.array(core_value)\n",
    "value=value.reshape(len(value)//6,6)\n",
    "value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>EE0002</td>\n",
       "      <td>Engineers and Society *</td>\n",
       "      <td>GC</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>EE0005</td>\n",
       "      <td>Introduction to Data Science and AI</td>\n",
       "      <td>GC</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EE0040</td>\n",
       "      <td>Engineers and Society *</td>\n",
       "      <td>GC</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EE1002</td>\n",
       "      <td>Physics Foundation for Electrical &amp; Electronic...</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EE1003</td>\n",
       "      <td>Introduction to Materials for Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>EE1005</td>\n",
       "      <td>From Computational Thinking to Programming</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>EE1071</td>\n",
       "      <td>Introduction to EEE Laboratories</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>EE2001</td>\n",
       "      <td>Circuit Analysis</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>EE2002</td>\n",
       "      <td>Analog Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>EE2003</td>\n",
       "      <td>Semiconductor Fundamentals</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>EE2004</td>\n",
       "      <td>Digital Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>EE2006</td>\n",
       "      <td>Engineering Mathematics I</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>EE2007</td>\n",
       "      <td>Engineering Mathematics I</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>EE2008</td>\n",
       "      <td>Data Structures and Algorithms</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>EE2010</td>\n",
       "      <td>Signals and Systems</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>EE2073</td>\n",
       "      <td>Introduction to EEE Design &amp; Project</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>EE3001</td>\n",
       "      <td>Engineering Electromagnetics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>EE3002</td>\n",
       "      <td>Microprocessors</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>EE3010</td>\n",
       "      <td>Electrical Devices and Machines</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>EE3011</td>\n",
       "      <td>Modelling and Control</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>EE3012</td>\n",
       "      <td>Communication Principles</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>EE3013</td>\n",
       "      <td>Semiconductor Devices and Processing</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>EE3014</td>\n",
       "      <td>Digital Signal Processing</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>EE3015</td>\n",
       "      <td>Power Systems &amp; Protection</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>EE3017</td>\n",
       "      <td>Computer Communications</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>EE3018</td>\n",
       "      <td>Introduction to Photonics</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>EE3019</td>\n",
       "      <td>Integrated Electronics</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>EE3080</td>\n",
       "      <td>Design &amp; Innovation Project</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>EE3179</td>\n",
       "      <td>Professional Internship *</td>\n",
       "      <td>C</td>\n",
       "      <td>8</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>EE3279</td>\n",
       "      <td>Professional Internship *</td>\n",
       "      <td>C</td>\n",
       "      <td>10</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>EE4901</td>\n",
       "      <td>Biomedical Control System Design</td>\n",
       "      <td>PE</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>EE4902</td>\n",
       "      <td>Design of Medical Information Processing Systems</td>\n",
       "      <td>PE</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>EE4903</td>\n",
       "      <td>Physiological Systems Analysis</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>EE4904</td>\n",
       "      <td>Biomedical Instrumentation</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>EE8061</td>\n",
       "      <td>Innovation and Technology Management</td>\n",
       "      <td>BM / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>EE8064</td>\n",
       "      <td>Intellectual Property for Electronic Engineers</td>\n",
       "      <td>BM / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>EE8084</td>\n",
       "      <td>Cyber Security</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>EE8085</td>\n",
       "      <td>Electrification for The Built Environment</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>EE8086</td>\n",
       "      <td>Astronomy - Stars, Galaxies and Cosmology</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>EE8087</td>\n",
       "      <td>Living with Mathematics</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>EE8092</td>\n",
       "      <td>Digital Lifestyle</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>EE8093</td>\n",
       "      <td>Energy Devices for Sustainable Urban Environme...</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>EE8094</td>\n",
       "      <td>Impact Of Electromagnetic Radiation On Humans</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>EE8095</td>\n",
       "      <td>Innovation and Commercialization</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>EE8097</td>\n",
       "      <td>Introduction to Spacecraft Design</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>IM1001</td>\n",
       "      <td>Data Structures and Algorithms</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>IM1002</td>\n",
       "      <td>Analog Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>IM1003</td>\n",
       "      <td>Object-Oriented Programming</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>IM1004</td>\n",
       "      <td>Digital Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>IM2001</td>\n",
       "      <td>Software Engineering</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>IM2002</td>\n",
       "      <td>Microprocessors</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>IM2003</td>\n",
       "      <td>Computer Communications</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>IM2004</td>\n",
       "      <td>Signals and Systems</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>IM2006</td>\n",
       "      <td>Engineering Mathematics I</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>IM2007</td>\n",
       "      <td>Engineering Mathematics II</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>IM2073</td>\n",
       "      <td>Introduction to Design &amp; Project</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>IM3001</td>\n",
       "      <td>Digital Signal Processing</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>IM3002</td>\n",
       "      <td>Communication Principles</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>IM3003</td>\n",
       "      <td>Information Security</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>IM3080</td>\n",
       "      <td>Design &amp; Innovation Project *</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>109 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            0                                                  1          2  \\\n",
       "0     EE0002                             Engineers and Society *         GC   \n",
       "1      EE0005                Introduction to Data Science and AI         GC   \n",
       "2      EE0040                            Engineers and Society *         GC   \n",
       "3     EE1002   Physics Foundation for Electrical & Electronic...          C   \n",
       "4     EE1003           Introduction to Materials for Electronics          C   \n",
       "5     EE1005          From Computational Thinking to Programming          C   \n",
       "6     EE1071                    Introduction to EEE Laboratories          C   \n",
       "7     EE2001                                    Circuit Analysis          C   \n",
       "8     EE2002                                  Analog Electronics          C   \n",
       "9     EE2003                          Semiconductor Fundamentals          C   \n",
       "10     EE2004                                Digital Electronics          C   \n",
       "11    EE2006                           Engineering Mathematics I          C   \n",
       "12    EE2007                           Engineering Mathematics I          C   \n",
       "13    EE2008                      Data Structures and Algorithms          C   \n",
       "14    EE2010                                 Signals and Systems          C   \n",
       "15    EE2073                Introduction to EEE Design & Project          C   \n",
       "16    EE3001                        Engineering Electromagnetics          C   \n",
       "17    EE3002                                     Microprocessors          C   \n",
       "18    EE3010                     Electrical Devices and Machines         PE   \n",
       "19    EE3011                               Modelling and Control         PE   \n",
       "20    EE3012                            Communication Principles         PE   \n",
       "21     EE3013               Semiconductor Devices and Processing         PE   \n",
       "22    EE3014                           Digital Signal Processing         PE   \n",
       "23    EE3015                          Power Systems & Protection         PE   \n",
       "24    EE3017                             Computer Communications         PE   \n",
       "25     EE3018                          Introduction to Photonics         PE   \n",
       "26     EE3019                             Integrated Electronics         PE   \n",
       "27    EE3080                         Design & Innovation Project          C   \n",
       "28     EE3179                          Professional Internship *          C   \n",
       "29     EE3279                          Professional Internship *          C   \n",
       "..        ...                                                ...        ...   \n",
       "79     EE4901                   Biomedical Control System Design         PE   \n",
       "80     EE4902   Design of Medical Information Processing Systems         PE   \n",
       "81     EE4903                     Physiological Systems Analysis         PE   \n",
       "82    EE4904                          Biomedical Instrumentation         PE   \n",
       "83     EE8061               Innovation and Technology Management    BM / UE   \n",
       "84    EE8064      Intellectual Property for Electronic Engineers    BM / UE   \n",
       "85     EE8084                                     Cyber Security   STS / UE   \n",
       "86    EE8085           Electrification for The Built Environment   STS / UE   \n",
       "87     EE8086          Astronomy - Stars, Galaxies and Cosmology   STS / UE   \n",
       "88     EE8087                            Living with Mathematics   STS / UE   \n",
       "89     EE8092                                  Digital Lifestyle  STS / UE    \n",
       "90     EE8093  Energy Devices for Sustainable Urban Environme...   STS / UE   \n",
       "91     EE8094      Impact Of Electromagnetic Radiation On Humans   STS / UE   \n",
       "92     EE8095                   Innovation and Commercialization   STS / UE   \n",
       "93    EE8097                   Introduction to Spacecraft Design   STS / UE   \n",
       "94     IM1001                     Data Structures and Algorithms          C   \n",
       "95     IM1002                                 Analog Electronics          C   \n",
       "96     IM1003                        Object-Oriented Programming          C   \n",
       "97     IM1004                                Digital Electronics          C   \n",
       "98    IM2001                                Software Engineering          C   \n",
       "99     IM2002                                    Microprocessors          C   \n",
       "100    IM2003                            Computer Communications          C   \n",
       "101    IM2004                                Signals and Systems          C   \n",
       "102    IM2006                          Engineering Mathematics I          C   \n",
       "103    IM2007                         Engineering Mathematics II          C   \n",
       "104    IM2073                   Introduction to Design & Project          C   \n",
       "105    IM3001                          Digital Signal Processing          C   \n",
       "106    IM3002                           Communication Principles          C   \n",
       "107    IM3003                               Information Security          C   \n",
       "108    IM3080                      Design & Innovation Project *          C   \n",
       "\n",
       "      3  4  5  \n",
       "0     3  Y  Y  \n",
       "1     3  Y  Y  \n",
       "2     3  Y  Y  \n",
       "3     4  Y  Y  \n",
       "4     3  Y  Y  \n",
       "5     3  Y  Y  \n",
       "6     1     Y  \n",
       "7     4  Y  Y  \n",
       "8     4  Y  Y  \n",
       "9     4  Y  Y  \n",
       "10    4  Y  Y  \n",
       "11    4  Y  Y  \n",
       "12    4  Y  Y  \n",
       "13    4  Y  Y  \n",
       "14    4  Y  Y  \n",
       "15    2  Y  Y  \n",
       "16    4  Y  Y  \n",
       "17    4  Y  Y  \n",
       "18    3  Y  Y  \n",
       "19    3  Y  Y  \n",
       "20    3  Y  Y  \n",
       "21    3  Y  Y  \n",
       "22    3  Y  Y  \n",
       "23    3  Y  Y  \n",
       "24    3  Y  Y  \n",
       "25    3  Y     \n",
       "26    3  Y  Y  \n",
       "27    2  Y  Y  \n",
       "28    8  Y  Y  \n",
       "29   10  Y  Y  \n",
       "..   .. .. ..  \n",
       "79    2  Y     \n",
       "80    2     Y  \n",
       "81    3  Y     \n",
       "82    3     Y  \n",
       "83    3  Y     \n",
       "84    3     Y  \n",
       "85    3  Y  Y  \n",
       "86    3  Y     \n",
       "87    3  Y  Y  \n",
       "88    3     Y  \n",
       "89    3     Y  \n",
       "90    3     Y  \n",
       "91    3  Y  Y  \n",
       "92    3  Y     \n",
       "93    3     Y  \n",
       "94    4  Y  Y  \n",
       "95    3     Y  \n",
       "96    3     Y  \n",
       "97    4  Y     \n",
       "98    3  Y  Y  \n",
       "99    4  Y     \n",
       "100   3  Y  Y  \n",
       "101   4     Y  \n",
       "102   4  Y  Y  \n",
       "103   4  Y  Y  \n",
       "104   2     Y  \n",
       "105   3  Y  Y  \n",
       "106   3  Y  Y  \n",
       "107   3  Y     \n",
       "108   2  Y  Y  \n",
       "\n",
       "[109 rows x 6 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=pd.DataFrame(value)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Course Code</th>\n",
       "      <th>Name</th>\n",
       "      <th>Course Type</th>\n",
       "      <th>AU</th>\n",
       "      <th>Sem 1</th>\n",
       "      <th>Sem 2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>EE0002</td>\n",
       "      <td>Engineers and Society *</td>\n",
       "      <td>GC</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>EE0005</td>\n",
       "      <td>Introduction to Data Science and AI</td>\n",
       "      <td>GC</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EE0040</td>\n",
       "      <td>Engineers and Society *</td>\n",
       "      <td>GC</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EE1002</td>\n",
       "      <td>Physics Foundation for Electrical &amp; Electronic...</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EE1003</td>\n",
       "      <td>Introduction to Materials for Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>EE1005</td>\n",
       "      <td>From Computational Thinking to Programming</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>EE1071</td>\n",
       "      <td>Introduction to EEE Laboratories</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>EE2001</td>\n",
       "      <td>Circuit Analysis</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>EE2002</td>\n",
       "      <td>Analog Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>EE2003</td>\n",
       "      <td>Semiconductor Fundamentals</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>EE2004</td>\n",
       "      <td>Digital Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>EE2006</td>\n",
       "      <td>Engineering Mathematics I</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>EE2007</td>\n",
       "      <td>Engineering Mathematics I</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>EE2008</td>\n",
       "      <td>Data Structures and Algorithms</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>EE2010</td>\n",
       "      <td>Signals and Systems</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>EE2073</td>\n",
       "      <td>Introduction to EEE Design &amp; Project</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>EE3001</td>\n",
       "      <td>Engineering Electromagnetics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>EE3002</td>\n",
       "      <td>Microprocessors</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>EE3010</td>\n",
       "      <td>Electrical Devices and Machines</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>EE3011</td>\n",
       "      <td>Modelling and Control</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>EE3012</td>\n",
       "      <td>Communication Principles</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>EE3013</td>\n",
       "      <td>Semiconductor Devices and Processing</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>EE3014</td>\n",
       "      <td>Digital Signal Processing</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>EE3015</td>\n",
       "      <td>Power Systems &amp; Protection</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>EE3017</td>\n",
       "      <td>Computer Communications</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>EE3018</td>\n",
       "      <td>Introduction to Photonics</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>EE3019</td>\n",
       "      <td>Integrated Electronics</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>EE3080</td>\n",
       "      <td>Design &amp; Innovation Project</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>EE3179</td>\n",
       "      <td>Professional Internship *</td>\n",
       "      <td>C</td>\n",
       "      <td>8</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>EE3279</td>\n",
       "      <td>Professional Internship *</td>\n",
       "      <td>C</td>\n",
       "      <td>10</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>EE4901</td>\n",
       "      <td>Biomedical Control System Design</td>\n",
       "      <td>PE</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>EE4902</td>\n",
       "      <td>Design of Medical Information Processing Systems</td>\n",
       "      <td>PE</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>EE4903</td>\n",
       "      <td>Physiological Systems Analysis</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>EE4904</td>\n",
       "      <td>Biomedical Instrumentation</td>\n",
       "      <td>PE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>EE8061</td>\n",
       "      <td>Innovation and Technology Management</td>\n",
       "      <td>BM / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>EE8064</td>\n",
       "      <td>Intellectual Property for Electronic Engineers</td>\n",
       "      <td>BM / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>EE8084</td>\n",
       "      <td>Cyber Security</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>EE8085</td>\n",
       "      <td>Electrification for The Built Environment</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>EE8086</td>\n",
       "      <td>Astronomy - Stars, Galaxies and Cosmology</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>EE8087</td>\n",
       "      <td>Living with Mathematics</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>EE8092</td>\n",
       "      <td>Digital Lifestyle</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>EE8093</td>\n",
       "      <td>Energy Devices for Sustainable Urban Environme...</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>EE8094</td>\n",
       "      <td>Impact Of Electromagnetic Radiation On Humans</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>EE8095</td>\n",
       "      <td>Innovation and Commercialization</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>EE8097</td>\n",
       "      <td>Introduction to Spacecraft Design</td>\n",
       "      <td>STS / UE</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>IM1001</td>\n",
       "      <td>Data Structures and Algorithms</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>IM1002</td>\n",
       "      <td>Analog Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>IM1003</td>\n",
       "      <td>Object-Oriented Programming</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>IM1004</td>\n",
       "      <td>Digital Electronics</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>IM2001</td>\n",
       "      <td>Software Engineering</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>IM2002</td>\n",
       "      <td>Microprocessors</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>IM2003</td>\n",
       "      <td>Computer Communications</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>IM2004</td>\n",
       "      <td>Signals and Systems</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>IM2006</td>\n",
       "      <td>Engineering Mathematics I</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>IM2007</td>\n",
       "      <td>Engineering Mathematics II</td>\n",
       "      <td>C</td>\n",
       "      <td>4</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>IM2073</td>\n",
       "      <td>Introduction to Design &amp; Project</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td></td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>IM3001</td>\n",
       "      <td>Digital Signal Processing</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>IM3002</td>\n",
       "      <td>Communication Principles</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>IM3003</td>\n",
       "      <td>Information Security</td>\n",
       "      <td>C</td>\n",
       "      <td>3</td>\n",
       "      <td>Y</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>IM3080</td>\n",
       "      <td>Design &amp; Innovation Project *</td>\n",
       "      <td>C</td>\n",
       "      <td>2</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>109 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Course Code                                               Name  \\\n",
       "0       EE0002                             Engineers and Society *   \n",
       "1        EE0005                Introduction to Data Science and AI   \n",
       "2        EE0040                            Engineers and Society *   \n",
       "3       EE1002   Physics Foundation for Electrical & Electronic...   \n",
       "4       EE1003           Introduction to Materials for Electronics   \n",
       "5       EE1005          From Computational Thinking to Programming   \n",
       "6       EE1071                    Introduction to EEE Laboratories   \n",
       "7       EE2001                                    Circuit Analysis   \n",
       "8       EE2002                                  Analog Electronics   \n",
       "9       EE2003                          Semiconductor Fundamentals   \n",
       "10       EE2004                                Digital Electronics   \n",
       "11      EE2006                           Engineering Mathematics I   \n",
       "12      EE2007                           Engineering Mathematics I   \n",
       "13      EE2008                      Data Structures and Algorithms   \n",
       "14      EE2010                                 Signals and Systems   \n",
       "15      EE2073                Introduction to EEE Design & Project   \n",
       "16      EE3001                        Engineering Electromagnetics   \n",
       "17      EE3002                                     Microprocessors   \n",
       "18      EE3010                     Electrical Devices and Machines   \n",
       "19      EE3011                               Modelling and Control   \n",
       "20      EE3012                            Communication Principles   \n",
       "21       EE3013               Semiconductor Devices and Processing   \n",
       "22      EE3014                           Digital Signal Processing   \n",
       "23      EE3015                          Power Systems & Protection   \n",
       "24      EE3017                             Computer Communications   \n",
       "25       EE3018                          Introduction to Photonics   \n",
       "26       EE3019                             Integrated Electronics   \n",
       "27      EE3080                         Design & Innovation Project   \n",
       "28       EE3179                          Professional Internship *   \n",
       "29       EE3279                          Professional Internship *   \n",
       "..          ...                                                ...   \n",
       "79       EE4901                   Biomedical Control System Design   \n",
       "80       EE4902   Design of Medical Information Processing Systems   \n",
       "81       EE4903                     Physiological Systems Analysis   \n",
       "82      EE4904                          Biomedical Instrumentation   \n",
       "83       EE8061               Innovation and Technology Management   \n",
       "84      EE8064      Intellectual Property for Electronic Engineers   \n",
       "85       EE8084                                     Cyber Security   \n",
       "86      EE8085           Electrification for The Built Environment   \n",
       "87       EE8086          Astronomy - Stars, Galaxies and Cosmology   \n",
       "88       EE8087                            Living with Mathematics   \n",
       "89       EE8092                                  Digital Lifestyle   \n",
       "90       EE8093  Energy Devices for Sustainable Urban Environme...   \n",
       "91       EE8094      Impact Of Electromagnetic Radiation On Humans   \n",
       "92       EE8095                   Innovation and Commercialization   \n",
       "93      EE8097                   Introduction to Spacecraft Design   \n",
       "94       IM1001                     Data Structures and Algorithms   \n",
       "95       IM1002                                 Analog Electronics   \n",
       "96       IM1003                        Object-Oriented Programming   \n",
       "97       IM1004                                Digital Electronics   \n",
       "98      IM2001                                Software Engineering   \n",
       "99       IM2002                                    Microprocessors   \n",
       "100      IM2003                            Computer Communications   \n",
       "101      IM2004                                Signals and Systems   \n",
       "102      IM2006                          Engineering Mathematics I   \n",
       "103      IM2007                         Engineering Mathematics II   \n",
       "104      IM2073                   Introduction to Design & Project   \n",
       "105      IM3001                          Digital Signal Processing   \n",
       "106      IM3002                           Communication Principles   \n",
       "107      IM3003                               Information Security   \n",
       "108      IM3080                      Design & Innovation Project *   \n",
       "\n",
       "    Course Type  AU Sem 1 Sem 2  \n",
       "0            GC   3     Y     Y  \n",
       "1            GC   3     Y     Y  \n",
       "2            GC   3     Y     Y  \n",
       "3             C   4     Y     Y  \n",
       "4             C   3     Y     Y  \n",
       "5             C   3     Y     Y  \n",
       "6             C   1           Y  \n",
       "7             C   4     Y     Y  \n",
       "8             C   4     Y     Y  \n",
       "9             C   4     Y     Y  \n",
       "10            C   4     Y     Y  \n",
       "11            C   4     Y     Y  \n",
       "12            C   4     Y     Y  \n",
       "13            C   4     Y     Y  \n",
       "14            C   4     Y     Y  \n",
       "15            C   2     Y     Y  \n",
       "16            C   4     Y     Y  \n",
       "17            C   4     Y     Y  \n",
       "18           PE   3     Y     Y  \n",
       "19           PE   3     Y     Y  \n",
       "20           PE   3     Y     Y  \n",
       "21           PE   3     Y     Y  \n",
       "22           PE   3     Y     Y  \n",
       "23           PE   3     Y     Y  \n",
       "24           PE   3     Y     Y  \n",
       "25           PE   3     Y        \n",
       "26           PE   3     Y     Y  \n",
       "27            C   2     Y     Y  \n",
       "28            C   8     Y     Y  \n",
       "29            C  10     Y     Y  \n",
       "..          ...  ..   ...   ...  \n",
       "79           PE   2     Y        \n",
       "80           PE   2           Y  \n",
       "81           PE   3     Y        \n",
       "82           PE   3           Y  \n",
       "83      BM / UE   3     Y        \n",
       "84      BM / UE   3           Y  \n",
       "85     STS / UE   3     Y     Y  \n",
       "86     STS / UE   3     Y        \n",
       "87     STS / UE   3     Y     Y  \n",
       "88     STS / UE   3           Y  \n",
       "89    STS / UE    3           Y  \n",
       "90     STS / UE   3           Y  \n",
       "91     STS / UE   3     Y     Y  \n",
       "92     STS / UE   3     Y        \n",
       "93     STS / UE   3           Y  \n",
       "94            C   4     Y     Y  \n",
       "95            C   3           Y  \n",
       "96            C   3           Y  \n",
       "97            C   4     Y        \n",
       "98            C   3     Y     Y  \n",
       "99            C   4     Y        \n",
       "100           C   3     Y     Y  \n",
       "101           C   4           Y  \n",
       "102           C   4     Y     Y  \n",
       "103           C   4     Y     Y  \n",
       "104           C   2           Y  \n",
       "105           C   3     Y     Y  \n",
       "106           C   3     Y     Y  \n",
       "107           C   3     Y        \n",
       "108           C   2     Y     Y  \n",
       "\n",
       "[109 rows x 6 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns=['Course Code', 'Name', 'Course Type', 'AU', 'Sem 1', 'Sem 2']\n",
    "df.set_index(pd.Index(list(range(1,110))))\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel(\"EEE NTU Courses.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}