JDComment_Processing.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 数据清洗"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#读取数据库数据\n",
    "import pandas as pd\n",
    "from pandas import DataFrame as df\n",
    "Comment_data = pd.read_csv('data/JDComment_data.csv')  # 读取训练数据"
   ]
  },
  {
   "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>用户ID</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>3985</th>\n",
       "      <td>12512647810</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-05 15:44:19</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4002</th>\n",
       "      <td>12511539300</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-05 10:29:41</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4016</th>\n",
       "      <td>12510642159</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-04 22:32:15</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4019</th>\n",
       "      <td>12510365973</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-04 21:05:51</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4059</th>\n",
       "      <td>12507908284</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-04 09:28:01</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4079</th>\n",
       "      <td>12506443899</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-03 18:22:05</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4085</th>\n",
       "      <td>12505863015</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-03 15:28:28</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4138</th>\n",
       "      <td>12503963100</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2019-03-02 22:14:36</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4150</th>\n",
       "      <td>12503323293</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-02 18:49:40</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4193</th>\n",
       "      <td>12501730345</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-02 10:51:11</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4198</th>\n",
       "      <td>12501621470</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-02 10:22:18</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4223</th>\n",
       "      <td>12500373334</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-03-01 20:10:43</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4230</th>\n",
       "      <td>12499846592</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-01 17:20:50</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4259</th>\n",
       "      <td>12498463528</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-01 10:27:22</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4270</th>\n",
       "      <td>12497661916</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>2019-02-28 22:51:40</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4297</th>\n",
       "      <td>12496614190</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-28 17:11:22</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4308</th>\n",
       "      <td>12496073379</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-28 14:26:02</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4326</th>\n",
       "      <td>12495626323</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-28 12:07:22</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4350</th>\n",
       "      <td>12494713311</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员[试用]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-28 04:34:43</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4356</th>\n",
       "      <td>12494103125</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-27 20:42:12</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4358</th>\n",
       "      <td>12494033160</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-27 20:19:50</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4380</th>\n",
       "      <td>12492602153</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-27 12:50:18</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4383</th>\n",
       "      <td>12492325826</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-27 11:26:18</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4392</th>\n",
       "      <td>12491902983</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-27 09:32:34</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4406</th>\n",
       "      <td>12491341929</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>钻石会员</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-26 22:58:05</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4451</th>\n",
       "      <td>12507613386</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>钻石会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-04 07:12:48</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4453</th>\n",
       "      <td>12506858021</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-03 20:31:07</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4454</th>\n",
       "      <td>12506463940</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-03 18:27:33</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4459</th>\n",
       "      <td>12503590022</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员[试用]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-02 20:13:56</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4460</th>\n",
       "      <td>12502670744</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-03-02 15:31:24</td>\n",
       "      <td>Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21281</th>\n",
       "      <td>12489812911</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-26 14:56:06</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21314</th>\n",
       "      <td>12480979132</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-23 18:12:31</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21322</th>\n",
       "      <td>12479983659</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-23 12:55:20</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21336</th>\n",
       "      <td>12477120440</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-22 14:01:11</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21339</th>\n",
       "      <td>12476622619</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-22 11:41:25</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21340</th>\n",
       "      <td>12476586486</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-22 11:31:55</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21341</th>\n",
       "      <td>12476061434</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-22 09:22:21</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21364</th>\n",
       "      <td>12469407179</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-20 11:39:25</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21388</th>\n",
       "      <td>12463806819</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-18 14:48:17</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21393</th>\n",
       "      <td>12463010551</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-18 11:01:05</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21406</th>\n",
       "      <td>12459296362</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-17 00:12:46</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21415</th>\n",
       "      <td>12458062851</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>注册会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-16 16:40:30</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21420</th>\n",
       "      <td>12457401326</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-16 12:58:07</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21432</th>\n",
       "      <td>12454929661</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-15 14:43:26</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21435</th>\n",
       "      <td>12454435350</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员[试用]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-15 11:53:19</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21477</th>\n",
       "      <td>12445385665</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>钻石会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-11 16:27:24</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21517</th>\n",
       "      <td>12440886522</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-08 22:27:38</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21526</th>\n",
       "      <td>12438724077</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-06 22:56:44</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21548</th>\n",
       "      <td>12434815282</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-02-03 11:27:13</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21578</th>\n",
       "      <td>12427204783</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-30 22:25:38</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21584</th>\n",
       "      <td>12426220053</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-30 16:37:35</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21586</th>\n",
       "      <td>12425417926</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-30 11:50:10</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21636</th>\n",
       "      <td>12412565973</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>PLUS会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-26 12:12:23</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21643</th>\n",
       "      <td>12410823020</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-25 20:16:27</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21650</th>\n",
       "      <td>12408914055</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>钻石会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-25 10:49:14</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21662</th>\n",
       "      <td>12405665157</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>铜牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-24 11:33:20</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21672</th>\n",
       "      <td>12402941862</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-23 15:13:28</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21674</th>\n",
       "      <td>12402597927</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>银牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-23 13:36:50</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21698</th>\n",
       "      <td>12397649891</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-22 00:38:15</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21708</th>\n",
       "      <td>12392642426</td>\n",
       "      <td>此用户未填写评价内容</td>\n",
       "      <td>金牌会员</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>2019-01-20 17:24:57</td>\n",
       "      <td>Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>625 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              用户ID        评论内容        会员级别  点赞数  回复数  得分                 购买时间  \\\n",
       "3985   12512647810  此用户未填写评价内容        铜牌会员    0    0   5  2019-03-05 15:44:19   \n",
       "4002   12511539300  此用户未填写评价内容        金牌会员    0    0   5  2019-03-05 10:29:41   \n",
       "4016   12510642159  此用户未填写评价内容        注册会员    0    0   5  2019-03-04 22:32:15   \n",
       "4019   12510365973  此用户未填写评价内容        金牌会员    0    0   5  2019-03-04 21:05:51   \n",
       "4059   12507908284  此用户未填写评价内容        银牌会员    0    0   5  2019-03-04 09:28:01   \n",
       "4079   12506443899  此用户未填写评价内容      PLUS会员    0    0   5  2019-03-03 18:22:05   \n",
       "4085   12505863015  此用户未填写评价内容        注册会员    0    0   5  2019-03-03 15:28:28   \n",
       "4138   12503963100  此用户未填写评价内容      PLUS会员    0    0   3  2019-03-02 22:14:36   \n",
       "4150   12503323293  此用户未填写评价内容        银牌会员    0    0   5  2019-03-02 18:49:40   \n",
       "4193   12501730345  此用户未填写评价内容        银牌会员    0    0   5  2019-03-02 10:51:11   \n",
       "4198   12501621470  此用户未填写评价内容      PLUS会员    0    0   5  2019-03-02 10:22:18   \n",
       "4223   12500373334  此用户未填写评价内容        注册会员    0    0   1  2019-03-01 20:10:43   \n",
       "4230   12499846592  此用户未填写评价内容        金牌会员    0    0   5  2019-03-01 17:20:50   \n",
       "4259   12498463528  此用户未填写评价内容        银牌会员    0    0   5  2019-03-01 10:27:22   \n",
       "4270   12497661916  此用户未填写评价内容        银牌会员    0    0   3  2019-02-28 22:51:40   \n",
       "4297   12496614190  此用户未填写评价内容        金牌会员    0    0   5  2019-02-28 17:11:22   \n",
       "4308   12496073379  此用户未填写评价内容        银牌会员    0    0   5  2019-02-28 14:26:02   \n",
       "4326   12495626323  此用户未填写评价内容        注册会员    0    0   5  2019-02-28 12:07:22   \n",
       "4350   12494713311  此用户未填写评价内容  PLUS会员[试用]    0    0   5  2019-02-28 04:34:43   \n",
       "4356   12494103125  此用户未填写评价内容        金牌会员    2    0   5  2019-02-27 20:42:12   \n",
       "4358   12494033160  此用户未填写评价内容        铜牌会员    0    0   5  2019-02-27 20:19:50   \n",
       "4380   12492602153  此用户未填写评价内容        注册会员    0    0   5  2019-02-27 12:50:18   \n",
       "4383   12492325826  此用户未填写评价内容        注册会员    0    0   5  2019-02-27 11:26:18   \n",
       "4392   12491902983  此用户未填写评价内容        注册会员    0    0   5  2019-02-27 09:32:34   \n",
       "4406   12491341929  此用户未填写评价内容        钻石会员    1    0   5  2019-02-26 22:58:05   \n",
       "4451   12507613386  此用户未填写评价内容        钻石会员    0    0   5  2019-03-04 07:12:48   \n",
       "4453   12506858021  此用户未填写评价内容        铜牌会员    0    0   5  2019-03-03 20:31:07   \n",
       "4454   12506463940  此用户未填写评价内容        注册会员    0    0   5  2019-03-03 18:27:33   \n",
       "4459   12503590022  此用户未填写评价内容  PLUS会员[试用]    0    0   5  2019-03-02 20:13:56   \n",
       "4460   12502670744  此用户未填写评价内容        铜牌会员    0    0   5  2019-03-02 15:31:24   \n",
       "...            ...         ...         ...  ...  ...  ..                  ...   \n",
       "21281  12489812911  此用户未填写评价内容        铜牌会员    0    3   5  2019-02-26 14:56:06   \n",
       "21314  12480979132  此用户未填写评价内容        铜牌会员    0    0   5  2019-02-23 18:12:31   \n",
       "21322  12479983659  此用户未填写评价内容        铜牌会员    0    0   5  2019-02-23 12:55:20   \n",
       "21336  12477120440  此用户未填写评价内容        注册会员    0    0   5  2019-02-22 14:01:11   \n",
       "21339  12476622619  此用户未填写评价内容        银牌会员    0    0   5  2019-02-22 11:41:25   \n",
       "21340  12476586486  此用户未填写评价内容        银牌会员    0    0   5  2019-02-22 11:31:55   \n",
       "21341  12476061434  此用户未填写评价内容        注册会员    0    0   5  2019-02-22 09:22:21   \n",
       "21364  12469407179  此用户未填写评价内容      PLUS会员    0    0   5  2019-02-20 11:39:25   \n",
       "21388  12463806819  此用户未填写评价内容        注册会员    0    0   5  2019-02-18 14:48:17   \n",
       "21393  12463010551  此用户未填写评价内容        金牌会员    0    0   5  2019-02-18 11:01:05   \n",
       "21406  12459296362  此用户未填写评价内容        注册会员    0    0   5  2019-02-17 00:12:46   \n",
       "21415  12458062851  此用户未填写评价内容        注册会员    0    0   5  2019-02-16 16:40:30   \n",
       "21420  12457401326  此用户未填写评价内容        金牌会员    0    0   5  2019-02-16 12:58:07   \n",
       "21432  12454929661  此用户未填写评价内容        金牌会员    0    0   5  2019-02-15 14:43:26   \n",
       "21435  12454435350  此用户未填写评价内容  PLUS会员[试用]    0    0   5  2019-02-15 11:53:19   \n",
       "21477  12445385665  此用户未填写评价内容        钻石会员    0    0   5  2019-02-11 16:27:24   \n",
       "21517  12440886522  此用户未填写评价内容      PLUS会员    0    1   5  2019-02-08 22:27:38   \n",
       "21526  12438724077  此用户未填写评价内容        铜牌会员    0    0   5  2019-02-06 22:56:44   \n",
       "21548  12434815282  此用户未填写评价内容      PLUS会员    0    0   5  2019-02-03 11:27:13   \n",
       "21578  12427204783  此用户未填写评价内容        金牌会员    2    0   5  2019-01-30 22:25:38   \n",
       "21584  12426220053  此用户未填写评价内容        铜牌会员    0    0   5  2019-01-30 16:37:35   \n",
       "21586  12425417926  此用户未填写评价内容        银牌会员    0    0   5  2019-01-30 11:50:10   \n",
       "21636  12412565973  此用户未填写评价内容      PLUS会员    0    0   5  2019-01-26 12:12:23   \n",
       "21643  12410823020  此用户未填写评价内容        银牌会员    0    0   5  2019-01-25 20:16:27   \n",
       "21650  12408914055  此用户未填写评价内容        钻石会员    0    0   5  2019-01-25 10:49:14   \n",
       "21662  12405665157  此用户未填写评价内容        铜牌会员    0    0   5  2019-01-24 11:33:20   \n",
       "21672  12402941862  此用户未填写评价内容        银牌会员    0    0   5  2019-01-23 15:13:28   \n",
       "21674  12402597927  此用户未填写评价内容        银牌会员    0    0   5  2019-01-23 13:36:50   \n",
       "21698  12397649891  此用户未填写评价内容        金牌会员    0    0   5  2019-01-22 00:38:15   \n",
       "21708  12392642426  此用户未填写评价内容        金牌会员    0    0   5  2019-01-20 17:24:57   \n",
       "\n",
       "                                                  手机型号  \n",
       "3985   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4002   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4016   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4019   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4059   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4079   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4085   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4138   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4150   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4193   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4198   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4223   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4230   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4259   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4270   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4297   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4308   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4326   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4350   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4356   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4358   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4380   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4383   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4392   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4406   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4451   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4453   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4454   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4459   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "4460   Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机  \n",
       "...                                                ...  \n",
       "21281       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21314       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21322       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21336       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21339       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21340       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21341       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21364       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21388       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21393       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21406       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21415       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21420       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21432       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21435       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21477       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21517       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21526       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21548       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21578       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21584       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21586       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21636       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21643       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21650       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21662       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21672       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21674       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21698       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "21708       Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机  \n",
       "\n",
       "[625 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Comment_data[Comment_data['评论内容'] == '此用户未填写评价内容' ]#查看评论前几行数据"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "填充缺省值以及删除第一行"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "用户ID    False\n",
       "评论内容    False\n",
       "会员级别    False\n",
       "点赞数     False\n",
       "回复数     False\n",
       "得分      False\n",
       "购买时间    False\n",
       "手机型号    False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Comment_data.drop(index=0,axis=0) #删除第一行\n",
    "Comment_data.isnull().any()#查看哪些列存在空值"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "用户ID    False\n",
       "评论内容    False\n",
       "会员级别    False\n",
       "点赞数     False\n",
       "回复数     False\n",
       "得分      False\n",
       "购买时间    False\n",
       "手机型号    False\n",
       "dtype: bool"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Comment_data[Comment_data.isnull().values==True]\n",
    "for col in Comment_data:\n",
    "    if col == \"会员级别\" or col == \"评论内容\":\n",
    "        Comment_data[col].fillna('', inplace=True)\n",
    "    elif col == \"用户ID\":\n",
    "        Comment_data[col].fillna('00000000000', inplace=True)\n",
    "    else:\n",
    "        Comment_data[col].fillna(0, inplace=True)\n",
    "Comment_data.isnull().any()#查看是否进行了填充"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "(DataFrame筛选数据与loc用法)[https://blog.csdn.net/junbujianwpl/article/details/70473659]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "21091\n"
     ]
    }
   ],
   "source": [
    "#Comment_data[Comment_data.评论内容.duplicated()].count()\n",
    "#print(Comment_data[Comment_data.评论内容.duplicated()].count())\t# 最后两项重复\n",
    "#print(len(Comment_data[Comment_data.评论内容 == '此用户未填写评价内容']))\n",
    "Comment_data[Comment_data['评论内容']==\"此用户未填写评价内容\"] = \"\"#清空未评价信息\n",
    "print(len(Comment_data[Comment_data['评论内容']!=\"\"])) #统计有效评论数"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 数据可视化及分析\n",
    "### 会员等级编码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[6 0 0 ... 5 7 0]\n",
      "['PLUS会员' 'PLUS会员[试用]' '企业会员' '注册会员' '金牌会员' '钻石会员' '铜牌会员' '银牌会员']\n",
      "[0 0 0 ... 3 3 3]\n",
      "['Apple iPhone 8 Plus (A1864) 256GB 金色 移动联通电信4G手机'\n",
      " 'Apple iPhone 8 Plus (A1864) 256GB 银色 移动联通电信4G手机'\n",
      " 'Apple iPhone 8 Plus (A1864) 64GB 深空灰色 移动联通电信4G手机'\n",
      " 'Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机']\n"
     ]
    }
   ],
   "source": [
    "from numpy import array\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "from sklearn import preprocessing\n",
    "# 会员等级分类\n",
    "data = Comment_data[Comment_data['会员级别']!='']\n",
    "value1 = array(data['会员级别'])\n",
    "phone_type = Comment_data[Comment_data['手机型号']!='']\n",
    "value2 = array(data['手机型号'])\n",
    "#print(values)\n",
    "# 手机型号分类\n",
    "#整数编码\n",
    "level_encoder = LabelEncoder()\n",
    "phone_type_encode = LabelEncoder()\n",
    "integer_level_encoded = level_encoder.fit_transform(value1)\n",
    "integer_type_encoded = phone_type_encode.fit_transform(value2)\n",
    "#print(label_encoder.get_params(False))\n",
    "print(integer_level_encoded)\n",
    "userLevel = level_encoder.classes_\n",
    "print(level_encoder.classes_)\n",
    "print(integer_type_encoded)\n",
    "phone_type = phone_type_encode.classes_\n",
    "print(phone_type_encode.classes_)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 购买时间处理"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "无效数据有625条\n",
      "['2017' '2018' '2019']\n",
      "[2 1 2 ... 2 2 2]\n"
     ]
    }
   ],
   "source": [
    "hourList = []\n",
    "month = []\n",
    "year = []\n",
    "useLessData = 0\n",
    "for i in Comment_data['购买时间']:\n",
    "    try:\n",
    "        #print(str(i))\n",
    "        hourList.append(str(i).split(' ')[1].split(':')[0])\n",
    "        month.append(str(i).split(' ')[0].split('-')[1])\n",
    "        year.append(str(i).split(' ')[0].split('-')[0])\n",
    "    except:\n",
    "        useLessData += 1\n",
    "print('无效数据有%s条'%useLessData)\n",
    "phone_year_encode = LabelEncoder()\n",
    "year_encoded = phone_year_encode.fit_transform(year)\n",
    "print(phone_year_encode.classes_)\n",
    "print(year_encoded)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"ab9bd350afe94f9088e4bf416a8f7a87\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_ab9bd350afe94f9088e4bf416a8f7a87 = echarts.init(document.getElementById('ab9bd350afe94f9088e4bf416a8f7a87'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_ab9bd350afe94f9088e4bf416a8f7a87 = {\n",
       "    \"series_id\": 238433,\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"left\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18,\n",
       "                \"color\": \"#FF0000\"\n",
       "            },\n",
       "            \"text\": \"\\u624b\\u673a\\u8d2d\\u4e70\\u65f6\\u6bb5\"\n",
       "        }\n",
       "    ],\n",
       "    \"dataZoom\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"type\": \"slider\",\n",
       "            \"start\": 50,\n",
       "            \"end\": 100,\n",
       "            \"orient\": \"horizontal\"\n",
       "        }\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"data\": [\n",
       "                532,\n",
       "                264,\n",
       "                120,\n",
       "                115,\n",
       "                60,\n",
       "                68,\n",
       "                144,\n",
       "                376,\n",
       "                758,\n",
       "                1175,\n",
       "                1509,\n",
       "                1358,\n",
       "                1330,\n",
       "                1213,\n",
       "                1121,\n",
       "                1371,\n",
       "                1097,\n",
       "                1240,\n",
       "                1102,\n",
       "                1116,\n",
       "                1355,\n",
       "                1380,\n",
       "                1328,\n",
       "                959\n",
       "            ],\n",
       "            \"markPoint\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"type\": \"bar\",\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 238433,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"left\": \"95%\",\n",
       "        \"show\": true,\n",
       "        \"top\": \"center\",\n",
       "        \"orient\": \"vertical\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\",\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"inverse\": false,\n",
       "            \"nameGap\": 25,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"type\": \"value\",\n",
       "            \"boundaryGap\": true,\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"rotate\": 0\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"0\\u65f6\",\n",
       "                \"1\\u65f6\",\n",
       "                \"2\\u65f6\",\n",
       "                \"3\\u65f6\",\n",
       "                \"4\\u65f6\",\n",
       "                \"5\\u65f6\",\n",
       "                \"6\\u65f6\",\n",
       "                \"7\\u65f6\",\n",
       "                \"8\\u65f6\",\n",
       "                \"9\\u65f6\",\n",
       "                \"10\\u65f6\",\n",
       "                \"11\\u65f6\",\n",
       "                \"12\\u65f6\",\n",
       "                \"13\\u65f6\",\n",
       "                \"14\\u65f6\",\n",
       "                \"15\\u65f6\",\n",
       "                \"16\\u65f6\",\n",
       "                \"17\\u65f6\",\n",
       "                \"18\\u65f6\",\n",
       "                \"19\\u65f6\",\n",
       "                \"20\\u65f6\",\n",
       "                \"21\\u65f6\",\n",
       "                \"22\\u65f6\",\n",
       "                \"23\\u65f6\"\n",
       "            ],\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"category\",\n",
       "            \"nameGap\": 25,\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"backgroundColor\": \"#7EC0EE\",\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"borderWidth\": 0,\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"borderColor\": \"#333\"\n",
       "    },\n",
       "    \"animation\": true,\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"orient\": \"horizontal\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "myChart_ab9bd350afe94f9088e4bf416a8f7a87.setOption(option_ab9bd350afe94f9088e4bf416a8f7a87);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.bar.Bar at 0x20faa850be0>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import random\n",
    "from pyecharts import Bar\n",
    "attr = [\"{}时\".format(i) for i in range(24)]\n",
    "v1 = [hourList.count(str(_).rjust(2,'0')) for _ in range(24)]\n",
    "bar = Bar(\"手机购买时段\",title_color='#FF0000',background_color='#7EC0EE')\n",
    "bar.add(\"\", attr, v1, is_label_show=True, is_datazoom_show=True)\n",
    "bar"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "分析一天中不同时段消费者的手机购买情况，可以分析得出，大部分消费者在午时（10-12时）和晚上（20-22时）出现了消费高峰期，在此时段顾客购买商品的概率更大，他们浏览商品的机会更多"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PLUS会员\n",
      "625\n",
      "PLUS会员[试用]\n",
      "625\n",
      "企业会员\n",
      "625\n",
      "注册会员\n",
      "625\n",
      "金牌会员\n",
      "625\n",
      "钻石会员\n",
      "625\n",
      "铜牌会员\n",
      "625\n",
      "银牌会员\n",
      "625\n",
      "[[], [747, 995, 981, 256, 292, 396, 252, 304, 232, 372, 1404, 404], [12, 151, 83, 4, 4, 0, 4, 4, 8, 4, 24, 0], [76, 28, 4, 0, 4, 0, 4, 0, 0, 8, 4, 24], [360, 502, 236, 0, 0, 0, 0, 0, 0, 0, 0, 20], [572, 616, 651, 224, 228, 352, 208, 196, 204, 228, 912, 276], [372, 426, 354, 136, 156, 272, 140, 116, 104, 268, 784, 220], [285, 496, 228, 0, 0, 0, 0, 0, 0, 0, 0, 8], [653, 782, 553, 176, 136, 300, 224, 212, 156, 124, 384, 156]]\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "\n",
    "v = [[]]\n",
    "for level in level_encoder.classes_:\n",
    "    print(level)\n",
    "    df = Comment_data[Comment_data['会员级别'] == level]\n",
    "    hourList = []\n",
    "    month = []\n",
    "    for i in df['购买时间']:\n",
    "        try:\n",
    "            #print(str(i).split(' ')[0].split('-')[1])\n",
    "            month.append(str(i).split(' ')[0].split('-')[1])\n",
    "        except:\n",
    "            useLessData += 1\n",
    "    print(useLessData)\n",
    "    data = []\n",
    "    for _ in range(1, 13):\n",
    "        if(_ < 10):\n",
    "            data.append(month.count('0'+str(_)))\n",
    "        else:\n",
    "            data.append(month.count(str(_)))\n",
    "    #print(data)\n",
    "    v.append(data)\n",
    "print(v)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PLUS会员所占比例31.46%\n",
      "PLUS会员[试用]所占比例1.41%\n",
      "企业会员所占比例0.72%\n",
      "注册会员所占比例5.30%\n",
      "金牌会员所占比例22.13%\n",
      "钻石会员所占比例15.87%\n",
      "铜牌会员所占比例4.82%\n",
      "银牌会员所占比例18.28%\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"f141f3b6111d4b82afd1783d31133f52\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_f141f3b6111d4b82afd1783d31133f52 = echarts.init(document.getElementById('f141f3b6111d4b82afd1783d31133f52'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_f141f3b6111d4b82afd1783d31133f52 = {\n",
       "    \"series_id\": 6960797,\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"inverse\": false,\n",
       "            \"nameGap\": 25,\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"splitLine\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"type\": \"value\",\n",
       "            \"boundaryGap\": true,\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"formatter\": \"{value} \",\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                },\n",
       "                \"rotate\": 0\n",
       "            },\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false\n",
       "            },\n",
       "            \"show\": true,\n",
       "            \"boundaryGap\": true,\n",
       "            \"axisLabel\": {\n",
       "                \"interval\": \"auto\",\n",
       "                \"rotate\": 0,\n",
       "                \"margin\": 8,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 12\n",
       "                }\n",
       "            },\n",
       "            \"axisTick\": {\n",
       "                \"alignWithLabel\": false\n",
       "            },\n",
       "            \"nameTextStyle\": {\n",
       "                \"fontSize\": 14\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"\\u4e00\\u6708\",\n",
       "                \"\\u4e8c\\u6708\",\n",
       "                \"\\u4e09\\u6708\",\n",
       "                \"\\u56db\\u6708\",\n",
       "                \"\\u4e94\\u6708\",\n",
       "                \"\\u516d\\u6708\",\n",
       "                \"\\u4e03\\u6708\",\n",
       "                \"\\u516b\\u6708\",\n",
       "                \"\\u4e5d\\u6708\",\n",
       "                \"\\u5341\\u6708\",\n",
       "                \"\\u5341\\u4e00\\u6708\",\n",
       "                \"\\u5341\\u4e8c\\u6708\"\n",
       "            ],\n",
       "            \"nameLocation\": \"middle\",\n",
       "            \"type\": \"category\",\n",
       "            \"nameGap\": 25,\n",
       "            \"axisLine\": {\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"left\": \"auto\",\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18,\n",
       "                \"color\": \"#20B2AA\"\n",
       "            },\n",
       "            \"text\": \"\\u6708\\u6d88\\u8d39\\u4e0e\\u4f1a\\u5458\\u7b49\\u7ea7\\u5206\\u6790\"\n",
       "        }\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    747\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    995\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    981\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    256\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    292\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    396\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    252\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    304\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    232\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    372\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    1404\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    404\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"PLUS\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    12\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    151\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    83\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    8\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    24\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    0\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"PLUS\\u4f1a\\u5458[\\u8bd5\\u7528]\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    76\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    28\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    8\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    4\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    24\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u4f01\\u4e1a\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    360\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    502\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    236\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    20\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u6ce8\\u518c\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    572\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    616\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    651\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    224\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    228\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    352\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    208\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    196\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    204\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    228\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    912\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    276\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u91d1\\u724c\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    372\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    426\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    354\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    136\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    156\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    272\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    140\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    116\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    104\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    268\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    784\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    220\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u94bb\\u77f3\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    285\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    496\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    228\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    0\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    8\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u94dc\\u724c\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        {\n",
       "            \"showSymbol\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"width\": 1,\n",
       "                    \"type\": \"solid\",\n",
       "                    \"curveness\": 0,\n",
       "                    \"opacity\": 1\n",
       "                }\n",
       "            },\n",
       "            \"markPoint\": {\n",
       "                \"data\": [\n",
       "                    {\n",
       "                        \"type\": \"average\",\n",
       "                        \"label\": {\n",
       "                            \"normal\": {\n",
       "                                \"textStyle\": {\n",
       "                                    \"color\": \"#fff\"\n",
       "                                }\n",
       "                            }\n",
       "                        },\n",
       "                        \"symbol\": \"pin\",\n",
       "                        \"name\": \"mean-Value\",\n",
       "                        \"symbolSize\": 50\n",
       "                    }\n",
       "                ]\n",
       "            },\n",
       "            \"step\": false,\n",
       "            \"symbolSize\": 4,\n",
       "            \"seriesId\": 6960797,\n",
       "            \"markLine\": {\n",
       "                \"data\": []\n",
       "            },\n",
       "            \"data\": [\n",
       "                [\n",
       "                    \"\\u4e00\\u6708\",\n",
       "                    653\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e8c\\u6708\",\n",
       "                    782\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e09\\u6708\",\n",
       "                    553\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u56db\\u6708\",\n",
       "                    176\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e94\\u6708\",\n",
       "                    136\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516d\\u6708\",\n",
       "                    300\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e03\\u6708\",\n",
       "                    224\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u516b\\u6708\",\n",
       "                    212\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u4e5d\\u6708\",\n",
       "                    156\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u6708\",\n",
       "                    124\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e00\\u6708\",\n",
       "                    384\n",
       "                ],\n",
       "                [\n",
       "                    \"\\u5341\\u4e8c\\u6708\",\n",
       "                    156\n",
       "                ]\n",
       "            ],\n",
       "            \"name\": \"\\u94f6\\u724c\\u4f1a\\u5458\",\n",
       "            \"smooth\": false,\n",
       "            \"label\": {\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"position\": \"top\"\n",
       "                }\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"type\": \"line\",\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"borderWidth\": 0,\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"borderColor\": \"#333\"\n",
       "    },\n",
       "    \"backgroundColor\": \"#F0F8FF\",\n",
       "    \"toolbox\": {\n",
       "        \"left\": \"95%\",\n",
       "        \"show\": true,\n",
       "        \"top\": \"center\",\n",
       "        \"orient\": \"vertical\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"title\": \"\\u4e0b\\u8f7d\\u56fe\\u7247\",\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"left\": \"right\",\n",
       "            \"top\": \"7%\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"PLUS\\u4f1a\\u5458\",\n",
       "                \"PLUS\\u4f1a\\u5458[\\u8bd5\\u7528]\",\n",
       "                \"\\u4f01\\u4e1a\\u4f1a\\u5458\",\n",
       "                \"\\u6ce8\\u518c\\u4f1a\\u5458\",\n",
       "                \"\\u91d1\\u724c\\u4f1a\\u5458\",\n",
       "                \"\\u94bb\\u77f3\\u4f1a\\u5458\",\n",
       "                \"\\u94dc\\u724c\\u4f1a\\u5458\",\n",
       "                \"\\u94f6\\u724c\\u4f1a\\u5458\"\n",
       "            ],\n",
       "            \"show\": true,\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"orient\": \"horizontal\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "myChart_f141f3b6111d4b82afd1783d31133f52.setOption(option_f141f3b6111d4b82afd1783d31133f52);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.line.Line at 0x20fab762f98>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Line\n",
    "import numpy as np\n",
    "\n",
    "attr = [\"一月\", \"二月\", \"三月\", \"四月\", \"五月\", \"六月\",'七月','八月','九月','十月','十一月','十二月']\n",
    "#plus = Comment_data[Comment_data['会员级别']=='PLUS会员']\n",
    "#v1 = [month.count(str(_)) for _ in range(0, 12)]\n",
    "#v2 = [55, 60, 16, 20, 15, 80]\n",
    "line = Line(\"月消费与会员等级分析\",title_color='#20B2AA',background_color='#F0F8FF')\n",
    "count = 1\n",
    "saleSum = 0.0\n",
    "for level in level_encoder.classes_:\n",
    "    line.add(level, attr, v[count], mark_point=[\"average\"], legend_pos ='right',legend_top ='7%')\n",
    "    saleSum += np.mean(v[count])\n",
    "    count += 1\n",
    "count = 1\n",
    "for level in level_encoder.classes_:\n",
    "    print(\"%s所占比例%.2lf%%\"%(level, np.mean(v[count])*100 / saleSum))\n",
    "    count += 1\n",
    "    \n",
    "#line.add(\"PLUS会员\", attr, v1, mark_point=[\"average\"])\n",
    "\n",
    "#line.add(\"商家B\", attr, v2, is_smooth=True, mark_line=[\"max\", \"average\"])\n",
    "line"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "通过分析上图可知，不论是哪种会员，他们在三月份前后以及十二月份前后购买手机的可能性最大，这可能大家新的一年想换一个新手机的想法有关，在这些月份进行手机推荐可能会有不错的收获。并且分析不同会员的购买情况可知，他们购买的频次降序排列为PLUS会员》金牌会员》银牌会员=钻石会员》PLUS会员（试用）》企业会员。\n",
    "分析原因，大致是因为PLUS会员大部分都属于高消费群体，他们购买这些价值昂贵的手机概率更大。因此，大致可以推断，这款手机的主要消费对象是京东商城的PLUS会员（31.00%）、金牌会员（21.87%）、银牌会员（18.52%）。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "from wordcloud import WordCloud,STOPWORDS,ImageColorGenerator\n",
    " \n",
    "data = Comment_data['评论内容'].tolist()\n",
    "dataStr = ','.join(data)\n",
    "#print(','.join(data))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "注:此处可能因评论数据量太大，出现数据溢出问题，解决方案参照[处理Jupyter Notebook报错：IOPub data rate exceeded](https://blog.csdn.net/LaoChengZier/article/details/80705298)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAQsAAAD8CAYAAABgtYFHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAGKZJREFUeJzt3Xl8FPXBx/HPbu6LIyBgIJwipwoIgoiAJyBtVaxSilbRetAqwaOPWi2CR62PgCD1AqugtqAgeHBEigSCHHIf4QjhyEEScpA7m2Ozu88fgW2p9GEUyGQy3/frxes1YXdnv9kk3/3Nb2Z2HD6fDxGRs3GaHUBErEFlISKGqCxExBCVhYgYorIQEUNUFiJiiMpCRAxRWYiIISoLETEk0OwAJ+kwUpELz3EuD9bIQkQMUVmIiCEqCxExRGUhIoaoLETEEJWFiBiishARQ1QWImKIykJEDFFZiIghKgsLmJe6jDEbnwcgtTybzzJWAfDu4cWMSIzj3s1TGJEYx4jEOJZnrz/tsSMS46jwVPmXRyTGEZ+9kRGJcfxl/zym7J0DwINbXvE/F4DX58Wno/Dl36gs6rkRiXEARAWFszZvO19lJXLLxQMB2Fd8hJ/HXMsDHX7B5J4P0SKkKTsKk3+wjrCAECYnzfZ/PTNlAY2DIrmpVX8OlKQB8HCnUWS4cvz38QGOczuVQBoYlUU9t+Sa16nwVOH1eRlyUR+Gt7qaJZlr/bd/m7OFv+yfhxMHT3QZS0pZhv+2U0UzIjGOyT0fYsXgmfy1zx9YMXgmXaPaEeBwMrf/JIrdZbx/5Atiw1sS6AgA4N3Dn9ftNyr1nqOeXDekXoSwouoaD8GBtX/gPh84zjAYKC2vJCoi9IyP93i8BASc+T3j1Pq8Ph9Oh4Pj+SVEN4nA7fYQERZ83r4HqTPnNFSsL6eoiwEr1u9j8nvxtLu4KXmF5cydMpYZf1/Da3E/B+DLNUl4fT5CgwPZuCeVIVdeQoeYaGpqvLy5IJE/3n8TOQWlJGxJ4Zc3XsGarYeYs2QjH710N9M+Wk1KRj5/ffoOwkJri2DMs/MAuK5vZxK2pgDwxN3X0Tm2OanZhbRqHsXjU5cA8P1HT5jwikhd0shCxD70eRYicuGpLETEEM1ZyDmJX7mH16Ytx+l0cP+9g+nZvTXR0RGsXrOfNYkH+HD2A0x55Uv69+vIa9OW89ILo+jfryMASfsyade2GZmZheTmleB0Onjxz18BkPDN02Z+W3IGmrMQsQ/NWYjIhaeyEBFDVBYiYojKQkQM0d4QC1iW+Rf2lyQwpMWD7Cv5lr7Rd9Cj8Y1sK1hCj8Y3EeAIZGbyrVzeZAQF1Rl0ihzAnqJ4OkcNIsO1i15Nf06AI4jOUddwvPIgB0rWEuIM5+rmY3E4nKSX7+BEVTp9om/D46vhjQMjub7leJoGt+bzjOe5tc0kMl17ufqiscxKHsXI1s/QrdF1AGwv+ILVOe9wZ9tXKa8ppLQmn3W5H9A2ojfdGg0huyKZ3UUriA2/nAzXboa2fIgSdx4nqlLpHDWIVcdnMbb9m1R4ilmRNZUKTzFPdYtn6v7h/u//qW7fMHX/MP+y1+dh+oFbALih1e/x+jwk5LwLQOeoa2gd3oM1ObO5vuV4mgTHsKconpTS9fyq3TSaBrfmUOkGvHg4ULyGMe2nsy73Qw6VbWBcxzl1/JO1Fu0NaaCm7h/GU92+MTvGj1blKSMkINLsGA3VOe0NUVmI2Id2nYrIhaeyEBFDNMFZT/T40xvsfelxALo//wYjL+/Cst3JdLwomiN5BTw8tD/vrfme4ZddSq/Yi1m17xDjBl3JxPnLeGXUzaxNPsITN1/LDVPf55MH7+LuOZ/51z2oc3u+S0kFYN4Dd9KpRTSDXn2PZ0cO5Z6re/ufE+CvY3/Bo3//itv79GDJ9r2nZfznkw+weHsS7yR8D8CQLh1oHhlBm6aNmLlqA1snPcqqfYd4ZlE8AP946FcEBTq58+1/sO/lx3lr9SbeWr2R2OjGdI9pSVZRCQ7g+m6daNesCY8vWMazI4fy6rI1jLy8Czd2v4THFyz7wWt1z9W9ufvq3gyb/gEv3nYTX+3cR2llFcnH83lkaH8GdW7P3XM+5a27b+X3n3xJTJNGPDK0P5e1ackzi+JZ8ug95/VnZxeas7CA7s+/wZ4X4whw1p+BYHZRKS0bR+J0OKh01xAadOb3nVeXreHZkUN/0nMcKyymTdPGP+oxWUUlxDRp9JOezwY0wSkihmiCU0QuPJWFRa3ZnMKkmUvNjiE2orKwoMdeWsjQqzrzYtzPzI7yE/z/W5zpuaP8y15vqf8xNZ48yipWApCcEcPR7EHkFD6N11dO1onxJGfE+B9X4lpMckYMB4+1O7Umajy5uD2ZlLqWUlDy1vn8hmxDZWFB25LSGTh6Gqs3HTQ7yk9w+mbz8YKJp/2hNwq/DYDyytU4nVH+xxwviCMz/z5KXV/RvtVq2rVaefKWAEpdX562zrDgfjSJHEdgQEtyC5+juHwhAEEBrXFVbSCv+JXTnlOM0a5TC9rw6ZNmRzhvWkXPoLj8X7t5azzZABSWfkBwYCeCAtvhqvyO0OArqK45RGT4Lbgq1xES1BUAhyOUti2/Jiz4Sv863J7aa6e0b5WA0xFBecWqk7f4cFV9R7uWKyit0Cbcj6W9IRa0NCGJnPwSHrhzoNlRzgt3TSpBge3/y62110bzektwOs+8S9Trq8DpCPvBY87E4y0iwNnkHNJamvaG2E1WbhH33HaV2THOm/9eFHDq9/u/FQXwH0Xxr8eciY2L4pxpZGFBWbnF/G3hBjrGNmfMz/ridOqapGKIRhZ206xJBN+s209SSraKQuqMysKivD4fGdmFZscQG1FZWFDCpoNc2/cSPpl6L2WuKrPjiE2oLCwoKjKU8NAgACLDQ0xOI3ahsrCgiLBgXJVus2OIzWhviAUNHD3Nf2BWWXkVkREaXYghOkXdbmo8Xgb/+o0GdSSn1AntOrWbwIDaH9uWPWm43R6T04hdqCwsaODoaQDMXbxJx1lInVFZWNiOfccICNCPUOqG5ixE7ENzFna0asMBsyOIzagsLKptTDRfrNptdgyxEW2GWFBKai6d27cwO4ZYjzZD7KZz+xas337E7BhiMxpZiNiHRhZ2M3D0NJYmJDFw9DSqqmvMjiM2obKwqOCgAABCgvWZy1I3VBYW9Nz44UyetZznxg+nqLTC7DhiE3pbsiBXRZVOIpM6p5GFBZWWVzH2ybnknig9+51FzhOVhQXdd8cAjh47QYtmUWe/s8h5ol2nFlRY7CIw0ElURKjZUcRatOvUbhbG72D6B6vNjiE2o5GFBZ36PAuAT2fcT+zFTU1MIxaij9WzG4/Hy/X3vsnqeRNwOB04HfoAHDFEmyF243Q6ee6RYXi9PhWF1BmVhQX99ZO1TJ61nPcXbTA7itiIysKCHrtnCGGhQWxLSjc7itiI5iwsKHHLIf/y4H6XmJhELEYTnCJiiCY47Wbg6GlUu2u4c8LfzI4iNqKysKgDR3K4bsClusiQ1BmVhQX16RHL7E/XM3pEHwpLXGbHEZvQnIWIfWjOwm5mzEtg4Ohp3BWnOQupOyoLC/ps+XYAjh0vwls/RoZiAyoLCxp1cy96dWvDt/Mm4POqLKRuaM7CwlwV1YSHBZsdQ6xDcxZ2c+oU9VvHv2dyErETjSws6FB6Huu2HCYqIoRfDu9tdhyxDo0s7OaSthdx36gBzF28yewoYiMaWVjQ9r0ZREWEAPgvkLx3VwY9roj136ekuIJGjcN45Y+LOJZeQGbGCVq0bEyT6AhGjelP8xaNuLRbDPl5pTRrHkVeTjHffL2TwTd2p7ysijXfJNGlR2tax0bTtWdr8vNKKS4sZ9v3Rxh5+5Xcfv1rrNw8ibenxtOlR2tee2EJKzdPMuX1EMN0IpmIGKLNEBG58FQWFnf02AmzI4hNqCwsauyTcwHo0KaZuUHENjRnYUGDxkz3Ly+dPZ4mUWFneYQX38mX2IGD/3yP8PrKcTrCqd2kPfWj+Ombt16fC6cj9AfPI6bTnIXdPPPQzUy89zq+m//E/1sUxa7lAJRXbeNA1mAOZA2mvGo7ruqdlFV+R1bhFAC8Xhe70ztS5PqaXeltOZxzF6n5D+P2HMdHDeVVW06uZwuHckYBUFLxT//jawvGS3VNOifKPsHpCMeHD1dV7TksHm8ZpZXr8Hh1bVYr08jCoqqqawgJDjQ7hliLRhZ2lJ5VwDvz15kdQ2xEZWFBSxOSaBsTzZbdaWZHERvRZogFnTqR7MW4kfTp0ZboxuEmJxKL0BGcduOuqf2Q3tLyKhWF/Bias7CbIWNnEBQYoKKQOqWysKgZ8xKYMS+BnBOn74701HhIWp8MwN4NB3l86GTS9h1j49JtvPvUx/h8vtp/Xh81bg/L5nwLwNqFG9n/fe2VznYm7GX7qj2UF9d+cvip+wCk7c887fneeGQOPp+PYynZpO07RlFuCQXZRf7bC7KL+OjFRdwc/GtSth9lwqBJHNx2hOSth8//iyIXlDZDLGjg6Gls+PRJs2OI9WjOwm5SUnP9p6aL/Aias7Cbe5/+mPEvLDA7htiMysKidh3IZODoaZSWV5odRWxCxwtblOYspK5pZGFBa/8+kYpKNzv3H/vJ63j5w5X+5X7jptNv3HT/8qTZK3BVVuOqcpNXVMYXiXuo8XgBmL9y+xnXt2TN7tPW80n8VgCeevNL+o2bzpZ96fQbN53sEyX4fDD2hY9ZlLCLKe/Hc8Ojb/OHWV/95O9F6obKwoJeeiuekQ+9Q69ubc55Xb97fZF/Oe6NJUz+7XBuHdyT8NBgwkOC2JWSBUBgQO2vypib+5z2+KXf7QXgz/NW+f9v0uwV/uWpE27lkVHX0K97WwA+XrEVhwP6dInFe/ICSSvffIQ+XdqwemvKOX8/cuFoM8SCDqfn0fsciuLUu/+XiUls+fCJ027buj+DkvJKprwfz/7UXJ7+zQ2cKC4HYO6yzdw38qrT7v+zQT0A2PLhE/xp9gpeemgEANsOZPDUm18yoGd7wkICSU7LZfrE29i0J5X5K7eTnJbDI7cP5GB6LgFOJw6Hg+v7dv7J35NceNp1akGbdqbicMDm3ak8ds9Qs+OIdWjXqd0cSsulqrqGK7qe+2aIiFHaDLGgt/+xDqfTwT+mjzM7itiIRhYWFBwUyC+uv4yDR3PMjiI2ojkLC8ovLOP7XbUffHPzNV0JCgowOZFYhOYs7KZ500j2HMxi5NAeBAToRyh1Q79pFrQwfgdffbubmfPW4HSe05uFiGHaDLEgV0U1+w4fp2/PtlRUugkLDTI70g9UVroJDQ0i+3gxCz/fTMzFTYmMDOG1qct5efIonp+8GICElU+TfbyY5s0iCQoK4Pph/4vP52P+x48AsCfpGG1aNyUyMhQHEBQUyPqNKdx0Yw8WL9lG/6s6Mv6xj3jh+VvpdXlb1q5L5pbhl2vT7Mx0irqIGKI5C7tZGL+DgaOnMeGlhWZHERtRWVhQ00a1VyHr2qkV9WNgKHagsrCgrh1bARDdOByH5jf5fHMSBWUus2M0eJqzEMsrLK/gdx98wfzHxpgdpb7TnIUdjX9hAa++t/Lsd7SBvcdyOJpXYHaMBk/nhljQ76d8SpeOLRk5pAcej9f2B2Y99fdllFVWmx2jwdNmiEV99e1uDqbm8dQDN5gdxXQbDqbRNeYioiN10aWz0HEWYm8HsvIoclUw4JK2Zkep71QWdjPxlUUMv7Y7gYFObhzY1ew4Yh2a4LSbzJximjWNIDI8lLLyKrPjmC63uIz4Xclmx2jwVBYW9MvhvTiSkU9a1glCgjVH3aJxJJfFtjI7RoOnzRCxvIpqN65qN800wXk22gyxq6UJSWZHqBemfL5KRVEHVBYWNHD0NL5Zt5+gQJ2GDbB0xwG2Hc00O0aDp7KwoD7dY3ltzj8Zdm03s6PUC7HNmuCqcpsdo8HTnIUF+Xzg8/n0KVknrdyTQoDTyQ09Opkdpb47p18YTaVb0EdffE+jyFAAbr/pCpPTmG/bkWOM6NXF7BgNnjZDLOi9Bd/RMbY5r7+/6ux3toGQoEB6tYsxO0aDp80QC9q0M5UDR3Lo2rElA3q1NzuO6VLzCmkUFqJzQ85Oh3vb1anCsLvqGg/B2jNkhI6zsJtZH69l4OhpJHx/0Owo9YKKom6oLCzosXuGEBYaxLakdLOj1AtFrkqzI9iCNkMsKHHLIf/y4H6XmJhELEZzFmJvPf/nDeaNv4srO7Q2O0p9pzkLuxk4ehrV7hrunPA3s6PUGzo35MJTWVjUgSM5XDfgUtxuj9lRTLfpxd+RV1JudowGT2VhQX16xDL70/WMHtGHwhJdL+NwbgEdWjQ1O0aDpzkLC0vPKqBtTLTZMUy3ZOtebu/bw+wYVqBzQ+zmxvtmEREWDMCX7zxschrz/XNPChdFRTCoS3uzozRoKgsL+ui131BY6mL2gvVmR6kXJgy7hiJXhdkxGjxthljUzx9+l6/fe8TsGPXC9tRM+rTXblMDdJyF2Nuu9Gwua9NKn+9xdjrOwm6u/82bZkeoVxqHhZJVVGJ2jAZPZWFBF1/UyL9cqY+TA6DG4zU7QoOnsrCgP44f5j8YKzQkyOQ05nt5yWrmJm4zO0aDpzkLsbyEfYfp1zGWyNBgs6PUd5rgtJuNO49yda8OZscQ69EEp93MmJvA3pRsBo2ZbnYUsRGNLCzM5wN3TQ3BQTq2TgzRZoiIGKLNEDsa++RcsyOIzWhkYWHb92XQp3us2THEOrQZIiKGaDNERC48lYVYQmF+qdkRbE9lIZaw8MN1ZkewPZWFWELa4VyzI9ieJjhF7EMTnNLwjb9jltkRbE8jCxH70MhCGr7CE2VmR7A9lYVJthduYGryH3/w/yllewGo8Pzw4kErshed9vXOou9/cJ/SmmL/ctyOMf/1+d87/Bq7i7Yw+8jr/v+bl2p8qP/N8cX+5cLqfNbmxQMwK+Ul9pfsIv745ye/fhHfvw0cV2QvOu3rf5dTmelf/s/7rFm+23A2uTBUFiaI2zGGIncBw1qNYkP+t6zPX+X/w24T1oEDpbuZmzqTLQWJJBX/6xOgujW6AqgtkrgdY/jw6Ay+zf0agI0nEihyF3Bqs/LUH1uVt9L/+NcPPOtfHtJiBAfLksiuSKfYXQjUFti/F8ypXHE7xvBJ2jv+7HE7xrA8e6H/fpP3PkZhdT4+fBwq20eRu4CsinQARl48moUZf8Pl+dfI4OV9jwPg8Xlwe93+9eZX5VDkLgDA8R8j5mtu7P5jXmK5AFQWJlqW9RlRQY39X6/JXQFA16jLAegU2Z1idxFubzVQ+8cFEBZQexHgmb3n0yq0DQA9G/chrfwQNb4aMivS2FyQyMze89la8J1//ccqUv3L6/JWcmvM3RS7C2kc1JT56bOZ2Xs+v+34pP8+1zS/kZm953Nf+zjubjcegAmdJ/lv33QiwV8uCbnLcOCgY0QXCqvz/ff5Jmcxd8X+lmVZnwEQf/xzfD4fn2a8T4AjgJf3TWTGwRf893/30F9YfGzeD16r8IgQYy+qXDAqC5M4cHBN8xvo3qgXld4KHuz4B5qFXOR/Rx3f6Vm+yPyYrIo0gpzBPLnzN5S4i3h69/3+dcTtGMPuos0ARAU25oomV5FWnkJMWFvCAyIAaBl65utp9IsexIYTqwh0BFPkLmBM24cAyK/KOW39yaV7mJs6018KnSK7+W8f0Ow6xnWYCNQWF0CgM5BBzW+ixusmqXgblzXuiw8fDoeTtPJDDG91B1c0uco/8pjS8y0mXjrFv85nuv0vaa7DALx96M/+/0/alvpjX2I5z7Q3RCxh+GXPEb/nFbNjWJ3OOpWGLzMtn9btmpsdw+q061QaPmeAflXNpp+AWEKlq9rsCLanzRCxBJ/Ph8Oha5meI22GSMPnrvZQT97YbEtlIZaQnHRMIwuTqSzEEl79wwKzI9ieykIsQVsg5lNZiCXoMzjNp70hYgnHMwtp1bqp2TGsTntDpOGbM3UFn32QaHYMW1NZiCW07XgRd90/2OwYtqayEEtoGaNNELNpzkIsofBEGU2iI3SsxbnRnIU0fBGRoWZHsD2VhVjCL/q+oFGFyVQWImKIykIs4VcPDjU7gu2pLMQSBgztanYE21NZiCUEBgWYHcH2VBZiCY/e9ZbZEWxPZSGW0KN3O7Mj2J4OyhJLyD5WwMVtos2OYXW6FICIGKIjOKXhG3fLNLMj2J7KQizh/onDzI5geyoLsYTy0sqz30kuKM1ZiNiH5iyk4Tu4N9PsCLankYWIfWhkIQ3fxoT9ZkewPY0sROxDIwsRufBUFiJiiMpCRAxRWYiIISoLETFEZSEihqgsRMQQlYWIGKKyEBFDVBYiYojKQkQMUVmIiCEqCxExRGUhIoaoLETEEJWFiBgSaHaAk87pQzlE5MLTyEJEDFFZiIghKgsRMURlISKGqCxExBCVhYgYorIQEUNUFiJiiMpCRAxRWYiIISoLETFEZSEihqgsRMQQlYWIGKKyEBFDVBYiYojKQkQMUVmIiCEqCxExRGUhIoaoLETEEJWFiBiishARQ/4P4H+LDO08sa8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "<wordcloud.wordcloud.WordCloud at 0x20fab8ab048>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "from wordcloud import WordCloud,STOPWORDS,ImageColorGenerator\n",
    " \n",
    "backgroup_Image = plt.imread('picture/phone.jpg') #笼罩图\n",
    " \n",
    "#f = open('人工智能.txt','r').read()  #生成词云的文档\n",
    "wordcloud = WordCloud(\n",
    "        background_color = 'white', #背景颜色，根据图片背景设置，默认为黑色\n",
    "        mask = backgroup_Image, #笼罩图\n",
    "        font_path = 'C:\\Windows\\Fonts\\STZHONGS.TTF',#若有中文需要设置才会显示中文\n",
    "        width = 1000,\n",
    "        height = 1200,\n",
    "        margin = 2).generate(dataStr) # generate 可以对全部文本进行自动分词\n",
    "#参数 width，height，margin分别对应宽度像素，长度像素，边缘空白处\n",
    " \n",
    "plt.imshow(wordcloud)\n",
    "plt.axis('off')\n",
    "plt.show()\n",
    " \n",
    "#保存图片：默认为此代码保存的路径\n",
    "wordcloud.to_file('picture/phoneComment.jpg')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "从图中可以看出，存在一些无效数据，没有处理，比如hellip就是无效数据。并且标点符号的影响使得一些评论次数比较多的句子\n",
    "显示了出来，这显然不太符合预期的词图效果。\n",
    "下面去在去除一些冗余的数据之后，重新进行分词并生存词云"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataStr = dataStr.replace('hellip','')\n",
    "dataStr = dataStr.replace('。','')\n",
    "dataStr = dataStr.replace('，','').replace('！','').replace(',','').replace('&','').replace('...','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Building prefix dict from the default dictionary ...\n",
      "DEBUG:jieba:Building prefix dict from the default dictionary ...\n",
      "Loading model from cache C:\\Users\\ADMINI~1\\AppData\\Local\\Temp\\jieba.cache\n",
      "DEBUG:jieba:Loading model from cache C:\\Users\\ADMINI~1\\AppData\\Local\\Temp\\jieba.cache\n",
      "Loading model cost 1.362 seconds.\n",
      "DEBUG:jieba:Loading model cost 1.362 seconds.\n",
      "Prefix dict has been built succesfully.\n",
      "DEBUG:jieba:Prefix dict has been built succesfully.\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAQsAAAD8CAYAAABgtYFHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzsnXdYFNfXx7+7y9KkiICAImIXNfZeErsxxcSSxPSe/Ey3pKlJTNQUW6KJJcbEFqOx9wJ2QEQBQXrvvS5l+855/xh2dofdhVV8Neh8nmefzNw2dw1z9t5zTxEREQQEBASaQnyvJyAgINAyEISFgICAVQjCQkBAwCoEYSEgIGAVgrAQEBCwCkFYCAgIWIUgLAQEBKxCEBYCAgJWIQgLAQEBq7C51xOoRzAjFRD4/0fUnM7CykJAQMAqBGEhICBgFYKwEBAQsApBWAgICFiFICwEBASsQhAWAgICViEIixaPzqRELfvCbEvSFbA9VJdQWVbDqws8EIGI4BRe2eEdodixNhAAcP1SMiIuJ9+JCQu0UARh0ULQKQ5z19q6HVCWDAcAKEsm8Npp63aAUV+HRvYVtHU7oKlZDQBgNLEQSdpBVTYNIokPfpi7G9FhaYi9lgEAyE4thkalQXlxNTdWys085KaXAABy0ksw+OEe/6/fUeC/jSAs7jGphWUoq6nD1gsRAIDr6XkAgJM39L/ipisHm1avQOr8pdnxRGJHAIDU9dv6dvMBAIwqGGrZZ1y7qc8OhayiDpkpRQAA/+7ecHJxgLuXCwBAXqvi2hblVeCx2cNMVh6jgj7nrt++9hvoFmzrngn5yaTs9P4IlBRUIepKGgAgPiobAJCXWQYAUDEarEg8aHY8hhjefY1GgdOFUdz9heJYvBS2xur5CZiBiP4Lnwee6MwCIiJSqDRUVaegsuo6Xr1Wfoi71ilDuGtF8SO8durq1aQoGV9fN7y+lCFN7Z9ERKQsnUo6TTKVKMvZe52KiIjqtHIiIsqTF1k139FBX9DIwM+4e+Nrc+jrRwd9QaODvqBRgZ9z1031NfeMhdE7eXVL4/5ttO+NigwqVlRZ9Zz7mGa9p/daSDyQwiIvo4QSb2SRQq6ilJu5lHIzl6vbu+k8ERGdPxJFWq2OiIhU5a+TThXBG0MtW0ZERIqSiUQMX7AoSsaTumoR27fyA9LU/EJaxXEiItIqzhCjqySFlhUSap2aiIjiZalERBRaGsmN89faQDq+95rJ/OOrsknHMDQy8DOaF/UnV65/mW9WZpkVAPFVOfXP1Fr8t9HoFNy1llFz1wdzw4iIaFTg50RknbC4XBLPXSdX51OpUsabJxHRyeuJFJ6cY3E+9xnNek+Fbcg9oKxIBolEAnsHW2QkFSAqNIVXd+l4NCQ2YoSfSwAA2Lb5C2LbQbwxpC6LAAD2nkGAyJFXZ+95DlLXZWzf1r/CxuljSOwfBwBI7CdDJG4Ne4ktO45YCgDo5dIVADDSYyA3zusfTcLjzwwBAOwNvMGVvxfxO8Qi1s1g9YA38Eb4OgDA0r4vAgAeat2Raxsvy+Gug4qiAQBH8q9yZT8k7OfNXaGrQpWa7aMjNVc+3ZfV0dzKVmeMZy9uq6RhtLAVm7pC6RiCnY3E6jEfZARhcQ9o09YF1y8lISOxAG08XSAWG/43eHi74pEn+mPouACMnNyn2c8iAoa9bH6vvnj9CewLirbY98r5BKQnFwIAVu+8wI1zdvx3XJtqjRx/DfsIm1JPYbxXX3wevZ03Rm9XP+6F/bjHk3j68veY6mMQfF/2moXAIsMcnKXeaG3rBwAQg/8Sjwr6HKGTTHUd+nnomXj+K+5a375YWQUXqaNJvyeGBqBf53aW/gkEjBCExT2gQ5e2eOGDiegc0A5DxvbEM++M5eqeeXccAMDewZYrOxmSgFOhidDqmIZDWeSlRTuRnlcGkQgI3znPbBtvdxf8a7Ri0Gh1SM8r4+4D+vpBVmF4Ce1s2V9mG5HhJV50828AwGD3bgCAkNIEk+eETvoJr19dCwAoVcnQysaeEyCjgj7HZO/+iJdFI6TsHAoUudAwahQp85GnyINcWwsAKFBUNPp9B7h15q7Pjl/KXY85+yXGnP0SX9/8B49d/BZjzn7JPTdfUY7M4gpkFjU+tgDLf8VF/YHkREIyTiamYP3MJ7myI3GJ+C34KoLmvM6VPTa6V7Of9fP5ULR2sEdepQxfPTYeAOBgL4VUYvi9kNpI8MKXOxDQyQvbvnsRbh5OcPNw4updnRwAALVaBaZe/BYA8OugdzD/xl9YPeANXClLwp5RnwIAHG3seM+XiBr/Xert2h/l6lK0lraBRCRBuaoEXZ0DoNIp2WebWRXoOZR3lbfdMSZ44g8AWOFwcuw3pg0cGp2WgBHCyuIeomUYrJ/5JP4MjwTACgoA+GDM8Nse82BMvNnyh7v6o1tbDzzS3fALbCs13auH75yHxMxizF9zGBGhqYgITeXqvN2duevgiT8CAJKr87F6wBsAgOjKDHRw9AAATPEewLUdFfQ5tgz7EAB/VdIQd1tPSOrre7sOgJ3YHi7S1gCAVjb25r/X2S8x3Xc4lvV9yeK4APB2l8kAwK1wBG4dYWVxD3mqTwByq2Tc/dWsXHz8yEh4OztZ7DPs5TUY1b8zrywsJhMMEX7/8XnYiM3L/77tvSGV8F9UvZKyIV18PRByIwOP+PggO70Yg0exWww/HzcAgJON4ee4h0t7AMCrYb9g+4hPuPIPezxhduxLE7+3+N1y5eVIqMpHnU6NJ9r3R5mqBldKU9HesQ2GuXcx2+e9bo81qssAgNFBXyBkEivcNg99H1fLkzHcnTUwS84rRVl1HdQODMZ16mxxDAFBWNxzOrR2xZvDWIXfD09MtqrPmvlP8+7fWLIbc18ai4fa+8DHxZlXF3YmFiOmPASpRILyOjncW1lezuv554dXAACxkVlo42kQXH7ebmbbzwr5EftHsybmY88thIbRmX1516eexPvdHjMpfyN8HdrYOmPVgNeRUVOKye0eQnZdOdxt2Wf7ObZBSk0Rr8/FkljUaBSY3XEMZnccg1FBn6ONrROOPcIqNzWMFlKxDbLqSjhBAQBSsQ0+vbEVDBEuTvgePXw9UZuqQutWthBoguaevd6hz31PWFI2HbgSS8n5pVzZ8euJ9PzKXbx2h8LiuGudjqFfj4USEdH/NhwgIqKhL602Gfv1b/6h2FTWqGtfVCwREb24cAel5ZbSmT2sfcKCAyfpdHwKnY5P4fr9feI6zf58m8U5Z6cXU1pSAfdc/TPuJ3Q6hv44HU4HE+KbbtzyEewsWgLDe/hhxog+6N6O3dPP3XIMUokY0gZn/Am5xQCAj/84CrFYBAc7G3zzTyAYxjr7glkD+Metk59j9R8rZkzFpICumNKrm9Vz9uvcFl16+HD3fbr68Op/TjyNnxNPY37kLvyceBoDTy4GAKxLDsS65EB8dH0H1iUHYvjpJWbH/+LGvwCAtUlneOWbUy8AAMJKU/FVzH7INIom53q9OA/Xi/NQrpRjZ9INLL9+gavTEeFqUQ7Xzpj9oTcxaUA3TA9ovhL5fkcQFveIn996EicikkzKP585FgCw9u1pAICSqlp09fHA7+/PvK3n1FWzL5oIlnUUt8vcgEcBAL6O7gCAqMdYQ7CPekxGWnUR1g15BR/1mIyrjy6xOEZkRSZ3UpIrLwcAvNONPT4e4dkNS/vNwtyIv5ucyxAvXwzx8oW7vSOmduzOq4sqyYdcq4GWYXC1KAcaxuBv8+yYfujY1g2B6WlWfusHF0FY3EPWvj0NX78wEZFZ+VyZpF5BGZfHrjC+fGY8Xh430Gx/Y9Ra9gVQarW88vCz5k9HLDHs5TWgBouY4vIa843BCgz9x5iuLt7cCmNM4FKTft/ePAQAGNSmE4qUrJJXpWPnfraIP+e/RrzNXY+escpkrIZlHg6tsGjIOO5+iJcvxvt2gY1YjA/7jYRUzK7mHnnGYKzWxkE4Q20KQcF5j0gqLEVueRU6t20DhVrDleVXVmNEVz80tggwZ5FZVskaL9nb8P+XDqh3KzdnZ9Gw/+MfbTZrwDXtkz+w9rMZZueyP+cavo87isfb98fSfrO48jMFN3Fi3AIAwBSfh0z6fdN3OrcN0REDAqGrsxevzaPnV+D0eIOnbJ1cjYaYEx7WIKtWQGdk5Na2VavbGudBQlhZ3CPspTaY1Kcb8ipkcHVgbQh6+nhiRFc/ONpK0bu9F7aHRJrtG75zHu/Tu4sPiitqcCYxFUyDZUFRNru0Ty4uQztXF/Rp52Uy3vBX1lgUFHq2Hb2G45f5v/gfXt+BWX5DAQBL+83CioTjAIDv445yggIAuji3NTum3q38h/7PYn/Oda48raYIR/OiOEERUsr6zrRytEXgro94Y4QcXIDbYdu+MN69n2vr2xrngaK5GtI79HngmDhiaZNtjh2KpEXzd/PKRr76s8X2sQVFJFeznpr60xA9j6zZTIuOBNKiI4Fc2dCXVtPQl1bTm0v+sTjm0JdWU0U1676+/t9gk9OYuMp83r1MLScdw1gc70Y56+H5RuhWi20aomEse6kSEY2avvKWyvV1xvU3IzKtnk8LRjgNacl8+PZWkw8ATBq5DE88PRDjJvUGwxAUdSrkZ5Vh1UuTUStToLK0BsGnbiLsbDzUSnYb08fHCw5SKW/8iAusr8bFuW9j7oRRWDZtElcXvnMePNycsOWb503mVSNXYdjLa3D0l7fh5szu5997djQAwzZo0Y1D6N26HeZcZRWQS2KO4q0r200UqdvTryC6IhcAUKaqxW9J5y2afxcoslCuKoKODEpIc1afuw5dwxsLdiIpnbW/SEwrQlRcDk6cj0NhiQwVVaxPy+gZq5BXWGn2WT9+OZ27fmiQv9k2AgYEncU95tc/XjcpuxAUj6Ar7DFkpy5eICKkxuVDp9PBw9sVWalF8PB2hY1Ugr7DuqC0SIb2/h68MTLyy2EntYFvV8O2w5xB1ol175iUXYpMw2e/HDW7Lbn850d4+E3WJb2/WwfszAjD+z1ZZaJMLYe9RGrSJ19eiWqNAv3bdIBYJEJ0RS5e6mzepL1GW4UaAG62nmbr9WzceRkA8NanrKB6+zP+iYnx9mT2+38i+MACTg+0YcclAMDoIeatQgUs0NylyR36PHBMHLGUvv6MDdjy5dx/aOKIpbyPnro61S2N+/eJ69z2gohIVl7L1S0+GmipGxERPf7h7zR93pYmn2G8FUmtLubVHcuNtnquiVWFjdZv+PMCRcVkNzmO8XbC3PX2/Vdp1PSV9PLHW7ny0TMsb1HuY5r1nt5rIfFACYsaleHFb0pncflCIp07E0sqlYaIiMLycyizqpJ2xUdTTAn/JatRqejn66GUX8NGgopOzrN6Tq9+9Tcp6p/RGHkFFVRSVkOXwlgL0Kib7EssV9yaMLOWnVmsQKquUTTRsmlhQURUVlFLo6avpMde/a1RXcZ9jqCzaAncLClCeEGuSfmnH/yNbz7fi+VfH8SSL/fhs492AQDGjO0JtVqLuvrAuXUa9tiwsM7U5sHJ1hZ1GjXaOrK+FP26tzc7B6aY9QQl1UXoAwFv++5F2NfHqSDFfjBlU0w+pLqA9j5u8HR3wsPDWQvQNm6tUCmTo8goGjg7SA2oah6You5gyp4Aqa/yqpkivsEUVX+HhjDE4KWO83DqXBycnQzeprd7TAoA7m6tcGzre5BVKxB8gH+C8r9n1t/2uA8UzZU2d+hz37Mn4SbvntGZnhjoVxszHl3FlZ06dqNZz2UUJ4hIW3/NxuEkdayFtkHcta6w2+09r/xlq9rpSiezn8Ju3H+JiLSMhhhiKLcujWTVCsrKKSMiw+mFuVWBNSsL/X3g5QSTcrUVK6v7BGFl0RLIklVhR5whKtWNyCxEXc/kPhlpxVzd6vWvcNe//HSyWc8V2T8G1IenE9XH4YSU9R9p+CsPUdP67q3rgnByfwQ2rWg4LwYk/weiNjsAEJiinoAum9eCKt/hniv2OAOQGmLvFIg9zkDszdpSSEQ2EEEEX8cucHG2R8cO7lAqNfD3dUfIwQW3bVcxesYqhBxcgEljAgAA3/1ygquT2gp6fmsQ/pXuEi62tghwNxgnDRzSyWy7NT8cR02NEs7O7PJbZyaUXteVa5D2KXtSsS0yCq8NGmhSbgmqfAcit82AJpF7QQ2VdU1+D7VKC7/OnpgyvYEJui4fIscXAABMcX+IvU39XkSt/gemfCb3XLEn6+xFqssQ2Q4ERPw4Hjl5FTh7KRGOznb4ex3/1GjP0QjodAweGc4KvLzCKq6uuKwaXh4u3L1eUOj5d8NbeO69Lfj6k8eb/L4CBgRhcZd4rEsPFNfVNtlu3peGoDFJCQW8ez0SIzuGZecv4rVBAzHkt42NCgqqWQ1RfcIhAGBk8yH24K8ORPaPNuxWjw761cnoSb2RdDMXOh2DfsYCT9IBTOkYiD2DIfaKYcu0qSDlKYicWKtL0qVD7H6AfX7xAIDqIPZOgcjuYTAlQyFuew1qRglbMSsoj52OwYB+fhhp5ojzt20XARiOUGe/v4Wrm/nOZk44lJTVmKxG2nu3hq2U/6c/bdhSHA3/CgKWEYTFXeJcVjrcHVk7h4tnE7D8a35mLXcPNmhN+JU0LF6wB+4ezthz9OMmx5WIRHj53/24/sGcRtsZCwowMk5QUPVXELnoHb1YgcCUjmvQ28goigg9H/JF7wEd+U00NyF2Z78TU9SdXT3YdAM0KwxtVJcAh2cAAGKvG7xtkLjtNQDgBAUAvP9Ww3kYMBYADVcOxrT1cDZbfv7fT/DMnD+wbyPrpCYIiqYRhMVdokKpQLWaPdkYO7EXxk40jZ8waeQyDBvZFUFXFiMvpwKvPrsB7dq74YefTS0sjdn53KxG600Qu3KXBkHBQnXbIHb7A0zZY4aXvgF1tUoU5lbAp0MbQ6G0b317Q3Rv/WqBe1br3+orygCxByAyfZGTa9i0AO0dOuFGRAkuBCfj60/Nh+hrLoXFsqYbCRhorob0Dn3ue+rUas4OwpjAPWFUWlBJGfEG24gTO4JJrdJQeBD/1EKh0VBRTQ11X7mG8mQy0up01H3lGl6bK9nZtPhMEFmCqXjDcl35a9y1/nSCqVpITOUcfjszJzlMzS8mfRteMzVGfi3qGOPeRJp0i/Nqitu1m/hmzTHuWqNu3P/kPkE4DWkJOEqlaOfkYlJORJDXKJARz0Zwqq6oRbe+fqiuqENhVhmvrb2NDbycnKAjQrlczsW+eH73v1wblVaHpZMnWpwH6UotVNRB1GarSbHIdTlErTfwy8Sm/vMiJ8OWyXg1YnwtcmID+lLtRkDa17g3YMMGy9WvLO4GS+YaVixPDPn2rj23pSIIi7vEqvAQxJeVmJRPnj0Cft19MOGZYQAAlzZO6NbPD+7ernjqrbFmx5KIRIgrKsGBONZlfM7wYXhxzz4AwNjO5k9Z9Ig9jnLXZco6/J12HdEV+diaFseV70qPgNg7BQlVRSb9t64NQnpSIX74fK/FZ+TJNkKmDEVOFWtEpdSyR6jFtXsAACKnxvUr1qDR6KBUaaDVMbd9nAoA16Kz8Gj/r5s9nwcBQWdxlxCJAIVGw92//dLvyMqw8CvfAL1TmTEv9Gd/mT8/dQYPd/LHw5380X3Vz0hZMLfJ8Trv/h4Zzy9EZHkOhrf1R5KsGMM8WYWlhtFhoLsvAMBWLIGG0XGRpYIyA0BYC6VSgxffHWsybm71bnRweR6+rqwwcLUfBQCwt2HH9nKa3eTcejj3b7T+dqw4+wa0x4bl5vU+KzcF4avVszFqghCDs0mau4+5Qx8BC5jzIWmopzAmuqDxCNyd/ll+W/MIzOhJgRk9SafTma3XMWoKzOhpsf+LV37irhVaNubG2HOf0drkw7Q35zKVKKtM+ow//wUREaXWGGJm1GmVREQ0L2ozqXRNW17W1Crpx/WnG7UAfYBo1nt6r4WEICzqibqeQcmJBZScWEAR4QZlnzll4q0wM3Ab7c9gTc03xl9psv25zAFmyxlG06gw0AuTcnmYVfMqVlSSjtHRF9FbrWqv72MsICpUNVb31ROXXECjpq+kNxbsuOW+9wGCsGgpfBty3qp21kTRaopj2fw8GJ2NVhR/JoWb7aNjFNxLb+kTfjmJNq04yetXJr9MgRk9SaHJNzvu4TxWSO3NuUx7cy5z5RpGy5XNClnG6xNUGEVERLuzL9Lu7IsUUsp+H5VOQ0fyrBNITfHxN3uJiIjR5pLW6DTnPkYQFvcbjQmLbo1sQYiIDsYZhETDLcewQ2vNlhtzPmuIxTpzK4uL2SPrBUXjsSksoRcCTaEP1RdTmUHni6IpriqLqwtOzqTIzDwqq6kjIqJ5u09wdZ/uOUkrTlwiIqKfz4Q08oTmreBaCM16T4XTkBZGYwrMNcGhOBhnMIrKeH4hBhwwRAK/+vRHGHts4x2bS3DuBKh1FRjWbh/sbbyt7legKOeuR3k0rljck3MJe3IuQSwS4c+MM+ji5INxXv2g0KlxOI8NultQVYOKOgXcnVgLWV83wxG1pzMbtbuiVo5PJo9q5El3NqfK/YiIyLpMV//P/CcmcS+ZNHIZ7/7g6flwdrGcyyKxpBSXMjO5exc7e+6EpCEMES8upv40xBwXsodiXMdrZuuCMgMwqVMiQvMehVyTjYc8V8LbibVVyCitQFmtHIM6tofEyA4jKrsAyUWleH5YPwBAWU0dPJzvfdj9hibijDoCYtvB93BGd4XmScTmLk3u0OeBY+KIpbR7R+hde16FUm5Vu6a2ISV15vUuKUVltOH8VZPy2Lwi+nL/ae6+tJoN85coM6/fGHhyIXddIz9uts24Zy1HOLeWhT8dpothKU03vL9o1nsq2FncA959ZTNnO/HX7xfwxruWHaYaYs4NPSjVkHpPJBJhYldTL003O/OrlGzZNqRU8DOeB2UGWHy+h+PDZsu7ebmjm5e7SXmf9l74fuYUQ//6VcWLoesROXW5xecAgI3EFxptNqQ2Bqe18OgsqDXaRnqZR2+foV9NjBrcBYtWHGmWQdeDhiAs7gG/7zBE1O7T1w9xMbmwtbOBuH75TgxBrdFBo9FCXqfGyDGsd+asXbvNuqFP6taVd//DxUv4cuwj3P2E45tw7on/mZ2Lm/0gPOIXAqmkNUSQ8LYhDCmh1lVBrsmETBWDtMq1OJtpSLw80T8WIgsBc6ZfXoNDD1t2mf+2r6nz2+HcCN69VpcHe9t+vLJh/f1594++/Ct82rrC18cNcrkKZZV1KC6rxumdH3Jt9ILiyJ8Gy9HRQw3/ZqTLgUjiZ3GuAiyCsLhLVJZWw83TBcFHIzFm2iDMn/oTBo3vjReMPCqDj7IZyMZMG4RamRxOro7YteIYdJU1GDNtEPa/aNn7tM/P6xA39yNE5hfwBAUAKHWGX+Jz11lfjTqlGgO6t0dBmQtSsjPQto0zpgzvyesnFtnD3sYb9jbeaOMwAmmVazGpUyIAgKDjBIe+TA9DDHLqyjHo1CKL8zW3qlgadwhhUww+GlIbf4v99Xi0cUJqZglSM01N6QFDvIuGKwgXo9ieInFbAAwE74fGEYTFXcLN0wU6LYPkiEwMm9wXk14YiVaujlDUqeDQyg4AKySunLiB4KOROLg+CIu2vgs7R1swWtNoWR8ePY5TyQYnrbRP51mMlOVgY8jlMWEIP5ReBy83DOvdsWGXJhFBgkmdEnEuqz+n+NQjFoktbjEGnVpktk4vWGzFhj9JO2nvJufx91p+BK2MnDJ09jPkUNl16BoObDbNjcJHDEFQNI0gLO4i6z/dhcdffwS29uzLO2baIJM2do62GDSuN8ZMG4Tq8lp4+XmgTibntdHodPh1mmmMh7RP52Hs5i24+M5b6Lz7e15dw3sAFk9EboUJ/qyXaEOBcSt8fmM3erj44J9RHzR7Psak1K82jEPsmYNRXwHErSGWNu6X8sDTXA3pHfoI3AKViqZzaRgz4fgmq9vKNWxcjWsFL3JWm3oaM/dm6wOaHN/4tIOIaGXCcTpfZN4wS8fUGF0bjKYa8+9Izy61qp1xPaNOJJ3yYqNt7xOE05CWxOL5u9Gnn0GZNvsV1lDoxyWH8cWSp7HxlzOY88kUXp89O0J590Enb+LPPXMwecRSBIZ9hfde24LeD/ni/fmWYmhaj4MNm3OkShlpslJ4xC/UXBeOSZ0SkFD2NXp5fIfk6kKL7fR1y+IOYXGf6SAQ4qpyoWZ0kOtUKFbKMLPDUIiNAvg+PHM1bwxrvU/NtRs3ojuWfjqNuxdJe0KEnibtBPgIwuIus2w1q6R8euIKHD77mVV99AJFLxz094FhbNxIkQiQ2vKTBxsbXn01cBJuhRvF75rdUthK2phpzcfDYQwA4IXQ3yy2Ma6z1K6Pqy/8HdiExtboLm6FC2GmoQJra5VwMlJ6CpgiWHDeZSaPWIpJU/siObEAYrEYm3e9a7JyOLD7Kvadms8rUyo0+HXVKcyZOxmOjnZQKtR4euIKTmBYovPu73F4yuvo28aHV16rUcFJaodrBbMhU8XcmS8HwN1hNAZ6/2Gx3ljBOejUInjYOePM+C/MtmVIDrHINJlzYwF69QrO0TNWwc7WBuf2fGJxLvpxYuPyEHUjC6++PLqxr3Y/IFhwtiQmDf+OiIhenrGOV65UauiN5zbQ7u0hXH5TPauXs7EiV3x3xOxYRERXQxq3RpwVtJ3kWhmdyP+Zwsr2UWZtFOXJE2/7e9wuDXUWb4T9blLWkMxavrWntTqLCbN/abTtAxjbolnvqXBedJcJDPsK2/+4iPmLpuH61XQoFRqoVFrY2dmgna8bZr8yCrYNMmTNW8iefGg1utt+7r6Jr8BB4oJHfT7EMPeZcLJpg/YOhn16VOVx/JryEnefUbURl3PG4mL2CFQpb5gZ8c7w5/B3YCu2wd+ZpvqQOq0CX8Ssw785gbc19tndH2PciO6Y+MJakzpjK9B9+6/h4KEIkzYCfIRtyF1i08bzAID/zRkPANiTcwo9nDuhQi3DBK9hCCoKw+A2vZFVV4ABbtYr2xTaHFSrYqDRVcHdcRxU2mK0th+E4roT0DIytHd+weqxfkh4DF/24iceSi7/HjnVOzEFc9kiAAAgAElEQVTRPw5ynQLZ8gy4SF1RripDv9aGo1+GdDhcsBcz2jeetsCSncWowCUY7dkDPw3g92eIgVjE/00z3oYQAWNmmioxjbcpOw+EQyqVYPY0g6PYB4v3oJOfB+a/MxHXrmegtlaJ8ePu+9B6zdqGCMLiHpEnL4Zcp4SDxA4dHA3u3Rm1eejsxMbA1HuimovBqUeuyYCjtDNq1AloJe0Kgg4SkQNq1YlgSAUXu9u3HdARA4nRixoni4aSUUAEEYqVhXjMZzoY0kEskkDNqHCp9CwmeT2O3VlXsCqRzSUqggh2EhtoGB10ZDAuMycwPr+x20RYmMNYWDTmJ2Kcdezjb/ZixtQBeKQ+C3xjeo/7GEFn0RLQ6RhKSmw8PqYxE0cspZlTVxMRUVldHV3LNeQV6bJi9S0/v1xVQysSDhIRG6GKiCi7tsSkXVhZEmkZHSm0atqbHUJ7soO5uuTqBNqTs63R5yRXJ9zy3Iwxp7+oVtfy7m9X1zD2GTZw0C9/nnsQ9RVEgs6iZSAWi9Cjp4/ZunlzdvDuJ41chqAriyGrYi03w7JzefUSkQjrw8IBAD1W/QyFRovxf/yF8X/8ha4r10DHmJqHnyiIgEKnwqmCSNiIJLhQHIvwcv4R4oXiWNyszMLlknjYS6R4xm8U3GwNtg7dnQMws93L+Gt/GGrqlEjNMvXHcFP74uS5WJRV1IJhDAvG1MwSXAhNRnZeBcKjMk366Wm44libsht7Gugs2rS+vXgYF/aygYP2HY/irSrov7G6/u/TXGlzhz73PUu/O0z7910zW/fac+vNhtJ74/mNRESUXFLGs9psLLq3ubqrZcm0NvkYKXVqCiy8QV/f3EVERCfyr5u0jSxP467V9cFxF0bv5Mp09QGE9RaVWi0b7Vtv3Rl5M5siY7KJiGjtlnMm42fmlNHVyAyL8ycieuXKxkbrLTFhdtNxNBuuKLZtD6aQ0BS6dr3xOd0nNOs9FXQW94jJo5YhMNSgi5DXqfDUpJU8/cS3C/fjm+9ngWDYbHZduQYiAKkWMqb3WPUzkutD7zUWEetOE5QZgJ7uX6GDi3mFKoFBbOUR9HCZhLDSPzDC8y3YSZwRW3kENmI7yNQFAIDhnm80+axpb2xARZWctzrQlzVFQz0FEeHipSRE3cjG/LnNt4D9j9MsnYVgwXkPMRYYjq3sEHRlMb7/5hAWfjsdANC9ftuSUlqG1vb2SKuoQNqn89Bj1c9Wje9pzy7XdUSQiCz/ndSoE3E1fwYCPL4xqdMxSii0uejp/hWCMgMgEdljvD//KDWzahMAWBQUAKvoVDF1UOiqMNbbEEdUydSgi2M/2Ijs0N6xn0k/AkFk9Df+/uI9nFA4dDoa0x9lFbhH/3rPKqXl5BfXIXDXR4Z5iUQYNzYA48ZaDvgjwCIIi7tEZEQmIiOz8E59VCy9kJg0chlOBy+ERMKqjxZ+Ox2J8fkI6N0e3XqwpySZFZVo69QKozqaD9BCALqtXGNS7mzLmi+bExTGqw4dowQA5Nfstzj/8IJZmNQp0SSKlkpXirTKtejvtd5iX/1x6RD3l0zq9GVt7Py5smvl6Rjq3gWpNTnwcfBAsbICXZx8ceh0NGIS8pp1iiFXqPHEaxtwfNt7huddz8DQIZ1ve8wHhubuY+7Q577n5Ilobn/fEHP6iimjl1NeTjlpNDq6nJFFySVlXF1jOgtjbsXbtCmPUmOM43Q29Ew1x+BTi60ee9rFVbwTkS3ph7jTkE+XH2y0r14fsWHZUYoOS2u0nbHuIvxaOv24wny8z/sMQWfRUiBinb7M8fTklTgc+Cmv7IlxP8KxlR32Hp+LKqUSh+LisfzCJfzw6GQ881Af8wPV03n39+js4o6zj79r1dxuJR6FWlcGDSPDlbwn0Kn1u+jqZtn/Qs+Q01+BMbKzmNlhKBb2eYrXJqO2BM8Er20yNqclRs9YhQVPjwAAdOjsiUGju5tt9/kPhxB6PZ1bodTUKuH8YDiRCXYWLYG8vArauaOxJDdEk0cts1gXUZ7Ku3/v8FFKKS0z27a4lv0lnnB8E3Xd/b1V87uVlUXD1URR7Smr++qRqeU08ORCGnhyIRXKK7nrxtgdFk1ERH+H3iAiou3BkXQqJplCU7J47VRKDVWUmU9tWFxaTbsPXqPs3HJKSimkpNQiImJPaaJjc+nYmRgKj7hvT0aa9Z4KdhZ3idatHTHKwi+dnjMhi/DR21u5e8Zo1VeprgUAZNUVAwDWP/Ukunq4Y/buf03GadvKYIeQOvtLDDiwBpsTr2JTQhg2JlzBurgQLL9x7pbmr2VqcClnNIIyAzC+Iz/Wxc0SfuKjQkUVvo092Oh4LlIHRE5djsipy/H4xZXo5OTZ5IqibwdW4evt6gwAaNfaBQ62Uqi1fJ+ZlNhcuLk7mfQHgKzsMmg1Ovj5toGOIS7HiVajQ1W1HH0C2jc6hwcZYRtyl8ioLYSNWAI/x7Z37ZkTT/zObUO2p0Tg1e6Wk+g0JyweAEQVvYWB3lsAAN/c3I/j+YYTk71jPkYXJ8P3VjNajDjDnrx889AMTPMdhEGnFuG97pPwZpextz0HAPhz1SmIxWK8Pm9K040fPISj05ZAYnUO+rj6W6zPrkuCrcQeRYos2Irt0dt1OOS6GtiK7ZFcHQE3W2+0c+h0S880zhXyavfBmBN8ABvHzLzdr9Ao5YpQMKSBWCTFt31n8UL9Xy1LxbPBrOdn5NTlsBXbmKwiIqcuxz9ZV0yOSn+PvYazOWmwEUvwWq+B6NWmLTo4uwIAFoaylp1Z1ZXwd3HDrqRoZC+wHFBo6uFtOPX0a7yy68V5GOLli48vHsfasaZxTQUMCCuLu0hSdQ56upgef549HYsxk7uiRJmLDo7dkVwThR7OA6EjHSrURahSl6JGW4mBbuMQsGYtNLrGXdWjPnofLnZ2Vs+rWhWP8ALTPB63Q1Ork8GnFmOCd2+LDmOWvFLN8Wd8BLKqq/Biz37o6eaJOeePYOP4pyy2/yz4NFaMMW94Ne/SCax55HGrntuCERScLYHQ0jjam3Op0TYplWV0s7SQjqQnUGplGZ3KTCYiou0JUZRXI6N/kqKbfI65Y9XOZrKmDzrQ/BSA1mCstBx++muacu5HIiI6VRBjsU9URWaT456s/7chYvOfd926ioiI4iIyqbbaNKDxuP1byG/LT5RfW82VLbh8ko6kJ1CZvI7G7d9Ci68E0YT9W5p8dgumWe/pvRYSD4ywuFvohQVjVNZ33yrq9M9y0hpFyM6rrbJ6zLJiGcVFZpFGo6Vrwcl0aGco1dawL+Sl0zcpMSaHa3s9ONnsGHFVuY2edhifhoSXsTYSyRWlFtunVBpOgs5ms+3H7P2dTu+/TjHh6XTDyM5i2pEdRETkt+UnIiIKzmdPT2LqBTMR0YXc+/YExJhmvaeCzuIeIJer4ehoe1t9tQyDK9k5Fuv1+znj9WbMLDae5970GHwTeQYqnbZJnxEdKSARsToPB0c7nD4Ygd4DOyL6ajreXjCVa5eTXgJbOzYPik7HoKqizux4r1zZyIu9CQBhU76FrdgGg04twhD3ztg09E0AwFD3Lpgf9TdWDzS1+NTTrbUhr+pgL/YE4/Iz76CyrAZuHs4oKagCAEQU5+PItJd5fUe3Y5Mq9fXwRlZ1Ja+uYcZ5ASOaK23u0Oe+p1pdR6k1bEyKapl1Gc31yKpM2y87f/G25tHpn+XUqcG2JDz/Od693o7ibGbf23oGEVFydUGTthPTL61p0raCiOjVM/tMypaFXyAionKFnMoVcur8l8Eic9vPZ8yOo19ZGBNSv8rQrywqlbeWk6WF0az3VFBwtlC6rVyD1EZSFkaW5kFLDJZEBuLjPqMR0NoLHZ3dTNrdKHoXZQo2H2hD5eT57EHQMU17chrzkOcqeDs9bqKoTKkpRHdnfjwPfZsnLq5EV2dv/DLo5YbDcXwy7jtMefVhTH1tLK9cXqOAo7MD9qw6htkLngSjY7Brw3m08XTG47OH4Wmvd/D0e5NRklOGtn4eiDwbi1+DDflUiSEo6pRwdDafZf4+Q1Bw3i8kVd8glU5BF0vYKN43KoOpQJFFEeUXTNp2X7mGp5cgYvUUcrWau8+vk1l81qMn/+Dd3yyeZ9GKk11l9Kf0yg1mP2kV6yip7HuKKZ5L1wpepA+vbzcZY+DJhTQm8FvuPq2mmFf/9tU/6JGg7xp2IyIijVpLC6Ysp6BdwWbriYjqquW0eAY/glhqdBZ3zTAMdy8rZ607l7/yGxER1VTVWRz3PqNZ7+m9FhKCsKgn6NTNW2rffeUa2hB2lbqsWE0KjcZsG+PtRo89P/JSAFoiMKMnZVb9YVIuU968JZNwc6RWFzW57Zh87geTsq1L9tFLPT6hs/+E0NYl+2inkUPZ1iX7aOuSfbR96QGLYxZmltA/Px2hnGQ2rKGyTkVErLDQ1KddmOz48i1/nxaIICxaGhNHLKWJI5bStAnsHvrZJ279GLPhEWnDuJzxFazPg1yr5gmNXv+uoLlX+PlHzJEj22W23FhghGawEbGOxyVZN+l6LhTFk0pnXsARESXJDHlCIs7GcsLizM7LtHXJPu7F1q8MLBF1Po5e7TOf9q89SS/1nEtR5+OIiIjRGYSmTqujn97cRL9+su2WvkMLpVnvqaCzuIdcOpeAZV+xPhTt2pvqEwBAxxB8O7TBj7/wA8vIlEq42vM9JfNkMvi6uvLK/kwKx5s9h93y3HSkhERk3hPzXFY/TPBvXhazM4U3McWnr9m6RFk+Alz5PhrzJi7FhOdH4/E3x3FlP76+EV9snQMAKMwogU9nU1P6A+tO49/Vx2DnaId5G95EVWk1xj3LeqZWFFXh88d+xB9RP6IsvwIe7ZtOz9jCEVIB3A88OuZ7nA62fJyZV1MNJ6ktrhXkYXLnrgCAf+Jv4oXefbE99gZefWjA3ZoqR2ppOZzsbOHj4ozogkKodToM7eD7//7cWq0STjYPhEv5naZZwkLwOv2PoBcUrz5jPuKUr7MLWtvbc4ICAF7ozf4y346gmGzbePKhZ9rx42CYa9/N0x25lTLu/npuvtXjG7P1a77n7LHfz0Kt1FhsH1qahJjKLMRUZnFlpRW1Vj9P4PYQhMVd4lpZFjJqyszWHY6M566n/+IPAEiuSYOWtNz14fwTXJvkmjQk16Rx15bo9Otq9P3dcjbzxqirVqCisAq5yQWNthvakV1JOEileH+kYbvz88Ul3PVzHeZwn8davYyZ3u9wdXt+OoKDa0/huQ5zMNWRPTp98t2JuHnZso9JPzd/BLj6op+bPwDgn8PXMf2tTTiVkoJ3Dh/GqRQ2xcGTO3dCZ2HlrHf/l2s0qFAoGv2OAiyCsLhLDPXwh18r/p74na0HUSyrxYiurEVhSk06chV5UOgUsBPb4kj+SRAIfo7t8XR7g5NTR8cO6OHcFTdl8XCQ2CG4LAwAkFVViV/Cr2D2wX/R+dfVAIAatYrrZ+nX/rkOc7jr5Ih0AMDJ2h2Q1yigUfF/4bcs3A1GZ5qXRKHRoKSW/XU/vvkseo/sjmObggAA/+Zu5D4n63Zi+OMDuX5uXq546v0p+Dd3I5bsM9iLDJ5sXp8xesYqFCmqcL08DTINawOyYcclAMDU7t2x+emn4ShlLUrdHBwQmJqKD48d542xMfwazqSmAgAcpVKIIOyDrUEQFncRGzH7z70o6ggAYPPrM+BkbwsvVzZQS3fnLtAyOjhIHODfyg9TvCdABBE0jBa1WtaMmiEG9hLWozS1Jh0iiCHXsr+M/q3d8Mmwkdgz4zlkfDgfmR/Ov+U59hjcBXtWHAUA+Hb3waFfTyPmYgJX/9b3z0MsMf2zUWi0aOvEfo91H/yF+CspqJOxL/OSmazg+mAEG6R4+ocGz08bWxu89T3fA1W/CtmycDevfPQMNqdpn9YdkCDLQ3gZ+8LzEgYB+O7CRVSrVHCwkWJq9+7o4enBG+eJnj1QUluHkb9vxvmMDNhKJBABOBifAIFGaO5xyh36PJDM3XWcvtx7+v/1Gf7rVnHXk6TPm71+1vd/Jv0yYlnnsJykfF57eY115tCT7V4gIqLKYtYwLCshj/5cvMek3VkjQ6urx6MaHZNhLKcuHDV9JR1NTaSw/BwKz88lIqLC2ho6kZZMf8ZEcO1O7w2nipJqiqx3eMtJK6a8jBIKORNr1fdq4TTrPRVWFneRag0bcv+7aFb/8Gjf7vh2xkSTdp3qtxDNxTgs363y3bPmc5PkJOabLTcm/OQNnFHuQvCha2jd1gWTbV9Ax4D2GPqoaZJmZZ0K/xv0hVVzasq/a0wHfzjY2MDd0REAUK1SwtfFBS/0MuQjmfLMULh5OsO1TX1OFR0DhgidephPLSlgQPA6vYu4SNnjPgcb1uN0cp9uWH82DE8N6gVfN9Y+Qq9ruFMC43aYM+RLbE0wzUMCALu+PwS1SoMfT36JOrUaW69G4XJaJr56bDwi8vLx+uCBaN3WBQAwZvpQXD8djUD1PwCA3iNNY5CGHrmOTZE/cvdR5+IwcELjkctjKrPQz80f2XWl6NjKkytfvOyIVd9PaiPG6CFd0aVXe/h39266gwAAwc7iP0FmaSU6eRqMsjr9uprTN4QX5WGYt8F2oansYsYU1NWgXStns3WTbV/gXuLGyE0uQIce7XB881k88Q67Cnq7/2f4I3oFziSmIjqvEL19vPBEnx4mfRW1Stg52EIsESP40DXEXEzAB2tfsziP8BM38POcP7AnZwNXv2/NcTwzzxDubvSMVdj017O4XJKI/m7+GOnZgyu/HZqTsKgFIjiS3W/4r1tFK65fJiKD6/SbgQdJqdXQ6awUk/bZ1ZVERKTR6ehYusH0+ruw8xafYayzIGJ1EYd+Y/UnW7/Zy6t7LWAuvd57Hvcx7vtPRAwtO32BtkVE0YjfNhMR0fwJfIewRx1e4q6TI9JNnn166wV6d9AXlJtSwCvXqLUmbUdNX0nVatZlP6W6gFd+KzRMNPSA0Kz39F4LCUFYmMF/3So6kBpHp7NSeNGiwgpYpaNeOOhZF3WF/og1ZEQvV8jplVP8GBBaRkFRRe9x96VyvgdnqTyYsmX/UK06k0rlwaTSms9JYonQrGyKzi+8pT5NcSjvEP2e/juvbNT0lfRr8klam3SCfkk8zitviEatJSKikmIZxUbn0PKvDtKmdYFc+78Pht/R+bYABAVnS+FcYRL3AYD4/GKsPxuGdYFXTNrO6NobUzp2w2/RV7my4T4dAAB+zq15bT8cMAJv9RmMsfvYUPxVKgW2PzoLL57ay7URQ4r2zjO4ew+H0bwxPBxGwc/lebSS+sPFtjcqlZGQa3Kt/m4jO/qhX7s7v/8f2maoSVkHRw8odWp83LPxALsSoyNeLx9XTJs5GP5G/iMvTjcdW8AygrC4iyRWFSFFVoIJPj0BAL3be+H9iSOQb2Qy3ZB146wPT3/xmbcAAJ1dWeOvXVOf5eoyZH/AXuLFXldtRk71rga9RShThAAACmoPw91hFApqjzb6PB3DQK3ToValtnqOjc6/OAGDTi3Cu9f+BABM9p6MDo4dTNo95TsEn/V6usnxRGIRwoJT8M+2EHi2dUGffh0w5XHTTO0C1iEoOO8Sp/LiEVWRg+GenaAjgrONHaqKNNgdFoNpA3th1hDDCcDtnITMHTYSHw0dcSen3CRytQaOtlKT8hUJx/BvtmFFdH7iIrhKHXEkLxLfNchU9mGPyXit8yP4OGIHQkqT8duQ1zDCoxtXHyeLQx9Xw7/N6BmrzColLZUL8BC8TlsKx3Jj8WSHh1CrVcHJxnxejztxZNqY5WZgFmv1ONm/m0nd2aw+mOgfZ7Fv+KVkDHvE9NRDT6XyGtzsDUv7ClUtvr65H2FlqZCIxLj26FJsSb/A1Z8rjMcEn954q8s4jDjzDcKmfMsb73D+YUhEEjzZ7kmLz9RjLCwUGg0icvIxpos/AGDuwZP4ecZjXFsdw0BSb0377anzeLJPT/i2dkFbZ/MpD+8jhNOQloBKxyrbypS1XNk7fx201Py2+d+JI+S/bhXPctOYxPISs+VBmb15gW0u54wlIoOSkIgoLdFw+nD47yt09SI/6E1gRk+SKeNMxl6bdNpshKxF0f828k1uDWMFZ6VcQZfTMnn1xjHCalUq+t+ew0REdCgmnmqUKvr6+Nk7Npf/MMJpSEsgv840T8fRqAQKS8umkOQsi/3yqs3H0dQLBEtCQd9GpdVarDeGIR1PWARl9raqnzGBGT2pVG6aSGm0UexNY5oSFpXqykbrm3P8eTqBPYJuOtDgfYVwGtISaOfIj2C1Ov4snhwQgO5eHsgsq7DYb/S2P0zKdsfdBACM8+/U6JYj88P56LHhF2gZg5foL5Gh+CUy1KStqMGfgqXtiEpXbPF5AODh8DAAYEdmMFcWPOnrRvvoGXxqMQadWoS0GvYZRcoinC85DwBYvPKoieGVrw9ryGZcXl2rtOpZUwLYbZiQIcR6BJ3Ff5wcmQx+DULldfp1NRLmfAQHG1a5qFVHAWBgYzsYjDYdWnU4xJJOEEvaQmzTBR+fOYG1U5rO46nPpK5PcGypDWCaNiA4dwKU2gKufMnNAziWHwUAOD72U/g48I97AWBxzF4s68ee2Aw6tQiz/Ibiy96GXKWBxYEY3mY4XKQu2LjzMnYdugbA1OpSLyweHtYNl8NTm/yexjxgSlFBwfkgMW7nX9g3czY86p2l7iR6QWCJSZ0ScSF7KLRMDXdv3Nf4/mZVDvq2ZpNAfxm9B4GFsQie/A3GBPKVmACsToQMAFt2h2LbvjCLJyJisQiX9zftms8whJo6Jcor69DZz6PJ9vcJgrBoqRAZPCmrlEoM+MN8SL07QfoH87i0fN9dOY+vR443adPwhTfHheyhGNfxGqKK3kS54grXvmHf969vw/ohr3H3OmLwW3IgPu5pPou5JU4WnsRjPo/xysKjszD/u/3NFhgPIEIMzpZAUUWNSVlOsSHPZkNBIRGJYG9jAydb8zlRnWxt0crWFo5SKextbGAjFjeao7PLb6wX6Z6km7Czab6z8UDvPzHYZzuCMgMQlBmAsR2v8uqNBQUASETiJgVFvqKSy4Oqp6GgAIBh/f0RcnCBWeexkIML8Pj4Ppj2xkYrv4mAtQgri7vE6j0XMX/2WLN16cmFaOPhDDd39py/IKcCTi72kNep4N0gRUBEYT6e2b+Hu5/RsxdWT5qKxjiw7hRmfmRoUyqvg6djK+7eePth7cqiYd+G/Rq+9I0ROXU5137HyDno7cp62TLEQCwSI0+RB18H81HDLRljFRTLEJOQh6njegMAIvLzsTY0DB+MGAaJWIzB7dlUA3HFxWjj4Ih2Ls6IyGdjdbSytUWAp6fJmPcBwjakJfDuyn2g+q/p4+6ChS9NhJ0t+wsffyMbDEPo1M0LTi4O0Gp0uHopCTY2Egwf29PimJN2bUVaBXuS0vBUZMUbm/DCF0+hpqoOAUO7muvOEZQZAInYETpGfkvColR+Edmyv1CtjsdQn3/hZGt4zqBTixrNXQoAn0TuxC+DXsaYtpa/Y3P4bPlBrFjE+sPsuBGNkX4d4O7oCDcHB4Rm52BURz9kV1WhY2tW+arSahFbXMwJkvsQwSirpXA1nm9PEZNWYKEln6jCpts1ZnPx3vDFFvsZ21ZYk57wfNYQIiLKlm2nSkWkxb7WZEe3pk1DNi/aQ3FXUijuSgptX8YatVVX1FLi9XQ6ue0i/b5wD4Uei2xilAeWZr2nQqSsu8iwXh2xes9FjBvYFQO7+6JvFzaUW548BXW6aoggQnfnQahQF6JUlQ8to0Zv15EY4N10yDf9yqLrb2uQ9gEbJVtRq0RyRAbWhy212K/hSqKxExF92/NZAzDe/wavzt/1zSbneKucKjoBEUQY4T4SrtLWSLqejv4PByA9Ngce7dwQfSkRryyaDme3VrB3sMXUVx9BSW454q/e2vGpgHUI25B7xLXEHAwN8Pt/GfvfhFg81+sh7v78nisYP3tkk/1u5TTEHJFFr2OQ91YAt66z2JZxGb8mnwEAhE5eAnuJeTuPplDptAjJyYaaYTC1C2t4VadWo5WtLVQ6LewkNohLLkCfHu0AABvTN6KXSy/4Oviii1OX23pmC0LQWQgAf/90FKOeGIhisQ5EgDaZtYJMj8nBa0tmce0UOg0cJFIczo7D0x35sS6bKyyM+0enscrCtm7OaOfuAoYhiMXs32pxZS2uJefgyeG9TMbYnxOOH+KP3pLtRUPya6pxo6gQXq1aYUg7X6SUlyGvphqVCgVmBvRGTa0SN+Jz8fCwbqjV1uJg/kEk1yRjeZ/bf2YLQTg6bQmMem+d2fJVRy+jso7N+7HhTBiiMg3Rs6+l5eKv8xHILq1CnUqNnLIqs2PkphaBCMhJKQQAjOjVkat79ZuZ3HW/g6sggghF8mp4O5iPzWmMhjF93pgO5yy2H+t3hTPYsreTQq7SoJ27C/ZdjsHNDENms51nI9HJi4258fuJq9geGMHVzfIbhsipy7E/by8q1OVNzhEwjb/Z3tkFT3TrgSHt2BOU7u4eGO/fGTMD2JMRZyd7LPzpCN769G842TghrTYNEpHEqmc9yAjC4i7h62lq7tyQPh28MbCTQRM/sFN79O/kA4BQLVeZ7dPp19Xo0M0bL38xDf4B7WFvK0V0egHGTB+KMdOHQiQSIfQI+zI+7N0Z9hIbeDu6oL2jK2Tqxv0oMio3mJTZiC0LGanEDTElHwMAenZoyy0X/b3bQMsYFo8LnnkE56PToNZoMaibL3r7m0bYmuX7LNrYugMAQstCLD7z5y2WhZee0TNWYfSMVXh9/g5eeVJ6EQBgUcAifNf7uybHedARFJx3iW9en2xSNvitNdi88DmUyGrh1soBD/fqxKu3kYh5wqMhxrEvIi/EQ1mrQqGrDbq155svj3pqMABgiKcfFDo2HWEHJ8RoTj0AACAASURBVPPCKyR3MghaiEVSSMWtEV38Plzs+sDTcSycbRs3BweACkWY4bm9/dnndjeNdvXRdDas3+DuTWddH+XBtiUCxszk21XMfWsCGMb8Llap1GDiC2sBAPb2Umxd/QqvXr8t2pC2AXO7z21yHg86gs7iHrP5bDg6e7lj4kON20Lo0ZIGZapCeNv7ccLiy6IOUCnVaO3pgpe/mHZb84gp+QgldUGwk7SFRGwPQAwdUwc1UwEindk+jlJ/jPI9xStTaotgb8NfKfyUcAyf92o6gE1TRNzMxidL9iHk4AJoSQMbkRTXKy6itawXunVqa9J+9IxVcHVxgKxaYdb5zN5eiklfK1GqKgUDBmv6mc+Vch8hKDhbGmqNFrZS84s645whGp0OUomEV55dlwwbsRTtHTqbtDdGq9Zihve7OFrxJ1fWfe/3SHl24R37HtHFc1AqvwigccvPWzkZ0WNJwbnjQDhemTkMoWVnEF8dga5OvdGhbqSJsJj4/Foc/WsOHB1szVp56gXJiW3v48ekH/FFT+uyorVwmiUshG3IPcBYUOy9chMqrRYvPzzQJKReemkFenp7outvhl88ua4WpCNOWDQkObcUHq6tsPOL3ZjxEd8MfPGAydiRGoHnOveHnYSdg5ZhEFaagUHufggqSMKkdj1hJ5FyiYyO5sQitaYE83tPAAAEF6dBpdNiYrue6O9l8L+oVsUhuvgDPOx30WROU9v141zRubkYuadbIqsuE9nyLAx3Hwk7MRuGcMRAdqs2ymMKRnlMwfas1egA02Phs7s/bnRsAGjlwPrdPCCCotkICs67xEtL/4asPjDLZxuOAQB2nonAsyP74uWHBwKASaaxyBz2ZCTtg3lYU+//EeAyCL1cBvPaFWSUQF7Dnqj06OAJdxdHfLLhTbz6NXsSUl5YadSacLkonbuzEYsxxqsrHG1sMbl9AOwlUuxIC+fq46sKMbNjf9RqWAXrGK+uGOhuah/iYtfHrKC4Xf7K/ANbs/5EZGUE1qaabg9UjAKlqgJ42rXjyo6fjb2lZ7R2vfNu/vczgrC4Swzo5gtXJzbXqVcbZxRX1ODlKfyX/uob/+PdvzjUkEh4ek9TmwQ9hdmlUNSpUFZQiS0nw5FWwB45iuoVeBVFhiPQV7oNwaT2pkF3azUqOEikkGkUeL3bcK78w4BHwBDBScr+si+/eQYbk4ORLGs8YlZkRWaj9U3xRqe3MaP9LLzm/yamtTMN+28jsoWbrSeGthnHlf244YzZsdzdWpktb+0iCItbQRAWd5HrSTk4F5mC60k5CLlpeJlSCssAgAtocziZ3f8rNVqTMWJlVxFRcZFX1rm3L9y9W0NWVoMAPy+k5Zdh4ZMr8O2zvwAA/HuxpxED27ZCrCwBl0r5YfXK1RWcMHCzdcSJi/EAgKj4XDhJ7dDZ2QNbD1zF5j0heFjVBYv6TkEPVy/eGIW1x7jrr2L24Z3wLbelqzAmT5GLlck/wkZkuluWiCSwEUnhYccqU2e/z+pmRs9Yhdgkfqb3rh3Ne5D26NwWO7J3YFP6Jnx+8/NmzfWBoLnOJXfoc9+zavcFem/1fu6aiEjHMLz/EhF1+XU1zdz3DxERHYlJaHJc/3WrKC4slcoKK6k4x5ByUKsxDdRbpCimclUFZdflmB1LrsklIqKUzGL2+Wdv0uGgGCIiSs5gy4JCEmnX0etm+8eXLjJbfjuRvXWMjrsOLDrNXafUz4OI6Hr5RQotO8MruxGfS6Omr6SHZ63mytZvv0hXItN544+avpLSs0tpc/pmKlBY59B3HyAE7G0prJ83EwvWG7J8/bDzLJLyS3lBa74bOxGRhay1o43Yuv89RITjf15EZWk1VyaxkeCr6auQGZuLc7vZlYSXfVu0sXWDn5ksXwAQkjsJANDNnz1ZmDbhITw1sS8AoHv9acPEUT3xwpPs9ikoMwCpFQbryfyaA2DI1NBrartbzwIWVm5I6TjJa4pJfXDZSdRqZXCT8m1K+vfyRcjBBdDpGEx/axMAoL13ayz86YjJGJ39PDDIbRAul17Gv7n/3vIcHzSE05C7hD7wzar3p4GpP65e9MokZJbwI3u/0KcvFl0IAgAM72Sdo1mfEd3QZ4Rp0qClh9jjwk4PscJBqdOiQiVHO0cXs+MYe46a8z4N8PgWvs7P8uq7teEfSWoYGewk9ryyUwUxOFUQYzKeuTI964ZMxRexn+IJn2kY7THGpF4EEUpUBRjbdhpSy0tM6kMOLkByejFGz1iFTT+8AI3GvK2Il70XfB19oWVMt3wCfAQ7i/8gdyIrmTFLx07ESw/1w+rYi3C0scVU357wcXThjk/NodDmw8HGYD1q7CRmKTpWUGYARvqeRCsp3xI1uboAPVzaoSEHU+MxrkNnuNrZQywS4WRmMiQiMab4d0NoWQhnuWlMamYJunVqix1ZP6ONrSd8HDrCpaoH2rRuZVGRqfcdmfXYQHzy1nh8tvwgrkRm8GwvDucfxtPtm86f2sIRHMn+r73zDo+i+vr4dzdt0wupJISQUEIIvUkVBKQjRayoqFh/Is2GBYiiIEgXFAtKEykCUgOEllBCC5ACKaQnpPdNtu95/5js7E5mN9kQ3ihmPs+zj3PrzEbm7L33NIH6+eJcBADAWmwBe0trHM2+g82Jl7E+IcrkGENBYQzTRlhaXs0LF/XxRV++pLfNEIlEiM7Lhoa0UGuZj7e9I24X5RsVFABY46shHmORK89Ab1dm1bFj/xWj/XVc2P8B5s5ighRfupGGrz5kLF2vlDLjfGwbjhnS4mnqocdD+rRocmvSSKVVsmVdxKudyTH01rl9dDCdnxKwbt/62o1F0Vp8I9zECOMYRsLSksZkH6kyjVdf9zDzQSJkmUKqquQccDaEUqWmMS9tYMvRJdFERHS28OxDe6Z/MUKkrEed5KpbSK66hWGeUzj16ZWlyK+R4qmALpz6tOpMpEkzMNLrcbPvUdckfEkv/aHhmcze6OO9tcE5KhXxuHr/OfRt/QeINNBQDZSaEig1pWjrPBMAYCl2wDfxf+OvbG7Mi7rnE/WpVRsTy8Le0hEd2jXsbq9j+DNrONuP/m79AQB2FoLNRUMIwqKZ2HL0Cl4b3x85ReXw83BBvzfX4OpPjKfjMM8pkKr5sSOe69ADXdy8EV2Qhce89IedgfZt4Wxl/guiExSVKjmcrLiHj6XyK9Boa3Dl/vQG59H1uXr/WV5ba0dmv28ldkHfVoEY79sTdpbWsBZbYl1iOOZ15pqeTz6/Ggcfn8+bZ2rkWvQ+/plJgZGcVoDXPtgORwcJjm97j60fPPU7rP/yGYjq2ZbPXrTbZAayfm79jNYL6BGERTPx2njmF8zPwwUnryaxggIAfk1jYmS+HvgFACaHKQDYW1pjcrsuqMvRvFMQQYRxPiMbvK+hWvZivt4QjACEunrD36F/g9GxAPPTBYhFVhjl05VTZ2dpjTZ2rTh1b7R/AmsTj2NVrxmc+o9DJuBp//5G5z4QfgurfmLOXzoG6h3H8gorAADvL9rT4PcQaAJN3cc8pM9/Hl1kbwP7K+r9OmM4FFt+iWLLL7H1x+8xGb43J1ymUnkNby6tQe7vhs4sDJlxdgfNOLuDXjiznaZH/E5r4/gZz02hO7MolV0zGQXcVL0pA6xexz6lQSeWcOrGnvnW5DMMmrKSqmsURttSM4voYnIG7b8WT2XVMtJotZRdUk7l1TJKLSihgooqOhV1lya+usnk/C2AJr2n/7SQaDHCgojo+SXbiEgvJIiIypWM1aWhsKhSMC/Ep9HH6dPo42y9TKXizdkYYdEUDAVBUsm3RgVDY4XFgSzjlqAPQmpmEV1IyqCEnAI6GZdMSrWaCiqqaP3Ji3QtLYftN2jKSrp+O/Oh3fcRo0nvqWBn8Q+hUKrZJEMNkVJRjA7O7jiUnIhJHbkJeUzFszCXa5m56NuWryaNyh4OuTqfV2+4BbmQPRKD2zDbgkpFAu5L/0Jwq0XIKamAXysm83tsZj4uJ2firVH9kVVcjnMJqRCLxHhuUHdExKVgTI9OOHz1Dib2YxzldIF90/JLoNZokVdWhcdDA6HSlMDKohXveXSkZRUj0N8dck0pLEW2sBTbsm35NdfhbdcHRBp8uuIwoq7cY56/ZWVQB4R4Fo8m5goKAOjgzJg0LzxzEpM6BuN0YSRGeA7l9EnIK0QXH360qLqcSrwHrZYwOqQDpv+6Cz39WuNeUTGe78M1yR7S5myDcw30O8JeX7n/NCtIbKwscTsjD90DfKBQqdE7kBFG/u4uGNCxLTr4uOPQ9TvIKWHOGlq76S1K72QXILStN/LLpHB1sEW5VIasonJYSsIBiOBg3RlONj15z2JhwZgMZVSdRpDTOBTKYiEWWcJdEgILsQ3Sqo7DQxKKZR9Pxo87ovD2DL5VqED9CCuLZiLydhqGdjcesKY+MqvK0NaRm+9UpVXBSszk1dCtLC6kZkKt1eLk3RR8M4kf7xMA4u8XILmoGFO7M4emr2zfh+EdApFZWo7F4/hZ1c1BZ9l5LmsghvlfanjAA1IhvwGlpgjWFq0gsuiKiPtJmNq28T4nLRzBgvNRQCco+sxajcVbwjHpk1847TFl5wEAlyPuIPUO40h2/n4aMqrKkFHF9R8BgB2Zeznl9h6tYCkWI2z8CE79gv3H2GuVRoOuPoxLt0ylxtaXnkZSQTFc7Wyh1vItL81hVLu7TBb1BgRFXk4ZPnl7K0b3XIz3XtiMrPQiTvvonovrLUuV8dBQDZwlfZFdXcZTARsytndYo77D1CHLGtW/pSKsLJqJWym56NHBuAk1gVj7ANISG7QmtbIEGq0WbhI7uEv0fg+p0nQEOTDq1aDvVyP1Pb69woNQJr+Bm/mzOKkJ60tnqMMc1euY3ksQfmNJg/1mTlzHKefllOLrjS+hXY9sAFpYiO3hInkMRXIpPCRM1vkxvZYgPGYJivIr4OHtjOQ799ExhOuLcvlcIgbUJple9sk+LFz+NGdsC0FIjPyoYqgVSaqMISKimIvJVFEqZeszKkt546Izss2af9GxCFLX6mojUzMa7H8yLZhOpgXTmYzebN2NvFmUXvaTyY85yZSnD9erQzevCqenBi7ltOvKY3vr1aizZ2zm9CmX36By2XUiIrpUkEZn7idz2qsqZURENL7fl0REtHjuH5z2J3ssYq+fHbGCiIgK7pc1+Oz/MQRtyKNEn1mr4WQnwbCeQVj06mgczdsGgHCn4ho+CN7As0A8fz8Nj7dmtjCRqRnIr6yCvY01xod0goaIF7cTAN7ffwRPdAjEsPaBuJGdixEdg7AhKhputrZ4sY/xfb4pj9GGqFFl4mLOGJOri9kvbsaGnW/xruvy3MiV+DPiQwCAtEoOB0cJSEu4ePYuBo/ghxQskFXBy9YRE/t/hcNXvsCVyGQsmrMTwV39oFSo4eJmj5joVJy4yWxJRvdcDB8/JgtaTbUCe858BFmNErZ2TNDeqgoZHJ1teff5jyGsLB5Vlm49ybGv0FFVzhhiFcuqKaYoh1QaxnFLrdFQabXeSGvPzTij81bI5ERE9PKOfWzdrZw8+uXydXauh8mdosV0Mi2YFOoS/rOUV9O6pYc4dWfDYyn8wA22/PXHe9jrj978jV0FfPD6Fjq6j7HFyCjbSFJFotH7H9nL9NGN2/HTOVr7FfeehiuLpwYuJZVSTU/2WES5WSWkUqpp4Ttbzf6+jzBNek+FA85/kM9eHgUHS35mMN1ioZXEDj3dfdmIWRZiMfbH3mH7Te8RCqWGCeryxbEItl6l0SA6Ixta0h9aSpUKdPf1xu6YxkXANofO7ksAANYWbry2l8evxQuzGIe3d55l3NOHje6K1WH6yFXnT8SDale4326eCSeDqNvjpjFRuWyt2kBDcuRW7uDdY8/v3PSGId3asCsGQ14atwYvjVsDWY0SllYW+HHPu3h10jpYWllgzJTejfnKLZOmSpuH9GnR6Kw4iYiS47JJrX74v/4PwnsHj3DKKcXF9M0Zron4x8dOcMpJRcVUF92v+tvPbKITf8fQyUM3672v4cpCR5XiDuVU/E4yVQ7dr6lg45Z+v0z/jM88wZyNxESn0uZVjAv+pXPGVyOzpmwwWv8fR1hZPKpkSxlPU2crvWVih1A/1sAIAP538S+T4+MqEvFz2i5OXURuMnsdtNu45+a+dK67+KDDG4z2E4tEiEzPwAu79qJcJsfZ1HQMCtB7v1bI5RDVLoOyyysQmZ6BpKJiZJbpPWhT7t5nzw3EYhGenNQToyb24KhGly/cx17LZUq2vy78oFqtgYN1Z/g6vQKJpS/KFTVYk8AYjT398iB27O7THwEANBr9iipsHvfvo+Pn/e8hOYGJAq59QLVxS0Ow4GxGxoT/ZLItpaIIqc9yYzxE5CZj46BpbDlk37e487Q+ZL2thYSz1Vh2KwJDvIPY8o+Dn2avCfrTrYFezCHmhBOMrYdKq8GEE7/gXmUxbk39ABKDcHvRWdnYNHkiXGwlaOPijK7e+hQAzhLG1mF11CXMHzIQbVyc2bZDu69i0rP90KEzo8K8G5eDrza8yLZvP6b3uv1kGfOcGfcK4R+oD8BbXlqN0T0XY+22N+DY9hQsRA4orP4buepP0aMVk1BZJBaBiJCbVQq/tozQLSuRYuZ7IzC652J07sYPTnw1KhlerV3QsYsvXp+8HjmZJayAEqiHpi5NHtJHwAiDDq2vt31PFnebEPjnUhp2ZCMF/rmUbpfkcupfOfdH3eFERPTUyV+JiCiutHnC4e+8yGxB0gpLKK2QORCNy86nPy/fJrlKRXdzC02O1WiNe5w+LKpl/7/z/wsQtiGPEl/dPMWre//yAV5d0O6vcWHibHwXa9pHo7NTe+TJ9JnBUp/9DMv7jkfqs5+hm1tr9PubSTI0rk1n3CzRJ945knUHYTEnsCb+POJK8/Ds6W2Iyk83uW3R0f3TdfW2G6OgQorUghK27O3iiF2Xb0Or1WvLj95MRG5ZJWwsLRHcmpsQiEjBXotFzKFll4/XGL1Xmew08ir5q7c+X3yPoqpqtrxg51Gj47Pyy4zWC9TSVGnzkD4thm9unuLVvRm1h1NecfsMjQ//mcaH/0z9Dq5hrwP/XMobW5foggw6lZNERETn799jr42NvVvGxK6sVimoTMGPm1EXuUpF83dwVzOG8TmMEfLR6gbnNYVSlUIaDd8orfvCdUb7a7V8F34iojHfbuGUb6TrXdYnrmJUptuPXSPVv+Rg+f+RJr2nwplFM6NLE2jI5sHckHYfdhuO97oMRui+FXi/yxDMCR2Kc3n3MMynvcl5CUD73V9j5/AZGOnbEf3+XourT81F179WIm7ah5y+vyVfxasd+yFfVolgF0+oSQsXa65BkqlfbwAIj03m1SV8O8/kOFNz6caYwkLsBVGd1IXHbyfh1jfvc+oeW7wJ0WHvoqh6HyzFTnCzG8dp1x2U6qiU6Vcrh+a/DABQqjT4bscZfPJKw9HHWixNlTYP6dNiUGk0FF+ax6mbf/kgr9+FfCZKtmE0q7qrg9MFF+nY/TOkqtlDqurdnHFERB9EHzI6Vnc9+jhjUl2hlLFtDSwUGoWpFYC5FJXMJpUqg4jqX6Ho2u5X/Eyy2v6GbL8QY3JscVU1ERHF3WsRKQyFlcWjxNzog/h+4FRO3YvtuQZBn10/hq/7cH8dASDlmU855UpVFQrkxdDYxsDG+RsA4HiPruw/EUqtBtZiC0xr1403X7AzE//C8Jf3elE2+nroNQhdP1nL+2U2xNTqQEsEVa3BWJeP1+BK2P/gIOEbStWHRDIU0pq9cHEyL0iNk+QxSCzbsmXDFc2yQ+dMjjv1yesIDRLyhjSEICyaGZ2gCNr9Nasq7eXux+ljKCjWJ0RhTigT6EZcxw/E3cYNWtLCyuFNQMRsb6RqJaePtdgCkXmpWNFvIlt3aRKzjF87gInIbbgFMRQUAOBib4uoL4z7cxgeGtal6ydrOYLElKAIPxWHi5fvoU0bN7z5Kje1gYPd05xyfVsjBoJUcQsONj3Q5eM1SPh2Hrp8vAYH573M6/n0+h3Y9vYz6O4vCAlzEYRFM1JWLUOFTI6wg6eR8ApjL5FbVglfVyck5hUh2EevCYhIuIe+gX6sQPn9wg0cvpWIdu6ukKvV+H7GJLhZu6BYUQaQBlrVTYitemJ8G75L+VCfIE7Zy9b8NAJKtekcoDUKFWBkKt1Lbfhy133RdYLEv00rBHfyQYA/N8ExAJRVLIed7SjYWPfmjDF1P4llIMS1QlPX19HWBh28+eH4Qv28eYLil7+jMeupx4zeQ0AQFs3KmFW/4cqid/HbLOYXc8nBCESnZuOFx7qjXyD3F31kl/Y4EJOAST1CYCEWoZ2HGxaMGQxPRwd8uOc4AEAitkFft24QWdhAJHbl3c8c1n75N+Yuespku1SuNPmLvv2dZ9DWne/bontRN566jP+NGsD+yhsjK5tRq56LTETC3ftY+fUzbJur8yeokRlXcxrDQszPdWoqj0i1QsEpbzt6DYG+pmN8CgjColkZEcL9hV8yeSRGrfwVcTn5PGGhw6I2EM6Ko+cxrnswUgtLsOIZJmFPoIM/9tyJxzMhoY16juKCSswY/R0mPtufJyhulyehu0sntpzw7TxkFpejrbsLDt+8i4k9O4NI7+xmikspmdgUEY3/jRrAqR+x7BecXjiLLY8Z1bXuUBaNpgC2klFsuaFtSKF0NzwduAmQXhho3CW/7tbk5fF9651bAII2pDlZsOso7b8RT/tvxNOMzfrw+NUKJd0r4DtgERHdztJrTr76+zT1C9tInRcyp//tanOYqqp3k6L8c97Y944fpsl7dhqd94cVx4iISKVUExFRujSH5BoF7cg4zOmnVKup7xffExHRoZg7bH1RpdSktaVGq6X91/T5WetqMrp8vJouJum1FsdPxrIfQ2rkek2QOdqQsprTnPohX/5ocgwRkVSut9isrJbTtmMPLzXBv5Qmvaf/tJBoUcLiYaNLeKyoXE1K6U8m2985+jcREV2ISGDbflhxjLas5xuI1cXwJTUUFro2uZFcJp/tOcHrV9+8REQ3jeTyKCqdW+8cdduUaq7AHV3HGKshpCYSGP2HEFSnjzI/XrmKt/vr82w2Jg9Iyv/mocPGNbCUjIbYih9NSsemcZMAAIMMIk7FXU/HC28OMzkmv7wKns4OSPh2HuZsP4wAd1f8ev4aJvbUH6DqtA2684jCSik8nRywdDoTXXzZoXNIK+QHGwaAy0ve4ZQjLyYjuKMPJBIrts7ddQ0ALXRxpRvahlTIo+AkeQzWFkxQYrVGg5T8EpP96x582ts2TrXb0hCERTOz5/cL6N63HTp18cWSiDMortarH9ttWMX5b32kz17ABsXRKK/yhIVuDmOCJyutCBt3v8up+yR2NQDARmyNsND34O2iV3Ose2kiTGF4cOnp5MBpWzhpGACgSsY9TAQAJ1tudO733zFlOcl8xx9fm4IhnQKM9tBZlKo1JbCy0GuU3BzsjGpCBB4MwZGsGdm44hhcWtmjUxcmyveHQwfj+6f0L2LMG8wLPLlTZ/ZjqpxVUcGOs7KfyblPUkkxAMDW0grG8A/04NUt7zYfk1oPx/xOr3DqRw1cyl4f++ocAKBayn351RotElOY7GVaIlyNScfd5DwAgFymgqOt3sR9xVeHjD6TKbRawsY1J0wKCgD4awXjbOft9DpEsGDr98x+gb3elxqHrKpyLLhovnZFoA5N3cc8pE+LZPm583QtO4e0GtOJjhtb1tWZyoG6eskB+mHFMVLIVexHx/6cCE7fmc9uJCIiuUxJh/czkbVfnMqNMHUrPpsiIu9SQhJjLp2aUUhR0Sl06vwdik9k3ORHDviK9u2KppLiKqPPVJcrl1Ia7HMt+h4REV29fK/BvmtvX6Avok9y6j5ee8hE7/80TXpPhZVFM0NE+HU946Ye7OEBiZUl4uNzcDGK75z1INS3/QAAWzvmVz47oxi/rjsJaxv9TnSKLzdB0W9/vgu1SgMbiRXWrWRsO3b89R6nT/cufhgxJBghHRkDp8C2Hhjcvz1GDu2MLp2YwDenLn2Oac/1xy+bzmDN8qMoLZFi7lu/m/wO/QYYd5gzjIDVpz+jhpbJlJDJlIg6l2hyvjndBqGbO3OOsS+ViUG6fA5/a/Xk25tMziEgbEOalZzMYqTcuY+R4xnd/1MhnRHq5QW3Vg6wsrZoYHTDrLnCZAUzJSiWfbIXEYdvAQDC5uxEVXlNg3NWV/PPG3QUFVSa9VybNzDC8aMvJiHmejoAYO3mmWy7QslYiR4Nv80ba4hhuEEAmD5+DYYO7wyJxBpDahMISavkRsc+HdSV818AeGwGc06Tml2Mx2asxskf3zU6VoBBEBbNiK9/K3Ts4svGrWTrfV1RVmraz8Ic2m1YhfVXL9erSVm4fDqefIpJKkwAkhJy8eoEroYhRZqpv07Mg7OLHery8ZydAAAPLydeW11uXE3DrHf1K5aCvHIs/ngPWz5wOAY21pZYvf4Ehg7uZGwKk+w9Og+jBi7lGIg5OBpPa5hbzRds0TuYTG5Bbdzx7Ohejbp3i6Sp+5iH9GmRLDoZQb/f4LpPP8iZhanzCWMc2HGJtBot1UjlNKbHIvpqwa4Gx4wc8BWNHPAVW542dhVFFx+g2LLTlC9LpZjS40REVCTPJJWGsVXIqb5LCeWRZj8XEVFllYxTHjv0G/ZaVqPk9V+/8jivbozBGB2H0+/Q9PCdVKNS0uhDvzbqmf5jNOk9FTKSNTMHdkVjyvOMs9Khu4lILirGB0MHs+3mqE0fhO/HTMD4DqZ/uX9N348ODv7IqsnDjLbMfv7m9XRUSxUYPCwYowYuxalLn2PjmhP437zRSKqKhkIjhYdNW4hFlvCStEOxIgtx5Wcx3OsVxJWfAUGLbi56lagu0xgAzHrxR2z6bRasnvWvoAAAIABJREFUrY1r748cjEH3nm3h5GzLrm4+nL0DKzfMAMCsejoE+yDqXCKCQ1rDw9P0KudeRQnUWi3iS/M525AWSJMykgnCohnZuOIYHn8yFBciEvD2B2ON9mm3YRXGBnVgy8dTUxost3dzQ5BrKzaGhEKjhkqjRZVSgUqFAlKlElVKhcktilKrwvXSeGTL8vG032hYiMRITy1EuyBPts/SL/bj86+mGh3fEDt/v4AXZw5uuKMRXnv+B2zZ9U69fea/sw2rf+C7oRvyXuQh3CjMgUgkwqVp3PmORCZgwtAuD/R8jxhC+sJHDaWCUVeWyWT0XeQFyskppatXUonowbchIT8Yj0qVmldMn2w9xpZX/x1JuyJvERHRj8cvc/rOjvmaiIiqFAq6lJ1FREQKtZoOJ+kT9bx/7AglFhUREdG13Bw6l5Fe73ctL6+hvPtldKVW1RkVmURxsdl07VpavePqo6hKStczmTiaW6NjaGn4WbbtUOxd+ugAk2Do1N17dC65/vs8NefnB36ORxBBdfooEX8rC1a1S++Nl6/gpV49YGEhRmtfvYt5RFJqo+ZMn70ANSqV0S1MoHcrLHtZv4qZN2kInhvCaGPeGsON3fBcG6afhVgM1K44v7t0ARM66rcvb/bpi7MZaQCAPq190dPbdPCY13fsh7OzLbx9XNCvVtU5eEhHhHb1Q58+TO6Sn7acx83bWdh34Dr2HbjOjg0OW4PgMOPm3fmVUhyJTwIASJVKzrpUYmUJFzsJtETo7ueN4mrjGp/8YubA8+DaWUbbBfgI5t7NjFajRcrd++jQuTU+G85EhsouKYFUKodvrcAY2SmovimMkj57AdptWNUo3xJjXCiOwWD3XhjQhsk89ukQbvSqLh6e6OKh35442fADEA/6bjNKal/SrLJy+LvyY17oePM1Zv6aGgUGDehgsp8hoa29ENqaSXb07pD+nLZRwe0xKpix0/BwsMe0Hsa3F97u/DOOx2asZjUkAnyElUUz0613AJulS0cb/1boHOLLluuLeVkfOiHRcdNas/qP6bEIY3os4tQNdjdfhShXq/HGzgPsKkD3KTH4NX9y/W9mzWWuoNBhatWho6S6BqM3cO8dnZ+F6PwsTt20BVtYYy9BUNSPsLL4B/gucTfC86/iCc+e+DRkBq+9bqzNxtDQCiPlzn2cPnobb384FuG3vuRYRQ5078le55ZX4khcIi6kZuJaZk6D953YNRjP9+2OXm1aN9jXkPBTcWwAnBde3Yw/fjMe79MYDQkMXZ/ExfNQppDhMW9/Xvtfq14DAFRVy+Fob9xGQ4BB0IY0I+POf4xjj3+Lsec/wq6Bi+BixfXSPJGagrePmedopRMEpoSCsfo1YQchq1bCzcMRZcVVIGJMqL9Y9RwWHzmN3Tdi4SSRwM/VCR093RHs7QF/V2cEe3ugtbN+2a57SRMX80PlXT8dj7hLKfDyb4Vxrwxl605sv4Cyoko8N38cjmw5hzYdfPD6EiaPa2FRJTw9uNuC+u7R2PZnTvyBsf6d4GhtjTYOLujvZTwqWQugSdoQYWXRjBx7/FtMjPoUY3z6wUpkiYWxP2NZtzfYdlsrKxx57iW0dnCEk0QCizorDIVGjcLqapTKZLiVn4ce9Rwu6lYYhgJj3uLJCN9/A9t/PAutRotdtVnHASBswgiETRhhbKpG0S7ED31GcMP8HfghAlPeGYk+I0Lx0+d7MOG1YTh/4BoAIOFuLnb8eRnLwp7G7zsuYOaMB1Ox1see0Yz3ablCDhcbZvVw9v49dHXzwbXCbIz1D8bVwiz08/RHRE4KRvo1bkvUUhDOLJqRqRe+QAcHXyRVZsPeUsIKirSEXCTGZGCofwC6eHjC1daWJygAwMbCEm2cnOFYRmhr1XCE7nMvv46rudwthLevK1753whWUNwqj0GKlHFi+ytnL3sNACnSZMRVxAIA7lQm4Hb5rQbvGXcpGddPx+PTqfotwpKd76G8qAqXjt7E5LdGIKibP+auZVzhu3T2xbIwJoBxfYLCMB/Kg7AvNY4VFABQKpfBXWKPDi5MVHEXa1uUKWoajC3akhFWFs3E3cpMDPXsjnfbM7k6lFo1VFo17C0lcPV0hKtHw34WkakZGBoUgPSkPGSnFeLxccaD0epo6+yCYdt+5awuevQP5PTREuFu5R10cOiIbi7dEV8Rhw4OHQEAWTVZUGmV6OjYESFOXSDTyBp8xmHTmKhfhqsLKxtLjHxugKkhZhH61Tq42tni8odvN3rsiaxkxJcUYKx/J8y9cBg/D5+GaYHMOUl7J0ZYdHRhYnyM8BVWFaYQVhbNRGentihXSrEj4yR2ZJyEtdgS9pbML11ZYRU2fb63wTmGBgUAANp18kGbQE9e+9m90SjO5WYCT5+9AG8d/dvofEqFCr1ce0NiwTyHk6UzQp315tC+tr7wkbSGjViChMp4/Jn9h1nfVUdw2Boo6sk7Ytiv7qduGwCU1cgaPNSsqeILtNH+HZFUXgR7K2sM99Wrped/dwD5JVUYMnMdHpuxGp9tOGLuV2uRCCuLZmRJ6Eyj9Xeup6HCDK/TshoZXOxskZGcD1mNEoHBPpxVw/DpjyFy/1UMndqPM+7r4aPqTgUAsLZhImk96TUGAOAl8YIXvNj2YEd9vM0uTqHo4mR+ygHdS9396w24/dls2Fia/qdW95DyjZ0HEHUvw2ibMV4OrU38TIBCrsTu1HW8Pl/0Yc5jXujYg62ztBDDu5Ujpo7ojnkvDcO2w1cbvFdLRhAWzYyaNLAUcWNXTHhlCCa8MqTBseGJKRjXuSOemNTTaPuxLeeQFJOODj0D4NNOv/Jwt9O7md++lg4rawuIRCJotQSVQs1uTSb+sA0phaYD3NbFHNUlYJ7AMEQnKMxlW/zKBvuEuPFXYg62XIMypUrTqPu2NARh0cxk1xTCSmQJSzEjMLwlboi/kgq/IE+4uNd/aPl8Lya5MREh+sxdDBjBDdIrEovgE+CBHz/+A2F75hqd4+M3+EZS4be+BAAcfqd+ZywdDakt1/96Bu+//gQAoLpGgfik+4i5nYUBvQON9n+YfDZlFb4+wFUZk+wQRLZMhPO06kwE2jPJk50dbXHwTCz+iriFeS8Nw/GLdzFratPOVv7LCMKimbhTkYE8eSlCndshu6YQEgsm7Ly3xA2lBRWwc5A0KCx0/LUlCpZW/MhaHn5ucPVyRkh/42HpAL1gUKs1sLRsenSuuly5mY78In2gGbVGC1uJNbp1ZixUF393GC5Odpj3pnlq2tCv1iHuizn1GghUlkjh1IqxWakrKAAAVAVSRCJJ6QOxwTGdWq3B8i0RAARTb3MQhEUzEeIcAF87D2xI3o+zhTcBAEeGLgMADJ3ENbFOLStFkKubybnGPtMP9nUiQrXbsApTDsnx9JyxUMiUJkbq0QmKIlk1DqYl4FZxHlYPHo/Yknz09WSyuseW5ONSXiayqsphZ2mF5zp2R3tn06H1ZXIV+vdsh/4927F1zo62rJVolVSOsA9MpxUAgF8uXueUe7Zpjc5ha2AhFiPhizm8/ie2RUFsEG5PXqPAxDee4HbS5ENk1R22YgmUpGKrF7zyBMRiMea9NAwA8MInW/HHcm50cwE9grBoRt69vgY7B3wOD4kL3grSvzS7vz8FK2tLTH1zOH69dQNLo87xrC/L5XK4SBgBUZBbBi9fV1Zg6LxNV5/6jO2fUR2HGk0lShQ5aGXthxDnQSAQCuTpcLbywKXiA+jq/DjsLL3xRpd+IDDmfTpBAQA50gp0cHHH5MAQHM1INPrrHpmXBkcrGxAIvdz9oNCocSgjAZ1dvWAlFqOTiyd6hjIWk44ODZtTfxcRxSlvnzkdBKBzrVYkYs5r8HNxZtuHTOkDO0dbKGRK2JhKEmQZBFiFoJVIBlsL7jPoBAUA9OnCNwcX0COoTpuRnQM+x8vR3+CtoIkgAwv3Z98bhalvDgcAvN6jN29cv19/RM+fN7LlwGAfzsri2uv84DAuVp4IcRqEGnUl2toznpe6jOLV6gp4S9rBU9IWDlY2tW18xrXthBF+QfC2c8TrIX0RZGRVMdQnED3dfdHLnREyNhaWmB7UHaFu3ujkwhwq3isqQXDYGnQ280C07lmICMCGZxjhOnLdFk6bnaMtAODsnmiEb42ERs033hLZTgYghoOlPSwMDpdPXU7CqctJbPnNaQPNer6WiiAsmpnuru2wJ/s0FBpmOXw07xL2Zp8BACRXZQPgRue+lJOFopr61aqG2g4AOLEtEi7WjAp0tM8bsLfUu4h7SwLhbuOHLs4Na18eFhM2bQPAOADtjYk32e9OXiGv7tfYGwCAUZ2Zc5hgL36CJAAY88pQjHllKCwsTf+TLldVQqnVb0NGDeiEUQM64eAZxkrVwY7vbi+gR9iGNDPjfJjTdt0Bp5a0sBYz/xsuFceiQiVFXze9fcNAP39YiETQ1Dr89fhpI6qUCqS+xz+MizpwDbaOEkga4T2ZVlyKhQdPYNbgvhgU2BZ21sazmDWW3IJy+HoxQipx8Txk3i9F29bMOUylVI6Lt9Lg6mSHx7oFsGOm/rQTT9SJ5aHQ6I26zLG5MAXJjyFN5otuLvz4FpOf6IY3wnbh58XPP/D8LQFhZdHMdHYKQGenALY8sfVgPOXLeGfObDeeIyh03KsVDNfv56JCIYeWyGhUrCFT+qLPyK54fFo/XpshCnUu7hQyruCB7m7YPet5jApujzL5DsQXzMS1nGFs35j7E3E1p+FVyLV4Jk7E8i0RqJDK4evlgvRcvc3G3lOMX0lqTjHEYhEG9ghEQGv9Ie5vl5kVxKbnJnHmdbaRQG6GFWhDiCxao0hRgu9TfmXr5LX5SmRyFX5e/DxSs4ubfJ//MoKw+BcxfPuWetv7tPZF+uwF2PoU49o9ec/ORs1/r2QxAKC45iRCPDcb7SMWSdDdZy8qFTeRXrYcANDP7zzyquo39e7TxR9aLeGT10bC2UGC6NgMWNVRzUbHZgBgAuTuDo9BTmE52/btyUh4OXJd9nX8lZxg1verF6seuC8rgLsNI6C2H76GY1F3sP90LI5fvIv9p2Nx6XZ60+/zH0bYhjQze7LO4hn/4UbbMsrLjK4Y6mpGhvoHIH32AoRFnuW4oRdkFUMsFkOtUnMsOHW0bxUGAPB1ehV5VTthb90ZTjZcta2W5LAQO0CpKYCDdSjKZBcBiOHj+AJvPh2p0jyUKCoQ6tIOdmD2/YbbCwCY+/Lj+CZhFxb5zUCQn7vRec7Pf4NX92KIaWe58aH81AbvDQ3D95GLuZWqeJDqNl5t9yJb9dLEvibnFTCOsLJoZkwJihkH9yLQ1Q0D/fwxJqgDJnToxH5MsXjocKTPXoDQzRsAAF7+7nBwsTMqKOri4/ginGx6QakpMqgVwd1uHCxEtsgsWwMP+wnQkgIEDW7lTTM5190KZgtiZ2GDdUkHAABfxu9g2ytU1diTeR6LQpmoYNk1RTiQc5Ft10Wziq24geulF9EQz2/ZDQBYNW0cpz58ayRfUACAVShEdoygePpn4yukv3Ial929JSKsLP4l7Jg8/YHHxr81m12R2NZjy1ChkGPlpQtYOnwk1l+9jIF+/gh0dYMbo32Er9NMAMzZCETMlqiP70kAQA+fv0zOW6mqxgRfJnDunE5TUK6UsoIBAJyt7NnryMI4DPXsiuul+rgZK6YwjmwBdkEokOfx5s+pqoCfo9624mb2fV6fjIQcjKmNzFUfFTLjuVCn+U0yWi+gRxAWzUiVWgZHS9sHHj965++NalcTIV9ahRqVCumzF8DO0gpD/Nti2cVIdHBrhfDUFHw+ZBgAoEalwk8x1zC3/0D09PZBfBFfjWmKFwK4FpMu1vyzB12foZ6MC/wUv0EAmEjgFz9gDlvTqpPhI/HjjTUUFDoMNSN3rtyDUt6w1SoAZJdVcMo7MvegRFmCia3HItA+wKw5WiqCsGgmFsf/hrDQVzH94mLM7qjP7DXUo/4ANoYkl9bvEVpfe9D3q5H63nyMDuqA0UH8AC92VlaY258xSrIQi9Hdy9usZzqfkIa2Hq4I8HTFH1G3kFlUhoVT9VutrOJy+Lu74GZ6LvZdjsfXL4xm24hqWEEBAN1d+kKt5Ws+Cmuq4WnHrE6Cw9bA2oJ7cBrSvz3eHbQYmy6G4dPJq/DNQfNTIXR0bI9+bs+Y3b8lIwiLZiIs9FXINUrsHRSGHRmnMCPAeIyJ+qgvH0hT84U8KLGZ+UgtKIGTrQQVNTJ4Ojsgo7AMAZ6u2HruBi4nZeLHt6bCyVaCpwdw42HU1OxGTc1ekLYcnl6XIIIIVmKunUd4egpyqiowq1sf3CtihGHs5+/znmPTRebwtj5BYSwqdD+3XlBqlbAWmzAVF2ARhEUzojPEMiUouvy4Hglv81+ExpJROBUBnvvr7SNT3oKtdQ/IlLdha90dZdIdcLB9AlYW3FD+hjErHG1soNRwYz74ezijoFyKzKIySKwt0T3ABwGeTLKkV4b1xvAujJFVkHcrnI3XZ1orL5sLtfoe7Oymw97+Vbb+XGE4hnmOYctj2ulXQRM2bcPZefwMYm899gUqS6UAgF3JXJPy4LA1eLFvdxCAP67dZusMtzGCoDAPQVg0MyPOzsfp4atRpCiHhw03U5epFISNXTHUKK4AAFTqLFhZ+qOy5iik8jNo7aafu0y6AyIHC2QWPo1gvxRUyU6gTLoNXi6fQ0tKONoy2c91L5VhljFDxvUMRkJGPgAgpK0XwrafQp8g5tyhskaOgtIqxKbeh5+7M9q46b+vs8tySKs2Qlq1HmKRC2ztpiBHlonHPUfz7gHwX3AdGrUWm6O/woFNpzj1iYvnsYJuZ62QMGwTaDyCsGhmJrRmzL0rVNUcYbHp+pVGzTN06y/IrmQO6xYOMq4FsLJkvCid7MajpGoTp61KFo5qRRQCvcMBAP4eWwGIkZY/CoHep+pOhYsfvIWCKikeX/0zAGDd9Am197DAiRvJaOvpijO3U/H2xAFY81ck5k0bCic7CW6l3odKrUHP9r7IKa5AKyc7uDrYoiC/DxydFsDauj+0VMX8TZRluFkWjYmtn+Xce9pPfxi1wQBg1BekXCmDi7WtSaHw7c2z+LincRW2gGkEYfEPQERo7+DLqXu3T3+826e/iRFcBvz2E/KlzAu2YcwETOjQCcsuRrLtIW1yeWPaeR3llDv51nXoEoOghq1NX6TmD0eQ91neHF6ODnjlsV5YOFqf/zSrsBxzpgyBjZUlfjtxFW08XOBk4JsS4OWKGyk58HV3hq+7Xqvh7cPc33ALUqTIh4WI+SdpGMn7rzdNG4QBwFiX12ElsYJKocKUd0dhb2os3ujM/VvuTLkJEYCnArrgqXbG858KNEBT07A/pE+LILM6n1Yn7iEiorevrSKNVmP22ID13xERUdD3q6nb5g0m2x+UhNI89lqj1dbbb+Xt03Q+716T7sfeS1P0UOYRMIsmvaeCBWcz4m/nhfc7MpaQP/SZj+V3dzV6jvi3ZmPndE/kVF9FbNku3C7dbrLvWH9+HE5jdQCQUsk4US2JCcfWlKv45Nphti0yPxWR+anYmnINIa7e6OfZFrtSY9h2mVTBm2/BlHUm7wUAGg2z+hGLjZt+131mw3vUN6+uPS0h1+gn8shNVNaJpJ5cda/BZxAQtiHNjoVIL5/z5eZH0tYhsbREqOsziCn5DdZiB/jY9zHab6z/XKw/sgApsdlIuJaGuzcyEHXsFr7d/R5SYpm4Ge9PWIXjWWux+MZxhPUeazBaxAbKAYCh3kG8/0bm6TUbtg42mN71U+yN+4atu3MjHcezTGdzt7DwRU3NLtjZ8d3C0xL426i8TL1HaM/BHZGWkAuNVov3x68yep/ALvpt3lj/uWyf7NQCOLnZc/rmyvKQK8vDcM/mi/HxSNLUpclD+vznUchVlHAjnYiIUuJz2Pq7NzPp7s1MIiK6l5BLCrmKiIhKamo445/568965zfchowLmMdeT+38Ma/vmDZz2OuL0Sm0cn04abVEicl5lJbBbAuS7uVTYnIeHTsVR1dupDX4/XRzamu3MN+88zuvz//GrGSv1ercBuc09rxEREvf2tJg/9T4HPZjWN6zKcLs+/4HEbYhjwqerV2xMewg8rL0Kwof/1bw8HFGRnI+2nbwgrUNs9g7kZrCGbt76rMgrX6cSnYQAKDVZHP6lRVV4mj6arasVDCRoQ7+ep6t6zWkE9S1OTKir6dh4pjuyM0rQ6cO3lDU9hcByCuowNiRoejXSx+A1xTHs9bizw2nIBKJcHjrBSzcxA98m5rA5F2tUOYitTqOra9Q5iJdGsXrr+OtxVM45c9+ZA5F69uOBHbxZT+GZU9fV17fMmU5r07ACE2VNg/p85/n3JFbpNVqSaNmDjVP7b/O63Pg9yg6vOMSERFN3fMHW6+SHSe1Mp5UsuNsnVJ2lFSyCNKos4i0SgpY/x3nYPL3FUc4c9f9da5bfhjcrV05PR26kIiIVi/4gzZ9sY+IiCZ3+pDtd7/6JpUq0kmmLiMiokJZIqVWnqWUilP1zm/uM9f3Xc/9fYPTdqXkOmlJS8WKErPmfsRp0nsqnFk0E4+PZ3xARBbMWcDIKfzAvJNf0WcR/2u6fi9vKam1aLTSq/ysJFz37Isz34DYIAX4i/PGoDFsX30cf6w9YXb/4ZN746P1L7FleY0Swb0CsO6T3ezZxfnDN/HcbMZa9UDiCravj10Pzlwekk7wkBh3xZ8a8jH23/mWVz/Wfy4Op616KLlP8uWF0FDTo3H91xGExT/AC1E/4cnWzIufXV0KZ2tbvB/MWEzOv/4nIguScX38Is6Y31O5cR7yZOVYGDoeqVWFCHL0RKosH60d9ZnYV8zejk9/mGn2M700fyxemj+24Y4mmBL8EY5lrsGc5XqDKoVMiW0rj+G59xrvB6PD2sYKy/63FQs36rc1Efuu1nt4Wl/b47U5Wi4cu43B47rD364NDuQegUKrwNwO/CjpAgY0dWnykD4tit5HwmjtnZO0O+MqPXFyBRERjT61im2Xq5V0syTT6Nhz+Yns9euXtpCWmK3H5cJ7VKWUsW3mbDu+fX8bEREdO3STrkbr7SY0Gr6dRVFhJRER5WSXUER4HNv/0olY+nvLeVLIlLwxY9rMoYRrDR+ONkTEX1dNfod3x6zgPuf9Mt4z/H9suR5RhAPOR43r4xehk7MPCmSV8JI444ekswgfyQTl3ZZ2CZ/d2o8ebvyENwqtGoM9GccqAmGwZ0dsTb2E6ec3IbEyH7HlOWzfD9fqg8+YOgg8e4AJkpuZUYyyEq7tQXoqN57F5u8jkJ5aiMoKGUaMDsXF80y+jQFPdkVgiC+sJVxv0c9f+hF7475BSJ92SLqVZfJvUS3dgqoqrvPX9lXHObYQI6aaDoG38fiHnLK7j96E3lBl2pBthkDDCMLiH2BFwnFEF91DVEESvu31NN7ppPdTCHLwwCuBg3hj7svKYSPW7xpFEGFm0CDMDBqEnJoyWIrEGOihz3H6xFTG/mJcwDxWe2CKt2ePRGi3NqioYBzFFn2yB+2CuKH5+g9sj3ZBnmwqwrkf6c9Miu7ztQk3zifCwZnJZzJ30mpee2HBQBQUDEB19S+oqWaM05JLGVuKgGdC4ORmj9MZqVBrtTiZrjeaunIqHmWFlbhwlIkWvuXrv0FEyErmRth6e+RyznbkeNZaQWA0laYuTR7Sp8VzOPuWWf1kav5yf/zpNUTEN9M2XH7XvR7TZg5t++7YgzwqjwmB81ktT9171VenQ61m7E7iCvOJiGhXQiwREaWXl1FKaTFb/zC0IWPazKHXH19q1jz/QZr0nv7TQqLFCou1+yPp1/ArtPSPCPrl+BUiIsotriBV7Uv38/FoupOZ/0BzTwicz6trjn27SqWmmQO/NNk+ps0c+vSFTUREVFG+mAryB1BlxXKz52/oO6ycu8OscecPx1D63ftm3/c/hCAsHkX2Rt6mtLwS+vtyPO04rdf9n49NpeIKKd28l0u7zt7kjZMrVA90v4XPb2SvEy4nsdc1VTI6sfUcfTZxOZ3Yeo7UKjX3ftVy2vblXvpl4U4iIlr1xo9G59+y7HCjnqcgfwBJpVtIKq3fGtMQWbWiUfcQ4CEIi/8yGq2Wzl5IpLMXGC3IvfRCo/3i7uZwyhWVMqP9iIjO771MJ7aeo0/Hf0NERM8HvENERIunruT0+24WIxhObD1HSjl/+6NDJlfS2u1n6dzVZLoQk0oHTt/mtN1JZVZId+7l0Yad54mIqFq6wyxhUVEq5ZSvnU+kI7WGa+z3OXqLZDUKtv3a+USqkcqpolRK331Yv5l8C0MQFv9liuu8LKaEwJY/LvDqbsZl0ddruOcSFw4wasjPn/qWrYvaf4VObD1H7/Th+5EQMcKiPnLyy0ij0VJcci7FJjE+H1XVcrY9Kb2AiIjyiyspJVMn7LQcYVGtzGD6SI8SEZFMlUOF1SdIpakgIqK7NzNM3l8nIIyxf8v5ep+9hdGk91TQhvzLaeVqj7MXktiyvZ01ft7O+FEkpuSz9WmZxTgdlYjTUYmc8QZGnQCAQZP7grSErw5+hKdcZwIANCoNnnz5cdRU8XNqXDtxG/EXErH6TSbdoaKGcRXfumQP28fXywVisQihHVqja0cmhqdhRvKOAYxmxauVI9r767Kgi2Bv/yrs7BgjLmsLV6g0peyYCkUMRLBChaI2bmaPtib/Rr2HdESfoXwL0AvhsZjy6lC8O4GvjRFoPCIiYzGPm51/xUMI/P9wMykHvh7OKCyTIjTIB3tP38JjoW2RnFWEEX07/tOP15IQNdylnsGCsBAQaDE0SVgI2xABAQGzEISFgICAWQjCQkBAwCz+LS7qTdpLCQgI/P8jrCwEBATMQhAWAgICZiEICwEBAbMQhIWAgIBZCMJCQEDALARhISAgYBaCsBAQEDALQVgICAj6bR9wAAAAb0lEQVSYhSAsBAQEzEIQFgICAmYhCAsBAQGzEISFgICAWQjCQkBAwCwEYSEgIGAWgrAQEBAwC0FYCAgImIUgLAQEBMxCEBYCAgJmIQgLAQEBsxCEhYCAgFkIwkJAQMAsBGEhICBgFoKwEBAQMIv/A/mnow7OlO28AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "<wordcloud.wordcloud.WordCloud at 0x20fab92aeb8>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "from wordcloud import WordCloud\n",
    "import matplotlib.pyplot as plt\n",
    "import jieba\n",
    "import os\n",
    "backgroup_Image = plt.imread('picture/phone.jpg') #笼罩图\n",
    "wordlist = jieba.cut(dataStr, cut_all=False)\n",
    "word_string = \" \".join(wordlist)\n",
    "wordcloud = WordCloud(font_path='front/simsun.ttc', background_color=\"white\",mask = backgroup_Image, width=1000, height=860, margin=2).generate(word_string)\n",
    "import matplotlib.pyplot as plt\n",
    "plt.imshow(wordcloud)\n",
    "plt.axis(\"off\")\n",
    "plt.show()\n",
    "wordcloud.to_file('picture/phoneComment.jpg')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "通过上面此图基本可以看出消费者对该款手机的整体评价，但其中可能还有一些刷单的情况，这些量无法控制，没法排除，因此还是要理性的看待一款手机综合性能。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"09a6603583d240fabcfbca9931b50a30\" style=\"width:800px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_09a6603583d240fabcfbca9931b50a30 = echarts.init(document.getElementById('09a6603583d240fabcfbca9931b50a30'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_09a6603583d240fabcfbca9931b50a30 = {\n",
       "    \"baseOption\": {\n",
       "        \"timeline\": {\n",
       "            \"bottom\": 0,\n",
       "            \"axisType\": \"category\",\n",
       "            \"loop\": true,\n",
       "            \"data\": [\n",
       "                \"2017 \\u5e74\",\n",
       "                \"2018 \\u5e74\",\n",
       "                \"2019 \\u5e74\"\n",
       "            ],\n",
       "            \"right\": \"auto\",\n",
       "            \"playInterval\": 2000,\n",
       "            \"rewind\": false,\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"autoPlay\": true,\n",
       "            \"symbolSize\": 10,\n",
       "            \"show\": true,\n",
       "            \"symbol\": \"emptyCircle\"\n",
       "        },\n",
       "        \"series\": [],\n",
       "        \"backgroundColor\": \"#F0F8FF\"\n",
       "    },\n",
       "    \"options\": [\n",
       "        {\n",
       "            \"title\": [\n",
       "                {\n",
       "                    \"left\": \"center\",\n",
       "                    \"subtextStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"top\": \"auto\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 18\n",
       "                    },\n",
       "                    \"text\": \"2017 \\u5e74\\u624b\\u673a\\u552e\\u51fa\\u60c5\\u51b5\"\n",
       "                }\n",
       "            ],\n",
       "            \"series\": [\n",
       "                {\n",
       "                    \"label\": {\n",
       "                        \"emphasis\": {\n",
       "                            \"formatter\": \"{b}: {d}%\",\n",
       "                            \"show\": true,\n",
       "                            \"textStyle\": {\n",
       "                                \"fontSize\": 12\n",
       "                            }\n",
       "                        },\n",
       "                        \"normal\": {\n",
       "                            \"formatter\": \"{b}: {d}%\",\n",
       "                            \"show\": true,\n",
       "                            \"textStyle\": {\n",
       "                                \"fontSize\": 12\n",
       "                            },\n",
       "                            \"position\": \"outside\"\n",
       "                        }\n",
       "                    },\n",
       "                    \"data\": [\n",
       "                        {\n",
       "                            \"value\": 1071,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 256GB \\u91d1\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 1071,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 256GB \\u94f6\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 1071,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 64GB \\u6df1\\u7a7a\\u7070\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 1071,\n",
       "                            \"name\": \"Apple iPhone 8 Plus 256GB \\u7ea2\\u8272\\u7279\\u522b\\u7248 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        }\n",
       "                    ],\n",
       "                    \"type\": \"pie\",\n",
       "                    \"seriesId\": 1396673,\n",
       "                    \"center\": [\n",
       "                        \"50%\",\n",
       "                        \"50%\"\n",
       "                    ],\n",
       "                    \"radius\": [\n",
       "                        \"40%\",\n",
       "                        \"75%\"\n",
       "                    ]\n",
       "                }\n",
       "            ],\n",
       "            \"color\": [\n",
       "                \"#c23531\",\n",
       "                \"#2f4554\",\n",
       "                \"#61a0a8\",\n",
       "                \"#d48265\",\n",
       "                \"#749f83\",\n",
       "                \"#ca8622\",\n",
       "                \"#bda29a\",\n",
       "                \"#6e7074\",\n",
       "                \"#546570\",\n",
       "                \"#c4ccd3\",\n",
       "                \"#f05b72\",\n",
       "                \"#ef5b9c\",\n",
       "                \"#f47920\",\n",
       "                \"#905a3d\",\n",
       "                \"#fab27b\",\n",
       "                \"#2a5caa\",\n",
       "                \"#444693\",\n",
       "                \"#726930\",\n",
       "                \"#b2d235\",\n",
       "                \"#6d8346\",\n",
       "                \"#ac6767\",\n",
       "                \"#1d953f\",\n",
       "                \"#6950a1\",\n",
       "                \"#918597\",\n",
       "                \"#f6f5ec\"\n",
       "            ],\n",
       "            \"legend\": [\n",
       "                {\n",
       "                    \"left\": \"left\",\n",
       "                    \"top\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"show\": false,\n",
       "                    \"data\": [\n",
       "                        \"Apple iPhone 8 Plus (A1864) 256GB \\u91d1\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus (A1864) 256GB \\u94f6\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus (A1864) 64GB \\u6df1\\u7a7a\\u7070\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus 256GB \\u7ea2\\u8272\\u7279\\u522b\\u7248 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                    ],\n",
       "                    \"selectedMode\": \"multiple\",\n",
       "                    \"orient\": \"vertical\"\n",
       "                }\n",
       "            ],\n",
       "            \"tooltip\": {\n",
       "                \"trigger\": \"item\",\n",
       "                \"borderWidth\": 0,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 14\n",
       "                },\n",
       "                \"triggerOn\": \"mousemove|click\",\n",
       "                \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "                \"axisPointer\": {\n",
       "                    \"type\": \"line\"\n",
       "                },\n",
       "                \"borderColor\": \"#333\"\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"title\": [\n",
       "                {\n",
       "                    \"left\": \"center\",\n",
       "                    \"subtextStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"top\": \"auto\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 18\n",
       "                    },\n",
       "                    \"text\": \"2018 \\u5e74\\u624b\\u673a\\u552e\\u51fa\\u60c5\\u51b5\"\n",
       "                }\n",
       "            ],\n",
       "            \"series\": [\n",
       "                {\n",
       "                    \"label\": {\n",
       "                        \"emphasis\": {\n",
       "                            \"formatter\": \"{b}: {d}%\",\n",
       "                            \"show\": true,\n",
       "                            \"textStyle\": {\n",
       "                                \"fontSize\": 12\n",
       "                            }\n",
       "                        },\n",
       "                        \"normal\": {\n",
       "                            \"formatter\": \"{b}: {d}%\",\n",
       "                            \"show\": true,\n",
       "                            \"textStyle\": {\n",
       "                                \"fontSize\": 12\n",
       "                            },\n",
       "                            \"position\": \"outside\"\n",
       "                        }\n",
       "                    },\n",
       "                    \"data\": [\n",
       "                        {\n",
       "                            \"value\": 2264,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 256GB \\u91d1\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 2264,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 256GB \\u94f6\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 2264,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 64GB \\u6df1\\u7a7a\\u7070\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 2264,\n",
       "                            \"name\": \"Apple iPhone 8 Plus 256GB \\u7ea2\\u8272\\u7279\\u522b\\u7248 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        }\n",
       "                    ],\n",
       "                    \"type\": \"pie\",\n",
       "                    \"seriesId\": 3712817,\n",
       "                    \"center\": [\n",
       "                        \"50%\",\n",
       "                        \"50%\"\n",
       "                    ],\n",
       "                    \"radius\": [\n",
       "                        \"40%\",\n",
       "                        \"75%\"\n",
       "                    ]\n",
       "                }\n",
       "            ],\n",
       "            \"color\": [\n",
       "                \"#c23531\",\n",
       "                \"#2f4554\",\n",
       "                \"#61a0a8\",\n",
       "                \"#d48265\",\n",
       "                \"#749f83\",\n",
       "                \"#ca8622\",\n",
       "                \"#bda29a\",\n",
       "                \"#6e7074\",\n",
       "                \"#546570\",\n",
       "                \"#c4ccd3\",\n",
       "                \"#f05b72\",\n",
       "                \"#ef5b9c\",\n",
       "                \"#f47920\",\n",
       "                \"#905a3d\",\n",
       "                \"#fab27b\",\n",
       "                \"#2a5caa\",\n",
       "                \"#444693\",\n",
       "                \"#726930\",\n",
       "                \"#b2d235\",\n",
       "                \"#6d8346\",\n",
       "                \"#ac6767\",\n",
       "                \"#1d953f\",\n",
       "                \"#6950a1\",\n",
       "                \"#918597\",\n",
       "                \"#f6f5ec\"\n",
       "            ],\n",
       "            \"legend\": [\n",
       "                {\n",
       "                    \"left\": \"left\",\n",
       "                    \"top\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"show\": false,\n",
       "                    \"data\": [\n",
       "                        \"Apple iPhone 8 Plus (A1864) 256GB \\u91d1\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus (A1864) 256GB \\u94f6\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus (A1864) 64GB \\u6df1\\u7a7a\\u7070\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus 256GB \\u7ea2\\u8272\\u7279\\u522b\\u7248 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                    ],\n",
       "                    \"selectedMode\": \"multiple\",\n",
       "                    \"orient\": \"vertical\"\n",
       "                }\n",
       "            ],\n",
       "            \"tooltip\": {\n",
       "                \"trigger\": \"item\",\n",
       "                \"borderWidth\": 0,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 14\n",
       "                },\n",
       "                \"triggerOn\": \"mousemove|click\",\n",
       "                \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "                \"axisPointer\": {\n",
       "                    \"type\": \"line\"\n",
       "                },\n",
       "                \"borderColor\": \"#333\"\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"title\": [\n",
       "                {\n",
       "                    \"left\": \"center\",\n",
       "                    \"subtextStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"top\": \"auto\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 18\n",
       "                    },\n",
       "                    \"text\": \"2019 \\u5e74\\u624b\\u673a\\u552e\\u51fa\\u60c5\\u51b5\"\n",
       "                }\n",
       "            ],\n",
       "            \"series\": [\n",
       "                {\n",
       "                    \"label\": {\n",
       "                        \"emphasis\": {\n",
       "                            \"formatter\": \"{b}: {d}%\",\n",
       "                            \"show\": true,\n",
       "                            \"textStyle\": {\n",
       "                                \"fontSize\": 12\n",
       "                            }\n",
       "                        },\n",
       "                        \"normal\": {\n",
       "                            \"formatter\": \"{b}: {d}%\",\n",
       "                            \"show\": true,\n",
       "                            \"textStyle\": {\n",
       "                                \"fontSize\": 12\n",
       "                            },\n",
       "                            \"position\": \"outside\"\n",
       "                        }\n",
       "                    },\n",
       "                    \"data\": [\n",
       "                        {\n",
       "                            \"value\": 1938,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 256GB \\u91d1\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 1939,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 256GB \\u94f6\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 1938,\n",
       "                            \"name\": \"Apple iPhone 8 Plus (A1864) 64GB \\u6df1\\u7a7a\\u7070\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        },\n",
       "                        {\n",
       "                            \"value\": 1936,\n",
       "                            \"name\": \"Apple iPhone 8 Plus 256GB \\u7ea2\\u8272\\u7279\\u522b\\u7248 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                        }\n",
       "                    ],\n",
       "                    \"type\": \"pie\",\n",
       "                    \"seriesId\": 4631571,\n",
       "                    \"center\": [\n",
       "                        \"50%\",\n",
       "                        \"50%\"\n",
       "                    ],\n",
       "                    \"radius\": [\n",
       "                        \"40%\",\n",
       "                        \"75%\"\n",
       "                    ]\n",
       "                }\n",
       "            ],\n",
       "            \"color\": [\n",
       "                \"#c23531\",\n",
       "                \"#2f4554\",\n",
       "                \"#61a0a8\",\n",
       "                \"#d48265\",\n",
       "                \"#749f83\",\n",
       "                \"#ca8622\",\n",
       "                \"#bda29a\",\n",
       "                \"#6e7074\",\n",
       "                \"#546570\",\n",
       "                \"#c4ccd3\",\n",
       "                \"#f05b72\",\n",
       "                \"#ef5b9c\",\n",
       "                \"#f47920\",\n",
       "                \"#905a3d\",\n",
       "                \"#fab27b\",\n",
       "                \"#2a5caa\",\n",
       "                \"#444693\",\n",
       "                \"#726930\",\n",
       "                \"#b2d235\",\n",
       "                \"#6d8346\",\n",
       "                \"#ac6767\",\n",
       "                \"#1d953f\",\n",
       "                \"#6950a1\",\n",
       "                \"#918597\",\n",
       "                \"#f6f5ec\"\n",
       "            ],\n",
       "            \"legend\": [\n",
       "                {\n",
       "                    \"left\": \"left\",\n",
       "                    \"top\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"show\": false,\n",
       "                    \"data\": [\n",
       "                        \"Apple iPhone 8 Plus (A1864) 256GB \\u91d1\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus (A1864) 256GB \\u94f6\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus (A1864) 64GB \\u6df1\\u7a7a\\u7070\\u8272 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\",\n",
       "                        \"Apple iPhone 8 Plus 256GB \\u7ea2\\u8272\\u7279\\u522b\\u7248 \\u79fb\\u52a8\\u8054\\u901a\\u7535\\u4fe14G\\u624b\\u673a\"\n",
       "                    ],\n",
       "                    \"selectedMode\": \"multiple\",\n",
       "                    \"orient\": \"vertical\"\n",
       "                }\n",
       "            ],\n",
       "            \"tooltip\": {\n",
       "                \"trigger\": \"item\",\n",
       "                \"borderWidth\": 0,\n",
       "                \"textStyle\": {\n",
       "                    \"fontSize\": 14\n",
       "                },\n",
       "                \"triggerOn\": \"mousemove|click\",\n",
       "                \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "                \"axisPointer\": {\n",
       "                    \"type\": \"line\"\n",
       "                },\n",
       "                \"borderColor\": \"#333\"\n",
       "            }\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "myChart_09a6603583d240fabcfbca9931b50a30.setOption(option_09a6603583d240fabcfbca9931b50a30);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.custom.timeline.Timeline at 0x20fbaf5bd30>"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Pie\n",
    "from pyecharts import Timeline\n",
    "#attr = [\"衬衫\", \"羊毛衫\", \"雪纺衫\", \"裤子\", \"高跟鞋\", \"袜子\"]\n",
    "attr = phone_type\n",
    "year1 = []\n",
    "year2 = []\n",
    "year3 = []\n",
    "Comment_data['购买时间'] = Comment_data['购买时间'].map(lambda x:x.split(' ')[0].split('-')[0])\n",
    "#print(Comment_data)\n",
    "#year1 = Comment_data[Comment_data['手机型号']==typ\n",
    "data1 = Comment_data[Comment_data['购买时间'] == '2017']\n",
    "data2 = Comment_data[Comment_data['购买时间'] == '2018']\n",
    "data3 = Comment_data[Comment_data['购买时间'] == '2019']\n",
    "#res = pd.concat([df1,df2,df3],axis=0,ignore_index=True)\n",
    "#data = Comment_data[Comment_data['手机型号']=='Apple iPhone 8 Plus 256GB 红色特别版 移动联通电信4G手机']\n",
    "v1 = [len(data1[data1['手机型号']==typ]) for typ in phone_type]\n",
    "v2 = [len(data2[data2['手机型号']==typ]) for typ in phone_type]\n",
    "v3 = [len(data3[data3['手机型号']==typ]) for typ in phone_type]\n",
    "#print(v1)\n",
    "#v2 = [len(Comment_data[Comment_data['手机型号']==typ]& Comment_data['购买时间'] == '2018') for typ in phone_type]\n",
    "#v3 = [len(Comment_data[Comment_data['手机型号']==typ]& Comment_data['购买时间'] == '2019') for typ in phone_type]\n",
    "#print(v1)\n",
    "pie_1 = Pie(\"2017 年手机售出情况\", title_pos='center',background_color='#F0F8FF')\n",
    "pie_1.add(\"\",attr,v1,radius=[40, 75],label_text_color=None,is_label_show=True,legend_orient=\"vertical\",legend_pos=\"left\",is_legend_show=False)\n",
    "pie_2 = Pie(\"2018 年手机售出情况\", title_pos='center',background_color='#F0F8FF')\n",
    "pie_2.add(\"\",attr,v2,radius=[40, 75],label_text_color=None,is_label_show=True,legend_orient=\"vertical\",legend_pos=\"left\",is_legend_show=False)\n",
    "pie_3 = Pie(\"2019 年手机售出情况\", title_pos='center',background_color='#F0F8FF')\n",
    "pie_3.add(\"\",attr,v3,radius=[40, 75],label_text_color=None,is_label_show=True,legend_orient=\"vertical\",legend_pos=\"left\",is_legend_show=False)\n",
    "timeline = Timeline(is_auto_play=True, timeline_bottom=0)\n",
    "timeline.add(pie_1, '2017 年')\n",
    "timeline.add(pie_2, '2018 年')\n",
    "timeline.add(pie_3, '2019 年')\n",
    "timeline\n",
    "#"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Referer反爬虫测试"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "url = \"https://sclub.jd.com/comment/productPageComments.action?callback=fetchJSON_comment98vv16247&productId=100000177760&score=0&sortType=5&page=6&pageSize=10&isShadowSku=0&rid=0&fold=1\"\n",
    "headers = {\n",
    "    'Accept': '*/*',\n",
    "    'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36',\n",
    "    'Referer':\"https://item.jd.com/100000177760.html#comment\"}\n",
    "r = requests.get(url,headers=headers)\n",
    "print(r.text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "name = \"\\xca\\xd6\\xbb\\xfa\\xba\\xdc\\xba\\xc3\\xa3\\xac\\xd0\\xc2\\xca\"\n",
    "print(name.encode().decode('unicode_escape'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [conda root]",
   "language": "python",
   "name": "conda-root-py"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}