click ảo.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ------------- data analysis and wrangling-------------------\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import random as rnd\n",
    "from pandas import DataFrame\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")\n",
    "import shap\n",
    "# ------------------------------------------------------------\n",
    "\n",
    "# ------- import các tool visualization ----------------------\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "# ------------------------------------------------------------"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "eda = pd.read_excel(r\"D:\\Le Hieu\\Data Science\\click ao.xlsx\")\n",
    "eda = pd.DataFrame(eda)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "eda1 = pd.read_excel(r\"D:\\Le Hieu\\Data Science\\click ao.xlsx\")\n",
    "eda1 = pd.DataFrame(eda1)\n",
    "eda1 = eda1.drop(['Đang chặn','VPN/Proxy','Vị trí'],axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>#</th>\n",
       "      <th>Địa chỉ IP</th>\n",
       "      <th>Từ khóa</th>\n",
       "      <th>Loại từ khóa</th>\n",
       "      <th>Vi phạm</th>\n",
       "      <th>Đang chặn</th>\n",
       "      <th>Thời điểm click</th>\n",
       "      <th>Hệ điều hành</th>\n",
       "      <th>Trình duyệt</th>\n",
       "      <th>Wifi/4G</th>\n",
       "      <th>Nhà mạng</th>\n",
       "      <th>Thiết bị</th>\n",
       "      <th>VPN/Proxy</th>\n",
       "      <th>Trang đích</th>\n",
       "      <th>Thành phố</th>\n",
       "      <th>Quốc gia</th>\n",
       "      <th>Mạng hiển thị</th>\n",
       "      <th>Vị trí</th>\n",
       "      <th>Chiến dịch</th>\n",
       "      <th>Nhóm quảng cáo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>118.71.135.89</td>\n",
       "      <td>đăng ký đầu tư chứng khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16:24:06 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>MIUI Browser</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>FPT Telecom Company</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hà Nội</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>171.252.193.38</td>\n",
       "      <td>đăng ký tài khoản chứng khoán vndirect</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>X</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15:54:50 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cellular</td>\n",
       "      <td>Viettel Corporation</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Ha Long,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>171.252.193.38</td>\n",
       "      <td>+đăng +ký +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15:49:11 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cellular</td>\n",
       "      <td>Viettel Corporation</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Ha Long,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>103.249.21.22</td>\n",
       "      <td>tao tai khoan chung khoan</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15:38:16 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Android Browser</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>Cloudvis technology company limited</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Di An,Binh Duong,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>113.172.140.68</td>\n",
       "      <td>tao tai khoan chung khoan</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15:36:11 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>VDC</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hồ Chí Minh</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\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>1849</th>\n",
       "      <td>1850</td>\n",
       "      <td>14.239.144.173</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>07:52:16 20/10/2020</td>\n",
       "      <td>iOS</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>VDC</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hải Phòng</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850</th>\n",
       "      <td>1851</td>\n",
       "      <td>113.185.74.167</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>04:03:29 20/10/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Android Browser</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>VDC</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Long Khanh,Dong Nai,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851</th>\n",
       "      <td>1852</td>\n",
       "      <td>8.39.127.182</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03:14:23 20/10/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Level 3 Communications</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Đồng Nai</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852</th>\n",
       "      <td>1853</td>\n",
       "      <td>42.116.129.247</td>\n",
       "      <td>đăng ký đầu tư chứng khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:18:46 20/10/2020</td>\n",
       "      <td>iOS</td>\n",
       "      <td>Mobile Safari</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>FPT Telecom Company</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hồ Chí Minh</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1853</th>\n",
       "      <td>1854</td>\n",
       "      <td>103.199.57.93</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>00:17:54 20/10/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cellular</td>\n",
       "      <td>Mobifone-</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>NaN</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hồ Chí Minh</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1854 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         #      Địa chỉ IP                                 Từ khóa  \\\n",
       "0        1   118.71.135.89              đăng ký đầu tư chứng khoán   \n",
       "1        2  171.252.193.38  đăng ký tài khoản chứng khoán vndirect   \n",
       "2        3  171.252.193.38     +đăng +ký +tài +khoản +chứng +khoán   \n",
       "3        4   103.249.21.22               tao tai khoan chung khoan   \n",
       "4        5  113.172.140.68               tao tai khoan chung khoan   \n",
       "...    ...             ...                                     ...   \n",
       "1849  1850  14.239.144.173           +mở +tài +khoản +chứng +khoán   \n",
       "1850  1851  113.185.74.167           +mở +tài +khoản +chứng +khoán   \n",
       "1851  1852    8.39.127.182           +mở +tài +khoản +chứng +khoán   \n",
       "1852  1853  42.116.129.247              đăng ký đầu tư chứng khoán   \n",
       "1853  1854   103.199.57.93           +mở +tài +khoản +chứng +khoán   \n",
       "\n",
       "       Loại từ khóa Vi phạm  Đang chặn      Thời điểm click Hệ điều hành  \\\n",
       "0     Đối sánh rộng     NaN        NaN  16:24:06 16/11/2020      Android   \n",
       "1     Đối sánh rộng       X        NaN  15:54:50 16/11/2020      Android   \n",
       "2     Đối sánh rộng     NaN        NaN  15:49:11 16/11/2020      Android   \n",
       "3     Đối sánh rộng     NaN        NaN  15:38:16 16/11/2020      Android   \n",
       "4     Đối sánh rộng     NaN        NaN  15:36:11 16/11/2020      Android   \n",
       "...             ...     ...        ...                  ...          ...   \n",
       "1849  Đối sánh rộng     NaN        NaN  07:52:16 20/10/2020          iOS   \n",
       "1850  Đối sánh rộng     NaN        NaN  04:03:29 20/10/2020      Android   \n",
       "1851  Đối sánh rộng     NaN        NaN  03:14:23 20/10/2020      Android   \n",
       "1852  Đối sánh rộng     NaN        NaN  00:18:46 20/10/2020          iOS   \n",
       "1853  Đối sánh rộng     NaN        NaN  00:17:54 20/10/2020      Android   \n",
       "\n",
       "          Trình duyệt       Wifi/4G                             Nhà mạng  \\\n",
       "0        MIUI Browser  Cố định/Wifi                  FPT Telecom Company   \n",
       "1              Chrome      Cellular                  Viettel Corporation   \n",
       "2              Chrome      Cellular                  Viettel Corporation   \n",
       "3     Android Browser  Cố định/Wifi  Cloudvis technology company limited   \n",
       "4              Chrome  Cố định/Wifi                                  VDC   \n",
       "...               ...           ...                                  ...   \n",
       "1849           Chrome  Cố định/Wifi                                  VDC   \n",
       "1850  Android Browser  Cố định/Wifi                                  VDC   \n",
       "1851           Chrome     Corporate               Level 3 Communications   \n",
       "1852    Mobile Safari  Cố định/Wifi                  FPT Telecom Company   \n",
       "1853           Chrome      Cellular                            Mobifone-   \n",
       "\n",
       "     Thiết bị  VPN/Proxy                                         Trang đích  \\\n",
       "0      Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1      Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "2      Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "3      Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "4      Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "...       ...        ...                                                ...   \n",
       "1849   Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1850   Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1851   Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1852   Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1853   Mobile        NaN  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "\n",
       "                        Thành phố Quốc gia  Mạng hiển thị  Vị trí  \\\n",
       "0                          Hà Nội       VN  Google search     NaN   \n",
       "1                 Ha Long,Vietnam       VN  Google search     NaN   \n",
       "2                 Ha Long,Vietnam       VN  Google search     NaN   \n",
       "3        Di An,Binh Duong,Vietnam       VN  Google search     NaN   \n",
       "4                    Hồ Chí Minh        VN  Google search     NaN   \n",
       "...                           ...      ...            ...     ...   \n",
       "1849                    Hải Phòng       VN  Google search     NaN   \n",
       "1850  Long Khanh,Dong Nai,Vietnam       VN  Google search     NaN   \n",
       "1851                     Đồng Nai       VN  Google search     NaN   \n",
       "1852                 Hồ Chí Minh        VN  Google search     NaN   \n",
       "1853                 Hồ Chí Minh        VN  Google search     NaN   \n",
       "\n",
       "        Chiến dịch   Nhóm quảng cáo  \n",
       "0     VCSC adwords  1. VCSC Adwords  \n",
       "1     VCSC adwords  1. VCSC Adwords  \n",
       "2     VCSC adwords  1. VCSC Adwords  \n",
       "3     VCSC adwords  1. VCSC Adwords  \n",
       "4     VCSC adwords  1. VCSC Adwords  \n",
       "...            ...              ...  \n",
       "1849  VCSC adwords  1. VCSC Adwords  \n",
       "1850  VCSC adwords  1. VCSC Adwords  \n",
       "1851  VCSC adwords  1. VCSC Adwords  \n",
       "1852  VCSC adwords  1. VCSC Adwords  \n",
       "1853  VCSC adwords  1. VCSC Adwords  \n",
       "\n",
       "[1854 rows x 20 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "eda"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>#</th>\n",
       "      <th>Địa chỉ IP</th>\n",
       "      <th>Từ khóa</th>\n",
       "      <th>Loại từ khóa</th>\n",
       "      <th>Vi phạm</th>\n",
       "      <th>Đang chặn</th>\n",
       "      <th>Thời điểm click</th>\n",
       "      <th>Hệ điều hành</th>\n",
       "      <th>Trình duyệt</th>\n",
       "      <th>Wifi/4G</th>\n",
       "      <th>Nhà mạng</th>\n",
       "      <th>Thiết bị</th>\n",
       "      <th>VPN/Proxy</th>\n",
       "      <th>Trang đích</th>\n",
       "      <th>Thành phố</th>\n",
       "      <th>Quốc gia</th>\n",
       "      <th>Mạng hiển thị</th>\n",
       "      <th>Vị trí</th>\n",
       "      <th>Chiến dịch</th>\n",
       "      <th>Nhóm quảng cáo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>118.71.135.89</td>\n",
       "      <td>đăng ký đầu tư chứng khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16:24:06 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>MIUI Browser</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>FPT Telecom Company</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hà Nội</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>171.252.193.38</td>\n",
       "      <td>đăng ký tài khoản chứng khoán vndirect</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15:54:50 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cellular</td>\n",
       "      <td>Viettel Corporation</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Ha Long,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>171.252.193.38</td>\n",
       "      <td>+đăng +ký +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15:49:11 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cellular</td>\n",
       "      <td>Viettel Corporation</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Ha Long,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>103.249.21.22</td>\n",
       "      <td>tao tai khoan chung khoan</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15:38:16 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Android Browser</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>Cloudvis technology company limited</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Di An,Binh Duong,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>113.172.140.68</td>\n",
       "      <td>tao tai khoan chung khoan</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15:36:11 16/11/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>VDC</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hồ Chí Minh</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\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>1849</th>\n",
       "      <td>1850</td>\n",
       "      <td>14.239.144.173</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>07:52:16 20/10/2020</td>\n",
       "      <td>iOS</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>VDC</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hải Phòng</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850</th>\n",
       "      <td>1851</td>\n",
       "      <td>113.185.74.167</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>04:03:29 20/10/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Android Browser</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>VDC</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Long Khanh,Dong Nai,Vietnam</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851</th>\n",
       "      <td>1852</td>\n",
       "      <td>8.39.127.182</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>03:14:23 20/10/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Level 3 Communications</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Đồng Nai</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852</th>\n",
       "      <td>1853</td>\n",
       "      <td>42.116.129.247</td>\n",
       "      <td>đăng ký đầu tư chứng khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>00:18:46 20/10/2020</td>\n",
       "      <td>iOS</td>\n",
       "      <td>Mobile Safari</td>\n",
       "      <td>Cố định/Wifi</td>\n",
       "      <td>FPT Telecom Company</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hồ Chí Minh</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1853</th>\n",
       "      <td>1854</td>\n",
       "      <td>103.199.57.93</td>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>Đối sánh rộng</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>00:17:54 20/10/2020</td>\n",
       "      <td>Android</td>\n",
       "      <td>Chrome</td>\n",
       "      <td>Cellular</td>\n",
       "      <td>Mobifone-</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>0.0</td>\n",
       "      <td>&lt;a href=\"https://invest.vcsc.com.vn/mo-tai-kho...</td>\n",
       "      <td>Hồ Chí Minh</td>\n",
       "      <td>VN</td>\n",
       "      <td>Google search</td>\n",
       "      <td>0.0</td>\n",
       "      <td>VCSC adwords</td>\n",
       "      <td>1. VCSC Adwords</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1854 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         #      Địa chỉ IP                                 Từ khóa  \\\n",
       "0        1   118.71.135.89              đăng ký đầu tư chứng khoán   \n",
       "1        2  171.252.193.38  đăng ký tài khoản chứng khoán vndirect   \n",
       "2        3  171.252.193.38     +đăng +ký +tài +khoản +chứng +khoán   \n",
       "3        4   103.249.21.22               tao tai khoan chung khoan   \n",
       "4        5  113.172.140.68               tao tai khoan chung khoan   \n",
       "...    ...             ...                                     ...   \n",
       "1849  1850  14.239.144.173           +mở +tài +khoản +chứng +khoán   \n",
       "1850  1851  113.185.74.167           +mở +tài +khoản +chứng +khoán   \n",
       "1851  1852    8.39.127.182           +mở +tài +khoản +chứng +khoán   \n",
       "1852  1853  42.116.129.247              đăng ký đầu tư chứng khoán   \n",
       "1853  1854   103.199.57.93           +mở +tài +khoản +chứng +khoán   \n",
       "\n",
       "       Loại từ khóa  Vi phạm  Đang chặn      Thời điểm click Hệ điều hành  \\\n",
       "0     Đối sánh rộng        0        0.0  16:24:06 16/11/2020      Android   \n",
       "1     Đối sánh rộng        1        0.0  15:54:50 16/11/2020      Android   \n",
       "2     Đối sánh rộng        0        0.0  15:49:11 16/11/2020      Android   \n",
       "3     Đối sánh rộng        0        0.0  15:38:16 16/11/2020      Android   \n",
       "4     Đối sánh rộng        0        0.0  15:36:11 16/11/2020      Android   \n",
       "...             ...      ...        ...                  ...          ...   \n",
       "1849  Đối sánh rộng        0        0.0  07:52:16 20/10/2020          iOS   \n",
       "1850  Đối sánh rộng        0        0.0  04:03:29 20/10/2020      Android   \n",
       "1851  Đối sánh rộng        0        0.0  03:14:23 20/10/2020      Android   \n",
       "1852  Đối sánh rộng        0        0.0  00:18:46 20/10/2020          iOS   \n",
       "1853  Đối sánh rộng        0        0.0  00:17:54 20/10/2020      Android   \n",
       "\n",
       "          Trình duyệt       Wifi/4G                             Nhà mạng  \\\n",
       "0        MIUI Browser  Cố định/Wifi                  FPT Telecom Company   \n",
       "1              Chrome      Cellular                  Viettel Corporation   \n",
       "2              Chrome      Cellular                  Viettel Corporation   \n",
       "3     Android Browser  Cố định/Wifi  Cloudvis technology company limited   \n",
       "4              Chrome  Cố định/Wifi                                  VDC   \n",
       "...               ...           ...                                  ...   \n",
       "1849           Chrome  Cố định/Wifi                                  VDC   \n",
       "1850  Android Browser  Cố định/Wifi                                  VDC   \n",
       "1851           Chrome     Corporate               Level 3 Communications   \n",
       "1852    Mobile Safari  Cố định/Wifi                  FPT Telecom Company   \n",
       "1853           Chrome      Cellular                            Mobifone-   \n",
       "\n",
       "     Thiết bị  VPN/Proxy                                         Trang đích  \\\n",
       "0      Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1      Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "2      Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "3      Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "4      Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "...       ...        ...                                                ...   \n",
       "1849   Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1850   Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1851   Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1852   Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "1853   Mobile        0.0  <a href=\"https://invest.vcsc.com.vn/mo-tai-kho...   \n",
       "\n",
       "                        Thành phố Quốc gia  Mạng hiển thị  Vị trí  \\\n",
       "0                          Hà Nội       VN  Google search     0.0   \n",
       "1                 Ha Long,Vietnam       VN  Google search     0.0   \n",
       "2                 Ha Long,Vietnam       VN  Google search     0.0   \n",
       "3        Di An,Binh Duong,Vietnam       VN  Google search     0.0   \n",
       "4                    Hồ Chí Minh        VN  Google search     0.0   \n",
       "...                           ...      ...            ...     ...   \n",
       "1849                    Hải Phòng       VN  Google search     0.0   \n",
       "1850  Long Khanh,Dong Nai,Vietnam       VN  Google search     0.0   \n",
       "1851                     Đồng Nai       VN  Google search     0.0   \n",
       "1852                 Hồ Chí Minh        VN  Google search     0.0   \n",
       "1853                 Hồ Chí Minh        VN  Google search     0.0   \n",
       "\n",
       "        Chiến dịch   Nhóm quảng cáo  \n",
       "0     VCSC adwords  1. VCSC Adwords  \n",
       "1     VCSC adwords  1. VCSC Adwords  \n",
       "2     VCSC adwords  1. VCSC Adwords  \n",
       "3     VCSC adwords  1. VCSC Adwords  \n",
       "4     VCSC adwords  1. VCSC Adwords  \n",
       "...            ...              ...  \n",
       "1849  VCSC adwords  1. VCSC Adwords  \n",
       "1850  VCSC adwords  1. VCSC Adwords  \n",
       "1851  VCSC adwords  1. VCSC Adwords  \n",
       "1852  VCSC adwords  1. VCSC Adwords  \n",
       "1853  VCSC adwords  1. VCSC Adwords  \n",
       "\n",
       "[1854 rows x 20 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "eda = eda.fillna(0)\n",
    "eda[\"Vi phạm\"].replace({\"X\": 1}, inplace=True)\n",
    "# eda[\"Đang chặn\"].replace({\"X\": 1}, inplace=True)\n",
    "eda"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Cơ chế click ảo khá bài bản, ko thấy tập trung vào 1 nhánh nào cụ thể để loại bỏ\n",
    "đủ các loại hệ điều hành ios, windown, android,... đủ cả các loại mạng wiki hay 4G. Thiết bị cũng vậy."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Target looks like classification\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXgAAAEWCAYAAABsY4yMAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAASQElEQVR4nO3de7AkZX3G8e8j64LcbxKBBRcEjWCMl42RaBIFShENeCtLooIgakwMCkFFiUSteL+WpaVBELkpIqKipfGCimVEcVERUAkrLLCAIEHCijcWfvljesNwPLs7u+f0mdl3v5+qU6enu6f7mbN7nul5p6dPqgpJUnvuM+4AkqR+WPCS1CgLXpIaZcFLUqMseElqlAUvSY2y4LXBS/LCJN8euv3rJLvP0rZfl+Skbnphkkoyb5a2vWuXdaPZ2J7aY8Fr1nRls/Lr7iS/Hbr9vDnK8IQky2ayjaravKqumo39VNVbqurImeQZ2ufSJPsPbfvaLutds7F9tWdWjiQkGBTjyukkS4Ejq+pra7ONJPOqasVsZxuHlh6L1k8ewat3SR6T5MIktyW5MckHkswfWl5J/inJlcCV3bxXd+vekOTIbp09umUbJ3lXkmuT3JTkw0nul2Qz4EvATkOvHHaaJs92Sc5LcnuSi4AHTVk+vK8Dk/wkyfIk1yc5dlX7SfKGJOckOSPJ7cALu3lnTIlwRPe4bkzyL0P7/ViSfx+6/f+vEpKcDuwKfL7b36unDvl0Gc5LcmuSJUlePLStNyQ5O8lp3WO5PMmitf/X1PrEgtdcuAs4Gtge2AfYD/jHKes8HfhLYK8kBwDHAPsDewB/O2XdtwMPBh7RLd8ZOKGq7gCeAtzQDV1sXlU3TJPng8DvgB2BI7qvVTkZeGlVbQE8DPj6GvZzMHAOsDVw5iq2+URgT+BJwHHDwy6rUlUvAK4F/q7b3zumWe0TwDJgJ+DZwFuS7De0/CDgrC7becAH1rRfrd8sePWuqi6uqu9W1YqqWgr8B39c2m+tqlur6rfAc4BTquryqvoN8MaVKyUJ8GLg6G795cBbgOeOkqV7Q/JZdE8IVXUZcOpq7nIngyedLavqV1X1gzXs4sKq+mxV3d09lum8sdv3pcApwCGjZF+dJLsAjwdeU1W/q6ofAScBLxha7dtV9cVuzP504M9nul9NNgtevUvy4CRfSPKLbujiLQyO5oddNzS905Tbw9P3BzYFLu6GfG4D/rObP4r7M3jvaXib16xm/WcBBwLXJLkgyT5r2P51a1g+dZ1rGDzemdoJWPmEN7ztnYdu/2Jo+jfAJrN1Ro8mkwWvufAh4GfAnlW1JfA6IFPWGb6s6Y3AgqHbuwxN3wL8Fti7qrbuvrYaeoN3TZdH/SWwYso2d13VylX1/ao6GNgB+Cxw9hr2M8rlWafue+Xwzh0MnrxWesBabPsGYNskW0zZ9vUj5FGjLHjNhS2A24FfJ/lT4GVrWP9s4PAkD02yKXDCygVVdTfwEeC9SXYASLJzkid3q9wEbJdkq+k23A1PnAu8IcmmSfYCDptu3STzkzwvyVZVdWf3GFaekrja/azB67t97w0cDnyym/8j4MAk2yZ5APDKKfe7CZj2/Pyqug74DvDWJJskeTjwIlb9PoA2ABa85sKxwN8DyxmU8ydXt3JVfQl4P/ANYAlwYbfo993313Tzv9sN+XwNeEh3358xeLPxqm4IZ7rhj5cDmzMYsvgYg3HwVXkBsLTbzz8Az1+L/azKBV3+84F3VdVXuvmnA5cAS4Gv8Mc/p7cC/9rt79hptnsIsJDB0fxngH+rqq+uRS41Jv7BD026JA8FLgM29rxyaXQewWsiJXlGN0SyDYPTIj9vuUtrx4LXpHopgzdEf85g3HtN4/aSpnCIRpIa5RG8JDVqoj7ksP3229fChQvHHUOS1hsXX3zxLVU17Qf9JqrgFy5cyOLFi8cdQ5LWG0lW+Ulsh2gkqVEWvCQ1yoKXpEZZ8JLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalRE/VJ1p8u+x8e/arTxh1DkubMxe88tLdtewQvSY2y4CWpURa8JDXKgpekRlnwktQoC16SGmXBS1KjLHhJapQFL0mNsuAlqVEWvCQ1yoKXpEZZ8JLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalRFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY2y4CWpURa8JDXKgpekRlnwktQoC16SGmXBS1KjLHhJapQFL0mNsuAlqVEWvCQ1yoKXpEZZ8JLUKAtekhplwUtSoyx4SWpUrwWf5IAkVyRZkuS4PvclSbq33go+yUbAB4GnAHsBhyTZq6/9SZLurc8j+McAS6rqqqr6A3AWcHCP+5MkDemz4HcGrhu6vaybdy9JXpJkcZLFK36zvMc4krRh6bPgM828+qMZVSdW1aKqWjRv0y16jCNJG5Y+C34ZsMvQ7QXADT3uT5I0pM+C/z6wZ5LdkswHnguc1+P+JElD5vW14apakeTlwJeBjYCPVtXlfe1PknRvvRU8QFV9Efhin/uQJE3PT7JKUqMseElqlAUvSY2y4CWpURa8JDXKgpekRlnwktQoC16SGmXBS1KjLHhJapQFL0mNsuAlqVEWvCQ1yoKXpEZZ8JLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalRFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY2y4CWpURa8JDXKgpekRlnwktQoC16SGmXBS1KjLHhJapQFL0mNsuAlqVEWvCQ1at64Awx76ILtWPzOQ8cdQ5KaMNIRfJIHJdm4m35CkqOSbN1vNEnSTIw6RPNp4K4kewAnA7sBH+8tlSRpxkYt+LuragXwDOB9VXU0sGN/sSRJMzVqwd+Z5BDgMOAL3bz79hNJkjQbRi34w4F9gDdX1dVJdgPO6C+WJGmmRjqLpqp+AhwFkGQbYIuqelufwSRJMzPqWTTfTLJlkm2BS4BTkryn32iSpJkYdYhmq6q6HXgmcEpVPRrYv79YkqSZGrXg5yXZEXgO97zJKkmaYKMW/JuALwNLqur7SXYHruwvliRppkZ9k/VTwKeGbl8FPKuvUJKkmRup4JNsArwI2BvYZOX8qjqip1ySpBkadYjmdOABwJOBC4AFwPK+QkmSZm7Ugt+jql4P3FFVpwJPBf6sv1iSpJka+VIF3ffbkjwM2ApY2EsiSdKsGPV68Cd2n2B9PXAesDlwQm+pJEkzNupZNCd1kxcAu/cXR5I0W1Zb8EmOWd3yqvJyBZI0odZ0BL9F972ATFlWsx9HkjRbVlvwVfVGgCSnAq+oqtu629sA7+4/niRpXY16Fs3DV5Y7QFX9CnhkP5EkSbNh1LNo7pNkm67Y6S4bPOp9R/aHGy/n2jetH6fX73rCpeOOIEmrNWpJvxv4TpJzGIy9Pwd4c2+pJEkzNuppkqclWQzsy+DN1md2f+VJkjShRh5m6QrdUpek9cSob7JKktYzFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY2y4CWpURa8JDXKgpekRlnwktQoC16SGmXBS1KjLHhJapQFL0mNsuAlqVEWvCQ1yoKXpEZZ8JLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalRFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY2y4CWpURa8JDXKgpekRlnwktSo3go+yUeT3Jzksr72IUlatT6P4D8GHNDj9iVJq9FbwVfVt4Bb+9q+JGn1xj4Gn+QlSRYnWXzrHXeNO44kNWPsBV9VJ1bVoqpatO1mG407jiQ1Y+wFL0nqhwUvSY3q8zTJTwAXAg9JsizJi/ralyTpj83ra8NVdUhf25YkrZlDNJLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalRFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY2y4CWpURa8JDXKgpekRlnwktQoC16SGmXBS1KjLHhJapQFL0mNsuAlqVEWvCQ1yoKXpEZZ8JLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalRFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY2y4CWpUfPGHWDY/B33ZtcTFo87hiQ1wSN4SWqUBS9JjbLgJalRFrwkNcqCl6RGWfCS1CgLXpIaZcFLUqMseElqlAUvSY1KVY07w/9Lshy4Ytw5VmF74JZxh1gFs60bs60bs627PvI9sKruP92CiboWDXBFVS0ad4jpJFlstrVntnVjtnUzydlg7vM5RCNJjbLgJalRk1bwJ447wGqYbd2Ybd2Ybd1McjaY43wT9SarJGn2TNoRvCRplljwktSoiSj4JAckuSLJkiTHjWH/uyT5RpKfJrk8ySu6+dsm+WqSK7vv2wzd57Vd3iuSPHkOMm6U5IdJvjBJ2ZJsneScJD/rfn77TFC2o7t/z8uSfCLJJuPMluSjSW5OctnQvLXOk+TRSS7tlr0/SXrK9s7u3/XHST6TZOtJyTa07NgklWT7ScqW5J+7/V+e5B3jyAZAVY31C9gI+DmwOzAfuATYa44z7Ag8qpveAvhvYC/gHcBx3fzjgLd303t1OTcGduvyb9RzxmOAjwNf6G5PRDbgVODIbno+sPUkZAN2Bq4G7tfdPht44TizAX8DPAq4bGjeWucBLgL2AQJ8CXhKT9meBMzrpt8+Sdm6+bsAXwauAbaflGzAE4GvARt3t3cYR7aqmogj+McAS6rqqqr6A3AWcPBcBqiqG6vqB930cuCnDAriYAYFRvf96d30wcBZVfX7qroaWMLgcfQiyQLgqcBJQ7PHni3Jlgz+g58MUFV/qKrbJiFbZx5wvyTzgE2BG8aZraq+Bdw6ZfZa5UmyI7BlVV1Yg2Y4beg+s5qtqr5SVSu6m98FFkxKts57gVcDw2eKTEK2lwFvq6rfd+vcPI5sMBlDNDsD1w3dXtbNG4skC4FHAt8D/qSqboTBkwCwQ7faXGd+H4P/yHcPzZuEbLsDvwRO6YaPTkqy2SRkq6rrgXcB1wI3Av9bVV+ZhGxTrG2enbvpuc55BIMjy4nIluQg4PqqumTKorFnAx4M/HWS7yW5IMlfjCvbJBT8dGNNYzl3M8nmwKeBV1bV7atbdZp5vWRO8jTg5qq6eNS7TDOvr5/nPAYvTz9UVY8E7mAwzLAqc/lz24bBEdNuwE7AZkmePwnZRrSqPHOeM8nxwArgzJWzVpFhTrIl2RQ4HjhhusWryDDXvxfbAI8FXgWc3Y2pz3m2SSj4ZQzG0lZawOCl9JxKcl8G5X5mVZ3bzb6pe/lE933lS625zPw44KAkSxkMX+2b5IwJybYMWFZV3+tun8Og8Cch2/7A1VX1y6q6EzgX+KsJyTZsbfMs456hkt5zJjkMeBrwvG74YBKyPYjBE/cl3e/FAuAHSR4wAdno9nVuDVzE4JX39uPINgkF/31gzyS7JZkPPBc4by4DdM+uJwM/rar3DC06Dzismz4M+NzQ/Ocm2TjJbsCeDN4kmXVV9dqqWlBVCxn8bL5eVc+fkGy/AK5L8pBu1n7ATyYhG4Ohmccm2bT7992PwXsrk5Bt2Frl6YZxlid5bPe4Dh26z6xKcgDwGuCgqvrNlMxjy1ZVl1bVDlW1sPu9WMbgJIlfjDtb57PAvgBJHszg5INbxpJtNt6pnekXcCCDM1d+Dhw/hv0/nsFLoh8DP+q+DgS2A84Hruy+bzt0n+O7vFcwS+94j5DzCdxzFs1EZAMeASzufnafZfDSdFKyvRH4GXAZcDqDsxfGlg34BIP3A+5kUEovWpc8wKLuMf0c+ADdJ9J7yLaEwZjxyt+JD09KtinLl9KdRTMJ2RgU+hndvn4A7DuObFXlpQokqVWTMEQjSeqBBS9JjbLgJalRFrwkNcqCl6RGWfDSLEryyu6TltLYeZqkNIu6T1Yuqqpbxp1F8gheG5wkh2ZwjfNLkpye5IFJzu/mnZ9k1269jyV59tD9ft19f0KSb+ae6+CfmYGjGFz35htJvjGeRyfdY964A0hzKcneDD5N+LiquiXJtgwu03taVZ2a5Ajg/az5cq2PBPZmcM2Q/+q29/4kxwBP9Ahek8AjeG1o9gXOWVnAVXUrgz+08PFu+ekMLl2xJhdV1bKqupvBx/gX9pBVmhELXhuasOZLsa5cvoLud6S7CNT8oXV+PzR9F74a1gSy4LWhOR94TpLtYPA3UYHvMLhSJ8DzgG9300uBR3fTBwP3HWH7yxn82Udp7Dzq0Aalqi5P8mbggiR3AT8EjgI+muRVDP5C1eHd6h8BPpfkIgZPDHeMsIsTgS8lubGqnjj7j0AanadJSlKjHKKRpEZZ8JLUKAtekhplwUtSoyx4SWqUBS9JjbLgJalR/wcds7fNjZfCgQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABagAAAF6CAYAAAD8nb9mAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzdeZgdVZ3/8feHRbawyCISVKIioDIBF1AZQERlRgzLKK7oiKKgjqjjPogQcFxwZwQHkGERBRcUBMQfqBhRkE3AsCiiQEQCyiKETcTw/f1R1VA0tzvd6U5ud/J+PU8/XffUqXNOXTpF3e899T2pKiRJkiRJkiRJWtyW6fcAJEmSJEmSJElLJwPUkiRJkiRJkqS+MEAtSZIkSZIkSeoLA9SSJEmSJEmSpL4wQC1JkiRJkiRJ6gsD1JIkSZIkSZKkvjBALUmSpAkpyd1JnjLGNo5N8t/jNSZJkiRJ48sAtSRJ0hIsyeuTXNwGe29K8sMkW4/w2Eqy4aIe41CqakpVXbuo2k+yR5L57Xsz8HPoOLT5i/EaYz8l2b3zvtyX5MHue7UYx+GXDJIkSUswA9SSJElLqCTvA74EfBJYF3gS8BVgl36Oa0GSLLcYu/tlGwgf+HnXYuz7URbzuQ+rqr4x8L4ALwPmdt+rkbYzkc5JkiRJE48BakmSpCVQktWBg4D/qKrvVdU9VfVAVZ1WVR9s62yZ5JdJ7mhnVx+a5DHtvnPapn7dzph9TVs+I8ll7THnJZne6fPZSS5NcleS7yT5Vnfma5K3Jfl9ktuTnJpkamdfJfmPJNcA13TKNmy3V0ry+SRzktyZ5BdJVmr3fSfJzW35OUmeOQ7v33Dn+ZEkf2jP86ok/9aWPx04HHhB+57d0ZbPSvLWzvGPmGU9xLkP1/+Hk9zY9n91khf3GP/z2/dk2U7ZvyWZ3W5v2c6sn5fkz0m+MMr3p+d70Dm/c5N8McntwMwkayU5re3voiT/Peg92CTJj9q/jauTvLot3wvYHfhQ+56eNppxSpIkaeIzQC1JkrRkegGwInDyMHXmA/8JrN3WfzHwToCq2rats1k7Y/ZbSZ4NHA3sDawFHAGcmmSFNrB9MnAssCZwItANWm4PfAp4NbAeMAf45qDx7Ao8D3hGj7F+DngOsFXb/oeAB9t9PwSeBjwOuAT4xjDnvEDDnWdb5Q/ANsDqwIHA15OsV1W/Ad7Ow7Oy1xhFtw+d+wLe542BdwFbVNWqwL8A1w9urKrOB+4Btu8Uvx44od0+BDikqlYDngp8exRjhSHeg87+5wHX0vw3+QRwWDuexwNvan8ASLIK8KN2bI8DXgd8Jckzq+pImv+en2nf051GOU5JkiRNcAaoJUmSlkxrAbdW1T+GqlBVv6qq86vqH1V1PU0g9IXDtPk24IiquqCq5lfVccD9wPPbn+WA/2lnan8PuLBz7O7A0VV1SVXdD/wXzUzjaZ06n6qq26vqvm6nSZYB3gK8p6pubPs+r22Hqjq6qu5qX88ENmtnkI/E89tZygM/z1/AeVJV36mquVX1YFV9i2bW85Yj7G8o3XMfrv/5wAo0gezlq+r6qvrDEG2eSBPsJcmqwI5tGcADwIZJ1q6qu9uA9oiN4D2YW1Vfbv/+/g68Ejigqu6tqquA4zp1ZwDXV9Ux7d/iJcB3gd1GMyZJkiRNTgaoJUmSlky3AWtnmPy/STZKcnqbCmIeTa7qtYdpcwPg/d2ALvBEYGr7c2NVVaf+DZ3tqTSzpgGoqrvbMa4/RP2utWlmgz8qEJtk2SSfbtNNzOPh2cTDnUfX+VW1Rufn/AWcJ0n+vZN+4w5g01H0N5TuuQ/Zf1X9HngvTSD+L0m+2U2VMsgJwCvamd+vAC6pqoH/BnsCGwG/bVNuzBjNYEfwHnTPZx2aLy9uGGL/BsDzBp3v7jSzrSVJkrSEM0AtSZK0ZPol8Dea1BFD+V/gt8DT2lQP+wIZpv4NwCcGBXRXrqoTgZuA9ZN0j39iZ3suTSASeCitw1rAjZ063eB2163tuTy1x77X0yz6+BKadBPTBroY5jwWZMjzTLIB8FWaNBtrtWk8ruj01+sc7gFW7rzuFXgdHNgf6n2mqk6oqq1p3s8CDu51Eu1M5Tk0Cxx203tQVddU1etoUmocDJzU/jdZoBG8B4PP5xbgH8ATOmXdv40bgJ8NOt8pVfWOHm1JkiRpCWOAWpIkaQlUVXcC+wOHJdk1ycpJlk/ysiSfaautCswD7k6yCfCOQc38GXhK5/VXgbcneV4aqyR5eZs+4pc06SfelWS5JLvwyJQPJwBvTrJ5O6P3k8AFbWqRBZ3LgzQ5mb+QZGo7a/oFbTur0qS/uI0mCPzJkb9LQxruPFehCZjeApDkzTSzhwf8GXhCm5N7wGU0M5lXTrPo454L23+SjZNs357734D7aN73oZwAvBvYFvjOQGGSNyRZp31v72iLh2una0HvwSNU1XzgezSLJa7c/q39e6fK6cBGSd7Y/o0un2SLNItOwqP/DiVJkrQEMUAtSZK0hKqqLwDvA/ajCSbeQDPr9ZS2ygdoZtbeRRMU/dagJmYCx7VpF15dVRfT5Ec+FPgr8Htgj7avv9OkkdiTJuD5BprA40Ce6J8AH6PJLXwTzWzo147idD4AXA5cBNxOM+t3GeBrNLOEbwSuAkaVS7mXBZznVcDnaQLyfwb+CTi3c/jZwJXAzUlubcu+SJOH+c80uZeHXcRxuP5p8k8fCtwN3EwzA3rfYZo7EdgOOLuqbu2U/ytwZZK7aRZMfG1V/W24cXXGt6D3oJd30cxwvxk4vh3XwN/GXcAONH8Pc9s6B7fnCvB/NDm370hyCpIkSVqi5JFpAqVFI8mrgPcA27YzdRZUfzvg61X1hAXVHeL4mcCGVfWGhTl+iPbeCry4qq4ejzYlLT2S7AG8tX0kf2Cxsl8Bb6iqC4c4ZhpwHbD8cIvcSRNZkguAw6vqmH6PZXFKsi5NoPr8qlrQbOnucXvwyGvF3cD0qrq2fb088AtgeeAjNAsRXrEQ45tFc5911BD7X0nzhcA/j+S+bdCxRZMy5vcLqHcw8PiqetNo2pckSWrXWDkD+FJVndHv8WjsnEGtMUlyd+fnwST3dV7vPlCvqr5DM+Ppg/0b7cJJ8kJgQ2Ar4LNJlu3sq/ZRXUl9MNJrUB/Ht3W72NdXgOcnOa7d9QWam6mewWlpskrywiSPb1N8vAmYDvy/fo9rvCS5PslLBpXtkeQXndfLAEcAb6RZxHCnEbTb81rR5mG+tlP1/cAxwJeArRYmOD0SVfVd4DzgP8erzSSbJJnepizZkmam/cnj1b6kxSPJNkmu7rzeOMmlSe5K8u4khyf5WD/HKGlySDIzydeH2X9lO3mxW3Zakj8ALwA+P9Lg9ML0pcVryFXdpZGoqikD20mup5n18+PB9dpvtz4I7JNkuck0G7Cqfgb8rH25cz/HIumRRnMN6sd1p6p+AazRmRX5piSrAZdW1VcW93ikxWBj4NvAFOAPwG5VdVN/h7R4tTOOBxamvGSExzzqWjFEvU+PyyBH5sPAO5MsM9pZ1ENYlSatx1TgLzQpQr4/Du1KGqMk/wVsU1U7dsquAa7pUfaxqtq4c/iHgFlV9axh2t8XmFJV+3bKDqBJI/XS7r1bkue25f9Ms/DqXJovsz5XVX8dy3lKWrzaJ8EGrEyT2mtgvYu9F3R8VT1zUHs7AX+kmQjwmqp6V1s+jTE+eTq4Ly1+zqDWIpFkuyR/SvLhJDfTzPbZGnj/wAWjnYX0gSSzk9yZ5FtJVhzUzvuT/CXJTe0CPEP19+QkP2u/uf8RsPbgsQyqf32Sl7SzvO5NslZn33OS3NI+RkuStyT5TZK/Jjkzzcr1JDmnPeTX7WzN14zpTZM0bnpdg5I8Nsnp7b/vv7bbT+gcMyvJx5Oc215LzkrSvZb8e5I5SW5L8rFeMyk7dddKcmqSeUkupMm1C0BVzaNZtG7Dtu5KST7ftn1nkl8kWanT3O5J/pjk1iQfHe/3ShpPVXVkVa1bVatU1fSq+kG/x7S4pVnE8bvttea6JO8epu6Q14p2f3WuFSsk+Vx7PfhzO0txpXbfI2ZxDz52CBsMc737DvAn4OPArCTP7Ow7NslhSX7QHntBkqcOavslSa5pr7WHJUlVXVRVG1bVylU1rao+VeYalCaKc4B/TvukaJLH06QSevagsg3bul0b0OTdH86ONI/i07b1VGA3mvUI6JRvBcyiyWm/SVWtQZMv/x/AZgtzYpL6p30SbEo7qeiPwE6dsmHX4xjCOcB7qup04IBxHaz6zgC1FqXHA2vS3LTsNUSdV9PcdDyZ5jHgPQYdvzqwPs1joIcleewQ7ZxAk891bZoPUyPKZ1hVN9PcBL26U/wG4JtV9UCSXWkWHnoFsA7wc5rZP1TVtm39zdoL7OCFpST11+Br0DI0X5ZtADwJuI9mobGu1wNvpll07DE0OVhJ8gyaR+93B9bj4WvTUA4D/tbWfUv7M5TPAc+hSSO0Js1MpO5sxa1pZqW+GNg/ydOHaUtSH6VJ73Ea8Guaa8SLgfcm+ZchDhnNteJgYCNgc5og0frA/mMYbs/rXeuHwNPafZfw6EUdXwccCDyWZgHHTwzaPwPYgiag9GpgqPOXNDFcRBOQ3rx9vS3wU+DqQWV/ADYamPyT5GzgRcCh7YSdjdovsf57oOH289tGNIuqDjiU5imNvw8ax2eAY9ovsP4MUFV/rKoDqmrWuJ2tpInkMUm+1n7pfWWapyiAR6ZWa++x3gFcneQ24PDOl+sDX5zd0V6LXjBEXyummRh5V5JLkjz0xddwk4+0eBig1qL0IHBAVd1fVfcNUed/qmpuVd1O84Fu886+B4CDquqBNq/Q3TRBmkdI8iSaD0Efa/s6p21rpI6jCUrTzhB4Hc3q8tA8dvKpqvpNO/P7k8DmA7OoJU1oj7gGVdVtVfXdqrq3qu6iCai8cNAxx1TV79pr1rd5+Jq0G3BaVf2iqv5OExTqOfOvvY68Eti/qu5pc8QeN0TdZWgCUu+pqhuran5VnVdV93eqHdiO/9c0QS9nEEn9dUqSOwZ+aL68GrAFsE5VHVRVf2/zR38VeO3gRkZ5rQjwNuA/q+r29hr2yV7tjsJQ1zuq6uiququ9Fs0ENkuyeufY71XVhe290Td45P0bwKer6o6q+iNNkGvwfkkTSHtvcwFNEJr2989pFmXtlp0z6Ljt23rvaifs/K5H8/8C/KSq5gMkeRXw98F5Y5OsQpNT9rvjclKSJoudgW8CawCn8ugJRAPeTTNx8EU0X9LfCfxvu2/gOrVGey36ZY/jAXYBvkMzKegEmnu65cd8BhoXBqi1KN1SVX9bQJ2bO9v30uSsHHDboPxBg/cPmAr8taru6ZTNGcU4vw88I8lTgJcCd3YWLtsAOKTzIfR2mlxow82clDQxPOIalGTlJEe0qTTm0XzIWiOdhU8Z+po0FbhhYEdV3QvcNkS/69Cs8XBDp2yoa9LawIo0M5KGMtx1UtLit2tVrTHwA7yzs28DYOqgAPa+wLo92hnNtWIdmtyNv+q0+//a8oXV89qSZNkkn07yh/ZaeX1bZ+0FHTuK/ZImnp/xcJBnG5rA888Hlf2sx3EL8nLa9B5JptB8ufbeHvUeSxOfeOj6keQz7TXvniT7LUTfkia+X1TVGe2XWMcz9GScvYGPtk9V/I1mwtCuowww/6qqTqqqB2gWrV8ReP5YBq/xY4Bai9Liyit4E/DY9lv3AU/qbN9D86EOeGjG0kMf6NqL27dpHt1/Iw/PnobmQ+Pe3Q+iVbVSVZ23CM5D0vgafA16P81TGM+rqtV4+ANXRtDWTUA3X/VKwFpD1L2FJlfiEztlTxqi7q00j/cPzt8qaXK6Abhu0H3Dqt1FxjpGe624D3hmp93V6+GFYgff6zx+DOfwepoZRi+hSWc0baDZMbQpaeI7B9i6TcmxTlVdA5wHbNWWbcqj808Pq31S7KU0X6hBkxro+Kq6rkf1v9I8/bbeQEFVfaj9IvBkmi/0JC15Bn+pvWKSXv/eN6BJ6/HbJL8FzqaZRf24UfTVnXD0IM16G1NHP2QtCgaoNelV1RzgYuDAJI9JsjWwU6fK72guci9vv13bD1hhUDNfo8l/vTPw9U754cB/DSwOlGT19rG0AX8GnjKe5yNpkVmVJsBzR5I1Gd3CGicBOyXZKsljaD5g9QzWtN/+fw+Y2c7afgZD5MVvb4yOBr6QZmG1ZZO8IMnga5SkyeFCYF6aBVpXav9Nb5pki8EVF+Ja8VXgi0keB5Bk/U5u618Dz0yyeZoFp2eO4RxWBe6neUpkZZrZjpKWfL+k+VJqL5pFCgcWdp7bls0dIrA8nC2A66vqlvb1i4F3J7k5zSLWTwS+neTD7dOwF9A8wi9Jg90A7FFVm3R+1q6qGxn55MiHJgW0X6A9geYapwnAALWWFK8HnkeTguMAmoAzAFV1J83jt0cBN9LMMvpT9+CqOpfmG/tLqur6TvnJNIsSfbN9zPUK4GWdQ2cCx7WPnnUXWpQ08XwJWIlmJuL5PDybZ4Gq6kpgH5r8aDcBdwF/oQni9PIumkfabwaOpVmccSgfAC6nWaDodpprjv9/liahNui8E03O5etorjdH0QR9ehnNteLDNAsSnt/ek/yYdm2ONu/rQW3ZNTR5YxfW12hSjdwIXEVzvZS0hGvz0V8MvI8mtceAX7Rlo5o93XoovUfrxTQzsTdvf+bSPLZ/WLv/Q8Bbknyk82XcE4AnL0TfkpYshwOfTPJkgCTrJNml3XcLTTxnQZMHn5PkFe0M7ffSfJbzPmeCSNXiysIgTWztKtQnVNVR/R6LpImtzaF4B/C0hZhNJEmSNOEk+RTwEeA5VXVJW/Zq4FvA26vqiCTbAV+vqie0+2e1r49qXx8L/Kmq9ktycXvcxUP0dz3w1qr6cafseTQTjrZqi/5Es2bQF6pqqPU/JE1wQ/x7nwlsWFVvaF9Po/mCf/mq+kf3mHbG83tpvtSaSjNZ6FtVtW977EHAO4DlgX+tqkcEntu+NgXmAzvSfOm/Z+da96jxafEyQC0B7aO3PwKeWFV39dj/EeBTVWX+RWkplWQn4Cc0qT0+T/PUxrPL/5FK6iFJAT+uqpf2eyyStLglWRe4DJjqvZIkaUF8hFhLvSTH0TwS+95ewWmAqvq0wWlpqbcLzaOoc4GnAa/1A5ekoVRVDE5LWoqtDrzPeyVJk0GS2Ule2O9xLM2cQS1JkiRJkiRJ6ovFPoM6yfwkl3V+piU5byHa+WySK5N8dlGMU5IkSZImuiQzk3xgmP3HJtmtR/l2SU5fiP62S7JV53XP9iVJkkZquT70eV9VbT6obKvBlZIs266EPpS9gXWq6v5xHZ0kSZIkaSjbAXcDo55kNFiS0DzV++BY25IkSZNXPwLUj5Lk7qqa0q4IfABwE7B5kn8CPk1zE7QCcFi7cvCpwCrABe1Kw+cDRwPrALcAbwbuBC4Edq6qq5OcCJxdVV8dahzLLLOs90bSGC0TeHDkmYNurap1FuFwempXFz+9qk4aQxufpVn994yq+uBYxuO1RxqbUV53oE/XnsnCa5L0aAtxnRmNUV+TknwU+HfgBprPP79K8jZgL+AxwO+BN1bVve0hL0nyHmBdmrzAC5w5nWRNms9YTwHubdueB7wdmJ/kDcA+bfVtk7wPeDzwoYF7rCQfBF5N81nu5Ko6IMk04IfAT4EXALsCc3qNweuRtNgtVfdIXmOkxiK+z+ka8hrTjwD1Skkua7evq6p/G7R/S2DTqrouyV7AnVW1RZIVgHOTnFVVO7dB7c0BkpwGfK2qjkvyFuB/qmrXJO8Cjk1yCPDY4YLTAFUPssGHR/2Um6SOOQfPoA5YbUR1c+C8nh9GRivJY4Dlq+qe8WivbXOxPcXhtUcam9Fcd2D8rj1LKq9J0qON9jozGqO9JiV5DvBa4Fk0n+cuAX4FfG/g806S/wb2BL7cHjYNeCHwVOCnSTYcQVcHApe2n6u2p/m8tXmSw4G7q+pzbV97AusBWwObAKcCJyXZgWZR4S2BAKcm2Rb4I7Ax8OaqemeP89uLJhgO4PVIWozmHDxjqbpH8p5HaizK+5yu4e55JkqKj64Lq+q6dnsHYHonp9nqNDc51w065gXAK9rt44HPAFTVj5K8CjgM2KxXZ4NvgCRNHkmeDryV5t//K4BLk+wP7ASsRPPo6d5DrB7+qJk+C/sUR1V9a1GepyRJUsc2NLOR7wVo70sANm0D02sAU4AzO8d8u50meE2Sa2kCyQuyNfBKgKo6O8laSVYfou4pbftXJVm3Lduh/bm0fT2F5rPcH4E5VXV+r4aq6kjgSIAss0zNOXjGCIYqSZImswmR4mOQ7gzIAPtU1ZlDVR5CASRZBng6cB+wJvCnR1X0BkgaVyssBzlw3iJrP8kqNI+K7klzjTgGmF5Vd7VVDq2qg9q6xwMzgNN6NPWomT5t+aif4ljI8/DLMUmStLB6ffl+LLBrVf06yR40X7APVX8kD/JmhP0CdJ8oS+f3p6rqiEc02qT4GNlTb1XObpRai2OG46L8HCdJw5mIAequM4F3JDm7qh5IshFwY4/H+M+jeczteGB34Bdt+X8CvwH2BY5O8oKqemDI3rwBkkZkvG6OFvIG6CZgNvDWqvptj/0vSvIhYGWaL6aupHeAutdMH1i4pzhG7RFfjiWLJ9uTJElaEpxDk8bw0zSf53YCjgBWBW5KsjzNZ6IbO8e8KslxwJNpckpfDTx/BP3sDny8fcrs1qqal+QuYCQ3gme2x36jqu5Osj4w9GcxSZK01JroAeqjaPKlXdKu8HwLzSIag72bJgD9wbbOm9tg9luBLavqriTnAPvRPL4/YqutsAz7PO+xbLDG8qTnJIL+K4o5dzzAly/4K/PuN8G/lni70cyePrld/PS4qpoDkGRF4CvAc6vqhiQzgRWHaKfXTB8Yn6c4JEmSFomquiTJt4DLaBYX/Hm762PABW3Z5TQB6wFXAz+jWSTx7VX1t+bj1bBmAsckmU2zSOKb2vLTaHJM78LDiyT2GudZbTq2X7Z93Q28ARhujQ9JkrQUWuwB6qqaMlRZVc0CZnXKH6SZ/bzvcO1U1fXA9j26e3qnzvsWZrz7PO+xPPupU1lu5VUZwU1cX1QVa601j32AT5xzW7+HIy1SVXUWcFaStWg+5Hw/ya00X0jd0Va7NckUmmD2Sb1bGpGRPsUxNgmmF5IW3qJOLSRJE01VfQL4RI9d/9uj7h5DtDGLzmevHvtvB3bpUf47YHqn6OeD9nc/px0CHNKj+U2H6leSJC19JvoM6r7bYI3lJ3RwGiAJy628GhuscWu/hyItNlV1G80HnkOSbAnMr6o7knyVZtbQ9cBFY+xmgU9xJJkKHFVVO7avz6BJPzI3yUHAxVV1KsMxvZA0YuORYshgtiRJkiRNHAaoFyBkQgenBySZsClIpEWtqi7sbO9Hk85nuPp7DHq90E9xVNVcYMdOeXd7/9GchyRJ0uKW5M3AewYVn1tV/9GP8UiSpKXPMv0egEbm3J/+mJ1fuAUztn42/3fYF/s9HEmSJElLgKo6pqo2H/RjcFqSJC02zqAepRdvsSm33nzjgiuO0NqPX5+fXHTFsHXmz5/PJ/f7IEeccDLrrjeV18/Ynu1e+jKeutEm4zYOSZIkSZIkSVrcDFCP0q033ziuuWJHsjDaFZf9iidOewpP2GAaAP+68yuYddYZBqglSZIkSZIkTWqm+JgE/nLzTTx+6voPvX7celP588039XFEkiRJkiRJkjR2Bqgngap6VNlkWLhRkiRJkiRJkoZjgHoSWHe9qdw89+G813+5aS6PW/fxfRyRJEmSJEmSJI2dAepJ4JmbPZs/Xv8H/vTHOTzw97/z/079Hi986cv6PSxJkiRJkiRJGhMXSZwElltuOf7r45/hHW94JQ/On8+ur9mdDTd+er+HJUmSJEmSJEljYoB6lNZ+/PrMOXjGuLY3EttsvwPbbL/DuPUrSZIkSZIkSf1mgHqUfnLRFf0egqQxSnIscHpVnTSGNj4L7AicUVUfHK+xSZIkSZIkLU0MUEua9JI8Bli+qu4ZxzaXrar5w1TZG1inqu4frz4lSZIkSZKWNi6SKGnSSvL0JJ8HrgY2asv2T3JRkiuSHJkkQxy+bZLzklybZLf22O2S/DTJCcDlSZZN8tm2vdlJ9m7rnQqsAlyQ5DWL/kwlSZIkSZKWTM6gljSpJFkFeDWwJxDgGGB6Vd3VVjm0qg5q6x4PzABO69HUesDWwCbAqcBAuo8tgU2r6rokewF3VtUWSVYAzk1yVlXtnOTuqtp8DOexF7DXwh4vSZIkSZK0JDBALWmyuQmYDby1qn7bY/+LknwIWBlYE7iS3gHqU6rqQeCqJOt2yi+squva7R2A6QMzrIHVgacB1zFGVXUkcCRAkhpre5IkSZIkSZORAWpJk81uNLOnT05yInBcVc0BSLIi8BXguVV1Q5KZwIpDtNPNHd1NA3LPoPJ9qurM8Rq8JEmSJEmSHmYO6klg//e/i+02fxqvePEL+j0Uqe+q6qyqeg1Neo47ge8n+XGSaTwcjL41yRSaYPZYnAm8I8nyAEk2alOMSJIkSZIkaRw4g3qUdtxyY2686S/j1t766z2OMy68etg6u7zqdbxuj7fx0fe+fdz6lSa7qroNOAQ4JMmWwPyquiPJV4HLgeuBi8bYzVHANOCSdrHFW4BduxWSTAWOqqod29dn0KQfmZvkIODiqjp1jOOQJEmSJElaIhmgHqUbb/oLdcBq49ZeDlxwsPs5z/9nbrzhj+PWp7SkqaoLO9v7AfstoP4eg15PaX/PAmZ1yh8E9m1/BrcxcMxcYMdOeXd7/9GchyRJkiRJ0tLGFB+SJEmSJEmSpL4wQC1JkiRJkiRJ6osxB6iTVJLjO6+XS3JLktMXcNzMJB/oUT41yUnt9nYLakeSJEmSJEmSNDmNxwzqe4BNk6zUvn4pcOPCNlZVc6tqt3EYlyRJkiRJkiRpAhuvFB8/BF7ebr8OOHFgR5I1k5ySZHaS85NM7xy3WZKzk1yT5G1t/WlJrhjcQZJVkhyd5KIklybZZZzGPuF9+D/25N933RW0EZ8AACAASURBVIE51/6el27xTL73zeMXfJAkSZIkSZIkTXDLjVM73wT2b9NxTAeOBrZp9x0IXFpVuybZHvgasHm7bzrwfGAV4NIkPximj48CZ1fVW5KsAVyY5MdVdc9YBp5kL2CvkdZff73HkQP/MpYuH9Xeghx82P+NW3+SJEmSJEmSNFGMS4C6qmYnmUYze/qMQbu3Bl7Z1js7yVpJVm/3fb+q7gPuS/JTYEvgsiG62QHYuZO3ekXgScBvxjj2I4EjocmnvaD6Z1x49Vi6kyRJkiRJkiS1xmsGNcCpwOeA7YC1OuXpUbcG/R5c3kuAV1aVEWJJkiRJkiRJWgKMVw5qaNJ6HFRVlw8qPwfYHSDJdsCtVTWv3bdLkhWTrEUT2L5omPbPBPZJkratZ43j2CVJkiRJkiRJi9m4zaCuqj8Bh/TYNRM4Jsls4F7gTZ19FwI/oEnV8fGqmtumCunl48CXgNltkPp6YMbgSkkuq6rN2+2jgMOr6uIkb2/Hefiozouiqmjj4hNWVVHDTkCXNGElzDn4UZczST2ssBzkwHkLrihJkiRJmhTGHKCuqik9ymYBs9rt24FdetSZOUR71wOb9mjnPmDvEYxn8872WzvbowpMD5hzxwOstdY8llt5tQkbpK4q/nHvPObc8UC/hyJpYVSxwYdP7/copL6bc/AM6oDVFnk/BrglSZIkaeIYzxzUS6QvX/BX9gE2WONW0jOddv8VxZw7HuDLF/y130ORJEmSJEmSpBEzQL0A8+5/kE+cc1u/hyFJkiRJkiRJS5zxXCRRkiRJkiRJkqQRM0AtSZIkSZIkSeoLA9SSJEmSJEmSpL4wQC1JkiRJkiRJ6gsD1JIkSZIkSZKkvjBALUmSJEmSJEnqCwPUkiRJk0yS8zrbz0xydpLfJbkmyceSpN23bpLTk/w6yVVJzujfqCVJkiTp0QxQS5IkTTJVtRVAkpWAU4FPV9VGwGbAVsA726oHAT+qqs2q6hnAR/oxXkmSJEkaigFqSZKkSSbJ3e3m64Fzq+osgKq6F3gXDwei1wP+NHBcVc1enOOUJEmSpAUxQC1JkjR5PRP4Vbegqv4ATEmyGnAY8H9Jfprko0mm9mokyV5JLk5y8aIfsiRJkiQ9zAC1JEnS5BWghthXVXUm8BTgq8AmwKVJ1ulR8ciqem5VPXfRDVWSJEmSHs0AtSRJ0uR1JfCIoHKSpwB3V9VdAFV1e1WdUFVvBC4Ctl38w5QkSZKk3gxQS1rqJDk2yW5jbOOzSa5M8tnxGpckLYRvAFsneQk8tGji/wCfaV9vn2TldntV4KnAH/s0VkmSJEl6lOX6PQBJGqskjwGWr6p7xrHNZatq/jBV9gbWqar7x6tPSRqtqrovyS7Al5McBiwLHA8c2lZ5DnBokn/QTEw4qqou6s9oJUmSJOnRnEEtadJK8vQknweuBjZqy/ZPclGSK5IcmSRDHL5tkvOSXDswmzrJdu1CYicAlydZtp0pfVGS2Un2buudCqwCXJDkNYv+TCXpkapqSmf78qrarqo2rqoNq+rAqqp232er6hlVNb2qNq2qz/dv1JIkSZL0aM6gljSpJFkFeDWwJ83iYMcA0wdyrQKHVtVBbd3jgRnAaT2aWg/YmmbRsFOBk9ryLYFNq+q6JHsBd1bVFklWAM5NclZV7Zzk7qrafAznsRew18IeL0mSJEmStCQwQC1psrkJmA28tap+22P/i5J8CFgZWJNmAbFeAepTqupB4Kok63bKL6yq69rtHYDpnXzVqwNPA65jjKrqSOBIgCQ11vYkSZIkSZImIwPUkiab3WhmT5+c5ETguKqaA5BkReArwHOr6oYkM4EVh2inmzu6mwbknkHl+1TVmeM1eEmSJEmSJD3MHNSSJpWqOquqXkOTnuNO4PtJfpxkGg8Ho29NMoUmmD0WZwLvSLI8QJKN2hQjkiRJkiRJGgcGqCVNSlV1W1Ud0uaB3heYX1V3AF8FLgdOAS4aYzdHAVcBlyS5AjiCQU+eJJma5IzO6zOSTG23D0qy8xjHIEmSJEmStMQyxYekSa+qLuxs7wfst4D6ewx6PaX9PQuY1Sl/kCb4vW+PNgaOmQvs2Cnvbu8/mvOQJEmSJEla2ow6QN3mdL27qj43xP5jgdOr6qRB5dsBH6iqGaPsbzvg71V13nDtj4uEOQePanjSUmmF5SAHzuv3MCRJkiRJkjTJTYYZ1NsBdwPnjbWhJAHSzop8tCo2+PDpY+1GWqLNOXgGf/voauPSlkFuSZIkSZKkpduIclAn+WiSq5P8GNi4LXtbkouS/DrJd5Os3DnkJUl+nuR3SUY0JTnJmklOSTI7yflJpreLnr0d+M8klyXZpq2+bZLzklybZLdOGx9sxzQ7yYFt2bQkv0nyFeAS4IkjGY8kSZIkSZIkadFaYIA6yXOA1wLPAl4BbNHu+l5VbVFVmwG/AfbsHDYNeCHwcuDwJCuOYCwHApdW1XSafK9fq6rrgcOBL1bV5lX187buesDWwAzg0+04dwCeBmwJbA48J8m2bf2N2/aeVVVzBp3fXkkuTnLxCMYoSZIkSZIkSRonI0nxsQ1wclXdC5Dk1LZ80yT/DawBTAHO7Bzz7TaNxjVJrgU2GUE/WwOvBKiqs5OslWT1Ieqe0rZ/VZJ127Id2p9L29dTaALWfwTmVNX5vRqqqiOBI9tzqxGMU5IkSZIkSZI0Dkaag7pX4PZYYNeq+nWSPWhyRQ9VfySB34ywX4D7exwX4FNVdcQjGm3ShNwzgv4lSZIkSZIkSYvRSALU5wDHJvl0W38n4AhgVeCmJMsDuwM3do55VZLjgCcDTwGuBp4/gn52Bz6eZDvg1qqal+QuYCQrsp3ZHvuNqro7yfrAAyM47mEJcw4eUcpsaam1wnIubihJkiRJkqTxscAAdVVdkuRbwGXAHGAgD/THgAvasstpAtYDrgZ+BqwLvL2q/pb0miD9CDOBY5LMBu4F3tSWnwaclGQXYJ9hxnlWkqcDv2z7uht4AzB/QR13GmGDD58+4urSkmbOwTOoA0byfdD4MNAtSZIkSZK0dBtRio+q+gTwiR67/rdH3T2GaGMWMGuYPm4HdulR/jtgeqfo54P2T+lsHwIc0qP5TYfqV5IkSZIkSZLUH8v0ewCSJEmSJEmSpKXTSBdJHDdJ3gy8Z1DxuVX1H4t7LJIkSZIkSZKk/lnsAeqqOgY4ZnH3K0mSJEmSJEmaWEzxIUmSJEmSJEnqCwPUkiRJkiRJkqS+WOwpPiRJgyTMOXhGv0ch9d0Ky0EOnNfvYUiSJEmSFiMD1JLUb1Vs8OHT+z0Kqa/mHDyDv310tcXSl0FwSZIkSZo4TPEhSZIkSZIkSeoLA9SSJEmSJEmSpL4wQC1JkiRJkiRJ6gsD1JIkSZIkSZKkvjBALUmSJEmSJEnqCwPUkiRJkiRJkqS+MEAtSZIkSZIkSeoLA9SSJEmSJEmSpL4wQC1JkiRJkiRJ6gsD1JIkSZIkSZKkvjBALUmSJEmSJEnqCwPUkiRJkiRJkqS+MEAtSZIkSZIkSeoLA9SSJEmSJEmSpL4wQC1JkiRJkiRJ6gsD1JIkSZK0lEjywSR79nsckiRJAwxQS5IkSdIkl+TxSb6Z5A9JrkpyRpKN2n2PTXJqkuOA86vq/4ZoY60klyW5OcmNSZ6R5KAkL1lA3zOTfGARnJYkSVoKLNfvAUiSJEmSFl6SACcDx1XVa9uyzYF1gd8BTwTeBqwH3DhUO1V1G7B5kpnA3VV1FbD/oh29JEla2jmDWpIkSZImtxcBD1TV4QMFVXVZVf28DV6/EfgJcDywfa8Gknw0ydVJfgxs3Ck/Nslu7fb1SQ5MckmSy5Ns0mniGUlmJbk2ybsX9kSS7JXk4iQXL2wbkiRpcnEGtSRJkiRNbpsCvxpi3yuAzYHNgLWBi5KcU1U3DVRI8hzgtcCzaD4jXjJMe7dW1bOTvBP4APDWtnwTmkD5qsDVSf63qh4Y7YlU1ZHAke24arTHS5KkyccZ1JIkSZK05NoaOLGq5lfVn4GfAVsMqrMNcHJV3VtV84BTh2nve+3vXwHTOuU/qKr7q+pW4C806UUkSZIWyBnUkiRJeljCnINn9HsU0oSywnKQA+f1exjDuRLYbYh9GWEbI52tfH/7ez6P/Dx5f2d78D5JkqQhedMgSZKkh1WxwYdP7/copL6Zc/AM6oDVFlt/4xT4Phv4ZJK3VdVXAZJsAawMnAPsneQ4YE1gW+CDg44/Bzg2yadpPiPuBBwxHgOTJElaEFN8SJIkSdIkVlUF/Bvw0iR/SHIlMBOYC5wMzAZ+TRPI/lBV3Tzo+EuAbwGXAd8Ffj5eY0tyRpKp7fZBSXZut3dOctB49SNJkiYvZ1BLkiRJ0iRXVXOBVw+x+4M8etb04OM/AXyiR/kene1pne2Lge3a7ZmDjtm0s71jZ3v/zvapDJ/rWpIkLSWcQS1JkiRJ6qmd9fySfo9DkiQtuZxBLUmSJEnqqTvrWZIkaVFwBrUkSZIkSZIkqS8MUEuSJEmSJEmS+sIAtSRJkiRJkiSpLwxQS5IkSZIkSZL6wgC1JEmSJEmSJKkvDFBLkiRJkiRJkvrCALUkSZIkSZIkqS8MUEuSJEmSJEmS+sIAtSRJkiRJkiSpLwxQS5IkSZIkSZL6wgC1JEmSJEmSJKkvDFBLkiRJkiRJkvrCALUkSZIkSZIkqS8MUEuSJEmSJEmS+sIAtSRJkiRJkiSpLwxQS5IkSZIkSZL6wgC1JEmSJEmSJKkvDFBLkiRJkiRJkvrCALUkSZIkSZLGXZJKcnzn9XJJbkly+gKOm5nkAz3KpyY5qd3ebkHtSJocDFBLkiRJkiRpUbgH2DTJSu3rlwI3LmxjVTW3qnYbl5FJmjAMUEuSJEmSJGlR+SHw8nb7dcCJAzuSrJnklCSzk5yfZHrnuM2SnJ3kmiRva+tPS3LF4A6SrJLk6CQXJbk0yS6L8oQkjS8D1JIkSZIkSVpUvgm8NsmKwHTggs6+A4FLq2o6sC/wtc6+6TSB7RcA+yeZOkwfHwXOrqotgBcBn02yyuBKSfZKcnGSi8d0RpLGlQFqSZIkSZIkLRJVNRuYRjN7+oxBu7cGjm/rnQ2slWT1dt/3q+q+qroV+Cmw5TDd7AB8JMllwCxgReBJPcZyZFU9t6qeu/BnJGm8LdfvAUiSJEmSJGmJdirwOWA7YK1OeXrUrUG/B5f3EuCVVXX1wg5QUv84g1qSJEmSJEmL0tHAQVV1+aDyc4DdAZJsB9xaVfPafbskWTHJWjSB7YuGaf9MYJ8kadt61jiOXdIi5gxqSZIkSZIkLTJV9SfgkB67ZgLHJJkN3Au8qbPvQuAHNKk6Pl5Vc5NMG6KLjwNfAma3QerrgRnjMXZJi54BakmSJEmSJI27qprSo2wWTZ5oqup2YJcedWYO0d71wKY92rkP2HschiypD0zxIUmSJEmSJEnqCwPUkiRJkiRJkqS+MEAtSZIkSZIkSeoLA9SSJEljkOSLSd7beX1mkqM6rz+fZP8kHxllu8cm2W08xypJkiRJE40BakmSpLE5D9gKIMkywNrAMzv7twLOrKpP92FskiRJkjShGaCWJEkam3NpA9Q0gekrgLuSPDbJCsDTgc2SHAoPzYz+nyTnJbl2YJZ0GocmuSrJD4DHDXSQ5MVJLk1yeZKjk6yQZMsk32v375LkviSPSbJikmvb8ne37c1O8s3F9o5IkiRJ0ggt1+8BSJIkTWZVNTfJP5I8iSZQ/UtgfeAFwJ3AbODvgw5bD9ga2AQ4FTgJ+DdgY+CfgHWBq4Cjk6wIHAu8uKp+l+RrwDuAQ4Fnte1tQxMY34Lm/u6CtvwjwJOr6v4kawx1Dkn2AvZa2PdAkiRJkhaWM6glSZLGbmAW9UCA+ped1+f1qH9KVT1YVVfRBKMBtgVOrKr5VTUXOLst3xi4rqp+174+Dti2qv4B/D7J04EtgS+0bWwD/LytOxv4RpI3AP8YavBVdWRVPbeqnrsQ5y5JkiRJC80AtSRJ0tgN5KH+J5qZzOfTzKDeiiZ4Pdj9ne10tqtH3fQoG/Bz4GXAA8CPaWZlbw2c0+5/OXAY8BzgV0l8ek6SJEnShGKAWpIkaezOBWYAt7czoG8H1qAJUv9yhG2cA7w2ybJJ1gNe1Jb/FpiWZMP29RuBn3WOeS/wy6q6BViLJm3Ile2CjU+sqp8CH2rHM2UsJylJkiRJ481ZNJIkSWN3ObA2cMKgsilVdWsy3CToh5wMbN8e9zvaIHRV/S3Jm4HvtDOgLwIOb4+5gCZFyMCM6dnAX6qq2rpfT7I6zSzsL1bVHWM4R0mSJEkadwaoJUmSxqiq5gOrDSrbo7N9LM1Ch48ob19PaX8X8K4h2v8JDy+I2C2/D1ih83qvzvYDNOk+JEmSJGnCMsWHJEmSJEmSJKkvDFBLkiRJkiRJkvrCALUkSZIkSZIkqS8MUEta6iQ5NsluY2zjs0muTPLZ8RqXJEmSJEnS0sZFEiVNekkeAyxfVfeMY5vLtoueDWVvYJ2qun+8+pQkSZIkSVraOINa0qSV5OlJPg9cDWzUlu2f5KIkVyQ5MkmGOHzbJOcluXZgNnWS7ZL8NMkJwOVJlm1nSl+UZHaSvdt6pwKrABckec2iP1NJkiRJkqQlkzOoJU0qSVYBXg3sCQQ4BpheVXe1VQ6tqoPauscDM4DTejS1HrA1sAlwKnBSW74lsGlVXZdkL+DOqtoiyQrAuUnOqqqdk9xdVZuP4Tz2AvZa2OMlSZIkSZKWBAaoJU02NwGzgbdW1W977H9Rkg8BKwNrAlfSO0B9SlU9CFyVZN1O+YVVdV27vQMwvZOvenXgacB1jFFVHQkcCZCkxtqeJEmSJEnSZGSAWtJksxvN7OmTk5wIHFdVcwCSrAh8BXhuVd2QZCaw4hDtdHNHd9OA3DOofJ+qOnO8Bi9JkiRJkqSHmYNa0qRSVWdV1Wto0nPcCXw/yY+TTOPhYPStSabQBLPH4kzgHUmWB0iyUZtiRJIkSZIkSePAALWkSamqbquqQ9o80PsC86vqDuCrwOXAKcBFY+zmKOAq4JIkVwBHMOjJkyRTk5zReX1Gkqnt9kFJdh7jGCRJkiRJkpZYpviQNOlV1YWd7f2A/RZQf49Br6e0v2cBszrlD9IEv/ft0cbAMXOBHTvl3e39R3MekiRJkiRJSxtnUEuSJEmSJEmS+sIAtSRJkiRJkiSpLwxQS5IkSZIkSZL6wgC1JEmSJEmSJKkvDFBLkiRJkiRJkvrCALUkSZIkSZIkqS8MUEuSJEmSJEmS+sIAtSRJkiRJkiSpLwxQS5IkSZIkSZL6wgC1JEmSJEmSJKkvDFBLkiRJkiRJkvrCALUkSZIkSZL0/9u792DLyvJOwL83NGkSWmBEg2IprY4GDSEYLhOUmDYXknE6ihlGBY2DMWl1Ei9lYkiIETCxYo+54WCCjaOokWjKBILIAEkUVPDCJcjFQDIROhes8hZBQIzAO3/sdcbN8fT1XFafPs9Tteus/a1vfetdXd27un5n7XcBoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAAAoxBQAwAAAAAwikUNqKvqEVX1vqr6x6r6bFVdVFUbqurCxTwvAAAAAAC7vkULqKuqkpyX5LLufnx3PznJKUkO2M7j91is2gAAAAAAGN+qRVz7GUm+2d1nzQx093VVtV+SH6uqDyQ5JMk1SV7Y3V1VtyV5R5Jjk5w5hNynJKkkH+ruk5Okqu5K8tYkP57k34Y5/zPJY5K8ursvGALuNyVZl2R1krd299sW8XoBAJa/qmzeuH7sKmA0q1cldfqdY5cBALBiLGZAPRM+z+UpSb4vye1JrkjytCQfH/bd293HVNWBST6Z5PBMQuhLq+q47j4/yd6Z3Jl9clWdl+S3k/xEkicneVeSC5K8JMkd3X1kVa1OckVVXdrdty7GxQIA7Ba6c9DJurGxMm3euD73/sY+S3pOYTgAsNKN9ZDET3f3v3T3A0muS7J2at/7h59HZhJCf7G770vy3iRPH/b9e5KLh+0bklze3d8ctmfWOjbJi6rquiSfSrJ/kifMLmToiX11VV29UBcHAAAAAMC2LeYd1DclOX4L+74xtX3/rDruHn7WVtb+Znf3sP3AzHrd/UBVzaxVSV7R3Zdsrcju3pRkU5JUVW9tLgAAAAAAC2cx76D+cJLVVfULMwNVdWSSH9nO4z+V5Eeq6mFDP+kTkly+A+e/JMnLq2rP4dxPrKq9d+B4AAAAAAAW0aLdQT089PA5Sf6wqn4tyb1Jbkty/nYe//mq+vUkH8nkbuiLuvsvd6CEt2fS7uPa4WGLX0xy3A4cDwAAAADAIlrMFh/p7tuTPHeOXWdPzfmlqe21s44/N8m5c6y7Zmr7tLn2Df2tTxleAAAAAADsYsZ6SCIAAAAAACucgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYxaqxCwAAAIBvU5XNG9ePXQXsElavSur0O8cuA2BRCKgBAADY9XTnoJMvHLsKGMXmjevTp+6zpOcUgANj0eIDAAAAAIBRCKgBAAAAABiFgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYhYAaAAAAAIBRCKgBAAAAABiFgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYhYAaAAAAAIBRCKgBAAAAABiFgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYhYAaAAAAAIBRCKgBAAAAABiFgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYhYAaAAAAAIBRCKgBAAAAABiFgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYhYAaAAAAAIBRCKgBAAAAABiFgBoAAAAAgFGsGrsAgBWvKps3rh+7ChjV6lVJnX7n2GUAAACwxATUAGPrzkEnXzh2FbDkNm9cnz51nyU/ryAcAABg16HFBwAAAAAAoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAAAoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAAAoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAAAoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQDAIqqq51RVV9XBO3jcuqq6cAePeVlVvWiO8bVVdeOOrAUAALAUVo1dAADAbu6EJB9P8vwkp813sapa1d33zbWvu8+a7/oAACtCVTZvXD92FTC61auSOv3OUWsQUAMALJKqWpPkaUmekeSCJKdV1bpMguovJTkkyTVJXtjdXVU/leQPh33XTq1zWpIDk6xN8qWq+vUk70jy8CRfTPLi7v6nYd5d3f27VXX4MOeeTAJyAABmdOegk3foy2qwW9m8cX361H2W7HxbC8G1+AAAWDzHJbm4u/8+yVeq6geH8ackeXWSJyd5XJKnVdVeSc5O8tNJfjjJI2atdXiSZ3f3iUnOTPLu7j40yXuTvGWOc78zySu7++htFVlVG6rq6qq6eoevEAAAYB4E1AAAi+eEJO8btt83vE+ST3f3v3T3A0muy+TO6IOT3Nrd/9DdneRPZq11QXd/fdg+Osm5w/Z7khwzPbGq9k2yX3dfPjVni7p7U3cf0d1H7NDVAQAAzJMWHwAAi6Cq9k/yo0kOqapOskeSTnJRkm9MTb0/3/o/WW9lybu3sm/2cbWNtQAAAHYJ7qAGAFgcx2fShuOg7l7b3Y9Ocmtm3e085eYkj62qxw/vT9jCvCS5MpOHLibJCzKrx3R3fzXJHVV1zNQcAACAXY6AGgBgcZyQ5LxZY3+e5MS5Jnf3vUk2JPlQVX08yeatrP3KJC+uquuT/GySV80x58VJ3lpVn0jy9Tn2AwAAjE6LDwCARdDd6+YYe0tmPdCwu39pavviTHpRzz7utFnvb8ukfcgW53X3NUl+YGr3abPnAytPVT0iyR8mOTKTdkO3JXn18DDXuebf1d1rqmptkgu7+5BtrH9bkiO6+0sLWDYAsBtzBzUAAMAKUFWVyTc7Luvux3f3k5OckuSAEWvaY6xzAwC7BgE1AADAyvCMJN/s7rNmBrr7uu7+WFW9tqquqqrrq+r0rS1SVSdV1ZlT7y+sqnVzzDu/qq6pqpuqasPU+F1V9Yaq+lSSoxfkygCAZUtADQAAsDIckuSa2YNVdWySJyQ5KslhSQ6vqqcvwPl+rrsPT3JEkldW1f7D+N5Jbuzu/9TdD3rIa1VtqKqrq+rqBTg/ALAM6EENAACwsh07vP52eL8mk8D6o/Nc95VV9Zxh+9HDml9Ocn8mD439Nt29KcmmJKmqnuf5AYBlQEANAACwMtyU5Pg5xivJ73T327Zznfvy4G/j7vVtC05afvx4kqO7+56qumxq3r3dff/2Fg0A7N60+AAAAFgZPpxkdVX9wsxAVR2Z5M4kP1dVa4axR1XV92xlnduSHFZV31FVj86kNchs+yb5tyGcPjjJDy3URQAAuxcBNbDiVNU5VTXX3UM7ssabhwf+vHmh6gIAWEzd3Umek+Qnquofq+qmJKclOXd4faKqbkjygSQP2cpSVyS5NckNSX43ybVzzLk4yaqquj7JbyX55EJdBwCwe9HiA1j2quo7k+zZ3Xcv4Jp7bOOrpy9N8vDu/sZCnRMAYLF19+1JnjvHrjOG1+z5a4aft2XykMWZoPsFW1h/7dTb/7yFOWt2pGYAYPfmDmpg2aqqJ1XV7yW5JckTh7HXV9VVVXVjVW2qqtrC4U+vqiur6nMzd1NX1bqq+khVnZvkoW9KnwAAENtJREFUhqraY7hT+qqqur6qXjrMuyCTp89/qqqet/hXCgAAALB7cgc1sKxU1d6Z3PXzkkwe6PPOJId299eGKWd29xuGue9Jsj7JB+dY6pFJjklycJILMvkqazLpoXhId99aVRuS3NHdR1bV6iRXVNWl3f2sqrqruw9bpMsEAAAAWBEE1MBy8/kk1yf5+e6+eY79z6iqX03y3UkemsnT6ucKqM/v7geSfLaqDpga/3R33zpsH5vk0Kl+1fsmeUImPRfnZQi/N8x3HQAAAIDlTEANLDfHZ3L39HlV9adJ3tXdm5OkqvZK8kdJjujuf66q05LstYV1pntHT7cBuXvW+Cu6+5KFKn5Gd29KsilJqqoXen0AAACA5UAPamBZ6e5Lu/t5mbTnuCPJX1bVX1fV2nwrjP5SVa3JJMyej0uSvLyq9kySqnri0GIEAAAAgAUgoAaWpe7+cnefMfSBPiXJ/d391SRnJ7khyflJrprnad6e5LNJrq2qG5O8LbO+eVJVB1bVRVPvL6qqA4ftN1TVs+ZZAwAAAMBuS4sPYNnr7k9Pbb8uyeu2Mf+kWe/XDD8vS3LZ1PgDmYTfp8yxxswxtyd55tT49Pbrd+Q6AAAAAFYad1ADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAAAoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAAAoxBQAwAAAAAwCgE1AAAAAACjEFADAAAAADAKATUAAAAAAKMQUAMAAAAAMAoBNQAAAAA7rKrur6rrquqmqvpMVb2mqnYqa6qqu+YYW1tVJ86/UmBXtmrsAnYpVdm8cf3YVcBoVq9K6vQ7xy4DAACA5eHr3X1YklTV9yQ5N8m+SU5doPXXJjlxWBfYTQmop3XnoJMvHLsKWDKbN65Pn7rPaOcXhgMAAOweuvsLVbUhyVVVdVom39p/U5J1SVYneWt3v62qHpnk/Un2ySSXenl3f2xmnap6WJIPJvntJL+Z5ElVdV2SdyX54+F1RJL7krymuz9SVSclec5wnscmObe7T1/0iwYWhIAaAAAAgHnr7s8NLT6+J8mzk9zR3UdW1eokV1TVpUl+Jskl3f3GqtojyXfPHF9VByS5IMnruvuvquruJL/S3euH/b88nOf7q+rgJJdW1ROHw49KckiSezIJyT/U3VdP1zcE6BsW708A2BkCagAAAAAWSg0/j01yaFUdP7zfN8kTklyV5B1VtWeS87v7umH/nkn+JskvdvflW1j7mCT/K0m6++aq2pxkJqD+q+7+cpJU1V8Mcx8UUHf3piSbhjk9r6sEFoyHJAIAAAAwb1X1uCT3J/lCJkH1K7r7sOH12O6+tLs/muTpSf41yXuq6kXD4fcluSbJT27tFFvZNztwFkDDMiGgBgAAAGBequrhSc5KcmZ3d5JLkrx8uFM6VfXEqtq7qg5K8oXuPjvJ/07yg8MSneTnkhxcVb82jH0tyUOmTvPRJC+YWS/JY5LcMuz7iap6aFV9V5LjklyxSJcKLDAtPgAAAADYGd81PMBwz0zugH5Pkt8f9r09ydok11ZVJfliJsHxuiSvrapvJrkrycwd1Onu+6vq+Uk+WFV3Jjk7yX1V9Zkk5yT5oyRnVdUNw/lO6u5vTJbPx4fz/8dMHpL4oPYewK5rpwPqqnpOkr9I8qTuvnkHjluXqQb323nMy5Lc093vnjW+NsmF3X3I9q4FAAAAwPx19x5b2fdAklOG17R3Da/Z89cMP/89D27z8WOzpp60hVN+obt/aRslA7ug+bT4OCGT3049fyEKqaothuXdfdbscBoAAAAAgOVtpwLqqlqT5GlJXpIhoK6qdVV1WVV9oKpurqr3Dl/hSFX91DD28SQ/M7XOaVW1qaouTfLuqjqoqv6mqq4ffj5mat6vDNuHV9VnquoTSX5xPhcPAAAAwPLW3ee4exqWr529g/q4JBd3998n+UpVzTS0f0qSVyd5cpLHJXlaVe2VSc+gn07yw0keMWutw5M8u7tPTHJmknd396FJ3pvkLXOc+51JXtndR+9k7QAAAAAA7AJ2NqA+Icn7hu33De+T5NPd/S9Dn6HrMmmGf3CSW7v7H4anuP7JrLUu6O6vD9tHJzl32H5PkmOmJ1bVvkn26+7Lp+bMS1VtqKqrq0rzfAAAAACAJbTDD0msqv2T/GiSQ6qqk+yRpJNclOQbU1Pvn1q/t7Lk3VvZN/u42sZaO6y7NyXZlCTD9QAAAAAAsAR25g7q4zNpw3FQd6/t7kcnuTWz7naecnOSx1bV44f3J2xhXpJcmW89dPEFmTyE8f/r7q8muaOqjpmaAwAAAADAMrQzAfUJSc6bNfbnSU6ca3J335tkQ5IPDQ9J3LyVtV+Z5MVVdX2Sn03yqjnmvDjJW4eHJM60BklVHVhVF029v6iqDhy231BVz9rmlQEAAAAAsGR2uMVHd6+bY+wtmfVAw+mnp3b3xZn0op593Gmz3t+WSfuQLc7r7muS/MDU7tOG8duTPHNq3vT267dwOQAAAAAAjGRnH5IIAAAAAADzIqAGAAAAAGAUAmoAAAAAAEYhoAYAAAAAYBQCagAAAAAARrFq7AJ2KVXZvHH92FXAklm9KqnT7xy7DAAAAABWKAH1tO4cdPKFY1cBi27zxvXpU/cZuwzhOAAAAMAKp8UHAAAAAACjcAc1wNi0F2KF0mYIAAAAATXA2LQXYje1q7QTmk0oDgAAsOvQ4gMAAAAAgFEIqAEAAAAAGIWAGgAAAACAUSxZQF1Vf1BVr556f0lVvX3q/e9V1Wu2cOxlVXXEHOMnVdWZw/Z3VNW7quodNXFRVe03vP7HYlwTAAAAAAA7bynvoL4yyVOTSZic5GFJvm9q/1OTXLEzC1dVJTkryZ5Jfr4nntndX02yXxIBNfD/VdU5VXX8PNd4c1XdVFVvXqi6AAAAAFaapQyor8gQUGcSTN+Y5GtV9R+qanWSJyVJVV1eVdcMd1g/cur4F1bVlVV1Y1UdNWvtM5Lsn+RF3f3AsM5tVfWwJG9K8viquk6QBLunqvrOqtp7gdfcYxtTXprkB7v7tQt5XgAAAICVZMkC6u6+Pcl9VfWYTILqTyT5VJKjkxyR5O+S/EGS47v78CTvSPLGqSX27u6nZnI39Dumxk9McniS53f3fXOc+teS/GN3HzZXkFRVG6rq6qq6et4XCSypqnpSVf1ekluSPHEYe31VXTX8MmvT8A2LuTx9+KXX52bupq6qdVX1kao6N8kNVbXHcKf0VVV1fVW9dJh3QZK9k3yqqp63+FcKAAAAsHtatcTnm7mL+qlJfj/Jo4btO5L8a5Jjk/zVkCftkeTzU8f+aZJ090erap+q2m8YvzbJwUmOyk60COnuTUk2JUlV9Y5fErCUhjuln5vkJUkqyTuTHNrdXxumnNndbxjmvifJ+iQfnGOpRyY5JpPPjwuSfGAYPyrJId19a1VtSHJHdx85fNPjiqq6tLufVVV3dfdhi3SZAAAAACvCUgfUM32ovz+TFh//nOSXk9yZ5MNJHtXdR2/h2Nnh8cz7m5O8PsmfVdVPdvdNC141sCv5fJLrM+k3f/Mc+59RVb+a5LuTPDTJTZk7oD5/aAn02ao6YGr8091967B9bJJDp/pV75vkCUluzTwN4feG+a4DAAAAsJwtZQ/qZHKH8/okX+nu+7v7K5k8xPDoJO9P8vCqOjpJqmrPqpp+iOLzhvFjMrmj8Y6ZHd19ZZKXJfnQ0EJk2teSPGSxLghYcsdn8o2L84Z2HgfN7KiqvZL8USatgr4/ydlJ9trCOt+Y2p5uA3L3rPFXDC2CDuvux3b3pQtxEd29qbuP6O4jFmI9AAAAgOVoqQPqG5I8LMknZ43d0d1fyCR42lhVn0lyXb71UMUk+bequjLJWZl8tf9BuvvCJKcnubiq9p8a/3ImX8u/0UMSYfnr7ku7+3mZtOe4I8lfVtVfV9XafCuM/lJVrcnkM2U+Lkny8qraM0mq6okL/TBGAAAAgJVsSVt8dPf9SfaZNXbS1PZ1SZ4+x3HrtrDeOUnOmXr/zkz60SbJ2qnxE3e2ZmDXNPzy6YwkZ1TVUUnu7+6vVtXZmfzi67YkV83zNG/P5LPk2uFhi19Mctz0hKo6MMnbu/uZw/uLMmk/cntVvSHJ1d19wTzrAAAAANgtLXUPaoAF192fntp+XZLXbWP+SbPerxl+XpbksqnxB5KcMrxmrzFzzO1Jnjk1Pr39+h25DgAAAICVZqlbfAAALGtVdVpV/cpW9p8z9XDV6fF1VXXhTpxvXVU9der9nOsDAAAsR+6gBgDYta1LcleSK+e70NCuqIZviGxpUjZvXD/fU8GytHpVUqffOXYZAAArioAaAGAbquo3krwoyT9n0o/+mqr6hSQbknxnkv+b5Ge7+57hkB+vqlclOSDJa4aHOW/rHA9N8o4kj0tyz7D2nUleluT+qnphklcM059eVa9J8ogkv9rdHxjWeG2S5yZZneS87j51eIjs/0nykSRHZ9JLf/MWC+nOQSfv8I3esKxt3rg+feo+2564CATiAMBKp8UHAMBWVNXhSZ6f5ClJfibJkcOuv+juI7v7B5L8XZKXTB22NsmPJPkvSc6qqr2241SnJ/nb7j40k9737+7u25KcleQPuvuw7v7YMPeRSY5Jsj7Jm4Y6j03yhCRHJTksyeFVNfPw6e8d1ntKd39bOF1VG6rq6qq6ejvqBAAAWDDuoAYA2LofzuRu5HuSpKouGMYPqarfTrJfkjVJLpk65s+GNhr/UFWfS3LwdpznmCT/NUm6+8NVtX9V7buFuecP63+2qg4Yxo4dXn87vF+TSWD9T0k2d/cnt3Ti7t6UZNNwfb0dtQIAACwIAfWD3bV54/pbxi5iBz0syZfGLmIHqHdxbXe9u8jXSb937AJ2Ecvts2e3/Xexi9it6t1FPmtm25nPnrlC23OSHNfdn6mqkzLpFb2l+dsT+tZ2njdJvjHHcZXkd7r7bQ9adNLi4+7tOP8Mn0mLS72La6frHfHzyv+Htmy5fR4lK+jfzEhWVL0jfC6ttM+j5fYZs9z+/ifLr+YVV+8Sf85s8TNGQP1gt3T3EWMXsSOq6urlVLN6F9dyrHfsGnYRy+qzZzn+PVPv4llu9SY79dnz0STnVNWbMvm/008neVuShyT5fFXtmeQFSf516pj/VlXvSvLYTHpK35Lkh7bjPC9I8ltVtS7Jl7r7zqr6WpLtaY57yXDse7v7rqp6VJJvbu9FTvGZtIjUu7iWW72J/w9tw7L6PEqW399B9S6u5Vjv2DUssWX1GbPc/j4ly69m9S6urX3GCKgBALaiu6+tqvcnuS6ThwvO9IH+zSSfGsZuyCSwnnFLksszeUjiy7r73qq5bpB+kNOSvLOqrs/kIYn/fRj/YJIPVNWz862HJM5V56VV9aQknxjOdVeSFya5f/uuFAAAYOkJqAEAtqG735jkjXPs+uM55p60hTUuS3LZVs7xlSTPnmP875McOjX0sVn710xtn5HkjDmWP2RL5wUAABjTd4xdwC5m09gF7ITlVrN6F5d6l6fl9ueg3sWl3sW3HGteSsvtz0e9i0u9i2851rxUluOfzXKrWb2LS727tuV2vcut3mT51azexbXFeqvbg9oBAJZKVb04yatmDV/R3b84Rj0AAABjElADAAAAADAKLT4AAAAAABiFgBoAAAAAgFEIqAEAAAAAGIWAGgAAAACAUQioAQAAAAAYxf8DbNc4ytYezZgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 1440x360 with 5 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import cafechungkhoan\n",
    "cafechungkhoan.plot(eda,'Vi phạm')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "eda1 = eda1.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "table1 = eda1.groupby('Từ khóa').count()\n",
    "table1 = table1.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "table2 = eda.groupby('Từ khóa').count()\n",
    "table2 = table2.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "merge = pd.merge(table1,table2,on='Từ khóa')"
   ]
  },
  {
   "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>Từ khóa</th>\n",
       "      <th>#_x</th>\n",
       "      <th>#_y</th>\n",
       "      <th>tỉ lệ xuất hiện click ảo %</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>đăng ký đầu tư chứng khoán</td>\n",
       "      <td>57</td>\n",
       "      <td>477</td>\n",
       "      <td>11.949686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>+mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>44</td>\n",
       "      <td>396</td>\n",
       "      <td>11.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>tao tai khoan chung khoan</td>\n",
       "      <td>12</td>\n",
       "      <td>160</td>\n",
       "      <td>7.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>+đăng +ký +tài +khoản +chứng +khoán</td>\n",
       "      <td>14</td>\n",
       "      <td>121</td>\n",
       "      <td>11.570248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>viet capital securities</td>\n",
       "      <td>17</td>\n",
       "      <td>97</td>\n",
       "      <td>17.525773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>hướng dẫn đăng ký tài khoản chứng khoán</td>\n",
       "      <td>10</td>\n",
       "      <td>88</td>\n",
       "      <td>11.363636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>+mở +tài +khoản +chứng +khoán +online</td>\n",
       "      <td>9</td>\n",
       "      <td>56</td>\n",
       "      <td>16.071429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>+tai +khoan +chung +khoan</td>\n",
       "      <td>12</td>\n",
       "      <td>52</td>\n",
       "      <td>23.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>+cách +mở +tài +khoản +chứng +khoán</td>\n",
       "      <td>3</td>\n",
       "      <td>49</td>\n",
       "      <td>6.122449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>+lập +tài +khoản +chứng +khoán</td>\n",
       "      <td>9</td>\n",
       "      <td>44</td>\n",
       "      <td>20.454545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>+tạo +tài +khoản +chứng +khoán</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>4.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>tạo tài khoản giao dịch chứng khoán</td>\n",
       "      <td>3</td>\n",
       "      <td>42</td>\n",
       "      <td>7.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>mở tài khoản chứng khoán fpts</td>\n",
       "      <td>4</td>\n",
       "      <td>37</td>\n",
       "      <td>10.810811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>+mở +tài +khoản +vndirect</td>\n",
       "      <td>3</td>\n",
       "      <td>26</td>\n",
       "      <td>11.538462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>mở tài khoản tcbs</td>\n",
       "      <td>5</td>\n",
       "      <td>22</td>\n",
       "      <td>22.727273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>+chơi +chứng +khoán +trên +điện +thoại</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "      <td>9.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>lập tài khoản giao dịch chứng khoán</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>6.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>hướng dẫn mở tài khoản chứng khoán vietcombank</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>mở tài khoản chứng khoán quốc tế</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>30.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>+mở +tk +chứng +khoán</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>11.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>+mở +tài +khoản +chứng +khoán +ở +đâu</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>mở tk chứng khoán online</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>lập tài khoản chứng khoán vietcombank</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>đăng ký tài khoản chứng khoán vndirect</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>33.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>mở tài khoản fpts</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>50.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>cách đăng ký chứng khoán</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           Từ khóa  #_x  #_y  \\\n",
       "25                      đăng ký đầu tư chứng khoán   57  477   \n",
       "4                    +mở +tài +khoản +chứng +khoán   44  396   \n",
       "21                       tao tai khoan chung khoan   12  160   \n",
       "10             +đăng +ký +tài +khoản +chứng +khoán   14  121   \n",
       "23                         viet capital securities   17   97   \n",
       "13         hướng dẫn đăng ký tài khoản chứng khoán   10   88   \n",
       "5            +mở +tài +khoản +chứng +khoán +online    9   56   \n",
       "8                        +tai +khoan +chung +khoan   12   52   \n",
       "1              +cách +mở +tài +khoản +chứng +khoán    3   49   \n",
       "2                   +lập +tài +khoản +chứng +khoán    9   44   \n",
       "9                   +tạo +tài +khoản +chứng +khoán    2   42   \n",
       "22             tạo tài khoản giao dịch chứng khoán    3   42   \n",
       "17                   mở tài khoản chứng khoán fpts    4   37   \n",
       "7                        +mở +tài +khoản +vndirect    3   26   \n",
       "20                               mở tài khoản tcbs    5   22   \n",
       "0           +chơi +chứng +khoán +trên +điện +thoại    2   21   \n",
       "15             lập tài khoản giao dịch chứng khoán    1   15   \n",
       "12  hướng dẫn mở tài khoản chứng khoán vietcombank    2   10   \n",
       "18                mở tài khoản chứng khoán quốc tế    3   10   \n",
       "3                            +mở +tk +chứng +khoán    1    9   \n",
       "6            +mở +tài +khoản +chứng +khoán +ở +đâu    2    5   \n",
       "16                        mở tk chứng khoán online    2    4   \n",
       "14           lập tài khoản chứng khoán vietcombank    1    3   \n",
       "24          đăng ký tài khoản chứng khoán vndirect    1    3   \n",
       "19                               mở tài khoản fpts    1    2   \n",
       "11                        cách đăng ký chứng khoán    1    1   \n",
       "\n",
       "    tỉ lệ xuất hiện click ảo %  \n",
       "25                   11.949686  \n",
       "4                    11.111111  \n",
       "21                    7.500000  \n",
       "10                   11.570248  \n",
       "23                   17.525773  \n",
       "13                   11.363636  \n",
       "5                    16.071429  \n",
       "8                    23.076923  \n",
       "1                     6.122449  \n",
       "2                    20.454545  \n",
       "9                     4.761905  \n",
       "22                    7.142857  \n",
       "17                   10.810811  \n",
       "7                    11.538462  \n",
       "20                   22.727273  \n",
       "0                     9.523810  \n",
       "15                    6.666667  \n",
       "12                   20.000000  \n",
       "18                   30.000000  \n",
       "3                    11.111111  \n",
       "6                    40.000000  \n",
       "16                   50.000000  \n",
       "14                   33.333333  \n",
       "24                   33.333333  \n",
       "19                   50.000000  \n",
       "11                  100.000000  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table3 = []\n",
    "table3 = pd.DataFrame(table3)\n",
    "table3['Từ khóa'] = merge['Từ khóa']\n",
    "table3['#_x'] = merge['#_x']\n",
    "table3['#_y'] = merge['#_y']\n",
    "table3['tỉ lệ xuất hiện click ảo %'] = (table3['#_x']/table3['#_y'])*100\n",
    "table3.sort_values(by=['#_y'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "eda['target'] = eda['Vi phạm']\n",
    "eda = eda.drop(['Vi phạm'],axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Running DummyClassifier(strategy='prior')\n",
      "accuracy: 0.879 average_precision: 0.121 roc_auc: 0.500 recall_macro: 0.500 f1_macro: 0.468\n",
      "=== new best DummyClassifier(strategy='prior') (using recall_macro):\n",
      "accuracy: 0.879 average_precision: 0.121 roc_auc: 0.500 recall_macro: 0.500 f1_macro: 0.468\n",
      "\n",
      "Running GaussianNB()\n",
      "accuracy: 0.141 average_precision: 0.122 roc_auc: 0.505 recall_macro: 0.502 f1_macro: 0.133\n",
      "=== new best GaussianNB() (using recall_macro):\n",
      "accuracy: 0.141 average_precision: 0.122 roc_auc: 0.505 recall_macro: 0.502 f1_macro: 0.133\n",
      "\n",
      "Running MultinomialNB()\n",
      "accuracy: 0.878 average_precision: 0.140 roc_auc: 0.526 recall_macro: 0.499 f1_macro: 0.468\n",
      "Running DecisionTreeClassifier(class_weight='balanced', max_depth=1)\n",
      "accuracy: 0.225 average_precision: 0.124 roc_auc: 0.513 recall_macro: 0.513 f1_macro: 0.224\n",
      "=== new best DecisionTreeClassifier(class_weight='balanced', max_depth=1) (using recall_macro):\n",
      "accuracy: 0.225 average_precision: 0.124 roc_auc: 0.513 recall_macro: 0.513 f1_macro: 0.224\n",
      "\n",
      "Running DecisionTreeClassifier(class_weight='balanced', max_depth=5)\n",
      "accuracy: 0.308 average_precision: 0.126 roc_auc: 0.500 recall_macro: 0.499 f1_macro: 0.271\n",
      "Running DecisionTreeClassifier(class_weight='balanced', min_impurity_decrease=0.01)\n",
      "accuracy: 0.273 average_precision: 0.121 roc_auc: 0.500 recall_macro: 0.500 f1_macro: 0.180\n",
      "Running LogisticRegression(C=0.1, class_weight='balanced', max_iter=1000)\n",
      "accuracy: 0.484 average_precision: 0.137 roc_auc: 0.532 recall_macro: 0.510 f1_macro: 0.407\n",
      "Running LogisticRegression(class_weight='balanced', max_iter=1000)\n",
      "accuracy: 0.485 average_precision: 0.142 roc_auc: 0.543 recall_macro: 0.522 f1_macro: 0.413\n",
      "=== new best LogisticRegression(class_weight='balanced', max_iter=1000) (using recall_macro):\n",
      "accuracy: 0.485 average_precision: 0.142 roc_auc: 0.543 recall_macro: 0.522 f1_macro: 0.413\n",
      "\n",
      "\n",
      "Best model:\n",
      "LogisticRegression(class_weight='balanced', max_iter=1000)\n",
      "Best Scores:\n",
      "accuracy: 0.485 average_precision: 0.142 roc_auc: 0.543 recall_macro: 0.522 f1_macro: 0.413\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "SimpleClassifier(random_state=2)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "eda_clean = cafechungkhoan.clean(eda, verbose=-1)\n",
    "fc = cafechungkhoan.SimpleClassifier(random_state=2)\n",
    "X = eda_clean.drop('target', axis=1)\n",
    "y = eda_clean.target\n",
    "fc.fit(X, y) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}