module 2/data_scraping.ipynb

{
 "cells": [
  {
   "cell_type": "raw",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# <img style=\"float: left; padding-right: 100px; width: 300px\" src=\"images/logo.png\">AI4SG Bootcamp:\n",
    "\n",
    "\n",
    "\n",
    "## Module 2D: Data Scraping\n",
    "\n",
    "\n",
    "**Authors:** Martha Shaka\n",
    "\n",
    "---\n",
    "\n",
    "### What is Data scraping\n",
    "It is commonly defined as a system where a technology extracts data from a particular codebase or program. Data scraping provides results for a variety of uses and automates aspects of data aggregation.\n",
    "Most common data scraping is *web scraping*, is the process of importing information from a website into a spreadsheet or \n",
    "local file saved on your computer. It’s one of the most efficient ways to get data from the web, and in some cases to channel\n",
    "that data to another website. \n",
    "Data scraping has a vast number of applications – it’s useful in just about any case where data needs to be moved from one place to another"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Uses of data scraping include:\n",
    "<ol start=\"1\">\n",
    "<li>Research for web content/business intelligence </li>\n",
    "<li>Pricing for travel booker sites/price comparison sites </li>\n",
    "<li>Finding sales leads/conducting market research by crawling public data sources (e.g. Yell and Twitter) </li>\n",
    "<li>Sending product data from an e-commerce site to another online vendor (e.g. Google Shopping)</li>\n",
    "</ol>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "In this lab, we'll scrape 2019 A level Results:\n",
    "\n",
    "https://onlinesys.necta.go.tz/results/2019/acsee/acsee.htm .\n",
    "\n",
    "We'll walk through scraping the list pages for the school names/urls"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Although many programming languages offer libraries for web information retrieval and analysis, \n",
    "we will be focusing on the Python data analysis ecosystem given its popularity and capabilities."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Table of Contents \n",
    "<ol start=\"0\">\n",
    "<li> Learning Goals </li>\n",
    "<li> Exploring the Web pages and downloading them</li>\n",
    "<li> Parse the page, extract school urls </li>\n",
    "<li> Parse a school page, extract student list with results </li>\n",
    "<li> Set up a pipeline for fetching and parsing</li>\n",
    "</ol>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Learning Goals\n",
    "\n",
    "Understand the structure of a web page. Use Beautiful soup to scrape content from these web pages.\n",
    "\n",
    "*This lab corresponds to lectures 2, 3 and 4 and maps on to homework 1 and further.*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "pd.set_option('display.width', 500)\n",
    "pd.set_option('display.max_columns', 100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import time, requests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Exploring the web pages and downloading them\n",
    "\n",
    "We're going to capture infromation on the from six NECTA results list for school. \n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To getch this page we use the `requests` module. But are we allowed to do this? Lets check:\n",
    "\n",
    "https://onlinesys.necta.go.tz/results/2019/acsee/acsee.htm\n",
    "\n",
    "Yes we are."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://onlinesys.necta.go.tz/results/2019/acsee/acsee.htm\n"
     ]
    }
   ],
   "source": [
    "URLSTART=\"https://onlinesys.necta.go.tz/results/2019/acsee/acsee.htm\"\n",
    "url = URLSTART\n",
    "print(url)\n",
    "page = requests.get(url)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We can see properties of the page. Most relevant are `status_code` and `text`. The former tells us  if the web-page was found, and if found , ok. (See lecture notes.)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "page.status_code # 200 is good"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'\\ufeff<HTML>\\r\\n<HEAD>\\r\\n<META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; charset=windows-1252\">\\r\\n<HEAD>\\r\\n<BODY TEXT=\"#000080\" LINK=\"#0000ff\" VLINK=\"#800080\" BGCOLOR=\"LIGHTYELLOW\">\\r\\n<FONT COLOR=\"#800080\"><H2>NATIONAL EXAMINATIONS COUNCIL OF TANZANIA</H2>\\r\\n<H3><U> ACSEE 2019 EXAMINATION RESULTS ENQUIRIES </U></H3></FONT>\\r\\n<BR>\\r\\n<TABLE BORDER=0 CELLSPACING=0 WIDTH=\"75%\" ALIGN=\"CENTER\" >\\r\\n<TR ><TD WIDTH=\"100%\" VALIGN=\"MIDDLE\"><B><FONT FACE=\"Arial\" SIZE=2><P ALIGN=\"CENTER\">CLICK ANY LETTER BELOW TO FILTER CENTRES BY ALPHABET</B></FONT></TD></TR>\\r\\n</TABLE>\\r\\n<TABLE BORDER CELLSPACING=1 WIDTH=\"75%\" ALIGN=\"CENTER\" >\\r\\n<TR> <TD WIDTH=\"10%\" VALIGN=\"MIDDLE\" BGCOLOR=\"LIGHTGREEN\">\\r\\n<B><FONT FACE=\"Arial\" SIZE=3><P ALIGN=\"CENTER\" ><A HREF=\"index.htm\">ALL CENTRES\\r\\n <TD WIDTH=\"2.5%\" VALIGN=\"MIDDLE\" BGCOLOR=\"LIGHTBLUE\">\\r\\n<B><FONT FACE=\"Arial\" SIZE=3><P ALIGN=\"CENTER\"><A HREF=\"indexfiles/index_a.htm\">A\\r\\n</A></B></FONT></TD>\\r\\n <TD WIDTH=\"2.5%\" VALIGN=\"MIDDLE\" BGCOLOR=\"LIGHTBLUE\">\\r\\n<B><FONT FACE=\"Arial\" SIZE=3><'"
      ]
     },
     "execution_count": 164,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "page.text[:1000]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let us write a loop to fetch students results for 2 schools with code p0104 and p0110 from goodreads. Notice the use of a format string. This is an example of old-style python format strings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "FTW files/school00.html\n",
      "FTW files/school01.html\n"
     ]
    }
   ],
   "source": [
    "URLSTART=\"https://onlinesys.necta.go.tz/results/2019/acsee/results/\"\n",
    "SCHOOL=[\"p0104\",\"p0110\"]\n",
    "for i in range(0,2):\n",
    "    bookpage=str(i)\n",
    "    stuff=requests.get(URLSTART+SCHOOL[i]+\".htm\")\n",
    "    filetowrite=\"files/school\"+ '%02d' % i + \".html\"\n",
    "    print(\"FTW\", filetowrite)\n",
    "    fd=open(filetowrite,\"w\",encoding=\"utf-8\")\n",
    "    fd.write(stuff.text)\n",
    "    fd.close()\n",
    "    time.sleep(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Parse the page, extract school urls\n",
    "\n",
    "Notice how we do file input-output, and use beautiful soup in the code below. The `with` construct ensures that the file being read is closed, something we do explicitly for the file being written. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Getting the html of the page is just the first step. Next step is to create a Beautiful Soup object from the html. \n",
    "This is done by passing the html to the BeautifulSoup() function. \n",
    "The Beautiful Soup package is used to parse the html, that is, take the raw html text and break it into Python objects. The second argument 'lxml' is the html parser whose details you do not need to worry about at this point."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "FTW files/school00.html\n",
      "ï»¿<html>\n",
      "<head>\n",
      "<meta content=\"text/html; charset=utf-8\" http-equiv=\"Content-Type\"/>\n",
      "<head>\n",
      "<body bgcolor=\"LIGHTBLUE\" link=\"#0000ff\" text=\"#000080\" vlink=\"#800080\">\n",
      "<font color=\"#800080\"><h2>NATIONAL EXAMINATIONS COUNCIL OF TANZANIA</h2>\n",
      "<h1><p align=\"LEFT\"> ACSEE 2019 EXAMINATION RESULTS</p></h1>\n",
      "<h3><p align=\"LEFT\">P0104 BWIRU BOYS' SECONDARY SCHOOL CENTRE\n",
      "\n",
      "<h3>DIV-I = 1;  DIV-II = 13;  DIV-III = 41;  DIV-IV = 15;  DIV-0 = 14  </h3></p></h3></font>\n",
      "</body></head></head></html>\n",
      "<table bgcolor=\"LIGHTYELLOW\" border=\"\" cellspacing=\"2\" width=\"70%\">\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<p align=\"CENTER\"><b><font face=\"Courier\" size=\"2\">CNO</font></b></p></td></tr></table>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<b><font face=\"Courier\" size=\"2\"><p align=\"CENTER\">SEX</p></font></b></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<b><font face=\"Courier\" size=\"2\"><p align=\"CENTER\">AGGT</p></font></b></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<b><font face=\"Courier\" size=\"2\"><p align=\"CENTER\">DIV</p></font></b></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<b><font face=\"Courier\" size=\"2\"><p align=\"LEFT\">DETAILED SUBJECTS\n",
      "\n",
      "</p></font></b></td>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0501</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'E'   CHEMISTRY - 'F'   BIOLOGY - 'S'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0502</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0503</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 9</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">I</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   KISWAHILI - 'B'   ENGLISH - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0504</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'F'   GEOGR - 'S'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0505</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'D'   BAM - 'F'   ECONOMICS - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0506</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'E'   GEOGR - 'D'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0507</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'E'   KISWAHILI - 'C'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0508</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'D'   ENGLISH - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0509</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 11</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   KISWAHILI - 'B'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0510</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'E'   KISWAHILI - 'C'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0511</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'D'   GEOGR - 'E'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0512</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'B'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0513</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'S'   KISWAHILI - 'E'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0514</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0515</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'S'   KISWAHILI - 'B'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0516</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0517</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - 'C'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0518</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'D'   ENGLISH - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0519</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   GEOGR - 'E'   BAM - 'F'   ECONOMICS - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0520</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0521</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'X'   HISTORY - 'X'   KISWAHILI - 'X'   ENGLISH - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0522</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'S'   KISWAHILI - 'B'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0523</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 17</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'F'   KISWAHILI - 'D'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0524</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 11</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   KISWAHILI - 'C'   ENGLISH - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0525</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'E'   KISWAHILI - 'C'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0526</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'E'   KISWAHILI - 'D'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0527</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'E'   GEOGR - 'E'   KISWAHILI - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0528</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">BAM - 'F'   ECONOMICS - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0529</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'X'   HISTORY - 'X'   KISWAHILI - 'X'   ENGLISH - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0530</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 11</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   KISWAHILI - 'B'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0531</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 19</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'E'   BAM - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0532</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'S'   GEOGR - 'E'   ENGLISH - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0533</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'X'   PHYSICS - 'X'   CHEMISTRY - 'X'   BIOLOGY - 'X'   BAM - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0534</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'S'   KISWAHILI - 'D'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0535</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0536</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'D'   CHEMISTRY - 'F'   BIOLOGY - 'E'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0537</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'E'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0538</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'E'   KISWAHILI - 'B'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0539</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0540</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   GEOGR - 'D'   PHYSICS - 'E'   ADV/MATHS - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0541</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'X'   PHYSICS - 'X'   CHEMISTRY - 'X'   BIOLOGY - 'X'   BAM - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0542</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'X'   CHEMISTRY - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0543</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'D'   KISWAHILI - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0544</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   PHYSICS - 'F'   CHEMISTRY - 'F'   ADV/MATHS - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0545</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 17</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'F'   KISWAHILI - 'D'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0546</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'S'   CHEMISTRY - 'F'   BIOLOGY - 'E'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0547</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'D'   GEOGR - 'E'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0548</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 10</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   KISWAHILI - 'B'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0549</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   GEOGR - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0550</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 20</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'S'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0551</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'E'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0552</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">BIOLOGY - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0553</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'E'   KISWAHILI - 'D'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0554</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">CHEMISTRY - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0555</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   PHYSICS - 'F'   CHEMISTRY - 'F'   ADV/MATHS - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0556</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'X'   PHYSICS - 'X'   CHEMISTRY - 'X'   ADV/MATHS - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0557</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 19</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   GEOGR - 'E'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0558</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'E'   CHEMISTRY - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0559</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'X'   CHEMISTRY - 'X'   ADV/MATHS - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0560</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   GEOGR - 'E'   KISWAHILI - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0561</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   GEOGR - 'S'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0562</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'S'   GEOGR - 'E'   ENGLISH - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0563</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   KISWAHILI - 'C'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0564</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   GEOGR - 'E'   CHEMISTRY - 'E'   BIOLOGY - 'E'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0565</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'X'   CHEMISTRY - 'X'   BIOLOGY - 'X'   BAM - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0566</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0567</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 14</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'D'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0568</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   PHYSICS - 'F'   CHEMISTRY - 'F'   ADV/MATHS - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0569</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 20</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'S'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0570</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0571</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">HISTORY - 'E'   GEOGR - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0572</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   GEOGR - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0573</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'X'   HISTORY - 'X'   KISWAHILI - 'X'   ENGLISH - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0574</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 19</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'E'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0575</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'S'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0576</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0577</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 15</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'E'   KISWAHILI - 'C'   ENGLISH - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0578</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   GEOGR - 'E'   ENGLISH - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0579</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 13</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'E'   GEOGR - 'E'   KISWAHILI - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0580</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 17</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'D'   CHEMISTRY - 'F'   BIOLOGY - 'S'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0581</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   GEOGR - 'D'   CHEMISTRY - 'S'   BIOLOGY - 'S'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0582</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 17</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   PHYSICS - 'E'   CHEMISTRY - 'F'   ADV/MATHS - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0583</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 17</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   GEOGR - 'S'   KISWAHILI - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0584</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   HISTORY - 'F'   ENGLISH - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0585</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 10</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   GEOGR - 'D'   KISWAHILI - 'B'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0586</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 19</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'E'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0587</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'E'   GEOGR - 'D'   KISWAHILI - 'C'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0588</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'S'   CHEMISTRY - 'S'   BIOLOGY - 'D'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0589</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">ABS</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">PHYSICS - 'X'   CHEMISTRY - 'X'   ADV/MATHS - 'X'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0590</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0591</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   PHYSICS - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0592</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 12</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">II</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'D'   KISWAHILI - 'C'   ENGLISH - 'E'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0593</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> -</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'E'   CHEMISTRY - 'F'   BIOLOGY - 'X'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0594</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   GEOGR - 'D'   CHEMISTRY - 'F'   BIOLOGY - 'E'   BAM - 'F'   </p></font></td></tr>\n",
      "<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0595</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">M</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 21</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">0</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   GEOGR - 'F'   CHEMISTRY - 'F'   BIOLOGY - 'F'   BAM - 'F'   </p></font></td></tr>\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "filetoread=\"files/school00.html\"\n",
    "print(\"FTW\", filetoread)\n",
    "with open(filetoread) as fdr:\n",
    "    data = fdr.read()\n",
    "    soup = BeautifulSoup(data, 'html.parser')\n",
    "print(soup)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The soup object allows you to extract interesting information about the website you're scraping such as getting the title of the page as shown below. \n",
    "You can view the html of the webpage by right-clicking anywhere on the webpage and selecting \"Inspect.\" This above see shows what the result looks like."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "None\n"
     ]
    }
   ],
   "source": [
    "# Get the title\n",
    "title = soup.title\n",
    "print(title)               #for this page it has no title as you can see on the above html codes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can use the find_all() method of soup to extract useful html tags within a webpage. \n",
    "Examples of useful tags include < a > for hyperlinks, < table > for tables, < tr > for table rows, < th > for table headers, and < td > for table cells.\n",
    "The code below shows how to extract all the rows within the table in a webpage. for our case we have only one table."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[<tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<p align=\"CENTER\"><b><font face=\"Courier\" size=\"2\">CNO</font></b></p></td></tr>, <tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0501</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'F'   GEOGR - 'E'   CHEMISTRY - 'F'   BIOLOGY - 'S'   BAM - 'F'   </p></font></td></tr>, <tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0502</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 16</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">III</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'F'   KISWAHILI - 'C'   ENGLISH - 'S'   </p></font></td></tr>, <tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0503</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 9</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">I</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'E'   HISTORY - 'D'   KISWAHILI - 'B'   ENGLISH - 'C'   </p></font></td></tr>, <tr><td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">P0104/0504</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">F</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"6%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\"> 18</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"4%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"CENTER\">IV</p></font></td>\n",
      "<td valign=\"MIDDLE\" width=\"58%\">\n",
      "<font face=\"Arial\" size=\"1\"><p align=\"LEFT\">G/STUDIES - 'S'   HISTORY - 'F'   GEOGR - 'S'   ENGLISH - 'E'   </p></font></td></tr>]\n"
     ]
    }
   ],
   "source": [
    "rows = soup.find_all('tr')\n",
    "print(rows[:5])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The output above shows that each row is printed with html tags embedded in each row. This is not what you want. You can use remove the html tags using Beautiful Soup or regular expressions.\n",
    "\n",
    "The easiest way to remove html tags is to use Beautiful Soup, and it takes just one line of code to do this. Pass the string of interest into BeautifulSoup() and use the get_text() method to extract the text without html tags."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[\"[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - 'C'   ENGLISH - 'D'   ]\", \"[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - 'C'   ENGLISH - 'D'   ]\", \"[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - 'C'   ENGLISH - 'D'   ]\", \"[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - 'C'   ENGLISH - 'D'   ]\", \"[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - 'C'   ENGLISH - 'D'   ]\"]\n"
     ]
    }
   ],
   "source": [
    "#finding columns in each row\n",
    "cols= []\n",
    "for row in rows:\n",
    "    cells = row.find_all('td')\n",
    "    cleantext = BeautifulSoup(str_cells, \"lxml\").get_text()\n",
    "    cols.append(cleantext)\n",
    "print(cols[:5])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The next step is to convert the list into a dataframe and get a quick view of the first 10 rows using Pandas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 172,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   0\n",
       "0  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "1  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "2  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "3  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "4  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "5  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "6  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "7  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "8  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
       "9  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ..."
      ]
     },
     "execution_count": 172,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataframe = pd.DataFrame(cols)\n",
    "dataframe.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "okey lets do the same for all the schools we have saved their html files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 175,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "FTW files/school00.html\n",
      "                                                    0\n",
      "0   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "1   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "2   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "3   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "4   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "5   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "6   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "7   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "8   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "9   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "10  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "11  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "12  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "13  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "14  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "15  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "16  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "17  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "18  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "19  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "20  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "21  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "22  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "23  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "24  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "25  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "26  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "27  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "28  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "29  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "..                                                ...\n",
      "66  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "67  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "68  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "69  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "70  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "71  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "72  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "73  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "74  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "75  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "76  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "77  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "78  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "79  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "80  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "81  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "82  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "83  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "84  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "85  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "86  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "87  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "88  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "89  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "90  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "91  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "92  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "93  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "94  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "95  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "\n",
      "[96 rows x 1 columns]\n",
      "FTW files/school01.html\n",
      "                                                     0\n",
      "0    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "1    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "2    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "3    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "4    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "5    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "6    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "7    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "8    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "9    [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "10   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "11   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "12   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "13   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "14   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "15   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "16   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "17   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "18   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "19   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "20   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "21   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "22   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "23   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "24   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "25   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "26   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "27   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "28   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "29   [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "..                                                 ...\n",
      "307  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "308  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "309  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "310  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "311  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "312  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "313  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "314  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "315  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "316  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "317  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "318  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "319  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "320  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "321  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "322  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "323  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "324  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "325  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "326  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "327  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "328  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "329  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "330  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "331  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "332  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "333  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "334  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "335  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "336  [\\nP0110/0741, \\nF, \\n 13, \\nIII, \\nG/STUDIES ...\n",
      "\n",
      "[337 rows x 1 columns]\n"
     ]
    }
   ],
   "source": [
    "list_rows = []\n",
    "for i in range(0,2):    \n",
    "    stri = '%02d' % i\n",
    "    filetoread=\"files/school\"+ stri + '.html'\n",
    "    print(\"FTW\", filetoread)\n",
    "    with open(filetoread) as fdr:\n",
    "        data = fdr.read()\n",
    "    soup = BeautifulSoup(data, 'html.parser')\n",
    "    rows = soup.find_all('tr')\n",
    "    schoolNames=soup.select(\"h3\")[0].text\n",
    "\n",
    "    \n",
    "    for row in rows:\n",
    "        cells = row.find_all('td')\n",
    "        cleantext = BeautifulSoup(str_cells, \"lxml\").get_text()\n",
    "        list_rows.append(cleantext)\n",
    "     \n",
    "    df = pd.DataFrame(list_rows)\n",
    "    print(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. Data Manipulation and Cleaning\n",
    "\n",
    "Ok so now lets dive in and get the data in the format required.\n",
    "The dataframe is not in the format we want. To clean it up, you should split the \"0\" column into multiple columns at the comma position. This is accomplished by using the str.split() method."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 184,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[\\nP0110/0741</td>\n",
       "      <td>\\nF</td>\n",
       "      <td>\\n 13</td>\n",
       "      <td>\\nIII</td>\n",
       "      <td>\\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               0     1       2       3                                                  4\n",
       "0  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "1  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "2  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "3  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "4  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "5  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "6  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "7  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "8  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI...\n",
       "9  [\\nP0110/0741   \\nF   \\n 13   \\nIII   \\nG/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI..."
      ]
     },
     "execution_count": 184,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df[0].str.split(',', expand=True)\n",
    "df1.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This looks much better, but there is still work to do. The dataframe has unwanted square brackets surrounding each row. You can use the strip() method to remove the opening square bracket on column \"0.\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            0  1   2    3                                                  4\n",
       "0  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "1  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "2  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "3  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "4  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "5  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "6  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "7  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "8  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "9  P0110/0741  F  13  III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ..."
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[0] = df1[0].str.strip('[')    #removing the [ in column 1\n",
    "df1[4] = df1[4].str.strip('[')    #removing the [ in the last column \n",
    "df1[0] = df1[0].str.strip('\\n') \n",
    "df1[1] = df1[1].str.strip(' \\n') \n",
    "df1[2] = df1[2].str.strip('\\n ') \n",
    "df1[3] = df1[3].str.strip(' \\n')\n",
    "df1[4] = df1[4].str.strip(' \\n') #removing the \\n in all the columns\n",
    "df1.head(10)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![](images/goodreads3.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The table is missing table headers. You can use the find_all() method to get the table headers. The html tag fpr table header is usually <th> but for our case there is no defined table header we will just right the list of the columns name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "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>index</th>\n",
       "      <th>sex</th>\n",
       "      <th>aggr</th>\n",
       "      <th>division</th>\n",
       "      <th>subjects</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>P0110/0741</td>\n",
       "      <td>F</td>\n",
       "      <td>13</td>\n",
       "      <td>III</td>\n",
       "      <td>G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        index sex aggr division                                           subjects\n",
       "0  P0110/0741   F   13      III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "1  P0110/0741   F   13      III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "2  P0110/0741   F   13      III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "3  P0110/0741   F   13      III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ...\n",
       "4  P0110/0741   F   13      III  G/STUDIES - 'E'   HISTORY - 'S'   KISWAHILI - ..."
      ]
     },
     "execution_count": 190,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.columns = ['index' , 'sex', 'aggr','division','subjects']\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 337 entries, 0 to 336\n",
      "Data columns (total 5 columns):\n",
      "index       337 non-null object\n",
      "sex         337 non-null object\n",
      "aggr        337 non-null object\n",
      "division    337 non-null object\n",
      "subjects    337 non-null object\n",
      "dtypes: object(5)\n",
      "memory usage: 13.2+ KB\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(337, 5)"
      ]
     },
     "execution_count": 191,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.info()\n",
    "df1.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we can save the data for future uses.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"files/student_results.csv\", index=False, header=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Exercise \n",
    "Your job is to write the code to get the list of ten schools code for example Bwiru Boys' Center is P0104 and save in a list called school_code."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Use this link https://onlinesys.necta.go.tz/results/2019/acsee/acsee.htm to get list of the school codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "FTW files/homepage.html\n",
      "FTW files/homepage.html\n",
      "['results/p0101.htm', 'results/p0104.htm', 'results/p0110.htm', 'results/p0112.htm', 'results/p0116.htm', 'results/p0119.htm', 'results/p0123.htm', 'results/p0129.htm', 'results/p0132.htm', 'results/p0133.htm']\n"
     ]
    }
   ],
   "source": [
    "## write you code here\n",
    "\n",
    "## Get the html file first and save it as homepage.html at the folder called results\n",
    "\n",
    "####################### write you code here\n",
    "\n",
    "\n",
    "## Create Beautiful soup object\n",
    "school_url= []\n",
    "filetoread=\"files/homepage.html\"\n",
    "####################### write you code here\n",
    "\n",
    "\n",
    "##Create a list of url for the first 100 schools\n",
    "\n",
    "####################### write you code here"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 4. Set up a pipeline for fetching and parsing\n",
    "\n",
    "Ok lets get back to the fetching..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "FTW results/p0101.htm\n",
      "FTW results/p0104.htm\n"
     ]
    }
   ],
   "source": [
    "\n",
    "urlStart = \"https://onlinesys.necta.go.tz/results/2019/acsee/\"\n",
    "for i in range(0,20):    \n",
    "    stuff=requests.get(urlStart+school_url[i])\n",
    "    filetowrite = school_url[i]\n",
    "    print(\"FTW\", filetowrite)\n",
    "    f = open(filetowrite,'w',encoding=\"utf-8\")\n",
    "    f.write(stuff.text)\n",
    "    f.close()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We have now saved html files for each school according to there school codes\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Note\n",
    "\n",
    "Now we have used Beautiful soup to scrape content from NECTA website. \n",
    "\n",
    "Whether or not you intend to use data scraping in your work, it’s advisable to still educate yourself on the subject, as it is most likely to become even more important in the next few years.\n",
    "\n",
    "There are now data scraping AI on the market that can use machine learning to keep on getting better at recognising inputs which only humans have traditionally been able to interpret – like images"
   ]
  }
 ],
 "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"
  },
  "latex_envs": {
   "LaTeX_envs_menu_present": true,
   "autoclose": false,
   "autocomplete": true,
   "bibliofile": "biblio.bib",
   "cite_by": "apalike",
   "current_citInitial": 1,
   "eqLabelWithNumbers": true,
   "eqNumInitial": 1,
   "hotkeys": {
    "equation": "Ctrl-E",
    "itemize": "Ctrl-I"
   },
   "labels_anchors": false,
   "latex_user_defs": false,
   "report_style_numbering": false,
   "user_envs_cfg": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}