saudi_ach_girls_the_priv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from bs4 import BeautifulSoup\n",
    "import re\n",
    "import pandas as pd\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.common.exceptions import TimeoutException\n",
    "from selenium.common.exceptions import NoSuchElementException\n",
    "import time "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url= 'https://www.qiyas.sa/en/Statistics-Data/Schools/Pages/DetResults.aspx'\n",
    "\n",
    "#Create a new Safari browser object\n",
    "driver = webdriver.Safari()\n",
    "driver.implicitly_wait(100)\n",
    "\n",
    "#Go to the website\n",
    "driver.get(url)\n",
    "\n",
    "##Extract data for Achievement, Girls, Theoretical, Private##\n",
    "    \n",
    "#Click on 'Achievement'\n",
    "driver.find_element_by_xpath('/html/body/form/div[3]/div/div/section/div[2]/div/div[1]/article/div[2]/div[1]/div/div/div/div[1]/div/span/div[1]/div/table/tbody/tr[1]/td/div/div[2]/div/label').click()\n",
    "\n",
    "#Click on 'Girls'\n",
    "driver.find_element_by_xpath('/html/body/form/div[3]/div/div/section/div[2]/div/div[1]/article/div[2]/div[1]/div/div/div/div[1]/div/span/div[1]/div/table/tbody/tr[2]/td/div/div[2]/div/label').click() \n",
    "\n",
    "#Click on 'Theoretical'\n",
    "driver.find_element_by_xpath('/html/body/form/div[3]/div/div/section/div[2]/div/div[1]/article/div[2]/div[1]/div/div/div/div[1]/div/span/div[1]/div/table/tbody/tr[3]/td/div/div[2]/div/label').click() \n",
    "\n",
    "#Click on 'Private'\n",
    "driver.find_element_by_xpath('/html/body/form/div[3]/div/div/section/div[2]/div/div[1]/article/div[2]/div[1]/div/div/div/div[1]/div/span/div[1]/div/table/tbody/tr[4]/td/div/div[2]/div').click() \n",
    "\n",
    "#Click on 'View the order of all schools'\n",
    "driver.find_element_by_xpath('/html/body/form/div[3]/div/div/section/div[2]/div/div[1]/article/div[2]/div[1]/div/div/div/div[1]/div/span/div[1]/div/table/tbody/tr[5]/td/span[1]/label').click() \n",
    "\n",
    "#Click on 'Submit'\n",
    "driver.find_element_by_xpath('/html/body/form/div[3]/div/div/section/div[2]/div/div[1]/article/div[2]/div[1]/div/div/div/div[1]/div/span/div[2]/div').click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>General Rank</th>\n",
       "      <th>Ministerial Number</th>\n",
       "      <th>School Name</th>\n",
       "      <th>City</th>\n",
       "      <th>Region</th>\n",
       "      <th>School Type</th>\n",
       "      <th>Category</th>\n",
       "      <th>Average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>96662</td>\n",
       "      <td>ثانوية دور الذكرالأهلية لتحفيظ القرآن الكريم</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تحفيظ بنات</td>\n",
       "      <td>78.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>46</td>\n",
       "      <td>35179</td>\n",
       "      <td>ثانوية دارالقلم النموذجية الأهلية</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>75.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>42262</td>\n",
       "      <td>مدارس طيبة الطيبة الأهلية - المرحلة الثانوية</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>75.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>60</td>\n",
       "      <td>97424</td>\n",
       "      <td>ثانوية الأرقم الأهلية لتحفيظ القرآن الكريم</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تحفيظ بنات</td>\n",
       "      <td>74.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>70</td>\n",
       "      <td>35066</td>\n",
       "      <td>ثانوية الذكر بجدة نظام مقررات</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>73.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>73</td>\n",
       "      <td>55693</td>\n",
       "      <td>ثانوية مدارس دار البيان الأهلية</td>\n",
       "      <td>الخبر</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>73.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>79</td>\n",
       "      <td>28252</td>\n",
       "      <td>ثانوية دار البشرى الأهلية بمكة المكرمة</td>\n",
       "      <td>مكة المكرمة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>87</td>\n",
       "      <td>51279</td>\n",
       "      <td>ثانوية الرشاد النموذجيه</td>\n",
       "      <td>الرس</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>72.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91</td>\n",
       "      <td>195029</td>\n",
       "      <td>ثانوية الفرسان الأهلية - المقررات</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>72.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>99</td>\n",
       "      <td>966465</td>\n",
       "      <td>ثانوية الرواد الأهلية ( الازدهار ) - مقررات</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>72.12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  General Rank Ministerial Number  \\\n",
       "0           12              96662   \n",
       "1           46              35179   \n",
       "2           50              42262   \n",
       "3           60              97424   \n",
       "4           70              35066   \n",
       "5           73              55693   \n",
       "6           79              28252   \n",
       "7           87              51279   \n",
       "8           91             195029   \n",
       "9           99             966465   \n",
       "\n",
       "                                    School Name             City      Region  \\\n",
       "0  ثانوية دور الذكرالأهلية لتحفيظ القرآن الكريم           الرياض      Riyadh   \n",
       "1             ثانوية دارالقلم النموذجية الأهلية              جدة      Makkah   \n",
       "2  مدارس طيبة الطيبة الأهلية - المرحلة الثانوية  المدينة المنورة      Madina   \n",
       "3    ثانوية الأرقم الأهلية لتحفيظ القرآن الكريم           الرياض      Riyadh   \n",
       "4                 ثانوية الذكر بجدة نظام مقررات              جدة      Makkah   \n",
       "5               ثانوية مدارس دار البيان الأهلية            الخبر  AlSharquia   \n",
       "6        ثانوية دار البشرى الأهلية بمكة المكرمة      مكة المكرمة      Makkah   \n",
       "7                       ثانوية الرشاد النموذجيه             الرس      Qassim   \n",
       "8             ثانوية الفرسان الأهلية - المقررات           الرياض      Riyadh   \n",
       "9   ثانوية الرواد الأهلية ( الازدهار ) - مقررات           الرياض      Riyadh   \n",
       "\n",
       "  School Type        Category Average  \n",
       "0    Domestic      تحفيظ بنات   78.63  \n",
       "1    Domestic  تعليم عام بنات   75.44  \n",
       "2    Domestic  تعليم عام بنات   75.12  \n",
       "3    Domestic      تحفيظ بنات   74.55  \n",
       "4    Domestic          مقررات    73.6  \n",
       "5    Domestic  تعليم عام بنات   73.32  \n",
       "6    Domestic  تعليم عام بنات      73  \n",
       "7    Domestic  تعليم عام بنات   72.33  \n",
       "8    Domestic          مقررات   72.29  \n",
       "9    Domestic          مقررات   72.12  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Retrieving table from first page \n",
    "time.sleep(5)\n",
    "soup_cbsp= BeautifulSoup(driver.page_source, 'html.parser')\n",
    "\n",
    "#Parse and extract data \n",
    "table= soup_cbsp.find_all(class_='table-responsive')[1]\n",
    "\n",
    "rows=table.find_all('tr')\n",
    "\n",
    "COLUMNS= ['General Rank', 'Ministerial Number', 'School Name', \n",
    "          'City', 'Region', 'School Type', 'Category', 'Average']\n",
    "\n",
    "sub_df=[]\n",
    "for row in rows:\n",
    "    cells= row.select('td')\n",
    "    cells=cells[0:8]\n",
    "    sub_df.append([cell.text.strip() for cell in cells])\n",
    "\n",
    "data_agtp = pd.DataFrame(sub_df, columns=COLUMNS).drop([0,1], axis=0).reset_index(drop=True)\n",
    "data_agtp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No more pages left\n"
     ]
    }
   ],
   "source": [
    "while True: \n",
    "    try: \n",
    "        next_page_btn= driver.find_elements(By.CLASS_NAME, \"Next\")\n",
    "        if not next_page_btn:\n",
    "            print(\"No next button\")\n",
    "            break\n",
    "        next_btn= next_page_btn[0]\n",
    "        if next_btn.get_attribute(\"class\")== \"aspNetDisabled Next\":\n",
    "            print(\"No more pages left\")\n",
    "            break\n",
    "        else: \n",
    "            WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.CLASS_NAME, \"Next\"))).click()\n",
    "        \n",
    "            time.sleep(10)\n",
    "        \n",
    "            soup_pgs= BeautifulSoup(driver.page_source, 'html.parser')\n",
    "        \n",
    "            #Parse and extract data \n",
    "        \n",
    "            table_pgs= soup_pgs.find_all(class_='table-responsive')[1]\n",
    "        \n",
    "            rows_pgs=table_pgs.find_all('tr')\n",
    "        \n",
    "            COLUMNS_pgs= ['General Rank', 'Ministerial Number', 'School Name', \n",
    "                  'City', 'Region', 'School Type', 'Category', 'Average']\n",
    "        \n",
    "            sub_df_pgs=[]\n",
    "            for row_pgs in rows_pgs:\n",
    "                cells_pgs= row_pgs.select('td')\n",
    "                cells_pgs=cells_pgs[0:8]\n",
    "                sub_df_pgs.append([cell_pgs.text.strip() for cell_pgs in cells_pgs])\n",
    "        \n",
    "            data_pgs = pd.DataFrame(sub_df_pgs, columns=COLUMNS_pgs).drop([0,1], axis=0).reset_index(drop=True)\n",
    "            data_agtp=data_agtp.append(data_pgs, ignore_index=True)\n",
    "        \n",
    "    except TimeoutException:\n",
    "        print(\"Exception has been thrown. No more pages left\")\n",
    "        break\n",
    "driver.quit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>General Rank</th>\n",
       "      <th>Ministerial Number</th>\n",
       "      <th>School Name</th>\n",
       "      <th>City</th>\n",
       "      <th>Region</th>\n",
       "      <th>School Type</th>\n",
       "      <th>Category</th>\n",
       "      <th>Average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>96662</td>\n",
       "      <td>ثانوية دور الذكرالأهلية لتحفيظ القرآن الكريم</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تحفيظ بنات</td>\n",
       "      <td>78.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>46</td>\n",
       "      <td>35179</td>\n",
       "      <td>ثانوية دارالقلم النموذجية الأهلية</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>75.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>50</td>\n",
       "      <td>42262</td>\n",
       "      <td>مدارس طيبة الطيبة الأهلية - المرحلة الثانوية</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>75.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>60</td>\n",
       "      <td>97424</td>\n",
       "      <td>ثانوية الأرقم الأهلية لتحفيظ القرآن الكريم</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تحفيظ بنات</td>\n",
       "      <td>74.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>70</td>\n",
       "      <td>35066</td>\n",
       "      <td>ثانوية الذكر بجدة نظام مقررات</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>73.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>73</td>\n",
       "      <td>55693</td>\n",
       "      <td>ثانوية مدارس دار البيان الأهلية</td>\n",
       "      <td>الخبر</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>73.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>79</td>\n",
       "      <td>28252</td>\n",
       "      <td>ثانوية دار البشرى الأهلية بمكة المكرمة</td>\n",
       "      <td>مكة المكرمة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>87</td>\n",
       "      <td>51279</td>\n",
       "      <td>ثانوية الرشاد النموذجيه</td>\n",
       "      <td>الرس</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>72.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>91</td>\n",
       "      <td>195029</td>\n",
       "      <td>ثانوية الفرسان الأهلية - المقررات</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>72.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>99</td>\n",
       "      <td>966465</td>\n",
       "      <td>ثانوية الرواد الأهلية ( الازدهار ) - مقررات</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>72.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>104</td>\n",
       "      <td>35080</td>\n",
       "      <td>ثانوية المستقبل</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>72.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>110</td>\n",
       "      <td>42356</td>\n",
       "      <td>مدارس درر المدينة الأهلية- المرحلة الثانوية</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>71.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>127</td>\n",
       "      <td>59099</td>\n",
       "      <td>ثانوية النخبة النموذجية</td>\n",
       "      <td>الأحساء</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>71.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>131</td>\n",
       "      <td>59008</td>\n",
       "      <td>ثانوية دور العلوم الأهلية</td>\n",
       "      <td>الأحساء</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>71.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>215</td>\n",
       "      <td>97128</td>\n",
       "      <td>ثانوية التعاون النموذجية الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>221</td>\n",
       "      <td>96627</td>\n",
       "      <td>ثانوية الدوحة السعودية الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>228</td>\n",
       "      <td>96634</td>\n",
       "      <td>ثانوية السمو الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>245</td>\n",
       "      <td>97423</td>\n",
       "      <td>ثانوية الأرقم الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>250</td>\n",
       "      <td>42250</td>\n",
       "      <td>مدارس دار الأمان الأهلية - المرحلة الثانوية</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>283</td>\n",
       "      <td>35078</td>\n",
       "      <td>ثانوية العقيق</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>284</td>\n",
       "      <td>35063</td>\n",
       "      <td>ثانوية روضة جدة النموذجية</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>69.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>293</td>\n",
       "      <td>351805</td>\n",
       "      <td>ثانوية الاندلس بجدة نظام مقررات</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>68.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>320</td>\n",
       "      <td>96969</td>\n",
       "      <td>ثانوية الإحسان الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>68.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>328</td>\n",
       "      <td>42347</td>\n",
       "      <td>مدارس العقيق الأهلية - المرحلة الثانوية (مقررات)</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>68.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>330</td>\n",
       "      <td>590215</td>\n",
       "      <td>مدارس أكاديمية الكفاح الأهلية للتعليم - الثانو...</td>\n",
       "      <td>الأحساء</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>68.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>349</td>\n",
       "      <td>966645</td>\n",
       "      <td>ثانوية التربية الأهلية - مقررات</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>68.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>431</td>\n",
       "      <td>42355</td>\n",
       "      <td>مدارس أنوار الفيحاء الأهلية - المرحلة الثانوية</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>67.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>483</td>\n",
       "      <td>42271</td>\n",
       "      <td>مدارس المعتز بالله الأهلية - المرحلة الثانوية</td>\n",
       "      <td>المدينة المنورة</td>\n",
       "      <td>Madina</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>67.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>496</td>\n",
       "      <td>96940</td>\n",
       "      <td>ثانوية الوسط الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>67.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>509</td>\n",
       "      <td>59187</td>\n",
       "      <td>ثانوية رؤية المستقبل</td>\n",
       "      <td>الأحساء</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>67.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>1343</td>\n",
       "      <td>96666</td>\n",
       "      <td>ثانوية الزهراء الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>1344</td>\n",
       "      <td>51270</td>\n",
       "      <td>ثانوية الغصون</td>\n",
       "      <td>الرس</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>1346</td>\n",
       "      <td>51284</td>\n",
       "      <td>ثانوية الوعد الاهلية</td>\n",
       "      <td>الرس</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>1354</td>\n",
       "      <td>966255</td>\n",
       "      <td>ثانوية دار السلام الأهلية - مقررات</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>مقررات</td>\n",
       "      <td>62.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>1356</td>\n",
       "      <td>49042</td>\n",
       "      <td>ثانوية فجر القصيم الأهلية ببريدة</td>\n",
       "      <td>بريدة</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>1360</td>\n",
       "      <td>63698</td>\n",
       "      <td>ثانوية  مدارس أبها الأهلية</td>\n",
       "      <td>أبها</td>\n",
       "      <td>Asser</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>1366</td>\n",
       "      <td>31547</td>\n",
       "      <td>ثانوية صروح العلم والتربية الأهلية بالطائف</td>\n",
       "      <td>الطائف</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>1370</td>\n",
       "      <td>56235</td>\n",
       "      <td>ثانوية مدارس درر الجزيرة الاهلية للبنات</td>\n",
       "      <td>الخبر</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>1371</td>\n",
       "      <td>60844</td>\n",
       "      <td>ثانوية نور التوحيد الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1377</td>\n",
       "      <td>31235</td>\n",
       "      <td>ثانوية أنجال المملكة الأهلية بالطائف</td>\n",
       "      <td>الطائف</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>1387</td>\n",
       "      <td>96645</td>\n",
       "      <td>ثانوية شبه الجزيرة الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>1397</td>\n",
       "      <td>35216</td>\n",
       "      <td>ثانوية جيل الحضارة الاهلية</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1400</td>\n",
       "      <td>60762</td>\n",
       "      <td>ثانوية  تربية الأجيال الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>1427</td>\n",
       "      <td>49157</td>\n",
       "      <td>ثانوية فجر القصيم الاهلية لتعليم الكبيرات ببريدة</td>\n",
       "      <td>بريدة</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>1445</td>\n",
       "      <td>60845</td>\n",
       "      <td>ثانوية منار السبيل الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>61.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>1453</td>\n",
       "      <td>35143</td>\n",
       "      <td>ثانوية الطفل المثالي</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>61.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>1469</td>\n",
       "      <td>31429</td>\n",
       "      <td>ثانوية واحة الفكر الأهلية بالطائف</td>\n",
       "      <td>الطائف</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>61.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>1490</td>\n",
       "      <td>96980</td>\n",
       "      <td>ثانوية الديوان الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>61.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>1492</td>\n",
       "      <td>97070</td>\n",
       "      <td>ثانوية أضواء الرياض الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>61.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>1504</td>\n",
       "      <td>28357</td>\n",
       "      <td>ثانوية البتول الأهلية بمكة المكرمة</td>\n",
       "      <td>مكة المكرمة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>61.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>1529</td>\n",
       "      <td>60831</td>\n",
       "      <td>ثانوية رواد النجاح الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>60.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>1556</td>\n",
       "      <td>35145</td>\n",
       "      <td>ثانوية الشعلة</td>\n",
       "      <td>جدة</td>\n",
       "      <td>Makkah</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>60.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>1558</td>\n",
       "      <td>60817</td>\n",
       "      <td>ثانوية الأكاديمية العصرية الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>60.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>1574</td>\n",
       "      <td>60738</td>\n",
       "      <td>ثانوية الواحة الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>59.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>1578</td>\n",
       "      <td>48918</td>\n",
       "      <td>ثانوية أنجال القصيم الأهلية ببريدة</td>\n",
       "      <td>بريدة</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>59.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>1579</td>\n",
       "      <td>96653</td>\n",
       "      <td>ثانوية الشفا الأهلية</td>\n",
       "      <td>الرياض</td>\n",
       "      <td>Riyadh</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>59.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>1585</td>\n",
       "      <td>48963</td>\n",
       "      <td>ثانوية البيان الأهلية ببريدة</td>\n",
       "      <td>بريدة</td>\n",
       "      <td>Qassim</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>59.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>1608</td>\n",
       "      <td>75068</td>\n",
       "      <td>ثانوية التربية  الإسلامية بحائل</td>\n",
       "      <td>حائل</td>\n",
       "      <td>Hail</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>58.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>1617</td>\n",
       "      <td>60814</td>\n",
       "      <td>ثانوية المجد الأهلية</td>\n",
       "      <td>حفر الباطن</td>\n",
       "      <td>AlSharquia</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>58.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>1625</td>\n",
       "      <td>186879</td>\n",
       "      <td>ثانوية بيت القيم الاهلية بالقريات</td>\n",
       "      <td>القريات</td>\n",
       "      <td>Gouf</td>\n",
       "      <td>Domestic</td>\n",
       "      <td>تعليم عام بنات</td>\n",
       "      <td>57.44</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>147 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    General Rank Ministerial Number  \\\n",
       "0             12              96662   \n",
       "1             46              35179   \n",
       "2             50              42262   \n",
       "3             60              97424   \n",
       "4             70              35066   \n",
       "5             73              55693   \n",
       "6             79              28252   \n",
       "7             87              51279   \n",
       "8             91             195029   \n",
       "9             99             966465   \n",
       "10           104              35080   \n",
       "11           110              42356   \n",
       "12           127              59099   \n",
       "13           131              59008   \n",
       "14           215              97128   \n",
       "15           221              96627   \n",
       "16           228              96634   \n",
       "17           245              97423   \n",
       "18           250              42250   \n",
       "19           283              35078   \n",
       "20           284              35063   \n",
       "21           293             351805   \n",
       "22           320              96969   \n",
       "23           328              42347   \n",
       "24           330             590215   \n",
       "25           349             966645   \n",
       "26           431              42355   \n",
       "27           483              42271   \n",
       "28           496              96940   \n",
       "29           509              59187   \n",
       "..           ...                ...   \n",
       "117         1343              96666   \n",
       "118         1344              51270   \n",
       "119         1346              51284   \n",
       "120         1354             966255   \n",
       "121         1356              49042   \n",
       "122         1360              63698   \n",
       "123         1366              31547   \n",
       "124         1370              56235   \n",
       "125         1371              60844   \n",
       "126         1377              31235   \n",
       "127         1387              96645   \n",
       "128         1397              35216   \n",
       "129         1400              60762   \n",
       "130         1427              49157   \n",
       "131         1445              60845   \n",
       "132         1453              35143   \n",
       "133         1469              31429   \n",
       "134         1490              96980   \n",
       "135         1492              97070   \n",
       "136         1504              28357   \n",
       "137         1529              60831   \n",
       "138         1556              35145   \n",
       "139         1558              60817   \n",
       "140         1574              60738   \n",
       "141         1578              48918   \n",
       "142         1579              96653   \n",
       "143         1585              48963   \n",
       "144         1608              75068   \n",
       "145         1617              60814   \n",
       "146         1625             186879   \n",
       "\n",
       "                                           School Name             City  \\\n",
       "0         ثانوية دور الذكرالأهلية لتحفيظ القرآن الكريم           الرياض   \n",
       "1                    ثانوية دارالقلم النموذجية الأهلية              جدة   \n",
       "2         مدارس طيبة الطيبة الأهلية - المرحلة الثانوية  المدينة المنورة   \n",
       "3           ثانوية الأرقم الأهلية لتحفيظ القرآن الكريم           الرياض   \n",
       "4                        ثانوية الذكر بجدة نظام مقررات              جدة   \n",
       "5                      ثانوية مدارس دار البيان الأهلية            الخبر   \n",
       "6               ثانوية دار البشرى الأهلية بمكة المكرمة      مكة المكرمة   \n",
       "7                              ثانوية الرشاد النموذجيه             الرس   \n",
       "8                    ثانوية الفرسان الأهلية - المقررات           الرياض   \n",
       "9          ثانوية الرواد الأهلية ( الازدهار ) - مقررات           الرياض   \n",
       "10                                     ثانوية المستقبل              جدة   \n",
       "11         مدارس درر المدينة الأهلية- المرحلة الثانوية  المدينة المنورة   \n",
       "12                             ثانوية النخبة النموذجية          الأحساء   \n",
       "13                           ثانوية دور العلوم الأهلية          الأحساء   \n",
       "14                    ثانوية التعاون النموذجية الأهلية           الرياض   \n",
       "15                      ثانوية الدوحة السعودية الأهلية           الرياض   \n",
       "16                                ثانوية السمو الأهلية           الرياض   \n",
       "17                               ثانوية الأرقم الأهلية           الرياض   \n",
       "18         مدارس دار الأمان الأهلية - المرحلة الثانوية  المدينة المنورة   \n",
       "19                                       ثانوية العقيق              جدة   \n",
       "20                           ثانوية روضة جدة النموذجية              جدة   \n",
       "21                     ثانوية الاندلس بجدة نظام مقررات              جدة   \n",
       "22                              ثانوية الإحسان الأهلية           الرياض   \n",
       "23    مدارس العقيق الأهلية - المرحلة الثانوية (مقررات)  المدينة المنورة   \n",
       "24   مدارس أكاديمية الكفاح الأهلية للتعليم - الثانو...          الأحساء   \n",
       "25                     ثانوية التربية الأهلية - مقررات           الرياض   \n",
       "26      مدارس أنوار الفيحاء الأهلية - المرحلة الثانوية  المدينة المنورة   \n",
       "27       مدارس المعتز بالله الأهلية - المرحلة الثانوية  المدينة المنورة   \n",
       "28                                ثانوية الوسط الأهلية           الرياض   \n",
       "29                                ثانوية رؤية المستقبل          الأحساء   \n",
       "..                                                 ...              ...   \n",
       "117                             ثانوية الزهراء الأهلية           الرياض   \n",
       "118                                      ثانوية الغصون             الرس   \n",
       "119                               ثانوية الوعد الاهلية             الرس   \n",
       "120                 ثانوية دار السلام الأهلية - مقررات           الرياض   \n",
       "121                   ثانوية فجر القصيم الأهلية ببريدة            بريدة   \n",
       "122                         ثانوية  مدارس أبها الأهلية             أبها   \n",
       "123         ثانوية صروح العلم والتربية الأهلية بالطائف           الطائف   \n",
       "124            ثانوية مدارس درر الجزيرة الاهلية للبنات            الخبر   \n",
       "125                         ثانوية نور التوحيد الأهلية       حفر الباطن   \n",
       "126               ثانوية أنجال المملكة الأهلية بالطائف           الطائف   \n",
       "127                         ثانوية شبه الجزيرة الأهلية           الرياض   \n",
       "128                         ثانوية جيل الحضارة الاهلية              جدة   \n",
       "129                      ثانوية  تربية الأجيال الأهلية       حفر الباطن   \n",
       "130   ثانوية فجر القصيم الاهلية لتعليم الكبيرات ببريدة            بريدة   \n",
       "131                         ثانوية منار السبيل الأهلية       حفر الباطن   \n",
       "132                               ثانوية الطفل المثالي              جدة   \n",
       "133                  ثانوية واحة الفكر الأهلية بالطائف           الطائف   \n",
       "134                             ثانوية الديوان الأهلية           الرياض   \n",
       "135                        ثانوية أضواء الرياض الأهلية           الرياض   \n",
       "136                 ثانوية البتول الأهلية بمكة المكرمة      مكة المكرمة   \n",
       "137                         ثانوية رواد النجاح الأهلية       حفر الباطن   \n",
       "138                                      ثانوية الشعلة              جدة   \n",
       "139                  ثانوية الأكاديمية العصرية الأهلية       حفر الباطن   \n",
       "140                              ثانوية الواحة الأهلية       حفر الباطن   \n",
       "141                 ثانوية أنجال القصيم الأهلية ببريدة            بريدة   \n",
       "142                               ثانوية الشفا الأهلية           الرياض   \n",
       "143                       ثانوية البيان الأهلية ببريدة            بريدة   \n",
       "144                    ثانوية التربية  الإسلامية بحائل             حائل   \n",
       "145                               ثانوية المجد الأهلية       حفر الباطن   \n",
       "146                  ثانوية بيت القيم الاهلية بالقريات          القريات   \n",
       "\n",
       "         Region School Type        Category Average  \n",
       "0        Riyadh    Domestic      تحفيظ بنات   78.63  \n",
       "1        Makkah    Domestic  تعليم عام بنات   75.44  \n",
       "2        Madina    Domestic  تعليم عام بنات   75.12  \n",
       "3        Riyadh    Domestic      تحفيظ بنات   74.55  \n",
       "4        Makkah    Domestic          مقررات    73.6  \n",
       "5    AlSharquia    Domestic  تعليم عام بنات   73.32  \n",
       "6        Makkah    Domestic  تعليم عام بنات      73  \n",
       "7        Qassim    Domestic  تعليم عام بنات   72.33  \n",
       "8        Riyadh    Domestic          مقررات   72.29  \n",
       "9        Riyadh    Domestic          مقررات   72.12  \n",
       "10       Makkah    Domestic  تعليم عام بنات   72.02  \n",
       "11       Madina    Domestic  تعليم عام بنات   71.89  \n",
       "12   AlSharquia    Domestic  تعليم عام بنات   71.32  \n",
       "13   AlSharquia    Domestic  تعليم عام بنات   71.24  \n",
       "14       Riyadh    Domestic  تعليم عام بنات   69.81  \n",
       "15       Riyadh    Domestic  تعليم عام بنات    69.7  \n",
       "16       Riyadh    Domestic  تعليم عام بنات   69.63  \n",
       "17       Riyadh    Domestic  تعليم عام بنات   69.53  \n",
       "18       Madina    Domestic  تعليم عام بنات   69.45  \n",
       "19       Makkah    Domestic  تعليم عام بنات   69.07  \n",
       "20       Makkah    Domestic  تعليم عام بنات   69.05  \n",
       "21       Makkah    Domestic          مقررات   68.92  \n",
       "22       Riyadh    Domestic  تعليم عام بنات   68.78  \n",
       "23       Madina    Domestic          مقررات   68.75  \n",
       "24   AlSharquia    Domestic          مقررات   68.74  \n",
       "25       Riyadh    Domestic          مقررات    68.6  \n",
       "26       Madina    Domestic  تعليم عام بنات   67.94  \n",
       "27       Madina    Domestic  تعليم عام بنات   67.65  \n",
       "28       Riyadh    Domestic  تعليم عام بنات   67.58  \n",
       "29   AlSharquia    Domestic  تعليم عام بنات   67.48  \n",
       "..          ...         ...             ...     ...  \n",
       "117      Riyadh    Domestic  تعليم عام بنات   62.63  \n",
       "118      Qassim    Domestic  تعليم عام بنات   62.61  \n",
       "119      Qassim    Domestic  تعليم عام بنات   62.59  \n",
       "120      Riyadh    Domestic          مقررات    62.5  \n",
       "121      Qassim    Domestic  تعليم عام بنات   62.48  \n",
       "122       Asser    Domestic  تعليم عام بنات   62.44  \n",
       "123      Makkah    Domestic  تعليم عام بنات   62.41  \n",
       "124  AlSharquia    Domestic  تعليم عام بنات   62.38  \n",
       "125  AlSharquia    Domestic  تعليم عام بنات   62.38  \n",
       "126      Makkah    Domestic  تعليم عام بنات   62.34  \n",
       "127      Riyadh    Domestic  تعليم عام بنات    62.3  \n",
       "128      Makkah    Domestic  تعليم عام بنات   62.24  \n",
       "129  AlSharquia    Domestic  تعليم عام بنات   62.21  \n",
       "130      Qassim    Domestic  تعليم عام بنات      62  \n",
       "131  AlSharquia    Domestic  تعليم عام بنات   61.89  \n",
       "132      Makkah    Domestic  تعليم عام بنات   61.78  \n",
       "133      Makkah    Domestic  تعليم عام بنات   61.58  \n",
       "134      Riyadh    Domestic  تعليم عام بنات   61.34  \n",
       "135      Riyadh    Domestic  تعليم عام بنات   61.33  \n",
       "136      Makkah    Domestic  تعليم عام بنات    61.2  \n",
       "137  AlSharquia    Domestic  تعليم عام بنات   60.63  \n",
       "138      Makkah    Domestic  تعليم عام بنات   60.23  \n",
       "139  AlSharquia    Domestic  تعليم عام بنات   60.15  \n",
       "140  AlSharquia    Domestic  تعليم عام بنات   59.75  \n",
       "141      Qassim    Domestic  تعليم عام بنات   59.68  \n",
       "142      Riyadh    Domestic  تعليم عام بنات   59.64  \n",
       "143      Qassim    Domestic  تعليم عام بنات   59.53  \n",
       "144        Hail    Domestic  تعليم عام بنات   58.75  \n",
       "145  AlSharquia    Domestic  تعليم عام بنات   58.43  \n",
       "146        Gouf    Domestic  تعليم عام بنات   57.44  \n",
       "\n",
       "[147 rows x 8 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_agtp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_agtp.to_csv('data/ach_girls_the_priv.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}