boris.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "mount_file_id": "11CUVsB1KbNj8tkxirAtYBd6mFaQZu8X_",
      "authorship_tag": "ABX9TyOGtSLB5ghmsasFeNxGaHRs",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Augusta02/30-Days-Of-Python/blob/master/boris.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "id": "_IZAaNIU5aIX"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "\n",
        "drive.mount('/content/gdrive/', force_remount=True)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CfpRJCsB8JK1",
        "outputId": "25ec23cf-617f-4c5c-a3ea-3657b5e28fa9"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/gdrive/\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "new_df = pd.read_csv('/content/drive/MyDrive/Datasets/New_bookings.csv')\n",
        "new_df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 487
        },
        "id": "nqSaEth69R5c",
        "outputId": "d9a8a531-e6aa-4f88-91db-b04f65ac8386"
      },
      "execution_count": 63,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        SHIPMENT_NUMBER                            SHIPPER_ID  CARRIER_ID  \\\n",
              "0  SEZHUK-240118-283413  ee7cbc7b-4f14-44ac-9c6e-086d70a27141  CAUK000872   \n",
              "1  SEZHUK-240111-281159  192cd5b5-978c-4681-b206-2f4d04e081ec  CAUK000876   \n",
              "2  SEZHUK-240110-280958  ee7cbc7b-4f14-44ac-9c6e-086d70a27141  CAUK000872   \n",
              "3  SEZHUK-240115-282151  3244246f-e37c-4ba4-b9b3-61416a4449ae  CAUK000250   \n",
              "4  SEZHUK-240110-280768  3244246f-e37c-4ba4-b9b3-61416a4449ae  CAUK000250   \n",
              "\n",
              "   VEHICLE_SIZE            VEHICLE_BUILD_UP FIRST_COLLECTION_POST_CODE  \\\n",
              "0  Tractor Unit                         Box                     DUBLIN   \n",
              "1  Tractor Unit  Curtain-Side 13.6M Trailer                   LS24 9SD   \n",
              "2  Tractor Unit  Curtain-Side 13.6M Trailer                     DUBLIN   \n",
              "3  Tractor Unit  Curtain-Side 13.6M Trailer                    S80 3FY   \n",
              "4  Tractor Unit  Curtain-Side 13.6M Trailer                    S80 3FY   \n",
              "\n",
              "  LAST_DELIVERY_POST_CODE  FIRST_COLLECTION_LATITUDE  \\\n",
              "0                 DN3 3FF                  53.407411   \n",
              "1                BT26 6JJ                  53.882244   \n",
              "2                 DN3 3FF                  53.407411   \n",
              "3                  DUBLIN                  53.293393   \n",
              "4                BT36 7LQ                  53.293393   \n",
              "\n",
              "   FIRST_COLLECTION_LONGITUDE  LAST_DELIVERY_LATITUDE  \\\n",
              "0                   -6.238118               53.537912   \n",
              "1                   -1.267537               54.474078   \n",
              "2                   -6.238118               53.537912   \n",
              "3                   -1.074008               53.294121   \n",
              "4                   -1.074008               54.664518   \n",
              "\n",
              "   LAST_DELIVERY_LONGITUDE FIRST_COLLECTION_SCHEDULE_EARLIEST  \\\n",
              "0                -1.033570           2024-01-18T18:00:00.000Z   \n",
              "1                -6.104285           2024-01-12T10:00:00.000Z   \n",
              "2                -1.033570           2024-01-11T15:03:00.000Z   \n",
              "3                -6.441900           2024-01-16T06:00:00.000Z   \n",
              "4                -5.932184           2024-01-11T06:00:00.000Z   \n",
              "\n",
              "  FIRST_COLLECTION_SCHEDULE_LATEST LAST_DELIVERY_SCHEDULE_EARLIEST  \\\n",
              "0         2024-01-18T23:00:00.000Z        2024-01-19T12:00:00.000Z   \n",
              "1         2024-01-16T07:00:00.000Z        2024-01-16T07:30:00.000Z   \n",
              "2         2024-01-11T15:33:00.000Z        2024-01-12T14:33:00.000Z   \n",
              "3         2024-01-16T06:59:00.000Z        2024-01-18T11:01:00.000Z   \n",
              "4         2024-01-11T06:59:00.000Z        2024-01-15T07:25:00.000Z   \n",
              "\n",
              "  LAST_DELIVERY_SCHEDULE_LATEST  \n",
              "0      2024-01-19T13:00:00.000Z  \n",
              "1      2024-01-16T08:00:00.000Z  \n",
              "2      2024-01-12T15:03:00.000Z  \n",
              "3      2024-01-18T11:31:00.000Z  \n",
              "4      2024-01-15T07:55:00.000Z  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-639af189-5867-4407-865f-a46c5119dd25\" class=\"colab-df-container\">\n",
              "    <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>SHIPMENT_NUMBER</th>\n",
              "      <th>SHIPPER_ID</th>\n",
              "      <th>CARRIER_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>LAST_DELIVERY_LONGITUDE</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SEZHUK-240118-283413</td>\n",
              "      <td>ee7cbc7b-4f14-44ac-9c6e-086d70a27141</td>\n",
              "      <td>CAUK000872</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box</td>\n",
              "      <td>DUBLIN</td>\n",
              "      <td>DN3 3FF</td>\n",
              "      <td>53.407411</td>\n",
              "      <td>-6.238118</td>\n",
              "      <td>53.537912</td>\n",
              "      <td>-1.033570</td>\n",
              "      <td>2024-01-18T18:00:00.000Z</td>\n",
              "      <td>2024-01-18T23:00:00.000Z</td>\n",
              "      <td>2024-01-19T12:00:00.000Z</td>\n",
              "      <td>2024-01-19T13:00:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>SEZHUK-240111-281159</td>\n",
              "      <td>192cd5b5-978c-4681-b206-2f4d04e081ec</td>\n",
              "      <td>CAUK000876</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>LS24 9SD</td>\n",
              "      <td>BT26 6JJ</td>\n",
              "      <td>53.882244</td>\n",
              "      <td>-1.267537</td>\n",
              "      <td>54.474078</td>\n",
              "      <td>-6.104285</td>\n",
              "      <td>2024-01-12T10:00:00.000Z</td>\n",
              "      <td>2024-01-16T07:00:00.000Z</td>\n",
              "      <td>2024-01-16T07:30:00.000Z</td>\n",
              "      <td>2024-01-16T08:00:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SEZHUK-240110-280958</td>\n",
              "      <td>ee7cbc7b-4f14-44ac-9c6e-086d70a27141</td>\n",
              "      <td>CAUK000872</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>DUBLIN</td>\n",
              "      <td>DN3 3FF</td>\n",
              "      <td>53.407411</td>\n",
              "      <td>-6.238118</td>\n",
              "      <td>53.537912</td>\n",
              "      <td>-1.033570</td>\n",
              "      <td>2024-01-11T15:03:00.000Z</td>\n",
              "      <td>2024-01-11T15:33:00.000Z</td>\n",
              "      <td>2024-01-12T14:33:00.000Z</td>\n",
              "      <td>2024-01-12T15:03:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SEZHUK-240115-282151</td>\n",
              "      <td>3244246f-e37c-4ba4-b9b3-61416a4449ae</td>\n",
              "      <td>CAUK000250</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>S80 3FY</td>\n",
              "      <td>DUBLIN</td>\n",
              "      <td>53.293393</td>\n",
              "      <td>-1.074008</td>\n",
              "      <td>53.294121</td>\n",
              "      <td>-6.441900</td>\n",
              "      <td>2024-01-16T06:00:00.000Z</td>\n",
              "      <td>2024-01-16T06:59:00.000Z</td>\n",
              "      <td>2024-01-18T11:01:00.000Z</td>\n",
              "      <td>2024-01-18T11:31:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>SEZHUK-240110-280768</td>\n",
              "      <td>3244246f-e37c-4ba4-b9b3-61416a4449ae</td>\n",
              "      <td>CAUK000250</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>S80 3FY</td>\n",
              "      <td>BT36 7LQ</td>\n",
              "      <td>53.293393</td>\n",
              "      <td>-1.074008</td>\n",
              "      <td>54.664518</td>\n",
              "      <td>-5.932184</td>\n",
              "      <td>2024-01-11T06:00:00.000Z</td>\n",
              "      <td>2024-01-11T06:59:00.000Z</td>\n",
              "      <td>2024-01-15T07:25:00.000Z</td>\n",
              "      <td>2024-01-15T07:55:00.000Z</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-639af189-5867-4407-865f-a46c5119dd25')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-639af189-5867-4407-865f-a46c5119dd25 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-639af189-5867-4407-865f-a46c5119dd25');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-4aeb5a81-58e5-4614-86d6-69dfdee3fc0e\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4aeb5a81-58e5-4614-86d6-69dfdee3fc0e')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-4aeb5a81-58e5-4614-86d6-69dfdee3fc0e button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "new_df",
              "summary": "{\n  \"name\": \"new_df\",\n  \"rows\": 1000,\n  \"fields\": [\n    {\n      \"column\": \"SHIPMENT_NUMBER\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 1000,\n        \"samples\": [\n          \"SEZHUK-240103-278810\",\n          \"SEZHUK-240108-280162\",\n          \"SEZHUK-240112-281605\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SHIPPER_ID\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 42,\n        \"samples\": [\n          \"1efc40ea-69b6-473c-9fe1-afe97714399d\",\n          \"3371b762-7c32-44f3-a14e-bfb0a6f3d50b\",\n          \"bad2a1c4-4cf3-4157-864f-ce161784831f\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"CARRIER_ID\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 121,\n        \"samples\": [\n          \"CAUK000230\",\n          \"CAUK000295\",\n          \"CAUK000954\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"VEHICLE_SIZE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"Tractor Unit\",\n          \"3.5 T Van\",\n          \"7.5T Rigid\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"VEHICLE_BUILD_UP\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 10,\n        \"samples\": [\n          \"High Security\",\n          \"Curtain-Side 13.6M Trailer\",\n          \"Box 44ft\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_POST_CODE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 108,\n        \"samples\": [\n          \"M24 4DP\",\n          \"CO4 9QJ\",\n          \"DN15 9YA\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_POST_CODE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 314,\n        \"samples\": [\n          \"SN2 2DJ\",\n          \"DE74 2TR\",\n          \"ML4 1RJ\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_LATITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8734970215408936,\n        \"min\": 49.205063,\n        \"max\": 55.9017,\n        \"num_unique_values\": 118,\n        \"samples\": [\n          51.900329,\n          51.507218,\n          53.620347\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_LONGITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.9642821605294243,\n        \"min\": -6.359247,\n        \"max\": 0.927015,\n        \"num_unique_values\": 118,\n        \"samples\": [\n          -0.217132,\n          -0.127586,\n          -0.665131\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_LATITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.3249282081506462,\n        \"min\": 49.190245,\n        \"max\": 57.151183,\n        \"num_unique_values\": 337,\n        \"samples\": [\n          55.896335,\n          51.605784,\n          51.507218\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_LONGITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.4638005826038136,\n        \"min\": -7.321696,\n        \"max\": 1.304127,\n        \"num_unique_values\": 337,\n        \"samples\": [\n          -3.53565,\n          -0.048194,\n          -0.127586\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_SCHEDULE_EARLIEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 484,\n        \"samples\": [\n          \"2024-01-15T00:00:00.000Z\",\n          \"2024-01-15T19:47:00.000Z\",\n          \"2024-01-17T20:20:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_SCHEDULE_LATEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 617,\n        \"samples\": [\n          \"2024-01-16T13:59:00.000Z\",\n          \"2024-01-16T02:45:00.000Z\",\n          \"2024-01-12T20:59:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_SCHEDULE_EARLIEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 614,\n        \"samples\": [\n          \"2024-01-10T19:55:00.000Z\",\n          \"2024-01-16T06:00:00.000Z\",\n          \"2024-01-13T05:30:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_SCHEDULE_LATEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 624,\n        \"samples\": [\n          \"2024-01-18T11:05:00.000Z\",\n          \"2024-01-17T17:32:00.000Z\",\n          \"2024-01-18T21:30:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 63
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/drive/MyDrive/Datasets/GPS_data.csv')\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "Eo9H0Zqe7bFz",
        "outputId": "0f14c31b-7f73-4eb7-d918-28ef3a760b42"
      },
      "execution_count": 64,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        SHIPMENT_NUMBER        LAT       LON              RECORD_TIMESTAMP\n",
              "0  SEZHUK-230918-245388  53.291931 -1.072948  2023-10-09T19:25:00.000+0100\n",
              "1  SEZHUK-230918-245388  53.400404 -1.078563  2023-10-09T19:40:00.000+0100\n",
              "2  SEZHUK-230918-245388  53.574182 -1.215761  2023-10-09T19:55:00.000+0100\n",
              "3  SEZHUK-230918-245388  53.706805 -1.336503  2023-10-09T20:10:00.000+0100\n",
              "4  SEZHUK-230918-245388  53.747501 -1.640298  2023-10-09T20:25:00.000+0100"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c0cfd0e1-de10-49d6-9b94-ce5812276338\" class=\"colab-df-container\">\n",
              "    <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>SHIPMENT_NUMBER</th>\n",
              "      <th>LAT</th>\n",
              "      <th>LON</th>\n",
              "      <th>RECORD_TIMESTAMP</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.291931</td>\n",
              "      <td>-1.072948</td>\n",
              "      <td>2023-10-09T19:25:00.000+0100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.400404</td>\n",
              "      <td>-1.078563</td>\n",
              "      <td>2023-10-09T19:40:00.000+0100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.574182</td>\n",
              "      <td>-1.215761</td>\n",
              "      <td>2023-10-09T19:55:00.000+0100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.706805</td>\n",
              "      <td>-1.336503</td>\n",
              "      <td>2023-10-09T20:10:00.000+0100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.747501</td>\n",
              "      <td>-1.640298</td>\n",
              "      <td>2023-10-09T20:25:00.000+0100</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c0cfd0e1-de10-49d6-9b94-ce5812276338')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-c0cfd0e1-de10-49d6-9b94-ce5812276338 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-c0cfd0e1-de10-49d6-9b94-ce5812276338');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-b64d214c-0244-45cd-8a6b-9087cfecd00e\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-b64d214c-0244-45cd-8a6b-9087cfecd00e')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-b64d214c-0244-45cd-8a6b-9087cfecd00e button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 64
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "shipping_df = pd.read_csv('/content/drive/MyDrive/Datasets/Shipment_bookings (1).csv')\n",
        "shipping_df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 469
        },
        "id": "HUca7QUC9dBE",
        "outputId": "ee72f6db-7359-4b0a-f55c-ad1124dc636b"
      },
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             PROJECT_ID       SHIPMENT_NUMBER  \\\n",
              "0  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "1  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231217-275004   \n",
              "2  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231210-272018   \n",
              "3  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "4  39a4e234-5d35-4d94-8e8a-b8bf6fe13953  SEZHUK-231025-256168   \n",
              "\n",
              "  CARRIER_DISPLAY_ID  VEHICLE_SIZE            VEHICLE_BUILD_UP  \\\n",
              "0         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "1         CAUK000660  Tractor Unit                    Box 44ft   \n",
              "2         CAUK000435  Tractor Unit                    Box 44ft   \n",
              "3         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "4         CAUK000155  Tractor Unit                Curtain Side   \n",
              "\n",
              "  FIRST_COLLECTION_POST_CODE LAST_DELIVERY_POST_CODE  \\\n",
              "0                   PE29 2XR                EH48 2FB   \n",
              "1                    BD5 8LZ                RG19 4BQ   \n",
              "2                    BD5 8LZ                 EN3 7QP   \n",
              "3                   HP22 5BL                NG31 7UH   \n",
              "4                   CV23 8BQ                 G75 0ZZ   \n",
              "\n",
              "   FIRST_COLLECTION_LATITUDE  FIRST_COLLECTION_LONGITUDE  \\\n",
              "0                  52.315672                   -0.157664   \n",
              "1                  53.764125                   -1.740145   \n",
              "2                  53.767302                   -1.746560   \n",
              "3                  51.779657                   -0.772897   \n",
              "4                  52.334853                   -1.180450   \n",
              "\n",
              "   LAST_DELIVERY_LATITUDE  LAST_DELIVERY_LONGITUDE  \\\n",
              "0               55.877803                -3.648558   \n",
              "1               51.398851                -1.231993   \n",
              "2               51.660700                -0.022247   \n",
              "3               52.888113                -0.634948   \n",
              "4               55.735089                -4.168719   \n",
              "\n",
              "  FIRST_COLLECTION_SCHEDULE_EARLIEST FIRST_COLLECTION_SCHEDULE_LATEST  \\\n",
              "0           2023-10-06T09:45:00.000Z         2023-10-06T10:00:00.000Z   \n",
              "1           2023-12-19T14:20:00.000Z         2023-12-19T16:00:00.000Z   \n",
              "2           2023-12-14T01:20:00.000Z         2023-12-14T03:00:00.000Z   \n",
              "3           2023-12-13T09:00:00.000Z         2023-12-13T09:30:00.000Z   \n",
              "4           2023-11-07T14:00:00.000Z         2023-11-07T15:00:00.000Z   \n",
              "\n",
              "  LAST_DELIVERY_SCHEDULE_EARLIEST LAST_DELIVERY_SCHEDULE_LATEST  \n",
              "0        2023-10-09T09:55:00.000Z      2023-10-09T10:25:00.000Z  \n",
              "1        2023-12-20T06:00:00.000Z      2023-12-20T08:56:00.000Z  \n",
              "2        2023-12-14T07:03:00.000Z      2023-12-14T10:43:00.000Z  \n",
              "3        2023-12-13T15:30:00.000Z      2023-12-13T16:00:00.000Z  \n",
              "4        2023-11-07T23:00:00.000Z      2023-11-07T23:59:00.000Z  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-41775d21-409e-47a2-affd-83ee7462fd33\" class=\"colab-df-container\">\n",
              "    <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>PROJECT_ID</th>\n",
              "      <th>SHIPMENT_NUMBER</th>\n",
              "      <th>CARRIER_DISPLAY_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>LAST_DELIVERY_LONGITUDE</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06T09:45:00.000Z</td>\n",
              "      <td>2023-10-06T10:00:00.000Z</td>\n",
              "      <td>2023-10-09T09:55:00.000Z</td>\n",
              "      <td>2023-10-09T10:25:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231217-275004</td>\n",
              "      <td>CAUK000660</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>RG19 4BQ</td>\n",
              "      <td>53.764125</td>\n",
              "      <td>-1.740145</td>\n",
              "      <td>51.398851</td>\n",
              "      <td>-1.231993</td>\n",
              "      <td>2023-12-19T14:20:00.000Z</td>\n",
              "      <td>2023-12-19T16:00:00.000Z</td>\n",
              "      <td>2023-12-20T06:00:00.000Z</td>\n",
              "      <td>2023-12-20T08:56:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231210-272018</td>\n",
              "      <td>CAUK000435</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>EN3 7QP</td>\n",
              "      <td>53.767302</td>\n",
              "      <td>-1.746560</td>\n",
              "      <td>51.660700</td>\n",
              "      <td>-0.022247</td>\n",
              "      <td>2023-12-14T01:20:00.000Z</td>\n",
              "      <td>2023-12-14T03:00:00.000Z</td>\n",
              "      <td>2023-12-14T07:03:00.000Z</td>\n",
              "      <td>2023-12-14T10:43:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>-0.634948</td>\n",
              "      <td>2023-12-13T09:00:00.000Z</td>\n",
              "      <td>2023-12-13T09:30:00.000Z</td>\n",
              "      <td>2023-12-13T15:30:00.000Z</td>\n",
              "      <td>2023-12-13T16:00:00.000Z</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>39a4e234-5d35-4d94-8e8a-b8bf6fe13953</td>\n",
              "      <td>SEZHUK-231025-256168</td>\n",
              "      <td>CAUK000155</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain Side</td>\n",
              "      <td>CV23 8BQ</td>\n",
              "      <td>G75 0ZZ</td>\n",
              "      <td>52.334853</td>\n",
              "      <td>-1.180450</td>\n",
              "      <td>55.735089</td>\n",
              "      <td>-4.168719</td>\n",
              "      <td>2023-11-07T14:00:00.000Z</td>\n",
              "      <td>2023-11-07T15:00:00.000Z</td>\n",
              "      <td>2023-11-07T23:00:00.000Z</td>\n",
              "      <td>2023-11-07T23:59:00.000Z</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-41775d21-409e-47a2-affd-83ee7462fd33')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-41775d21-409e-47a2-affd-83ee7462fd33 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-41775d21-409e-47a2-affd-83ee7462fd33');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-2ce66fa0-a9b4-43e2-92ee-8316773c66f9\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-2ce66fa0-a9b4-43e2-92ee-8316773c66f9')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-2ce66fa0-a9b4-43e2-92ee-8316773c66f9 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "shipping_df",
              "summary": "{\n  \"name\": \"shipping_df\",\n  \"rows\": 3245,\n  \"fields\": [\n    {\n      \"column\": \"PROJECT_ID\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 49,\n        \"samples\": [\n          \"192cd5b5-978c-4681-b206-2f4d04e081ec\",\n          \"5c22fd8b-0496-422d-a31b-597c50cc8bc3\",\n          \"09585ac3-30ad-4115-b56c-878a25db4b76\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SHIPMENT_NUMBER\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3245,\n        \"samples\": [\n          \"SEZHUK-231228-277312\",\n          \"SEZHUK-231122-265395\",\n          \"SEZHUK-230929-248766\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"CARRIER_DISPLAY_ID\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 92,\n        \"samples\": [\n          \"CAUK000618\",\n          \"CAUK000770\",\n          \"CAUK000781\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"VEHICLE_SIZE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"Tractor Unit\",\n          \"3.5T Van\",\n          \"7.5T Rigid\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"VEHICLE_BUILD_UP\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 13,\n        \"samples\": [\n          \"Box 40ft\",\n          \"40ft Container\",\n          \"Curtain-Side 13.6M Trailer\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_POST_CODE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 154,\n        \"samples\": [\n          \"DE74 2TR\",\n          \"RG14 2DQ\",\n          \"SE28 0GU\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_POST_CODE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 433,\n        \"samples\": [\n          \"EX15 3ES\",\n          \"IP1 5NX\",\n          \"B66 1QG\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_LATITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8545789084671339,\n        \"min\": 50.38645,\n        \"max\": 55.932081,\n        \"num_unique_values\": 183,\n        \"samples\": [\n          53.304842,\n          51.508022,\n          51.893945\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_LONGITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8791123625723575,\n        \"min\": -6.104285,\n        \"max\": 1.397815,\n        \"num_unique_values\": 183,\n        \"samples\": [\n          -1.482042,\n          -0.05711,\n          -0.518006\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_LATITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.0998195965702868,\n        \"min\": 50.228709,\n        \"max\": 57.653603,\n        \"num_unique_values\": 497,\n        \"samples\": [\n          53.085338,\n          51.439021,\n          51.247484\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_LONGITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.572144507648225,\n        \"min\": -8.687242,\n        \"max\": 1.457581,\n        \"num_unique_values\": 497,\n        \"samples\": [\n          -1.378715,\n          0.20267,\n          -0.580755\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_SCHEDULE_EARLIEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1989,\n        \"samples\": [\n          \"2023-12-19T21:20:00.000Z\",\n          \"2023-11-13T22:19:00.000Z\",\n          \"2023-11-27T15:30:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_SCHEDULE_LATEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 2359,\n        \"samples\": [\n          \"2023-11-01T14:00:00.000Z\",\n          \"2023-12-15T18:02:00.000Z\",\n          \"2023-10-05T12:50:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_SCHEDULE_EARLIEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 2491,\n        \"samples\": [\n          \"2023-12-06T10:37:00.000Z\",\n          \"2023-10-06T06:55:00.000Z\",\n          \"2023-10-25T08:30:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_SCHEDULE_LATEST\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 2565,\n        \"samples\": [\n          \"2023-12-05T13:30:00.000Z\",\n          \"2023-12-19T15:00:00.000Z\",\n          \"2023-11-29T03:00:00.000Z\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 65
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Preprocessing Data"
      ],
      "metadata": {
        "id": "1wwNND5kH629"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.isnull().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JVxs8_McHe5p",
        "outputId": "4b2bf2ee-ba73-41d3-9b47-8095a70cb97c"
      },
      "execution_count": 66,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "SHIPMENT_NUMBER     0\n",
              "LAT                 0\n",
              "LON                 0\n",
              "RECORD_TIMESTAMP    0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 66
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "shipping_df.isnull().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "eQvCR4R1Hli2",
        "outputId": "f093cdb5-9f12-4e6c-ad28-d82d92f39086"
      },
      "execution_count": 67,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "PROJECT_ID                            0\n",
              "SHIPMENT_NUMBER                       0\n",
              "CARRIER_DISPLAY_ID                    0\n",
              "VEHICLE_SIZE                          0\n",
              "VEHICLE_BUILD_UP                      0\n",
              "FIRST_COLLECTION_POST_CODE            1\n",
              "LAST_DELIVERY_POST_CODE               4\n",
              "FIRST_COLLECTION_LATITUDE             0\n",
              "FIRST_COLLECTION_LONGITUDE            0\n",
              "LAST_DELIVERY_LATITUDE                0\n",
              "LAST_DELIVERY_LONGITUDE               0\n",
              "FIRST_COLLECTION_SCHEDULE_EARLIEST    0\n",
              "FIRST_COLLECTION_SCHEDULE_LATEST      0\n",
              "LAST_DELIVERY_SCHEDULE_EARLIEST       0\n",
              "LAST_DELIVERY_SCHEDULE_LATEST         0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 67
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['RECORD_TIMESTAMP'].dtype"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "IcEe6LpMHsqd",
        "outputId": "e0c9d085-e66c-4588-af66-057988e1ee52"
      },
      "execution_count": 68,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dtype('O')"
            ]
          },
          "metadata": {},
          "execution_count": 68
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# change record_timestamp to datetime data type\n",
        "df['RECORD_TIMESTAMP'] = pd.to_datetime(df['RECORD_TIMESTAMP'], utc=True)"
      ],
      "metadata": {
        "id": "Nrk7vQuaHz-0"
      },
      "execution_count": 69,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df['RECORD_TIMESTAMP'].dtype"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "n1tSwvloJXcx",
        "outputId": "feecd038-7a52-432c-82fb-d31197ecc597"
      },
      "execution_count": 70,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "datetime64[ns, UTC]"
            ]
          },
          "metadata": {},
          "execution_count": 70
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "COBqdbPNJZL0",
        "outputId": "86b31185-fc9d-47a2-98d5-801bc663d0f0"
      },
      "execution_count": 71,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        SHIPMENT_NUMBER        LAT       LON          RECORD_TIMESTAMP\n",
              "0  SEZHUK-230918-245388  53.291931 -1.072948 2023-10-09 18:25:00+00:00\n",
              "1  SEZHUK-230918-245388  53.400404 -1.078563 2023-10-09 18:40:00+00:00\n",
              "2  SEZHUK-230918-245388  53.574182 -1.215761 2023-10-09 18:55:00+00:00\n",
              "3  SEZHUK-230918-245388  53.706805 -1.336503 2023-10-09 19:10:00+00:00\n",
              "4  SEZHUK-230918-245388  53.747501 -1.640298 2023-10-09 19:25:00+00:00"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0d8f0ce0-452f-417d-badf-d26b50fc4081\" class=\"colab-df-container\">\n",
              "    <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>SHIPMENT_NUMBER</th>\n",
              "      <th>LAT</th>\n",
              "      <th>LON</th>\n",
              "      <th>RECORD_TIMESTAMP</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.291931</td>\n",
              "      <td>-1.072948</td>\n",
              "      <td>2023-10-09 18:25:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.400404</td>\n",
              "      <td>-1.078563</td>\n",
              "      <td>2023-10-09 18:40:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.574182</td>\n",
              "      <td>-1.215761</td>\n",
              "      <td>2023-10-09 18:55:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.706805</td>\n",
              "      <td>-1.336503</td>\n",
              "      <td>2023-10-09 19:10:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>SEZHUK-230918-245388</td>\n",
              "      <td>53.747501</td>\n",
              "      <td>-1.640298</td>\n",
              "      <td>2023-10-09 19:25:00+00:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0d8f0ce0-452f-417d-badf-d26b50fc4081')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-0d8f0ce0-452f-417d-badf-d26b50fc4081 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-0d8f0ce0-452f-417d-badf-d26b50fc4081');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-a8fd1f94-3e96-4939-a890-5c185fd03f64\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-a8fd1f94-3e96-4939-a890-5c185fd03f64')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-a8fd1f94-3e96-4939-a890-5c185fd03f64 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 71
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "shipping_df['FIRST_COLLECTION_SCHEDULE_LATEST'].dtype"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "o9kgU_QaKY9G",
        "outputId": "ae9f1958-6c7e-47da-9ab6-241db0e74cd9"
      },
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "dtype('O')"
            ]
          },
          "metadata": {},
          "execution_count": 72
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# convert time data in shipping dataframe\n",
        "\n",
        "datetime_cols = [\n",
        "    'FIRST_COLLECTION_SCHEDULE_EARLIEST',\n",
        "    'FIRST_COLLECTION_SCHEDULE_LATEST',\n",
        "    'LAST_DELIVERY_SCHEDULE_EARLIEST',\n",
        "    'LAST_DELIVERY_SCHEDULE_LATEST'\n",
        "]\n",
        "\n",
        "for cols in datetime_cols:\n",
        "  shipping_df[cols] = pd.to_datetime(shipping_df[cols], utc=True)"
      ],
      "metadata": {
        "id": "dfQtCaZWJfWO"
      },
      "execution_count": 73,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "shipping_df['FIRST_COLLECTION_SCHEDULE_LATEST'].dtype"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "L_2IhbAYKtwu",
        "outputId": "da1e8c46-3377-48fa-f8c3-b37bc48852cc"
      },
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "datetime64[ns, UTC]"
            ]
          },
          "metadata": {},
          "execution_count": 74
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "shipping_df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 469
        },
        "id": "Zt8kJxz9LAl1",
        "outputId": "45ceebd4-a767-4a20-ccce-8e64e8fad782"
      },
      "execution_count": 75,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             PROJECT_ID       SHIPMENT_NUMBER  \\\n",
              "0  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "1  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231217-275004   \n",
              "2  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231210-272018   \n",
              "3  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "4  39a4e234-5d35-4d94-8e8a-b8bf6fe13953  SEZHUK-231025-256168   \n",
              "\n",
              "  CARRIER_DISPLAY_ID  VEHICLE_SIZE            VEHICLE_BUILD_UP  \\\n",
              "0         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "1         CAUK000660  Tractor Unit                    Box 44ft   \n",
              "2         CAUK000435  Tractor Unit                    Box 44ft   \n",
              "3         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "4         CAUK000155  Tractor Unit                Curtain Side   \n",
              "\n",
              "  FIRST_COLLECTION_POST_CODE LAST_DELIVERY_POST_CODE  \\\n",
              "0                   PE29 2XR                EH48 2FB   \n",
              "1                    BD5 8LZ                RG19 4BQ   \n",
              "2                    BD5 8LZ                 EN3 7QP   \n",
              "3                   HP22 5BL                NG31 7UH   \n",
              "4                   CV23 8BQ                 G75 0ZZ   \n",
              "\n",
              "   FIRST_COLLECTION_LATITUDE  FIRST_COLLECTION_LONGITUDE  \\\n",
              "0                  52.315672                   -0.157664   \n",
              "1                  53.764125                   -1.740145   \n",
              "2                  53.767302                   -1.746560   \n",
              "3                  51.779657                   -0.772897   \n",
              "4                  52.334853                   -1.180450   \n",
              "\n",
              "   LAST_DELIVERY_LATITUDE  LAST_DELIVERY_LONGITUDE  \\\n",
              "0               55.877803                -3.648558   \n",
              "1               51.398851                -1.231993   \n",
              "2               51.660700                -0.022247   \n",
              "3               52.888113                -0.634948   \n",
              "4               55.735089                -4.168719   \n",
              "\n",
              "  FIRST_COLLECTION_SCHEDULE_EARLIEST FIRST_COLLECTION_SCHEDULE_LATEST  \\\n",
              "0          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "1          2023-12-19 14:20:00+00:00        2023-12-19 16:00:00+00:00   \n",
              "2          2023-12-14 01:20:00+00:00        2023-12-14 03:00:00+00:00   \n",
              "3          2023-12-13 09:00:00+00:00        2023-12-13 09:30:00+00:00   \n",
              "4          2023-11-07 14:00:00+00:00        2023-11-07 15:00:00+00:00   \n",
              "\n",
              "  LAST_DELIVERY_SCHEDULE_EARLIEST LAST_DELIVERY_SCHEDULE_LATEST  \n",
              "0       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  \n",
              "1       2023-12-20 06:00:00+00:00     2023-12-20 08:56:00+00:00  \n",
              "2       2023-12-14 07:03:00+00:00     2023-12-14 10:43:00+00:00  \n",
              "3       2023-12-13 15:30:00+00:00     2023-12-13 16:00:00+00:00  \n",
              "4       2023-11-07 23:00:00+00:00     2023-11-07 23:59:00+00:00  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8ccfa42d-ee26-4ff6-b831-dc7bceefb6b5\" class=\"colab-df-container\">\n",
              "    <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>PROJECT_ID</th>\n",
              "      <th>SHIPMENT_NUMBER</th>\n",
              "      <th>CARRIER_DISPLAY_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>LAST_DELIVERY_LONGITUDE</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231217-275004</td>\n",
              "      <td>CAUK000660</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>RG19 4BQ</td>\n",
              "      <td>53.764125</td>\n",
              "      <td>-1.740145</td>\n",
              "      <td>51.398851</td>\n",
              "      <td>-1.231993</td>\n",
              "      <td>2023-12-19 14:20:00+00:00</td>\n",
              "      <td>2023-12-19 16:00:00+00:00</td>\n",
              "      <td>2023-12-20 06:00:00+00:00</td>\n",
              "      <td>2023-12-20 08:56:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231210-272018</td>\n",
              "      <td>CAUK000435</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>EN3 7QP</td>\n",
              "      <td>53.767302</td>\n",
              "      <td>-1.746560</td>\n",
              "      <td>51.660700</td>\n",
              "      <td>-0.022247</td>\n",
              "      <td>2023-12-14 01:20:00+00:00</td>\n",
              "      <td>2023-12-14 03:00:00+00:00</td>\n",
              "      <td>2023-12-14 07:03:00+00:00</td>\n",
              "      <td>2023-12-14 10:43:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>-0.634948</td>\n",
              "      <td>2023-12-13 09:00:00+00:00</td>\n",
              "      <td>2023-12-13 09:30:00+00:00</td>\n",
              "      <td>2023-12-13 15:30:00+00:00</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>39a4e234-5d35-4d94-8e8a-b8bf6fe13953</td>\n",
              "      <td>SEZHUK-231025-256168</td>\n",
              "      <td>CAUK000155</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain Side</td>\n",
              "      <td>CV23 8BQ</td>\n",
              "      <td>G75 0ZZ</td>\n",
              "      <td>52.334853</td>\n",
              "      <td>-1.180450</td>\n",
              "      <td>55.735089</td>\n",
              "      <td>-4.168719</td>\n",
              "      <td>2023-11-07 14:00:00+00:00</td>\n",
              "      <td>2023-11-07 15:00:00+00:00</td>\n",
              "      <td>2023-11-07 23:00:00+00:00</td>\n",
              "      <td>2023-11-07 23:59:00+00:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8ccfa42d-ee26-4ff6-b831-dc7bceefb6b5')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-8ccfa42d-ee26-4ff6-b831-dc7bceefb6b5 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-8ccfa42d-ee26-4ff6-b831-dc7bceefb6b5');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-6a3f423e-16bd-44da-829f-4cf2a85dafda\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-6a3f423e-16bd-44da-829f-4cf2a85dafda')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-6a3f423e-16bd-44da-829f-4cf2a85dafda button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "shipping_df",
              "summary": "{\n  \"name\": \"shipping_df\",\n  \"rows\": 3245,\n  \"fields\": [\n    {\n      \"column\": \"PROJECT_ID\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 49,\n        \"samples\": [\n          \"192cd5b5-978c-4681-b206-2f4d04e081ec\",\n          \"5c22fd8b-0496-422d-a31b-597c50cc8bc3\",\n          \"09585ac3-30ad-4115-b56c-878a25db4b76\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SHIPMENT_NUMBER\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3245,\n        \"samples\": [\n          \"SEZHUK-231228-277312\",\n          \"SEZHUK-231122-265395\",\n          \"SEZHUK-230929-248766\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"CARRIER_DISPLAY_ID\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 92,\n        \"samples\": [\n          \"CAUK000618\",\n          \"CAUK000770\",\n          \"CAUK000781\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"VEHICLE_SIZE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"Tractor Unit\",\n          \"3.5T Van\",\n          \"7.5T Rigid\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"VEHICLE_BUILD_UP\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 13,\n        \"samples\": [\n          \"Box 40ft\",\n          \"40ft Container\",\n          \"Curtain-Side 13.6M Trailer\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_POST_CODE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 154,\n        \"samples\": [\n          \"DE74 2TR\",\n          \"RG14 2DQ\",\n          \"SE28 0GU\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_POST_CODE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 433,\n        \"samples\": [\n          \"EX15 3ES\",\n          \"IP1 5NX\",\n          \"B66 1QG\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_LATITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8545789084671339,\n        \"min\": 50.38645,\n        \"max\": 55.932081,\n        \"num_unique_values\": 183,\n        \"samples\": [\n          53.304842,\n          51.508022,\n          51.893945\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_LONGITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8791123625723575,\n        \"min\": -6.104285,\n        \"max\": 1.397815,\n        \"num_unique_values\": 183,\n        \"samples\": [\n          -1.482042,\n          -0.05711,\n          -0.518006\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_LATITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.0998195965702868,\n        \"min\": 50.228709,\n        \"max\": 57.653603,\n        \"num_unique_values\": 497,\n        \"samples\": [\n          53.085338,\n          51.439021,\n          51.247484\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_LONGITUDE\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.572144507648225,\n        \"min\": -8.687242,\n        \"max\": 1.457581,\n        \"num_unique_values\": 497,\n        \"samples\": [\n          -1.378715,\n          0.20267,\n          -0.580755\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_SCHEDULE_EARLIEST\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2023-09-29 14:00:00+00:00\",\n        \"max\": \"2023-12-31 00:30:00+00:00\",\n        \"num_unique_values\": 1989,\n        \"samples\": [\n          \"2023-12-19 21:20:00+00:00\",\n          \"2023-11-13 22:19:00+00:00\",\n          \"2023-11-27 15:30:00+00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"FIRST_COLLECTION_SCHEDULE_LATEST\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2023-10-01 01:00:00+00:00\",\n        \"max\": \"2023-12-31 01:00:00+00:00\",\n        \"num_unique_values\": 2359,\n        \"samples\": [\n          \"2023-11-01 14:00:00+00:00\",\n          \"2023-12-15 18:02:00+00:00\",\n          \"2023-10-05 12:50:00+00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_SCHEDULE_EARLIEST\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2023-10-01 03:00:00+00:00\",\n        \"max\": \"2024-01-03 10:25:00+00:00\",\n        \"num_unique_values\": 2491,\n        \"samples\": [\n          \"2023-12-06 10:37:00+00:00\",\n          \"2023-10-06 06:55:00+00:00\",\n          \"2023-10-25 08:30:00+00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"LAST_DELIVERY_SCHEDULE_LATEST\",\n      \"properties\": {\n        \"dtype\": \"date\",\n        \"min\": \"2023-10-01 03:30:00+00:00\",\n        \"max\": \"2024-01-03 10:55:00+00:00\",\n        \"num_unique_values\": 2565,\n        \"samples\": [\n          \"2023-12-05 13:30:00+00:00\",\n          \"2023-12-19 15:00:00+00:00\",\n          \"2023-11-29 03:00:00+00:00\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 75
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# merge GPS and Shipping data\n",
        "\n",
        "merged_data = pd.merge(shipping_df, df, on='SHIPMENT_NUMBER', how='inner')\n",
        "merged_data.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 417
        },
        "id": "U-RvZHgfLMZV",
        "outputId": "0ca5c7a8-ef9e-446e-87a9-4cc2d8fbcee0"
      },
      "execution_count": 76,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             PROJECT_ID       SHIPMENT_NUMBER  \\\n",
              "0  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "1  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "2  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "3  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "4  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231217-275004   \n",
              "\n",
              "  CARRIER_DISPLAY_ID  VEHICLE_SIZE            VEHICLE_BUILD_UP  \\\n",
              "0         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "1         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "2         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "3         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "4         CAUK000660  Tractor Unit                    Box 44ft   \n",
              "\n",
              "  FIRST_COLLECTION_POST_CODE LAST_DELIVERY_POST_CODE  \\\n",
              "0                   PE29 2XR                EH48 2FB   \n",
              "1                   PE29 2XR                EH48 2FB   \n",
              "2                   PE29 2XR                EH48 2FB   \n",
              "3                   PE29 2XR                EH48 2FB   \n",
              "4                    BD5 8LZ                RG19 4BQ   \n",
              "\n",
              "   FIRST_COLLECTION_LATITUDE  FIRST_COLLECTION_LONGITUDE  \\\n",
              "0                  52.315672                   -0.157664   \n",
              "1                  52.315672                   -0.157664   \n",
              "2                  52.315672                   -0.157664   \n",
              "3                  52.315672                   -0.157664   \n",
              "4                  53.764125                   -1.740145   \n",
              "\n",
              "   LAST_DELIVERY_LATITUDE  LAST_DELIVERY_LONGITUDE  \\\n",
              "0               55.877803                -3.648558   \n",
              "1               55.877803                -3.648558   \n",
              "2               55.877803                -3.648558   \n",
              "3               55.877803                -3.648558   \n",
              "4               51.398851                -1.231993   \n",
              "\n",
              "  FIRST_COLLECTION_SCHEDULE_EARLIEST FIRST_COLLECTION_SCHEDULE_LATEST  \\\n",
              "0          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "1          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "2          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "3          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "4          2023-12-19 14:20:00+00:00        2023-12-19 16:00:00+00:00   \n",
              "\n",
              "  LAST_DELIVERY_SCHEDULE_EARLIEST LAST_DELIVERY_SCHEDULE_LATEST        LAT  \\\n",
              "0       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316349   \n",
              "1       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316602   \n",
              "2       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316440   \n",
              "3       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316544   \n",
              "4       2023-12-20 06:00:00+00:00     2023-12-20 08:56:00+00:00  53.763753   \n",
              "\n",
              "        LON          RECORD_TIMESTAMP  \n",
              "0 -0.156690 2023-10-06 08:58:00+00:00  \n",
              "1 -0.157301 2023-10-06 09:03:00+00:00  \n",
              "2 -0.157995 2023-10-06 09:05:00+00:00  \n",
              "3 -0.157263 2023-10-06 09:24:00+00:00  \n",
              "4 -1.739292 2023-12-19 15:47:00+00:00  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7dfc52d7-9030-4453-9f61-ffc6d4cd0f86\" class=\"colab-df-container\">\n",
              "    <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>PROJECT_ID</th>\n",
              "      <th>SHIPMENT_NUMBER</th>\n",
              "      <th>CARRIER_DISPLAY_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>LAST_DELIVERY_LONGITUDE</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "      <th>LAT</th>\n",
              "      <th>LON</th>\n",
              "      <th>RECORD_TIMESTAMP</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316349</td>\n",
              "      <td>-0.156690</td>\n",
              "      <td>2023-10-06 08:58:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316602</td>\n",
              "      <td>-0.157301</td>\n",
              "      <td>2023-10-06 09:03:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316440</td>\n",
              "      <td>-0.157995</td>\n",
              "      <td>2023-10-06 09:05:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316544</td>\n",
              "      <td>-0.157263</td>\n",
              "      <td>2023-10-06 09:24:00+00:00</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231217-275004</td>\n",
              "      <td>CAUK000660</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>RG19 4BQ</td>\n",
              "      <td>53.764125</td>\n",
              "      <td>-1.740145</td>\n",
              "      <td>51.398851</td>\n",
              "      <td>-1.231993</td>\n",
              "      <td>2023-12-19 14:20:00+00:00</td>\n",
              "      <td>2023-12-19 16:00:00+00:00</td>\n",
              "      <td>2023-12-20 06:00:00+00:00</td>\n",
              "      <td>2023-12-20 08:56:00+00:00</td>\n",
              "      <td>53.763753</td>\n",
              "      <td>-1.739292</td>\n",
              "      <td>2023-12-19 15:47:00+00:00</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7dfc52d7-9030-4453-9f61-ffc6d4cd0f86')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-7dfc52d7-9030-4453-9f61-ffc6d4cd0f86 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-7dfc52d7-9030-4453-9f61-ffc6d4cd0f86');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-a7aaa1f7-c54c-4e18-bc26-66e9086a2782\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-a7aaa1f7-c54c-4e18-bc26-66e9086a2782')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-a7aaa1f7-c54c-4e18-bc26-66e9086a2782 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "merged_data"
            }
          },
          "metadata": {},
          "execution_count": 76
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bAx-Wa6DL0A1",
        "outputId": "cda986fb-c9ee-44c8-fe2e-0abfc93fa346"
      },
      "execution_count": 77,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(641662, 4)"
            ]
          },
          "metadata": {},
          "execution_count": 77
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "shipping_df.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Un9rgq5nL7Yu",
        "outputId": "5afb55c7-7ce7-489c-e520-01e3efa3d970"
      },
      "execution_count": 78,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(3245, 15)"
            ]
          },
          "metadata": {},
          "execution_count": 78
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "merged_data.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "9cw621ZIMAhx",
        "outputId": "fb478ea6-4a2c-4351-eb6f-ef8acd22c8ee"
      },
      "execution_count": 79,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(641662, 18)"
            ]
          },
          "metadata": {},
          "execution_count": 79
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the dataset between october first and december 31st 2023\n",
        "start_date = pd.to_datetime('2023-10-01')\n",
        "end_date = pd.to_datetime('2023-12-31')\n",
        "\n",
        "\n",
        "filtered_data = merged_data[merged_data['RECORD_TIMESTAMP'].dt.date >= start_date.date()]\n",
        "filtered_data = filtered_data[filtered_data['RECORD_TIMESTAMP'].dt.date <= end_date.date()]"
      ],
      "metadata": {
        "id": "ftDAyHqlM9UJ"
      },
      "execution_count": 80,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Analyze On-Time Deliveries"
      ],
      "metadata": {
        "id": "LGm0sejdeEhg"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# buffer time\n",
        "buffer_time = pd.Timedelta(minutes=30)\n",
        "# total_delivery = len(filtered_data)\n",
        "\n",
        "# create column for on-time delivery, initializing with False\n",
        "filtered_data['On-Time Delivery'] = False\n",
        "\n",
        "# iterate row to calculate latest time\n",
        "# latest time is the time we expect delivery to be delivered\n",
        "for index, row in filtered_data.iterrows():\n",
        "  # extract arrival time\n",
        "  arrival_time = row['RECORD_TIMESTAMP']\n",
        "  # extract scheduled delivery latest\n",
        "  scheduled_delivery = row['LAST_DELIVERY_SCHEDULE_LATEST']\n",
        "  # calculate the latest time item should be delivered\n",
        "  latest_time = scheduled_delivery + buffer_time\n",
        "\n",
        "  # check if the arrival_time is within the latest_time range\n",
        "  if arrival_time <= latest_time:\n",
        "    filtered_data.loc[index, 'On-Time Delivery'] = True\n"
      ],
      "metadata": {
        "id": "n4wO6HYtS-h-"
      },
      "execution_count": 81,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# percentage of on-time deliveries\n",
        "total_delivery = len(filtered_data)\n",
        "on_time_deliveries = filtered_data['On-Time Delivery'].sum()\n",
        "\n",
        "percentage_of_on_time_deliveries = (on_time_deliveries / total_delivery) * 100\n",
        "\n",
        "print(f\"Percentage of on-time deliveries: {percentage_of_on_time_deliveries:.2f}%\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xiGb-KdDbLBI",
        "outputId": "702f9e18-baf3-46b6-be6c-1d4a3e48ed87"
      },
      "execution_count": 82,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Percentage of on-time deliveries: 75.20%\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Potential Late Delivery"
      ],
      "metadata": {
        "id": "utFcBnUeeKdD"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "new_df.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "0sPqpUnBgQsH",
        "outputId": "9d9f2adb-c1fb-482e-fc2a-688dff526d14"
      },
      "execution_count": 83,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['SHIPMENT_NUMBER', 'SHIPPER_ID', 'CARRIER_ID', 'VEHICLE_SIZE',\n",
              "       'VEHICLE_BUILD_UP', 'FIRST_COLLECTION_POST_CODE',\n",
              "       'LAST_DELIVERY_POST_CODE', 'FIRST_COLLECTION_LATITUDE',\n",
              "       'FIRST_COLLECTION_LONGITUDE', 'LAST_DELIVERY_LATITUDE',\n",
              "       'LAST_DELIVERY_LONGITUDE', 'FIRST_COLLECTION_SCHEDULE_EARLIEST',\n",
              "       'FIRST_COLLECTION_SCHEDULE_LATEST', 'LAST_DELIVERY_SCHEDULE_EARLIEST',\n",
              "       'LAST_DELIVERY_SCHEDULE_LATEST'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 83
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# merge shipper_id from the new_bookings data to the filtered dataframe\n",
        "\n",
        "data = filtered_data.merge(new_df[['SHIPMENT_NUMBER', 'SHIPPER_ID']], on='SHIPMENT_NUMBER', how='left')\n",
        "\n",
        "data.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 434
        },
        "id": "mDQMUCJeg7bB",
        "outputId": "a98f3f24-253e-422f-9451-ae74c1adb1c5"
      },
      "execution_count": 84,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             PROJECT_ID       SHIPMENT_NUMBER  \\\n",
              "0  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "1  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "2  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "3  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "4  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231217-275004   \n",
              "\n",
              "  CARRIER_DISPLAY_ID  VEHICLE_SIZE            VEHICLE_BUILD_UP  \\\n",
              "0         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "1         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "2         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "3         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "4         CAUK000660  Tractor Unit                    Box 44ft   \n",
              "\n",
              "  FIRST_COLLECTION_POST_CODE LAST_DELIVERY_POST_CODE  \\\n",
              "0                   PE29 2XR                EH48 2FB   \n",
              "1                   PE29 2XR                EH48 2FB   \n",
              "2                   PE29 2XR                EH48 2FB   \n",
              "3                   PE29 2XR                EH48 2FB   \n",
              "4                    BD5 8LZ                RG19 4BQ   \n",
              "\n",
              "   FIRST_COLLECTION_LATITUDE  FIRST_COLLECTION_LONGITUDE  \\\n",
              "0                  52.315672                   -0.157664   \n",
              "1                  52.315672                   -0.157664   \n",
              "2                  52.315672                   -0.157664   \n",
              "3                  52.315672                   -0.157664   \n",
              "4                  53.764125                   -1.740145   \n",
              "\n",
              "   LAST_DELIVERY_LATITUDE  LAST_DELIVERY_LONGITUDE  \\\n",
              "0               55.877803                -3.648558   \n",
              "1               55.877803                -3.648558   \n",
              "2               55.877803                -3.648558   \n",
              "3               55.877803                -3.648558   \n",
              "4               51.398851                -1.231993   \n",
              "\n",
              "  FIRST_COLLECTION_SCHEDULE_EARLIEST FIRST_COLLECTION_SCHEDULE_LATEST  \\\n",
              "0          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "1          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "2          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "3          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "4          2023-12-19 14:20:00+00:00        2023-12-19 16:00:00+00:00   \n",
              "\n",
              "  LAST_DELIVERY_SCHEDULE_EARLIEST LAST_DELIVERY_SCHEDULE_LATEST        LAT  \\\n",
              "0       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316349   \n",
              "1       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316602   \n",
              "2       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316440   \n",
              "3       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316544   \n",
              "4       2023-12-20 06:00:00+00:00     2023-12-20 08:56:00+00:00  53.763753   \n",
              "\n",
              "        LON          RECORD_TIMESTAMP  On-Time Delivery SHIPPER_ID  \n",
              "0 -0.156690 2023-10-06 08:58:00+00:00              True        NaN  \n",
              "1 -0.157301 2023-10-06 09:03:00+00:00              True        NaN  \n",
              "2 -0.157995 2023-10-06 09:05:00+00:00              True        NaN  \n",
              "3 -0.157263 2023-10-06 09:24:00+00:00              True        NaN  \n",
              "4 -1.739292 2023-12-19 15:47:00+00:00              True        NaN  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-dd03f039-cc91-45a5-81a9-ed71079248d9\" class=\"colab-df-container\">\n",
              "    <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>PROJECT_ID</th>\n",
              "      <th>SHIPMENT_NUMBER</th>\n",
              "      <th>CARRIER_DISPLAY_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>LAST_DELIVERY_LONGITUDE</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "      <th>LAT</th>\n",
              "      <th>LON</th>\n",
              "      <th>RECORD_TIMESTAMP</th>\n",
              "      <th>On-Time Delivery</th>\n",
              "      <th>SHIPPER_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316349</td>\n",
              "      <td>-0.156690</td>\n",
              "      <td>2023-10-06 08:58:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316602</td>\n",
              "      <td>-0.157301</td>\n",
              "      <td>2023-10-06 09:03:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316440</td>\n",
              "      <td>-0.157995</td>\n",
              "      <td>2023-10-06 09:05:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316544</td>\n",
              "      <td>-0.157263</td>\n",
              "      <td>2023-10-06 09:24:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231217-275004</td>\n",
              "      <td>CAUK000660</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>RG19 4BQ</td>\n",
              "      <td>53.764125</td>\n",
              "      <td>-1.740145</td>\n",
              "      <td>51.398851</td>\n",
              "      <td>-1.231993</td>\n",
              "      <td>2023-12-19 14:20:00+00:00</td>\n",
              "      <td>2023-12-19 16:00:00+00:00</td>\n",
              "      <td>2023-12-20 06:00:00+00:00</td>\n",
              "      <td>2023-12-20 08:56:00+00:00</td>\n",
              "      <td>53.763753</td>\n",
              "      <td>-1.739292</td>\n",
              "      <td>2023-12-19 15:47:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-dd03f039-cc91-45a5-81a9-ed71079248d9')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-dd03f039-cc91-45a5-81a9-ed71079248d9 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-dd03f039-cc91-45a5-81a9-ed71079248d9');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-ad4204e9-e505-4f56-b171-b8f9fb129ab5\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ad4204e9-e505-4f56-b171-b8f9fb129ab5')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-ad4204e9-e505-4f56-b171-b8f9fb129ab5 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data"
            }
          },
          "metadata": {},
          "execution_count": 84
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 434
        },
        "id": "AA_p8cKnlS84",
        "outputId": "af3dfbb4-ecaa-451a-e991-709b8c625b92"
      },
      "execution_count": 85,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                             PROJECT_ID       SHIPMENT_NUMBER  \\\n",
              "0  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "1  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "2  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "3  5456fcfa-5b0c-428e-b322-240d508b6660  SEZHUK-231005-250448   \n",
              "4  eb7a9df0-4875-43d8-9060-c79c35eae2fb  SEZHUK-231217-275004   \n",
              "\n",
              "  CARRIER_DISPLAY_ID  VEHICLE_SIZE            VEHICLE_BUILD_UP  \\\n",
              "0         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "1         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "2         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "3         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "4         CAUK000660  Tractor Unit                    Box 44ft   \n",
              "\n",
              "  FIRST_COLLECTION_POST_CODE LAST_DELIVERY_POST_CODE  \\\n",
              "0                   PE29 2XR                EH48 2FB   \n",
              "1                   PE29 2XR                EH48 2FB   \n",
              "2                   PE29 2XR                EH48 2FB   \n",
              "3                   PE29 2XR                EH48 2FB   \n",
              "4                    BD5 8LZ                RG19 4BQ   \n",
              "\n",
              "   FIRST_COLLECTION_LATITUDE  FIRST_COLLECTION_LONGITUDE  \\\n",
              "0                  52.315672                   -0.157664   \n",
              "1                  52.315672                   -0.157664   \n",
              "2                  52.315672                   -0.157664   \n",
              "3                  52.315672                   -0.157664   \n",
              "4                  53.764125                   -1.740145   \n",
              "\n",
              "   LAST_DELIVERY_LATITUDE  LAST_DELIVERY_LONGITUDE  \\\n",
              "0               55.877803                -3.648558   \n",
              "1               55.877803                -3.648558   \n",
              "2               55.877803                -3.648558   \n",
              "3               55.877803                -3.648558   \n",
              "4               51.398851                -1.231993   \n",
              "\n",
              "  FIRST_COLLECTION_SCHEDULE_EARLIEST FIRST_COLLECTION_SCHEDULE_LATEST  \\\n",
              "0          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "1          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "2          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "3          2023-10-06 09:45:00+00:00        2023-10-06 10:00:00+00:00   \n",
              "4          2023-12-19 14:20:00+00:00        2023-12-19 16:00:00+00:00   \n",
              "\n",
              "  LAST_DELIVERY_SCHEDULE_EARLIEST LAST_DELIVERY_SCHEDULE_LATEST        LAT  \\\n",
              "0       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316349   \n",
              "1       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316602   \n",
              "2       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316440   \n",
              "3       2023-10-09 09:55:00+00:00     2023-10-09 10:25:00+00:00  52.316544   \n",
              "4       2023-12-20 06:00:00+00:00     2023-12-20 08:56:00+00:00  53.763753   \n",
              "\n",
              "        LON          RECORD_TIMESTAMP  On-Time Delivery SHIPPER_ID  \n",
              "0 -0.156690 2023-10-06 08:58:00+00:00              True        NaN  \n",
              "1 -0.157301 2023-10-06 09:03:00+00:00              True        NaN  \n",
              "2 -0.157995 2023-10-06 09:05:00+00:00              True        NaN  \n",
              "3 -0.157263 2023-10-06 09:24:00+00:00              True        NaN  \n",
              "4 -1.739292 2023-12-19 15:47:00+00:00              True        NaN  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c982d0e6-c414-4b77-a77d-21e236b283ea\" class=\"colab-df-container\">\n",
              "    <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>PROJECT_ID</th>\n",
              "      <th>SHIPMENT_NUMBER</th>\n",
              "      <th>CARRIER_DISPLAY_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>LAST_DELIVERY_LONGITUDE</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "      <th>LAT</th>\n",
              "      <th>LON</th>\n",
              "      <th>RECORD_TIMESTAMP</th>\n",
              "      <th>On-Time Delivery</th>\n",
              "      <th>SHIPPER_ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316349</td>\n",
              "      <td>-0.156690</td>\n",
              "      <td>2023-10-06 08:58:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316602</td>\n",
              "      <td>-0.157301</td>\n",
              "      <td>2023-10-06 09:03:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316440</td>\n",
              "      <td>-0.157995</td>\n",
              "      <td>2023-10-06 09:05:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>5456fcfa-5b0c-428e-b322-240d508b6660</td>\n",
              "      <td>SEZHUK-231005-250448</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>PE29 2XR</td>\n",
              "      <td>EH48 2FB</td>\n",
              "      <td>52.315672</td>\n",
              "      <td>-0.157664</td>\n",
              "      <td>55.877803</td>\n",
              "      <td>-3.648558</td>\n",
              "      <td>2023-10-06 09:45:00+00:00</td>\n",
              "      <td>2023-10-06 10:00:00+00:00</td>\n",
              "      <td>2023-10-09 09:55:00+00:00</td>\n",
              "      <td>2023-10-09 10:25:00+00:00</td>\n",
              "      <td>52.316544</td>\n",
              "      <td>-0.157263</td>\n",
              "      <td>2023-10-06 09:24:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>eb7a9df0-4875-43d8-9060-c79c35eae2fb</td>\n",
              "      <td>SEZHUK-231217-275004</td>\n",
              "      <td>CAUK000660</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Box 44ft</td>\n",
              "      <td>BD5 8LZ</td>\n",
              "      <td>RG19 4BQ</td>\n",
              "      <td>53.764125</td>\n",
              "      <td>-1.740145</td>\n",
              "      <td>51.398851</td>\n",
              "      <td>-1.231993</td>\n",
              "      <td>2023-12-19 14:20:00+00:00</td>\n",
              "      <td>2023-12-19 16:00:00+00:00</td>\n",
              "      <td>2023-12-20 06:00:00+00:00</td>\n",
              "      <td>2023-12-20 08:56:00+00:00</td>\n",
              "      <td>53.763753</td>\n",
              "      <td>-1.739292</td>\n",
              "      <td>2023-12-19 15:47:00+00:00</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c982d0e6-c414-4b77-a77d-21e236b283ea')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-c982d0e6-c414-4b77-a77d-21e236b283ea button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-c982d0e6-c414-4b77-a77d-21e236b283ea');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7a32bb3b-ecc3-473a-b9c4-a26216f66e3a\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7a32bb3b-ecc3-473a-b9c4-a26216f66e3a')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7a32bb3b-ecc3-473a-b9c4-a26216f66e3a button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data"
            }
          },
          "metadata": {},
          "execution_count": 85
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# function that checks for delayed delivery.\n",
        "\n",
        "def delay_time(row):\n",
        "  if row['RECORD_TIMESTAMP'] > row['LAST_DELIVERY_SCHEDULE_LATEST'] + buffer_time:\n",
        "    return \"Alert\"\n",
        "  return \"No Alert\"\n",
        "\n",
        "# create a new column named Delayed Time.\n",
        "data['Delayed_Deliveries'] = data.apply(delay_time,axis=1)\n",
        "# filter data to only shipment that should be notified\n",
        "notify_shipment = data[data['Delayed_Deliveries'] == \"Alert\"]\n",
        "# notify_shipment[['SHIPMENT_NUMBER','SHIPPER_ID','LAST_DELIVERY_SCHEDULE_LATEST', 'Delay_Deliveries']]\n",
        "notify_shipment.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 533
        },
        "collapsed": true,
        "id": "XjOvkhjgiMrP",
        "outputId": "68ccdd3b-877e-4bf8-e8e9-ec1c09e50dd7"
      },
      "execution_count": 91,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                               PROJECT_ID       SHIPMENT_NUMBER  \\\n",
              "793  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "794  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "795  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "796  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "797  40415fe3-e446-4d1e-b141-3698b0dc47f3  SEZHUK-231211-272127   \n",
              "\n",
              "    CARRIER_DISPLAY_ID  VEHICLE_SIZE            VEHICLE_BUILD_UP  \\\n",
              "793         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "794         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "795         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "796         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "797         CAUK000096  Tractor Unit  Curtain-Side 13.6M Trailer   \n",
              "\n",
              "    FIRST_COLLECTION_POST_CODE LAST_DELIVERY_POST_CODE  \\\n",
              "793                   HP22 5BL                NG31 7UH   \n",
              "794                   HP22 5BL                NG31 7UH   \n",
              "795                   HP22 5BL                NG31 7UH   \n",
              "796                   HP22 5BL                NG31 7UH   \n",
              "797                   HP22 5BL                NG31 7UH   \n",
              "\n",
              "     FIRST_COLLECTION_LATITUDE  FIRST_COLLECTION_LONGITUDE  \\\n",
              "793                  51.779657                   -0.772897   \n",
              "794                  51.779657                   -0.772897   \n",
              "795                  51.779657                   -0.772897   \n",
              "796                  51.779657                   -0.772897   \n",
              "797                  51.779657                   -0.772897   \n",
              "\n",
              "     LAST_DELIVERY_LATITUDE  ...  FIRST_COLLECTION_SCHEDULE_EARLIEST  \\\n",
              "793               52.888113  ...           2023-12-13 09:00:00+00:00   \n",
              "794               52.888113  ...           2023-12-13 09:00:00+00:00   \n",
              "795               52.888113  ...           2023-12-13 09:00:00+00:00   \n",
              "796               52.888113  ...           2023-12-13 09:00:00+00:00   \n",
              "797               52.888113  ...           2023-12-13 09:00:00+00:00   \n",
              "\n",
              "    FIRST_COLLECTION_SCHEDULE_LATEST LAST_DELIVERY_SCHEDULE_EARLIEST  \\\n",
              "793        2023-12-13 09:30:00+00:00       2023-12-13 15:30:00+00:00   \n",
              "794        2023-12-13 09:30:00+00:00       2023-12-13 15:30:00+00:00   \n",
              "795        2023-12-13 09:30:00+00:00       2023-12-13 15:30:00+00:00   \n",
              "796        2023-12-13 09:30:00+00:00       2023-12-13 15:30:00+00:00   \n",
              "797        2023-12-13 09:30:00+00:00       2023-12-13 15:30:00+00:00   \n",
              "\n",
              "    LAST_DELIVERY_SCHEDULE_LATEST        LAT       LON  \\\n",
              "793     2023-12-13 16:00:00+00:00  52.889578 -0.634969   \n",
              "794     2023-12-13 16:00:00+00:00  52.889929 -0.636091   \n",
              "795     2023-12-13 16:00:00+00:00  52.891457 -0.635607   \n",
              "796     2023-12-13 16:00:00+00:00  52.890664 -0.633919   \n",
              "797     2023-12-13 16:00:00+00:00  52.890594 -0.634765   \n",
              "\n",
              "             RECORD_TIMESTAMP On-Time Delivery  SHIPPER_ID Delayed_Deliveries  \n",
              "793 2023-12-13 16:32:00+00:00            False         NaN              Alert  \n",
              "794 2023-12-13 16:33:00+00:00            False         NaN              Alert  \n",
              "795 2023-12-13 16:34:00+00:00            False         NaN              Alert  \n",
              "796 2023-12-13 16:42:00+00:00            False         NaN              Alert  \n",
              "797 2023-12-13 16:46:00+00:00            False         NaN              Alert  \n",
              "\n",
              "[5 rows x 21 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-45a9e143-9682-4da5-a7f1-c16bd100ccbe\" class=\"colab-df-container\">\n",
              "    <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>PROJECT_ID</th>\n",
              "      <th>SHIPMENT_NUMBER</th>\n",
              "      <th>CARRIER_DISPLAY_ID</th>\n",
              "      <th>VEHICLE_SIZE</th>\n",
              "      <th>VEHICLE_BUILD_UP</th>\n",
              "      <th>FIRST_COLLECTION_POST_CODE</th>\n",
              "      <th>LAST_DELIVERY_POST_CODE</th>\n",
              "      <th>FIRST_COLLECTION_LATITUDE</th>\n",
              "      <th>FIRST_COLLECTION_LONGITUDE</th>\n",
              "      <th>LAST_DELIVERY_LATITUDE</th>\n",
              "      <th>...</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_EARLIEST</th>\n",
              "      <th>FIRST_COLLECTION_SCHEDULE_LATEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_EARLIEST</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "      <th>LAT</th>\n",
              "      <th>LON</th>\n",
              "      <th>RECORD_TIMESTAMP</th>\n",
              "      <th>On-Time Delivery</th>\n",
              "      <th>SHIPPER_ID</th>\n",
              "      <th>Delayed_Deliveries</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>793</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>...</td>\n",
              "      <td>2023-12-13 09:00:00+00:00</td>\n",
              "      <td>2023-12-13 09:30:00+00:00</td>\n",
              "      <td>2023-12-13 15:30:00+00:00</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>52.889578</td>\n",
              "      <td>-0.634969</td>\n",
              "      <td>2023-12-13 16:32:00+00:00</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>794</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>...</td>\n",
              "      <td>2023-12-13 09:00:00+00:00</td>\n",
              "      <td>2023-12-13 09:30:00+00:00</td>\n",
              "      <td>2023-12-13 15:30:00+00:00</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>52.889929</td>\n",
              "      <td>-0.636091</td>\n",
              "      <td>2023-12-13 16:33:00+00:00</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>...</td>\n",
              "      <td>2023-12-13 09:00:00+00:00</td>\n",
              "      <td>2023-12-13 09:30:00+00:00</td>\n",
              "      <td>2023-12-13 15:30:00+00:00</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>52.891457</td>\n",
              "      <td>-0.635607</td>\n",
              "      <td>2023-12-13 16:34:00+00:00</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>...</td>\n",
              "      <td>2023-12-13 09:00:00+00:00</td>\n",
              "      <td>2023-12-13 09:30:00+00:00</td>\n",
              "      <td>2023-12-13 15:30:00+00:00</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>52.890664</td>\n",
              "      <td>-0.633919</td>\n",
              "      <td>2023-12-13 16:42:00+00:00</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>40415fe3-e446-4d1e-b141-3698b0dc47f3</td>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>CAUK000096</td>\n",
              "      <td>Tractor Unit</td>\n",
              "      <td>Curtain-Side 13.6M Trailer</td>\n",
              "      <td>HP22 5BL</td>\n",
              "      <td>NG31 7UH</td>\n",
              "      <td>51.779657</td>\n",
              "      <td>-0.772897</td>\n",
              "      <td>52.888113</td>\n",
              "      <td>...</td>\n",
              "      <td>2023-12-13 09:00:00+00:00</td>\n",
              "      <td>2023-12-13 09:30:00+00:00</td>\n",
              "      <td>2023-12-13 15:30:00+00:00</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>52.890594</td>\n",
              "      <td>-0.634765</td>\n",
              "      <td>2023-12-13 16:46:00+00:00</td>\n",
              "      <td>False</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 21 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-45a9e143-9682-4da5-a7f1-c16bd100ccbe')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-45a9e143-9682-4da5-a7f1-c16bd100ccbe button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-45a9e143-9682-4da5-a7f1-c16bd100ccbe');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-aa2fea0e-8f8f-44cd-96cd-5ce44a9dbe79\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-aa2fea0e-8f8f-44cd-96cd-5ce44a9dbe79')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-aa2fea0e-8f8f-44cd-96cd-5ce44a9dbe79 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "notify_shipment"
            }
          },
          "metadata": {},
          "execution_count": 91
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "notify_shipment[['SHIPMENT_NUMBER','SHIPPER_ID','LAST_DELIVERY_SCHEDULE_LATEST', 'Delayed_Deliveries']]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "Myf4uJLWl4yU",
        "outputId": "54b62ef8-aace-444a-ce44-15c3c137a564"
      },
      "execution_count": 92,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             SHIPMENT_NUMBER SHIPPER_ID LAST_DELIVERY_SCHEDULE_LATEST  \\\n",
              "793     SEZHUK-231211-272127        NaN     2023-12-13 16:00:00+00:00   \n",
              "794     SEZHUK-231211-272127        NaN     2023-12-13 16:00:00+00:00   \n",
              "795     SEZHUK-231211-272127        NaN     2023-12-13 16:00:00+00:00   \n",
              "796     SEZHUK-231211-272127        NaN     2023-12-13 16:00:00+00:00   \n",
              "797     SEZHUK-231211-272127        NaN     2023-12-13 16:00:00+00:00   \n",
              "...                      ...        ...                           ...   \n",
              "641190  SEZHUK-231014-253126        NaN     2023-10-15 17:03:01+00:00   \n",
              "641191  SEZHUK-231014-253126        NaN     2023-10-15 17:03:01+00:00   \n",
              "641192  SEZHUK-231014-253126        NaN     2023-10-15 17:03:01+00:00   \n",
              "641193  SEZHUK-231014-253126        NaN     2023-10-15 17:03:01+00:00   \n",
              "641194  SEZHUK-231014-253126        NaN     2023-10-15 17:03:01+00:00   \n",
              "\n",
              "       Delayed_Deliveries  \n",
              "793                 Alert  \n",
              "794                 Alert  \n",
              "795                 Alert  \n",
              "796                 Alert  \n",
              "797                 Alert  \n",
              "...                   ...  \n",
              "641190              Alert  \n",
              "641191              Alert  \n",
              "641192              Alert  \n",
              "641193              Alert  \n",
              "641194              Alert  \n",
              "\n",
              "[159135 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3c64feb1-0bfb-4d7c-9198-eb3e0a95fe3e\" class=\"colab-df-container\">\n",
              "    <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>SHIPMENT_NUMBER</th>\n",
              "      <th>SHIPPER_ID</th>\n",
              "      <th>LAST_DELIVERY_SCHEDULE_LATEST</th>\n",
              "      <th>Delayed_Deliveries</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>793</th>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>794</th>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>795</th>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>796</th>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>797</th>\n",
              "      <td>SEZHUK-231211-272127</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-12-13 16:00:00+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>641190</th>\n",
              "      <td>SEZHUK-231014-253126</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-10-15 17:03:01+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>641191</th>\n",
              "      <td>SEZHUK-231014-253126</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-10-15 17:03:01+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>641192</th>\n",
              "      <td>SEZHUK-231014-253126</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-10-15 17:03:01+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>641193</th>\n",
              "      <td>SEZHUK-231014-253126</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-10-15 17:03:01+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>641194</th>\n",
              "      <td>SEZHUK-231014-253126</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2023-10-15 17:03:01+00:00</td>\n",
              "      <td>Alert</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>159135 rows × 4 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3c64feb1-0bfb-4d7c-9198-eb3e0a95fe3e')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-3c64feb1-0bfb-4d7c-9198-eb3e0a95fe3e button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-3c64feb1-0bfb-4d7c-9198-eb3e0a95fe3e');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-351e0737-7a58-4d9d-9270-90cd74436390\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-351e0737-7a58-4d9d-9270-90cd74436390')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-351e0737-7a58-4d9d-9270-90cd74436390 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe"
            }
          },
          "metadata": {},
          "execution_count": 92
        }
      ]
    }
  ]
}