SCRAPING_PRICES_USING_SKYSCANNER.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "SCRAPING PRICES USING SKYSCANNER",
      "provenance": [],
      "collapsed_sections": [
        "YPFsU8qZKFUD",
        "i5YhFbpnKHXl",
        "YZlwgwrANYCO",
        "XHJ7jharK5cU"
      ],
      "toc_visible": true,
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/fersebas/data_kdd_recopilation/blob/master/SCRAPING_PRICES_USING_SKYSCANNER.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "b9ZGihFv6ZGn",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns\n",
        "%matplotlib inline"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jdfO1amFpIgP",
        "colab_type": "text"
      },
      "source": [
        "# 1. Funciones api skyscanner"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "50XDODJ50fY6",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def create_session(depart_date, arrival_date):   \n",
        "  import requests\n",
        "  url = \"https://skyscanner-skyscanner-flight-search-v1.p.rapidapi.com/apiservices/pricing/v1.0\"\n",
        "\n",
        "  payload = \"inboundDate=\"+arrival_date+\"&cabinClass=economy&children=0&infants=0&country=ES&currency=EUR&locale=es-ES&originPlace=MAD-sky&destinationPlace=LPA-sky&outboundDate=\"+depart_date+\"&adults=1\"\n",
        "  headers = {\n",
        "      'x-rapidapi-host': \"skyscanner-skyscanner-flight-search-v1.p.rapidapi.com\",\n",
        "      'x-rapidapi-key': \"c87701c514msh05e1981eb4b7ba3p106611jsn5b01d80662c5\",\n",
        "      'content-type': \"application/x-www-form-urlencoded\"\n",
        "      }\n",
        "\n",
        "\n",
        "  while True:\n",
        "    response = requests.request(\"POST\", url, data=payload, headers=headers)\n",
        "    if response.status_code == 201:\n",
        "      print(\"Sesion creada\")\n",
        "      print(response.text)\n",
        "      break\n",
        "  return response\n"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "V-5cP36s1qpA",
        "colab_type": "code",
        "outputId": "19de4ac9-1ab5-41d9-99f3-0b9efeb09838",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 50
        }
      },
      "source": [
        "r = create_session(\"2019-10-11\", \"2019-10-13\")"
      ],
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Sesion creada\n",
            "{}\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2qtETSEWfk1H",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def get_json(response):\n",
        "  # SessionKey \tThe Session key to identify the session.\n",
        "  # 1. Query - A copy of the query which was submitted.\n",
        "  # 2. Status -\tThe status of the session – ‘UpdatesPending’ or ‘UpdatesComplete’.\n",
        "  # 3. Itineraries - A list of itineraries - see below for the itinerary object.\n",
        "  # 4. Legs -\tDetails of the legs that make up the itineraries: airports, times, overall duration, stops and carrier ids.\n",
        "  # 5. Segments - Details of the segments of each leg. Including the carrier (or marketing carrier) and the operating carrier.\n",
        "  # 6. Carriers -\tDetails of the carriers.\n",
        "  # 7. Agents -\tDetails of the agents who sell the tickets. Can be an airline or a travel agent.\n",
        "  # 8. Places -\tA list of all the places that appear in the itineraries.\n",
        "  # 9. Currencies - A list of the currencies shown in the response.\n",
        "\n",
        "  url = response.headers[\"Location\"]\n",
        "  session_id = url.split(\"/\")[-1]\n",
        "  import requests\n",
        "  import json\n",
        "  url = \"https://skyscanner-skyscanner-flight-search-v1.p.rapidapi.com/apiservices/pricing/uk2/v1.0/\"+session_id\n",
        "\n",
        "  querystring = {\"sortType\":\"price\",\"sortOrder\":\"asc\",\"stops\":\"0\",\"pageIndex\":\"0\",\"pageSize\":\"10\"}\n",
        "\n",
        "  headers = {\n",
        "      'x-rapidapi-host': \"skyscanner-skyscanner-flight-search-v1.p.rapidapi.com\",\n",
        "      'x-rapidapi-key': \"c87701c514msh05e1981eb4b7ba3p106611jsn5b01d80662c5\"\n",
        "      }\n",
        "\n",
        "  response = requests.request(\"GET\", url, headers=headers, params=querystring)\n",
        "  return response.json()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3D1oTp-_IZz8",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 162
        },
        "outputId": "e1ce5af0-b88d-4117-85ff-0c8a707645c6"
      },
      "source": [
        "json_data = get_json(r)"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "error",
          "ename": "NameError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-8-3db4f27278e6>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mjson_data\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mget_json\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mr\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;31mNameError\u001b[0m: name 'r' is not defined"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mO8crXHogVdZ",
        "colab_type": "code",
        "outputId": "36dac7ec-859d-44f0-d9d6-64b23aa67973",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 162
        }
      },
      "source": [
        "json_data[\"Status\"]"
      ],
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "error",
          "ename": "NameError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-9-95b87bd559b6>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mjson_data\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Status\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;31mNameError\u001b[0m: name 'json_data' is not defined"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YPFsU8qZKFUD",
        "colab_type": "text"
      },
      "source": [
        "#**1. Query**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "v68Y8kzOhqbu",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "Query = pd.DataFrame.from_records([json_data['Query']])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "t-5bxtFnltit",
        "colab_type": "code",
        "outputId": "bd549ffe-a3b7-486e-d331-f49908ec9851",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 77
        }
      },
      "source": [
        "Query"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Adults</th>\n",
              "      <th>CabinClass</th>\n",
              "      <th>Children</th>\n",
              "      <th>Country</th>\n",
              "      <th>Currency</th>\n",
              "      <th>DestinationPlace</th>\n",
              "      <th>GroupPricing</th>\n",
              "      <th>InboundDate</th>\n",
              "      <th>Infants</th>\n",
              "      <th>Locale</th>\n",
              "      <th>LocationSchema</th>\n",
              "      <th>OriginPlace</th>\n",
              "      <th>OutboundDate</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>economy</td>\n",
              "      <td>0</td>\n",
              "      <td>ES</td>\n",
              "      <td>EUR</td>\n",
              "      <td>13689</td>\n",
              "      <td>False</td>\n",
              "      <td>2019-10-14</td>\n",
              "      <td>0</td>\n",
              "      <td>es-ES</td>\n",
              "      <td>Default</td>\n",
              "      <td>13870</td>\n",
              "      <td>2019-10-11</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Adults CabinClass  Children  ... LocationSchema OriginPlace OutboundDate\n",
              "0       1    economy         0  ...        Default       13870   2019-10-11\n",
              "\n",
              "[1 rows x 13 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "i5YhFbpnKHXl",
        "colab_type": "text"
      },
      "source": [
        "# **2. Status**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "csQ7UkEQlZRs",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "Status = json_data['Status']"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MH38-GyHltMl",
        "colab_type": "code",
        "outputId": "12dfa470-1182-4ce1-9d61-7a0e481fc546",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        }
      },
      "source": [
        "Status"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'UpdatesPending'"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "nreNAZLdKK1y",
        "colab_type": "text"
      },
      "source": [
        "# **3. Itineraries**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9hYDLFy0YBiL",
        "colab_type": "code",
        "outputId": "0609be93-9fd2-459b-a487-4adfe96cdc60",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 140
        }
      },
      "source": [
        "Itineraries = pd.DataFrame()\n",
        "num_iteraries = len(json_data['Itineraries'])\n",
        "for i in range(num_iteraries):\n",
        "  new = pd.DataFrame(json_data['Itineraries'][i]['PricingOptions'])\n",
        "  new[\"InboundLegId\"] = json_data['Itineraries'][i]['InboundLegId']\n",
        "  new[\"OutboundLegId\"] = json_data['Itineraries'][i]['OutboundLegId']\n",
        "  Itineraries = Itineraries.append(new)\n",
        "Itineraries.reset_index(inplace=True)\n",
        "Itineraries.head(2)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Agents</th>\n",
              "      <th>DeeplinkUrl</th>\n",
              "      <th>Price</th>\n",
              "      <th>QuoteAgeInMinutes</th>\n",
              "      <th>InboundLegId</th>\n",
              "      <th>OutboundLegId</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>[4035342]</td>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>147.85</td>\n",
              "      <td>188</td>\n",
              "      <td>13689-1910131800--32680-0-13870-1910132150</td>\n",
              "      <td>13870-1910110705--32680-0-13689-1910110900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>[3986805]</td>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>148.03</td>\n",
              "      <td>100</td>\n",
              "      <td>13689-1910131800--32680-0-13870-1910132150</td>\n",
              "      <td>13870-1910110705--32680-0-13689-1910110900</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index  ...                               OutboundLegId\n",
              "0      0  ...  13870-1910110705--32680-0-13689-1910110900\n",
              "1      1  ...  13870-1910110705--32680-0-13689-1910110900\n",
              "\n",
              "[2 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 92
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YZlwgwrANYCO",
        "colab_type": "text"
      },
      "source": [
        "# **4. Legs**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fl-65E9fOHFc",
        "colab_type": "code",
        "outputId": "47ae6473-a2d8-4da1-93b8-d5e3fe78642e",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 164
        }
      },
      "source": [
        "Legs = pd.DataFrame()\n",
        "num_legs = len(json_data['Legs'])\n",
        "for i in range(num_legs):\n",
        "  Legs = Legs.append(pd.DataFrame([json_data['Legs'][i]]))\n",
        "Legs.reset_index(inplace=True)\n",
        "Legs.head(1)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Arrival</th>\n",
              "      <th>Carriers</th>\n",
              "      <th>Departure</th>\n",
              "      <th>DestinationStation</th>\n",
              "      <th>Directionality</th>\n",
              "      <th>Duration</th>\n",
              "      <th>FlightNumbers</th>\n",
              "      <th>Id</th>\n",
              "      <th>JourneyMode</th>\n",
              "      <th>OperatingCarriers</th>\n",
              "      <th>OriginStation</th>\n",
              "      <th>SegmentIds</th>\n",
              "      <th>Stops</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>2019-10-11T10:35:00</td>\n",
              "      <td>[1202]</td>\n",
              "      <td>2019-10-11T08:40:00</td>\n",
              "      <td>13689</td>\n",
              "      <td>Outbound</td>\n",
              "      <td>175</td>\n",
              "      <td>[{'FlightNumber': '3826', 'CarrierId': 1202}]</td>\n",
              "      <td>13870-1910110840--32221-0-13689-1910111035</td>\n",
              "      <td>Flight</td>\n",
              "      <td>[1202]</td>\n",
              "      <td>13870</td>\n",
              "      <td>[26]</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index              Arrival Carriers  ... OriginStation  SegmentIds Stops\n",
              "0      0  2019-10-11T10:35:00   [1202]  ...         13870        [26]    []\n",
              "\n",
              "[1 rows x 14 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 94
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "bou8171wK0q3",
        "colab_type": "text"
      },
      "source": [
        "# **5. Carriers**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Yvz0AYq7Logy",
        "colab_type": "code",
        "outputId": "3aa2b73d-383a-46bd-8e47-6e80982ac937",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 106
        }
      },
      "source": [
        "Carries = pd.DataFrame()\n",
        "num_carries = len(json_data['Carriers'])\n",
        "for i in range(num_carries):\n",
        "  Carries = Carries.append(pd.DataFrame([json_data['Carriers'][i]]))\n",
        "Carries.reset_index(inplace=True)\n",
        "Carries.head(2)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Code</th>\n",
              "      <th>DisplayCode</th>\n",
              "      <th>Id</th>\n",
              "      <th>ImageUrl</th>\n",
              "      <th>Name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>I2</td>\n",
              "      <td>I2</td>\n",
              "      <td>1202</td>\n",
              "      <td>https://s1.apideeplink.com/images/airlines/I2.png</td>\n",
              "      <td>Iberia Express</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0</td>\n",
              "      <td>IB</td>\n",
              "      <td>IB</td>\n",
              "      <td>1218</td>\n",
              "      <td>https://s1.apideeplink.com/images/airlines/IB.png</td>\n",
              "      <td>Iberia</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index  ...            Name\n",
              "0      0  ...  Iberia Express\n",
              "1      0  ...          Iberia\n",
              "\n",
              "[2 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 95
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "XHJ7jharK5cU",
        "colab_type": "text"
      },
      "source": [
        "#**6. Segments**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "818geSyr6gZn",
        "colab_type": "code",
        "outputId": "55588dfa-7d4f-4086-ad40-dfcec38f5c7b",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 386
        }
      },
      "source": [
        "json_data['Segments'][0:2]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[{'ArrivalDateTime': '2019-10-11T10:30:00',\n",
              "  'Carrier': 1218,\n",
              "  'DepartureDateTime': '2019-10-11T08:40:00',\n",
              "  'DestinationStation': 16864,\n",
              "  'Directionality': 'Outbound',\n",
              "  'Duration': 170,\n",
              "  'FlightNumber': '3942',\n",
              "  'Id': 0,\n",
              "  'JourneyMode': 'Flight',\n",
              "  'OperatingCarrier': 1202,\n",
              "  'OriginStation': 13870},\n",
              " {'ArrivalDateTime': '2019-10-11T12:00:00',\n",
              "  'Carrier': 1218,\n",
              "  'DepartureDateTime': '2019-10-11T11:30:00',\n",
              "  'DestinationStation': 13689,\n",
              "  'Directionality': 'Outbound',\n",
              "  'Duration': 30,\n",
              "  'FlightNumber': '81',\n",
              "  'Id': 1,\n",
              "  'JourneyMode': 'Flight',\n",
              "  'OperatingCarrier': 1612,\n",
              "  'OriginStation': 16864}]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "3ec6qpknW6Zh",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "f6zJlymNMjul",
        "colab_type": "text"
      },
      "source": [
        "#7. Agents"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JIKvLWEMMwGN",
        "colab_type": "code",
        "outputId": "bc07ad24-8275-45bf-ce94-4a6d629bef5d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 106
        }
      },
      "source": [
        "Agents = pd.DataFrame()\n",
        "num_agents = len(json_data['Agents'])\n",
        "for i in range(num_agents):\n",
        "  Agents = Agents.append(pd.DataFrame([json_data['Agents'][i]]))\n",
        "Agents.reset_index(inplace=True)\n",
        "Agents.head(2)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Id</th>\n",
              "      <th>ImageUrl</th>\n",
              "      <th>Name</th>\n",
              "      <th>OptimisedForMobile</th>\n",
              "      <th>Status</th>\n",
              "      <th>Type</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>3390855</td>\n",
              "      <td>https://s1.apideeplink.com/images/websites/nor...</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>True</td>\n",
              "      <td>UpdatesComplete</td>\n",
              "      <td>Airline</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0</td>\n",
              "      <td>4288780</td>\n",
              "      <td>https://s1.apideeplink.com/images/websites/vue...</td>\n",
              "      <td>Vueling Airlines</td>\n",
              "      <td>True</td>\n",
              "      <td>UpdatesComplete</td>\n",
              "      <td>Airline</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index       Id  ...           Status     Type\n",
              "0      0  3390855  ...  UpdatesComplete  Airline\n",
              "1      0  4288780  ...  UpdatesComplete  Airline\n",
              "\n",
              "[2 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kYXExa3_Uue1",
        "colab_type": "text"
      },
      "source": [
        "# **Join all**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CxoysPP6Uv0f",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# partimos de los precios de las opciones que hay\n",
        "# Cruzamos con las legs para saber que vuelos son (fecha,hora,aerolinea,duracion)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rlguNgn0WEpt",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "legs_aux = Legs[[\"Id\",\"Departure\",\"Arrival\",\"Stops\",\"Carriers\",\"Duration\"]]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "A6uQmBoXUzI4",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla = pd.merge(Itineraries, legs_aux.add_prefix(\"Ida_\"), how=\"left\", left_on=\"OutboundLegId\", right_on=\"Ida_Id\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d0rFAol5Ww10",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla2 = pd.merge(tabla, legs_aux.add_prefix(\"Vuelta_\"), how=\"left\", left_on=\"InboundLegId\", right_on=\"Vuelta_Id\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bzH9y4HdNCM1",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla2.loc[:, 'Agents'] = tabla2.Agents.map(lambda x: x[0])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-iUmdG2EM7ui",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla3 = pd.merge(tabla2, Agents[[\"Name\",\"Id\"]].rename(columns={\"Name\":\"Billete_Vendido\"}), how=\"left\", left_on=\"Agents\", right_on=\"Id\").drop(columns=\"Id\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "r5SfONSGRE77",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla3.loc[:, 'Ida_Carriers'] = tabla3.Ida_Carriers.map(lambda x: x[0])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I7A-g9eSQJpJ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla4 = pd.merge(tabla3, Carries[[\"Name\",\"Id\"]].rename(columns={\"Name\":\"Ida_Aerolinea\"}), how=\"left\",\n",
        "                  left_on=\"Ida_Carriers\", right_on=\"Id\").drop(columns=\"Id\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "svFUCsjsmiKr",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla4.loc[:, 'Vuelta_Carriers'] = tabla4.Vuelta_Carriers.map(lambda x: x[0])"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cn0VE3Frmaa_",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "tabla5 = pd.merge(tabla4, Carries[[\"Name\",\"Id\"]].rename(columns={\"Name\":\"Vuelta_Aerolinea\"}), how=\"left\",\n",
        "                  left_on=\"Vuelta_Carriers\", right_on=\"Id\").drop(columns=\"Id\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YHlnDqwwW0-I",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "final = tabla5.copy()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fPXGihmXwCqn",
        "colab_type": "code",
        "outputId": "e8876629-b3ee-4733-a013-acd1fb454663",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 261
        }
      },
      "source": [
        "final.head(2)"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Agents</th>\n",
              "      <th>DeeplinkUrl</th>\n",
              "      <th>Price</th>\n",
              "      <th>QuoteAgeInMinutes</th>\n",
              "      <th>InboundLegId</th>\n",
              "      <th>OutboundLegId</th>\n",
              "      <th>Ida_Id</th>\n",
              "      <th>Ida_Departure</th>\n",
              "      <th>Ida_Arrival</th>\n",
              "      <th>Ida_Stops</th>\n",
              "      <th>Ida_Carriers</th>\n",
              "      <th>Ida_Duration</th>\n",
              "      <th>Vuelta_Id</th>\n",
              "      <th>Vuelta_Departure</th>\n",
              "      <th>Vuelta_Arrival</th>\n",
              "      <th>Vuelta_Stops</th>\n",
              "      <th>Vuelta_Carriers</th>\n",
              "      <th>Vuelta_Duration</th>\n",
              "      <th>Billete_Vendido</th>\n",
              "      <th>Ida_Aerolinea</th>\n",
              "      <th>Vuelta_Aerolinea</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>4035342</td>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>147.85</td>\n",
              "      <td>188</td>\n",
              "      <td>13689-1910131800--32680-0-13870-1910132150</td>\n",
              "      <td>13870-1910110705--32680-0-13689-1910110900</td>\n",
              "      <td>13870-1910110705--32680-0-13689-1910110900</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>[]</td>\n",
              "      <td>1816</td>\n",
              "      <td>175</td>\n",
              "      <td>13689-1910131800--32680-0-13870-1910132150</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>[]</td>\n",
              "      <td>1816</td>\n",
              "      <td>170</td>\n",
              "      <td>Travelgenio</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>3986805</td>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>148.03</td>\n",
              "      <td>100</td>\n",
              "      <td>13689-1910131800--32680-0-13870-1910132150</td>\n",
              "      <td>13870-1910110705--32680-0-13689-1910110900</td>\n",
              "      <td>13870-1910110705--32680-0-13689-1910110900</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>[]</td>\n",
              "      <td>1816</td>\n",
              "      <td>175</td>\n",
              "      <td>13689-1910131800--32680-0-13870-1910132150</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>[]</td>\n",
              "      <td>1816</td>\n",
              "      <td>170</td>\n",
              "      <td>Travel2Be</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   index   Agents  ... Ida_Aerolinea  Vuelta_Aerolinea\n",
              "0      0  4035342  ...    Air Europa        Air Europa\n",
              "1      1  3986805  ...    Air Europa        Air Europa\n",
              "\n",
              "[2 rows x 22 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 108
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "9ORLbEF-Xuaw",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "final[\"Origen\"] = \"MAD\"\n",
        "final[\"Destino\"] = \"LPA\""
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "aL4MjD59YvVb",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "final = final[[\"DeeplinkUrl\",\"Origen\",\"Destino\",\"Ida_Departure\",\"Ida_Arrival\",\"Vuelta_Departure\",\"Vuelta_Arrival\",\"Price\",\"Billete_Vendido\",\"Ida_Aerolinea\",\n",
        "       \"Vuelta_Aerolinea\",\"Ida_Duration\",\"Vuelta_Duration\"]]"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6SksF_gNB4Ri",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import datetime\n",
        "final[\"FechaHora_Consulta\"] = datetime.datetime.now()"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HUaXUlRDY3W6",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "final.to_csv(\"tabla_busqueda.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VJbWKNV_OPl3",
        "colab_type": "code",
        "outputId": "4097e4a4-faae-43c9-8432-ce1d8637c3f8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "source": [
        "final"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>DeeplinkUrl</th>\n",
              "      <th>Origen</th>\n",
              "      <th>Destino</th>\n",
              "      <th>Ida_Departure</th>\n",
              "      <th>Ida_Arrival</th>\n",
              "      <th>Vuelta_Departure</th>\n",
              "      <th>Vuelta_Arrival</th>\n",
              "      <th>Price</th>\n",
              "      <th>Billete_Vendido</th>\n",
              "      <th>Ida_Aerolinea</th>\n",
              "      <th>Vuelta_Aerolinea</th>\n",
              "      <th>Ida_Duration</th>\n",
              "      <th>Vuelta_Duration</th>\n",
              "      <th>FechaHora_Consulta</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>147.85</td>\n",
              "      <td>Travelgenio</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>148.03</td>\n",
              "      <td>Travel2Be</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>151.98</td>\n",
              "      <td>Tripair</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>153.00</td>\n",
              "      <td>Budgetair.es</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>153.99</td>\n",
              "      <td>GotoGate</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>154.99</td>\n",
              "      <td>lastminute.com</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>154.99</td>\n",
              "      <td>Tix.es</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>159.78</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>162.60</td>\n",
              "      <td>eDreams</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>166.64</td>\n",
              "      <td>Opodo</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>167.77</td>\n",
              "      <td>Viajes El Corte Ingles</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>175.00</td>\n",
              "      <td>Trip.com</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>175.68</td>\n",
              "      <td>Expedia</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>177.00</td>\n",
              "      <td>Kiwi.com</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>182.99</td>\n",
              "      <td>Mytrip</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>248.99</td>\n",
              "      <td>Rumbo</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>147.85</td>\n",
              "      <td>Travelgenio</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>151.98</td>\n",
              "      <td>Tripair</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>153.00</td>\n",
              "      <td>Budgetair.es</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>153.99</td>\n",
              "      <td>GotoGate</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>154.99</td>\n",
              "      <td>lastminute.com</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>159.23</td>\n",
              "      <td>Travel2Be</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>159.78</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>162.60</td>\n",
              "      <td>eDreams</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>163.00</td>\n",
              "      <td>Trip.com</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>165.99</td>\n",
              "      <td>Tix.es</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>166.64</td>\n",
              "      <td>Opodo</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>167.77</td>\n",
              "      <td>Viajes El Corte Ingles</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>175.68</td>\n",
              "      <td>Expedia</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T07:05:00</td>\n",
              "      <td>2019-10-11T09:00:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>182.99</td>\n",
              "      <td>Mytrip</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</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",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T08:40:00</td>\n",
              "      <td>2019-10-11T10:35:00</td>\n",
              "      <td>2019-10-13T06:40:00</td>\n",
              "      <td>2019-10-13T10:20:00</td>\n",
              "      <td>150.73</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>175</td>\n",
              "      <td>160</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T06:40:00</td>\n",
              "      <td>2019-10-13T10:20:00</td>\n",
              "      <td>150.73</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>175</td>\n",
              "      <td>160</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>153.78</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>155.69</td>\n",
              "      <td>Travelgenio</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>157.74</td>\n",
              "      <td>Travel2Be</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>157.99</td>\n",
              "      <td>lastminute.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>158.99</td>\n",
              "      <td>Mytrip</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>159.00</td>\n",
              "      <td>Budgetair.es</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>164.67</td>\n",
              "      <td>eDreams</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>165.99</td>\n",
              "      <td>GotoGate</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>168.44</td>\n",
              "      <td>Opodo</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>169.00</td>\n",
              "      <td>Trip.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>173.68</td>\n",
              "      <td>Expedia</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>176.00</td>\n",
              "      <td>Kiwi.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T08:00:00</td>\n",
              "      <td>2019-10-13T11:45:00</td>\n",
              "      <td>192.99</td>\n",
              "      <td>Rumbo</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>155.69</td>\n",
              "      <td>Travelgenio</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>155.87</td>\n",
              "      <td>Travel2Be</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>163.99</td>\n",
              "      <td>GotoGate</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>175.99</td>\n",
              "      <td>lastminute.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>177.99</td>\n",
              "      <td>Mytrip</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>185.00</td>\n",
              "      <td>Kiwi.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T18:00:00</td>\n",
              "      <td>2019-10-13T21:50:00</td>\n",
              "      <td>193.99</td>\n",
              "      <td>Rumbo</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>170</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>155.69</td>\n",
              "      <td>Travelgenio</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>163.99</td>\n",
              "      <td>GotoGate</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>56</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>175.99</td>\n",
              "      <td>lastminute.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>177.99</td>\n",
              "      <td>Mytrip</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>185.00</td>\n",
              "      <td>Kiwi.com</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T12:30:00</td>\n",
              "      <td>2019-10-11T14:25:00</td>\n",
              "      <td>2019-10-13T10:00:00</td>\n",
              "      <td>2019-10-13T13:45:00</td>\n",
              "      <td>232.99</td>\n",
              "      <td>Rumbo</td>\n",
              "      <td>Norwegian</td>\n",
              "      <td>Air Europa</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T21:30:00</td>\n",
              "      <td>2019-10-11T23:20:00</td>\n",
              "      <td>2019-10-13T06:40:00</td>\n",
              "      <td>2019-10-13T10:20:00</td>\n",
              "      <td>156.06</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>170</td>\n",
              "      <td>160</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>http://partners.api.skyscanner.net/apiservices...</td>\n",
              "      <td>MAD</td>\n",
              "      <td>LPA</td>\n",
              "      <td>2019-10-11T08:40:00</td>\n",
              "      <td>2019-10-11T10:35:00</td>\n",
              "      <td>2019-10-13T11:55:00</td>\n",
              "      <td>2019-10-13T15:40:00</td>\n",
              "      <td>160.23</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>Iberia Express</td>\n",
              "      <td>175</td>\n",
              "      <td>165</td>\n",
              "      <td>2019-09-16 22:36:41.622799</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>62 rows × 14 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                          DeeplinkUrl  ...         FechaHora_Consulta\n",
              "0   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "1   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "2   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "3   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "4   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "5   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "6   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "7   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "8   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "9   http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "10  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "11  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "12  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "13  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "14  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "15  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "16  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "17  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "18  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "19  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "20  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "21  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "22  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "23  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "24  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "25  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "26  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "27  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "28  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "29  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "..                                                ...  ...                        ...\n",
              "32  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "33  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "34  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "35  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "36  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "37  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "38  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "39  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "40  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "41  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "42  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "43  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "44  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "45  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "46  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "47  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "48  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "49  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "50  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "51  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "52  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "53  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "54  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "55  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "56  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "57  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "58  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "59  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "60  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "61  http://partners.api.skyscanner.net/apiservices...  ... 2019-09-16 22:36:41.622799\n",
              "\n",
              "[62 rows x 14 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 114
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OQn9jIo7KEl3",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# to do \n",
        "# finalizar mapeo variables Sí\n",
        "# bucle hasta que acepte la página Sí\n",
        "# bucle hasta que carge la página 0\n",
        "# más de una página\n",
        "# funcion\n"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}