predeal.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 数据预处理\n",
    "\n",
    "1. 根据商品活动时间筛选商品，得到以商品为索引的，某时间段的表格。\n",
    "2. 以商品评论为索引组织数据，得到列数为 商品数*平均评论数 的表格。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from dateutil.parser import parse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>品牌名称</th>\n",
       "      <th>sku_id</th>\n",
       "      <th>活动时间</th>\n",
       "      <th>商品名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>福库</td>\n",
       "      <td>49816790708</td>\n",
       "      <td>2020-01-02 14:58:53</td>\n",
       "      <td>福库（CUCKOO）电饭煲 IH电磁加热 多功能 新款高压电饭锅CRP-HR0899SR 3.8L</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>福库</td>\n",
       "      <td>50112986733</td>\n",
       "      <td>2020-01-02 14:59:19</td>\n",
       "      <td>【福库旗舰店】福库电饭煲 原装进口IH加热 多功能新款高压电饭锅 3.8升</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>北京故宫文化服务中心</td>\n",
       "      <td>63629984539</td>\n",
       "      <td>2020-01-03 11:24:24</td>\n",
       "      <td>故宫文创 故宫口红 毛戈平跃龙点韵 立体雕花滋润保湿 送女友生日礼物情人节文创彩妆</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>北京故宫文化服务中心</td>\n",
       "      <td>63629984538</td>\n",
       "      <td>2020-01-03 11:24:41</td>\n",
       "      <td>故宫文创 故宫口红 毛戈平跃龙点韵 立体雕花滋润保湿 送女友生日礼物情人节文创彩妆</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>北京故宫文化服务中心</td>\n",
       "      <td>63629984537</td>\n",
       "      <td>2020-01-03 11:24:48</td>\n",
       "      <td>故宫文创 故宫口红 毛戈平跃龙点韵 立体雕花滋润保湿 送女友生日礼物情人节文创彩妆</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         品牌名称       sku_id                活动时间  \\\n",
       "0          福库  49816790708 2020-01-02 14:58:53   \n",
       "1          福库  50112986733 2020-01-02 14:59:19   \n",
       "2  北京故宫文化服务中心  63629984539 2020-01-03 11:24:24   \n",
       "3  北京故宫文化服务中心  63629984538 2020-01-03 11:24:41   \n",
       "4  北京故宫文化服务中心  63629984537 2020-01-03 11:24:48   \n",
       "\n",
       "                                                商品名称  \n",
       "0  福库（CUCKOO）电饭煲 IH电磁加热 多功能 新款高压电饭锅CRP-HR0899SR 3.8L  \n",
       "1              【福库旗舰店】福库电饭煲 原装进口IH加热 多功能新款高压电饭锅 3.8升  \n",
       "2          故宫文创 故宫口红 毛戈平跃龙点韵 立体雕花滋润保湿 送女友生日礼物情人节文创彩妆  \n",
       "3          故宫文创 故宫口红 毛戈平跃龙点韵 立体雕花滋润保湿 送女友生日礼物情人节文创彩妆  \n",
       "4          故宫文创 故宫口红 毛戈平跃龙点韵 立体雕花滋润保湿 送女友生日礼物情人节文创彩妆  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "activity_path = \"./data/activity.xlsx\"\n",
    "activity_sheet = pd.read_excel(activity_path)\n",
    "activity_sheet.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>product_name</th>\n",
       "      <th>productId</th>\n",
       "      <th>afterCount</th>\n",
       "      <th>goodCount</th>\n",
       "      <th>generalCount</th>\n",
       "      <th>poorCount</th>\n",
       "      <th>comment_num</th>\n",
       "      <th>product_prices</th>\n",
       "      <th>hotComments</th>\n",
       "      <th>good_comment</th>\n",
       "      <th>middle_comment</th>\n",
       "      <th>poor_comment</th>\n",
       "      <th>product_comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NEObella韩国进口彩色隐形眼镜美瞳半年抛1片装14.0mm小直径 向日葵425度</td>\n",
       "      <td>100013000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>{\"J_100013000000\": {\"p\": \"-1.00\", \"op\": \"406.3...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>{}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>箭牌卫浴（ARROW）洗手盆卫生间洗脸盆柜组合洗漱台组合简约面盆实木浴室柜组合</td>\n",
       "      <td>24236949315</td>\n",
       "      <td>73</td>\n",
       "      <td>2000</td>\n",
       "      <td>10</td>\n",
       "      <td>74</td>\n",
       "      <td>3000</td>\n",
       "      <td>{\"J_24236949315\": {\"p\": \"-1.00\", \"op\": \"5699.0...</td>\n",
       "      <td>[{\"款式新颖\": 5}, {\"风格简约\": 4}, {\"吸力强劲\": 2}, {\"显得高端...</td>\n",
       "      <td>[{\"nickname\": \"j***Y\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"d***g\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"龙***痔\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{\"款式新颖\": [{\"nickname\": \"y***z\", \"score\": 5, \"c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NEObella韩国进口彩色隐形眼镜美瞳半年抛1片装14.0mm小直径 向日葵300度</td>\n",
       "      <td>100007000000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{\"J_100007000000\": {\"p\": \"169.00\", \"op\": \"169....</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>{}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>香奈儿（Chanel）口红唇膏可可小姐水亮/丝绒系列口红</td>\n",
       "      <td>62383970544</td>\n",
       "      <td>5</td>\n",
       "      <td>800</td>\n",
       "      <td>21</td>\n",
       "      <td>20</td>\n",
       "      <td>4000</td>\n",
       "      <td>{\"J_62383970544\": {\"p\": \"-1.00\", \"op\": \"158.00\"}}</td>\n",
       "      <td>[{\"提亮肤色\": 1}, {\"精美漂亮\": 1}, {\"不油不干\": 1}]</td>\n",
       "      <td>[{\"nickname\": \"jd_136638hgrq\", \"score\": 5, \"co...</td>\n",
       "      <td>[{\"nickname\": \"f***0\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"十***天\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{\"提亮肤色\": [{\"nickname\": \"小***蔓\", \"score\": 5, \"c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>魅可（M.A.C） mac新款子弹头哑光唇釉棒棒糖</td>\n",
       "      <td>57328615327</td>\n",
       "      <td>10</td>\n",
       "      <td>1000</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>3000</td>\n",
       "      <td>{\"J_57328615327\": {\"p\": \"199.00\", \"op\": \"328.0...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{\"nickname\": \"s***t\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"j***q\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"j***a\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  product_name     productId  afterCount  \\\n",
       "0  NEObella韩国进口彩色隐形眼镜美瞳半年抛1片装14.0mm小直径 向日葵425度  100013000000           0   \n",
       "1      箭牌卫浴（ARROW）洗手盆卫生间洗脸盆柜组合洗漱台组合简约面盆实木浴室柜组合   24236949315          73   \n",
       "2  NEObella韩国进口彩色隐形眼镜美瞳半年抛1片装14.0mm小直径 向日葵300度  100007000000           0   \n",
       "3                 香奈儿（Chanel）口红唇膏可可小姐水亮/丝绒系列口红   62383970544           5   \n",
       "4                    魅可（M.A.C） mac新款子弹头哑光唇釉棒棒糖   57328615327          10   \n",
       "\n",
       "   goodCount  generalCount  poorCount  comment_num  \\\n",
       "0          0             0          0            1   \n",
       "1       2000            10         74         3000   \n",
       "2          0             0          0            0   \n",
       "3        800            21         20         4000   \n",
       "4       1000            12         21         3000   \n",
       "\n",
       "                                      product_prices  \\\n",
       "0  {\"J_100013000000\": {\"p\": \"-1.00\", \"op\": \"406.3...   \n",
       "1  {\"J_24236949315\": {\"p\": \"-1.00\", \"op\": \"5699.0...   \n",
       "2  {\"J_100007000000\": {\"p\": \"169.00\", \"op\": \"169....   \n",
       "3  {\"J_62383970544\": {\"p\": \"-1.00\", \"op\": \"158.00\"}}   \n",
       "4  {\"J_57328615327\": {\"p\": \"199.00\", \"op\": \"328.0...   \n",
       "\n",
       "                                         hotComments  \\\n",
       "0                                                 []   \n",
       "1  [{\"款式新颖\": 5}, {\"风格简约\": 4}, {\"吸力强劲\": 2}, {\"显得高端...   \n",
       "2                                                 []   \n",
       "3            [{\"提亮肤色\": 1}, {\"精美漂亮\": 1}, {\"不油不干\": 1}]   \n",
       "4                                                 []   \n",
       "\n",
       "                                        good_comment  \\\n",
       "0                                                 []   \n",
       "1  [{\"nickname\": \"j***Y\", \"score\": 5, \"content\": ...   \n",
       "2                                                 []   \n",
       "3  [{\"nickname\": \"jd_136638hgrq\", \"score\": 5, \"co...   \n",
       "4  [{\"nickname\": \"s***t\", \"score\": 5, \"content\": ...   \n",
       "\n",
       "                                      middle_comment  \\\n",
       "0                                                 []   \n",
       "1  [{\"nickname\": \"d***g\", \"score\": 3, \"content\": ...   \n",
       "2                                                 []   \n",
       "3  [{\"nickname\": \"f***0\", \"score\": 3, \"content\": ...   \n",
       "4  [{\"nickname\": \"j***q\", \"score\": 3, \"content\": ...   \n",
       "\n",
       "                                        poor_comment  \\\n",
       "0                                                 []   \n",
       "1  [{\"nickname\": \"龙***痔\", \"score\": 1, \"content\": ...   \n",
       "2                                                 []   \n",
       "3  [{\"nickname\": \"十***天\", \"score\": 1, \"content\": ...   \n",
       "4  [{\"nickname\": \"j***a\", \"score\": 1, \"content\": ...   \n",
       "\n",
       "                                    product_comments  \n",
       "0                                                 {}  \n",
       "1  {\"款式新颖\": [{\"nickname\": \"y***z\", \"score\": 5, \"c...  \n",
       "2                                                 {}  \n",
       "3  {\"提亮肤色\": [{\"nickname\": \"小***蔓\", \"score\": 5, \"c...  \n",
       "4                                                 {}  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "allcomment_path = \"./data/comment3.csv\"\n",
    "comment_sheet = pd.read_csv(allcomment_path)\n",
    "comment_sheet.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>品牌名称</th>\n",
       "      <th>sku_id</th>\n",
       "      <th>活动时间</th>\n",
       "      <th>商品名称</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>华为</td>\n",
       "      <td>100009177406</td>\n",
       "      <td>2020-01-13 18:14:26</td>\n",
       "      <td>华为 HUAWEI Mate 30 Pro 5G 麒麟990 OLED环幕屏双4000万徕卡...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    品牌名称        sku_id                活动时间  \\\n",
       "259   华为  100009177406 2020-01-13 18:14:26   \n",
       "\n",
       "                                                  商品名称  \n",
       "259  华为 HUAWEI Mate 30 Pro 5G 麒麟990 OLED环幕屏双4000万徕卡...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product_id='100009177406'\n",
    "# product_id='64021836968'\n",
    "\n",
    "activity_sheet.query(f'sku_id == {product_id}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>product_name</th>\n",
       "      <th>productId</th>\n",
       "      <th>afterCount</th>\n",
       "      <th>goodCount</th>\n",
       "      <th>generalCount</th>\n",
       "      <th>poorCount</th>\n",
       "      <th>comment_num</th>\n",
       "      <th>product_prices</th>\n",
       "      <th>hotComments</th>\n",
       "      <th>good_comment</th>\n",
       "      <th>middle_comment</th>\n",
       "      <th>poor_comment</th>\n",
       "      <th>product_comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6122</th>\n",
       "      <td>华为 HUAWEI Mate 30 Pro 5G 麒麟990 OLED环幕屏双4000万徕卡...</td>\n",
       "      <td>100009177406</td>\n",
       "      <td>1000</td>\n",
       "      <td>3</td>\n",
       "      <td>400</td>\n",
       "      <td>600</td>\n",
       "      <td>10</td>\n",
       "      <td>{\"J_100009177406\": {\"p\": \"-1.00\", \"op\": \"7899....</td>\n",
       "      <td>[{\"反应超快\": 8}, {\"黑色大方\": 6}, {\"充电快速\": 5}, {\"清晰度高...</td>\n",
       "      <td>[{\"nickname\": \"A***个\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"熊***6\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"jd_185890khim\", \"score\": 1, \"co...</td>\n",
       "      <td>{\"反应超快\": [{\"nickname\": \"j***4\", \"score\": 5, \"c...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           product_name     productId  \\\n",
       "6122  华为 HUAWEI Mate 30 Pro 5G 麒麟990 OLED环幕屏双4000万徕卡...  100009177406   \n",
       "\n",
       "      afterCount  goodCount  generalCount  poorCount  comment_num  \\\n",
       "6122        1000          3           400        600           10   \n",
       "\n",
       "                                         product_prices  \\\n",
       "6122  {\"J_100009177406\": {\"p\": \"-1.00\", \"op\": \"7899....   \n",
       "\n",
       "                                            hotComments  \\\n",
       "6122  [{\"反应超快\": 8}, {\"黑色大方\": 6}, {\"充电快速\": 5}, {\"清晰度高...   \n",
       "\n",
       "                                           good_comment  \\\n",
       "6122  [{\"nickname\": \"A***个\", \"score\": 5, \"content\": ...   \n",
       "\n",
       "                                         middle_comment  \\\n",
       "6122  [{\"nickname\": \"熊***6\", \"score\": 3, \"content\": ...   \n",
       "\n",
       "                                           poor_comment  \\\n",
       "6122  [{\"nickname\": \"jd_185890khim\", \"score\": 1, \"co...   \n",
       "\n",
       "                                       product_comments  \n",
       "6122  {\"反应超快\": [{\"nickname\": \"j***4\", \"score\": 5, \"c...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comment_sheet.query(f'productId == {product_id}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>product_name</th>\n",
       "      <th>productId</th>\n",
       "      <th>afterCount</th>\n",
       "      <th>goodCount</th>\n",
       "      <th>generalCount</th>\n",
       "      <th>poorCount</th>\n",
       "      <th>comment_num</th>\n",
       "      <th>product_prices</th>\n",
       "      <th>hotComments</th>\n",
       "      <th>good_comment</th>\n",
       "      <th>middle_comment</th>\n",
       "      <th>poor_comment</th>\n",
       "      <th>product_comments</th>\n",
       "      <th>sku_id</th>\n",
       "      <th>活动时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>箭牌卫浴（ARROW）洗手盆卫生间洗脸盆柜组合洗漱台组合简约面盆实木浴室柜组合</td>\n",
       "      <td>24236949315</td>\n",
       "      <td>73</td>\n",
       "      <td>2000</td>\n",
       "      <td>10</td>\n",
       "      <td>74</td>\n",
       "      <td>3000</td>\n",
       "      <td>{\"J_24236949315\": {\"p\": \"-1.00\", \"op\": \"5699.0...</td>\n",
       "      <td>[{\"款式新颖\": 5}, {\"风格简约\": 4}, {\"吸力强劲\": 2}, {\"显得高端...</td>\n",
       "      <td>[{\"nickname\": \"j***Y\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"d***g\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"龙***痔\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{\"款式新颖\": [{\"nickname\": \"y***z\", \"score\": 5, \"c...</td>\n",
       "      <td>24236949315</td>\n",
       "      <td>2020-08-05 18:34:07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>香奈儿（Chanel）口红唇膏可可小姐水亮/丝绒系列口红</td>\n",
       "      <td>62383970544</td>\n",
       "      <td>5</td>\n",
       "      <td>800</td>\n",
       "      <td>21</td>\n",
       "      <td>20</td>\n",
       "      <td>4000</td>\n",
       "      <td>{\"J_62383970544\": {\"p\": \"-1.00\", \"op\": \"158.00\"}}</td>\n",
       "      <td>[{\"提亮肤色\": 1}, {\"精美漂亮\": 1}, {\"不油不干\": 1}]</td>\n",
       "      <td>[{\"nickname\": \"jd_136638hgrq\", \"score\": 5, \"co...</td>\n",
       "      <td>[{\"nickname\": \"f***0\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"十***天\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{\"提亮肤色\": [{\"nickname\": \"小***蔓\", \"score\": 5, \"c...</td>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>魅可（M.A.C） mac新款子弹头哑光唇釉棒棒糖</td>\n",
       "      <td>57328615327</td>\n",
       "      <td>10</td>\n",
       "      <td>1000</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>3000</td>\n",
       "      <td>{\"J_57328615327\": {\"p\": \"199.00\", \"op\": \"328.0...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{\"nickname\": \"s***t\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"j***q\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"j***a\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{}</td>\n",
       "      <td>57328615327</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>魅可（MAC)口红 经典头唇膏 棒棒糖唇釉</td>\n",
       "      <td>68292269899</td>\n",
       "      <td>4</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1000</td>\n",
       "      <td>{\"J_68292269899\": {\"p\": \"-1.00\", \"op\": \"208.00\"}}</td>\n",
       "      <td>[{\"极其好用\": 1}]</td>\n",
       "      <td>[{\"nickname\": \"j***p\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"丶***甜\", \"score\": 3, \"content\": ...</td>\n",
       "      <td>[{\"nickname\": \"j***m\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{\"极其好用\": [{\"nickname\": \"j***u\", \"score\": 5, \"c...</td>\n",
       "      <td>68292269899</td>\n",
       "      <td>2020-07-09 22:34:59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>汤姆福特(TOM FORD)TF口红唇膏子弹头套装小辣椒女士显色丰润唇膏礼物七夕情人节礼物</td>\n",
       "      <td>66472346588</td>\n",
       "      <td>20</td>\n",
       "      <td>500</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>6000</td>\n",
       "      <td>{\"J_66472346588\": {\"p\": \"-1.00\", \"op\": \"318.00\"}}</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{\"nickname\": \"j***t\", \"score\": 5, \"content\": ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{\"nickname\": \"只***e\", \"score\": 1, \"content\": ...</td>\n",
       "      <td>{}</td>\n",
       "      <td>66472346588</td>\n",
       "      <td>2020-07-09 22:40:46</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    product_name    productId  afterCount  \\\n",
       "0        箭牌卫浴（ARROW）洗手盆卫生间洗脸盆柜组合洗漱台组合简约面盆实木浴室柜组合  24236949315          73   \n",
       "1                   香奈儿（Chanel）口红唇膏可可小姐水亮/丝绒系列口红  62383970544           5   \n",
       "2                      魅可（M.A.C） mac新款子弹头哑光唇釉棒棒糖  57328615327          10   \n",
       "3                         魅可（MAC)口红 经典头唇膏 棒棒糖唇釉   68292269899           4   \n",
       "4  汤姆福特(TOM FORD)TF口红唇膏子弹头套装小辣椒女士显色丰润唇膏礼物七夕情人节礼物  66472346588          20   \n",
       "\n",
       "   goodCount  generalCount  poorCount  comment_num  \\\n",
       "0       2000            10         74         3000   \n",
       "1        800            21         20         4000   \n",
       "2       1000            12         21         3000   \n",
       "3        100             1          5         1000   \n",
       "4        500             0          1         6000   \n",
       "\n",
       "                                      product_prices  \\\n",
       "0  {\"J_24236949315\": {\"p\": \"-1.00\", \"op\": \"5699.0...   \n",
       "1  {\"J_62383970544\": {\"p\": \"-1.00\", \"op\": \"158.00\"}}   \n",
       "2  {\"J_57328615327\": {\"p\": \"199.00\", \"op\": \"328.0...   \n",
       "3  {\"J_68292269899\": {\"p\": \"-1.00\", \"op\": \"208.00\"}}   \n",
       "4  {\"J_66472346588\": {\"p\": \"-1.00\", \"op\": \"318.00\"}}   \n",
       "\n",
       "                                         hotComments  \\\n",
       "0  [{\"款式新颖\": 5}, {\"风格简约\": 4}, {\"吸力强劲\": 2}, {\"显得高端...   \n",
       "1            [{\"提亮肤色\": 1}, {\"精美漂亮\": 1}, {\"不油不干\": 1}]   \n",
       "2                                                 []   \n",
       "3                                      [{\"极其好用\": 1}]   \n",
       "4                                                 []   \n",
       "\n",
       "                                        good_comment  \\\n",
       "0  [{\"nickname\": \"j***Y\", \"score\": 5, \"content\": ...   \n",
       "1  [{\"nickname\": \"jd_136638hgrq\", \"score\": 5, \"co...   \n",
       "2  [{\"nickname\": \"s***t\", \"score\": 5, \"content\": ...   \n",
       "3  [{\"nickname\": \"j***p\", \"score\": 5, \"content\": ...   \n",
       "4  [{\"nickname\": \"j***t\", \"score\": 5, \"content\": ...   \n",
       "\n",
       "                                      middle_comment  \\\n",
       "0  [{\"nickname\": \"d***g\", \"score\": 3, \"content\": ...   \n",
       "1  [{\"nickname\": \"f***0\", \"score\": 3, \"content\": ...   \n",
       "2  [{\"nickname\": \"j***q\", \"score\": 3, \"content\": ...   \n",
       "3  [{\"nickname\": \"丶***甜\", \"score\": 3, \"content\": ...   \n",
       "4                                                 []   \n",
       "\n",
       "                                        poor_comment  \\\n",
       "0  [{\"nickname\": \"龙***痔\", \"score\": 1, \"content\": ...   \n",
       "1  [{\"nickname\": \"十***天\", \"score\": 1, \"content\": ...   \n",
       "2  [{\"nickname\": \"j***a\", \"score\": 1, \"content\": ...   \n",
       "3  [{\"nickname\": \"j***m\", \"score\": 1, \"content\": ...   \n",
       "4  [{\"nickname\": \"只***e\", \"score\": 1, \"content\": ...   \n",
       "\n",
       "                                    product_comments       sku_id  \\\n",
       "0  {\"款式新颖\": [{\"nickname\": \"y***z\", \"score\": 5, \"c...  24236949315   \n",
       "1  {\"提亮肤色\": [{\"nickname\": \"小***蔓\", \"score\": 5, \"c...  62383970544   \n",
       "2                                                 {}  57328615327   \n",
       "3  {\"极其好用\": [{\"nickname\": \"j***u\", \"score\": 5, \"c...  68292269899   \n",
       "4                                                 {}  66472346588   \n",
       "\n",
       "                 活动时间  \n",
       "0 2020-08-05 18:34:07  \n",
       "1 2020-07-09 22:37:19  \n",
       "2 2020-07-09 22:37:19  \n",
       "3 2020-07-09 22:34:59  \n",
       "4 2020-07-09 22:40:46  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comment_activity_sheet = pd.merge(\n",
    "    comment_sheet,\n",
    "    activity_sheet[[\"sku_id\", \"活动时间\"]],\n",
    "    left_on=\"productId\",\n",
    "    right_on=\"sku_id\",\n",
    ")\n",
    "comment_activity_sheet.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('商品数：', (6880, 13), '活动数：', (28889, 4), '商品-活动数：', (6818, 15))"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"商品数：\", comment_sheet.shape, \"活动数：\", activity_sheet.shape, \"商品-活动数：\", comment_activity_sheet.shape\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "july = \"2020-07-01 00:00:00\"\n",
    "august = \"2020-08-01 00:00:00\"\n",
    "september = \"2020-09-01 00:00:00\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "after_february = comment_activity_sheet[\n",
    "    comment_activity_sheet[\"活动时间\"]\n",
    "    > \"2020-02-01 00:00:00\"\n",
    "]\n",
    "\n",
    "before_july = after_february[\n",
    "    after_february[\"活动时间\"] < july\n",
    "]\n",
    "before_august = after_february[\n",
    "    after_february[\"活动时间\"] < august\n",
    "]\n",
    "before_september = after_february[\n",
    "    after_february[\"活动时间\"] < september\n",
    "]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('before_july: ',\n",
       " (1397, 15),\n",
       " 'before_august: ',\n",
       " (2804, 15),\n",
       " 'before_september: ',\n",
       " (3836, 15))"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'before_july: ',before_july.shape,\\\n",
    "'before_august: ',before_august.shape,\\\n",
    "'before_september: ',before_september.shape,\\\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "\n",
    "max_time_span = datetime.timedelta(days=90)\n",
    "zero_time_span = datetime.timedelta(days=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "may='2020-05-01 00:00:00'\n",
    "november='2020-11-01 00:00:00'\n",
    "\n",
    "def get_comments(x):\n",
    "    result=[]\n",
    "    \n",
    "    time_span = datetime.timedelta(days=0)\n",
    "    for y in eval(x[1]).values():\n",
    "        for z in y:\n",
    "            _span = x[0]-parse(z[\"referenceTime\"])\n",
    "            if _span > zero_time_span:\n",
    "                if _span > max_time_span:\n",
    "                    time_span=max_time_span\n",
    "                    break\n",
    "                elif _span>time_span:\n",
    "                    time_span=_span\n",
    "                    \n",
    "\n",
    "\n",
    "    time_ceiling=x[0]+time_span\n",
    "    time_floor=x[0]-time_span\n",
    "    for y in eval(x[1]).values():\n",
    "        for z in y:\n",
    "            if parse(z[\"referenceTime\"])>time_floor and parse(z[\"referenceTime\"])<time_ceiling:\n",
    "                result.append((z[\"referenceTime\"], z[\"content\"]))\n",
    "    return result\n",
    "\n",
    "# before_august.dropna(subset=['product_comments'])\n",
    "product_comment=before_august[['活动时间','product_comments']].apply(get_comments,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_comments_(x):\n",
    "    result=[]\n",
    "\n",
    "        \n",
    "    time_span = datetime.timedelta(days=0)\n",
    "    for y in eval(x[1]):\n",
    "        _span = x[0]-parse(y[\"referenceTime\"])\n",
    "        if _span > zero_time_span:\n",
    "            if _span > max_time_span:\n",
    "                time_span=max_time_span\n",
    "                break\n",
    "            elif _span>time_span:\n",
    "                time_span=_span\n",
    "\n",
    "    time_ceiling=x[0]+time_span\n",
    "    time_floor=x[0]-time_span\n",
    "    for y in eval(x[1]):\n",
    "        if parse(y[\"referenceTime\"])>time_floor and parse(y[\"referenceTime\"])<time_ceiling:\n",
    "            result.append((y[\"referenceTime\"], y[\"content\"]))\n",
    "    return result\n",
    "    \n",
    "# todo 可合并\n",
    "poor_comment=before_august[['活动时间','poor_comment']].apply(get_comments_,axis=1)\n",
    "middle_comment=before_august[['活动时间','middle_comment']].apply(get_comments_,axis=1)\n",
    "good_comment=before_august[['活动时间','good_comment']].apply(get_comments_,axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1    [(2020-04-29 19:44:36, 产品质感：感觉是假的，和正品的不一样), (2...\n",
       " 2    [(2020-06-09 22:22:32, 质量一塌糊涂，拆开用都没用就坏了\\n客服有和没...\n",
       " 3    [(2020-07-12 08:41:30, 显色效果：跟没涂一样), (2020-06-3...\n",
       " 4                                                   []\n",
       " 5    [(2020-06-18 00:15:02, 差劲差劲???????????????????...\n",
       " dtype: object,\n",
       " 1    [(2020-06-19 17:54:45, 好小，刚收到还没有用，用了在追加评论吧！送钥匙...\n",
       " 2    [(2020-09-01 19:21:29, 颜色有点儿太深了     冬天涂着还好), (...\n",
       " 3                                                   []\n",
       " 4                                                   []\n",
       " 5                                                   []\n",
       " dtype: object,\n",
       " 1    [(2020-06-16 16:54:53, 宝贝q收到就迫不及待打开，包装很安全，还送了钥...\n",
       " 2    [(2020-08-01 23:59:32, 包装得很好，我女朋友说很好用不容易掉色), (...\n",
       " 3    [(2020-06-12 21:23:28, 质量很好，包装盒很nice), (2020-0...\n",
       " 4    [(2020-08-26 03:36:07, 产品质量好，颜色艳丽，女朋友很喜欢), (20...\n",
       " 5    [(2020-07-03 14:49:28, 产品质感：手感很轻便，整体偏滋润\\n产品颜色：...\n",
       " dtype: object,\n",
       " 1    []\n",
       " 2    []\n",
       " 3    []\n",
       " 4    []\n",
       " 5    []\n",
       " dtype: object)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "poor_comment.head(),\\\n",
    "middle_comment.head(),\\\n",
    "good_comment.head(),\\\n",
    "product_comment.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('2020-04-29 19:44:36', '产品质感：感觉是假的，和正品的不一样'),\n",
       " ('2020-04-18 21:52:42', '差的要命'),\n",
       " ('2020-06-27 12:20:38', '不是正品'),\n",
       " ('2020-06-27 12:20:38', '不是正品'),\n",
       " ('2020-05-26 15:16:10', '太干了，不知道是不是假的'),\n",
       " ('2020-08-12 23:40:59', '产品质量差，欺骗消费者，不是正品，弄虚作假，'),\n",
       " ('2020-05-20 12:31:14', '本次体验非常不好，以后不会来买了。'),\n",
       " ('2020-07-08 18:41:05', '质量非常差！'),\n",
       " ('2020-04-17 10:29:14',\n",
       "  '产品质感：收到货打开后都是断的，虽然客服补偿了，说吹风机吹一下可以接回来，搞的我手上衣服上到处都是，心里很不爽，到最后彻底没用了???'),\n",
       " ('2020-04-17 10:29:14',\n",
       "  '产品质感：收到货都是断的，客服说吹风吹一下可以接回来。，结果搞得到处都是，弄的衣服上都是，我穿的还是白衣服，费我一件衣服，，一件衣服几百块钱，你个破口红给毁了，，搞的我现在特别气愤'),\n",
       " ('2020-06-26 16:48:30', '假的'),\n",
       " ('2020-06-19 17:54:45', '好小，刚收到还没有用，用了在追加评论吧！送钥匙链还可以，'),\n",
       " ('2020-07-30 18:04:08', '香奈儿的口红有一股香味，味道好闻，抹上口红一天，香味也持续不断，个人不喜欢带香味的口红，是正品'),\n",
       " ('2020-06-04 11:39:53', '为什么二维码扫不出来，'),\n",
       " ('2020-06-05 01:19:12', '沾杯又掉色'),\n",
       " ('2020-06-19 14:43:48', '不像正品'),\n",
       " ('2020-06-17 19:52:41', '持久效果：效果还是不错，但是没用两天既然断了，现在都没法用了'),\n",
       " ('2020-05-22 14:04:37', '太小了'),\n",
       " ('2020-08-08 10:11:21',\n",
       "  '为了买一支称心如意的，花了很多时间，查阅了很多资料，终于盼到了，大失所望，上色卡粉，先涂润唇膏还是卡粉，真怀疑是不是假的，果断另外买ct'),\n",
       " ('2020-06-16 16:54:53',\n",
       "  '宝贝q收到就迫不及待打开，包装很安全，还送了钥匙链，礼品盒，礼品袋，卖家考虑的很周全，送人很大气，不过我是自己用的。，打开口红有淡淡香味，上唇试了，图一是薄图，图二是半厚图半薄图，颜色个人比较满意，喜欢的宝宝可以果断下哦手，用的其他品牌的都是正装量，用不完过期挺可以的，迷你装的够用不用担心用不完！'),\n",
       " ('2020-05-03 12:27:12',\n",
       "  '非常不错，小小的一只装在包里随身携带很方便，颜色也很正，也很称肤色，非常喜欢，谢谢店家送的小熊钥匙扣非常漂亮！'),\n",
       " ('2020-05-11 19:01:21',\n",
       "  '收到快递迫不及待的打开了，口红的盒子高大上，让我惊喜的是，竟然看到一个小礼物，太可爱了，感谢卖家，口红是我要的颜色，热卖豆沙色，和图片颜色没有差别，爱了爱了，我决定要关注店铺，接着买、买、买，祝店家生意兴隆！财源滚滚！'),\n",
       " ('2020-04-28 16:40:26', '小小的，很适合出门带，颜色很漂亮，不涂唇膏也不会太干，很喜欢'),\n",
       " ('2020-05-19 12:12:10', '口红质量很好，涂起来不干，很显白，是正品'),\n",
       " ('2020-04-13 15:20:25',\n",
       "  '宝贝收到了，特意用了才来评价，质感细门腻，颜色非常正，而且持久不掉色，不沾杯，用后滋润不起皮，显得皮肤也白了好多，非常喜欢，下次还会回购的。'),\n",
       " ('2020-08-09 12:03:35',\n",
       "  '包装完好，口红外卖用充气袋保护者，非常好，之前看评论还担心路上会损坏了呢，这个担心是多余的。颜色也漂亮，赠品非常实用'),\n",
       " ('2020-08-03 17:23:41', '商品很好，很喜欢，送人的，朋友也很喜欢，质量也不错。总体是不错的，。'),\n",
       " ('2020-06-20 18:29:09', '好用是真的好用，mini也是真的mini，很顺滑，味道也好闻，但是感觉颜色不适合我'),\n",
       " ('2020-05-29 16:52:35',\n",
       "  '挺好的，很漂亮，而且小小的很好，包装很好，送的小礼物也很好，平时买的正装口红太多都用不完，就喜欢这种小小的优惠装，物美价廉。就是需要戴口罩还不能涂。'),\n",
       " ('2020-05-24 16:37:15',\n",
       "  '产品质感：轻盈不油腻\\n产品颜色：很正\\n持久效果：一般\\n滋润效果：很滋润\\n适合肤色：白皮\\n其他特色：膏体形状颜色都很漂亮\\n客服态度也很好呀，送的礼品也很好看，爱了爱了'),\n",
       " ('2020-06-13 14:41:58', '颜色很正，气味也好闻，搽后不容易脱妆，小样的质量一样值得信赖。'),\n",
       " ('2020-06-11 17:00:15', '颜色很好看，肤色显白，味道好闻，滋润效果很好'),\n",
       " ('2020-07-07 10:53:25',\n",
       "  '产品质感：正品\\n产品颜色：如描述一致\\n持久效果：很好\\n滋润效果：很好\\n适合肤色：应该说适合各种肤色'),\n",
       " ('2020-06-19 12:02:47', '很喜欢这款口红，涂上很自然很滋润'),\n",
       " ('2020-05-19 14:09:16', '产品质感：老婆特喜欢，这个颜色适合很多性格的女人，方便携带，作为携带补妆最合适。'),\n",
       " ('2020-06-13 10:26:47', '包装很漂亮，送的钥匙扣也很可爱，很喜欢，期待用过后有满意的效果！会再次回购！'),\n",
       " ('2020-06-27 14:11:29', '总的来说是很好的，颜色有点不适合我，真的很小样\\n产品质感：挺好'),\n",
       " ('2020-06-03 15:22:52', '口红很棒，第一次购买，感觉颜色好看，比较持久。'),\n",
       " ('2020-06-18 19:34:24', '是正品，太好看了吧，这个外壳我爱了，包装也特别严实，很喜欢'),\n",
       " ('2020-05-15 21:28:30', '口红颜色正，款式漂亮，温和滋润，包装精美，价格实惠，很满意！'),\n",
       " ('2020-04-15 15:56:52', '口红颜色不错，很合适我的肤色，很显白。'),\n",
       " ('2020-05-15 16:36:29', '产品质感：非常好\\n产品颜色：好好看\\n持久效果：涂了几分钟后会更好看\\n适合肤色：黄皮白皮都适合'),\n",
       " ('2020-05-13 11:31:33', '服务态度真好，物流也好的一批，残次品返回去，我收不到货物，就当作花钱喂狗了。'),\n",
       " ('2020-06-26 07:43:47', '好看，淡淡的涂上一层，气色好很多'),\n",
       " ('2020-07-26 14:41:04', '非常好，最近都买小样，因为大样真的用不完啊'),\n",
       " ('2020-06-16 13:05:59', '包装很精美，还没使用，试用了再追加吧，不过送的小坠子不错，叮叮**'),\n",
       " ('2020-05-20 18:56:37', '超级喜欢，颜色很好看，香香的'),\n",
       " ('2020-07-06 18:45:23', '很喜欢，味道香香的，很滋润'),\n",
       " ('2020-07-30 14:45:17', '香味很好闻，送人很不错，很喜欢'),\n",
       " ('2020-06-16 09:45:13', '口红很好，送礼盒又送小熊，物美价廉??'),\n",
       " ('2020-05-21 14:05:59', '产品质感：豆沙色给妈妈很有气质很好看！'),\n",
       " ('2020-06-16 13:10:32', '不错，包装很好，看上去高大上'),\n",
       " ('2020-05-21 14:05:59', '很喜欢，枫叶给自己，上嘴好看。'),\n",
       " ('2020-04-14 20:30:43', '滋润效果：效果很好用原来很好看'),\n",
       " ('2020-06-15 13:08:58', '非常棒，送的小熊也特别喜欢'),\n",
       " ('2020-07-05 22:29:36', '特别好！大赞，推荐大家买'),\n",
       " ('2020-04-13 15:03:24', '宝贝很棒。物流也快。好评！'),\n",
       " ('2020-06-15 14:49:38', '是正品，非常好，喜欢'),\n",
       " ('2020-07-09 08:42:05', '太小了吧！还是不错的，有点小贵'),\n",
       " ('2020-05-28 20:32:07',\n",
       "  '第一次买这个牌子的口红，想试试，颜色和颜值都好喜欢，就是味道是一种花香?味，个人觉得没有巧克力的好闻。'),\n",
       " ('2020-06-12 15:07:00',\n",
       "  '第一次买大牌，不知道是不是正品，就是味道挺好闻的，也挺润的，就是量真的好少，还没根拇指大，瞬间感觉不值，哈哈哈哈'),\n",
       " ('2020-05-28 17:06:02', '小小的一只，携带方便，唯一的缺点就是口红顶端蹭到里面的壳上了。希望涂上不干吧。颜色看着可以，比较鲜亮'),\n",
       " ('2020-08-04 12:47:30', '送的钥匙扣很好，就是找不到口红的生产日期。还没用，包装完好。'),\n",
       " ('2020-07-29 10:03:48', '颜色没得说，很漂亮，但是个人觉得还是有点干。'),\n",
       " ('2020-05-30 16:39:58', '还没有开始使用，不过有淡淡的香味，太爱！还送了小礼物很喜欢'),\n",
       " ('2020-05-19 19:49:54', '哑光的说实话我不是很喜欢，不过香味还可以，'),\n",
       " ('2020-04-14 19:08:57', '东西不错，就是颜色不太适合我，涂上不太好看'),\n",
       " ('2020-08-05 14:21:55', '好看，个人觉得，颜色更柔和自然保护区管'),\n",
       " ('2020-06-25 20:11:59', '质量不错，外观精美，比较实用'),\n",
       " ('2020-07-12 20:05:51', '喜欢，自己用的好给盆友买又给妹妹买！好东西要分享'),\n",
       " ('2020-07-15 11:25:26', '颜色棒棒哒，谢谢卖家送的小礼物'),\n",
       " ('2020-07-29 22:31:18', '口红? 非常好就是价格有点高'),\n",
       " ('2020-06-19 08:08:18', '产品质感：挺好京东买东西方便，送货也快，'),\n",
       " ('2020-06-13 19:00:25', '精致，美观，携带方便。'),\n",
       " ('2020-05-19 18:23:27', '这个口红不错，好喜欢'),\n",
       " ('2020-06-19 08:08:18', '京东买东西方便，送货也快，'),\n",
       " ('2020-05-06 15:50:33', '正品  还送礼物  开心'),\n",
       " ('2020-06-23 17:38:29', '还没用就掉了！也不知道好不好！还有没有了'),\n",
       " ('2020-06-15 07:11:38', '不错，很好看'),\n",
       " ('2020-06-22 21:47:47', '产品质感：非常棒\\n产品颜色：非常棒\\n持久效果：非常棒'),\n",
       " ('2020-07-20 16:45:09', '产品质感：是正品\\n滋润效果：很滋润'),\n",
       " ('2020-07-25 11:41:49', '产品颜色：好看\\n产品质感：很好'),\n",
       " ('2020-06-20 09:29:19', '产品颜色：颜色正，和大只一样'),\n",
       " ('2020-04-15 18:51:49', '口红到货了，和描述的一样。赞'),\n",
       " ('2020-05-15 21:01:49', '还不错第一次网购很顺利'),\n",
       " ('2020-07-22 06:53:43', '产品颜色：挺喜欢的啊'),\n",
       " ('2020-07-26 06:17:18', '还好，先用一下再评论。'),\n",
       " ('2020-05-26 21:25:31', '挺不错的，老婆也喜欢'),\n",
       " ('2020-08-22 13:59:35', '很小，显色度还可以'),\n",
       " ('2020-07-28 14:29:40', '太喜欢！味道也好闻'),\n",
       " ('2020-07-08 12:50:09', '还没用不知道效果'),\n",
       " ('2020-07-03 09:45:27', '其他特色：包装还行'),\n",
       " ('2020-05-28 14:38:29', '品牌就是值得信赖'),\n",
       " ('2020-05-05 18:24:51', '产品颜色：颜色不错'),\n",
       " ('2020-06-18 07:25:43', '非常显白的色号'),\n",
       " ('2020-06-18 23:42:16', '产品颜色：很艳丽'),\n",
       " ('2020-06-18 19:16:10', '很喜欢这个颜色'),\n",
       " ('2020-06-09 20:46:05', '是我喜欢的类型'),\n",
       " ('2020-08-08 15:50:23', '适合肤色：不错'),\n",
       " ('2020-05-18 11:37:32', '喜欢，颜色很好看'),\n",
       " ('2020-05-04 10:53:37', '产品颜色：很显白'),\n",
       " ('2020-07-29 14:17:21', '滋润效果：很好'),\n",
       " ('2020-07-13 13:35:29', '产品颜色：好看'),\n",
       " ('2020-06-18 06:38:26', '收到了，很喜欢，'),\n",
       " ('2020-06-12 14:11:37', '很好用，不掉色'),\n",
       " ('2020-04-17 16:28:48', '颜色好，很滋润。'),\n",
       " ('2020-04-19 07:36:35', '看上去还不错'),\n",
       " ('2020-07-12 23:19:26', '还没用过呢！'),\n",
       " ('2020-07-15 20:56:20', '太喜欢了'),\n",
       " ('2020-06-15 09:07:22', '颜色很正'),\n",
       " ('2020-06-02 06:31:19', '很好看咯'),\n",
       " ('2020-07-23 14:04:31', '挺好的'),\n",
       " ('2020-06-18 12:00:27', '很好用'),\n",
       " ('2020-06-16 13:53:40', '喜欢'),\n",
       " ('2020-07-12 14:46:43', '产品质感：不好\\n产品颜色：与图和描述不同。不是豆沙色。\\n持久效果：差\\n滋润效果：不好'),\n",
       " ('2020-05-19 16:02:18',\n",
       "  '打开后口红上方有人为损坏，应该是盖盖子时候伤到的，因为口红盖子内没有口红损坏的残留物，给客服说了以后给我反了十元的补贴，希望以后这些问题能改善吧'),\n",
       " ('2020-05-23 15:05:25',\n",
       "  '之前用的是3.5g的，好润好用。这次想携带方便点买1.2g完全有对比，1.2g直接判断假得不能用，不上色，涂了有一层脱皮的样子，难看，用一次都不敢用了。花了钱，买了假货，后悔到不能相信网购，实体店还好找一下。真的太差'),\n",
       " ('2020-05-18 15:33:11', '有股淡淡的玫瑰香气，颜色也好看，涂起来不显唇纹，也不拔干。'),\n",
       " ('2020-05-17 06:35:10', '包装一般，有送礼品。口红盖子有明显划痕，一点都不像新的。'),\n",
       " ('2020-06-19 15:24:43', '这种假货也拿出来骗人/根本扫这个商品不出来！就证明假货'),\n",
       " ('2020-06-17 21:07:59', '东西不好，不滋润掉色也很严重，和便宜的一个样'),\n",
       " ('2020-06-05 01:19:12', '这哪叫不沾杯，又干又一直掉色'),\n",
       " ('2020-06-19 13:09:50', '这个珊瑚色为啥跟想象中的不一样呢？'),\n",
       " ('2020-07-23 15:01:29', '颜色不好看  特别小一**'),\n",
       " ('2020-05-22 20:23:10', '快递超级慢啊  京东第一次买到这么慢的物流'),\n",
       " ('2020-07-06 18:04:48', '颜色太深了，不太适合我，送人了'),\n",
       " ('2020-07-19 23:03:06', '这个可能是个假牌子，会掉色，'),\n",
       " ('2020-08-04 14:39:16', '感觉有点干，不觉得是正品'),\n",
       " ('2020-05-25 16:17:19', '跟官方买的不一样，怀疑是不是正品'),\n",
       " ('2020-05-20 15:58:09', '跟预计送达时间不一样'),\n",
       " ('2020-06-03 18:34:01', '那么小点我怀疑换包'),\n",
       " ('2020-05-11 06:55:30', '不掉色，又起坨'),\n",
       " ('2020-05-15 13:01:09', '实在太小了'),\n",
       " ('2020-06-18 04:31:49', '物流有点慢'),\n",
       " ('2020-05-29 00:25:01', '味不喜欢'),\n",
       " ('2020-08-22 10:20:47', '好好'),\n",
       " ('2020-06-09 18:51:40', '可以')]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comment=poor_comment+middle_comment+good_comment+product_comment\n",
    "comment.values[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "137  to  136\n",
      "78  to  69\n",
      "30  to  30\n",
      "119  to  119\n",
      "56  to  51\n",
      "0  to  0\n",
      "26  to  24\n",
      "39  to  28\n",
      "20  to  20\n",
      "8  to  2\n",
      "10  to  5\n",
      "63  to  63\n",
      "10  to  9\n",
      "29  to  2\n",
      "210  to  203\n",
      "192  to  179\n",
      "90  to  9\n",
      "135  to  103\n",
      "12  to  12\n",
      "9  to  8\n",
      "9  to  8\n",
      "0  to  0\n",
      "238  to  236\n",
      "121  to  104\n",
      "34  to  29\n",
      "22  to  22\n",
      "0  to  0\n",
      "21  to  11\n",
      "7  to  7\n",
      "2  to  2\n",
      "185  to  174\n",
      "206  to  169\n",
      "67  to  62\n",
      "41  to  39\n",
      "201  to  2\n",
      "10  to  1\n",
      "13  to  12\n",
      "1  to  1\n",
      "11  to  11\n",
      "1  to  1\n",
      "12  to  3\n",
      "0  to  0\n",
      "20  to  18\n",
      "437  to  399\n",
      "22  to  19\n",
      "0  to  0\n",
      "0  to  0\n",
      "30  to  30\n",
      "0  to  0\n",
      "0  to  0\n",
      "29  to  26\n",
      "11  to  9\n",
      "34  to  23\n",
      "5  to  5\n",
      "9  to  9\n",
      "4  to  3\n",
      "11  to  11\n",
      "61  to  44\n",
      "3  to  3\n",
      "0  to  0\n",
      "0  to  0\n",
      "240  to  26\n",
      "1  to  1\n",
      "0  to  0\n",
      "241  to  232\n",
      "30  to  27\n",
      "79  to  79\n",
      "538  to  520\n",
      "232  to  197\n",
      "189  to  187\n",
      "119  to  119\n",
      "29  to  27\n",
      "440  to  343\n",
      "308  to  301\n",
      "349  to  340\n",
      "390  to  385\n",
      "124  to  123\n",
      "75  to  70\n",
      "143  to  134\n",
      "224  to  200\n",
      "599  to  551\n",
      "72  to  69\n",
      "1  to  1\n",
      "107  to  100\n",
      "160  to  156\n",
      "148  to  96\n",
      "3  to  3\n",
      "3  to  3\n",
      "52  to  51\n",
      "127  to  116\n",
      "3  to  3\n",
      "105  to  100\n",
      "295  to  277\n",
      "2  to  2\n",
      "1  to  1\n",
      "7  to  7\n",
      "1485  to  7\n",
      "0  to  0\n",
      "191  to  186\n",
      "8  to  8\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "358  to  319\n",
      "974  to  2\n",
      "189  to  3\n",
      "115  to  109\n",
      "0  to  0\n",
      "9  to  9\n",
      "15  to  13\n",
      "15  to  12\n",
      "65  to  63\n",
      "7  to  7\n",
      "1180  to  86\n",
      "12  to  10\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "72  to  71\n",
      "0  to  0\n",
      "4  to  4\n",
      "186  to  168\n",
      "217  to  215\n",
      "14  to  11\n",
      "11  to  8\n",
      "0  to  0\n",
      "0  to  0\n",
      "40  to  40\n",
      "6  to  4\n",
      "153  to  152\n",
      "20  to  5\n",
      "0  to  0\n",
      "31  to  4\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "412  to  408\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "280  to  273\n",
      "31  to  31\n",
      "135  to  103\n",
      "0  to  0\n",
      "68  to  63\n",
      "158  to  155\n",
      "0  to  0\n",
      "55  to  54\n",
      "4  to  4\n",
      "0  to  0\n",
      "1  to  1\n",
      "17  to  17\n",
      "0  to  0\n",
      "25  to  22\n",
      "18  to  16\n",
      "19  to  17\n",
      "242  to  220\n",
      "0  to  0\n",
      "3  to  3\n",
      "0  to  0\n",
      "1  to  1\n",
      "12  to  11\n",
      "7  to  7\n",
      "164  to  159\n",
      "64  to  64\n",
      "0  to  0\n",
      "3  to  3\n",
      "0  to  0\n",
      "0  to  0\n",
      "12  to  3\n",
      "1  to  1\n",
      "10  to  8\n",
      "9  to  4\n",
      "8  to  8\n",
      "53  to  53\n",
      "0  to  0\n",
      "0  to  0\n",
      "41  to  41\n",
      "0  to  0\n",
      "3  to  3\n",
      "43  to  43\n",
      "1  to  1\n",
      "15  to  15\n",
      "21  to  17\n",
      "73  to  47\n",
      "97  to  1\n",
      "0  to  0\n",
      "179  to  178\n",
      "120  to  116\n",
      "10  to  10\n",
      "0  to  0\n",
      "135  to  95\n",
      "221  to  216\n",
      "0  to  0\n",
      "155  to  101\n",
      "540  to  26\n",
      "40  to  1\n",
      "0  to  0\n",
      "112  to  109\n",
      "514  to  507\n",
      "14  to  6\n",
      "192  to  188\n",
      "182  to  173\n",
      "577  to  571\n",
      "201  to  197\n",
      "243  to  9\n",
      "105  to  105\n",
      "247  to  209\n",
      "556  to  395\n",
      "197  to  192\n",
      "227  to  224\n",
      "85  to  82\n",
      "293  to  271\n",
      "68  to  61\n",
      "1490  to  17\n",
      "51  to  51\n",
      "0  to  0\n",
      "3  to  2\n",
      "147  to  3\n",
      "2  to  1\n",
      "1  to  1\n",
      "0  to  0\n",
      "386  to  317\n",
      "64  to  62\n",
      "898  to  872\n",
      "1  to  1\n",
      "7  to  7\n",
      "135  to  5\n",
      "17  to  17\n",
      "4  to  2\n",
      "7  to  7\n",
      "34  to  34\n",
      "1991  to  19\n",
      "66  to  58\n",
      "56  to  10\n",
      "80  to  2\n",
      "16  to  13\n",
      "60  to  2\n",
      "54  to  49\n",
      "298  to  177\n",
      "9  to  9\n",
      "17  to  15\n",
      "673  to  14\n",
      "2  to  2\n",
      "0  to  0\n",
      "31  to  29\n",
      "22  to  22\n",
      "88  to  88\n",
      "33  to  30\n",
      "1367  to  926\n",
      "22  to  22\n",
      "69  to  63\n",
      "803  to  565\n",
      "3  to  3\n",
      "11  to  11\n",
      "15  to  2\n",
      "302  to  259\n",
      "55  to  55\n",
      "143  to  142\n",
      "89  to  62\n",
      "64  to  62\n",
      "429  to  390\n",
      "123  to  108\n",
      "33  to  30\n",
      "4  to  4\n",
      "124  to  123\n",
      "373  to  361\n",
      "11  to  5\n",
      "3694  to  97\n",
      "419  to  406\n",
      "271  to  213\n",
      "154  to  145\n",
      "305  to  8\n",
      "6  to  6\n",
      "526  to  462\n",
      "4  to  4\n",
      "56  to  56\n",
      "467  to  466\n",
      "159  to  144\n",
      "40  to  39\n",
      "3  to  1\n",
      "159  to  127\n",
      "76  to  73\n",
      "0  to  0\n",
      "28  to  28\n",
      "20  to  20\n",
      "138  to  130\n",
      "0  to  0\n",
      "243  to  183\n",
      "246  to  236\n",
      "1172  to  1099\n",
      "48  to  46\n",
      "9  to  9\n",
      "10  to  8\n",
      "2  to  2\n",
      "34  to  33\n",
      "2000  to  33\n",
      "0  to  0\n",
      "3  to  3\n",
      "1  to  1\n",
      "45  to  45\n",
      "16  to  11\n",
      "4  to  4\n",
      "21  to  21\n",
      "16  to  15\n",
      "8  to  4\n",
      "445  to  410\n",
      "214  to  214\n",
      "0  to  0\n",
      "0  to  0\n",
      "156  to  4\n",
      "0  to  0\n",
      "0  to  0\n",
      "183  to  182\n",
      "87  to  84\n",
      "583  to  20\n",
      "75  to  71\n",
      "416  to  245\n",
      "395  to  368\n",
      "192  to  191\n",
      "319  to  303\n",
      "81  to  3\n",
      "133  to  4\n",
      "0  to  0\n",
      "89  to  33\n",
      "30  to  29\n",
      "3  to  3\n",
      "1392  to  12\n",
      "30  to  30\n",
      "47  to  47\n",
      "7  to  7\n",
      "68  to  55\n",
      "638  to  9\n",
      "196  to  195\n",
      "32  to  29\n",
      "59  to  53\n",
      "797  to  694\n",
      "9  to  9\n",
      "75  to  63\n",
      "226  to  164\n",
      "18  to  18\n",
      "598  to  447\n",
      "10  to  10\n",
      "4  to  4\n",
      "34  to  30\n",
      "35  to  14\n",
      "75  to  70\n",
      "7  to  7\n",
      "12  to  12\n",
      "129  to  128\n",
      "37  to  32\n",
      "2  to  2\n",
      "104  to  14\n",
      "138  to  129\n",
      "136  to  20\n",
      "936  to  933\n",
      "0  to  0\n",
      "54  to  54\n",
      "95  to  95\n",
      "0  to  0\n",
      "119  to  118\n",
      "343  to  336\n",
      "310  to  299\n",
      "653  to  617\n",
      "86  to  65\n",
      "1  to  1\n",
      "7  to  7\n",
      "84  to  80\n",
      "13  to  13\n",
      "9  to  9\n",
      "83  to  73\n",
      "43  to  41\n",
      "306  to  6\n",
      "25  to  25\n",
      "324  to  297\n",
      "1  to  1\n",
      "7  to  7\n",
      "117  to  97\n",
      "899  to  724\n",
      "21  to  21\n",
      "2  to  2\n",
      "31  to  30\n",
      "0  to  0\n",
      "0  to  0\n",
      "14  to  14\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "1169  to  9\n",
      "141  to  123\n",
      "6  to  6\n",
      "508  to  508\n",
      "94  to  94\n",
      "346  to  236\n",
      "21  to  18\n",
      "171  to  171\n",
      "2  to  2\n",
      "80  to  77\n",
      "699  to  9\n",
      "542  to  541\n",
      "62  to  9\n",
      "413  to  409\n",
      "93  to  11\n",
      "122  to  91\n",
      "168  to  166\n",
      "245  to  165\n",
      "91  to  91\n",
      "48  to  6\n",
      "13  to  12\n",
      "2  to  2\n",
      "4  to  4\n",
      "390  to  319\n",
      "12  to  9\n",
      "15  to  15\n",
      "98  to  83\n",
      "0  to  0\n",
      "992  to  28\n",
      "8  to  8\n",
      "503  to  493\n",
      "489  to  489\n",
      "13  to  12\n",
      "35  to  27\n",
      "984  to  2\n",
      "1568  to  1228\n",
      "395  to  5\n",
      "10  to  10\n",
      "69  to  60\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "29  to  21\n",
      "0  to  0\n",
      "5  to  5\n",
      "36  to  32\n",
      "29  to  28\n",
      "7  to  6\n",
      "41  to  40\n",
      "8  to  7\n",
      "91  to  10\n",
      "413  to  407\n",
      "27  to  26\n",
      "174  to  141\n",
      "32  to  29\n",
      "566  to  419\n",
      "4  to  4\n",
      "22  to  22\n",
      "25  to  25\n",
      "564  to  31\n",
      "81  to  70\n",
      "72  to  71\n",
      "4  to  4\n",
      "0  to  0\n",
      "141  to  118\n",
      "21  to  21\n",
      "13  to  11\n",
      "489  to  482\n",
      "8  to  8\n",
      "104  to  101\n",
      "54  to  39\n",
      "4  to  4\n",
      "107  to  71\n",
      "23  to  23\n",
      "447  to  311\n",
      "1  to  1\n",
      "122  to  111\n",
      "4  to  2\n",
      "112  to  95\n",
      "0  to  0\n",
      "819  to  530\n",
      "247  to  160\n",
      "16  to  15\n",
      "1333  to  731\n",
      "101  to  3\n",
      "356  to  233\n",
      "66  to  66\n",
      "6  to  6\n",
      "157  to  157\n",
      "23  to  22\n",
      "3546  to  8\n",
      "58  to  54\n",
      "14  to  14\n",
      "0  to  0\n",
      "335  to  334\n",
      "2  to  2\n",
      "8  to  7\n",
      "174  to  157\n",
      "115  to  84\n",
      "45  to  43\n",
      "23  to  20\n",
      "15  to  15\n",
      "0  to  0\n",
      "28  to  28\n",
      "189  to  179\n",
      "4  to  3\n",
      "17  to  17\n",
      "0  to  0\n",
      "22  to  22\n",
      "0  to  0\n",
      "168  to  166\n",
      "2  to  2\n",
      "7  to  1\n",
      "276  to  260\n",
      "94  to  93\n",
      "49  to  46\n",
      "16  to  15\n",
      "3  to  3\n",
      "6  to  5\n",
      "163  to  147\n",
      "199  to  181\n",
      "0  to  0\n",
      "0  to  0\n",
      "41  to  40\n",
      "7  to  7\n",
      "0  to  0\n",
      "86  to  61\n",
      "3  to  3\n",
      "52  to  45\n",
      "390  to  3\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "9  to  9\n",
      "0  to  0\n",
      "366  to  225\n",
      "238  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "639  to  301\n",
      "40  to  39\n",
      "409  to  390\n",
      "185  to  185\n",
      "11  to  8\n",
      "15  to  15\n",
      "151  to  126\n",
      "15  to  15\n",
      "5  to  5\n",
      "15  to  13\n",
      "10  to  10\n",
      "9  to  9\n",
      "38  to  38\n",
      "425  to  423\n",
      "2  to  2\n",
      "2  to  2\n",
      "44  to  43\n",
      "27  to  27\n",
      "1  to  1\n",
      "94  to  91\n",
      "4  to  4\n",
      "3  to  3\n",
      "577  to  479\n",
      "152  to  151\n",
      "2552  to  15\n",
      "115  to  109\n",
      "96  to  93\n",
      "65  to  65\n",
      "157  to  125\n",
      "526  to  396\n",
      "1334  to  2\n",
      "357  to  338\n",
      "28  to  28\n",
      "33  to  31\n",
      "59  to  43\n",
      "43  to  41\n",
      "12  to  12\n",
      "289  to  4\n",
      "4  to  4\n",
      "7  to  7\n",
      "115  to  115\n",
      "269  to  197\n",
      "72  to  28\n",
      "110  to  5\n",
      "1037  to  776\n",
      "123  to  118\n",
      "502  to  464\n",
      "222  to  111\n",
      "40  to  40\n",
      "7  to  7\n",
      "129  to  129\n",
      "78  to  77\n",
      "20  to  19\n",
      "75  to  71\n",
      "39  to  34\n",
      "7  to  7\n",
      "34  to  34\n",
      "5  to  5\n",
      "191  to  183\n",
      "103  to  99\n",
      "230  to  185\n",
      "96  to  92\n",
      "197  to  139\n",
      "82  to  16\n",
      "268  to  246\n",
      "2004  to  6\n",
      "11  to  11\n",
      "2  to  2\n",
      "284  to  282\n",
      "0  to  0\n",
      "382  to  338\n",
      "0  to  0\n",
      "72  to  63\n",
      "104  to  7\n",
      "831  to  820\n",
      "58  to  51\n",
      "53  to  6\n",
      "8  to  8\n",
      "111  to  108\n",
      "298  to  251\n",
      "22  to  22\n",
      "27  to  27\n",
      "24  to  24\n",
      "15  to  14\n",
      "2  to  2\n",
      "378  to  378\n",
      "39  to  35\n",
      "114  to  35\n",
      "416  to  389\n",
      "20  to  19\n",
      "7  to  7\n",
      "1208  to  1051\n",
      "20  to  2\n",
      "0  to  0\n",
      "5  to  5\n",
      "23  to  23\n",
      "72  to  71\n",
      "1126  to  1069\n",
      "91  to  59\n",
      "0  to  0\n",
      "10  to  10\n",
      "571  to  571\n",
      "3  to  3\n",
      "262  to  255\n",
      "5  to  5\n",
      "522  to  409\n",
      "430  to  274\n",
      "11  to  11\n",
      "19  to  13\n",
      "458  to  385\n",
      "1  to  1\n",
      "408  to  277\n",
      "42  to  41\n",
      "14  to  14\n",
      "320  to  260\n",
      "502  to  494\n",
      "119  to  95\n",
      "81  to  76\n",
      "212  to  164\n",
      "153  to  134\n",
      "96  to  88\n",
      "22  to  20\n",
      "380  to  311\n",
      "46  to  43\n",
      "29  to  29\n",
      "241  to  231\n",
      "0  to  0\n",
      "2  to  2\n",
      "61  to  33\n",
      "29  to  27\n",
      "137  to  116\n",
      "63  to  60\n",
      "2307  to  11\n",
      "193  to  145\n",
      "3365  to  8\n",
      "660  to  551\n",
      "317  to  274\n",
      "24  to  17\n",
      "203  to  172\n",
      "38  to  29\n",
      "195  to  195\n",
      "13  to  13\n",
      "0  to  0\n",
      "20  to  1\n",
      "450  to  363\n",
      "135  to  17\n",
      "52  to  48\n",
      "53  to  50\n",
      "7  to  7\n",
      "6  to  6\n",
      "173  to  134\n",
      "61  to  54\n",
      "217  to  158\n",
      "1  to  1\n",
      "20  to  20\n",
      "65  to  64\n",
      "3383  to  10\n",
      "7  to  5\n",
      "17  to  1\n",
      "2195  to  48\n",
      "81  to  3\n",
      "350  to  271\n",
      "1  to  1\n",
      "2  to  1\n",
      "149  to  140\n",
      "23  to  23\n",
      "148  to  11\n",
      "1566  to  1111\n",
      "154  to  144\n",
      "61  to  61\n",
      "189  to  185\n",
      "33  to  18\n",
      "89  to  85\n",
      "14  to  14\n",
      "174  to  157\n",
      "0  to  0\n",
      "4  to  4\n",
      "32  to  32\n",
      "4  to  4\n",
      "9  to  9\n",
      "61  to  53\n",
      "1  to  1\n",
      "54  to  54\n",
      "306  to  173\n",
      "399  to  7\n",
      "104  to  104\n",
      "4  to  4\n",
      "4  to  4\n",
      "165  to  157\n",
      "30  to  1\n",
      "132  to  132\n",
      "3  to  3\n",
      "200  to  200\n",
      "60  to  3\n",
      "656  to  436\n",
      "474  to  8\n",
      "129  to  19\n",
      "152  to  134\n",
      "460  to  370\n",
      "319  to  314\n",
      "25  to  23\n",
      "1  to  1\n",
      "6228  to  4501\n",
      "726  to  598\n",
      "167  to  160\n",
      "68  to  63\n",
      "164  to  141\n",
      "351  to  350\n",
      "228  to  6\n",
      "549  to  397\n",
      "669  to  491\n",
      "20  to  20\n",
      "1461  to  28\n",
      "0  to  0\n",
      "0  to  0\n",
      "64  to  4\n",
      "885  to  3\n",
      "95  to  89\n",
      "6  to  5\n",
      "19  to  17\n",
      "12  to  12\n",
      "182  to  178\n",
      "448  to  402\n",
      "137  to  80\n",
      "4  to  4\n",
      "2  to  1\n",
      "222  to  210\n",
      "2  to  2\n",
      "1341  to  911\n",
      "91  to  4\n",
      "0  to  0\n",
      "57  to  52\n",
      "140  to  139\n",
      "4  to  4\n",
      "602  to  14\n",
      "20  to  2\n",
      "147  to  146\n",
      "852  to  665\n",
      "25  to  25\n",
      "198  to  194\n",
      "185  to  167\n",
      "66  to  64\n",
      "21  to  21\n",
      "1838  to  25\n",
      "43  to  43\n",
      "644  to  593\n",
      "0  to  0\n",
      "78  to  68\n",
      "12  to  10\n",
      "20  to  2\n",
      "228  to  222\n",
      "18  to  16\n",
      "24  to  23\n",
      "287  to  286\n",
      "63  to  57\n",
      "216  to  199\n",
      "1  to  1\n",
      "21  to  20\n",
      "769  to  47\n",
      "121  to  120\n",
      "106  to  100\n",
      "13  to  13\n",
      "20  to  18\n",
      "479  to  439\n",
      "729  to  25\n",
      "4  to  2\n",
      "1  to  1\n",
      "274  to  274\n",
      "279  to  273\n",
      "69  to  68\n",
      "43  to  40\n",
      "102  to  102\n",
      "8  to  8\n",
      "253  to  232\n",
      "87  to  78\n",
      "2  to  2\n",
      "83  to  83\n",
      "58  to  54\n",
      "22  to  20\n",
      "5  to  5\n",
      "5  to  5\n",
      "1001  to  721\n",
      "11  to  9\n",
      "0  to  0\n",
      "77  to  69\n",
      "49  to  43\n",
      "21  to  21\n",
      "0  to  0\n",
      "9  to  9\n",
      "876  to  3\n",
      "199  to  3\n",
      "0  to  0\n",
      "113  to  112\n",
      "268  to  236\n",
      "0  to  0\n",
      "14  to  13\n",
      "70  to  40\n",
      "734  to  74\n",
      "270  to  270\n",
      "556  to  442\n",
      "34  to  31\n",
      "622  to  11\n",
      "121  to  118\n",
      "8  to  4\n",
      "3  to  3\n",
      "59  to  3\n",
      "90  to  90\n",
      "42  to  37\n",
      "25  to  24\n",
      "6  to  5\n",
      "11  to  9\n",
      "93  to  91\n",
      "28  to  27\n",
      "71  to  66\n",
      "650  to  502\n",
      "40  to  40\n",
      "276  to  246\n",
      "4  to  4\n",
      "29  to  10\n",
      "2  to  1\n",
      "268  to  191\n",
      "5  to  5\n",
      "55  to  51\n",
      "952  to  934\n",
      "2  to  2\n",
      "0  to  0\n",
      "28  to  28\n",
      "15  to  14\n",
      "0  to  0\n",
      "8  to  5\n",
      "23  to  23\n",
      "37  to  30\n",
      "97  to  85\n",
      "424  to  265\n",
      "4  to  4\n",
      "0  to  0\n",
      "43  to  40\n",
      "234  to  6\n",
      "60  to  3\n",
      "6  to  6\n",
      "294  to  229\n",
      "408  to  322\n",
      "280  to  243\n",
      "2  to  2\n",
      "535  to  529\n",
      "9  to  9\n",
      "133  to  132\n",
      "1  to  1\n",
      "30  to  26\n",
      "150  to  150\n",
      "191  to  191\n",
      "557  to  557\n",
      "50  to  46\n",
      "3  to  3\n",
      "69  to  69\n",
      "14  to  13\n",
      "1  to  1\n",
      "14  to  14\n",
      "35  to  31\n",
      "144  to  132\n",
      "199  to  197\n",
      "0  to  0\n",
      "81  to  20\n",
      "341  to  336\n",
      "10  to  5\n",
      "78  to  71\n",
      "8  to  5\n",
      "355  to  352\n",
      "145  to  113\n",
      "2  to  2\n",
      "384  to  384\n",
      "13  to  13\n",
      "29  to  27\n",
      "66  to  66\n",
      "2233  to  1278\n",
      "261  to  9\n",
      "37  to  37\n",
      "881  to  681\n",
      "11  to  11\n",
      "33  to  33\n",
      "79  to  72\n",
      "271  to  26\n",
      "48  to  48\n",
      "20  to  2\n",
      "2  to  2\n",
      "22  to  8\n",
      "209  to  208\n",
      "154  to  141\n",
      "397  to  390\n",
      "31  to  8\n",
      "5  to  5\n",
      "9  to  9\n",
      "67  to  67\n",
      "70  to  69\n",
      "62  to  62\n",
      "1300  to  90\n",
      "98  to  98\n",
      "200  to  175\n",
      "33  to  33\n",
      "95  to  72\n",
      "314  to  304\n",
      "418  to  16\n",
      "29  to  25\n",
      "36  to  36\n",
      "65  to  64\n",
      "107  to  87\n",
      "575  to  502\n",
      "7  to  2\n",
      "67  to  67\n",
      "11  to  11\n",
      "1  to  1\n",
      "1844  to  1158\n",
      "159  to  128\n",
      "77  to  72\n",
      "0  to  0\n",
      "47  to  47\n",
      "0  to  0\n",
      "0  to  0\n",
      "109  to  106\n",
      "22  to  21\n",
      "42  to  35\n",
      "628  to  12\n",
      "36  to  33\n",
      "1862  to  36\n",
      "276  to  256\n",
      "46  to  44\n",
      "43  to  42\n",
      "0  to  0\n",
      "2  to  2\n",
      "12  to  12\n",
      "117  to  108\n",
      "410  to  13\n",
      "3  to  3\n",
      "327  to  22\n",
      "79  to  78\n",
      "56  to  46\n",
      "22  to  22\n",
      "110  to  105\n",
      "67  to  63\n",
      "109  to  104\n",
      "1  to  1\n",
      "9  to  6\n",
      "51  to  38\n",
      "25  to  24\n",
      "102  to  100\n",
      "3  to  3\n",
      "138  to  138\n",
      "134  to  103\n",
      "30  to  1\n",
      "43  to  40\n",
      "149  to  142\n",
      "303  to  7\n",
      "0  to  0\n",
      "1087  to  668\n",
      "40  to  23\n",
      "90  to  9\n",
      "0  to  0\n",
      "0  to  0\n",
      "95  to  92\n",
      "115  to  108\n",
      "58  to  55\n",
      "90  to  79\n",
      "18  to  18\n",
      "43  to  38\n",
      "496  to  15\n",
      "52  to  50\n",
      "7  to  6\n",
      "0  to  0\n",
      "8  to  7\n",
      "45  to  40\n",
      "72  to  60\n",
      "60  to  3\n",
      "2  to  1\n",
      "842  to  778\n",
      "523  to  470\n",
      "211  to  169\n",
      "710  to  611\n",
      "1237  to  23\n",
      "15  to  8\n",
      "1  to  1\n",
      "258  to  189\n",
      "0  to  0\n",
      "11  to  11\n",
      "37  to  33\n",
      "42  to  39\n",
      "14  to  14\n",
      "6  to  4\n",
      "2  to  2\n",
      "167  to  144\n",
      "19  to  17\n",
      "0  to  0\n",
      "176  to  175\n",
      "216  to  196\n",
      "139  to  138\n",
      "105  to  82\n",
      "18  to  16\n",
      "6  to  6\n",
      "20  to  20\n",
      "0  to  0\n",
      "0  to  0\n",
      "149  to  137\n",
      "0  to  0\n",
      "8  to  6\n",
      "2  to  1\n",
      "190  to  146\n",
      "12  to  10\n",
      "41  to  30\n",
      "30  to  22\n",
      "1  to  1\n",
      "258  to  248\n",
      "412  to  8\n",
      "58  to  4\n",
      "131  to  125\n",
      "0  to  0\n",
      "90  to  87\n",
      "2  to  2\n",
      "92  to  84\n",
      "0  to  0\n",
      "205  to  203\n",
      "53  to  49\n",
      "71  to  64\n",
      "3  to  3\n",
      "2901  to  1633\n",
      "61  to  4\n",
      "346  to  255\n",
      "191  to  163\n",
      "61  to  54\n",
      "3  to  3\n",
      "476  to  468\n",
      "591  to  6\n",
      "208  to  207\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "97  to  26\n",
      "210  to  206\n",
      "43  to  40\n",
      "74  to  71\n",
      "69  to  59\n",
      "12  to  11\n",
      "81  to  74\n",
      "72  to  66\n",
      "96  to  89\n",
      "171  to  155\n",
      "0  to  0\n",
      "0  to  0\n",
      "214  to  185\n",
      "73  to  67\n",
      "2  to  2\n",
      "289  to  271\n",
      "95  to  84\n",
      "19  to  18\n",
      "29  to  29\n",
      "0  to  0\n",
      "268  to  246\n",
      "101  to  95\n",
      "100  to  93\n",
      "1  to  1\n",
      "2369  to  10\n",
      "263  to  247\n",
      "2161  to  20\n",
      "0  to  0\n",
      "0  to  0\n",
      "15  to  5\n",
      "158  to  155\n",
      "0  to  0\n",
      "297  to  296\n",
      "0  to  0\n",
      "25  to  25\n",
      "73  to  72\n",
      "4  to  4\n",
      "82  to  80\n",
      "0  to  0\n",
      "14  to  7\n",
      "3  to  1\n",
      "130  to  10\n",
      "69  to  65\n",
      "327  to  15\n",
      "289  to  276\n",
      "0  to  0\n",
      "171  to  137\n",
      "0  to  0\n",
      "1  to  1\n",
      "104  to  8\n",
      "0  to  0\n",
      "285  to  230\n",
      "14  to  13\n",
      "67  to  60\n",
      "0  to  0\n",
      "89  to  84\n",
      "13  to  13\n",
      "199  to  11\n",
      "214  to  196\n",
      "53  to  31\n",
      "143  to  135\n",
      "1  to  1\n",
      "48  to  48\n",
      "187  to  187\n",
      "7  to  7\n",
      "207  to  202\n",
      "7  to  7\n",
      "9  to  9\n",
      "1384  to  2\n",
      "1  to  1\n",
      "61  to  7\n",
      "0  to  0\n",
      "10  to  10\n",
      "85  to  6\n",
      "16  to  16\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "4  to  4\n",
      "0  to  0\n",
      "3  to  1\n",
      "82  to  17\n",
      "1  to  1\n",
      "589  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "27  to  27\n",
      "0  to  0\n",
      "60  to  3\n",
      "4  to  1\n",
      "0  to  0\n",
      "4  to  4\n",
      "1  to  1\n",
      "2  to  2\n",
      "2  to  2\n",
      "3  to  3\n",
      "10  to  10\n",
      "216  to  12\n",
      "13  to  13\n",
      "2  to  2\n",
      "0  to  0\n",
      "14  to  14\n",
      "0  to  0\n",
      "0  to  0\n",
      "78  to  76\n",
      "18  to  15\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "5  to  5\n",
      "21  to  21\n",
      "1  to  1\n",
      "1  to  1\n",
      "4  to  4\n",
      "15  to  15\n",
      "199  to  198\n",
      "0  to  0\n",
      "1  to  1\n",
      "19  to  18\n",
      "0  to  0\n",
      "9  to  9\n",
      "0  to  0\n",
      "1  to  1\n",
      "6  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "21  to  15\n",
      "23  to  23\n",
      "34  to  18\n",
      "7  to  7\n",
      "23  to  23\n",
      "2  to  2\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "18  to  15\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "40  to  4\n",
      "183  to  183\n",
      "107  to  12\n",
      "581  to  580\n",
      "201  to  3\n",
      "534  to  497\n",
      "0  to  0\n",
      "358  to  348\n",
      "23  to  22\n",
      "16  to  15\n",
      "0  to  0\n",
      "2  to  2\n",
      "27  to  26\n",
      "1  to  1\n",
      "354  to  350\n",
      "196  to  2\n",
      "0  to  0\n",
      "216  to  205\n",
      "28  to  28\n",
      "0  to  0\n",
      "4  to  4\n",
      "3  to  3\n",
      "366  to  354\n",
      "223  to  209\n",
      "333  to  321\n",
      "114  to  111\n",
      "0  to  0\n",
      "48  to  46\n",
      "3  to  3\n",
      "24  to  22\n",
      "12  to  11\n",
      "160  to  132\n",
      "23  to  22\n",
      "3  to  3\n",
      "589  to  12\n",
      "37  to  3\n",
      "7  to  7\n",
      "12  to  2\n",
      "0  to  0\n",
      "10  to  1\n",
      "20  to  2\n",
      "8  to  2\n",
      "205  to  204\n",
      "22  to  21\n",
      "1  to  1\n",
      "198  to  187\n",
      "4  to  4\n",
      "55  to  1\n",
      "0  to  0\n",
      "2  to  2\n",
      "5  to  5\n",
      "3  to  3\n",
      "30  to  3\n",
      "45  to  9\n",
      "66  to  10\n",
      "30  to  3\n",
      "53  to  50\n",
      "23  to  4\n",
      "20  to  5\n",
      "0  to  0\n",
      "79  to  76\n",
      "2  to  2\n",
      "4  to  4\n",
      "0  to  0\n",
      "26  to  9\n",
      "8  to  6\n",
      "37  to  35\n",
      "42  to  38\n",
      "0  to  0\n",
      "115  to  114\n",
      "2  to  2\n",
      "11  to  10\n",
      "10  to  2\n",
      "125  to  124\n",
      "64  to  10\n",
      "8  to  4\n",
      "13  to  13\n",
      "3  to  3\n",
      "2  to  2\n",
      "46  to  44\n",
      "5  to  5\n",
      "1  to  1\n",
      "29  to  23\n",
      "20  to  20\n",
      "2  to  2\n",
      "424  to  368\n",
      "43  to  42\n",
      "45  to  44\n",
      "0  to  0\n",
      "7  to  7\n",
      "134  to  133\n",
      "21  to  20\n",
      "152  to  134\n",
      "95  to  87\n",
      "34  to  34\n",
      "2  to  2\n",
      "3  to  3\n",
      "1  to  1\n",
      "6  to  6\n",
      "84  to  82\n",
      "606  to  19\n",
      "172  to  127\n",
      "30  to  26\n",
      "111  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "0  to  0\n",
      "13  to  13\n",
      "17  to  17\n",
      "8  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "4  to  4\n",
      "19  to  15\n",
      "4  to  4\n",
      "28  to  28\n",
      "0  to  0\n",
      "24  to  19\n",
      "14  to  14\n",
      "15  to  14\n",
      "8  to  8\n",
      "5  to  5\n",
      "34  to  29\n",
      "11  to  11\n",
      "5  to  5\n",
      "296  to  289\n",
      "14  to  14\n",
      "0  to  0\n",
      "3  to  3\n",
      "0  to  0\n",
      "14  to  14\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "40  to  32\n",
      "32  to  30\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "14  to  14\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "96  to  95\n",
      "0  to  0\n",
      "17  to  17\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "116  to  116\n",
      "302  to  302\n",
      "122  to  119\n",
      "115  to  115\n",
      "68  to  66\n",
      "233  to  208\n",
      "88  to  84\n",
      "1665  to  19\n",
      "272  to  271\n",
      "48  to  46\n",
      "19  to  17\n",
      "127  to  124\n",
      "5  to  5\n",
      "35  to  33\n",
      "0  to  0\n",
      "5  to  5\n",
      "165  to  164\n",
      "0  to  0\n",
      "199  to  186\n",
      "152  to  134\n",
      "0  to  0\n",
      "6  to  6\n",
      "36  to  9\n",
      "81  to  73\n",
      "10  to  7\n",
      "7  to  7\n",
      "8  to  8\n",
      "51  to  51\n",
      "0  to  0\n",
      "4  to  4\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  1\n",
      "1  to  1\n",
      "12  to  12\n",
      "0  to  0\n",
      "15  to  15\n",
      "0  to  0\n",
      "1  to  1\n",
      "15  to  13\n",
      "11  to  9\n",
      "46  to  32\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "2  to  2\n",
      "45  to  37\n",
      "21  to  2\n",
      "6  to  1\n",
      "80  to  80\n",
      "292  to  7\n",
      "58  to  8\n",
      "265  to  264\n",
      "0  to  0\n",
      "115  to  115\n",
      "8  to  8\n",
      "182  to  11\n",
      "8  to  6\n",
      "248  to  241\n",
      "91  to  89\n",
      "1  to  1\n",
      "6  to  6\n",
      "41  to  41\n",
      "0  to  0\n",
      "78  to  75\n",
      "5  to  5\n",
      "74  to  69\n",
      "78  to  77\n",
      "0  to  0\n",
      "37  to  10\n",
      "0  to  0\n",
      "0  to  0\n",
      "20  to  4\n",
      "0  to  0\n",
      "4  to  2\n",
      "96  to  93\n",
      "11  to  11\n",
      "11  to  11\n",
      "2  to  2\n",
      "0  to  0\n",
      "11  to  11\n",
      "7  to  7\n",
      "3  to  3\n",
      "13  to  12\n",
      "3  to  3\n",
      "2  to  2\n",
      "0  to  0\n",
      "1  to  1\n",
      "32  to  27\n",
      "1  to  1\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "6  to  1\n",
      "90  to  9\n",
      "204  to  6\n",
      "5  to  5\n",
      "24  to  21\n",
      "123  to  119\n",
      "21  to  21\n",
      "20  to  19\n",
      "0  to  0\n",
      "435  to  411\n",
      "37  to  28\n",
      "22  to  22\n",
      "2  to  2\n",
      "54  to  54\n",
      "0  to  0\n",
      "9  to  9\n",
      "78  to  11\n",
      "4  to  4\n",
      "165  to  164\n",
      "978  to  977\n",
      "301  to  5\n",
      "14  to  14\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "0  to  0\n",
      "19  to  14\n",
      "20  to  18\n",
      "5  to  5\n",
      "1  to  1\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "14  to  13\n",
      "4  to  3\n",
      "0  to  0\n",
      "10  to  10\n",
      "1  to  1\n",
      "1  to  1\n",
      "15  to  3\n",
      "0  to  0\n",
      "6  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "66  to  62\n",
      "0  to  0\n",
      "2  to  2\n",
      "19  to  18\n",
      "313  to  284\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "4  to  4\n",
      "0  to  0\n",
      "2  to  2\n",
      "1  to  1\n",
      "12  to  12\n",
      "4  to  4\n",
      "0  to  0\n",
      "76  to  76\n",
      "95  to  93\n",
      "13  to  13\n",
      "17  to  14\n",
      "6  to  6\n",
      "0  to  0\n",
      "2  to  2\n",
      "12  to  12\n",
      "4  to  3\n",
      "63  to  57\n",
      "0  to  0\n",
      "3  to  1\n",
      "7  to  7\n",
      "5  to  5\n",
      "6  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "12  to  8\n",
      "0  to  0\n",
      "1  to  1\n",
      "3  to  3\n",
      "49  to  49\n",
      "22  to  15\n",
      "0  to  0\n",
      "565  to  4\n",
      "1  to  1\n",
      "62  to  8\n",
      "286  to  286\n",
      "132  to  128\n",
      "49  to  40\n",
      "3  to  3\n",
      "59  to  51\n",
      "149  to  140\n",
      "7  to  6\n",
      "0  to  0\n",
      "2  to  1\n",
      "5  to  4\n",
      "0  to  0\n",
      "9  to  9\n",
      "49  to  48\n",
      "12  to  11\n",
      "2  to  2\n",
      "6  to  6\n",
      "90  to  9\n",
      "1  to  1\n",
      "4  to  4\n",
      "1  to  1\n",
      "0  to  0\n",
      "1  to  1\n",
      "2  to  2\n",
      "11  to  8\n",
      "12  to  9\n",
      "6  to  6\n",
      "0  to  0\n",
      "20  to  2\n",
      "74  to  67\n",
      "13  to  13\n",
      "2  to  2\n",
      "0  to  0\n",
      "4  to  4\n",
      "0  to  0\n",
      "1  to  1\n",
      "4  to  3\n",
      "30  to  30\n",
      "5  to  5\n",
      "2  to  2\n",
      "2  to  2\n",
      "4  to  4\n",
      "0  to  0\n",
      "61  to  11\n",
      "74  to  11\n",
      "0  to  0\n",
      "37  to  19\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "13  to  13\n",
      "24  to  3\n",
      "23  to  17\n",
      "4  to  4\n",
      "34  to  34\n",
      "68  to  57\n",
      "50  to  49\n",
      "211  to  195\n",
      "15  to  15\n",
      "218  to  158\n",
      "1  to  1\n",
      "390  to  364\n",
      "372  to  352\n",
      "77  to  77\n",
      "0  to  0\n",
      "587  to  8\n",
      "38  to  22\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "6  to  6\n",
      "0  to  0\n",
      "89  to  81\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "21  to  21\n",
      "0  to  0\n",
      "0  to  0\n",
      "118  to  116\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "29  to  29\n",
      "3  to  3\n",
      "31  to  29\n",
      "339  to  326\n",
      "12  to  11\n",
      "88  to  88\n",
      "0  to  0\n",
      "0  to  0\n",
      "22  to  21\n",
      "4  to  3\n",
      "2  to  2\n",
      "5  to  5\n",
      "4  to  4\n",
      "14  to  10\n",
      "21  to  17\n",
      "433  to  427\n",
      "11  to  11\n",
      "15  to  13\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "54  to  52\n",
      "0  to  0\n",
      "3  to  3\n",
      "6  to  6\n",
      "0  to  0\n",
      "122  to  104\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "135  to  131\n",
      "383  to  368\n",
      "3  to  1\n",
      "42  to  33\n",
      "78  to  69\n",
      "1  to  1\n",
      "4  to  4\n",
      "0  to  0\n",
      "15  to  10\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "21  to  15\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "4  to  4\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "17  to  13\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "12  to  12\n",
      "12  to  9\n",
      "8  to  5\n",
      "0  to  0\n",
      "0  to  0\n",
      "27  to  27\n",
      "3  to  2\n",
      "190  to  189\n",
      "0  to  0\n",
      "0  to  0\n",
      "8  to  8\n",
      "0  to  0\n",
      "386  to  368\n",
      "79  to  78\n",
      "315  to  305\n",
      "22  to  22\n",
      "313  to  301\n",
      "32  to  23\n",
      "275  to  14\n",
      "97  to  16\n",
      "1012  to  995\n",
      "24  to  22\n",
      "27  to  26\n",
      "24  to  23\n",
      "0  to  0\n",
      "19  to  18\n",
      "139  to  134\n",
      "155  to  150\n",
      "25  to  24\n",
      "22  to  20\n",
      "3  to  3\n",
      "710  to  588\n",
      "61  to  56\n",
      "23  to  21\n",
      "27  to  27\n",
      "501  to  12\n",
      "153  to  148\n",
      "0  to  0\n",
      "20  to  16\n",
      "0  to  0\n",
      "0  to  0\n",
      "4  to  4\n",
      "12  to  12\n",
      "0  to  0\n",
      "31  to  7\n",
      "0  to  0\n",
      "1  to  1\n",
      "13  to  4\n",
      "12  to  6\n",
      "0  to  0\n",
      "0  to  0\n",
      "73  to  73\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "38  to  28\n",
      "9  to  9\n",
      "0  to  0\n",
      "0  to  0\n",
      "19  to  17\n",
      "41  to  35\n",
      "0  to  0\n",
      "2  to  2\n",
      "394  to  362\n",
      "0  to  0\n",
      "20  to  1\n",
      "2  to  2\n",
      "246  to  214\n",
      "0  to  0\n",
      "1  to  1\n",
      "9  to  9\n",
      "3  to  3\n",
      "5  to  5\n",
      "5  to  5\n",
      "38  to  38\n",
      "0  to  0\n",
      "164  to  163\n",
      "0  to  0\n",
      "1336  to  2\n",
      "3  to  3\n",
      "52  to  7\n",
      "13  to  12\n",
      "24  to  8\n",
      "93  to  76\n",
      "1  to  1\n",
      "0  to  0\n",
      "18  to  2\n",
      "13  to  13\n",
      "7  to  3\n",
      "0  to  0\n",
      "11  to  2\n",
      "149  to  148\n",
      "0  to  0\n",
      "5  to  5\n",
      "5  to  5\n",
      "5  to  3\n",
      "0  to  0\n",
      "14  to  11\n",
      "203  to  175\n",
      "15  to  14\n",
      "36  to  30\n",
      "3  to  3\n",
      "2  to  2\n",
      "0  to  0\n",
      "2  to  2\n",
      "22  to  22\n",
      "335  to  26\n",
      "192  to  185\n",
      "437  to  415\n",
      "290  to  2\n",
      "14  to  12\n",
      "17  to  12\n",
      "3  to  3\n",
      "0  to  0\n",
      "1  to  1\n",
      "9  to  9\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "4  to  4\n",
      "1  to  1\n",
      "10  to  10\n",
      "1  to  1\n",
      "0  to  0\n",
      "19  to  18\n",
      "0  to  0\n",
      "0  to  0\n",
      "197  to  196\n",
      "91  to  86\n",
      "4  to  4\n",
      "7  to  7\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  1\n",
      "0  to  0\n",
      "6  to  6\n",
      "208  to  183\n",
      "140  to  135\n",
      "93  to  2\n",
      "255  to  249\n",
      "150  to  137\n",
      "0  to  0\n",
      "10  to  10\n",
      "0  to  0\n",
      "3  to  3\n",
      "1  to  1\n",
      "12  to  11\n",
      "5  to  5\n",
      "63  to  58\n",
      "0  to  0\n",
      "0  to  0\n",
      "230  to  219\n",
      "200  to  198\n",
      "82  to  77\n",
      "2  to  2\n",
      "199  to  189\n",
      "143  to  140\n",
      "0  to  0\n",
      "9  to  4\n",
      "2  to  2\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "26  to  26\n",
      "0  to  0\n",
      "14  to  14\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "144  to  141\n",
      "136  to  135\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "1  to  1\n",
      "0  to  0\n",
      "63  to  63\n",
      "2  to  2\n",
      "34  to  34\n",
      "0  to  0\n",
      "6  to  6\n",
      "5  to  5\n",
      "4  to  4\n",
      "377  to  377\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "143  to  143\n",
      "1  to  1\n",
      "205  to  3\n",
      "49  to  49\n",
      "4  to  4\n",
      "1953  to  14\n",
      "56  to  49\n",
      "5  to  5\n",
      "0  to  0\n",
      "48  to  42\n",
      "19  to  16\n",
      "273  to  12\n",
      "47  to  42\n",
      "10  to  10\n",
      "0  to  0\n",
      "3  to  3\n",
      "198  to  196\n",
      "14  to  14\n",
      "197  to  184\n",
      "4  to  4\n",
      "8  to  8\n",
      "44  to  44\n",
      "5  to  5\n",
      "2  to  2\n",
      "14  to  14\n",
      "27  to  26\n",
      "43  to  9\n",
      "2  to  1\n",
      "109  to  106\n",
      "0  to  0\n",
      "83  to  83\n",
      "1  to  1\n",
      "0  to  0\n",
      "31  to  28\n",
      "2  to  2\n",
      "2  to  2\n",
      "1  to  1\n",
      "4  to  4\n",
      "5  to  4\n",
      "0  to  0\n",
      "36  to  36\n",
      "152  to  134\n",
      "2  to  2\n",
      "0  to  0\n",
      "9  to  9\n",
      "10  to  10\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "1  to  1\n",
      "1  to  1\n",
      "2  to  2\n",
      "326  to  7\n",
      "1  to  1\n",
      "73  to  73\n",
      "11  to  8\n",
      "4  to  4\n",
      "2  to  2\n",
      "616  to  11\n",
      "8  to  8\n",
      "36  to  2\n",
      "1  to  1\n",
      "20  to  18\n",
      "0  to  0\n",
      "2  to  2\n",
      "2  to  2\n",
      "0  to  0\n",
      "27  to  20\n",
      "1  to  1\n",
      "108  to  103\n",
      "3  to  3\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "1  to  1\n",
      "209  to  207\n",
      "12  to  9\n",
      "204  to  200\n",
      "85  to  78\n",
      "2  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "80  to  61\n",
      "6  to  6\n",
      "77  to  77\n",
      "47  to  46\n",
      "210  to  192\n",
      "13  to  13\n",
      "22  to  18\n",
      "10  to  10\n",
      "3  to  3\n",
      "37  to  36\n",
      "56  to  54\n",
      "0  to  0\n",
      "43  to  43\n",
      "302  to  7\n",
      "104  to  95\n",
      "7  to  5\n",
      "10  to  5\n",
      "3  to  3\n",
      "0  to  0\n",
      "682  to  614\n",
      "30  to  25\n",
      "90  to  9\n",
      "3  to  2\n",
      "60  to  58\n",
      "0  to  0\n",
      "364  to  364\n",
      "5  to  5\n",
      "3  to  3\n",
      "2  to  2\n",
      "9  to  9\n",
      "8  to  8\n",
      "36  to  36\n",
      "70  to  7\n",
      "1194  to  27\n",
      "25  to  24\n",
      "327  to  296\n",
      "19  to  15\n",
      "6  to  6\n",
      "1  to  1\n",
      "178  to  167\n",
      "10  to  10\n",
      "21  to  20\n",
      "3  to  3\n",
      "0  to  0\n",
      "2  to  2\n",
      "2  to  2\n",
      "30  to  30\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "4  to  4\n",
      "14  to  14\n",
      "4  to  4\n",
      "5  to  5\n",
      "0  to  0\n",
      "0  to  0\n",
      "166  to  153\n",
      "7  to  7\n",
      "125  to  116\n",
      "4  to  4\n",
      "1  to  1\n",
      "173  to  169\n",
      "9  to  7\n",
      "17  to  17\n",
      "9  to  9\n",
      "1  to  1\n",
      "8  to  3\n",
      "1  to  1\n",
      "6  to  6\n",
      "18  to  12\n",
      "0  to  0\n",
      "31  to  31\n",
      "5  to  3\n",
      "1  to  1\n",
      "76  to  73\n",
      "0  to  0\n",
      "1  to  1\n",
      "237  to  190\n",
      "26  to  23\n",
      "0  to  0\n",
      "31  to  28\n",
      "11  to  11\n",
      "0  to  0\n",
      "164  to  157\n",
      "17  to  14\n",
      "77  to  77\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "33  to  33\n",
      "531  to  341\n",
      "5  to  5\n",
      "0  to  0\n",
      "6  to  6\n",
      "13  to  10\n",
      "10  to  10\n",
      "23  to  23\n",
      "0  to  0\n",
      "28  to  27\n",
      "0  to  0\n",
      "54  to  53\n",
      "1  to  1\n",
      "0  to  0\n",
      "25  to  25\n",
      "4  to  4\n",
      "0  to  0\n",
      "6  to  6\n",
      "29  to  29\n",
      "653  to  584\n",
      "0  to  0\n",
      "412  to  404\n",
      "1  to  1\n",
      "0  to  0\n",
      "163  to  161\n",
      "16  to  16\n",
      "38  to  38\n",
      "6  to  5\n",
      "6  to  3\n",
      "9  to  7\n",
      "93  to  93\n",
      "0  to  0\n",
      "14  to  14\n",
      "9  to  2\n",
      "22  to  22\n",
      "39  to  36\n",
      "0  to  0\n",
      "166  to  165\n",
      "3  to  3\n",
      "0  to  0\n",
      "23  to  23\n",
      "39  to  33\n",
      "15  to  12\n",
      "0  to  0\n",
      "87  to  85\n",
      "112  to  94\n",
      "75  to  67\n",
      "7  to  7\n",
      "2  to  2\n",
      "40  to  40\n",
      "1085  to  824\n",
      "5  to  5\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "20  to  20\n",
      "12  to  12\n",
      "63  to  57\n",
      "12  to  12\n",
      "13  to  13\n",
      "0  to  0\n",
      "0  to  0\n",
      "4  to  4\n",
      "0  to  0\n",
      "346  to  327\n",
      "14  to  13\n",
      "0  to  0\n",
      "40  to  40\n",
      "93  to  92\n",
      "166  to  165\n",
      "101  to  87\n",
      "1  to  1\n",
      "3  to  3\n",
      "0  to  0\n",
      "0  to  0\n",
      "377  to  365\n",
      "1  to  1\n",
      "0  to  0\n",
      "2  to  2\n",
      "66  to  63\n",
      "20  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "52  to  50\n",
      "15  to  15\n",
      "20  to  20\n",
      "14  to  14\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "17  to  17\n",
      "1  to  1\n",
      "17  to  17\n",
      "9  to  8\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "70  to  64\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "692  to  9\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "14  to  2\n",
      "0  to  0\n",
      "1  to  1\n",
      "1  to  1\n",
      "7  to  6\n",
      "0  to  0\n",
      "13  to  10\n",
      "0  to  0\n",
      "8  to  5\n",
      "20  to  3\n",
      "6  to  2\n",
      "19  to  18\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "17  to  17\n",
      "1  to  1\n",
      "43  to  40\n",
      "241  to  232\n",
      "79  to  74\n",
      "105  to  12\n",
      "45  to  28\n",
      "320  to  304\n",
      "0  to  0\n",
      "207  to  199\n",
      "19  to  19\n",
      "10  to  10\n",
      "3  to  3\n",
      "11  to  11\n",
      "2  to  2\n",
      "32  to  27\n",
      "2  to  2\n",
      "8  to  7\n",
      "2  to  2\n",
      "3  to  3\n",
      "13  to  13\n",
      "153  to  153\n",
      "10  to  10\n",
      "114  to  113\n",
      "252  to  12\n",
      "5  to  5\n",
      "5  to  5\n",
      "10  to  10\n",
      "2  to  2\n",
      "3  to  3\n",
      "4  to  3\n",
      "8  to  8\n",
      "23  to  16\n",
      "9  to  6\n",
      "10  to  2\n",
      "103  to  11\n",
      "0  to  0\n",
      "317  to  295\n",
      "0  to  0\n",
      "4  to  4\n",
      "1  to  1\n",
      "0  to  0\n",
      "5  to  1\n",
      "83  to  75\n",
      "195  to  195\n",
      "71  to  71\n",
      "0  to  0\n",
      "2  to  2\n",
      "6  to  4\n",
      "10  to  10\n",
      "0  to  0\n",
      "16  to  16\n",
      "757  to  607\n",
      "2  to  2\n",
      "0  to  0\n",
      "24  to  19\n",
      "1  to  1\n",
      "15  to  15\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "58  to  41\n",
      "0  to  0\n",
      "5  to  5\n",
      "69  to  56\n",
      "13  to  4\n",
      "15  to  15\n",
      "10  to  10\n",
      "3  to  2\n",
      "30  to  26\n",
      "7  to  7\n",
      "8  to  8\n",
      "10  to  8\n",
      "4  to  4\n",
      "58  to  51\n",
      "84  to  72\n",
      "71  to  40\n",
      "0  to  0\n",
      "40  to  28\n",
      "14  to  11\n",
      "80  to  77\n",
      "8  to  8\n",
      "8  to  8\n",
      "248  to  7\n",
      "3  to  3\n",
      "101  to  96\n",
      "4  to  4\n",
      "153  to  149\n",
      "2  to  2\n",
      "35  to  29\n",
      "205  to  205\n",
      "243  to  9\n",
      "126  to  126\n",
      "0  to  0\n",
      "0  to  0\n",
      "15  to  14\n",
      "6  to  6\n",
      "2  to  2\n",
      "25  to  21\n",
      "0  to  0\n",
      "83  to  11\n",
      "7  to  7\n",
      "1  to  1\n",
      "6  to  6\n",
      "3  to  3\n",
      "42  to  39\n",
      "338  to  315\n",
      "37  to  10\n",
      "24  to  19\n",
      "128  to  95\n",
      "11  to  9\n",
      "52  to  17\n",
      "32  to  30\n",
      "256  to  230\n",
      "41  to  41\n",
      "21  to  21\n",
      "197  to  194\n",
      "4  to  4\n",
      "46  to  44\n",
      "243  to  216\n",
      "34  to  26\n",
      "3  to  3\n",
      "15  to  13\n",
      "7  to  7\n",
      "0  to  0\n",
      "53  to  47\n",
      "7  to  7\n",
      "267  to  265\n",
      "45  to  43\n",
      "18  to  18\n",
      "4  to  4\n",
      "0  to  0\n",
      "417  to  16\n",
      "0  to  0\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "12  to  10\n",
      "2  to  2\n",
      "1  to  1\n",
      "1  to  1\n",
      "24  to  4\n",
      "5  to  5\n",
      "5  to  5\n",
      "6  to  5\n",
      "42  to  5\n",
      "3  to  3\n",
      "199  to  186\n",
      "0  to  0\n",
      "1  to  1\n",
      "10  to  7\n",
      "8  to  8\n",
      "17  to  14\n",
      "0  to  0\n",
      "4  to  4\n",
      "15  to  13\n",
      "281  to  261\n",
      "0  to  0\n",
      "0  to  0\n",
      "28  to  27\n",
      "34  to  34\n",
      "81  to  4\n",
      "54  to  52\n",
      "255  to  255\n",
      "5  to  5\n",
      "10  to  9\n",
      "31  to  29\n",
      "1  to  1\n",
      "18  to  18\n",
      "22  to  18\n",
      "9  to  9\n",
      "113  to  7\n",
      "223  to  222\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "76  to  76\n",
      "0  to  0\n",
      "4  to  4\n",
      "12  to  12\n",
      "7  to  6\n",
      "34  to  34\n",
      "22  to  19\n",
      "3  to  3\n",
      "74  to  44\n",
      "26  to  26\n",
      "0  to  0\n",
      "10  to  10\n",
      "1  to  1\n",
      "14  to  14\n",
      "1  to  1\n",
      "0  to  0\n",
      "21  to  15\n",
      "0  to  0\n",
      "7  to  7\n",
      "12  to  12\n",
      "43  to  33\n",
      "8  to  8\n",
      "97  to  90\n",
      "0  to  0\n",
      "13  to  6\n",
      "10  to  10\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "102  to  100\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "0  to  0\n",
      "3  to  3\n",
      "0  to  0\n",
      "14  to  14\n",
      "2  to  2\n",
      "0  to  0\n",
      "5  to  4\n",
      "1  to  1\n",
      "82  to  77\n",
      "0  to  0\n",
      "89  to  89\n",
      "0  to  0\n",
      "10  to  9\n",
      "1  to  1\n",
      "2  to  2\n",
      "37  to  33\n",
      "17  to  14\n",
      "4  to  4\n",
      "63  to  58\n",
      "1  to  1\n",
      "216  to  198\n",
      "160  to  145\n",
      "77  to  76\n",
      "0  to  0\n",
      "2  to  2\n",
      "76  to  75\n",
      "3  to  3\n",
      "4  to  4\n",
      "1  to  1\n",
      "1  to  1\n",
      "0  to  0\n",
      "11  to  11\n",
      "2  to  2\n",
      "3  to  3\n",
      "0  to  0\n",
      "2  to  2\n",
      "1  to  1\n",
      "0  to  0\n",
      "43  to  43\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "14  to  14\n",
      "8  to  8\n",
      "192  to  187\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "26  to  26\n",
      "8  to  7\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "8  to  8\n",
      "0  to  0\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "3  to  3\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "0  to  0\n",
      "113  to  113\n",
      "42  to  42\n",
      "11  to  11\n",
      "37  to  20\n",
      "50  to  50\n",
      "0  to  0\n",
      "0  to  0\n",
      "37  to  27\n",
      "37  to  34\n",
      "1  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "10  to  7\n",
      "4  to  4\n",
      "1  to  1\n",
      "2  to  2\n",
      "2  to  2\n",
      "0  to  0\n",
      "6  to  6\n",
      "3  to  2\n",
      "1  to  1\n",
      "88  to  85\n",
      "4  to  4\n",
      "5  to  5\n",
      "14  to  12\n",
      "377  to  289\n",
      "0  to  0\n",
      "5  to  5\n",
      "0  to  0\n",
      "20  to  18\n",
      "7  to  4\n",
      "79  to  72\n",
      "19  to  19\n",
      "4  to  3\n",
      "28  to  28\n",
      "30  to  30\n",
      "164  to  154\n",
      "4  to  3\n",
      "75  to  71\n",
      "9  to  9\n",
      "96  to  93\n",
      "15  to  15\n",
      "2  to  2\n",
      "0  to  0\n",
      "41  to  40\n",
      "4  to  4\n",
      "0  to  0\n",
      "92  to  87\n",
      "9  to  9\n",
      "0  to  0\n",
      "0  to  0\n",
      "5  to  5\n",
      "0  to  0\n",
      "118  to  116\n",
      "3  to  3\n",
      "16  to  16\n",
      "382  to  370\n",
      "229  to  220\n",
      "30  to  28\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "6  to  6\n",
      "1  to  1\n",
      "2  to  2\n",
      "16  to  9\n",
      "0  to  0\n",
      "3  to  3\n",
      "10  to  10\n",
      "29  to  28\n",
      "2  to  2\n",
      "18  to  18\n",
      "4  to  4\n",
      "29  to  22\n",
      "2  to  2\n",
      "0  to  0\n",
      "0  to  0\n",
      "311  to  308\n",
      "14  to  14\n",
      "4  to  4\n",
      "3  to  3\n",
      "18  to  18\n",
      "23  to  20\n",
      "1  to  1\n",
      "21  to  18\n",
      "7  to  5\n",
      "0  to  0\n",
      "175  to  170\n",
      "0  to  0\n",
      "2  to  2\n",
      "8  to  8\n",
      "0  to  0\n",
      "0  to  0\n",
      "7  to  7\n",
      "0  to  0\n",
      "0  to  0\n",
      "12  to  12\n",
      "21  to  21\n",
      "1  to  1\n",
      "0  to  0\n",
      "4  to  4\n",
      "32  to  32\n",
      "9  to  9\n",
      "0  to  0\n",
      "441  to  441\n",
      "77  to  77\n",
      "54  to  54\n",
      "22  to  22\n",
      "324  to  321\n",
      "1375  to  3\n",
      "31  to  23\n",
      "1  to  1\n",
      "3  to  3\n",
      "35  to  30\n",
      "210  to  209\n",
      "1  to  1\n",
      "26  to  25\n",
      "2  to  2\n",
      "8  to  4\n",
      "17  to  16\n",
      "420  to  415\n",
      "0  to  0\n",
      "0  to  0\n",
      "2  to  1\n",
      "2  to  2\n",
      "3  to  1\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "150  to  6\n",
      "4  to  4\n",
      "2  to  2\n",
      "0  to  0\n",
      "12  to  4\n",
      "18  to  13\n",
      "4  to  4\n",
      "16  to  11\n",
      "8  to  8\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "63  to  9\n",
      "16  to  15\n",
      "64  to  62\n",
      "105  to  100\n",
      "286  to  261\n",
      "207  to  198\n",
      "248  to  204\n",
      "136  to  134\n",
      "196  to  188\n",
      "136  to  126\n",
      "184  to  165\n",
      "140  to  128\n",
      "0  to  0\n",
      "0  to  0\n",
      "6  to  5\n",
      "20  to  19\n",
      "8  to  8\n",
      "145  to  140\n",
      "17  to  16\n",
      "69  to  58\n",
      "35  to  34\n",
      "10  to  9\n",
      "41  to  40\n",
      "0  to  0\n",
      "615  to  579\n",
      "5  to  5\n",
      "386  to  366\n",
      "58  to  49\n",
      "11  to  9\n",
      "2  to  2\n",
      "630  to  624\n",
      "565  to  541\n",
      "36  to  36\n",
      "40  to  39\n",
      "551  to  548\n",
      "51  to  51\n",
      "17  to  17\n",
      "11  to  11\n",
      "3  to  3\n",
      "27  to  23\n",
      "25  to  21\n",
      "42  to  37\n",
      "23  to  21\n",
      "10  to  10\n",
      "10  to  10\n",
      "10  to  10\n",
      "4  to  4\n",
      "10  to  10\n",
      "4  to  4\n",
      "10  to  10\n",
      "10  to  10\n",
      "10  to  10\n",
      "10  to  10\n",
      "10  to  10\n",
      "0  to  0\n",
      "24  to  22\n",
      "19  to  17\n",
      "28  to  26\n",
      "36  to  33\n",
      "42  to  40\n",
      "34  to  32\n",
      "37  to  34\n",
      "26  to  26\n",
      "6  to  6\n",
      "36  to  35\n",
      "9  to  7\n",
      "58  to  57\n",
      "36  to  35\n",
      "35  to  34\n",
      "36  to  35\n",
      "34  to  33\n",
      "26  to  25\n",
      "0  to  0\n",
      "0  to  0\n",
      "0  to  0\n",
      "14  to  14\n",
      "14  to  14\n",
      "14  to  14\n",
      "12  to  12\n",
      "5  to  5\n",
      "0  to  0\n",
      "14  to  14\n",
      "14  to  14\n",
      "14  to  14\n",
      "14  to  14\n",
      "188  to  177\n",
      "156  to  150\n",
      "190  to  180\n",
      "163  to  157\n",
      "167  to  155\n",
      "163  to  156\n",
      "0  to  0\n",
      "12  to  12\n",
      "0  to  0\n",
      "44  to  42\n",
      "21  to  19\n",
      "33  to  31\n",
      "50  to  44\n",
      "75  to  74\n",
      "0  to  0\n",
      "27  to  27\n",
      "29  to  29\n",
      "6  to  6\n",
      "21  to  21\n"
     ]
    }
   ],
   "source": [
    "# comment.map(lambda x: list(set(x)))\n",
    "def deduplicate(x:list):\n",
    "    x_=list(set(x))\n",
    "    print(len(x),' to ',len(x_))\n",
    "    return x_\n",
    "\n",
    "deduplicate_comment=comment.map(deduplicate)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/envs/python3.7/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "before_august[\"评论明细\"] = deduplicate_comment\n",
    "# before_august[['productId', '评论明细']].values[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['[{\"nickname\": \"jd_136638hgrq\", \"score\": 5, \"content\": \"宝贝q收到就迫不及待打开，包装很安全，还送了钥匙链，礼品盒，礼品袋，卖家考虑的很周全，送人很大气，不过我是自己用的。，打开口红有淡淡香味，上唇试了，图一是薄图，图二是半厚图半薄图，颜色个人比较满意，喜欢的宝宝可以果断下哦手，用的其他品牌的都是正装量，用不完过期挺可以的，迷你装的够用不用担心用不完！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-16 16:54:53\", \"usefulVoteCount\": 0, \"replyCount\": 5}, {\"nickname\": \"有***兽\", \"score\": 5, \"content\": \"不错，一次买了两管，豆沙红和珊瑚红，香味我很喜欢，质感很不错的，小小的一管，携带方便，还没有使用，包装很不错，有盒子和袋子，如果送人的话也挺合适，物流很快，点赞\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-29 13:43:51\", \"usefulVoteCount\": 3, \"replyCount\": 1}, {\"nickname\": \"jd_150362ypa\", \"score\": 5, \"content\": \"非常不错，小小的一只装在包里随身携带很方便，颜色也很正，也很称肤色，非常喜欢，谢谢店家送的小熊钥匙扣非常漂亮！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-03 12:27:12\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"子***1\", \"score\": 5, \"content\": \"东西非常好，而且是香奈儿香水的味道，上色很好，雾感很高级，非常喜欢，颜色对肤色也非常友好！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-28 16:55:54\", \"usefulVoteCount\": 12, \"replyCount\": 3}, {\"nickname\": \"j***f\", \"score\": 5, \"content\": \"收到快递迫不及待的打开了，口红的盒子高大上，让我惊喜的是，竟然看到一个小礼物，太可爱了，感谢卖家，口红是我要的颜色，热卖豆沙色，和图片颜色没有差别，爱了爱了，我决定要关注店铺，接着买、买、买，祝店家生意兴隆！财源滚滚！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-11 19:01:21\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"有***兽\", \"score\": 5, \"content\": \"这款我很喜欢，包装盒、包装袋齐全，香味闻着很舒服，这款43号的色很正，我喜欢，同时买了58号豆沙红给妈妈使用，妈妈很喜欢，收到很长时间了才来评价，非常满意，一小管先用着，用没了再买吧，物流很快，包装的很好，点赞\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-03-29 13:43:51\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"南***4\", \"score\": 5, \"content\": \"很不错，是我期待的颜色，质感也挺好，擦起来也不干\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-03 15:03:14\", \"usefulVoteCount\": 15, \"replyCount\": 0}, {\"nickname\": \"j***s\", \"score\": 5, \"content\": \"小小的，很适合出门带，颜色很漂亮，不涂唇膏也不会太干，很喜欢\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-28 16:40:26\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"杨***人\", \"score\": 5, \"content\": \"口红质量很好，涂起来不干，很显白，是正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-19 12:12:10\", \"usefulVoteCount\": 3, \"replyCount\": 0}, {\"nickname\": \"j***x\", \"score\": 5, \"content\": \"宝贝收到了，特意用了才来评价，质感细门腻，颜色非常正，而且持久不掉色，不沾杯，用后滋润不起皮，显得皮肤也白了好多，非常喜欢，下次还会回购的。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-13 15:20:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"z***x\", \"score\": 5, \"content\": \"产品质感：很精致，非常细\\\\n产品颜色：正，喜欢\\\\n持久效果：不错\\\\n滋润效果：不错\\\\n适合肤色：百搭\\\\n其他特色：很精致\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-04 20:40:15\", \"usefulVoteCount\": 13, \"replyCount\": 0}, {\"nickname\": \"邢***瘦\", \"score\": 5, \"content\": \"产品质感：收到货品，包装很棒，有档次，送人也是可以的\\\\n产品颜色：枫叶色，个人感觉这款需要化妆了再涂，这样更有气质\\\\n滋润效果：个人感觉干呀，要先唇部打底，这是重点，不然拔干到懵逼呀\\\\n适合肤色：我没化妆试涂了一下，还不错，化妆后更棒\\\\n是不是正品我就不知道了?&zwj;♂?因为口红从来没有用完过，所以比较喜欢买小样\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-09 14:24:25\", \"usefulVoteCount\": 5, \"replyCount\": 0}, {\"nickname\": \"j***e\", \"score\": 5, \"content\": \"超好用，颜色好看，买的试用装，一涂就爱上了，味道还很香，不干不油，反正是那种一用就喜欢的。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-07 21:38:11\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"W***2\", \"score\": 5, \"content\": \"包装完好，口红外卖用充气袋保护者，非常好，之前看评论还担心路上会损坏了呢，这个担心是多余的。颜色也漂亮，赠品非常实用\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-08-09 12:03:35\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***x\", \"score\": 5, \"content\": \"非常喜欢的一款口红，首先颜色很亮丽也很显皮肤白，第二有淡淡香味很好闻，第三很滋润一点都不干，大品牌真是值得信赖，以后还会回购的\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-05 14:58:12\", \"usefulVoteCount\": 6, \"replyCount\": 0}, {\"nickname\": \"星***_\", \"score\": 5, \"content\": \"商品很好，很喜欢，送人的，朋友也很喜欢，质量也不错。总体是不错的，。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-08-03 17:23:41\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"是***啊\", \"score\": 5, \"content\": \"好用是真的好用，mini也是真的mini，很顺滑，味道也好闻，但是感觉颜色不适合我\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-20 18:29:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"老***动\", \"score\": 5, \"content\": \"非常好，很不错，只是发过来女朋友已经分手了，不知道给那个，难办啊，\", \"productColor\": \"丝绒系列 63#复古酒红(姨妈色)-夜幕3.5g\", \"referenceTime\": \"2020-03-02 21:23:26\", \"usefulVoteCount\": 11, \"replyCount\": 8}, {\"nickname\": \"j***2\", \"score\": 5, \"content\": \"挺好的，很漂亮，而且小小的很好，包装很好，送的小礼物也很好，平时买的正装口红太多都用不完，就喜欢这种小小的优惠装，物美价廉。就是需要戴口罩还不能涂。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-29 16:52:35\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***d\", \"score\": 5, \"content\": \"盒子装着看起来就很高大尚！口红色号很喜欢！显白！也很滋润！大爱！\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-05 23:49:05\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"布***6\", \"score\": 5, \"content\": \"产品质感：质感很好\\\\n产品颜色：颜色正，漂亮\\\\n持久效果：持久\\\\n滋润效果：滋润保湿\\\\n适合肤色：白皙\\\\n其他特色：价格实惠，好用。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-24 15:15:12\", \"usefulVoteCount\": 8, \"replyCount\": 2}, {\"nickname\": \"王***1\", \"score\": 5, \"content\": \"正品，正品，绝对正品，上色效果好，包装特别高大上，特别满意，适合大众肤色。滋润度特别好！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-08 13:34:08\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***t\", \"score\": 5, \"content\": \"口红已收到，包装精美。试用了一下，很滋润，颜色和效果都很满意。送的小礼物很喜欢，需要时还要回购。五星好评！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-16 21:31:52\", \"usefulVoteCount\": 4, \"replyCount\": 0}, {\"nickname\": \"宫***乐\", \"score\": 5, \"content\": \"产品质感：轻盈不油腻\\\\n产品颜色：很正\\\\n持久效果：一般\\\\n滋润效果：很滋润\\\\n适合肤色：白皮\\\\n其他特色：膏体形状颜色都很漂亮\\\\n客服态度也很好呀，送的礼品也很好看，爱了爱了\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-24 16:37:15\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***f\", \"score\": 5, \"content\": \"颜色很正，气味也好闻，搽后不容易脱妆，小样的质量一样值得信赖。\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-13 14:41:58\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"小***1\", \"score\": 5, \"content\": \"口红收到已经涂上了，颜色特别正，喝水也不沾杯，显得我肤色很白，喜欢美美哒。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-09 17:56:30\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***c\", \"score\": 5, \"content\": \"买的小样 不过真的很好用 就是真的好小啊！比想象的小多了\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-09 14:08:30\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***v\", \"score\": 5, \"content\": \"颜色是我喜欢的，很显白也很高级。\\\\n我买的时候说的是送香水小样，但收到的是小熊挂坠\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-05 16:51:37\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"c***0\", \"score\": 5, \"content\": \"产品质感：颜色非常好看的口红，小样正好，正装口红每次都用不完，省下的钱可以多买几只口红啦，香港发货，物流也很快。\\\\n包装很精美、送的小熊饰品也好看。\\\\n第一次评论这么长，也不是托，就想试试一百字有多少，真的不好凑啊、\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-16 00:06:26\", \"usefulVoteCount\": 3, \"replyCount\": 2}, {\"nickname\": \"m***0\", \"score\": 5, \"content\": \"颜色很好看，肤色显白，味道好闻，滋润效果很好\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-11 17:00:15\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"感***e\", \"score\": 5, \"content\": \"唇膏已收到，物流很快，色泽纯正，很喜欢，商家服务态度好，很满意，赞赞！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-28 16:06:42\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"h***c\", \"score\": 5, \"content\": \"产品质感：正品\\\\n产品颜色：如描述一致\\\\n持久效果：很好\\\\n滋润效果：很好\\\\n适合肤色：应该说适合各种肤色\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-07 10:53:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***J\", \"score\": 5, \"content\": \"很喜欢这款口红，涂上很自然很滋润\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-19 12:02:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"x***n\", \"score\": 5, \"content\": \"产品质感：老婆特喜欢，这个颜色适合很多性格的女人，方便携带，作为携带补妆最合适。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-19 14:09:16\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"追***0\", \"score\": 5, \"content\": \"产品质感：挺好的\\\\n滋润效果：很好\\\\n产品颜色：好看\\\\n适合肤色：都可以\\\\n持久效果：很好\\\\n其他特色：性价比特别高\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-31 16:02:01\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***w\", \"score\": 5, \"content\": \"包装很漂亮，送的钥匙扣也很可爱，很喜欢，期待用过后有满意的效果！会再次回购！\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-13 10:26:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"清***风\", \"score\": 5, \"content\": \"颜色好，很滋润，持久效果好，好用的，正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-22 16:14:34\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***7\", \"score\": 5, \"content\": \"虽说是买的小样，大品牌就是好用，超级喜欢\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-11 13:39:49\", \"usefulVoteCount\": 3, \"replyCount\": 0}, {\"nickname\": \"j***x\", \"score\": 5, \"content\": \"这个口红很棒哦，颜色正，女儿说很满意！！！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-08 15:28:25\", \"usefulVoteCount\": 2, \"replyCount\": 0}, {\"nickname\": \"j***d\", \"score\": 5, \"content\": \"很显白，非常好看，持久度也很好，非常喜欢。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-29 13:48:40\", \"usefulVoteCount\": 3, \"replyCount\": 0}, {\"nickname\": \"j***e\", \"score\": 5, \"content\": \"总的来说是很好的，颜色有点不适合我，真的很小样\\\\n产品质感：挺好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-27 14:11:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***w\", \"score\": 5, \"content\": \"口红很棒，第一次购买，感觉颜色好看，比较持久。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-03 15:22:52\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"是正品，太好看了吧，这个外壳我爱了，包装也特别严实，很喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-18 19:34:24\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"醉***6\", \"score\": 5, \"content\": \"口红颜色正，款式漂亮，温和滋润，包装精美，价格实惠，很满意！\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-15 21:28:30\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***f\", \"score\": 5, \"content\": \"口红颜色不错，很合适我的肤色，很显白。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-15 15:56:52\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"N***酱\", \"score\": 5, \"content\": \"比较滋润，颜色很少女，小的可以买多种色号，省哦～\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-12 00:33:38\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"王***5\", \"score\": 5, \"content\": \"挺好看的，送给媳妇的，她很喜欢，这就足够好了\", \"productColor\": \"丝绒系列 58#热卖豆沙红3.5g【李佳琦推荐】\", \"referenceTime\": \"2020-02-11 22:57:36\", \"usefulVoteCount\": 7, \"replyCount\": 0}, {\"nickname\": \"j***r\", \"score\": 5, \"content\": \"口红颜色很喜欢，商家还送了小礼物?，多谢商家，下次还会回购！\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-03-01 12:35:46\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***f\", \"score\": 5, \"content\": \"口红颜色很正，很好看，滋润保湿不油腻\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-28 18:55:36\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"c***0\", \"score\": 5, \"content\": \"收到了，谢谢老板还送了小礼物，颜色很正，品牌东西就是不一，\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-04 15:59:06\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"卟***语\", \"score\": 5, \"content\": \"包装的很漂亮，还送了一个公仔和钥匙扣。\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-12 17:40:28\", \"usefulVoteCount\": 4, \"replyCount\": 0}, {\"nickname\": \"王***e\", \"score\": 5, \"content\": \"口红收到了，包装精美。颜色正，涂上很漂亮。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-30 15:40:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***x\", \"score\": 5, \"content\": \"产品质感：非常好\\\\n产品颜色：好好看\\\\n持久效果：涂了几分钟后会更好看\\\\n适合肤色：黄皮白皮都适合\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-15 16:36:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***0\", \"score\": 5, \"content\": \"是哑光的，很上色，持久度可以，应该是正品\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-03-21 09:17:11\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***3\", \"score\": 5, \"content\": \"服务态度真好，物流也好的一批，残次品返回去，我收不到货物，就当作花钱喂狗了。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-13 11:31:33\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"雯***瑗\", \"score\": 5, \"content\": \"好看，淡淡的涂上一层，气色好很多\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-26 07:43:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"小***蔓\", \"score\": 5, \"content\": \"很好，很喜欢，颜色也好，显皮肤白嫩\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-06 12:40:07\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***t\", \"score\": 5, \"content\": \"持久效果：不错\\\\n产品质感：很好\\\\n产品颜色：很正，涂上漂亮\\\\n适合肤色：都适合\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-10 19:58:14\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***0\", \"score\": 5, \"content\": \"非常好，最近都买小样，因为大样真的用不完啊\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-26 14:41:04\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***2\", \"score\": 5, \"content\": \"包装很精美，还没使用，试用了再追加吧，不过送的小坠子不错，叮叮**\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-16 13:05:59\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"路***L\", \"score\": 5, \"content\": \"颜色超美 包装很精致 还送了小熊 太喜欢了！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-31 23:35:08\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***c\", \"score\": 5, \"content\": \"口红收到了，物流很快。赠品很多，口红颜色很正，特别喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-24 15:08:03\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"王***7\", \"score\": 5, \"content\": \"非常漂亮，高端大气上档次，精品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-31 23:13:25\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"下***冷\", \"score\": 5, \"content\": \"色号挺正的，是我喜欢的意颜色，物流也很快\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-10 15:58:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"小***g\", \"score\": 5, \"content\": \"是正品还有淡淡的香味。这个也很好看。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-26 20:03:11\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***c\", \"score\": 5, \"content\": \"超级喜欢，颜色很好看，香香的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-20 18:56:37\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"e****\", \"score\": 5, \"content\": \"非常好   味道好   外观精致\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-02 00:59:53\", \"usefulVoteCount\": 2, \"replyCount\": 0}, {\"nickname\": \"x***3\", \"score\": 5, \"content\": \"口红颜色好看 保湿效果很好，值得推荐\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-26 14:46:36\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***h\", \"score\": 5, \"content\": \"很喜欢，味道香香的，很滋润\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-06 18:45:23\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***y\", \"score\": 5, \"content\": \"等了很久，不过很喜欢，没用让我失望\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-22 14:52:28\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***4\", \"score\": 5, \"content\": \"香味很好闻，送人很不错，很喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-30 14:45:17\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"口红很好，送礼盒又送小熊，物美价廉??\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-16 09:45:13\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***r\", \"score\": 5, \"content\": \"产品质感：豆沙色给妈妈很有气质很好看！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-21 14:05:59\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"D***d\", \"score\": 5, \"content\": \"礼品盒很精致！口红也很好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-03 08:44:39\", \"usefulVoteCount\": 2, \"replyCount\": 0}, {\"nickname\": \"x***烟\", \"score\": 5, \"content\": \"颜色选错了，太红了，其他的都很好\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-06 12:28:30\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"不错，包装很好，看上去高大上\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-16 13:10:32\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***6\", \"score\": 5, \"content\": \"非常喜欢这种颜色，这个价钱买的真心值了\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-30 13:37:35\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***f\", \"score\": 5, \"content\": \"产品质感：好\\\\n滋润效果：好\\\\n持久效果：好\\\\n产品颜色：好\\\\n其他特色：完美\\\\n适合肤色：白\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-11 23:19:42\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***r\", \"score\": 5, \"content\": \"很喜欢，枫叶给自己，上嘴好看。\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-21 14:05:59\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***6\", \"score\": 5, \"content\": \"滋润效果：效果很好用原来很好看\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-14 20:30:43\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"中***团\", \"score\": 5, \"content\": \"朋友推荐的，颜色不错，很喜欢\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-24 12:56:08\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"y***1\", \"score\": 5, \"content\": \"很精美漂亮！包装非常喜欢！\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-15 14:16:33\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"jd_152089ktn\", \"score\": 5, \"content\": \"其他特色：真的很好用，喜欢，赶紧下手\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-19 23:27:06\", \"usefulVoteCount\": 2, \"replyCount\": 1}, {\"nickname\": \"1***p\", \"score\": 5, \"content\": \"上色效果非常不错，喜欢?\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-07 16:15:39\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***4\", \"score\": 5, \"content\": \"小样很迷你，颜色好看，喜欢。\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-27 13:28:54\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"华***颖\", \"score\": 5, \"content\": \"质量很好，颜色好看很正，卖家发货很快\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-25 14:48:31\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"小***8\", \"score\": 5, \"content\": \"颜色很好，价格实惠，满意\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-22 19:13:54\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"很好用，滋润，颜色很漂亮\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-09 00:54:23\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"项***5\", \"score\": 5, \"content\": \"挺好的，特别好玩，小的可爱\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-09 08:44:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"f***B\", \"score\": 5, \"content\": \"颜色很纯正  包装也很漂亮，非常满意\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-12 22:44:52\", \"usefulVoteCount\": 4, \"replyCount\": 1}, {\"nickname\": \"j***h\", \"score\": 5, \"content\": \"产品颜色：非常喜欢这个颜色！！！！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-30 09:20:50\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***d\", \"score\": 5, \"content\": \"非常棒，送的小熊也特别喜欢\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-15 13:08:58\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"l***o\", \"score\": 5, \"content\": \"很好，家人喜欢，安心推荐\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-10 14:47:34\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"圆***姐\", \"score\": 5, \"content\": \"非常喜欢 超级有质感\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-30 03:16:48\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"不错，很喜欢这个颜色\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-24 20:33:24\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"T***n\", \"score\": 5, \"content\": \"特别好！大赞，推荐大家买\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-05 22:29:36\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"f***9\", \"score\": 5, \"content\": \"宝贝很棒。物流也快。好评！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-13 15:03:24\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"H***5\", \"score\": 5, \"content\": \"很好，满意，值得推荐\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-26 17:25:34\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"T***P\", \"score\": 5, \"content\": \"很喜欢  还送了小挂件\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-19 00:33:32\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"君***谷\", \"score\": 5, \"content\": \"是正品，非常好，喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-15 14:49:38\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"睡***鱼\", \"score\": 5, \"content\": \"当看到膏体颜色的时候我快崩溃了，但是上嘴以后颜色很优秀，显的人比较温柔，这是我用过最不像病入膏肓的豆沙色，这个口红味道是真的香&hellip;&hellip;\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-18 23:09:53\", \"usefulVoteCount\": 0, \"replyCount\": 3}, {\"nickname\": \"Y***g\", \"score\": 5, \"content\": \"很精致，只是用的很干，要是能湿润些就好了！没有想象中那么好！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-09 11:55:15\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"f***Y\", \"score\": 5, \"content\": \"太小了吧！还是不错的，有点小贵\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-09 08:42:05\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***u\", \"score\": 5, \"content\": \"第一次买这个牌子的口红，想试试，颜色和颜值都好喜欢，就是味道是一种花香?味，个人觉得没有巧克力的好闻。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-28 20:32:07\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"嘟***2\", \"score\": 5, \"content\": \"第一次买大牌，不知道是不是正品，就是味道挺好闻的，也挺润的，就是量真的好少，还没根拇指大，瞬间感觉不值，哈哈哈哈\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-12 15:07:00\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***k\", \"score\": 5, \"content\": \"定妆持久，肤色白的人用着更显白皙，产品颜色和图片描述一致，而且不干涩\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-06 13:46:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***w\", \"score\": 5, \"content\": \"小小的一只，携带方便，唯一的缺点就是口红顶端蹭到里面的壳上了。希望涂上不干吧。颜色看着可以，比较鲜亮\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-28 17:06:02\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"时光匆匆zxm\", \"score\": 4, \"content\": \"送的钥匙扣很好，就是找不到口红的生产日期。还没用，包装完好。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-08-04 12:47:30\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***6\", \"score\": 5, \"content\": \"挺好的 应该是正品 还送了匙扣\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-02 18:22:05\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"羊***刚\", \"score\": 5, \"content\": \"颜色好看是我想要的效果  滋润持久  和描述相符  好评\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-01 19:08:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"优****\", \"score\": 4, \"content\": \"颜色没得说，很漂亮，但是个人觉得还是有点干。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-29 10:03:48\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"河***儿\", \"score\": 5, \"content\": \"这是我收到时间最长的快递了，由于疫情原因，等了差不多2个月才到，颜色挺好看的！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-23 22:43:59\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"A***X\", \"score\": 4, \"content\": \"还没有开始使用，不过有淡淡的香味，太爱！还送了小礼物很喜欢\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-30 16:39:58\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"l***e\", \"score\": 5, \"content\": \"哑光的说实话我不是很喜欢，不过香味还可以，\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-19 19:49:54\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"c***x\", \"score\": 5, \"content\": \"产品颜色：比我想的深些，但是也挺好看的\\\\n持久效果：不掉色\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-19 21:09:03\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***W\", \"score\": 5, \"content\": \"东西不错，就是颜色不太适合我，涂上不太好看\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-14 19:08:57\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***h\", \"score\": 5, \"content\": \"虽然疫情原因 快递有点慢 但是唇膏很喜欢?\\\\n还会光顾的\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-20 19:50:04\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"好看，个人觉得，颜色更柔和自然保护区管\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-08-05 14:21:55\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"1***2\", \"score\": 5, \"content\": \"颜色可以，淡淡的香味，但是粘杯\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-07 16:14:04\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***d\", \"score\": 5, \"content\": \"滋润效果：很滋润\\\\n持久效果：不容易掉色，\\\\n产品质感：是正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-10 19:15:07\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"浅***0\", \"score\": 5, \"content\": \"颜色好看，也好涂，喜欢，香香的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-22 12:55:30\", \"usefulVoteCount\": 3, \"replyCount\": 1}, {\"nickname\": \"设***委\", \"score\": 5, \"content\": \"质量不错，外观精美，比较实用\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-25 20:11:59\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"链***节\", \"score\": 5, \"content\": \"上色效果挺好看的，滋润持久\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-29 16:06:02\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***n\", \"score\": 5, \"content\": \"喜欢，自己用的好给盆友买又给妹妹买！好东西要分享\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-12 20:05:51\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"f***g\", \"score\": 5, \"content\": \"非常好，虽然受疫情影响快递等了很久，但是产品不错\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-14 23:42:18\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***e\", \"score\": 5, \"content\": \"颜色棒棒哒，谢谢卖家送的小礼物\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-15 11:25:26\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"K***K\", \"score\": 5, \"content\": \"口红? 非常好就是价格有点高\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-29 22:31:18\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***c\", \"score\": 5, \"content\": \"老品牌，质量依然如此优良，值得购买！！！\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-01 22:32:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"m***g\", \"score\": 5, \"content\": \"漂亮的颜色，你必须要有一款\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-06 18:12:15\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"A***a\", \"score\": 5, \"content\": \"客服态度好，商品棒买它就没错，信我\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-10 14:21:31\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***g\", \"score\": 5, \"content\": \"产品质感：挺好京东买东西方便，送货也快，\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-19 08:08:18\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"精致，美观，携带方便。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-13 19:00:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"佳***蓓\", \"score\": 5, \"content\": \"这个口红不错，好喜欢\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-19 18:23:27\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***g\", \"score\": 5, \"content\": \"京东买东西方便，送货也快，\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-19 08:08:18\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***o\", \"score\": 5, \"content\": \"挺好，颜色正，大家买吧\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-05 13:02:57\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"l***e\", \"score\": 5, \"content\": \"口红抹上以后好看漂亮，还会再来\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-25 14:31:38\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***i\", \"score\": 5, \"content\": \"正品  还送礼物  开心\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-06 15:50:33\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"8***狸\", \"score\": 5, \"content\": \"看了可以，就是老是小了\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-08 21:32:27\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"k***3\", \"score\": 5, \"content\": \"香香的，感觉还行，就是卸下来是紫色不是红\\\\n，这个不知道到底是什么问题\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-20 13:54:11\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***t\", \"score\": 5, \"content\": \"等得好辛苦啊！差不多两个月才寄到。虽然是特殊情况，但也不用这么久，口红?应该是小样品的，没有我理想的克数，不过还可以吧。\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-29 11:56:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***w\", \"score\": 5, \"content\": \"还没用就掉了！也不知道好不好！还有没有了\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-23 17:38:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***7\", \"score\": 5, \"content\": \"大牌口红跟平常用的都一样嘛，也是有粘杯，起皮呀\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-30 12:36:11\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"d***R\", \"score\": 5, \"content\": \"真漂亮，还送了礼物\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-15 15:49:52\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***O\", \"score\": 5, \"content\": \"很精致，有点拔干\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-18 17:11:17\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***0\", \"score\": 5, \"content\": \"颜色还可以\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-25 14:27:34\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***f\", \"score\": 5, \"content\": \"颜色适合秋冬\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-04 16:16:38\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"滋润效果：干干的哪里有滋润\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-03 13:05:20\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***0\", \"score\": 5, \"content\": \"不错，很好看\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-15 07:11:38\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"无***1\", \"score\": 5, \"content\": \"产品质感：非常棒\\\\n产品颜色：非常棒\\\\n持久效果：非常棒\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-22 21:47:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***4\", \"score\": 5, \"content\": \"产品质感：服 \\\\n产品颜色：不错\\\\n适合肤色：可以\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-03 13:44:27\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***a\", \"score\": 5, \"content\": \"产品质感：是正品\\\\n滋润效果：很滋润\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-20 16:45:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"咕***s\", \"score\": 5, \"content\": \"产品颜色：好看\\\\n产品质感：很好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-25 11:41:49\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"酸***猬\", \"score\": 5, \"content\": \"产品颜色：颜色正，和大只一样\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-20 09:29:19\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"小***9\", \"score\": 5, \"content\": \"口红到货了，和描述的一样。赞\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-15 18:51:49\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"天***贝\", \"score\": 5, \"content\": \"挺好的我朋友很喜欢也很感动。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-22 14:46:21\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***8\", \"score\": 5, \"content\": \"产品颜色：很好\\\\n产品质感：很好\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-05 21:25:19\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***g\", \"score\": 5, \"content\": \"还不错第一次网购很顺利\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-15 21:01:49\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"a***7\", \"score\": 5, \"content\": \"口红很棒，女朋友很喜欢。\", \"productColor\": \"丝绒系列 58#热卖豆沙红3.5g【李佳琦推荐】\", \"referenceTime\": \"2020-02-04 19:12:58\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"G***X\", \"score\": 5, \"content\": \"产品颜色：挺喜欢的啊\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-22 06:53:43\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"d***6\", \"score\": 5, \"content\": \"还好，先用一下再评论。\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-26 06:17:18\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"产品质感：颜色正，超喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-17 15:24:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"m***5\", \"score\": 5, \"content\": \"挺不错的，老婆也喜欢\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-26 21:25:31\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***g\", \"score\": 5, \"content\": \"滋润效果：特别好，不沾杯\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-23 16:59:37\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"很小，显色度还可以\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-08-22 13:59:35\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"u***T\", \"score\": 5, \"content\": \"宝贝已收到，女友很喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-27 10:39:39\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***n\", \"score\": 5, \"content\": \"太喜欢！味道也好闻\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-28 14:29:40\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***p\", \"score\": 5, \"content\": \"还没用不知道效果\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-08 12:50:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***g\", \"score\": 5, \"content\": \"其他特色：包装还行\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-03 09:45:27\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***I\", \"score\": 5, \"content\": \"品牌就是值得信赖\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-28 14:38:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***k\", \"score\": 5, \"content\": \"产品颜色：颜色不错\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-05 18:24:51\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"r***c\", \"score\": 5, \"content\": \"颜色很漂亮。很喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-27 15:16:13\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"曾***0\", \"score\": 5, \"content\": \"产品颜色：漂亮持久\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-22 15:37:32\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"王***6\", \"score\": 5, \"content\": \"非常显白的色号\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-18 07:25:43\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***5\", \"score\": 5, \"content\": \"产品颜色：很艳丽\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-18 23:42:16\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***3\", \"score\": 5, \"content\": \"很喜欢这个颜色\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-18 19:16:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"C***C\", \"score\": 5, \"content\": \"是我喜欢的类型\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-09 20:46:05\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***q\", \"score\": 5, \"content\": \"适合肤色：不错\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-08-08 15:50:23\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"2***3\", \"score\": 5, \"content\": \"喜欢，颜色很好看\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-18 11:37:32\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"坏***0\", \"score\": 5, \"content\": \"持久效果：非常不错\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-28 17:55:55\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***u\", \"score\": 5, \"content\": \"产品颜色：很显白\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-04 10:53:37\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***I\", \"score\": 5, \"content\": \"滋润效果：很好\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-29 14:17:21\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***7\", \"score\": 5, \"content\": \"产品颜色：好看\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-13 13:35:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"U***L\", \"score\": 5, \"content\": \"收到了，很喜欢，\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-18 06:38:26\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"A***h\", \"score\": 5, \"content\": \"很好用，不掉色\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-12 14:11:37\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***g\", \"score\": 5, \"content\": \"颜色特别好看\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-22 21:41:04\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"t***儿\", \"score\": 5, \"content\": \"颜色好，很滋润。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-17 16:28:48\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***1\", \"score\": 5, \"content\": \"看上去还不错\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-19 07:36:35\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***z\", \"score\": 5, \"content\": \"好用不贵。喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-30 14:13:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***j\", \"score\": 5, \"content\": \"颜色好看喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-28 14:08:08\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***8\", \"score\": 5, \"content\": \"还没用过呢！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-12 23:19:26\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***1\", \"score\": 5, \"content\": \"产品质感：可以\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-08 16:50:56\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"B***H\", \"score\": 5, \"content\": \"很不错的东西\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-08 01:42:19\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"书***风\", \"score\": 5, \"content\": \"好很好非常好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-03 14:48:01\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***r\", \"score\": 5, \"content\": \"非常好很喜欢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-29 20:16:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***k\", \"score\": 5, \"content\": \"很不错，很精致\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-22 16:47:15\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***0\", \"score\": 5, \"content\": \"个人觉得很好\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-23 12:08:33\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***d\", \"score\": 5, \"content\": \"颜色很好看\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-03-14 19:52:06\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***m\", \"score\": 5, \"content\": \"太喜欢了\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-15 20:56:20\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***3\", \"score\": 5, \"content\": \"颜色很正\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-15 09:07:22\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"1***p\", \"score\": 5, \"content\": \"很好看咯\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-02 06:31:19\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***e\", \"score\": 5, \"content\": \"颜色非常正\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-17 09:57:27\", \"usefulVoteCount\": 1, \"replyCount\": 0}, {\"nickname\": \"j***蟹\", \"score\": 4, \"content\": \"非常满意\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-08 08:29:33\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***h\", \"score\": 5, \"content\": \"挺好的\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-23 14:04:31\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***z\", \"score\": 5, \"content\": \"不错，很好\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-12 16:57:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***n\", \"score\": 5, \"content\": \"颜色超正\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-05 15:46:07\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"很好用\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-18 12:00:27\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"郭***3\", \"score\": 5, \"content\": \"精致、小巧\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-12 23:38:45\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"s***a\", \"score\": 5, \"content\": \"比较实惠\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-06 07:20:57\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***G\", \"score\": 5, \"content\": \"挺好的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-24 15:06:57\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***R\", \"score\": 5, \"content\": \"很不错\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-06 08:10:45\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***酱\", \"score\": 5, \"content\": \"很漂亮\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-01 08:50:16\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"艳***9\", \"score\": 5, \"content\": \"喜欢\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-16 13:53:40\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***0\", \"score\": 5, \"content\": \"好评。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-22 10:43:07\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"刘***娟\", \"score\": 5, \"content\": \"满分！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-01 02:17:42\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"梨***n\", \"score\": 5, \"content\": \"产品质感：质感好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-11 21:43:57\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"淘***I\", \"score\": 5, \"content\": \"正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-11-24 19:43:41\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"跳妹的番茄\", \"score\": 5, \"content\": \"这个是小样，感觉真的是很小。因为我是买来送人的，所以不知道效果怎么样，但是大概看了一下，还是很不错的，而且东西还不是很贵，挺实惠，总的来说就是物美价廉，但是有点美中不足的就是上面的chanel logo有点小瑕疵。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-23 23:03:11\", \"usefulVoteCount\": 2, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"产品质感：不好\\\\n产品颜色：与图和描述不同。不是豆沙色。\\\\n持久效果：差\\\\n滋润效果：不好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-12 14:46:43\", \"usefulVoteCount\": 2, \"replyCount\": 0}, {\"nickname\": \"j***h\", \"score\": 5, \"content\": \"打开后口红上方有人为损坏，应该是盖盖子时候伤到的，因为口红盖子内没有口红损坏的残留物，给客服说了以后给我反了十元的补贴，希望以后这些问题能改善吧\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-19 16:02:18\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"梓***B\", \"score\": 5, \"content\": \"其他特色：味道与实体店差别太大，实体店无味、这里买有香味浓郁。金色位置明显凸出部分太多。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-20 22:29:17\", \"usefulVoteCount\": 5, \"replyCount\": 1}, {\"nickname\": \"j***u\", \"score\": 5, \"content\": \"之前用的是3.5g的，好润好用。这次想携带方便点买1.2g完全有对比，1.2g直接判断假得不能用，不上色，涂了有一层脱皮的样子，难看，用一次都不敢用了。花了钱，买了假货，后悔到不能相信网购，实体店还好找一下。真的太差\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-23 15:05:25\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***7\", \"score\": 5, \"content\": \"非常的袖珍，就是邮回来的速度不是一般的慢，咋也有两个来月\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-02 13:18:50\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"以***寜\", \"score\": 5, \"content\": \"有股淡淡的玫瑰香气，颜色也好看，涂起来不显唇纹，也不拔干。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-18 15:33:11\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***s\", \"score\": 5, \"content\": \"包装一般，有送礼品。口红盖子有明显划痕，一点都不像新的。\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-17 06:35:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"l***6\", \"score\": 5, \"content\": \"可以说，难辨真假，外壳感觉假，香味还行，那个上色一般。\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-05 23:05:22\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"偶***g\", \"score\": 5, \"content\": \"比我想象中的还要小很多\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-10 00:02:23\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"落***生\", \"score\": 5, \"content\": \"香味比较浓，买的本品感觉没那么香，不知道是不是真的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-06 12:55:33\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"ZuaJDTaMBtKJ\", \"score\": 5, \"content\": \"这种假货也拿出来骗人/根本扫这个商品不出来！就证明假货\", \"productColor\": \"炫亮系列 99#大红色-海盗3.5g\", \"referenceTime\": \"2020-06-19 15:24:43\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***r\", \"score\": 5, \"content\": \"很迷你，颜色的话。没有很特别，一般般\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-06 18:05:40\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"E***K\", \"score\": 5, \"content\": \"商品，和现实发过来的，一点也不一样，希望大家不要上当，太垃圾。\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-02-05 11:37:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***0\", \"score\": 5, \"content\": \"东西不好，不滋润掉色也很严重，和便宜的一个样\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-17 21:07:59\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"忽***现\", \"score\": 5, \"content\": \"太喜欢这个色号了，图上有点玫红和豆沙色的中和\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-06 09:44:49\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 5, \"content\": \"这哪叫不沾杯，又干又一直掉色\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-05 01:19:12\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"心***5\", \"score\": 5, \"content\": \"这个珊瑚色为啥跟想象中的不一样呢？\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-19 13:09:50\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***h\", \"score\": 5, \"content\": \"不知道是不是正品   颜色好容易摖掉\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-24 11:12:07\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"a***u\", \"score\": 5, \"content\": \"颜色不好看  特别小一**\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-23 15:01:29\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***v\", \"score\": 5, \"content\": \"快递超级慢啊  京东第一次买到这么慢的物流\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-22 20:23:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***H\", \"score\": 5, \"content\": \"颜色太深了，不太适合我，送人了\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-06 18:04:48\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"c***2\", \"score\": 5, \"content\": \"还没用，不过太小了，还是想买大的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-03-27 16:06:52\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***v\", \"score\": 5, \"content\": \"不好看，不适合我。幸好买的是小样\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-06 18:29:39\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"a***4\", \"score\": 5, \"content\": \"这个可能是个假牌子，会掉色，\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-19 23:03:06\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"米***3\", \"score\": 5, \"content\": \"感觉有点干，不觉得是正品\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-08-04 14:39:16\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***8\", \"score\": 5, \"content\": \"快递领取点服务态度极差极差差差差\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-06 09:40:33\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"利***驮\", \"score\": 5, \"content\": \"跟官方买的不一样，怀疑是不是正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-05-25 16:17:19\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"许***h\", \"score\": 5, \"content\": \"跟预计送达时间不一样\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-20 15:58:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"S***X\", \"score\": 5, \"content\": \"物流慢死了，等了2个月\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-31 13:53:13\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"星***8\", \"score\": 5, \"content\": \"太精致了\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-04 13:55:10\", \"usefulVoteCount\": 2, \"replyCount\": 1}, {\"nickname\": \"j***c\", \"score\": 5, \"content\": \"那么小点我怀疑换包\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-03 18:34:01\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***y\", \"score\": 5, \"content\": \"收货实在是太慢了\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-02-23 00:46:43\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***4\", \"score\": 5, \"content\": \"不掉色，又起坨\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-11 06:55:30\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***o\", \"score\": 5, \"content\": \"实在太小了\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-15 13:01:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***士\", \"score\": 5, \"content\": \"物流有点慢\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-18 04:31:49\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***C\", \"score\": 5, \"content\": \"明显有色差\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-08 17:27:32\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***z\", \"score\": 5, \"content\": \"味不喜欢\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-29 00:25:01\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***v\", \"score\": 5, \"content\": \"有点袖珍\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-24 20:19:43\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***c\", \"score\": 5, \"content\": \"小了点\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-03 14:31:30\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"L***i\", \"score\": 5, \"content\": \"正品！颜色挺适合我的！比~要便宜的多！\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-01 16:41:42\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***1\", \"score\": 5, \"content\": \"非常好\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-16 11:55:10\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***1\", \"score\": 5, \"content\": \"好好\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-08-22 10:20:47\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"m***-\", \"score\": 5, \"content\": \"可以\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-09 18:51:40\", \"usefulVoteCount\": 0, \"replyCount\": 0}]',\n",
       "        '[{\"nickname\": \"f***0\", \"score\": 3, \"content\": \"好小，刚收到还没有用，用了在追加评论吧！送钥匙链还可以，\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-19 17:54:45\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***d\", \"score\": 3, \"content\": \"香奈儿的口红有一股香味，味道好闻，抹上口红一天，香味也持续不断，个人不喜欢带香味的口红，是正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-07-30 18:04:08\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***V\", \"score\": 3, \"content\": \"为什么二维码扫不出来，\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-04 11:39:53\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***b\", \"score\": 3, \"content\": \"适合肤色：沾杯，不理想\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-15 21:21:28\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"他***海\", \"score\": 3, \"content\": \"感觉不是正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-02 12:55:32\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"j***6\", \"score\": 3, \"content\": \"标识为什么是歪的     有点不舒服\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-01-01 05:57:52\", \"usefulVoteCount\": 3, \"replyCount\": 1}, {\"nickname\": \"j***b\", \"score\": 2, \"content\": \"沾杯又掉色\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-05 01:19:12\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"w***z\", \"score\": 2, \"content\": \"不像正品\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-19 14:43:48\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"M***0\", \"score\": 2, \"content\": \"持久效果：效果还是不错，但是没用两天既然断了，现在都没法用了\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-17 19:52:41\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"X***8\", \"score\": 3, \"content\": \"太小了\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-22 14:04:37\", \"usefulVoteCount\": 0, \"replyCount\": 0}, {\"nickname\": \"紫***轩\", \"score\": 2, \"content\": \"为了买一支称心如意的，花了很多时间，查阅了很多资料，终于盼到了，大失所望，上色卡粉，先涂润唇膏还是卡粉，真怀疑是不是假的，果断另外买ct\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-08-08 10:11:21\", \"usefulVoteCount\": 0, \"replyCount\": 0}]',\n",
       "        '[{\"nickname\": \"十***天\", \"score\": 1, \"content\": \"产品质感：感觉有点假\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-20 19:42:57\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***1\", \"score\": 1, \"content\": \"产品质感：感觉是假的，和正品的不一样\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-29 19:44:36\", \"usefulVoteCount\": 1, \"replyCount\": 2}, {\"nickname\": \"j***9\", \"score\": 1, \"content\": \"字母H有点小瑕疵  感觉不是真品  正常来说香奈儿哪么大一个品牌应该不会有这个小瑕疵的  所以觉得是假的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2019-12-04 15:21:53\", \"usefulVoteCount\": 1, \"replyCount\": 1}, {\"nickname\": \"1***p\", \"score\": 1, \"content\": \"假的！\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-23 16:25:15\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***a\", \"score\": 1, \"content\": \"搽的嘴唇干\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-07 10:18:43\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***6\", \"score\": 1, \"content\": \"差的要命\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-18 21:52:42\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***m\", \"score\": 1, \"content\": \"不是正品\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-27 12:20:38\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***m\", \"score\": 1, \"content\": \"不是正品\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-06-27 12:20:38\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***2\", \"score\": 1, \"content\": \"太干了，不知道是不是假的\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-26 15:16:10\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***5\", \"score\": 1, \"content\": \"产品质量差，欺骗消费者，不是正品，弄虚作假，\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-08-12 23:40:59\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***p\", \"score\": 1, \"content\": \"一点都不好，差开就这样了，客服好久了也不回话\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-03-26 20:44:15\", \"usefulVoteCount\": 0, \"replyCount\": 2}, {\"nickname\": \"j***F\", \"score\": 1, \"content\": \"本次体验非常不好，以后不会来买了。\", \"productColor\": \"99#大红色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-05-20 12:31:14\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"q***-\", \"score\": 1, \"content\": \"色差太严重！发货太慢！\\\\n产品颜色：色差严重\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-14 00:37:50\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"j***i\", \"score\": 1, \"content\": \"质量非常差！\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-07-08 18:41:05\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"I***P\", \"score\": 1, \"content\": \"产品质感：收到货打开后都是断的，虽然客服补偿了，说吹风机吹一下可以接回来，搞的我手上衣服上到处都是，心里很不爽，到最后彻底没用了???\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-17 10:29:14\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"I***P\", \"score\": 1, \"content\": \"产品质感：收到货都是断的，客服说吹风吹一下可以接回来。，结果搞得到处都是，弄的衣服上都是，我穿的还是白衣服，费我一件衣服，，一件衣服几百块钱，你个破口红给毁了，，搞的我现在特别气愤\", \"productColor\": \"57#枫叶色 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-04-17 10:29:14\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"赵***z\", \"score\": 1, \"content\": \"假的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-04-08 22:22:42\", \"usefulVoteCount\": 0, \"replyCount\": 1}, {\"nickname\": \"梦***7\", \"score\": 1, \"content\": \"假的\", \"productColor\": \" 58#热卖豆沙红 香奈儿口红小样1.2g【限量】\", \"referenceTime\": \"2020-06-26 16:48:30\", \"usefulVoteCount\": 0, \"replyCount\": 1}]',\n",
       "        '{\"提亮肤色\": [{\"nickname\": \"小***蔓\", \"score\": 5, \"content\": \"很好，很喜欢，颜色也好，显皮肤白嫩\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-06 12:40:07\", \"usefulVoteCount\": 1, \"replyCount\": 0}], \"精美漂亮\": [{\"nickname\": \"y***1\", \"score\": 5, \"content\": \"很精美漂亮！包装非常喜欢！\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2019-12-15 14:16:33\", \"usefulVoteCount\": 1, \"replyCount\": 0}], \"不油不干\": [{\"nickname\": \"j***k\", \"score\": 5, \"content\": \"定妆持久，肤色白的人用着更显白皙，产品颜色和图片描述一致，而且不干涩\", \"productColor\": \"43#珊瑚红 香奈儿口红小样正品1.2g【限量】\", \"referenceTime\": \"2020-01-06 13:46:09\", \"usefulVoteCount\": 0, \"replyCount\": 0}]}']],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "before_august.query(\"productId == 62383970544\")[\n",
    "    [\"good_comment\", 'middle_comment','poor_comment',\"product_comments\"]\n",
    "].values\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>productId</th>\n",
       "      <th>评论明细</th>\n",
       "      <th>sku_id</th>\n",
       "      <th>活动时间</th>\n",
       "      <th>活动前评论</th>\n",
       "      <th>活动后评论</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>62383970544</td>\n",
       "      <td>[(2020-04-14 20:30:43, 滋润效果：效果很好用原来很好看), (2020...</td>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>[(2020-04-14 20:30:43, 滋润效果：效果很好用原来很好看), (2020...</td>\n",
       "      <td>[(2020-08-03 17:23:41, 商品很好，很喜欢，送人的，朋友也很喜欢，质量也...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>57328615327</td>\n",
       "      <td>[(2020-09-06 19:02:07, 张艺兴冲鸭), (2020-08-22 14:...</td>\n",
       "      <td>57328615327</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>[(2020-05-22 23:07:15, 产品质感：好), (2020-05-19 18...</td>\n",
       "      <td>[(2020-09-06 19:02:07, 张艺兴冲鸭), (2020-08-22 14:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>68292269899</td>\n",
       "      <td>[(2020-06-12 21:23:28, 质量很好，包装盒很nice), (2020-0...</td>\n",
       "      <td>68292269899</td>\n",
       "      <td>2020-07-09 22:34:59</td>\n",
       "      <td>[(2020-06-12 21:23:28, 质量很好，包装盒很nice), (2020-0...</td>\n",
       "      <td>[(2020-07-15 15:33:31, 看吧！假的，一股刺鼻的化学味道，申请退货了),...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>66472346588</td>\n",
       "      <td>[(2020-08-08 19:34:31, 产品质感：口红收到，产品质感很好，颜爸正，不掉...</td>\n",
       "      <td>66472346588</td>\n",
       "      <td>2020-07-09 22:40:46</td>\n",
       "      <td>[(2020-04-11 18:32:42, 产品颜色：给女朋友买的，质量不错，原装正品，颜...</td>\n",
       "      <td>[(2020-08-08 19:34:31, 产品质感：口红收到，产品质感很好，颜爸正，不掉...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>69591452342</td>\n",
       "      <td>[(2020-07-02 12:06:33, 很好看 境外发货还这么快 嗯&amp;hellip;&amp;...</td>\n",
       "      <td>69591452342</td>\n",
       "      <td>2020-07-09 22:51:48</td>\n",
       "      <td>[(2020-07-02 12:06:33, 很好看 境外发货还这么快 嗯&amp;hellip;&amp;...</td>\n",
       "      <td>[(2020-07-11 21:35:41, 真是爱了爱了), (2020-07-16 10...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     productId                                               评论明细  \\\n",
       "0  62383970544  [(2020-04-14 20:30:43, 滋润效果：效果很好用原来很好看), (2020...   \n",
       "1  57328615327  [(2020-09-06 19:02:07, 张艺兴冲鸭), (2020-08-22 14:...   \n",
       "2  68292269899  [(2020-06-12 21:23:28, 质量很好，包装盒很nice), (2020-0...   \n",
       "3  66472346588  [(2020-08-08 19:34:31, 产品质感：口红收到，产品质感很好，颜爸正，不掉...   \n",
       "4  69591452342  [(2020-07-02 12:06:33, 很好看 境外发货还这么快 嗯&hellip;&...   \n",
       "\n",
       "        sku_id                活动时间  \\\n",
       "0  62383970544 2020-07-09 22:37:19   \n",
       "1  57328615327 2020-07-09 22:37:19   \n",
       "2  68292269899 2020-07-09 22:34:59   \n",
       "3  66472346588 2020-07-09 22:40:46   \n",
       "4  69591452342 2020-07-09 22:51:48   \n",
       "\n",
       "                                               活动前评论  \\\n",
       "0  [(2020-04-14 20:30:43, 滋润效果：效果很好用原来很好看), (2020...   \n",
       "1  [(2020-05-22 23:07:15, 产品质感：好), (2020-05-19 18...   \n",
       "2  [(2020-06-12 21:23:28, 质量很好，包装盒很nice), (2020-0...   \n",
       "3  [(2020-04-11 18:32:42, 产品颜色：给女朋友买的，质量不错，原装正品，颜...   \n",
       "4  [(2020-07-02 12:06:33, 很好看 境外发货还这么快 嗯&hellip;&...   \n",
       "\n",
       "                                               活动后评论  \n",
       "0  [(2020-08-03 17:23:41, 商品很好，很喜欢，送人的，朋友也很喜欢，质量也...  \n",
       "1  [(2020-09-06 19:02:07, 张艺兴冲鸭), (2020-08-22 14:...  \n",
       "2  [(2020-07-15 15:33:31, 看吧！假的，一股刺鼻的化学味道，申请退货了),...  \n",
       "3  [(2020-08-08 19:34:31, 产品质感：口红收到，产品质感很好，颜爸正，不掉...  \n",
       "4  [(2020-07-11 21:35:41, 真是爱了爱了), (2020-07-16 10...  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "thin_before_august = pd.merge(before_august[['productId','评论明细']], activity_sheet[['sku_id', '活动时间']], left_on='productId', right_on='sku_id')\n",
    "\n",
    "\n",
    "thin_before_august['活动前评论'] = thin_before_august.apply(lambda x: [c for c in x['评论明细'] if parse(c[0]) < x['活动时间']], axis=1)\n",
    "thin_before_august['活动后评论'] = thin_before_august.apply(lambda x: [c for c in x['评论明细'] if parse(c[0]) > x['活动时间']], axis=1)\n",
    "\n",
    "thin_before_august.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2804, 6)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "thin_before_august.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "data4train=[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "for value in thin_before_august.values:\n",
    "    for __comment in value[4]:\n",
    "        data4train.append([value[0], value[3], __comment[0], __comment[1], '活动前'])\n",
    "    for __comment in value[5]:\n",
    "        data4train.append([value[0], value[3], __comment[0], __comment[1], '活动后'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "169641"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data4train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "data4train_sheet = pd.DataFrame(data4train, columns=['productId', '活动时间', '评论时间', '评论内容', '类型'])\n",
    "data4train_sheet['美学维度'] = ''\n",
    "data4train_sheet['功能维度'] = ''\n",
    "data4train_sheet['服务维度'] = ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>productId</th>\n",
       "      <th>活动时间</th>\n",
       "      <th>评论时间</th>\n",
       "      <th>评论内容</th>\n",
       "      <th>类型</th>\n",
       "      <th>美学维度</th>\n",
       "      <th>功能维度</th>\n",
       "      <th>服务维度</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>2020-04-14 20:30:43</td>\n",
       "      <td>滋润效果：效果很好用原来很好看</td>\n",
       "      <td>活动前</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>2020-07-06 18:04:48</td>\n",
       "      <td>颜色太深了，不太适合我，送人了</td>\n",
       "      <td>活动前</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>2020-05-19 14:09:16</td>\n",
       "      <td>产品质感：老婆特喜欢，这个颜色适合很多性格的女人，方便携带，作为携带补妆最合适。</td>\n",
       "      <td>活动前</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>2020-06-16 16:54:53</td>\n",
       "      <td>宝贝q收到就迫不及待打开，包装很安全，还送了钥匙链，礼品盒，礼品袋，卖家考虑的很周全，送人很...</td>\n",
       "      <td>活动前</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>62383970544</td>\n",
       "      <td>2020-07-09 22:37:19</td>\n",
       "      <td>2020-05-26 15:16:10</td>\n",
       "      <td>太干了，不知道是不是假的</td>\n",
       "      <td>活动前</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     productId                活动时间                 评论时间  \\\n",
       "0  62383970544 2020-07-09 22:37:19  2020-04-14 20:30:43   \n",
       "1  62383970544 2020-07-09 22:37:19  2020-07-06 18:04:48   \n",
       "2  62383970544 2020-07-09 22:37:19  2020-05-19 14:09:16   \n",
       "3  62383970544 2020-07-09 22:37:19  2020-06-16 16:54:53   \n",
       "4  62383970544 2020-07-09 22:37:19  2020-05-26 15:16:10   \n",
       "\n",
       "                                                评论内容   类型 美学维度 功能维度 服务维度  \n",
       "0                                    滋润效果：效果很好用原来很好看  活动前                 \n",
       "1                                    颜色太深了，不太适合我，送人了  活动前                 \n",
       "2           产品质感：老婆特喜欢，这个颜色适合很多性格的女人，方便携带，作为携带补妆最合适。  活动前                 \n",
       "3  宝贝q收到就迫不及待打开，包装很安全，还送了钥匙链，礼品盒，礼品袋，卖家考虑的很周全，送人很...  活动前                 \n",
       "4                                       太干了，不知道是不是假的  活动前                 "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data4train_sheet.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "data4train_sheet.to_excel('data/comment_20211212.xlsx', engine='xlsxwriter', index=False, freeze_panes=[1,0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "0c544d681126d804d1243b64729a47934a3cbc7bce72a0ec0a94992403418035"
  },
  "kernelspec": {
   "display_name": "Python 3.7.11 64-bit ('python3.7': conda)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.11"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}