EDA_시각화.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"3_EDA및시각화.ipynb","provenance":[],"collapsed_sections":[],"machine_shape":"hm","authorship_tag":"ABX9TyOZmh6sWcUf2zpg4/Y5ZU05"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"},"accelerator":"TPU"},"cells":[{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"Yw9wDzSLLSbt","executionInfo":{"status":"ok","timestamp":1634463442510,"user_tz":-540,"elapsed":8892,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"2a56e6f7-8860-442f-8694-15a2c5387eb4"},"source":["!sudo apt-get install -y fonts-nanum\n","!sudo fc-cache -fv\n","!rm ~/.cache/matplotlib -rf"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Reading package lists... Done\n","Building dependency tree       \n","Reading state information... Done\n","The following NEW packages will be installed:\n","  fonts-nanum\n","0 upgraded, 1 newly installed, 0 to remove and 37 not upgraded.\n","Need to get 9,604 kB of archives.\n","After this operation, 29.5 MB of additional disk space will be used.\n","Get:1 http://archive.ubuntu.com/ubuntu bionic/universe amd64 fonts-nanum all 20170925-1 [9,604 kB]\n","Fetched 9,604 kB in 1s (7,173 kB/s)\n","debconf: unable to initialize frontend: Dialog\n","debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76, <> line 1.)\n","debconf: falling back to frontend: Readline\n","debconf: unable to initialize frontend: Readline\n","debconf: (This frontend requires a controlling tty.)\n","debconf: falling back to frontend: Teletype\n","dpkg-preconfigure: unable to re-open stdin: \n","Selecting previously unselected package fonts-nanum.\n","(Reading database ... 155047 files and directories currently installed.)\n","Preparing to unpack .../fonts-nanum_20170925-1_all.deb ...\n","Unpacking fonts-nanum (20170925-1) ...\n","Setting up fonts-nanum (20170925-1) ...\n","Processing triggers for fontconfig (2.12.6-0ubuntu2) ...\n","/usr/share/fonts: caching, new cache contents: 0 fonts, 1 dirs\n","/usr/share/fonts/truetype: caching, new cache contents: 0 fonts, 3 dirs\n","/usr/share/fonts/truetype/humor-sans: caching, new cache contents: 1 fonts, 0 dirs\n","/usr/share/fonts/truetype/liberation: caching, new cache contents: 16 fonts, 0 dirs\n","/usr/share/fonts/truetype/nanum: caching, new cache contents: 10 fonts, 0 dirs\n","/usr/local/share/fonts: caching, new cache contents: 0 fonts, 0 dirs\n","/root/.local/share/fonts: skipping, no such directory\n","/root/.fonts: skipping, no such directory\n","/var/cache/fontconfig: cleaning cache directory\n","/root/.cache/fontconfig: not cleaning non-existent cache directory\n","/root/.fontconfig: not cleaning non-existent cache directory\n","fc-cache: succeeded\n"]}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"vk49SlDIKPs0","executionInfo":{"status":"ok","timestamp":1634463481323,"user_tz":-540,"elapsed":31001,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"0e37134a-4551-4ae6-a1cf-072e7586c32e"},"source":["import os, sys\n","from google.colab import drive\n","drive.mount('/content/drive')\n","my_path = '/content/notebooks'\n","os.symlink('/content/drive/My Drive/Colab Notebooks', my_path)\n","sys.path.insert(0,my_path)"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Mounted at /content/drive\n"]}]},{"cell_type":"code","metadata":{"id":"qMbsiB3PvYa-"},"source":["import matplotlib.pyplot as plt\n","\n","plt.rc('font', family='NanumBarunGothic') "],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"4LuypAGSzhej"},"source":["# 사용할 라이브러리 \n","import pandas as pd\n","import matplotlib.pyplot as plt\n","from matplotlib import rc\n","import seaborn as sns\n","%matplotlib inline\n","import warnings\n","\n","warnings.filterwarnings('ignore')\n","plt.rc('font', family='NanumBarunGothic') "],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"VyO5ln7KnqCi"},"source":["again = pd.read_csv('/content/drive/MyDrive/LMEMBERS 프로젝트(1차)/dataset/1015/again_dataset.csv',encoding='cp949',index_col=0)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"rDDf-twVn6iX"},"source":["a1 = again['구매금액_A_1'].sum()\n","a2 = again['구매금액_A_2'].sum()\n","a3 = again['구매금액_A_3'].sum()\n","a4 =again['구매금액_A_4'].sum()\n","\n","b1 = again['구매금액_B_1'].sum()\n","b2 = again['구매금액_B_2'].sum()\n","b3 = again['구매금액_B_3'].sum()\n","b4 = again['구매금액_B_4'].sum()\n","\n","c1 = again['구매금액_C_1'].sum()\n","c2 = again['구매금액_C_2'].sum()\n","c3 = again['구매금액_C_3'].sum()\n","c4 = again['구매금액_C_4'].sum()\n","\n","d1 = again['구매금액_D_1'].sum()\n","d2 = again['구매금액_D_2'].sum()\n","d3 = again['구매금액_D_3'].sum()\n","d4 = again['구매금액_D_4'].sum()"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"142VFDhXrVrA"},"source":["제휴사별기수별매출 = pd.DataFrame({'quarter':['14-1','14-2','15-1','15-2'],\n","                   'A':[a1, a2, a3, a4],\n","                   'B':[b1, b2, b3, b4],\n","                   'C':[c1, c2, c3, c4],\n","                   'D':[d1, d2, d3, d4]\n","                   })"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"j3QKz7OVszmm"},"source":["제휴사별기수별매출.set_index('quarter',inplace=True)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"nGZ2MGNIu0Z5","executionInfo":{"status":"ok","timestamp":1634465637178,"user_tz":-540,"elapsed":4,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"c6db6761-b2f2-426c-fbda-6bf5639f4308"},"source":["제휴사별기수별매출"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>A</th>\n","      <th>B</th>\n","      <th>C</th>\n","      <th>D</th>\n","    </tr>\n","    <tr>\n","      <th>quarter</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>14-1</th>\n","      <td>118545080930</td>\n","      <td>28005534843</td>\n","      <td>11505615602</td>\n","      <td>109039010</td>\n","    </tr>\n","    <tr>\n","      <th>14-2</th>\n","      <td>130229870180</td>\n","      <td>28293300200</td>\n","      <td>12253126219</td>\n","      <td>187336274</td>\n","    </tr>\n","    <tr>\n","      <th>15-1</th>\n","      <td>128085420260</td>\n","      <td>27392575451</td>\n","      <td>12620518270</td>\n","      <td>230191900</td>\n","    </tr>\n","    <tr>\n","      <th>15-2</th>\n","      <td>136021599860</td>\n","      <td>27022036430</td>\n","      <td>12836103067</td>\n","      <td>236363960</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                    A            B            C          D\n","quarter                                                   \n","14-1     118545080930  28005534843  11505615602  109039010\n","14-2     130229870180  28293300200  12253126219  187336274\n","15-1     128085420260  27392575451  12620518270  230191900\n","15-2     136021599860  27022036430  12836103067  236363960"]},"metadata":{},"execution_count":36}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":532},"id":"HusdFPqjs4P-","executionInfo":{"status":"ok","timestamp":1634465744938,"user_tz":-540,"elapsed":352,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"d6c33aa1-5603-43bc-ed09-e50d989ecfcb"},"source":["제휴사별기수별매출.plot(kind='bar',figsize=(10,8))\n","plt.title( '제휴사별 매출변화', size=20 )\n","plt.ylabel('매출 합계')\n","plt.xlabel('기수')\n","plt.legend(labels=제휴사별기수별매출.columns, loc='best')\n","plt.show()"],"execution_count":null,"outputs":[{"output_type":"display_data","data":{"image/png":"iVBORw0KGgoAAAANSUhEUgAAAmAAAAIDCAYAAACjC6IkAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3dfbytZV0n/s9XVA6EHBs5jAbJIUjAwgwxH0ojqabxaWg0IXvQnH5kZjVYqfPr4acVg02jjT38NLLGEAzTHDUZGxV+B2pA61CWiFCmmPSgB6RQG1Tg+/tjrZPLzd777H3OXtd+OO/367Vfa933da9rf8/hZu/Pue7rvu7q7gAAMM691rsAAICDjQAGADCYAAYAMJgABgAwmAAGADCYAAbcQ1U9vKoevwHqOLqqzqiqB653Lcupqq+rqkevdx1rpaq2Tf/ev2K9a4GtqixDAVTVNyb5niS/2N03VtWuJI/u7m3LfOYpSU5YovmS7t6zgu97rySHJ/l8d392kfZzkvxOku/r7tcuaDsySXf3pxbp88gkd3T3HTP7T0pyapIrV1LbPur+jiT/JsmLuvvWqrohybbu3rnMZ3YnecQiTW/t7rOW+dxhSe7V3Z9ZpO2ILPi7q6r7J9mZ5G+6+5MLjr9Pku2LfJs7u/sfZ47bmeQjSX6hu1+8VG3A/rv3ehcArI+qqv7Cv8BOSfIfklyc5MYVdvEfkvy7Jdp2JVlJyHl4kmuTvDrJD67w++71F0k+neSrF+x/SJIPJvmFJLPh4duTXJDkm6b1LWoa4Ja6OnDX9O/sUZn8+X8+ya0rrPfnkuxYZP9N+/jcO5KcnuSIBXVuS/KpJG9Ics5M07dlGlqTvHZBX2dO+1vozzP5bwEMIoDBFldV/yuTX7yz7pVJ8Hnk/va73KjNKtw1fb1j2aP2z/2q6tiZ7SNX+LmLknzXEm2LhZolTUeovnlm1y2LHHZkVT0jySe7+90r7Xs/vT+TP8NCn1xkHzBHAhhsfRcluSpJJ/l8kspkdOiG1XZUVXckOXSVH/uJ7v6vS7QdNn29x+W1FfrSqvr+Bfv2zhd73vRrf/1Yks9N35+yn30dm+R/LNN+dyb/PSrJq5LsTwD70qo6fWb7HvO2qurMTP4MSzmiqp4/ff/uzCcQAzMEMNjiuvuS2e2q+prsZwBL8vys/ufGNcu0PXj6+uH9qCVJvizJbyzR9uYkr5vZ/ndJnr2Kvi/s7k8nSVV9W/YvgN2Y5H4L9nUmwevBSX5iWtMrp++XclhVvWfBvpq+fuv0aznfk+RZK6g3mYyQ7VrhscB+EsDg4LP3br3/vdoPdvdrZrer6sRM5lwdmcno2t8n+fPFJowv4aHT1w+ttpapG5OcsWDfiUn+MMlfdfdbFtQ61HS+2KdnanhgJpP3vzPJt2QSxl6Q5Fdm5uMt5u7c8+/oXkm+Lsk7k/zkzP4nZBKwZ+t4dmbCZ1UdnUkA7CQf7u7bZo+fTsIH5kgAg4PPv81kgvwfVtXxmVxS/Ner6aCqnp7JhPbFQs3nquoNSc7r7n1NUP/G6evjMrlMulp3dvc/LKjt/tO3z1ywNMSX70f/+3LCdDL8fRc2VNX2JI/NJKCekuTx09ePJ3lbkv8nkxsDXpnkp6vqDzO5seDPuvutC7r7bHd/94L+t2US5G7r7t0z+3cuVWxVPTLJr2RyE8Hey5+pqsuTPK+7/2qlf3DgwAhgcBCZjnw8Mclvd/ddVfWOJCetso9HJ/ndTC5hnpXJJcZbMwkhJyb53kzmT+3IJOwt1c+DknzDdPN5VfVfuvvzSxz+HVV18vT9Fd39zun7+87s3+v46esdSf5xZv9idyAeqNk5Wx9d0HavTObf3ZXkukzmgp2b5Oruvnt6zM9X1QmZ/D09KpNAdViShQFsOd9QVW+Z2f6yxQ6a3pBwRSYB8IxM/rsdkslNAr+VZFdVnbxwWQ9gPgQwOLj8eJL75AsTtZ+byfIG/zYrn+P08ExGTl69YKTm/yR5f1X9dJJnZrJ0wnLOzeRn0HszCR8vymRZh8U8cfqVJHdmctktSb4ykyUnFvPm2TWsqurFmYzaraUfSPKJJL86u3O6TtiXZLIMxl0zTScmObGqssCnk1w+/UpVPTvJ+7r7fSuo4d754iUqDlviuKdNj/u+7r5yZv/vV9XLkvzXTC6Lvnmm7UVV9aLp+/O6+7+toB5gBQQwOEhMFyL9kUxGq55QVc/o7t+dth277Ie/2JuT/KckL6+qx2YyknJbJiNgX5HkOzIZhflPy9TywEzC4J5MJpD/YZKfrKo3d/f1i3zkHguxJvmPWbA21gLXrehPc2De2d03TQPM7KK1v5TkmAPs+6VJ9gaww6tq4RywvSluV3f/yzpgM4vXLrR3sdbDF2k7fMExe12Z5A+m7/9oJUUDKyOAwUFgOl/okiT/nMnaX29L8qqq+pPu/shq+uruT1TVwzMZMXtyJgFqdhL+e5L8QHdfsUQtey/NHZHkh7v79qp6TiY3BVxWVY9ZOK9riTreMu3vSzJZ4X6hbQvmgO1K8pgkiwW8NdXdSwbamVXm3zAbnJbxhiS7l2n/sxWW9fuZTM7/L1X1uSRXZ3IJ8lsyGX38m9xzHt57uvtlK+wfWAUBDLa4qjokk8DziCTf1d0fqaofyGTU6R3788zH6V1z50+/VutXM/mlf+neUa3uvraqfijJa5K8s6qe3N1/s8L+TsnyS10stOxK+Gupqg5P8pwFu//V9PUrZ9be2usj3X3Z7I7uftVa1NLdf1tV/ybJ/5svHiHrTILXc83/gnE2XQCbXkb575k852zJfz1W1b0zWbPogiRf2903TPcfnuSnkrwwyRGzz4qDraaqDs1kLazvSPKK7n59knT31dPA86pMHj/05qV7SabPhvzG5Y5Zgb3LLzw7k7lOz55t7O7fnD738JVJdlfVaSvs94OZjGztyzOT/PBKi03yqUXmaq3WkZncdbiY06Zfsy6bfi2qqr46k2f4vn9/iunu9yQ5rap2ZHKJ9nNJvmbhMyOB+dt0ASyTybq/nMndV8s5LsnHMpngO+urMrlz6ZlrXxpsON+e5N8neXl3//hsQ3e/enop6u3TY5bzyiRvmtm+13TfjVkwAT3JeZmsMXXegv2fzeSS5e8mefZiD9/u7l+dznV6THffvMIA9Pkk+7xkmclzE1fi0iw9f+zaFfaRJJleSl3RH6KqllsHbK+3ZPJze+dq6liou/dU1eczWd7ik9Pvf2iSozJZvf+AHlYO7NumC2DdfVFVnbF3ezqi9WuZ3Hp+aCb/yn9jd/91kr+uqh9e8Pk/mX5uXNGwTrr70qr6s+5e9AHb3f1byb7/f+juL3qcznSE+ZVJbu7uhXcAnpPkmIX7p21f3d0f38f3+oN8YeL3SjwsyZ+s4vhldffbMwmlB2w6924tnpm5Yt19aSYhcm8ND8o9H4d0SJKjJ8318UxG6mZvIljusUXAGth0AWwRL0xyQ3d/3/TyxbVV9dbu/ty+PggHg6XC13rYV/g6QJdkcjl1X/5ijjUsdP8sfkfiSHflix8Cfvd0319n8gzOT2VyF+utmdxE8dHc825IYI1thQB2epKjq2rvgo/3yuRhvCudwAtsDQ/MZI2yfblvJneBjnRNktev5MCqOqq7b1nmkPtX1UtW0NXN3f2a7v5EJpd+V8yjiGD+tkIAuy7JB7r7dUlSVcev4u4pYOs4c/q1L2/I+AD2mKzsRoFkst7WcgFseyaPMdqX92ZyVymwAdXyz3/dmKZzwJ7b3edU1f2SvDqTiaNJ8qfdfd7Msbumx96woI+bkpzsLkgAYLRNGcAAADaze613AQAAB5tNNQfsqKOO6p07d653GQAA+3Tttdfe0t07FmvbVAFs586d2b17uUeiAQBsDFX10aXaXIIEABhMAAMAGEwAAwAYbFPNAQMADh6f//znc/PNN+eOOzb2kp3btm3Lsccem/vc5z4r/szcAlhVnZTkvyf5m+4+Z4ljtmXyEN3f6+6XzKsWAGDzufnmm3O/+90vO3fuTFWtdzmL6u7ceuutufnmm3P88cev+HPzvAT5qCS/vI9jfjbJu+dYAwCwSd1xxx15wAMesGHDV5JUVR7wgAesepRubgGsuy9K8g9LtVfVo5IcneSt86oBANjcNnL42mt/alyXOWBVdWiS/5zk6Um+Zh/Hnpvk3CR58IMfPP/iAIANaeeLL1vT/m562ZPWtL/VWK+7IF+a5BXdfdu+DuzuC7v79O4+fceORReTBQCYmxe96EV5/OMfnzvvvHPN+hwWwKrqkKo6crp5apLvqapLk/xckqdX1Q+OqgUAYCXuuuuufOhDH8rTn/70vOMd71izfkeOgJ2T5OIk6e4ndfc507sjfzPJm7r7VQNrAQDYp3e96115zGMek2c84xm5+OKL16zfuQaw7t61dwmK7r6ku5+6yDGvtQQFALARXXTRRXna056WBz7wgbn99tvzyU9+ck36tRI+AMAibr/99lx55ZU577zzctZZZ+XjH/94Lr300jXp20r4AACLeOMb35gf+7Efywte8IIkyT/+4z/myU9+cp73vOcdcN8CGACwKYxeNuJ1r3tdXvva1/7L9v3vf/8cccQRueGGG3LyyScfUN8CGADAInbt2nWPfX/wB3+wJn2bAwYAMJgABgAwmAAGADCYOWAAsAmt1XMR1/N5iAczI2AAAIMJYAAAg7kECQBsDi/Zvsb9/dPa9rcKAhgAwBJuuummPOxhD8tpp52Wu+++O4cffnguvvjiHHXUUQfUr0uQAADLeOhDH5pdu3blqquuyuMe97i85jWvOeA+BTAAgBXo7tx888055ZRTDrgvAQwAYBnXX399zjjjjHzVV31Vbrzxxjz+8Y8/4D7NAQMAWMbeS5BJcvnll+cZz3hG3vWudx1Qn0bAAABW6Jhjjsltt912wP0YAQMANod1WjZi7yXIqsrdd9+dV7/61QfcpwAGALCEnTt35vbbb1/zfl2CBAAYTAADABhMAAMAGEwAAwAYTAADABhMAAMAGMwyFDBnO1982Zr0c9PLnrQm/QBsVqf+9qlr2t/7n/X+Ne1vNQQwAIAl3HDDDXnxi1+c2267LXfeeWeOO+64XHjhhTniiCMOqF8BDABgEXv27MlZZ52V17/+9TnttNOSJNdee23uvPPOA+5bAAMAWMSFF16YZz3rWf8SvpLkEY94xJr0bRI+AMAiPvaxj+Xkk0+eS98CGADAIk444YR8+MMfnkvfLkECbCBrcdesO2ZhbXz3d393zjzzzDzlKU/JQx7ykCTJFVdckRNOOCHHHXfcAfUtgAEAm8LoZSMe9KAH5eKLL85zn/vcfPrTn862bdty8skn5+Uvf/kB9y2AAQAs4bTTTssVV1yx5v2aAwYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYZSgAgE3hgyefsqb9nXLDB9e0v9UwAgYAsISbbropRx55ZM4444w88pGPzJlnnpnLLjvwJ1YYAQMAWMZDH/rQ7Nq1K0nyoQ99KGeddVYOPfTQfPM3f/N+92kEDABghU488cScf/75+Y3f+I0D6kcAAwBYhRNPPDF///d/f0B9CGAAAKtwww035Cu+4isOqA9zwAAAVugDH/hAzj///PzO7/zOAfUjgAEAm8J6LRtx/fXX55u+6ZtSVTn66KNz0UUX5aSTTjqgPgUwAIAl7Ny5M7fffvua92sOGADAYAIYAMBgAhgAwGACGACwYXX3epewT/tT49wCWFWdVFVXV9Wli7TtqKpLquq9VbW7qp4/rzoAgM1p27ZtufXWWzd0COvu3Hrrrdm2bduqPjfPuyAfleSXk5y1SNvRSS7o7uuq6rAkH6mqX+uN/DcMAAx17LHH5uabb86ePXvWu5Rlbdu2Lccee+yqPjO3ANbdF1XVGUu0fWBm8wFJbha+AIBZ97nPfXL88cevdxlzsa5zwKrqS5JclOT7lznm3Ollyt0bPQEDAKzEugWwqrpfkjcleWl3v2+p47r7wu4+vbtP37Fjx7gCAQDmZFgAq6pDqurI6fvtSd6S5Be6+8pRNQAAbAQjR8DOSXLx9P1PJjk5yUuqatf065iBtQAArJu5Pguyu3cl2TV9f0mSS6bvX5jkhfP83vO288WXHXAfN73sSWtQCQCw2ViIFQBgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGAwAQwAYDABDABgMAEMAGCwuQWwqjqpqq6uqkuXaD9/2n5NVZ0xrzoAADaaeY6APSrJLy/WUFVPSPLw7n5skqcleXVV3XuOtQAAbBhzC2DdfVGSf1ii+cwkb5we93dJPprkpHnVAgCwkazXHLAdSW6Z2b5luu8equrcqtpdVbv37NkzpDgAgHlarwD2mSTbZ7a3J7ltsQO7+8LuPr27T9+xY9GMBgCwqQwLYFV1SFUdOd28PMlTp/uPyuTy442jagEAWE8jR8DOSXLx9P1lST5eVVcneXuSH+3uOwbWAgCwbuZ652F370qya/r+kiSXTN93kh+Z5/cGANioLMQKADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMNhcA1hVPb+qrqmq91TV2QvadlTV26vqqqraXVU/OM9aAAA2invPq+OqOiHJc5I8OsmhSf64qt7Z3bdND/nxJFd29y9W1eFJrq+q3+3uW+dVEwDARjDPEbAnJHlbd3+uuz+V5Kokj51p/4ckD5i+PzLJPye5Y471AABsCHMbAUuyI8ktM9u3TPft9StJLquqv0xy/yQ/2N2fWdhJVZ2b5NwkefCDHzy/agEABpnnCNhnkmyf2d6e5LaZ7Z9L8u7ufkiSE5OcV1UPXdhJd1/Y3ad39+k7duxY2AwAsOnMM4BdnuSJVXVIVR2W5Iwku6vqyGn7SUk+Mn3/qST/lOSEOdYDALAhzC2Adfd1Sd6e5Ook/1+SV2QSwi6eHvJTSX6kqq5K8idJPprkHfOqBwBgo5jnHLB09wVJLliw+5Jp2/VJHj/P7w8AsBFZiBUAYDABDABgMAEMAGAwAQwAYDABDABgsEXvgqyqv0rSSWr6mpn3laSnC6gCALBKSy1D8Q1DqwAAOIgsFcDelMlo18OS/Gkmo15fm+Qv8oWRMGt4AQDsh6UC2LcmOTTJO7r7CUlSVdd0t9AFAHCAlpqEf2aSa5McX1UXVdWjkzx/XFkAAFvXUgGsk7ysux+Y5JeSPC+T5zZuG1YZAMAWtdwyFJUk3f1n3f29Sd6W5LKquu+QygAAtqil5oBdn+Rjszu6+/eq6rAkj0hyzbwLAwDYqhYNYN39kSSpqtd19/fM7L94VGEAAFvVUguxfm8mlyC/fvo+Sd6f5NS9x3T3RfMvDwBg61nqEuSXT19/c+b9R5M8KMlzM5mkL4ABAOyHpS5Bnl9V53T3pVV1RJLPd/dnk1xZVU/OFx5PBADAKi16F2RVfWeSr6uqpya5OsmfV9Ujh1YGALBFLbUMxfMymQP2zCSnJXlSkh8ZVRQAwFa21BywZHKZ8a7uvrOqbkvysKr6rSQnxiVIAID9tlQA+90kxyf506p6c5Kjk7wyyY2ZTMwHAGA/LTUJ/1eq6rzu/qWq+qMkn+nu6wbXBgCwJS15CbK7f2n6+t5x5QAAbH3LPQsSAIA5WFEAq6oL5l0IAMDBYrm7IJMkVfXzmTySaHuSr0/yf5Kc3N2vmndxAABb0ZIjYFX1K1V1TJJjpru+KslPJPlvSb5zQG0AAFvSUivhX5jk9CRvTHLFTNPbk3xyQF0AAFvWUiNgpyT55yR/msmjiO6X5NdjAVYAgAO23CT8SvKGJGck+XSSn57uAwDgACwVwH5t+npNksdkMvL1iem+Q5Nsn3NdAABb1lIr4V9aVcdNnwN5yHT33yd5X5IjM3k0EQAA+2G5lfB/Yfr2h5O8o7s/kuQjSS4fURgAwFa1z3XAuvvTSR43oBYAgIPCogGsqv4qk3lfleSBmVx+nJ2A3939kPmXBwCw9Sw1B+wr976vqmu6+zHjSgIA2NqWGgH7YL6w5ldV1fULj+nuh86zMACArWqpEbBTquq4RZo+391/N+eaAAC2tOUm4f9pkv+dydyvvfPBvjzJwwfUBQCwZS0XwP6yu586u6OqrplzPQAAW95yAezYqvqZBfsOnWcxAAAHg+UC2I8vsu8n51UIAMDBYrmV8N8wshAAgIPFUg/jBgBgTgQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAweYawKrq+VV1TVW9p6rOXqT9a6vq6qr6o6p6+zxrAQDYKJZ7GPcBqaoTkjwnyaOTHJrkj6vqnd1927T9/kl+PclZ3f13VTW3WgAANpJ5joA9Icnbuvtz3f2pJFcleexM+3cneU+SC6vqj5J8+2KdVNW5VbW7qnbv2bNnjuUCAIwxzwC2I8ktM9u3TPftdXKS45L8+0zC1wVVNdueJOnuC7v79O4+fceOezQDAGw68wxgn0myfWZ7e5LbZrbvSvLG6QjZniTXZhLKAAC2tHkGsMuTPLGqDqmqw5KckWR3VR05bf+jJGcmSVV9SZKHJfnLOdYDALAhzG3ie3dfN72z8eokneQVmYSws5M8NcnvJfn6qtqd5M4kL+3uj8+rHgCAjWKudx529wVJLliw+5Jp291J/uM8vz8AwEZkIVYAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAweYawKrq+VV1TVW9p6rOXuKYbVX1/qp6yTxrAQDYKO49r46r6oQkz0ny6CSHJvnjqnpnd9+24NCfTfLuedUBALDRzHME7AlJ3tbdn+vuTyW5KsljZw+oqkclOTrJW5fqpKrOrardVbV7z549cywXAGCMeQawHUlumdm+ZbovSVJVhyb5z0nOW66T7r6wu0/v7tN37Nix3KEAAJvCPAPYZ5Jsn9nenmT28uNLk7xikUuSAABb2jwD2OVJnlhVh1TVYUnOSLK7qo6ctp+a5Huq6tIkP5fk6VX1g3OsBwBgQ5jbJPzuvq6q3p7k6iSd5BWZhLCzkzy1u5+099iqenaSnd39qnnVAwCwUcwtgCVJd1+Q5IIFuy9Z5LjXzrMOAICNxEKsAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAg917vQsAVugl29egj3868D4AOGAC2Hpai1+oiV+qALDJuAQJADCYETCArcboOmx4AhgAHMzML10XLkECAAwmgAEADCaAAQAMJoABAAwmgAEADCaAAQAMJoABAAwmgAEADCaAAQAMJoABAAwmgAEADCaAAQAMJoABAAwmgAEADCaAAQAMJoABAAwmgAEADCaAAQAMNtcAVlXPr6prquo9VXX2grYdVXVJVb23qnZX1fPnWQsAwEZx73l1XFUnJHlOkkcnOTTJH1fVO7v7tukhRye5oLuvq6rDknykqn6tu3teNQEAbATzHAF7QpK3dffnuvtTSa5K8ti9jd39ge6+brr5gCQ3Lxa+qurc6QjZ7j179syxXACAMeYZwHYkuWVm+5bpvi9SVV+S5KIk379YJ919YXef3t2n79hxj48DAGw68wxgn0myfWZ7e5LbZg+oqvsleVOSl3b3++ZYCwDAhjHPAHZ5kidW1SHTOV5nJNldVUcmSVVtT/KWJL/Q3VfOsQ4AgA1lbpPwp5Pr357k6iSd5BWZhLCzkzw1yU8mOTnJS6pq78e+q7v/dl41AQBsBHMLYEnS3RckuWDB7kumbS9M8sJ5fn8AgI3IQqwAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIMJYAAAgwlgAACDCWAAAIPde70LAAA2t1N/+9Q16ef9z3r/mvSzGQhgACxqLX6pHky/UGE1BDA4iPhXKsDGYA4YAMBgRsC2AJcJAGBzMQIGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABp7JJ+EAAAYvSURBVAAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMJgABgAwmAAGADCYAAYAMNhcA1hVPb+qrqmq91TV2Yu0n19VV0+POWOetQAAbBT3nlfHVXVCkuckeXSSQ5P8cVW9s7tvm7Y/IcnDu/uxVfVlSa6oqq/u7jvnVRMAY33w5FPWpJ9TbvjgmvTDxrYW58tmOVequ+fTcdX/leSY7n7JdPvXk7ytuy+bbp+f5K+6+7XT7f+V5AXd/YEF/Zyb5Nzp5klJbpxLwZvbUUluWe8i2BScK6yG84WVcq4s7rju3rFYw9xGwJLsyBf/x7hlum+2/Zpl2pMk3X1hkgvnUeBWUVW7u/v09a6Djc+5wmo4X1gp58rqzXMO2GeSbJ/Z3p7ktlW0AwBsSfMMYJcneWJVHVJVhyU5I8nuqjpypv2pSVJVR8XlRQDgIDG3S5DdfV1VvT3J1Uk6ySsyCWFnZxK8LkvyrVV1dSZB8Ee7+4551bPFuUTLSjlXWA3nCyvlXFmluU3CBwBgcRZiBQAYTAADABhMAAMAGEwAAwAYTAADABhMAAMADlhV1XrXsJkIYLBFVdXjquodVfXKqrrfzP43rGddwOZWVU+vqg9W1Vur6piZpsvXrahNaJ7PgmQOqupbl2rr7neOrIUN7xeTvCDJlyX5/ao6u7s/nuTo9S2Ljaiqzl2qbfpMXtjrhUnOTHJMkkur6vu7+8YkRsBWQQDbfN6Q5K2ZPF1gVicRwJh1Z3dfnSRV9YFMflB+Z+557kCS/EyS307yuQX7nS8sdGd3/12Sv6uq70jy+qr6oThXVkUA23x+KMlh3f2b610IG95nq+pfdfcnu/uDVfW8JG9Mcv/1LowN6TlJTu7uX17vQtjwbqmqL+/uj3X3P1TVd2Xys+Vfr3dhm4lHEW1CVbW9u/9pvetgY6uqr03ypd19xcy+U5O8prsftX6VAZtZVR2f5Ojufu/MvmOTvLy7z16/yjYXAQwAYDB3QW5iVfXK9a6BzcG5wmq4U5aVcq7sPwFsczt1vQtg03CusBrulGWlnCv7SQADYCFzU1gp58p+EsA2N2uusFLOFVbD+cJKOVf2kwC2uf3qehfApuFcYTV+ar0LYNNwruwnAWwT6+7fS5Kq+oH1roWNzbnCKn2iqs5a8JgZWIxzZT9ZhmKTqaqfWbgrydOSvKm7f3YdSmKDcq6wGlX1tu5+alU9JZPHWL07yTck+b+7+3+ub3VsJM6VtWEl/M3n6UnelcnjiPZeez8zyU3rVRAblnOF1Thi+vqjSb6luz9WVV+a5PeT+KXKLOfKGnAJcvN5ZJI7kzw7yfu6+8okf9vdF61rVWxEzhX2x327+2NJ0t23Jfn8OtfDxuVcOQBGwDaZ7v5skhdV1aOSvKmqXhG3AbMI5wqrdEpV/VaS4/buqKpt8XuCe3KurAFzwDaxqrpvkpcmObW7n7ze9bBxOVfYl6r6l1+m3f3R6b6vTPJl09FTSOJcWSsCGADAYIYLN5mqev1Sbd39zJG1sLE5V1gN5wsr5VxZGwLY5nNcklcm+fh6F8KG51xhNZwvrJRzZQ24BLnJVNVDkjyqu1+33rWwsTlXWA3nCyvlXFkbAhgAwGDWAQMAGEwAAw4qVVUz7z+0oO1eVfWJqjpkfGXAwUQAA7a0qnpEVe2efr03yaeqavsSh/9AkkOTHDuuQuBgJIABW1p3X9vdp3f36Uken+TD3f1Ps8dU1SFV9YIk35/kmUl+v6q+fXa0DGAtCWDAweScJG+c3VFVxyS5IcnxSc7o7suSfFuSJye5yuVIYB7cBQkcFKrq2CRvS3Lm9MHBqaoPdfeJVXV4d//zIp+p9kMSmAMLsQJbXlU9NMklSZ6zN3zNtP2PJA9a6mpjVV3W3T83/yqBg4kABmxpVfWUJD+e5JzuvnFhe3d/+4Ljb+runYPKAw5SAhiw1f3PJJd1993rXQjAXgIYsKV1913rXQPAQibhAwAMZhkKAIDBBDAAgMEEMACAwQQwAIDBBDAAgMEEMACAwQQwAIDB/n97ZShq7f0H6gAAAABJRU5ErkJggg==\n","text/plain":["<Figure size 720x576 with 1 Axes>"]},"metadata":{"needs_background":"light"}}]},{"cell_type":"code","metadata":{"id":"k_Ak7eOKLCqZ"},"source":["purprd = pd.read_csv('/content/drive/MyDrive/ cakd3_colab/LDATA/dataset/PURPRD.csv')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"MTNFsCZQjGq6"},"source":["newcat = pd.read_csv('/content/drive/MyDrive/LMEMBERS 프로젝트(1차)/dataset/뉴소중대.csv',encoding='cp949')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"XrtVj_GYjmEC","executionInfo":{"status":"ok","timestamp":1632751576407,"user_tz":-540,"elapsed":289,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"4bf3004a-8d23-431d-c372-917d0d4d760c"},"source":["newcat['중분류코드'].value_counts()"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["601     114\n","402     105\n","1701     69\n","1706     68\n","602      64\n","       ... \n","5311      1\n","1309      1\n","1409      1\n","5903      1\n","4102      1\n","Name: 중분류코드, Length: 656, dtype: int64"]},"metadata":{},"execution_count":71}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"i6z61_3xLguM","executionInfo":{"status":"ok","timestamp":1632751200570,"user_tz":-540,"elapsed":288,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"432c0744-184e-40bc-d581-aa7fd3301798"},"source":["purprd.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>Unnamed: 0</th>\n","      <th>제휴사</th>\n","      <th>영수증번호</th>\n","      <th>대분류코드</th>\n","      <th>중분류코드</th>\n","      <th>소분류코드</th>\n","      <th>고객번호</th>\n","      <th>점포코드</th>\n","      <th>구매일자</th>\n","      <th>구매시간</th>\n","      <th>구매금액</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0</td>\n","      <td>B</td>\n","      <td>8664000</td>\n","      <td>15</td>\n","      <td>1504</td>\n","      <td>B150401</td>\n","      <td>17218</td>\n","      <td>44</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>2420</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>B</td>\n","      <td>8664000</td>\n","      <td>16</td>\n","      <td>1601</td>\n","      <td>B160101</td>\n","      <td>17218</td>\n","      <td>44</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>1070</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>B</td>\n","      <td>8664000</td>\n","      <td>16</td>\n","      <td>1602</td>\n","      <td>B160201</td>\n","      <td>17218</td>\n","      <td>44</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>8060</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>3</td>\n","      <td>B</td>\n","      <td>8664000</td>\n","      <td>18</td>\n","      <td>1803</td>\n","      <td>B180301</td>\n","      <td>17218</td>\n","      <td>44</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>6000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>4</td>\n","      <td>B</td>\n","      <td>8664001</td>\n","      <td>5</td>\n","      <td>509</td>\n","      <td>B050901</td>\n","      <td>17674</td>\n","      <td>44</td>\n","      <td>20140222</td>\n","      <td>22</td>\n","      <td>1120</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   Unnamed: 0 제휴사    영수증번호  대분류코드  중분류코드  ...   고객번호  점포코드      구매일자  구매시간  구매금액\n","0           0   B  8664000     15   1504  ...  17218    44  20140222    20  2420\n","1           1   B  8664000     16   1601  ...  17218    44  20140222    20  1070\n","2           2   B  8664000     16   1602  ...  17218    44  20140222    20  8060\n","3           3   B  8664000     18   1803  ...  17218    44  20140222    20  6000\n","4           4   B  8664001      5    509  ...  17674    44  20140222    22  1120\n","\n","[5 rows x 11 columns]"]},"metadata":{},"execution_count":63}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"J6WuCXqXL3f7","executionInfo":{"status":"ok","timestamp":1632745053093,"user_tz":-540,"elapsed":5,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"a684a6ca-1966-4e52-dda7-b7bbb88a3a6b"},"source":["data = purprd[['고객번호','대분류코드','중분류코드','구매일자','구매시간','구매금액']]\n","data.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>대분류코드</th>\n","      <th>중분류코드</th>\n","      <th>구매일자</th>\n","      <th>구매시간</th>\n","      <th>구매금액</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>17218</td>\n","      <td>15</td>\n","      <td>1504</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>2420</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>17218</td>\n","      <td>16</td>\n","      <td>1601</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>1070</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>17218</td>\n","      <td>16</td>\n","      <td>1602</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>8060</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>17218</td>\n","      <td>18</td>\n","      <td>1803</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>6000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>17674</td>\n","      <td>5</td>\n","      <td>509</td>\n","      <td>20140222</td>\n","      <td>22</td>\n","      <td>1120</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["    고객번호  대분류코드  중분류코드      구매일자  구매시간  구매금액\n","0  17218     15   1504  20140222    20  2420\n","1  17218     16   1601  20140222    20  1070\n","2  17218     16   1602  20140222    20  8060\n","3  17218     18   1803  20140222    20  6000\n","4  17674      5    509  20140222    22  1120"]},"metadata":{},"execution_count":6}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"q3ZvaHEpTCJB","executionInfo":{"status":"ok","timestamp":1632745053539,"user_tz":-540,"elapsed":450,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"c97dd6a0-6857-4910-a885-3d7245e9e452"},"source":["data.info()"],"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["<class 'pandas.core.frame.DataFrame'>\n","RangeIndex: 28593030 entries, 0 to 28593029\n","Data columns (total 6 columns):\n"," #   Column  Dtype\n","---  ------  -----\n"," 0   고객번호    int64\n"," 1   대분류코드   int64\n"," 2   중분류코드   int64\n"," 3   구매일자    int64\n"," 4   구매시간    int64\n"," 5   구매금액    int64\n","dtypes: int64(6)\n","memory usage: 1.3 GB\n"]}]},{"cell_type":"code","metadata":{"id":"puEoXi3NTFcq"},"source":["cust_demo = pd.read_csv('/content/drive/MyDrive/LMEMBERS 프로젝트(1차)/dataset/cust_demo.csv')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"odgMYZECVdBb"},"source":["cust_demo.drop('Unnamed: 0',axis=1, inplace=True)"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"ImQ-7XzLVfQg","executionInfo":{"status":"ok","timestamp":1632745053946,"user_tz":-540,"elapsed":3,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"b9464afa-bef8-41d6-ee6b-11957aeb1720"},"source":["cust_demo.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>성별</th>\n","      <th>연령대</th>\n","      <th>거주지역</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>60.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>100.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>33.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>F</td>\n","      <td>60세이상</td>\n","      <td>16.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>100.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   고객번호 성별    연령대   거주지역\n","0     1  M  60세이상   60.0\n","1     2  M  60세이상  100.0\n","2     3  M  60세이상   33.0\n","3     4  F  60세이상   16.0\n","4     5  M  60세이상  100.0"]},"metadata":{},"execution_count":10}]},{"cell_type":"code","metadata":{"id":"wC8D5rFYVqeO"},"source":["data2 = pd.merge(data,cust_demo,on='고객번호',how='outer')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"1UM4iHmnV6iU","executionInfo":{"status":"ok","timestamp":1632745058150,"user_tz":-540,"elapsed":5,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"49bcafa3-f4e4-427d-8ce3-265e2ffc1172"},"source":["data2.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>대분류코드</th>\n","      <th>중분류코드</th>\n","      <th>구매일자</th>\n","      <th>구매시간</th>\n","      <th>구매금액</th>\n","      <th>성별</th>\n","      <th>연령대</th>\n","      <th>거주지역</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>17218</td>\n","      <td>15</td>\n","      <td>1504</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>2420</td>\n","      <td>F</td>\n","      <td>50세~54세</td>\n","      <td>100.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>17218</td>\n","      <td>16</td>\n","      <td>1601</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>1070</td>\n","      <td>F</td>\n","      <td>50세~54세</td>\n","      <td>100.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>17218</td>\n","      <td>16</td>\n","      <td>1602</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>8060</td>\n","      <td>F</td>\n","      <td>50세~54세</td>\n","      <td>100.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>17218</td>\n","      <td>18</td>\n","      <td>1803</td>\n","      <td>20140222</td>\n","      <td>20</td>\n","      <td>6000</td>\n","      <td>F</td>\n","      <td>50세~54세</td>\n","      <td>100.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>17218</td>\n","      <td>20</td>\n","      <td>2004</td>\n","      <td>20151023</td>\n","      <td>18</td>\n","      <td>2850</td>\n","      <td>F</td>\n","      <td>50세~54세</td>\n","      <td>100.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["    고객번호  대분류코드  중분류코드      구매일자  구매시간  구매금액 성별      연령대   거주지역\n","0  17218     15   1504  20140222    20  2420  F  50세~54세  100.0\n","1  17218     16   1601  20140222    20  1070  F  50세~54세  100.0\n","2  17218     16   1602  20140222    20  8060  F  50세~54세  100.0\n","3  17218     18   1803  20140222    20  6000  F  50세~54세  100.0\n","4  17218     20   2004  20151023    18  2850  F  50세~54세  100.0"]},"metadata":{},"execution_count":12}]},{"cell_type":"code","metadata":{"id":"3ISQn4ygWLwO"},"source":["data2 = data2[['고객번호','대분류코드','중분류코드','구매금액']]"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"bWNLwFoZWfvv","executionInfo":{"status":"ok","timestamp":1632745103483,"user_tz":-540,"elapsed":44874,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"5378258f-338d-4420-ef10-d09a11443536"},"source":["data2 = data2.astype({'대분류코드':'str','중분류코드':'str'})\n","data2.dtypes"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["고객번호      int64\n","대분류코드    object\n","중분류코드    object\n","구매금액      int64\n","dtype: object"]},"metadata":{},"execution_count":14}]},{"cell_type":"code","metadata":{"id":"Yfm7XiOXjla8"},"source":["aggregations={'구매금액':'sum','대분류코드':lambda x:x.mode(),'중분류코드':lambda x:x.mode()}\n","\n","data_eda = data2.groupby('고객번호').agg(aggregations).reset_index()\n","data_eda.to_csv('/content/drive/MyDrive/LMEMBERS 프로젝트(1차)/dataset_bmcat_mode',encoding='cp949')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"5izzjN4Ib3dE","executionInfo":{"status":"ok","timestamp":1632745118255,"user_tz":-540,"elapsed":20,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"7f6392f0-12a0-45b8-c2da-1b87d24af5aa"},"source":["data4 = pd.merge(data_eda,cust_demo,on='고객번호',how='outer')\n","data4.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>구매금액</th>\n","      <th>대분류코드</th>\n","      <th>중분류코드</th>\n","      <th>성별</th>\n","      <th>연령대</th>\n","      <th>거주지역</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>85042550</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>60.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>99880760</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>100.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>3165167</td>\n","      <td>12</td>\n","      <td>1201</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>33.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>16693810</td>\n","      <td>1</td>\n","      <td>106</td>\n","      <td>F</td>\n","      <td>60세이상</td>\n","      <td>16.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>13237070</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>100.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   고객번호      구매금액 대분류코드 중분류코드 성별    연령대   거주지역\n","0     1  85042550     1   104  M  60세이상   60.0\n","1     2  99880760     1   104  M  60세이상  100.0\n","2     3   3165167    12  1201  M  60세이상   33.0\n","3     4  16693810     1   106  F  60세이상   16.0\n","4     5  13237070     1   104  M  60세이상  100.0"]},"metadata":{},"execution_count":16}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"pFzXJDaZpqBW","executionInfo":{"status":"ok","timestamp":1632745118256,"user_tz":-540,"elapsed":19,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"4f940cda-e27d-452e-d169-ccfff1f573ec"},"source":["data4 = data4[['고객번호','성별','연령대','대분류코드','중분류코드','구매금액']]\n","data4.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>성별</th>\n","      <th>연령대</th>\n","      <th>대분류코드</th>\n","      <th>중분류코드</th>\n","      <th>구매금액</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>85042550</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>99880760</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>12</td>\n","      <td>1201</td>\n","      <td>3165167</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>F</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>106</td>\n","      <td>16693810</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>13237070</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   고객번호 성별    연령대 대분류코드 중분류코드      구매금액\n","0     1  M  60세이상     1   104  85042550\n","1     2  M  60세이상     1   104  99880760\n","2     3  M  60세이상    12  1201   3165167\n","3     4  F  60세이상     1   106  16693810\n","4     5  M  60세이상     1   104  13237070"]},"metadata":{},"execution_count":17}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"xyuW_X5iqImk","executionInfo":{"status":"ok","timestamp":1632745118256,"user_tz":-540,"elapsed":18,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"a0dce017-acc8-4bea-8acf-992aba3d84e2"},"source":["data5 = data4.rename(columns={'고객번호':'custid','성별':'sex','연령대':'age','대분류코드':'cat_b_mode','중분류코드':'cat_m_mode','구매금액':\n","                              'amount'})\n","data5.head()"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>custid</th>\n","      <th>sex</th>\n","      <th>age</th>\n","      <th>cat_b_mode</th>\n","      <th>cat_m_mode</th>\n","      <th>amount</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>85042550</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>99880760</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>12</td>\n","      <td>1201</td>\n","      <td>3165167</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>F</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>106</td>\n","      <td>16693810</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>M</td>\n","      <td>60세이상</td>\n","      <td>1</td>\n","      <td>104</td>\n","      <td>13237070</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   custid sex    age cat_b_mode cat_m_mode    amount\n","0       1   M  60세이상          1        104  85042550\n","1       2   M  60세이상          1        104  99880760\n","2       3   M  60세이상         12       1201   3165167\n","3       4   F  60세이상          1        106  16693810\n","4       5   M  60세이상          1        104  13237070"]},"metadata":{},"execution_count":18}]},{"cell_type":"code","metadata":{"id":"pDEM6mFgNhLa"},"source":["data5 = data5.astype({'cat_b_mode':'str','cat_m_mode':'str'})"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"-mnHtYJKPHla"},"source":["# 남성이 많이 사는 카테고리 순위(대분류,중분류)\n","man_procat_mode = data5[data5['sex']=='M']['cat_b_mode'].value_counts()"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"vAAxpumfaPjP","executionInfo":{"status":"ok","timestamp":1632748771204,"user_tz":-540,"elapsed":291,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"83f4fd4a-6464-4ac2-b749-08a2bcb74a80"},"source":["man_procat_mode"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["1              1298\n","10              347\n","14              306\n","15              268\n","3               267\n","               ... \n","['12' '14']       1\n","['15' '3']        1\n","['24' '9']        1\n","34                1\n","['14' '5']        1\n","Name: cat_b_mode, Length: 64, dtype: int64"]},"metadata":{},"execution_count":48}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":592},"id":"Lu1HtZRTPqr9","executionInfo":{"status":"ok","timestamp":1632750374783,"user_tz":-540,"elapsed":1355,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"38100699-bf18-49e2-9dce-05c4dd4db00a"},"source":["man_procat_mode.plot(kind='bar', figsize=(10,8))"],"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["<matplotlib.axes._subplots.AxesSubplot at 0x7f238bd75210>"]},"metadata":{},"execution_count":51},{"output_type":"display_data","data":{"image/png":"iVBORw0KGgoAAAANSUhEUgAAAlsAAAItCAYAAAAOvr+tAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3debwkVX3//9eHTVYHgUElAhONIAYDKm4YdjUqBpfIV8FoFBUVFMR9S6JGFHchanB03AUVt4BLZBs2BxRQYowGjQguiM4oYn4sivD5/XHqMjU9fW/Xvd2nb9+Z1/Px6Mftrjq36tTp6up3V9WpisxEkiRJdWww3xWQJElalxm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqaKN5rsC09luu+1yyZIl810NSZKkgS6//PJVmbm437iJDVtLlizhsssum+9qSJIkDRQR10w3zsOIkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVtNF8V2CQJa/6yhqvrz7h4HmqiSRJ0uy5Z0uSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKBoatiNg1IlZExKeb14sj4lMR8c2IuCwiXtgM3zgilkbEhRFxQUTs3gy/c0Sc1gw/MyLuUXeRJEmSJkeXPVsPAU5qvd4eeEtmPgTYB3hdRATwdOBPmbkPcAywtCn/MuDSZvj7gLePqvKSJEmTbmDYysyPA9e1Xv93Zn6vebkt8PPMTOAg4LNNmSuAbSNii/Zw4Azg4aOrviRJ0mSb8zlbTZD6OPCcZtBiYFWryKpm2B3DM/P28q/Rd74RcWRzaPKylStXzrVqkiRJE2NOYSsitgI+B7yh2YsFcCOwqFVsEXB9n+HZhK61ZObSzNwrM/davHjxXKomSZI0UWYdtiJiEfAl4K2ZeX5r1DnAIU2ZXSnnb93QM/yRwBVIkiStJzaaw/+8FrgP8PpyXjwATwOWAcsi4kIggOc2404APhoRhwG3As8bqsaSJEkLSKewlZnnAec1z18BvGKaoof3+d9VwOPmVj1JkqSFzYuaSpIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUNDFsRsWtErIiIT7eGHd8Muzgi9m+GbRwRSyPiwoi4ICJ2b4bfOSJOa4afGRH3qLY0kiRJE6bLnq2HACdNvYiIA4E9M3Nv4O+AkyNiI+DpwJ8ycx/gGGBp8y8vAy5thr8PePsI6y9JkjTRBoatzPw4cF1r0EHAac24a4FrgF2b4Z9thl8BbBsRW7SHA2cADx9V5SVJkibdXM7ZWgysar1e1QwbODwzbwciIjxXTJIkrRfmEnpuBBa1Xi8Crp/F8GxC11oi4siIuCwiLlu5cuUcqiZJkjRZ5hK2zgEOAYiI7SiHEK/sGb4r5fytG3qGPxK4YroJZ+bSzNwrM/davHjxHKomSZI0WTaaw/98BXhURKyghLVjM/OWiFgGLIuIC4EAntuUPwH4aEQcBtwKPG8E9ZYkSVoQOoWtzDwPOK95npTehr1lbgYO7zN8FfC4YSopSZK0UHmiuiRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKmiOYWtiNgsIk6JiG9ExKUR8cZm+PERsSIiLo6I/ZthG0fE0oi4MCIuiIjdR1h/SZKkibbRHP/vmcD1mXl4RGwIrIiIG4A9M3PviNgBOLcJVk8H/pSZ+0TEnsBSYO9RVF6SJGnSzfUw4nXA1k3Q2pwS2h4AnAaQmdcC1wC7AgcBn22GXwFsGxFbDFlvSZKkBWFOYSszvwjcAlwF/C/wMeBGYFWr2CpgcfPoN1ySJGmdN9dztp5HCVf3BHYGDgAeBCxqFVsEXN+U6ze833SPjIjLIuKylStXzqVqkiRJE2WuhxF3BX6ambdl5i2Uw4ofBg4BiIjtmjJXAue0hu9KOX/rhn4TzcylmblXZu61eLE7vyRJ0sI31xPk3w58JCKe2EzjauCjwL0jYgUlxB2bmbdExDJgWURcCATw3KFrLUmStEDMKWxl5i+BR/cZdUyfsjcDh89lPpIkSQudFzWVJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVTRU2IqInSPinIhYEREXRcSmEXF88/riiNi/KbdxRCyNiAsj4oKI2H0ktZckSZpwG831HyNiQ+AzwLMy8wfN6/2APTNz74jYATi3CVZPB/6UmftExJ7AUmDvEdRfkiRpos05bAGPAa4Ejo+IuwKnAncHTgPIzGsj4hpgV+Ag4IPN8CsiYtuI2CIzbxyq9pIkSRNumLB1H2A3SpC6HbgAuAG4uFVmFbC4eazqM3yNsBURRwJHAuy0005DVE2SJGkyDHPO1m3A6Zn5f80eqrOBPwcWtcosAq6nhKp+w9eQmUszc6/M3Gvx4sVDVE2SJGkyDBO2LgL2j4gNI2Ij4OHAMuAQgIjYjnII8UrgnNbwXSnnb90wTMUlSZIWgjkfRszMSyPiLOAy4A/Ap4ETgRMjYgUlyB2bmbdExDJgWURcCATw3OGrLkmSNPmGOWeLzHwr8Naewcf0KXczcPgw85IkSVqIvKipJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFVk2JIkSarIsCVJklSRYUuSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqaKhwlYUZ0XER5vXx0fEioi4OCL2b4ZtHBFLI+LCiLggInYfvtqSJEkLw0ZD/v9RwPeAu0TEgcCembl3ROwAnNsEq6cDf8rMfSJiT2ApsPeQ85UkSVoQ5rxnKyKWAI8FTmoGHQScBpCZ1wLXALs2wz/bDL8C2DYitphzjSVJkhaQOYWtiAhKyDoGyGbwYmBVq9iqZth0w/tN98iIuCwiLlu5cuVcqiZJkjRR5rpn6/nA1zPzx61hNwKLWq8XAdfPMHwtmbk0M/fKzL0WL+6bxyRJkhaUuYatBwH7RsSngZOB/SgB6hCAiNiOcgjxSuCc1vBdKedv3TBkvSVJkhaEOZ0gn5lHTD1veh0+E/gX4MSIWEEJccdm5i0RsQxYFhEXAgE8d9hKS5IkLRTD9kYkM88DzmteHtNn/M3A4cPOR5IkaSHyoqaSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqmjoG1FPgiWv+soar68+4eB5qokkSdKa3LMlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIrWiRtRD9J7o2rwZtWSJGk83LMlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkXrxb0Ru+i9f6L3TpQkSaNg2JoFA5kkSZotDyNKkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkioybEmSJFU057AVEVtExPsj4lsRcWlEvLkZfnxErIiIiyNi/2bYxhGxNCIujIgLImL3EdVfkiRpom00xP9uDZySmUdFxAbADyLie8Cembl3ROwAnNsEq6cDf8rMfSJiT2ApsPfQtZckSZpwcw5bmfkL4BfNyy2APwIPBE5rxl8bEdcAuwIHAR9shl8REdtGxBaZeeMwlZckSZp0Q5+zFREbAh8HXg5sBaxqjV4FLG4e/Yb3TuvIiLgsIi5buXLlsFWTJEmad0OFrYjYGPgk8OnM/A/gRmBRq8gi4PoZhq8hM5dm5l6ZudfixWtlMUmSpAVnmBPkNwE+DZyemZ9pBp8DHNKM345yCPHKnuG7Us7fumGIekuSJC0Iw5wg/xxgf2DbiHheM+ylwK8iYgUlyB2bmbdExDJgWURcCATw3CHmK0mStGAMc4L8+4H39xl1eZ+yNwOHz3VekiRJC9Uwe7bUY8mrvrLWsKtPOHgeaiJJkiaFV5CXJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkiuyNOGb2WJQkaf3ini1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkiryC/ATqvcq8V5iXJGnhcs+WJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVWTYkiRJqshLPyxQXh5CkqSFwT1bkiRJFRm2JEmSKjJsSZIkVWTYkiRJqsiwJUmSVJFhS5IkqSLDliRJUkWGLUmSpIoMW5IkSRUZtiRJkirydj3rqN7b+YC39JEkaT64Z0uSJKkiw5YkSVJFhi1JkqSKDFuSJEkVGbYkSZIqMmxJkiRVZNiSJEmqyLAlSZJUkRc1XY/1XvjUi55KkjR67tmSJEmqyLAlSZJUkWFLkiSpIsOWJElSRYYtSZKkiuyNqBnZY1GSpOG4Z0uSJKkiw5YkSVJFHkbU0AYdauwd36WMhyslSesKw5YWjFGEOkmSxs2wpfVKlz1ooyojSRJ4zpYkSVJVY9uzFREvBJ4GBPDuzPzMuOYtjduozlPz0KkkLXxjCVsRcS/gCOChwJ2Ab0XEmZl5/TjmL63PPOQpSfNrXHu2DgROz8w/An+MiAuAvYG1f5ZLGrtx7WWbr/nUqoskdRGZWX8mEa8Bfp+Z721eHw/8KDM/2lPuSODI5uWuwJWt0dsBqwbMalCZUUzDukz+fCapLi7z+lGX9XGZJ6kuLvP6UZdJX+adM3Nx39KZWf0BHAu8tvX6vcDjZzmNy4YtM4ppWJfJn88k1cVlXj/qsj4u8yTVxWVeP+qy0Ja5/RhXb8RzgMdGxIYRsRmwP/DNMc1bkiRp3ozlnK3M/F5EfBlYASTwrsy8bhzzliRJmk9ju/RDZr4FeMsQk1g6gjKjmIZ1mfz5TFJdXOb1oy7r4zJPUl1c5vWjLgttme8wlhPkJUmS1ldeQV6SJKkiw5YkSVJFhq0OImKbiLhT83yviHhka9zmrecHRMSLI+KBI5jn64adxjTT3WdqWaYZv0nr+e4R8bSI+Ks5zmv79vSaYfefy7Rqi4g9ImKn5vkjIuLo9ns7aSJiu4h4fEQ8KSLuN9/1kSRNz7A1QEQcB1wCfDsing28CzgmIt7aFPlyU+4I4M2UTgfviohnzWIeH+55fAQ4IiI+PNKFKT4NXBgRr4yILfuMPzuKo4GPAvcD3hcRx8xQ/x0iYpeeYccDFwCXRsSjWqPe2bWiEbFj17LDiIjXAx8APt/cw/Mo4C+BZT3lBobHiLhLc3kTIuI+EXFwRGzQU2aDiNgtIvaNiPv1BNyByxwRTwPOBv4WeAfwpog4NyK2m6b8thHx8Ijof7G96efTpS6dwvlMy1xTRDxvmPGzmE/fH0cRce+IeEJE/Nko5jNbEbHJgMfGHaczls9iLf22UQPKj6TdRmmmH/0V5zmrdpvltOdlm9DFqLYLbWPrjVhD8yW2K7AYuB64MsstgWb6n+dl5gf6DL835Qv20sz8RWvUocBuwPbAfwE7ArcAF/VM4hnAwZn524h4H+XL8CMdF+UezbRPmqoO8G+UsDNQRNw9M3/ZZ/i2wH2AH2bmymbwD4FHNfVdHhH/AbwnM3/TjN8gMzMiDgP2zcybImIjSnA6qZnuYZQv+V8DrwHeDvwhIj6Zme9upvMISrttCXwsIu6cmZ9rlq2rKyLiB8C/Ap/Njr05ImIHYMvM/GFr2I6Z+bNp/uUxlPt2bklpn50z848RcUnr/48H/q5Zzpdn5pnNqHdSbkdFRDwfeCVwY0T8I/AS4IZm+i9syuwHnAxcDfwGWATsEhHHZObXOy7zS4GHZebNEXFX4K3A64EPAU9o5nN68/xJlF7AlwP3i4jXZ+ZpEXHtTE0IXAPcu0Ndzm6W6SjgWZT1/vkRcVpmTq0vg5Z5qo03onwGNwSuyszfzVDHtSsd8U99luPvIuKumfnGQeN7pnUX4Jamje8D3Av4Wmbe3udHUAD7RcQ9M/OIiDg9Mw+JiL+lfDbOBl4fEa/JzK820+/S/rcPWORdKOvrdK4FDgZ+2Uyz9/0Lyu3TtupQlxnXhY7Lc9UMZQBWUra3M01nW6a/qncA12TmQwdtoyJixYC6PKSp87DtNug9vDYznzygzNSP/hcAt0bEu4B/AG6IiEdk5isj4pQBk+jSttcAJzJcu3Vdnhm3CSNcnoHtD3y3z/+2txsD1+3MfOiA+Uxm2JqpoTPz8KbMwA14h43vwI1iM8/bgF9GxAcz8+Zm2jf1qdtvm783R8StXZc3Mx8VEUdRrqz/osy8OiKuz8wLetrlaOB1wM+A52Tm1EryKVZ/4c/4JVtml7cCy6LsQXsq8NWIWJGZxwG3RMSuwK9as74d2LT1+kWUkLsjJYTtAtwInAdMhS2aDfL/RcSTgU9GxIa0NlwR8eYZ2uQ1lA/Bk4EXAy+NiA8AH8vMP/W0S5fwN1OIubUJmDcCf2gF9vZ72CU8HgHcl7IuXgH8RdMu7Qv4vhk4sB2Oo+yROh34esdlvnlqPaRsdO6Zmd+JNfdcbd0Eg2MowWxVRGwBnAWcRvlhcgDTiIjlHesyMJx3WGYi4iDKe3Mt8ADg+xFxDWU9v7nLNqGp61nAv7P6fTmIso3oMn6qboNC86AfR1N7jI8FHpmZP2vC2xnA1HalS/tvSvl89i1CeX8Om2H8J4CzM/NvZ5jPGZQfJsOuC12WZ7fm/6er71s6TOf6zNxhwHxg8DYqmLltL8/Me84wn67tNug9/ESH7SAM/tE/irZdzvDt9olmWoOWadA2YVTLM7D9Gbxd6DKfwWZzuflxPYBvAP8P2K/30VPm7j3/tx2wovX6u5Q9D/u2pnEB8Ixm/LnN37OBHZvndwEuak3jM8B9+szn883z64HlwK9a4xdNTbs17M3TPVplljRv+AuAU/u0y7coK889KFfl/+tm+PJWmQum/gLbNc+3mGqXdtmeaT+x+bsTcDHli+MSSng5E3hFu+1bzz/een526/n7gL1brzcCPgesbA37PuXL6x96H+33p3l+56Yu3waO7an7CsoX3G6U8HEXYJOedWE55VfxvzTt+Gxgo2bcpyhf9J+g7B16D+UL9mut//9m6/mGwCnAU3rqeH7r+ZWt5+f1a7vedb7rMgNvBL4EHEPZOL2xz/vyDeBulC/4DVvDL51aJwZ8BrfoWJezKRvnzwObN8M2AL7ddZmb55ezen3dpXk/Hju1ftFtm3Anyl6+DwOLmmGndh3f8znbrGm/65p1K4Bvtcoc1bTtkj7zmdquXNAz3fbntEv732tAmQMGjJ/x/2dZl37rwnem1oWO03j4gDIP7zCdxV2WhQHbqA5tO7DtRvQe3osB28GmXHtb9pbW87Om2m4EbbvFqNpt0DIxeDs4quXp0v6DthsD5zNoXcnMiQ1buwBPH1CmywZ8UCN22SguArbvU797zlC3nYDde4YN/EC1yj4fWNZn+CU9K9JXKUGyvSEc9CV7TIf234By+OGllF8Xe/WM/zLwZz3DtgTOaL3eHNihp8zGwAtar/cCnjdDPZb3GbY5cNwM7/l04W/a4EAJsM8HntCMP5IS0u/W+p8u4fGMps3eDPxH8/xJrBnCjm/KPYMSJg4DTqUcyp3NMj8SeBnl0DWUMNCu7/0pe9ROBL4IHE75HLwb2AY4Gjh0wHrQry5btOsC7Mza4fws1gznb+qzzJ8GTmyVubBnPuc3f6d+JAzcJrT+9yFNHR4DnDKH8QNDc/N6CX1+HFEO230E+Glr2KZTy9il/YGtKJ/BB81lfFPmrpS9vC+focww68LmwHEdl2dTyiHiacPSoOl0rWtTdtptVIe2HUm7dXmPmnIzbgebMtP+6B9F246i3WazTPTfDn6asr0ayfLMpr5N+bW2C7NZ5wY9JvIwYpZzbWY6FwHK+UZnUA6JrKKEokOAS1vT+QPwyoh4CPC55lh3tqaxW3P+xc5TAyJiU1qHVzPzhmnqN1P9f9pn8DOAB2bmxwYsF5l5MuUQaa//jYj7Zub3M/PGiPh/lD0c926VeSHlC+ASyjKfRjkEdlEz7ZN6J9pn/rcDX2ke/byAsueo7Tjgn1vTuAlY41BrlsOX/9Z6fVlE/DQiNsnWuXYRcf/M/A5wcURsA9yYmX+IiL2Au+TqQ4NTro+IP8vMX2TmM5ppbAnc3Cpzx+G+zPw98OaIOBE4MjNvodXemdnvysCvonx4iYgDgD0oQf6cVplnAScAP6J8yM+gfID/ujXt1zaH3B5ACX03Ap+kHD6DEgCn2mH3Zj7/1bvMmXkWZcMw9Tope2GmXn8nIg6h7CLfAHgwJZz/uGmLzVnz0HA/F0fE9sDvpt6fZr07r1VmJeVX5mMoG8hbgVdl5uWturwuIg6lrB+bAv9J+THx1dZ0vt+8H+cAf0M5VAKrP68/n/rctdr/wvZ8mnHbU/a4HAy8Abjz1PoUEftQ9k59MyLuGN9nuX8fES+l7An9SfP8J027ERGbZ+ZNWQ73n0g532/71v9Pnb/x+tawlwGvnaompf036zPvKVtQvoSuo7VNm8V4KOv/t1jzlIBendeFPsNekplvinJu6KBpLAbe1tT32XOsS9e6Qmsb1foc/ZTyngxqu9m02zDvIXDHdvCqiLhTz3burFaxl9Cc1tBa/78BvJzRtO2UFwA7RMSqVl0eRrd2a/tuZl7W1Le9Hftus8yvbbYJD6Z8Bv+C8oPzjCidMbouz9Dt39RxG8qpHwcDX2P1Z3g269zMhk1r8/kADqD8av4ApZfgwTOU3YRynPfLrWE7Tz1aw+5N69DEJD0ov2Tu2zNsEfDWPsOOphyKeQ/lCzdGWI8P9zw+Qjn59cOznM6bgP+hfPk+qjV8ao/jcZTQ/d+UD90FlABzQs90dqRnTyPwV5RwO/X6zbOpW5+6TtXpCMoXz8uA84Fntcq8eJr6vnUWy3wB5QN+NHAZJbxdSDmXb2RtO83/7NPz+vhB05ihXZ7ZKnM4ZUP2oWY9OR04l+awYVNmQ+C5lPMWj6bsld4QuP8s2r9d30f2qeMvKF+ir6ScbzPT5+yE5v3ckLKn8vPAbn3qsqK3Lozo81HjQTmXby7/95EaywRsO4Jl2qfPsOk+R1d6pH8AABbbSURBVAP37PeZVgB/xoBtKOVHzVZzmP5027n2dmPg52wUbdelLh2nO2P7M/228oQZpjn0ujLX9h/JfGpU3se6/aCcw/VOVofVJZRfA/vOcjrfbD6QWwFfAJ7cDF/e/F3RfNndnbL3crOmfN9DyJWXeWpjdx6wTfN8M9Y8hLmi2eBOW1+ac79mWOaLpv6y+hyojWidszGitt2357Ef5fyrfbtOYxbt8m1gs+b5XSmHHO8PfGnE7T9omZdTDmU/m/JL91+YwwZ8UF3o8PmgnHf575Q9g7+l7Ik+smc+d6YcVvkO5fzTzwN/0xr//GZ9uwflkPaPmjI7tspMnc/3l83471G+/HZplTmq+Tt1UvS1lEDcPiw94zJ1mcY0bXlKz+sZp0OH9bbL54iyB/W4qXF96rW0adt9KXuDLwH+lzXPEXw45UfE1yg/0q8Afk7p1DFVZjfg/c282qd1tA+hD9zOMXid25gSYL7YtNc7WfuHeZfP/IzbMOBJzd+tgY83y3wSPT9eOrT/wG1lh3VlD0oo+lfKOvldyh7og7p+hrq0P3Nct3sfE3kYsYuOPRZnLNOxh9NIjGJeo1jmLvMZJDv2nuw4rWSGHovZoSfouNslZ+h1muUQbJeeq9Mtc5feoF3rOVPbfplyHsjPWH2I9R7AMykblC7T6J3fdO0ysPfkbN6fAe0/U30zZ+6JO5K6dPx8nELpWfwEyp6/uwH3jIhXZ+ZbmjKnUt6jt1POadkAeHqUS718FHhqZp4cEScBnwX+nrK3/wOUwyew+hD2G4DnZuZ5EfEAyhfko5txT6YEgjcBJ2fmKRHxuGbYkzou08BpRMQfKXtlbmP1OrdHRFyVq3v+DZpOp/WWwZ+jTSmHC8+P0oP7pFzzlJFds/TmfQNlr+6Po1xm5fOtNn1b0+aLKT3o/obSI/pcyl5cgA82dd8BOD0iDs1yisUaFyLusp1rle23/n+EsnfmnZT1+ibg3RHxnsz8WlOm62d+pm3YCyk/ZI6n7Al6CaWj0Hub6UwZuB2baT4d15UTgX+inM95NqXH5irKuV9Tp3cM+gxN1WWm9h+4bncym2Q2SQ+691ictkyXaYyzvuNY5hEv0xJm6D3Z4f9nPOmcAT1Bx9kudOh12qW+HZZ5YG/QEbXtfSgn8R/RKnPqbKYxi3bp2ntyps9ql/kMWubl07TVE2ezPnWpy6DPB2t3CJjac9Hu9XpRT5mzKL/Ap/aOXt78Pa+n3AV9pvuNnjLL+5RZMV2ZQcvUZRqUcxrPpDkcO806N+N06LDedvkcteazIaWj0qWUczC3b4Z/i7KH9Os907249fy81vP/7F2GPu/FfpS9YFv2tEuX7caM61yf9voa5Vyjdn27fOYH9b6/Y360Dqv2WQcHtf+g+XRZV9odWa5oPT+n62dotss86PMx06NzwUl70K3H4oxlukxjnPUdxzJXWra+vSc7/N+MPRbp2BN0vtqFnl6nXeo7aJmb1zP2Bh1F27bm8zJKILk7a++mHziNLu3SDBvUe3LW70+f9h+0PnU6X2cUdekZt9bng7KX4QmUwxxPoTmkyppfzuew+py1BwP/0Tyf6qn5UsoeqpcBhzXD9qUV5IAfUDrn/GfP/Ns9m7/T/N+3espcPMPyrrFMXadB2cPzOcqJ3dFnnRs4nUHrbZfPEWsH42jeh4tb6+tyyqHm9wJ7U/aifKr1PxdROro8mnKI8UFNfS7tKbNZ6/VfU77w22Vm3eO9d51r5rND83wJq8Pp+X3aZKbP/Ix1oYSsnVj7x8KFfeo3U/t32VYOWlcuBDZtnk9d8iOAM7t+hjou86w/H33fr9kU9uHDx7r3aDYsX6HnEig+qrb5DpTru32PcghwR8ov7vb5PvdtvkSnTuy/X1PmH1tlntF8AV5POYR1BrBTa/w/sPY1m+4HvLD1+p+bxz+1hu0BHD+L5ZnVNJp6f5XWtexmO51h1ls67JWg9JB7e9OmX2pCwyat8Q+h7LX5YvP+Tb1Xj2+VOQh4bM90D6S1h2pE69M+lMOI36Z0XNi/WVfeP035ObUd5XDlR1gzaO8BfLTiZ2W6deUA1r4s0UOBp7VeD/wMjXrdnu4RzT9KWo9FxNSeprVu+yTVEBF3Ax6cmacPMY05rbdR7gDx+7nOd1I1V2H/TXb4Yl9In/lRrCvzzbAlrWeaE31fTvl1/fb5rs/6pkv7N9f9OQz4dZbbbM1qfGs+L2vKzGk+HZdn6Gl0mc641tuIuAflkjm/ysyjpykz9Hs4TuvaZ36hrdswofdGlFTVzZTLJMx00UbV06X9R3GBz1Fe1HQmnaYREbtMNy7LBWsHTWdk621EPGqG0RdSTpafaT6jeA9HpkPbjqTtOsxnJDouz8Ss250m5J4tSVJtTVf6S2jdzaGRmXngmOtyPaVXZe8XYGbmEeOsyyiMq23XtfmMk2FLklRdRBwL/CwzvzABdTmc0ktw2XzXZRTG1bbr2nzGybAlSaquucDszpl51XzXBSAiFmWfe98uRONq23VtPuNk2JLWMxGxFeW6Mb/OzEE3lNWIdWn/iNgUuFdTZuVsx49qPh2XZ+hpdJnOuNbbjp0PxtK2o7KufeYX2roN5aJjktYvW1Bu5/LoQQVVRZf2X0y5HcwJcxw/qvl0MXAaEbFNRBwdEYcOMZ2RrLcRcdeIeEdEvHy6Igw+KXpcbTtQx7Yduu06zmdoI1yesazbXblnS5ImQETcJzP/Z77rUUNEbAscAVyXmZ+Y57rcmXIfw1/lHO7nOmnG1bbrynwiYtvM/M24p2HYkqQxi4id+gz+V8qV3X/WlLkb8ErgOsp1nz5Eub/dMZl5cUQsA76cmV8csi4bUe5F9wjKL/nrKZc/ODkzbxlm2nOoy6Bl3pFyvahrmnGnAFtT2u07I6zHUZn5/mZ+n6JcTf4y4MjMvK4pc2fK7Xz2pVyV/EfA0sz8ems6dwae09T39GaZtgZek5nXjKq+XUTEbsCLmnqelOXmy0TEiZl57DjrMgoR8aTM/EJEbE25bdVfUW6o/ZrM/P9m+L9TsueG8nOY96ynYdiS1kPjul6O+ouIP1C+fP+P1d3bHwH8aKpre0R8lXKbkm0ptyY5GfgJ8J7MfFhEXE65z95+wPsp9+27vWc+A9/niPgQ8HvKbYNWUe4V90RgSWb+fcfl2WSG+fyxyzSa6Qxa5jOBT1LCz2OBN1CC2dsy84Cu8+lQj3Mz88CI+BjlZtSnRMTjKDdxflJT5iuUmxifSznHawPK7WDOzsyPNmW+SLm33j2B7Sk3iP4l5bZMYz2MHxEXUdaTHShte2hm3jS1rOOsyyi03qP3AT8FllHub/mgzHxmU+aPlBti38bqz9kewO8y854d5zP0NADvjejDx/r4AG6ifEks73mcO991Wx8elC+75cBBrWGn9pRp3yz3e63n5zV/lzd/t6bcu+0y4AWsef++ge8zPTcrHjR8mrK3Uu7J95Pm7x3PZ9kug5Z56m8AP2iNP2fE78+5zd8VPcOXt55f1DPuLMoerm/2qfeGwE96pz/mda59k/P9KMFvSzrcJ3ISH+33iGbHUbvNm+fPAs4EdmsNO3WW8xl6GpnpFeSl9dSrWceuY7OQZObyiPgWcEJEPBF4BWtfYHOziNicEqa2b+579ztgq6nJNNP6HfCGiHgncBTlSuH3b8p0eZ8zIh6YmZdPDYiI+zC7O4y8jbJHZ3m/kbPo1TVome8UERtk5u3NnqYpt/dOaDode+bdJSL2Ze02aJ80/4eIuH9mficiHgzclpm3RUT70OtmAM3w9l7C27rWd5BZtO0GEbFZZt6cmedHxG2Um2hvOeL5DGUW89m0ORx/WzYJqLHh1JPM/EhEfB04KSK+CbyDtT9nMxrFNMDb9Ujrq/cCO893JdZnmXkj8KKI2I9yNfPe3uH/BlxJOcT395Q9J7dTDj9Cz9W1s5yn8raIOKk1uMv7/Hzg5Ob8pN9Qgs5vKcGtqzcB951h/FSvruuAZ89QbtAyvwd4KGWP048BImJvyl6arqZ6sl0HTBe2vkTZ+/jlqQERsQdlL+GUFwFLI+LPgV8Az26uD3V2q8ynImLfzLwgM7/RTOehwLdnUd9BurbtP1OW6asAmXlRRLwFOHXE8xlW1/lcSTmMfMdpD8179ON2ocy8FnhyRDwD+AprX5V+oFFMw3O2JGmeNXtzdmvvXWqGbwn8MTP/2OzluXtm/lczbpfsOb9umB6NEbExsB1wY2b+fk4LMgIzLfO6YGrP3HzXY1RG0btvXJoOGA/OzNMHFh7xNLzOlrSeGdf1ctRfv/bPzJv6BK2dgG2AuzXPNwfe1OyBArglInZqPXYG3jo1frbvc2bempm/rBW0ImKjiHhuRHwmIs6NiM9HxIubw0ZTZXYE3gy8MCIWAR+j7HXbc5TrbURMneS+dUR8PCKuiIiTImLL2p+PGkErIu4WEe+OiFdGxJ0i4hMRcWlEPKwZX3OZ/nXUE4yI7SPiFc0h9vbwV89yOrtFxPsj4riI2DAzr8vM0yPixLnWbWoas/0/DyNK65+R3clec9K1/X/E2j0WH0AJIAd2GN9pPjGCnqkdp3Ey5fDgu1mz1+OHKIcMofQom+pteA6rexu+G3gyo1tvXwh8ATge+G/gJZSebO8FXtplPhHxqOnGZeaZTZlx9fr9MKt7cX6d0tbvpRx2fRgj+sxP1zMvIq7K2fTMG+xUyvt/UEQcAjy7CamPBN7S1KVL236Q1T0wT4+IQzPzJkqv0U5G9R56GFFaD0XE1s2J1XMar+F0aX/KSe7/BLwpM89php+amYc1zw+Yafws5nMtcAlrn4eS2fGSABFx06BpRMT5mblfn/+9Y3hEnJeZ+0dEAN/PzN2a4edk5kGjWm9j9WUDVgAPnzrBujX/Lu32E8q5dr1fopmZRzTlBrbLKPS04fcyc/fm+XmZuf9UnYdtu4h4FuUyF8dm5g+aYWusc6PQszyHAY8HnkbphHFAM7zLOndBZu7bPN8PeBVwKHBGdrxUyKjeQ/dsSeunL0XEI5n+RM8vUk6mVR0D2z8zD4gZeix27NHY5X0eRc/UUfV6HNTbcFTr7aCebF3mczSwWWYum2E+4+r1O6gXJ4yg7UbVM6+DTZvDfrdl5qkRcSvlmmYbt8p0aduhemDOYj4DuWdLWg9FxNVM310+gJ9n5j7jq9H6Zbbt3/wqfx2wQWYe1Gd6fcd3mQ+wP7BzZl416wVZPZ8NB02jCVYnA2v1eszMbzdlnkL5YlvR+r+9gYdm5rtGtd5GxEeap7dn5rObYXsAx2XmM7vOJyIWZeYNM8xnYLuMQrPH6Y2Uw7THAW+l6cWZmW9oylzNCD/zUXrmPZWSIx4z99r3nfZTgD9k5pdaw54GfCwzN2ped1nnDgLulJlfbQ07kHKdrLt2rMtI3kPDliQtADFNj8Wu4ydFTEivx3VNzEMvzhhB775Zzm/LnOFWPJPMsCVJEyYitqGcG/PrzDxttuNHNZ9xTWOU0xmHiLgr5R6Nv8rMt09TZsEsz0LTpW0nad0Gz9mSpEk0qPfYqHqUjmI6o+r1OLZesiPoYXYz5Ur9v5ppNiyc5Vlo8+nStmNbtztNyD1bkrTwjLBn3ih6qY2k1+O4esmOsZfgurY8EzOfjusc41i3O33ODFuStPBExHmU6w5N17vs6126t49iOl2mQbkFzoy9uka1TINExLGD6jIK6+DyTMx8Oq5zMajMKNbtTp8zw5YkLTwj7Jk39HRG1etxXL1kx9hL8GrWreWZmPl0XOd2HFRmFOt2p8+ZYUuSJkuUW9jci3Ji7sr5ro/WFBFbAftS3p/pbmYt3cF7I0rS5FkMvA04Yb4rMgoxQffjHFFdtgAeCzx6RNWas3G17bo2n3GzN6IkTZjM/BlwcO/wiNg2M38zD1Ua1iTdj3PoumTmdZQryE+CcbXtujafsfIwoiQtEBFxSmYePt/1mItx9cwbV10i4vnAUspNjt8D7AF8F3hxE5bHZoy9Htep+YyThxElaQJFxB8j4vyIODcilkfEcuDREVH15OSKvhQRG0fEJv0elHvWLaS6PDUzbwdOAj4H3A/4EPCBivWezrjadl2bz9h4GFGSJtPzKFevPjYzfwAQEadm5mHzW605WwJcOc24qd5j47KE4esydZPnbTLz083zr0XEq4es21wsYTxtu67NZ2w8jChJEyoidqDsOfkm8A7gUwv1MOK6JiJeCuwM/BT4RWaeGhH7AseP4nIOWrcYtiRpwkXEM4CnUrbZj5nv+qho3pfnA7sBt1JC8dGZ+dN5rZgmjmFLkhaAiLgb8KDMPGO+6yJpdjxnS5ImUETsCLwcuIZy4vUyYOuI+HlmfmdeKydpVtyzJUkTKCLOBD4J/AXlAppvAK4D3jaK++lpOBHxqOnGZeaZ46yLJp97tiRpMm2SmR+PiAAOnTp8GBHT3adN4/UZ4N+B3j0WCRi2tAbDliRNpjtFxAaZeXtEPK413LA1GY4GNsvMZfNdEU0+DyNK0gSKiKcAP8vMFa1hewMPzcx3zV/NNCUiFmXmDfNdD00+w5YkSVJF3q5HkiZMRGwTEUdHxKHzXRetLSLuGhHviIiXz3ddtDB4zpYkTZ4ANgc2ne+KqK+bKRcw/dV8V0QLg4cRJUmSKvIwoiRJUkWGLUmSpIoMW5I0YSJi04j4y4hYPN910doiYquIODgiHjTfddHCYNiSpMmzGHgbcMJ8V0R9bUG5hdKj57siWhg8QV6SJKki92xJ0gSKiMdHxAYRsai5ptNZEfHOiFg033WTNDvu2ZKkCRQR52fmfhHxMeAHwJeA/YGDMtOLnc6ziNhlunGZ+cNx1kWTz4uaStJk2rz5++eZ+Q/N8/+JiMPmq0JawxXAJZQL0LYlcOD4q6NJZtiSpMm0PCJeBpwfEX+dmRdFxL1ZHcI0v15NuVH4F+a7Ipp8HkaUpAkUEQH8I/AE4L7AT4HfA8/JzCvms26CiNgQ2Dkzr5rvumjyGbYkacJFxLbAbZn5u/mui6TZM2xJkjQLEbENcBjw68w8bb7ro8nnOVuSNIHs7TbRgnLu3KbzXREtDO7ZkqQJFBE3MU1vt8y0t9s8i4itZzqsO2i81i+GLUmaQBFxLPZ2m1gRcR7wSNYOw1O+npkHjK9GmmSGLUmaQPZ2m2wRcTVw+3SjgZ9n5j7jq5EmmWFLkiSpIu+NKEkTJiK2iYijI8Lb8kjrAMOWJE0ee7tJ6xAPI0qSJFXkni1JkqSKDFuSJEkVGbYkacJExKYR8ZcRsXi+6yJpeIYtSZo8i4G3ASfMd0UkDc8T5CVJkiryRtSSNIEiYiPgWcAjKHu6rgcuBE7OzFvms26SZsc9W5I0gSLiQ8Dvgc8Cq4BFwBOBJZn59/NZN0mz454tSZpM987M/XqGXR4R589LbSTNmSfIS9Jkyoh4YHtARNwHfyRLC46HESVpAjXB6mRgR+A3wNbAb4GjMvPb81k3SbNj2JKkCRYRGwPbATdm5u/nuz6SZs+wJUmSVJHH/iVpAkXELtONy8wfjrMukobjni1JmkARcRNwCRA9ozIzD5yHKkmaI8OWJE2giDgW+FlmfmG+6yJpOIYtSZpAEbEhsHNmXjXfdZE0HMOWJElSRV7UVJImTERsExFHR8Sh810XScMzbEnS5Algc2DT+a6IpOF5GFGSJlBEbJ2Zv5vreEmTwz1bkjSZvhQRG0fEJv0ewBfnu4KSuvGippI0mZYAV04zLoCfj68qkobhYURJkqSKPIwoSZJUkWFLkiSpIsOWJElSRYYtSZKkigxbkiRJFRm2JEmSKjJsSZIkVfT/A23HDIspm/EgAAAAAElFTkSuQmCC\n","text/plain":["<Figure size 720x576 with 1 Axes>"]},"metadata":{"needs_background":"light"}}]},{"cell_type":"code","metadata":{"id":"GYT-Cwa3rAvB"},"source":["data5.to_csv('/content/drive/MyDrive/LMEMBERS 프로젝트(1차)/고객별_대분류중분류(최빈).csv',encoding='cp949')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"F6UuKXuyrQoM"},"source":["p1 = pd.pivot_table(data5,values='amount',index='sex',columns='age',aggfunc='sum')"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":518},"id":"SX9IWKsfrvF0","executionInfo":{"status":"ok","timestamp":1632745295906,"user_tz":-540,"elapsed":846,"user":{"displayName":"dj W","photoUrl":"https://lh3.googleusercontent.com/a/default-user=s64","userId":"15436059952051218625"}},"outputId":"cd795b66-2552-4b8e-b426-74a599745a41"},"source":["p1.plot(kind='bar', figsize=(10,8))\n","plt.title( '성별 및 연령대별 매출 합계', size=20 )\n","plt.ylabel('매출 합계')\n","plt.xlabel('성별')\n","plt.legend(labels=p1.columns, loc='best')\n","plt.show()"],"execution_count":null,"outputs":[{"output_type":"display_data","data":{"image/png":"iVBORw0KGgoAAAANSUhEUgAAAmAAAAH1CAYAAABRKEK9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzdeXxWxaH/8c8AShANEIJYQBI2E1HvtRIVEGiAoFgUWURjQRuVUqUsV6u3KCqorGIjBLXIBQwqGFdKIPhDBMJqhGCxBASJApHNQiCphiUhzO+P8+Tpk30hz2H7vl+vvMgzZ86cOaQ1X2bmzDHWWkRERETEPTXOdgdERERELjYKYCIiIiIuUwATERERcZkCmIiIiIjLFMBEREREXKYAJiJSAmNMc2NMpDGm/tnuS0mMMYGe/oWe7b74kzHmUs99hp/tvohUJwUwkXOIMaaOMeYxY0zXIuWXGWPqG2NMCecEGmMuL1IWZIy51xjT1g99TDTGLPVDu1cZY240xlx2hu0MMsbMqGxwMsY8bIyZZYyp4yn6HbASuNGnTi3Pz6F2CecHeI7VKFJ+uzHmzircSkl9fM0Y87TnY1tP/2LKqH+9McaW8tWnCtcPN8ZMLeFrRJF6lxljnjLG9KzsNTznD/L8LBoCQTj3OaoqbYmcqxTARFxkjPmTMeaXMn4h1wP+Bvy+SPmbwFGgYQnnfAd8UaTsGuAj4L5y+hNaxi/ogq+oEtoOK6vdItdo6vmFOsIY088YU6+Uqo8B/wD+y+fcNsaYrDK+YktoJxL4I3C5TzvGE56Kffmc9xvgUaBYuPLRCefnMLyEY2M9x64pUh6H8zMtU2n9K9LHB4Fe5bXlYx/wh1K+/lGJdgo0BKJK+IooUi8QmAJEV6RRY0wNY0xtY0xNT1EnnJ/FFVXoo8h5oVb5VUSkGl0O1AVyqrndS40xzXw+N6rk+WuBD4qUdQEGVLVDnuAQCwwFagL5nj9/NsY8ba19qwLNHAWmllBeHxgJXOa51uVAgOdYSQFqIPBuKf2sY609UYG+VFRjY8wvPp/L/e+s5+8qr6wqlemAZ+SzIAgeLqXazcaYDsAGa+0P5bQXBFwKfI8TuEqqc5Xn23+V09ZuIKSUwz0o/o8JkQuSApiIu1p6/kyv4vmDivxyB6gD/Br4scq9gq3W2td9CzyznVUOYMBfcUaKPgX+F9iNM20WB8wwxsworwFr7WGckaVCPOueRvoUzcAJWeX5AEgtUlZW8CnNLcaYwUXKCkbukkuov6eC7W4GZvt8fhi4qXJdA+Ah4C9lHC8Iw3lAN6DMAIbzM/xNBa/9q3KOv4QzQgZwGsgF+uMEu58qeA2R854CmIi7uuL80vFO/xtjHgeaej7WLef810op/47Cv3BbAa9WsY9nzBjTGPgTsB2IttYWhJwtnrVH3+EEx4d8ThuAs+6qKl4HFnu+f5RSRmmA/2etja/iNXwNoPRwOgxn6q/AtEq0+71vEDbGdKJqAewFYJzPZ+vz1QN4EWgCDLLWrq1Ae38GGlTw2kdw1m2VyFo7p2iZMeY3nr5V9R8mIucdBTARl3gW1rfxfHwdKFgE/SjQroLNXIfzC87XP4Gj1tq/+1yr6Joct92MM8KyzCd8AWCtzTbGrAbuBdZZaw+Bs2C8aCOeaa2iI1Z42vZtMwVI8ZwTSekBrLq8RPF1XaNxwtdya+32gkJjzDh81qO5wVqbizOyhOfBjf8G7sFZQ9YKZzQyylq7pYLtbfK01RpnVLM9Tsg6DqQB8dbazwvq+zwrEmmM+djz/YfW2g9LucSNONOsx0zx50xELkgKYCIu8Dw19xrOL6y3gP8xxjxrrZ1grY3wqXcVcKCMpv7lmZbzbfs00NYYk+xTfLYXL5/y/FnagvaCJw3Lm/6rhTM6uBGYX8LxfwIYY96jYlOQ1eVna+1B3wJjTMG6vneMMcd8DrUADlXjtS8zzpYMJa6jMsZcgzMlHYYTvCJxwtLXwDs4I1/9gH8aY7biBNctwBfW2q2lXdQzGrcUOAa8hxPiGgB9gaXGmOetteOKnNYAKAjWyaW029TT12XACk9xb6BDaX0RuRAogIn4mWdbgnicX4Z/wXk6rAUwzjhbHrxgrbUVbK61MSa4SFlNnMCT5XvZSnbzv40xTxUpu62Sbfhaj/OgQW9jzDPWWu+onTGmBU4oOAJE+4x43FxGe9ustSUtxi/wLv8ZKbsfZ4Smqo5WYBSmkSm+L1XBtNu/Ad91eqfPoC8luRn4tozjt+KsI9uF86TjWGChtTajoIIx5k84D1lEArcAd1FKQPLxPE5w/i9r7fc+bY0HNgDPGWNirbW+4XOBtTamnHYH4vzv9Wlr7TeeNpuhACYXOAUwET8yxjTAGS34LfCutfYVT/n9QALwHPAbY8wIa+3mCjT5ZSnlX1lrvfs6GWPal1G3JO05s9BSiLX238aYZ3AW3K83xkzAeYLuBpx7roMTGif5nBZQrKEiPNNpl3jqNgQa40yptQWWWmtXe6Yyz+RexgMngM7A7aXU+V/PV0mGFZmC3E4F7q0StuL8HV4DTPa5zq+AOzwfH8dZaF+gWymhcpfn6wPg18aYXwMfW2uLPugBzu8LizOK6+uUp6wmldzayBgTAPwPsLEgfIlcLBTARPzEM9LzJU5IeBWfRfLW2pPGmH44v3zGAK1xnoArzVuU/Xh+laa4rLW7qfxoWUXbnm6MycIJNHN9Dm0BHrTWrvStb4wZi/N3UZLfG2OK7o3m60dg9Rl019er1tosY8woigewb3HWUZVlfzX1ozSHrbV/94RsX9cBb1dD+8kUHsErEIvzJORaY8xsnL/zejhTkB2AuFKCW1mew3lq8vfGmNv5z5OkN5Z+isiFQQFMxE+stbuMMWOAHdba5BKOW+A1Y8wMa23RUYWidb/EM6JljClY4F5ICb+QOwB7q9J3Y8xBnODoa5W1NhJnk8wKhTZr7bue9VlhOFN0+z2hr6KygWd8PufjLC7/BcjEub90a21WCedWO2vtTzgjmgVbYVxVQrW2RUabYoCTfu4a1tovKOPn4hNw77TW/r8qtJ9kjLkNZ/uPR3BGIAsW4f+eUvZZK6M/3XB2t//IWrvMGDML54EUkYuCApiIH5W22ahnHVcbnP2Qcj2BZyfOOq4HcabrSrOS8rerKPAiJeyjVQHPlHCNfeDdm6vCPEFze7kVSz73ZwpPU1bE98BXVDD0eB6QqMrrj57C2WqjIvYAoVW4RpUYY24COhYpvsXz592epxl9fea7rqs01tqvPG8fCAUWWWtL+zsuCM4lPmXp+UfEApyF/H/ytD0YGOw5PgPnbQYiF6zzLoAZY8JwhtkzrLWlvubCs7P0MGAi8OuCNRnGec/cczjrNy6v5h2wRcpkjIkBnsDndTs+fsb5pfSCtbasjTu7UsIIWBHhVHI6yrN3Vw/PxzwKL+oHqOuZBqwJfGKtza5gu42A6cAKa+3MyvSphLbq4Iy23IOzniwYZ91RNrADZ5r2LWvtxFKauNszclUXaIYzMnc98GQVuvMqntGwcsyj/J9Xgf7GmIo+kFGW23H+21eSoSWUDaDs0O9rGM7P4FfAwVLq1PVcfy6Q5HvAGNMXZ7TsGNCzYBsSkYvNeRfAcJ7wieM/eyiVJgRnjcJXRcqvw/mPdFU3fBSpEmPMVJzpm+14Fh7jTKPVxllI3hvPu/6MMe2ttaVtSvkT5S92ruyriACupexppILd0w/jvGeyouriPJn4C1DlAGaMCcH5/25rnKfu3sEZWToNXIkz5Toa+LMxpr/vvlQ++uE88fdvnLVa6Tih9zOKv8+wPP+uYL1TlB/A8ik81XpGrLWTqMDIoecfBFVdN9bZGHO0lGOBJRUaY4YCbwDbgL5l/G9c5IJ33gUwa+07no0WAe+I1hs4j/XXBmKttR95htO/N8YML3L+Rs957nVaLnqeUZcROHsx3VbCyOs/gQXGmM9x9rt6FmedTUm2UfEpyMpYQ+H9wwp2Ts/H+YdPPP/ZPf3n6r64tXYsZU+XTsUJX7+31r5TUgVjzH/h3Me7xphmBZvAWmvfo5zRqir8N+ElKjcFWSrPNG1lp1pLZYy5Fmfbk/LcegaXKW1T1bK8jfMez6os2Be5oJx3AawE/wtst9Y+7Jme2GSMWejZCVrkXBGCs0B6RTnT3p95/mxRTntbKH0bBF8VHmGw1ubj8/SbMaYmzlTWcOBOnNcH/cZaW3RU2S2/Bg6VFr4ArLX/NMYsx3ky72rKf8dhdYih/HcYlvmQhR/cQ+lTkNXlJpyXpZekAc4/NgrxPGwywZ+dEjlfXAgBLAK40hhzp+dzDZwnkzJKP0XEdd/gbEz6oDEmvqQdxz3rFgt2Ek8pp73Lqdij+q1xXntUIZ6tMzrivMqnF85UZsE/ZnJwpkcvBf5RhRGMmzxP4pVns+9rlXz8A+hjjHnAWvt+Kf2/HmeNXCaF38foT20p/wXUGGMyrLW7XOiPr9eoWAit6Bo1X7+h5O0qwOVXL4mcjy6EAJYGbLXWvgvOLxDfHZ9FzgWefaUexJle/MYYswJnhOAIztR5KM4mmk1xdpEfX06TLajYCMdPVCCAGWOexVmI3tBTdAD4O85msWtwQs0DOKNhzwPWGPMD0K0S/3/7teerPHM91y7qf3AWzM83xjyBsx5sL84asEY4m6/ejvP048AyntCrbhUZiQRnnze3A9gTFaz3Dc5mrJVR2ovhRaQCTMXfgHLu8KwBe8xaG22MuQKYgfNEE8DX1tonfOome+puL9LGbiBcT0GKm4wxzXGeQuuOMzp1Bc4Thz/hjPB8iPPS4vxSG/Ffv0bj7DW2zlq7s5R6NXDWFnUCAqy1U9zrpfcpyBiKPwWZhTNF+gUw01rr1uiXiEiVnJcBTEREROR8Vqn3domIiIjImVMAExEREXHZebUIPzg42IaGhp7tboiIiIiUa9OmTYettSVujH1eBbDQ0FBSU1PPdjdEREREymWMKXUTZk1BioiIiLhMAUxERETEZQpgIiIiIi47r9aAiYiISPXIy8tj7969nDih/cjPVEBAAM2aNeOSSy6p8DkKYCIiIhehvXv3csUVVxAaGoox5mx357xlrSUzM5O9e/fSokWLCp+nKUgREZGL0IkTJ2jYsKHC1xkyxtCwYcNKjyQqgImIiFykzufwFR4eztq1a4mJiSmz3rhx44iPjy+zTuvWrc+oL1X5e9QUpIiIiBA6Kqla29s9qVe5dXbs2MHDDz9M8+bNSUhI4NSpUwwdOpRt27aRk5PDlClTiIqKAmDTpk1MmTKFhISEEts6cuQIgwcPZs+ePVx99dXMmTOHoKCgQnX+9a9/8dvf/haAK664gpUrV57hXVadRsBERETkrPjqq68YMWKE9/OcOXOoXbs2a9eu5fPPP2f48OHk5uYCkJubS2BgYKltvfTSS/Ts2ZNNmzbRs2dPXn755ULHFy9e7A1fAD///DMRERF899131XxXFaMAJiIiImfFQw89xFVXXeX9/M0339C9e3cAGjVqRJMmTdi6dSsAaWlp5OTksHDhQiIiIoq1tXr1ah544AEAoqOjWb16daHjd911Fxs2bODxxx/nlltuYcyYMaSmpnLNNdf46/bKpAAmIiIi54Rrr72WpUuXAvDdd9/x9ddfk5+fD8CSJUtIT0+nXbt2Jb6WsOg6rJLWZb366qts2bKFkSNH8n//938sWbIEcJ4Ibd++PQsWLKjuWyqVApiIiIicEwYPHowxhs6dOxMXF8e1115Ly5Yt2bBhA3l5ecTFxTFo0CBOnjxZ7NwuXbrw/vvvA5CQkEDnzp2L1Vm2bBlPPvkkYWFhPPbYYyxbtgyAZs2akZKSQt++ff17gz60CF9ERETOCbVq1eLNN98EICkpiczMTE6cOMGDDz5IYmIiYWFhdO3alfnz5xc79/nnn+fhhx9mxowZNG3alLlz5xar065dO+bPn8+f/vQnPvroI+9059mgACYiIiLnhH/+858MGzYMay2tWrVi1qxZ1K1bl2XLltG8eXMAxowZA8DkyZMLnRsUFMTChQvLbP+FF17gpZdeol+/fvTs2ZOBAwf650YqQAFMREREKrRthD9ERkYSGRkJwE033cT69euL1SkIX2fqsssuY9KkSdXS1plSABMREZHzzvbt2wHo1KlTmfWee+65cttKT0+vlj5Vhhbhi4iIiLhMAUxERETEZQpgIiIiIi7TGjARH3tHranSec0mFd9vRkREpDQaARMRERFxmQKYiIiInHfCw8NZu3YtMTExfr9WZGQkBw8epHXr1tXWpqYgRUREBMbWq+b2sss8nJOTw9NPP01qairWWnr06MGECRMYPXo0K1euxFrLxIkTvXuEbdq0iSlTppCQkFDprkybNo13332XOnXqUL9+fRISEqhbt673+ODBg0lPTyc5Odlb1qZNG3bu3Fnpa1WUApiIiIi4Lisri9/97ne8+eabnD59mmuvvZbrr7+ezZs3s379evbv30+3bt1IS0ujVq1a5ObmEhgYWKVr/epXv2Ljxo0YY/jDH/7AokWLiI6OBpxXHpXUbkBAwBndX3k0BSkiIiKua9q0qXcT1ZycHC699FI2bdrEgAEDAGjSpAkhISHs2LEDgLS0NHJycli4cCERERHF2jtw4AB33nknffv2Zd++ffzwww8cOXIEgPvuuw9jjLdewVRiVlYWr776KuPHjy/U1s6dOzl69CgZGRlERESwadOmar9/jYCJiIjIWZOfn89DDz3ElClT+PTTTwkODvYeCw4O5tChQwAsWbKE/fv3065dO1JTUwkPDy/UzokTJ3jvvff46aefeOSRR6hTpw7z5s0rVGfSpEn8+te/9ga4p556ivHjx1OnTp1C9ZKSkmjYsCEbN24kNTXVOw1anRTARERE5KzIy8vjoYceIjo6mp49e7J06VKys/+zdiw7O5sGDRqwYcMG8vLyiIuLY9CgQSxdurRYWy1atACgYcOGJR6fOnUq+/fvJy4uDoDPPvuMBg0a0LFjx0L1srOzmTNnDl988QVRUVG0a9euOm/ZSwFMREREXJebm8sDDzzAvffey/333w9A9+7deffddxk4cCCHDx9mx44dNGrUiK5du5KYmEhYWBhdu3Zl/vz5lbrW5MmTycjI4I033vCWrVu3ju+//57o6Gjy8vLYtm0bw4cPZ8uWLTz77LNceeWVxMbGMm7cuGq97wIKYCIiIuK6WbNmkZycTGZmJm+99RYAf/3rX2ncuDEdO3bk9OnTTJs2jSZNmrBs2TKaN28OwJgxYwAnVFXEtm3bGD16NLfddpt3KvHBBx8sFKx2795NTEwM06dPZ8+ePYSEhAAQFRVFVFSUpiBFRETET8rZNqK6DR06lKFDhxYrL2nKryB8VUXbtm05depUmXVCQ0O9W1AUhC9/UwATERGR88727dsBvE9S+lNBOEtPT6+2NrUNhYiIiIjLFMBEREREXKYAJiIiIuIyBTARERERlymAiYiIiLhMAUxERETOO+Hh4ezdu9cve3QVFRMTQ0pKivcdktVB21CIiIgIN8y9oVrb2/L7LWUez8nJ4emnnyY1NRVrLT169GDIkCG0b9/e+57Hyy+/nMWLFwOQmZlJr169SElJqXRfEhISiI2NJSAggJo1a/L+++9z1VVX8emnn/LKK69w6tQpOnfuTGxsrPel3TfccAMbN24kICCg0terCI2AiYiIiOuysrL43e9+x4YNG/jqq6/45JNPOHjwID179iQ5OZnk5GRv+ALn1UWBgYFVutall17KunXrWL16NVFRUcTHx5OVlcWoUaP4/PPPSU1NJSsriwULFhQ6r3bt2md0j2VRABMRERHXNW3a1LuJak5ODpdeein169dn+fLldOrUiW7dupGYmOitn5aWRk5ODhs2bCAiIoIDBw4Uai8nJ4f+/ftzxx13sG3bNjIzM9m1axcA/fr145JLLgFg//79tGnThp07d9K2bVtvqOvWrRurVq0C4Pjx4+zevZvs7GwiIiIKBcHqoilIEREROWvy8/N56KGHmDJlCmFhYWRkZGCMISMjgx49ehAWFkZYWBhJSUn88ssv1KhRg9TUVO80ZYGTJ08yZcoUateuzbBhwzh27Bhvv/12oTrvv/8+v/zyC/379+fw4cNs2bKFzMxMAgMD+fjjj7n66qsBWLp0KS1btmT27NmkpqYSExNT7ffttwBmjAkD3gYyrLXRJRwfD3QFDPCMtTbZX30RERGRc09eXh4PPfQQ0dHR9OzZs9Cx5s2bExUVxdatW6lTpw7r1q0jMTGRPn36sGLFimJtBQUFERQUBFBsKhHgo48+YsGCBcyfPx+A4OBgJkyYQJ8+fahXrx6tWrWiZcuW5OXlMXHiRBYtWsSAAQP8tsjfn1OQtwJxJR0wxnQDbrTWdgT6AzOMMRqNExERuUjk5uYSHR1N7969uf/++wH47rvvOH78OABHjx5lzZo1tGvXjrvuuovY2FhCQkIYOXIkU6dOrdS15s2bR0JCAvPmzaNWrf/Ejf79+7NmzRri4+NJSUlh4MCBPPLII/Tr14/mzZsza9YsxowZU3037cNvocda+44xJrKUw92Bjzz19htj9gBhwFZ/9UdERETOHbNmzSI5OZnMzEzeeustAO6++24WLFhAzZo1ycvLY/z48YSEhLBo0SJCQkIAvNOBH3zwQYWu8/PPP/PQQw9x66230qNHDwB69OjB6NGjGTBgAIcPH+b06dNMnz6d4OBgxo8fT/PmzQHnScjFixefX1OQ5WgEfOnz+bCnrBhjzBBgCOD9CxEpz1/vv6tK593f4i/V3BMRkfNDedtGVLehQ4cydOjQYuV//vOfi5UVhK+quOKKK8jPzy/xWElTlW5ljbMVwHKAej6f6wFHS6porZ0JzASIiIiw/u+aiIiInOu2b98OQHJyst+vFR8fD0B6enq1tenaNhTGmJrGmIINPJYDvT3lwTjTjzvc6ouIiIjI2eTmPmDRwHue75OAn4wx64HFwEhr7QkX+yIiIiJy1vh1CtKztUSy5/t5wDzP9xYY4c9ri4iIiJyrtBO+iIiIiMsUwERERERcpgAmIiIi553w8HDWrl3rlz26ioqMjOTgwYO0bt262trU7vMiIiLCt+HXVmt7127/tszjWVlZDBkyhB9//BFrLffddx9PPvkko0ePZuXKlVhrmThxovdVQJs2bWLKlCkkJCRUui+jRo1i5cqVXHLJJbRu3ZqZM2dy6aWXeo8PHjyY9PT0QltaFLyw218UwERERMR1J0+eZOzYsbRt25ZTp05x7bXX0qxZMzZv3sz69evZv38/3bp1Iy0tjVq1apGbm0tgYGD5DZfgjjvuYNKkSQA8/PDDJCYmcu+99wKQlJRUYrsBAQFVv7kK0BSkiIiIuK5x48a0bdsWgEOHDlGrVi2++uorBgwYAECTJk0ICQlhxw5nm9C0tDRycnJYuHAhERERxdo7cOAAd955J3379mXfvn388MMPHDlyBICuXbsCTuj78ccfvbvdZ2Vl8eqrrzJ+/PhCbe3cuZOjR4+SkZFBREQEmzZtqvb7VwATERGRs2bUqFFcd911PPnkk/z8888EBwd7jwUHB3Po0CEAlixZQnp6Ou3atSM1NbVYOydOnOC9995j/PjxPPLIIzz55JPUrl3be/yjjz4iNDSUkJAQb4B76qmnGD9+PHXq1CnUVlJSEg0bNmTjxo2kpqbSrl27ar9vBTARERE5ayZNmsSPP/7IO++8w86dO8nOzvYey87OpkGDBmzYsIG8vDzi4uIYNGgQJ0+eLNZOixYtaNiwIW3btmXp0qX8/e9/p27dut7jAwYMYN++fTRo0IBXX32Vzz77jAYNGtCxY8dC7WRnZzNnzhyWLVvGiy++yO7du/1y31oDJiIiIq7bsWMHQUFBNGrUiMsuu4x69erxhz/8gfnz5zNw4EAOHz7Mjh07aNSoEV27diUxMZGwsDC6du3K/PnzK3ydo0ePsn//fq677jpq1KhB48aNOXLkCOvWreP7778nOjqavLw8tm3bxvDhw9myZQvPPvssV155JbGxsYwbN84v968AJiIiIq6rVasWf/zjH8nOzubYsWN06tSJ3r17s3z5cjp27Mjp06eZNm0aTZo0YdmyZd51W2PGjAFg8uTJFbpOQEAAcXFx/PDDD+Tm5hIUFMTs2bMJCgry1tm9ezcxMTFMnz6dPXv2EBISAkBUVBRRUVHeJzGrkwKYiIiIlLttRHVr1aoVn376abHyuLi4YmUF4asq6tSpw1tvvVVmndDQUO8WFAXhy98UwEREROS8s337dgA6derk92sVhLP09PRqa1OL8EVERERcpgAmIiIi4jIFMBERERGXKYCJiIiIuEwBTERERMRlCmAiIiJy3gkPD2fv3r1+2aOrqJiYGFJSUmjdunW1taltKERERIQ3HltRre39aUa3Mo9nZWUxZMgQfvzxR6y13HffffTr14/27dsTHh4OwOWXX87ixYsByMzMpFevXqSkpFS6L9OmTWPevHnUqVOH+vXrM3fuXOrXr8+nn37KK6+8wqlTp+jcuTOxsbEYYwC44YYb2LhxIwEBAZW+XkVoBExERERcd/LkScaOHcuXX37J2rVr+dvf/sbhw4fp2bMnycnJJCcne8MXQG5uLoGBgVW61n//93/z1VdfsWrVKm666SZmzZpFVlYWo0aN4vPPPyc1NZWsrCwWLFhQ6Dzfl3lXNwUwERERcV3jxo1p27YtAIcOHaJWrVrUrVuX5cuX06lTJ7p160ZiYqK3flpaGjk5OWzYsIGIiAgOHDhQqL2cnBz69+/PHXfcwbZt28jMzGTXrl0AREZGYowhPz+fH374gZCQEHbu3Enbtm29oa5bt26sWrUKgOPHj7N7926ys7OJiIgoFASri6YgRURE5KwZNWoUM2fOZPLkyYSHh5ORkYExhoyMDHr06EFYWBhhYWEkJSXxyy+/UKNGDVJTU73TlAVOnjzJlClTqF27NsOGDePYsWO8/fbb3uNr165l0KBBhIeH07t3b37++We2bNlCZmYmgYGBfPzxx1x99dUALF26lJYtWzJ79mxSU1OJiYmp9vvWCJiIiIicNWuUlIgAACAASURBVJMmTeLHH3/knXfeYePGjd41WM2bNycqKoqtW7eSkZHBunXrSExM5A9/+ANHjx4t1k5QUBAtW7akadOmLFiwgKVLl9KkSRPv8U6dOrF7925++9vf8sQTTxAcHMyECRPo06cPffv2JTQ0lDZt2pCXl8fEiRNZtGgRH374IZs2bfLLfSuAiYiIiOt27NjBoUOHALjsssuoV68e//jHPzh+/DgAR48eZc2aNbRr14677rqL2NhYQkJCGDlyJFOnTq3wdfLz8/nyyy+9n3/1q195A1z//v1Zs2YN8fHxpKSkMHDgQB555BH69etH8+bNmTVrFmPGjKnGu/4PTUGKiIiI62rVqsUf//hHsrOzOXbsGJ06deKaa66hR48e1KxZk7y8PMaPH09ISAiLFi0iJCQEwDsd+MEHH1ToOjVq1GDBggU8//zz5Ofnc8kll/DWW28BMGDAAA4fPszp06eZPn06wcHBjB8/nubNmwPOk5CLFy/2yxSkApiIiIiUu21EdWvVqhWffvppsfK1a9cWKysIX1VhjOGVV14p8VjRpx4Bb/jyNwUwEREROe9s374dgOTkZL9fKz4+HoD09PRqa1NrwERERERcpgAmIiIi4jIFMBERERGXaQ2YSDUYO3asq+eJiMj5TSNgIiIiIi5TABMREZHzTnh4OGvXrvXLHl1FRUZGcvDgQVq3bl1tbWoKUkRERPjr/XdVa3t//qBiL7C21nL77bfTtGlT4uPjGT16NCtXrsRay8SJE4mMjARg06ZNTJkyhYSEhCr3aezYscybN4+dO3cWKh88eDDp6emFtrRo06ZNsXrVSQFMREREzpo333yT66+/nqNHj7JixQo2b97M+vXr2b9/P926dSMtLY1atWqRm5tLYGBgla+zefNmvv32W5o2bVqoPCkpqcR2AwICqnytitAUpIiIiJwVu3fvZsmSJYwYMQKA5cuXM2DAAACaNGlCSEgIO3bsACAtLY2cnBwWLlxIREREsbYOHDjAnXfeSd++fdm3bx8//PADR44cASAvL4+nnnqKuLi4QudkZWXx6quvMn78+ELlO3fu5OjRo2RkZBAREeGXF3JrBExERERcZ61lxIgRxMXFYYwB4NChQ3To0MFbJzg42PvC7iVLlrB//37atWtHamoq4eHhhdo7ceIE7733Hj/99BOPPPIIderUYd68eQBMmDCBwYMH07hx40LnPPXUU4wfP546deoUKk9KSqJhw4Zs3LiR1NRU7zRodVIAExEREdfNmDGDO+64g1atWrF7924A6tatS3Z2trdOdnY2DRo0YMOGDeTl5REXF8egQYNYunRpsfZatGgBQMOGDQsd/+c//8l3333HmDFjCtX/7LPPaNCgAR07dixUnp2dzZw5c/jiiy+IioqiXbt21XXLhSiAiYiIiOs2btxITk4Oa9asISsrix07dvDwww+TmJjIwIEDOXz4MDt27KBRo0Z07dqVxMREwsLC6Nq1K/Pnz6/wddatW0d2djbR0dEAfPPNN0RHR9O6dWu+//57oqOjycvLY9u2bQwfPpwtW7bw7LPPcuWVVxIbG8u4ceP8cv8KYCIiIuK6OXPmeL9PTk4mPj6e559/npEjR9KxY0dOnz7NtGnTaNKkCcuWLaN58+YA3pGsyZMnV+g6jz/+OI8//rj3c2hoaLEnKXfv3k1MTAzTp09nz549hISEABAVFUVUVJSmIEVERMQ/KrpthD9ERkZ6Q07RhfKAN3xVh4LpTl+hoaHeLSgKwpe/KYCJiIjIeWf79u0AdOrUye/XKghn6enp1damtqEQERERcZkCmIiIiIjLFMBEREREXKYAJiIiIuIyBTARERERlymAiYiIyHknPDycvXv3+mWPrqJiYmJISUmhdevW1damtqEQERER9o5aU63tNZvUuUL1rLXcfvvtNG3alLFjx9K+fXvvex4vv/xyFi929ifLzMykV69epKSkVLlPb7/9NkOGDCEvLw+ATz/9lFdeeYVTp07RuXNnYmNjve+lvOGGG9i4cSMBAQFVvl5ZNAImIiIiZ82bb77J9ddf7/3cs2dPkpOTSU5O9oYvgNzcXAIDA6t8nX379jF//nzat28PQFZWFqNGjeLzzz8nNTWVrKwsFixYUOic2rVrV/l65VEAExERkbNi9+7dLFmyhBEjRnjLli9fTqdOnejWrRuJiYne8rS0NHJyctiwYQMREREcOHCgUFs5OTn079+fO+64g23btpGZmcmuXbu8x0eMGMHUqVOpWbMmADt37qRt27beUNetWzdWrVoFwPHjx9m9ezfZ2dlEREQUCoLVRVOQIiIi4jprLSNGjCAuLs477RcSEkJGRgbGGDIyMujRowdhYWGEhYWRlJTEL7/8Qo0aNUhNTfVOUxY4efIkU6ZMoXbt2gwbNoxjx47x9ttvAzB37lxuvvlmrrvuOm/9Fi1asGXLFjIzMwkMDOTjjz/m6quvBmDp0qW0bNmS2bNnk5qaSkxMTLXfvwKYiIiIuG7GjBnccccdtGrVyvt+xoIgBs77H6Oioti6dSt16tRh3bp1JCYm0qdPH1asWFGsvaCgIIKCggAKTSUeOHCAhISEYqNYwcHBTJgwgT59+lCvXj1atWpFy5YtycvLY+LEiSxatIgBAwb4bZG/piBFRETEdRs3bmT16tVER0fz2GOPsWrVKl566SWOHz8OwNGjR1mzZg3t2rXjrrvuIjY2lpCQEEaOHMnUqVMrfJ0NGzZw+vRpBg4cSHR0NN988w3R0dEcOnSI/v37s2bNGuLj40lJSWHgwIE88sgj9OvXj+bNmzNr1izGjBnjl/vXCJiIiIi4bs6cOd7vk5OTiY+Pp0uXLvTo0YOaNWuSl5fH+PHjCQkJYdGiRYSEhAB4pwM/+OCDCl3nnnvu4Z577vF+Dg0NJSEhAYC+ffty+PBhTp8+zfTp0wkODmb8+PE0b94ccJ6EXLx4saYgRURExD8qum2EP0RGRnqn+tauXVvseEH4qg4F051AsaceAW/48jcFMBERETnvbN++HXBGz/wtPj4egPT09GprU2vARERERFymACYiIiLiMgUwEREREZcpgImIiIi4TAFMRERExGUKYCIiInLeCQ8PZ+/evX7bqd7X2LFjSUhIICoqqtA2FmdC21CIiIgIY8eOdb29+vXrc+ONN3o/L168mPj4eObNm4e1lieeeIL7778fgMzMTHr16kVKSkql+xITE8P27dsJCAgAYNiwYdx7773e42+//TZDhgwhLy/PW3b33XczZcqUYu+crC4KYCIiInJW3HjjjYX28fr++++ZM2cOKSkpnDx5kltuuYXbb7+dBg0akJubS2BgYJWvlZCQQGhoaLHyffv2MX/+fNq3b1+o/EyvVx5NQYqIiMhZsXXrVrp06UKXLl2YPXs2K1asoHfv3lx66aVcccUVdOnShfXr1wOQlpZGTk4OGzZsICIiggMHDhRqKycnh/79+3PHHXewbds2MjMz2bVrFwA1atRg0KBBdOjQgaFDh3L06FHveSNGjGDq1KnUrFmzWN9ycnLo1asXM2fOrPZ71wiYiIiInBU//fQTNWrU8E4v3n333QQHB3uPBwcHc+jQIQCSkpL45ZdfqFGjBqmpqcWmBk+ePMmUKVOoXbs2w4YN49ixY7z99tsAzJo1ixo1apCfn8+UKVMYMWIE7777LnPnzuXmm2/muuuuK9TW5s2bCQoKIi4ujqSkpGqfngUFMBERETlLatRwJuIaNmxI//79OXbsGNnZ2d7j2dnZNGjQgIyMDNatW0diYiJ9+vRhxYoVxdoKCgoiKCgIKP6Ox4Lr1KxZk0cffZTu3btz4MABEhISWLx4cbG2nnvuOWbNmsXLL79MUlJStd1voT75pVURERGRMuzZs4esrCwAjh8/zqJFi+jWrRtLliwhPz+f48ePk5ycTEREBHfddRexsbGEhIQwcuRIpk6dWqlrbd682fv9Bx98QJcuXdiwYQOnT59m4MCBREdH88033xAdHc3jjz/O1VdfzS233MKMGTOYMmVKocX51cWvI2DGmGHAQMAAr1lrP/A51gh4GwgELgNmW2v/5s/+iIiIyLnh3//+NzExMeTn55OXl8fgwYPp3Lkzd911Fx07dsQYw5NPPknTpk1ZtGgRISEhgPNEIzhBqqJee+010tPTqVmzJqGhobz++usEBgZyzz33eOuEhoaSkJDAvn37uOqqqwBo2rQpycnJ59cUpDGmFfAI0B6oDWwwxnxurS1Y+fYUsMpaO8UYcxmwzRjzobU20199EhERkZL5I2SU5YYbbmDlypXFyp955hmeeeaZQmUF4auq5s6dW26dgv29mjZtekbXqih/joB1AxKttblArjFmNdARKJhMPQg09nwfCBwDTvixPyIiInKB2L59O0ChbSz8pSCcRkdHV1ub/gxgjYDDPp8Pe8oKTAeSjDHfAfWBx621OX7sj4iIiMg5wZ+L8HOAej6f6wFHfT6/DHxhrb0GaA08YYxpW7QRY8wQY0yqMSa14FFUERERkfOZPwPYcuC3xpiaxpg6QCSQaowp2FY2DNjl+f5nIBtoVbQRa+1Ma22EtTaiUaNGRQ+LiIiInHf8FsCstWnAYmA9sBKIxQlh73mqPAeM8KwN2wjsAT7zV39EREREzhV+3YbCWjsRmFikeJ7n2Dagiz+vLyIiInIu0kasIiIict6JjIzk4MGDtG7d2u/Xio+PZ9KkSQwePLjanrrUq4hERESE5SuKLcM+I927fV9unfr163PjjTd6Py9evJhmzZoVK7v88ssBaNOmDTt37qx0X8aOHcvf//536tevD8C9997LsGHD2Lp1K8OHD+fEiRPUq1eP999/31tn+PDh9OrVi549e1b6ehWhACYiIiJnxY033lhsRKmksgIBAQFVvtbUqVOJjIwsVDZkyBCmTZtGREQE8fHxvPDCC8TFxQGQm5tLYGBgCS1VD01BioiIyFmxdetWunTpQpcuXZg9e3apZQA7d+7k6NGjZGRkEBERwaZNm4q19/vf/56uXbuybt06Tpw4QVpaGgDGGJ5++mk6dOjAgw8+SEZGBgC7du0iIiICgO7du7Nq1SpvW2lpaeTk5DB48GBefPHFar93jYCJiIjIWfHTTz9Ro0YNMjMz6dWrF6GhoSWWde/enaSkJBo2bMjGjRtJTU0tNpoFzrRhmzZtGD58OBkZGbz++usAPP/884wZMwaAefPmMXDgQNasWUOTJk1ISUmhffv2vP/+++Tn53v7lZOTw4wZM/jkk0+Ij4/n4MGD1XrvGgETERGRs6JGDSeGNGzYkP79+/PNN9+UWJadnc2cOXNYtmwZL774ove9jUVFRERQr1493nnnHZKTk7n++usLXQdg4MCB3nVks2fPZsyYMXTv3p3Tp0/Tpk0bAF566SWeffZZGjduzIwZM/xz735pVURERKQMe/bsISsrC4Djx4+zaNEi2rVrV6zstttu45577uHZZ5/lyiuvJDY2lnHjxlXqWps3b/Z+v3jxYu+043XXXcfSpUtZunQpW7ZsYciQIcyePZvdu3czYMAAJk+eTEJCApmZmdV01/+hKUgRERFx3b///W9iYmLIz88nLy+PwYMHExQURN++fQuV3XrrrcydO5eQkBAAoqKiiIqKKnEKsjQffvghjz32GLVr16ZBgwbMnDkTgAkTJvDFF19w/PhxHn/8ce68804OHz7MAw88gDGGK664guTkZL9MQSqAiYiISIW2jahON9xwAytXrixWXlJZQfiqqgkTJpRY/sILL/DCCy8UKgsODj6ja1WUApiIiIicdwq2qkhPT/f7tWJiYqq9Ta0BExEREXGZApiIiIiIyxTARERERFymACYiIiLiMgUwEREREZcpgImIiIi4TNtQiIiICFet3Fx+pUo42PXGam2vqPDwcGbNmsWsWbOIj48vtd64ceNo1qxZmVtJtG7d2pXtLHxpBExERETOij179tC9e3c6duxIp06dOHHiBKNHj6Zjx4506NDBu9cXwKZNm4iOji61rSNHjtCvXz/atWtHnz59OHLkSKl1r7rqquq8jSpRABMRERHX5efnc//99/P666+zfv16Vq1axfr169m8eTPr16/nk08+4bHHHuPUqVMA5ObmEhgYWGp7L730Ej179mTTpk307NmTl19+ucR6W7Zs4fLLL+fHH38s1JeIiAg+/PDD6r3JMiiAiYiIiOs+++wzwsLCGD16NLfddht/+9vfWL58OQMGDACgSZMmhISEsGPHDgDS0tLIyclh4cKF3pdp+1q9ejUPPPAAANHR0axevbpYncOHDzNmzBjWrVvHn//8Z77++msAatasSWpqKvfdd5+/brcYrQETERER123fvp1vv/2W5cuXU6NGDbp06UK9evXo0KGDt05wcDCHDh0CYMmSJezfv5927dqRmppKeHh4ofaMMWV+3rt3LwMHDmTmzJk0btyYWbNm8cwzz9CyZUs/3WHZNAImIiIirqtZsya9e/fmiiuuoG7dukRFRbFr1y6ys7O9dbKzs2nQoAEbNmwgLy+PuLg4Bg0axMmTJ4u116VLF95//30AEhIS6Ny5c6HjzZo1Y8WKFYSFhQEQGBjIG2+8Qf369Xnsscf8eKclUwATERER13Xq1Ink5GTy8/M5deoU69at49FHHyUxMRFwpgt37NhBo0aNePDBB/nrX//KrbfeSteuXZk/f36x9p5//nmSkpK46aabSEpK4vnnny9Wp2bNmqSlpXH77bdzyy23EBERQYcOHWjbtq3f77coTUHKOe+Nx1ac7S6IiFzw/L1tRFE333wzPXr0ICIigtq1axMdHc3IkSMZOXIkHTt25PTp00ybNo0mTZqwbNkymjdvDsCYMWMAmDx5cqH2goKCWLhwYbnXffTRR4mLi+PWW28FnKnJDh06kJ6eTu3atav5LkunACYiIiJnxV/+8hf+8pe/FCqLi4srVq8gfFWHxo0b8/XXX9O2bVsuueQStm3bxmWXXcYll1xSbdeoCAUwEREROe9s374dcKYyy/Lcc88V+jx37lxiY2MZMGAAp06dom3btnz22WfUqOHuqiwFMBEREbloNGjQoNQ9wtykRfgiIiIiLlMAExERuUhZa892Fy4IVfl7VAATERG5CAUEBJCZmakQdoastWRmZhIQEFCp87QGTERE5CLUrFkz9u7d691pXqouICCAZs2aVeocBTAREZGL0CWXXEKLFi3OdjcuWpqCFBEREXGZApiIiIiIyxTARERERFymACYiIiLiMgUwEREREZcpgImIiIi4TAFMRERExGUKYCIiIiIuUwATERERcZkCmIiIiIjLFMBEREREXKYAJiIiIuIyBTARERERlymAiYiIiLhMAUxERETEZQpgIiIiIi5TABMRERFxmQKYiIiIiMsUwERERERcpgAmIiIi4jIFMBERERGXKYCJiIiIuEwBTERERMRlCmAiIiIiLlMAExEREXGZApiIiIiIyxTARERERFymACYiIiLiMgUwEREREZcpgImIiIi4TAFMRERExGW1znYHRC5my1e0qtJ53bt9X809ERERN2kETERERMRlCmAiIiIiLlMAExEREXGZApiIiIiIyxTARERERFymACYiIiLiMr8GMGPMMGPMl8aYFGPM/SUc/7UxZr0xZq0xZrE/+yIiIiJyrvDbPmDGmFbAI0B7oDawwRjzubX2qOd4feAtoI+1dr8xRnuSiYiIyEXBnyNg3YBEa22utfZnYDXQ0ef4ICAFmGmMWQv09WNfRERERM4ZJY46GWN2AhYwnj/x+d4A1lp7TTltNwIO+3w+7CkrEA5cDfQD6gFfGmOSrbWHKnsTIiIiIueT0qb9OlVD2zk4wapAPeCoz+d84CNrbS5wyBizCSeUFQpgxpghwBCA5s2bV0O3RERERM6u0qYgPwY+AnYA7wMJnu8/8jlWnuXAb40xNY0xdYBIINUYE+g5vhboDmCMqQv8F/Bd0UastTOttRHW2ohGjRoVPSwiIiJy3iltBOx2nIXzn1lruwEYY7601napaMPW2jTPk43rcaYuY3FC2P1Ab+AT4DZjTCpwCnjRWvtTVW9ERERE5HxRWgDrDkwD6hpj3gHeBIZVtnFr7URgYpHieZ5jp4H/qWybIiIiIue70qYgLTDJWnsV8BowFBhhjAlwrWciIiIiF6iytqEwANbaf1hrHwISgSRjzKWu9ExERETkAlXaFOQ24EffAmvtJ57F9O2AL/3dMREREZELVYkBzFq7C8AY86619kGf8vfc6piIiIjIhaq0jVgfwpmCvM3zPcAW4IaCOtbad/zfPREREZELT2lTkFd7/pzt8/0e4FfAYziL9BXARERERKqgtCnI8caYaGttgjHmciDPWnsSWGWMuYv/vJ5IRERERCqpxKcgjTEPALcYY3rjbKT6jTHmZld7JiIiInKBKm0biqE4a8B+B9wE9AJGuNUpERERkQtZaWvAwJlmzLfWnjLGHAX+yxgzB2iNpiBFREREqqy0APYh0AL42hjzKXAlzquJduAszBcRERGRKiptEf50Y8wT1trXjDFrgRxrbZrLfRMRERG5IJU6BWmtfc3z51fudUdERETkwlfWuyBFRERExA8qFMCMMRP93RERERGRi0VZT0ECYIwZh/NKonrAbcBxINxa+zd/d05ERETkQlTqCJgxZroxpinQ1FN0HfA0MBV4wIW+iYiIiFyQStsJfyYQAXwErPA5tBg44kK/RERERC5YpY2AXQscA77GeRXRFcBbaANWERERkTNW1iJ8A3wARAK/AM97ykRERETkDJQWwN7w/Pkl0AFn5OtfnrLaQD0/90tERETkglXaTvgJxpgQz3sga3qKDwCbgUCcVxOJiIiISBWUtRP+ZM+3w4HPrLW7gF3Acjc6JiIiInKhKncfMGvtL0BnF/oiIiIiclEoMYAZY3birPsywFU404++C/CttfYa/3dPRERE5MJT2hqwNgXfG2O+tNZ2cK9LIiIiIhe20kbAvuU/e34ZY8y2onWstW392TERERGRC1VpI2DXGmNCSjiUZ63d7+c+iYiIiFzQylqE/zWwDmftV8F6sKuBG13ol4iIiMgFq6wA9p21trdvgTHmSz/3R0REROSCV1YAa2aMeaFIWW1/dkZERETkYlBWAHuqhLLR/uqIiIiIyMWirJ3wP3CzIyIiIiIXi9Jexi0iIiIifqIAJiIiIuIyBTARERERlymAiYiIiLhMAUxERETEZQpgIiIiIi4rax8wETlHXbVyc5XOO9hVbxITETkXaARMRERExGUKYCIiIiIuUwATERERcZkCmIiIiIjLFMBEREREXKYAJiIiIuIyBTARERERlymAiYiIiLhMAUxERETEZQpgIiIiIi5TABMRERFxmQKYiIiIiMsUwERERERcpgAmIiIi4jIFMBERERGXKYCJiIiIuEwBTERERMRlCmAiIiIiLlMAExEREXGZApiIiIiIyxTARERERFymACYiIiLiMgUwEREREZcpgImIiIi4TAFMRERExGUKYCIiIiIuUwATERERcVmts90BuXh8G35tpc+5dvu3fuiJiIjI2aURMBERERGXKYCJiIiIuMyvAcwYM8wY86UxJsUYc38pdQKMMVuMMWP92RcRERGRc4Xf1oAZY1oBjwDtgdrABmPM59bao0WqvgR84a9+iIiIiJxr/DkC1g1ItNbmWmt/BlYDHX0rGGNuBa4EFvqxHyIiIiLnFH8GsEbAYZ/Phz1lABhjagMTgCfKasQYM8QYk2qMST106JBfOioiIiLiJn8GsBygns/neoDv9OOLQGwJU5KFWGtnWmsjrLURjRo1KquqiIiIyHnBnwFsOfBbY0xNY0wdIBJINcYEeo7fADxojEkAXgbuNcY87sf+iIiIiJwT/LYI31qbZoxZDKwHLBCLE8LuB3pba3sV1DXGxACh1tq/+as/IiIiIucKv+6Eb62dCEwsUjyvhHrx/uyHiIiIyLlEG7GKiIiIuEwBTERERMRlCmAiIiIiLlMAExEREXGZApiIiIiIyxTARERERFymACYiIiLiMgUwEREREZcpgImIiIi4TAFMRERExGUKYCIiIiIuUwATERERcZkCmIiIiIjLFMBEREREXKYAJiIiIuIyBTARERERlymAiYiIiLhMAUxERETEZQpgIiIiIi5TABMRERFxmQKYiIiIiMsUwERERERcpgAmIiIi4jIFMBERERGXKYCJiIiIuEwBTERERMRlCmAiIiIiLlMAExER+f/t3U+opXd9x/HPF6dqFB2KjkhIrTELYzA1ahbpSCFOpAsRcVEZxC5EbCI2tIuKCUhhipSktCoItjXYRSrZaHQRdKE10aaQ2HQsIhEVLKWtFSFTxj8Vytj028U9aW/Gm5Dc3Od77j3n9drMOed5fne+DMPhfZ/nOc+BYQIMAGCYAAMAGCbAAACGCTAAgGECDABgmAADABgmwAAAhgkwAIBhx9Y9AACsw8ffe9/TXvO7f3lqgUnYRo6AAQAME2AAAMMEGADAMAEGADBMgAEADBNgAADDBBgAwDABBgAwTIABAAwTYAAAwwQYAMAwAQYAMEyAAQAME2AAAMMEGADAMAEGADBMgAEADBNgAADDjq17AADYdN+/9e/2te6y23/jgCfhsBBgAPAUffj0W/a17vTltxzwJBx1TkECAAwTYAAAwwQYAMAwAQYAMEyAAQAME2AAAMMEGADAMAEGADBMgAEADBNgAADDBBgAwDABBgAwTIABAAxbNMCq6uaqerCqvlZVpy/adqKq7qqqv6+qs1V185KzAAAcFseW+sFVdUWSdye5LslzkjxUVV/q7vOrXV6S5LbufriqLknyz1X18e7upWYCADgMljwCdirJPd19obt/muT+JCcf29jd3+ruh1dPX5Tk++ILANgGSwbYiSTndj0/fDUo1gAABk9JREFUt3rtcarq+Un+Osl79vohVXXj6hTl2UceeWSRQQEAJi0ZYD9LcnzX8+NJzu/eoapekOTuJH/U3d/Y64d09x3dfW13X3vixC/0GwDAkbPYNWBJ7k3yiaq6Pcmzk1yf5LaqemF3/6Sqjif5XJIPdfffLjgHABxJZ86cGV3HnMUCbHVx/eeTPJCkk3wkOxF2Oslbk3wwyZVJzlTVY8ve2d3/vtRMAACHwZJHwNLdtyW57aKX71pt+0CSDyz59wMAHEZuxAoAMEyAAQAME2AAAMMEGADAMAEGADBMgAEADBNgAADDBBgAwDABBgAwbNE74bOZrr7z6n2t+/QBzwEAR5UjYAAAwwQYAMAwAQYAMEyAAQAME2AAAMMEGADAMAEGADBMgAEADBNgAADDBBgAwDABBgAwTIABAAwTYAAAwwQYAMAwAQYAMEyAAQAME2AAAMOOrXsAAOBweOlXvrGvdT984zUHPMnmE2AAsGHuve+K/S2szx7sIDwhpyABAIYJMACAYQIMAGCYAAMAGCbAAACGCTAAgGECDABgmPuAAXCkffvKVz3tNa/6zrcXmASeOkfAAACGCTAAgGECDABgmAADABgmwAAAhgkwAIBhAgwAYJgAAwAYJsAAAIYJMACAYQIMAGCYAAMAGCbAAACGCTAAgGECDABgmAADABgmwAAAhgkwAIBhAgwAYJgAAwAYJsAAAIYJMACAYcfWPQBrdOb4/tZd/rKDnQMAtowjYAAAwwQYAMAwAQYAMEyAAQAMcxE+AIfC1Xdeva91nz7gOWCCI2AAAMMEGADAMAEGADBMgAEADBNgAADDFg2wqrq5qh6sqq9V1ek9tv9xVT2w2uf6JWcBADgsFrsNRVVdkeTdSa5L8pwkD1XVl7r7/Gr7qSTXdPfJqro0yX1V9eru/u+lZgIAOAyWvA/YqST3dPeFJBeq6v4kJ5N8YbX9hiSfSZLu/kFV/UuSVyb51oIzAbC0M8f3t+7ylx3sHHCILRlgJ5Kc2/X83Oq13dsffJLtSZKqujHJjaun/1lV3z3gOXnaHt7Xqqv2s6hqX39Xkhfn8f//npL3/9/vB4fda/e1at//mjDCe8v6eW85YL/6RBuWDLCfJdn9a9DxJOefxvYkSXffkeSOJQZkc1XV2e6+dt1zAJvFewsHZcmL8O9N8uaqelZVXZLk+iRnq+qFu7a/NUmq6sXZOf3o6BYAsPEWOwLW3Q9X1eeTPJCkk3wkOxF2Ojvh9YUkv1lVD2QnBH+/u/9rqXkAAA6L6u51zwAHrqpuXJ2+Bjgw3ls4KAIMAGCYO+EDAAwTYAAAwwQYR15V3bDr8ZXrnAUAngrXgHHkVdV93X3q4scAz0RVPZrk35L8z2Mvrf7s7n7FeqZiUyx5I1aYUk/wGOCZ+LMkb0ryxSR/1d3/tOZ52CACjE3QT/AYYN+6+5aqelaSNyf506p6fpI7k9y9+p5j2DenIDnyqurH2fkS98rO18I99ri7++Q6ZwM2R1X9SpJPJbmqu1+y7nk42hwBYxP82roHADZXVb06yXuSXJfkniTvWO9EbAJHwABgD1V1U5J3ZudC/E9291fWPBIbRIABwB5Wn4L8ZpIf5aLrS33ammfKKUgA2JtbTbAYR8AAAIa5Ez4AwDABBgAwTIABW6uqvvck215eVV+enAfYHgIM2ApVdUNV3bXH6++qqlt3Pf/XqnpTkjeMDghsFZ+CBLbFrye5JEmq6u4kL9+17X1V9bbV419KclmSXx6dDtgqAgzYeFX1uiTXJvliVf1JktPd/eiuU5B/3t23r/b9cXa+gPl565kW2AZOQQIbrarenuQPk/xOd/9FkoeSfGjXLueS/FZVna2qs0n+prt/O8lNSe4fHxjYCu4DBmy0qnp2kp/3Hm92VXVTd39i9fireyz/enf/wcIjAlvIKUhgo3X3hSSpqrckuTX//753Psktu3Z920VLL03yscUHBLaSAAM2XlW9IDsxdbK7f7h67fVJPpXkNavdfpDkHy9a+g9jQwJbRYAB2+BCkkeTXFVVP8rOJx1fk+Q/du1TSZ570bprZsYDto1rwICtUFWvTPJ7Sa5M8vMkX0/y0e4+t9bBgK0kwAAAhrkNBQDAMAEGADBMgAEADBNgAADDBBgAwDABBgAw7H8BuiVKyzVfuuUAAAAASUVORK5CYII=\n","text/plain":["<Figure size 720x576 with 1 Axes>"]},"metadata":{"needs_background":"light"}}]}]}