applications/10-bridging-web-ui-to-notebook.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "material-discharge",
   "metadata": {},
   "source": [
    "# Bridging Web UI into Notebooks\n",
    "\n",
    "**Star: `ipywidgets`**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "dietary-restriction",
   "metadata": {},
   "outputs": [],
   "source": [
    "import ipywidgets as widgets\n",
    "# From here on will use 'widgets.' to reference this library"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "stylish-benefit",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import plotly\n",
    "import folium\n",
    "import re\n",
    "import plotly.express as px\n",
    "import unicodedata"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "blank-cattle",
   "metadata": {},
   "source": [
    "## Preprocessing\n",
    "\n",
    "### Data \n",
    "\n",
    "Data reflects index values which can be used to evaluate boards (billboards). \n",
    "\n",
    "The three index types: \n",
    "\n",
    "    AC - Audience Concentration: Percentage of target audience deivce within total audience devices\n",
    "    AD - Audience Distribution: Percentage describing audience seen at a board also seen at another board\n",
    "    I - Index: Indicates highest index accross all boards at a particular hour"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "discrete-possible",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Enter the file path to any index file\n",
    "df = pd.read_csv('../data/sample_boards_report.csv')\n",
    "\n",
    "\n",
    "# Dataframe clean up\n",
    "df = df.rename(columns={'day_of_week':'DoW',\n",
    "                        'long':'lon',\n",
    "                        'audience_composition':'audComp',\n",
    "                       'bell_mobile_device_match_rate':'bellMobileDeviceMatchRate'})\n",
    "\n",
    "\n",
    "# Condense Index values to average over all hours\n",
    "df['AC'] = df[[s for s in df.columns if 'AC' in s]].mean(axis=1)\n",
    "df['AD'] = df[[s for s in df.columns if 'AD' in s]].mean(axis=1)\n",
    "df['I'] = df[[s for s in df.columns if 'I' in s]].mean(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "fancy-wiring",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['board_id', 'market', 'product_name', 'sales_address', 'lat', 'lon',\n",
       "       'height', 'width', 'facing', 'total_observed',\n",
       "       'audience_target_observed', 'audComp', 'index', 'DoW', 'AD_00', 'AD_01',\n",
       "       'AD_02', 'AD_03', 'AD_04', 'AD_05', 'AD_06', 'AD_07', 'AD_08', 'AD_09',\n",
       "       'AD_10', 'AD_11', 'AD_12', 'AD_13', 'AD_14', 'AD_15', 'AD_16', 'AD_17',\n",
       "       'AD_18', 'AD_19', 'AD_20', 'AD_21', 'AD_22', 'AD_23', 'AC_00', 'AC_01',\n",
       "       'AC_02', 'AC_03', 'AC_04', 'AC_05', 'AC_06', 'AC_07', 'AC_08', 'AC_09',\n",
       "       'AC_10', 'AC_11', 'AC_12', 'AC_13', 'AC_14', 'AC_15', 'AC_16', 'AC_17',\n",
       "       'AC_18', 'AC_19', 'AC_20', 'AC_21', 'AC_22', 'AC_23', 'I_00', 'I_01',\n",
       "       'I_02', 'I_03', 'I_04', 'I_05', 'I_06', 'I_07', 'I_08', 'I_09', 'I_10',\n",
       "       'I_11', 'I_12', 'I_13', 'I_14', 'I_15', 'I_16', 'I_17', 'I_18', 'I_19',\n",
       "       'I_20', 'I_21', 'I_22', 'I_23', 'AC', 'AD', 'I'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "dress-spectrum",
   "metadata": {},
   "outputs": [],
   "source": [
    "# We create a custom function to re-format the data for easier visualization\n",
    "def load_all_data(df):\n",
    "    # Select AC, AD, an I columns\n",
    "    indices= df[df.columns[-76:-3]]\n",
    "    \n",
    "    # Extract hour from column\n",
    "    Col = df[df.columns[-76:-3]].columns.str.split('_',expand=True).values\n",
    "    \n",
    "    # Create a multi-level index to use for pivot \n",
    "    indices.columns = pd.MultiIndex.from_tuples([('', x[0]) if pd.isnull(x[1]) else x for x in Col])\n",
    "    \n",
    "    # Groupby Day of Week\n",
    "    a = indices.groupby([( '', 'DoW')]).mean()\n",
    "    \n",
    "    # Pivot table so that extracted hour becomes a row value under HoD column for each DoW\n",
    "    # Values are separated and aggregated by mean values for each of AC, AD, and I\n",
    "    new = a.unstack(level=3).reset_index().dropna().rename(columns={'level_0':'index', \n",
    "                                                                'level_1':'HoD', \n",
    "                                                                ('','DoW'):'DoW',\n",
    "                                                                0:'values'}).pivot_table('values',\n",
    "                                                                                         ['DoW','HoD'],\n",
    "                                                                                         ['index'], \n",
    "                                                                                         aggfunc='mean').reset_index()\n",
    "    # Only need Days of Week Values in Heatmap therefore total can be removed\n",
    "    new = new[~(new['DoW'] == 'total')]\n",
    "    \n",
    "    return new"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "whole-publicity",
   "metadata": {},
   "source": [
    "# Introduction\n",
    "\n",
    "We have previously looked at creating interactive visuals [07-interactive-visuals](07-interactive-visualizations.ipynb) utilizing tools/libraries such as [Plotly](https://plotly.com/python/) and [Deck.gl](https://deck.gl/docs). \n",
    "\n",
    "\n",
    "**In this tutorial we will examine:**\n",
    "* **General Overiview of `ipywidget`**\n",
    "* **Introduce different levels of `ipywidget`use cases**\n",
    "* **Demonstrate the high customization capability of the tool**\n",
    "\n",
    "\n",
    "## What is `ipywidgets` in a nutshell?\n",
    "`ipywidget` allows us to create [interactive HTML widgets](https://ipywidgets.readthedocs.io/en/latest/examples/Widget%20List.html) to manipulate and visualize data. "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "primary-philippines",
   "metadata": {},
   "source": [
    "## Use Cases:\n",
    "\n",
    "### 1. Basic HTML Rendering"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "drawn-sleeve",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "35232660a6cd43bab7e3b241383aa75e",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HTML(value='\\n    \"<i>Battlecruiser operational!</i>\"\\n    <br />\\n    - A battlecruiser commander\\n')"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "widgets.HTML('''\n",
    "    \"<i>Battlecruiser operational!</i>\"\n",
    "    <br />\n",
    "    - A battlecruiser commander\n",
    "''')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "mathematical-bradford",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "3df6ca26816544f581e2ca997eb5dc35",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "HTML(value='\\n  <!DOCTYPE html>\\n  <html lang=\"en\" xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:v=\"urn:schemas-m…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# some more nuanced HTML rendering, such as EQ product's login email template\n",
    "widgets.HTML('''\n",
    "  <!DOCTYPE html>\n",
    "  <html lang=\"en\" xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\">\n",
    "  <head>\n",
    "    <meta charset=\"utf-8\"> <!-- utf-8 works for most cases -->\n",
    "    <meta name=\"viewport\" content=\"width=device-width\"> <!-- Forcing initial-scale shouldn't be necessary -->\n",
    "    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\"> <!-- Use the latest (edge) version of IE rendering engine -->\n",
    "    <meta name=\"x-apple-disable-message-reformatting\">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n",
    "    <title></title> <!-- The title tag shows in email notifications, like Android 4.4. -->\n",
    "    <!-- Web Font / @font-face : BEGIN -->\n",
    "    <!-- NOTE: If web fonts are not required, lines 10 - 27 can be safely removed. -->\n",
    "    <!-- Desktop Outlook chokes on web font references and defaults to Times New Roman, so we force a safe fallback font. -->\n",
    "    <!--[if mso]>\n",
    "      <style>\n",
    "        * {\n",
    "          font-family: sans-serif !important;\n",
    "        }\n",
    "      </style>\n",
    "    <![endif]-->\n",
    "    <!-- All other clients get the webfont reference; some will render the font and others will silently fail to the fallbacks. More on that here: http://stylecampaign.com/blog/2015/02/webfont-support-in-email/ -->\n",
    "    <!--[if !mso]><!-->\n",
    "    <!-- insert web font reference, eg: <link href='https://fonts.googleapis.com/css?family=Roboto:400,700' rel='stylesheet' type='text/css'> -->\n",
    "    <!--<![endif]-->\n",
    "    <!-- Web Font / @font-face : END -->\n",
    "    <!-- CSS Reset : BEGIN -->\n",
    "    <style>\n",
    "      /* What it does: Remove spaces around the email design added by some email clients. */\n",
    "      /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n",
    "      html,\n",
    "      body {\n",
    "        margin: 0 auto !important;\n",
    "        padding: 0 !important;\n",
    "        height: 100% !important;\n",
    "        width: 100% !important;\n",
    "      }\n",
    "      /* What it does: Stops email clients resizing small text. */\n",
    "      * {\n",
    "        -ms-text-size-adjust: 100%;\n",
    "        -webkit-text-size-adjust: 100%;\n",
    "      }\n",
    "      /* What it does: Centers email on Android 4.4 */\n",
    "      div[style*=\"margin: 16px 0\"] {\n",
    "        margin: 0 !important;\n",
    "      }\n",
    "      /* What it does: Stops Outlook from adding extra spacing to tables. */\n",
    "      table,\n",
    "      td {\n",
    "        mso-table-lspace: 0pt !important;\n",
    "        mso-table-rspace: 0pt !important;\n",
    "      }\n",
    "      /* What it does: Fixes webkit padding issue. Fix for Yahoo mail table alignment bug. Applies table-layout to the first 2 tables then removes for anything nested deeper. */\n",
    "      table {\n",
    "        border-spacing: 0 !important;\n",
    "        border-collapse: collapse !important;\n",
    "        table-layout: fixed !important;\n",
    "        margin: 0 auto !important;\n",
    "      }\n",
    "      table table table {\n",
    "        table-layout: auto;\n",
    "      }\n",
    "      /* What it does: Uses a better rendering method when resizing images in IE. */\n",
    "      img {\n",
    "        -ms-interpolation-mode:bicubic;\n",
    "      }\n",
    "      /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n",
    "      a {\n",
    "        text-decoration: none;\n",
    "      }\n",
    "      /* What it does: A work-around for email clients meddling in triggered links. */\n",
    "      *[x-apple-data-detectors],  /* iOS */\n",
    "      .unstyle-auto-detected-links *,\n",
    "      .aBn {\n",
    "        border-bottom: 0 !important;\n",
    "        cursor: default !important;\n",
    "        color: inherit !important;\n",
    "        text-decoration: none !important;\n",
    "        font-size: inherit !important;\n",
    "        font-family: inherit !important;\n",
    "        font-weight: inherit !important;\n",
    "        line-height: inherit !important;\n",
    "      }\n",
    "      /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n",
    "      .a6S {\n",
    "        display: none !important;\n",
    "        opacity: 0.01 !important;\n",
    "      }\n",
    "      /* If the above doesn't work, add a .g-img class to any image in question. */\n",
    "      img.g-img + div {\n",
    "        display: none !important;\n",
    "      }\n",
    "      /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n",
    "      /* Create one of these media queries for each additional viewport size you'd like to fix */\n",
    "      /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n",
    "      @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n",
    "        .email-container {\n",
    "          min-width: 320px !important;\n",
    "        }\n",
    "      }\n",
    "      /* iPhone 6, 6S, 7, 8, and X */\n",
    "      @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n",
    "        .email-container {\n",
    "          min-width: 375px !important;\n",
    "        }\n",
    "      }\n",
    "      /* iPhone 6+, 7+, and 8+ */\n",
    "      @media only screen and (min-device-width: 414px) {\n",
    "        .email-container {\n",
    "          min-width: 414px !important;\n",
    "        }\n",
    "      }\n",
    "    </style>\n",
    "    <!-- CSS Reset : END -->\n",
    "    <!-- Reset list spacing because Outlook ignores much of our inline CSS. -->\n",
    "    <!--[if mso]>\n",
    "    <style type=\"text/css\">\n",
    "      ul,\n",
    "      ol {\n",
    "        margin: 0 !important;\n",
    "      }\n",
    "      li {\n",
    "        margin-left: 30px !important;\n",
    "      }\n",
    "      li.list-item-first {\n",
    "        margin-top: 0 !important;\n",
    "      }\n",
    "      li.list-item-last {\n",
    "        margin-bottom: 10px !important;\n",
    "      }\n",
    "    </style>\n",
    "    <![endif]-->\n",
    "    <!-- Progressive Enhancements : BEGIN -->\n",
    "    <style>\n",
    "      /* What it does: Hover styles for buttons */\n",
    "      .button-td,\n",
    "      .button-a {\n",
    "        transition: all 100ms ease-in;\n",
    "      }\n",
    "      .button-td-primary:hover,\n",
    "      .button-a-primary:hover {\n",
    "        background: #555555 !important;\n",
    "        border-color: #555555 !important;\n",
    "      }\n",
    "      /* Media Queries */\n",
    "      @media screen and (max-width: 600px) {\n",
    "        /* What it does: Adjust typography on small screens to improve readability */\n",
    "        .email-container p {\n",
    "          font-size: 17px !important;\n",
    "        }\n",
    "      }\n",
    "    </style>\n",
    "    <!-- Progressive Enhancements : END -->\n",
    "    <!-- What it does: Makes background images in 72ppi Outlook render at correct size. -->\n",
    "    <!--[if gte mso 9]>\n",
    "    <xml>\n",
    "      <o:OfficeDocumentSettings>\n",
    "        <o:AllowPNG/>\n",
    "        <o:PixelsPerInch>96</o:PixelsPerInch>\n",
    "      </o:OfficeDocumentSettings>\n",
    "    </xml>\n",
    "    <![endif]-->\n",
    "  </head>\n",
    "  <!--\n",
    "    The email background color (#ffffff) is defined in three places:\n",
    "    1. body tag: for most email clients\n",
    "    2. center tag: for Gmail and Inbox mobile apps and web versions of Gmail, GSuite, Inbox, Yahoo, AOL, Libero, Comcast, freenet, Mail.ru, Orange.fr\n",
    "    3. mso conditional: For Windows 10 Mail\n",
    "  -->\n",
    "  <body width=\"100%\" style=\"margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #ffffff;\">\n",
    "    <center style=\"width: 100%; background-color: #ffffff;\">\n",
    "    <!--[if mso | IE]>\n",
    "    <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"background-color: #ffffff;\">\n",
    "    <tr>\n",
    "    <td>\n",
    "    <![endif]-->\n",
    "      <!-- Visually Hidden Preheader Text : BEGIN -->\n",
    "      <div style=\"display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;\">\n",
    "        LOCUS (EQ Works) Login Magic Link\n",
    "      </div>\n",
    "      <!-- Visually Hidden Preheader Text : END -->\n",
    "      <!-- Create white space after the desired preview text so email clients don’t pull other distracting text into the inbox preview. Extend as necessary. -->\n",
    "      <!-- Preview Text Spacing Hack : BEGIN -->\n",
    "      <div style=\"display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;\">\n",
    "        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n",
    "      </div>\n",
    "      <!-- Preview Text Spacing Hack : END -->\n",
    "      <!--\n",
    "        Set the email width. Defined in two places:\n",
    "        1. max-width for all clients except Desktop Windows Outlook, allowing the email to squish on narrow but never go wider than 600px.\n",
    "        2. MSO tags for Desktop Windows Outlook enforce a 600px width.\n",
    "      -->\n",
    "      <div style=\"max-width: 600px; margin: 0 auto;\" class=\"email-container\">\n",
    "        <!--[if mso]>\n",
    "        <table align=\"center\" role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"600\">\n",
    "        <tr>\n",
    "        <td>\n",
    "        <![endif]-->\n",
    "        <!-- Email Body : BEGIN -->\n",
    "        <table align=\"center\" role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"margin: 0 auto;\">\n",
    "          <!-- 1 Column Text + Button : BEGIN -->\n",
    "          <tr>\n",
    "            <td style=\"background-color: #ffffff;\">\n",
    "              <table role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\">\n",
    "                <tr>\n",
    "                  <td style=\"padding: 10px; font-family: sans-serif; font-size: 15px; line-height: 20px; color: #555555; text-align: center;\">\n",
    "                    <h1 style=\"margin: 0 0 10px 0; font-family: sans-serif; font-size: 25px; line-height: 30px; color: #333333; font-weight: normal;\">Welcome to LOCUS (EQ Works)</h1>\n",
    "                  </td>\n",
    "                </tr>\n",
    "                <tr>\n",
    "                  <td style=\"padding: 0 20px;\">\n",
    "                    <!-- Button : BEGIN -->\n",
    "                    <table align=\"center\" role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" style=\"margin: auto;\">\n",
    "                      <tr>\n",
    "                        <td class=\"button-td button-td-primary\" style=\"border-radius: 4px; background: #6BA4F8;\">\n",
    "                          <a class=\"button-a button-a-primary\" href=\"https://console.locus.place\" style=\"background: #6BA4F8; border: 1px solid #DDDDDD; font-family: sans-serif; font-size: 18px; line-height: 18px; text-decoration: none; padding: 17px 20px; color: #ffffff; display: block; border-radius: 4px;\">Login with the Magic Link on this device</a>\n",
    "                        </td>\n",
    "                      </tr>\n",
    "                    </table>\n",
    "                    <!-- Button : END -->\n",
    "                  </td>\n",
    "                </tr>\n",
    "              </table>\n",
    "            </td>\n",
    "          </tr>\n",
    "          <!-- 1 Column Text + Button : END -->\n",
    "        </table>\n",
    "        <!-- Email Body : END -->\n",
    "        <!-- Email Footer : BEGIN -->\n",
    "        <table align=\"center\" role=\"presentation\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\" style=\"margin: 0 auto;\">\n",
    "          <tr>\n",
    "            <td style=\"padding: 5px; font-family: sans-serif; font-size: 12px; line-height: 15px; text-align: center; color: #888888;\">\n",
    "              <hr>\n",
    "              <p>Having an issue? <a style=\"color: #6BA4F8;\" href=\"mailto:dev@eqworks.com?subject=LOCUS (EQ Works) Login issue\">Contact Us</a></p>\n",
    "            </td>\n",
    "          </tr>\n",
    "        </table>\n",
    "        <!-- Email Footer : END -->\n",
    "        <!--[if mso]>\n",
    "        </td>\n",
    "        </tr>\n",
    "        </table>\n",
    "        <![endif]-->\n",
    "      </div>\n",
    "    <!--[if mso | IE]>\n",
    "    </td>\n",
    "    </tr>\n",
    "    </table>\n",
    "    <![endif]-->\n",
    "    </center>\n",
    "  </body>\n",
    "  </html>\n",
    "''')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "shared-upset",
   "metadata": {},
   "source": [
    "### 2. Adding Interactivity to Variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "rural-technician",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>board_id</th>\n",
       "      <th>market</th>\n",
       "      <th>product_name</th>\n",
       "      <th>sales_address</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "      <th>height</th>\n",
       "      <th>width</th>\n",
       "      <th>facing</th>\n",
       "      <th>total_observed</th>\n",
       "      <th>...</th>\n",
       "      <th>I_17</th>\n",
       "      <th>I_18</th>\n",
       "      <th>I_19</th>\n",
       "      <th>I_20</th>\n",
       "      <th>I_21</th>\n",
       "      <th>I_22</th>\n",
       "      <th>I_23</th>\n",
       "      <th>AC</th>\n",
       "      <th>AD</th>\n",
       "      <th>I</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7387802</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Static</td>\n",
       "      <td>HUMBER COLLEGE - MF-J-Block J107-M-WAL 1</td>\n",
       "      <td>43.72806</td>\n",
       "      <td>-79.60669</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Main Floor</td>\n",
       "      <td>49</td>\n",
       "      <td>...</td>\n",
       "      <td>0.616949</td>\n",
       "      <td>0.652551</td>\n",
       "      <td>0.685661</td>\n",
       "      <td>0.605912</td>\n",
       "      <td>0.471603</td>\n",
       "      <td>0.745840</td>\n",
       "      <td>0.407592</td>\n",
       "      <td>0.419499</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>0.560110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7387802</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Classique/Classic</td>\n",
       "      <td>HUMBER COLLEGE - MF-J-Block J107-M-WAL 1</td>\n",
       "      <td>43.72806</td>\n",
       "      <td>-79.60669</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Main Floor</td>\n",
       "      <td>63</td>\n",
       "      <td>...</td>\n",
       "      <td>0.650903</td>\n",
       "      <td>0.652281</td>\n",
       "      <td>0.757948</td>\n",
       "      <td>0.781714</td>\n",
       "      <td>0.605385</td>\n",
       "      <td>0.754253</td>\n",
       "      <td>0.565936</td>\n",
       "      <td>0.388702</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>0.519233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7387802</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Static</td>\n",
       "      <td>HUMBER COLLEGE - MF-J-Block J107-M-WAL 1</td>\n",
       "      <td>43.72806</td>\n",
       "      <td>-79.60669</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Main Floor</td>\n",
       "      <td>54</td>\n",
       "      <td>...</td>\n",
       "      <td>0.849123</td>\n",
       "      <td>0.787547</td>\n",
       "      <td>0.777997</td>\n",
       "      <td>0.936624</td>\n",
       "      <td>0.990516</td>\n",
       "      <td>0.849786</td>\n",
       "      <td>0.717077</td>\n",
       "      <td>0.530335</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>0.714648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7387802</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Static</td>\n",
       "      <td>HUMBER COLLEGE - MF-J-Block J107-M-WAL 1</td>\n",
       "      <td>43.72806</td>\n",
       "      <td>-79.60669</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>Main Floor</td>\n",
       "      <td>183</td>\n",
       "      <td>...</td>\n",
       "      <td>0.895639</td>\n",
       "      <td>0.790288</td>\n",
       "      <td>0.836098</td>\n",
       "      <td>0.789456</td>\n",
       "      <td>0.787585</td>\n",
       "      <td>0.771634</td>\n",
       "      <td>0.580450</td>\n",
       "      <td>0.505038</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>0.736328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7395463</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>Static</td>\n",
       "      <td>RYERSON U - TED ROGERS SCHOOL OF MGT - F2-TRS-...</td>\n",
       "      <td>43.65568</td>\n",
       "      <td>-79.38287</td>\n",
       "      <td>17.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2nd Floor</td>\n",
       "      <td>48</td>\n",
       "      <td>...</td>\n",
       "      <td>1.311018</td>\n",
       "      <td>0.815688</td>\n",
       "      <td>0.647569</td>\n",
       "      <td>0.865588</td>\n",
       "      <td>1.296909</td>\n",
       "      <td>0.978914</td>\n",
       "      <td>0.993506</td>\n",
       "      <td>0.780774</td>\n",
       "      <td>0.052631</td>\n",
       "      <td>1.034701</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 89 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   board_id   market       product_name  \\\n",
       "0   7387802  Toronto             Static   \n",
       "1   7387802  Toronto  Classique/Classic   \n",
       "2   7387802  Toronto             Static   \n",
       "3   7387802  Toronto             Static   \n",
       "4   7395463  Toronto             Static   \n",
       "\n",
       "                                       sales_address       lat       lon  \\\n",
       "0           HUMBER COLLEGE - MF-J-Block J107-M-WAL 1  43.72806 -79.60669   \n",
       "1           HUMBER COLLEGE - MF-J-Block J107-M-WAL 1  43.72806 -79.60669   \n",
       "2           HUMBER COLLEGE - MF-J-Block J107-M-WAL 1  43.72806 -79.60669   \n",
       "3           HUMBER COLLEGE - MF-J-Block J107-M-WAL 1  43.72806 -79.60669   \n",
       "4  RYERSON U - TED ROGERS SCHOOL OF MGT - F2-TRS-...  43.65568 -79.38287   \n",
       "\n",
       "   height  width      facing  total_observed  ...      I_17      I_18  \\\n",
       "0    17.0   13.0  Main Floor              49  ...  0.616949  0.652551   \n",
       "1    17.0   13.0  Main Floor              63  ...  0.650903  0.652281   \n",
       "2    17.0   13.0  Main Floor              54  ...  0.849123  0.787547   \n",
       "3    17.0   13.0  Main Floor             183  ...  0.895639  0.790288   \n",
       "4    17.0   13.0   2nd Floor              48  ...  1.311018  0.815688   \n",
       "\n",
       "       I_19      I_20      I_21      I_22      I_23        AC        AD  \\\n",
       "0  0.685661  0.605912  0.471603  0.745840  0.407592  0.419499  0.041667   \n",
       "1  0.757948  0.781714  0.605385  0.754253  0.565936  0.388702  0.041667   \n",
       "2  0.777997  0.936624  0.990516  0.849786  0.717077  0.530335  0.041667   \n",
       "3  0.836098  0.789456  0.787585  0.771634  0.580450  0.505038  0.041667   \n",
       "4  0.647569  0.865588  1.296909  0.978914  0.993506  0.780774  0.052631   \n",
       "\n",
       "          I  \n",
       "0  0.560110  \n",
       "1  0.519233  \n",
       "2  0.714648  \n",
       "3  0.736328  \n",
       "4  1.034701  \n",
       "\n",
       "[5 rows x 89 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "after-spice",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "49533b056091450a9a887c62d7ddcfbe",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Dropdown(index=2, options=('Static', 'Classique/Classic', 'Transit Shelter', 'Bike Share', 'Signature Column/C…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "Product = widgets.Dropdown(\n",
    "             options = df.product_name.unique(),\n",
    "             value = 'Transit Shelter',\n",
    "             descriptions = 'Product Name')\n",
    "display(Market)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "legitimate-vintage",
   "metadata": {},
   "source": [
    "### 3. Adding Interactivity to Simple Plot (Seaborn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "familiar-catch",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "d011a2f7d6f74fddb20ce22b50a46c53",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "interactive(children=(ToggleButtons(description='Index:', options=('AC', 'AD', 'I'), value='AC'), Output()), _…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Day of Week vs. Hour of Day  - Index Based Heatmap\n",
    "def dvsh(c):\n",
    "    g = sns.heatmap(load_all_data(df[df.product_name == Product.value]).pivot_table(c,\n",
    "                                        'HoD',\n",
    "                                        'DoW'))\n",
    "    \n",
    "    g.set_title(Market.value +'\\n Index: '+ c)\n",
    "\n",
    "    return plt.show(g)\n",
    "    \n",
    "# Options for values included here\n",
    "temp = widgets.interact(dvsh,\n",
    "    c = widgets.ToggleButtons(\n",
    "    options=['AC', 'AD', 'I'],\n",
    "    description='Index:',\n",
    "    disabled=False,\n",
    "    button_style=''))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "lightweight-spain",
   "metadata": {},
   "source": [
    "### 4. Enhancing the interactivity of an interactive plot (Plotly)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "responsible-fellow",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "ad7bcb4e8e1747309f743d8a37f239e1",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "interactive(children=(ToggleButtons(description='Index:', options=('AC', 'AD', 'I'), value='AC'), Output()), _…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def sunburst(index):\n",
    "    # Cleaning of data to represent in the graph\n",
    "    # Done at this stage because the 0s and Nans are still used in mean aggregation for other visuals.\n",
    "    n = df[(df[str(index)] != 0)& (df[str(index)].notna())& (df.DoW != 'total')]\n",
    "    fig = px.sunburst(n, path=['market', 'product_name', 'DoW'], values=index,\n",
    "                  color=index,\n",
    "                  color_continuous_scale='RdBu')\n",
    "    return fig.show()\n",
    "    \n",
    "# Options for values included here\n",
    "temp = widgets.interact(sunburst,\n",
    "    index = widgets.ToggleButtons(\n",
    "    options=['AC', 'AD', 'I'],\n",
    "    description='Index:',\n",
    "    disabled=False,\n",
    "    button_style=''))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "cardiovascular-anime",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Turns off warning when using np.where to copy values\n",
    "pd.options.mode.chained_assignment = None"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "waiting-sandwich",
   "metadata": {},
   "source": [
    "### 5a. Adding Interactivity to Geospatial Visuals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "executed-nomination",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "aba8ea5b9caf48eeb699d18574e75857",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "interactive(children=(Dropdown(description='Product', index=2, options=('Static', 'Classique/Classic', 'Transi…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def m_dist( Product, Attribute, Threshold):\n",
    "    d = df[(df.product_name == Product) & (df.DoW == 'total')]\n",
    "    d['label'] = np.where(d[Attribute] >= Threshold,0, 1)\n",
    "    \n",
    "    color = ['red','blue']\n",
    "    \n",
    "    map_val = folium.Map(location=[round(d['lat'].mean(), 2),\n",
    "                                   round(d['lon'].mean(), 2)], \n",
    "                     zoom_start=10, \n",
    "                     tiles='Stamen Toner')\n",
    "\n",
    "    for row in d.iterrows():\n",
    "        row_values = row[1]\n",
    "        location = [row_values['lat'], row_values['lon']]\n",
    "        \n",
    "        html = html = '<h4> <b> Board ID: ' + str(row_values['board_id']) + '</h4></b>' + '<br><b>Audience Composition: </b>' + str(row_values['audComp']) + '<br><br><b> Index: </b>' + str(row_values['index'])\n",
    "        iframe = folium.IFrame(html=html, width=300, height=150)\n",
    "        popup = folium.Popup(iframe, max_width=2650)\n",
    "        \n",
    "        marker = folium.Marker(location=location, popup=popup, icon=folium.Icon(color=color[row_values['label']]))\n",
    "        marker.add_to(map_val)\n",
    "        \n",
    "        \n",
    "    return map_val\n",
    "        \n",
    "# Options for values included here\n",
    "temp = widgets.interact(m_dist,\n",
    "    Attribute = widgets.ToggleButtons(\n",
    "    options=['AC', 'AD', 'I'],\n",
    "    description='Index:',\n",
    "    disabled=False,\n",
    "    button_style=''),\n",
    "         Product = widgets.Dropdown(\n",
    "             options = df.product_name.unique(),\n",
    "             value = 'Transit Shelter',\n",
    "             descriptions = 'Product'),\n",
    "        Threshold = widgets.FloatSlider(\n",
    "            value=0.8,\n",
    "            min = -1,\n",
    "            max=1,\n",
    "            step=0.05,\n",
    "            disabled = False,\n",
    "            continuous_update=False,\n",
    "            orientation='horizontal',\n",
    "            readout=True,\n",
    "            readout_format='.1f'))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "automatic-simon",
   "metadata": {},
   "source": [
    "### 5b. Customization of HTMLs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "medical-valuable",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "eb927f54477d45f8ad23601853f85e38",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "interactive(children=(Dropdown(description='Product', index=2, options=('Static', 'Classique/Classic', 'Transi…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "def m_dist(Product, Attribute, Threshold):\n",
    "    d = df[(df.product_name == Product) & (df.DoW == 'total')]\n",
    "    d['label'] = np.where(d[Attribute] >= Threshold,0, 1)\n",
    "    \n",
    "    color = ['red','blue']\n",
    "    \n",
    "    map_val = folium.Map(location=[round(d['lat'].mean(), 2),\n",
    "                                   round(d['lon'].mean(), 2)], \n",
    "                     zoom_start=10, \n",
    "                     tiles='Stamen Toner')\n",
    "\n",
    "    for row in d.iterrows():\n",
    "        row_values = row[1]\n",
    "        location = [row_values['lat'], row_values['lon']]\n",
    "        \n",
    "        uid_panel = row_values['board_id']\n",
    "        AC = row_values['audComp']\n",
    "        I = row_values['I']\n",
    "        html=f\"\"\"\n",
    "        <div align=\"center\"><h1> <b>Board ID: {uid_panel}</h1>\n",
    "        <p> <b>AC Value: {round(AC,2)}\n",
    "        <br> Index Value: {round(I, 2)}</p></div>\n",
    "        \"\"\"\n",
    "        \n",
    "        iframe = folium.IFrame(html=html, width=300, height=100)\n",
    "        popup = folium.Popup(iframe, max_width=2650)\n",
    "        \n",
    "        marker = folium.Marker(location=location, popup=popup, icon=folium.Icon(color=color[row_values['label']]))\n",
    "        marker.add_to(map_val)\n",
    "        \n",
    "        \n",
    "    return map_val\n",
    "        \n",
    "# Options for values included here\n",
    "temp = widgets.interact(m_dist,\n",
    "    Attribute = widgets.ToggleButtons(\n",
    "    options=['AC', 'AD', 'I'],\n",
    "    description='Index:',\n",
    "    disabled=False,\n",
    "    button_style=''),\n",
    "         Product = widgets.Dropdown(\n",
    "             options = df.product_name.unique(),\n",
    "             value = 'Transit Shelter',\n",
    "             descriptions = 'Product'),\n",
    "        Threshold = widgets.FloatSlider(\n",
    "            value=0.8,\n",
    "            min = -1,\n",
    "            max=1,\n",
    "            step=0.05,\n",
    "            disabled = False,\n",
    "            continuous_update=False,\n",
    "            orientation='horizontal',\n",
    "            readout=True,\n",
    "            readout_format='.1f'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "developing-visit",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}