StarterNotebook.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "48G-1fAIJ-Ml"
      },
      "outputs": [],
      "source": [
        "import pandas as  pd \n",
        "import numpy as np \n",
        "import requests, zipfile"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def download(file):\n",
        "  #the url and auth_value from the website \n",
        "  url = f\"https://api.zindi.africa/v1/competitions/next-gen-wifi-throughput-prediction-challenge/files/{file}\"\n",
        "  myobj = {'auth_token': \"x7nYdKyCrmLZfSkD3GJBxNkQ\"} \n",
        "\n",
        "  x = requests.post(url, data = myobj,stream=True)\n",
        "  target_path = file\n",
        "\n",
        "  handle = open(target_path, \"wb\")\n",
        "  for chunk in x.iter_content(chunk_size=512):\n",
        "      if chunk:  # filter out keep-alive new chunks\n",
        "          handle.write(chunk)\n",
        "  handle.close()"
      ],
      "metadata": {
        "id": "gg9plsVAKL1R"
      },
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "download('Test.csv')\n",
        "download('Train.csv')\n",
        "download('TrainTargets.csv')\n",
        "download('SampleSubmission.csv')"
      ],
      "metadata": {
        "id": "_6E5foRtKPwv"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def preprocess(data,is_train=True):\n",
        "\n",
        "  dep=data['Deployment'].unique()\n",
        "  rows=[]\n",
        "  for dd in dep:\n",
        "    df=data[data.Deployment==dd]\n",
        "    \n",
        "    toxp_map=dict()\n",
        "    rssi_map=dict()\n",
        "    flag=0\n",
        "    for i, j in df.iterrows():\n",
        "        if('STA' in j[0]):\n",
        "          rssi_map[j[0]]={f'AP{i}':j[i] for i in range(1,10)}\n",
        "        else:\n",
        "          toxp_map[j[0]]={(j.index[i],'STA'+str(int(j[i]))) for i in range(1,10)}\n",
        "\n",
        "    \n",
        "    for exp,elems in toxp_map.items():\n",
        "      rows1=[]\n",
        "      for e in elems:\n",
        "        row=[dd,exp]\n",
        "        if(e[-1]!='STA0'):\n",
        "          row.extend([e[0],e[1],rssi_map[e[-1]][e[0]]])\n",
        "          rows.append(row)\n",
        "  \n",
        "\n",
        "      #rows.extend(rows1)\n",
        "    \n",
        "  data=pd.DataFrame(rows)\n",
        "  data.columns = ['Deployment','TXOP','mainAP','mainSTA','mainRSSI']\n",
        "  data['ID']='Deployment'+data['Deployment'].astype(str)+'_'+data['TXOP']+'_'+data['mainAP']+'_'+data['mainSTA']\n",
        "  if(is_train):\n",
        "    tt=pd.read_csv('TrainTargets.csv')\n",
        "    data=pd.merge(data,tt,on='ID')\n",
        "  \n",
        "  \n",
        "  return data\n",
        "  \n",
        "\n",
        "\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "id": "oLVYv91EKSho"
      },
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "train=pd.read_csv('Train.csv')\n",
        "train=preprocess(train)"
      ],
      "metadata": {
        "id": "2uCBB3uuK3xc"
      },
      "execution_count": 5,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "train"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "Vo_aY9WmK6KV",
        "outputId": "b1760c1d-1e62-469f-9e97-3cd86e4b4f88"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "         Deployment     TXOP mainAP mainSTA  mainRSSI  \\\n",
              "0              9391    TXOP1    AP2    STA2    -67.19   \n",
              "1              9391    TXOP1    AP7    STA7    -63.71   \n",
              "2              9391    TXOP1    AP1    STA1    -64.87   \n",
              "3              9391    TXOP1    AP5    STA5    -66.72   \n",
              "4              9391    TXOP2    AP6    STA6    -65.12   \n",
              "...             ...      ...    ...     ...       ...   \n",
              "1749591        3934   TXOP99    AP1    STA2    -65.12   \n",
              "1749592        3934  TXOP100    AP8   STA15    -67.62   \n",
              "1749593        3934  TXOP100    AP2    STA3    -52.57   \n",
              "1749594        3934  TXOP100    AP5    STA9    -64.87   \n",
              "1749595        3934  TXOP100    AP4    STA7    -66.72   \n",
              "\n",
              "                                       ID  Target  \n",
              "0           Deployment9391_TXOP1_AP2_STA2     0.0  \n",
              "1           Deployment9391_TXOP1_AP7_STA7   108.0  \n",
              "2           Deployment9391_TXOP1_AP1_STA1    30.0  \n",
              "3           Deployment9391_TXOP1_AP5_STA5    54.0  \n",
              "4           Deployment9391_TXOP2_AP6_STA6   156.0  \n",
              "...                                   ...     ...  \n",
              "1749591    Deployment3934_TXOP99_AP1_STA2   312.0  \n",
              "1749592  Deployment3934_TXOP100_AP8_STA15     0.0  \n",
              "1749593   Deployment3934_TXOP100_AP2_STA3   156.0  \n",
              "1749594   Deployment3934_TXOP100_AP5_STA9     0.0  \n",
              "1749595   Deployment3934_TXOP100_AP4_STA7    30.0  \n",
              "\n",
              "[1749596 rows x 7 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5c6eca4e-8282-4860-b7d9-a29a9036f30f\">\n",
              "    <div 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>Deployment</th>\n",
              "      <th>TXOP</th>\n",
              "      <th>mainAP</th>\n",
              "      <th>mainSTA</th>\n",
              "      <th>mainRSSI</th>\n",
              "      <th>ID</th>\n",
              "      <th>Target</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>9391</td>\n",
              "      <td>TXOP1</td>\n",
              "      <td>AP2</td>\n",
              "      <td>STA2</td>\n",
              "      <td>-67.19</td>\n",
              "      <td>Deployment9391_TXOP1_AP2_STA2</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>9391</td>\n",
              "      <td>TXOP1</td>\n",
              "      <td>AP7</td>\n",
              "      <td>STA7</td>\n",
              "      <td>-63.71</td>\n",
              "      <td>Deployment9391_TXOP1_AP7_STA7</td>\n",
              "      <td>108.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>9391</td>\n",
              "      <td>TXOP1</td>\n",
              "      <td>AP1</td>\n",
              "      <td>STA1</td>\n",
              "      <td>-64.87</td>\n",
              "      <td>Deployment9391_TXOP1_AP1_STA1</td>\n",
              "      <td>30.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>9391</td>\n",
              "      <td>TXOP1</td>\n",
              "      <td>AP5</td>\n",
              "      <td>STA5</td>\n",
              "      <td>-66.72</td>\n",
              "      <td>Deployment9391_TXOP1_AP5_STA5</td>\n",
              "      <td>54.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>9391</td>\n",
              "      <td>TXOP2</td>\n",
              "      <td>AP6</td>\n",
              "      <td>STA6</td>\n",
              "      <td>-65.12</td>\n",
              "      <td>Deployment9391_TXOP2_AP6_STA6</td>\n",
              "      <td>156.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1749591</th>\n",
              "      <td>3934</td>\n",
              "      <td>TXOP99</td>\n",
              "      <td>AP1</td>\n",
              "      <td>STA2</td>\n",
              "      <td>-65.12</td>\n",
              "      <td>Deployment3934_TXOP99_AP1_STA2</td>\n",
              "      <td>312.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1749592</th>\n",
              "      <td>3934</td>\n",
              "      <td>TXOP100</td>\n",
              "      <td>AP8</td>\n",
              "      <td>STA15</td>\n",
              "      <td>-67.62</td>\n",
              "      <td>Deployment3934_TXOP100_AP8_STA15</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1749593</th>\n",
              "      <td>3934</td>\n",
              "      <td>TXOP100</td>\n",
              "      <td>AP2</td>\n",
              "      <td>STA3</td>\n",
              "      <td>-52.57</td>\n",
              "      <td>Deployment3934_TXOP100_AP2_STA3</td>\n",
              "      <td>156.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1749594</th>\n",
              "      <td>3934</td>\n",
              "      <td>TXOP100</td>\n",
              "      <td>AP5</td>\n",
              "      <td>STA9</td>\n",
              "      <td>-64.87</td>\n",
              "      <td>Deployment3934_TXOP100_AP5_STA9</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1749595</th>\n",
              "      <td>3934</td>\n",
              "      <td>TXOP100</td>\n",
              "      <td>AP4</td>\n",
              "      <td>STA7</td>\n",
              "      <td>-66.72</td>\n",
              "      <td>Deployment3934_TXOP100_AP4_STA7</td>\n",
              "      <td>30.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1749596 rows × 7 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5c6eca4e-8282-4860-b7d9-a29a9036f30f')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-5c6eca4e-8282-4860-b7d9-a29a9036f30f 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-5c6eca4e-8282-4860-b7d9-a29a9036f30f');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "test=pd.read_csv('Test.csv')\n",
        "test=preprocess(test,False)"
      ],
      "metadata": {
        "id": "_2c_DaI5K70Q"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "test"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "CgETJctUL1Lf",
        "outputId": "15aa95a7-905c-473c-a443-47c4b44854ca"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        Deployment     TXOP mainAP mainSTA  mainRSSI  \\\n",
              "0             9373    TXOP1    AP9   STA35    -69.12   \n",
              "1             9373    TXOP2    AP1    STA3    -67.19   \n",
              "2             9373    TXOP2    AP3    STA9    -63.71   \n",
              "3             9373    TXOP2    AP4   STA13    -64.87   \n",
              "4             9373    TXOP3    AP4   STA14    -65.58   \n",
              "...            ...      ...    ...     ...       ...   \n",
              "749919        5144   TXOP98    AP5   STA10    -67.62   \n",
              "749920        5144   TXOP99    AP3    STA5    -63.71   \n",
              "749921        5144   TXOP99    AP9   STA17    -65.58   \n",
              "749922        5144  TXOP100    AP8   STA16    -64.61   \n",
              "749923        5144  TXOP100    AP4    STA7    -69.12   \n",
              "\n",
              "                                      ID  \n",
              "0         Deployment9373_TXOP1_AP9_STA35  \n",
              "1          Deployment9373_TXOP2_AP1_STA3  \n",
              "2          Deployment9373_TXOP2_AP3_STA9  \n",
              "3         Deployment9373_TXOP2_AP4_STA13  \n",
              "4         Deployment9373_TXOP3_AP4_STA14  \n",
              "...                                  ...  \n",
              "749919   Deployment5144_TXOP98_AP5_STA10  \n",
              "749920    Deployment5144_TXOP99_AP3_STA5  \n",
              "749921   Deployment5144_TXOP99_AP9_STA17  \n",
              "749922  Deployment5144_TXOP100_AP8_STA16  \n",
              "749923   Deployment5144_TXOP100_AP4_STA7  \n",
              "\n",
              "[749924 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f061c8ab-d49d-46f7-be8d-c661740aa926\">\n",
              "    <div 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>Deployment</th>\n",
              "      <th>TXOP</th>\n",
              "      <th>mainAP</th>\n",
              "      <th>mainSTA</th>\n",
              "      <th>mainRSSI</th>\n",
              "      <th>ID</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>9373</td>\n",
              "      <td>TXOP1</td>\n",
              "      <td>AP9</td>\n",
              "      <td>STA35</td>\n",
              "      <td>-69.12</td>\n",
              "      <td>Deployment9373_TXOP1_AP9_STA35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>9373</td>\n",
              "      <td>TXOP2</td>\n",
              "      <td>AP1</td>\n",
              "      <td>STA3</td>\n",
              "      <td>-67.19</td>\n",
              "      <td>Deployment9373_TXOP2_AP1_STA3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>9373</td>\n",
              "      <td>TXOP2</td>\n",
              "      <td>AP3</td>\n",
              "      <td>STA9</td>\n",
              "      <td>-63.71</td>\n",
              "      <td>Deployment9373_TXOP2_AP3_STA9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>9373</td>\n",
              "      <td>TXOP2</td>\n",
              "      <td>AP4</td>\n",
              "      <td>STA13</td>\n",
              "      <td>-64.87</td>\n",
              "      <td>Deployment9373_TXOP2_AP4_STA13</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>9373</td>\n",
              "      <td>TXOP3</td>\n",
              "      <td>AP4</td>\n",
              "      <td>STA14</td>\n",
              "      <td>-65.58</td>\n",
              "      <td>Deployment9373_TXOP3_AP4_STA14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749919</th>\n",
              "      <td>5144</td>\n",
              "      <td>TXOP98</td>\n",
              "      <td>AP5</td>\n",
              "      <td>STA10</td>\n",
              "      <td>-67.62</td>\n",
              "      <td>Deployment5144_TXOP98_AP5_STA10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749920</th>\n",
              "      <td>5144</td>\n",
              "      <td>TXOP99</td>\n",
              "      <td>AP3</td>\n",
              "      <td>STA5</td>\n",
              "      <td>-63.71</td>\n",
              "      <td>Deployment5144_TXOP99_AP3_STA5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749921</th>\n",
              "      <td>5144</td>\n",
              "      <td>TXOP99</td>\n",
              "      <td>AP9</td>\n",
              "      <td>STA17</td>\n",
              "      <td>-65.58</td>\n",
              "      <td>Deployment5144_TXOP99_AP9_STA17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749922</th>\n",
              "      <td>5144</td>\n",
              "      <td>TXOP100</td>\n",
              "      <td>AP8</td>\n",
              "      <td>STA16</td>\n",
              "      <td>-64.61</td>\n",
              "      <td>Deployment5144_TXOP100_AP8_STA16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749923</th>\n",
              "      <td>5144</td>\n",
              "      <td>TXOP100</td>\n",
              "      <td>AP4</td>\n",
              "      <td>STA7</td>\n",
              "      <td>-69.12</td>\n",
              "      <td>Deployment5144_TXOP100_AP4_STA7</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>749924 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f061c8ab-d49d-46f7-be8d-c661740aa926')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-f061c8ab-d49d-46f7-be8d-c661740aa926 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-f061c8ab-d49d-46f7-be8d-c661740aa926');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from lightgbm import LGBMRegressor\n",
        "from sklearn.model_selection import KFold\n",
        "from sklearn.metrics import mean_squared_error as mse\n",
        "\n",
        "\n",
        "folds = KFold(n_splits = 5)\n",
        "\n",
        "predictions = []\n",
        "losses = []\n",
        "X=train[['mainRSSI']]\n",
        "y=train['Target']\n",
        "X_ts=test[['mainRSSI']]\n",
        "\n",
        "for i,( train_index, test_index) in enumerate(folds.split(X, y)):\n",
        "  print(50*'--')\n",
        "  print(f'Fold {i+1}/5')\n",
        "  print(50*'--')\n",
        "  X_train, X_test, y_train, y_test = X.iloc[train_index], X.iloc[test_index], y.iloc[train_index], y.iloc[test_index]\n",
        "\n",
        "  # Train model\n",
        "  model =LGBMRegressor(n_estimators=1000)\n",
        "  model.fit(X_train,y_train)\n",
        "  # Make predictions\n",
        "  preds = model.predict(X_ts)\n",
        "  y_pred = model.predict(X_test)\n",
        "  # Append predictions and losses\n",
        "  predictions.append(preds)\n",
        "  loss = mse(y_test, y_pred,squared=False)\n",
        "  # Print loss\n",
        "  print(f'{i+1}:  {loss}\\n')\n",
        "  losses.append(loss)\n",
        "  \n",
        "print(f'Mean loss  {np.mean(losses)}')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "eOUkKV2_Lf_h",
        "outputId": "35fa8734-a8be-41e8-934a-e83261fc9cf4"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "----------------------------------------------------------------------------------------------------\n",
            "Fold 1/5\n",
            "----------------------------------------------------------------------------------------------------\n",
            "1:  86.28696925882939\n",
            "\n",
            "----------------------------------------------------------------------------------------------------\n",
            "Fold 2/5\n",
            "----------------------------------------------------------------------------------------------------\n",
            "2:  86.40892571217763\n",
            "\n",
            "----------------------------------------------------------------------------------------------------\n",
            "Fold 3/5\n",
            "----------------------------------------------------------------------------------------------------\n",
            "3:  86.44284373162247\n",
            "\n",
            "----------------------------------------------------------------------------------------------------\n",
            "Fold 4/5\n",
            "----------------------------------------------------------------------------------------------------\n",
            "4:  86.23226568054274\n",
            "\n",
            "----------------------------------------------------------------------------------------------------\n",
            "Fold 5/5\n",
            "----------------------------------------------------------------------------------------------------\n",
            "5:  86.5914931955002\n",
            "\n",
            "Mean loss  86.3924995157345\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#Making submission\n",
        "ss=test[['ID']]\n",
        "ss['Target']=np.mean(predictions,0)\n",
        "ss"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 521
        },
        "id": "A5L4H-nbL35F",
        "outputId": "cb5c6b63-d114-4c40-a8e9-89454aa2eba1"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-11-e0c206ac8ddd>:3: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  ss['Target']=np.mean(predictions,0)\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                      ID      Target\n",
              "0         Deployment9373_TXOP1_AP9_STA35   68.565325\n",
              "1          Deployment9373_TXOP2_AP1_STA3   79.698668\n",
              "2          Deployment9373_TXOP2_AP3_STA9  114.407521\n",
              "3         Deployment9373_TXOP2_AP4_STA13  101.279049\n",
              "4         Deployment9373_TXOP3_AP4_STA14   89.033458\n",
              "...                                  ...         ...\n",
              "749919   Deployment5144_TXOP98_AP5_STA10   73.680251\n",
              "749920    Deployment5144_TXOP99_AP3_STA5  114.407521\n",
              "749921   Deployment5144_TXOP99_AP9_STA17   89.033458\n",
              "749922  Deployment5144_TXOP100_AP8_STA16  102.776802\n",
              "749923   Deployment5144_TXOP100_AP4_STA7   68.565325\n",
              "\n",
              "[749924 rows x 2 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-eede191c-3ee4-4d7f-97cc-9c5d8be3474e\">\n",
              "    <div 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>ID</th>\n",
              "      <th>Target</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Deployment9373_TXOP1_AP9_STA35</td>\n",
              "      <td>68.565325</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Deployment9373_TXOP2_AP1_STA3</td>\n",
              "      <td>79.698668</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Deployment9373_TXOP2_AP3_STA9</td>\n",
              "      <td>114.407521</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Deployment9373_TXOP2_AP4_STA13</td>\n",
              "      <td>101.279049</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Deployment9373_TXOP3_AP4_STA14</td>\n",
              "      <td>89.033458</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749919</th>\n",
              "      <td>Deployment5144_TXOP98_AP5_STA10</td>\n",
              "      <td>73.680251</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749920</th>\n",
              "      <td>Deployment5144_TXOP99_AP3_STA5</td>\n",
              "      <td>114.407521</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749921</th>\n",
              "      <td>Deployment5144_TXOP99_AP9_STA17</td>\n",
              "      <td>89.033458</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749922</th>\n",
              "      <td>Deployment5144_TXOP100_AP8_STA16</td>\n",
              "      <td>102.776802</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749923</th>\n",
              "      <td>Deployment5144_TXOP100_AP4_STA7</td>\n",
              "      <td>68.565325</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>749924 rows × 2 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-eede191c-3ee4-4d7f-97cc-9c5d8be3474e')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-eede191c-3ee4-4d7f-97cc-9c5d8be3474e 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-eede191c-3ee4-4d7f-97cc-9c5d8be3474e');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "ss['Target']=ss['Target'].astype(np.float16)#Otherwise file will be too large"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "C24tpS3MMNLY",
        "outputId": "e1c05e2e-d1a0-4cb6-ae64-df97fc7d2b47"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-12-0be4644114fd>:1: SettingWithCopyWarning: \n",
            "A value is trying to be set on a copy of a slice from a DataFrame.\n",
            "Try using .loc[row_indexer,col_indexer] = value instead\n",
            "\n",
            "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
            "  ss['Target']=ss['Target'].astype(np.float16)#Otherwise file will be too large\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "ss.to_csv('ss.csv',index=False)"
      ],
      "metadata": {
        "id": "3hzrK6bCMsfV"
      },
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "ss"
      ],
      "metadata": {
        "id": "rUaAVGytOSvJ",
        "outputId": "9c950459-b24f-4ccd-b9ea-ca993deaedd6",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        }
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                      ID    Target\n",
              "0         Deployment9373_TXOP1_AP9_STA35   68.5625\n",
              "1          Deployment9373_TXOP2_AP1_STA3   79.6875\n",
              "2          Deployment9373_TXOP2_AP3_STA9  114.4375\n",
              "3         Deployment9373_TXOP2_AP4_STA13  101.2500\n",
              "4         Deployment9373_TXOP3_AP4_STA14   89.0625\n",
              "...                                  ...       ...\n",
              "749919   Deployment5144_TXOP98_AP5_STA10   73.6875\n",
              "749920    Deployment5144_TXOP99_AP3_STA5  114.4375\n",
              "749921   Deployment5144_TXOP99_AP9_STA17   89.0625\n",
              "749922  Deployment5144_TXOP100_AP8_STA16  102.7500\n",
              "749923   Deployment5144_TXOP100_AP4_STA7   68.5625\n",
              "\n",
              "[749924 rows x 2 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-aa60b913-55e5-4b54-a714-c4b8a434878c\">\n",
              "    <div 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>ID</th>\n",
              "      <th>Target</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Deployment9373_TXOP1_AP9_STA35</td>\n",
              "      <td>68.5625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Deployment9373_TXOP2_AP1_STA3</td>\n",
              "      <td>79.6875</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Deployment9373_TXOP2_AP3_STA9</td>\n",
              "      <td>114.4375</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Deployment9373_TXOP2_AP4_STA13</td>\n",
              "      <td>101.2500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Deployment9373_TXOP3_AP4_STA14</td>\n",
              "      <td>89.0625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749919</th>\n",
              "      <td>Deployment5144_TXOP98_AP5_STA10</td>\n",
              "      <td>73.6875</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749920</th>\n",
              "      <td>Deployment5144_TXOP99_AP3_STA5</td>\n",
              "      <td>114.4375</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749921</th>\n",
              "      <td>Deployment5144_TXOP99_AP9_STA17</td>\n",
              "      <td>89.0625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749922</th>\n",
              "      <td>Deployment5144_TXOP100_AP8_STA16</td>\n",
              "      <td>102.7500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>749923</th>\n",
              "      <td>Deployment5144_TXOP100_AP4_STA7</td>\n",
              "      <td>68.5625</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>749924 rows × 2 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-aa60b913-55e5-4b54-a714-c4b8a434878c')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-aa60b913-55e5-4b54-a714-c4b8a434878c 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-aa60b913-55e5-4b54-a714-c4b8a434878c');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "dygpf6dQOTli"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}