MozCon_GSC_Impressions_|_Data_Skeptic.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "MozCon - GSC Impressions | Data Skeptic",
      "provenance": [],
      "collapsed_sections": [
        "gEK0vIyQvPcF",
        "Phl9tt-7e1zK",
        "xK81OVKjV1Xw",
        "fxGVedYcWbba",
        "OfdcVN93XTU1"
      ],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/BritneyMuller/colab-notebooks/blob/master/MozCon_GSC_Impressions_%7C_Data_Skeptic.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "W6LXKzHpEcKJ"
      },
      "source": [
        "## Power Up Your Data Skeptic Skills!!!\n",
        "[Make a copy of this notebook]\n",
        "\n",
        "\n",
        "📄 **Pages:**\n",
        "- What pages are ranking for the same keywords (cannibalization)\n",
        "- What pages have dropped in performance?\n",
        "- What pages have improved?\n",
        "- What are the top page categories on your site?\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "\n",
        "---\n",
        "\n",
        "\n",
        "\n",
        "---\n",
        "\n",
        "###+Shoutout to [Masaki Okazawa](https://twitter.com/saksters) who built several of these sections for a @RankSense #RSTWittorial\n",
        "[Catch the genius thread & Notebook here.](https://twitter.com/saksters/status/1364991835425406976?s=20)\n",
        "\n",
        "*Modifications, additions, and errors by Britney Muller*\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "gEK0vIyQvPcF"
      },
      "source": [
        "##Pull Website Data\n",
        "\n",
        "- Connect GSC to GDS: Export the bottom Landing Page Query Report as CSV: \n",
        "\n",
        "https://datastudio.google.com/reporting/53fe5326-d1f7-41a4-8796-b6d65c1215e6\n",
        "\n",
        "(May-vs-april-landing-pages.csv)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "w_jjPG9KUDlt"
      },
      "source": [
        "###Import Libraries"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "MjOfszX_Utg3"
      },
      "source": [
        "import csv\n",
        "import json\n",
        "import requests\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import re\n",
        "import seaborn as sns\n",
        "from matplotlib import pyplot as plt\n",
        "\n",
        "from IPython.display import display"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "rDHDoPp8Tt-k"
      },
      "source": [
        "###Upload CSV\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "53mZDHPPSOF_",
        "colab": {
          "resources": {
            "http://localhost:8080/nbextensions/google.colab/files.js": {
              "data": "Ly8gQ29weXJpZ2h0IDIwMTcgR29vZ2xlIExMQwovLwovLyBMaWNlbnNlZCB1bmRlciB0aGUgQXBhY2hlIExpY2Vuc2UsIFZlcnNpb24gMi4wICh0aGUgIkxpY2Vuc2UiKTsKLy8geW91IG1heSBub3QgdXNlIHRoaXMgZmlsZSBleGNlcHQgaW4gY29tcGxpYW5jZSB3aXRoIHRoZSBMaWNlbnNlLgovLyBZb3UgbWF5IG9idGFpbiBhIGNvcHkgb2YgdGhlIExpY2Vuc2UgYXQKLy8KLy8gICAgICBodHRwOi8vd3d3LmFwYWNoZS5vcmcvbGljZW5zZXMvTElDRU5TRS0yLjAKLy8KLy8gVW5sZXNzIHJlcXVpcmVkIGJ5IGFwcGxpY2FibGUgbGF3IG9yIGFncmVlZCB0byBpbiB3cml0aW5nLCBzb2Z0d2FyZQovLyBkaXN0cmlidXRlZCB1bmRlciB0aGUgTGljZW5zZSBpcyBkaXN0cmlidXRlZCBvbiBhbiAiQVMgSVMiIEJBU0lTLAovLyBXSVRIT1VUIFdBUlJBTlRJRVMgT1IgQ09ORElUSU9OUyBPRiBBTlkgS0lORCwgZWl0aGVyIGV4cHJlc3Mgb3IgaW1wbGllZC4KLy8gU2VlIHRoZSBMaWNlbnNlIGZvciB0aGUgc3BlY2lmaWMgbGFuZ3VhZ2UgZ292ZXJuaW5nIHBlcm1pc3Npb25zIGFuZAovLyBsaW1pdGF0aW9ucyB1bmRlciB0aGUgTGljZW5zZS4KCi8qKgogKiBAZmlsZW92ZXJ2aWV3IEhlbHBlcnMgZm9yIGdvb2dsZS5jb2xhYiBQeXRob24gbW9kdWxlLgogKi8KKGZ1bmN0aW9uKHNjb3BlKSB7CmZ1bmN0aW9uIHNwYW4odGV4dCwgc3R5bGVBdHRyaWJ1dGVzID0ge30pIHsKICBjb25zdCBlbGVtZW50ID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgnc3BhbicpOwogIGVsZW1lbnQudGV4dENvbnRlbnQgPSB0ZXh0OwogIGZvciAoY29uc3Qga2V5IG9mIE9iamVjdC5rZXlzKHN0eWxlQXR0cmlidXRlcykpIHsKICAgIGVsZW1lbnQuc3R5bGVba2V5XSA9IHN0eWxlQXR0cmlidXRlc1trZXldOwogIH0KICByZXR1cm4gZWxlbWVudDsKfQoKLy8gTWF4IG51bWJlciBvZiBieXRlcyB3aGljaCB3aWxsIGJlIHVwbG9hZGVkIGF0IGEgdGltZS4KY29uc3QgTUFYX1BBWUxPQURfU0laRSA9IDEwMCAqIDEwMjQ7CgpmdW5jdGlvbiBfdXBsb2FkRmlsZXMoaW5wdXRJZCwgb3V0cHV0SWQpIHsKICBjb25zdCBzdGVwcyA9IHVwbG9hZEZpbGVzU3RlcChpbnB1dElkLCBvdXRwdXRJZCk7CiAgY29uc3Qgb3V0cHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKG91dHB1dElkKTsKICAvLyBDYWNoZSBzdGVwcyBvbiB0aGUgb3V0cHV0RWxlbWVudCB0byBtYWtlIGl0IGF2YWlsYWJsZSBmb3IgdGhlIG5leHQgY2FsbAogIC8vIHRvIHVwbG9hZEZpbGVzQ29udGludWUgZnJvbSBQeXRob24uCiAgb3V0cHV0RWxlbWVudC5zdGVwcyA9IHN0ZXBzOwoKICByZXR1cm4gX3VwbG9hZEZpbGVzQ29udGludWUob3V0cHV0SWQpOwp9CgovLyBUaGlzIGlzIHJvdWdobHkgYW4gYXN5bmMgZ2VuZXJhdG9yIChub3Qgc3VwcG9ydGVkIGluIHRoZSBicm93c2VyIHlldCksCi8vIHdoZXJlIHRoZXJlIGFyZSBtdWx0aXBsZSBhc3luY2hyb25vdXMgc3RlcHMgYW5kIHRoZSBQeXRob24gc2lkZSBpcyBnb2luZwovLyB0byBwb2xsIGZvciBjb21wbGV0aW9uIG9mIGVhY2ggc3RlcC4KLy8gVGhpcyB1c2VzIGEgUHJvbWlzZSB0byBibG9jayB0aGUgcHl0aG9uIHNpZGUgb24gY29tcGxldGlvbiBvZiBlYWNoIHN0ZXAsCi8vIHRoZW4gcGFzc2VzIHRoZSByZXN1bHQgb2YgdGhlIHByZXZpb3VzIHN0ZXAgYXMgdGhlIGlucHV0IHRvIHRoZSBuZXh0IHN0ZXAuCmZ1bmN0aW9uIF91cGxvYWRGaWxlc0NvbnRpbnVlKG91dHB1dElkKSB7CiAgY29uc3Qgb3V0cHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKG91dHB1dElkKTsKICBjb25zdCBzdGVwcyA9IG91dHB1dEVsZW1lbnQuc3RlcHM7CgogIGNvbnN0IG5leHQgPSBzdGVwcy5uZXh0KG91dHB1dEVsZW1lbnQubGFzdFByb21pc2VWYWx1ZSk7CiAgcmV0dXJuIFByb21pc2UucmVzb2x2ZShuZXh0LnZhbHVlLnByb21pc2UpLnRoZW4oKHZhbHVlKSA9PiB7CiAgICAvLyBDYWNoZSB0aGUgbGFzdCBwcm9taXNlIHZhbHVlIHRvIG1ha2UgaXQgYXZhaWxhYmxlIHRvIHRoZSBuZXh0CiAgICAvLyBzdGVwIG9mIHRoZSBnZW5lcmF0b3IuCiAgICBvdXRwdXRFbGVtZW50Lmxhc3RQcm9taXNlVmFsdWUgPSB2YWx1ZTsKICAgIHJldHVybiBuZXh0LnZhbHVlLnJlc3BvbnNlOwogIH0pOwp9CgovKioKICogR2VuZXJhdG9yIGZ1bmN0aW9uIHdoaWNoIGlzIGNhbGxlZCBiZXR3ZWVuIGVhY2ggYXN5bmMgc3RlcCBvZiB0aGUgdXBsb2FkCiAqIHByb2Nlc3MuCiAqIEBwYXJhbSB7c3RyaW5nfSBpbnB1dElkIEVsZW1lbnQgSUQgb2YgdGhlIGlucHV0IGZpbGUgcGlja2VyIGVsZW1lbnQuCiAqIEBwYXJhbSB7c3RyaW5nfSBvdXRwdXRJZCBFbGVtZW50IElEIG9mIHRoZSBvdXRwdXQgZGlzcGxheS4KICogQHJldHVybiB7IUl0ZXJhYmxlPCFPYmplY3Q+fSBJdGVyYWJsZSBvZiBuZXh0IHN0ZXBzLgogKi8KZnVuY3Rpb24qIHVwbG9hZEZpbGVzU3RlcChpbnB1dElkLCBvdXRwdXRJZCkgewogIGNvbnN0IGlucHV0RWxlbWVudCA9IGRvY3VtZW50LmdldEVsZW1lbnRCeUlkKGlucHV0SWQpOwogIGlucHV0RWxlbWVudC5kaXNhYmxlZCA9IGZhbHNlOwoKICBjb25zdCBvdXRwdXRFbGVtZW50ID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQob3V0cHV0SWQpOwogIG91dHB1dEVsZW1lbnQuaW5uZXJIVE1MID0gJyc7CgogIGNvbnN0IHBpY2tlZFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgaW5wdXRFbGVtZW50LmFkZEV2ZW50TGlzdGVuZXIoJ2NoYW5nZScsIChlKSA9PiB7CiAgICAgIHJlc29sdmUoZS50YXJnZXQuZmlsZXMpOwogICAgfSk7CiAgfSk7CgogIGNvbnN0IGNhbmNlbCA9IGRvY3VtZW50LmNyZWF0ZUVsZW1lbnQoJ2J1dHRvbicpOwogIGlucHV0RWxlbWVudC5wYXJlbnRFbGVtZW50LmFwcGVuZENoaWxkKGNhbmNlbCk7CiAgY2FuY2VsLnRleHRDb250ZW50ID0gJ0NhbmNlbCB1cGxvYWQnOwogIGNvbnN0IGNhbmNlbFByb21pc2UgPSBuZXcgUHJvbWlzZSgocmVzb2x2ZSkgPT4gewogICAgY2FuY2VsLm9uY2xpY2sgPSAoKSA9PiB7CiAgICAgIHJlc29sdmUobnVsbCk7CiAgICB9OwogIH0pOwoKICAvLyBXYWl0IGZvciB0aGUgdXNlciB0byBwaWNrIHRoZSBmaWxlcy4KICBjb25zdCBmaWxlcyA9IHlpZWxkIHsKICAgIHByb21pc2U6IFByb21pc2UucmFjZShbcGlja2VkUHJvbWlzZSwgY2FuY2VsUHJvbWlzZV0pLAogICAgcmVzcG9uc2U6IHsKICAgICAgYWN0aW9uOiAnc3RhcnRpbmcnLAogICAgfQogIH07CgogIGNhbmNlbC5yZW1vdmUoKTsKCiAgLy8gRGlzYWJsZSB0aGUgaW5wdXQgZWxlbWVudCBzaW5jZSBmdXJ0aGVyIHBpY2tzIGFyZSBub3QgYWxsb3dlZC4KICBpbnB1dEVsZW1lbnQuZGlzYWJsZWQgPSB0cnVlOwoKICBpZiAoIWZpbGVzKSB7CiAgICByZXR1cm4gewogICAgICByZXNwb25zZTogewogICAgICAgIGFjdGlvbjogJ2NvbXBsZXRlJywKICAgICAgfQogICAgfTsKICB9CgogIGZvciAoY29uc3QgZmlsZSBvZiBmaWxlcykgewogICAgY29uc3QgbGkgPSBkb2N1bWVudC5jcmVhdGVFbGVtZW50KCdsaScpOwogICAgbGkuYXBwZW5kKHNwYW4oZmlsZS5uYW1lLCB7Zm9udFdlaWdodDogJ2JvbGQnfSkpOwogICAgbGkuYXBwZW5kKHNwYW4oCiAgICAgICAgYCgke2ZpbGUudHlwZSB8fCAnbi9hJ30pIC0gJHtmaWxlLnNpemV9IGJ5dGVzLCBgICsKICAgICAgICBgbGFzdCBtb2RpZmllZDogJHsKICAgICAgICAgICAgZmlsZS5sYXN0TW9kaWZpZWREYXRlID8gZmlsZS5sYXN0TW9kaWZpZWREYXRlLnRvTG9jYWxlRGF0ZVN0cmluZygpIDoKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgJ24vYSd9IC0gYCkpOwogICAgY29uc3QgcGVyY2VudCA9IHNwYW4oJzAlIGRvbmUnKTsKICAgIGxpLmFwcGVuZENoaWxkKHBlcmNlbnQpOwoKICAgIG91dHB1dEVsZW1lbnQuYXBwZW5kQ2hpbGQobGkpOwoKICAgIGNvbnN0IGZpbGVEYXRhUHJvbWlzZSA9IG5ldyBQcm9taXNlKChyZXNvbHZlKSA9PiB7CiAgICAgIGNvbnN0IHJlYWRlciA9IG5ldyBGaWxlUmVhZGVyKCk7CiAgICAgIHJlYWRlci5vbmxvYWQgPSAoZSkgPT4gewogICAgICAgIHJlc29sdmUoZS50YXJnZXQucmVzdWx0KTsKICAgICAgfTsKICAgICAgcmVhZGVyLnJlYWRBc0FycmF5QnVmZmVyKGZpbGUpOwogICAgfSk7CiAgICAvLyBXYWl0IGZvciB0aGUgZGF0YSB0byBiZSByZWFkeS4KICAgIGxldCBmaWxlRGF0YSA9IHlpZWxkIHsKICAgICAgcHJvbWlzZTogZmlsZURhdGFQcm9taXNlLAogICAgICByZXNwb25zZTogewogICAgICAgIGFjdGlvbjogJ2NvbnRpbnVlJywKICAgICAgfQogICAgfTsKCiAgICAvLyBVc2UgYSBjaHVua2VkIHNlbmRpbmcgdG8gYXZvaWQgbWVzc2FnZSBzaXplIGxpbWl0cy4gU2VlIGIvNjIxMTU2NjAuCiAgICBsZXQgcG9zaXRpb24gPSAwOwogICAgZG8gewogICAgICBjb25zdCBsZW5ndGggPSBNYXRoLm1pbihmaWxlRGF0YS5ieXRlTGVuZ3RoIC0gcG9zaXRpb24sIE1BWF9QQVlMT0FEX1NJWkUpOwogICAgICBjb25zdCBjaHVuayA9IG5ldyBVaW50OEFycmF5KGZpbGVEYXRhLCBwb3NpdGlvbiwgbGVuZ3RoKTsKICAgICAgcG9zaXRpb24gKz0gbGVuZ3RoOwoKICAgICAgY29uc3QgYmFzZTY0ID0gYnRvYShTdHJpbmcuZnJvbUNoYXJDb2RlLmFwcGx5KG51bGwsIGNodW5rKSk7CiAgICAgIHlpZWxkIHsKICAgICAgICByZXNwb25zZTogewogICAgICAgICAgYWN0aW9uOiAnYXBwZW5kJywKICAgICAgICAgIGZpbGU6IGZpbGUubmFtZSwKICAgICAgICAgIGRhdGE6IGJhc2U2NCwKICAgICAgICB9LAogICAgICB9OwoKICAgICAgbGV0IHBlcmNlbnREb25lID0gZmlsZURhdGEuYnl0ZUxlbmd0aCA9PT0gMCA/CiAgICAgICAgICAxMDAgOgogICAgICAgICAgTWF0aC5yb3VuZCgocG9zaXRpb24gLyBmaWxlRGF0YS5ieXRlTGVuZ3RoKSAqIDEwMCk7CiAgICAgIHBlcmNlbnQudGV4dENvbnRlbnQgPSBgJHtwZXJjZW50RG9uZX0lIGRvbmVgOwoKICAgIH0gd2hpbGUgKHBvc2l0aW9uIDwgZmlsZURhdGEuYnl0ZUxlbmd0aCk7CiAgfQoKICAvLyBBbGwgZG9uZS4KICB5aWVsZCB7CiAgICByZXNwb25zZTogewogICAgICBhY3Rpb246ICdjb21wbGV0ZScsCiAgICB9CiAgfTsKfQoKc2NvcGUuZ29vZ2xlID0gc2NvcGUuZ29vZ2xlIHx8IHt9OwpzY29wZS5nb29nbGUuY29sYWIgPSBzY29wZS5nb29nbGUuY29sYWIgfHwge307CnNjb3BlLmdvb2dsZS5jb2xhYi5fZmlsZXMgPSB7CiAgX3VwbG9hZEZpbGVzLAogIF91cGxvYWRGaWxlc0NvbnRpbnVlLAp9Owp9KShzZWxmKTsK",
              "ok": true,
              "headers": [
                [
                  "content-type",
                  "application/javascript"
                ]
              ],
              "status": 200,
              "status_text": ""
            }
          },
          "base_uri": "https://localhost:8080/",
          "height": 140
        },
        "outputId": "8625e373-1d06-49aa-f0e3-622d5f1be31d"
      },
      "source": [
        "from google.colab import files\n",
        "upload = files.upload()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-21703bb6-0f4d-433b-a8f3-781fee3b5845\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-21703bb6-0f4d-433b-a8f3-781fee3b5845\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script src=\"/nbextensions/google.colab/files.js\"></script> "
            ],
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ]
          },
          "metadata": {
            "tags": []
          }
        },
        {
          "output_type": "stream",
          "text": [
            "Saving GSC - Data Skeptic Dashboard for SEOs_Page 1_Table (3).csv to GSC - Data Skeptic Dashboard for SEOs_Page 1_Table (3).csv\n",
            "Saving GSC - Data Skeptic Dashboard for SEOs_Page 1_Table (4).csv to GSC - Data Skeptic Dashboard for SEOs_Page 1_Table (4).csv\n",
            "Saving GSC - Data Skeptic Dashboard for SEOs_Page 1_Table (5).csv to GSC - Data Skeptic Dashboard for SEOs_Page 1_Table (5).csv\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DdIZ0-ToQV8l"
      },
      "source": [
        "###Name the Page CSV into a dataframe\n"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fSzNmgGDwF77",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "9c97e134-a770-4fd7-90ef-5da686c427e1"
      },
      "source": [
        "lp_query = pd.read_csv(\"GSC - Data Skeptic Dashboard for SEOs_Page 1_Table.csv\")\n",
        "lp_query.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.module+javascript": "\n      import \"https://ssl.gstatic.com/colaboratory/data_table/a6224c040fa35dcf/data_table.js\";\n\n      window.createDataTable({\n        data: [[{\n            'v': 0,\n            'f': \"0\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Lifestyle/Fun/Google+Kick+Ball.axd\",\n\"google kickball\",\n{\n            'v': 1150,\n            'f': \"1150\",\n        },\n{\n            'v': 1041.0,\n            'f': \"1041.0\",\n        },\n{\n            'v': 750,\n            'f': \"750\",\n        },\n{\n            'v': 676.0,\n            'f': \"676.0\",\n        },\n{\n            'v': 0.6521739130434783,\n            'f': \"0.6521739130434783\",\n        },\n{\n            'v': -0.02672516952532911,\n            'f': \"-0.02672516952532911\",\n        }],\n [{\n            'v': 1,\n            'f': \"1\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Google+Dino+Game+Tee\",\n\"chrome dino\",\n{\n            'v': 107970,\n            'f': \"107970\",\n        },\n{\n            'v': -49864.0,\n            'f': \"-49864.0\",\n        },\n{\n            'v': 481,\n            'f': \"481\",\n        },\n{\n            'v': -1474.0,\n            'f': \"-1474.0\",\n        },\n{\n            'v': 0.004454941187366861,\n            'f': \"0.004454941187366861\",\n        },\n{\n            'v': -0.007931490126545225,\n            'f': \"-0.007931490126545225\",\n        }],\n [{\n            'v': 2,\n            'f': \"2\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Shop+by+Brand/YouTube\",\n\"youtube merchandise\",\n{\n            'v': 2635,\n            'f': \"2635\",\n        },\n{\n            'v': 229.0,\n            'f': \"229.0\",\n        },\n{\n            'v': 437,\n            'f': \"437\",\n        },\n{\n            'v': 47.0,\n            'f': \"47.0\",\n        },\n{\n            'v': 0.16584440227703984,\n            'f': \"0.16584440227703984\",\n        },\n{\n            'v': 0.003749639184770504,\n            'f': \"0.003749639184770504\",\n        }],\n [{\n            'v': 3,\n            'f': \"3\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Mens/Mens+T+Shirts\",\n\"google t shirt\",\n{\n            'v': 1884,\n            'f': \"1884\",\n        },\n{\n            'v': 206.0,\n            'f': \"206.0\",\n        },\n{\n            'v': 352,\n            'f': \"352\",\n        },\n{\n            'v': 48.0,\n            'f': \"48.0\",\n        },\n{\n            'v': 0.18683651804670912,\n            'f': \"0.18683651804670912\",\n        },\n{\n            'v': 0.005668460835743683,\n            'f': \"0.005668460835743683\",\n        }],\n [{\n            'v': 4,\n            'f': \"4\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Google+Dino+Game+Tee\",\n\"dino game\",\n{\n            'v': 67570,\n            'f': \"67570\",\n        },\n{\n            'v': -248375.0,\n            'f': \"-248375.0\",\n        },\n{\n            'v': 347,\n            'f': \"347\",\n        },\n{\n            'v': -5597.0,\n            'f': \"-5597.0\",\n        },\n{\n            'v': 0.005135415125055498,\n            'f': \"0.005135415125055498\",\n        },\n{\n            'v': -0.013677985941585848,\n            'f': \"-0.013677985941585848\",\n        }]],\n        columns: [[\"number\", \"index\"], [\"string\", \"Landing Page\"], [\"string\", \"Query\"], [\"number\", \"Impressions\"], [\"number\", \"\\u0394\"], [\"number\", \"Url Clicks\"], [\"number\", \"\\u0394.1\"], [\"number\", \"URL CTR\"], [\"number\", \"\\u0394.2\"]],\n        columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n        rowsPerPage: 25,\n        helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n        suppressOutputScrolling: true,\n        minimumWidth: undefined,\n      });\n    ",
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Landing Page</th>\n",
              "      <th>Query</th>\n",
              "      <th>Impressions</th>\n",
              "      <th>Δ</th>\n",
              "      <th>Url Clicks</th>\n",
              "      <th>Δ.1</th>\n",
              "      <th>URL CTR</th>\n",
              "      <th>Δ.2</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>google kickball</td>\n",
              "      <td>1150</td>\n",
              "      <td>1041.0</td>\n",
              "      <td>750</td>\n",
              "      <td>676.0</td>\n",
              "      <td>0.652174</td>\n",
              "      <td>-0.026725</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>chrome dino</td>\n",
              "      <td>107970</td>\n",
              "      <td>-49864.0</td>\n",
              "      <td>481</td>\n",
              "      <td>-1474.0</td>\n",
              "      <td>0.004455</td>\n",
              "      <td>-0.007931</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>youtube merchandise</td>\n",
              "      <td>2635</td>\n",
              "      <td>229.0</td>\n",
              "      <td>437</td>\n",
              "      <td>47.0</td>\n",
              "      <td>0.165844</td>\n",
              "      <td>0.003750</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>google t shirt</td>\n",
              "      <td>1884</td>\n",
              "      <td>206.0</td>\n",
              "      <td>352</td>\n",
              "      <td>48.0</td>\n",
              "      <td>0.186837</td>\n",
              "      <td>0.005668</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>dino game</td>\n",
              "      <td>67570</td>\n",
              "      <td>-248375.0</td>\n",
              "      <td>347</td>\n",
              "      <td>-5597.0</td>\n",
              "      <td>0.005135</td>\n",
              "      <td>-0.013678</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                        Landing Page  ...       Δ.2\n",
              "0  https://shop.googlemerchandisestore.com/Google...  ... -0.026725\n",
              "1  https://shop.googlemerchandisestore.com/Google...  ... -0.007931\n",
              "2  https://shop.googlemerchandisestore.com/Google...  ...  0.003750\n",
              "3  https://shop.googlemerchandisestore.com/Google...  ...  0.005668\n",
              "4  https://shop.googlemerchandisestore.com/Google...  ... -0.013678\n",
              "\n",
              "[5 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 121
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "47KV8UB5Qc-p"
      },
      "source": [
        "###Clean the Data\n",
        "Clean the data up to make it easier for an analysis. This includes removing null values, renaming columns, and having the right data types. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xLkM8QgHR186"
      },
      "source": [
        "# Rename columns to your preference\n",
        "lp_query = lp_query.rename(columns={\"Url Clicks\":\"URL Clicks\",\"Δ\": \"Impressions Difference\", \"Δ.1\": \"URL Clicks Difference\", \"Δ.2\":\"URL CTR Difference\", \"Δ.3\":\"Average Position Difference\"})\n",
        "\n",
        "# Replace all null values in the data set with 0\n",
        "lp_query = lp_query.fillna(0)\n",
        "lp_query.isnull().sum()\n",
        "\n",
        "# Cast columns as int64 data type\n",
        "lp_query['Impressions Difference'] = lp_query['Impressions Difference'].astype('int64')\n",
        "lp_query['URL Clicks Difference'] = lp_query['URL Clicks Difference'].astype('int64')\n",
        "\n",
        "# Added a style to the Landing Page column so that we can see the full URL\n",
        "lp_query.head().style.set_properties(subset=['Landing Page'], **{'width': '100px'})"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Phl9tt-7e1zK"
      },
      "source": [
        "##Add Category Column"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "X1fHVhKyGJPY",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ebdc911b-5984-420f-8069-04204a467528"
      },
      "source": [
        "# Extracts string after the 4th forward slash and puts the value into a Category column. \n",
        "lp_query['Category']=lp_query['Landing Page'].str.extract(r'(?:.*?\\/){4}([^\\/?#]+)')\n",
        "\n",
        "# Replaces all + and - in the extracted string with a space and makes it title case.\n",
        "lp_query['Category']=lp_query['Category'].str.replace('+', ' ')\n",
        "lp_query['Category']=lp_query['Category'].str.replace('-', ' ').str.title()\n",
        "lp_query.head().style.set_properties(subset=['Landing Page'], **{'width': '100px'})"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<style  type=\"text/css\" >\n",
              "#T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col0,#T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col0,#T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col0,#T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col0,#T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col0{\n",
              "            width:  100px;\n",
              "        }</style><table id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >Landing Page</th>        <th class=\"col_heading level0 col1\" >Query</th>        <th class=\"col_heading level0 col2\" >Impressions</th>        <th class=\"col_heading level0 col3\" >Impressions Difference</th>        <th class=\"col_heading level0 col4\" >URL Clicks</th>        <th class=\"col_heading level0 col5\" >URL Clicks Difference</th>        <th class=\"col_heading level0 col6\" >URL CTR</th>        <th class=\"col_heading level0 col7\" >URL CTR Difference</th>        <th class=\"col_heading level0 col8\" >Category</th>    </tr></thead><tbody>\n",
              "                <tr>\n",
              "                        <th id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col0\" class=\"data row0 col0\" >https://shop.googlemerchandisestore.com/Google+Redesign/Lifestyle/Fun/Google+Kick+Ball.axd</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col1\" class=\"data row0 col1\" >google kickball</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col2\" class=\"data row0 col2\" >1150</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col3\" class=\"data row0 col3\" >1041</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col4\" class=\"data row0 col4\" >750</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col5\" class=\"data row0 col5\" >676</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col6\" class=\"data row0 col6\" >0.652174</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col7\" class=\"data row0 col7\" >-0.026725</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row0_col8\" class=\"data row0 col8\" >Lifestyle</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col0\" class=\"data row1 col0\" >https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Google+Dino+Game+Tee</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col1\" class=\"data row1 col1\" >chrome dino</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col2\" class=\"data row1 col2\" >107970</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col3\" class=\"data row1 col3\" >-49864</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col4\" class=\"data row1 col4\" >481</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col5\" class=\"data row1 col5\" >-1474</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col6\" class=\"data row1 col6\" >0.004455</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col7\" class=\"data row1 col7\" >-0.007931</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row1_col8\" class=\"data row1 col8\" >Apparel</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col0\" class=\"data row2 col0\" >https://shop.googlemerchandisestore.com/Google+Redesign/Shop+by+Brand/YouTube</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col1\" class=\"data row2 col1\" >youtube merchandise</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col2\" class=\"data row2 col2\" >2635</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col3\" class=\"data row2 col3\" >229</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col4\" class=\"data row2 col4\" >437</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col5\" class=\"data row2 col5\" >47</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col6\" class=\"data row2 col6\" >0.165844</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col7\" class=\"data row2 col7\" >0.003750</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row2_col8\" class=\"data row2 col8\" >Shop By Brand</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col0\" class=\"data row3 col0\" >https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Mens/Mens+T+Shirts</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col1\" class=\"data row3 col1\" >google t shirt</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col2\" class=\"data row3 col2\" >1884</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col3\" class=\"data row3 col3\" >206</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col4\" class=\"data row3 col4\" >352</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col5\" class=\"data row3 col5\" >48</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col6\" class=\"data row3 col6\" >0.186837</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col7\" class=\"data row3 col7\" >0.005668</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row3_col8\" class=\"data row3 col8\" >Apparel</td>\n",
              "            </tr>\n",
              "            <tr>\n",
              "                        <th id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col0\" class=\"data row4 col0\" >https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Google+Dino+Game+Tee</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col1\" class=\"data row4 col1\" >dino game</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col2\" class=\"data row4 col2\" >67570</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col3\" class=\"data row4 col3\" >-248375</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col4\" class=\"data row4 col4\" >347</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col5\" class=\"data row4 col5\" >-5597</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col6\" class=\"data row4 col6\" >0.005135</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col7\" class=\"data row4 col7\" >-0.013678</td>\n",
              "                        <td id=\"T_807f0846_c7fc_11eb_807b_0242ac1c0002row4_col8\" class=\"data row4 col8\" >Apparel</td>\n",
              "            </tr>\n",
              "    </tbody></table>"
            ],
            "text/plain": [
              "<pandas.io.formats.style.Styler at 0x7fe6807c1b90>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 126
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "09aatHmqX60P",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "325a3e4c-76ae-4a54-c799-4994376b8482"
      },
      "source": [
        "# Creates new columns for the value of the previous period, given we only have the data \n",
        "# for the current period and the absolute change. \n",
        "lp_query['Impressions (Prior Period)'] = (lp_query['Impressions'] - lp_query['Impressions Difference'])\n",
        "lp_query['Clicks (Prior Period)'] = (lp_query['URL Clicks'] - lp_query['URL Clicks Difference'])\n",
        "lp_query['Site CTR (Prior Period)'] = (lp_query['URL CTR'] - lp_query['URL CTR Difference'])\n",
        "lp_query.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.module+javascript": "\n      import \"https://ssl.gstatic.com/colaboratory/data_table/a6224c040fa35dcf/data_table.js\";\n\n      window.createDataTable({\n        data: [[{\n            'v': 0,\n            'f': \"0\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Lifestyle/Fun/Google+Kick+Ball.axd\",\n\"google kickball\",\n{\n            'v': 1150,\n            'f': \"1150\",\n        },\n{\n            'v': 1041,\n            'f': \"1041\",\n        },\n{\n            'v': 750,\n            'f': \"750\",\n        },\n{\n            'v': 676,\n            'f': \"676\",\n        },\n{\n            'v': 0.6521739130434783,\n            'f': \"0.6521739130434783\",\n        },\n{\n            'v': -0.02672516952532911,\n            'f': \"-0.02672516952532911\",\n        },\n\"Lifestyle\",\n{\n            'v': 109,\n            'f': \"109\",\n        },\n{\n            'v': 74,\n            'f': \"74\",\n        },\n{\n            'v': 0.6788990825688074,\n            'f': \"0.6788990825688074\",\n        }],\n [{\n            'v': 1,\n            'f': \"1\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Google+Dino+Game+Tee\",\n\"chrome dino\",\n{\n            'v': 107970,\n            'f': \"107970\",\n        },\n{\n            'v': -49864,\n            'f': \"-49864\",\n        },\n{\n            'v': 481,\n            'f': \"481\",\n        },\n{\n            'v': -1474,\n            'f': \"-1474\",\n        },\n{\n            'v': 0.004454941187366861,\n            'f': \"0.004454941187366861\",\n        },\n{\n            'v': -0.007931490126545225,\n            'f': \"-0.007931490126545225\",\n        },\n\"Apparel\",\n{\n            'v': 157834,\n            'f': \"157834\",\n        },\n{\n            'v': 1955,\n            'f': \"1955\",\n        },\n{\n            'v': 0.012386431313912087,\n            'f': \"0.012386431313912087\",\n        }],\n [{\n            'v': 2,\n            'f': \"2\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Shop+by+Brand/YouTube\",\n\"youtube merchandise\",\n{\n            'v': 2635,\n            'f': \"2635\",\n        },\n{\n            'v': 229,\n            'f': \"229\",\n        },\n{\n            'v': 437,\n            'f': \"437\",\n        },\n{\n            'v': 47,\n            'f': \"47\",\n        },\n{\n            'v': 0.16584440227703984,\n            'f': \"0.16584440227703984\",\n        },\n{\n            'v': 0.003749639184770504,\n            'f': \"0.003749639184770504\",\n        },\n\"Shop By Brand\",\n{\n            'v': 2406,\n            'f': \"2406\",\n        },\n{\n            'v': 390,\n            'f': \"390\",\n        },\n{\n            'v': 0.16209476309226933,\n            'f': \"0.16209476309226933\",\n        }],\n [{\n            'v': 3,\n            'f': \"3\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Mens/Mens+T+Shirts\",\n\"google t shirt\",\n{\n            'v': 1884,\n            'f': \"1884\",\n        },\n{\n            'v': 206,\n            'f': \"206\",\n        },\n{\n            'v': 352,\n            'f': \"352\",\n        },\n{\n            'v': 48,\n            'f': \"48\",\n        },\n{\n            'v': 0.18683651804670912,\n            'f': \"0.18683651804670912\",\n        },\n{\n            'v': 0.005668460835743683,\n            'f': \"0.005668460835743683\",\n        },\n\"Apparel\",\n{\n            'v': 1678,\n            'f': \"1678\",\n        },\n{\n            'v': 304,\n            'f': \"304\",\n        },\n{\n            'v': 0.18116805721096543,\n            'f': \"0.18116805721096543\",\n        }],\n [{\n            'v': 4,\n            'f': \"4\",\n        },\n\"https://shop.googlemerchandisestore.com/Google+Redesign/Apparel/Google+Dino+Game+Tee\",\n\"dino game\",\n{\n            'v': 67570,\n            'f': \"67570\",\n        },\n{\n            'v': -248375,\n            'f': \"-248375\",\n        },\n{\n            'v': 347,\n            'f': \"347\",\n        },\n{\n            'v': -5597,\n            'f': \"-5597\",\n        },\n{\n            'v': 0.005135415125055498,\n            'f': \"0.005135415125055498\",\n        },\n{\n            'v': -0.013677985941585848,\n            'f': \"-0.013677985941585848\",\n        },\n\"Apparel\",\n{\n            'v': 315945,\n            'f': \"315945\",\n        },\n{\n            'v': 5944,\n            'f': \"5944\",\n        },\n{\n            'v': 0.018813401066641346,\n            'f': \"0.018813401066641346\",\n        }]],\n        columns: [[\"number\", \"index\"], [\"string\", \"Landing Page\"], [\"string\", \"Query\"], [\"number\", \"Impressions\"], [\"number\", \"Impressions Difference\"], [\"number\", \"URL Clicks\"], [\"number\", \"URL Clicks Difference\"], [\"number\", \"URL CTR\"], [\"number\", \"URL CTR Difference\"], [\"string\", \"Category\"], [\"number\", \"Impressions (Prior Period)\"], [\"number\", \"Clicks (Prior Period)\"], [\"number\", \"Site CTR (Prior Period)\"]],\n        columnOptions: [{\"width\": \"1px\", \"className\": \"index_column\"}],\n        rowsPerPage: 25,\n        helpUrl: \"https://colab.research.google.com/notebooks/data_table.ipynb\",\n        suppressOutputScrolling: true,\n        minimumWidth: undefined,\n      });\n    ",
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Landing Page</th>\n",
              "      <th>Query</th>\n",
              "      <th>Impressions</th>\n",
              "      <th>Impressions Difference</th>\n",
              "      <th>URL Clicks</th>\n",
              "      <th>URL Clicks Difference</th>\n",
              "      <th>URL CTR</th>\n",
              "      <th>URL CTR Difference</th>\n",
              "      <th>Category</th>\n",
              "      <th>Impressions (Prior Period)</th>\n",
              "      <th>Clicks (Prior Period)</th>\n",
              "      <th>Site CTR (Prior Period)</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>google kickball</td>\n",
              "      <td>1150</td>\n",
              "      <td>1041</td>\n",
              "      <td>750</td>\n",
              "      <td>676</td>\n",
              "      <td>0.652174</td>\n",
              "      <td>-0.026725</td>\n",
              "      <td>Lifestyle</td>\n",
              "      <td>109</td>\n",
              "      <td>74</td>\n",
              "      <td>0.678899</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>chrome dino</td>\n",
              "      <td>107970</td>\n",
              "      <td>-49864</td>\n",
              "      <td>481</td>\n",
              "      <td>-1474</td>\n",
              "      <td>0.004455</td>\n",
              "      <td>-0.007931</td>\n",
              "      <td>Apparel</td>\n",
              "      <td>157834</td>\n",
              "      <td>1955</td>\n",
              "      <td>0.012386</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>youtube merchandise</td>\n",
              "      <td>2635</td>\n",
              "      <td>229</td>\n",
              "      <td>437</td>\n",
              "      <td>47</td>\n",
              "      <td>0.165844</td>\n",
              "      <td>0.003750</td>\n",
              "      <td>Shop By Brand</td>\n",
              "      <td>2406</td>\n",
              "      <td>390</td>\n",
              "      <td>0.162095</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>google t shirt</td>\n",
              "      <td>1884</td>\n",
              "      <td>206</td>\n",
              "      <td>352</td>\n",
              "      <td>48</td>\n",
              "      <td>0.186837</td>\n",
              "      <td>0.005668</td>\n",
              "      <td>Apparel</td>\n",
              "      <td>1678</td>\n",
              "      <td>304</td>\n",
              "      <td>0.181168</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>https://shop.googlemerchandisestore.com/Google...</td>\n",
              "      <td>dino game</td>\n",
              "      <td>67570</td>\n",
              "      <td>-248375</td>\n",
              "      <td>347</td>\n",
              "      <td>-5597</td>\n",
              "      <td>0.005135</td>\n",
              "      <td>-0.013678</td>\n",
              "      <td>Apparel</td>\n",
              "      <td>315945</td>\n",
              "      <td>5944</td>\n",
              "      <td>0.018813</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                        Landing Page  ... Site CTR (Prior Period)\n",
              "0  https://shop.googlemerchandisestore.com/Google...  ...                0.678899\n",
              "1  https://shop.googlemerchandisestore.com/Google...  ...                0.012386\n",
              "2  https://shop.googlemerchandisestore.com/Google...  ...                0.162095\n",
              "3  https://shop.googlemerchandisestore.com/Google...  ...                0.181168\n",
              "4  https://shop.googlemerchandisestore.com/Google...  ...                0.018813\n",
              "\n",
              "[5 rows x 12 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 127
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LzQ-paYIXd_s"
      },
      "source": [
        "# Creates 2 new dataframes, one for brand queries and one for non-brand queries.\n",
        "lp_query_brand = lp_query[lp_query['Query'].str.contains('google')]\n",
        "lp_query_non_brand = lp_query[~lp_query['Query'].str.contains('google')]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "xK81OVKjV1Xw"
      },
      "source": [
        "##Top 10 Categories by Clicks"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "oK-oQILQO0aR"
      },
      "source": [
        "##### Total Site"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PIhnmdBrsX2O",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "2e03c1bb-25ec-48ea-c713-e159c3c08bc2"
      },
      "source": [
        "category_pivot = lp_query.pivot_table(index='Category', values=['URL Clicks'], aggfunc={'URL Clicks': np.sum})\n",
        "category_pivot = category_pivot.sort_values(by='URL Clicks', ascending=False)\n",
        "category_pivot.head(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>URL Clicks</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Category</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Apparel</th>\n",
              "      <td>5062</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Shop By Brand</th>\n",
              "      <td>2666</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Accessories</th>\n",
              "      <td>1060</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lifestyle</th>\n",
              "      <td>993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Stationery</th>\n",
              "      <td>494</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bags</th>\n",
              "      <td>316</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Drinkware</th>\n",
              "      <td>273</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Clearance</th>\n",
              "      <td>136</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Office</th>\n",
              "      <td>89</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Store Policies</th>\n",
              "      <td>51</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                URL Clicks\n",
              "Category                  \n",
              "Apparel               5062\n",
              "Shop By Brand         2666\n",
              "Accessories           1060\n",
              "Lifestyle              993\n",
              "Stationery             494\n",
              "Bags                   316\n",
              "Drinkware              273\n",
              "Clearance              136\n",
              "Office                  89\n",
              "Store Policies          51"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 133
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RcayZnPoV7bF",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "bd8b1446-79d1-4711-e5ba-8374d8c74e9f"
      },
      "source": [
        "ax_category = category_pivot.head(10).plot(kind='bar')\n",
        "ax_category.set_ylabel('URL Clicks')\n",
        "ax_category.set_title('Top 10 URL Clicks by Category')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Text(0.5, 1.0, 'Top 10 URL Clicks by Category')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 134
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAFWCAYAAACYQLF6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debyUZf3/8ddbRDF3gdRAwoVMMkEll/JbpmnuqKlpLmQWX7+5fitLW36aZl/KUlPTxFyg3FOTtCw3XHKFVMSdXBIyN3DBxAA/vz+uazjDcc7cB86Ze0bO+/l4zOPMfd33zP05c+bMZ67lvi5FBGZmZvUs1ewAzMys9TlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjDrIkkhab18/1eSftCJx0yU9NUunvcESb/tynOYdZaThSFpdtXtXUlvV23v303n2EfSXZL+LWlijf3DJU3O+ydLGl7nuZ6V9Ll2ZV+WdGe+Pzh/gFd+h2clHVv0HHXOt6ak8yW9IOlNSY9L+qGk5dsfGxGHRsRJnXneViPpS5Im5dfsBUl/krRVJx+7IGHaksnJwoiIFSo34B/ArlVlF3fTaWYCpwNj2u+QtAxwLfBbYFVgHHBtLu+KVfLvtBfwA0nbLeoTSFoNuBtYDtgyIlYEtgNWAdbtYnwtQ9I3SH+fHwOrA4OAs4GRzYyriKSlmx1DT+FkYR2StKyk0yX9M99Ol7Rs3re1pOmSvivplfxNvcNaSETcFBFXAP+ssXtrYGng9Ih4JyLOAARs0x2/R0RMAh4BOqyt1PEN4E3ggIh4Nj/f8xFxVERMaX+wpIsk/ahqe6SkByW9Ienvknao8Zg1JU2RdEze/rKkp3Mt5pmC2l0fSZfnY/8maVh+jmMkXdXuPGdI+kWN868MnAgcFhFXR8RbETE3Iv4QEZWYNpN0t6TXcq3jrEoyl3R7fqqHcq3ki7l8l/y7v5ZrlRtVnXMTSQ/kuK/Mv0P16/Y1SdMkzZQ0QdKHqvaFpMMkPQU8JemXkn7e7neaIOl/67xutoicLKye7wFbkD5khwGbAd+v2r8G0A8YAIwCxkpafzHO8zFgSiw898yUXN5lkrYANgSmLcbDPwdcHRHvLsZ5NwPGA8eQaiKfBp5td8zawG3AWRFxSm7aOgPYMddiPgk8WOc0I4ErgdWAS4DfS+pNqqXtIGmVfJ6lgX1zPO1tCfQBrqlznvnA/5L+3lsC2wJfB4iIT+djhuXa6OWSNgYuAP4b6AucC0zIX0CWyee6KMd9KbBH1WuyDfB/wD7AmsBzwGXt4tkd2BwYSqqJ7idpqfz4fqS/2yV1fh9bRE4WVs/+wIkR8VJEvAz8EDiw3TE/yLWB24DrSf/gi2oF4PV2Za8DKy7Gc1V7RdLbpGaks4HfL8Zz9AVeWMzzHwJcEBE3RsS7ETEjIh6v2j8UuBU4PiLGVpW/C2woabmIeCEiHqlzjskR8buImAucSvrQ3yIiXgBuB/bOx+0AvBIRk2s8R9+8b15HJ4mIyRFxT0TMyzWsc4HP1IlrNHBuRNwbEfMjYhzwDunLxxakmuQZuQZzNXBf1WP3J71uf4uId4DjgC0lDa465v8iYmZEvB0R95HeL9vmffsCEyPixTrx2SJysrB6PkT6VlfxXC6rmBURb9XZ31mzgZXala1Eav6pZR7Qu11Zb2Buu7J+pET0TVJTV/vHdMarpG+3i2Mt4O919u8PzAB+VynIr+cXgUOBFyRdL+mjdZ7j+arHvgtMp+1vMA44IN8/APhNB8/xKtCvXvu/pI9Iuk7SvyS9Qerb6Fcnrg8D38xNUK9Jeo30enwo32a0q0k+X3V/ofddRMzOMQ7o4Hjo/O9qi8nJwur5J+mfvmIQC/c5rNpuRFD7/Z31CLCRJFWVbZTLa/kHMLhd2dosnNgAyN9qTwXmkJtNFtFNwB6VJo5F9Dz1O8FPAF4BLpHUq1IYEX+OiO1ISepx4Lw6z7FW5U6OcSBtf4Pfk17XDYFdgI4GK9xN+ta/e53znJNjGRIRKwHfJfUrdeR54OSIWKXq9oGIuJRUUxvQ7u+9VtX9hd53+T3Wl5RYK9pPl/1bYGTus9mAxatFWh1OFlbPpcD3JfXP7cD/j/RPWe2HkpaR9F+kD6Qraz2RpF6S+pCaH5aS1Ce3rQNMJLWJH5nbtA/P5bd0ENflwNGSPqpkBPAV3tuuXW0M8O0cQ0XvHEflVuub9amkWs44SR/Ov8sASadWd9h24HzgYEnbSloqP666ljCX1Ey0PDA+H7N67hRfnvQBPpvULNWRTSXtmWM/Oj/mHoCImEOqtVwC3BcR/6j1BBHxOulv+0tJu0v6gKTeknaU9NN82IrAG8Ds/Dv8T7uneRFYp2r7POBQSZvnv9HyknaWtCIpOc0HDpe0tKSRpP6wikvz6zZcaUDFj4F7KwMMOvgdpgP3k2oUV0XE23VeM1scEeGbbwtupA7Yz+X7fUidrS/k2xlAn7xva1KTx/dI347/ARxY53m/TPo2WH27qGr/xsBk4G3gb8DGdZ5rKeBY4CnSB9ijwCFV+wfn51+6qkykmsoRVb9n+3h+1MH5PkTqrP0XqWnsceB44AN5fwDr5fsXVT8PqeN2Sn7cNODzuXwi8NWq1/mm/NgBpA7v14HX8nFDO4jrBFIyuDw//wPAJu2O2SrHd3An/vb7A5OAt/Lvej3wybzv0/n3ng3cQRo9dWfVYw/N75HXgH1y2Q6kD/DX8r4rgRXzvhGkjvvZufxqUv9X9fP9nTTk+jpgYNW+Ba93u/gPyPs+2+z/oyXxpvwimy0SSVsDv42Igc2OxTomaRDpQ36NiHij2fF0RNK9wK8i4sIuPMenSTXfD4c/2Lqdm6HMllC5D+MbwGWtligkfUbSGrkZahSpj+qGLjxfb+Ao4NdOFI3hqx/NlkC5z+NFUqf/ey4EbAHrA1eQ+mueBvaKNNx3kUnagNR89hBwcLdFaAtxM5SZmRVyM5SZmRVysjAzs0JLZJ9Fv379YvDgwc0Ow8zsfWXy5MmvRET/WvuWyGQxePBgJk2a1OwwzMzeVyS9ZxaECjdDmZlZIScLMzMr5GRhZmaFlsg+CzN7/5s7dy7Tp09nzpw5zQ5lidOnTx8GDhxI796dn7XfycLMWtL06dNZccUVGTx4MAvPZm5dERG8+uqrTJ8+nbXXXrvTj3MzlJm1pDlz5tC3b18nim4mib59+y5yjc3JwsxalhNFYyzO69rQZCHpWUkPS3pQ0qRctpqkGyU9lX+umssl6QxJ0yRNkbRJ1fOMysc/lWeoNDNrqGeffZYNN9xwobITTjiBn/3sZwB8+ctfZu2112b48OEMGzaMm2++ecFxW2+9deG1Xk8++SQ77bQTQ4YMYZNNNmGfffbhxRdfZOLEieyyyy4ATJgwgTFjxixSjI1SRp/FZyPilartY4GbI2KMpGPz9neAHYEh+bY5aRnHzSWtRlpoZgRpYZPJkiZExKyuBDX42Ou78nCeHbNzlx5vZoumq/+z7XXH//App5zCXnvtxa233sro0aN56qmnOvW4OXPmsPPOO3Pqqaey6667AjBx4kRefvnlhY7bbbfd2G233bocZ3doRjPUSNLi6uSfu1eVj4/kHmAVSWsCnwdujIiZOUHcSGtOuWxmPdSWW27JjBkzig/MLrnkErbccssFiQJSbaR9LeGiiy7i8MPTKsMvvvgie+yxB8OGDWPYsGHcddddCx379NNPs/HGG3P//ffzyCOPsNlmmzF8+HA22mijTiexehpdswjgL5ICODcixgKrV81b/y9g9Xx/AGmR94rpuayjcjOzlnDDDTew++67Fx+YTZ06lU033XSRznHkkUfymc98hmuuuYb58+cze/ZsZs1KDSxPPPEE++67LxdddBHDhg3jiCOO4KijjmL//ffnP//5D/Pnz1+kc9XS6GSxVUTMkPRB4EZJj1fvjIjIiaTLJI0GRgMMGjSoO57SzHqwjjqBq8uPOeYYvvvd7zJ9+nTuvvvuhsZzyy23MH78eAB69erFyiuvzKxZs3j55ZcZOXIkV199NUOHDgVSTefkk09m+vTp7LnnngwZMqTL529oM1REzMg/XwKuATYDXszNS+SfL+XDZwBrVT18YC7rqLz9ucZGxIiIGNG/f81JE83MOq1v374LvrlXzJw5k379+i3YPuWUU3jyySf5yU9+wle+8pVOP/fHPvYxJk+e3C1xrrzyygwaNIg777xzQdmXvvQlJkyYwHLLLcdOO+3ELbfc0uXzNCxZSFpe0oqV+8D2wFRgAlAZ0TQKuDbfnwAclEdFbQG8npur/gxsL2nVPHJq+1xmZtYwK6ywAmuuueaCD9qZM2dyww03sNVWW73n2MMPP5x3332XP/+5cx9NX/rSl7jrrru4/vq2Tvvbb7+dqVOndviYbbfdlnPOOQeA+fPn8/rrrwOwzDLLcM011zB+/HguueQSIPVfrLPOOhx55JGMHDmSKVOmdO6XrqORNYvVgTslPQTcB1wfETcAY4DtJD0FfC5vA/yRtBbvNOA84OsAETETOAm4P99OzGVmZg01fvx4TjrpJIYPH84222zD8ccfz7rrrvue4yTx/e9/n5/+9KcLynbeeWcGDhzIwIED2XvvvRc6frnlluO6667jzDPPZMiQIQwdOpSzzz6beq0iv/jFL7j11lv5+Mc/zqabbsqjjz66YN/yyy/Pddddx2mnncaECRO44oor2HDDDRk+fDhTp07loIMO6vJrsUSuwT1ixIgoGuPsobNmre2xxx5jgw02aHYYS6xar6+kyRExotbxvoLbzMwKOVmYmVkhJwszMyvkZGFmLWtJ7FNtBYvzujpZmFlL6tOnD6+++qoTRjerrGfRp0+fRXqcFz8ys5Y0cOBApk+f/p7J9azrKivlLQonCzNrSb17916kldyssdwMZWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhRqeLCT1kvSApOvy9tqS7pU0TdLlkpbJ5cvm7Wl5/+Cq5zgulz8h6fONjtnMzBZWRs3iKOCxqu2fAKdFxHrALOCQXH4IMCuXn5aPQ9JQYF/gY8AOwNmSepUQt5mZZQ1NFpIGAjsDv87bArYBfpcPGQfsnu+PzNvk/dvm40cCl0XEOxHxDDAN2KyRcZuZ2cIaXbM4Hfg28G7e7gu8FhHz8vZ0YEC+PwB4HiDvfz0fv6C8xmMWkDRa0iRJk15++eXu/j3MzHq0hiULSbsAL0XE5Eado1pEjI2IERExon///mWc0sysx1i6gc/9KWA3STsBfYCVgF8Aq0haOtceBgIz8vEzgLWA6ZKWBlYGXq0qr6h+jJmZlaBhNYuIOC4iBkbEYFIH9S0RsT9wK7BXPmwUcG2+PyFvk/ffEhGRy/fNo6XWBoYA9zUqbjMze69G1iw68h3gMkk/Ah4Azs/l5wO/kTQNmElKMETEI5KuAB4F5gGHRcT88sM2M+u5SkkWETERmJjvP02N0UwRMQfYu4PHnwyc3LgIzcysHl/BbWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhQqThaR1JS2b728t6UhJqzQ+NDMzaxWdqVlcBcyXtB4wFlgLuKShUZmZWUvpTLJ4NyLmAXsAZ0bEMcCajQ3LzMxaSWeSxVxJ+wGjgOtyWe/GhWRmZq2mM8niYGBL4OSIeEbS2sBvGhuWmZm1kqU7ccxyEXFkZSMnjEcaGJOZmbWYztQszpO0YWUjN0n9oHEhmZlZq+lMstgLGC/po5K+Bnwd2L7oQZL6SLpP0kOSHpH0w1y+tqR7JU2TdLmkZXL5snl7Wt4/uOq5jsvlT0j6/OL8omZmtvgKk0VEPA3sC1wNfAHYPiJe78RzvwNsExHDgOHADpK2AH4CnBYR6wGzgEPy8YcAs3L5afk4JA3N5/8YsANwtqRenf8VzcysqzpMFpIeljRF0hTgd8BqwNrAvbmsrkhm583e+RbANvn5AMYBu+f7I/M2ef+2kpTLL4uIdyLiGWAasNki/I5mZtZF9Tq4d+nqk+cawGRgPeCXwN+B1/J1GwDTgQH5/gDgeYCImCfpdaBvLr+n6mmrH1N9rtHAaIBBgwZ1NXQzM6vSYc0iIp6LiOdIF+DNrNqeBazRmSePiPkRMRwYSKoNfLQbYu7oXGMjYkREjOjfv3+jTmNm1iN1poP7HGB21fbsXNZpEfEacCvpeo1VJFVqNAOBGfn+DNJUIuT9KwOvVpfXeIyZmZWgM8lCERGVjYh4l05cnyGpf2XCQUnLAdsBj5GSxl75sFHAtfn+hLxN3n9LPu8EYN88WmptYAhwXyfiNjOzbtKZi/KelnQkbbWJrwNPd+JxawLjcr/FUsAVEXGdpEeByyT9CHgAOD8ffz7wG0nTgJmkEVBExCOSrgAeBeYBh0XE/M79emZm1h06kywOBc4Avk8azXQzuSO5noiYAmxco/xpaoxmiog5wN4dPNfJwMmdiNXMzBqgMFlExEvkb/lmZtYzdZgsJH07In4q6UxSjWIh1fNFmZnZkq1ezeKx/HNSGYGYmVnr6jBZRMQf8s9xHR1jZmY9Q71mqD9Qo/mpIiJ2a0hEZmbWcuo1Q/2stCjMzKyl1UsWjwL9I+LR6sI8C+zLDY3KzMxaSr0ruM8E+tUo7wv8ojHhmJlZK6pXs1gvIm5vXxgRd0hapLmhrLbBx17f5ed4dszO3RCJmVl99WoWK9bZ17u7AzEzs9ZVL1lMk7RT+0JJO9K5uaHMzGwJUa8Z6mjgekn7kBYwAhhBmma8ywsjmZnZ+0e9xY+eAj4O3AYMzrfbgI0i4skygjMzs9ZQdyLBiHgHuLCkWMzMrEV1ZvEjMzPr4ZwszMys0GIlC0mXd3cgZmbWuha3ZrFlt0ZhZmYtzc1QZmZWqN4U5Zt0tAtfwW1m1qPUGzr78zr7Hu/uQMzMrHXVWynvs2UGYmZmrWuR+ywkbSfpxkYEY2ZmranDZCFpG0lPSpot6beSPi5pEjAG8BTlZmY9SL2axc+B0aTFjn4H3A1cFBGbRsTVZQRnZmatoV4Hd0TExHz/95JmRMRZJcRkZmYtpl6yWEXSntXHVm+7dmFm1nPUSxa3AbtWbd9etR2Ak4WZWQ9Rb+jswWUGYmZmraveFdzfaFcUwCvAnRHxTEOjMjOzllJvNNSK7W4rkZZV/ZOkfUuIzczMWkS9Zqgf1iqXtBpwE3BZo4IyM7PWsshXcEfETNJkgnVJWkvSrZIelfSIpKNy+WqSbpT0VP65ai6XpDMkTZM0pXoiQ0mj8vFPSRq1qDGbmVnXLM50H58FZnXi0HnANyNiKLAFcJikocCxwM0RMQS4OW8D7AgMybfR5KvEc03meGBzYDPg+EqCMTOzctTr4H6Y1KldbTXgn8BBRU8cES8AL+T7b0p6DBgAjAS2zoeNAyYC38nl4yMigHskrSJpzXzsjblGQ56Xagfg0k79hmZm1mX1rrPYpd12AK9GxFuLehJJg4GNgXuB1XMiAfgXsHq+PwB4vuph03NZR+XtzzGaVCNh0KBBixqimZnVUa+D+7nuOIGkFYCrgKMj4g2prbsjIkJS+9rLYomIscBYgBEjRnTLc5qZWdLQZVUl9SYliourpgd5MTcvkX++lMtnAGtVPXxgLuuo3MzMStKwZKFUhTgfeCwiTq3aNQGojGgaBVxbVX5QHhW1BfB6bq76M7C9pFVzx/b2uczMzEpSr8+iqz4FHAg8LOnBXPZd0noYV0g6BHgO2Cfv+yOwEzAN+DdwMKShupJOAu7Px51Y6ew2M7NyNCxZRMSddHw9xrY1jg/gsA6e6wLggu6LzszMFkVD+yzMzGzJ4GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZoYYlC0kXSHpJ0tSqstUk3Sjpqfxz1VwuSWdImiZpiqRNqh4zKh//lKRRjYrXzMw6tnQDn/si4CxgfFXZscDNETFG0rF5+zvAjsCQfNscOAfYXNJqwPHACCCAyZImRMSsBsbd4ww+9vouPf7ZMTt3UyRm1qoaVrOIiNuBme2KRwLj8v1xwO5V5eMjuQdYRdKawOeBGyNiZk4QNwI7NCpmMzOrrZE1i1pWj4gX8v1/Aavn+wOA56uOm57LOip/D0mjgdEAgwYN6saQrQxdrd2AazhmjdS0Du6ICFLTUnc939iIGBERI/r3799dT2tmZpSfLF7MzUvkny/l8hnAWlXHDcxlHZWbmVmJyk4WE4DKiKZRwLVV5QflUVFbAK/n5qo/A9tLWjWPnNo+l5mZWYka1mch6VJga6CfpOmkUU1jgCskHQI8B+yTD/8jsBMwDfg3cDBARMyUdBJwfz7uxIho32luZmYN1rBkERH7dbBr2xrHBnBYB89zAXBBN4ZmZmaLyFdwm5lZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVqhh61mYvR8NPvb6Lj3+2TE7d1MkZq3FNQszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyENnzVpMV4fvgofwWvdzzcLMzAq5ZmFmNfkCRavmmoWZmRVysjAzs0JOFmZmVsjJwszMCrmD28xalocRtw7XLMzMrJBrFmZmBTyM+H1Us5C0g6QnJE2TdGyz4zEz60neFzULSb2AXwLbAdOB+yVNiIhHmxuZmVk5mt1/836pWWwGTIuIpyPiP8BlwMgmx2Rm1mMoIpodQyFJewE7RMRX8/aBwOYRcXjVMaOB0XlzfeCJLp62H/BKF5+jO7RCHK0QA7RGHI6hTSvE0QoxQGvE0R0xfDgi+tfa8b5ohuqMiBgLjO2u55M0KSJGdNfzvZ/jaIUYWiUOx9BacbRCDK0SR6NjeL80Q80A1qraHpjLzMysBO+XZHE/METS2pKWAfYFJjQ5JjOzHuN90QwVEfMkHQ78GegFXBARjzT4tN3WpNVFrRBHK8QArRGHY2jTCnG0QgzQGnE0NIb3RQe3mZk11/ulGcrMzJrIycLMzAo5WZiZWaH3RQd3TyDpYaDDDqSI2KjEcBaQtCqwVkRMacb5W4GkvhHxarPjqJC0FLBCRLzR7FiseSQdBVwIvAn8GtgYODYi/tKI8/X4ZCHpG/X2R8SpJYWyS/55WP75m/xz/5LOv4CkicBupPfHZOAlSX+NiLqvVYNiEek1WCciTpQ0CFgjIu4rMYx7JD1I+sf8UzRhVIikS4BDgfmkoeQrSfpFRJxSchxN/3tI+gDwTWBQRHxN0hBg/Yi4rsQYPgKcA6weERtK2gjYLSJ+VFYMwFci4heSPg+sChxI+txoSLJwMxSsWHArRUQ8FxHPAdtFxLcj4uF8OxbYvqw4spXzt9Y9gfERsTnwuZJjqDgb2BLYL2+/SZpUskwfIQ1LPBB4StKP84dFmYbmv8nuwJ+AtXM8ZWuFv8eFwDs5DkgX6Jb5IQ1wHnAcMBcg17z3LTkG5Z87Ab/JlxOozvFd0uNrFhHxw2bH0I4kfSoi/po3Pkn5SX1pSWsC+wDfK/nc7W0eEZtIegAgImblCzNLk2sSNwI3Svos8Fvg65IeIlX77y4hjN6SepOSxVkRMVdSM8a9N/3vAawbEV+UtF+O4d+5xlOmD0TEfe1OO6/kGCZL+gvpi8NxklYE3m3UyXp8sqhokWolwCHABZJWJn1LmAV8peQYTiRdAPnXiLhf0jrAUyXHUDE3T1EfAJL608B/iFok9QUOIH2TfxE4gjSDwHDgStI/a6OdCzwLPATcLunDQDP6LJr+9wD+I2m5qhjWJdU0yvRKPm8lhr2AF0qO4RDSe/DpnDD7Agc37GwR4Vtqgr6NNBX6A1VlU5sYz8qk5qCmvzZN/rvsT/pgng6cTJpNeO+SY3gS+AEwsMa+7zTxtVm6h/49tsv/ry8DF5OS6NYlx7AOcBPwb1Iz2J3A4JJjEOlLzP/L24OAzRp1Pl/BnUm6PyI+IemBiNg4lz0YEcNLjmNZ4AvAYKpqfhFxYokxtEotqxLPR4FtSf8cN0fEYyWeuxfw04j4Zlnn7CCOWoMLXgcmR8SDJcWwFLAFMJMm/T2qYumbYxFwT0Q0ZXpwScsDS0XEm0049zmkWt02EbFBHrn4l4j4RCPO5w7uNq1QrQS4lrSw0zzgrapbmZreeSdptcoNeAm4FLgEeDGXlSIi5gOfLOt8dYwgjYYakG//DewAnCfp22UEEBHvAr+MiMcj4pcRcVaTEsUewLyIuD7SCKh5knYvOYYfS1olIt6KiDclrSqp7C9Tm0fEYcAcSP1HQMP6j1yzyHK7/FjSB8Ms4Blg/0gjlMqMY2pEbFjmOWvE0PRalqRnSIm70oNYeaOK1Oe8TomxnEP6gL6SqsQdEVeXGMPtwE4RMTtvrwBcT0oYkyNiaElx/Ay4G7g6mvThUeu9WP1eLSmG95xP0t8iYpMSY7iX9Hl1f6RBB/1JNYuGvA7u4GZBU8PXI+JzzaxWZndJ+nhEPNyk80ML1LIiooxO487qA7wKbFNVFkBpyQL4IAt34s4lNRO+LanMzt3/Br5B+jY/h7bkvVKJMdRqESn7s6yXpGUj4h2A3OG+bBJb/IoAABUESURBVMkxnAFcA3xQ0snAXsD3G3UyJwtSU4OkrfL9spt82tsK+HL+Zv0Obf+MZV7BfRiplvVRSTNItawDSjz/ApKuAs4HbsjNIKWLiMaNMOm8i4F7JV2bt3cFLslfbh4tK4iIKO3aozomSTqVtus7DiNdPFqmi4GbJV2Ytw8GxpUZQERcLGkybf1HuzeyWdDNUFkrNDXkOD5cq7zs5rAcS7NrWUj6HOkfcQvS3+bCiOjq+uqLGkNLdPhL+gRt/Sd/jYhJZZ6/Ko5VgSGkGhcAEXF7iedfnjQ6rXKh6I3Aj8r+oidpR9IHNcCNEfHnks67UkS80VHfXUTMbMh5nSySqm8I1SIiyr7GAQBJH2Thf8Z/lHDOAyLitx2MvCHKm/rkPfJ1J/uRLhJ8ntQJ/9uImFvCuW8DjgHOrerDaUrfUjPeF+3O/1XgKNLSxg+SkvjdEbFN3Qdat5F0XUTsUtWvt2AXDezPczNU1iJNDUjaDfg58CHSKKAPA48BHyvh9Mvnn63Q1LBAu4viHiA1AWwFjAK2LiGEpl+tW+N9MQh4nHLeF9WOAj5BGq762Tys+cdlBpBret/ivcPLG56wJN0ZEVtJepPaH9QN77uJiF3yz1L79ZwsMkl9SFdEfoyFv7mVXbM4ifRt7aaI2DhPL1FKf0FEnJs7+9+IiNPKOGcRSdcA65MmSNs1Iiod7ZdLKqsZpukd/jTxfdHOnIiYI4ncwfu4pPVLjuFK4FekmVbnl3zug6A1+m7yEOJbIuL1vL0K6eLE3zfifL7Oos1vgDWAz5OuDh1ImiStbHMjTYe9lKSlIuJW0hj7UuTrCvYrPLA850XE0Ij4v0qiyBcuEhFlvS6HkabbqHT4Hw38T0nnrmjq+6LK9Pyh9HvSXFnXAmX3p82LiHMi4r6ImFy5lXTuKwEk3VzS+eo5vpIoACLiNeD4Rp3MNYs260XE3pJGRsQ4pSmh72hCHK/lMfS3AxdLeonyL8r7q6SzgMtZuLP/byXHAWk20T+2K7sbKG08e0Q8DTR7WHUrvC+IiD3y3RMk3UqaluaGksP4g6Svk4aNLhg23KiO3XaWkvRdYP1afXsl9+uVOoTYyaJNpaP0NUkbAv8ijW0v20jgbeB/SfPwrEya2K9MlQueqs8bLHydQUNJWoM0Om05SRvTdnHeSsAHyoojx7LQFCyVvosocQoWWuN9gaSTSAnrroi4rezzZ6Pyz2OqyoI0X1Oj7Uua+bcXze/bK3UIsZNFm7F5SOAPSBOlrZDvlyb3F1wXEZ8lzflS6rjtinz+Zvs88GVSc+DPaUsWbwLfLTmWa8nzMFH+7KbAQtf/vCvpeuDVJl1B/TSpmfKM3Ml7B3B7RFxb/2Hdp8kXbO4QET/J/TWlJ+t2jiB9Rl2et2+kbfG0buehsy0mt4XuWd0W2YQYVia1fX46F90GnNiMmCR9ISKuKvu87WJo2hQskrYAxpAm7zuJ1LfWj9QEcVBElN0EVIlrDdJ6J98CVi27wzfX/oey8GCU8SWc98GIGF721B6twDWLLA/PPAH4FKlKewdwUpS/9vJs4GFJN7Jwf8GRJcZwATCV9GEAacjqhaSV88o2UNJKpBrFeaS+ioatM9yBZk7BchapJrUycAuwY0Tck4esXkrJ/QWSfk36kH6R9D+yF1BqX5ak40lDpoeS+rN2JE0R3vBkATwm6SngQ5Kq16UvbaYFSadHxNGS/sDCw3chBbFbQ87rmkWSP5xvJ62CBqldeOuIKHU5UUmjapVHRGlNUh1M1Fb6dO35vA9FxDCldYYPJc1985syv9VJehRYjzTtSalTsFS/7pIei4gNqvaVOnlePuc1pGs9HiXVOG/PAwDKjOFhYBhp7ZlhklYnXaC5XUnnXwOYSEqUIvV3vg3lzLQgadOImCzpM7X2N6ovyTWLNmtGxElV2z+S9MWygygzKdTxtqStIuJOAEmfIv8zNEH1OsPjI+IRqfQlNHcs+XzVqufDav83KP2bXmU0lKQNSP1Kt0rqFREDSwzj7Yh4V9K8XOt8CVirjBNLWpo0kWI/Up+i8rkvpKQliCvDhMseYOBk0eYvkvYFrsjbe5GWFi2FpCGkN9tM4FRSk8t/AX8HDil5HqD/AcapbWnXmaTO5mYodZ3hWiLiOUnDSH8PgDsi4qGSTj9M0hukv8Ny+T55u0/HD2sMSbuQXodPA6uQmsbKHmI+KV/rcR5p0MFs0nDqMpxCGgW1dmUIdU5YP8u3oxodQK5Z1fqi0NAar5uhsjyyY3naPoiWoq3PoOGX8UuqtLmuRBoeeTTwB9I/5o8iYvNGnr+DmFYCiIhmrPVciWEp2tYZfi33LQ2ItCBTWTEcBXyNtinJ9wDGRsSZZcXQKvL1N3eQEuY/m3B+kZa3fT5vDwZWKuv9kPsrPtJ+JFoeyfh4RAwpIYaak41WNKopzMmiRbRrm54WEevV2ldSLEeRqtXN7FSuxCJS/9E6EXGipEHAGhFxX4kxTAG2rAxfzRfn3V1Gn0WrkbRjRPypXdmhEfGrEmN4OCI+Xtb52p37yYj4yKLua2A8q5Pm6gK4LyJeatS5PN1HFUl7SjpV0s9V8jKNLNy00v6bfNnrOHwl1ya2B/qSRkONKTmGirOBLWmbguRN2i5CKotYeA6i+bT1pfQ0P5C04OJMpSVdR5Ycw9+UpmtvhkclHdS+UNIBpIkdSyNpH+A+YG/SyMV7leYtawj3WWSSziaNeLk0Fx0qabtIa9yW4aP5G6yAdauG5Ylyrkyt1gqdyhWbR1oy8gFI6wxLatg6wx24kPSPeE3e3p20IFNPtBtwnaRjSEu6fpTyk8XmwP6SniM1FZe5QNhhwNWSvkLb1dIjgOVIzZNl+h7wiUptQmlZ1ZuA3zXiZE4WbbYBNqi0RUoaBzxS4vk3KD6kNE3vVK4yN7cHV/4u/cuOJSJOlTSRNC06wMER8UCZMbSKiHhFabr0m0gflns14Uryz5d8vgUiYgawea5dVaaH/2NENGNiwaXaNTu9SgNbi9xnkUm6Djis0jmUO5HOiohdmxtZ+Wp0Kq9G6lQsrVO5Kpb9gS+S+k3GkdcZjogrSzh3U1Yka0V67/oNy5DW9AjKX4O7ElNTF4JqNkmnABvR1hryRWBKRHynIedzskiUVkP7BKkNkHz/fnL/QaOuimxF+bqKByPirdwWuwnwizIuOKqKYe2IeCbf/yht6wzfHA1cZ7hdDE1ZkczqUwcLhEVE2QtBNZ2kPWmr8d4REdfUO75L53KySNpdDSnSkNV9ga9D+RfANFPuLxlG+tZyEWmRmX0iouYVow2KYXJEbCrp5ojYtvgRVhZJA0gf0NWr1JW5BvdDpGbjhRaCiohDyoqhmfI1WT8D1gUeBr6Vm8cayn0WWUTcpjQV9pdIowueAX5VdpKQtCtwfUQ0q48A0uIyIWkkqSnufEll/yNW1g34iJq8bkCthNVTk5ikn5CaOx6lbYRYkKbKKcvciHhV0oKFoCSdXuL5m+0C0jVZtwO7AmdSwrxtPT5ZKK3nu1++vUKa7lfRvGm6vwicLukq4IKIKHU4XvampONIQ2b/K/dh9C45hsq6AUvTpHUDlJba/QDQT2n6+uo1NQY0I6YWsDuwfkQ0Zar2rLIQ1B00cSGoJloxIs7L95+QVMpEjj2+GUrSu6Q33SERMS2XPd3M9uh85fR+wMGkb20XApdGSSu0KU2U9iXg/oi4I18It3WUMAV0jVjecxFYiec+inQl/YeAGbQlizdIy72e1Yy4mknSn4C9I2J2E2NYnjRP1lK0LQR1cZQ/Q3RTSHqc9PlQeT9eTPp/FTRuRUsni3Tx3b6kqclvAC4Dfh3NXWClMmX6gaQPq8dI14CcUdYUE3k02JCIuEnSB4BeZSWrfP4DIuK3kr5J7WmYy2yGOqInTu1RS67xDgNuZuElTcucQr/p789mUlrOtiMREQ1Z0bLHN0NFxO+B3+dvKyNJH84flHQOcE3ZU1zkkR4Hk5LDeGCziHgp/0M8SmqfbHQMXwNGA6uROtEGAL8ijUgqy/L55wo19pX6DScizlSTFttpQRPyrWla5P3ZNM1qIu/xNYtacvv03sAXy+7EzBcDnl9rdImkbcu4+EfSg8BmwL2R10to5nw87Uk6OiJK69BUB4vtRETDplawjrX6+3NJ5bmhaoiIWRExthmjXSJiVCVRSOpXPc1GiVeJvhMR/6lsKM3h30rfKt4zOqrB9iJ9a/1XRBxMaoZZueQYmkrSFfnnw5KmtL+VHE6rvz+XSD2+GapVqM5ay5LKXmv5tjxsdTlJ25GuNflDiecvUvY8VU1bbKeFVNZp2KWpUSSt/v5cIrkZqkVImkTbWstjabfWcpS4fGYeKnsIadZZkRaB+nUT5gCqSdI/ImJQiec7m/S32Rf4JmmxnQdzLaPHyHN03dTEYeWVOFr6/VmW3OpQ2vT9ThYtQi201nLu7J8TEfPzdi9g2Yj4d4kxtJ+LaMEuYLmIaEqtWCUvttNqJN0M7BkRrzc7lp4uD8J5F9gmIjbIfa1/iYiGTN/uZqjW0UprLd8MfI70DRrS9Mt/AT5ZVgAR0ZQL8Wqpvlo7Ip5tX9bDzAYelnQjVRfClTF0Vh0vJ1qJoactRlXq9P1OFq2jldZa7lN90VVEzM5Dd3sUX8Fd09W0LS9btj2B1YHn25WvBfyr/HCartTp+50sWkRE9Gp2DFXekrRJ5UpQSZvy3tpOT/DftF3BPbmq/E2gx129DRAR4/KHEhHxcsmnPw04rv3sx3nQwWmkeZJ6kjOAa0jXhZ1Mnr6/USdzn4W9h9KSlZcB/yR9m16DdM3J5LoPXMLk12E6aYGfMyWNAr4APAucED1rPQsBxwOHk4bci7SexZkRcWJJMdzfUXt8T7vOInfyb0EaPVnK9P1OFlaTpN7A+nnziYiY28x4miFP0Pa5iJgp6dOkBHoEaWGoDXrSRXl55t8dgdHRts7IOsA5wA0RcVoJMTwVEUM62DctItZrdAytpOyBL74oz95D0mHA8hExNSKmAitI+nqz42qCXlW1hy8CYyPiqoj4AWk6lp7kQGC/SqIAiIingQOAg0qKYVKe6mMhkr7Kws2EPcXNkr5QfeFuI7lm0YLyrK+bkTqu7o+IUjvvqofxVpWV+i2mFUiaCgyPiHl5ps/RVVfXT42IDZsbYXnq/b5lvRaSVie10f+HtuQwgrTE6x5l/580Wx5evjxpXZE5uTiiQUvcuoO7xeRvSf8PuIXUDnmmpBMj4oISw+glSZWLnPKIi4YNyWthl5KuFn6F1MF/B4Ck9YCedp3BfxZzX7eJiBeBTyqtjFdJTtdHxC1lnL/VlD283DWLFiPpCeCTlbn5laYqvysi1q//yG6N4RTSspnn5qL/Bv4REd8qK4ZWkadhWZN0sdNbuewjwAqNWjegFUmaT+0FhkQaal324ljGglmqP503J0bEdY06l2sWredV0tDMijdzWZm+Q5oC+tC8PYU0IqrHiYh7apQ92YxYmqnFhnYbIGkM8AnS4kcAR0n6VEQc15DzuWbRWiSNBz4OXEvqsxhJ+rCeAuUt+qO29cj3AZ4GrooeuDKcWavKs/0Oj4h383Yv4IFGXcnumkXr+Xu+VVybfza8fVK11yNv2mIrZlZoFdK1FtDgafNds2hRSgvSEyWudawWXI/czGqTtB9pWYNbSX1HnyZd4X5ZQ87nZNFalJbv/A1pyUhI3/APiohHSjh3S65Hbma1SVqT1G8BcF8jhw87WbQYSXcB34uIW/P21sCPI6K0GV/Vth75fsA2pLXAS1+P3Mw6Vmvm40bOhuwruFvP8pVEARARE0kX3pQmIt6KiEsiYldgIPAAaYSUmTWZpD6SViPPhixptXwbTANnQ3bNosVIugb4G6kpCtJ0CptGxB7Ni8rMWoWko2ibDXkGbVPnvwGc16hRi04WLSavm/BDYKtcdAdphtNZzYvKzFqNpCMi4szSzudkYWb2/pGnzn++0pkt6SDS1PnP0cCp850sWky+1uFbwGCqroOJiG2aFZOZtY5mTZ3vi/Jaz5XAr4Bfk2aTNDOrVnPqfOAqSQ826qROFq1nXkSc0+wgzKxl9ZK0dETMI62SN7pqX8M+050sWkQeCgfwh7zQ0DXAO5X9PWkJTzOrqylT57vPokVIeoY0cWCtVa/CU26YWUUzps53sjAzs0K+grtFSPpEXk61sn2QpGslnVHVRGVm1hROFq3jXPLylHk43BjSnEyvA2ObGJeZmTu4W0hThsOZmXWGaxato5ekSvLeFqhehN5J3cyayh9CraMpw+HMzDrDo6FaSDOGw5mZdYaThZmZFXKfhZmZFXKyMDOzQk4WZnVIWkPSZZL+LmmypD/mfqRax66S5/UyW+I4WZh1QJJIEzpOjIh1I2JT4Dhg9Q4esgrQ8GRRNcTarDROFmYd+ywwNyJ+VSmIiIeAByTdLOlvkh6WNDLvHgOsK+lBSacASDpG0v2Spkj6YeV5JP1A0hOS7pR0qaRv5fLhku7Jx1+Tl9lF0kRJp0uaBHxP0jOSeud9K1VvmzWCv6GYdWxDYHKN8jnAHhHxhqR+wD2SJgDHAhtGxHAASdsDQ4DNSLMJT8hTubxNWgZzGNAb+FvVecYDR0TEbZJOBI4Hjs77lomIEfm5BwM7A78H9gWujoi53fi7my3EycJs0Qn4cf7gfxcYQO2mqe3z7YG8vQIpeawIXBsRc4A5kv4AIGllYJWIuC0fP460cmLF5VX3fw18m5QsDga+1g2/l1mHnCzMOvYIUGs94/2B/sCmETFX0rNAnxrHCfi/iDh3oULp6BrHdsZblTsR8VdJgyVtTZpXbOpiPqdZp7jPwqxjtwDLSlqwbKWkjYAPAy/lRPHZvA3wJqnWUPFn4CuSVsiPHSDpg8BfgV0l9cn7dgGIiNeBWZL+Kz/+QOA2OjYeuAS4sIu/p1kh1yzMOhARIWkP4HRJ3yH1VTwLnACcIelhYBLweD7+VUl/lTQV+FNEHCNpA+DuNLCK2cABEXF/7uOYArwIPEzb/F+jgF9J+gDwNKmJqSMXAz8izStm1lCe7sOsCSStEBGzc1K4HRi9qPN/SdoLGBkRBzYkSLMqrlmYNcdYSUNJfR3jFiNRnAnsCOzUiODM2nPNwszMCrmD28zMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRX6/+lB2PyLZGheAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "d1OnJmRmX7km"
      },
      "source": [
        "#Evaluate which Categories are correlated highest (and least high) with Clicks:\n",
        "lp_query = lp_query.iloc[:,:6]\n",
        "correlation_mat = lp_query.corr()\n",
        "sns.heatmap(correlation_mat, annot = True)\n",
        "plt.show()"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yc2BpPhXVUi0"
      },
      "source": [
        "#Optional: To unload the filterable table\n",
        "%unload_ext google.colab.data_table\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "_GK6tybfPA_1"
      },
      "source": [
        "##### Brand Queries"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NZrd1pTQJ-EV",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a2df6941-d903-492f-db69-b560500bb27b"
      },
      "source": [
        "brand_category_pivot = lp_query_brand.pivot_table(index='Category', values=['URL Clicks'], aggfunc={'URL Clicks': np.sum})\n",
        "brand_category_pivot = brand_category_pivot.sort_values(by='URL Clicks', ascending=False)\n",
        "brand_category_pivot.head(10)\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>URL Clicks</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Category</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Apparel</th>\n",
              "      <td>3015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lifestyle</th>\n",
              "      <td>978</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Accessories</th>\n",
              "      <td>525</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Stationery</th>\n",
              "      <td>420</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bags</th>\n",
              "      <td>294</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Drinkware</th>\n",
              "      <td>258</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Shop By Brand</th>\n",
              "      <td>228</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Clearance</th>\n",
              "      <td>133</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Office</th>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Frequently Asked Questions</th>\n",
              "      <td>39</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                            URL Clicks\n",
              "Category                              \n",
              "Apparel                           3015\n",
              "Lifestyle                          978\n",
              "Accessories                        525\n",
              "Stationery                         420\n",
              "Bags                               294\n",
              "Drinkware                          258\n",
              "Shop By Brand                      228\n",
              "Clearance                          133\n",
              "Office                              73\n",
              "Frequently Asked Questions          39"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 135
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "pjlcArzIK5Vw",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "019e2319-a7da-4d11-e52c-20fa118409bf"
      },
      "source": [
        "ax_category = brand_category_pivot.head(10).plot(kind='bar')\n",
        "ax_category.set_ylabel('URL Clicks')\n",
        "ax_category.set_title('Top 10 Brand URL Clicks by Category')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Text(0.5, 1.0, 'Top 10 Brand URL Clicks by Category')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 136
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAGXCAYAAABC9HxrAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debzc0/3H8ddbRKNiT0oqSBBqqQSxlSpV+xJUNfaqNvVrbNX6FdVSrVZLtUqrpRStvbYUpfbwsyVBI5IiDSqqhNiCIPH5/XHOJJObe+cbycx35ua+n4/HPO7MmeV87ty58/me5XuOIgIzM7NaFml2AGZm1vqcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVnYQk9SP0khadFmx1KkbayS/ibp4Hl43rOSvrCAdV8k6ccL8hq28HKy6IQkTau6fCjp3arb+9epjn0k3S/pHUl3t3P/IElj8v1jJA2q8Vp3S5qe43tD0khJn65HnPWQv5zXaFN2sqQ/5+tb5/d5mqS3JD0p6ZCi16hR35qSrpb0Sn4/xko6RlK3to+NiJ0i4uIF+f2aQcmRksZJelvS5Pw7F/7dO1Ny70qcLDqhiOhZuQD/BnarKru0TtVMBX4FnNb2DkmLATcAfwaWBS4GbsjlHTk8x7sccDfwp44e2KJfEv/J8S8FfAs4X9JaH/VFJK0OPAQ8D3w6IpYGvgQMBpasY7zNdhZwFHAk6W++JnA9sEszgyrSop+9luBksRCR9DFJv5L0n3z5laSP5fu2zkd3J+Qj2mdrtUIi4vaIuAr4Tzt3bw0sCvwqIt6LiF8DAj5fFGNEzASuANapivtkSX+R9GdJbwJfkbSJpAckvS7pRUnnVCejfOR5mKSn82N+I0n5vm6Szsi/5yTq+AUVyc2kZLr+fLzED4H7I+KYiHgxv+aTEbFfRLze9sG5Vfa1qttflzQht3DGS9qwneesLekZSfvm29+V9EJVq2jbGvH1knRbfuw9klbNr/EbSb9oU88ISd9qp/4BwHBg34i4M39G3omISyPitPyYXSQ9KulNSc9LOrnqJUbmn6/n1tzm+Tlfzb/7a5JurcSW79s+/25vSPptjv1r+b5FJJ0o6TlJL0u6RNLS+b5KK+ZQSf8G7pR0k6Qj2vxOYyXtWeN9W+g5WSxcvgdsBgwCBgKbACdW3b8i0AtYCTgYOG9+jo6BdYGxMedaMWNzeU35C39/4ME2dw0B/gIsA1wKzCQdwfcCNge2Bb7Z5jm7AhuTvrT3AXbI5V/P921AOmLfex5/r0L5i2f3HNfE+XiJL5B+z/mp+0vAycBBpBbO7sCrbR6zIXArcEREXJ7/vocDG0fEkqT36Nka1ewP/Ij0+z1G+ltAaj3uK2mRXE+v/Ltc1s5rbAtMjoiHa9Tzdv49liEl8/+RtEe+b6v8c5ncWn5A0hDgBGAvoDdwL3B5VSx/AY4HlgeeBD5TVddX8mUbYDWgJ3BOm3g+B6xNen8uBg6o3CFpIOl/5qYav89Cz8li4bI/cEpEvBwRU0hHsQe2ecz385HePaQP/z7zUU9P4I02ZW9Quxvl15JeB94ifXn9sM39D0TE9RHxYUS8GxFjIuLBiJgREc8Cvyf9Q1c7LSJej4h/A3eRkiT5d/pVRDwfEVOBn37k33Bun8zxvwtcBxwTEY/Ox+ssD7w4nzF8Dfh5RIzKLZyJEfFc1f2fBUYAB0XEjblsJvAxYB1J3SPi2Yj4V406boqIkRHxHungY3NJK+cv/jdIiQBgKHB3RLw0P79jRNwdEY/nv/dY0hd/279vtcOAn0bEhIiYAfwEGJRbFzsDT0TEtfm+XwP/rXru/sCZETEpIqaRksrQNl1OJ0fE2xHxLuk9XDO3kCD9D10ZEe/X+p0Wdk4WC5dPAtVfHs/lsorXIuLtGvfPq2mkI9tqS5ESQUeOjIhlgMVJR/1/kVTdjfN89YOVBoFvlPTf3DX1E9LRbrXqL4R3SEkM0u9U/XrV70l7ZgLd25R1Bz6ouv2fHP9SpC+jwi63DrwK9JnP564M1PqiP4zUxXV3pSAiJgJHk1okL0u6QlKtv/ms9y1/sU5l9mek+oj7ADoedyr8HSVtKukuSVMkvZFjb/v3rbYqcFbucnw9xyXSEf8cf+/c4p1c9dz2/i8WBVaoKqt+/nTgSuCA3JLat8bv2mU4WSxc/kP6p6pYhTnHHJaVtESN++fVE8D6lTGCbP1cXlM+kryX1IWzffVdbR56LvBPYEBELEXqghDz5kXSF2vFKgWP/zfQr01Zf9pJMvmI+7vAp6u6TT6K24EvzsfzIH2hrV7j/sOAVST9srowIi6LiC1Jn40AflbjNWa9b5IqExIqn5E/A0Nyt8zapAHr9twB9JU0uEY9l5GO4FfOg/y/Y/bft72lsJ8HvhERy1RdFo+I+0l/775Vcav6Nu3/X8wAqltFbeu8mNQi2RZ4JyIeqPG7dAlOFguXy4ETJfXO/bg/IP2DV/uhpMUkfZZ0hH91ey+UB4l7kI7AFpHUQ1Ll6Ptu0tH4kUqD6ofn8jvnJcg8YLkOtZPLksCbwDRJnwL+Z15eO7sqx9ZX0rLAcQWPv5L0vvXNYxJfAHajg7GF3B3xC9L7W22x/D5VLnNNhQVOAj4j6XRJKwJIWkNpcH+Zgjj/AHxH0kZK1qge5CW17HYEtpJUGUheS9LnlSY6TCd1o31Yo46dJW2Zx5Z+BDwYEc/n33syMIp0lH1N7rKZS0Q8DfwWuFxpYkXlfRkqqfK3WBKYGhHTJW0C7Ff1ElNyjKtVlf0OOF7Suvn3WjqP4UDqTv20pD1y19Jw0vhcxeXAtyT1zwnwJ6RupRkdvQk5OXxI+jt3+VYFABHhSye+kAYrv5Cv9yB1kbyYL78GeuT7tiY1zb8HvEI6mj6wxut+hXS0VX25qOr+DYAxpC+fR4ANarzW3aQvqmn5MhH4VtX9JwN/bvOcrUgti2mkwcxTgPuq7g9gjarbFwE/ztcXBX5J6g55hvTlEcCiHcS3OHB6fi/fyL/P7lX3b00asK1+zsfz+7hbVTxtL1/roL61SEn61VzfP0hdRd1ILZxZseb37mtVzz2MNIA7DRhXed/bfA6Wy6/5I1KL72FSIpkK3Ah8soO4LiJ9Kd+WX38k0L/NYw7I8W1T8LkUaersE6QuwhdISXndfP/epJbbWzmmc6o/A/nvPQV4Hdgslx0IPE46iHgeuLDq8TsCT+X387fAA+TPN+mg+Af5OVPIU77zfXO8321+hxPzfas1+/+8FS7Kb4ot5CRtTfpn7Fv0WLOOSNqK9GW7arTol0ceZ5gM7B8Rdy3A6xwEDIvUhdfluRvKzOZJ7oY8CvhDqyUKSTtIWiZ3t1XGt9pOz/4or/dx0lTt8+oUYqfnZGFmhSStTeoS6kM6s7/VbE6aKfYKabxpj+hgTKWIpB1I3VUv0f55JF2Su6HMzKyQWxZmZlZooVw0q1evXtGvX79mh2Fm1qmMGTPmlYjo3d59C2Wy6NevH6NHj252GGZmnYqkDlc7cDeUmZkVcrIwM7NCThZmZlZooRyzMLPO74MPPmDy5MlMnz692aEsdHr06EHfvn3p3r3tYssdc7Iws5Y0efJkllxySfr168ecCxzbgogIXn31VSZPnkz//v3n+XnuhjKzljR9+nSWX355J4o6k8Tyyy//kVtsThZm1rKcKBpjft7XhiWLvH79w5L+IekJST/M5f0lPSRpoqQr87r55H0RrszlD0nqV/Vax+fyJ/O6LWZmVqJGjlm8B3w+Iqbl1Srvk/Q34BjglxFxhaTfAYeSdkU7lLTt5xqShpJ28/qypHVI+/2uS9oe8XZJa0bEzAbGbmYtpt9xN9X19Z49bZfa9z/7LLvuuivjxo2bVXbyySfTs2dPvvOd7/CVr3yFe+65h6WXXpqI4Mwzz2TbbdMW5VtvvTVnnHEGgwd3vFngU089xdFHH83TTz/NkksuyRprrMHZZ5/NhAkTOOOMM7jxxhsZMWIE48eP57jj2t+/q70YG6VhySIvYTwt3+yeL0Hau7iyK9bFpI1vzgWG5OuQdig7J2+POAS4ItJ2ls9ImghsQtrcZL7V44NX9GEzs4Xb6aefzt57781dd93FsGHDePrpp+fpedOnT2eXXXbhzDPPZLfddgPg7rvvZsqUKXM8bvfdd2f33Xeve9zzo6FjFnlrzseAl0m7b/0LeD1mb2c4mbThOvlnZfvGGaQdr5avLm/nOdV1DZM0WtLotm+4mVkjbb755rzwwgvz/PjLLruMzTfffFaigNQaWW+99eZ43EUXXcThh6ddi1966SX23HNPBg4cyMCBA7n//vvneOykSZPYYIMNGDVqFE888QSbbLIJgwYNYv3115/nJFZLQ6fO5q6iQXlv4euATzWwrvPIG5UMHjzY666bWWluueUW9thjj3l+/Lhx49hoo40+Uh1HHnkkn/vc57juuuuYOXMm06ZN47XXXgPgySefZOjQoVx00UUMHDiQI444gqOOOor999+f999/n5kzF7zXvpTzLCLidUl3kTYoWUbSorn10Je0Ny/558rA5Lzp+tKkPYor5RXVzzEza4iOZgxVlx977LGccMIJTJ48mQceWKCe8UJ33nknl1xyCQDdunVj6aWX5rXXXmPKlCkMGTKEa6+9lnXWWQdILZ1TTz2VyZMns9deezFgwIAFrr+Rs6F65xYFkhYHtgMmAHeRNmsHOBi4IV8fkW+T778zj3uMAIbm2VL9gQGkDejNzBpm+eWXn3XkXjF16lR69eo16/bpp5/OU089xc9+9jO++tWvzvNrr7vuuowZM6YucS699NKsssoq3HfffbPK9ttvP0aMGMHiiy/OzjvvzJ133rnA9TRyzKIPcJekscAo4LaIuBH4LnBMHqheHrggP/4CYPlcfgxwHEBEPAFcBYwHbgGGeyaUmTVaz5496dOnz6wv2qlTp3LLLbew5ZZbzvXYww8/nA8//JBbb711nl57v/324/777+emm2ZPtBk5cmTNWU3bbrst5557LgAzZ87kjTfeAGCxxRbjuuuu45JLLuGyy9IusJMmTWK11VbjyCOPZMiQIYwdO3befukaGjkbaiywQTvlk0izmdqWTwe+1MFrnQqcWu8YzazzaMbsw0suuYThw4dzzDHHAHDSSSex+uqrz/U4SZx44on8/Oc/Z4cd0qlgu+yyy6y1lzbffHOuvvrqWY9ffPHFufHGGzn66KM5+uij6d69O+uvvz5nnXUWr7zySruxnHXWWQwbNowLLriAbt26ce6559KnTx8AllhiCW688Ua22247evbsyfjx4/nTn/5E9+7dWXHFFTnhhBMW+L1YKPfgHjx4cBRtfuSps2atbcKECay99trNDmOh1d77K2lMRLR7coiX+zAzs0JOFmZmVsjJwsxa1sLYTd4K5ud9dbIws5bUo0cPXn31VSeMOqvsZ9GjR4+P9DxvfmRmLalv375Mnjx5rvWSbMFVdsr7KJwszKwlde/e/SPt5GaN5W4oMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFGpYsJK0s6S5J4yU9IemoXH6ypBckPZYvO1c953hJEyU9KWmHqvIdc9lEScc1KmYzM2tfI/fgngF8OyIekbQkMEbSbfm+X0bEGdUPlrQOMBRYF/gkcLukNfPdvwG2AyYDoySNiIjxDYzdzMyqNCxZRMSLwIv5+luSJgAr1XjKEOCKiHgPeEbSRGCTfN/EiJgEIOmK/FgnCzOzkpQyZiGpH7AB8FAuOlzSWEkXSlo2l60EPF/1tMm5rKPytnUMkzRa0ugpU6bU+TcwM+vaGp4sJPUErgGOjog3gXOB1YFBpJbHL+pRT0ScFxGDI2Jw79696/GSZmaWNXLMAkndSYni0oi4FiAiXqq6/3zgxnzzBWDlqqf3zWXUKDczsxI0cjaUgAuACRFxZlV5n6qH7QmMy9dHAEMlfUxSf2AA8DAwChggqb+kxUiD4CMaFbeZmc2tkS2LLYADgcclPZbLTgD2lTQICOBZ4BsAEfGEpKtIA9czgOERMRNA0uHArUA34MKIeKKBcZuZWRuNnA11H6B27rq5xnNOBU5tp/zmWs8zM7PG8hncZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWqGHJQtLKku6SNF7SE5KOyuXLSbpN0tP557K5XJJ+LWmipLGSNqx6rYPz45+WdHCjYjYzs/Y1smUxA/h2RKwDbAYMl7QOcBxwR0QMAO7ItwF2AgbkyzDgXEjJBTgJ2BTYBDipkmDMzKwcDUsWEfFiRDySr78FTABWAoYAF+eHXQzska8PAS6J5EFgGUl9gB2A2yJiakS8BtwG7NiouM3MbG6ljFlI6gdsADwErBARL+a7/guskK+vBDxf9bTJuayj8rZ1DJM0WtLoKVOm1DV+M7OuruHJQlJP4Brg6Ih4s/q+iAgg6lFPRJwXEYMjYnDv3r3r8ZJmZpY1NFlI6k5KFJdGxLW5+KXcvUT++XIufwFYuerpfXNZR+VmZlaSRs6GEnABMCEizqy6awRQmdF0MHBDVflBeVbUZsAbubvqVmB7Scvmge3tc5mZmZVk0Qa+9hbAgcDjkh7LZScApwFXSToUeA7YJ993M7AzMBF4BzgEICKmSvoRMCo/7pSImNrAuM3MrI3CZCFpdWByRLwnaWtgfdKspddrPS8i7gPUwd3btvP4AIZ38FoXAhcWxWpmZo0xL91Q1wAzJa0BnEcaP7isoVGZmVlLmZdk8WFEzAD2BM6OiGOBPo0Ny8zMWsm8JIsPJO1LGoy+MZd1b1xIZmbWauYlWRwCbA6cGhHPSOoP/KmxYZmZWSuZl9lQi0fEkZUbOWE80cCYzMysxcxLy+J8SetVbuQuqe83LiQzM2s189Ky2Bv4i6T9gM8CB5FOjDMzsy6iMFlExCRJQ4HrgX8D20fEuw2PzMzMWkaHyULS48y5yN9yQDfgIUlExPqNDs7MzFpDrZbFrqVFYWZmLa3DAe6IeC4iniOdgDe16vZrwIplBWhmZs03L7OhzgWmVd2elsvMzKyLmJdkobzIHwAR8SGNXa3WzMxazLwki0mSjpTUPV+OAiY1OjAzM2sd85IsDgM+Q9qdbjKwKTCskUGZmVlrmZfzLF4GhpYQi5mZtaha51n8b0T8XNLZzHm+BQDV60WZmdnCrVbLYkL+ObqMQMzMrHV1mCwi4q/558XlhWNmZq2oVjfUX2mn+6kiInZvSERmZtZyanVDnVFaFGZm1tJqJYvxQO+IGF9dKGkdYEpDozIzs5ZS6zyLs4Fe7ZQvD5zVmHDMzKwV1UoWa0TEyLaFEXEv4OXJzcy6kFrJYska93WvdyBmZta6aiWLiZJ2blsoaSe8NpSZWZdSK1kcDfxK0kWSjsiXi0njFUcVvbCkCyW9LGlcVdnJkl6Q9Fi+7Fx13/GSJkp6UtIOVeU75rKJko6bv1/TzMwWRK3Nj54GPg3cA/TLl3uA9SPiqXl47YuAHdsp/2VEDMqXm2HWDKuhwLr5Ob+V1E1SN+A3wE7AOsC++bFmZlaimgsJRsR7wB/n54UjYqSkfvP48CHAFbm+ZyRNBDbJ902MiEkAkq7Ijx3f/suYmVkjzMsS5fV2uKSxuZtq2Vy2EvB81WMm57KOyuciaZik0ZJGT5ni00DMzOqp7GRxLrA6MAh4EfhFvV44Is6LiMERMbh37971elkzM2M+k4WkK+fneRHxUkTMzFuzns/srqYXgJWrHto3l3VUbmZmJZrflsXm8/MkSX2qbu4JVGZKjQCGSvqYpP7AAOBhYBQwQFJ/SYuRBsFHzGfMZmY2nwp3yptfki4HtgZ6SZoMnARsLWkQaTXbZ4FvAETEE5KuIg1czwCGR8TM/DqHA7cC3YALI+KJRsVsZmbtq7VE+YYd3cU8nMEdEfu2U3xBjcefCpzaTvnNwM1F9ZmZWePUalnUGnz+Z70DMTOz1lVrp7xtygzEzMxa10ce4Ja0naTbGhGMmZm1pg6ThaTPS3pK0jRJf5b0aUmjgdNI50uYmVkXUatl8QtgGGmzo78ADwAXRcRGEXFtGcGZmVlrqDXAHRFxd75+vaQXIuKcEmIyM7MWUytZLCNpr+rHVt9268LMrOuolSzuAXaruj2y6nYAThZmZl1Eramzh5QZiJmZta5aZ3Af06YogFeA+yLimYZGZWZmLaXWbKgl21yWAgYDf5M0tITYzMysRdTqhvphe+WSlgNuB65oVFBmZtZaPvIZ3BExlbSYoJmZdRHzs9zHNsBrDYjFzMxaVK0B7sdJg9rVlgP+AxzUyKDMzKy11DrPYtc2twN4NSLebmA8ZmbWgmoNcD9XZiBmZta65ncPbjMz60KcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvUsGQh6UJJL0saV1W2nKTbJD2dfy6byyXp15ImShoracOq5xycH/+0pIMbFa+ZmXWskS2Li4Ad25QdB9wREQOAO/JtgJ2AAfkyDDgXZi2HfhKwKbAJcFIlwZiZWXkaliwiYiQwtU3xEODifP1iYI+q8ksieRBYRlIfYAfgtoiYGhGvAbcxdwIyM7MGK3vMYoWIeDFf/y+wQr6+EvB81eMm57KOyuciaZik0ZJGT5kypb5Rm5l1cU0b4I6IYO4l0Bfk9c6LiMERMbh37971elkzM6P2EuWN8JKkPhHxYu5mejmXvwCsXPW4vrnsBWDrNuV3lxBnKfodd9MCv8azp+1Sh0jMzGoru2UxAqjMaDoYuKGq/KA8K2oz4I3cXXUrsL2kZfPA9va5zMzMStSwloWky0mtgl6SJpNmNZ0GXCXpUOA5YJ/88JuBnYGJwDvAIZD2+5b0I2BUftwpeQ9wMzMrUcOSRUTs28Fd27bz2ACGd/A6FwIX1jE0MzP7iHwGt5mZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFWpKspD0rKTHJT0maXQuW07SbZKezj+XzeWS9GtJEyWNlbRhM2I2M+vKmtmy2CYiBkXE4Hz7OOCOiBgA3JFvA+wEDMiXYcC5pUdqZtbFLdrsAKoMAbbO1y8G7ga+m8sviYgAHpS0jKQ+EfFiU6JcCPU77qYFfo1nT9ulDpGYWatqVssigL9LGiNpWC5boSoB/BdYIV9fCXi+6rmTc9kcJA2TNFrS6ClTpjQqbjOzLqlZLYstI+IFSZ8AbpP0z+o7IyIkxUd5wYg4DzgPYPDgwR/puWZmVltTWhYR8UL++TJwHbAJ8JKkPgD558v54S8AK1c9vW8uMzOzkpSeLCQtIWnJynVge2AcMAI4OD/sYOCGfH0EcFCeFbUZ8IbHK8zMytWMbqgVgOskVeq/LCJukTQKuErSocBzwD758TcDOwMTgXeAQ8oP2cysays9WUTEJGBgO+WvAtu2Ux7A8BJCMzOzDrTS1Fnrwjx916y1ebkPMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIZ+UZ1ZlQU8O9ImBtrByy8LMzAq5ZWHWYrz0ibUityzMzKyQWxZm1i6P31g1tyzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIU+dNbOW5RMUW4dbFmZmVsjJwszMCjlZmJlZIY9ZmJkV8NInblmYmdk86DQtC0k7AmcB3YA/RMRpTQ7JzKw0zZ4Z1ilaFpK6Ab8BdgLWAfaVtE5zozIz6zo6RbIANgEmRsSkiHgfuAIY0uSYzMy6DEVEs2MoJGlvYMeI+Fq+fSCwaUQcXvWYYcCwfHMt4MkFrLYX8MoCvkY9tEIcrRADtEYcrRADtEYcrRADtEYcrRADLHgcq0ZE7/bu6DRjFkUi4jzgvHq9nqTRETG4Xq/XmeNohRhaJY5WiKFV4miFGFoljlaIodFxdJZuqBeAlatu981lZmZWgs6SLEYBAyT1l7QYMBQY0eSYzMy6jE7RDRURMyQdDtxKmjp7YUQ80eBq69altYBaIY5WiAFaI45WiAFaI45WiAFaI45WiAEaGEenGOA2M7Pm6izdUGZm1kROFmZmVsjJwszMCnWKAW5rHknLAitHxNgm1L18RLxadr21SFoE6BkRbzY7lrJIehzocHAzItYvMRyrIml1YHJEvCdpa2B94JKIeL3udXX1AW5Jx9S6PyLOLCuWCkkC9gdWi4hTJK0CrBgRD5dU/93A7qSDiTHAy8D/RUTN96oBcTwNPAb8EfhbNOnDKuky4DBgJmka91LAWRFxeslxNOVzIWnVfHV4/vmn/HN/gIg4rpH1txPPx4FvA6tExNclDQDWiogbS45jTeBcYIWIWE/S+sDuEfHjEmN4DBgM9ANuBm4A1o2Inetdl7uhYMmCSzP8Ftgc2Dfffou0kGJZls5HznuRjlI2Bb5QYv0Va5KmAh4IPC3pJ/kftGzr5PdjD+BvQP8cU9ma8rmIiOci4jlgu4j434h4PF+OA7ZvdP3t+CPwHum9gHSCbmlf0FXOB44HPgDIre+hJcfwYUTMAPYEzo6IY4E+jaioy3dDRcQPmx1DOzaNiA0lPQoQEa/lkxHLsqikPsA+wPdKrHcOuSVxG3CbpG2APwPflPQP4LiIeKCkULpL6k5KFudExAeSmtHKafbnQpK2iIj/yzc+Q3MOOFePiC9L2hcgIt7Jra6yfTwiHm5T9YySY/ggvw8HA7vlsu6NqMgti8gRFXoAAB1YSURBVEzSmpLukDQu315f0olNCueDvCx75Fh6Ax+WWP8ppBMg/xURoyStBjxdYv1AGrOQdJSk0cB3gCNIC6V9G7isxFB+DzwLLAGMzN0yzRizaPbn4lDgt5KelfQcqaXz1RLrr3hf0uLMfh9WJ7U0yvZKrrsSx97AiyXHcAiphXVqRDwjqT+zuwnrKyJ8SV3h95CWQn+0qmxck2LZn7ScyWTgVNIKul9q9nvUhPfhKeD7QN927vtuk2NbtKt+LoClSV2VzXrvt8v/r1OAS0mJfOsmxLEacDvwDqkr7D6gX7Pel0ZfuvwAd4WkURGxsaRHI2KDXPZYRAxqUjyfArYFBNwRERNKrLsVBu66AT+PiG+XVWeNWNob2H8DGBMRj5UUwyLAZsBUmve5+BjwRdJg6qwu7Ig4pawYqmJZnvR+CHgwIpq2PLikJYBFIuKtJtS9BXAysCrpbyJSD+5q9a6ry49ZVGl6k1LSclU3XwYur74vIqaWFMr5wLGk7hciYmyeEVRasoiImblPvBUMzpe/5tu7AmOBwyRdHRE/b3QAEfGhpN/kA5l/Nrq+DtxATpI0p9sHAEl7AndGxE359jKS9oiI60uO4yekA5rX8+1lgW9HRJnd1xcA3yL9TWY2siK3LLLcL38e8BngNeAZYP9Is0DKiuEZUrKqjJhV/jgNO1roII6WaGVJOhdYCbgaeLtSHhHXlhzHSGDniJiWb/cEbgJ2JLUuStniV9IZwAPAtdGEf1xJ4yJivbLrbSeOuT6L1Z/VEuOYq05Jj0TEhiXG8FCk2YoN55YFs7o8vhkRX2hmkzIi+pddZwea3srKegCvAp+vKgug1GQBfII5j6Q/IHXRvSupzCPsbwDHADMkTWf2QcRSJdV/v6RPR8TjJdXXkfYm5jTju6ybpI9FxHsAedD9YyXHcJek00n/E7M+ixHxSL0rcrJgVpfHlvn620WPbzRJ15Cal7dERJmzXSqGk1pZn5L0AqmVdUDZQUTEIWXX2YFLgYck3ZBv7wZclg8sxpcVREQ067yfii2Br+QW8HvMTlZln8E9WtKZzD7HZDipG6ZslwJ3SPpjvn0IcHHJMVRaFdW74wVzHmDVhbuhslbp8sixfIH0wdssx/PHiFjQPcXnJ46mtbJy/U0faK+KZWNSFyWks9lHlx1DjmNZYACp1QVARIwsqe5V2ysvs6s2x7EEaZZc5UTR24AfN+NAT9JOpAkHALdFxK1lx1AWJ4us6uigWkREM+aRAyBpadLZut8DnicNPP85Ij5oUH0HRMSfO1oCJUpe+kTSPeSB9qqxk6b1m0v6BHN+Sf+75Pq/BhxF2lb4MdLBxAMRUfejyII4mvo+2Gz5O+IkYKtcdA9wSkS8Ue+63A2VtVCXBzBrauABpGUlHiU1ebcknam5dYOqXSL/bHZ3R0UrnCGLpN2BXwCfJM1SW4U0I2ndkkM5CtiYNFV0mzy9+idlVd7O+7AqMIGS34fc4vwOc0/hLSVpSrovIraU9BZzLrBY9hgSwIXAONJqC5C+L/5IWqqnrpwsMkk9SGeorsucR02ltywkXQesRToTc7eIqAwuX5nPZm6IiPh9Hux/MyJ+2ah6PoJWGWj/Eeko/vaI2EBp6ZHSx3CA6RExXRJ5YPWfktYqsf5WeR+uBn4H/IEGTxftwEHQEmNIkJY++WLV7R8qLS5Yd17uY7Y/ASsCO5Cacn1JC7U1w/kRsU5E/LSSKPIJUUTE4NpPXTARMZPZC9U123DSuR6Vgfajgf9pQhwfRFoqfRFJi0TEXcw5oFiWyZKWAa4nrZd1A1DmeEGrvA8zIuLciHg4IsZULiXWfzWApDtKrLMj71Ym58Csk/TebURFHrPIKnOmJY2NiPWVFo67NyI2a0Isc83VLnP+tqRfkhYju5I5B/vrPh1vHuNp9kD77aRFBH9KWpvqZWDjiGjaSYOSPkdaduOWiHi/pDpb4n2QdHKu+zrmnC5aykmrSgs5Xg18E5hrHK/MsT1Jg0gzsJYmdYNNBb4SEf+od13uhpqtMmj8uqT1gP+S5teXRtKKpBlZi0vagNkn5y0FfLzEUConPFUv49CQ6Xi1tF1eojJ20YTlJYaQjta+RVqfaWnmfG9KIelHwEjg/oi4p+z6aZH3gTRuB2nyQ0WQ1moqw1BS0uxGk8f38nIzAyUtlW83bIFLJ4vZzsvTEr9PWqytZ75eph2Ar5C6wH7B7GTxFnBCWUFExDZl1VWgJZaXqJqS+aGkm4BXm3EGNTCJ1EX46zy4ei8wMiJuqP20BZfHsm7Mn40PKf98glla4OTVHSPiZ3ncqBnJssOZi1UHVHVv3bgbqgVJ+mJEXNPE+kubjlcQR1OXl5C0GXAaqWn/I9K4Vi/SWN9BEXFLk+JakTT75TvAsmUNtOY++r3K/hx0EMt6wDrMORnlkpLqfiwiBpW9tEebGL6RJ6Sc1M7d0Ygk5pZFlqeqngxsQWrS3gv8KJqzB3Tf3Kx8i3RuxYakzX7+XlL9pU3HK9Ds5SXOIbXolgbuBHaKiAfzlNXLgVKThaQ/kL4gXyJ9PvcGyhxHmgY8Luk25hzLOrLEGMhfkFuT3oubgZ1Iy4OXkiyACUpb/n5SUvXe9KWd0R4Rv89Xb4+8GdWsINIgd925ZZHlf4CRpN3YIPXJbh0RpW8nKukfETFQ0g6kvZ9PBP5U4gB3ewu1NWMhwfHAGqTlRkpfXqL6d5Y0ISLWrrqvGQvXXUc6x2E8qbU3MiImlVj/we2VR0SpXVKSHgcGkvaeGShpBdLJqtuVGMOKwN2khC3SmOe7UO4Z7WVOhnHLYrY+EfGjqts/lvTlJsVSGavYmbQH9hNSqdtGvitpy4i4Dxo7Ha/ATk2os1r1ulxtf//Sj7IiYk8ASWuTxrfuktQtIvqWVH/TxinaeDfSku0zcgv8ZWDlsiqXtChpQcdepLEb5fr/SEnbEEvanLT8TO824xZLkQbe687JYra/SxoKXJVv703aWrQZxkj6O9AfOF7SkpS7feb/ABfnsYtZ0/FKrB9IR2iSBgKfzUX3NmJKYA0DJb1Jeg8Wz9fJt3t0/LTGkLQr6b3YCliG1DV2bwn1DiB9CU4lTRU9P8fxL+DQJqyTNTqfb3I+afLDNNLS7WU5nTQLqn9lOndOWmfky1ElxLAYaRLOosw5I+tN0ndX3bkbKsuzS5Zg9pfyIszuly31FH6lXdEGAZMi4vU8nrJSRIwteGq942j4dLyC+o8Cvs7sJcn3BM6LiLObEU+zSTqHlBzujYj/lFhvZTxgKdK02aNJG0F9lrSAXyn7KeRYRNpm9/l8ux+wVJn/G3m8Ys22M+LyjLF/RsSAEmNZtdLtlb83ejbq/9VncGcRsWRELBIRi+bLIrlsyTITRSUc0uBdZeBwCUo8kpV0VNUA+5mSHpG0fVn1VzkU2DQifhARPyAtNfH1JsTRKm6KiCurE4Wkw0qot2dEnBcRZ5C6gK6OiOkRcRsl79+Qv6Bvrrr9bNkHUTmMuY6yI61+UPbR908lLZVPXB0HjJd0bNGT5oeTRRVJe0k6U9IvJO3RxFB+C2zO7GU33mL22v1l+Go+OtkeWJ40G+q0EuuvEHOu/TOT2eM5XdH3Jc06MVLS/5JOlGu06i7Qtketzdhv5RGlJeObZbykg9oWSjqA8re8XSf/r+4B/I3UdX1gIyrymEUm6bekmTeVfa8Pk7RdRAxvQjibRsSGeVkBIuI1SYuVWH+zB9gr/kjadOi6fHsP0qZQXdXuwI35yHFH4FOUkyw+laeICli9arqoKO+s6WqbAvtLeo7UVVz2JkzDgWslfZXZmy4NBhYndZWWqbvS0kR7AOdExAeSGtK6cbKY7fPA2pXmpaSLgSeaFMsHuf+zEktvyj2Ca/YAO5DOQpV0N2lpdoBDIuLRsuNoFRHxitIy4beTvqT2LulM8rWLH1KqHZpZeUS8AGyaW3mV5dlvjohmLCz4e+BZ4B/ASKUNqhoyZuEB7kzSjcDwqsGiVUmZercmxLI/8GXSyXgXk2Y3nBgRV5dUf9sB9uVIg4ql9A1LWioi3sz1ziVKWjCuVWjufRMWI+3rEZS/f0LLkDdhapekRSOi7vu+OFlkSruybQw8nIs2BkaRs3RE7F5CDP0j4pl8/VOk7RoF3BERExpdf1UcWwCPRcTbuR92Q+Cssk42knRjROyqtNdze5vLNKPrw1qEOtiEKSLK3oyq6fIJiT8BPhkRO0laB9g8IureXetkkSkt+TzrJmla4FDSMsRECat8ShoTERtJuiMiti1+RsPiGEs6Q3Z94CLSJjP7RMTnaj3PGk/SSqQvx+od4krZg7tVSPoHqdt4jk2YIuLQJodWOkl/I58MmM9mX5R0Zvun612XxyyyiLhHaVnw/YAvkZaY+F0ZSaLKIpJOANZUO/tgR3nr5M+IiJA0hNQVd4Gk0v8R20uazU6kzSTpZ6TuyfHMniUWpGVqyqh/N9L03WbMgKr2QUS8KmnWJkySftXkmJqlV0RcJel4gIiYIakhuwd2+WShtJ/vvvnyCmnDH0VzlumurJPf9qzMsr2VP3wHAp/NYxjdy6pcaYvbjwO9lJaNr97XY6Wy4mhBewBrRUSzlmv/MvArSdcAF0ZE2dNEK16X1JN0guKlkl6mamHDLubtfNJuZTLMZqRl/euuy3dDSfqQ9KE7NCIm5rJJzewXl7RTRPytifWvSGphjYqIeyWtQlpUsawloI8inSX8SeAFZieLN0lbzp5TRhytJnc5fCkipjUxhqVIB1aHkL6g/ghcHiXuYphPQHuXdJ5YZROmS6M5K0Q3laQNgbOB9Ugn5fUmzZKr+2QUJ4t08t1Q0tLktwBXAH+IJmywotkbmnybds4ELbEbqjIbbEBE3C7p40C3Mr8QcgxHdNWlPdqTj+gHAncw53aiZS8RXjlR82hgAun8pF+X+bdqhc9nq8jjFGuRDqqejIgPCp4yX7p8N1REXA9cn49WhpD+AT4h6VzguihvDwlIy3pAWiCsrdKyuqSvA8OA5YDVSV0/vyPNzipNRJytJm5y04JG5EtT5FlIh5CSwyXAJhHxcv6yHk86wi0jjpb4fLaCds4k31BSQ/5HunzLoj25n/xLwJdbZTBV0tERUcognqTHgE2AhyLv2SDp8UbMsCiIo91NbiKiIatqWm35RNUL2pt9JWnbsk5Ka5XPZyuQVJ2ge5AS5iON+B9xsugkJP07IlYpqa6HImJT5Q1+cjP3kRKXU6jE0fRNblqBpKsiYp/8frTXPVnq3yXH1Ism7UXeKp/PVqS0dPsVEbFjvV+7y3dDdSJlrs10T57Cu7ik7Ujnmvy1xPormrrJTQup7I+wazMqV429yCU1Yy/yVvl8tqK3Scv01J2TRedR5hHccaTlwR8HvkHqAvpDifVXNHuTm5YQES/mtcIuatKU7pbai5zW+Xw2naS/Mvu7YRFSl+1VHT9jAepyN1TraGcNoFl3AYtHRCnJPQ/2T4+0Pn9lU5ePRcQ7ZdTfQUz9KHmTm1Yj6Q5gr4hoyDz6GvW21F7kNlublSdmAM9FxORG1OWWRQuJiGaeiFftDuALpCN5SEsv/520529pqs/Wjohn25Z1QdOAxyXdRtVJaCVMnW2Jvcg7GrOZFUjXHLP4D7NXBX6kUYkCnCysfT2qT/yKiGl5emQpfAZ3h65l9hazZWqVvcj3AlYAnm9TvjLw3xLjaLrcPXsRaf22x3LxLyXdDhwG7FDvsSQnC2vP25I2jIhHACRtxNxHlI30DWafwT2mqvwtUv95lxQRFyvtbUJETCmx3m5l1VXgl8DxbVc/zpMffgmUvp1AE51NShJ7VdbqkiTgRNJg/5r5Ujces7C5KG1ZeQWpiStgRdI5J2NqPrG+9U8mLVtwtqSDgS+SNnk5ObrefhYCTgIOJw1iitQ/fXZEnNLM2MokaVREtLudalc7z0LS0xExoIP7Xga2iIin61mn9+C2uUTEKNKWnf9DatKuXVaiyH4PvJcTxVbAT0mbQL0BnFdiHK3iW6TlaDaOiOUiYlnS1qJbSPpWc0Mr1TI17lu8tCha35v1ThTgZGHtkDQcWCIixkXEOKCnpG+WGEK3qtbDl4HzIuKaiPg+aamJruZAYN/IG2MBRMQk4ACg7XIPC7PReamPOUj6GnN2V3YF90v6QW51ziLpROD+RlTobiibS/VUyaqy0qZIShoHDMpr8/8TGFZZYkLSuIhYr4w4WkWt37ns9yOvSLwJaVbSqIgobWA5n8F/HfA+s5PDYNI2s3uWGUuz5XGaC0i7WFYGuAcBjwJfjYi678PtAW5rTzdJqizlkM+zWKzE+i8nnaX7Cmlg/d4cxxo0aK3+Fvf+fN5XV/kI/gekE/MEnC3plIi4sIz6I+Il4DNKO+NVEuRNEXFnGfW3kpwMviRpddKJeADjI+JfjarTLQubi6TTSVt3/j4XfQP4d0R8p8QYNgP6AH+PiLdz2ZpAz8osra5Caeez9jb3EWmacykbU0l6EvhMZd+IvFT5/RGxVhn1W3O5ZWHt+S5pCejD8u2xpBlRpYmIB9spe6rMGFpFC01dfZU0fbnirVxmXYCThc0lL973EGmvgH1Ii8Zd09yorAVMBB6SdANpzGIIMFZ5v/gyN+ey8jlZ2Cxqfz9ymrR4nbWef+VLxQ35Z6ssU9NlSFqu1v2NOBfJYxY2i1pwP3JrPZJ6QloGptmxdFWSniG17gSsAryWry9DGl+s+zLlPs/Cqu0FvAjcJel8SdtS7j4a1sIkrSfpUeAJ4AlJYySt2+y4uqKI6J8P4m4HdouIXhGxPGnPk4ZsBe2Whc1Fs/cj3xf4PGm/5bL3I7cWI+l+4HsRcVe+vTXwk4godTVim629ZU4atfSJWxY2l4h4OyIui4jdgL6kE32+2+SwrPmWqCQKgIi4G1iieeEY8B9JJ0rqly/fI63pVnduWZjZPJF0HfAIaVtVSMuNbBQRezYvqq4tD3SfBGxFGsMYCZziAW4za5q8t8gPgS1z0b2kVYBfa15UBqnruHLyasPqcLIwM+ucJH2GtP94z4hYRdJA4BsRUfeFP50szGye5PNwvgP0o+ocrYj4fLNi6uryybN7AyMqC302anFJn5RnZvPqauB3pCPZmU2OxbKIeL7NSuUN+ds4WZjZvJoREec2Owibw/O5KyokdQeOAiY0oiJ3Q5lZTVVLSxwJvEzaU+K9yv1dbZvbViKpF3AW8AXSCbR/B470bCgzK12bpSXaCi8H0zySdoqIv7UpOywiflf3upwszMw6p3xW/YmVDaAkHQt8PiJ2qntdThZmVoukjYHnK9uWSjoI+CLwHOk8C3dDNUnuhroROBbYEfgUab/2uu+g6GRhZjVJegT4QkRMlbQVcAVwBGnP57UjYu+mBtjFSfoEaUHBMaT9txvype5kYWY1SfpHRAzM138DTImIk/PtxyJiUDPj64okvcXscaQAFgNm5OsREUvVu05PnTWzIt0kLRoRM4BtSVvuVvg7pAkiovQNp7zqrJkVuRy4J2+n+i5pTSgkrQG80czAujpJW+QtBZB0gKQzJa3SkLrcDWVmRSRtBvQB/l5ZsC4v/9EzIh5panBdmKSxwEBgfeAi0tn1+0TE5+pel5OFmVnnJOmRiNhQ0g+AFyLigkpZvetyf6OZWef1lqTjSXuLbCVpEaB7IyrymIWZWef1ZdLSK4fm82D6Aqc3oiJ3Q5mZLSQkfRYYGhHD6/3a7oYyM+vEJG0A7Ad8CXgGuKYR9ThZmJl1Mnkm2r758gpwJamnaJuG1eluKDOzzkXSh6TzXQ6NiIm5bFIjVwD2ALeZWeezF/AicJek8yVtS/tLyNeNWxZmZp1UPnt7CKk76vPAJcB1EfH3utflZGFm1vlJWpY0yP3liNi27q/vZGFmZkU8ZmFmZoWcLMzMrJCThZlZJyXpiDxW0XBOFmZmndcKwChJV0naUVLDps96gNvMrBPLCWJ74BBgMHAVcEFE/Kue9bhlYWbWiUU64v9vvswAlgX+Iunn9azHLQszs05K0lHAQaT1of4AXB8RH+R9LZ6OiNXrVZcXEjQz67yWA/aKiOeqCyPiQ0m71rMityzMzDoZScvVuj8ipta9TicLM7PORdIzQND+4oHRiNVnnSzMzKyQZ0OZmXVSku6Yl7J68AC3mVknI6kHsATQK5/BXemOWgpYqRF1OlmYmXU+3wCOBj4JjGF2sngTOKcRFXrMwsysk5J0REScXUpdThZmZp2XpM8A/ajqKYqIS+pdj7uhzMw6KUl/AlYHHgNm5uIgba9a37rcsjAz65wkTQDWiRK+yD111sys8xoHrFhGRe6GMjPrvHoB4yU9DLxXKYyI3etdkZOFmVnndXJZFXnMwsysE5O0KjAgIm6X9HGgW0S8Ve96PGZhZtZJSfo68Bfg97loJeD6RtTlZGFm1nkNB7YgnblNRDwNfKIRFTlZmJl1Xu9FxPuVG5IWJZ1nUXdOFmZmndc9kk4AFpe0HXA18NdGVOQBbjOzTirvtX0osD1pMcFbgT804iQ9JwszMyvk8yzMzDqpqu1V59CIbVWdLMzMOq/BVdd7AF8ClmtERe6GMjNbiEgaExEb1ft13bIwM+ukJG1YdXMRUkujId/rThZmZp3XL6quzwCeBfZpREXuhjIzs0JuWZiZdVKSjql1f0ScWa+6nCzMzDqvwcDGwIh8ezfgYeDpelfkbigzs05K0khgl8qS5JKWBG6KiK3qXZfXhjIz67xWAN6vuv1+Lqs7d0OZmXVelwAPS7ou394DuLgRFbkbysysE8vnWnw23xwZEY82oh53Q5mZdW4fB96MiLOAyZL6N6IStyzMzDopSSeRZkStFRFrSvokcHVEbFHvutyyMDPrvPYEdgfeBoiI/wBLNqIiJwszs87r/bzRUQBIWqJRFTlZmJl1XldJ+j2wjKSvA7cD5zeiIo9ZmJl1QpIE9AU+RdW2qhFxW0Pqc7IwM+ucJD0eEZ8uoy53Q5mZdV6PSNq4jIrcsjAz66Qk/RMYQNrH4m1SV1RExPp1r8vJwsysc5G0SkT8W9Kq7d0fEc/VvU4nCzOzzkXSIxGxYb5+TUR8sdF1eszCzKzzUdX11cqo0MnCzKzziQ6uN4y7oczMOhlJM5k9oL048E7lLtIA91J1r9PJwszMirgbyszMCjlZmJlZIScLMzMr5GRhVoOkFSVdIelfksZIulnSmh08dhlJ3yw7RrMyOFmYdSCv6nkdcHdErB4RGwHHAyt08JRlgIYnC0mLNroOs7acLMw6tg3wQUT8rlIQEf8AHpV0h6RHJD0uaUi++zRgdUmPSTodQNKxkkZJGivph5XXkfR9SU9Kuk/S5ZK+k8sHSXowP/46Scvm8rsl/UrSaOB7kp6R1D3ft1T1bbNG8BGKWcfWA8a0Uz4d2DMi3pTUC3hQ0gjgOGC9iBgEIGl70iJvm5Dmv4+QtBXwLvBFYCDQHXikqp5LgCMi4h5JpwAnAUfn+xaLiMH5tfsBuwDXA0OBayPigzr+7mZzcLIw++gE/CR/8X8IrET7XVPb58uj+XZPUvJYErghIqYD0yX9FUDS0sAyEXFPfvzFwNVVr3dl1fU/AP9LShaHAF+vw+9l1iEnC7OOPQHs3U75/kBvYKOI+EDSs0CPdh4n4KcR8fs5CqWj23nsvHi7ciUi/k9SP0lbA90iYtx8vqbZPPGYhVnH7gQ+JmlYpUDS+sCqwMs5UWyTbwO8RWo1VNwKfFVSz/zclSR9Avg/YDdJPfJ9uwJExBvAa5I+m59/IHAPHbsEuAz44wL+nmaF3LIw60BEhKQ9gV9J+i5prOJZ4GTg15IeB0YD/8yPf1XS/0kaB/wtIo6VtDbwQJpYxTTggIgYlcc4xgIvAY8Db+RqDwZ+J+njwCRSF1NHLgV+DFxex1/brF1eG8qsCST1jIhpOSmMBIZFxCMf8TX2BoZExIENCdKsilsWZs1xnqR1SGMdF89Hojgb2AnYuRHBmbXlloWZmRXyALeZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZof8HKvRisI6mBu0AAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "0SMZ73vQPMyb"
      },
      "source": [
        "##### Non-Brand Queries"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CvfK2WUOLBFG",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3b4f0d43-0593-4b99-ffe8-3b08b419535e"
      },
      "source": [
        "non_brand_category_pivot = lp_query_non_brand.pivot_table(index='Category', values=['URL Clicks'], aggfunc={'URL Clicks': np.sum})\n",
        "non_brand_category_pivot = non_brand_category_pivot.sort_values(by='URL Clicks', ascending=False)\n",
        "non_brand_category_pivot.head(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>URL Clicks</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Category</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Shop By Brand</th>\n",
              "      <td>2438</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Apparel</th>\n",
              "      <td>2047</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Accessories</th>\n",
              "      <td>535</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Stationery</th>\n",
              "      <td>74</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Super G Unisex Joggers</th>\n",
              "      <td>45</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Store Policies</th>\n",
              "      <td>44</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bags</th>\n",
              "      <td>22</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Shipping Information</th>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Office</th>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Lifestyle</th>\n",
              "      <td>15</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                        URL Clicks\n",
              "Category                          \n",
              "Shop By Brand                 2438\n",
              "Apparel                       2047\n",
              "Accessories                    535\n",
              "Stationery                      74\n",
              "Super G Unisex Joggers          45\n",
              "Store Policies                  44\n",
              "Bags                            22\n",
              "Shipping Information            17\n",
              "Office                          16\n",
              "Lifestyle                       15"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 137
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zGZmUEveLIY0",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3322f116-5692-47e7-b35a-c1b1b088755d"
      },
      "source": [
        "ax_category = non_brand_category_pivot.head(10).plot(kind='bar')\n",
        "ax_category.set_ylabel('URL Clicks')\n",
        "ax_category.set_title('Top 10 Non-Brand URL Clicks by Category')"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Text(0.5, 1.0, 'Top 10 Non-Brand URL Clicks by Category')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 138
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAGBCAYAAACXe53tAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debgcRfn28e9NCIuEHQRkC6uySFgCiKIiyL4EEBFkE9DoTxB4FRQQBVEUBVFEjIKyBFlEAQmLIAIBEZAkiCwBJIQAYQ1hCzuE5/2janImJ3OmT5Iz3ZPM/bmuuc5MdU/3M3Nm5umuqq5SRGBmZtbMPFUHYGZm7c/JwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4VZE5K+JOm2quPoje6xSnpN0qoFzxkoKSTNO5v7niDps7OzDWtvThYVy1/o2u19SW/WPd6nj/axp6TbJb0haWSD5etLGpOXj5G0fpNtjZT0lqQV68o+K2lCX8TaYH8h6fX8frwg6WJJi7ViXzNL0haSJjYoHynpy/n+CZLezfG/nP8PmxVto8k+t5V0q6QpkiZJukXSLo3WjYgBETF+Vl5blSQtIumXkp7I79uj+fFSvXjuHJPc5zROFhXLX+gBETEAeALYua7swj7azYvAL4GTuy+QNB9wJfBHYHHgfODKXN6T14Hv9VFsvTEovz+rkmI8odFKStrxM/2nHP9SwM3An2dlI5L2yM8dDqwALAN8H9i5j+KsXP7c3QisA2wHLAJsBkwGNqkwtEKze3bW7trxi2WApPnz0dTT+fZLSfPnZVtImijp2Hy0PaHZWUhE/CMiLgWebrB4C2Be4JcR8XZE/AoQsGWT8H4F7C1ptR5iXysfXb8s6YH6I19J50k6U9I1+ej43z1tp8HreBUYAaxdt72Rkk6S9C/gDWBVSQdKejBvf7ykr9atX3vvviXpeUnPSDqwbvmSkkZIelXSXUCvYutl/O8BFwLLS1p6Zp4rScBpwA8j4vcR8UpEvB8Rt0TEV3p4TkhaPd9fUNLPJT0u6RVJt0lasMFzPpc/T+tKWkDSHyVNzv/LUZKWaRLmxpLGSnpJ0rmSFsjbvF/StIQmqX/+3G7QYBv7AysBu0XE2Pwan4+IH0bEtfn5R+ezjSl5f7vl8rWA3wKb1c7kcvn8kk7NZyrPSfpt/WuX9O38OXha0pe7vW+LShqez+Iel3Rc7YAkn8X8S9IvJE0GTpT0oqSP1m37g0pn7DP1/25HThbt67vAx4D1gUGko6rj6pYvSzpSXR44ADhL0odnYT/rAPfG9OO+3JvLe/IUcDbwg+4LJPUHrgL+DnwQ+AZwYbfY9srPXRwYB5zUm0AlLQ7sCtzZbdF+wFBgYeBx4HlgJ9JR6YHALyRtWLf+ssCipPfuYODMvG2AM4G3gOWAg/KtT+Sj5v1JR8kvzeTTPwysCPxlFnd/KrAR8HFgCeDbwPvd4jsQ+Cnw2Yi4n/S5WjTvd0nga8CbTfaxD7AtKcGuSdfndTiwb916OwDPRMR/Gmzjs8B1EfFak/08Cnwyx/YD4I+SlouIB3OMd+Qz81p15ck5nvWB1Un/9+/n17wd8M2839VJB0/1zsj7WRX4NOn/d2Dd8k2B8aSzvB8Cl3R7rXsDN0bEpCavZ84QEb61yQ2YQPqiQvpC7FC3bFtgQr6/BfAesFDd8kuB7xVs/8vAyG5l3wMu6VZ2IXBCD9sYmbezNPAKKal8ti62TwLPAvPUPefi2vaA84Df1y3bAXioScwBvAq8DEwFHgKW7xbPiQWv+6/A4XXv3ZvAvHXLnycl5n7Au8BH6pb9GLith+1uAUzs6T3K908A3qmLfzKwRdE2GmzzE/m9WKDJOl+qjzWvvzrpoPBNUnVe9+cMzOsdCYwFVqhbdhBwO7BeLz+7X+v2f3003/8QMAVYJD/+C/DtHrZzA3DyTH5v7gGG9PAeiFRtulpd2WbAY/n+OcBP6patXve+9cv/u7Xrln+V/B3K+3qiWyybkqqTlR+PBvacmdfTrjefWbSvD5GOkmsez2U1L0XE602W99ZrpCPweouQvtw9inSk9GvgxG6LPgQ8GRH1R62Pk47map6tu/8GMAAgV6vVGvd/W7fOhpGOEhcAhgH/rFVxZE/WByBpe0l35iqBl0k/XPWNo5MjVQl1j2FpUpVc/fbq/wfdvQf0b1Den5R0ai7N8S8D3E86wp9Zk/Pf5WbhuUuR3rtHm6xzFHBmRNQ3tl8AXA9ckqtofpbPHHvS/X37EEBEPA38C/icUueE7UkHJI1MpuA1Stpf0j25auxlYF2m///WWxr4ADCmbv3rcjk5xvq46+8vRfpfdv8eLt/D+kTEv0mfpy0kfYSUdEY0ez1zCieL9vU0sHLd45WYvs1hcUkLNVneWw8A6+U68Zr1cnmRU4DPMP2P39PAipq+oXklUtVVUxHx4+hq3P9ag+XvAr8HViH9QExbVLuj1K5zGanaZZn8I30t6QizyCRSAlixrmylJus/ASwlaUDd/kX6v82QZCLiBVJ12QmSZvZH/2HSD9PnZvJ5AC+Qqtaatb9sAxwnadr2I+LdiPhBRKxNqr7aiVQN05Pu71v95/F8UvXM50nVRD19Hv4BbNvtsz2NpJVJVaCHAkvm/+/9dP1/uw+j/QLprGqdiFgs3xaN1OEA4BlSZ4FGr+EFUtLv/j2sj73RsN2117of8JeIeKvhK53DOFm0r4tJX96llboMfp/UY6neDyTNJ+mTpC9yw142kvrlI/F5gXlyw2XtCHEkqXrksNwQeGguv6kowIh4Gfg5qf67pnZk9e3ckLkFqbfOJYWvuICkfqT64jdJ9cSNzAfMT/7hl7Q96YewUERMBS4n/Zh/QNLapHr7ntZ/gvR6fyppQE5UR5F+YLq3q9Se8zDpaL3+PSP/T+pv6va8INWtf0+pAX8RSfNI2lzSWQWv631Sdctpkj6UPw+b5XhrHiD1PjpTuUOCpM9I+mh+31/Nr+v97tuvc4ikFSQtQWpz+1Pdsr8CGwKHk9owenIBKSleJukj+TUumc86dwAWIv1AT8oxHsj0Bw7PASvk9qHaaz+b1G71wfyc5SVtm9e/FDhQqVPGB6jr5Zc/D5cCJ0laOCeqbzLj97C7PwK7kRJGs9c6R3GyaF8/ItV33gvcB9ydy2qeJTWSPk06pf9aRDzUw7b2I/3ADiO1KbxJ+gIREe+QGo33J9WrHwTsmst743RSsqFuezuTqhpeAH4D7N8ktt74r6TXSK/3AFJPmRcbrRgRU4DDSF/yl4AvMnPVAIeSqqSeJbWvnFuw/hdIDfnjSEecWwE7FhxNngIMrf14kao13ux2m+EsICL+kvd3EOn//hzpM3FlL17XkaTP0ShSV+qf0u37HxH/JR10nJ2T7LKk9oVXgQeBW0g/5j25iNSxYTypymva5zUi3iSd8a1CSsgNRcTbpDawh0jtF68Cd5GqhP4dEWNJByh35Nf/UVIVV81NpMT3rKQXctl3SP+fOyW9Sjp7+XDe399Ivfturq2Tn/N2/vsNUpvHeOC2/BrPafIeEBFPkr6vAfyz2bpzklojjM1B8tH6HyNihaJ1zdqFpO8Da0bEvoUrV0Sp++39wPzd2rVmdjvnAE9HxHGFK88h5uqLSMysPeSqqYNJZ7ltRek6jWtJDeE/Ba6azUQxENgdaHQdyRzL1VBm1lKSvkJqh/hbRNxadTwNfJXUffpRUpXq/83qhiT9kHRmckpEPNY34bUHV0OZmVkhn1mYmVmhubLNYqmlloqBAwdWHYaZ2RxlzJgxL0REw3Gs5spkMXDgQEaPHl11GGZmcxRJPY5Y0LJqKEkrSrpZaVTIByQdnstPkPRUvlz/nnyhTe05x0gaJ+nhuotmkLRdLhsn6ehWxWxmZo218sziPeBbEXG3pIVJY7PckJf9IiJOrV85Xy27F2lgug8B/5C0Zl58JrA1MBEYJWlEvjjHzMxK0LJkERHPkMZdISKmSHqQ6Qfg6m4IafTTt4HHJI2ja7KTcZFn/JJ0SV7XycLMrCSltFnki1Q2II2j8wngUEn7k4az+FZEvERKJPXj6UykK7k82a180wb7GEoapI2VVmo29puZzQneffddJk6cyFtvzRXj8LWVBRZYgBVWWIH+/ZsNIjy9lieLPCLnZcAREfGqpGGkSUIi//05fTDBTEScBZwFMHjwYF88YjaHmzhxIgsvvDADBw6k27iKNhsigsmTJzNx4kRWWWWVXj+vpddZ5JFNLwMujIjLASLiuYiYWjcaZK2q6SmmHx54hVzWU7mZzcXeeustllxySSeKPiaJJZdccqbP2FrZG0rAH4AHI+K0uvL6cfx3I10aD2lk0L3yMNmrAGuQRpscBawhaZU87PBezCWTiZhZc04UrTEr72srq6E+QRo07D5J9+SyY4G9Ja1PqoaaQBqXhYh4QNKlpIbr94BD8njy5DkWridNc3hORPRmYh4zM+sjrewNdRuNZye7tslzTgJOalB+bbPnmdncb+DR1/Tp9iacvGPz5RMmsNNOO3H//fdPKzvhhBMYMGAARx55JF/60pe45ZZbWHTRRYkITjvtNLbaaisAtthiC0499VQGDx7c4/b/97//ccQRR/DII4+w8MILs/rqq3PGGWfw4IMPcuqpp3L11VczYsQIxo4dy9FHN768rFGMrTJXXsHdG33xwSv6sJnZ3O2UU05hjz324Oabb2bo0KE88sgjvXreW2+9xY477shpp53GzjvvDMDIkSOZNGnSdOvtsssu7LLLLn0e96zwQIJmZrNps80246mnet/v5qKLLmKzzTabliggnY2su+6606133nnnceihaabj5557jt12241BgwYxaNAgbr/99unWHT9+PBtssAGjRo3igQceYJNNNmH99ddnvfXW63USa6ZjzyzMzPrKddddx6677trr9e+//3422mijmdrHYYcdxqc//WmuuOIKpk6dymuvvcZLL70EwMMPP8xee+3Feeedx6BBg/jGN77B4Ycfzj777MM777zD1KlTC7ZezMnCzKyBnnoM1ZcfddRRHHvssUycOJE77rijpfHcdNNNDB8+HIB+/fqx6KKL8tJLLzFp0iSGDBnC5Zdfztprrw2kM52TTjqJiRMnsvvuu7PGGmvM9v5dDWVm1sCSSy457ci95sUXX2SppZaa9viUU07hf//7Hz/96U856KDeX1u8zjrrMGbMmD6Jc9FFF2WllVbitttum1b2xS9+kREjRrDggguyww47cNNNN832fpwszMwaGDBgAMstt9y0H9oXX3yR6667js0333yGdQ899FDef/99rr/++l5t+4tf/CK3334711zT1dHm1ltvbdqraauttmLYsGEATJ06lVdeeQWA+eabjyuuuILhw4dz0UUXAan9YtVVV+Wwww5jyJAh3Hvvvb170U24GsrM5ghV9D4cPnw4hxxyCN/85jcBOP7441lttdVmWE8Sxx13HD/72c/Ydts0u8KOO+44beylzTbbjD//+c/T1l9wwQW5+uqrOeKIIzjiiCPo378/6623HqeffjovvPBCw1hOP/10hg4dyh/+8Af69evHsGHDWG65dI3zQgstxNVXX83WW2/NgAEDGDt2LBdccAH9+/dn2WWX5dhjj53t92KunIN78ODBUTT5kbvOmrW3Bx98kLXWWqvqMOZajd5fSWMiouHFIa6GMjOzQk4WZmZWyMnCzNrW3FhN3g5m5X11sjCztrTAAgswefJkJ4w+VpvPYoEFFpip57k3lJm1pRVWWIGJEyfOMF6Szb7aTHkzw8nCzNpS//79Z2omN2stV0OZmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoU8B3eFBh59zWxvY8LJO/ZBJGZmzbXszELSipJuljRW0gOSDs/lS0i6QdIj+e/iuVySfiVpnKR7JW1Yt60D8vqPSDqgVTGbmVljrayGeg/4VkSsDXwMOETS2sDRwI0RsQZwY34MsD2wRr4NBYZBSi7A8cCmwCbA8bUEY2Zm5WhZsoiIZyLi7nx/CvAgsDwwBDg/r3Y+sGu+PwQYHsmdwGKSlgO2BW6IiBcj4iXgBmC7VsVtZmYzKqWBW9JAYAPg38AyEfFMXvQssEy+vzzwZN3TJuaynsq772OopNGSRk+aNKlP4zcz63QtTxaSBgCXAUdExKv1yyIigOiL/UTEWRExOCIGL7300n2xSTMzy1qaLCT1JyWKCyPi8lz8XK5eIv99Ppc/BaxY9/QVcllP5WZmVpJW9oYS8AfgwYg4rW7RCKDWo+kA4Mq68v1zr6iPAa/k6qrrgW0kLZ4btrfJZWZmVpJWXmfxCWA/4D5J9+SyY4GTgUslHQw8DuyZl10L7ACMA94ADgSIiBcl/RAYldc7MSJebGHcZmbWTcuSRUTcBqiHxVs1WD+AQ3rY1jnAOX0XnZmZzQwP92FmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFXKyMDOzQk4WZmZWyMnCzMwKOVmYmVmhwmQhaTVJ8+f7W0g6TNJirQ/NzMzaRW/OLC4DpkpaHTgLWBG4qKVRmZlZW+lNsng/It4DdgPOiIijgOWKniTpHEnPS7q/ruwESU9JuiffdqhbdoykcZIelrRtXfl2uWycpKNn7uWZmVlf6E2yeFfS3sABwNW5rH8vnncesF2D8l9ExPr5di2ApLWBvYB18nN+I6mfpH7AmcD2wNrA3nldMzMrUW+SxYHAZsBJEfGYpFWAC4qeFBG3Ai/2Mo4hwCUR8XZEPAaMAzbJt3ERMT4i3gEuyeuamVmJepMsFoyIwyLiYoD8Y/7AbOzzUEn35mqqxXPZ8sCTdetMzGU9lc9A0lBJoyWNnjRp0myEZ2Zm3fUmWZwtad3ag1wl9b1Z3N8wYDVgfeAZ4OezuJ0ZRMRZETE4IgYvvfTSfbVZMzMD5u3FOnsAf5H0ReCTwP7ANrOys4h4rnZf0tl0tYE8ReplVbNCLqNJuZmZlaTwzCIixpMany8HPgdsExGvzMrOJNX3otoNqPWUGgHsJWn+3CayBnAXMApYQ9IqkubLcYyYlX2bmdms6/HMQtJ9QNQVLQH0A/4tiYhYr9mGJV0MbAEsJWkicDywhaT183YnAF8FiIgHJF0KjAXeAw6JiKl5O4cC1+d9nxMRs9NeYmZms6BZNdROs7PhiNi7QfEfmqx/EnBSg/JrgWtnJxYzM5s9PVZDRcTjEfE46QK8F+sevwQsW1aAZmZWvd70hhoGvFb3+LVcZmZmHaI3yUIRMa3tIiLep3e9qMzMbC7Rm2QxPo802z/fDgfGtzowMzNrH71JFl8DPk66vmEisCkwtJVBmZlZeymsToqI50nXN5iZWYdqdp3FtyPiZ5LOYPrrLQCIiMNaGpmZmbWNZmcWD+a/o8sIxMzM2lePySIirsp/zy8vHDMza0fNqqGuokH1U01E7NKSiMzMrO00q4Y6tbQozMysrTVLFmOBpSNibH1hntbUswuZmXWQZtdZnAEs1aB8SeD01oRjZmbtqFmyWD3Poz2diPgn0HR4cjMzm7s0SxYLN1nWv68DMTOz9tUsWYyTtEP3Qknb47GhzMw6SrMG7iOAayTtCYzJZYOBzZjNiZHMzGzO0mzyo0eAjwK3AAPz7RZgvYj4XxnBmZlZe2g6kGBEvA2cW1IsZmbWpnozRLmZmXU4JwszMys0S8lC0p/6OhAzM2tfs3pmsVmfRmFmZm3N1VBmZlao2RDlG/a0CF/BbWbWUZp1nf15k2UP9XUgZmbWvprNlPeZMgMxM7P2NdNtFpK2lnRDK4IxM7P21GOykLSlpP9Jek3SHyV9VNJo4GRgWHkhmplZ1ZqdWfwcGEqa7OgvwB3AeRGxUURcXkZwZmbWHpo1cEdEjMz3/yrpqYj4dQkxmZlZm2mWLBaTtHv9uvWPfXZhZtY5miWLW4Cd6x7fWvc4ACcLM7MO0azr7IFlBmJmZu2r2RXc3+xWFMALwG0R8VjRhiWdQ5pR7/mIWDeXLQH8iTSR0gRgz4h4SZKA04EdgDeAL0XE3fk5BwDH5c3+KCLO7/WrMzOzPtGsN9TC3W6LkKZV/ZukvXqx7fOA7bqVHQ3cGBFrADfmxwDbA2vk21By19ycXI4HNgU2AY6XtHgv9m1mZn2oWTXUDxqV5x/wfwCXNNtwRNwqaWC34iHAFvn++cBI4Du5fHhEBHCnpMUkLZfXvSEiXsz7voGUgC5utm8zM+tbM30Fd/7h1izub5mIeCbffxZYJt9fHniybr2Juayn8hlIGipptKTRkyZNmsXwzMyskVkZ7uMzwEuzu+N8FhGzu5267Z0VEYMjYvDSSy/dV5s1MzOaN3Dfx4w/5ksATwP7z+L+npO0XEQ8k6uZns/lTwEr1q23Qi57iq5qq1r5yFnct5mZzaJm11ns1O1xAJMj4vXZ2N8I4ADS+FIHAFfWlR8q6RJSY/YrOaFcD/y4rlF7G+CY2di/mZnNgmYN3I/PzoYlXUw6K1hK0kRSr6aTgUslHQw8DuyZV7+W1G12HKnr7IE5hhcl/RAYldc7sdbYbWZm5Wl2ZjFbImLvHhZt1WDdAA7pYTvnAOf0YWhmZjaTPAe3mZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVcrIwM7NCThZmZlbIycLMzAo5WZiZWSEnCzMzK+RkYWZmhZwszMyskJOFmZkVmreKnUqaAEwBpgLvRcRgSUsAfwIGAhOAPSPiJUkCTgd2AN4AvhQRd1cR99xq4NHXzPY2Jpy8Yx9EYmbtqsozi89ExPoRMTg/Phq4MSLWAG7MjwG2B9bIt6HAsNIjNTPrcO1UDTUEOD/fPx/Yta58eCR3AotJWq6KAM3MOlVVySKAv0saI2loLlsmIp7J958Flsn3lweerHvuxFw2HUlDJY2WNHrSpEmtitvMrCNV0mYBbB4RT0n6IHCDpIfqF0ZESIqZ2WBEnAWcBTB48OCZeq6ZmTVXyZlFRDyV/z4PXAFsAjxXq17Kf5/Pqz8FrFj39BVymZmZlaT0ZCFpIUkL1+4D2wD3AyOAA/JqBwBX5vsjgP2VfAx4pa66yszMSlBFNdQywBWpRyzzAhdFxHWSRgGXSjoYeBzYM69/Lanb7DhS19kDyw/ZzKyzlZ4sImI8MKhB+WRgqwblARxSQmhmZtaDduo6a2ZmbcrJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKyQk4WZmRVysjAzs0JOFmZmVsjJwszMCjlZmJlZIScLMzMr5GRhZmaFnCzMzKzQvFUHYAYw8OhrZnsbE07esQ8iMbNGfGZhZmaFnCzMzKyQq6HM6sxudVhfVIW5Ss7a0RxzZiFpO0kPSxon6eiq4zEz6yRzxJmFpH7AmcDWwERglKQRETG22sjM5l4+y+q7ONohhtmNY045s9gEGBcR4yPiHeASYEjFMZmZdQxFRNUxFJK0B7BdRHw5P94P2DQiDq1bZygwND/8MPDwbO52KeCF2dxGX2iHONohBmiPONohBmiPONohBmiPONohBpj9OFaOiKUbLZgjqqF6IyLOAs7qq+1JGh0Rg/tqe3NyHO0QQ7vE0Q4xtEsc7RBDu8TRDjG0Oo45pRrqKWDFuscr5DIzMyvBnJIsRgFrSFpF0nzAXsCIimMyM+sYc0Q1VES8J+lQ4HqgH3BORDzQ4t32WZXWbGqHONohBmiPONohBmiPONohBmiPONohBmhhHHNEA7eZmVVrTqmGMjOzCjlZmJlZIScLMzMrNEc0cLeSpPuAHhtuImK9EsNpO5IWB1aMiHsr2PeSETG57P12i+ETwD0R8bqkfYENgdMj4vGS4zgcOBeYAvwe2AA4OiL+XmYc3WKaBxgQEa+WvN+lga8AA6n7DYuIg8qMo9N0fLIAdsp/D8l/L8h/9ykzCEnfbLY8Ik4rMZaRwC6kz8cY4HlJ/4qIpjG2wJ2S7iH9SP4tqumNMQwYJGkQ8C3SD/Vw4NMlx3FQRJwuaVtgcWA/0me11GQh6SLga8BUUpf2RSSdHhGnlBjGlcA/gX/kOCohaU3S52OZiFhX0nrALhHxo5LjEOn3atWIOFHSSsCyEXFXX+6n46uhIuLxfJS4dUR8OyLuy7ejgW1KDGXhgluZFs1Hi7sDwyNiU+CzJccAsCapK+B+wCOSfpy/oGV6LyepIcCvI+JMyv9/ACj/3QG4IHcdV5P1W2Xt/NnYFfgbsArp/1OmD0TEdyLi0oi4rHYrOQaAs4FjgHcB8tn3XhXE8RtgM2Dv/HgKaeDVPuUziy6S9ImI+Fd+8HFKTKYR8YOy9tUL80paDtgT+G5VQeQf6RuAGyR9Bvgj8HVJ/yVVwdxRQhhTJB0D7At8Kle99C9hv92NkfR30o/zMZIWBt6vII7+kvqTksWvI+JdSWWf8V0taYeIuLbk/Xb3gYi4Kx3YT/NeBXFsGhEbSvoPQES8lC9e7lMdf2ZR52DgN5ImSHqclK1LrwOVtKakGyXdnx+vJ+m4ksM4kXQB5KMRMUrSqsAjJceApCUlHS5pNHAk8A3SQGnfAi4qKYwvAG8DB0fEs6ShZsqscqk5GDga2MplPTQAAB3lSURBVDgi3gDmAw6sII7fAROAhYBbJa0MlNpmARxOShhvSZqSb2XHAPCCpNXIbZ55wNNnKojj3TyNQy2OpWnBgYQvyutG0qIAEfFKRfu/BTgK+F1EbJDL7o+IdauIp0qS/keqlz83IiZ2W/adiPhpi/ffD/hHRHymlfvpZSyl1EvPCknzRkQVR9SVygdRZwEfB14CHgP2jYgJJcexD+mgZkPgfGAP4LiI+HOf7sfJIpE0P/A5ZuxhcWLJcYyKiI0l/acuWdwTEeuXGEPlDXf5h/pnEfGtsvbZQxw3ArtXdfBQF8cw0tHilhGxVu6l9veI2LjkOBp1cngFGBMR95QYxy7Ap/LDkRFxdVn7bhDLQsA8ETGlwhg+AmxFase6MSIe7Ot9uBqqy5WkRsz3gNfrbmVrh1PbyhvuImIq6Yitaq8B90n6g6Rf1W4VxLFpRBwCvAWpXppUFVW2waTeUMvn21eB7YCzJX27jAAknUyqihqbb4dL+kkZ++4Wx48lLRYRr0fEFEmLSyrzgGqJ2g14HriYVD37XC7rU27g7rJCRGxXdRCkLrxnAR+R9BTp1LbUbry0T8PdPZJGAH+mLnFHxOUlxnB5vlWtlHrpXlgB2DAiXstxHA9cQzrKHwP8rIQYdgDWj4j3cwznA/8hHeCUafuIOLb2IDcs7wCU1cY4hvR5qH1Ra9VEyvdX7cudOVl0uV3SRyPivqoCyD8GX4+Iz1Z8atsOZzcACwCTgS3ryoISf7wj4nxJCwIrRcTszr44O34FXAF8UNJJ5HrpCuL4IKnBv+ZdUnXlm5Le7uE5rbAY8GK+v2iJ+63XT9L8EfE2QP6czF/WziNilbL2BU4W9TYHviTpMdKXQaTem6VdwR0RUyVtnu9XUQVW0+jsZt+yg4iIKnr7TEfSzsCppCqfVSStD5wYEbuUGUdEXChpDF310ru2ol66Fy4E/i3pyvx4Z+CifHAztqQYfgL8R9LNpPfiU6SeYmW7ELhR0rn58YGkBuZSSboM+ANwXe1sqyX7cQN3krsAzqCCYR2GkeqCq6x6qcVSacNdmzS0jyGd2YysoneapEUi4tWe6qAj4sVG5S2OaWO62pP+FRGjK4hhOaDWuH9X7tZcOknbkxI4wA0RcX0FMXyWlKg+RvrdOLcVZ8FOFt1I+iCp+gOAiHii5P2f26A4yhj3RtK+EfHHHnq8lDrkSI6n8m7Eku6MiI916512b1lnnJKujoid8hlv/Ze1dubbp/XSMxFX6d8TSR+JiIckbdhoeUTc3eoY2lnu9r836ULaJ0kdVf4YEe/2xfZdDZXlrng/Bz5E6lmwMvAgsE6ZcVRc9bJQ/lvFcBaNtEND+wOSvkiqn14DOAy4vaydR8RO+W+p9dM9afA9WQl4iHK+J98Ehub9dxdM37bVMpJui4jNJU2hcQJfpIw4usW0JKmqeD9SY/+FpKr1A4At+mIfThZdfkg6jftHRGygNLxE6fX0khYgXa27DtMfubX8zCIifpcb2V+NiF+0en+90A4N7d8gHam9TeqaeD3ps1IqSbsBN9Wu95C0GLBFRPy15FAq+55ExNB8d/uIeKt+Wf7elGX/HE9bHFRJugL4MOkC1p0jovYd+ZPS6Ad9wtdZdHk30nDY80iaJyJuJvUpL9sFwLLAtsAtpK6KpbUZ5Osb9i5csRyHkIaXqDW0HwH8X5kBRMQbEfHdiNg4Igbn+28VP7PPHV9/YWBEvAwcX0Ec7fA9aXRmV9rZHqldoHbBZjs4OyLWjoif1BJFvsiYiOiz/43PLLq8LGkAcCtwoaTnqeaivNUj4vOShuRumxeRhmMu078k/Rr4E9M3spdaJxwR44FKuxFLuooZ5zt5BRhNakspK3E0OrCr4vtb2fdE0rKkzh8LStqArusLFgE+UEYM2TySjgU+3Kh9r+y2PeBHQPdBFe8gDf/RZ5wsugwB3gT+H+kiuEVJA+qVrdYY9bKkdYFnSX3by1QbWqT+9ZdWJ1yjbkOw1NouSh6CZTywNKkKCtIYPFNIw6efTXnDc4+WdBpdQ08fQrooq2xVfk+2Bb5EOtuu/0GeAhzb6Aktshdp1N1+VNi+V3bydG8o2m7AuC8DlwHrkSb9GQB8LyJ+V2lgFZB0HXncIeomuYmIRg2crYphVPfxl9Q1ftcDEVFKB4h8dvU9uuYVuQH4UZXX40haCpgcJf+ISPpcVDN/RW3/h0eaiOr7JR+4dI/jAFLyHEyaiKqWLKYA5/V1d3sni0xtMmBcO8hd8I6na6C2W0gXopX63pTdTbaHGB4Etq11DVUa7fX6SIP5TetOO7eT9DHgZNJV0z8kta0tRaoe2z8iris5nh2ZsRNIKT/cygN7Sro7Ivq0qmcW4ykleboaqkttwLgbmL6e/rAyg8hd4E4APkGq+vkn8MMody7qc4D7SZMfQapqOZc0c16ZKh+ChTR3xm2SHiUdua1CmoBpIUq4WlfSLyPiiB7aTijxSvJfk6p6FgVuIvVIulNptNOLgdKShaTfkqpZPkOa5nYPoMyh2h+U9AjwIUn1c9OXPupDtoKkRUhnFGeT2ir6fH52n1lk+ZRuBhFR6uX7OVndSpoVDlK98BYRUdq0pmowJHqjshLiGAusThpupJIhWHIc8wMfyQ8fLrM3lKSNImKMpIZzfkfELSXFMe3/L+nBiFirblmpZ1i1iyLr/g4gzdH+yRJjWBYYSUpUIrU1vgmVjPrw34gYpDQ/+9dIY4Zd0NdnPT6zyMpOCk0sFxH1/fh/JOkLJcfwpqTNI+I2AEmfIH8RSrZ9BfucjqTuZ1OrSXoFuC8inm/1/iNiTP5bSlJoon7Moe6fhbKPOGv7f0PSh0iDTS5X1s4lzUu6QHAp0tmlgBVJZ99VTENcPz/78Ih4QN2uZO0LHZ8s8lW53yXVxZ5GOo37JPAoaSrNsse9+bukvYBL8+M9SBeClen/gPNz24VI782XSo6BiHhc0iDS/wPgnxHx35LDOBjYjFT1ItLVsGNIgwqeGBEXtHLnku6j8Y9x2WdZg5SmLhWp901tGlNR125QkqvzRYmnAHeT3p/fl7j/U0i9oFapdefO1UCn5tvhJcYCJc3P3vHVUJJuA4aTupv9P9KFX1eRfqB+FBGblhzPFNKwG7V/9jx0taGUOpRA/gIQEVXMb4ykw4Gv0DUk+W7AWRFxRokxXE9qwH0uP16G9HnZG7i11Q3w6mGAy5qyqzzaTa4iXKDMzhe5vWLN7r3Acq/KhyJijbJiyfudh9TdfXxEvJzbPZePNGlZ3+3HyWK6uthxEbF6o2WdJP9In0uLG8x6Ece9wGa17qG5UfmOMtssJI2NiLXrHgt4ICLWrqCufhmmH2m15dVg7Sj/KO/IjFMgl3IxnKT/RcSaM7ushfGUMj+7h/uY/nSt+xF0FTORIWl3SadJ+rmkXSsI4aB8NrENsCSpN9TJFcQh6q6vyPf7vC62wEhJV0s6IHeCGJHLFgJeLisISXuSevx8ntRL7d9KY2V1oqtI1aJLkqqDareyjJW0f/dCSfuSBlUs229IVaW1YXqm0HXxZp/p+DYL0rhD95J+hFar6won+nhawt6Q9BtSD6DaFcNfk7R1pPmXSwsj/21pg1kvnEv6UbwiP96VNMlLmQ4hdRnePD8+H7gsV0GUeRHnd4GNa2cTStOq/gP4S4kxtIsVKuieWu8Q4HJJB9F1Ff1gYEFSVWnZNo2IDSX9B6ZN79rn87M7WcBaxauUaktgrVp9qNL8wg+UHEMpDWZFIuI0SSPp+qE+MCL+U3IMkdu13iE1pN5V9hXL2Tzdqp0m07k1A3+TtE3Z1aI1EfEUsKmkLekamv3aiKhqYMFS5mfv+GTRhg2E40hzBNTiWjGXlelguhrM3lCapa20eTY0/exwE/KttmyJKHF2uFz9cwqpT72AMyQdFRFlH9Fflxvb68eo6j54XKe4E7giN+y+S0XzSETETaReclUrZX72jm/gbjdKs8NtTNcVqRuTxn15Fcq5YjdfV3FPRLye62E3BE4vK7GqjWaHk/RfYOvu1T8RMaisGOpiqa8O+2dEXNFs/blV/lwMIV3r0rE/YJJWiYjH8v2P0DU/+43RgvnZnSzaTLcrdUXqwrsX8HUo5+Ks3G4ziDSY4XmkPux7RkTDq4jnZpLui4iP1j2eB/hvfVmL978Gqe/+asB9wJG5GqRjSbqVNKpBJR1Q2oWkMRGxkaQbI2Kr4mfMno6vhqqRtDNwTdUfwIi4RWm44S+Ser48Bvy25Ct438t19UOAX0fEHyQdXOL+gTS4Y/cvQVlfjDpVV/+cQ7qu41ZgZ+AMyh+jq92MJ/VI+xtpGBigknkkqlabV2NNlTCvhpNFly8Av5R0GXBORJTaBU7SmqSub3sDL5AmHlJUM2z6FEnHkLrMfjIfTfcva+dKU2R+AFhK0uJMP07/8mXFARARR0n6HGlgR0gXBZZZ/bNwRJyd7z8sqdQJqNrUY/k2X751qtq8GvNSQtdhV0PVyVcs701qzA1S182Lo4QZ2iS9Txph9uCIGJfLxpdZP18Xy7KkM5tREfHPfJHPFhExvKT9H066kv5DwFN0JYtXSVNI/rqMONqBpIdIn8nae3Ah6X8jKH/2wqrlXj/DI2KfqmNpF5K2j4i/tXw/ThbTy5fK70f6sXqQdM3Dr1o9xES++G4v0hHsdcAlwO8jYpVW7rdJPCsDa0TEPyR9AOhXRtLsFsM3yhzao9u+p9DzAHlvk8YO+26ru0tKurnJ4oiIUmcvbAe5K/OWEfFO1bFUSdK+EfFHSd+i8fD1roZqBUm7kM4oVifVEW8SEc/nH8qxpLrilomIvwJ/zVcGDyElqw9KGgZcUWafcklfAYYCS5AaVpcHfkvqbVGaiDhDaWrZtZl+kpuWn+FERI+n9fnodl3SUX5Lx4aqqBqy3Y0nzRM/gunnnum0NouF8t8BDZb1+VmAzyyyfPHbHyLi1gbLtqrigptcX/954AtlNupKugfYBPh3beyj7r2CSorjeNIor2uTGpW3B26LiLYY5kLSV6MDp7utWv5czCAiflB2LO1K0hER8cs+3aaTxYxU0dzC7ULSvyNi09pAeUrj999d9hALSsNzDwL+E2lyl2WAP0bE1mXGYe1JadIjIuK1qmNpN5KeiIiV+nKbnTpcwDSSPiZppKTLJW0g6X7SlKLPSdqu6vgqckvukregpK2BP5MGbyvbm7kr83u588HzpCvarYNJWjePg/QA8ICkMZLWKXpeh+nzsdw6PlmQ5hb+Makf/U3AlyNiWeBTwE+qDKxCRwOTSBeBfZVUBdTnwwf0wmilSW7OJg3YdjdwR5kBSFq7QdkWZcaQ9ylJ+0r6fn68kqRNyo6jTZwFfDMiVo6IlUnzpJ9d8JxO4zaLvqY2mlu4XeRG9rciYmp+3A+YPyLeqDCmgcAi0ccTuvRiv/cDFwA/IzWy/wwYHBGblRzHMNLgcFtGxFq5PevvEbFxwVPnOspzTheVze2a9NgTsGBE9GkHJp9ZtNfcwu3iRtJwyzULkobDLpWkaZ0KImJCRNxbX1aSTUlVX7eTxuh6mq4L9EqNI9Iw9W9BGoaazr0gbbyk70kamG/HkXpIdZSIWDgiFmlwW7ivEwW46yy019zC7WKB+kbDiHgtdyEuRTtdwU0a1fRNUsJcAHisoiFhShmGeg5xEPAD0nS7QbqY9aBKI+oAHZ8sIqJf1TG0odclbVi7OljSRsx41tVKX6XrCu4xdeVTSG1MZRoFXEka/Xcp4LeSPhcRny85jlKGoW5nki6IiP1Ic6IfVnU8nabj2yxsRpI2Jl1B/jTpqH5Z0rUeY5o+sW/3PxHYI1+YdwDwOdK8FidEufNZDI6I0d3K9ouIC0qMYR7gY8CLtHgY6nYmaSzwWeBvpOtvpuvxU+bnohM5WVhDkvoDH84PH46Id0vc993AZyPiRUmfIiWub5AmZFqrzIvyJAnYB1g1Ik7M42QtGxF3FTy1r+PoyM4W9SQdBvwfabrj+jHDoOR5TjqRk4XNQNIhwIUR8XJ+vDiwd0T8pqT9T+vZIulMYFJEnJAfT+u9VlIsbdELSdKppG7Dl3fqxaI1koZFxP9VHUencbKok0db3YTUaDYqIp6tOKRKNPpBLvPINndXXT8i3sujrg6tDcMi6f6IaOl4TN1iuTsiNqx//VV008zdJBcCppJ7RFHBVKLtIjf2L0Ndu2tEPFFdRHO/jm/grpH0ZeD7pAvzanMtnxgR51QbWSX6SVLtCDZ/Mcvspnkx6SryF0gN6//McawOvFJiHNAmvZCaDWzYaSQdCpwAPEfX/yJIMztai/jMIpP0MPDxiJicHy8J3B4RH27+zLmPpFOAlYHaIHlfBZ6IiCNLjOFjwHKkKp/Xc9mawIAocQ4HSfuQJsbaEDif3AspIv5cVgx1sexCGlkAYGREXF12DO1A0jjSdSeTq46lk/jMostkUtfMmim5rBN9hzRE+dfy43tJPaJKExF3Nij7X5kx5H1eKGkMXb2Qdq2iF5Kkk0nddy/MRYdL+kREHFN2LG3gSco/w+x4PrPIJA0HPkrqUx+kOSXuzbeOGytfXfOA70m6Ovay6KAZ6mokrQZMjIi385hQ65Fmanu55DjuJbXjvJ8f9yONxttxVS+S/kDqqXcNnT0Hd6l8ZtHl0XyruTL/7Zi6YjWeB7zTJ+C5DBic20t+B4wALgJ2qCCWxUjXWgAsWsH+28UT+dbpc3CXymcW3XTyGPlqo3nA20Vdb6hvk4ZMP6OKax4k7Q2cDNxMqg77FHBMRFxSZhzWuXxmkSlN33kBaSpRck+c/SPigUoDK9fupHnAb5ZUmwe8z8fFn8O8m3+o9wd2zmX9yw4iIi6WNJLUbgHwnU7r2i3pKpoM7hkRu5QYTsfxmUUm6XbguxFxc368BfDjiPh4pYFVQF3zgO8NbEmak7zUecDbRZ7P4mvAHfkHexVgz4j4aclx3BjdptZtVDY3k/TpZssj4payYulEThaZx8hvTBXNA25J3Qi8NzP9eEiLANdFxEcqCs06jJNFJukK0kxstQHi9gU2iojdqovKqiLp0ojYU2ke8Bm+JGX1QpJ0OF0j8NaPh/QqcHYn9lCzajhZZPkI+gfA5rnon6QRTl+qLiqriqTlIuIZSSs3Wh4Rj5cczzci4owy92lWz8nCrI3l4dqfrDVmS9qfNFz745Q8XLt1NieLLF9jcCQwkOkHJ9uyqpisepJ2B34KfJBUBSRKHMCvnYZrbxc99Ip6BRgN/C4i3prxWTa7nCwySf8FfkuamW1qrbysCX+sPeVxiHauaqKhdhquvV1IOh1YmjTgJKSxu14lJZBF8mx61sd8nUWX9yJiWNVBWNt5ruIZ6fpJmjci3iONTzW0blmnfn8/3m0+kaskjYqIjSV10nVRperUD9s0kpbId6+S9HXSPMf14824TrizjZb0J+CvTP+5uLyk/bfTcO3tYoCklWrzV+TZCwfkZe9UF9bcreOroSQ9Rjp9bXSlsqdq7HCSzm1QHBFxUIkxtMVw7e1C0g6kKuNHSd/bVYCvAyOBr0TEL6uLbu7V8cnCzOY8kuYHahckPuxG7dbr+GThronWiKQzmL7HTZBG4r05Im6rJiqrkfRxZuy5OLyygDqAk4W7JloDkg5oULwEaX6PP7mqozqSLgBWA+6hq+diRMRh1UU193OycNdEmwmSFiRNt1vqEOXWRdKDwNrR6T9eJZun6gDaQD9JtVPZrYCb6pZ1fG8xm15EvFl1DMb9lDzNr/nHENw10XopH1TsB0ysOpYOtxQwVtJdTN+d2fNZtFDHV0OBuybajCRNYcYhJd4EbgGOiIiny4/KoOd5LTyfRWs5WZiZWSFXQ5nZHEHSbRGxeYOzvlIHd+xUPrMwM7NCPrMwszmOpA1JE5UFcFtE/KfikOZ67jpr1guSlpe0Ur75IKtCkr4PnA8sSeoZdZ6k46qNau7naiizBiQdA/SPiBPz4yeAl4H5gPMj4idVxtfJJD0MDKqNB5UvlLwnIj5cbWRzN59ZmDX2eeDndY8nR8R6wDrAjtWEZNnTwAJ1j+cHnqoolo7h02mzHtSuuclOz2VT85GsVecV4AFJN5DaLLYG7pL0KwCPEdUaThZmjQ2Q1D8i3gWIiPNg2tDY7qJZrSvyrWZkRXF0FLdZmDUg6cek8YcOjYg3ctlCwK+BZyPimCrj63SS5iPNZxGk+Sw8Q16Luc3CrLHvAc8DT0gaI2kMMAF4Li+ziuSZ8h4FfkVK3uMkbV9tVHM/n1mYNZHbJ1bPD8d51NnqSXoI2CkixuXHqwHXRMRHmj/TZofbLMyayMnhvqrjsOlMqSWKbDwwpapgOoXPLMxsjiJpGLAycCmpzeLzwBPAPwAi4vLqopt7OVmY9UCSgBUi4smqY7Euks5tsjgi4qDSgukgThZmTUi6LyI+WnUcZlVzm4VZc3dL2jgiRlUdSKeT9O2I+JmkM5hxYipfjNdiThZmzW0K7CPpceB1uuZOWK/asDrSg/nv6Eqj6FCuhjJrQtLKjcoj4vGyYzGrks8szJqIiMclbQ6sERHnSloaGFB1XJ1M0prAkcBA6n7DImLLqmLqBD6zMGtC0vHAYODDEbGmpA8Bf46IT1QcWseS9F/gt8AYYGqtPCLGVBZUB/CZhVlzuwEbAHcDRMTTkhauNqSO915EDKs6iE7jsaHMmnsn0ul3wLTBBK0CkpaQtARwlaSvS1quVpbLrYV8ZmHW3KWSfgcsJukrwEHA2RXH1KnGkJK28uOj6pYFsGrpEXUQt1mYFZC0NbBNfvj3iLihynjMquAzC7Ni9wELko5ePahgRSRtDDwZEc/mx/sDnwMeB06IiBerjG9u5zYLsyYkfRm4C9gd2AO4U5LHHqrG74B3ACR9CjgZGE6aZvWsCuPqCK6GMmtC0sPAxyNicn68JHB7RHy42sg6j6T/RsSgfP9MYFJEnJAf3xMR61cZ39zOZxZmzU1m+rkSpuQyK18/SbWq862Am+qWuUq9xfwGmzU3Dvi3pCtJbRZDgHslfRMgIk6rMrgOczFwi6QXgDeBfwJIWp1UFWUt5GoosybyFdw9iogflBWLgaSPAcuReqW9nsvWBAZExN2VBjeXc7IwM7NCroYya0LSzTSeO8GD1llHcbIwa+7IuvsLkPr1v1dRLGaVcTWU2UySdFdEbFJ1HGZl8pmFWRPdBqibB9gIWLSicMwq42Rh1lz94HXvAY8BB1cakVkFXA1lZmaFfAW3WQOSNpa0bN3j/SVdKelXnjvBOpGThVljHrTOrI7bLMwa61c35PUXgLMi4jLgMkn3VBiXWSV8ZmHWmAetM6vjD71ZYx60zqyOe0OZ9cCD1pl1cbIwM7NCbrMwM7NCThZmZlbIycKsCUnLSrpE0qOSxki6NrdbNFp3MUlfLztGszI4WZj1QJKAK4CREbFaRGwEHAMs08NTFgNanizquvSalcbJwqxnnwHejYjf1goi4r/AfyTdKOluSfdJGpIXnwysJukeSacASDpK0ihJ90qaNgWrpO9JeljSbZIulnRkLl9f0p15/SskLZ7LR0r6paTRwHclPSapf162SP1js1bwEYpZz9YljTrb3VvAbhHxqqSlgDsljQCOBtaNiPUBJG0DrAFsQhq1dkQeOuRN0iRKg4D+wN11+xkOfCMibpF0InA8cEReNl9EDM7bHgjsCPwV2Au4PCLe7cPXbjYdJwuzmSfgx/mH/31geRpXTW2Tb//JjweQksfCwJUR8RbwlqSrACQtCiwWEbfk9c8H/ly3vT/V3f898G1SsjgQ+EofvC6zHjlZmPXsAWCPBuX7AEsDG0XEu5ImkKZc7U7ATyLid9MVSkc0WLc3Xq/diYh/SRooaQvSOFb3z+I2zXrFbRZmPbsJmF/S0FqBpPWAlYHnc6L4TH4MMIV01lBzPXCQpAH5uctL+iDwL2BnSQvkZTsBRMQrwEuSPpmfvx9wCz0bDlwEnDubr9OskM8szHoQESFpN+CXkr5DaquYAJwA/ErSfcBo4KG8/mRJ/5J0P/C3iDhK0lrAHaljFa8B+0bEqNzGcS/wHHAfXeNNHQD8VtIHgPGkKqaeXAj8iDSOlVlLebgPswpIGhARr+WkcCswdGbHm5K0BzAkIvZrSZBmdXxmYVaNsyStTWrrOH8WEsUZwPbADq0Izqw7n1mYmVkhN3CbmVkhJwszMyvkZGFmZoWcLMzMrJCThZmZFfr/yQndVx4TuJYAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fxGVedYcWbba"
      },
      "source": [
        "##Keyword Cannibalization"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QzhVd7GjW2X6",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "3858a4f9-2fa9-40c3-c0c0-81a10c3d8dec"
      },
      "source": [
        "brand_keyword_cannibalization_pivot = lp_query_brand.pivot_table(index='Query', values=['Landing Page','URL Clicks'], aggfunc={'Landing Page': 'count', 'URL Clicks': np.sum})\n",
        "brand_keyword_cannibalization_pivot = brand_keyword_cannibalization_pivot.sort_values(by='Landing Page', ascending=False)\n",
        "brand_keyword_cannibalization_pivot.head(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Landing Page</th>\n",
              "      <th>URL Clicks</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Query</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>site:shop.googlemerchandisestore.com</th>\n",
              "      <td>119</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google merchandise store</th>\n",
              "      <td>54</td>\n",
              "      <td>533</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google merchandise</th>\n",
              "      <td>43</td>\n",
              "      <td>162</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>shop.googlemerchandisestore</th>\n",
              "      <td>41</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>if the google merchandise store</th>\n",
              "      <td>38</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>shop.googlemerchandisestore.com</th>\n",
              "      <td>33</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google lanyard</th>\n",
              "      <td>30</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google gift shop</th>\n",
              "      <td>29</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google store mountain view</th>\n",
              "      <td>28</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google employee store</th>\n",
              "      <td>27</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                      Landing Page  URL Clicks\n",
              "Query                                                         \n",
              "site:shop.googlemerchandisestore.com           119           0\n",
              "google merchandise store                        54         533\n",
              "google merchandise                              43         162\n",
              "shop.googlemerchandisestore                     41          10\n",
              "if the google merchandise store                 38           0\n",
              "shop.googlemerchandisestore.com                 33           0\n",
              "google lanyard                                  30           0\n",
              "google gift shop                                29           2\n",
              "google store mountain view                      28           4\n",
              "google employee store                           27           1"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 139
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EU4l5s2zX7yF",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "cc55f5f3-5cc0-4e60-dd52-fbe8b0eb6675"
      },
      "source": [
        "non_brand_keyword_cannibalization_pivot = lp_query_non_brand.pivot_table(index={'Query'}, values=['Landing Page','URL Clicks'], aggfunc={'Landing Page':'count', 'URL Clicks': np.sum})\n",
        "non_brand_keyword_cannibalization_pivot = non_brand_keyword_cannibalization_pivot.sort_values(by='Landing Page', ascending=False)\n",
        "non_brand_keyword_cannibalization_pivot.head(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Landing Page</th>\n",
              "      <th>URL Clicks</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Query</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>merchandise store</th>\n",
              "      <td>38</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>merchandise shop</th>\n",
              "      <td>37</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>buy merchandise</th>\n",
              "      <td>31</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>merchandise</th>\n",
              "      <td>30</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>merchandise.com</th>\n",
              "      <td>29</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>home merchandise</th>\n",
              "      <td>28</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>store merchandise</th>\n",
              "      <td>28</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>twitter merchandise store</th>\n",
              "      <td>26</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>go merchandise</th>\n",
              "      <td>26</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>shop merchandise</th>\n",
              "      <td>25</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                           Landing Page  URL Clicks\n",
              "Query                                              \n",
              "merchandise store                    38           1\n",
              "merchandise shop                     37           1\n",
              "buy merchandise                      31           0\n",
              "merchandise                          30           4\n",
              "merchandise.com                      29           0\n",
              "home merchandise                     28           0\n",
              "store merchandise                    28           0\n",
              "twitter merchandise store            26           0\n",
              "go merchandise                       26           0\n",
              "shop merchandise                     25           0"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 140
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "OfdcVN93XTU1"
      },
      "source": [
        "##Breakout Queries"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AIS-hKWT1mCc",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "9f8106bf-99d2-4b8d-d77f-89e9e8a6a34c"
      },
      "source": [
        "lp_query_grouped[lp_query_grouped['Clicks (Prior Period)'] == 0].head(50)\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Impressions</th>\n",
              "      <th>Impressions Difference</th>\n",
              "      <th>URL Clicks</th>\n",
              "      <th>URL Clicks Difference</th>\n",
              "      <th>URL CTR</th>\n",
              "      <th>URL CTR Difference</th>\n",
              "      <th>Impressions (Prior Period)</th>\n",
              "      <th>Clicks (Prior Period)</th>\n",
              "      <th>Site CTR (Prior Period)</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Query</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>google t シャツ</th>\n",
              "      <td>57.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>6.000000</td>\n",
              "      <td>6.000000</td>\n",
              "      <td>0.105263</td>\n",
              "      <td>0.105263</td>\n",
              "      <td>35.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>tshirt store</th>\n",
              "      <td>628.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.007962</td>\n",
              "      <td>0.007962</td>\n",
              "      <td>468.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google pixel shipping speed</th>\n",
              "      <td>28.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>0.178571</td>\n",
              "      <td>0.178571</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google printed t shirts</th>\n",
              "      <td>33.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>0.121212</td>\n",
              "      <td>0.121212</td>\n",
              "      <td>19.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google fi phone shipping time</th>\n",
              "      <td>18.0</td>\n",
              "      <td>-9.0</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>0.222222</td>\n",
              "      <td>0.222222</td>\n",
              "      <td>27.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google certification</th>\n",
              "      <td>2368.0</td>\n",
              "      <td>992.0</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>0.001689</td>\n",
              "      <td>0.001689</td>\n",
              "      <td>1376.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>youtube play store</th>\n",
              "      <td>1277.0</td>\n",
              "      <td>1231.0</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>0.003132</td>\n",
              "      <td>0.003132</td>\n",
              "      <td>46.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google returns</th>\n",
              "      <td>284.0</td>\n",
              "      <td>-6.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.010563</td>\n",
              "      <td>0.010563</td>\n",
              "      <td>290.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>stickers shop</th>\n",
              "      <td>226.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.013274</td>\n",
              "      <td>0.013274</td>\n",
              "      <td>142.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>hat</th>\n",
              "      <td>5110.0</td>\n",
              "      <td>2566.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.000587</td>\n",
              "      <td>0.000587</td>\n",
              "      <td>2544.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google return</th>\n",
              "      <td>250.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.012000</td>\n",
              "      <td>0.012000</td>\n",
              "      <td>236.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>accessories google</th>\n",
              "      <td>24.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.125000</td>\n",
              "      <td>0.125000</td>\n",
              "      <td>23.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>shipping information</th>\n",
              "      <td>473.0</td>\n",
              "      <td>402.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.006342</td>\n",
              "      <td>0.006342</td>\n",
              "      <td>71.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>stikers</th>\n",
              "      <td>488.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>0.006148</td>\n",
              "      <td>0.006148</td>\n",
              "      <td>138.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google fi shipping time</th>\n",
              "      <td>51.0</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.039216</td>\n",
              "      <td>0.039216</td>\n",
              "      <td>61.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>electronic merchandise</th>\n",
              "      <td>28.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.071429</td>\n",
              "      <td>0.071429</td>\n",
              "      <td>18.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google store shipping delay</th>\n",
              "      <td>14.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.142857</td>\n",
              "      <td>0.142857</td>\n",
              "      <td>11.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>android mini collectible</th>\n",
              "      <td>15.0</td>\n",
              "      <td>-15.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.133333</td>\n",
              "      <td>0.133333</td>\n",
              "      <td>30.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google daddy</th>\n",
              "      <td>1224.0</td>\n",
              "      <td>456.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.001634</td>\n",
              "      <td>0.001634</td>\n",
              "      <td>768.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30 days of google cloud 2021 goodies</th>\n",
              "      <td>14.0</td>\n",
              "      <td>-1.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.142857</td>\n",
              "      <td>0.142857</td>\n",
              "      <td>15.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google store delivery</th>\n",
              "      <td>50.0</td>\n",
              "      <td>7.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.040000</td>\n",
              "      <td>0.040000</td>\n",
              "      <td>43.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>merchandise socks</th>\n",
              "      <td>26.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.076923</td>\n",
              "      <td>0.076923</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>android toy robot</th>\n",
              "      <td>65.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.030769</td>\n",
              "      <td>0.030769</td>\n",
              "      <td>42.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>webstore</th>\n",
              "      <td>1702.0</td>\n",
              "      <td>1420.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.001175</td>\n",
              "      <td>0.001175</td>\n",
              "      <td>282.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google store cancel order</th>\n",
              "      <td>70.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.028571</td>\n",
              "      <td>0.028571</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>cap google</th>\n",
              "      <td>60.0</td>\n",
              "      <td>-3.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.033333</td>\n",
              "      <td>0.033333</td>\n",
              "      <td>63.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>bags</th>\n",
              "      <td>3539.0</td>\n",
              "      <td>1128.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.000565</td>\n",
              "      <td>0.000565</td>\n",
              "      <td>2411.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mouse pad</th>\n",
              "      <td>1680.0</td>\n",
              "      <td>390.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.001190</td>\n",
              "      <td>0.001190</td>\n",
              "      <td>1290.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>android logo toy</th>\n",
              "      <td>15.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.133333</td>\n",
              "      <td>0.133333</td>\n",
              "      <td>11.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>shop t shirt</th>\n",
              "      <td>172.0</td>\n",
              "      <td>163.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.011628</td>\n",
              "      <td>0.011628</td>\n",
              "      <td>9.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>googlerainbow</th>\n",
              "      <td>61.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.032787</td>\n",
              "      <td>0.032787</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>indian youtuber merchandise</th>\n",
              "      <td>36.0</td>\n",
              "      <td>-6.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.055556</td>\n",
              "      <td>0.055556</td>\n",
              "      <td>42.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>womens t shirts</th>\n",
              "      <td>1298.0</td>\n",
              "      <td>1187.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.001541</td>\n",
              "      <td>0.001541</td>\n",
              "      <td>111.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google street view shirt</th>\n",
              "      <td>4.0</td>\n",
              "      <td>-10.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>merch apparel</th>\n",
              "      <td>50.0</td>\n",
              "      <td>23.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.040000</td>\n",
              "      <td>0.040000</td>\n",
              "      <td>27.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>shop t-shirt</th>\n",
              "      <td>31.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.064516</td>\n",
              "      <td>0.064516</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>women t-shirts</th>\n",
              "      <td>157.0</td>\n",
              "      <td>117.0</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>0.012739</td>\n",
              "      <td>0.012739</td>\n",
              "      <td>40.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>googley swag</th>\n",
              "      <td>191.0</td>\n",
              "      <td>152.0</td>\n",
              "      <td>1.500000</td>\n",
              "      <td>1.500000</td>\n",
              "      <td>0.003937</td>\n",
              "      <td>0.003937</td>\n",
              "      <td>39.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>socks</th>\n",
              "      <td>3679.5</td>\n",
              "      <td>847.5</td>\n",
              "      <td>1.500000</td>\n",
              "      <td>1.500000</td>\n",
              "      <td>0.000205</td>\n",
              "      <td>0.000205</td>\n",
              "      <td>2832.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>chrome dinosaurs</th>\n",
              "      <td>19.0</td>\n",
              "      <td>-0.5</td>\n",
              "      <td>1.500000</td>\n",
              "      <td>1.500000</td>\n",
              "      <td>0.041667</td>\n",
              "      <td>0.041667</td>\n",
              "      <td>19.5</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>дино хром</th>\n",
              "      <td>59.0</td>\n",
              "      <td>-2.0</td>\n",
              "      <td>1.333333</td>\n",
              "      <td>1.333333</td>\n",
              "      <td>0.008032</td>\n",
              "      <td>0.008032</td>\n",
              "      <td>61.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>crewneck sweatshirt green</th>\n",
              "      <td>13.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.076923</td>\n",
              "      <td>0.076923</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>t shirt merchandising</th>\n",
              "      <td>12.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.083333</td>\n",
              "      <td>0.083333</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google certificate</th>\n",
              "      <td>283.0</td>\n",
              "      <td>107.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.003534</td>\n",
              "      <td>0.003534</td>\n",
              "      <td>176.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>noogler hat</th>\n",
              "      <td>58.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.017241</td>\n",
              "      <td>0.017241</td>\n",
              "      <td>53.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>how long does google fi take to ship</th>\n",
              "      <td>50.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.020000</td>\n",
              "      <td>0.020000</td>\n",
              "      <td>49.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>webstore google</th>\n",
              "      <td>411.0</td>\n",
              "      <td>343.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.002433</td>\n",
              "      <td>0.002433</td>\n",
              "      <td>68.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>charcoal long sleeve shirt</th>\n",
              "      <td>63.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.015873</td>\n",
              "      <td>0.015873</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google shipment tracking</th>\n",
              "      <td>69.0</td>\n",
              "      <td>-20.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.014493</td>\n",
              "      <td>0.014493</td>\n",
              "      <td>89.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>google baseball red hat</th>\n",
              "      <td>63.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.015873</td>\n",
              "      <td>0.015873</td>\n",
              "      <td>7.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                      Impressions  ...  Site CTR (Prior Period)\n",
              "Query                                              ...                         \n",
              "google t シャツ                                 57.0  ...                      0.0\n",
              "tshirt store                                628.0  ...                      0.0\n",
              "google pixel shipping speed                  28.0  ...                      0.0\n",
              "google printed t shirts                      33.0  ...                      0.0\n",
              "google fi phone shipping time                18.0  ...                      0.0\n",
              "google certification                       2368.0  ...                      0.0\n",
              "youtube play store                         1277.0  ...                      0.0\n",
              "google returns                              284.0  ...                      0.0\n",
              "stickers shop                               226.0  ...                      0.0\n",
              "hat                                        5110.0  ...                      0.0\n",
              "google return                               250.0  ...                      0.0\n",
              "accessories google                           24.0  ...                      0.0\n",
              "shipping information                        473.0  ...                      0.0\n",
              "stikers                                     488.0  ...                      0.0\n",
              "google fi shipping time                      51.0  ...                      0.0\n",
              "electronic merchandise                       28.0  ...                      0.0\n",
              "google store shipping delay                  14.0  ...                      0.0\n",
              "android mini collectible                     15.0  ...                      0.0\n",
              "google daddy                               1224.0  ...                      0.0\n",
              "30 days of google cloud 2021 goodies         14.0  ...                      0.0\n",
              "google store delivery                        50.0  ...                      0.0\n",
              "merchandise socks                            26.0  ...                      0.0\n",
              "android toy robot                            65.0  ...                      0.0\n",
              "webstore                                   1702.0  ...                      0.0\n",
              "google store cancel order                    70.0  ...                      0.0\n",
              "cap google                                   60.0  ...                      0.0\n",
              "bags                                       3539.0  ...                      0.0\n",
              "mouse pad                                  1680.0  ...                      0.0\n",
              "android logo toy                             15.0  ...                      0.0\n",
              "shop t shirt                                172.0  ...                      0.0\n",
              "googlerainbow                                61.0  ...                      0.0\n",
              "indian youtuber merchandise                  36.0  ...                      0.0\n",
              "womens t shirts                            1298.0  ...                      0.0\n",
              "google street view shirt                      4.0  ...                      0.0\n",
              "merch apparel                                50.0  ...                      0.0\n",
              "shop t-shirt                                 31.0  ...                      0.0\n",
              "women t-shirts                              157.0  ...                      0.0\n",
              "googley swag                                191.0  ...                      0.0\n",
              "socks                                      3679.5  ...                      0.0\n",
              "chrome dinosaurs                             19.0  ...                      0.0\n",
              "дино хром                                    59.0  ...                      0.0\n",
              "crewneck sweatshirt green                    13.0  ...                      0.0\n",
              "t shirt merchandising                        12.0  ...                      0.0\n",
              "google certificate                          283.0  ...                      0.0\n",
              "noogler hat                                  58.0  ...                      0.0\n",
              "how long does google fi take to ship         50.0  ...                      0.0\n",
              "webstore google                             411.0  ...                      0.0\n",
              "charcoal long sleeve shirt                   63.0  ...                      0.0\n",
              "google shipment tracking                     69.0  ...                      0.0\n",
              "google baseball red hat                      63.0  ...                      0.0\n",
              "\n",
              "[50 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 144
        }
      ]
    }
  ]
}