{ "cells": [ { "cell_type": "markdown", "id": "0dcfab92", "metadata": {}, "source": [ "# Ezega Data Analysis\n", "\n", "Author: [Meheret Samuel](https://github.com/senadev42)\n", "\n", "
\n", "\n", "### The Pre-amble\n", "A few months ago a friend of mine, [Kidus](https://github.com/kidesleo), decided to scrape ezega.com, which is a sort of index for bussinesses in ethiopia. The result was a jsonl file with about 8k entries that I've been sitting on with the vague goal of looking into but not finding the time to.\n", "\n", "Finally have time now, and while doing data analysis with clean datasets taken off the internet has been fun, it's not time to work with something dirty and real.\n" ] }, { "cell_type": "markdown", "id": "7cacfc79", "metadata": {}, "source": [ "## Setting Up\n", "\n", "First let's import the libraries we're going to be using." ] }, { "cell_type": "code", "execution_count": 1, "id": "72a842d4", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import re\n", "\n", "#This dataset has long columns\n", "pd.set_option('display.max_colwidth', None)" ] }, { "cell_type": "markdown", "id": "b70f614f", "metadata": {}, "source": [ "And then the file itself, setting lines=True to indicate that newlines are being used as a delimiter here because this is jsonl." ] }, { "cell_type": "code", "execution_count": 2, "id": "e31e0679", "metadata": {}, "outputs": [], "source": [ "df = pd.read_json('ezega_data.jsonl', lines=True)" ] }, { "cell_type": "markdown", "id": "a1de98a8", "metadata": {}, "source": [ "Now let's take a peek at our data set." ] }, { "cell_type": "code", "execution_count": 3, "id": "02ae8583", "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_category
0Bagel Corner Bakeryhttps://businessguide.ezega.com/images/noimage.pngAddis AbabaNoneNone[0116513067, 0911455510, +251116352780, 0115506104, 251116546674, +251111234015, +25111663949496]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765830&bid=732720&cid=788190AutoResources
1AWASH BAR & RESTURANThttps://businessguide.ezega.com/images/noimage.pngMekelleNoneNone[0344402815, 0344418248, 0344415657]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=762390&bid=383775&cid=786685AutoResources
2BITMAS General Trading PLChttps://businessguide.ezega.com/images/noimage.pngRas Desta Damtwe St. NTO Building, 3rd floor, No 20 and our shop is located behind Commercial CollegNoneNone[+251115501364, +251911516445+2510911133182, +251115549216, +251116674903, +251116691400, 011416878, +25111116022, +919726772088]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763250&bid=967715&cid=782170AutoWater Services
3ROB VIDEOhttps://businessguide.ezega.com/images/noimage.pngMekelleNoneNone[0344400112]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765615&bid=438170&cid=789910AutoWater Services
4Tesfa PLWHA Associationhttps://businessguide.ezega.com/images/noimage.pngAddis AbabaNoneNone[0467730206, 0116558830, 2511613426, 0115540391, 0116185992, 01115533010116554776]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766260&bid=803455&cid=769270AutoShipping Companies
\n", "
" ], "text/plain": [ " business_title \\\n", "0 Bagel Corner Bakery \n", "1 AWASH BAR & RESTURANT \n", "2 BITMAS General Trading PLC \n", "3 ROB VIDEO \n", "4 Tesfa PLWHA Association \n", "\n", " business_image \\\n", "0 https://businessguide.ezega.com/images/noimage.png \n", "1 https://businessguide.ezega.com/images/noimage.png \n", "2 https://businessguide.ezega.com/images/noimage.png \n", "3 https://businessguide.ezega.com/images/noimage.png \n", "4 https://businessguide.ezega.com/images/noimage.png \n", "\n", " business_location \\\n", "0 Addis Ababa \n", "1 Mekelle \n", "2 Ras Desta Damtwe St. NTO Building, 3rd floor, No 20 and our shop is located behind Commercial Colleg \n", "3 Mekelle \n", "4 Addis Ababa \n", "\n", " business_url business_description \\\n", "0 None None \n", "1 None None \n", "2 None None \n", "3 None None \n", "4 None None \n", "\n", " business_numbers \\\n", "0 [0116513067, 0911455510, +251116352780, 0115506104, 251116546674, +251111234015, +25111663949496] \n", "1 [0344402815, 0344418248, 0344415657] \n", "2 [+251115501364, +251911516445+2510911133182, +251115549216, +251116674903, +251116691400, 011416878, +25111116022, +919726772088] \n", "3 [0344400112] \n", "4 [0467730206, 0116558830, 2511613426, 0115540391, 0116185992, 01115533010116554776] \n", "\n", " ezega_url \\\n", "0 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765830&bid=732720&cid=788190 \n", "1 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=762390&bid=383775&cid=786685 \n", "2 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763250&bid=967715&cid=782170 \n", "3 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765615&bid=438170&cid=789910 \n", "4 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766260&bid=803455&cid=769270 \n", "\n", " category sub_category \n", "0 Auto Resources \n", "1 Auto Resources \n", "2 Auto Water Services \n", "3 Auto Water Services \n", "4 Auto Shipping Companies " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head()" ] }, { "cell_type": "markdown", "id": "1c6e14c9", "metadata": {}, "source": [ "As expected, it's a bit messy. \n", "\n", "At a glance, \n", "- `business_url` and `business_description` look like they have a lot of values missing, \n", "- the bussiness titles are inconsistently capitalized,\n", "- some of the locations are cities while some of them are full addresses\n", "- and the bussiness numbers are arrays that seem to be a mix of the Country Code +251 suffix and the simple, local 0 suffix\n", "- the categories don't seem super relevant to the companies name so I suspect it wasn't registered properly.\n", "\n", "And there's probably other stuff that isn't immediately apparent from this quick look through, but let's work on cleaning this up first." ] }, { "cell_type": "markdown", "id": "18983378", "metadata": {}, "source": [ "## Clean Up" ] }, { "cell_type": "markdown", "id": "e063aea4", "metadata": {}, "source": [ "### 1. Missing Values\n", "\n", "> business_url and business_description look like they have a lot of values missing\n", "\n", "Let's start up by seeing exactly how much is missing, and if there's any other fields that are missing data as well." ] }, { "cell_type": "code", "execution_count": 4, "id": "9513f907", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Number of columns: 8656\n" ] }, { "data": { "text/plain": [ "business_title 0\n", "business_image 0\n", "business_location 0\n", "business_url 6754\n", "business_description 7358\n", "business_numbers 0\n", "ezega_url 0\n", "category 0\n", "sub_category 0\n", "dtype: int64" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "print(\"Number of columns: \", df.shape[0])\n", "\n", "df.isnull().sum()" ] }, { "cell_type": "markdown", "id": "1843bb79", "metadata": {}, "source": [ "Okay, that's actually a lot of missing urls and descriptions. Dropping the rows in question isn't an option when they make up over half of our dataset, so we can just replace them with placeholders for now." ] }, { "cell_type": "code", "execution_count": 5, "id": "0aecc4c8", "metadata": {}, "outputs": [], "source": [ "df['business_url'] = df['business_url'].fillna('N/A')\n", "df['business_description'] = df['business_description'].fillna('No description available')" ] }, { "cell_type": "markdown", "id": "0fca76c1", "metadata": {}, "source": [ "Let's check again." ] }, { "cell_type": "code", "execution_count": 6, "id": "20395bcc", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "business_title 0\n", "business_image 0\n", "business_location 0\n", "business_url 0\n", "business_description 0\n", "business_numbers 0\n", "ezega_url 0\n", "category 0\n", "sub_category 0\n", "dtype: int64" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.isnull().sum()" ] }, { "cell_type": "code", "execution_count": 7, "id": "68cdbabc", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_category
0Bagel Corner Bakeryhttps://businessguide.ezega.com/images/noimage.pngAddis AbabaN/ANo description available[0116513067, 0911455510, +251116352780, 0115506104, 251116546674, +251111234015, +25111663949496]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765830&bid=732720&cid=788190AutoResources
1AWASH BAR & RESTURANThttps://businessguide.ezega.com/images/noimage.pngMekelleN/ANo description available[0344402815, 0344418248, 0344415657]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=762390&bid=383775&cid=786685AutoResources
2BITMAS General Trading PLChttps://businessguide.ezega.com/images/noimage.pngRas Desta Damtwe St. NTO Building, 3rd floor, No 20 and our shop is located behind Commercial CollegN/ANo description available[+251115501364, +251911516445+2510911133182, +251115549216, +251116674903, +251116691400, 011416878, +25111116022, +919726772088]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763250&bid=967715&cid=782170AutoWater Services
3ROB VIDEOhttps://businessguide.ezega.com/images/noimage.pngMekelleN/ANo description available[0344400112]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765615&bid=438170&cid=789910AutoWater Services
4Tesfa PLWHA Associationhttps://businessguide.ezega.com/images/noimage.pngAddis AbabaN/ANo description available[0467730206, 0116558830, 2511613426, 0115540391, 0116185992, 01115533010116554776]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766260&bid=803455&cid=769270AutoShipping Companies
\n", "
" ], "text/plain": [ " business_title \\\n", "0 Bagel Corner Bakery \n", "1 AWASH BAR & RESTURANT \n", "2 BITMAS General Trading PLC \n", "3 ROB VIDEO \n", "4 Tesfa PLWHA Association \n", "\n", " business_image \\\n", "0 https://businessguide.ezega.com/images/noimage.png \n", "1 https://businessguide.ezega.com/images/noimage.png \n", "2 https://businessguide.ezega.com/images/noimage.png \n", "3 https://businessguide.ezega.com/images/noimage.png \n", "4 https://businessguide.ezega.com/images/noimage.png \n", "\n", " business_location \\\n", "0 Addis Ababa \n", "1 Mekelle \n", "2 Ras Desta Damtwe St. NTO Building, 3rd floor, No 20 and our shop is located behind Commercial Colleg \n", "3 Mekelle \n", "4 Addis Ababa \n", "\n", " business_url business_description \\\n", "0 N/A No description available \n", "1 N/A No description available \n", "2 N/A No description available \n", "3 N/A No description available \n", "4 N/A No description available \n", "\n", " business_numbers \\\n", "0 [0116513067, 0911455510, +251116352780, 0115506104, 251116546674, +251111234015, +25111663949496] \n", "1 [0344402815, 0344418248, 0344415657] \n", "2 [+251115501364, +251911516445+2510911133182, +251115549216, +251116674903, +251116691400, 011416878, +25111116022, +919726772088] \n", "3 [0344400112] \n", "4 [0467730206, 0116558830, 2511613426, 0115540391, 0116185992, 01115533010116554776] \n", "\n", " ezega_url \\\n", "0 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765830&bid=732720&cid=788190 \n", "1 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=762390&bid=383775&cid=786685 \n", "2 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763250&bid=967715&cid=782170 \n", "3 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765615&bid=438170&cid=789910 \n", "4 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766260&bid=803455&cid=769270 \n", "\n", " category sub_category \n", "0 Auto Resources \n", "1 Auto Resources \n", "2 Auto Water Services \n", "3 Auto Water Services \n", "4 Auto Shipping Companies " ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head()" ] }, { "cell_type": "markdown", "id": "a060b294", "metadata": {}, "source": [ "Well that fixes that." ] }, { "cell_type": "markdown", "id": "7d431433", "metadata": {}, "source": [ "### 2. Cleaning the title\n", "\n", "> the bussiness titles are inconsistently capitalized,\n", "\n", "This would be somewhat of a non-issue if I didn't plan on doing some analysis on the names themselves later. And it frankly feels like a tricky issue to solve. Let's look at the bussiness_title column and see what we're working with first." ] }, { "cell_type": "code", "execution_count": 8, "id": "f53858ae", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Number of titles where all the words are capitalized\n", "3948\n" ] } ], "source": [ "def is_fully_capitalized(title):\n", " '''\n", " For every bussiness title:\n", " 1. Split it into words using space as a separator\n", " 2. Count the number of words int he title\n", " 3. Check if each word is capital, and count the number of fully capital words\n", " 4. If that is equal to the total amount of words then the title is full capitalized, return true\n", " '''\n", " words = title.split()\n", " total_words = len(words)\n", " capitalized_words = sum(word.isupper() for word in words)\n", " return capitalized_words == total_words\n", "\n", "fully_capitalized_titles = df[df['business_title'].apply(is_fully_capitalized)]\n", "\n", "print(\"Number of titles where all the words are capitalized\")\n", "print(fully_capitalized_titles['business_title'].shape[0])" ] }, { "cell_type": "markdown", "id": "a0770c23", "metadata": {}, "source": [ "Okay that's nearly half the titles. Also not very meaningful. \n", "\n", "Putting it in a binary yes-or-now way doesn't seem to be the best way of looking at this so let's look at a distribution instead.\n" ] }, { "cell_type": "code", "execution_count": 9, "id": "dacdf804", "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkQAAAHHCAYAAABeLEexAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8g+/7EAAAACXBIWXMAAA9hAAAPYQGoP6dpAABVUElEQVR4nO3deVwU9f8H8NfKsSC4IOeCcnmDggdehCkqgYqmqZXmgaaWfkFF/JJa3pWofb0y06w8Kik7PBJPFLzxQtFQJDUUCwFRAfEAhM/vjx7MzxVEQNhF5/V8PObxYGY+O5/37A7Li5nP7CqEEAJEREREMlZL1wUQERER6RoDEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRVdrs2bOhUCi00pePjw98fHyk+f3790OhUODXX3/VSv8jRoyAs7OzVvqqrNzcXIwePRpqtRoKhQIhISFa6ffJ1+bq1atQKBRYt26dVvqvbsXH2v79+6t0uwqFArNnz5bm161bB4VCgatXr1ZpP8/i7OyMESNGaLXPqlRV9VfX6/wsFf19efK4oarDQEQA/v/NuHgyMjKCvb09/P398fnnn+Pu3btV0k9qaipmz56N+Pj4KtleVarJtZXHvHnzsG7dOowbNw7ff/89hg0b9tS2zs7OGq/349PDhw+1WHX5XblyBe+//z4aNGgAIyMjqFQqeHt7Y9myZXjw4IFWa4mIiMDSpUu12qeuFBYWQqVSoW/fviXWLVmyBAqFAoGBgSXWzZw5EwqFAn/++ac2yqxRiv9ZfNb0+D8Sj9uxYwdDjw7o67oAqlnmzp0LFxcXFBQUIC0tDfv370dISAgWL16M33//HR4eHlLb6dOnY+rUqRXafmpqKubMmQNnZ2e0atWq3I/bs2dPhfqpjLJq+/rrr1FUVFTtNTyP6OhodOzYEbNmzSpX+1atWmHy5MkllhsaGlZ1ac9t+/btePPNN6FUKjF8+HC0aNEC+fn5OHz4MMLCwnD+/HmsXr26Wvru3LkzHjx4oPG8REREICEhoUrPwg0bNgyDBg2CUqmssm1WBT09PXTs2BFHjx4tse7IkSPQ19fHkSNHSl1nY2ODJk2aaKPM51ba61xZ/fv3R6NGjaT53NxcjBs3Dm+88Qb69+8vLbe1tYWTkxMePHgAAwMDafmOHTuwYsUKhiItYyAiDT179kTbtm2l+WnTpiE6Ohq9e/fG66+/jsTERBgbGwMA9PX1oa9fvYfQ/fv3Ubt2bZ3/kX78zaqmysjIgJubW7nb16tXD0OHDq3GiqpGcnIyBg0aBCcnJ0RHR8POzk5aFxQUhMuXL2P79u3V1n+tWrVgZGRUbdsvpqenBz09vWrvpzI6deqEqKgoJCYmwtXVVVp+5MgRvPXWW4iIiEBaWhrUajUA4NGjRzh+/Dj8/Pyeu+979+7BxMTkubfzLFX5Ont4eGj885iZmYlx48bBw8Oj1N85bRxf9Gy8ZEbP1K1bN8yYMQPXrl3DDz/8IC0vbQxRVFQUOnXqBHNzc5iamqJp06b48MMPAfx7jb5du3YAgJEjR0qnjYuvnfv4+KBFixaIi4tD586dUbt2bemxT45TKVZYWIgPP/wQarUaJiYmeP3113H9+nWNNk8bY/D4Np9VW2ljiO7du4fJkyfDwcEBSqUSTZs2xf/+9z8IITTaKRQKBAcHY8uWLWjRogWUSiWaN2+OXbt2lf6EPyEjIwOjRo2Cra0tjIyM0LJlS6xfv15aXzz2ITk5Gdu3b5dqf56xKE8bH1aZcS5r166FQqHAmTNnSqybN28e9PT08M8//zz18QsXLkRubi6+/fZbjTBUrFGjRpg4caJGf926dYONjQ2USiXc3NywcuXKEo9zdnZG7969sWfPHrRq1QpGRkZwc3PDpk2bNNo9ObbEx8cH27dvx7Vr16TnuvjYyM/Px8yZM+Hp6QkzMzOYmJjg1VdfRUxMzDOfpyef27Iuuzx+PBcVFWHp0qVo3rw5jIyMYGtri/fffx937tzR2L4QAp988gnq16+P2rVro2vXrjh//vwz6wL+DUQANM4E/fXXX0hLS0NwcDCMjIw01sXHx+PevXvS44B/z2C++uqrMDExgbm5Ofr27YvExESNfor3+cKFC3jnnXdQt25daRvlrb+goABz5sxB48aNYWRkBEtLSynQlaW0MUTF70kXLlxA165dUbt2bdSrVw8LFy4s1/NWHk+OIRoxYgRWrFgBABqveVn++ecfvPvuu7C1tZXeX9asWVOi3fLly9G8eXPUrl0bdevWRdu2bREREVFl+/Ki4xkiKpdhw4bhww8/xJ49ezBmzJhS25w/fx69e/eGh4cH5s6dC6VSicuXL0tvlK6urpg7dy5mzpyJ9957D6+++ioA4JVXXpG2cevWLfTs2RODBg3C0KFDYWtrW2Zdn376KRQKBaZMmYKMjAwsXboUvr6+iI+Pl85klUd5anucEAKvv/46YmJiMGrUKLRq1Qq7d+9GWFgY/vnnHyxZskSj/eHDh7Fp0yb85z//QZ06dfD5559jwIABSElJgaWl5VPrevDgAXx8fHD58mUEBwfDxcUFv/zyC0aMGIGsrCxMnDgRrq6u+P777zFp0iTUr19fugxmbW1d5j4XFBQgMzNTY1nt2rVRu3btZz5fFTFw4EAEBQVhw4YNaN26tca6DRs2wMfHB/Xq1Xvq47dt24YGDRo89bV40sqVK9G8eXO8/vrr0NfXx7Zt2/Cf//wHRUVFCAoK0mh76dIlvP322xg7diwCAwOxdu1avPnmm9i1axdee+21Urf/0UcfITs7G3///bf0OpuamgIAcnJy8M0332Dw4MEYM2YM7t69i2+//Rb+/v44ceJEhS4TP3nZBQDi4uKwdOlS2NjYSMvef/99rFu3DiNHjsSECROQnJyML774AmfOnMGRI0eks5szZ87EJ598gl69eqFXr144ffo0/Pz8kJ+f/8xaOnbsCH19fRw+fBijR48G8G84MjExQbt27dC2bVscOXIEAwYMkNYB/x+k9u7di549e6JBgwaYPXs2Hjx4gOXLl8Pb2xunT58u8c/Gm2++icaNG2PevHnSPxjlrX/27NkIDw/H6NGj0b59e+Tk5ODUqVM4ffr0U1/Tsty5cwc9evRA//798dZbb+HXX3/FlClT4O7ujp49e1Z4e8/y/vvvIzU1FVFRUfj++++f2T49PR0dO3aU/vGytrbGzp07MWrUKOTk5EiXdb/++mtMmDABAwcOxMSJE/Hw4UOcO3cOx48fxzvvvFPl+/FCEkRCiLVr1woA4uTJk09tY2ZmJlq3bi3Nz5o1Szx+CC1ZskQAEDdv3nzqNk6ePCkAiLVr15ZY16VLFwFArFq1qtR1Xbp0keZjYmIEAFGvXj2Rk5MjLf/5558FALFs2TJpmZOTkwgMDHzmNsuqLTAwUDg5OUnzW7ZsEQDEJ598otFu4MCBQqFQiMuXL0vLAAhDQ0ONZWfPnhUAxPLly0v09bilS5cKAOKHH36QluXn5wsvLy9hamqqse9OTk4iICCgzO093hZAiWnWrFlCiJKvbbHi4yQ5OVla9uTzmJycXOJ5HDx4sLC3txeFhYXSstOnTz/1+S6WnZ0tAIi+ffuWa7+EEOL+/fsllvn7+4sGDRpoLCt+Dn777TeN/uzs7DSO8+JjLSYmRloWEBCgcTwUe/TokcjLy9NYdufOHWFrayveffddjeWPP99ClP7cPu7mzZvC0dFRuLu7i9zcXCGEEIcOHRIAxIYNGzTa7tq1S2N5RkaGMDQ0FAEBAaKoqEhq9+GHHwoApf5+PKldu3aiYcOG0vz7778vunbtKoQQ4oMPPhDt2rWT1g0cOFDUrl1bFBQUCCGEaNWqlbCxsRG3bt2S2pw9e1bUqlVLDB8+XFpWfNwNHjxYo++K1N+yZcty/x48rrTXufg96bvvvpOW5eXlCbVaLQYMGFDubd+8ebPE612stN+XoKCgUn//hCh53IwaNUrY2dmJzMxMjXaDBg0SZmZm0u9D3759RfPmzctdsxzxkhmVm6mpaZl3m5mbmwMAtm7dWukByEqlEiNHjix3++HDh6NOnTrS/MCBA2FnZ4cdO3ZUqv/y2rFjB/T09DBhwgSN5ZMnT4YQAjt37tRY7uvri4YNG0rzHh4eUKlU+Ouvv57Zj1qtxuDBg6VlBgYGmDBhAnJzc3HgwIFK70OHDh0QFRWlMQ0fPrzS2yvL8OHDkZqaqnHpaMOGDTA2NpbOKpQmJycHADRe42d5/MxgdnY2MjMz0aVLF/z111/Izs7WaGtvb4833nhDmlepVBg+fDjOnDmDtLS0cvdZTE9PTxrvVlRUhNu3b+PRo0do27YtTp8+XeHtFSssLMTgwYNx9+5dbN68WRpT88svv8DMzAyvvfYaMjMzpcnT0xOmpqbS8713717k5+dj/PjxGpdfKjIovFOnTrhy5Yr0vBw5ckQ6a+ft7Y0zZ87g/v370roOHTpAX18fN27cQHx8PEaMGAELCwtpex4eHnjttddK/V0dO3asxnxF6jc3N8f58+dx6dKlcu9bWUxNTTXG/RgaGqJ9+/bP/N3VBiEEfvvtN/Tp0wdCCI1jwN/fH9nZ2dJxZ25ujr///hsnT57UcdU1FwMRlVtubm6Zf5jefvtteHt7Y/To0bC1tcWgQYPw888/Vygc1atXr0IDqBs3bqwxr1Ao0KhRo2r/LJdr167B3t6+xPNRPOD02rVrGssdHR1LbKNu3bolxnmU1k/jxo1Rq5bmr+rT+qkIKysr+Pr6akwNGjSo9PbK8tprr8HOzg4bNmwA8G9Y+PHHH9G3b98yjymVSgUAFfrYhyNHjsDX11caq2JtbS2NRXsyEDVq1KjE+Iziu6IqewytX78eHh4e0vgVa2trbN++vUTfFTF9+nRER0cjIiJCI1hfunQJ2dnZsLGxgbW1tcaUm5uLjIwMAP9/nDz5+2JtbY26deuWq4bHxxFlZWXh/Pnz8Pb2BvDvpeVHjx7hxIkTSE5Oxo0bN6T2xX03bdq0xDZdXV2RmZmJe/fuaSx3cXHRmK9I/XPnzkVWVhaaNGkCd3d3hIWF4dy5c+Xax9LUr1+/xDFSnt9dbbh58yaysrKwevXqEq9/8T+WxcfAlClTYGpqivbt26Nx48YICgoq9e5AOeMYIiqXv//+G9nZ2SXGNDzO2NgYBw8eRExMDLZv345du3Zh48aN6NatG/bs2VOuO2gqMu6nvJ42ILGwsFBrd/U8rR/xxADsmqKs56wy9PT08M477+Drr7/Gl19+iSNHjiA1NfWZd7mpVCrY29sjISGhXP1cuXIF3bt3R7NmzbB48WI4ODjA0NAQO3bswJIlS6r9oxN++OEHjBgxAv369UNYWBhsbGygp6eH8PBwXLlypVLb3LJlCxYsWICPP/4YPXr00FhXVFQEGxsbKWg+6VnjyCqiOOAcPnxYGmfm5eUF4N9w3bhxYxw+fFi6qeHxAdUV9TzvA507d8aVK1ewdetW7NmzB9988w2WLFmCVatWSeOfKqIm/+4WH89Dhw4t9bOgAEh3u7m6uiIpKQmRkZHYtWsXfvvtN3z55ZeYOXMm5syZo7WaazIGIiqX4sF9/v7+ZbarVasWunfvju7du2Px4sWYN28ePvroI8TExMDX17fKP9n6ydPiQghcvnxZ45bXunXrIisrq8Rjr127pnFGpCK1OTk5Ye/evbh7967GGY6LFy9K66uCk5MTzp07h6KiIo2zRFXdz5OK/+vOysqSLoUCz3dGavjw4Vi0aBG2bduGnTt3wtra+pnHEwD07t0bq1evRmxsrPQH+Gm2bduGvLw8/P777xpn5Z52l9fly5chhNB47Ys/SLCsTyZ/2rHy66+/okGDBti0aZNGm/J+NtST/vzzTwQGBqJfv37SWa7HNWzYEHv37oW3t3eZIaL4OLl06ZLGMX/z5s1yn+mwsbGRQo+JiQnc3Nw0jo1XXnkFR44cwd9//w09PT3ptSruOykpqcQ2L168CCsrq2feVl/R+i0sLDBy5EiMHDkSubm56Ny5M2bPnl2pQKQL5X0vsra2Rp06dVBYWAhfX99ntjcxMcHbb7+Nt99+G/n5+ejfvz8+/fRTTJs2jbf+g5fMqByio6Px8ccfw8XFBUOGDHlqu9u3b5dYVnxXTV5eHgBIb3ylBZTK+O677zQup/z666+4ceOGxt0fDRs2xLFjxzTuRomMjCxxe35FauvVqxcKCwvxxRdfaCwv/uTeqrr7pFevXkhLS8PGjRulZY8ePcLy5cthamqKLl26VEk/Tyq+LHPw4EFp2b179zRu96+o4s9m+eabb/Dbb79h0KBB5focqw8++AAmJiYYPXo00tPTS6y/cuUKli1bBuD//5t//L/37OxsrF27ttRtp6amYvPmzdJ8Tk4OvvvuO7Rq1Ur6TJ3SmJiYlHoJrLT+jx8/jtjY2LJ2sVS5ubl44403UK9ePaxfv77UP5JvvfUWCgsL8fHHH5dY9+jRI+lY9vX1hYGBAZYvX65RW0U/bbtTp06Ij4/Hnj17Stz198orryA2NhaHDh2Ch4eH9I+CnZ0dWrVqhfXr12v8biUkJGDPnj3o1avXM/utSP23bt3SmDc1NUWjRo2k96AXQXnfi/T09DBgwAD89ttvpZ5FvXnzpvTzk8+LoaEh3NzcIIRAQUHB8xf9EuAZItKwc+dOXLx4EY8ePUJ6ejqio6MRFRUFJycn/P7772X+FzF37lwcPHgQAQEBcHJyQkZGBr788kvUr19fOn3esGFDmJubY9WqVahTpw5MTEzQoUOHEmMGysvCwgKdOnXCyJEjkZ6ejqVLl6JRo0YaHw0wevRo/Prrr+jRowfeeustXLlyBT/88IPGWIyK1tanTx907doVH330Ea5evYqWLVtiz5492Lp1K0JCQkpsu7Lee+89fPXVVxgxYgTi4uLg7OyMX3/9FUeOHMHSpUsrNNi4Ivz8/ODo6IhRo0YhLCwMenp6WLNmDaytrZGSklLp7Q4fPhz//e9/AaDcHwrZsGFDRERE4O2334arq6vGJ1UfPXpU+hiC4roNDQ3Rp08fvP/++8jNzcXXX38NGxsb3Lhxo8S2mzRpglGjRuHkyZOwtbXFmjVrkJ6e/tQAVczT0xMbN25EaGgo2rVrB1NTU/Tp0we9e/fGpk2b8MYbbyAgIADJyclYtWoV3NzckJubW6Hnas6cObhw4QKmT5+OrVu3lnhOvLy80KVLF7z//vsIDw9HfHw8/Pz8YGBggEuXLuGXX37BsmXLMHDgQFhbW+O///0vwsPD0bt3b/Tq1QtnzpzBzp07YWVlVe6aOnXqhLVr1+LkyZMlPsLglVdeQXZ2NrKzszF+/HiNdZ999hl69uwJLy8vjBo1Srrt3szMrFyfxlyR+t3c3ODj4wNPT09YWFjg1KlT+PXXXxEcHFzu/dQ1T09PAMCECRPg7+8PPT09DBo0qNS28+fPR0xMDDp06IAxY8bAzc0Nt2/fxunTp7F3717pH1U/Pz+o1Wp4e3vD1tYWiYmJ+OKLLxAQEFBt7yMvHN3c3EY1TfEtv8WToaGhUKvV4rXXXhPLli3TuL272JO3Zu/bt0/07dtX2NvbC0NDQ2Fvby8GDx4s/vzzT43Hbd26Vbi5uQl9fX2N2027dOny1NtCn3bb/Y8//iimTZsmbGxshLGxsQgICBDXrl0r8fhFixaJevXqCaVSKby9vcWpU6dKbLOs2p687V4IIe7evSsmTZok7O3thYGBgWjcuLH47LPPNG4LFuLf22SDgoJK1PS0jwN4Unp6uhg5cqSwsrIShoaGwt3dvdRb1St62/2z2sbFxYkOHToIQ0ND4ejoKBYvXlzp2+6L3bhxQ+jp6YkmTZqUq87H/fnnn2LMmDHC2dlZGBoaijp16ghvb2+xfPly8fDhQ6nd77//Ljw8PISRkZFwdnYWCxYsEGvWrClRd/FzsHv3buHh4SGUSqVo1qyZ+OWXXzT6Le127NzcXPHOO+8Ic3NzAUA6NoqKisS8efOEk5OTUCqVonXr1iIyMrLU4wfPuO0+MDCw1I9GQCm3ya9evVp4enoKY2NjUadOHeHu7i4++OADkZqaKrUpLCwUc+bMEXZ2dsLY2Fj4+PiIhISEch+HQgiRlJQk1fDk73VRUZH0fGzcuLHEY/fu3Su8vb2FsbGxUKlUok+fPuLChQsabYrfU0r76I7y1v/JJ5+I9u3bC3Nzc2FsbCyaNWsmPv30U5Gfn1/mvj3ttvvS3pNKez3LUtHb7h89eiTGjx8vrK2thUKh0HifLW076enpIigoSDg4OAgDAwOhVqtF9+7dxerVq6U2X331lejcubOwtLQUSqVSNGzYUISFhYns7Oxy78fLTiFEDRgZRkSykJmZCTs7O8ycORMzZszQaS3Ozs5o0aIFIiMjdVoHEdUMHENERFqzbt06FBYWYtiwYbouhYhIA8cQEVG1i46OxoULF/Dpp5+iX79+Zd7BRUSkCwxERFTt5s6di6NHj8Lb2xvLly/XdTlERCVwDBERERHJHscQERERkewxEBEREZHscQxRORQVFSE1NRV16tSp8q+eICIiouohhMDdu3dhb29f4kuyn8RAVA6pqalwcHDQdRlERERUCdevX0f9+vXLbMNAVA7FH2t+/fp1qFQqHVdDRERE5ZGTkwMHB4dyfT0JA1E5FF8mU6lUDEREREQvmPIMd+GgaiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPX1dF0BASkoKMjMztd6vlZUVHB0dtd4vERFRTcNApGMpKSlo2swVDx/c13rfRsa1kXQxkaGIiIhkj4FIxzIzM/HwwX1Y9p4MA0sHrfVbcOs6bkUuQmZmJgMRERHJHgNRDWFg6QClupGuyyAiIpIlDqomIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItnTaSBauXIlPDw8oFKpoFKp4OXlhZ07d0rrHz58iKCgIFhaWsLU1BQDBgxAenq6xjZSUlIQEBCA2rVrw8bGBmFhYXj06JFGm/3796NNmzZQKpVo1KgR1q1bp43dIyIioheETgNR/fr1MX/+fMTFxeHUqVPo1q0b+vbti/PnzwMAJk2ahG3btuGXX37BgQMHkJqaiv79+0uPLywsREBAAPLz83H06FGsX78e69atw8yZM6U2ycnJCAgIQNeuXREfH4+QkBCMHj0au3fv1vr+EhERUc2kEEIIXRfxOAsLC3z22WcYOHAgrK2tERERgYEDBwIALl68CFdXV8TGxqJjx47YuXMnevfujdTUVNja2gIAVq1ahSlTpuDmzZswNDTElClTsH37diQkJEh9DBo0CFlZWdi1a1e5asrJyYGZmRmys7OhUqmqdH9Pnz4NT09PqAOXQqluVKXbLkte2mWkrQ9BXFwc2rRpo7V+iYiItKUif79rzBiiwsJC/PTTT7h37x68vLwQFxeHgoIC+Pr6Sm2aNWsGR0dHxMbGAgBiY2Ph7u4uhSEA8Pf3R05OjnSWKTY2VmMbxW2Kt0FERESkr+sC/vjjD3h5eeHhw4cwNTXF5s2b4ebmhvj4eBgaGsLc3Fyjva2tLdLS0gAAaWlpGmGoeH3xurLa5OTk4MGDBzA2Ni5RU15eHvLy8qT5nJyc595PIiIiqrl0foaoadOmiI+Px/HjxzFu3DgEBgbiwoULOq0pPDwcZmZm0uTg4KDTeoiIiKh66TwQGRoaolGjRvD09ER4eDhatmyJZcuWQa1WIz8/H1lZWRrt09PToVarAQBqtbrEXWfF889qo1KpSj07BADTpk1Ddna2NF2/fr0qdpWIiIhqKJ0HoicVFRUhLy8Pnp6eMDAwwL59+6R1SUlJSElJgZeXFwDAy8sLf/zxBzIyMqQ2UVFRUKlUcHNzk9o8vo3iNsXbKI1SqZQ+CqB4IiIiopeXTscQTZs2DT179oSjoyPu3r2LiIgI7N+/H7t374aZmRlGjRqF0NBQWFhYQKVSYfz48fDy8kLHjh0BAH5+fnBzc8OwYcOwcOFCpKWlYfr06QgKCoJSqQQAjB07Fl988QU++OADvPvuu4iOjsbPP/+M7du363LXiYiIqAbRaSDKyMjA8OHDcePGDZiZmcHDwwO7d+/Ga6+9BgBYsmQJatWqhQEDBiAvLw/+/v748ssvpcfr6ekhMjIS48aNg5eXF0xMTBAYGIi5c+dKbVxcXLB9+3ZMmjQJy5YtQ/369fHNN9/A399f6/tLRERENVON+xyimoifQ0RERPTieSE/h4iIiIhIVxiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPZ0GojCw8PRrl071KlTBzY2NujXrx+SkpI02vj4+EChUGhMY8eO1WiTkpKCgIAA1K5dGzY2NggLC8OjR4802uzfvx9t2rSBUqlEo0aNsG7duurePSIiInpB6DQQHThwAEFBQTh27BiioqJQUFAAPz8/3Lt3T6PdmDFjcOPGDWlauHChtK6wsBABAQHIz8/H0aNHsX79eqxbtw4zZ86U2iQnJyMgIABdu3ZFfHw8QkJCMHr0aOzevVtr+0pEREQ1l74uO9+1a5fG/Lp162BjY4O4uDh07txZWl67dm2o1epSt7Fnzx5cuHABe/fuha2tLVq1aoWPP/4YU6ZMwezZs2FoaIhVq1bBxcUFixYtAgC4urri8OHDWLJkCfz9/atvB4mIiOiFUKPGEGVnZwMALCwsNJZv2LABVlZWaNGiBaZNm4b79+9L62JjY+Hu7g5bW1tpmb+/P3JycnD+/Hmpja+vr8Y2/f39ERsbW2odeXl5yMnJ0ZiIiIjo5aXTM0SPKyoqQkhICLy9vdGiRQtp+TvvvAMnJyfY29vj3LlzmDJlCpKSkrBp0yYAQFpamkYYAiDNp6WlldkmJycHDx48gLGxsca68PBwzJkzp8r3kYiIiGqmGhOIgoKCkJCQgMOHD2ssf++996Sf3d3dYWdnh+7du+PKlSto2LBhtdQybdo0hIaGSvM5OTlwcHColr6IiIhI92rEJbPg4GBERkYiJiYG9evXL7Nthw4dAACXL18GAKjVaqSnp2u0KZ4vHnf0tDYqlarE2SEAUCqVUKlUGhMRERG9vHQaiIQQCA4OxubNmxEdHQ0XF5dnPiY+Ph4AYGdnBwDw8vLCH3/8gYyMDKlNVFQUVCoV3NzcpDb79u3T2E5UVBS8vLyqaE+IiIjoRabTQBQUFIQffvgBERERqFOnDtLS0pCWloYHDx4AAK5cuYKPP/4YcXFxuHr1Kn7//XcMHz4cnTt3hoeHBwDAz88Pbm5uGDZsGM6ePYvdu3dj+vTpCAoKglKpBACMHTsWf/31Fz744ANcvHgRX375JX7++WdMmjRJZ/tORERENYdOA9HKlSuRnZ0NHx8f2NnZSdPGjRsBAIaGhti7dy/8/PzQrFkzTJ48GQMGDMC2bdukbejp6SEyMhJ6enrw8vLC0KFDMXz4cMydO1dq4+Ligu3btyMqKgotW7bEokWL8M033/CWeyIiIgKg40HVQogy1zs4OODAgQPP3I6TkxN27NhRZhsfHx+cOXOmQvURERGRPNSIQdVEREREusRARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREsqfTQBQeHo527dqhTp06sLGxQb9+/ZCUlKTR5uHDhwgKCoKlpSVMTU0xYMAApKena7RJSUlBQEAAateuDRsbG4SFheHRo0cabfbv3482bdpAqVSiUaNGWLduXXXvHhEREb0gdBqIDhw4gKCgIBw7dgxRUVEoKCiAn58f7t27J7WZNGkStm3bhl9++QUHDhxAamoq+vfvL60vLCxEQEAA8vPzcfToUaxfvx7r1q3DzJkzpTbJyckICAhA165dER8fj5CQEIwePRq7d+/W6v4SERFRzaQQQghdF1Hs5s2bsLGxwYEDB9C5c2dkZ2fD2toaERERGDhwIADg4sWLcHV1RWxsLDp27IidO3eid+/eSE1Nha2tLQBg1apVmDJlCm7evAlDQ0NMmTIF27dvR0JCgtTXoEGDkJWVhV27dj2zrpycHJiZmSE7OxsqlapK9/n06dPw9PSEOnAplOpGVbrtsuSlXUba+hDExcWhTZs2WuuXiIhIWyry97tGjSHKzs4GAFhYWAAA4uLiUFBQAF9fX6lNs2bN4OjoiNjYWABAbGws3N3dpTAEAP7+/sjJycH58+elNo9vo7hN8TaIiIhI3vR1XUCxoqIihISEwNvbGy1atAAApKWlwdDQEObm5hptbW1tkZaWJrV5PAwVry9eV1abnJwcPHjwAMbGxhrr8vLykJeXJ83n5OQ8/w4SERFRjVVjzhAFBQUhISEBP/30k65LQXh4OMzMzKTJwcFB1yURERFRNaoRgSg4OBiRkZGIiYlB/fr1peVqtRr5+fnIysrSaJ+eng61Wi21efKus+L5Z7VRqVQlzg4BwLRp05CdnS1N169ff+59JCIioppLp4FICIHg4GBs3rwZ0dHRcHFx0Vjv6ekJAwMD7Nu3T1qWlJSElJQUeHl5AQC8vLzwxx9/ICMjQ2oTFRUFlUoFNzc3qc3j2yhuU7yNJymVSqhUKo2JiIiIXl46HUMUFBSEiIgIbN26FXXq1JHG/JiZmcHY2BhmZmYYNWoUQkNDYWFhAZVKhfHjx8PLywsdO3YEAPj5+cHNzQ3Dhg3DwoULkZaWhunTpyMoKAhKpRIAMHbsWHzxxRf44IMP8O677yI6Oho///wztm/frrN9JyIioppDp2eIVq5ciezsbPj4+MDOzk6aNm7cKLVZsmQJevfujQEDBqBz585Qq9XYtGmTtF5PTw+RkZHQ09ODl5cXhg4diuHDh2Pu3LlSGxcXF2zfvh1RUVFo2bIlFi1ahG+++Qb+/v5a3V8iIiKqmXR6hqg8H4FkZGSEFStWYMWKFU9t4+TkhB07dpS5HR8fH5w5c6bCNRIREdHLr0YMqiYiIiLSJQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpK9SgWiBg0a4NatWyWWZ2VloUGDBs9dFBEREZE2VSoQXb16FYWFhSWW5+Xl4Z9//nnuooiIiIi0qULfZfb7779LP+/evRtmZmbSfGFhIfbt2wdnZ+cqK46IiIhIGyoUiPr16wcAUCgUCAwM1FhnYGAAZ2dnLFq0qMqKIyIiItKGCgWioqIiAICLiwtOnjwJKyuraimKiIiISJsqFIiKJScnV3UdRERERDpTqUAEAPv27cO+ffuQkZEhnTkqtmbNmucujIiIiEhbKhWI5syZg7lz56Jt27aws7ODQqGo6rqIiIiItKZSgWjVqlVYt24dhg0bVtX1EBEREWldpT6HKD8/H6+88kpV10JERESkE5UKRKNHj0ZERERV10JERESkE5W6ZPbw4UOsXr0ae/fuhYeHBwwMDDTWL168uEqKI6pKKSkpyMzM1Hq/VlZWcHR01Hq/RERUfpUKROfOnUOrVq0AAAkJCRrrOMCaaqKUlBQ0beaKhw/ua71vI+PaSLqYyFBERFSDVSoQxcTEVHUdRNUqMzMTDx/ch2XvyTCwdNBavwW3ruNW5CJkZmYyEBER1WCV/hwioheRgaUDlOpGui6DiIhqmEoFoq5du5Z5aSw6OrrSBRERERFpW6UCUfH4oWIFBQWIj49HQkJCiS99JSIiIqrpKhWIlixZUury2bNnIzc397kKIiIiItK2Sn0O0dMMHTqU32NGREREL5wqDUSxsbEwMjKqyk0SERERVbtKXTLr37+/xrwQAjdu3MCpU6cwY8aMKimMiIiISFsqFYjMzMw05mvVqoWmTZti7ty58PPzq5LCiIiIiLSlUoFo7dq1VV0HERERkc481wczxsXFITExEQDQvHlztG7dukqKIiIiItKmSgWijIwMDBo0CPv374e5uTkAICsrC127dsVPP/0Ea2vrqqyRiIiIqFpV6i6z8ePH4+7duzh//jxu376N27dvIyEhATk5OZgwYUJV10hERERUrSp1hmjXrl3Yu3cvXF1dpWVubm5YsWIFB1UTERHRC6dSZ4iKiopgYGBQYrmBgQGKioqeuygiIiIibapUIOrWrRsmTpyI1NRUadk///yDSZMmoXv37lVWHBEREZE2VCoQffHFF8jJyYGzszMaNmyIhg0bwsXFBTk5OVi+fHlV10hERERUrSo1hsjBwQGnT5/G3r17cfHiRQCAq6srfH19q7Q4IiIiIm2o0Bmi6OhouLm5IScnBwqFAq+99hrGjx+P8ePHo127dmjevDkOHTpUXbUSERERVYsKBaKlS5dizJgxUKlUJdaZmZnh/fffx+LFi6usOCIiIiJtqFAgOnv2LHr06PHU9X5+foiLi3vuooiIiIi0qUKBKD09vdTb7Yvp6+vj5s2bz10UERERkTZVKBDVq1cPCQkJT11/7tw52NnZlXt7Bw8eRJ8+fWBvbw+FQoEtW7ZorB8xYgQUCoXG9OQZqtu3b2PIkCFQqVQwNzfHqFGjkJubW6KuV199FUZGRnBwcMDChQvLXSMRERG9/CoUiHr16oUZM2bg4cOHJdY9ePAAs2bNQu/evcu9vXv37qFly5ZYsWLFU9v06NEDN27ckKYff/xRY/2QIUNw/vx5REVFITIyEgcPHsR7770nrc/JyYGfnx+cnJwQFxeHzz77DLNnz8bq1avLXScRERG93Cp02/306dOxadMmNGnSBMHBwWjatCkA4OLFi1ixYgUKCwvx0UcflXt7PXv2RM+ePctso1QqoVarS12XmJiIXbt24eTJk2jbti0AYPny5ejVqxf+97//wd7eHhs2bEB+fj7WrFkDQ0NDNG/eHPHx8Vi8eLFGcCIiIiL5qtAZIltbWxw9ehQtWrTAtGnT8MYbb+CNN97Ahx9+iBYtWuDw4cOwtbWt0gL3798PGxsbNG3aFOPGjcOtW7ekdbGxsTA3N5fCEAD4+vqiVq1aOH78uNSmc+fOMDQ0lNr4+/sjKSkJd+7cKbXPvLw85OTkaExERET08qrwBzM6OTlhx44duHPnDi5fvgwhBBo3boy6detWeXE9evRA//794eLigitXruDDDz9Ez549ERsbCz09PaSlpcHGxkbjMfr6+rCwsEBaWhoAIC0tDS4uLhptikNbWlpaqXWHh4djzpw5Vb4/REREVDNV6pOqAaBu3bpo165dVdZSwqBBg6Sf3d3d4eHhgYYNG2L//v3V+p1p06ZNQ2hoqDSfk5MDBweHauuPiIiIdKtS32WmKw0aNICVlRUuX74MAFCr1cjIyNBo8+jRI9y+fVsad6RWq5Genq7Rpnj+aWOTlEolVCqVxkREREQvrxcqEP3999+4deuWdGu/l5cXsrKyND4MMjo6GkVFRejQoYPU5uDBgygoKJDaREVFoWnTptVymY+IiIhePDoNRLm5uYiPj0d8fDwAIDk5GfHx8UhJSUFubi7CwsJw7NgxXL16Ffv27UPfvn3RqFEj+Pv7A/j3C2V79OiBMWPG4MSJEzhy5AiCg4MxaNAg2NvbAwDeeecdGBoaYtSoUTh//jw2btyIZcuWaVwSIyIiInnTaSA6deoUWrdujdatWwMAQkND0bp1a8ycORN6eno4d+4cXn/9dTRp0gSjRo2Cp6cnDh06BKVSKW1jw4YNaNasGbp3745evXqhU6dOGp8xZGZmhj179iA5ORmenp6YPHkyZs6cyVvuiYiISFLpQdVVwcfHB0KIp67fvXv3M7dhYWGBiIiIMtt4eHjg0KFDFa6PiIiI5OGFGkNEREREVB0YiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPZ0GogOHjyIPn36wN7eHgqFAlu2bNFYL4TAzJkzYWdnB2NjY/j6+uLSpUsabW7fvo0hQ4ZApVLB3Nwco0aNQm5urkabc+fO4dVXX4WRkREcHBywcOHC6t41IiIieoHoNBDdu3cPLVu2xIoVK0pdv3DhQnz++edYtWoVjh8/DhMTE/j7++Phw4dSmyFDhuD8+fOIiopCZGQkDh48iPfee09an5OTAz8/Pzg5OSEuLg6fffYZZs+ejdWrV1f7/hEREdGLQV+Xnffs2RM9e/YsdZ0QAkuXLsX06dPRt29fAMB3330HW1tbbNmyBYMGDUJiYiJ27dqFkydPom3btgCA5cuXo1evXvjf//4He3t7bNiwAfn5+VizZg0MDQ3RvHlzxMfHY/HixRrBiYiIiOSrxo4hSk5ORlpaGnx9faVlZmZm6NChA2JjYwEAsbGxMDc3l8IQAPj6+qJWrVo4fvy41KZz584wNDSU2vj7+yMpKQl37tzR0t4QERFRTabTM0RlSUtLAwDY2tpqLLe1tZXWpaWlwcbGRmO9vr4+LCwsNNq4uLiU2Ebxurp165boOy8vD3l5edJ8Tk7Oc+4NERER1WQ19gyRLoWHh8PMzEyaHBwcdF0SERERVaMaG4jUajUAID09XWN5enq6tE6tViMjI0Nj/aNHj3D79m2NNqVt4/E+njRt2jRkZ2dL0/Xr159/h4iIiKjGqrGXzFxcXKBWq7Fv3z60atUKwL+Xro4fP45x48YBALy8vJCVlYW4uDh4enoCAKKjo1FUVIQOHTpIbT766CMUFBTAwMAAABAVFYWmTZuWerkMAJRKJZRKZTXvoXylpKQgMzNTq30mJiZqtT8iInqx6DQQ5ebm4vLly9J8cnIy4uPjYWFhAUdHR4SEhOCTTz5B48aN4eLighkzZsDe3h79+vUDALi6uqJHjx4YM2YMVq1ahYKCAgQHB2PQoEGwt7cHALzzzjuYM2cORo0ahSlTpiAhIQHLli3DkiVLdLHLspeSkoKmzVzx8MF9XZdCREQk0WkgOnXqFLp27SrNh4aGAgACAwOxbt06fPDBB7h37x7ee+89ZGVloVOnTti1axeMjIykx2zYsAHBwcHo3r07atWqhQEDBuDzzz+X1puZmWHPnj0ICgqCp6cnrKysMHPmTN5yryOZmZl4+OA+LHtPhoGl9sZmPfjrFLIP/aC1/p6kizNUVlZWcHR01Hq/REQvIp0GIh8fHwghnrpeoVBg7ty5mDt37lPbWFhYICIiosx+PDw8cOjQoUrXSVXPwNIBSnUjrfVXcEs348AKc+8ACgWGDh2q9b6NjGsj6WIiQxERUTnU2DFERC+DorxcQAitnxEruHUdtyIXITMzk4GIiKgcGIiItEDbZ8SIiKhiauxt90RERETawjNEMqftwb68/Z2IiGoiBiKZ0uVgXyIiopqGgUimdDXYV9e3vxMREZWGgUjm5HL7OxERUVk4qJqIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkj4GIiIiIZI+BiIiIiGSPgYiIiIhkr0YHotmzZ0OhUGhMzZo1k9Y/fPgQQUFBsLS0hKmpKQYMGID09HSNbaSkpCAgIAC1a9eGjY0NwsLC8OjRI23vChEREdVg+rou4FmaN2+OvXv3SvP6+v9f8qRJk7B9+3b88ssvMDMzQ3BwMPr3748jR44AAAoLCxEQEAC1Wo2jR4/ixo0bGD58OAwMDDBv3jyt7wsRERHVTDU+EOnr60OtVpdYnp2djW+//RYRERHo1q0bAGDt2rVwdXXFsWPH0LFjR+zZswcXLlzA3r17YWtri1atWuHjjz/GlClTMHv2bBgaGmp7d4iIiKgGqvGB6NKlS7C3t4eRkRG8vLwQHh4OR0dHxMXFoaCgAL6+vlLbZs2awdHREbGxsejYsSNiY2Ph7u4OW1tbqY2/vz/GjRuH8+fPo3Xr1qX2mZeXh7y8PGk+Jyen+naQqBolJiZqvU8rKys4OjpqvV8ioudRowNRhw4dsG7dOjRt2hQ3btzAnDlz8OqrryIhIQFpaWkwNDSEubm5xmNsbW2RlpYGAEhLS9MIQ8Xri9c9TXh4OObMmVO1O0OkRYW5dwCFAkOHDtV630bGtZF0MZGhiIheKDU6EPXs2VP62cPDAx06dICTkxN+/vlnGBsbV1u/06ZNQ2hoqDSfk5MDBweHauuPqKoV5eUCQsCy92QYWGrv2C24dR23IhchMzOTgYiIXig1OhA9ydzcHE2aNMHly5fx2muvIT8/H1lZWRpnidLT06UxR2q1GidOnNDYRvFdaKWNSyqmVCqhVCqrfgeItMzA0gFKdSNdl0FEVOPV6Nvun5Sbm4srV67Azs4Onp6eMDAwwL59+6T1SUlJSElJgZeXFwDAy8sLf/zxBzIyMqQ2UVFRUKlUcHNz03r9REREVDPV6DNE//3vf9GnTx84OTkhNTUVs2bNgp6eHgYPHgwzMzOMGjUKoaGhsLCwgEqlwvjx4+Hl5YWOHTsCAPz8/ODm5oZhw4Zh4cKFSEtLw/Tp0xEUFMQzQERERCSp0YHo77//xuDBg3Hr1i1YW1ujU6dOOHbsGKytrQEAS5YsQa1atTBgwADk5eXB398fX375pfR4PT09REZGYty4cfDy8oKJiQkCAwMxd+5cXe0SERER1UA1OhD99NNPZa43MjLCihUrsGLFiqe2cXJywo4dO6q6NCIiInqJvFBjiIiIiIiqAwMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyZ6+rgsgopdPYmKi1vu0srKCo6Oj1vslopcDAxERVZnC3DuAQoGhQ4dqvW8j49pIupjIUERElcJARERVpigvFxAClr0nw8DSQWv9Fty6jluRi5CZmclARESVwkBERFXOwNIBSnUjXZdBRFRuHFRNREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyxy93JaKXRmJiotb7tLKygqOjo9b7JaKqxUBERC+8wtw7gEKBoUOHar1vI+PaSLqYyFBE9IJjICKiF15RXi4gBCx7T4aBpYPW+i24dR23IhchMzOTgYjoBcdAREQvDQNLByjVjXRdBhG9gGQViFasWIHPPvsMaWlpaNmyJZYvX4727dvruiwiesFx7BLRi082gWjjxo0IDQ3FqlWr0KFDByxduhT+/v5ISkqCjY2NrssjohcQxy4RvTxkE4gWL16MMWPGYOTIkQCAVatWYfv27VizZg2mTp2q4+qI6EWk67FLhw4dgqurq9b6LcazU/QykkUgys/PR1xcHKZNmyYtq1WrFnx9fREbG6vDyojoZaDtsUu6PDMFAEqlEX777VfY2dlptd+8vDwolUqt9gnoLgCmpKQgMzNT6/3KNfDKIhBlZmaisLAQtra2GsttbW1x8eLFEu3z8vKQl5cnzWdnZwMAcnJyqry23Nzcf/tMu4yi/IdVvv2nKbh1nf2yX/b7gvabl5oICAFVu/7QM7PWWr8AUHDzKnLP7kbv3r212u+/FACE1ns1VBrhh++/K/E3pDqlp6dj6LDhyM/T3nFVTBf7CwBqtRpqtbpKt1n8d1uIchw3Qgb++ecfAUAcPXpUY3lYWJho3759ifazZs0S+Pe3jhMnTpw4ceL0gk/Xr19/ZlaQxRkiKysr6OnpIT09XWN5enp6qWl02rRpCA0NleaLiopw+/ZtWFpaQqFQVGltOTk5cHBwwPXr16FSqap02zUR9/flxv19+cltn7m/LzYhBO7evQt7e/tntpVFIDI0NISnpyf27duHfv36Afg35Ozbtw/BwcEl2iuVyhLXqc3Nzau1RpVK9VIcfOXF/X25cX9ffnLbZ+7vi8vMzKxc7WQRiAAgNDQUgYGBaNu2Ldq3b4+lS5fi3r170l1nREREJF+yCURvv/02bt68iZkzZyItLQ2tWrXCrl27tD5ojIiIiGoe2QQiAAgODi71EpkuKZVKzJo1Sye3kuoC9/flxv19+cltn7m/8qEQojz3ohERERG9vGrpugAiIiIiXWMgIiIiItljICIiIiLZYyAiIiIi2WMg0qEVK1bA2dkZRkZG6NChA06cOKHrkqpNeHg42rVrhzp16sDGxgb9+vVDUlKSrsvSmvnz50OhUCAkJETXpVSbf/75B0OHDoWlpSWMjY3h7u6OU6dO6bqsalFYWIgZM2bAxcUFxsbGaNiwIT7++OPyfV/SC+DgwYPo06cP7O3toVAosGXLFo31QgjMnDkTdnZ2MDY2hq+vLy5duqSbYqtAWftbUFCAKVOmwN3dHSYmJrC3t8fw4cORmpqqu4KrwLNe48eNHTsWCoUCS5cu1Vp9usBApCMbN25EaGgoZs2ahdOnT6Nly5bw9/dHRkaGrkurFgcOHEBQUBCOHTuGqKgoFBQUwM/PD/fu3dN1adXu5MmT+Oqrr+Dh4aHrUqrNnTt34O3tDQMDA+zcuRMXLlzAokWLULduXV2XVi0WLFiAlStX4osvvkBiYiIWLFiAhQsXYvny5bourUrcu3cPLVu2xIoVK0pdv3DhQnz++edYtWoVjh8/DhMTE/j7++PhQ+1/EWlVKGt/79+/j9OnT2PGjBk4ffo0Nm3ahKSkJLz++us6qLTqPOs1LrZ582YcO3asXF998cKrii9PpYpr3769CAoKkuYLCwuFvb29CA8P12FV2pORkSEAiAMHDui6lGp19+5d0bhxYxEVFSW6dOkiJk6cqOuSqsWUKVNEp06ddF2G1gQEBIh3331XY1n//v3FkCFDdFRR9QEgNm/eLM0XFRUJtVotPvvsM2lZVlaWUCqV4scff9RBhVXryf0tzYkTJwQAce3aNe0UVc2ets9///23qFevnkhISBBOTk5iyZIlWq9Nm3iGSAfy8/MRFxcHX19faVmtWrXg6+uL2NhYHVamPdnZ2QAACwsLHVdSvYKCghAQEKDxWr+Mfv/9d7Rt2xZvvvkmbGxs0Lp1a3z99de6LqvavPLKK9i3bx/+/PNPAMDZs2dx+PBh9OzZU8eVVb/k5GSkpaVpHNNmZmbo0KGDrN6/FApFtX/HpS4VFRVh2LBhCAsLQ/PmzXVdjlbI6pOqa4rMzEwUFhaW+NoQW1tbXLx4UUdVaU9RURFCQkLg7e2NFi1a6LqcavPTTz/h9OnTOHnypK5LqXZ//fUXVq5cidDQUHz44Yc4efIkJkyYAENDQwQGBuq6vCo3depU5OTkoFmzZtDT00NhYSE+/fRTDBkyRNelVbu0tDQAKPX9q3jdy+zhw4eYMmUKBg8e/NJ8+WlpFixYAH19fUyYMEHXpWgNAxFpXVBQEBISEnD48GFdl1Jtrl+/jokTJyIqKgpGRka6LqfaFRUVoW3btpg3bx4AoHXr1khISMCqVateykD0888/Y8OGDYiIiEDz5s0RHx+PkJAQ2Nvbv5T7S/8qKCjAW2+9BSEEVq5cqetyqk1cXByWLVuG06dPQ6FQ6LocreElMx2wsrKCnp4e0tPTNZanp6dDrVbrqCrtCA4ORmRkJGJiYlC/fn1dl1Nt4uLikJGRgTZt2kBfXx/6+vo4cOAAPv/8c+jr66OwsFDXJVYpOzs7uLm5aSxzdXVFSkqKjiqqXmFhYZg6dSoGDRoEd3d3DBs2DJMmTUJ4eLiuS6t2xe9Rcnv/Kg5D165dQ1RU1Et9dujQoUPIyMiAo6Oj9P517do1TJ48Gc7Ozrour9owEOmAoaEhPD09sW/fPmlZUVER9u3bBy8vLx1WVn2EEAgODsbmzZsRHR0NFxcXXZdUrbp3744//vgD8fHx0tS2bVsMGTIE8fHx0NPT03WJVcrb27vExyj8+eefcHJy0lFF1ev+/fuoVUvz7VNPTw9FRUU6qkh7XFxcoFarNd6/cnJycPz48Zf2/as4DF26dAl79+6FpaWlrkuqVsOGDcO5c+c03r/s7e0RFhaG3bt367q8asNLZjoSGhqKwMBAtG3bFu3bt8fSpUtx7949jBw5UtelVYugoCBERERg69atqFOnjjTWwMzMDMbGxjqururVqVOnxPgoExMTWFpavpTjpiZNmoRXXnkF8+bNw1tvvYUTJ05g9erVWL16ta5LqxZ9+vTBp59+CkdHRzRv3hxnzpzB4sWL8e677+q6tCqRm5uLy5cvS/PJycmIj4+HhYUFHB0dERISgk8++QSNGzeGi4sLZsyYAXt7e/Tr1093RT+HsvbXzs4OAwcOxOnTpxEZGYnCwkLp/cvCwgKGhoa6Kvu5POs1fjL0GRgYQK1Wo2nTptouVXt0fZubnC1fvlw4OjoKQ0ND0b59e3Hs2DFdl1RtAJQ6rV27Vtelac3LfNu9EEJs27ZNtGjRQiiVStGsWTOxevVqXZdUbXJycsTEiROFo6OjMDIyEg0aNBAfffSRyMvL03VpVSImJqbU39fAwEAhxL+33s+YMUPY2toKpVIpunfvLpKSknRb9HMoa3+Tk5Of+v4VExOj69Ir7Vmv8ZPkcNu9QoiX5KNViYiIiCqJY4iIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiF4gV69ehUKhQHx8vK5LkVy8eBEdO3aEkZERWrVqVS19+Pj4ICQkRJp3dnbG0qVLq6WvqlZVr9mT29m/fz8UCgWysrKeu8anmT17drW9plVBG88ByQcDEVEFjBgxAgqFAvPnz9dYvmXLFll9K/TjZs2aBRMTEyQlJWl8v9Xjip+3J6fHvzpA24QQWL16NTp06ABTU1OYm5ujbdu2WLp0Ke7fv19l/Tg4OODGjRvSV7ZU1R/xV155BTdu3ICZmVkVVFk5dnZ2JX4Xpk6dCoVCgf3792ss9/HxwbBhw7RYHVHFMBARVZCRkREWLFiAO3fu6LqUKpOfn1/px165cgWdOnWCk5NTmV962aNHD9y4cUNj0uWX/A4bNgwhISHo27cvYmJiEB8fjxkzZmDr1q3Ys2dPlfWjp6cHtVoNff2q/epIQ0NDqNVqnQZxHx+fEsEnJiYGDg4OGssfPnyIY8eOoVu3bpXq53mOT6LyYiAiqiBfX1+o1WqEh4c/tU1plxqWLl0KZ2dnaX7EiBHo168f5s2bB1tbW5ibm2Pu3Ll49OgRwsLCYGFhgfr162Pt2rUltn/x4kW88sorMDIyQosWLXDgwAGN9QkJCejZsydMTU1ha2uLYcOGITMzU1rv4+OD4OBghISEwMrKCv7+/qXuR1FREebOnYv69etDqVSiVatW2LVrl7ReoVAgLi4Oc+fOhUKhwOzZs5/6nCiVSqjVao1JT09Peh4eFxISAh8fn6du63HvvvsuevfurbGsoKAANjY2+Pbbb0t9zM8//4wNGzbgxx9/xIcffoh27drB2dkZffv2RXR0NLp27QoAOHnyJF577TVYWVnBzMwMXbp0wenTpzW2pVAosHLlSvTs2RPGxsZo0KABfv31V2n945e6rl69Km27bt26UCgUGDFiBABg165d6NSpE8zNzWFpaYnevXvjypUrT93vJ880+fj4lHoW7urVqwCArKwsjB49GtbW1lCpVOjWrRvOnj2rsc358+fD1tYWderUwahRo/Dw4cMyn/uuXbviyJEjePToEQDg7t27OHPmDKZMmaIRiGJjY5GXlyft+4EDB9C+fXsolUrY2dlh6tSp0jaK96W043PHjh1o0qQJjI2N0bVrV2nfil27dg19+vRB3bp1YWJigubNm2PHjh1l7gNRMQYiogrS09PDvHnzsHz5cvz999/Pta3o6Gikpqbi4MGDWLx4MWbNmoXevXujbt26OH78OMaOHYv333+/RD9hYWGYPHkyzpw5Ay8vL/Tp0we3bt0C8O8fvm7duqF169Y4deoUdu3ahfT0dLz11lsa21i/fj0MDQ1x5MgRrFq1qtT6li1bhkWLFuF///sfzp07B39/f7z++uu4dOkSAODGjRto3rw5Jk+ejBs3buC///3vcz0flTF69Gjs2rULN27ckJZFRkbi/v37ePvtt0t9zIYNG9C0aVP07du3xDqFQiFdhrp79y4CAwNx+PBhHDt2DI0bN0avXr1w9+5djcfMmDEDAwYMwNmzZzFkyBAMGjQIiYmJJbbt4OCA3377DQCQlJSEGzduYNmyZQCAe/fuITQ0FKdOncK+fftQq1YtvPHGGygqKirX87Bp0yaNs2/9+/dH06ZNYWtrCwB48803kZGRgZ07dyIuLg5t2rRB9+7dcfv2bQD/hsTZs2dj3rx5OHXqFOzs7PDll1+W2WfXrl2Rm5uLkydPAgAOHTqEJk2aYMCAATh+/LgUqGJiYuDs7AxnZ2f8888/6NWrF9q1a4ezZ89i5cqV+Pbbb/HJJ59obPvJ4/P69evo378/+vTpg/j4eIwePRpTp07VeExQUBDy8vJw8OBB/PHHH1iwYAFMTU3L9fwR8dvuiSogMDBQ9O3bVwghRMeOHcW7774rhBBi8+bN4vFfp1mzZomWLVtqPHbJkiXCyclJY1tOTk6isLBQWta0aVPx6quvSvOPHj0SJiYm4scffxRCCOmbt+fPny+1KSgoEPXr1xcLFiwQQgjx8ccfCz8/P42+r1+/LgBI30jepUsX0bp162fur729vfj00081lrVr10785z//keZbtmwpZs2aVeZ2AgMDhZ6enjAxMZGmgQMHSuuKn9NiEydOFF26dJHmu3TpIiZOnCjNP/nN225ubtL+CyFEnz59xIgRI55aj6urq3j99dfLrLk0hYWFok6dOmLbtm3SMgBi7NixGu06dOggxo0bJ4T4/9fszJkzQoj//5bxO3fulNnXzZs3BQDxxx9/VHg7ixcvFubm5tLrfejQIaFSqcTDhw812jVs2FB89dVXQgghvLy8NF7X4v148jh+Ur169cS8efOEEEKEhYVJ22jSpImIjo4WQgjx6quvipEjRwohhPjwww9F06ZNRVFRkbSNFStWCFNTU+l3obTjc9q0acLNzU1j2ZQpUzSeA3d3dzF79uwy6yV6Gp4hIqqkBQsWYP369aWeCSiv5s2bo1at//81tLW1hbu7uzSvp6cHS0tLZGRkaDzOy8tL+llfXx9t27aV6jh79ixiYmJgamoqTc2aNQMAjUswnp6eZdaWk5OD1NRUeHt7ayz39vau1D537doV8fHx0vT5559XeBtPM3r0aOnSYnp6Onbu3Il33333qe2FEOXabnp6OsaMGYPGjRvDzMwMKpUKubm5SElJ0Wj3+OtRPF/R5+jSpUsYPHgwGjRoAJVKJV1efbKvZ9m5cyemTp2KjRs3okmTJgD+PSZyc3NhaWmpcVwkJydLx0RiYiI6dOhQ5n6V5vFxRPv375cudXbp0gX79+/HgwcPcPz4celyWWJiIry8vDTGPnl7eyM3N1fjTOiTx2d56pswYQI++eQTeHt7Y9asWTh37twz6ycqVrWj/IhkpHPnzvD398e0adOkcSDFatWqVeKPbkFBQYltGBgYaMwrFIpSl5X3sgkA5Obmok+fPliwYEGJdXZ2dtLPJiYm5d5mVTAxMUGjRo1KLC/vc1WW4cOHY+rUqYiNjcXRo0fh4uKCV1999antmzRpgosXLz5zu4GBgbh16xaWLVsGJycnKJVKeHl5Vcsg3z59+sDJyQlff/017O3tUVRUhBYtWlSorwsXLmDQoEGYP38+/Pz8pOW5ubmws7MrMQAaAMzNzZ+r7q5du2LixIm4desWzpw5gy5dugD4NxB99dVX6Ny5M/Lz8ys8oLoyx+fo0aPh7++P7du3Y8+ePQgPD8eiRYswfvz4Cm+L5IdniIiew/z587Ft2zbExsZqLLe2tkZaWprGH/qq/OygY8eOST8/evQIcXFxcHV1BQC0adMG58+fh7OzMxo1aqQxVeSPjEqlgr29PY4cOaKx/MiRI3Bzc6uaHcG/z9Xj43+Aij9XlpaW6NevH9auXYt169Zh5MiRZbZ/55138Oeff2Lr1q0l1gkhkJ2dDeDffZ0wYQJ69eqF5s2bQ6lUagxOL/b461E8X/x6PMnQ0BAAUFhYKC27desWkpKSMH36dHTv3h2urq4VvosxMzMTffr0wYABAzBp0iSNdW3atEFaWhr09fVLHBNWVlYAAFdXVxw/frzM/SpN165dce/ePSxevBiNGzeGjY0NgH//YThx4gR27tyJxo0bo169elI/sbGxGr8bR44cQZ06dVC/fv2n9uPq6ooTJ048sz4HBweMHTsWmzZtwuTJk/H1118/cx+IAAYioufi7u6OIUOGlLj84+Pjg5s3b2LhwoW4cuUKVqxYgZ07d1ZZvytWrMDmzZtx8eJFBAUF4c6dO9IloqCgINy+fRuDBw/GyZMnceXKFezevRsjR47U+CNcHmFhYViwYAE2btyIpKQkTJ06FfHx8Zg4cWKV7Uu3bt1w6tQpfPfdd7h06RJmzZqFhISECm9n9OjR0iXMwMDAMtu+9dZbePvttzF48GBpEPG1a9cQGRkJX19fxMTEAAAaN26M77//HomJiTh+/DiGDBkCY2PjEtv75ZdfsGbNGvz555+YNWsWTpw4geDg4FL7dnJygkKhQGRkJG7evInc3FzUrVsXlpaWWL16NS5fvozo6GiEhoZWaP8HDBiA2rVrY/bs2UhLS5OmwsJC+Pr6wsvLC/369cOePXtw9epVHD16FB999BFOnToFAJg4cSLWrFmDtWvXSvtx/vz5Z/bboEEDODo6Yvny5dLZIeDfYGJvb4/Vq1dLl8sA4D//+Q+uX7+O8ePH4+LFi9i6dStmzZqF0NBQjcvHTxo7diwuXbqEsLAwJCUlISIiAuvWrdNoExISgt27dyM5ORmnT59GTEzMU4Mp0ZMYiIie09y5c0tc0nJ1dcWXX36JFStWoGXLljhx4kSV3oE1f/58zJ8/Hy1btsThw4fx+++/S//pF5/VKSwshJ+fH9zd3RESEgJzc/My/+CUZsKECQgNDcXkyZPh7u6OXbt24ffff0fjxo2rbF/8/f0xY8YMfPDBB2jXrh3u3r2L4cOHV3g7vr6+sLOzg7+/P+zt7ctsq1AoEBERgcWLF2PLli3o0qULPDw8MHv2bPTt21e6zfvbb7/FnTt30KZNGwwbNgwTJkyQzoA8bs6cOfjpp5/g4eGB7777Dj/++ONTz6LVq1cPc+bMwdSpU2Fra4vg4GDUqlULP/30E+Li4tCiRQtMmjQJn332WYX2/+DBg0hISICTkxPs7Oyk6fr161AoFNixYwc6d+6MkSNHokmTJhg0aBCuXbsm3YX29ttvS6+Dp6cnrl27hnHjxpWr765du+Lu3bslPiqhS5cuuHv3rkYgqlevHnbs2IETJ06gZcuWGDt2LEaNGoXp06eX2YejoyN+++03bNmyBS1btsSqVaswb948jTaFhYUICgqCq6srevTogSZNmjzzTjmiYgpR3tGFREQ1WG5uLurVq4e1a9eif//+WutXoVBg8+bNJT5LiYheLBxUTUQvtKKiImRmZmLRokUwNzfH66+/ruuSiOgFxEBERC+0lJQUuLi4oH79+li3bl2Vf0UGEckDL5kRERGR7HFQNREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyd7/AVKGRmaCBRROAAAAAElFTkSuQmCC", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "def count_fully_capitalized_words(title):\n", " words = title.split()\n", " capitalized_words = sum(word.isupper() for word in words)\n", " return capitalized_words\n", "\n", "df['fully_capitalized_words_count'] = df['business_title'].apply(count_fully_capitalized_words)\n", "\n", "plt.hist(df['fully_capitalized_words_count'], bins=range(df['fully_capitalized_words_count'].max() + 2), edgecolor='black')\n", "plt.xlabel('Number of Fully Capitalized Words')\n", "plt.ylabel('Count')\n", "plt.title('Distribution of Fully Capitalized Words in Titles')\n", "plt.show()\n" ] }, { "cell_type": "markdown", "id": "f3de1b25", "metadata": {}, "source": [ "So the half the bussiness titles have no full uppercase words, and for the ones that do contain fully capitalized titles the count seems to peak at 3 and can extend as far as ... 14. Actually I want to see the full distribution for the word length now." ] }, { "cell_type": "code", "execution_count": 10, "id": "7eac4a48", "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkQAAAHHCAYAAABeLEexAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8g+/7EAAAACXBIWXMAAA9hAAAPYQGoP6dpAABPOklEQVR4nO3deVhUZeM+8HtYZkBWAWEgARFcwF1MxBWVQMPtp75pueaaYeYSGW/lgpVbbplLq1hqZb2ppYkiCG5oiJJLSmoomgJuMIJswvP7o4vzdWRHhkHO/bmuc12ec555ljkM3J7znDMKIYQAERERkYwZ6LsDRERERPrGQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARKQDCxYsgEKhqJW2/Pz84OfnJ63HxMRAoVDgp59+qpX2x48fjyZNmtRKW9WVlZWFSZMmQa1WQ6FQYObMmfruUpU9eZyr6+rVq1AoFAgPD3/quqpKoVBgwYIFlSrbpEkTjB8/Xqf9IXocAxFRBcLDw6FQKKTFxMQETk5OCAwMxCeffIIHDx7USDs3b97EggULkJiYWCP11aS63LfK+OijjxAeHo5p06bh22+/xZgxY0ot5+XlhXbt2pXYvmPHDigUCvTq1avEvq+//hoKhQL79++v8X7XdU9+NspaygrMx44dw4IFC5CRkVGr/SYqjZG+O0D0rAgLC4ObmxsKCgqQmpqKmJgYzJw5EytXrsQvv/yCtm3bSmXfe+89vPPOO1Wq/+bNm1i4cCGaNGmC9u3bV/p1tfGHuLy+ffHFFygqKtJ5H55GdHQ0unTpgvnz55dbrnv37vjqq6+QmZkJKysrafvRo0dhZGSE+Ph4FBQUwNjYWGufoaEhfH19ddb/muTq6oqcnBytMVRXz5498e2332ptmzRpEjp37owpU6ZI28zNzQEAOTk5MDL6vz87x44dw8KFCzF+/HhYW1s/dX+IngYDEVEl9e/fH506dZLWQ0NDER0djQEDBmDQoEG4cOECTE1NAQBGRkZav/h14eHDh2jQoAGUSqVO26lITfxh1bX09HR4eXlVWK579+744osvcOzYMfTv31/afvToUbz00kvYtm0bEhIS0KVLF2nfkSNH0LZtW1hYWDxVH7Ozs2FmZvZUdVRG8VnOmtC0aVM0bdpUa9trr72Gpk2bYvTo0SXK11S7RLrAS2ZET6FPnz54//33ce3aNWzZskXaXtocosjISHTv3h3W1tYwNzdHixYt8N///hfAv/N+nn/+eQDAq6++Kl1qKJ7n4efnh9atWyMhIQE9e/ZEgwYNpNeWNbeksLAQ//3vf6FWq2FmZoZBgwbh+vXrWmXKmqfxeJ0V9a20OUTZ2dmYM2cOnJ2doVKp0KJFC3z88ccQQmiVUygUmD59Onbu3InWrVtDpVKhVatWiIiIKP0Nf0J6ejomTpwIBwcHmJiYoF27dti8ebO0v3g+VXJyMvbs2SP1/erVq6XW1717dwD/BqBiubm5OHXqFIYOHYqmTZtq7bt9+zb++usv6XUAcPr0afTv3x+WlpYwNzdH3759cfz4ca12ii81xcbG4vXXX4e9vT0aN24s7f/888/h7u4OU1NTdO7cGYcPHy61v2vXrkWrVq3QoEEDNGzYEJ06dcK2bdvKfc9Km0M0fvx4mJub459//sGQIUNgbm6ORo0a4a233kJhYWG59VXF43OIFixYgJCQEACAm5tbhccGADIyMjBz5kzp58rDwwNLly4tcYby+++/h7e3NywsLGBpaYk2bdpgzZo1NTYOqp94hojoKY0ZMwb//e9/sX//fkyePLnUMufPn8eAAQPQtm1bhIWFQaVS4fLly9IfV09PT4SFhWHevHmYMmUKevToAQDo2rWrVMfdu3fRv39/jBw5EqNHj4aDg0O5/frwww+hUCgwd+5cpKenY/Xq1fD390diYqJ0JqsyKtO3xwkhMGjQIBw8eBATJ05E+/btsW/fPoSEhOCff/7BqlWrtMofOXIEP//8M15//XVYWFjgk08+wbBhw5CSkgJbW9sy+5WTkwM/Pz9cvnwZ06dPh5ubG3788UeMHz8eGRkZePPNN+Hp6Ylvv/0Ws2bNQuPGjTFnzhwAQKNGjUqts2nTpnBycsKRI0ekbfHx8cjPz0fXrl3RtWtXHD16VKrn2LFjAP4vSJ0/fx49evSApaUl3n77bRgbG+Ozzz6Dn58fYmNj4ePjo9Xe66+/jkaNGmHevHnIzs4GAHz11VeYOnUqunbtipkzZ+Lvv//GoEGDYGNjA2dnZ+m1X3zxBWbMmIHhw4fjzTffRG5uLs6cOYMTJ07glVdeKfN9K0thYSECAwPh4+ODjz/+GAcOHMCKFSvg7u6OadOmVbm+igwdOhR//fUXvvvuO6xatQp2dnYAyj42Dx8+RK9evfDPP/9g6tSpcHFxwbFjxxAaGopbt25h9erVAP79j8fLL7+Mvn37YunSpQCACxcu4OjRo3jzzTdrfBxUjwgiKtemTZsEABEfH19mGSsrK9GhQwdpff78+eLxj9eqVasEAHH79u0y64iPjxcAxKZNm0rs69WrlwAgNm7cWOq+Xr16SesHDx4UAMRzzz0nNBqNtH379u0CgFizZo20zdXVVYwbN67COsvr27hx44Srq6u0vnPnTgFAfPDBB1rlhg8fLhQKhbh8+bK0DYBQKpVa2/744w8BQKxdu7ZEW49bvXq1ACC2bNkibcvPzxe+vr7C3Nxca+yurq4iKCio3PqK/ec//xGmpqYiPz9fCCHE4sWLhZubmxBCiPXr1wt7e3up7FtvvSUAiH/++UcIIcSQIUOEUqkUV65ckcrcvHlTWFhYiJ49e0rbin+munfvLh49eqTVf3t7e9G+fXuRl5cnbf/8888FAK1jMnjwYNGqVatKjelxycnJJY7luHHjBAARFhamVbZDhw7C29u7SvWbmZmV+jMlxL/He/78+dL68uXLBQCRnJxcouyTP5uLFi0SZmZm4q+//tIq98477whDQ0ORkpIihBDizTffFJaWllrvK1Fl8JIZUQ0wNzcv926z4gmju3btqvYEZJVKhVdffbXS5ceOHas1r2X48OFwdHTEb7/9Vq32K+u3336DoaEhZsyYobV9zpw5EEJg7969Wtv9/f3h7u4urbdt2xaWlpb4+++/K2xHrVbj5ZdflrYZGxtjxowZyMrKQmxsbLX63717d+Tk5CAhIQHAv5fPis+GdevWDenp6bh06ZK0z83NDU5OTigsLMT+/fsxZMgQrXk1jo6OeOWVV3DkyBFoNBqttiZPngxDQ0Np/eTJk0hPT8drr72mNTds/PjxWpO8gX9/pm7cuIH4+PhqjbM0r732mtZ6jx49KjwOteXHH39Ejx490LBhQ9y5c0da/P39UVhYiEOHDgH4933Jzs5GZGSknntMzxoGIqIakJWVVe6k2hEjRqBbt26YNGkSHBwcMHLkSGzfvr1K4ei5556r0gTqZs2aaa0rFAp4eHiUO0ejJly7dg1OTk4l3g9PT09p/+NcXFxK1NGwYUPcv3+/wnaaNWsGAwPtX2NltVNZj88jEkLg2LFj6NatGwCgdevWsLS0xNGjR5Gbm4uEhASp/O3bt/Hw4UO0aNGiRJ2enp4oKioqMYfLzc2txJiAksfO2Ni4xOTluXPnwtzcHJ07d0azZs0QHBysNb+pqkxMTEpcrqrMcagtly5dQkREBBo1aqS1+Pv7A/h3Phnw72XI5s2bo3///mjcuDEmTJhQ6TlpJG8MRERP6caNG8jMzISHh0eZZUxNTXHo0CEcOHAAY8aMwZkzZzBixAi88MILlZ60WpV5P5VV1sMja3IibUUeP0PyOPHEBOza0q5dO1hYWODIkSO4ePEi7t27J50hMjAwgI+PD44cOSLNLXp8QnVVPc0x9fT0RFJSEr7//nt0794d//vf/9C9e/cKHy1QlrKOQ11RVFSEF154AZGRkaUuw4YNAwDY29sjMTERv/zyizSXrX///hg3bpyeR0B1HQMR0VMqfg5LYGBgueUMDAzQt29frFy5En/++Sc+/PBDREdH4+DBgwDKDifVVXxZp5gQApcvX9a6I6xhw4alPhTvybMrVembq6srbt68WeIS4sWLF6X9NcHV1RWXLl0qcZbtadsxNDREly5dcPToURw5ckS6S6lY8cTq4rMxxYGoUaNGaNCgAZKSkkrUefHiRRgYGGhNii5rTEDJY1dQUIDk5OQS5c3MzDBixAhs2rQJKSkpCAoKwocffojc3NyqDVpPqvJz5e7ujqysLPj7+5e6PH6mUalUYuDAgVi/fj2uXLmCqVOn4ptvvsHly5d1MQyqJxiIiJ5CdHQ0Fi1aBDc3N4waNarMcvfu3SuxrfgBh3l5eQAgPYOmpp7a+80332iFkp9++gm3bt3Ser6Ou7s7jh8/jvz8fGnb7t27S1zaqUrfXnzxRRQWFuLTTz/V2r5q1SooFAqt9p/Giy++iNTUVPzwww/StkePHmHt2rUwNzcv9anSldW9e3fcvn0bmzZtgo+Pj9Zlua5duyIpKQm7du2Cra2tdInO0NAQAQEB2LVrl9ZlybS0NGzbtg3du3eHpaVlue126tQJjRo1wsaNG7WOSXh4eIn3/u7du1rrSqUSXl5eEEKgoKCgmiOvXVX5uXrppZcQFxeHffv2ldiXkZGBR48eASj5vhgYGEgPTS3+rBGVhrfdE1XS3r17cfHiRTx69AhpaWmIjo5GZGQkXF1d8csvv5T70LmwsDAcOnQIQUFBcHV1RXp6OtavX4/GjRtLZxjc3d1hbW2NjRs3wsLCAmZmZvDx8Skxz6SybGxs0L17d7z66qtIS0vD6tWr4eHhofVogEmTJuGnn35Cv3798NJLL+HKlSvYsmWL1iTnqvZt4MCB6N27N959911cvXoV7dq1w/79+7Fr1y7MnDmzRN3VNWXKFHz22WcYP348EhIS0KRJE/z00084evQoVq9e/VQPSiw+JnFxcSW+e6tLly5QKBQ4fvw4Bg4cqHWW44MPPpCeN/X666/DyMgIn332GfLy8rBs2bIK2zU2NsYHH3yAqVOnok+fPhgxYgSSk5OxadOmEnOIAgICoFar0a1bNzg4OODChQv49NNPERQU9NQPiawt3t7eAIB3330XI0eOhLGxMQYOHFjqAypDQkLwyy+/YMCAARg/fjy8vb2RnZ2Ns2fP4qeffsLVq1dhZ2eHSZMm4d69e+jTpw8aN26Ma9euYe3atWjfvr0UXolKpdd73IieAcW3SBcvSqVSqNVq8cILL4g1a9Zo3d5d7Mnb7qOiosTgwYOFk5OTUCqVwsnJSbz88sslbiHetWuX8PLyEkZGRlq3Rvfq1avMW6zLuu3+u+++E6GhocLe3l6YmpqKoKAgce3atRKvX7FihXjuueeESqUS3bp1EydPnixRZ3l9e/K2eyGEePDggZg1a5ZwcnISxsbGolmzZmL58uWiqKhIqxwAERwcXKJPZT0O4ElpaWni1VdfFXZ2dkKpVIo2bdqU+miAqtx2L4QQ2dnZ0jj3799fYn/btm0FALF06dIS+06dOiUCAwOFubm5aNCggejdu7c4duyYVpmKHuWwfv164ebmJlQqlejUqZM4dOhQiWPy2WefiZ49ewpbW1uhUqmEu7u7CAkJEZmZmeWOrazb7s3MzEqUffLnuDKqctu9EP/eTv/cc88JAwMDrVvwS/sZePDggQgNDRUeHh5CqVQKOzs70bVrV/Hxxx9Lj0n46aefREBAgLC3txdKpVK4uLiIqVOnilu3blVpHCQ/CiH0NHORiIiIqI7gHCIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9PpixEoqKinDz5k1YWFjU+NcrEBERkW4IIfDgwQM4OTmV+CLoJzEQVcLNmzcr/A4iIiIiqpuuX7+Oxo0bl1uGgagSih+Df/369Qq/i4iIiIjqBo1GA2dn50p9nQ0DUSUUXyaztLRkICIiInrGVGa6CydVExERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHs6TUQbdiwAW3btpW+I8zX1xd79+6V9ufm5iI4OBi2trYwNzfHsGHDkJaWplVHSkoKgoKC0KBBA9jb2yMkJASPHj3SKhMTE4OOHTtCpVLBw8MD4eHhtTE8IiIiekboNRA1btwYS5YsQUJCAk6ePIk+ffpg8ODBOH/+PABg1qxZ+PXXX/Hjjz8iNjYWN2/exNChQ6XXFxYWIigoCPn5+Th27Bg2b96M8PBwzJs3TyqTnJyMoKAg9O7dG4mJiZg5cyYmTZqEffv21fp4iYiIqG5SCCGEvjvxOBsbGyxfvhzDhw9Ho0aNsG3bNgwfPhwAcPHiRXh6eiIuLg5dunTB3r17MWDAANy8eRMODg4AgI0bN2Lu3Lm4ffs2lEol5s6diz179uDcuXNSGyNHjkRGRgYiIiIq1SeNRgMrKytkZmby2+6JiIieEVX5+21US32qUGFhIX788UdkZ2fD19cXCQkJKCgogL+/v1SmZcuWcHFxkQJRXFwc2rRpI4UhAAgMDMS0adNw/vx5dOjQAXFxcVp1FJeZOXNmmX3Jy8tDXl6etK7RaGpuoPRUUlJScOfOHZ22YWdnBxcXF522QUREdYveA9HZs2fh6+uL3NxcmJubY8eOHfDy8kJiYiKUSiWsra21yjs4OCA1NRUAkJqaqhWGivcX7yuvjEajQU5ODkxNTUv0afHixVi4cGFNDZFqSEpKClq09ERuzkOdtmNi2gBJFy8wFBERyYjeA1GLFi2QmJiIzMxM/PTTTxg3bhxiY2P12qfQ0FDMnj1bWtdoNHB2dtZjjwgA7ty5g9ych7AdMAfGtro5HgV3r+Pu7hW4c+cOAxERkYzoPRAplUp4eHgAALy9vREfH481a9ZgxIgRyM/PR0ZGhtZZorS0NKjVagCAWq3G77//rlVf8V1oj5d58s60tLQ0WFpalnp2CABUKhVUKlWNjI9qnrGtM1RqD313g4iI6pE69xyioqIi5OXlwdvbG8bGxoiKipL2JSUlISUlBb6+vgAAX19fnD17Funp6VKZyMhIWFpawsvLSyrzeB3FZYrrICIiItLrGaLQ0FD0798fLi4uePDgAbZt24aYmBjs27cPVlZWmDhxImbPng0bGxtYWlrijTfegK+vL7p06QIACAgIgJeXF8aMGYNly5YhNTUV7733HoKDg6UzPK+99ho+/fRTvP3225gwYQKio6Oxfft27NmzR59DJyIiojpEr4EoPT0dY8eOxa1bt2BlZYW2bdti3759eOGFFwAAq1atgoGBAYYNG4a8vDwEBgZi/fr10usNDQ2xe/duTJs2Db6+vjAzM8O4ceMQFhYmlXFzc8OePXswa9YsrFmzBo0bN8aXX36JwMDAWh8vERER1U117jlEdRGfQ1Q3nDp1Ct7e3lCPW62zOUR5qZeRunkmEhIS0LFjR520QUREtaMqf7/r3BwiIiIiotrGQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREssdARERERLLHQERERESyx0BEREREsqfXQLR48WI8//zzsLCwgL29PYYMGYKkpCStMn5+flAoFFrLa6+9plUmJSUFQUFBaNCgAezt7RESEoJHjx5plYmJiUHHjh2hUqng4eGB8PBwXQ+PiIiInhF6DUSxsbEIDg7G8ePHERkZiYKCAgQEBCA7O1ur3OTJk3Hr1i1pWbZsmbSvsLAQQUFByM/Px7Fjx7B582aEh4dj3rx5Upnk5GQEBQWhd+/eSExMxMyZMzFp0iTs27ev1sZKREREdZeRPhuPiIjQWg8PD4e9vT0SEhLQs2dPaXuDBg2gVqtLrWP//v34888/ceDAATg4OKB9+/ZYtGgR5s6diwULFkCpVGLjxo1wc3PDihUrAACenp44cuQIVq1ahcDAQN0NkIiIiJ4JdWoOUWZmJgDAxsZGa/vWrVthZ2eH1q1bIzQ0FA8fPpT2xcXFoU2bNnBwcJC2BQYGQqPR4Pz581IZf39/rToDAwMRFxdXaj/y8vKg0Wi0FiIiIqq/9HqG6HFFRUWYOXMmunXrhtatW0vbX3nlFbi6usLJyQlnzpzB3LlzkZSUhJ9//hkAkJqaqhWGAEjrqamp5ZbRaDTIycmBqamp1r7Fixdj4cKFNT5GIiIiqpvqTCAKDg7GuXPncOTIEa3tU6ZMkf7dpk0bODo6om/fvrhy5Qrc3d110pfQ0FDMnj1bWtdoNHB2dtZJW0RERKR/deKS2fTp07F7924cPHgQjRs3Lresj48PAODy5csAALVajbS0NK0yxevF847KKmNpaVni7BAAqFQqWFpaai1ERERUf+k1EAkhMH36dOzYsQPR0dFwc3Or8DWJiYkAAEdHRwCAr68vzp49i/T0dKlMZGQkLC0t4eXlJZWJiorSqicyMhK+vr41NBIiIiJ6luk1EAUHB2PLli3Ytm0bLCwskJqaitTUVOTk5AAArly5gkWLFiEhIQFXr17FL7/8grFjx6Jnz55o27YtACAgIABeXl4YM2YM/vjjD+zbtw/vvfcegoODoVKpAACvvfYa/v77b7z99tu4ePEi1q9fj+3bt2PWrFl6GzsRERHVHXoNRBs2bEBmZib8/Pzg6OgoLT/88AMAQKlU4sCBAwgICEDLli0xZ84cDBs2DL/++qtUh6GhIXbv3g1DQ0P4+vpi9OjRGDt2LMLCwqQybm5u2LNnDyIjI9GuXTusWLECX375JW+5JyIiIgB6nlQthCh3v7OzM2JjYyusx9XVFb/99lu5Zfz8/HD69Okq9Y+IiIjkoU5MqiYiIiLSJwYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj29BqLFixfj+eefh4WFBezt7TFkyBAkJSVplcnNzUVwcDBsbW1hbm6OYcOGIS0tTatMSkoKgoKC0KBBA9jb2yMkJASPHj3SKhMTE4OOHTtCpVLBw8MD4eHhuh4eERERPSP0GohiY2MRHByM48ePIzIyEgUFBQgICEB2drZUZtasWfj111/x448/IjY2Fjdv3sTQoUOl/YWFhQgKCkJ+fj6OHTuGzZs3Izw8HPPmzZPKJCcnIygoCL1790ZiYiJmzpyJSZMmYd++fbU6XiIiIqqbFEIIoe9OFLt9+zbs7e0RGxuLnj17IjMzE40aNcK2bdswfPhwAMDFixfh6emJuLg4dOnSBXv37sWAAQNw8+ZNODg4AAA2btyIuXPn4vbt21AqlZg7dy727NmDc+fOSW2NHDkSGRkZiIiIqLBfGo0GVlZWyMzMhKWlpW4GTxU6deoUvL29oR63Giq1h07ayEu9jNTNM5GQkICOHTvqpA0iIqodVfn7XafmEGVmZgIAbGxsAAAJCQkoKCiAv7+/VKZly5ZwcXFBXFwcACAuLg5t2rSRwhAABAYGQqPR4Pz581KZx+soLlNcBxEREcmbkb47UKyoqAgzZ85Et27d0Lp1awBAamoqlEolrK2ttco6ODggNTVVKvN4GCreX7yvvDIajQY5OTkwNTXV2peXl4e8vDxpXaPRPP0AiYiIqM6qM2eIgoODce7cOXz//ff67goWL14MKysraXF2dtZ3l4iIiEiH6kQgmj59Onbv3o2DBw+icePG0na1Wo38/HxkZGRolU9LS4NarZbKPHnXWfF6RWUsLS1LnB0CgNDQUGRmZkrL9evXn3qMREREVHfpNRAJITB9+nTs2LED0dHRcHNz09rv7e0NY2NjREVFSduSkpKQkpICX19fAICvry/Onj2L9PR0qUxkZCQsLS3h5eUllXm8juIyxXU8SaVSwdLSUmshIiKi+kuvc4iCg4Oxbds27Nq1CxYWFtKcHysrK5iamsLKygoTJ07E7NmzYWNjA0tLS7zxxhvw9fVFly5dAAABAQHw8vLCmDFjsGzZMqSmpuK9995DcHAwVCoVAOC1117Dp59+irfffhsTJkxAdHQ0tm/fjj179uht7ERERFR36PUM0YYNG5CZmQk/Pz84OjpKyw8//CCVWbVqFQYMGIBhw4ahZ8+eUKvV+Pnnn6X9hoaG2L17NwwNDeHr64vRo0dj7NixCAsLk8q4ublhz549iIyMRLt27bBixQp8+eWXCAwMrNXxEhERUd2k1zNElXkEkomJCdatW4d169aVWcbV1RW//fZbufX4+fnh9OnTVe4jERER1X91YlI1ERERkT4xEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsGem7A0R10YULF3Rav52dHVxcXHTaBhERVR4DEdFjCrPuAwoFRo8erdN2TEwbIOniBYYiIqI6olqBqGnTpoiPj4etra3W9oyMDHTs2BF///13jXSOqLYV5WUBQsB2wBwY2zrrpI2Cu9dxd/cK3Llzh4GIiKiOqFYgunr1KgoLC0tsz8vLwz///PPUnSLSN2NbZ6jUHvruBhER1ZIqBaJffvlF+ve+fftgZWUlrRcWFiIqKgpNmjSpsc4RERER1YYqBaIhQ4YAABQKBcaNG6e1z9jYGE2aNMGKFStqrHP0bElJScGdO3d0Vr+uJzoTEZF8VSkQFRUVAQDc3NwQHx8POzs7nXSKnj0pKSlo0dITuTkP9d0VIiKiKqvWHKLk5OSa7gc94+7cuYPcnIc6nYyc8/dJZB7eopO6iYhI3qp9231UVBSioqKQnp4unTkq9vXXXz91x+jZpMvJyAV3r+ukXiIiomoFooULFyIsLAydOnWCo6MjFApFTfeLiIiIqNZUKxBt3LgR4eHhGDNmTE33h4iIiKjWVeu7zPLz89G1a9ea7gsRERGRXlQrEE2aNAnbtm2r6b4QERER6UW1Lpnl5ubi888/x4EDB9C2bVsYGxtr7V+5cmWNdI6IiIioNlQrEJ05cwbt27cHAJw7d05rHydYExER0bOmWoHo4MGDNd0PIiIiIr2p1hwiIiIiovqkWmeIevfuXe6lsejo6Gp3iIiIiKi2VSsQFc8fKlZQUIDExEScO3euxJe+EhEREdV11QpEq1atKnX7ggULkJWV9VQdIiIiIqptNTqHaPTo0fweMyIiInrm1GggiouLg4mJSU1WSURERKRz1bpkNnToUK11IQRu3bqFkydP4v3336+RjhERERHVlmoFIisrK611AwMDtGjRAmFhYQgICKiRjhERERHVlmoFok2bNtV0P4iIiIj05qnmECUkJGDLli3YsmULTp8+XeXXHzp0CAMHDoSTkxMUCgV27typtX/8+PFQKBRaS79+/bTK3Lt3D6NGjYKlpSWsra0xceLEEne6nTlzBj169ICJiQmcnZ2xbNmyKveViIiI6q9qnSFKT0/HyJEjERMTA2trawBARkYGevfuje+//x6NGjWqVD3Z2dlo164dJkyYUGJeUrF+/fppnZFSqVRa+0eNGoVbt24hMjISBQUFePXVVzFlyhRs27YNAKDRaBAQEAB/f39s3LgRZ8+exYQJE2BtbY0pU6ZUY/RERERU31QrEL3xxht48OABzp8/D09PTwDAn3/+iXHjxmHGjBn47rvvKlVP//790b9//3LLqFQqqNXqUvdduHABERERiI+PR6dOnQAAa9euxYsvvoiPP/4YTk5O2Lp1K/Lz8/H1119DqVSiVatWSExMxMqVKxmIiIiICEA1L5lFRERg/fr1UhgCAC8vL6xbtw579+6tsc4BQExMDOzt7dGiRQtMmzYNd+/elfbFxcXB2tpaCkMA4O/vDwMDA5w4cUIq07NnTyiVSqlMYGAgkpKScP/+/VLbzMvLg0aj0VqIiIio/qpWICoqKoKxsXGJ7cbGxigqKnrqThXr168fvvnmG0RFRWHp0qWIjY1F//79UVhYCABITU2Fvb291muMjIxgY2OD1NRUqYyDg4NWmeL14jJPWrx4MaysrKTF2dm5xsZEREREdU+1AlGfPn3w5ptv4ubNm9K2f/75B7NmzULfvn1rrHMjR47EoEGD0KZNGwwZMgS7d+9GfHw8YmJiaqyN0oSGhiIzM1Narl+/rtP2iIiISL+qFYg+/fRTaDQaNGnSBO7u7nB3d4ebmxs0Gg3Wrl1b032UNG3aFHZ2drh8+TIAQK1WIz09XavMo0ePcO/ePWnekVqtRlpamlaZ4vWy5iapVCpYWlpqLURERFR/VWtStbOzM06dOoUDBw7g4sWLAABPT0/4+/vXaOeedOPGDdy9exeOjo4AAF9fX2RkZCAhIQHe3t4AgOjoaBQVFcHHx0cq8+6776KgoEC6zBcZGYkWLVqgYcOGOu0vERERPRuqdIYoOjoaXl5e0Gg0UCgUeOGFF/DGG2/gjTfewPPPP49WrVrh8OHDla4vKysLiYmJSExMBAAkJycjMTERKSkpyMrKQkhICI4fP46rV68iKioKgwcPhoeHBwIDAwH8G8L69euHyZMn4/fff8fRo0cxffp0jBw5Ek5OTgCAV155BUqlEhMnTsT58+fxww8/YM2aNZg9e3ZVhk5ERET1WJUC0erVqzF58uRSLyFZWVlh6tSpWLlyZaXrO3nyJDp06IAOHToAAGbPno0OHTpg3rx5MDQ0xJkzZzBo0CA0b94cEydOhLe3Nw4fPqz1LKKtW7eiZcuW6Nu3L1588UV0794dn3/+uVa/9u/fj+TkZHh7e2POnDmYN28eb7knIiIiSZUumf3xxx9YunRpmfsDAgLw8ccfV7o+Pz8/CCHK3L9v374K67CxsZEewliWtm3bVunMFREREclLlc4QpaWllXq7fTEjIyPcvn37qTtFREREVJuqFIiee+45nDt3rsz9Z86ckSY8ExERET0rqhSIXnzxRbz//vvIzc0tsS8nJwfz58/HgAEDaqxzRERERLWhSnOI3nvvPfz8889o3rw5pk+fjhYtWgAALl68iHXr1qGwsBDvvvuuTjpKREREpCtVCkQODg44duwYpk2bhtDQUGlCtEKhQGBgINatW1fiazKIiIiI6roqP5jR1dUVv/32G+7fv4/Lly9DCIFmzZrxIYdERET0zKrWk6oBoGHDhnj++edrsi9EREREelGt7zIjIiIiqk8YiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPb0GogOHTqEgQMHwsnJCQqFAjt37tTaL4TAvHnz4OjoCFNTU/j7++PSpUtaZe7du4dRo0bB0tIS1tbWmDhxIrKysrTKnDlzBj169ICJiQmcnZ2xbNkyXQ+NiIiIniF6DUTZ2dlo164d1q1bV+r+ZcuW4ZNPPsHGjRtx4sQJmJmZITAwELm5uVKZUaNG4fz584iMjMTu3btx6NAhTJkyRdqv0WgQEBAAV1dXJCQkYPny5ViwYAE+//xznY+PiIiIng1G+my8f//+6N+/f6n7hBBYvXo13nvvPQwePBgA8M0338DBwQE7d+7EyJEjceHCBURERCA+Ph6dOnUCAKxduxYvvvgiPv74Yzg5OWHr1q3Iz8/H119/DaVSiVatWiExMRErV67UCk5EREQkX3V2DlFycjJSU1Ph7+8vbbOysoKPjw/i4uIAAHFxcbC2tpbCEAD4+/vDwMAAJ06ckMr07NkTSqVSKhMYGIikpCTcv3+/lkZDREREdZlezxCVJzU1FQDg4OCgtd3BwUHal5qaCnt7e639RkZGsLGx0Srj5uZWoo7ifQ0bNizRdl5eHvLy8qR1jUbzlKMhIiKiuqzOniHSp8WLF8PKykpanJ2d9d0lIiIi0qE6e4ZIrVYDANLS0uDo6ChtT0tLQ/v27aUy6enpWq979OgR7t27J71erVYjLS1Nq0zxenGZJ4WGhmL27NnSukajYSiiGnfhwgWd1m9nZwcXFxedtkFEVF/U2UDk5uYGtVqNqKgoKQBpNBqcOHEC06ZNAwD4+voiIyMDCQkJ8Pb2BgBER0ejqKgIPj4+Upl3330XBQUFMDY2BgBERkaiRYsWpV4uAwCVSgWVSqXjEZJcFWbdBxQKjB49WqftmJg2QNLFCwxFRESVoNdAlJWVhcuXL0vrycnJSExMhI2NDVxcXDBz5kx88MEHaNasGdzc3PD+++/DyckJQ4YMAQB4enqiX79+mDx5MjZu3IiCggJMnz4dI0eOhJOTEwDglVdewcKFCzFx4kTMnTsX586dw5o1a7Bq1Sp9DJkIRXlZgBCwHTAHxra6OfNYcPc67u5egTt37jAQERFVgl4D0cmTJ9G7d29pvfgy1bhx4xAeHo63334b2dnZmDJlCjIyMtC9e3dERETAxMREes3WrVsxffp09O3bFwYGBhg2bBg++eQTab+VlRX279+P4OBgeHt7w87ODvPmzeMt96R3xrbOUKk99N0NIiKCngORn58fhBBl7lcoFAgLC0NYWFiZZWxsbLBt27Zy22nbti0OHz5c7X4SERFR/ca7zIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9hiIiIiISPYYiIiIiEj2GIiIiIhI9oz03QEi0p0LFy7otH47Ozu4uLjotA0iotrAQERUDxVm3QcUCowePVqn7ZiYNkDSxQsMRUT0zGMgIqqHivKyACFgO2AOjG2dddJGwd3ruLt7Be7cucNARETPPAYionrM2NYZKrWHvrtBRFTncVI1ERERyR4DEREREckeAxERERHJXp0ORAsWLIBCodBaWrZsKe3Pzc1FcHAwbG1tYW5ujmHDhiEtLU2rjpSUFAQFBaFBgwawt7dHSEgIHj16VNtDISIiojqszk+qbtWqFQ4cOCCtGxn9X5dnzZqFPXv24Mcff4SVlRWmT5+OoUOH4ujRowCAwsJCBAUFQa1W49ixY7h16xbGjh0LY2NjfPTRR7U+FiIiIqqb6nwgMjIyglqtLrE9MzMTX331FbZt24Y+ffoAADZt2gRPT08cP34cXbp0wf79+/Hnn3/iwIEDcHBwQPv27bFo0SLMnTsXCxYsgFKprO3hEBERUR1Upy+ZAcClS5fg5OSEpk2bYtSoUUhJSQEAJCQkoKCgAP7+/lLZli1bwsXFBXFxcQCAuLg4tGnTBg4ODlKZwMBAaDQanD9/vsw28/LyoNFotBYiIiKqv+p0IPLx8UF4eDgiIiKwYcMGJCcno0ePHnjw4AFSU1OhVCphbW2t9RoHBwekpqYCAFJTU7XCUPH+4n1lWbx4MaysrKTF2Vk3D7YjIiKiuqFOXzLr37+/9O+2bdvCx8cHrq6u2L59O0xNTXXWbmhoKGbPni2tazQahiIiIqJ6rE6fIXqStbU1mjdvjsuXL0OtViM/Px8ZGRlaZdLS0qQ5R2q1usRdZ8Xrpc1LKqZSqWBpaam1EBERUf31TAWirKwsXLlyBY6OjvD29oaxsTGioqKk/UlJSUhJSYGvry8AwNfXF2fPnkV6erpUJjIyEpaWlvDy8qr1/hMREVHdVKcvmb311lsYOHAgXF1dcfPmTcyfPx+GhoZ4+eWXYWVlhYkTJ2L27NmwsbGBpaUl3njjDfj6+qJLly4AgICAAHh5eWHMmDFYtmwZUlNT8d577yE4OBgqlUrPoyMiIqK6ok4Hohs3buDll1/G3bt30ahRI3Tv3h3Hjx9Ho0aNAACrVq2CgYEBhg0bhry8PAQGBmL9+vXS6w0NDbF7925MmzYNvr6+MDMzw7hx4xAWFqavIREREVEdVKcD0ffff1/ufhMTE6xbtw7r1q0rs4yrqyt+++23mu4aERER1SPP1BwiIiIiIl1gICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZYyAiIiIi2WMgIiIiItljICIiIiLZM9J3B4jo2XbhwgWd1m9nZwcXFxedtkFExEBERNVSmHUfUCgwevRonbZjYtoASRcvMBQRkU4xEBFRtRTlZQFCwHbAHBjbOuukjYK713F39wrcuXOHgYiIdIqBiIieirGtM1RqD313g4joqXBSNREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyR4DEREREckeAxERERHJHgMRERERyZ6RvjtAtSMlJQV37tzRWf0XLlzQWd1ERES6xkAkAykpKWjR0hO5OQ/13RUiIqI6iYFIBu7cuYPcnIewHTAHxrbOOmkj5++TyDy8RSd1ExER6RoDkYwY2zpDpfbQSd0Fd6/rpF4iIqLawEBERHWerueo2dnZwcXFRadtEFHdxkBERHVWYdZ9QKHA6NGjddqOiWkDJF28wFBEJGMMRERUZxXlZQFC6HT+W8Hd67i7ewXu3LnDQEQkYwxERFTn6XL+GxERwAczEhEREfEMERERwInbRHLHQEREssaJ20QEyCwQrVu3DsuXL0dqairatWuHtWvXonPnzvruFhHpUW1O3D58+DA8PT110kYxnokiqh7ZBKIffvgBs2fPxsaNG+Hj44PVq1cjMDAQSUlJsLe313f3iEjPdDlxu7bOQgGASmWC//3vJzg6OuqsDYYuqo9kE4hWrlyJyZMn49VXXwUAbNy4EXv27MHXX3+Nd955R6994xevEtVvtXEWCgByb5xHRvSXGDBggM7aAHj5j+onWQSi/Px8JCQkIDQ0VNpmYGAAf39/xMXF6bFn/OJVIjnR9eMDCu5erzeX//Ly8qBSqXRWf221UV/Opun6P+6A/t8rWQSiO3fuoLCwEA4ODlrbHRwccPHixRLl8/LykJeXJ61nZmYCADQaTY337erVq8jNeQjL54fC0KpRjdcPAPk3/0L2nweRl3oZRfm5Ommj+LvM2AbbYBv6aePxdooK8nTWzqMH//5R1P3lPwUA8cy3oVSZYMu335T4+1OTDAwMUFRUpLP609LSMHrMWOTn6e5nFwBUJqZIOBkPZ+eaC/PFf7eFqMRxFjLwzz//CADi2LFjWttDQkJE586dS5SfP3++wL+fEi5cuHDhwoXLM75cv369wqwgizNEdnZ2MDQ0RFpamtb2tLQ0qNXqEuVDQ0Mxe/Zsab2oqAj37t2Dra0tFApFjfZNo9HA2dkZ169fh6WlZY3WXdfJdexyHTcg37HLddwAxy7HsdelcQsh8ODBAzg5OVVYVhaBSKlUwtvbG1FRURgyZAiAf0NOVFQUpk+fXqK8SqUqcV3Z2tpap320tLTU+w+Ovsh17HIdNyDfsct13ADHLsex15VxW1lZVaqcLAIRAMyePRvjxo1Dp06d0LlzZ6xevRrZ2dnSXWdEREQkX7IJRCNGjMDt27cxb948pKamon379oiIiNDpRDciIiJ6NsgmEAHA9OnTS71Epk8qlQrz58/X+a2fdZFcxy7XcQPyHbtcxw1w7HIc+7M6boUQlbkXjYiIiKj+MtB3B4iIiIj0jYGIiIiIZI+BiIiIiGSPgYiIiIhkj4GoFqxbtw5NmjSBiYkJfHx88Pvvv5db/scff0TLli1hYmKCNm3a4LfffqulntacxYsX4/nnn4eFhQXs7e0xZMgQJCUllfua8PBwKBQKrcXExKSWelwzFixYUGIMLVu2LPc19eF4A0CTJk1KjF2hUCA4OLjU8s/y8T506BAGDhwIJycnKBQK7Ny5U2u/EALz5s2Do6MjTE1N4e/vj0uXLlVYb1V/V9S28sZdUFCAuXPnok2bNjAzM4OTkxPGjh2LmzdvlltndT4z+lDRMR8/fnyJcfTr16/Ceuv6MQcqHntpn3uFQoHly5eXWWddPO4MRDr2ww8/YPbs2Zg/fz5OnTqFdu3aITAwEOnp6aWWP3bsGF5++WVMnDgRp0+fxpAhQzBkyBCcO3eulnv+dGJjYxEcHIzjx48jMjISBQUFCAgIQHZ2drmvs7S0xK1bt6Tl2rVrtdTjmtOqVSutMRw5cqTMsvXleANAfHy81rgjIyMBAP/5z3/KfM2zeryzs7PRrl07rFu3rtT9y5YtwyeffIKNGzfixIkTMDMzQ2BgIHJzy/5yzKr+rtCH8sb98OFDnDp1Cu+//z5OnTqFn3/+GUlJSRg0aFCF9VblM6MvFR1zAOjXr5/WOL777rty63wWjjlQ8dgfH/OtW7fw9ddfQ6FQYNiwYeXWW+eOe418eyqVqXPnziI4OFhaLywsFE5OTmLx4sWlln/ppZdEUFCQ1jYfHx8xdepUnfZT19LT0wUAERsbW2aZTZs2CSsrq9rrlA7Mnz9ftGvXrtLl6+vxFkKIN998U7i7u4uioqJS99eH4y2EEADEjh07pPWioiKhVqvF8uXLpW0ZGRlCpVKJ7777rsx6qvq7Qt+eHHdpfv/9dwFAXLt2rcwyVf3M1AWljX3cuHFi8ODBVarnWTvmQlTuuA8ePFj06dOn3DJ18bjzDJEO5efnIyEhAf7+/tI2AwMD+Pv7Iy4urtTXxMXFaZUHgMDAwDLLPysyMzMBADY2NuWWy8rKgqurK5ydnTF48GCcP3++NrpXoy5dugQnJyc0bdoUo0aNQkpKSpll6+vxzs/Px5YtWzBhwoRyvxC5PhzvJyUnJyM1NVXruFpZWcHHx6fM41qd3xXPgszMTCgUigq/C7Iqn5m6LCYmBvb29mjRogWmTZuGu3fvllm2vh7ztLQ07NmzBxMnTqywbF077gxEOnTnzh0UFhaW+HoQBwcHpKamlvqa1NTUKpV/FhQVFWHmzJno1q0bWrduXWa5Fi1a4Ouvv8auXbuwZcsWFBUVoWvXrrhx40Yt9vbp+Pj4IDw8HBEREdiwYQOSk5PRo0cPPHjwoNTy9fF4A8DOnTuRkZGB8ePHl1mmPhzv0hQfu6oc1+r8rqjrcnNzMXfuXLz88svlfsFnVT8zdVW/fv3wzTffICoqCkuXLkVsbCz69++PwsLCUsvXx2MOAJs3b4aFhQWGDh1abrm6eNxl9dUdpB/BwcE4d+5chdeHfX194evrK6137doVnp6e+Oyzz7Bo0SJdd7NG9O/fX/p327Zt4ePjA1dXV2zfvr1S/2OqL7766iv0798fTk5OZZapD8ebSldQUICXXnoJQghs2LCh3LL15TMzcuRI6d9t2rRB27Zt4e7ujpiYGPTt21ePPatdX3/9NUaNGlXhDRJ18bjzDJEO2dnZwdDQEGlpaVrb09LSoFarS32NWq2uUvm6bvr06di9ezcOHjyIxo0bV+m1xsbG6NChAy5fvqyj3umetbU1mjdvXuYY6tvxBoBr167hwIEDmDRpUpVeVx+ONwDp2FXluFbnd0VdVRyGrl27hsjIyHLPDpWmos/Ms6Jp06aws7Mrcxz16ZgXO3z4MJKSkqr82QfqxnFnINIhpVIJb29vREVFSduKiooQFRWl9T/jx/n6+mqVB4DIyMgyy9dVQghMnz4dO3bsQHR0NNzc3KpcR2FhIc6ePQtHR0cd9LB2ZGVl4cqVK2WOob4c78dt2rQJ9vb2CAoKqtLr6sPxBgA3Nzeo1Wqt46rRaHDixIkyj2t1flfURcVh6NKlSzhw4ABsbW2rXEdFn5lnxY0bN3D37t0yx1FfjvnjvvrqK3h7e6Ndu3ZVfm2dOO76ntVd333//fdCpVKJ8PBw8eeff4opU6YIa2trkZqaKoQQYsyYMeKdd96Ryh89elQYGRmJjz/+WFy4cEHMnz9fGBsbi7Nnz+prCNUybdo0YWVlJWJiYsStW7ek5eHDh1KZJ8e+cOFCsW/fPnHlyhWRkJAgRo4cKUxMTMT58+f1MYRqmTNnjoiJiRHJycni6NGjwt/fX9jZ2Yn09HQhRP093sUKCwuFi4uLmDt3bol99el4P3jwQJw+fVqcPn1aABArV64Up0+flu6mWrJkibC2tha7du0SZ86cEYMHDxZubm4iJydHqqNPnz5i7dq10npFvyvqgvLGnZ+fLwYNGiQaN24sEhMTtT73eXl5Uh1Pjruiz0xdUd7YHzx4IN566y0RFxcnkpOTxYEDB0THjh1Fs2bNRG5urlTHs3jMhaj4510IITIzM0WDBg3Ehg0bSq3jWTjuDES1YO3atcLFxUUolUrRuXNncfz4cWlfr169xLhx47TKb9++XTRv3lwolUrRqlUrsWfPnlru8dMDUOqyadMmqcyTY585c6b0Pjk4OIgXX3xRnDp1qvY7/xRGjBghHB0dhVKpFM8995wYMWKEuHz5srS/vh7vYvv27RMARFJSUol99el4Hzx4sNSf7+LxFRUViffff184ODgIlUol+vbtW+I9cXV1FfPnz9faVt7virqgvHEnJyeX+bk/ePCgVMeT467oM1NXlDf2hw8fioCAANGoUSNhbGwsXF1dxeTJk0sEm2fxmAtR8c+7EEJ89tlnwtTUVGRkZJRax7Nw3BVCCKHTU1BEREREdRznEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRARERGR7DEQERERkewxEBEREZHsMRAR1XFXr16FQqFAYmKivrsiuXjxIrp06QITExO0b99e390plZ+fH2bOnFmt14aHh8Pa2rpG+6MPT/Me1AVNmjTB6tWryy2zYMGCOvszSM8WBiKiCowfPx4KhQJLlizR2r5z504oFAo99Uq/5s+fDzMzMyQlJZX4LjYA2LhxIywsLPDo0SNpW1ZWFoyNjeHn56dVNiYmBgqFAleuXNF1tyttxIgR+Ouvv56qjuJxFS+mpqZo1aoVPv/88xrqZcV+/vlnLFq0qNbaq6wn35vSlpiYGMTHx2PKlCnS6xQKBXbu3Km/jlO9ZqTvDhA9C0xMTLB06VJMnToVDRs21Hd3akR+fj6USmW1XnvlyhUEBQXB1dW11P29e/dGVlYWTp48iS5dugD495uw1Wo1Tpw4gdzcXJiYmAAADh48CBcXF7i7u1e5H0IIFBYWwsioZn+VmZqawtTUtEbqSkpKgqWlJXJycvDrr79i2rRpcHd3R9++fWuk/vLY2NjovI3q6Nq1K27duiWtv/nmm9BoNNi0aZO0zcbGpto/n0TVwTNERJXg7+8PtVqNxYsXl1mmtFP3q1evRpMmTaT18ePHY8iQIfjoo4/g4OAAa2trhIWF4dGjRwgJCYGNjQ0aN26s9Yeh2MWLF9G1a1eYmJigdevWiI2N1dp/7tw59O/fH+bm5nBwcMCYMWNw584dab+fnx+mT5+OmTNnws7ODoGBgaWOo6ioCGFhYWjcuDFUKhXat2+PiIgIab9CoUBCQgLCwsKgUCiwYMGCEnW0aNECjo6OiImJkbbFxMRg8ODBcHNzw/Hjx7W29+7dGwCQl5eHGTNmwN7eHiYmJujevTvi4+O1yioUCuzduxfe3t5QqVQ4cuQIsrOzMXbsWJibm8PR0RErVqwo0af169ejWbNmMDExgYODA4YPH17q+IGSl8yKj+23336LJk2awMrKCiNHjsSDBw/KrKOYvb091Go13NzcMGPGDLi5ueHUqVPS/tIuC7Vv3156X4UQWLBgAVxcXKBSqeDk5IQZM2ZUalxPXjJr0qQJPvroI0yYMAEWFhZwcXEpccbq+vXreOmll2BtbQ0bGxsMHjwYV69elfbHxMSgc+fOMDMzg7W1Nbp164Zr164BAP744w/07t0bFhYWsLS0hLe3N06ePFniPVEqlVCr1dJiamoKlUqltU2pVGq9N8Wfo//3//4fFAqF1ufqSV9++SU8PT1hYmKCli1bYv369WWWJSrGQERUCYaGhvjoo4+wdu1a3Lhx46nqio6Oxs2bN3Ho0CGsXLkS8+fPx4ABA9CwYUOcOHECr732GqZOnVqinZCQEMyZMwenT5+Gr68vBg4ciLt37wIAMjIy0KdPH3To0AEnT55EREQE0tLS8NJLL2nVsXnzZiiVShw9ehQbN24stX9r1qzBihUr8PHHH+PMmTMIDAzEoEGDcOnSJQDArVu30KpVK8yZMwe3bt3CW2+9VWo9vXv3xsGDB6X1gwcPws/PD7169ZK25+Tk4MSJE1Igevvtt/G///0PmzdvxqlTp+Dh4YHAwEDcu3dPq+533nkHS5YswYULF9C2bVuEhIQgNjYWu3btwv79+xETE6MVOk6ePIkZM2YgLCwMSUlJiIiIQM+ePSs8Vo+7cuUKdu7cid27d2P37t2IjY0tcRm1PEIIREREICUlBT4+PpV+3f/+9z+sWrUKn332GS5duoSdO3eiTZs21R7XihUr0KlTJ5w+fRqvv/46pk2bhqSkJABAQUEBAgMDYWFhgcOHD+Po0aMwNzdHv379kJ+fj0ePHmHIkCHo1asXzpw5g7i4OEyZMkW6dDxq1Cg0btwY8fHxSEhIwDvvvANjY+NKj7U8xcF406ZNuHXrllZQftzWrVsxb948fPjhh7hw4QI++ugjvP/++9i8eXON9IPqMb1+tSzRM2DcuHFi8ODBQgghunTpIiZMmCCEEGLHjh3i8Y/Q/PnzRbt27bReu2rVKuHq6qpVl6urqygsLJS2tWjRQvTo0UNaf/TokTAzMxPfffedEEJI3yK+ZMkSqUxBQYFo3LixWLp0qRBCiEWLFomAgACttq9fv671zfO9evUSHTp0qHC8Tk5O4sMPP9Ta9vzzz4vXX39dWm/Xrl2Jb+1+0hdffCHMzMxEQUGB0Gg0wsjISKSnp4tt27aJnj17CiGEiIqKEgDEtWvXRFZWljA2NhZbt26V6sjPzxdOTk5i2bJlQoj/+9btnTt3SmUePHgglEql2L59u7Tt7t27wtTUVLz55ptCCCH+97//CUtLS6HRaCocvxBCbNq0SVhZWUnr8+fPFw0aNNB6fUhIiPDx8SmzjuK+mpmZCTMzM2FkZCQMDAzEBx98oFXO1dVVrFq1Smvb4+/vihUrRPPmzUV+fn6JNioaV69evaT3oLit0aNHS+tFRUXC3t5ebNiwQQghxLfffitatGghioqKpDJ5eXnC1NRU7Nu3T9y9e1cAEDExMaW2Z2FhIcLDw8t8T8ry+GfscU++NwDEjh07tMo8+blzd3cX27Zt0yqzaNEi4evrW+V+kbzwDBFRFSxduhSbN2/GhQsXql1Hq1atYGDwfx89BwcH6X/8wL9no2xtbZGenq71Ol9fX+nfRkZG6NSpk9SPP/74AwcPHoS5ubm0tGzZEgC0Jit7e3uX2zeNRoObN2+iW7duWtu7detW5TH7+fkhOzsb8fHxOHz4MJo3b45GjRqhV69e0jyimJgYNG3aFC4uLrhy5QoKCgq02jY2Nkbnzp1LtN2pUyfp31euXEF+fr7WWRcbGxu0aNFCWn/hhRfg6uqKpk2bYsyYMdi6dSsePnxYpfE0adIEFhYW0rqjo2OJY1Saw4cPIzExEYmJifjyyy/x0UcfYcOGDZVu9z//+Q9ycnLQtGlTTJ48GTt27JAmq1dnXG3btpX+rVAooFarpXH88ccfuHz5MiwsLKSfIxsbG+Tm5uLKlSuwsbHB+PHjERgYiIEDB2LNmjVac4Fmz56NSZMmwd/fH0uWLKn1ifLZ2dm4cuUKJk6cqPVZ+OCDD+rUpH2qmxiIiKqgZ8+eCAwMRGhoaIl9BgYGEEJobSsoKChR7slLCAqFotRtRUVFle5XVlYWBg4cKP3hLV4uXbqkdQnFzMys0nU+LQ8PDzRu3BgHDx7EwYMH0atXLwCAk5MTnJ2dcezYMRw8eBB9+vSpct1VHYeFhQVOnTqF7777Do6Ojpg3bx7atWuHjIyMStdR3WPk5uYGDw8PtGrVCq+++irGjBmDDz/8UNpf0c+Ns7MzkpKSsH79epiamuL1119Hz549UVBQUK1xlTeOrKwseHt7l/g5+uuvv/DKK68A+PeSVVxcHLp27YoffvgBzZs3l+aELViwAOfPn0dQUBCio6Ph5eWFHTt2VPge1ZSsrCwAwBdffKHV/3PnzmnNWyMqDQMRURUtWbIEv/76K+Li4rS2N2rUCKmpqVp/3Gry2UGP/0J/9OgREhIS4OnpCQDo2LEjzp8/jyZNmsDDw0NrqUp4sLS0hJOTE44ePaq1/ejRo/Dy8qpyn3v37o2YmBjExMRo3W7fs2dP7N27F7///rs0f8jd3V2a31SsoKAA8fHx5bbt7u4OY2NjnDhxQtp2//79ErfNGxkZwd/fH8uWLcOZM2dw9epVREdHV3lMT8vQ0BA5OTnSeqNGjbTOsmg0GiQnJ2u9xtTUFAMHDsQnn3yCmJgYxMXF4ezZswBqdlwdO3bEpUuXYG9vX+LnyMrKSirXoUMHhIaG4tixY2jdujW2bdsm7WvevDlmzZqF/fv3Y+jQoaXeIFBdxsbGKCwsLHO/g4MDnJyc8Pfff5fov5ubW431g+on3nZPVEVt2rTBqFGj8Mknn2ht9/Pzw+3bt7Fs2TIMHz4cERER2Lt3LywtLWuk3XXr1qFZs2bw9PTEqlWrcP/+fUyYMAEAEBwcjC+++AIvv/wy3n77bdjY2ODy5cv4/vvv8eWXX8LQ0LDS7YSEhGD+/Plwd3dH+/btsWnTJiQmJmLr1q1V7nPv3r0RHByMgoIC6QwRAPTq1QvTp09Hfn6+FIjMzMwwbdo06W47FxcXLFu2DA8fPsTEiRPLbMPc3BwTJ05ESEgIbG1tYW9vj3fffVfrsuTu3bvx999/o2fPnmjYsCF+++03FBUVaV1W05X09HTk5uYiLy8Pv//+O7799lutO8H69OmD8PBwDBw4ENbW1pg3b57W8QoPD0dhYSF8fHzQoEEDbNmyBaampnB1da3xcY0aNQrLly/H4MGDpTsNr127hp9//hlvv/02CgoK8Pnnn2PQoEFwcnJCUlISLl26hLFjxyInJwchISEYPnw43NzccOPGDcTHx2PYsGFP/R4Wa9KkCaKiotCtWzeoVKpSH4GxcOFCzJgxA1ZWVujXrx/y8vJw8uRJ3L9/H7Nnz66xvlD9w0BEVA1hYWH44YcftLZ5enpi/fr1+Oijj7Bo0SIMGzYMb731Vo09iG/JkiVYsmQJEhMT4eHhgV9++QV2dnYAIJ3VmTt3LgICApCXlwdXV1f069dPKxhUxowZM5CZmYk5c+YgPT0dXl5e+OWXX9CsWbMq97l3797IyclBy5Yt4eDgIG3v1asXHjx4IN2e//gYi4qKMGbMGDx48ACdOnXCvn37Knz20/Lly6XLhhYWFpgzZw4yMzOl/dbW1vj555+xYMEC5ObmolmzZvjuu+/QqlWrKo+pqorDiZGREZydnTF16lStRxWEhoYiOTkZAwYMgJWVFRYtWqR1hsja2hpLlizB7NmzUVhYiDZt2uDXX3+Fra1tjY+rQYMGOHToEObOnYuhQ4fiwYMHeO6559C3b1/pWUoXL17E5s2bcffuXTg6OiI4OBhTp07Fo0ePcPfuXYwdOxZpaWmws7PD0KFDsXDhwqd6/x63YsUKzJ49G1988QWee+45rccBFJs0aRIaNGiA5cuXIyQkBGZmZmjTps0z/cRuqh0K8eTFayIiIiKZ4RwiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSPQYiIiIikj0GIiIiIpI9BiIiIiKSvf8P6JhR3CR/ExAAAAAASUVORK5CYII=", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "def count_words(title):\n", " words = title.split()\n", " return len(words)\n", "\n", "df['total_words_count'] = df['business_title'].apply(count_words)\n", "\n", "plt.hist(df['total_words_count'], bins=range(df['total_words_count'].max() + 2), edgecolor='black')\n", "plt.xlabel('Number of Words in Bussiness Title')\n", "plt.ylabel('Count')\n", "plt.title('Distribution of Words in Titles')\n", "plt.show()" ] }, { "cell_type": "markdown", "id": "e9f80019", "metadata": {}, "source": [ "So we've got titles as short as 0 words and as long as 17.5(?) words. Let's take a look at the first group.\n", "\n" ] }, { "cell_type": "code", "execution_count": 11, "id": "d0319ec3", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Number of titles with 0 words: 13\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_categoryfully_capitalized_words_counttotal_words_count
333https://businessguide.ezega.com/images/noimage.png\\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\tN/ANo description available[0251113453, 0251114254, 02511148900251118151, 025111489302511109950251119149, 02511122000251125923]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763250&bid=3289285&cid=781955AutoSpare Parts00
3509https://businessguide.ezega.com/images/thumb/pict0-13753.jpg?time9/26/2023 9:50:50 AM\\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\tN/ANo description available[]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=794425&bid=3235535&cid=794855AutoResorts00
3602https://businessguide.ezega.com/images/thumb/pict0-13753.jpg?time9/26/2023 9:51:07 AM\\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\tN/ANo description available[]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=794425&bid=3235535&cid=794855&page=0AutoEthiopian Evangelical00
3655https://businessguide.ezega.com/images/noimage.png\\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\tN/ANo description available[6122268326, 0920607823, 251115516777, 251116292285, 251115512686]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764970&bid=1407605&cid=782385AutoEthiopian Evangelical00
3883https://businessguide.ezega.com/images/thumb/pict0-6540.jpg?time9/26/2023 9:51:49 AM\\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\tN/ANo description available[+251116180578, 0911241526, 0911241526, 0115529150, 0115539135]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763680&bid=1684740&cid=771420HealthcareSpa/Massage00
\n", "
" ], "text/plain": [ " business_title \\\n", "333 \n", "3509 \n", "3602 \n", "3655 \n", "3883 \n", "\n", " business_image \\\n", "333 https://businessguide.ezega.com/images/noimage.png \n", "3509 https://businessguide.ezega.com/images/thumb/pict0-13753.jpg?time9/26/2023 9:50:50 AM \n", "3602 https://businessguide.ezega.com/images/thumb/pict0-13753.jpg?time9/26/2023 9:51:07 AM \n", "3655 https://businessguide.ezega.com/images/noimage.png \n", "3883 https://businessguide.ezega.com/images/thumb/pict0-6540.jpg?time9/26/2023 9:51:49 AM \n", "\n", " business_location \\\n", "333 \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \n", "3509 \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \n", "3602 \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \n", "3655 \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \n", "3883 \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \\r\\n\\t \\r\\n\\t \\r\\n \\r\\n\\t \n", "\n", " business_url business_description \\\n", "333 N/A No description available \n", "3509 N/A No description available \n", "3602 N/A No description available \n", "3655 N/A No description available \n", "3883 N/A No description available \n", "\n", " business_numbers \\\n", "333 [0251113453, 0251114254, 02511148900251118151, 025111489302511109950251119149, 02511122000251125923] \n", "3509 [] \n", "3602 [] \n", "3655 [6122268326, 0920607823, 251115516777, 251116292285, 251115512686] \n", "3883 [+251116180578, 0911241526, 0911241526, 0115529150, 0115539135] \n", "\n", " ezega_url \\\n", "333 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763250&bid=3289285&cid=781955 \n", "3509 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=794425&bid=3235535&cid=794855 \n", "3602 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=794425&bid=3235535&cid=794855&page=0 \n", "3655 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764970&bid=1407605&cid=782385 \n", "3883 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=763680&bid=1684740&cid=771420 \n", "\n", " category sub_category fully_capitalized_words_count \\\n", "333 Auto Spare Parts 0 \n", "3509 Auto Resorts 0 \n", "3602 Auto Ethiopian Evangelical 0 \n", "3655 Auto Ethiopian Evangelical 0 \n", "3883 Healthcare Spa/Massage 0 \n", "\n", " total_words_count \n", "333 0 \n", "3509 0 \n", "3602 0 \n", "3655 0 \n", "3883 0 " ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "print(\"Number of titles with 0 words: \", df[df['total_words_count'] == 0].shape[0])\n", "\n", "df[df['total_words_count'] == 0].head()" ] }, { "cell_type": "markdown", "id": "dc013939", "metadata": {}, "source": [ "We'll have to drop these I suppose since there's not much we can do with them. The locations are malformed and the urls go nowhere as well." ] }, { "cell_type": "code", "execution_count": 12, "id": "a16a7b7c", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_categoryfully_capitalized_words_counttotal_words_count
\n", "
" ], "text/plain": [ "Empty DataFrame\n", "Columns: [business_title, business_image, business_location, business_url, business_description, business_numbers, ezega_url, category, sub_category, fully_capitalized_words_count, total_words_count]\n", "Index: []" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = df[df['total_words_count'] != 0]\n", "\n", "df[df['total_words_count'] == 0].head()" ] }, { "cell_type": "markdown", "id": "36e17e55", "metadata": {}, "source": [ "Back to the distribution. Let's now look at the second and figure out why we've got such long titles." ] }, { "cell_type": "code", "execution_count": 13, "id": "d3e2e680", "metadata": {}, "outputs": [ { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAAioAAAHHCAYAAACRAnNyAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjguMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8g+/7EAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA/80lEQVR4nO3dd3wVVf7/8feFVNIoIQ1IoXdQ0EiRUCKBpS4WbAgqiggLCKLG/SpNBVQERYqyLrgqYgXUVVCBgDQNQURcQECaUqIoJKGEkJzfHz5yf1ySQCr3BF/Px+M+1pk5d+Zz7twh7505M9dhjDECAACwUAV3FwAAAFAQggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCv5Sxo8fL4fDcVm21bFjR3Xs2NE5nZSUJIfDoffff/+ybH/QoEGKjo6+LNsqroyMDA0ePFhhYWFyOBwaNWqUu0sqsgv3c3Ht27dPDodDCxYsKPG6isrhcGj8+PGFahsdHa1BgwaVaT3A+QgqKLcWLFggh8PhfPn4+CgiIkIJCQl66aWXlJ6eXirbOXTokMaPH68tW7aUyvpKk821FcYzzzyjBQsWaOjQoXrjjTc0YMCAfNs1btxYLVq0yDN/8eLFcjgciouLy7Ps3//+txwOhz7//PNSr9t2Fx4bBb0KCrLr16/X+PHjdfz48ctaN5AfD3cXAJTUxIkTFRMTo6ysLB05ckRJSUkaNWqUXnjhBX300Udq3ry5s+3//d//6bHHHivS+g8dOqQJEyYoOjpaLVu2LPT7LscfyIvVNm/ePOXk5JR5DSWxcuVKXXfddRo3btxF27Vv316vvfaaTpw4oaCgIOf8devWycPDQ8nJycrKypKnp6fLsooVK6pNmzZlVn9pioqK0unTp136UFwdOnTQG2+84TJv8ODBuvbaa3X//fc75/n7+0uSTp8+LQ+P///nYP369ZowYYIGDRqkypUrl7geoCQIKij3unfvrtatWzunExMTtXLlSvXs2VO9e/fW9u3b5evrK0ny8PBw+Qe5LJw6dUqVKlWSl5dXmW7nUkrjD15ZS01NVePGjS/Zrn379po3b57Wr1+v7t27O+evW7dOt9xyixYuXKiUlBRdd911zmVr165V8+bNFRAQUKIaT548KT8/vxKtozByzwqWhtq1a6t27dou8x544AHVrl1bd955Z572pbVdoCxw6QdXpM6dO+uJJ57Q/v379eabbzrn5zdG5YsvvlD79u1VuXJl+fv7q0GDBnr88ccl/Tmu5JprrpEk3X333c5T5rnjCDp27KimTZsqJSVFHTp0UKVKlZzvLWjsQnZ2th5//HGFhYXJz89PvXv31sGDB13aFDQO4Px1Xqq2/MaonDx5UmPGjFGtWrXk7e2tBg0a6Pnnn9eFP6LucDg0fPhwLVmyRE2bNpW3t7eaNGmiZcuW5f+BXyA1NVX33nuvQkND5ePjoxYtWuj11193Ls8dr7N3717997//dda+b9++fNfXvn17SX8Gk1xnzpzR5s2b1a9fP9WuXdtl2a+//qoff/zR+T5J+vbbb9W9e3cFBgbK399fXbp00caNG122k3vJZPXq1XrwwQcVEhKimjVrOpe/+uqrqlOnjnx9fXXttdfqq6++yrfemTNnqkmTJqpUqZKqVKmi1q1ba+HChRf9zPIbozJo0CD5+/vrl19+Ud++feXv76/q1avr4YcfVnZ29kXXVxTnj1EZP368xo4dK0mKiYm55L6RpOPHj2vUqFHO71XdunU1derUPGf0Fi1apFatWikgIECBgYFq1qyZXnzxxVLrB65MnFHBFWvAgAF6/PHH9fnnn+u+++7Lt80PP/ygnj17qnnz5po4caK8vb21e/du5x+9Ro0aaeLEiXryySd1//336/rrr5cktW3b1rmOY8eOqXv37rr11lt15513KjQ09KJ1Pf3003I4HHr00UeVmpqqGTNmKD4+Xlu2bHGe+SmMwtR2PmOMevfurVWrVunee+9Vy5YttXz5co0dO1a//PKLpk+f7tJ+7dq1+vDDD/Xggw8qICBAL730km688UYdOHBA1apVK7Cu06dPq2PHjtq9e7eGDx+umJgYvffeexo0aJCOHz+ukSNHqlGjRnrjjTf00EMPqWbNmhozZowkqXr16vmus3bt2oqIiNDatWud85KTk3X27Fm1bdtWbdu21bp165zrWb9+vaT/H3B++OEHXX/99QoMDNQjjzwiT09PvfLKK+rYsaNWr16t2NhYl+09+OCDql69up588kmdPHlSkvTaa69pyJAhatu2rUaNGqWffvpJvXv3VtWqVVWrVi3ne+fNm6cRI0bopptu0siRI3XmzBlt3bpVX3/9tW6//fYCP7eCZGdnKyEhQbGxsXr++ef15Zdfatq0aapTp46GDh1a5PVdSr9+/fTjjz/q7bff1vTp0xUcHCyp4H1z6tQpxcXF6ZdfftGQIUMUGRmp9evXKzExUYcPH9aMGTMk/fl/CG677TZ16dJFU6dOlSRt375d69at08iRI0u9H7iCGKCcmj9/vpFkkpOTC2wTFBRkrrrqKuf0uHHjzPlf++nTpxtJ5tdffy1wHcnJyUaSmT9/fp5lcXFxRpKZO3duvsvi4uKc06tWrTKSTI0aNUxaWppz/rvvvmskmRdffNE5LyoqygwcOPCS67xYbQMHDjRRUVHO6SVLlhhJ5qmnnnJpd9NNNxmHw2F2797tnCfJeHl5ucz77rvvjCQzc+bMPNs634wZM4wk8+abbzrnnT171rRp08b4+/u79D0qKsr06NHjouvLdfPNNxtfX19z9uxZY4wxkydPNjExMcYYY2bPnm1CQkKcbR9++GEjyfzyyy/GGGP69u1rvLy8zJ49e5xtDh06ZAICAkyHDh2c83K/U+3btzfnzp1zqT8kJMS0bNnSZGZmOue/+uqrRpLLPunTp49p0qRJofp0vr179+bZlwMHDjSSzMSJE13aXnXVVaZVq1ZFWr+fn1++3ylj/tzf48aNc04/99xzRpLZu3dvnrYXfjcnTZpk/Pz8zI8//ujS7rHHHjMVK1Y0Bw4cMMYYM3LkSBMYGOjyuQKFwaUfXNH8/f0vevdP7kDBpUuXFnvgqbe3t+6+++5Ct7/rrrtcxk3cdNNNCg8P16efflqs7RfWp59+qooVK2rEiBEu88eMGSNjjD777DOX+fHx8apTp45zunnz5goMDNRPP/10ye2EhYXptttuc87z9PTUiBEjlJGRodWrVxer/vbt2+v06dNKSUmR9OdloNyzR+3atVNqaqp27drlXBYTE6OIiAhlZ2fr888/V9++fV3GbYSHh+v222/X2rVrlZaW5rKt++67TxUrVnROb9q0SampqXrggQdcxh4NGjTIZXCv9Od36ueff1ZycnKx+pmfBx54wGX6+uuvv+R+uFzee+89XX/99apSpYp+++035ys+Pl7Z2dlas2aNpD8/l5MnT+qLL75wc8UobwgquKJlZGRcdDBl//791a5dOw0ePFihoaG69dZb9e677xYptNSoUaNIA2fr1avnMu1wOFS3bt2LjgEoDfv371dERESez6NRo0bO5eeLjIzMs44qVarojz/+uOR26tWrpwoVXP95KWg7hXX+OBVjjNavX6927dpJkpo2barAwECtW7dOZ86cUUpKirP9r7/+qlOnTqlBgwZ51tmoUSPl5OTkGSMUExOTp09S3n3n6emZZ9Dqo48+Kn9/f1177bWqV6+ehg0b5jJ+pqh8fHzyXHYpzH64XHbt2qVly5apevXqLq/4+HhJf45Xkv68nFa/fn11795dNWvW1D333FPoMU/4ayOo4Ir1888/68SJE6pbt26BbXx9fbVmzRp9+eWXGjBggLZu3ar+/fvrhhtuKPRgxaKMKymsgh5KV5oDKC/l/DMK5zMXDLy9XFq0aKGAgACtXbtWO3bs0O+//+48o1KhQgXFxsZq7dq1zrEr5w+kLaqS7NNGjRpp586dWrRokdq3b68PPvhA7du3v+Qt2AUpaD/YIicnRzfccIO++OKLfF833nijJCkkJERbtmzRRx995Bwr1b17dw0cONDNPYDtCCq4YuU+RyIhIeGi7SpUqKAuXbrohRde0P/+9z89/fTTWrlypVatWiWp4NBQXLmXJ3IZY7R7926XO3SqVKmS78O2LjwbUZTaoqKidOjQoTyXwnbs2OFcXhqioqK0a9euPGelSrqdihUr6rrrrtO6deu0du1a510juXIH1OaevcgNKtWrV1elSpW0c+fOPOvcsWOHKlSo4DIYtqA+SXn3XVZWlvbu3ZunvZ+fn/r376/58+frwIED6tGjh55++mmdOXOmaJ12k6J8r+rUqaOMjAzFx8fn+zr/zJyXl5d69eql2bNna8+ePRoyZIj+85//aPfu3WXRDVwhCCq4Iq1cuVKTJk1STEyM7rjjjgLb/f7773nm5T44LTMzU5Kcz9Aorad0/uc//3EJC++//74OHz7s8nyQOnXqaOPGjTp79qxz3ieffJLnEkVRavvb3/6m7Oxsvfzyyy7zp0+fLofD4bL9kvjb3/6mI0eO6J133nHOO3funGbOnCl/f/98nyJbWO3bt9evv/6q+fPnKzY21uXyUtu2bbVz504tXbpU1apVc15qqlixorp27aqlS5e6XF47evSoFi5cqPbt2yswMPCi223durWqV6+uuXPnuuyTBQsW5Pnsjx075jLt5eWlxo0byxijrKysYvb88irK9+qWW27Rhg0btHz58jzLjh8/rnPnzknK+7lUqFDB+TDG3GMNyA+3J6Pc++yzz7Rjxw6dO3dOR48e1cqVK/XFF18oKipKH3300UUfZjVx4kStWbNGPXr0UFRUlFJTUzV79mzVrFnT+f/I69Spo8qVK2vu3LkKCAiQn5+fYmNj84xjKKyqVauqffv2uvvuu3X06FHNmDFDdevWdbmFevDgwXr//ffVrVs33XLLLdqzZ4/efPNNl8GtRa2tV69e6tSpk/75z39q3759atGihT7//HMtXbpUo0aNyrPu4rr//vv1yiuvaNCgQUpJSVF0dLTef/99rVu3TjNmzCjRA9hy98mGDRvy/DbNddddJ4fDoY0bN6pXr14uZwWeeuop5/NyHnzwQXl4eOiVV15RZmamnn322Utu19PTU0899ZSGDBmizp07q3///tq7d6/mz5+fZ4xK165dFRYWpnbt2ik0NFTbt2/Xyy+/rB49epT44XOXS6tWrSRJ//znP3XrrbfK09NTvXr1yvfBd2PHjtVHH32knj17atCgQWrVqpVOnjyp77//Xu+//7727dun4OBgDR48WL///rs6d+6smjVrav/+/Zo5c6ZatmzpDJVAvtx6zxFQArm3kua+vLy8TFhYmLnhhhvMiy++6HIbbK4Lb09esWKF6dOnj4mIiDBeXl4mIiLC3HbbbXlutVy6dKlp3Lix8fDwcLmFNC4ursBbUQu6Pfntt982iYmJJiQkxPj6+poePXqY/fv353n/tGnTTI0aNYy3t7dp166d2bRpU551Xqy2C29PNsaY9PR089BDD5mIiAjj6elp6tWrZ5577jmTk5Pj0k6SGTZsWJ6aCrpt+kJHjx41d999twkODjZeXl6mWbNm+d5CXZTbk40x5uTJk85+fv7553mWN2/e3EgyU6dOzbNs8+bNJiEhwfj7+5tKlSqZTp06mfXr17u0udQt77NnzzYxMTHG29vbtG7d2qxZsybPPnnllVdMhw4dTLVq1Yy3t7epU6eOGTt2rDlx4sRF+1bQ7cl+fn552l74PS6MotyebMyftx3XqFHDVKhQweVW5fy+A+np6SYxMdHUrVvXeHl5meDgYNO2bVvz/PPPO28nf//9903Xrl1NSEiI8fLyMpGRkWbIkCHm8OHDReoH/nocxrhpZBwAAMAlMEYFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBa5fqBbzk5OTp06JACAgJK/THnAACgbBhjlJ6eroiIiDw/YHqhch1UDh06dMnf6AAAAHY6ePCgatasedE25Tqo5D6O+uDBg5f8rQ4AAGCHtLQ01apVq1A/K1Gug0ru5Z7AwECCCgAA5Uxhhm0wmBYAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArOX2oPLLL7/ozjvvVLVq1eTr66tmzZpp06ZN7i4LAABYwK2/9fPHH3+oXbt26tSpkz777DNVr15du3btUpUqVdxZFgAAsIRbg8rUqVNVq1YtzZ8/3zkvJibGjRUBAACbuPXSz0cffaTWrVvr5ptvVkhIiK666irNmzfPnSUBAACLuPWMyk8//aQ5c+Zo9OjRevzxx5WcnKwRI0bIy8tLAwcOzNM+MzNTmZmZzum0tLQyre/AgQP67bffynQbAAoWHBysyMhId5cBwI0cxhjjro17eXmpdevWWr9+vXPeiBEjlJycrA0bNuRpP378eE2YMCHP/BMnTigwMLBUaztw4IAaNGykM6dPlep6ARSej28l7dyxnbACXGHS0tIUFBRUqL/fbj2jEh4ersaNG7vMa9SokT744IN82ycmJmr06NHO6bS0NNWqVatMavvtt9905vQpVes5Rp7VymYbAAqWdeygjn0yTb/99htBBfgLc2tQadeunXbu3Oky78cff1RUVFS+7b29veXt7X05SnPyrFZL3mF1L+s2AQDAn9w6mPahhx7Sxo0b9cwzz2j37t1auHChXn31VQ0bNsydZQEAAEu4Nahcc801Wrx4sd5++201bdpUkyZN0owZM3THHXe4sywAAGAJt176kaSePXuqZ8+e7i4DAABYyO2P0AcAACgIQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAttwaV8ePHy+FwuLwaNmzozpIAAIBFPNxdQJMmTfTll186pz083F4SAACwhNtTgYeHh8LCwtxdBgAAsJDbx6js2rVLERERql27tu644w4dOHCgwLaZmZlKS0tzeQEAgCuXW4NKbGysFixYoGXLlmnOnDnau3evrr/+eqWnp+fbfvLkyQoKCnK+atWqdZkrBgAAl5Nbg0r37t118803q3nz5kpISNCnn36q48eP69133823fWJiok6cOOF8HTx48DJXDAAALie3j1E5X+XKlVW/fn3t3r073+Xe3t7y9va+zFUBAAB3cfsYlfNlZGRoz549Cg8Pd3cpAADAAm4NKg8//LBWr16tffv2af369fr73/+uihUr6rbbbnNnWQAAwBJuvfTz888/67bbbtOxY8dUvXp1tW/fXhs3blT16tXdWRYAALCEW4PKokWL3Ll5AABgOavGqAAAAJyPoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALCWNUFlypQpcjgcGjVqlLtLAQAAlrAiqCQnJ+uVV15R8+bN3V0KAACwiNuDSkZGhu644w7NmzdPVapUcXc5AADAIm4PKsOGDVOPHj0UHx9/ybaZmZlKS0tzeQEAgCuXhzs3vmjRIm3evFnJycmFaj958mRNmDChjKsCAAC2cNsZlYMHD2rkyJF666235OPjU6j3JCYm6sSJE87XwYMHy7hKAADgTm47o5KSkqLU1FRdffXVznnZ2dlas2aNXn75ZWVmZqpixYou7/H29pa3t/flLhUAALiJ24JKly5d9P3337vMu/vuu9WwYUM9+uijeUIKAAD463FbUAkICFDTpk1d5vn5+alatWp55gMAgL8mt9/1AwAAUBC33vVzoaSkJHeXAAAALMIZFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYK1iBZXatWvr2LFjeeYfP35ctWvXLnFRAAAAUjGDyr59+5SdnZ1nfmZmpn755ZcSFwUAACBJHkVp/NFHHzn/e/ny5QoKCnJOZ2dna8WKFYqOji614gAAwF9bkYJK3759JUkOh0MDBw50Webp6ano6GhNmzat1IoDAAB/bUUKKjk5OZKkmJgYJScnKzg4uEyKAgAAkIoYVHLt3bu3tOsAAADIo1hBRZJWrFihFStWKDU11XmmJde///3vEhcGAABQrKAyYcIETZw4Ua1bt1Z4eLgcDkdp1wUAAFC8oDJ37lwtWLBAAwYMKO16AAAAnIr1HJWzZ8+qbdu2pV0LAACAi2IFlcGDB2vhwoWlXQsAAICLYl36OXPmjF599VV9+eWXat68uTw9PV2Wv/DCC6VSHAAA+GsrVlDZunWrWrZsKUnatm2byzIG1gIAgNJSrKCyatWq0q4DAAAgj2KNUQEAALgcinVGpVOnThe9xLNy5cpiFwQAAJCrWEEld3xKrqysLG3ZskXbtm3L82OFAAAAxVWsoDJ9+vR8548fP14ZGRklKggAACBXqY5RufPOO/mdHwAAUGpKNahs2LBBPj4+pblKAADwF1asSz/9+vVzmTbG6PDhw9q0aZOeeOKJUikMAACgWEElKCjIZbpChQpq0KCBJk6cqK5du5ZKYQAAAMUKKvPnzy+Vjc+ZM0dz5szRvn37JElNmjTRk08+qe7du5fK+gEAQPlWrKCSKyUlRdu3b5f0Z8i46qqrivT+mjVrasqUKapXr56MMXr99dfVp08fffvtt2rSpElJSgMAAFeAYgWV1NRU3XrrrUpKSlLlypUlScePH1enTp20aNEiVa9evVDr6dWrl8v0008/rTlz5mjjxo0EFQAAULy7fv7xj38oPT1dP/zwg37//Xf9/vvv2rZtm9LS0jRixIhiFZKdna1Fixbp5MmTatOmTbHWAQAArizFOqOybNkyffnll2rUqJFzXuPGjTVr1qwiD6b9/vvv1aZNG505c0b+/v5avHixGjdunG/bzMxMZWZmOqfT0tKKUz4AACgninVGJScnR56ennnme3p6Kicnp0jratCggbZs2aKvv/5aQ4cO1cCBA/W///0v37aTJ09WUFCQ81WrVq3ilA8AAMqJYgWVzp07a+TIkTp06JBz3i+//KKHHnpIXbp0KdK6vLy8VLduXbVq1UqTJ09WixYt9OKLL+bbNjExUSdOnHC+Dh48WJzyAQBAOVGsSz8vv/yyevfurejoaOdZjYMHD6pp06Z68803S1RQTk6Oy+Wd83l7e8vb27tE6wcAAOVHsYJKrVq1tHnzZn355ZfasWOHJKlRo0aKj48v0noSExPVvXt3RUZGKj09XQsXLlRSUpKWL19enLIAAMAVpkhBZeXKlRo+fLg2btyowMBA3XDDDbrhhhskSSdOnFCTJk00d+5cXX/99YVaX2pqqu666y4dPnxYQUFBat68uZYvX+5cJwAA+GsrUlCZMWOG7rvvPgUGBuZZFhQUpCFDhuiFF14odFB57bXXirJ5AADwF1OkwbTfffedunXrVuDyrl27KiUlpcRFAQAASEUMKkePHs33tuRcHh4e+vXXX0tcFAAAgFTEoFKjRg1t27atwOVbt25VeHh4iYsCAACQihhU/va3v+mJJ57QmTNn8iw7ffq0xo0bp549e5ZacQAA4K+tSINp/+///k8ffvih6tevr+HDh6tBgwaSpB07dmjWrFnKzs7WP//5zzIpFAAA/PUUKaiEhoZq/fr1Gjp0qBITE2WMkSQ5HA4lJCRo1qxZCg0NLZNCAQDAX0+RH/gWFRWlTz/9VH/88Yd2794tY4zq1aunKlWqlEV9AADgL6xYT6aVpCpVquiaa64pzVoAAABcFOtHCQEAAC4HggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWm4NKpMnT9Y111yjgIAAhYSEqG/fvtq5c6c7SwIAABZxa1BZvXq1hg0bpo0bN+qLL75QVlaWunbtqpMnT7qzLAAAYAkPd2582bJlLtMLFixQSEiIUlJS1KFDBzdVBQAAbOHWoHKhEydOSJKqVq2a7/LMzExlZmY6p9PS0i5LXQAAwD2sGUybk5OjUaNGqV27dmratGm+bSZPnqygoCDnq1atWpe5SgAAcDlZE1SGDRumbdu2adGiRQW2SUxM1IkTJ5yvgwcPXsYKAQDA5WbFpZ/hw4frk08+0Zo1a1SzZs0C23l7e8vb2/syVgYAANzJrUHFGKN//OMfWrx4sZKSkhQTE+POcgAAgGXcGlSGDRumhQsXaunSpQoICNCRI0ckSUFBQfL19XVnaQAAwAJuHaMyZ84cnThxQh07dlR4eLjz9c4777izLAAAYAm3X/oBAAAoiDV3/QAAAFyIoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALCWW4PKmjVr1KtXL0VERMjhcGjJkiXuLAcAAFjGrUHl5MmTatGihWbNmuXOMgAAgKU83Lnx7t27q3v37u4sAQAAWMytQaWoMjMzlZmZ6ZxOS0tzYzUALoft27e7uwTgLy04OFiRkZFu2365CiqTJ0/WhAkT3F0GgMsgO+MPyeHQnXfe6e5SgL80H99K2rlju9vCSrkKKomJiRo9erRzOi0tTbVq1XJjRQDKSk5mhmSMqvUcI89qHOeAO2QdO6hjn0zTb7/9RlApDG9vb3l7e7u7DACXkWe1WvIOq+vuMgC4Cc9RAQAA1nLrGZWMjAzt3r3bOb13715t2bJFVatWdevAHQAAYAe3BpVNmzapU6dOzunc8ScDBw7UggUL3FQVAACwhVuDSseOHWWMcWcJAADAYoxRAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWIugAgAArEVQAQAA1iKoAAAAaxFUAACAtQgqAADAWgQVAABgLYIKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFQAAYC2CCgAAsBZBBQAAWMuKoDJr1ixFR0fLx8dHsbGx+uabb9xdEgAAsIDbg8o777yj0aNHa9y4cdq8ebNatGihhIQEpaamurs0AADgZm4PKi+88ILuu+8+3X333WrcuLHmzp2rSpUq6d///re7SwMAAG7m1qBy9uxZpaSkKD4+3jmvQoUKio+P14YNG9xYGQAAsIGHOzf+22+/KTs7W6GhoS7zQ0NDtWPHjjztMzMzlZmZ6Zw+ceKEJCktLa3Ua8vIyPhzm0d2K+fsmVJfP4CLyzp2UBLHIOBOWb//LOnPv4ml+bc2d13GmEu2dWtQKarJkydrwoQJeebXqlWrzLb5x/KXy2zdAC6NYxBwv7i4uDJZb3p6uoKCgi7axq1BJTg4WBUrVtTRo0dd5h89elRhYWF52icmJmr06NHO6ZycHP3++++qVq2aHA5HqdaWlpamWrVq6eDBgwoMDCzVdduA/pV/V3ofr/T+SVd+H+lf+VdWfTTGKD09XREREZds69ag4uXlpVatWmnFihXq27evpD/Dx4oVKzR8+PA87b29veXt7e0yr3LlymVaY2Bg4BX7BZTo35XgSu/jld4/6crvI/0r/8qij5c6k5LL7Zd+Ro8erYEDB6p169a69tprNWPGDJ08eVJ33323u0sDAABu5vag0r9/f/3666968skndeTIEbVs2VLLli3LM8AWAAD89bg9qEjS8OHD873U407e3t4aN25cnktNVwr6V/5d6X280vsnXfl9pH/lnw19dJjC3BsEAADgBm5/Mi0AAEBBCCoAAMBaBBUAAGAtggoAALDWFRlU1qxZo169eikiIkIOh0NLliwpsO0DDzwgh8OhGTNmXHK9s2bNUnR0tHx8fBQbG6tvvvnGZfmZM2c0bNgwVatWTf7+/rrxxhvzPHW3NJRF/yZPnqxrrrlGAQEBCgkJUd++fbVz506XNh07dpTD4XB5PfDAA6XQI1dl0b/x48fnqb1hw4YubS7X/pPKpo/R0dF5+uhwODRs2DBnG1v24aBBg/LU0a1bt0uut7wcg8Xpn03HoFQ2fbTpOCyL/pWnY1CStm/frt69eysoKEh+fn665pprdODAgYuu97333lPDhg3l4+OjZs2a6dNPP3VZbozRk08+qfDwcPn6+io+Pl67du0qUV+uyKBy8uRJtWjRQrNmzbpou8WLF2vjxo2FeoTvO++8o9GjR2vcuHHavHmzWrRooYSEBKWmpjrbPPTQQ/r444/13nvvafXq1Tp06JD69etX4v5cqCz6t3r1ag0bNkwbN27UF198oaysLHXt2lUnT550aXfffffp8OHDztezzz5bor7kpyz6J0lNmjRxqX3t2rUuyy/X/pPKpo/Jycku/fviiy8kSTfffLNLO1v2Ybdu3VzqePvtty+6zvJ2DBa1fzYdg1LZ9FGy5zgsi/6Vp2Nwz549at++vRo2bKikpCRt3bpVTzzxhHx8fApc5/r163Xbbbfp3nvv1bfffqu+ffuqb9++2rZtm7PNs88+q5deeklz587V119/LT8/PyUkJOjMmRL8sKi5wkkyixcvzjP/559/NjVq1DDbtm0zUVFRZvr06Rddz7XXXmuGDRvmnM7OzjYRERFm8uTJxhhjjh8/bjw9Pc17773nbLN9+3YjyWzYsKFU+pKf0urfhVJTU40ks3r1aue8uLg4M3LkyJIVXESl1b9x48aZFi1aFLjcXfvPmLLbhyNHjjR16tQxOTk5znm27MOBAweaPn36FGk95ekYLE7/LmTLMWhM6fXR1uOwrPahzcdg//79zZ133lmk9dxyyy2mR48eLvNiY2PNkCFDjDHG5OTkmLCwMPPcc885lx8/ftx4e3ubt99+u3jFG2OuyDMql5KTk6MBAwZo7NixatKkySXbnz17VikpKYqPj3fOq1ChguLj47VhwwZJUkpKirKyslzaNGzYUJGRkc42l0tR+5efEydOSJKqVq3qMv+tt95ScHCwmjZtqsTERJ06darE9RZVcfu3a9cuRUREqHbt2rrjjjtcTnHatP+kku/Ds2fP6s0339Q999yT5wc7bdiHkpSUlKSQkBA1aNBAQ4cO1bFjxwpsW96OQalo/cuPzcdgruL0sTwdhyXZhzYfgzk5Ofrvf/+r+vXrKyEhQSEhIYqNjb3oJWhJ2rBhg8u+kaSEhATnvtm7d6+OHDni0iYoKEixsbEl2n9WPJn2cps6dao8PDw0YsSIQrX/7bfflJ2dneex/qGhodqxY4ck6ciRI/Ly8srzI4mhoaE6cuRIqdRdWEXt34VycnI0atQotWvXTk2bNnXOv/322xUVFaWIiAht3bpVjz76qHbu3KkPP/ywtEovlOL0LzY2VgsWLFCDBg10+PBhTZgwQddff722bdumgIAAq/afVPJ9uGTJEh0/flyDBg1ymW/LPuzWrZv69eunmJgY7dmzR48//ri6d++uDRs2qGLFinnal7djsKj9u5Dtx6BUvD6Wp+OwpPvQ5mMwNTVVGRkZmjJlip566ilNnTpVy5YtU79+/bRq1SrFxcXl+74jR47kewzm7pvc/71Ym+L4ywWVlJQUvfjii9q8eXOelHslKI3+DRs2TNu2bctz7fj+++93/nezZs0UHh6uLl26aM+ePapTp06J6i6s4vave/fuzv9u3ry5YmNjFRUVpXfffVf33ntvWZRabKWxD1977TV17949z9gWG/ahJN16660udTRv3lx16tRRUlKSunTpctnqKCsl7Z/Nx2Cu4vSxPB2HJd2HNh+DOTk5kqQ+ffrooYcekiS1bNlS69ev19y5cwsMKu7yl7v089VXXyk1NVWRkZHy8PCQh4eH9u/frzFjxig6Ojrf9wQHB6tixYp5Rp4fPXpUYWFhkqSwsDCdPXtWx48fL7DN5VCc/p1v+PDh+uSTT7Rq1SrVrFnzom1jY2MlSbt37y6N0gulpP3LVblyZdWvX99Zuy37Typ5H/fv368vv/xSgwcPvmRbd+zD/NSuXVvBwcEF1lGejsH8XKp/57P9GCxIUfqYy+bj8EJF6Z/tx2BwcLA8PDzUuHFjl/mNGjW66F0/YWFhlzwGc+cV1KY4/nJBZcCAAdq6dau2bNnifEVERGjs2LFavnx5vu/x8vJSq1attGLFCue8nJwcrVixQm3atJEktWrVSp6eni5tdu7cqQMHDjjbXA7F6Z/05y1lw4cP1+LFi7Vy5UrFxMRccltbtmyRJIWHh5dW+ZdU3P5dKCMjQ3v27HHWbsv+k0rex/nz5yskJEQ9evS4ZFt37MP8/Pzzzzp27FiBdZSnYzA/l+qfVH6OwYIUpo8Xsvk4vFBR+mf7Mejl5aVrrrkmz+3vP/74o6Kiogp8X5s2bVz2jSR98cUXzn0TExOjsLAwlzZpaWn6+uuvS7b/ij0M12Lp6enm22+/Nd9++62RZF544QXz7bffmv379+fbPr87Kjp37mxmzpzpnF60aJHx9vY2CxYsMP/73//M/fffbypXrmyOHDnibPPAAw+YyMhIs3LlSrNp0ybTpk0b06ZNm3LRv6FDh5qgoCCTlJRkDh8+7HydOnXKGGPM7t27zcSJE82mTZvM3r17zdKlS03t2rVNhw4dykX/xowZY5KSkszevXvNunXrTHx8vAkODjapqanONpdr/5VVH435806YyMhI8+ijj+ZZhy37MD093Tz88MNmw4YNZu/evebLL780V199talXr545c+ZMgf0rL8dgcftn0zFYVn206Tgsi/4ZUz6OQWOM+fDDD42np6d59dVXza5du8zMmTNNxYoVzVdffeVcx4ABA8xjjz3mnF63bp3x8PAwzz//vNm+fbsZN26c8fT0NN9//72zzZQpU0zlypXN0qVLzdatW02fPn1MTEyMOX36dLH7ckUGlVWrVhlJeV4DBw7Mt31+fwSioqLMuHHjXObNnDnTREZGGi8vL3PttdeajRs3uiw/ffq0efDBB02VKlVMpUqVzN///ndz+PDhUuzZn8qif/mtT5KZP3++McaYAwcOmA4dOpiqVasab29vU7duXTN27Fhz4sSJctG//v37m/DwcOPl5WVq1Khh+vfvb3bv3u3ynsu1/4wpu+/o8uXLjSSzc+fOPOuwZR+eOnXKdO3a1VSvXt14enqaqKgoc99997kEjoL6Vx6OweL2z6ZjsKz6aNNxWFbf0fJwDOZ67bXXTN26dY2Pj49p0aKFWbJkics64uLi8vyb9O6775r69esbLy8v06RJE/Pf//7XZXlOTo554oknTGhoqPH29jZdunTJ97MoCocxxhT/fAwAAEDZ+cuNUQEAAOUHQQUAAFiLoAIAAKxFUAEAANYiqAAAAGsRVAAAgLUIKgAAwFoEFaCY9u3bJ4fD4XwEtg127Nih6667Tj4+PmrZsqW7y8lXx44dNWrUqGK9d8GCBXl+Wbc8KslnYIPo6GjNmDHjom3Gjx9v7XcQ5QtBBeXWoEGD5HA4NGXKFJf5S5YsuSJ/Gbswxo0bJz8/P+3cuTPPb3JI0ty5cxUQEKBz584552VkZMjT01MdO3Z0aZuUlCSHw6E9e/aUddmF1r9/f/34448lWkduv3Jfvr6+atKkiV599dVSqvLSPvzwQ02aNOmyba+wLvxs8nslJSUpOTnZ5VeAHQ6HlixZ4r7CcUXzcHcBQEn4+Pho6tSpGjJkiKpUqeLuckrF2bNn5eXlVaz37tmzRz169Cjwh8U6deqkjIwMbdq0Sdddd52kP3+tOSwsTF9//bXOnDkjHx8fSdKqVasUGRlZrJ+eN8YoOztbHh6l+0+Mr6+vfH19S2VdO3fuVGBgoE6fPq2PP/5YQ4cOVZ06ddSlS5dSWf/FVK1atcy3URxt27bV4cOHndMjR45UWlqa5s+f75xXtWrVYn8/geLgjArKtfj4eIWFhWny5MkFtsnvFPSMGTMUHR3tnB40aJD69u2rZ555RqGhoapcubImTpyoc+fOaezYsapatapq1qzp8g92rh07dqht27by8fFR06ZNtXr1apfl27ZtU/fu3eXv76/Q0FANGDBAv/32m3N5x44dNXz4cI0aNUrBwcFKSEjItx85OTmaOHGiatasKW9vb7Vs2VLLli1zLnc4HEpJSdHEiRPlcDg0fvz4POto0KCBwsPDlZSU5JyXlJSkPn36KCYmRhs3bnSZ36lTJ0lSZmamRowYoZCQEPn4+Kh9+/ZKTk52aetwOPTZZ5+pVatW8vb21tq1a3Xy5Enddddd8vf3V3h4uKZNm5anptmzZ6tevXry8fFRaGiobrrppnz7L+W99JO7b9944w1FR0crKChIt956q9LT0wtcR66QkBCFhYUpJiZGI0aMUExMjDZv3uxcnt/ljZYtWzo/V2OMxo8fr8jISHl7eysiIkIjRowoVL8uvPQTHR2tZ555Rvfcc48CAgIUGRmZ5wzPwYMHdcstt6hy5cqqWrWq+vTpo3379jmXJyUl6dprr5Wfn58qV66sdu3aaf/+/ZKk7777Tp06dVJAQIACAwPVqlUrbdq0Kc9n4uXlpbCwMOfL19dX3t7eLvO8vLxcPpvc4+jvf/+7HA6Hy3F1oX/9619q1KiRfHx81LBhQ82ePbvAtkAuggrKtYoVK+qZZ57RzJkz9fPPP5doXStXrtShQ4e0Zs0avfDCCxo3bpx69uypKlWq6Ouvv9YDDzygIUOG5NnO2LFjNWbMGH377bdq06aNevXqpWPHjkmSjh8/rs6dO+uqq67Spk2btGzZMh09elS33HKLyzpef/11eXl5ad26dZo7d26+9b344ouaNm2ann/+eW3dulUJCQnq3bu3du3aJUk6fPiwmjRpojFjxujw4cN6+OGH811Pp06dtGrVKuf0qlWr1LFjR8XFxTnnnz59Wl9//bUzqDzyyCP64IMP9Prrr2vz5s2qW7euEhIS9Pvvv7us+7HHHtOUKVO0fft2NW/eXGPHjtXq1au1dOlSff7550pKSnIJA5s2bdKIESM0ceJE7dy5U8uWLVOHDh0uua/Ot2fPHi1ZskSffPKJPvnkE61evTrP5cCLMcZo2bJlOnDggGJjYwv9vg8++EDTp0/XK6+8ol27dmnJkiVq1qxZsfs1bdo0tW7dWt9++60efPBBDR06VDt37pQkZWVlKSEhQQEBAfrqq6+0bt06+fv7q1u3bjp79qzOnTunvn37Ki4uTlu3btWGDRt0//33Oy+B3nHHHapZs6aSk5OVkpKixx57TJ6enoXu68XkBtb58+fr8OHDLgH2fG+99ZaefPJJPf3009q+fbueeeYZPfHEE3r99ddLpQ5cwUr0k4aAGw0cOND06dPHGGPMddddZ+655x5jjDGLFy8253+1x40bZ1q0aOHy3unTp5uoqCiXdUVFRZns7GznvAYNGpjrr7/eOX3u3Dnj5+dn3n77bWOMMXv37jWSzJQpU5xtsrKyTM2aNc3UqVONMcZMmjTJdO3a1WXbBw8edPl11bi4OHPVVVddsr8RERHm6aefdpl3zTXXmAcffNA53aJFizy/5nqhefPmGT8/P5OVlWXS0tKMh4eHSU1NNQsXLnT+3PyKFSuMJLN//36TkZFhPD09zVtvveVcx9mzZ01ERIR59tlnjTH//5daz//11fT0dOPl5WXeffdd57xjx44ZX19fM3LkSGOMMR988IEJDAw0aWlpl+y/McbMnz/fBAUFOafHjRtnKlWq5PL+sWPHmtjY2ALXkVurn5+f8fPzMx4eHqZChQrmqaeecmmX3y9Wn//5Tps2zdSvX9+cPXs2zzYu1a+4uDjnZ5C7rTvvvNM5nZOTY0JCQsycOXOMMca88cYbpkGDBiYnJ8fZJjMz0/j6+prly5ebY8eOGUkmKSkp3+0FBASYBQsWFPiZFOT8Y+x8F342kszixYtd2lx43NWpU8csXLjQpc2kSZNMmzZtilwX/lo4o4IrwtSpU/X6669r+/btxV5HkyZNVKHC/z8kQkNDnf8PWfrz7E21atWUmprq8r42bdo4/9vDw0OtW7d21vHdd99p1apV8vf3d74aNmwoSS6DVFu1anXR2tLS0nTo0CG1a9fOZX67du2K3OeOHTvq5MmTSk5O1ldffaX69eurevXqiouLc45TSUpKUu3atRUZGak9e/YoKyvLZduenp669tpr82y7devWzv/es2ePzp4963KWomrVqmrQoIFz+oYbblBUVJRq166tAQMG6K233tKpU6eK1J/o6GgFBAQ4p8PDw/Pso/x89dVX2rJli7Zs2aJ//etfeuaZZzRnzpxCb/fmm2/W6dOnVbt2bd13331avHixc5BycfrVvHlz5387HA6FhYU5+/Hdd99p9+7dCggIcH6PqlatqjNnzmjPnj2qWrWqBg0apISEBPXq1Usvvviiy1iT0aNHa/DgwYqPj9eUKVMu+wDpkydPas+ePbr33ntdjoWnnnrKqsHasBNBBVeEDh06KCEhQYmJiXmWVahQQcYYl3lZWVl52l14KtzhcOQ7Lycnp9B1ZWRkqFevXs4/iLmvXbt2uVwK8PPzK/Q6S6pu3bqqWbOmVq1apVWrVikuLk6SFBERoVq1amn9+vVatWqVOnfuXOR1F7UfAQEB2rx5s95++22Fh4frySefVIsWLXT8+PFCr6O4+ygmJkZ169ZVkyZNdPfdd2vAgAF6+umnncsv9b2pVauWdu7cqdmzZ8vX11cPPvigOnTooKysrGL162L9yMjIUKtWrfJ8j3788Ufdfvvtkv689LJhwwa1bdtW77zzjurXr+8cczR+/Hj98MMP6tGjh1auXKnGjRtr8eLFl/yMSktGRoYkad68eS71b9u2zWVcFJAfggquGFOmTNHHH3+sDRs2uMyvXr26jhw54vJHpzSffXL+P7Tnzp1TSkqKGjVqJEm6+uqr9cMPPyg6Olp169Z1eRXlj3pgYKAiIiK0bt06l/nr1q1T48aNi1xzp06dlJSUpKSkJJfbkjt06KDPPvtM33zzjXN8Sp06dZzjZ3JlZWUpOTn5otuuU6eOPD099fXXXzvn/fHHH3luL/bw8FB8fLyeffZZbd26Vfv27dPKlSuL3KeSqlixok6fPu2crl69ustZibS0NO3du9flPb6+vurVq5deeuklJSUlacOGDfr+++8llW6/rr76au3atUshISF5vkdBQUHOdldddZUSExO1fv16NW3aVAsXLnQuq1+/vh566CF9/vnn6tevX74Dw4vL09NT2dnZBS4PDQ1VRESEfvrppzz1x8TElFoduDJxezKuGM2aNdMdd9yhl156yWV+x44d9euvv+rZZ5/VTTfdpGXLlumzzz5TYGBgqWx31qxZqlevnho1aqTp06frjz/+0D333CNJGjZsmObNm6fbbrtNjzzyiKpWrardu3dr0aJF+te//qWKFSsWejtjx47VuHHjVKdOHbVs2VLz58/Xli1b9NZbbxW55k6dOmnYsGHKyspynlGRpLi4OA0fPlxnz551BhU/Pz8NHTrUefdTZGSknn32WZ06dUr33ntvgdvw9/fXvffeq7Fjx6patWoKCQnRP//5T5fLa5988ol++ukndejQQVWqVNGnn36qnJwcl8tDZSU1NVVnzpxRZmamvvnmG73xxhsud+Z07txZCxYsUK9evVS5cmU9+eSTLvtrwYIFys7OVmxsrCpVqqQ333xTvr6+ioqKKvV+3XHHHXruuefUp08f551f+/fv14cffqhHHnlEWVlZevXVV9W7d29FRERo586d2rVrl+666y6dPn1aY8eO1U033aSYmBj9/PPPSk5O1o033ljizzBXdHS0VqxYoXbt2snb2zvfRwVMmDBBI0aMUFBQkLp166bMzExt2rRJf/zxh0aPHl1qteDKQ1DBFWXixIl65513XOY1atRIs2fP1jPPPKNJkybpxhtv1MMPP1xqD/iaMmWKpkyZoi1btqhu3br66KOPFBwcLEnOsyCPPvqounbtqszMTEVFRalbt24uf7ALY8SIETpx4oTGjBmj1NRUNW7cWB999JHq1atX5Jo7deqk06dPq2HDhgoNDXXOj4uLU3p6uvM25vP7mJOTowEDBig9PV2tW7fW8uXLL/nsmueee855+SsgIEBjxozRiRMnnMsrV66sDz/8UOPHj9eZM2dUr149vf3222rSpEmR+1RUuaHBw8NDtWrV0pAhQ1xu6U5MTNTevXvVs2dPBQUFadKkSS5nVCpXrqwpU6Zo9OjRys7OVrNmzfTxxx+rWrVqpd6vSpUqac2aNXr00UfVr18/paenq0aNGurSpYvzWTA7duzQ66+/rmPHjik8PFzDhg3TkCFDdO7cOR07dkx33XWXjh49quDgYPXr108TJkwo0ed3vmnTpmn06NGaN2+eatSo4XLbdK7BgwerUqVKeu655zR27Fj5+fmpWbNm5foJvbg8HObCi7AAAACWYIwKAACwFkEFAABYi6ACAACsRVABAADWIqgAAABrEVQAAIC1CCoAAMBaBBUAAGAtggoAALAWQQUAAFiLoAIAAKxFUAEAANb6f/kz0rfSjdGgAAAAAElFTkSuQmCC", "text/plain": [ "
" ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "(10, 11)\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_categoryfully_capitalized_words_counttotal_words_count
1160Addis ababa water and sewerage authority invitation to bid is a company located in Addis Ababa, Ethhttps://businessguide.ezega.com/images/thumb/pict0-12890.jpg?time9/26/2023 9:44:42 AMAddis Ababa,EthiopiaN/ANo description available[251116620010, +251115575566, 25111663059866338156632754, 0115159213, 0114655687, 0116630597]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764540&bid=3049990&cid=784750&page=3AutoSpare Parts017
1948HOLIDAY IN ETHIOPIA | VACATION IN ETHIOPIA | OVERLAND ETHIOPIA TOUR | ETHIOPIA TOUR PACKAGES AND Ehttps://businessguide.ezega.com/images/thumb/pict0-2738.jpg?time9/26/2023 9:46:44 AMEthiopiahttp://www.overlandethiopiatours.com[+251911444601, +251913689229+251911678366, +251913689229+251911678366, +251116522507, +25111551349455045535528822, +251118602442]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766045&bid=867310&cid=791200&page=4AutoOther Tour/Travel1417
5810Southern Nations, Nationalities & People’s Regional State - Institute For The Study of Nationalitieshttps://businessguide.ezega.com/images/thumb/pict0-303.jpg?time9/26/2023 9:56:39 AMAwassahttp://www.snnprs.gov.etNo description available[046220588704622040620462214779046220, 0462210074, 1546, 0462206364, 0462260370, 0462209870, 04622070690462205863, 04622039610462200282]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766690&bid=343785&cid=777870&page=3EducationSuppliers014
6336Addistech security camera/CCTV/, Home Alarm, Time attendance machine & Fire Alarm system provider chttps://businessguide.ezega.com/images/thumb/pict0-5256.jpg?time9/26/2023 9:57:46 AMBole Africa Ave, DH Geda Tower #206www.addistechsolution.comNo description available[0912604414, 0911502614, 18368, +2519132560640911306530, 862150320898, 251111570898, +251115549172, +25111156200715724831572485]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765400&bid=1408680&cid=774000&page=0EducationSuppliers014
6344Addistech security camera/CCTV/, Home Alarm, Time attendance machine & Fire Alarm system provider chttps://businessguide.ezega.com/images/thumb/pict0-5256.jpg?time9/26/2023 9:57:47 AMBole Africa Ave, DH Geda Tower #206www.addistechsolution.comNo description available[0912604414, 0911502614, 18368, +2519132560640911306530, 862150320898, 251111570898, +251115549172, +25111156200715724831572485]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765400&bid=1408680&cid=774000EducationSuppliers014
\n", "
" ], "text/plain": [ " business_title \\\n", "1160 Addis ababa water and sewerage authority invitation to bid is a company located in Addis Ababa, Eth \n", "1948 HOLIDAY IN ETHIOPIA | VACATION IN ETHIOPIA | OVERLAND ETHIOPIA TOUR | ETHIOPIA TOUR PACKAGES AND E \n", "5810 Southern Nations, Nationalities & People’s Regional State - Institute For The Study of Nationalities \n", "6336 Addistech security camera/CCTV/, Home Alarm, Time attendance machine & Fire Alarm system provider c \n", "6344 Addistech security camera/CCTV/, Home Alarm, Time attendance machine & Fire Alarm system provider c \n", "\n", " business_image \\\n", "1160 https://businessguide.ezega.com/images/thumb/pict0-12890.jpg?time9/26/2023 9:44:42 AM \n", "1948 https://businessguide.ezega.com/images/thumb/pict0-2738.jpg?time9/26/2023 9:46:44 AM \n", "5810 https://businessguide.ezega.com/images/thumb/pict0-303.jpg?time9/26/2023 9:56:39 AM \n", "6336 https://businessguide.ezega.com/images/thumb/pict0-5256.jpg?time9/26/2023 9:57:46 AM \n", "6344 https://businessguide.ezega.com/images/thumb/pict0-5256.jpg?time9/26/2023 9:57:47 AM \n", "\n", " business_location \\\n", "1160 Addis Ababa,Ethiopia \n", "1948 Ethiopia \n", "5810 Awassa \n", "6336 Bole Africa Ave, DH Geda Tower #206 \n", "6344 Bole Africa Ave, DH Geda Tower #206 \n", "\n", " business_url business_description \\\n", "1160 N/A No description available \n", "1948 http://www.overlandethiopiatours.com   \n", "5810 http://www.snnprs.gov.et No description available \n", "6336 www.addistechsolution.com No description available \n", "6344 www.addistechsolution.com No description available \n", "\n", " business_numbers \\\n", "1160 [251116620010, +251115575566, 25111663059866338156632754, 0115159213, 0114655687, 0116630597] \n", "1948 [+251911444601, +251913689229+251911678366, +251913689229+251911678366, +251116522507, +25111551349455045535528822, +251118602442] \n", "5810 [046220588704622040620462214779046220, 0462210074, 1546, 0462206364, 0462260370, 0462209870, 04622070690462205863, 04622039610462200282] \n", "6336 [0912604414, 0911502614, 18368, +2519132560640911306530, 862150320898, 251111570898, +251115549172, +25111156200715724831572485] \n", "6344 [0912604414, 0911502614, 18368, +2519132560640911306530, 862150320898, 251111570898, +251115549172, +25111156200715724831572485] \n", "\n", " ezega_url \\\n", "1160 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764540&bid=3049990&cid=784750&page=3 \n", "1948 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766045&bid=867310&cid=791200&page=4 \n", "5810 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766690&bid=343785&cid=777870&page=3 \n", "6336 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765400&bid=1408680&cid=774000&page=0 \n", "6344 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=765400&bid=1408680&cid=774000 \n", "\n", " category sub_category fully_capitalized_words_count \\\n", "1160 Auto Spare Parts 0 \n", "1948 Auto Other Tour/Travel 14 \n", "5810 Education Suppliers 0 \n", "6336 Education Suppliers 0 \n", "6344 Education Suppliers 0 \n", "\n", " total_words_count \n", "1160 17 \n", "1948 17 \n", "5810 14 \n", "6336 14 \n", "6344 14 " ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "upper_bound = 14\n", "\n", "plt.hist(df[df['total_words_count'] >= upper_bound]['total_words_count'], bins=range(upper_bound, df[df['total_words_count'] >= upper_bound]['total_words_count'].max() ), edgecolor='black')\n", "plt.xlabel('Number of Words in Bussiness Title')\n", "plt.ylabel('Count')\n", "plt.title('Distribution of Words in Titles')\n", "plt.show()\n", "\n", "print(df[df['total_words_count'] >= upper_bound].shape)\n", "df[df['total_words_count'] >= upper_bound].head()" ] }, { "cell_type": "code", "execution_count": 14, "id": "375d1aed", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "(4, 11)\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_categoryfully_capitalized_words_counttotal_words_count
1160Addis ababa water and sewerage authority invitation to bid is a company located in Addis Ababa, Ethhttps://businessguide.ezega.com/images/thumb/pict0-12890.jpg?time9/26/2023 9:44:42 AMAddis Ababa,EthiopiaN/ANo description available[251116620010, +251115575566, 25111663059866338156632754, 0115159213, 0114655687, 0116630597]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764540&bid=3049990&cid=784750&page=3AutoSpare Parts017
1948HOLIDAY IN ETHIOPIA | VACATION IN ETHIOPIA | OVERLAND ETHIOPIA TOUR | ETHIOPIA TOUR PACKAGES AND Ehttps://businessguide.ezega.com/images/thumb/pict0-2738.jpg?time9/26/2023 9:46:44 AMEthiopiahttp://www.overlandethiopiatours.com[+251911444601, +251913689229+251911678366, +251913689229+251911678366, +251116522507, +25111551349455045535528822, +251118602442]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766045&bid=867310&cid=791200&page=4AutoOther Tour/Travel1417
6750Caltex lubricants | Dubai | UAE | Saudi Arabia | Saudi | Bahrain | Kuwait /Oman Egypthttps://businessguide.ezega.com/images/noimage.pngNational Oil Ethiopia, PLC Bole Sub-City, on Cape Verde street Addis Ababa Ethiopiahttps://me.caltexlubricants.com/No description available[043373220, 0904647909, +251911515139, +251116620911, +25111646088586, +25111552845255110973]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=767765&bid=3260045&cid=777655&page=5EducationSuppliers117
7189Gethan Trading and Technology PLC - Food Stuffs Local Distributer and Agent Eden Spring Waterhttps://businessguide.ezega.com/images/thumb/pict0-13495.jpg?time9/26/2023 10:00:00 AMBole Sub city, around Jakros, EBM building Office No. 2AF2018N/ANo description available[+251911642409+251930797079, +251921146614, +251118613504, +251115512186, +251911423244, +251221120373, +2511166245326188000]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764325&bid=3180065&cid=778300EducationInternational Organizations115
\n", "
" ], "text/plain": [ " business_title \\\n", "1160 Addis ababa water and sewerage authority invitation to bid is a company located in Addis Ababa, Eth \n", "1948 HOLIDAY IN ETHIOPIA | VACATION IN ETHIOPIA | OVERLAND ETHIOPIA TOUR | ETHIOPIA TOUR PACKAGES AND E \n", "6750 Caltex lubricants | Dubai | UAE | Saudi Arabia | Saudi | Bahrain | Kuwait /Oman Egypt \n", "7189 Gethan Trading and Technology PLC - Food Stuffs Local Distributer and Agent Eden Spring Water \n", "\n", " business_image \\\n", "1160 https://businessguide.ezega.com/images/thumb/pict0-12890.jpg?time9/26/2023 9:44:42 AM \n", "1948 https://businessguide.ezega.com/images/thumb/pict0-2738.jpg?time9/26/2023 9:46:44 AM \n", "6750 https://businessguide.ezega.com/images/noimage.png \n", "7189 https://businessguide.ezega.com/images/thumb/pict0-13495.jpg?time9/26/2023 10:00:00 AM \n", "\n", " business_location \\\n", "1160 Addis Ababa,Ethiopia \n", "1948 Ethiopia \n", "6750 National Oil Ethiopia, PLC Bole Sub-City, on Cape Verde street Addis Ababa Ethiopia \n", "7189 Bole Sub city, around Jakros, EBM building Office No. 2AF2018 \n", "\n", " business_url business_description \\\n", "1160 N/A No description available \n", "1948 http://www.overlandethiopiatours.com   \n", "6750 https://me.caltexlubricants.com/ No description available \n", "7189 N/A No description available \n", "\n", " business_numbers \\\n", "1160 [251116620010, +251115575566, 25111663059866338156632754, 0115159213, 0114655687, 0116630597] \n", "1948 [+251911444601, +251913689229+251911678366, +251913689229+251911678366, +251116522507, +25111551349455045535528822, +251118602442] \n", "6750 [043373220, 0904647909, +251911515139, +251116620911, +25111646088586, +25111552845255110973] \n", "7189 [+251911642409+251930797079, +251921146614, +251118613504, +251115512186, +251911423244, +251221120373, +2511166245326188000] \n", "\n", " ezega_url \\\n", "1160 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764540&bid=3049990&cid=784750&page=3 \n", "1948 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766045&bid=867310&cid=791200&page=4 \n", "6750 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=767765&bid=3260045&cid=777655&page=5 \n", "7189 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764325&bid=3180065&cid=778300 \n", "\n", " category sub_category fully_capitalized_words_count \\\n", "1160 Auto Spare Parts 0 \n", "1948 Auto Other Tour/Travel 14 \n", "6750 Education Suppliers 1 \n", "7189 Education International Organizations 1 \n", "\n", " total_words_count \n", "1160 17 \n", "1948 17 \n", "6750 17 \n", "7189 15 " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "upper_bound = 15\n", "\n", "print(df[df['total_words_count'] >= upper_bound].shape)\n", "df[df['total_words_count'] >= upper_bound].head()" ] }, { "cell_type": "code", "execution_count": 15, "id": "55878c30", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "(3, 11)\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
business_titlebusiness_imagebusiness_locationbusiness_urlbusiness_descriptionbusiness_numbersezega_urlcategorysub_categoryfully_capitalized_words_counttotal_words_count
1160Addis ababa water and sewerage authority invitation to bid is a company located in Addis Ababa, Ethhttps://businessguide.ezega.com/images/thumb/pict0-12890.jpg?time9/26/2023 9:44:42 AMAddis Ababa,EthiopiaN/ANo description available[251116620010, +251115575566, 25111663059866338156632754, 0115159213, 0114655687, 0116630597]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764540&bid=3049990&cid=784750&page=3AutoSpare Parts017
1948HOLIDAY IN ETHIOPIA | VACATION IN ETHIOPIA | OVERLAND ETHIOPIA TOUR | ETHIOPIA TOUR PACKAGES AND Ehttps://businessguide.ezega.com/images/thumb/pict0-2738.jpg?time9/26/2023 9:46:44 AMEthiopiahttp://www.overlandethiopiatours.com[+251911444601, +251913689229+251911678366, +251913689229+251911678366, +251116522507, +25111551349455045535528822, +251118602442]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766045&bid=867310&cid=791200&page=4AutoOther Tour/Travel1417
6750Caltex lubricants | Dubai | UAE | Saudi Arabia | Saudi | Bahrain | Kuwait /Oman Egypthttps://businessguide.ezega.com/images/noimage.pngNational Oil Ethiopia, PLC Bole Sub-City, on Cape Verde street Addis Ababa Ethiopiahttps://me.caltexlubricants.com/No description available[043373220, 0904647909, +251911515139, +251116620911, +25111646088586, +25111552845255110973]https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=767765&bid=3260045&cid=777655&page=5EducationSuppliers117
\n", "
" ], "text/plain": [ " business_title \\\n", "1160 Addis ababa water and sewerage authority invitation to bid is a company located in Addis Ababa, Eth \n", "1948 HOLIDAY IN ETHIOPIA | VACATION IN ETHIOPIA | OVERLAND ETHIOPIA TOUR | ETHIOPIA TOUR PACKAGES AND E \n", "6750 Caltex lubricants | Dubai | UAE | Saudi Arabia | Saudi | Bahrain | Kuwait /Oman Egypt \n", "\n", " business_image \\\n", "1160 https://businessguide.ezega.com/images/thumb/pict0-12890.jpg?time9/26/2023 9:44:42 AM \n", "1948 https://businessguide.ezega.com/images/thumb/pict0-2738.jpg?time9/26/2023 9:46:44 AM \n", "6750 https://businessguide.ezega.com/images/noimage.png \n", "\n", " business_location \\\n", "1160 Addis Ababa,Ethiopia \n", "1948 Ethiopia \n", "6750 National Oil Ethiopia, PLC Bole Sub-City, on Cape Verde street Addis Ababa Ethiopia \n", "\n", " business_url business_description \\\n", "1160 N/A No description available \n", "1948 http://www.overlandethiopiatours.com   \n", "6750 https://me.caltexlubricants.com/ No description available \n", "\n", " business_numbers \\\n", "1160 [251116620010, +251115575566, 25111663059866338156632754, 0115159213, 0114655687, 0116630597] \n", "1948 [+251911444601, +251913689229+251911678366, +251913689229+251911678366, +251116522507, +25111551349455045535528822, +251118602442] \n", "6750 [043373220, 0904647909, +251911515139, +251116620911, +25111646088586, +25111552845255110973] \n", "\n", " ezega_url \\\n", "1160 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=764540&bid=3049990&cid=784750&page=3 \n", "1948 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=766045&bid=867310&cid=791200&page=4 \n", "6750 https://businessguide.ezega.com/Default.aspx?action=BussinessDetail&pid=767765&bid=3260045&cid=777655&page=5 \n", "\n", " category sub_category fully_capitalized_words_count \\\n", "1160 Auto Spare Parts 0 \n", "1948 Auto Other Tour/Travel 14 \n", "6750 Education Suppliers 1 \n", "\n", " total_words_count \n", "1160 17 \n", "1948 17 \n", "6750 17 " ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "upper_bound = 16\n", "\n", "print(df[df['total_words_count'] >= upper_bound].shape)\n", "df[df['total_words_count'] >= upper_bound].head()" ] }, { "cell_type": "markdown", "id": "e6889683", "metadata": {}, "source": [ "Browsing through the titles with different legnths shows that the title inflation is essential a result of poor data entry and/or registration practices. Some of them have legitimate reasons to be that long while others are a result of business owners entering contant information or taglines into title names.\n", "\n", "Regardless we'll have to find a way to work around it." ] }, { "cell_type": "code", "execution_count": null, "id": "c4631a8c", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "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.11.5" } }, "nbformat": 4, "nbformat_minor": 5 }