Cross-Price_ONLY.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Part 3 .- Price Elasticity and Cross-Price Elasticity of Demand "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3.2 Cross-Price Elasticity Matrix\n",
    "\n",
    "### 3.2.1 Cross - Price Elasticity Definition\n",
    "\n",
    "Cross-price elasticity help the marketer to know the naturality of main competitors related to price, which it help to analyze the sensitivity of one price against other competitors prices. As for instance, does our product impression demand increase, if our direct competitor Y increases their prices on the same or similar electronic products within a certain timeframe? \n",
    "\n",
    "- Cross-Price Elasticity Formula\n",
    "\n",
    "    **Quantity percentage change/ Competitor Price percentage change * Competitor Price Mean/ Quantity Mean**\n",
    "    \n",
    "## Content\n",
    "\n",
    "- **3.2.1 Cross - Price Elasticity Definition**\n",
    "- **3.2.2 Sample Selection**\n",
    "- **3.2.3 Sample Imputation**\n",
    "- **3.2.4 Divergent Plot Function for Price Elasticities Vizualization**\n",
    "- **3.2.5 Cross - Price Elasticity Matrix Function (Multi Linear Regression)**\n",
    "- **3.2.6 Cross - Price Elasticity 12 MacBook (Mid 2017, Silver) Case**\n",
    "- **3.2.7  Cross - Price Elasticity 12 MacBook (Mid 2017, Silver) Conclusion**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('price_clean.csv', encoding = \"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_best = df[df['merchant']=='Bestbuy.com']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.2.2 Sample Selection\n",
    "\n",
    "For the price elasticity model, we take the following sample: \n",
    "<t>\n",
    "Bestbuy main category is **laptop, computer** with **9.5% (1,071)** of total impression count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Bestbuy Category Percentage\n",
      "--------------------------------------------------\n",
      "laptop, computer                9.488792\n",
      "speaker, portable, bluetooth    6.715691\n",
      "car, speaker, subwoofer         4.899442\n",
      "receiver, amplifier, home       4.429875\n",
      "car, receiver, dash             3.641357\n",
      "Name: Category_name, dtype: float64\n",
      " Bestbuy Category values count\n",
      "--------------------------------------------------\n",
      "laptop, computer                1071\n",
      "speaker, portable, bluetooth     758\n",
      "car, speaker, subwoofer          553\n",
      "receiver, amplifier, home        500\n",
      "car, receiver, dash              411\n",
      "Name: Category_name, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "category = df_best['Category_name'].value_counts()\n",
    "print(\"Bestbuy Category Percentage\\n{}\\n{}\\n Bestbuy Category values count\\n{}\\n{}\".format(\n",
    "      50*\"-\", (category / len(df_best.index))[:5] * 100, 50*\"-\", category[:5]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_laptop = df_best[df_best['Category_name']=='laptop, computer']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###  3.2.3 Sample Imputation\n",
    "\n",
    "Following data preprocessing selected is for the 2017 year, on a weekly basis.\n",
    "- Mean price and number of impression count per week\n",
    "- NaN value manipulation, this model implements the fillna method = 'ffill' by filling the nan values with the last reference cell value. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#impressions per month\n",
    "test1 = df_laptop.groupby(['name', 'Week_Number']).agg({'disc_price': 'mean' ,'Date_imp': 'count' }).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "x_pivot = test1.pivot(index='Week_Number', columns='name' ,values='disc_price')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "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>Week_Number</th>\n",
       "      <th>12 MacBook (Mid 2017, Gold)</th>\n",
       "      <th>12 MacBook (Mid 2017, Silver)</th>\n",
       "      <th>12.3 32GB Multi-Touch 2-in-1 Chromebook Plus</th>\n",
       "      <th>13.3 MacBook Air (Mid 2017, Silver)</th>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Silver)</th>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Space Gray)</th>\n",
       "      <th>ASUS VivoBook Max X541SA 15.6Inch Laptop Intel Pentium 4GB Memory 500GB HD Matte IMR X541SA-PD0703X</th>\n",
       "      <th>Acer - 2-in-1 15.6 Refurbished Touch-Screen Laptop - Intel Core i7 - 12GB Memory - NVIDIA GeForce 940MX - 1TB Hard Drive - Steel gray\"</th>\n",
       "      <th>Acer 15.6 Chromebook CB5-571-C4G4</th>\n",
       "      <th>...</th>\n",
       "      <th>HP - ProBook 14 Laptop - Intel Core i5 - 4GB Memory - 500GB Hard Drive - Black\"</th>\n",
       "      <th>HP 15-AY103DX 15.6 Touchscreen Touch Screen HD Laptop Notebook PC Computer 7th Gen i5-7200U Kaby Lake 8GB Memory 1TB HDD Hard Drive Windows 10\"</th>\n",
       "      <th>Lenovo - 100S-14IBR 14 Laptop - Intel Celeron - 2GB Memory - 32GB eMMC Flash Memory - Navy blue\"</th>\n",
       "      <th>Lenovo - Yoga 710 2-in-1 11.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - 128GB Solid State Drive - Silver Tablet PC Notebook 80V6000PUS\"</th>\n",
       "      <th>Lenovo 80TX0007US Y 710-11ISK 11.6-Inch FHD Touch Laptop (Pentium 4405Y, 4 GB Ram, 128 GB SSD, Windows 10), SilverNotebook PC Computer Tablet Touchscreen Screen 2-in-1</th>\n",
       "      <th>Lenovo Flex 4 1470 80SA0000US 2-in-1 - 14 HD Touch - Pentium 4405U 2.1Ghz - 4GB - 500GB\"</th>\n",
       "      <th>MSI - WS Series 15.6 Laptop - Intel Core i7 - 16GB Memory - 256GB Solid State Drive + 2TB Hard Drive - Aluminum Black\"</th>\n",
       "      <th>New Asus Q524u 15.6fhd 2in1 Touch I77500u 3.5ghz 16gb Ddr4 2tb Hd 940mx2gb W10\"</th>\n",
       "      <th>Razer - Blade Pro 17.3 4K Ultra HD Touch-Screen Laptop - Intel Core i7 - 32GB Memory - NVIDIA GeForce GTX 1080 - 1TB SSD - Black\"</th>\n",
       "      <th>Samsung - Notebook 5 15.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - NVIDIA GeForce 920MX - 1TB Hard Drive - Solid black\"</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>426.495</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2799.99</td>\n",
       "      <td>2599.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>899.99</td>\n",
       "      <td>236.495</td>\n",
       "      <td>...</td>\n",
       "      <td>799.99</td>\n",
       "      <td>499.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>664.99</td>\n",
       "      <td>379.99</td>\n",
       "      <td>316.99</td>\n",
       "      <td>NaN</td>\n",
       "      <td>807.49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>617.49</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week_Number  12 MacBook (Mid 2017, Gold)  12 MacBook (Mid 2017, Silver)  \\\n",
       "0            4                          NaN                            NaN   \n",
       "1            9                          NaN                            NaN   \n",
       "\n",
       "   12.3 32GB Multi-Touch 2-in-1 Chromebook Plus  \\\n",
       "0                                           NaN   \n",
       "1                                       426.495   \n",
       "\n",
       "   13.3 MacBook Air (Mid 2017, Silver)  \\\n",
       "0                                  NaN   \n",
       "1                                  NaN   \n",
       "\n",
       "   15.4 MacBook Pro with Touch Bar (Late 2016, Silver)  \\\n",
       "0                                                NaN     \n",
       "1                                            2799.99     \n",
       "\n",
       "   15.4 MacBook Pro with Touch Bar (Late 2016, Space Gray)  \\\n",
       "0                                                NaN         \n",
       "1                                            2599.99         \n",
       "\n",
       "   ASUS VivoBook Max X541SA 15.6Inch Laptop Intel Pentium 4GB Memory 500GB HD Matte IMR X541SA-PD0703X  \\\n",
       "0                                                NaN                                                     \n",
       "1                                                NaN                                                     \n",
       "\n",
       "   Acer - 2-in-1 15.6 Refurbished Touch-Screen Laptop - Intel Core i7 - 12GB Memory - NVIDIA GeForce 940MX - 1TB Hard Drive - Steel gray\"  \\\n",
       "0                                                NaN                                                                                        \n",
       "1                                             899.99                                                                                        \n",
       "\n",
       "   Acer 15.6 Chromebook CB5-571-C4G4  \\\n",
       "0                                NaN   \n",
       "1                            236.495   \n",
       "\n",
       "                                                                 ...                                                                  \\\n",
       "0                                                                ...                                                                   \n",
       "1                                                                ...                                                                   \n",
       "\n",
       "   HP - ProBook 14 Laptop - Intel Core i5 - 4GB Memory - 500GB Hard Drive - Black\"  \\\n",
       "0                                                NaN                                 \n",
       "1                                             799.99                                 \n",
       "\n",
       "   HP 15-AY103DX 15.6 Touchscreen Touch Screen HD Laptop Notebook PC Computer 7th Gen i5-7200U Kaby Lake 8GB Memory 1TB HDD Hard Drive Windows 10\"  \\\n",
       "0                                                NaN                                                                                                 \n",
       "1                                             499.99                                                                                                 \n",
       "\n",
       "   Lenovo - 100S-14IBR 14 Laptop - Intel Celeron - 2GB Memory - 32GB eMMC Flash Memory - Navy blue\"  \\\n",
       "0                                                NaN                                                  \n",
       "1                                                NaN                                                  \n",
       "\n",
       "   Lenovo - Yoga 710 2-in-1 11.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - 128GB Solid State Drive - Silver Tablet PC Notebook 80V6000PUS\"  \\\n",
       "0                                                NaN                                                                                                  \n",
       "1                                             664.99                                                                                                  \n",
       "\n",
       "   Lenovo 80TX0007US Y 710-11ISK 11.6-Inch FHD Touch Laptop (Pentium 4405Y, 4 GB Ram, 128 GB SSD, Windows 10), SilverNotebook PC Computer Tablet Touchscreen Screen 2-in-1  \\\n",
       "0                                                NaN                                                                                                                         \n",
       "1                                             379.99                                                                                                                         \n",
       "\n",
       "   Lenovo Flex 4 1470 80SA0000US 2-in-1 - 14 HD Touch - Pentium 4405U 2.1Ghz - 4GB - 500GB\"  \\\n",
       "0                                                NaN                                          \n",
       "1                                             316.99                                          \n",
       "\n",
       "   MSI - WS Series 15.6 Laptop - Intel Core i7 - 16GB Memory - 256GB Solid State Drive + 2TB Hard Drive - Aluminum Black\"  \\\n",
       "0                                                NaN                                                                        \n",
       "1                                                NaN                                                                        \n",
       "\n",
       "   New Asus Q524u 15.6fhd 2in1 Touch I77500u 3.5ghz 16gb Ddr4 2tb Hd 940mx2gb W10\"  \\\n",
       "0                                                NaN                                 \n",
       "1                                             807.49                                 \n",
       "\n",
       "   Razer - Blade Pro 17.3 4K Ultra HD Touch-Screen Laptop - Intel Core i7 - 32GB Memory - NVIDIA GeForce GTX 1080 - 1TB SSD - Black\"  \\\n",
       "0                                                NaN                                                                                   \n",
       "1                                                NaN                                                                                   \n",
       "\n",
       "   Samsung - Notebook 5 15.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - NVIDIA GeForce 920MX - 1TB Hard Drive - Solid black\"  \n",
       "0                                                NaN                                                                                  \n",
       "1                                             617.49                                                                                  \n",
       "\n",
       "[2 rows x 40 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_values = pd.DataFrame(x_pivot.to_records())\n",
    "x_values.fillna(method='ffill', inplace=True)\n",
    "x_values[:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "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>Week_Number</th>\n",
       "      <th>12 MacBook (Mid 2017, Gold)</th>\n",
       "      <th>12 MacBook (Mid 2017, Silver)</th>\n",
       "      <th>12.3 32GB Multi-Touch 2-in-1 Chromebook Plus</th>\n",
       "      <th>13.3 MacBook Air (Mid 2017, Silver)</th>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Silver)</th>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Space Gray)</th>\n",
       "      <th>ASUS VivoBook Max X541SA 15.6Inch Laptop Intel Pentium 4GB Memory 500GB HD Matte IMR X541SA-PD0703X</th>\n",
       "      <th>Acer - 2-in-1 15.6 Refurbished Touch-Screen Laptop - Intel Core i7 - 12GB Memory - NVIDIA GeForce 940MX - 1TB Hard Drive - Steel gray\"</th>\n",
       "      <th>Acer 15.6 Chromebook CB5-571-C4G4</th>\n",
       "      <th>...</th>\n",
       "      <th>HP - ProBook 14 Laptop - Intel Core i5 - 4GB Memory - 500GB Hard Drive - Black\"</th>\n",
       "      <th>HP 15-AY103DX 15.6 Touchscreen Touch Screen HD Laptop Notebook PC Computer 7th Gen i5-7200U Kaby Lake 8GB Memory 1TB HDD Hard Drive Windows 10\"</th>\n",
       "      <th>Lenovo - 100S-14IBR 14 Laptop - Intel Celeron - 2GB Memory - 32GB eMMC Flash Memory - Navy blue\"</th>\n",
       "      <th>Lenovo - Yoga 710 2-in-1 11.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - 128GB Solid State Drive - Silver Tablet PC Notebook 80V6000PUS\"</th>\n",
       "      <th>Lenovo 80TX0007US Y 710-11ISK 11.6-Inch FHD Touch Laptop (Pentium 4405Y, 4 GB Ram, 128 GB SSD, Windows 10), SilverNotebook PC Computer Tablet Touchscreen Screen 2-in-1</th>\n",
       "      <th>Lenovo Flex 4 1470 80SA0000US 2-in-1 - 14 HD Touch - Pentium 4405U 2.1Ghz - 4GB - 500GB\"</th>\n",
       "      <th>MSI - WS Series 15.6 Laptop - Intel Core i7 - 16GB Memory - 256GB Solid State Drive + 2TB Hard Drive - Aluminum Black\"</th>\n",
       "      <th>New Asus Q524u 15.6fhd 2in1 Touch I77500u 3.5ghz 16gb Ddr4 2tb Hd 940mx2gb W10\"</th>\n",
       "      <th>Razer - Blade Pro 17.3 4K Ultra HD Touch-Screen Laptop - Intel Core i7 - 32GB Memory - NVIDIA GeForce GTX 1080 - 1TB SSD - Black\"</th>\n",
       "      <th>Samsung - Notebook 5 15.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - NVIDIA GeForce 920MX - 1TB Hard Drive - Solid black\"</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Week_Number  12 MacBook (Mid 2017, Gold)  12 MacBook (Mid 2017, Silver)  \\\n",
       "0            4                          NaN                            NaN   \n",
       "1            9                          NaN                            NaN   \n",
       "\n",
       "   12.3 32GB Multi-Touch 2-in-1 Chromebook Plus  \\\n",
       "0                                           NaN   \n",
       "1                                           4.0   \n",
       "\n",
       "   13.3 MacBook Air (Mid 2017, Silver)  \\\n",
       "0                                  NaN   \n",
       "1                                  NaN   \n",
       "\n",
       "   15.4 MacBook Pro with Touch Bar (Late 2016, Silver)  \\\n",
       "0                                                NaN     \n",
       "1                                                3.0     \n",
       "\n",
       "   15.4 MacBook Pro with Touch Bar (Late 2016, Space Gray)  \\\n",
       "0                                                NaN         \n",
       "1                                                6.0         \n",
       "\n",
       "   ASUS VivoBook Max X541SA 15.6Inch Laptop Intel Pentium 4GB Memory 500GB HD Matte IMR X541SA-PD0703X  \\\n",
       "0                                                NaN                                                     \n",
       "1                                                NaN                                                     \n",
       "\n",
       "   Acer - 2-in-1 15.6 Refurbished Touch-Screen Laptop - Intel Core i7 - 12GB Memory - NVIDIA GeForce 940MX - 1TB Hard Drive - Steel gray\"  \\\n",
       "0                                                NaN                                                                                        \n",
       "1                                                2.0                                                                                        \n",
       "\n",
       "   Acer 15.6 Chromebook CB5-571-C4G4  \\\n",
       "0                                NaN   \n",
       "1                                4.0   \n",
       "\n",
       "                                                                 ...                                                                  \\\n",
       "0                                                                ...                                                                   \n",
       "1                                                                ...                                                                   \n",
       "\n",
       "   HP - ProBook 14 Laptop - Intel Core i5 - 4GB Memory - 500GB Hard Drive - Black\"  \\\n",
       "0                                                NaN                                 \n",
       "1                                                1.0                                 \n",
       "\n",
       "   HP 15-AY103DX 15.6 Touchscreen Touch Screen HD Laptop Notebook PC Computer 7th Gen i5-7200U Kaby Lake 8GB Memory 1TB HDD Hard Drive Windows 10\"  \\\n",
       "0                                                NaN                                                                                                 \n",
       "1                                                2.0                                                                                                 \n",
       "\n",
       "   Lenovo - 100S-14IBR 14 Laptop - Intel Celeron - 2GB Memory - 32GB eMMC Flash Memory - Navy blue\"  \\\n",
       "0                                                NaN                                                  \n",
       "1                                                NaN                                                  \n",
       "\n",
       "   Lenovo - Yoga 710 2-in-1 11.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - 128GB Solid State Drive - Silver Tablet PC Notebook 80V6000PUS\"  \\\n",
       "0                                                NaN                                                                                                  \n",
       "1                                                4.0                                                                                                  \n",
       "\n",
       "   Lenovo 80TX0007US Y 710-11ISK 11.6-Inch FHD Touch Laptop (Pentium 4405Y, 4 GB Ram, 128 GB SSD, Windows 10), SilverNotebook PC Computer Tablet Touchscreen Screen 2-in-1  \\\n",
       "0                                                NaN                                                                                                                         \n",
       "1                                                4.0                                                                                                                         \n",
       "\n",
       "   Lenovo Flex 4 1470 80SA0000US 2-in-1 - 14 HD Touch - Pentium 4405U 2.1Ghz - 4GB - 500GB\"  \\\n",
       "0                                                NaN                                          \n",
       "1                                                4.0                                          \n",
       "\n",
       "   MSI - WS Series 15.6 Laptop - Intel Core i7 - 16GB Memory - 256GB Solid State Drive + 2TB Hard Drive - Aluminum Black\"  \\\n",
       "0                                                NaN                                                                        \n",
       "1                                                NaN                                                                        \n",
       "\n",
       "   New Asus Q524u 15.6fhd 2in1 Touch I77500u 3.5ghz 16gb Ddr4 2tb Hd 940mx2gb W10\"  \\\n",
       "0                                                NaN                                 \n",
       "1                                                4.0                                 \n",
       "\n",
       "   Razer - Blade Pro 17.3 4K Ultra HD Touch-Screen Laptop - Intel Core i7 - 32GB Memory - NVIDIA GeForce GTX 1080 - 1TB SSD - Black\"  \\\n",
       "0                                                NaN                                                                                   \n",
       "1                                                NaN                                                                                   \n",
       "\n",
       "   Samsung - Notebook 5 15.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - NVIDIA GeForce 920MX - 1TB Hard Drive - Solid black\"  \n",
       "0                                                NaN                                                                                  \n",
       "1                                                2.0                                                                                  \n",
       "\n",
       "[2 rows x 40 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_pivot = test1.pivot(index='Week_Number', columns='name', values='Date_imp')\n",
    "y_values = pd.DataFrame(y_pivot.to_records())\n",
    "y_values.fillna(method='ffill', inplace=True)\n",
    "y_values[:2]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.2.4 Divergent Plot Function for Price Elasticities Vizualization"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def divergent_plot(df, values_column, ylabel, xlabel):\n",
    "\n",
    "    #Divergent plot\n",
    "    df['ranking'] = df[values_column].rank( ascending = True).astype(int)\n",
    "    df.sort_values(values_column, ascending =False, inplace = True)\n",
    "    plt.figure(figsize = (12,5), dpi = 80)\n",
    "    plt.hlines(y = df['ranking'] , xmin = 0, xmax = df[values_column], alpha = 0.5, linewidth = 3)\n",
    "    \n",
    "    #Add elasticity labels\n",
    "    for x, y, tex in zip(df[values_column], df['ranking'] , df[values_column]):\n",
    "        plt.text(x, y, round(tex, 2), horizontalalignment='right' if x < 0 else 'left', \n",
    "                 verticalalignment='center', fontdict={'color':'red' if x < 0 else 'green', 'size':10})\n",
    "        \n",
    "    \n",
    "    # Axis and title\n",
    "    plt.gca().set(ylabel= ylabel, xlabel= xlabel)\n",
    "    plt.yticks(df['ranking'])\n",
    "    plt.title(values_column , fontdict={'size':13})\n",
    "    plt.grid(linestyle='--', alpha=0.5)\n",
    "    plt.show()\n",
    "            \n",
    "    \n",
    "    #Adjust Ranking column and print dataframe\n",
    "    cols = list(df.columns)\n",
    "    cols = [cols[-1]] + cols[:-1]\n",
    "    df = df[cols]\n",
    "    \n",
    "    df = df.iloc[:,:3]\n",
    "    df.set_index('ranking', inplace=True)\n",
    "    display(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.2.5 Cross - Price Elasticity Matrix Function (Multi Linear Regression)\n",
    "\n",
    "In following function:\n",
    "- Multiple dataframes with x values features of the entire sample of laptop category within their prices of 2017 and a dependent variable that reflect the ad impression demand of each respective laptop for the analysis were iterrated for coefficient matrix\n",
    "- Coefficient (slope) values that reflect the change in competitors price divided by the change in respective product ad impression quantity and obtained a p-value of less than .05 were labelled as no effect due that the null hypothesis cannot be rejected "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Cross price elasticity function\n",
    "\n",
    "def crossprice_(df_x, df_y, column_name):\n",
    "    import statsmodels.api as sm\n",
    "    \n",
    "    #grab all X_values\n",
    "    new_df = df_x.copy()\n",
    "    #grab y_value with same column name\n",
    "    new_df['y_value-' + column_name] = df_y[column_name]\n",
    "    \n",
    "    multi_xvalues = new_df.loc[:, new_df.columns[1:-1]]\n",
    "    multi_yvalue = new_df.loc[:, new_df.columns[-1]]\n",
    "    \n",
    "    #get price mean values per product\n",
    "    mean_xvalues = np.mean(multi_xvalues)\n",
    "    #get mean quantity for y value\n",
    "    mean_yvalue = np.mean(multi_yvalue)\n",
    "    \n",
    "    # Multilinear regression\n",
    "    X = sm.add_constant(multi_xvalues)\n",
    "    model = sm.OLS(multi_yvalue, X, missing='drop')\n",
    "    result = model.fit()\n",
    "    \n",
    "    #get results\n",
    "    results_summary = result.summary()\n",
    "    #get pvalues of each coefficient\n",
    "    pvalue = result.pvalues\n",
    "    \n",
    "    #transform summary result to a table\n",
    "    results_as_html = results_summary.tables[1].as_html()\n",
    "    new_dataframe = pd.read_html(results_as_html, header=0, index_col=0)[0]\n",
    "    \n",
    "    #add p value to the table\n",
    "    new_dataframe['p_value']= pvalue\n",
    "    \n",
    "    #set product name as index\n",
    "    new_dataframe.index.name = 'name'\n",
    "    new_dataframe.reset_index()\n",
    "    \n",
    "    #get each product name price mean\n",
    "    new_dataframe['mean'] = mean_xvalues\n",
    "    # execute cross-price formula\n",
    "    new_dataframe['price_elasticity'] = (new_dataframe.coef) * (new_dataframe['mean'] / mean_yvalue)\n",
    "\n",
    "    new_dataframe = new_dataframe.reset_index()\n",
    "    pvalue_significant = new_dataframe['p_value']\n",
    "    \n",
    "    #Chech null hypothesis for coefficient or slope value per product\n",
    "    new_dataframe[column_name+'_CPE'] = np.where((pvalue_significant > .05), 'No effect', new_dataframe['price_elasticity'])\n",
    "    new_dataframe = new_dataframe.dropna()\n",
    "    \n",
    "    return new_dataframe[['name', column_name + '_CPE']]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#append cross-price elasticity into a matrix for analysis\n",
    "result_df = pd.DataFrame()\n",
    "for column in x_values.columns[1:]:\n",
    "    result_df[['name', column + '_CPE']] = crossprice_(x_values, y_values, column)\n",
    "    result_df = result_df.dropna()\n",
    "    result_df[column+'_CPE'] = pd.to_numeric(result_df[column+'_CPE'], errors='coerce').fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_df = result_df.set_index('name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>12 MacBook (Mid 2017, Gold)_CPE</th>\n",
       "      <th>12 MacBook (Mid 2017, Silver)_CPE</th>\n",
       "      <th>12.3 32GB Multi-Touch 2-in-1 Chromebook Plus_CPE</th>\n",
       "      <th>13.3 MacBook Air (Mid 2017, Silver)_CPE</th>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Silver)_CPE</th>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Space Gray)_CPE</th>\n",
       "      <th>ASUS VivoBook Max X541SA 15.6Inch Laptop Intel Pentium 4GB Memory 500GB HD Matte IMR X541SA-PD0703X_CPE</th>\n",
       "      <th>Acer - 2-in-1 15.6 Refurbished Touch-Screen Laptop - Intel Core i7 - 12GB Memory - NVIDIA GeForce 940MX - 1TB Hard Drive - Steel gray\"_CPE</th>\n",
       "      <th>Acer 15.6 Chromebook CB5-571-C4G4_CPE</th>\n",
       "      <th>Alienware - R3 17.3 Laptop - Intel Core i7 - 16GB Memory - 1TB Hard Drive + 256GB Solid State Drive - Epic Silver\"_CPE</th>\n",
       "      <th>...</th>\n",
       "      <th>HP - ProBook 14 Laptop - Intel Core i5 - 4GB Memory - 500GB Hard Drive - Black\"_CPE</th>\n",
       "      <th>HP 15-AY103DX 15.6 Touchscreen Touch Screen HD Laptop Notebook PC Computer 7th Gen i5-7200U Kaby Lake 8GB Memory 1TB HDD Hard Drive Windows 10\"_CPE</th>\n",
       "      <th>Lenovo - 100S-14IBR 14 Laptop - Intel Celeron - 2GB Memory - 32GB eMMC Flash Memory - Navy blue\"_CPE</th>\n",
       "      <th>Lenovo - Yoga 710 2-in-1 11.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - 128GB Solid State Drive - Silver Tablet PC Notebook 80V6000PUS\"_CPE</th>\n",
       "      <th>Lenovo 80TX0007US Y 710-11ISK 11.6-Inch FHD Touch Laptop (Pentium 4405Y, 4 GB Ram, 128 GB SSD, Windows 10), SilverNotebook PC Computer Tablet Touchscreen Screen 2-in-1_CPE</th>\n",
       "      <th>Lenovo Flex 4 1470 80SA0000US 2-in-1 - 14 HD Touch - Pentium 4405U 2.1Ghz - 4GB - 500GB\"_CPE</th>\n",
       "      <th>MSI - WS Series 15.6 Laptop - Intel Core i7 - 16GB Memory - 256GB Solid State Drive + 2TB Hard Drive - Aluminum Black\"_CPE</th>\n",
       "      <th>New Asus Q524u 15.6fhd 2in1 Touch I77500u 3.5ghz 16gb Ddr4 2tb Hd 940mx2gb W10\"_CPE</th>\n",
       "      <th>Razer - Blade Pro 17.3 4K Ultra HD Touch-Screen Laptop - Intel Core i7 - 32GB Memory - NVIDIA GeForce GTX 1080 - 1TB SSD - Black\"_CPE</th>\n",
       "      <th>Samsung - Notebook 5 15.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - NVIDIA GeForce 920MX - 1TB Hard Drive - Solid black\"_CPE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</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",
       "      <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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12 MacBook (Mid 2017, Gold)</th>\n",
       "      <td>-4.266917</td>\n",
       "      <td>-1.904690</td>\n",
       "      <td>-0.000684</td>\n",
       "      <td>-0.000697</td>\n",
       "      <td>0.041909</td>\n",
       "      <td>0.307334</td>\n",
       "      <td>-0.000697</td>\n",
       "      <td>-0.000811</td>\n",
       "      <td>-0.000545</td>\n",
       "      <td>-1.994301</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.994301</td>\n",
       "      <td>-0.000742</td>\n",
       "      <td>-0.000712</td>\n",
       "      <td>-0.000697</td>\n",
       "      <td>-0.000671</td>\n",
       "      <td>-0.000581</td>\n",
       "      <td>-1.957483</td>\n",
       "      <td>-0.000671</td>\n",
       "      <td>-3.912072</td>\n",
       "      <td>-2.065526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 MacBook (Mid 2017, Silver)</th>\n",
       "      <td>-10.606051</td>\n",
       "      <td>0.500366</td>\n",
       "      <td>-0.000385</td>\n",
       "      <td>-0.000392</td>\n",
       "      <td>0.034864</td>\n",
       "      <td>0.511337</td>\n",
       "      <td>-0.000392</td>\n",
       "      <td>-0.000456</td>\n",
       "      <td>-0.000307</td>\n",
       "      <td>1.216628</td>\n",
       "      <td>...</td>\n",
       "      <td>1.327231</td>\n",
       "      <td>-0.000417</td>\n",
       "      <td>-0.000401</td>\n",
       "      <td>-0.000392</td>\n",
       "      <td>-0.000377</td>\n",
       "      <td>-0.000327</td>\n",
       "      <td>1.302728</td>\n",
       "      <td>-0.000377</td>\n",
       "      <td>-0.751019</td>\n",
       "      <td>1.317356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12.3 32GB Multi-Touch 2-in-1 Chromebook Plus</th>\n",
       "      <td>-0.162390</td>\n",
       "      <td>0.158330</td>\n",
       "      <td>0.002599</td>\n",
       "      <td>0.002651</td>\n",
       "      <td>-0.022064</td>\n",
       "      <td>-0.139738</td>\n",
       "      <td>0.002651</td>\n",
       "      <td>0.003083</td>\n",
       "      <td>0.002072</td>\n",
       "      <td>0.104993</td>\n",
       "      <td>...</td>\n",
       "      <td>0.034998</td>\n",
       "      <td>0.002820</td>\n",
       "      <td>0.002707</td>\n",
       "      <td>0.002651</td>\n",
       "      <td>0.002549</td>\n",
       "      <td>0.002209</td>\n",
       "      <td>0.034352</td>\n",
       "      <td>0.002549</td>\n",
       "      <td>0.059411</td>\n",
       "      <td>0.054372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13.3 MacBook Air (Mid 2017, Silver)</th>\n",
       "      <td>-0.409262</td>\n",
       "      <td>0.675283</td>\n",
       "      <td>0.008963</td>\n",
       "      <td>0.009142</td>\n",
       "      <td>-0.025664</td>\n",
       "      <td>0.239535</td>\n",
       "      <td>0.009142</td>\n",
       "      <td>0.010631</td>\n",
       "      <td>0.007144</td>\n",
       "      <td>0.488509</td>\n",
       "      <td>...</td>\n",
       "      <td>0.407091</td>\n",
       "      <td>0.009726</td>\n",
       "      <td>0.009337</td>\n",
       "      <td>0.009142</td>\n",
       "      <td>0.008791</td>\n",
       "      <td>0.007619</td>\n",
       "      <td>0.399576</td>\n",
       "      <td>0.008791</td>\n",
       "      <td>0.460708</td>\n",
       "      <td>0.421630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15.4 MacBook Pro with Touch Bar (Late 2016, Silver)</th>\n",
       "      <td>1.074186</td>\n",
       "      <td>-0.483384</td>\n",
       "      <td>0.121514</td>\n",
       "      <td>0.123944</td>\n",
       "      <td>-0.067361</td>\n",
       "      <td>-0.718519</td>\n",
       "      <td>0.123944</td>\n",
       "      <td>0.144122</td>\n",
       "      <td>0.103590</td>\n",
       "      <td>0.051971</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.213697</td>\n",
       "      <td>0.131856</td>\n",
       "      <td>0.126582</td>\n",
       "      <td>0.123944</td>\n",
       "      <td>0.119177</td>\n",
       "      <td>0.103287</td>\n",
       "      <td>-0.209752</td>\n",
       "      <td>0.119177</td>\n",
       "      <td>0.483686</td>\n",
       "      <td>-0.331994</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    12 MacBook (Mid 2017, Gold)_CPE  \\\n",
       "name                                                                                  \n",
       "12 MacBook (Mid 2017, Gold)                                               -4.266917   \n",
       "12 MacBook (Mid 2017, Silver)                                            -10.606051   \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                              -0.162390   \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                       -0.409262   \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                         1.074186   \n",
       "\n",
       "                                                    12 MacBook (Mid 2017, Silver)_CPE  \\\n",
       "name                                                                                    \n",
       "12 MacBook (Mid 2017, Gold)                                                 -1.904690   \n",
       "12 MacBook (Mid 2017, Silver)                                                0.500366   \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                 0.158330   \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                          0.675283   \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                          -0.483384   \n",
       "\n",
       "                                                    12.3 32GB Multi-Touch 2-in-1 Chromebook Plus_CPE  \\\n",
       "name                                                                                                   \n",
       "12 MacBook (Mid 2017, Gold)                                                                -0.000684   \n",
       "12 MacBook (Mid 2017, Silver)                                                              -0.000385   \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                0.002599   \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                         0.008963   \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                          0.121514   \n",
       "\n",
       "                                                    13.3 MacBook Air (Mid 2017, Silver)_CPE  \\\n",
       "name                                                                                          \n",
       "12 MacBook (Mid 2017, Gold)                                                       -0.000697   \n",
       "12 MacBook (Mid 2017, Silver)                                                     -0.000392   \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                       0.002651   \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                0.009142   \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                 0.123944   \n",
       "\n",
       "                                                    15.4 MacBook Pro with Touch Bar (Late 2016, Silver)_CPE  \\\n",
       "name                                                                                                          \n",
       "12 MacBook (Mid 2017, Gold)                                                                  0.041909         \n",
       "12 MacBook (Mid 2017, Silver)                                                                0.034864         \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                -0.022064         \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                         -0.025664         \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                          -0.067361         \n",
       "\n",
       "                                                    15.4 MacBook Pro with Touch Bar (Late 2016, Space Gray)_CPE  \\\n",
       "name                                                                                                              \n",
       "12 MacBook (Mid 2017, Gold)                                                                  0.307334             \n",
       "12 MacBook (Mid 2017, Silver)                                                                0.511337             \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                -0.139738             \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.239535             \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                          -0.718519             \n",
       "\n",
       "                                                    ASUS VivoBook Max X541SA 15.6Inch Laptop Intel Pentium 4GB Memory 500GB HD Matte IMR X541SA-PD0703X_CPE  \\\n",
       "name                                                                                                                                                          \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000697                                                         \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000392                                                         \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002651                                                         \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.009142                                                         \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.123944                                                         \n",
       "\n",
       "                                                    Acer - 2-in-1 15.6 Refurbished Touch-Screen Laptop - Intel Core i7 - 12GB Memory - NVIDIA GeForce 940MX - 1TB Hard Drive - Steel gray\"_CPE  \\\n",
       "name                                                                                                                                                                                             \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000811                                                                                            \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000456                                                                                            \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.003083                                                                                            \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.010631                                                                                            \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.144122                                                                                            \n",
       "\n",
       "                                                    Acer 15.6 Chromebook CB5-571-C4G4_CPE  \\\n",
       "name                                                                                        \n",
       "12 MacBook (Mid 2017, Gold)                                                     -0.000545   \n",
       "12 MacBook (Mid 2017, Silver)                                                   -0.000307   \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                     0.002072   \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                              0.007144   \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                               0.103590   \n",
       "\n",
       "                                                    Alienware - R3 17.3 Laptop - Intel Core i7 - 16GB Memory - 1TB Hard Drive + 256GB Solid State Drive - Epic Silver\"_CPE  \\\n",
       "name                                                                                                                                                                         \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -1.994301                                                                        \n",
       "12 MacBook (Mid 2017, Silver)                                                                1.216628                                                                        \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.104993                                                                        \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.488509                                                                        \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.051971                                                                        \n",
       "\n",
       "                                                                                                                    ...                                                                    \\\n",
       "name                                                                                                                ...                                                                     \n",
       "12 MacBook (Mid 2017, Gold)                                                                                         ...                                                                     \n",
       "12 MacBook (Mid 2017, Silver)                                                                                       ...                                                                     \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                                        ...                                                                     \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                                                 ...                                                                     \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                                                  ...                                                                     \n",
       "\n",
       "                                                    HP - ProBook 14 Laptop - Intel Core i5 - 4GB Memory - 500GB Hard Drive - Black\"_CPE  \\\n",
       "name                                                                                                                                      \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -1.994301                                     \n",
       "12 MacBook (Mid 2017, Silver)                                                                1.327231                                     \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.034998                                     \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.407091                                     \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                          -0.213697                                     \n",
       "\n",
       "                                                    HP 15-AY103DX 15.6 Touchscreen Touch Screen HD Laptop Notebook PC Computer 7th Gen i5-7200U Kaby Lake 8GB Memory 1TB HDD Hard Drive Windows 10\"_CPE  \\\n",
       "name                                                                                                                                                                                                      \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000742                                                                                                     \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000417                                                                                                     \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002820                                                                                                     \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.009726                                                                                                     \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.131856                                                                                                     \n",
       "\n",
       "                                                    Lenovo - 100S-14IBR 14 Laptop - Intel Celeron - 2GB Memory - 32GB eMMC Flash Memory - Navy blue\"_CPE  \\\n",
       "name                                                                                                                                                       \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000712                                                      \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000401                                                      \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002707                                                      \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.009337                                                      \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.126582                                                      \n",
       "\n",
       "                                                    Lenovo - Yoga 710 2-in-1 11.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - 128GB Solid State Drive - Silver Tablet PC Notebook 80V6000PUS\"_CPE  \\\n",
       "name                                                                                                                                                                                                       \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000697                                                                                                      \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000392                                                                                                      \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002651                                                                                                      \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.009142                                                                                                      \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.123944                                                                                                      \n",
       "\n",
       "                                                    Lenovo 80TX0007US Y 710-11ISK 11.6-Inch FHD Touch Laptop (Pentium 4405Y, 4 GB Ram, 128 GB SSD, Windows 10), SilverNotebook PC Computer Tablet Touchscreen Screen 2-in-1_CPE  \\\n",
       "name                                                                                                                                                                                                                              \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000671                                                                                                                             \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000377                                                                                                                             \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002549                                                                                                                             \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.008791                                                                                                                             \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.119177                                                                                                                             \n",
       "\n",
       "                                                    Lenovo Flex 4 1470 80SA0000US 2-in-1 - 14 HD Touch - Pentium 4405U 2.1Ghz - 4GB - 500GB\"_CPE  \\\n",
       "name                                                                                                                                               \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000581                                              \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000327                                              \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002209                                              \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.007619                                              \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.103287                                              \n",
       "\n",
       "                                                    MSI - WS Series 15.6 Laptop - Intel Core i7 - 16GB Memory - 256GB Solid State Drive + 2TB Hard Drive - Aluminum Black\"_CPE  \\\n",
       "name                                                                                                                                                                             \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -1.957483                                                                            \n",
       "12 MacBook (Mid 2017, Silver)                                                                1.302728                                                                            \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.034352                                                                            \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.399576                                                                            \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                          -0.209752                                                                            \n",
       "\n",
       "                                                    New Asus Q524u 15.6fhd 2in1 Touch I77500u 3.5ghz 16gb Ddr4 2tb Hd 940mx2gb W10\"_CPE  \\\n",
       "name                                                                                                                                      \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -0.000671                                     \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.000377                                     \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.002549                                     \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.008791                                     \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.119177                                     \n",
       "\n",
       "                                                    Razer - Blade Pro 17.3 4K Ultra HD Touch-Screen Laptop - Intel Core i7 - 32GB Memory - NVIDIA GeForce GTX 1080 - 1TB SSD - Black\"_CPE  \\\n",
       "name                                                                                                                                                                                        \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -3.912072                                                                                       \n",
       "12 MacBook (Mid 2017, Silver)                                                               -0.751019                                                                                       \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.059411                                                                                       \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.460708                                                                                       \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                           0.483686                                                                                       \n",
       "\n",
       "                                                    Samsung - Notebook 5 15.6 Touch-Screen Laptop - Intel Core i5 - 8GB Memory - NVIDIA GeForce 920MX - 1TB Hard Drive - Solid black\"_CPE  \n",
       "name                                                                                                                                                                                       \n",
       "12 MacBook (Mid 2017, Gold)                                                                 -2.065526                                                                                      \n",
       "12 MacBook (Mid 2017, Silver)                                                                1.317356                                                                                      \n",
       "12.3 32GB Multi-Touch 2-in-1 Chromebook Plus                                                 0.054372                                                                                      \n",
       "13.3 MacBook Air (Mid 2017, Silver)                                                          0.421630                                                                                      \n",
       "15.4 MacBook Pro with Touch Bar (Late 2016, Sil...                                          -0.331994                                                                                      \n",
       "\n",
       "[5 rows x 39 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "### 3.2.6 Cross - Price Elasticity 12 MacBook (Mid 2017, Silver) Case\n",
    "\n",
    "As an example, we analyze cross-price elasticity for 12 MacBook (Mid 2017, Silver) Laptop, which it would provide following conclusions:\n",
    "\n",
    "    - if other laptops in the category changes their prices, what it would happen to 12 MacBook ad impression demand? How ad impression is going to be affected when other laptop devices change their price?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Take the biggest negative and positive elasticities of 12 MacBook (Mid 2017, Silver)\n",
    "test_largest = result_df.nlargest(3,result_df.columns[1])[[result_df.columns[1]]]\n",
    "test_smallest = result_df.nsmallest(3,result_df.columns[1])[[result_df.columns[1]]]\n",
    "frames = [test_smallest, test_largest]\n",
    "\n",
    "result = pd.concat(frames).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAxkAAAFvCAYAAAAmBwYKAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAAMTQAADE0B0s6tTgAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzs3Xl8XHd97//XRxrtu2zLi2RbsrOVLJiSQKAhGAhbLlv5hbQ0EEqhYWuBptBCewsBWprLjwKl0FBaKIS1kEIpKS0ptO4lLCVAyEZJ0OZF1mJHlmRJ1v69f5yZE0mxrZnxSKOPz/v5eMzDnpmzfGbe58zMR2ezEAIiIiIiIiKFUlLsAkRERERE5OyiJkNERERERApKTYaIiIiIiBSUmgwRERERESkoNRkiIiIiIlJQajJERERERKSg1GSIiIiIiEhBqckQEVnnzGyvmQUza89j3DeZ2b+ewbzb0/Peu8JwvWZ2U77z8exk71H6/m+u0fzfbmb/uBbzEhHJlpoMEVkTZnalmX3NzPanf4DddJJhXmhm3zCzATObNLP7zex3zcxWmPan0tP8yimmGcysoFceNbObMtNN3ybM7Kdmdn0h53MmzKwJuAn434sey9T9k5MMf8mi19OefvggsBX43hnW8hQz+0czO2RmJ8zsITN7h5mVLxuuzsz+1sweTr+n/2Zm5y4b5gYz+7aZDZ+qAUo3PeEktwfyqP0FZnZnen4TZtZpZp8zs/r0IAV5j87AXwJXmtlTcxnJzJrN7GYz+590JkfM7Ltm9ttmVpEe5lOL3ru59Pr7MTPbsGg6J3ufg5n9XYFfp4g4oiZDRNZKLfAz4A+AgVMMsxf4PvBi4CLgA8D7gLdkMf2DwPPMbMuyx28A9udRbzYOEf243Ao8FvgS8OmV/uq/hl4NdIcQfrzs8YeB883s0mWPv4Zl71UIYT6EMBBCmDnDWn4F6AJ+A3gM8HbgjcAHlw33GeCZwEuAK9KPfcvMahYNUw38B/DW08zvMh7JZitwDnAC+GIuRZvZ04CvAP+erucS4PXAKFABBX2PcmJm5WZmIYRJ4AvAjTmM2wr8GHge8E7gQuBJwEeJ1pknLRr8+0TvYTtRZi8Gbl02yTez9P3emks9InIWCiHopptuuq3pDegFbspy2L8GfrTCMJ8C9hH98Hz7ose3AzNEP6LCosebiH7M7if64dkJ/ClQsWy6VwHfASaJflT+F7A7/dxNQO9JankYeOui+2XAzUBfupafAS9bNs5Woh+/I+l69gGXLXp+LxCA9vT9EqK/XvcDe07zvtwDvGPZYzel3/9PAn+z6PGq9Pz/ZNm82tP39y4adg/RD88p4CHg2lwyXTSdPwCOLrp/XnpeVy/Lahp49UnGf1Rtp5nXbwOzwLYca/wgcPcKw5zsPQrAb6b//2ngP04y3j8BX110/5nAd9PLQF86ow0nWc5fD/QA80Bj+rmnAXOZ+1m8rq8BgycbHigF6hfPc9nzf5yed9Xy16qbbrrplrlpS4aIrHeNRD/cs/G3wKsX7V71KqLGY/mWjAqiH/svBn4J+EOiv97+UWYAM7sK+CbRX3ufBDyB6AdX6mQzNrNSM/v/0vX+YNFT7yX6gftmoq0znwVuNbNnp8czoh+bFxD9VfkJRFt6vmVmLSeZTwVRQ/Ic4EkhhJ+eop4m4GLghyd7nui9eqmZ1abv/xpR0/KdUwyfmW418K9ETdflwCuItig8qtYsLM/2V4AFoq0GAIQQjhG9his4M68Bvh5COJzjeAPAbjN70opDntqtwF4z25F5IL270dVEDQhm9nSiH/5fJNpa8kKgA/inZbsLPp4o+18l2no2kX78h0TN55UrFZNeNp4H/FUIYWT58yHaMjN2mkmcSM/rpOuCiAhodykRWcfSu6pcC/xVlqN8BWgAnmFmJcBvAR9fPlCIdm358xDCj0MIvSGEfwTeT7QrT8Y7gW+GEN4cQrgnhPBgCOHvQwgPLhpmh5mNm9k40V/bvwj8fgjhO+n6q4l2L3lHCOHLIYSHQgjvJfox+cfpaTydqLG4LoRwZwjhPqIf7pPA7ywrvQH4N6ItNE8OIfSe5r3YCRjRX8QfJYTwfaLm69fTD/02UeOxkuvSdVwXQvhpejqvJNoSkjUzewzRe/PhRQ9vBR4OIcwuG3wg/Vxe0ruFPR74mzxG/wjwn8D3zKzfzL5u0cH0zTlM4z+Jdq17+aLHXgqMAf+Svv8O4CMhhL8KIfwihPAjouXginTtGYFH3vv7M+9VCGGCaEtURxb1nEv0/f+zHF4DEOf2BuCHIYTji576WGZdWHR7Ra7TF5Gzh5oMEVmXzOyJwFeBd4cQbs9mnBDCNNFfjW8AnguUA18/ybTNzG40sx+nD3YdB95N9MM84/Es+ov6KRwm2nVoD/A4oqbgz+yRswqdk67hzmXj/RfRPvCk/x0JIcQHJKdfx38vGibj60R/PX56CGGlrTuZH/1Tpxnmb4EbzOxCote7fD/7k3kM8ODi+YcQ7ifaspEVMzuHaCvRP4QQPprlaGdy4P5riHYvuiPXEUMIEyGEFxLtEvV2ombh7cDPzez8LKexQLQFa3GTcT3w+UUN1WXAGxf/SOeRJmDxge8/X/bjfrEpsmv2MltGsn1Pn5Ku6QRwP9GucdctG+YdPLIuZG5fzXL6InIWUpMhIutO+sDpfwfeF0J4d46jf5xoV5M/BP7+JH8VB/g94F3pYZ9F1CD8GdHxE7mYCyF0pm/3hRD+hujH5Eo1Gyv/wDvZMP+crvXJWdR2JP3v6f7i/hmiXao+THRswNEspstJ6sqamV0E/F+iv+C/etnT/cAGM1uew2ZOfbKAleZXT7TV4OMhhLzrDiHsDyF8KoTwOqJd7ADelsMkPk10sP0T083JZenHMkqAv+DRP9TPBRY32ZOnmUczj+R+Og8R7Za2vIk9lR+la/klouMwnhFC6Fw2zNCidSFzO90uVyJyllOTISLripk9D/gG0UHE7811/BDCz3lkH/5TnULzacAdIYS/CSHcHUL4BbBr2TA/Bp6R6/yJDoitTv+/k2g3ql9ZNswVQGbLxQNAY3o3FCA+7uKyRcNkvJ9oN6uvm9lzV6ijm2j3mYtONUD6eIfbiHbZymZXqUy9FyzeXSi9JaRhpRHN7AlEW3G+FEJ47Ul+9H+X6HvpqkXjNAJP5NFbg7L1MqKtSX+f5/iPkn7fBsnhOJT0bnY/JNqC8QrggbD0rF8/Ai46yQ/1ztNsuYiZ2XlExxr9KMv6/wX4HTN7VG7p44vqFz10Il1Hb3orm4jIitRkiMiaMLNaM9tjZnuIfvRtSd9f/OP6WqLjKv5/4PNmtiV925Tj7J4NbAwhdJ3i+Z8TXVfgGWZ2rpn9AdHWj8XeAzzXzD5g0fUjzjez31y2i0zpohrbzeylRLvE/BNAiE4t+mHg3WZ2TXpef0h00G6mgfoPoh+fnzWzX0n/pf/vgRqi04kuEUL4S6JTg37FzF5wqjcgvYvON4GVrp3w28CmEMJ/rDBcxueJdo36rJk91swuJzoL0onTjWRmVwLfJjoe5eZF71t8yuEQwkPp5z9q0QUI96TnN0B0itbMtLakn8ssO+ekl6X4wOpFXgP8UwhhMMvXt7zum8zs/Wb2NDPrMLOLzez9RM1brrsDfZroAPuXsXQrBkS7G11tZn9pZo8zs91m9hwz+4SZZbML1F6i0zjfm2UtrydqgH9iZi8zswvT8/w1ojOH/XKW08loWJxp+taU4zRE5GxSrNNa6aabbsm68chpWJffehcNs2+lYU4x7U+x7DSby57/TZaewrae6CDtUaK/9t8KvGnxMOnhnk30g+tEetj/BHaln7tpWY1TwC+IdruqWjSNfE5h+1+c5hS26cd+Kz3Pa07zuq8ExoHaRY/ddLr3c/m8OPnpWR+Xfl+mia598euscArbdEYny3b5e15HtAVqmGjXoG8C5y4bZvl7n7l9atlwl6cff8Ypasq8tt88Td1PA/4h/fqmgKNEW1yuO8l0Fr9Hj5ou0e5M00Rbux51Kl3gKcC3gONEZ436H+BDQGql5ZxoF7Q/znGd3EDU0D+46LXdSXRWtvJs1q1Fr/Vkt2+d6eeGbrrp5vdmIZzJsXQiIrKemdk3gW+HEN5X7FrWm/RpY/8FuDCE0F3sevKVPknCPwPnhRCyPgBfRGQ1aXcpEZGz2xtYYVemBHse8H88NxhpLURbVtRgiMi6oS0ZIiIiZxEzu47TXxPkMSGEA2tVj4gkk5oMERGRs4iZ1RGd9vdUekMIc2tVj4gkk5oMEREREREpKB2TISIiIiIiBZUqdgGnUlFRETZtyvXU+KtnYWGBkhL1ZN4oN5+Um0/KzSfl5pNy88l7bn19fTMhhIpshl23TcamTZs4dOhQscsQERERERHAzI5kO6zfVmqNDQ0NFbsEyYNy80m5+aTcfFJuPik3n5KUm5qMLI2NjRW7BMmDcvNJufmk3HxSbj4pN5+SlJuaDBERERERKSg1GVmqqakpdgmSB+Xmk3LzSbn5pNx8Um4+JSm3dXudjLa2tqADv0VERERE1gcz6wshtGUzrLZkZKm3t7fYJUgelJtPys0n5eaTcvNJufmUpNzUZGRpbm6u2CVIHpSbT8rNJ+Xmk3LzSbn5lKTc1GSIiIiIiDjyrn3vwt5l3D90/6Oeu6vvLp78iSdT/WfVXPOla5Y899X/+SqX3HIJez62hwv/+kL++Nt/zGodOrEmF+MzswrgL4BnAzPA3SGEl63FvAtlPV19XLKn3HxSbj4pN5+Um0/KzadC5PaT/p/wg74fsKNhx0mf31q3lQ8950Pc3X83/97970ueu2rXVbzwghdSYiXMzM9wxSev4IltT+QF57/gjOtabq22ZNwMLADnhRAuBN66RvMtmMrKymKXIHlQbj4pN5+Um0/KzSfl5tOZ5jY9N80bvvEG/vrqv8awkw7TVt/GE1qfQEWq4lHP1VXUUWLRz/+puSmm56fj+4W26lsyzKwGeCXQFtLbY0II/as930I7ePAg55xzTrHLkBwpN58efPBBtmzZUuwyJEc9PT10dHQUuwzJkXLzSbn5lG9uNTU11NTU8I7/fAcvu/hldDTln/33Dn6P197+Wh56+CFef9nr+V/n/q+8p3U6a7G71G7gYeB/m9lVwAngphDCt9dg3iLi0H333cdXvvKVYpchORoeHqa5ubnYZUiOlJtPys2nfHPbu3cvFbsruOvwXdx81c1nVMOTtz+Ze193L0cmjvDiL72Y7xz4DlfuvPKMpnkya9FklAG7gJ+FEN5mZo8FvmVmjwkhHMkMZGY3Ajdm7tfX19PZ2QlEm5ba2to4dOgQU1NTADQ3N9PQ0EBPT088o7a2NmZmZhgaGgKgtLSUjo4OBgYGGB8fB6Curo7NmzfT3d3NwsICAJs3byaVStHX1xdPq6Ojg5GREY4dOwbA6OgoEP1lfHp6Oq6hvr5+yenItm/fzvT0dFxDKpWivb2d/v5+JiYm4tfW0tJCV1dXfLDNli1bKC0tXVLDrl27GB4eZmRkBICqqipaW1s5cOAAMzMzAGzYsIHa2lr279+/pIapqSmOHDmSUw1bt27FzDh8+HA8rd27d3P06NH49VdXV7Nt2zb279/P7OwsABs3bqS6upoDBw7E4+3YsYPJyUmOHj0aLQRlZezcuZPDhw8zOTkJQENDAxs3bqSrqyseb9u2bYQQ6O/vzywX7N69m6GhIcbGxoCom9+6dSu9vb3xWRo2bdpEZWUlBw8ejKe1c+dOTpw4ES9H5eXl7Nixg76+Pk6cOAFAY2Mjzc3NdHd3x+O1trYyPz/PwMBATjW0tLRQUVGxpIb29nbGxsYYHh4GoKKigu3bty9ZlpuammhsbFyyLLe2tjI3N8fg4CAAJSUl7Nq1i8HBQY4fPw5AbW0tW7Zsoaenh/n5+biG8vJyFl9jpqOjg9HR0biG9bA+ZWo41fqUqbe+vp75+fl4uS0pKaGxsZHjx4/Hy19FRQU1NTXx68u8N2YWv1eZ9/nEiRPxa06lUtTX1zM6Ohq/f1VVVZSXl8fLO0TrytzcXLzcnmkNk5OT8WsuKyujrq6OkZGR+P2rrq6mrKxsSQ0NDQ3Mzs6uWEN1dXX8HmfyCSHEeWXe54mJiRVrSKVS8fKeqWFmZiZed0pLS2loaGBsbCxeB2ZmZgghFKSGmpoaSktLl9TQ2NjI9PT0aWuorKyksrIy/tzM1LCwsBAvR2ZGU1MT4+Pj8WdpeXk5tbW1HDt2LP5MzKaGzHK0uIaqqioqKiqW1LB8Wc6lhpKSkiXLUWNjI1NTUysuyyvVkFmOpqenl3xGaX1aH+tTZWUlVVVVp6whU7/Wp/W1Pq20LM/NzTE7O5vz+nT8+HG+2/1dHhh8gO1/sR2AgckBnnXrs3jPZe/hqa1PfdTvvcHBwXi5ONnvvdH+US5vvpy/+97f8ZQdT8nq914uVv1ifGa2ERgEykMI8+nHfgj8QQhh36nGW28X45udnaWsrKzYZUiOlJtP3/rWt7jzzjuLXYbkaH5+ntLS0mKXITlSbj4pN5/yzW3v3r3s3bt3yWPtH2rn9t+4nYtaLjrpOJ/66ae4/aHbue3a2+LHHjz6IOduOJcSK+H49HGe+7nn8orHvoLffvxvZ1VHLhfjW/UtGSGEo2b2baIzS33DzHYCHcCDqz3vQhofH6epqanYZUiOlJtPF1xwAZdcckmxy5AcjYyM0NjYWOwyJEfKzSfl5lO+udXU1Jz2+as/dzXvftq7uXTbpXQNd/HUTz2VydlJpuamaPtAG3/0lD/i9Ze9ni//7Mt8/r7PU1ZaxvzCPNc85hpe/cuvzvflnNaqb8kAMLNdwCeBDcA88K4QwldPN85625LR2dmpA4gdUm4+KTeflJtPys0n5eaT99zW1ZYMgBBCN7B3LeYlIiIiIiLFpSt+Z6m8vLzYJUgelJtPys0n5eaTcvNJufmUpNzWZHepfKy33aVERERERJIsl92ltCUjS4tPxyl+KDeflJtPys0n5eaTcvMpSbmpychS5hzO4oty80m5+aTcfFJuPik3n5KUm5oMEREREREpKDUZWdK5qH1Sbj4pN5+Um0/KzSfl5lOSctOB31laWFigpEQ9mTfKzSfl5pNy80m5+aTcfPKemw78XgXd3d3FLkHyoNx8Um4+KTeflJtPys2nJOWmJkNERERERApKTYaIiIiIiBSUmowstba2FrsEyYNy80m5+aTcfFJuPik3n5KUm5qMLM3Pzxe7BMmDcvNJufmk3HxSbj4pN5+SlJuajCwNDAwUuwTJg3LzSbn5pNx8Um4+KTefkpSbmgwRERERESkoNRlZMrNilyB5UG4+KTeflJtPys0n5eZTknLTxfhERERERGRFuhjfKhgaGip2CZIH5eaTcvNJufmk3HxSbj4lKTc1GVkaGxsrdgmSB+Xmk3LzSbn5pNx8Um4+JSk3NRkiIiIiIlJQajKyVFNTU+wSJA/KzSfl5pNy80m5+aTcfEpSbjrwW0REREREVqQDv1dBb29vsUuQPCg3n5SbT8rNJ+Xmk3LzKUm5qcnI0tzcXLFLkDwoN5+Um0/KzSfl5pNy8ylJuanJEBERERGRglKTkaWWlpZilyB5UG4+KTeflJtPys0n5eZTknJTk5GlioqKYpcgeVBuPik3n5SbT8rNJ+XmU5JyU5ORpYMHDxa7BMmDcvNJufmk3HxSbj4pN5+SlJuaDBERERERKSg1GSIiIiIiUlC6GF+W5ubmSKVSxS5DcqTcfFJuPik3n5SbT8rNJ++56WJ8q2BsbKzYJUgelJtPys0n5eaTcvNJufmUpNzUZGRpeHi42CVIHpSbT8rNJ+Xmk3LzSbn5lKTc1GSIiIiIiEhBqcnIUpLOa3w2UW4+KTeflJtPys0n5eZTknLTgd8iIiIiIrIiHfi9CtTw+KTcfFJuPik3n5SbT8rNpyTlpiYjS1NTU8UuQfKg3HxSbj4pN5+Um0/Kzack5aYmQ0RERERECkpNRpaampqKXYLkQbn5pNx8Um4+KTeflJtPScpNTUaWGhsbi12C5EG5+aTcfFJuPik3n5SbT0nKTU1Glnp6eopdguRBufmk3HxSbj4pN5+Um09Jyk1NhoiIiIiIFJSaDBERERERKSg1GVlqbW0tdgmSB+Xmk3LzSbn5pNx8Um4+JSk3NRlZmpubK3YJkgfl5pNy80m5+aTcfFJuPiUpNzUZWRocHCx2CZIH5eaTcvNJuflU6Nym5qZ40RdfxHl/dR57PraH53z2OfSO9D5quN6RXvZ+ai8NNzdw6ccvXfLcrffcyp6P7YlvG9+3kRf/w4sLWqd3Wt98SlJuqbWYiZn1AlPpG8CfhxD+YS3mLSIiImvrhsffwHPPeS5mxkd++BFu+PoN3PHyO5YMU19Rz58+/U8ZnRrlnfveueS56x97Pdc/9vr4/sW3XMx1F1+3JrWLSGGsSZORdk0I4f41nF9BlZRoo49Hys2nqakphoaGil2G5Gh4eFi5OVTI3GpqaqipqeHqc6+OH7u87XI+9IMPPWrY5qpmrthxBft69512mj/s+yGD44O84PwXFKTGs4W+33xKUm5r2WS4tmvXrmKXIHlQbj4dPXqU2267rdhliEiO9u7dy969e5c89uH//jDPP+/5eU/zEz/5BC+/5OWUlZadYXVnF32/+ZSk3NayyficmZUA/w28PYRwZPGTZnYjcGPmfn19PZ2dnQBUVlbS1tbGoUOHmJqK9rhqbm6moaFhyUVN2tramJmZif8iU1paSkdHBwMDA4yPjwNQV1fH5s2b6e7uZmFhAYDNmzeTSqXo6+uLp9XR0cHIyAjHjh0DYHp6mgsvvJCDBw8yPT0d11BfX09vb2883vbt25meno5rSKVStLe309/fz8TERPzaWlpa6OrqIoQAwJYtWygtLV1Sw65duxgeHmZkZASAqqoqWltbOXDgADMzMwBs2LCB2tpa9u/fv6SGqakpjhw5klMNW7duxcw4fPhwPK3du3dz9OhRRkdHAaiurmbbtm3s37+f2dlZADZu3Eh1dTUHDhyIx9uxYweTk5McPXoUgLKyMnbu3Mnhw4eZnJwEoKGhgY0bN9LV1RWPt23bNkII9Pf3Z5YLdu/ezdDQEGNjY0D0l7KtW7fS29sbH0C1adMmKisrOXjwYDytnTt3cuDAgfj1lZeXs2PHDvr6+jhx4gQQXXmzubmZ7u7ueLzW1lbm5+cZGBjIqYaWlhYqKiqW1NDe3s7Y2BjDw8MAVFRUsH379iXLclNTE42NjUuW5dbWVubm5uJ9N0tKSti1axeDg4McP34cgNraWrZs2UJPTw/z8/NxDeXl5Rw6dCieVkdHB6Ojo3EN62F9ytRwqvWps7OT4eFh6uvrmZ+fj5fbkpISGhsbOX78eLz8VVRUUFNTE7++zHtjZvF7lXmfT5w4Eb/mVCpFfX09o6Oj8ftXVVVFeXl5vLxDtK7Mzc3Fy+2Z1jA5ORm/5rKyMurq6hgZGYnfv+rqasrKypbU0NDQwOzs7Io1VFdXx+9xJp8QQpxX5n2emJhYsYZUKhUv75kaZmZm4nWntLSUhoYGxsbG4nUghEBzc3NBaqipqaG0tHRJDY2NjUxPT5+2hsrKSiorK+PPzUwNCwsL8XJkZjQ1NTE+Ph5/lpaXl1NbW8uxY8fiz4xsasgsR4trqKqqoqKiYkkNy5flXGooKSlZshw1NjYyNTW14rK8Ug2Z5ejIkSOUlpYCZ74+DQ4Oxt/dGzZs4CP3fIT7Dt/Hrc+4lc7OzpN+PwHMzs7G4y3+fpqcneQL932B/7juP5icnDyrvp/Gx8d5+OGH4+xz/X4aHx+nrq5O30+s7fdTRr6/91KpFJs3b3b7ey8XlpnhajKzHSGEA2ZWBvwpcHEI4erTjdPW1hYWL4jF1tnZyTnnnFPsMiRHys2nz33uc/ziF78odhmSo+HhYZqbm4tdhuSokLkt3pLx/u+9ny/e/0W+df23aKxsPOU4+3r38ZY73sKPbvjRo5679Z5bueVHt/D9V32/IPWdTfT95pP33MysL4TQls2wa7IlI4RwIP3vrJl9CHhoLeYrIj5dfPHFPPOZzyx2GZKjnp4eOjo6il2G5KiQudXU1ADwge9/gC/c/wW+9fLTNxgr+eTdn+RVj3tVQWoTkbW16k2GmdUAZSGEzDbblwJ3r/Z8C622trbYJUgelJtPLS0ttLS0FLsMydHCwoJyc6jQuR0aO8Tv3/H77GraxdM+/TQAKlIV/Per/5tX//OrecH5L+AF57+A6blpdn94N9Pz04xOjdL2gTZefsnL+fOr/hyAruEuftz/Y77+0q8XrLazib7ffEpSbqu+u5SZ7QL+ESgFDOgG3hRC6D3deOttdykRERERkSTLZXepVT+PVgihO4TwuBDCJSGEi0MIL1ypwViPFh9wJH4oN5+Um0/KzSfl5pNy8ylJuSXnZL1nKHN2BPFFufmk3HxSbj4pN5+Um09Jyk1NhoiIiIiIFJSajCzpYEaflJtPys0n5eaTcvNJufmUpNzUZGSpvLy82CVIHpSbT8rNJ+Xmk3LzSbn5lKTc1GRkSWe68km5+aTcfFJuPik3n5SbT0nKTU2GiIiIiIgUlJoMEREREREpqFW/GF++1tvF+Obn5yktLS12GZIj5eaTcvNJufmk3HxSbj55z21dXYzvbDE6OlrsEiQPys0n5eaTcvNJufmk3HxKUm5qMrI0PDxc7BIkD8rNJ+Xmk3LzSbn5pNx8SlJuajJERERERKSg1GRkqbKystglSB6Um0/KzSfl5pNy80m5+ZSk3HTgt4iIiIiIrEgHfq8CNTw+KTeflJtPys0n5eaTcvMpSbmpycjS1NRUsUuQPCg3n5SbT8rNJ+Xmk3LzKUm5qckQEREREZGCUpORpebm5mKXIHlQbj4pN5+Um0/KzSfl5lOSclOTkaWGhoZilyB5UG4+KTeflJtPys0n5eZTknJTk5Glnp6eYpcgeVBuPik3n5SbT8rNJ+XmU5JyU5MhIiIiIiIFpSZDREREREQKShfjy9LU1FSirtJ4tlBuPik3n5SbT8rNJ+Xmk/fcdDG+VTAzM1PsEiQPys0n5eYejv4fAAAgAElEQVSTcvNJufmk3HxKUm5qMrI0NDRU7BIkD8rNJ+Xmk3LzSbn5pNx8SlJuajJERERERKSg1GRkqbS0tNglSB6Um0/KzSfl5pNy80m5+ZSk3HTgt4iIiIiIrEgHfq+CgYGBYpcgeVBuPik3n5SbT8rNJ+XmU5JyU5ORpfHx8WKXIHlQbj4pN5+Um0/KzSfl5lOSclOTISIiIiIiBaUmI0t1dXXFLkHyoNx8Um4+KTeflJtPys2nJOWmA79FRERERGRFq3Lgt5mVmtn/yb8s37q7u4tdguRBufmk3HxSbj4pN5+Um09Jyi3rJiOEMA88YRVrWdcWFhaKXYLkQbn5pNx8Um4+KTeflJtPScot12Myvm5mf2hmm8ysOnNblcpERERERMSlVI7Dvz/9758DAbD0v2f95Qs3b95c7BIkD8rNJ+Xmk3LzSbn5pNx8SlJuOTUZIYTEno0qlcq1H5P1QLn5pNx8Um4+KTeflJtPScot56bBzPaY2W+k/99oZlsLX9b609fXV+wSJA/KzSfl5pNy80m5+aTcfEpSbjk1GWb2WuDTwHvSD20APlfookRERERExK9ct2S8BrgcGAMIIXQBLYUuSkRERERE/MrpYnxm9t8hhCea2d0hhMelH/tpCGFPoQtbbxfjm5+fp7T0rD++/ayj3HxSbj4pN5+Um0/KzSfvua3KxfjSjpjZeURnlMLMXg4czHEaLo2MjBS7BMmDcvNJufmk3HxSbj4pN5+SlFuuTcabgc8C55tZL/D29GNnvWPHjhW7BMmDcvNJufmk3HxSbj4pN5+SlFuup7DtNLPLgfOJrpHxYPpK4CIiIiIiIkDuF+MDeDzwDKJdpqqAHxe0onWqsrKy2CVIHpSbT8rNJ+Xmk3LzSbn5lKTccj2F7e8BXwY2A1uA28zsTatR2HrT1pbVMS6yzig3n5SbT8rNp/fd9z7aP9SOvcu4f+j+kw4zMTPBK7/2Si6+5WLO/8j5vO1bbyNz4piFsMBb7ngLF/31RVzwkQt41ddexcz8zFq+hETS+uZTknLL9ZiM1wGPDyH8Xgjh94i2arwh25HN7J1mFszsohznW3QHDybi+PazjnLzSbn5pNx8unLjldz5W3eys2HnKYd573feC8C9r72X+193P3cP3M1tP7sNgE/85BPcO3gvP3nNT/ifN/wPAH/5g79c/cITTuubT0nKLdfdpfpDCA9n7oQQhs1sIJsRzeyXia6xcSDHea4L09PTxS5B8qDcfDp27BgVFRXFLkNydPjwYeXmTE1NDXua9tBWf/q/rt4zeA/XP/Z6zIyy0jKetetZfObez/CSC1/CPYP3cNWuqygvLQfg6nOv5l3/9S7e+itvXYuXkFj6fvMpSbll1WSY2WPS//2umf0d8In0/VcC38xi/Argo8BvAP+ZR50ikiD33XcfX/nKV4pdhuRoeHiY5ubmYpchOdi7d29Wu29ctu0yvvTAl3jRBS9iem6ar/78q4xNj8XPffwnH+d1l76OilQFX3zgi/SO9K5y5SKy3mW7JeNflt1/xqL/B+DPVhj/3cBnQwg9ZnbSAczsRuDGzP36+no6OzuB6CCZtrY2Dh06xNTUFADNzc00NDTQ09MTT6OtrY2ZmRmGhoYAKC0tpaOjg4GBAcbHxwGoq6tj8+bNdHd3s7CwAMDmzZtJpVL09fXF0+ro6GBkZCQ+1djc3BwQbebKdKHNzc3U19fT29sbj7d9+3amp6fjGlKpFO3t7fT39zMxMRG/tpaWFrq6uuJ9Wrds2UJpaemSGnbt2sXw8HB8TuWqqipaW1s5cOAAMzPR/q4bNmygtraW/fv3L6lhamqKI0eO5FTD1q1bMTMOHz4cT2v37t0cPXqU0dFRAKqrq9m2bRv79+9ndnYWgI0bN1JdXc2BA49spNqxYweTk5McPXoUgLKyMnbu3Mnhw4eZnJwEoKGhgY0bN9LV1RWPt23bNkII9Pf3Z5YLdu/ezdDQEGNj0RdaTU0NW7dupbe3N85l06ZNVFZWLtkMuXPnTsrKyuLlqLy8nB07dtDX18eJEycAaGxspLm5me7u7ni81tZW5ufnGRgYyKmGlpYWKioqltTQ3t7O2NgYw8PDAFRUVLB9+/Yly3JTUxONjY1LluXW1lbm5uYYHBwEoKSkhF27djE4OMjx48cBqK2tZcuWLfT09DA/Px/XUF5ezuILWXZ0dDA6OhrXsB7Wp0wNp1qfpqamGB4epr6+nvn5+Xi5LSkpobGxkePHj8fLX0VFBTU1NfHry7w3Zha/V5n3+cSJE/FrTqVS1NfXMzo6Gr9/VVVVlJeXx8s7ROvK3NxcvNyeaQ2Tk5Pxay4rK6Ouro6RkZH4/auurqasrGxJDQ0NDczOzq5YQ3V19ZLTI9bV1RFCiPPKvM8TExMr1pBKpeLlPVPDzMxMvO6UlpbS0NDA2NhYvA6YGSGEgtRQU1NDaWnpkhoaGxuZnp4+bQ2VlZVUVlYuORd9XV0dCwsL8XJkZjQ1NTE+Ph5/lpaXl1NbW8uxY8fiz8RsasgsR4trqKqqoqKiYkkNy5flXGooKSlZshw1NjYyNTW14rK8Ug0lJdEe0yEEOjs7mZub4+GHH4YWHvX99MbHv5Ebv3Ejj/3oY2kob+Apu57CHZ130NnZyZNrnsx9m+7jyk9dSWohxZM2P4lSSjl27Ji+nzj199P4+Hj0fpPf99Pk5CRdXV36fmJtv58y8v29V1VVxYkTJ9z+3stFTlf8zoeZPYmoCXlGCCGkr6/xvBDCyY8uS1tvV/yem5sjlcrnZFxSTMrNp29/+9t85zvfKXYZkqOFhYX4h6v4sHfvXq644orox8mH2rn9N27nopaVD5u8+c6beeDIA3zmVz/zqOe+eP8X+ehdH+U7r9Q6vJr0/eaT99xyueJ3zq/SzKqBtsXjhhB+dppRngpcAGS2YrQB3zSzV4cQ/jXX+RdLb28v55xzTrHLkBwpN582bdrE61//+mKXITnq6emho6Oj2GVIDmpqarL6nBybHiNVkqK6rJqeYz3c8qNb+Nqvfw2AqbkppuamaKxs5OjkUW6+82be87T3rEX5iabvN5+SlFtOTUb6FLbvBo4BmYvwBWDXqcYJIdwM3LxoGr1ksSVDRJKrurqalpaWYpchORobG1NuDt30w5vY98/7GBgf4Kpbr6K2vJbON3Zy9eeu5t1PezeXbruU7mPdXPvla0mVpEiVpPjgsz/Ini17ABidGuWpn3oqpSWlzC/M8+bL38zzz39+kV+ViBRbrlsyfhc4P4RweMUhRUREZN276Qk3nfQvq9+47hvx//ds2cNDv/vQScffXLuZn//Oz1etPhHxKadjMszsv0IIT13FemLr7ZiM6elpnZrRIeXmk3LzSbn5pNx8Um4+ec9tNY/JeGf6FLbfAKYyD4YQvnHqUc4O3heKpFJuPik3n5SbT8rNJ+XmU5Jyy7XJeBHwfOA8lh6TcdY3GUNDQ9TX1xe7DMmRcvNJufmk3HxSbj4pN5+SlFuuTcYLgfYQwonVKEZERERERPzL9YTmXcDsahSy3nk+p3GSKTeflJtPys0n5eaTcvMpSbnleuD3LcCFwD+x9JiMvy50YevtwG8RERERkSTL5cDvXLdkVBJtzbgYuCx9uzTHabjU399f7BIkD8rNJ+Xmk3LzSbn5pNx8SlJuOW2zCSG8crUKWe8mJiaKXYLkQbn5pNx8Um4+KTeflJtPScot1yt+X3+yx0MItxamHBERERER8S7Xo0+ev+j/lcAVwA+As77JSMrpxs42ys0n5eaTcvNJufmk3HxKUm45Hfj9qJHNOoD3hBBeVriSIjrwW0RERERk/VjNA7+XCCH0AOefyTS86OrqKnYJkgfl5pNy80m5+aTcfFJuPiUpt1yPybh60d1S4IlEV/w+653JFh8pHuXmk3LzSbn5pNx8Um4+JSm3XI/JeOui/88Rnc721wpXjoiIiIiIeJfrKWyftlqFrHdbtmwpdgmSB+Xmk3LzSbn5pNx8Um4+JSm3rJoMM9txuudDCAcKU876VVpaWuwSJA/KzSfl5pNy80m5+aTcfEpSbtke+P1j4Efpf3+86P59QM/qlLa+9PX1FbsEyYNy80m5+aTcfFJuPik3n5KUW1ZbMkIImxbfN7My4HXA24Evr0JdIiIiIiLiVM6nsDWzlwL/AzwdeHoI4dUFr0pERERERNzK+mJ8ZvYs4GZgAnhbCOG7q1nYersY38LCAiUlZ3RZESkC5eaTcvNJufmk3HxSbj55z63gF+MzszuAW4D3A88G7jaz6swt/1L9GB4eLnYJkgfl5pNy80m5+aTcfFJuPiUpt2xbqauADuCzwPFFt/H0v2e9kZGRYpcgeVBuPik3n5SbT8rNJ+XmU5Jyy/bA72y3eFSEEKbPrCQREREREfGs0DuFfb/A01s3qqqqil2C5EG5+aTcfFJuPik3n5SbT0nKLesDv7OamNndIYTHFWJa6+3AbxERERGRJCv4gd85KFzHss4cOHDWX9T8rKTcfFJuPik3n5SbT8rNpyTl5vccWmtsZmam2CVIHpSbT8rNJ+Xmk3LzSbn5lKTcCt1kWIGnJyIiIiIizhS6yfhBgae3bmzYsKHYJUgelJtPys0n5eaTcvNJufmUpNyyOoVthpm9/iQPjwI/DCH8IoTwusKUtf7U1tYWuwTJg3LzSbn5pNx8Um4+KTefkpRbrlsyngv8OdHF+a4C3gu8FPi2mf1WgWtbV/bv31/sEiQPys0n5eaTcvNJufmk3HxKUm757C51UQjhxSGEFwMXAxPAE4AbC1qZiIiIiIi4lGuT0R5COJi5k/7/eSGEAWCuoJWJiIiIiIhLuTYZg2b2R2a21cy2mNnbgWEzK+UsvkYGwPbt24tdguRBufmk3HxSbj4pN5+Um09Jyi3XJuN64JeB+4EHgMcDrwDK0s+dtaampopdguRBufmk3HxSbj4pN5+Um09Jyi2nJiOEcDiEcE0IYUP6dk0I4VAIYSqEcN9qFbkeHDlypNglSB6Um0/KzSfl5pNy80m5+ZSk3HI6hS2AmT0R2L143BDCrYUsSkRERERE/Mr1Ohm3AM8GfgrMpx8OwFnfZKRSOfdjsg4oN5+Um0/KzSfl5pNy8ylJuVkI2R+vbWa/AC4OIaz6DmVtbW3h0KFDqz0bERERERHJgpn1hRDashk21wO/+9eiwViP+vv7i12C5EG5+aTcfFJuPik3n5SbT0nKLddtNt8zsy8BXwTiZiOE8I2CVrUOTUxMFLsEyYNy80m5+aTcfFJuPik3n5KUW65NxhPT//7uoscCcNY3GSIiIiIikp2cmowQwtNWq5D1rr6+vtglSB6Um0/KzSfl5pNy80m5+ZSk3LI68NvMOkIIPWb2mJM9H0L4WaEL04HfIiIiIiLrx2oc+P1X6X//5SS323Ou0KGurq5ilyB5UG4+KTeflJtPys0n5eZTknLLanepEMLz0v92rG4561cup/qV9UO5+aTcfFJuPik3n5SbT0nKLadT2JrZK07y2HsLV06RvfGN0N4OZnD//acebmICXvlKuPhiOP98eNvbIEELjYiIiIjI6eR6nYw3mNnTM3fM7I+Ax600kpndYWb3mtlPzew7ZrYn10LXxDXXwJ13ws6dj3pq69atj9x5b7qvuvfeqBm5+2647bY1KlJysSQ3cUO5+aTcfFJuPik3n5KUW66nsP1V4N/M7NeBpwPPBp6TxXjXhhBGAMzsRcAngV/Ocd6r78orT/mUmT1y55574Prroy0eZWXwrGfBZz4DL3kJExMTiToH8no3OTmpPBwyM2pqaopdhuRoyeekuKHcfFJuPiUpt1xPYdtnZr8B/DNwBLgqhHAii/FGFt1tABZyqnIdOHz4MOecc05057LL4Etfghe9CKan4atfhbExAO666y727dtXvEJlieHhYZqbm4tdhuTo3HPP5brrrit2GZKjJZ+T4oZy80m5+ZSk3LJqMszsy0QX3cuYAyaAT5oZIYRrs5jGrUDmOhuP2vphZjcCN2bu19fX09nZCUBlZSVtbW0cOnSIqanoQuPNzc00NDTQ09MTT6OtrY2ZmRmGhoYAKC0tpaOjg4GBAcbHxwGoq6tj8+bNdHd3s7AQ9TqbN28mlUrR19cHwM65OUrm5xl5+GGOHTsGwOjoKAAHDx5k5ppr2NDbS+3jH0/Jhg2M/tIvUfX973Oos5OZmRmmp6fjv56XlJTQ2NjI8ePHmZ2dBaCiooKamhqGh4fj2mtrazEzjh8/Hj/W1NTEiRMn4tecSqWor69ndHSU+fl5AKqqqigvL4/ry7x3c3NzTE5OFqSGyclJpqenASgrK6Ouro6RkZH4/auurqasrGxJDQ0NDczOzq5YQ3V1dfweZ/IJIcR5ZbKemJhYsYZUKsVYutlbXEPmNZaWltLQ0MDY2Bhzc3NAtGxVVVUVpIaamhpKS0uX1NDY2Mj09DQnTpw4bQ2VlZWMjDzSi9fV1bGwsBAvR2ZGU1MT4+PjzMzMAFBeXk5tbS3Hjh2LDyTLpobMcrS4hqqqKioqKpbUUF9fz/z8fF41lJSULFmOGhsbmZqaWnFZztQwOjpKZ2cn27dvZ3p6Ol6nU6kU7e3t9Pf3x3XV19fT0tJCV1dXXMOWLVsoLS2N12mAXbt2MTw8HL/GqqoqWltbOXDgQPx6NmzYQG1tLfv374/H2759O1NTUxw5ciSnGrZu3YqZcfjw4Xhau3fv5ujRo/G6Ul1dzbZt29i/f3+8XmzcuJHq6moOHDgQj7djxw4mJyc5evQoEC1/O3fu5PDhw/E61tDQwMaNG5ecuWTbtm2EEOjv748z3L17N0NDQ/EyUlNTw9atW+nt7Y2Xh02bNlFZWcnBgwfjae3cuZPx8XEefvjhOPsdO3bQ19cXL1sTExMsLCzQ3d0dj9fa2sr8/DwDAwM51dDS0kJFRcWSGtrb2xkbG4vX6YqKCrZv377ku6GpqYnGxsYl3w2tra3Mzc0xODgIRJ9Hu3btYnBwMF5Oa2tr2bJlCz09PfEy2dLSQnl5OYtPp97R0cHo6Ghcw1p/P2VqGBkZiT+3MjUcPHgw/oxqbm6mvr6e3t7eeLxTrU9jY2Px963Wp/WzPjU2NtLc3HzK9eno0aNan9bh+rTSspz5Pva6PuUi2+tkPOqA78VCCJ/OeobRtH4thHD16YZbk+tk3HorfOAD0f/f9KboYG6IDv6+/Xa46KJ40M7OzlN3njffDA88AJ/5DPv27dOWjHVEWzJ80pYMn077OSnrlnLzSbn55D23XK6TkVWTUWhmdgJoCyE8fKphinoxvpM0GSGER/ajGxuDVAqqq6GnB/buha99Dfbs0TEZ68yS3MSN6upqamtri12G5Ejrm0/KzSfl5pP33HJpMnI6JsPMGoHXALsXjxtC+K3TjFMP1IYQDqfv/yrwMDB8qnGK5g1viJqFgQG46iqorYX0JuSZZz6Tiptvhksvhe5uuPbaqNFIpeCDH4Q90QmzampqdMDqOnLkyBE2bdpU7DIkR0eOHFGT4dDRo0e1vjmk3HxSbj4lKbdczy51G9EB398H5rMcpwH4RzOrIjrg+wjwvLAer0by0Y9Gt5M4+LGPPbJ5a88eeOihNSxM8jU6OpqYlflsotx8Um4+KTeflJtPScot1yZjawjhqlxGCCEcBJ6Q43xERERERMSpXC/G12VmDatSyTpXXV1d7BIkD8rNJ+Xmk3LzSbn5pNx8SlJuOR34bWafI9oq8a/AVObxEMIfFLqwoh74LSIiIiIiS+Ry4HeuWzIeAj5LdOD2xKLbWW/xeYnFD+Xmk3LzSbn5pNx8Um4+JSm3XK/4/a7VKmS9y1yIRHxRbj4pN5+Um0/KzSfl5lOScsv1wG/M7MXAHqAy89hq7C4lIiIiIiI+5bS7lJl9CHgl8GqgFPh1YMMq1LXu5HopdVkflJtPys0n5eaTcvNJufmUpNxyPSbjGcALgSMhhN8HLgNaCl7VOpSkswGcTZSbT8rNJ+Xmk3LzSbn5lKTccm0ypkIIC0Aws7IQwiDQugp1rTsHDhwodgmSB+Xmk3LzSbn5pNx8Um4+JSm3XI/JOG5m1cCdwKfNbABIzhEsIiIiIiKyoly3ZLwUmAPeCjwAzANvKXRRIiIiIiLiV9YX4zOzS4GdwL4QwsNmdiHwZ8CvhBA2Fbqw9XYxvpmZGcrLy4tdhuRIufmk3HxSbj4pN5+Um0/ecyv4xfjM7A+BfyfagvEDM/td4C6gEzg330I9mZycLHYJkgfl5pNy80m5+aTcfFJuPiUpt2x3l/pN4DEhhMuB5wMfBJ4fQnhLCGFktYpbT44ePVrsEiQPys0n5eaTcvNJufmk3HxKUm7ZNhlTIYR+gBDCz4GHQgjfXr2yRERERETEq2zPLlVhZr8EWOaBxfdDCD9bhdrWlbKysmKXIHlQbj4pN5+Um0/KzSfl5lOScsvqwG8z6wVONWAIIewqZFGw/g78FhERERFJsoIf+B1CaA8hdJziVvAGYz06fPhwsUuQPCg3n5SbT8rNJ+Xmk3LzKUm55XqdjMRK0tkAzibKzSfl5pNy80m5+aTcfEpSbmoyRERERESkoNRkZKmhoaHYJUgelJtPys0n5eaTcvNJufmUpNyyvuL3WltvB36HEDCzlQeUdUW5+aTcfFJuPik3n5SbT95zK/iB3wJdXV3FLkHyoNx8Um4+KTeflJtPys2nJOWmJkNERERERApKTYaIiIiIiBSUmowsbdu2rdglSB6Um0/KzSfl5pNy80m5+ZSk3NRkZGm9HiAvp6fcfFJuPik3n5SbT8rNpyTlpiYjS/39/cUuQfKg3HxSbj4pN5+Um0/Kzack5aYmQ0RERERECkpNRpY8n9M4yZSbT8rNJ+Xmk3LzSbn5lKTcdDE+ERERERFZkS7GtwqGhoaKXYLkQbn5pNx8Um4+KTeflJtPScpNTUaWxsbGil2C5EG5+aTcfFJuPik3n5SbT0nKTU2GiIiIiIgUlJqMLNXU1BS7BMmDcvNJufmk3HxSbj4pN5+SlJsO/BYRERERkRXpwO9V0NvbW+wSJA/KzSfl5pNy80m5+aTcfEpSbmoysjQ3N1fsEiQPys0n5eaTcvNJufmk3HxKUm5qMkREREREpKDUZGRp06ZNxS5B8qDcfFJuPik3n5SbT8rNpyTlpiYjS5WVlcUuQfKg3HxSbj4pN5+Um0/Kzack5aYmI0sHDx4sdgmSB+Xmk3LzSbn5pNx8Um4+JSk3NRkiIiIiIlJQajJERERERKSgdDG+LM3OzlJWVlbsMiRHys0n5eaTcvNJufmk3HzynpsuxrcKxsfHi12C5EG5+aTcfFJuPik3n5SbT0nK7exrMt74RmhvBzO4//5TDzcxAa98JVx8MZx/PrztbZDZqnPrrbBnzyO3jRsp+7VfW5PypbAefvjhYpcgeVBuPik3n5SbT8rNpyTltupNhplVmtk/mdlDZvZTM/s3M2tftRlecw3ceSfs3Hn64d773ujfe++NmpG774bbboseu/56+OlPH7lt3crxF7xg1UoWERERETmbpNZoPh8H/jWEEMzsd9L3n7Uqc7ryyuyGu+eeqJkwg7IyeNaz4DOfgZe8ZOlwP/whDA4y+9znAjAxMcHExESBi5bVMjY2xtDQULHLkBzNzc0VuwTJQ3l5ebFLkDwoN5+Um09Jym3Vm4wQwhTwjUUP/QB482rPd0WXXQZf+hK86EUwPQ1f/SqMjT16uE98Al7+cnbs3g3AXXfdxb59+9a2VpGE2bt3LxdccEGxy5Ac7dixo9glSB6Um0/Kzack5bZWWzIWeyPw9eUPmtmNwI2Z+/X19XR2dgLR1RHb2to4dOgQU1NTADQ3N9PQ0EBPT088jba2NmZmZhgaGmLn3ByDhw7RdtFFDAwMxAfa1NXVsXnzZnquvZam3l6qHvtYSjdtIjzhCczfcQeH0vPs6Ohg5PBhGr/wBQ79wz8wdt99XHzxxQwNDTE8PAxAVVUVFRUVjIyMsLju+fn5eGtHSUkJjY2NHD9+nNnZWQAqKiqoqamJpwNQW1uLmXH8+PH4saamJk6cOBG/5lQqRX19PaOjo8zPz8c1lJeXMzo6uqSGubk5JicnC1LD5OQk09PTAJSVlVFXV8fIyAgLCwsAVFdXU1ZWtqSGhoYGZmdnV6yhurqaY8eOxePV1dURQlhyYFRzczMTExMr1pBKpRhb1Cg2NDQwMjKCmQFQWlpKQ0MDY2Nj8V/KKysrqaqqKkgNNTU1lJaWLqmhsbGR6elpTpw4cdoaKisrlyxHdXV1LCwsxMuRmdHU1MT4+DgzMzNA9NeQ2tpajh07RuYscdnUkFmOFteQzbKcSw0lJSVLlqPGxkampqZWXJYzNTz44IO0tbWxfft2pqen461RqVSK9vZ2+vv747rq6+tpaWmhq6srrmHLli2UlpbS19cX17Br1y6Gh4fj11hVVUVraysHDhyIX8+GDRuora1l//798Xjbt29namqKI0eO5FTD1q1bMTMOHz4cT2v37t0cPXo0Xleqq6vZtm0b+/fvj9eLjRs3Ul1dzYEDB+LxduzYweTkJEePHgWi5W/nzp0cPnw4XscaGhrYuHEjXV1d8Xjbtm0jhEB/f3+c4e7duxkaGoqXkZqaGrZu3Upvb2+8PGzatInKysolF43auXMn4+Pj8f7E5eXl7Nixg76+vnjZmpub47zzzqO7uzser7W1lfn5eQYGBnKqoaWlhYqKiiU1tLe3MzY2Fn9uVVRUsH379iXfDU1NTTQ2Ni75bmhtbWVubo7BwUEg+jzatWsXg4OD8XJaW1vLli1b6OnpiZfJlpYWysvLWXymw46ODkZHR+Ma8vl+guizoKOj46TfT93d3fHnyubNm0mlUkuW5Y6ODkZGRuLPrUwNBw8ejD+jmpubqa+vp7e3Nx7vVOvTAw88QEVFBaD1afohLKEAABWeSURBVD2tT42NjTQ3N59yfRodHaWxsVHrE+trfVppWTYztm3b5nZ9ysWansLWzP4IeD7wjBDC5OmGzfoUtrfeCh/4QPT/N70pOpgbooO/b78dLroou+JuvhkeeCDaZWrxtG+5Bb7/fTo7OznnnHPYt2+ftmQ4Mjw8THNzc7HLkByde+65XHfddcUuQ3KU+ZwUX5SbT8rNJ++55XIK2zXbkmFmbwFeDFy1UoORk+uvj265GhuDVAqqq6GnJ2omvva1pcN88pPwqlcteeiyyy7jMY95zBkULGupp6eHjo6OYpchOcr81VtERER8WpMmI70r1EuJGoyRlYY/I294Q9QsDAzAVVdBbS2kd4Hi6qvh3e+GSy+F7m649tqo0Uil4IMfjE5Xm9HVBT/+MXw92rOrsbERiDZD1tTUrOpLkMIpKSnJefOeFF9Jydl3du0kyHxOii/KzSfl5lOSclv13aXMrA04CHQDmZ20p0MITzzdeOvtit8LCwv64eOQcvNJufmk3HxSbj4pN5+857aurvgdQjgUQrAQwu4Qwp707bQNxnq0+MAr8UO5+aTcfFJuPik3n5SbT0nKzW8rJSIiIiIi65KaDBERERERKSg1GVlqbW0tdgmSB+Xmk3LzSbn5pNx8Um4+JSk3NRlZylxMRnxRbj4pN5+Um0/KzSfl5lOSclOTkSWdt98n5eaTcvNJufmk3HxSbj4lKTc1GSIiIiIiUlBqMrJkZsUuQfKg3HxSbj4pN5+Um0/Kzack5bbqF+PL13q7GJ+IiIiISJKtq4vxnS2GhoaKXYLkQbn5pNx8Um4+KTeflJtPScpNTUaWxsbGil2C5EG5+aTcfFJuPik3n5SbT0nKTU2GiIiIiIgUlJqMLNXU1BS7BMmDcvNJufmk3HxSbj4pN5+SlJsO/BYRERERkRXpwO9V0NvbW+wSJA/KzSfl5pNy80m5+aTcfEpSbmoysjQ3N1fsEiQPys0n5eaTcvNJufmk3HxKUm5qMkREREREpKDUZGSppaWl2CVIHpSbT8rNJ+Xmk3LzSbn5lKTc1GRkqaKiotglSB6Um0/KzSfl5pNy80m5+ZSk3NRkZOngwYPFLkHyoNx8Um4+KTeflJtPys2nJOWmJkNERERERApKTYaIiIiIiBSULsaXpbm5OVKpVLHLkBwpN5+Um0/KzSfl5pNy88l7broY3yoYGxsrdgmSB+Xmk3LzSbn5pNx8Um4+JSk3NRlZGh4eLnYJkgfl5pNy80m5+aTcfFJuPiUpNzUZIiIiIiJSUGoyspSk8xqfTZSbT8rNJ+Xmk3LzSbn5lKTcdOC3iIiIiIisSAd+rwI1PD4pN5+Um0/KzSfl5pNy8ylJuanJyNLU1FSxS5A8KDeflJtPys0n5eaTcvMpSbmpyRARERERkYJSk5GlpqamYpcgeVBuPik3n5SbT8rNJ+XmU5JyU5ORpcbGxmKXIHlQbj4pN5+Um0/KzSfl5lOSclOTkaWenp5ilyB5UG4+KTeflJtPys0n5eZTknJTkyEiIiIiIgWlJkNERERERApKTUaWWltbi12C5EG5+aTcfFJuPik3n5SbT0nKTU1Glubm5opdguRBufmk3HxSbj4pN5+Um09Jyk1NRpYGBweLXYLkQbn5pNx8Um4+KTeflJtPScpNTYaIiIiIiBSUmowslZTorfJIufmk3HxSbj4pN5+Um09Jys1CCMWu4aTa2trCoUOHil2GiIiIiIgAZtYXQmjLZtjktFNnKEn70J1NlJtPys0n5eaTcvNJufmUpNzUZGTp+PHjxS5B8qDcfFJuPik3n5SbT8rNpyTlpiZDREREREQKSk1Glmpra4tdguRBufmk3HxSbj4pN5+Um09Jys13kzE1BS96EZx3HuzZA895DvT2nnr4T3wCzj0Xdu+GG26AzAVRenth715oaIBLLz3pqFu2bCl09bIGlJtPys0n5eaTcvNJufmUpNzWpMkwsw+bWa+ZBTO7qKATv+EGePBB+OlP4XnPi+6fTE8P/MmfwJ13QmcnDAxETQdAfT386Z/C5z9/ytn09PQUtGxZG8rNJ+Xmk3LzSbn5pNx8SlJuqTWaz23A+4A7CzrVykq4+upH7l9+OXzoQ6eo4Db41V+FzZuj+699LbzvffCa10BzM1xxBezb96jRJiYmmJiYYGhoiJqamoKWL6tPufmUpAPjzibz8/PFLkHyoNx8Um4+JSm3NWkyQgj/F8DMVndGH/4wPP/5J3/uwAHYufOR++3t0WMruOuuu9i3bx/Dw8M0NzcXpk5ZM8rNp3PPPZdLLrmk2GWIiIhIntZqS8aKzOxG4MbM/fr6ejo7OwGorKykra2NQ4cOMTU1BUBzczMNDQ3xZqemW26h6cEHGf/a1xhKj1daWkpHRwcDAwNUjo4yV13N/OAgmzdv5uCBA2yZnf1/7d19cBz1fcfx90eSJVnPlm35UX7mye0QQkOTOCQ8hnbSAENpMrTlMYGEdlKYEjrDpB1IMmlJA3gSBlrC8BAoDQmFpk0oT6HFhZQEBoqNcZMQP8jPYPwgybIs2bK+/eNWl5NjSSdz9mrR5zVzo9u9ffiuvrt3973f/nZZv3o106ZNo6Kigp2bNzO5t5dNq1czf/582tvb2bx5Mzt37mTgpoUdHR35KnTixIlUVVXR3t5OYdwHDhxgz549QO7Ojk1NTezevZv9+/cDUFVVRW1tLTt37szPV1dXh6RBv+BOmjSJvXv35re5oqKChoaG34ihsrKSjo6OQTH09fXR3d1dkhi6u7vp7e0FYMKECdTX19Pe3k5/fz8ANTU1TJgwYVAMjY2N7N+/f8QYampq2LVrV36++vp6IoKurq78uObmZvbs2TNiDBUVFXR2dg6KoaKiIr+N5eXlNDY20tnZSV/SH6e6upqJEyeWJIba2lrKy8sHxdDU1ERvby979+4dNobq6upB+1F9fT39/f35/UgSkyZNoquri3379gFQWVlJXV0du3btyu+fxcQwsB8VxlDMvjyaGMrKygbtR01NTfT09Iy4Lw/EsG/fPlavXk1rayu9vb1s27YtP9+8efPYunVrPq6GhgZaWlpYs2ZNPobp06dTXl7O5s2b8zEsWLCAnTt35rdx4sSJzJo1iw0bNuS3Z/LkydTV1bF+/fr8fK2trfT09PDOO++MKoYZM2YgiS1btuSXtXDhQrZv354/Vmpqapg5cybr16/PHxdTpkyhpqaGDQU/gsyZM4fu7m62b98O5Pa/uXPnsmXLlvwx1tjYyJQpU1izZk1+vpkzZxIRbN26NZ/DhQsXsm3btvw+Ultby4wZM2hra8vvD1OnTqW6upqNGzfmlzV37ly6urrYsWNHPvdz5sxh8+bN+X2rsrKS/v5+1q5dm59v1qxZHDhwgLfeemtUMbS0tFBVVTUohnnz5tHZ2Zk/pquqqmhtbR302TBp0iSampoGnZIwa9Ys+vr68tenLysrY8GCBbz99tv5/bSuro7p06ezbt26/D7Z0tJCZWUlhTeGnT9/Ph0dHfkYivl8Apg9ezb79u3L78uFn08D7zX19fVMmzaNtWvX5t9XBj6fCvflgc+ngfetgRg2btyYf49qbm6moaGBtoJ+ikMdT2VlZfnPWx9PY+d4ampqorm5ecjjqaenhzVr1vh4YmwdTyPty3V1dezduzezx9NoHNU7fktqAz4ZEW+MNO2Qd/x+8EFYujT3/Npr4Yor4NZb4Xvfg2efhaamQy/wlltyHbzvvDM3/MQTudOlCk+RWrYMrr8eXnmlYNQyli1bRl9fHxUVY6YmsyI5b9m0ZMkSzjnnnLTDsFHq6emhuro67TBslJy3bHLesinreRvNHb+z9+3r0ktzjwFLl8LDDw9fYABceGGu38WNN0JLC9x1F1x00YirO+WUU1i8eDHr1q1j/vz5JdgAO5qct2wa+NXbsmXTpk0sWrQo7TBslJy3bHLesmk85S17RUahTZvgi1+EBQvgjDNy46qq4KWXcs+vvBLOOy/3WLAAvvIV+MhHoL8fzjwTPvvZ3HS9vbnL2vb2QkcHzJ4Nl1wCN99MbW0ttbW1dHZ20tLSks522mFz3rKp8HQvMzMzy56jUmRIuhM4H5gOPCupKyLefRk3ezYMd7rXPfcMHr7qqtzjYFVVuYLFzMzMzMzetaPaJ2M0huyTkZIDBw5QXl6edhg2Ss5bNjlv2eS8ZZPzlk3OWzZlPW+j6ZOR7Tt+H0WFV06y7HDessl5yybnLZuct2xy3rJpPOXNRUaRCi/1atnhvGWT85ZNzls2OW/Z5Lxl03jKm4sMMzMzMzMrKRcZRcryNY3HM+ctm5y3bHLessl5yybnLZvGU97c8dvMzMzMzEbkjt9HgAuebHLessl5yybnLZuct2xy3rJpPOXNRUaRenp60g7BDoPzlk3OWzY5b9nkvGWT85ZN4ylvLjLMzMzMzKykxmyfDEm9wDtpx1GgDuhKOwgbNectm5y3bHLessl5yybnLZuynrepEVFVzIRjtsgYayRtKraji40dzls2OW/Z5Lxlk/OWTc5bNo2nvPl0KTMzMzMzKykXGWZmZmZmVlIuMoq3NO0A7LA4b9nkvGWT85ZNzls2OW/ZNG7y5j4ZZmZmZmZWUm7JMDMzMzOzknKRYWZmZmZmJeUio0iS/k7SzyWtkPSypDPTjsmKI+kzklZK6pP0hbTjsaFJOkbSi5LeTI6zxWnHZCOTdLukNkkh6bfTjsdGJqla0r8lx9pySU9Jmpd2XDYySc9Iej3J2wuSTko7JiuepJvGy3uli4zivQCcHBHvA64CHpNUnXJMVpxXgU8D3007EBvRt4G7I+JY4BvAvSnHY8V5FDgVWJ92IDYqdwPHRcRJwOPJsI19n46IE5O83Qbcl3ZAVhxJJwMfAjakHcvR4CKjSBHxZETsTQZXAuXAlBRDsiJFxIqI+DnQn3YsNjRJLcDJwEPJqMeA+f51deyLiOcjYlPacVjxIqInIp6IX1/95WfAgjRjsuJERHvBYCP+bMsESVXAncCfA+PiqksVaQeQUVcAa/yhalZSrcCWiOgDiIiQtAGYA7SlGZjZOHAN8KO0g7DiSHoQOCMZ/P00Y7GifRV4KCLWSUo7lqPCRUZC0gvACUO8/P6I2JhMdxZwE/DxoxWbDa/Y3FkmHPzrzvh4JzZLkaQvAccAV6cdixUnIi4FkHQZcAvwiXQjsuFI+jBwCnBD2rEcTS4yEhHx0ZGmkXQacD9wbkT88shHZcUoJneWCRuB2ZIqIqJPuZ96Whkn566apUHS9cAfAmdHRHfa8djoRMQDku6SNDkidqQdjw3pNOB4YKAVYzbwtKQrI+LJVCM7gtwno0iSPgb8E3B+RKxIOx6z95qI2Aa8BlycjLoQaIuIttSCMnsPk3Qd8MfAxw86z9/GKEkNkmYWDF8A7AB2pheVjSQivh4RMyNiXkTMAzYBv/deLjDAd/wumqRfAQ3A1oLRl0TEypRCsiJJuhj4OjAJ2AfsIdca9VqqgdlvkHQc8B1gMtAJXBYRq1INykYk6U7gfGA6sB3oiohF6UZlw5E0m1zr4VpgdzK6NyI+mF5UNhJJreQuijGRXIfvd4DrI2J5qoHZqEhqAz4ZEW+kHcuR5CLDzMzMzMxKyqdLmZmZmZlZSbnIMDMzMzOzknKRYWZmZmZmJeUiw8zMzMzMSspFhpmZmZmZlZSLDDMzMzMzKykXGWZmKZJUIelGSb+QtCr5e7ekpqMcx+mSuiUtl/S6pJ9IOnGY6ZdLmngE1j3weDR57fKB54e57MslHVswfJ6kW0aYZ6ak5wqGvyyp8nBjMDMbjyrSDsDMbJy7F2gGPhwRuySVkbvbeTMw6C7Mkioiou8IxvJ/EfGBZF3XAvcDv3OoGCLipCO17hK7nNwNAt8EiIgfAj8cboaI2AKcUTDqJuBWcjfzNDOzIrglw8wsJZIWAZ8CroiIXQAR0R8R/xIRa5Nf+JdLul3ST4ELJE2T9ANJKyW9IelzybLKJN2RtISskPSqpGpJUyU9k0z/uqT7iwzvx8BxybK/k8TwFLAiGReS6pLnJ0h6Oln+65KuTsZPl/SIpJeT8V99l/+v6ZKeS7ZtVRKTktfOTdaxPPm/nC/pSuADwO3J+E8c3DIi6YrktRWSXpE0L3lsT16/K5n0xWS6OZLellRTsIyHJf3Zu9k2M7P3GrdkmJml52TgVxGxfZhpTgS+EBHXAEj6PvCLiLhAUgvwqqTlwH7gLGBxRPRLaiT3y/vFQFtEnJPM31xkbBcBrxYMnwp8LCK6CieSVAH8O/A3EfFIMm5K8vIDwN9GxPPJdI9LuiAifnCI9S1OtmPAUxFxw0HTtAPnRkSXpPJkvRcCjwJfA66OiBeT1qCGiGiXdDFwa0Q8nsR2eUHspwN/DXw0IrYWFA4tA9NExNWSPg8sGdh2Sc8CfwLcI2k6cDZw1SH/i2Zm45SLDDOzse3NiPhJwfDZwPsAImKbpH8lV1z8AzABuC/pT/AfSbHxM+AvJd0G/Dfw9DDrKvyi/yZwWcFrjxxcYCSOAyoGCowkru2SaoEzgWlJYwNAHXD8EOsu5nSpMuDvJZ0KiFwxsJxckfGfwDeTVopnImL50IvJ+wPgwYjYmsTdDVAQ71C+BXwbuAf4PPDdIf43ZmbjlosMM7P0/C9wjKTJEbFjiGkO9eU1Dh6OiA5JvwWcRq4/wc2SPhYRP5V0Erni5ELga5LeD3wfWJTMf1byd7gv+qP9El2WxHlKROwf5bxDuQ6YDHwwInokLQWqASLiumT7zwAekPTPEfGNEq13kIh4WVKPpNPItWCceSTWY2aWZe6TYWaWkohYDTwG3KvkalLKuVTSwiFmexYY6IcxFbgA+K/keW1EPAN8CWgj1zIxH+hKWhr+AjgWqIuIP4qIk5LHUAVOMX4J7JP0qYERkqZExG7gBeCGgvEzJc1+F+uaBLyVFBjTyPVnGVj28RGxKiLuAP4R+FDyUifQOMTyfgRcmpzyhKSawr4WBXYfYhnfAh4CVkXEm4e9RWZm71EuMszM0vUZcp2pX5K0ClgFLAGG+uJ/DXCipNeB58j1eXgZaAV+nIxfCbwBPAmczq/7bfwP8FcR0VGq4JOrXZ0PfG6gczm5FhOAPwVOSMavJFdQTR5iUYs1+BK2zx1imtuBJcm23Eeu4Bpwc9IZ/DXgEuDLyfi7gRsHOn4fFPvz5PpyPCNpBbnTyaYeYr23kSvklif9YCB3ilYdcMcQ22NmNq4p4uBWdzMzMxuOpN8l15JxfET0px2PmdlY4z4ZZmZmoyDpHuAc4EoXGGZmh+aWDDMzMzMzKyn3yTAzMzMzs5JykWFmZmZmZiXlIsPMzMzMzErKRYaZmZmZmZWUiwwzMzMzMyspFxlmZmZmZlZS/w+nOaIkFeHHAgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x106caac18>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>name</th>\n",
       "      <th>12 MacBook (Mid 2017, Silver)_CPE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ranking</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Apple MacBook Pro with Touch Bar - 13.3 - Core...</td>\n",
       "      <td>4.128415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Dell - XPS 2-in-1 13.3 Touch-Screen Laptop - I...</td>\n",
       "      <td>2.172169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Asus - 2-in-1 15.6 4K Ultra HD Touch-Screen La...</td>\n",
       "      <td>1.987359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12 MacBook (Mid 2017, Gold)</td>\n",
       "      <td>-1.904690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apple - MacBook Pro¨ - 13 Display - Intel Core...</td>\n",
       "      <td>-1.973667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Details About Openbox Excellent: Asus Rog Gl50...</td>\n",
       "      <td>-2.013038</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      name  \\\n",
       "ranking                                                      \n",
       "6        Apple MacBook Pro with Touch Bar - 13.3 - Core...   \n",
       "5        Dell - XPS 2-in-1 13.3 Touch-Screen Laptop - I...   \n",
       "4        Asus - 2-in-1 15.6 4K Ultra HD Touch-Screen La...   \n",
       "3                              12 MacBook (Mid 2017, Gold)   \n",
       "2        Apple - MacBook Pro¨ - 13 Display - Intel Core...   \n",
       "1        Details About Openbox Excellent: Asus Rog Gl50...   \n",
       "\n",
       "         12 MacBook (Mid 2017, Silver)_CPE  \n",
       "ranking                                     \n",
       "6                                 4.128415  \n",
       "5                                 2.172169  \n",
       "4                                 1.987359  \n",
       "3                                -1.904690  \n",
       "2                                -1.973667  \n",
       "1                                -2.013038  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "CPE_MacBook = divergent_plot(result ,result.columns[1], 'Ranking_Number', 'Cross-Price Elasticity' )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.2.7  Cross - Price Elasticity 12 MacBook (Mid 2017, Silver) Conclusion\n",
    "\n",
    "Regarding negative cross-price elasticities, it means that these products are complements not substitutes. In other words from our sample data, we can analyze that that when prices of 12 MacBook (Mid 2017, Gold), Macbook Pro 13 and Asus Q304 13.3 Laptop I5 goes up that means that our ad impression demand goes down.\n",
    "\n",
    "- As for instance an increase of **10%** in MacBook Pro 13 price, it will decreases our impression demand by **11.97%**\n",
    "\n",
    "Regarding positive cross-price elasticities, it means that these products are substitutes (main competitors). In other words from our sample data, we can analyze that the main competitors of 12 MacBook (Mid 2017, Gold) are Apple MacBook Pro, Dell - XPS 2-in-1 13.3 Touch-Screen Laptop  and Asus - 2-in-1 15.6 4K Ultra HD Touch-Screen.\n",
    "\n",
    "- As for instance, if Apple MacBook Pro with Touch Bar - 13.3 increases their price by **10%**, our impression demand would tend to increase up to **40%**\n",
    "\n",
    "As a conclusion, cross-price elasticities would help the marketer to measure price sensitivity in comparison with other products and will help to know main competitors in the field of pricing\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### References:\n",
    "- (Doe, 2019) Cost and Economics in Pricing Strategy  (John Doe, University of Virginia)\n",
    "- (OECD, 2003) OECD (https://stats.oecd.org/glossary/detail.asp?ID=3206)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "for column in result_df.columns[1:]:\n",
    "    test_largest = result_df.nlargest(3, column)[[column]]\n",
    "    test_smallest = result_df.nsmallest(3, column)[[column]]\n",
    "    frames = [test_smallest, test_largest]\n",
    "\n",
    "result = pd.concat(frames).reset_index()"
   ]
  }
 ],
 "metadata": {
  "hide_input": false,
  "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.6.4"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}