Python_Code_and_Data/Web_Scraping_Business.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "import time, os\n",
    "import pandas as pd\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from datetime import datetime, timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "chromedriver = \"C:\\Program Files\\Google\\Chrome\\Application/chromedriver.exe\" # path to the chromedriver executable\n",
    "os.environ[\"webdriver.chrome.driver\"] = chromedriver"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(['https://www.almosafer.com/en/flights/FRA-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/FRA-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/FRA-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/FRA-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/FRA-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/FRA-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/FRA-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/VIE-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/ORY-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/GVA-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/AMS-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BUD-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/BRU-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LHR-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/MAD-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/CIA-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/PRG-RUH/2021-12-07/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-01/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-02/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-03/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-04/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-05/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-06/Business/1Adult/',\n",
       "  'https://www.almosafer.com/en/flights/LIS-RUH/2021-12-07/Business/1Adult/'],\n",
       " ['Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday',\n",
       "  'Wednesday',\n",
       "  'Thursday',\n",
       "  'Friday',\n",
       "  'Saturday',\n",
       "  'Sunday',\n",
       "  'Monday',\n",
       "  'Tuesday'],\n",
       " ['2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07',\n",
       "  '2021-12-01',\n",
       "  '2021-12-02',\n",
       "  '2021-12-03',\n",
       "  '2021-12-04',\n",
       "  '2021-12-05',\n",
       "  '2021-12-06',\n",
       "  '2021-12-07'])"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url_list = []\n",
    "date_list = []\n",
    "day_list = []\n",
    "list_of_loc =  [\"FRA-RUH\",\"VIE-RUH\",\"ORY-RUH\",\n",
    "               \"GVA-RUH\",\"AMS-RUH\",\"BUD-RUH\",\n",
    "               \"BRU-RUH\",\"LHR-RUH\",\"MAD-RUH\",\n",
    "               \"PRG-RUH\",\"LIS-RUH\",]\n",
    "def make_flight_url(starting_date):\n",
    "\n",
    "    base_url1 = 'https://www.almosafer.com/en/flights/'\n",
    "    base_url2 = '/Business/1Adult/'\n",
    "    for location in list_of_loc:\n",
    "        for i in range(0,7):\n",
    "            starting_date_2 = (starting_date + timedelta(days=i))\n",
    "            day_list.append(starting_date_2.strftime(\"%A\"))\n",
    "            date_for_url = str(starting_date_2.year) + \"-\" + str(starting_date_2.month).zfill(2) + \"-\" + str(starting_date_2.day).zfill(2)\n",
    "            date_list.append(date_for_url)\n",
    "            search_url = (base_url1 + location + \"/\" + date_for_url + base_url2)\n",
    "            url_list.append(search_url)\n",
    "    return url_list, day_list , date_list\n",
    "\n",
    "starting_date = '12/01/21'\n",
    "starting_date = datetime.strptime(starting_date, '%m/%d/%y')\n",
    "make_flight_url(starting_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-5-1dc895020458>:7: DeprecationWarning: executable_path has been deprecated, please pass in a Service object\n",
      "  driver = webdriver.Chrome(chromedriver)\n"
     ]
    }
   ],
   "source": [
    "columns = [\"Flight_Number\",\"Ariline\",\"Class\",\"Date\",\"Day\",\"Time_of_Landing\",\"Time_of_arrival\",\"Number_of_Stops\",\"Duration\",\"Baggage\",\"Location\",\"Destination\",\"Price\"]\n",
    "flight_df = pd.DataFrame(columns=columns)\n",
    "\n",
    "i = 0\n",
    "\n",
    "for url in url_list[:]:\n",
    "    driver = webdriver.Chrome(chromedriver)\n",
    "    driver.get(url)\n",
    "    time.sleep(2)\n",
    "    \n",
    "    price_list =[]\n",
    "    airline_list = []\n",
    "    flight_num_list = []\n",
    "    time_landing_list = []\n",
    "    time_arrival_list = []\n",
    "    Duration_list = []\n",
    "    Baggage_list =[]\n",
    "    stops_list =[]\n",
    "    \n",
    "\n",
    "    for j in range(8):\n",
    "        driver.execute_script(\"window.scrollTo(0, document.documentElement.scrollHeight);\")\n",
    "        time.sleep(1)\n",
    "\n",
    "    soup = BeautifulSoup(driver.page_source)\n",
    "    soup\n",
    "\n",
    "    for rest in soup.find_all('div', class_='sc-cSYcjD hXnhxm')[:]: \n",
    "        price_list.append(rest.text)\n",
    "\n",
    "    for rest in soup.find_all('div', class_='sc-dEfkYy dunONY')[:]: \n",
    "        airline_list.append(rest.find('div').text)\n",
    "\n",
    "    for rest in soup.find_all('div', class_='sc-dEfkYy dunONY')[:]: \n",
    "        flight_num_list.append(rest.find_all('div')[-1].text)\n",
    "\n",
    "    for rest in soup.find_all('div', class_='sc-bIqbHp aPzHZ sc-kpOJdX kAzjOl col-2')[:]: \n",
    "        time_landing_list.append(rest.find(\"div\").text)\n",
    "\n",
    "    for rest in soup.find_all('div', class_='sc-bIqbHp gwjyCQ sc-kpOJdX kAzjOl col-2')[:]: \n",
    "        time_arrival_list.append(rest.find(\"div\").text)\n",
    "\n",
    "    for rest in soup.find_all('div',class_=\"sc-jxGEyO dfxDXk sc-kpOJdX kAzjOl col-5\")[:]:\n",
    "        stops_list.append(rest.find(\"span\").text)\n",
    "        \n",
    "    for rest in soup.find_all('span', class_='sc-FQuPU kdpQLw')[:]: \n",
    "        Duration_list.append(rest.text)\n",
    "\n",
    "    for rest in soup.find_all('span', class_='sc-iuDHTM cnrMzL')[:]: \n",
    "        Baggage_list.append(rest.text)\n",
    "\n",
    "    for M in range(len(flight_num_list)):\n",
    "        flight_df.loc[len(flight_df)] = {\"Flight_Number\":flight_num_list[M],\n",
    "                             \"Ariline\":airline_list[M],\n",
    "                             \"Class\":\"Business\",\n",
    "                             \"Date\":date_list[i],\n",
    "                             \"Day\":day_list[i],\n",
    "                             \"Time_of_Landing\":time_landing_list[M],\n",
    "                             \"Time_of_arrival\":time_arrival_list[M],\n",
    "                             \"Number_of_Stops\":stops_list[M],   \n",
    "                             \"Duration\":Duration_list[M],\n",
    "                             \"Baggage\":Baggage_list[M],\n",
    "                             \"Location\":soup.find('div', class_='sc-yZwTr bmGDAz').text,\n",
    "                             \"Destination\":\"RUH\",\n",
    "                             \"Price\":price_list[M]}\n",
    "    \n",
    "    i += 1\n",
    "    \n",
    "    driver.close()\n",
    "flight_df.to_csv(\"Business_FLIGHTS\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Flight_Number</th>\n",
       "      <th>Ariline</th>\n",
       "      <th>Class</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day</th>\n",
       "      <th>Time_of_Landing</th>\n",
       "      <th>Time_of_arrival</th>\n",
       "      <th>Number_of_Stops</th>\n",
       "      <th>Duration</th>\n",
       "      <th>Baggage</th>\n",
       "      <th>Location</th>\n",
       "      <th>Destination</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RJ-126</td>\n",
       "      <td>Royal Jordanian</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-01</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>02:45pm</td>\n",
       "      <td>02:10am</td>\n",
       "      <td>1 Stop</td>\n",
       "      <td>09h 25m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>FRA</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR4,970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MS-9000</td>\n",
       "      <td>Egyptair</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-01</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>01:30pm</td>\n",
       "      <td>03:40am</td>\n",
       "      <td>1 Stop</td>\n",
       "      <td>12h 10m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>FRA</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR3,927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BA-903</td>\n",
       "      <td>British Airways</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-01</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>11:25am</td>\n",
       "      <td>11:40pm</td>\n",
       "      <td>1 Stop</td>\n",
       "      <td>10h 15m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>FRA</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR6,258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BA-8762</td>\n",
       "      <td>British Airways</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-01</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>10:15am</td>\n",
       "      <td>11:40pm</td>\n",
       "      <td>1 Stop</td>\n",
       "      <td>11h 25m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>FRA</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR6,307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TK-1594</td>\n",
       "      <td>Turkish Airlines</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-01</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>06:10pm</td>\n",
       "      <td>05:45am</td>\n",
       "      <td>1 Stop</td>\n",
       "      <td>09h 35m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>FRA</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR7,363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1518</th>\n",
       "      <td>TP-1352</td>\n",
       "      <td>Turkish Airlines</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>09:45am</td>\n",
       "      <td>05:45am</td>\n",
       "      <td>2 Stops</td>\n",
       "      <td>17h 00m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>LIS</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR11,207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1519</th>\n",
       "      <td>EY-1554</td>\n",
       "      <td>Etihad Airways</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>09:45am</td>\n",
       "      <td>11:05am</td>\n",
       "      <td>2 Stops</td>\n",
       "      <td>22h 20m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>LIS</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR10,868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1520</th>\n",
       "      <td>AF-1125</td>\n",
       "      <td>Air France</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>05:30am</td>\n",
       "      <td>07:15pm</td>\n",
       "      <td>1 Stop</td>\n",
       "      <td>10h 45m</td>\n",
       "      <td>Baggage included  (40KG)</td>\n",
       "      <td>LIS</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR12,587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1521</th>\n",
       "      <td>ET-1730</td>\n",
       "      <td>Ethiopian Airlines</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>01:20pm</td>\n",
       "      <td>01:55am</td>\n",
       "      <td>2 Stops</td>\n",
       "      <td>33h 35m</td>\n",
       "      <td>Baggage included  (60KG)</td>\n",
       "      <td>LIS</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR11,789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1522</th>\n",
       "      <td>ET-1892</td>\n",
       "      <td>Ethiopian Airlines</td>\n",
       "      <td>Business</td>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>01:05pm</td>\n",
       "      <td>01:55am</td>\n",
       "      <td>2 Stops</td>\n",
       "      <td>33h 50m</td>\n",
       "      <td>Baggage included  (60KG)</td>\n",
       "      <td>LIS</td>\n",
       "      <td>RUH</td>\n",
       "      <td>SAR11,777</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1523 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Flight_Number             Ariline     Class        Date        Day  \\\n",
       "0           RJ-126     Royal Jordanian  Business  2021-12-01  Wednesday   \n",
       "1          MS-9000            Egyptair  Business  2021-12-01  Wednesday   \n",
       "2           BA-903     British Airways  Business  2021-12-01  Wednesday   \n",
       "3          BA-8762     British Airways  Business  2021-12-01  Wednesday   \n",
       "4          TK-1594    Turkish Airlines  Business  2021-12-01  Wednesday   \n",
       "...            ...                 ...       ...         ...        ...   \n",
       "1518       TP-1352    Turkish Airlines  Business  2021-12-07    Tuesday   \n",
       "1519       EY-1554      Etihad Airways  Business  2021-12-07    Tuesday   \n",
       "1520       AF-1125          Air France  Business  2021-12-07    Tuesday   \n",
       "1521       ET-1730  Ethiopian Airlines  Business  2021-12-07    Tuesday   \n",
       "1522       ET-1892  Ethiopian Airlines  Business  2021-12-07    Tuesday   \n",
       "\n",
       "     Time_of_Landing Time_of_arrival Number_of_Stops Duration  \\\n",
       "0            02:45pm         02:10am          1 Stop  09h 25m   \n",
       "1            01:30pm         03:40am          1 Stop  12h 10m   \n",
       "2            11:25am         11:40pm          1 Stop  10h 15m   \n",
       "3            10:15am         11:40pm          1 Stop  11h 25m   \n",
       "4            06:10pm         05:45am          1 Stop  09h 35m   \n",
       "...              ...             ...             ...      ...   \n",
       "1518         09:45am         05:45am         2 Stops  17h 00m   \n",
       "1519         09:45am         11:05am         2 Stops  22h 20m   \n",
       "1520         05:30am         07:15pm          1 Stop  10h 45m   \n",
       "1521         01:20pm         01:55am         2 Stops  33h 35m   \n",
       "1522         01:05pm         01:55am         2 Stops  33h 50m   \n",
       "\n",
       "                       Baggage Location Destination      Price  \n",
       "0     Baggage included  (40KG)      FRA         RUH   SAR4,970  \n",
       "1     Baggage included  (40KG)      FRA         RUH   SAR3,927  \n",
       "2     Baggage included  (40KG)      FRA         RUH   SAR6,258  \n",
       "3     Baggage included  (40KG)      FRA         RUH   SAR6,307  \n",
       "4     Baggage included  (40KG)      FRA         RUH   SAR7,363  \n",
       "...                        ...      ...         ...        ...  \n",
       "1518  Baggage included  (40KG)      LIS         RUH  SAR11,207  \n",
       "1519  Baggage included  (40KG)      LIS         RUH  SAR10,868  \n",
       "1520  Baggage included  (40KG)      LIS         RUH  SAR12,587  \n",
       "1521  Baggage included  (60KG)      LIS         RUH  SAR11,789  \n",
       "1522  Baggage included  (60KG)      LIS         RUH  SAR11,777  \n",
       "\n",
       "[1523 rows x 13 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flight_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "flight_df.to_csv(\"Business_FLIGHTS\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# del flight_df"
   ]
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}