week_1/week_1_first_meet.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##  1.快速認識資料"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv('Ntu_Orders.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SalesOrderSlaveId</th>\n",
       "      <th>DateId</th>\n",
       "      <th>MemberId</th>\n",
       "      <th>TradesOrderSlaveId</th>\n",
       "      <th>ShopId</th>\n",
       "      <th>SalePageId</th>\n",
       "      <th>TradesOrderGroupCode</th>\n",
       "      <th>TrackSourceTypeDef</th>\n",
       "      <th>TrackChannelTypeDef</th>\n",
       "      <th>TrackDeviceTypeDef</th>\n",
       "      <th>...</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>PromotionDiscount</th>\n",
       "      <th>EcouponDiscount</th>\n",
       "      <th>SalesOrderSlaveTotalPayment</th>\n",
       "      <th>SalesOrderSlaveDateTime</th>\n",
       "      <th>SalesOrderSlaveStatusDef</th>\n",
       "      <th>PayProfileTypeDef</th>\n",
       "      <th>ShippingProfileTypeDef</th>\n",
       "      <th>EcouponId</th>\n",
       "      <th>IsSalePageGift</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26914456</td>\n",
       "      <td>20170103</td>\n",
       "      <td>48D5DE26-236E-4854-8474-B0DCEAFF4F42</td>\n",
       "      <td>26971960</td>\n",
       "      <td>1317</td>\n",
       "      <td>9804</td>\n",
       "      <td>b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>399.0</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>374.0</td>\n",
       "      <td>2017-01-03 23:11:47.207</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>26914457</td>\n",
       "      <td>20170103</td>\n",
       "      <td>48D5DE26-236E-4854-8474-B0DCEAFF4F42</td>\n",
       "      <td>26971961</td>\n",
       "      <td>1317</td>\n",
       "      <td>9804</td>\n",
       "      <td>b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>399.0</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>374.0</td>\n",
       "      <td>2017-01-03 23:11:47.223</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26767644</td>\n",
       "      <td>20170101</td>\n",
       "      <td>C8B989DB-05F9-42D3-BD4F-E203482C5E58</td>\n",
       "      <td>26825136</td>\n",
       "      <td>1317</td>\n",
       "      <td>10118</td>\n",
       "      <td>b'\\x1d\\x8f}\\x12lu&gt;.&amp;\\xfc\\xbc\\xe0\\xd2\\xad\\xe5\\x...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>350.0</td>\n",
       "      <td>-34.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>316.0</td>\n",
       "      <td>2017-01-01 17:21:32.113</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26780512</td>\n",
       "      <td>20170101</td>\n",
       "      <td>C39E36F7-5091-48DA-BE8F-8CE043E009EE</td>\n",
       "      <td>26837997</td>\n",
       "      <td>1317</td>\n",
       "      <td>10036</td>\n",
       "      <td>b'&amp;QI#u)\\xf8\\xf7\\n6\\x01~\\xd1\\xf3,\\x1f\\xb8\\xe3\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>540.0</td>\n",
       "      <td>-57.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>483.0</td>\n",
       "      <td>2017-01-01 21:41:58.153</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>26823950</td>\n",
       "      <td>20170102</td>\n",
       "      <td>7D87099A-B49C-4136-A8E9-F76BB5588B19</td>\n",
       "      <td>26881442</td>\n",
       "      <td>1317</td>\n",
       "      <td>10268</td>\n",
       "      <td>b'\\xfd\\x0b\\x9ee\\xdc\\xaea@\\x102;jX\\xfek\\x99m\\x1...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>445.0</td>\n",
       "      <td>-44.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>2017-01-02 15:37:33.610</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   SalesOrderSlaveId    DateId                              MemberId  \\\n",
       "0           26914456  20170103  48D5DE26-236E-4854-8474-B0DCEAFF4F42   \n",
       "1           26914457  20170103  48D5DE26-236E-4854-8474-B0DCEAFF4F42   \n",
       "2           26767644  20170101  C8B989DB-05F9-42D3-BD4F-E203482C5E58   \n",
       "3           26780512  20170101  C39E36F7-5091-48DA-BE8F-8CE043E009EE   \n",
       "4           26823950  20170102  7D87099A-B49C-4136-A8E9-F76BB5588B19   \n",
       "\n",
       "   TradesOrderSlaveId  ShopId  SalePageId  \\\n",
       "0            26971960    1317        9804   \n",
       "1            26971961    1317        9804   \n",
       "2            26825136    1317       10118   \n",
       "3            26837997    1317       10036   \n",
       "4            26881442    1317       10268   \n",
       "\n",
       "                                TradesOrderGroupCode TrackSourceTypeDef  \\\n",
       "0  b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...                Web   \n",
       "1  b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...                Web   \n",
       "2  b'\\x1d\\x8f}\\x12lu>.&\\xfc\\xbc\\xe0\\xd2\\xad\\xe5\\x...                Web   \n",
       "3  b'&QI#u)\\xf8\\xf7\\n6\\x01~\\xd1\\xf3,\\x1f\\xb8\\xe3\\...                Web   \n",
       "4  b'\\xfd\\x0b\\x9ee\\xdc\\xaea@\\x102;jX\\xfek\\x99m\\x1...                Web   \n",
       "\n",
       "  TrackChannelTypeDef TrackDeviceTypeDef       ...       UnitPrice  \\\n",
       "0               Brand             Mobile       ...           399.0   \n",
       "1               Brand             Mobile       ...           399.0   \n",
       "2               Brand             Mobile       ...           350.0   \n",
       "3               Brand             Mobile       ...           540.0   \n",
       "4               Brand             Mobile       ...           445.0   \n",
       "\n",
       "  PromotionDiscount EcouponDiscount SalesOrderSlaveTotalPayment  \\\n",
       "0             -25.0             0.0                       374.0   \n",
       "1             -25.0             0.0                       374.0   \n",
       "2             -34.0             0.0                       316.0   \n",
       "3             -57.0             0.0                       483.0   \n",
       "4             -44.0             0.0                       401.0   \n",
       "\n",
       "   SalesOrderSlaveDateTime  SalesOrderSlaveStatusDef  PayProfileTypeDef  \\\n",
       "0  2017-01-03 23:11:47.207                    Finish        SevenEleven   \n",
       "1  2017-01-03 23:11:47.223                    Finish        SevenEleven   \n",
       "2  2017-01-01 17:21:32.113                    Finish             Family   \n",
       "3  2017-01-01 21:41:58.153                    Finish             Family   \n",
       "4  2017-01-02 15:37:33.610                    Finish             Family   \n",
       "\n",
       "   ShippingProfileTypeDef  EcouponId  IsSalePageGift  \n",
       "0             SevenEleven        NaN           False  \n",
       "1             SevenEleven        NaN           False  \n",
       "2                  Family        NaN           False  \n",
       "3                  Family        NaN           False  \n",
       "4                  Family        NaN           False  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SalesOrderSlaveId</th>\n",
       "      <th>DateId</th>\n",
       "      <th>MemberId</th>\n",
       "      <th>TradesOrderSlaveId</th>\n",
       "      <th>ShopId</th>\n",
       "      <th>SalePageId</th>\n",
       "      <th>TradesOrderGroupCode</th>\n",
       "      <th>TrackSourceTypeDef</th>\n",
       "      <th>TrackChannelTypeDef</th>\n",
       "      <th>TrackDeviceTypeDef</th>\n",
       "      <th>...</th>\n",
       "      <th>UnitPrice</th>\n",
       "      <th>PromotionDiscount</th>\n",
       "      <th>EcouponDiscount</th>\n",
       "      <th>SalesOrderSlaveTotalPayment</th>\n",
       "      <th>SalesOrderSlaveDateTime</th>\n",
       "      <th>SalesOrderSlaveStatusDef</th>\n",
       "      <th>PayProfileTypeDef</th>\n",
       "      <th>ShippingProfileTypeDef</th>\n",
       "      <th>EcouponId</th>\n",
       "      <th>IsSalePageGift</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2268343</th>\n",
       "      <td>50056662</td>\n",
       "      <td>20171220</td>\n",
       "      <td>97E7CF33-3DF1-4514-AC5E-448D7DD41799</td>\n",
       "      <td>50120466</td>\n",
       "      <td>1317</td>\n",
       "      <td>16093</td>\n",
       "      <td>b'pG]\\xcc\\x00\\xebp\\xf8rh\\xcc\\xde\\xf6\\x9d\\xf9\\x...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>199.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>2017-12-20 16:11:30.963</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268344</th>\n",
       "      <td>50056663</td>\n",
       "      <td>20171220</td>\n",
       "      <td>97E7CF33-3DF1-4514-AC5E-448D7DD41799</td>\n",
       "      <td>50120467</td>\n",
       "      <td>1317</td>\n",
       "      <td>16093</td>\n",
       "      <td>b'pG]\\xcc\\x00\\xebp\\xf8rh\\xcc\\xde\\xf6\\x9d\\xf9\\x...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>199.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>2017-12-20 16:11:30.987</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268345</th>\n",
       "      <td>50057718</td>\n",
       "      <td>20171220</td>\n",
       "      <td>CEC073AD-FED6-4382-A408-56527B10DE4E</td>\n",
       "      <td>50121525</td>\n",
       "      <td>1317</td>\n",
       "      <td>9125</td>\n",
       "      <td>b'\\xdd\\xda\\xe9\\xbb\\x12#\\xe3\\xca7\\x0e\\xb07\\xff#...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>249.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>249.0</td>\n",
       "      <td>2017-12-20 16:31:19.820</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268346</th>\n",
       "      <td>50057719</td>\n",
       "      <td>20171220</td>\n",
       "      <td>CEC073AD-FED6-4382-A408-56527B10DE4E</td>\n",
       "      <td>50121526</td>\n",
       "      <td>1317</td>\n",
       "      <td>8602</td>\n",
       "      <td>b'\\xdd\\xda\\xe9\\xbb\\x12#\\xe3\\xca7\\x0e\\xb07\\xff#...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>499.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>499.0</td>\n",
       "      <td>2017-12-20 16:31:19.840</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268347</th>\n",
       "      <td>50058976</td>\n",
       "      <td>20171220</td>\n",
       "      <td>F135AC00-E702-47F1-B496-8EDCBE62EBBD</td>\n",
       "      <td>50122780</td>\n",
       "      <td>1317</td>\n",
       "      <td>10114</td>\n",
       "      <td>b'\\xf4\\n\\x14\\xdc\\x85n\\x17JY\\x14\\xb3\\x99v\\x15\\x...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>199.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>2017-12-20 16:54:19.263</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         SalesOrderSlaveId    DateId                              MemberId  \\\n",
       "2268343           50056662  20171220  97E7CF33-3DF1-4514-AC5E-448D7DD41799   \n",
       "2268344           50056663  20171220  97E7CF33-3DF1-4514-AC5E-448D7DD41799   \n",
       "2268345           50057718  20171220  CEC073AD-FED6-4382-A408-56527B10DE4E   \n",
       "2268346           50057719  20171220  CEC073AD-FED6-4382-A408-56527B10DE4E   \n",
       "2268347           50058976  20171220  F135AC00-E702-47F1-B496-8EDCBE62EBBD   \n",
       "\n",
       "         TradesOrderSlaveId  ShopId  SalePageId  \\\n",
       "2268343            50120466    1317       16093   \n",
       "2268344            50120467    1317       16093   \n",
       "2268345            50121525    1317        9125   \n",
       "2268346            50121526    1317        8602   \n",
       "2268347            50122780    1317       10114   \n",
       "\n",
       "                                      TradesOrderGroupCode TrackSourceTypeDef  \\\n",
       "2268343  b'pG]\\xcc\\x00\\xebp\\xf8rh\\xcc\\xde\\xf6\\x9d\\xf9\\x...         AndroidApp   \n",
       "2268344  b'pG]\\xcc\\x00\\xebp\\xf8rh\\xcc\\xde\\xf6\\x9d\\xf9\\x...         AndroidApp   \n",
       "2268345  b'\\xdd\\xda\\xe9\\xbb\\x12#\\xe3\\xca7\\x0e\\xb07\\xff#...                Web   \n",
       "2268346  b'\\xdd\\xda\\xe9\\xbb\\x12#\\xe3\\xca7\\x0e\\xb07\\xff#...                Web   \n",
       "2268347  b'\\xf4\\n\\x14\\xdc\\x85n\\x17JY\\x14\\xb3\\x99v\\x15\\x...                Web   \n",
       "\n",
       "        TrackChannelTypeDef TrackDeviceTypeDef       ...       UnitPrice  \\\n",
       "2268343               Brand             Mobile       ...           199.0   \n",
       "2268344               Brand             Mobile       ...           199.0   \n",
       "2268345               Brand                 PC       ...           249.0   \n",
       "2268346               Brand                 PC       ...           499.0   \n",
       "2268347               Brand                 PC       ...           199.0   \n",
       "\n",
       "        PromotionDiscount EcouponDiscount SalesOrderSlaveTotalPayment  \\\n",
       "2268343               0.0             0.0                       199.0   \n",
       "2268344               0.0             0.0                       199.0   \n",
       "2268345               0.0             0.0                       249.0   \n",
       "2268346               0.0             0.0                       499.0   \n",
       "2268347               0.0             0.0                       199.0   \n",
       "\n",
       "         SalesOrderSlaveDateTime  SalesOrderSlaveStatusDef  PayProfileTypeDef  \\\n",
       "2268343  2017-12-20 16:11:30.963                    Finish             Family   \n",
       "2268344  2017-12-20 16:11:30.987                    Finish             Family   \n",
       "2268345  2017-12-20 16:31:19.820                    Cancel             Family   \n",
       "2268346  2017-12-20 16:31:19.840                    Cancel             Family   \n",
       "2268347  2017-12-20 16:54:19.263                    Finish        SevenEleven   \n",
       "\n",
       "         ShippingProfileTypeDef  EcouponId  IsSalePageGift  \n",
       "2268343                  Family        NaN           False  \n",
       "2268344                  Family        NaN           False  \n",
       "2268345                  Family        NaN           False  \n",
       "2268346                  Family        NaN           False  \n",
       "2268347             SevenEleven        NaN           False  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "*了解資料樣貌與型態 : shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2268348, 27)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "*info()方法，看資料中的變數目前都是那些型態"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2268348 entries, 0 to 2268347\n",
      "Data columns (total 27 columns):\n",
      "SalesOrderSlaveId              int64\n",
      "DateId                         int64\n",
      "MemberId                       object\n",
      "TradesOrderSlaveId             int64\n",
      "ShopId                         int64\n",
      "SalePageId                     int64\n",
      "TradesOrderGroupCode           object\n",
      "TrackSourceTypeDef             object\n",
      "TrackChannelTypeDef            object\n",
      "TrackDeviceTypeDef             object\n",
      "LevelOneCategoryName           object\n",
      "LevelTwoCategoryName           object\n",
      "LevelThreeCategoryName         object\n",
      "LevelFourCategoryName          object\n",
      "IsMajor                        bool\n",
      "IsGift                         bool\n",
      "Quantity                       int64\n",
      "UnitPrice                      float64\n",
      "PromotionDiscount              float64\n",
      "EcouponDiscount                float64\n",
      "SalesOrderSlaveTotalPayment    float64\n",
      "SalesOrderSlaveDateTime        object\n",
      "SalesOrderSlaveStatusDef       object\n",
      "PayProfileTypeDef              object\n",
      "ShippingProfileTypeDef         object\n",
      "EcouponId                      float64\n",
      "IsSalePageGift                 bool\n",
      "dtypes: bool(3), float64(5), int64(6), object(13)\n",
      "memory usage: 421.8+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df['new_DateId'] = pd.to_datetime(df['DateId'].astype(str), format=\"%Y%m%d\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2268348 entries, 0 to 2268347\n",
      "Data columns (total 28 columns):\n",
      "SalesOrderSlaveId              int64\n",
      "DateId                         int64\n",
      "MemberId                       object\n",
      "TradesOrderSlaveId             int64\n",
      "ShopId                         int64\n",
      "SalePageId                     int64\n",
      "TradesOrderGroupCode           object\n",
      "TrackSourceTypeDef             object\n",
      "TrackChannelTypeDef            object\n",
      "TrackDeviceTypeDef             object\n",
      "LevelOneCategoryName           object\n",
      "LevelTwoCategoryName           object\n",
      "LevelThreeCategoryName         object\n",
      "LevelFourCategoryName          object\n",
      "IsMajor                        bool\n",
      "IsGift                         bool\n",
      "Quantity                       int64\n",
      "UnitPrice                      float64\n",
      "PromotionDiscount              float64\n",
      "EcouponDiscount                float64\n",
      "SalesOrderSlaveTotalPayment    float64\n",
      "SalesOrderSlaveDateTime        object\n",
      "SalesOrderSlaveStatusDef       object\n",
      "PayProfileTypeDef              object\n",
      "ShippingProfileTypeDef         object\n",
      "EcouponId                      float64\n",
      "IsSalePageGift                 bool\n",
      "new_DateId                     datetime64[ns]\n",
      "dtypes: bool(3), datetime64[ns](1), float64(5), int64(6), object(13)\n",
      "memory usage: 439.1+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SalesOrderSlaveId</th>\n",
       "      <th>DateId</th>\n",
       "      <th>MemberId</th>\n",
       "      <th>TradesOrderSlaveId</th>\n",
       "      <th>ShopId</th>\n",
       "      <th>SalePageId</th>\n",
       "      <th>TradesOrderGroupCode</th>\n",
       "      <th>TrackSourceTypeDef</th>\n",
       "      <th>TrackChannelTypeDef</th>\n",
       "      <th>TrackDeviceTypeDef</th>\n",
       "      <th>...</th>\n",
       "      <th>PromotionDiscount</th>\n",
       "      <th>EcouponDiscount</th>\n",
       "      <th>SalesOrderSlaveTotalPayment</th>\n",
       "      <th>SalesOrderSlaveDateTime</th>\n",
       "      <th>SalesOrderSlaveStatusDef</th>\n",
       "      <th>PayProfileTypeDef</th>\n",
       "      <th>ShippingProfileTypeDef</th>\n",
       "      <th>EcouponId</th>\n",
       "      <th>IsSalePageGift</th>\n",
       "      <th>new_DateId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26914456</td>\n",
       "      <td>20170103</td>\n",
       "      <td>48D5DE26-236E-4854-8474-B0DCEAFF4F42</td>\n",
       "      <td>26971960</td>\n",
       "      <td>1317</td>\n",
       "      <td>9804</td>\n",
       "      <td>b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>374.0</td>\n",
       "      <td>2017-01-03 23:11:47.207</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>26914457</td>\n",
       "      <td>20170103</td>\n",
       "      <td>48D5DE26-236E-4854-8474-B0DCEAFF4F42</td>\n",
       "      <td>26971961</td>\n",
       "      <td>1317</td>\n",
       "      <td>9804</td>\n",
       "      <td>b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>374.0</td>\n",
       "      <td>2017-01-03 23:11:47.223</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26767644</td>\n",
       "      <td>20170101</td>\n",
       "      <td>C8B989DB-05F9-42D3-BD4F-E203482C5E58</td>\n",
       "      <td>26825136</td>\n",
       "      <td>1317</td>\n",
       "      <td>10118</td>\n",
       "      <td>b'\\x1d\\x8f}\\x12lu&gt;.&amp;\\xfc\\xbc\\xe0\\xd2\\xad\\xe5\\x...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-34.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>316.0</td>\n",
       "      <td>2017-01-01 17:21:32.113</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>26780512</td>\n",
       "      <td>20170101</td>\n",
       "      <td>C39E36F7-5091-48DA-BE8F-8CE043E009EE</td>\n",
       "      <td>26837997</td>\n",
       "      <td>1317</td>\n",
       "      <td>10036</td>\n",
       "      <td>b'&amp;QI#u)\\xf8\\xf7\\n6\\x01~\\xd1\\xf3,\\x1f\\xb8\\xe3\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-57.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>483.0</td>\n",
       "      <td>2017-01-01 21:41:58.153</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>26823950</td>\n",
       "      <td>20170102</td>\n",
       "      <td>7D87099A-B49C-4136-A8E9-F76BB5588B19</td>\n",
       "      <td>26881442</td>\n",
       "      <td>1317</td>\n",
       "      <td>10268</td>\n",
       "      <td>b'\\xfd\\x0b\\x9ee\\xdc\\xaea@\\x102;jX\\xfek\\x99m\\x1...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-44.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>2017-01-02 15:37:33.610</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   SalesOrderSlaveId    DateId                              MemberId  \\\n",
       "0           26914456  20170103  48D5DE26-236E-4854-8474-B0DCEAFF4F42   \n",
       "1           26914457  20170103  48D5DE26-236E-4854-8474-B0DCEAFF4F42   \n",
       "2           26767644  20170101  C8B989DB-05F9-42D3-BD4F-E203482C5E58   \n",
       "3           26780512  20170101  C39E36F7-5091-48DA-BE8F-8CE043E009EE   \n",
       "4           26823950  20170102  7D87099A-B49C-4136-A8E9-F76BB5588B19   \n",
       "\n",
       "   TradesOrderSlaveId  ShopId  SalePageId  \\\n",
       "0            26971960    1317        9804   \n",
       "1            26971961    1317        9804   \n",
       "2            26825136    1317       10118   \n",
       "3            26837997    1317       10036   \n",
       "4            26881442    1317       10268   \n",
       "\n",
       "                                TradesOrderGroupCode TrackSourceTypeDef  \\\n",
       "0  b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...                Web   \n",
       "1  b'q\\x14\\xa49\\xaa\\\\\\xecs\\xff6wH\\xfbXd\\x93\\xfbf\\...                Web   \n",
       "2  b'\\x1d\\x8f}\\x12lu>.&\\xfc\\xbc\\xe0\\xd2\\xad\\xe5\\x...                Web   \n",
       "3  b'&QI#u)\\xf8\\xf7\\n6\\x01~\\xd1\\xf3,\\x1f\\xb8\\xe3\\...                Web   \n",
       "4  b'\\xfd\\x0b\\x9ee\\xdc\\xaea@\\x102;jX\\xfek\\x99m\\x1...                Web   \n",
       "\n",
       "  TrackChannelTypeDef TrackDeviceTypeDef     ...     PromotionDiscount  \\\n",
       "0               Brand             Mobile     ...                 -25.0   \n",
       "1               Brand             Mobile     ...                 -25.0   \n",
       "2               Brand             Mobile     ...                 -34.0   \n",
       "3               Brand             Mobile     ...                 -57.0   \n",
       "4               Brand             Mobile     ...                 -44.0   \n",
       "\n",
       "  EcouponDiscount SalesOrderSlaveTotalPayment  SalesOrderSlaveDateTime  \\\n",
       "0             0.0                       374.0  2017-01-03 23:11:47.207   \n",
       "1             0.0                       374.0  2017-01-03 23:11:47.223   \n",
       "2             0.0                       316.0  2017-01-01 17:21:32.113   \n",
       "3             0.0                       483.0  2017-01-01 21:41:58.153   \n",
       "4             0.0                       401.0  2017-01-02 15:37:33.610   \n",
       "\n",
       "   SalesOrderSlaveStatusDef  PayProfileTypeDef  ShippingProfileTypeDef  \\\n",
       "0                    Finish        SevenEleven             SevenEleven   \n",
       "1                    Finish        SevenEleven             SevenEleven   \n",
       "2                    Finish             Family                  Family   \n",
       "3                    Finish             Family                  Family   \n",
       "4                    Finish             Family                  Family   \n",
       "\n",
       "   EcouponId  IsSalePageGift  new_DateId  \n",
       "0        NaN           False  2017-01-03  \n",
       "1        NaN           False  2017-01-03  \n",
       "2        NaN           False  2017-01-01  \n",
       "3        NaN           False  2017-01-01  \n",
       "4        NaN           False  2017-01-02  \n",
       "\n",
       "[5 rows x 28 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2.資料選取 (Slice) 與過濾 (Filter)\n",
    "2.1資料選取"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1\n",
       "1    1\n",
       "2    1\n",
       "3    1\n",
       "4    1\n",
       "Name: Quantity, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Quantity'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "SalesOrderSlaveId                                                       26780512\n",
       "DateId                                                                  20170101\n",
       "MemberId                                    C39E36F7-5091-48DA-BE8F-8CE043E009EE\n",
       "TradesOrderSlaveId                                                      26837997\n",
       "ShopId                                                                      1317\n",
       "SalePageId                                                                 10036\n",
       "TradesOrderGroupCode           b'&QI#u)\\xf8\\xf7\\n6\\x01~\\xd1\\xf3,\\x1f\\xb8\\xe3\\...\n",
       "TrackSourceTypeDef                                                           Web\n",
       "TrackChannelTypeDef                                                        Brand\n",
       "TrackDeviceTypeDef                                                        Mobile\n",
       "LevelOneCategoryName                                                      服裝、內睡衣\n",
       "LevelTwoCategoryName                                                          女裝\n",
       "LevelThreeCategoryName                                                        上衣\n",
       "LevelFourCategoryName                                                      成套衣褲組\n",
       "IsMajor                                                                     True\n",
       "IsGift                                                                     False\n",
       "Quantity                                                                       1\n",
       "UnitPrice                                                                    540\n",
       "PromotionDiscount                                                            -57\n",
       "EcouponDiscount                                                                0\n",
       "SalesOrderSlaveTotalPayment                                                  483\n",
       "SalesOrderSlaveDateTime                                  2017-01-01 21:41:58.153\n",
       "SalesOrderSlaveStatusDef                                                  Finish\n",
       "PayProfileTypeDef                                                         Family\n",
       "ShippingProfileTypeDef                                                    Family\n",
       "EcouponId                                                                    NaN\n",
       "IsSalePageGift                                                             False\n",
       "new_DateId                                                   2017-01-01 00:00:00\n",
       "Name: 3, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1000    1\n",
       "1001    1\n",
       "1002    1\n",
       "1003    1\n",
       "1004    1\n",
       "1005    1\n",
       "Name: Quantity, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[1000:1005, 'Quantity']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>new_DateId</th>\n",
       "      <th>Quantity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>2017-12-26</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003</th>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>2017-12-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1005</th>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     new_DateId  Quantity\n",
       "1000 2017-12-26         1\n",
       "1001 2017-12-28         1\n",
       "1002 2017-12-28         1\n",
       "1003 2017-12-31         1\n",
       "1004 2017-12-31         1\n",
       "1005 2018-01-04         1"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[1000:1005, ['new_DateId', 'Quantity']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2.2 資料過濾 (Filter) :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SalesOrderSlaveId</th>\n",
       "      <th>DateId</th>\n",
       "      <th>MemberId</th>\n",
       "      <th>TradesOrderSlaveId</th>\n",
       "      <th>ShopId</th>\n",
       "      <th>SalePageId</th>\n",
       "      <th>TradesOrderGroupCode</th>\n",
       "      <th>TrackSourceTypeDef</th>\n",
       "      <th>TrackChannelTypeDef</th>\n",
       "      <th>TrackDeviceTypeDef</th>\n",
       "      <th>...</th>\n",
       "      <th>PromotionDiscount</th>\n",
       "      <th>EcouponDiscount</th>\n",
       "      <th>SalesOrderSlaveTotalPayment</th>\n",
       "      <th>SalesOrderSlaveDateTime</th>\n",
       "      <th>SalesOrderSlaveStatusDef</th>\n",
       "      <th>PayProfileTypeDef</th>\n",
       "      <th>ShippingProfileTypeDef</th>\n",
       "      <th>EcouponId</th>\n",
       "      <th>IsSalePageGift</th>\n",
       "      <th>new_DateId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6863</th>\n",
       "      <td>27641010</td>\n",
       "      <td>20170115</td>\n",
       "      <td>92F342F5-C557-4FB2-9A7A-57EE93C1F7C8</td>\n",
       "      <td>27698599</td>\n",
       "      <td>1317</td>\n",
       "      <td>6736</td>\n",
       "      <td>b'U\\x90vc:\\x80\\xd1\\x0f(\\x9f\\xb3\\xdb\\x83\\xf4{\\x...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-37.0</td>\n",
       "      <td>261.0</td>\n",
       "      <td>2017-01-15 21:43:58.147</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>133.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6864</th>\n",
       "      <td>27845417</td>\n",
       "      <td>20170119</td>\n",
       "      <td>524988E2-A374-4ECA-B0C0-2093BB0D1EEB</td>\n",
       "      <td>27903045</td>\n",
       "      <td>1317</td>\n",
       "      <td>9582</td>\n",
       "      <td>b' ~\\xd0\\xdbN\\x88v\\x03\\xda%PK\\xf3,-+\\xf9~Mc'</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-26.0</td>\n",
       "      <td>274.0</td>\n",
       "      <td>2017-01-19 12:11:57.307</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>133.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6866</th>\n",
       "      <td>27746936</td>\n",
       "      <td>20170117</td>\n",
       "      <td>4197D6AB-4375-413F-86FA-2541CBB67049</td>\n",
       "      <td>27804553</td>\n",
       "      <td>1317</td>\n",
       "      <td>8677</td>\n",
       "      <td>b' \\x11\\xb9s\\x98\\x04\\xa5\\xe1^\\x13\\x03\\xd6\\xf8\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-82.0</td>\n",
       "      <td>516.0</td>\n",
       "      <td>2017-01-17 19:29:59.587</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>133.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6867</th>\n",
       "      <td>28489918</td>\n",
       "      <td>20170131</td>\n",
       "      <td>2A8C7A74-26FC-450C-A0A6-BE3547503763</td>\n",
       "      <td>28547770</td>\n",
       "      <td>1317</td>\n",
       "      <td>7151</td>\n",
       "      <td>b'\\x920\\xfe\\xca\\xdd\\x9b\\x85W\\x06v\\nNU&lt;o\\xb5\\x0...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-50.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>2017-01-31 18:29:38.380</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6868</th>\n",
       "      <td>28361104</td>\n",
       "      <td>20170129</td>\n",
       "      <td>58606276-4EE4-4637-A3CC-7E4BB4EB7E7E</td>\n",
       "      <td>28418880</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\x12N\\xa8\\xa2\\x12\\xe2|h\\xc8\\xa5\\xa4H\\xe0\\xad...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2017-01-29 02:02:48.997</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6869</th>\n",
       "      <td>28361106</td>\n",
       "      <td>20170129</td>\n",
       "      <td>58606276-4EE4-4637-A3CC-7E4BB4EB7E7E</td>\n",
       "      <td>28418882</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\x12N\\xa8\\xa2\\x12\\xe2|h\\xc8\\xa5\\xa4H\\xe0\\xad...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2017-01-29 02:02:49.030</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6870</th>\n",
       "      <td>28870964</td>\n",
       "      <td>20170207</td>\n",
       "      <td>15337531-D92B-4B9D-A5E6-0529B1899430</td>\n",
       "      <td>28928870</td>\n",
       "      <td>1317</td>\n",
       "      <td>10610</td>\n",
       "      <td>b'\\xbc\\'\\x07\"q\" |\\xa1\\xe7\\xd0\\x96R\\xfbB?\\xfca\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>575.0</td>\n",
       "      <td>2017-02-07 00:48:43.863</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>134.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6871</th>\n",
       "      <td>27901089</td>\n",
       "      <td>20170120</td>\n",
       "      <td>4A2D7D19-2D37-4DCF-93B2-D2F700EDE466</td>\n",
       "      <td>27958735</td>\n",
       "      <td>1317</td>\n",
       "      <td>9440</td>\n",
       "      <td>b'{\\r\\xc1\\xb0;\\xefM0]\\xd8Z \\x9cKP\\t\\xee\\xbe\\x83.'</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>497.0</td>\n",
       "      <td>2017-01-20 10:02:41.640</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>133.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6872</th>\n",
       "      <td>27735790</td>\n",
       "      <td>20170117</td>\n",
       "      <td>13DC2161-FBD2-4838-9D47-48FC5406B657</td>\n",
       "      <td>27793406</td>\n",
       "      <td>1317</td>\n",
       "      <td>10456</td>\n",
       "      <td>b'3\\xc8\\xd7S\\x07\\x94\\r\\xf7RY\\x01\\x02a\\xce\\xa8....</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-50.0</td>\n",
       "      <td>746.0</td>\n",
       "      <td>2017-01-17 15:04:45.450</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>128.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6873</th>\n",
       "      <td>28361105</td>\n",
       "      <td>20170129</td>\n",
       "      <td>58606276-4EE4-4637-A3CC-7E4BB4EB7E7E</td>\n",
       "      <td>28418881</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\x12N\\xa8\\xa2\\x12\\xe2|h\\xc8\\xa5\\xa4H\\xe0\\xad...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2017-01-29 02:02:49.013</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6874</th>\n",
       "      <td>28105751</td>\n",
       "      <td>20170123</td>\n",
       "      <td>D9AF9E28-506E-4BE6-91D1-24B634C99056</td>\n",
       "      <td>28163502</td>\n",
       "      <td>1317</td>\n",
       "      <td>9447</td>\n",
       "      <td>b\"\\x01\\x1f+bn\\xf42\\x16\\xd2'CmS&lt;X\\xe4\\xa8CQ \"</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-50.0</td>\n",
       "      <td>547.0</td>\n",
       "      <td>2017-01-23 20:22:45.843</td>\n",
       "      <td>Finish</td>\n",
       "      <td>CreditCardOnce</td>\n",
       "      <td>Home</td>\n",
       "      <td>128.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6875</th>\n",
       "      <td>28385676</td>\n",
       "      <td>20170129</td>\n",
       "      <td>B38D72B2-2F75-4692-9B3E-D642386EE72C</td>\n",
       "      <td>28443487</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\x9b;\\xb2\\xa1f\\x02d$\\xf9\\xa2\\xb2-\\xf7^~\\xd6\\...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2017-01-29 17:12:45.377</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6876</th>\n",
       "      <td>28385677</td>\n",
       "      <td>20170129</td>\n",
       "      <td>B38D72B2-2F75-4692-9B3E-D642386EE72C</td>\n",
       "      <td>28443488</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\x9b;\\xb2\\xa1f\\x02d$\\xf9\\xa2\\xb2-\\xf7^~\\xd6\\...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2017-01-29 17:12:45.393</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6877</th>\n",
       "      <td>28385678</td>\n",
       "      <td>20170129</td>\n",
       "      <td>B38D72B2-2F75-4692-9B3E-D642386EE72C</td>\n",
       "      <td>28443489</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\x9b;\\xb2\\xa1f\\x02d$\\xf9\\xa2\\xb2-\\xf7^~\\xd6\\...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2017-01-29 17:12:45.407</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6878</th>\n",
       "      <td>28391620</td>\n",
       "      <td>20170129</td>\n",
       "      <td>D2628A0C-18E7-4C67-9F8D-545F3555575A</td>\n",
       "      <td>28449431</td>\n",
       "      <td>1317</td>\n",
       "      <td>10376</td>\n",
       "      <td>b'\\xc5*72\\xcc8\\xbf\\x85q\\xfa\\xe3\\x06]#\\xc3\\x82\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2017-01-29 20:05:54.527</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>130.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6970</th>\n",
       "      <td>49957464</td>\n",
       "      <td>20171219</td>\n",
       "      <td>19A1CECD-5E02-4549-8600-2D0DACFC3C14</td>\n",
       "      <td>50021244</td>\n",
       "      <td>1317</td>\n",
       "      <td>16043</td>\n",
       "      <td>b'\\x18\\xb5\"*\\xb7&amp;Q\\xfc*\\x82\\x9aC\\x8ad\\xe4\\xc8\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-83.0</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>2017-12-19 02:43:33.950</td>\n",
       "      <td>WaitingToShipping</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6971</th>\n",
       "      <td>49907080</td>\n",
       "      <td>20171218</td>\n",
       "      <td>1919A1C1-1E37-434F-B183-EC3BD96538D3</td>\n",
       "      <td>49970745</td>\n",
       "      <td>1317</td>\n",
       "      <td>8653</td>\n",
       "      <td>b'F\\xd5\\x81\\x1c\\xff\\xae\\xcc\\xd07\\xe0\\xf4\\xf3\\x...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>-63.0</td>\n",
       "      <td>-56.0</td>\n",
       "      <td>511.0</td>\n",
       "      <td>2017-12-18 12:29:45.300</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6972</th>\n",
       "      <td>49481325</td>\n",
       "      <td>20171212</td>\n",
       "      <td>6536AA0C-10A0-47F2-9D4C-6075BB40B25A</td>\n",
       "      <td>49544821</td>\n",
       "      <td>1317</td>\n",
       "      <td>9905</td>\n",
       "      <td>b'\\xd6\\x8f\\x9a6\\x15\\x1dA\\xf8(2\\x83\\xa5h\\xe8\\x1...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-37.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>2017-12-12 15:41:19.600</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6986</th>\n",
       "      <td>49854636</td>\n",
       "      <td>20171217</td>\n",
       "      <td>44546A64-9816-40C6-91E7-8AC472B48E8F</td>\n",
       "      <td>49918315</td>\n",
       "      <td>1317</td>\n",
       "      <td>6194</td>\n",
       "      <td>b'\\xd1W\\x97x\\x08\\x9a\\xd9\\xc8\\xce\\xd43\\t[\\x05_\\...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-28.0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>2017-12-17 18:13:40.367</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6987</th>\n",
       "      <td>49489976</td>\n",
       "      <td>20171212</td>\n",
       "      <td>027A2E19-9D8E-487C-8D62-BBEB120B36CE</td>\n",
       "      <td>49553515</td>\n",
       "      <td>1317</td>\n",
       "      <td>7563</td>\n",
       "      <td>b':\\x16\\xa6\\x04J7H\\xc3\\xecMM\\xe9q2\\x8d\\x866\\xe...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-48.0</td>\n",
       "      <td>377.0</td>\n",
       "      <td>2017-12-12 17:38:43.173</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6988</th>\n",
       "      <td>49521062</td>\n",
       "      <td>20171212</td>\n",
       "      <td>231DEA5A-E593-4993-AC9E-625886590F53</td>\n",
       "      <td>49584707</td>\n",
       "      <td>1317</td>\n",
       "      <td>9261</td>\n",
       "      <td>b'\\x13\\xb1\\xd7\\x88\\xe3\\x8a\\xca\\x0f\\x8e\\xd2\\xe6...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-39.0</td>\n",
       "      <td>357.0</td>\n",
       "      <td>2017-12-12 22:47:59.800</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>241.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6989</th>\n",
       "      <td>49835804</td>\n",
       "      <td>20171217</td>\n",
       "      <td>B1068AA3-E8F3-4ADC-AA54-233AC4F07179</td>\n",
       "      <td>49899495</td>\n",
       "      <td>1317</td>\n",
       "      <td>15490</td>\n",
       "      <td>b'z\\xab`k\\xf9\\x8f\\xf3\\x88_\\xfc\\xf2\\xe7[\\x94\\xa...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-70.0</td>\n",
       "      <td>570.0</td>\n",
       "      <td>2017-12-17 13:08:31.367</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>219.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6990</th>\n",
       "      <td>49952979</td>\n",
       "      <td>20171219</td>\n",
       "      <td>5C255370-96E4-4D4B-BC79-DD905448683A</td>\n",
       "      <td>50016696</td>\n",
       "      <td>1317</td>\n",
       "      <td>16043</td>\n",
       "      <td>b'\\x9d\\xb7^!\\x9d\\xdc\\xcdi\\x19\\xb4\\x97\\x80\\xd1\\...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-41.0</td>\n",
       "      <td>357.0</td>\n",
       "      <td>2017-12-19 00:40:11.847</td>\n",
       "      <td>WaitingToShipping</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6991</th>\n",
       "      <td>50221348</td>\n",
       "      <td>20171223</td>\n",
       "      <td>93725D70-6D1D-41CB-BFE4-99C633A9E20E</td>\n",
       "      <td>50285193</td>\n",
       "      <td>1317</td>\n",
       "      <td>15746</td>\n",
       "      <td>b'\\xd6W\\xc8\\xb2\\x996\\xc3\\xe5\\xc0\\xdd{?(\\xdfn%1...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-75.0</td>\n",
       "      <td>825.0</td>\n",
       "      <td>2017-12-23 10:25:24.117</td>\n",
       "      <td>WaitingToShipping</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>248.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6992</th>\n",
       "      <td>50321561</td>\n",
       "      <td>20171224</td>\n",
       "      <td>F3B2025C-DA51-41A8-983A-7824620D9B6D</td>\n",
       "      <td>50385381</td>\n",
       "      <td>1317</td>\n",
       "      <td>9915</td>\n",
       "      <td>b'\\x171\\x93\\x80\\x1f\\xe5\\xf2\\\\mUL?\\xd20\\xb0+S\\x...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-48.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>2017-12-24 22:43:55.807</td>\n",
       "      <td>WaitingToShipping</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>248.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6993</th>\n",
       "      <td>49441954</td>\n",
       "      <td>20171212</td>\n",
       "      <td>4AD98F0F-5EF8-4CAC-A329-0245D4D9A5D8</td>\n",
       "      <td>49505376</td>\n",
       "      <td>1317</td>\n",
       "      <td>16043</td>\n",
       "      <td>b\"\\x8e\\xaa\\x81\\xa8\\x93\\xdc\\xa8\\xd9\\xfc9\\x0c\\xe...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-38.0</td>\n",
       "      <td>360.0</td>\n",
       "      <td>2017-12-12 04:06:18.753</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>241.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6994</th>\n",
       "      <td>49468062</td>\n",
       "      <td>20171212</td>\n",
       "      <td>1DFE84B1-5EB6-41C7-8FB9-865BA3767963</td>\n",
       "      <td>49531509</td>\n",
       "      <td>1317</td>\n",
       "      <td>9449</td>\n",
       "      <td>b'\\xa1\\xf1\\xa2\\xa7W\\xa3\\xdd7\\xe4y\\xdc\\x95\\x8a\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-27.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>2017-12-12 13:13:35.537</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7002</th>\n",
       "      <td>49603963</td>\n",
       "      <td>20171213</td>\n",
       "      <td>3E70FA5B-34B6-40E9-B380-7597012FCE40</td>\n",
       "      <td>49667630</td>\n",
       "      <td>1317</td>\n",
       "      <td>15892</td>\n",
       "      <td>b'#\\xdb\\xc8IH7g\\x82\\xf5\\x7f\\xa9S\\xd9\\x8cT\\xfa6...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-78.0</td>\n",
       "      <td>702.0</td>\n",
       "      <td>2017-12-13 22:36:45.093</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>241.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7003</th>\n",
       "      <td>50105102</td>\n",
       "      <td>20171221</td>\n",
       "      <td>FAE23F68-C4F0-4069-AE3F-239506D481B9</td>\n",
       "      <td>50168908</td>\n",
       "      <td>1317</td>\n",
       "      <td>16043</td>\n",
       "      <td>b'\\xed\\xf5\\x86`\\xb5\\xc6\\x1dEr\\xa3\\x1e\\xfd\\xb5\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-38.0</td>\n",
       "      <td>360.0</td>\n",
       "      <td>2017-12-21 10:34:47.817</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>245.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7004</th>\n",
       "      <td>50276547</td>\n",
       "      <td>20171224</td>\n",
       "      <td>7B0D533F-EFD2-4E5B-A36D-52A39EC16365</td>\n",
       "      <td>50340329</td>\n",
       "      <td>1317</td>\n",
       "      <td>9261</td>\n",
       "      <td>b'\\xb9\\x82\\xb2Ie\\x88\\xdc}[\\xabv\\xd3\\xc4\\xc6d\\x...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>2017-12-24 09:39:00.250</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>248.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262800</th>\n",
       "      <td>29211406</td>\n",
       "      <td>20170212</td>\n",
       "      <td>24169751-9853-425D-9503-D2C2BD0261F8</td>\n",
       "      <td>29269428</td>\n",
       "      <td>1317</td>\n",
       "      <td>9432</td>\n",
       "      <td>b'A\\xc9$\\xd0\\x1e\\r\\x08\\x83F\\xaf\\xb3I\\x8cq\\x08C...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-182.0</td>\n",
       "      <td>-59.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>2017-02-12 20:50:42.770</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>135.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262877</th>\n",
       "      <td>28144800</td>\n",
       "      <td>20170124</td>\n",
       "      <td>204DCB43-5A3E-46C8-BB45-00B5C4677082</td>\n",
       "      <td>28202554</td>\n",
       "      <td>1317</td>\n",
       "      <td>10291</td>\n",
       "      <td>b'$I\\xa3\\xae\\xfb\\xb5z\\xd7Z\\xd9$B\\xe8\\xb9\\xb8\\x...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-182.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>416.0</td>\n",
       "      <td>2017-01-24 14:03:57.907</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262878</th>\n",
       "      <td>28189235</td>\n",
       "      <td>20170125</td>\n",
       "      <td>4EC9EE65-CC15-4798-BB91-929582CB1836</td>\n",
       "      <td>28246999</td>\n",
       "      <td>1317</td>\n",
       "      <td>9432</td>\n",
       "      <td>b'\\x07\\xc4\\x1cd6q!\\xb4\\xc2\\xe9\\xfc\\x8b0\\xf1-\\x...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-204.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>2017-01-25 10:18:29.830</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-01-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262879</th>\n",
       "      <td>29414393</td>\n",
       "      <td>20170216</td>\n",
       "      <td>AC3377D3-451B-468E-AA1F-19E99A18EE72</td>\n",
       "      <td>29472478</td>\n",
       "      <td>1317</td>\n",
       "      <td>4874</td>\n",
       "      <td>b'\\xebjs=\\xbd\\x90\\xd2\\xf3\\xa3b\\x1d\\x9d\\x83&gt;\\xa...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-148.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>2017-02-16 11:13:20.317</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262880</th>\n",
       "      <td>29477329</td>\n",
       "      <td>20170217</td>\n",
       "      <td>1193B665-113D-4891-A094-CF5663C991AC</td>\n",
       "      <td>29535449</td>\n",
       "      <td>1317</td>\n",
       "      <td>10671</td>\n",
       "      <td>b'9\\xb9\\x1c\\xa82\\x81!\\xe0\\xa2\\x17\\xa3\\x8b\\\\!\\x...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-105.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>493.0</td>\n",
       "      <td>2017-02-17 11:56:30.340</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262885</th>\n",
       "      <td>29759556</td>\n",
       "      <td>20170221</td>\n",
       "      <td>789D71AF-62E6-436A-906E-F30BE9F5903A</td>\n",
       "      <td>29817704</td>\n",
       "      <td>1317</td>\n",
       "      <td>8630</td>\n",
       "      <td>b'\\xd8\\x0c-\\xf8?\\x18\\x15\\x81\\xe2\\xe6\\xf4u\\x18\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>-241.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>299.0</td>\n",
       "      <td>2017-02-21 23:40:23.107</td>\n",
       "      <td>Finish</td>\n",
       "      <td>CreditCardOnce</td>\n",
       "      <td>Home</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262886</th>\n",
       "      <td>29645891</td>\n",
       "      <td>20170220</td>\n",
       "      <td>ECE56DCB-3825-4FBD-8CFC-8B8D055BED9F</td>\n",
       "      <td>29704023</td>\n",
       "      <td>1317</td>\n",
       "      <td>9432</td>\n",
       "      <td>b'}4\\x06S\\xdd\\x08\\xfe\\x83\\xbe\\x8e-\\xdc\\x04\\xfe...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-182.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>2017-02-20 02:57:14.197</td>\n",
       "      <td>Finish</td>\n",
       "      <td>CreditCardOnce</td>\n",
       "      <td>Home</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262912</th>\n",
       "      <td>28570904</td>\n",
       "      <td>20170202</td>\n",
       "      <td>673340B6-8294-4A2C-ACAB-4F1B8FF34363</td>\n",
       "      <td>28628799</td>\n",
       "      <td>1317</td>\n",
       "      <td>6603</td>\n",
       "      <td>b'\\xd2C\\xc3\"\\x1c\\x8d\\x80\\x1c\\xf3?\\x96\\x91\\x10\\...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>2017-02-02 00:05:40.190</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262913</th>\n",
       "      <td>29739611</td>\n",
       "      <td>20170221</td>\n",
       "      <td>DCA07C7D-3C0D-40C2-8D9E-5C787CCE6953</td>\n",
       "      <td>29797761</td>\n",
       "      <td>1317</td>\n",
       "      <td>9432</td>\n",
       "      <td>b'\\x7f(\\x9b@\\xc2\\x8e[\\xe9]\\\\\\x7f\\xba\\xa8\\x81\\x...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-182.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>2017-02-21 19:43:45.343</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262914</th>\n",
       "      <td>28535876</td>\n",
       "      <td>20170201</td>\n",
       "      <td>A83DE5DE-9B7F-4060-A2FC-0B122B250DBA</td>\n",
       "      <td>28593771</td>\n",
       "      <td>1317</td>\n",
       "      <td>9432</td>\n",
       "      <td>b'\\xe0\\xefL\\xa0Y&lt;&gt;\\x91\\x06(\\x1e\\x0ez\\xd5e\\x9aU...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-182.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>2017-02-01 14:21:02.173</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262915</th>\n",
       "      <td>29528346</td>\n",
       "      <td>20170218</td>\n",
       "      <td>4BE46120-1D32-44D8-A81F-5767464BF53C</td>\n",
       "      <td>29586472</td>\n",
       "      <td>1317</td>\n",
       "      <td>10663</td>\n",
       "      <td>b'X\\x9a\\xba\\xd3=\\x03\\x1b=\\x97\\xaa\\x82\\xa8.R&amp;IZ...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-210.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>388.0</td>\n",
       "      <td>2017-02-18 09:44:53.697</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262918</th>\n",
       "      <td>49737947</td>\n",
       "      <td>20171215</td>\n",
       "      <td>BDB57598-6027-48A7-B5A8-E7FD795AD748</td>\n",
       "      <td>49801655</td>\n",
       "      <td>1317</td>\n",
       "      <td>9448</td>\n",
       "      <td>b'}Z?\\x15D\\xea\\xf8\\x19&amp;\\x1e.\\x08\\x0c^\\x97\\xc1\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-38.0</td>\n",
       "      <td>360.0</td>\n",
       "      <td>2017-12-15 22:33:09.553</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>244.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2262919</th>\n",
       "      <td>29758761</td>\n",
       "      <td>20170221</td>\n",
       "      <td>42D47847-5BAE-4374-84DD-C45BE4367314</td>\n",
       "      <td>29816916</td>\n",
       "      <td>1317</td>\n",
       "      <td>4870</td>\n",
       "      <td>b'c\\xfa\\xd0`\\xeb\\xe6\\xd3\\xc8\\xe6r\\x9c\\x9ag\\xf8...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-148.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>250.0</td>\n",
       "      <td>2017-02-21 23:30:24.157</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2263549</th>\n",
       "      <td>50695530</td>\n",
       "      <td>20171230</td>\n",
       "      <td>20899564-205B-4EB3-901C-5B9791F9E513</td>\n",
       "      <td>50759269</td>\n",
       "      <td>1317</td>\n",
       "      <td>11231</td>\n",
       "      <td>b'|\\xbb\\xc3v5\\xa6W{\\x88^\\x11\\x18~\\t\\xc8\\xfa\\xd...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>-183.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>215.0</td>\n",
       "      <td>2017-12-30 17:46:07.183</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2263552</th>\n",
       "      <td>50695961</td>\n",
       "      <td>20171230</td>\n",
       "      <td>8862C13E-1951-4BF1-979A-8F2742EBE778</td>\n",
       "      <td>50759699</td>\n",
       "      <td>1317</td>\n",
       "      <td>8263</td>\n",
       "      <td>b'e%\\xc4\\xa5\\x00\\xb7\\xf1\\xfb\\x1a\\xb5s\\x83\\xe6:...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>2017-12-30 17:54:40.837</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2263679</th>\n",
       "      <td>50025364</td>\n",
       "      <td>20171220</td>\n",
       "      <td>50492D13-C61F-4A20-ADB6-9BFEDCF6992F</td>\n",
       "      <td>50089248</td>\n",
       "      <td>1317</td>\n",
       "      <td>16260</td>\n",
       "      <td>b'z\\x8f\\xde\\xdd}\\xb8\\x1e%\\xf2\\x1aT)\\n\\xb5\\xeeZ...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td>2017-12-20 01:35:15.543</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2263682</th>\n",
       "      <td>50025372</td>\n",
       "      <td>20171220</td>\n",
       "      <td>50492D13-C61F-4A20-ADB6-9BFEDCF6992F</td>\n",
       "      <td>50089256</td>\n",
       "      <td>1317</td>\n",
       "      <td>9874</td>\n",
       "      <td>b'z\\x8f\\xde\\xdd}\\xb8\\x1e%\\xf2\\x1aT)\\n\\xb5\\xeeZ...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-103.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>977.0</td>\n",
       "      <td>2017-12-20 01:35:15.660</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2263684</th>\n",
       "      <td>50025376</td>\n",
       "      <td>20171220</td>\n",
       "      <td>50492D13-C61F-4A20-ADB6-9BFEDCF6992F</td>\n",
       "      <td>50089260</td>\n",
       "      <td>1317</td>\n",
       "      <td>9117</td>\n",
       "      <td>b'z\\x8f\\xde\\xdd}\\xb8\\x1e%\\xf2\\x1aT)\\n\\xb5\\xeeZ...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-38.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>360.0</td>\n",
       "      <td>2017-12-20 01:35:15.720</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2264789</th>\n",
       "      <td>31998564</td>\n",
       "      <td>20170329</td>\n",
       "      <td>71CE5E2E-9323-4A46-814A-8BBA19F2E86E</td>\n",
       "      <td>32057146</td>\n",
       "      <td>1317</td>\n",
       "      <td>1435</td>\n",
       "      <td>b'h\\xbd\\x06\\xe6\\x04\\x88Q\\xc6\\xdf*\\x9d\\x97\\xe3\\...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-171.0</td>\n",
       "      <td>-11.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>2017-03-29 17:54:18.287</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>136.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-03-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2267624</th>\n",
       "      <td>50565206</td>\n",
       "      <td>20171228</td>\n",
       "      <td>54259047-F597-4FDC-8D82-0E9D7DD0F794</td>\n",
       "      <td>50629007</td>\n",
       "      <td>1317</td>\n",
       "      <td>9105</td>\n",
       "      <td>b'\\xd9\\xb2\\x94\\xab|L\\xabD\\xc1\\xdfQ\\x94\\\\\\x90\\x...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-60.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>338.0</td>\n",
       "      <td>2017-12-28 18:05:55.953</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2267941</th>\n",
       "      <td>49881042</td>\n",
       "      <td>20171217</td>\n",
       "      <td>911057C0-B39D-4587-A110-E93B8FCF04E8</td>\n",
       "      <td>49944734</td>\n",
       "      <td>1317</td>\n",
       "      <td>15875</td>\n",
       "      <td>b'\\x80;X\\xd9\\t\\xb5c\\xfc]T\\xecFVfa\\xf4\\xbf^c:'</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>-36.0</td>\n",
       "      <td>343.0</td>\n",
       "      <td>2017-12-17 23:25:31.483</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>241.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268017</th>\n",
       "      <td>50734862</td>\n",
       "      <td>20171231</td>\n",
       "      <td>D28A4B9E-39A3-4D3D-9BA5-B71BFFD0A12C</td>\n",
       "      <td>50798599</td>\n",
       "      <td>1317</td>\n",
       "      <td>6736</td>\n",
       "      <td>b'R\\xca\\xef\\x1d\\x96t\\x12x\\xe6\\xfc^At\\xaf\\x03cZ...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-214.0</td>\n",
       "      <td>-34.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>2017-12-31 07:58:57.703</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>219.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268042</th>\n",
       "      <td>50756074</td>\n",
       "      <td>20171231</td>\n",
       "      <td>5C50396C-FE1A-493C-82B3-88A49A0F6D17</td>\n",
       "      <td>50819804</td>\n",
       "      <td>1317</td>\n",
       "      <td>2</td>\n",
       "      <td>b'\\xe7\\x98\\xec\\xf3\\xba\\x99\\xb2\\x0e\\xc1d\\x8dl\\x...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-92.0</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>290.0</td>\n",
       "      <td>2017-12-31 14:19:20.973</td>\n",
       "      <td>Finish</td>\n",
       "      <td>CreditCardOnce</td>\n",
       "      <td>Home</td>\n",
       "      <td>219.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268063</th>\n",
       "      <td>50037168</td>\n",
       "      <td>20171220</td>\n",
       "      <td>8895899B-88C8-409F-93A6-3980DAFE73C4</td>\n",
       "      <td>50100983</td>\n",
       "      <td>1317</td>\n",
       "      <td>15986</td>\n",
       "      <td>b'O[\\x8by\\xf6\\x8c\\x01\\x13J\\xbb+\\x90\\xc8\\x97\\xc...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>2017-12-20 10:16:32.810</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268097</th>\n",
       "      <td>50246597</td>\n",
       "      <td>20171223</td>\n",
       "      <td>76F1F770-EAC0-4FE4-8D29-8D56EE92602C</td>\n",
       "      <td>50310404</td>\n",
       "      <td>1317</td>\n",
       "      <td>8076</td>\n",
       "      <td>b\"\\x0eQ\\xa8)\\xc3\\xb7\\x1b{1J:'\\x86vNj\\xeb+\\xf5m\"</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-53.0</td>\n",
       "      <td>-40.0</td>\n",
       "      <td>305.0</td>\n",
       "      <td>2017-12-23 19:35:22.810</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>245.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268147</th>\n",
       "      <td>50773380</td>\n",
       "      <td>20171231</td>\n",
       "      <td>BAECFBF0-3A43-43DF-90BA-3FB618729050</td>\n",
       "      <td>50837113</td>\n",
       "      <td>1317</td>\n",
       "      <td>13525</td>\n",
       "      <td>b'\\xa6(\\xd4\\xd8\\x00\\x16\\xe5.C\\x90\\x1f;\\xea\\x9f...</td>\n",
       "      <td>AndroidApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-60.0</td>\n",
       "      <td>-101.0</td>\n",
       "      <td>237.0</td>\n",
       "      <td>2017-12-31 19:40:09.627</td>\n",
       "      <td>Finish</td>\n",
       "      <td>Family</td>\n",
       "      <td>Family</td>\n",
       "      <td>219.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268158</th>\n",
       "      <td>49648355</td>\n",
       "      <td>20171214</td>\n",
       "      <td>237E3AC3-1DD5-4DB5-898E-909B0DE1E3B3</td>\n",
       "      <td>49712057</td>\n",
       "      <td>1317</td>\n",
       "      <td>10225</td>\n",
       "      <td>b'\\xf5\\x9eIk\\x98\\xc2\\x0f\\x18Z\\xb5\\xee\\xf9\\xfd\\...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-68.0</td>\n",
       "      <td>-18.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>2017-12-14 14:52:15.590</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268164</th>\n",
       "      <td>49651124</td>\n",
       "      <td>20171214</td>\n",
       "      <td>F11B4D2C-0E2C-44FC-BDA4-98CA49C2146F</td>\n",
       "      <td>49714825</td>\n",
       "      <td>1317</td>\n",
       "      <td>8263</td>\n",
       "      <td>b'\\x91\\xaf\\xb7\\x921\\x19#\\x9d\\xe6d`S\\xa4\\xd2\\xc...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>-27.0</td>\n",
       "      <td>352.0</td>\n",
       "      <td>2017-12-14 15:38:32.007</td>\n",
       "      <td>Cancel</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>242.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268174</th>\n",
       "      <td>49658742</td>\n",
       "      <td>20171214</td>\n",
       "      <td>A477B2F9-AFBC-4856-9769-6D89E23B3BE1</td>\n",
       "      <td>49722425</td>\n",
       "      <td>1317</td>\n",
       "      <td>15871</td>\n",
       "      <td>b\"\\xef\\xae\\xe5!Z\\xe6}\\x180\\x13\\xcf\\x88Vv\\x91\\x...</td>\n",
       "      <td>iOSApp</td>\n",
       "      <td>Brand</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>...</td>\n",
       "      <td>-25.0</td>\n",
       "      <td>-43.0</td>\n",
       "      <td>452.0</td>\n",
       "      <td>2017-12-14 18:16:03.127</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>241.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2268288</th>\n",
       "      <td>50054322</td>\n",
       "      <td>20171220</td>\n",
       "      <td>F7D11BA0-AF9E-42D4-95B2-31CFC51C1404</td>\n",
       "      <td>50118134</td>\n",
       "      <td>1317</td>\n",
       "      <td>11231</td>\n",
       "      <td>b'\\xbd\\x06\\x81\\xf5\\x0b\\x14G\\xa7\\x90\\x19j\\xf8\\r...</td>\n",
       "      <td>Web</td>\n",
       "      <td>Brand</td>\n",
       "      <td>PC</td>\n",
       "      <td>...</td>\n",
       "      <td>-148.0</td>\n",
       "      <td>-32.0</td>\n",
       "      <td>218.0</td>\n",
       "      <td>2017-12-20 15:23:31.980</td>\n",
       "      <td>Finish</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>SevenEleven</td>\n",
       "      <td>221.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2017-12-20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37899 rows × 28 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         SalesOrderSlaveId    DateId                              MemberId  \\\n",
       "6863              27641010  20170115  92F342F5-C557-4FB2-9A7A-57EE93C1F7C8   \n",
       "6864              27845417  20170119  524988E2-A374-4ECA-B0C0-2093BB0D1EEB   \n",
       "6866              27746936  20170117  4197D6AB-4375-413F-86FA-2541CBB67049   \n",
       "6867              28489918  20170131  2A8C7A74-26FC-450C-A0A6-BE3547503763   \n",
       "6868              28361104  20170129  58606276-4EE4-4637-A3CC-7E4BB4EB7E7E   \n",
       "6869              28361106  20170129  58606276-4EE4-4637-A3CC-7E4BB4EB7E7E   \n",
       "6870              28870964  20170207  15337531-D92B-4B9D-A5E6-0529B1899430   \n",
       "6871              27901089  20170120  4A2D7D19-2D37-4DCF-93B2-D2F700EDE466   \n",
       "6872              27735790  20170117  13DC2161-FBD2-4838-9D47-48FC5406B657   \n",
       "6873              28361105  20170129  58606276-4EE4-4637-A3CC-7E4BB4EB7E7E   \n",
       "6874              28105751  20170123  D9AF9E28-506E-4BE6-91D1-24B634C99056   \n",
       "6875              28385676  20170129  B38D72B2-2F75-4692-9B3E-D642386EE72C   \n",
       "6876              28385677  20170129  B38D72B2-2F75-4692-9B3E-D642386EE72C   \n",
       "6877              28385678  20170129  B38D72B2-2F75-4692-9B3E-D642386EE72C   \n",
       "6878              28391620  20170129  D2628A0C-18E7-4C67-9F8D-545F3555575A   \n",
       "6970              49957464  20171219  19A1CECD-5E02-4549-8600-2D0DACFC3C14   \n",
       "6971              49907080  20171218  1919A1C1-1E37-434F-B183-EC3BD96538D3   \n",
       "6972              49481325  20171212  6536AA0C-10A0-47F2-9D4C-6075BB40B25A   \n",
       "6986              49854636  20171217  44546A64-9816-40C6-91E7-8AC472B48E8F   \n",
       "6987              49489976  20171212  027A2E19-9D8E-487C-8D62-BBEB120B36CE   \n",
       "6988              49521062  20171212  231DEA5A-E593-4993-AC9E-625886590F53   \n",
       "6989              49835804  20171217  B1068AA3-E8F3-4ADC-AA54-233AC4F07179   \n",
       "6990              49952979  20171219  5C255370-96E4-4D4B-BC79-DD905448683A   \n",
       "6991              50221348  20171223  93725D70-6D1D-41CB-BFE4-99C633A9E20E   \n",
       "6992              50321561  20171224  F3B2025C-DA51-41A8-983A-7824620D9B6D   \n",
       "6993              49441954  20171212  4AD98F0F-5EF8-4CAC-A329-0245D4D9A5D8   \n",
       "6994              49468062  20171212  1DFE84B1-5EB6-41C7-8FB9-865BA3767963   \n",
       "7002              49603963  20171213  3E70FA5B-34B6-40E9-B380-7597012FCE40   \n",
       "7003              50105102  20171221  FAE23F68-C4F0-4069-AE3F-239506D481B9   \n",
       "7004              50276547  20171224  7B0D533F-EFD2-4E5B-A36D-52A39EC16365   \n",
       "...                    ...       ...                                   ...   \n",
       "2262800           29211406  20170212  24169751-9853-425D-9503-D2C2BD0261F8   \n",
       "2262877           28144800  20170124  204DCB43-5A3E-46C8-BB45-00B5C4677082   \n",
       "2262878           28189235  20170125  4EC9EE65-CC15-4798-BB91-929582CB1836   \n",
       "2262879           29414393  20170216  AC3377D3-451B-468E-AA1F-19E99A18EE72   \n",
       "2262880           29477329  20170217  1193B665-113D-4891-A094-CF5663C991AC   \n",
       "2262885           29759556  20170221  789D71AF-62E6-436A-906E-F30BE9F5903A   \n",
       "2262886           29645891  20170220  ECE56DCB-3825-4FBD-8CFC-8B8D055BED9F   \n",
       "2262912           28570904  20170202  673340B6-8294-4A2C-ACAB-4F1B8FF34363   \n",
       "2262913           29739611  20170221  DCA07C7D-3C0D-40C2-8D9E-5C787CCE6953   \n",
       "2262914           28535876  20170201  A83DE5DE-9B7F-4060-A2FC-0B122B250DBA   \n",
       "2262915           29528346  20170218  4BE46120-1D32-44D8-A81F-5767464BF53C   \n",
       "2262918           49737947  20171215  BDB57598-6027-48A7-B5A8-E7FD795AD748   \n",
       "2262919           29758761  20170221  42D47847-5BAE-4374-84DD-C45BE4367314   \n",
       "2263549           50695530  20171230  20899564-205B-4EB3-901C-5B9791F9E513   \n",
       "2263552           50695961  20171230  8862C13E-1951-4BF1-979A-8F2742EBE778   \n",
       "2263679           50025364  20171220  50492D13-C61F-4A20-ADB6-9BFEDCF6992F   \n",
       "2263682           50025372  20171220  50492D13-C61F-4A20-ADB6-9BFEDCF6992F   \n",
       "2263684           50025376  20171220  50492D13-C61F-4A20-ADB6-9BFEDCF6992F   \n",
       "2264789           31998564  20170329  71CE5E2E-9323-4A46-814A-8BBA19F2E86E   \n",
       "2267624           50565206  20171228  54259047-F597-4FDC-8D82-0E9D7DD0F794   \n",
       "2267941           49881042  20171217  911057C0-B39D-4587-A110-E93B8FCF04E8   \n",
       "2268017           50734862  20171231  D28A4B9E-39A3-4D3D-9BA5-B71BFFD0A12C   \n",
       "2268042           50756074  20171231  5C50396C-FE1A-493C-82B3-88A49A0F6D17   \n",
       "2268063           50037168  20171220  8895899B-88C8-409F-93A6-3980DAFE73C4   \n",
       "2268097           50246597  20171223  76F1F770-EAC0-4FE4-8D29-8D56EE92602C   \n",
       "2268147           50773380  20171231  BAECFBF0-3A43-43DF-90BA-3FB618729050   \n",
       "2268158           49648355  20171214  237E3AC3-1DD5-4DB5-898E-909B0DE1E3B3   \n",
       "2268164           49651124  20171214  F11B4D2C-0E2C-44FC-BDA4-98CA49C2146F   \n",
       "2268174           49658742  20171214  A477B2F9-AFBC-4856-9769-6D89E23B3BE1   \n",
       "2268288           50054322  20171220  F7D11BA0-AF9E-42D4-95B2-31CFC51C1404   \n",
       "\n",
       "         TradesOrderSlaveId  ShopId  SalePageId  \\\n",
       "6863               27698599    1317        6736   \n",
       "6864               27903045    1317        9582   \n",
       "6866               27804553    1317        8677   \n",
       "6867               28547770    1317        7151   \n",
       "6868               28418880    1317       10376   \n",
       "6869               28418882    1317       10376   \n",
       "6870               28928870    1317       10610   \n",
       "6871               27958735    1317        9440   \n",
       "6872               27793406    1317       10456   \n",
       "6873               28418881    1317       10376   \n",
       "6874               28163502    1317        9447   \n",
       "6875               28443487    1317       10376   \n",
       "6876               28443488    1317       10376   \n",
       "6877               28443489    1317       10376   \n",
       "6878               28449431    1317       10376   \n",
       "6970               50021244    1317       16043   \n",
       "6971               49970745    1317        8653   \n",
       "6972               49544821    1317        9905   \n",
       "6986               49918315    1317        6194   \n",
       "6987               49553515    1317        7563   \n",
       "6988               49584707    1317        9261   \n",
       "6989               49899495    1317       15490   \n",
       "6990               50016696    1317       16043   \n",
       "6991               50285193    1317       15746   \n",
       "6992               50385381    1317        9915   \n",
       "6993               49505376    1317       16043   \n",
       "6994               49531509    1317        9449   \n",
       "7002               49667630    1317       15892   \n",
       "7003               50168908    1317       16043   \n",
       "7004               50340329    1317        9261   \n",
       "...                     ...     ...         ...   \n",
       "2262800            29269428    1317        9432   \n",
       "2262877            28202554    1317       10291   \n",
       "2262878            28246999    1317        9432   \n",
       "2262879            29472478    1317        4874   \n",
       "2262880            29535449    1317       10671   \n",
       "2262885            29817704    1317        8630   \n",
       "2262886            29704023    1317        9432   \n",
       "2262912            28628799    1317        6603   \n",
       "2262913            29797761    1317        9432   \n",
       "2262914            28593771    1317        9432   \n",
       "2262915            29586472    1317       10663   \n",
       "2262918            49801655    1317        9448   \n",
       "2262919            29816916    1317        4870   \n",
       "2263549            50759269    1317       11231   \n",
       "2263552            50759699    1317        8263   \n",
       "2263679            50089248    1317       16260   \n",
       "2263682            50089256    1317        9874   \n",
       "2263684            50089260    1317        9117   \n",
       "2264789            32057146    1317        1435   \n",
       "2267624            50629007    1317        9105   \n",
       "2267941            49944734    1317       15875   \n",
       "2268017            50798599    1317        6736   \n",
       "2268042            50819804    1317           2   \n",
       "2268063            50100983    1317       15986   \n",
       "2268097            50310404    1317        8076   \n",
       "2268147            50837113    1317       13525   \n",
       "2268158            49712057    1317       10225   \n",
       "2268164            49714825    1317        8263   \n",
       "2268174            49722425    1317       15871   \n",
       "2268288            50118134    1317       11231   \n",
       "\n",
       "                                      TradesOrderGroupCode TrackSourceTypeDef  \\\n",
       "6863     b'U\\x90vc:\\x80\\xd1\\x0f(\\x9f\\xb3\\xdb\\x83\\xf4{\\x...             iOSApp   \n",
       "6864          b' ~\\xd0\\xdbN\\x88v\\x03\\xda%PK\\xf3,-+\\xf9~Mc'             iOSApp   \n",
       "6866     b' \\x11\\xb9s\\x98\\x04\\xa5\\xe1^\\x13\\x03\\xd6\\xf8\\...                Web   \n",
       "6867     b'\\x920\\xfe\\xca\\xdd\\x9b\\x85W\\x06v\\nNU<o\\xb5\\x0...                Web   \n",
       "6868     b'\\x12N\\xa8\\xa2\\x12\\xe2|h\\xc8\\xa5\\xa4H\\xe0\\xad...                Web   \n",
       "6869     b'\\x12N\\xa8\\xa2\\x12\\xe2|h\\xc8\\xa5\\xa4H\\xe0\\xad...                Web   \n",
       "6870     b'\\xbc\\'\\x07\"q\" |\\xa1\\xe7\\xd0\\x96R\\xfbB?\\xfca\\...                Web   \n",
       "6871     b'{\\r\\xc1\\xb0;\\xefM0]\\xd8Z \\x9cKP\\t\\xee\\xbe\\x83.'         AndroidApp   \n",
       "6872     b'3\\xc8\\xd7S\\x07\\x94\\r\\xf7RY\\x01\\x02a\\xce\\xa8....         AndroidApp   \n",
       "6873     b'\\x12N\\xa8\\xa2\\x12\\xe2|h\\xc8\\xa5\\xa4H\\xe0\\xad...                Web   \n",
       "6874          b\"\\x01\\x1f+bn\\xf42\\x16\\xd2'CmS<X\\xe4\\xa8CQ \"         AndroidApp   \n",
       "6875     b'\\x9b;\\xb2\\xa1f\\x02d$\\xf9\\xa2\\xb2-\\xf7^~\\xd6\\...             iOSApp   \n",
       "6876     b'\\x9b;\\xb2\\xa1f\\x02d$\\xf9\\xa2\\xb2-\\xf7^~\\xd6\\...             iOSApp   \n",
       "6877     b'\\x9b;\\xb2\\xa1f\\x02d$\\xf9\\xa2\\xb2-\\xf7^~\\xd6\\...             iOSApp   \n",
       "6878     b'\\xc5*72\\xcc8\\xbf\\x85q\\xfa\\xe3\\x06]#\\xc3\\x82\\...                Web   \n",
       "6970     b'\\x18\\xb5\"*\\xb7&Q\\xfc*\\x82\\x9aC\\x8ad\\xe4\\xc8\\...                Web   \n",
       "6971     b'F\\xd5\\x81\\x1c\\xff\\xae\\xcc\\xd07\\xe0\\xf4\\xf3\\x...                Web   \n",
       "6972     b'\\xd6\\x8f\\x9a6\\x15\\x1dA\\xf8(2\\x83\\xa5h\\xe8\\x1...                Web   \n",
       "6986     b'\\xd1W\\x97x\\x08\\x9a\\xd9\\xc8\\xce\\xd43\\t[\\x05_\\...         AndroidApp   \n",
       "6987     b':\\x16\\xa6\\x04J7H\\xc3\\xecMM\\xe9q2\\x8d\\x866\\xe...             iOSApp   \n",
       "6988     b'\\x13\\xb1\\xd7\\x88\\xe3\\x8a\\xca\\x0f\\x8e\\xd2\\xe6...         AndroidApp   \n",
       "6989     b'z\\xab`k\\xf9\\x8f\\xf3\\x88_\\xfc\\xf2\\xe7[\\x94\\xa...         AndroidApp   \n",
       "6990     b'\\x9d\\xb7^!\\x9d\\xdc\\xcdi\\x19\\xb4\\x97\\x80\\xd1\\...         AndroidApp   \n",
       "6991     b'\\xd6W\\xc8\\xb2\\x996\\xc3\\xe5\\xc0\\xdd{?(\\xdfn%1...         AndroidApp   \n",
       "6992     b'\\x171\\x93\\x80\\x1f\\xe5\\xf2\\\\mUL?\\xd20\\xb0+S\\x...             iOSApp   \n",
       "6993     b\"\\x8e\\xaa\\x81\\xa8\\x93\\xdc\\xa8\\xd9\\xfc9\\x0c\\xe...                Web   \n",
       "6994     b'\\xa1\\xf1\\xa2\\xa7W\\xa3\\xdd7\\xe4y\\xdc\\x95\\x8a\\...                Web   \n",
       "7002     b'#\\xdb\\xc8IH7g\\x82\\xf5\\x7f\\xa9S\\xd9\\x8cT\\xfa6...                Web   \n",
       "7003     b'\\xed\\xf5\\x86`\\xb5\\xc6\\x1dEr\\xa3\\x1e\\xfd\\xb5\\...                Web   \n",
       "7004     b'\\xb9\\x82\\xb2Ie\\x88\\xdc}[\\xabv\\xd3\\xc4\\xc6d\\x...             iOSApp   \n",
       "...                                                    ...                ...   \n",
       "2262800  b'A\\xc9$\\xd0\\x1e\\r\\x08\\x83F\\xaf\\xb3I\\x8cq\\x08C...                Web   \n",
       "2262877  b'$I\\xa3\\xae\\xfb\\xb5z\\xd7Z\\xd9$B\\xe8\\xb9\\xb8\\x...         AndroidApp   \n",
       "2262878  b'\\x07\\xc4\\x1cd6q!\\xb4\\xc2\\xe9\\xfc\\x8b0\\xf1-\\x...         AndroidApp   \n",
       "2262879  b'\\xebjs=\\xbd\\x90\\xd2\\xf3\\xa3b\\x1d\\x9d\\x83>\\xa...             iOSApp   \n",
       "2262880  b'9\\xb9\\x1c\\xa82\\x81!\\xe0\\xa2\\x17\\xa3\\x8b\\\\!\\x...             iOSApp   \n",
       "2262885  b'\\xd8\\x0c-\\xf8?\\x18\\x15\\x81\\xe2\\xe6\\xf4u\\x18\\...                Web   \n",
       "2262886  b'}4\\x06S\\xdd\\x08\\xfe\\x83\\xbe\\x8e-\\xdc\\x04\\xfe...                Web   \n",
       "2262912  b'\\xd2C\\xc3\"\\x1c\\x8d\\x80\\x1c\\xf3?\\x96\\x91\\x10\\...         AndroidApp   \n",
       "2262913  b'\\x7f(\\x9b@\\xc2\\x8e[\\xe9]\\\\\\x7f\\xba\\xa8\\x81\\x...         AndroidApp   \n",
       "2262914  b'\\xe0\\xefL\\xa0Y<>\\x91\\x06(\\x1e\\x0ez\\xd5e\\x9aU...             iOSApp   \n",
       "2262915  b'X\\x9a\\xba\\xd3=\\x03\\x1b=\\x97\\xaa\\x82\\xa8.R&IZ...             iOSApp   \n",
       "2262918  b'}Z?\\x15D\\xea\\xf8\\x19&\\x1e.\\x08\\x0c^\\x97\\xc1\\...                Web   \n",
       "2262919  b'c\\xfa\\xd0`\\xeb\\xe6\\xd3\\xc8\\xe6r\\x9c\\x9ag\\xf8...             iOSApp   \n",
       "2263549  b'|\\xbb\\xc3v5\\xa6W{\\x88^\\x11\\x18~\\t\\xc8\\xfa\\xd...                Web   \n",
       "2263552  b'e%\\xc4\\xa5\\x00\\xb7\\xf1\\xfb\\x1a\\xb5s\\x83\\xe6:...         AndroidApp   \n",
       "2263679  b'z\\x8f\\xde\\xdd}\\xb8\\x1e%\\xf2\\x1aT)\\n\\xb5\\xeeZ...             iOSApp   \n",
       "2263682  b'z\\x8f\\xde\\xdd}\\xb8\\x1e%\\xf2\\x1aT)\\n\\xb5\\xeeZ...             iOSApp   \n",
       "2263684  b'z\\x8f\\xde\\xdd}\\xb8\\x1e%\\xf2\\x1aT)\\n\\xb5\\xeeZ...             iOSApp   \n",
       "2264789  b'h\\xbd\\x06\\xe6\\x04\\x88Q\\xc6\\xdf*\\x9d\\x97\\xe3\\...             iOSApp   \n",
       "2267624  b'\\xd9\\xb2\\x94\\xab|L\\xabD\\xc1\\xdfQ\\x94\\\\\\x90\\x...                Web   \n",
       "2267941      b'\\x80;X\\xd9\\t\\xb5c\\xfc]T\\xecFVfa\\xf4\\xbf^c:'         AndroidApp   \n",
       "2268017  b'R\\xca\\xef\\x1d\\x96t\\x12x\\xe6\\xfc^At\\xaf\\x03cZ...             iOSApp   \n",
       "2268042  b'\\xe7\\x98\\xec\\xf3\\xba\\x99\\xb2\\x0e\\xc1d\\x8dl\\x...         AndroidApp   \n",
       "2268063  b'O[\\x8by\\xf6\\x8c\\x01\\x13J\\xbb+\\x90\\xc8\\x97\\xc...                Web   \n",
       "2268097    b\"\\x0eQ\\xa8)\\xc3\\xb7\\x1b{1J:'\\x86vNj\\xeb+\\xf5m\"         AndroidApp   \n",
       "2268147  b'\\xa6(\\xd4\\xd8\\x00\\x16\\xe5.C\\x90\\x1f;\\xea\\x9f...         AndroidApp   \n",
       "2268158  b'\\xf5\\x9eIk\\x98\\xc2\\x0f\\x18Z\\xb5\\xee\\xf9\\xfd\\...                Web   \n",
       "2268164  b'\\x91\\xaf\\xb7\\x921\\x19#\\x9d\\xe6d`S\\xa4\\xd2\\xc...                Web   \n",
       "2268174  b\"\\xef\\xae\\xe5!Z\\xe6}\\x180\\x13\\xcf\\x88Vv\\x91\\x...             iOSApp   \n",
       "2268288  b'\\xbd\\x06\\x81\\xf5\\x0b\\x14G\\xa7\\x90\\x19j\\xf8\\r...                Web   \n",
       "\n",
       "        TrackChannelTypeDef TrackDeviceTypeDef     ...     PromotionDiscount  \\\n",
       "6863                  Brand             Mobile     ...                   0.0   \n",
       "6864                  Brand             Mobile     ...                   0.0   \n",
       "6866                  Brand             Mobile     ...                   0.0   \n",
       "6867                  Brand             Mobile     ...                   0.0   \n",
       "6868                  Brand             Mobile     ...                   0.0   \n",
       "6869                  Brand             Mobile     ...                   0.0   \n",
       "6870                  Brand                 PC     ...                   0.0   \n",
       "6871                  Brand             Mobile     ...                   0.0   \n",
       "6872                  Brand             Mobile     ...                   0.0   \n",
       "6873                  Brand             Mobile     ...                   0.0   \n",
       "6874                  Brand             Mobile     ...                   0.0   \n",
       "6875                  Brand             Mobile     ...                   0.0   \n",
       "6876                  Brand             Mobile     ...                   0.0   \n",
       "6877                  Brand             Mobile     ...                   0.0   \n",
       "6878                  Brand             Mobile     ...                   0.0   \n",
       "6970                  Brand             Mobile     ...                 -83.0   \n",
       "6971                  Brand                 PC     ...                 -63.0   \n",
       "6972                  Brand             Mobile     ...                   0.0   \n",
       "6986                  Brand             Mobile     ...                   0.0   \n",
       "6987                  Brand             Mobile     ...                   0.0   \n",
       "6988                  Brand             Mobile     ...                   0.0   \n",
       "6989                  Brand             Mobile     ...                   0.0   \n",
       "6990                  Brand             Mobile     ...                   0.0   \n",
       "6991                  Brand             Mobile     ...                   0.0   \n",
       "6992                  Brand             Mobile     ...                   0.0   \n",
       "6993                  Brand             Mobile     ...                   0.0   \n",
       "6994                  Brand             Mobile     ...                   0.0   \n",
       "7002                  Brand             Mobile     ...                   0.0   \n",
       "7003                  Brand             Mobile     ...                   0.0   \n",
       "7004                  Brand             Mobile     ...                   0.0   \n",
       "...                     ...                ...     ...                   ...   \n",
       "2262800               Brand             Mobile     ...                -182.0   \n",
       "2262877               Brand             Mobile     ...                -182.0   \n",
       "2262878               Brand             Mobile     ...                -204.0   \n",
       "2262879               Brand             Mobile     ...                -148.0   \n",
       "2262880               Brand             Mobile     ...                -105.0   \n",
       "2262885               Brand                 PC     ...                -241.0   \n",
       "2262886               Brand             Mobile     ...                -182.0   \n",
       "2262912               Brand             Mobile     ...                 -18.0   \n",
       "2262913               Brand             Mobile     ...                -182.0   \n",
       "2262914               Brand             Mobile     ...                -182.0   \n",
       "2262915               Brand             Mobile     ...                -210.0   \n",
       "2262918               Brand             Mobile     ...                   0.0   \n",
       "2262919               Brand             Mobile     ...                -148.0   \n",
       "2263549               Brand                 PC     ...                -183.0   \n",
       "2263552               Brand             Mobile     ...                 -60.0   \n",
       "2263679               Brand             Mobile     ...                 -25.0   \n",
       "2263682               Brand             Mobile     ...                -103.0   \n",
       "2263684               Brand             Mobile     ...                 -38.0   \n",
       "2264789               Brand             Mobile     ...                -171.0   \n",
       "2267624               Brand             Mobile     ...                 -60.0   \n",
       "2267941               Brand             Mobile     ...                 -19.0   \n",
       "2268017               Brand             Mobile     ...                -214.0   \n",
       "2268042               Brand             Mobile     ...                 -92.0   \n",
       "2268063               Brand             Mobile     ...                   0.0   \n",
       "2268097               Brand             Mobile     ...                 -53.0   \n",
       "2268147               Brand             Mobile     ...                 -60.0   \n",
       "2268158               Brand             Mobile     ...                 -68.0   \n",
       "2268164               Brand             Mobile     ...                 -19.0   \n",
       "2268174               Brand             Mobile     ...                 -25.0   \n",
       "2268288               Brand                 PC     ...                -148.0   \n",
       "\n",
       "        EcouponDiscount SalesOrderSlaveTotalPayment  SalesOrderSlaveDateTime  \\\n",
       "6863              -37.0                       261.0  2017-01-15 21:43:58.147   \n",
       "6864              -26.0                       274.0  2017-01-19 12:11:57.307   \n",
       "6866              -82.0                       516.0  2017-01-17 19:29:59.587   \n",
       "6867              -50.0                       340.0  2017-01-31 18:29:38.380   \n",
       "6868                0.0                         3.0  2017-01-29 02:02:48.997   \n",
       "6869                0.0                         3.0  2017-01-29 02:02:49.030   \n",
       "6870               -5.0                       575.0  2017-02-07 00:48:43.863   \n",
       "6871             -100.0                       497.0  2017-01-20 10:02:41.640   \n",
       "6872              -50.0                       746.0  2017-01-17 15:04:45.450   \n",
       "6873                0.0                         4.0  2017-01-29 02:02:49.013   \n",
       "6874              -50.0                       547.0  2017-01-23 20:22:45.843   \n",
       "6875               -3.0                         1.0  2017-01-29 17:12:45.377   \n",
       "6876                0.0                         4.0  2017-01-29 17:12:45.393   \n",
       "6877                0.0                         4.0  2017-01-29 17:12:45.407   \n",
       "6878                0.0                         4.0  2017-01-29 20:05:54.527   \n",
       "6970              -24.0                       490.0  2017-12-19 02:43:33.950   \n",
       "6971              -56.0                       511.0  2017-12-18 12:29:45.300   \n",
       "6972              -37.0                       338.0  2017-12-12 15:41:19.600   \n",
       "6986              -28.0                       269.0  2017-12-17 18:13:40.367   \n",
       "6987              -48.0                       377.0  2017-12-12 17:38:43.173   \n",
       "6988              -39.0                       357.0  2017-12-12 22:47:59.800   \n",
       "6989              -70.0                       570.0  2017-12-17 13:08:31.367   \n",
       "6990              -41.0                       357.0  2017-12-19 00:40:11.847   \n",
       "6991              -75.0                       825.0  2017-12-23 10:25:24.117   \n",
       "6992              -48.0                       450.0  2017-12-24 22:43:55.807   \n",
       "6993              -38.0                       360.0  2017-12-12 04:06:18.753   \n",
       "6994              -27.0                       233.0  2017-12-12 13:13:35.537   \n",
       "7002              -78.0                       702.0  2017-12-13 22:36:45.093   \n",
       "7003              -38.0                       360.0  2017-12-21 10:34:47.817   \n",
       "7004              -19.0                       179.0  2017-12-24 09:39:00.250   \n",
       "...                 ...                         ...                      ...   \n",
       "2262800           -59.0                       139.0  2017-02-12 20:50:42.770   \n",
       "2262877             0.0                       416.0  2017-01-24 14:03:57.907   \n",
       "2262878             0.0                       176.0  2017-01-25 10:18:29.830   \n",
       "2262879             0.0                       250.0  2017-02-16 11:13:20.317   \n",
       "2262880             0.0                       493.0  2017-02-17 11:56:30.340   \n",
       "2262885             0.0                       299.0  2017-02-21 23:40:23.107   \n",
       "2262886             0.0                       198.0  2017-02-20 02:57:14.197   \n",
       "2262912             0.0                       132.0  2017-02-02 00:05:40.190   \n",
       "2262913             0.0                       198.0  2017-02-21 19:43:45.343   \n",
       "2262914             0.0                       198.0  2017-02-01 14:21:02.173   \n",
       "2262915             0.0                       388.0  2017-02-18 09:44:53.697   \n",
       "2262918           -38.0                       360.0  2017-12-15 22:33:09.553   \n",
       "2262919             0.0                       250.0  2017-02-21 23:30:24.157   \n",
       "2263549             0.0                       215.0  2017-12-30 17:46:07.183   \n",
       "2263552             0.0                       338.0  2017-12-30 17:54:40.837   \n",
       "2263679             0.0                       255.0  2017-12-20 01:35:15.543   \n",
       "2263682             0.0                       977.0  2017-12-20 01:35:15.660   \n",
       "2263684             0.0                       360.0  2017-12-20 01:35:15.720   \n",
       "2264789           -11.0                       216.0  2017-03-29 17:54:18.287   \n",
       "2267624             0.0                       338.0  2017-12-28 18:05:55.953   \n",
       "2267941           -36.0                       343.0  2017-12-17 23:25:31.483   \n",
       "2268017           -34.0                       132.0  2017-12-31 07:58:57.703   \n",
       "2268042           -16.0                       290.0  2017-12-31 14:19:20.973   \n",
       "2268063             0.0                       398.0  2017-12-20 10:16:32.810   \n",
       "2268097           -40.0                       305.0  2017-12-23 19:35:22.810   \n",
       "2268147          -101.0                       237.0  2017-12-31 19:40:09.627   \n",
       "2268158           -18.0                       394.0  2017-12-14 14:52:15.590   \n",
       "2268164           -27.0                       352.0  2017-12-14 15:38:32.007   \n",
       "2268174           -43.0                       452.0  2017-12-14 18:16:03.127   \n",
       "2268288           -32.0                       218.0  2017-12-20 15:23:31.980   \n",
       "\n",
       "         SalesOrderSlaveStatusDef  PayProfileTypeDef  ShippingProfileTypeDef  \\\n",
       "6863                       Finish        SevenEleven             SevenEleven   \n",
       "6864                       Finish        SevenEleven             SevenEleven   \n",
       "6866                       Finish        SevenEleven             SevenEleven   \n",
       "6867                       Finish        SevenEleven             SevenEleven   \n",
       "6868                       Finish        SevenEleven             SevenEleven   \n",
       "6869                       Finish        SevenEleven             SevenEleven   \n",
       "6870                       Finish        SevenEleven             SevenEleven   \n",
       "6871                       Finish        SevenEleven             SevenEleven   \n",
       "6872                       Cancel        SevenEleven             SevenEleven   \n",
       "6873                       Finish        SevenEleven             SevenEleven   \n",
       "6874                       Finish     CreditCardOnce                    Home   \n",
       "6875                       Finish             Family                  Family   \n",
       "6876                       Finish             Family                  Family   \n",
       "6877                       Finish             Family                  Family   \n",
       "6878                       Finish        SevenEleven             SevenEleven   \n",
       "6970            WaitingToShipping        SevenEleven             SevenEleven   \n",
       "6971                       Finish             Family                  Family   \n",
       "6972                       Finish             Family                  Family   \n",
       "6986                       Finish        SevenEleven             SevenEleven   \n",
       "6987                       Finish        SevenEleven             SevenEleven   \n",
       "6988                       Finish        SevenEleven             SevenEleven   \n",
       "6989                       Cancel             Family                  Family   \n",
       "6990            WaitingToShipping        SevenEleven             SevenEleven   \n",
       "6991            WaitingToShipping             Family                  Family   \n",
       "6992            WaitingToShipping        SevenEleven             SevenEleven   \n",
       "6993                       Finish        SevenEleven             SevenEleven   \n",
       "6994                       Finish        SevenEleven             SevenEleven   \n",
       "7002                       Finish        SevenEleven             SevenEleven   \n",
       "7003                       Cancel             Family                  Family   \n",
       "7004                       Cancel        SevenEleven             SevenEleven   \n",
       "...                           ...                ...                     ...   \n",
       "2262800                    Finish             Family                  Family   \n",
       "2262877                    Finish             Family                  Family   \n",
       "2262878                    Finish             Family                  Family   \n",
       "2262879                    Finish             Family                  Family   \n",
       "2262880                    Finish             Family                  Family   \n",
       "2262885                    Finish     CreditCardOnce                    Home   \n",
       "2262886                    Finish     CreditCardOnce                    Home   \n",
       "2262912                    Finish             Family                  Family   \n",
       "2262913                    Finish             Family                  Family   \n",
       "2262914                    Finish             Family                  Family   \n",
       "2262915                    Finish             Family                  Family   \n",
       "2262918                    Finish             Family                  Family   \n",
       "2262919                    Finish             Family                  Family   \n",
       "2263549                    Finish             Family                  Family   \n",
       "2263552                    Finish             Family                  Family   \n",
       "2263679                    Finish             Family                  Family   \n",
       "2263682                    Finish             Family                  Family   \n",
       "2263684                    Finish             Family                  Family   \n",
       "2264789                    Finish        SevenEleven             SevenEleven   \n",
       "2267624                    Finish             Family                  Family   \n",
       "2267941                    Finish             Family                  Family   \n",
       "2268017                    Finish             Family                  Family   \n",
       "2268042                    Finish     CreditCardOnce                    Home   \n",
       "2268063                    Finish        SevenEleven             SevenEleven   \n",
       "2268097                    Finish        SevenEleven             SevenEleven   \n",
       "2268147                    Finish             Family                  Family   \n",
       "2268158                    Finish        SevenEleven             SevenEleven   \n",
       "2268164                    Cancel        SevenEleven             SevenEleven   \n",
       "2268174                    Finish        SevenEleven             SevenEleven   \n",
       "2268288                    Finish        SevenEleven             SevenEleven   \n",
       "\n",
       "         EcouponId  IsSalePageGift  new_DateId  \n",
       "6863         133.0           False  2017-01-15  \n",
       "6864         133.0           False  2017-01-19  \n",
       "6866         133.0           False  2017-01-17  \n",
       "6867         130.0           False  2017-01-31  \n",
       "6868         130.0           False  2017-01-29  \n",
       "6869         130.0           False  2017-01-29  \n",
       "6870         134.0           False  2017-02-07  \n",
       "6871         133.0           False  2017-01-20  \n",
       "6872         128.0           False  2017-01-17  \n",
       "6873         130.0           False  2017-01-29  \n",
       "6874         128.0           False  2017-01-23  \n",
       "6875         130.0           False  2017-01-29  \n",
       "6876         130.0           False  2017-01-29  \n",
       "6877         130.0           False  2017-01-29  \n",
       "6878         130.0           False  2017-01-29  \n",
       "6970         242.0           False  2017-12-19  \n",
       "6971         242.0           False  2017-12-18  \n",
       "6972         242.0           False  2017-12-12  \n",
       "6986         242.0           False  2017-12-17  \n",
       "6987         242.0           False  2017-12-12  \n",
       "6988         241.0           False  2017-12-12  \n",
       "6989         219.0           False  2017-12-17  \n",
       "6990         242.0           False  2017-12-19  \n",
       "6991         248.0           False  2017-12-23  \n",
       "6992         248.0           False  2017-12-24  \n",
       "6993         241.0           False  2017-12-12  \n",
       "6994         242.0           False  2017-12-12  \n",
       "7002         241.0           False  2017-12-13  \n",
       "7003         245.0           False  2017-12-21  \n",
       "7004         248.0           False  2017-12-24  \n",
       "...            ...             ...         ...  \n",
       "2262800      135.0           False  2017-02-12  \n",
       "2262877        NaN           False  2017-01-24  \n",
       "2262878        NaN           False  2017-01-25  \n",
       "2262879        NaN           False  2017-02-16  \n",
       "2262880        NaN           False  2017-02-17  \n",
       "2262885        NaN           False  2017-02-21  \n",
       "2262886        NaN           False  2017-02-20  \n",
       "2262912        NaN           False  2017-02-02  \n",
       "2262913        NaN           False  2017-02-21  \n",
       "2262914        NaN           False  2017-02-01  \n",
       "2262915        NaN           False  2017-02-18  \n",
       "2262918      244.0           False  2017-12-15  \n",
       "2262919        NaN           False  2017-02-21  \n",
       "2263549        NaN           False  2017-12-30  \n",
       "2263552        NaN           False  2017-12-30  \n",
       "2263679        NaN           False  2017-12-20  \n",
       "2263682        NaN           False  2017-12-20  \n",
       "2263684        NaN           False  2017-12-20  \n",
       "2264789      136.0           False  2017-03-29  \n",
       "2267624        NaN           False  2017-12-28  \n",
       "2267941      241.0           False  2017-12-17  \n",
       "2268017      219.0           False  2017-12-31  \n",
       "2268042      219.0           False  2017-12-31  \n",
       "2268063        NaN           False  2017-12-20  \n",
       "2268097      245.0           False  2017-12-23  \n",
       "2268147      219.0           False  2017-12-31  \n",
       "2268158      242.0           False  2017-12-14  \n",
       "2268164      242.0           False  2017-12-14  \n",
       "2268174      241.0           False  2017-12-14  \n",
       "2268288      221.0           False  2017-12-20  \n",
       "\n",
       "[37899 rows x 28 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Quantity'] > 1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3.資料分組(group_by)+繪圖"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### *變項：購買商品數量隨日期分佈 的情形"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "data1 = df.groupby(by='new_DateId')['Quantity'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYkAAAEWCAYAAACT7WsrAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAIABJREFUeJzsnXecXWWZ+L/PvXfu9N4y6QnphJJC\nR6RIVwFFBVHBhmJvi7q/dVnrqquyIorrKgrigigoiCAgEHpJJ4EE0pNJJtN7ufX9/XHKnHvnTrlT\nMjOZ5/v5zGfuvKfPPec879PFGIOiKIqipMI33iegKIqiTFxUSCiKoij9okJCURRF6RcVEoqiKEq/\nqJBQFEVR+kWFhKIoitIvKiQURVGUflEhoSiKovSLCglFURSlXwLjfQLDpayszMydO3e8T0NRFGVS\nsX79+gZjTPlQ15+0QmLu3LmsW7duvE9DURRlUiEi+9JZX81NiqIoSr8MKiREZJaIPCUi20TkNRH5\nvD3+HyJyUEQ22T+XeLb5uojsFJE3RORCz/hF9thOEfmaZ3yeiLwsIjtE5I8iEhztC1UURVHSZyia\nRBT4sjFmKXAq8GkRWWYvu9kYc6L98zCAvewq4FjgIuAXIuIXET/wc+BiYBlwtWc/P7D3tRBoBj46\nStenKIqijIBBhYQxpsYYs8H+3A5sA2YMsMllwD3GmJAxZg+wEzjZ/tlpjNltjAkD9wCXiYgA5wJ/\ntre/A7h8uBekKIqijB5p+SREZC6wAnjZHvqMiLwqIreLSLE9NgM44Nms2h7rb7wUaDHGRJPGUx3/\nehFZJyLr6uvr0zl1RVEUZRgMWUiISB5wH/AFY0wbcBtwDHAiUAP82Fk1xeZmGON9B435lTFmtTFm\ndXn5kCO4FEVRlGEypBBYEcnAEhB/MMbcD2CMqfUs/1/gIfvPamCWZ/OZwCH7c6rxBqBIRAK2NuFd\nX1EURRlHhhLdJMBvgG3GmJ94xqs8q10BbLU/PwhcJSKZIjIPWAi8AqwFFtqRTEEs5/aDxuqf+hRw\npb39tcADI7ssRVGU4bO7voO5X/s76/Y2jfepjDtD0STOAD4IbBGRTfbYv2JFJ52IZRraC3wCwBjz\nmojcC7yOFRn1aWNMDEBEPgM8CviB240xr9n7+ypwj4h8B9iIJZQURVHGhed3NQLwl40HWT23ZJzP\nZnwZVEgYY54jtd/g4QG2+S7w3RTjD6fazhizGyv6SVEUZdzx2W+8uEnpHp1SaMa1oihKEn6xpEQs\nrkJChYSiKEoSPp8jJMb5RCYAKiQURVGScDQJNTepkFAURemD36fmJgcVEoqiKEk45ibVJFRIKIqi\n9EGjm3pRIaEoipKERjf1okJCURQliV5z0zifyARAhYSiKEoSbnSTSgkVEoqiKMnYMoKoCgkVEoqi\nKMk4/mp1XKuQUBRF6YMjHFRIqJBQFEXpg2Nl0ugmFRKKoih9MK4mMc4nMgFQIaEoipKEIxw0ukmF\nhKIoSh8cX0RMfRIqJBRFUZJxHdeqSaiQUBRF6Q/VJFRIKIqi9ME1N2nTIRUSiqIoycRt4WBUk1Ah\noSiKkkyvJqFCQoWEoihKEo4CoT4JFRKKoih9cDQJlREqJBRFUfqgZTl6USGhKIqShEF9Eg4qJBRF\nUZKIa6lwFxUSiqIoSRiNbnJRIaEoipKEU45DNQkVEoqiKH3oNTeN73lMBFRIKIqiJKHJdL2okFAU\nRUnCaD8JFxUSiqIoSbghsOqTUCGhKIqSjCbT9TKokBCRWSLylIhsE5HXROTz9niJiDwuIjvs38X2\nuIjILSKyU0ReFZGVnn1da6+/Q0Su9YyvEpEt9ja3iIiMxcUqiqIMBbfpkGoSQ9IkosCXjTFLgVOB\nT4vIMuBrwBPGmIXAE/bfABcDC+2f64HbwBIqwE3AKcDJwE2OYLHXud6z3UUjvzRFUZThYTS6yWVQ\nIWGMqTHGbLA/twPbgBnAZcAd9mp3AJfbny8D7jQWLwFFIlIFXAg8boxpMsY0A48DF9nLCowxLxor\ng+VOz74URVGOOI7DWs1NafokRGQusAJ4Gag0xtSAJUiACnu1GcABz2bV9thA49UpxlMd/3oRWSci\n6+rr69M5dUVRlCHjlQ1TvfHQkIWEiOQB9wFfMMa0DbRqijEzjPG+g8b8yhiz2hizury8fLBTVhRF\nGRZeX8RU1yaGJCREJANLQPzBGHO/PVxrm4qwf9fZ49XALM/mM4FDg4zPTDGuKIoyLni1h6gKiYGx\nI41+A2wzxvzEs+hBwIlQuhZ4wDP+ITvK6VSg1TZHPQpcICLFtsP6AuBRe1m7iJxqH+tDnn0piqIc\ncbxiIRKLj9t5TAQCQ1jnDOCDwBYR2WSP/SvwfeBeEfkosB94j73sYeASYCfQBXwYwBjTJCLfBtba\n633LGNNkf74B+B2QDTxi/yiKoowLam7qZVAhYYx5jtR+A4DzUqxvgE/3s6/bgdtTjK8Dlg92Loqi\nKEcCr1yIxKa2kNCMa0VRlCTiCT6JqW1uUiGhKIqShDfqNaqahKIoiuLFW/1Vo5sURVGUBLxyIabm\nJkVRFMWL8QTBquNaURRFSUB9Er2okFAURUkiIU9CazcpiqIoXhKT6dQnoSiKonjwOq7r20Os3dvU\n/8pHOUMpy6EoijKl8Bb4++RdGwDY/b1L8PmmXtNM1SQURVGSSGVh6o7EjvyJTABUSCiKoiRhUrS0\n6QhFx+FMxh8VEoqiKEmkSrJu71EhoSiKopAY3eTQqZqEoiiKAonJdA5qblIURVGA1JqECglFURQF\nsHwSkhTt2qE+CUVRFAUsTSLDl/h6VE1CURRFAaxkuoA/UZVQIaEoiqIAluM6w6+aBKiQUBRF6UPc\nmD5CQkNgFUVRFMByXAeTzU3quFYURVHA8Ukkvh7bVZNQFEVRwNIkMpI0CTU3KYqiKEBqn4Q6rhVF\nURTA0iT6hMCqT0JRFEUB2yeRlEyn/SQURVEUwMqT8PsEv6cTXap6TlMBFRKKoihJxI3BJyQIiViK\nbnVTARUSiqIoScSNQUTwi2oSKiQURVGSiBvwCQTU3KRCQlEUJRljDD4R/H6vuUmFREpE5HYRqROR\nrZ6x/xCRgyKyyf65xLPs6yKyU0TeEJELPeMX2WM7ReRrnvF5IvKyiOwQkT+KSHA0L1BRFCVdnH4S\nCZqECol++R1wUYrxm40xJ9o/DwOIyDLgKuBYe5tfiIhfRPzAz4GLgWXA1fa6AD+w97UQaAY+OpIL\nUhRFGSmOJuFL8EmM4wmNI4MKCWPMM0DTEPd3GXCPMSZkjNkD7AROtn92GmN2G2PCwD3AZSIiwLnA\nn+3t7wAuT/MaFEVRRhVLk5AETSKmPom0+YyIvGqbo4rtsRnAAc861fZYf+OlQIsxJpo0nhIRuV5E\n1onIuvr6+hGcuqIoSv8YJwTWr+am4QqJ24BjgBOBGuDH9rikWNcMYzwlxphfGWNWG2NWl5eXp3fG\niqIoQ8SKbtIQWIDAcDYyxtQ6n0Xkf4GH7D+rgVmeVWcCh+zPqcYbgCIRCdjahHd9RVGUcSFVMl3c\nWBqGSKq57dHLsDQJEany/HkF4EQ+PQhcJSKZIjIPWAi8AqwFFtqRTEEs5/aDxhgDPAVcaW9/LfDA\ncM5JURRltOj1Sfj6jE81BtUkRORu4GygTESqgZuAs0XkRCzT0F7gEwDGmNdE5F7gdSAKfNoYE7P3\n8xngUcAP3G6Mec0+xFeBe0TkO8BG4DejdnWKoijDwBiD0KtJ+MQSEHFj8Ke0kh+9DCokjDFXpxju\n90VujPku8N0U4w8DD6cY340V/aQow2b74TY++JtXePhzb6E8P3O8T0eZ5MSdZDpbSGT4fYSicWJx\nQ4Z/nE/uCKMZ18pRwa66TurbQxxs6R7vU1GOAowBn69XkwgGrFflVHReq5BQjgrCMavWfzg6RUt1\nKqOKU+DPyZPIdIXEeJ7V+KBCQjkqiEStp1eFhDIaGCcE1mNugqlZv0mFhHJUELKL/TsahaKMhOQQ\nWNfcpEJCUSYnEVuDCEen3kOsjD7xJE0i6FefhKJMasKuJqHmJmXkxO0Q2ECyuUmFhKJMTno1CRUS\nysgxdjKd306m6zU3jedZjQ8qJJSjAleTUCGhjAJugT/7DanmJkWZ5PQKCXVcKyPH8UkEkjQJjW5S\nlEmKo0FEYlPvIVZGn7gxmkxno0JCOSpwhIQ6rpXRIO76JBzHtbjjUw0VEspRQcQWDiH1SSijgOmT\nJ2EVbFJzk6JMUsIa3aSMIlYIbG9ZDnVcK8okx/FFRNTcpIwCluPaq0k45qapJySG1ZlOUSYaIdUk\nlFHE6UCXHAI7Fc1NKiSUo4KI5kkoo4hT4M/pVDqVk+lUSChHBRrdpIwmToE/p591xhT2SaiQUI4K\nVJNQRpO4AZ9P8ElinoTWblKUSYoW+FNGE6vpkKcsh5YKV5TJjYbAKqNJb9MhuyyHa24az7MaH1RI\nKEcFWuBPGU2SS4Vr7SZFsYnE4nz+no1sq2kb71NJC3VcK6OJ5bjWpkOgQkJJ4mBzNw9sOsSaN+rH\n+1TSQh3XymhiSEymm8rRTSoklASausIAHGzp4nfP75k06nVvFVgVEsrIMMa4TYccc1NmxtQ1N2kI\nrJJAU4clJO56aT8A5flZXHp81Xie0pBwynKoJqGMFEdZOJLmpnjc0NgZpjw/c0z2PxJUk1ASaOoM\nJ/w9WdRrRzhoFVhlpDj3vE+gLC+TrAwfeVnWfHqsMq6f2F7HGT94ss/zNxFQTUJJoDHpJnXKEkxk\njDGaJ6GMGo5FyecTLjmuilPmlVDXHgLGLpmutq2HcDROQ0eIktzgmBxjuKgmoSTQ3JUoJDpD0XE6\nk6Hj7UanPgllpHi1Z79PqCjIcs1OY5VM59y37T0T73lTIaEk0NiRKCQm4k2bjFd7UJ+EMlK8PgkH\n5/NY+a2j9kSnYwJOylRIKAk0dYYS/p6IN20yEVsw5Ab9KiSUEWPo9Uk4OOU5xsrc5Ex0JqLmrkJC\nSSDZcdYxiTSJvKwA0biZkvV1lNEjPpAmMUb3lqtJjMLz1hmKsq+xc8T7cVAhoSTQ1BVmRlG2+/dk\n0CQc7SE304rDUOe1MhIcn4Q3aKPX3DS2PonReN4+/Nu1vPW/1ox4Pw6DCgkRuV1E6kRkq2esREQe\nF5Ed9u9ie1xE5BYR2Skir4rISs8219rr7xCRaz3jq0Rki73NLSKTIZ5m/Lnjhb2s+NZjmFG+aZs6\nwpy9uJwPnDqbopwM2ieDkLAfsHwVEsooYOzbx6tJOI7rsUqmi8RHT0i8srcJGL1zHYom8TvgoqSx\nrwFPGGMWAk/YfwNcDCy0f64HbgNLqAA3AacAJwM3OYLFXud6z3bJx1JScNODr9HcFaFtFM1BPZEY\nneEY04uy+c7lxzGnJGdSmJucWZijSYQiKiSU4ePNk3Dw+cZYk4iOvuO6JxIblf0MKiSMMc8ATUnD\nlwF32J/vAC73jN9pLF4CikSkCrgQeNwY02SMaQYeBy6ylxUYY1401pT4Ts++lAEoy7NiqQ+1dI/a\nPh1/RHGOte+8rMCkMjflZ6kmoYycXnOT1yfhLBubY0ZHUZNw6AofISHRD5XGmBoA+3eFPT4DOOBZ\nr9oeG2i8OsV4SkTkehFZJyLr6usnVwG60aYsz0rfr2kdfSHhJPPkZQaGpElEY3HaeiKjdh7p4jxY\nznmP1gxKmby8fqiNy3/+/LDuy17Hde+YX8bY3OT4JEbZMjAajLbjOpU/wQxjPCXGmF8ZY1YbY1aX\nl5cP8xSPDpwaLwdbekZtn46QKM1zhETGkGY2v3thL+f9+OlR948MFSeXo9wWnGpuUn7y+BtsOtDC\ns282pL2tEwKboEmMtblpFPMknKKE3eMsJGptUxH27zp7vBqY5VlvJnBokPGZKcaVQSjIygDGxtzk\nzMjzBzA37WnodGdVu+o7qW8PjVvdpLZua7boCM5Q1Ho47n5lP/98vXZczkkZX5x7uKEjNMiafRkw\nmW6sNYnREBJ+61zH29z0IOBEKF0LPOAZ/5Ad5XQq0Gqbox4FLhCRYtthfQHwqL2sXUROtaOaPuTZ\nlzIAzk01mkLCqdtUYvskcjP9dISifTSEmtZu3vaTp3lg00EAmu3txsvk5Djvy/OzAOixNYmv37+F\nj925blzOSRlfnP4Pu+o70t622365Ot3owGNuGuuM6yRzUyga40v3bmJHbfuQ9xWwW652HykhISJ3\nAy8Ci0WkWkQ+CnwfOF9EdgDn238DPAzsBnYC/wt8CsAY0wR8G1hr/3zLHgO4Afi1vc0u4JFRubKj\nnPAYCInmzjB+n1CYbWkpeZkZxOLGfek6vHawjVjcsOVgK9Dbg6Ktu+8saH9jF1+6d1PCDWuM4aYH\ntvLMm6PjV3I0CceZH4rGxs30pUwMnBpkO2rTFxKO9uHcTwD2e3fM7qtwP5rEP7Ye5v4NB7nlyZ1D\n3pcTrjtaPolBq8AaY67uZ9F5KdY1wKf72c/twO0pxtcBywc7DyURR5Oobh5dTaI4J8O1vzrlkdt6\nImQH/e56b9izmp111gPoaBLtKTSJT//fBrYcbOUdx0/nnCVWfMOG/S3c8eI+Hth8iE3/fsGIz7u9\nJ0peZsA9x1A0TucozaKUyYlTg2xH3UiERG9vB98YO66j/ZTl2Li/BYC5pTlD3lfGBDE3KeOME/ZZ\n09ozohlDdXMXz+2wnHtNnSE3/BWgqsAy3zjaypfv3cxPHnuD7YctIbHLERJdjpBIvME7QlFX23jd\n0zP7j2uthkY5GX5Gg7aeCAVZATIDvUKioT19W7Ry9OD41xo6QmmbXeptAeNtAOQm042x4zo5efWV\nPcnZB4PjnyCOa2Wc8Ray2zuCOi3/9tetfOA3L/Py7kaaOsMJtexnlVizlwO2tnLfhmpueXInbxy2\nXviHWnvoCEVp7rI0iGSfxO9f3Od+3moLC4BnbaFU2x4aFZW4rTtCQXYGWXaLyZ5IjMZOFRJTGW8N\nsq5wes5gZ4LhfRYcTWIwGfHJ36/nhrvWp3U8SOzR7m3Fu81+1jpDQ39Oen0SoxNOq0JikhKKxt0a\nS3vqhyYkbluziw37mxPGHEfZNx7YSmNn2A1/BZhVYu3/QFOXGzEEsLu+k/nluQBs3N/squCv7Gli\no73/7nCM/3lmF2cvLufS46t4ZOthbluzi0gsTm1bD8eU5xKLG9dkNRyMMfzXo9t5YVcj+UmaRH37\nxOvwpYw9naEoH/zNyzR2hqkqtDThriR/2O9f2kf9AJpmQ0eI4pwM1/kNvTkTg5mb/vHaYR7Zejjt\n8/b2QXFMTi1dEVcodUeG/sJXTUIBrJtqUWUeALsbBhcSsbjhB//Yzrt+8ULCeIvt9H2ztoPd9Z0s\nqsx3l+UEA5TlBTnQ1EWNJx8jGjecu9jyL3hDTO98cR9X/OIFusMx9jR00tIV4cpVMzlpjlWB5Qf/\n2M7avU3EDbxtaSWQaIYaCmv3NvHb5/cAljnr50/toiMUpSArw21WH4rEhhX6qEx+thxsdTXVmcXW\nJMf7sqxp7eEbf93Kn9dXp9weLCHh9UfA2Nduinr26zivW7u92lA6moQtJMKjE5KuQmKSEo7FKcoJ\nUlmQyZ4hCIkWT8e5N2yfgjGGmpZu3n58FSLWbOm9q2clbDerJIcDzV19HOTHzSxkTmkOf3u1ps+x\n/rz+gGvuqcjP4ppT53DnR04G4NfPWi/4U48pJej3uX4Nh589sYMv37u53+t4zy9f5Jt/e51Y3FDb\n1isICrIzyPL6JDxCYqwebGXi0drda/J0NG3vC7a2zZrsVDd39buPho5wHyEhIogMHN0UHUE5GK/5\n2PHtOWZcSM/c5PhNutLQPgZChcQkJRyNE/T7mFOSy/7G/m94B6+N9ont1uy/rSdKZzjGCTOLuHj5\nNN61cibTPWXCAWYV57C/qavPQ1WSG+TMBWUpG7ff/coBN7qkNC9Iht/HWYvKOWFmIU9ur3P3O6c0\nh11JprI1b9a75+elOxxL0Fqqm7uoa+/VbvKzAmT4rQc5WZMYLbU7He55ZT9zv/b3SVH76mjC+73n\n2wmnXp+E06t6oKjAxo4QZfmZfcZ9IgM6rpu6hm/ijMYNBXY0YWe419wEVr5GOuYmpwlXj0Y3TW3C\n0TjBgI+C7MCQynk3el7mjlBx6j5VFWXxi2tW8aP3nNBnuzmlORxq6ekTSlicE+Rtyyr7rL+4Mp/X\na9pYa5crLsvtfdguOHaa+3l6URbzy3PZ05C43+rmLlq6Ijz62uGEBKIb73s1ITFut53l7RCJxRER\nMgM+O7rJo6qP4Yv65sff5Kt/frXP+Nfu3wLA4VGsraUMjvO9f/Fti7jsxOkAdHlm4fWukEg9sTLG\n2JpEsM8yvwgDKQve+zHdDomRWJxi21He4WoS1rXMLMpOS5MI25FS6pOY4kRihmDAR3YwMKQoBmfG\nnxP0s7/JekCc0Naqwux+t1s9t4RY3PSx4RbnBjl7UTk3v+8EPnDqbHf8+rPmA/CHl/cT8AkF2b2p\nOGcv7q23lRMMML88j/1NXa6aHorGXBPSJ36/nvNvfsY1Fb20uzHh+LvqO6jzmJuc7TIDfnoisYRZ\n3WjFi6fi+Z0NPL8rsT6Q17zlNRkoY099Rw9FORl8/m0LKcqxNQnPy9KrSaQyHd277gAdoSjHTi/s\ns8znG9jc5BUS6WqQ0ZihyA4/73Ad19Y9PL0oO60wXscJrnkSUxxHk8jJ8A/pZnA0iRNnFbGv0RES\nlrlmRlH/QuKUeSWAZet1SnGDVbpDRLhixUy+c/lx7vjqucVu5FNpXjChSNqyqoKEfc8vyyUSM26I\n7aEUxQp/+fQu4nHTxxG9u6Ezwdx05oIyALIyLE2ipSvsRqR0jlIoYCpq23v6mNy84b6pzHHK2NHQ\nHnYLPWYHrfvVO4mqt+8Zy2/V97u55YmdrJ5TzLtW9C1G7RMZ0L/l3V+61VzDsTjFtlDr8EQ3BXxC\neX5mWvewIyQmahVY5QhgjCEci5Ph95Ed9A9pltFk38AnzCqiprWbcDTOvsZOMgO+hKShZLIy/K7q\n/W+XLrXHfAkZ2F6qCrNZWGFFXZXm9nX+/fz9K/nlB6yGhfPLrfUc5/WBpkQTQFleJv/16Bvcs/ZA\nn/j03fUd1LWHmFWSzaZ/P5/rTp8LWJpEKBqnuSvi+ldGq4ZNMsZYzvOucCzhgfSG9TarkDiieCOT\nnGRN7yTKO9s/kMLk1NARYtWcYrfqgBd/Pz6JtXub+OBvXmavJ4Ak3Tpm0VjcTWTt8Diui3IyyM0c\n2jPeuy/bca2axNTFqfOSGfCRE/TTFRm8VlFTZ4iCrADHlOcRN3CwpZvth9tZWJnnhvf1x+8/egq3\nvn8Fq+xQ1pKcvvZaJ9wwGPCxwBYSTg0oL5ceX8VFy6sAWGiH8L5ZZ/kekp2Jz954Dkum5fO7F/b0\n2c/Blm7q2kJU5GdRlBN0H+rMgI+eSIyWrrArJIb6sNS3h/jYHWuHHD7b2h1xbc8fuv0VfvOcdZ61\nHg1nJM5MJX3qPU5nZyLj/f7r2kNUFljLD7cmaq7haJxQNJ6gMXvx+SRlMt09rxzg2R0N3PpUb32l\ndM1NkZhxnxdvCGxhdgY5wcCQNQlnAgnqk5jSOC+moN8SErG4GbQbm5Uol8kcuwbMXzYeZFtNO0um\nFQy4HcDSqgLefvx0CrMt4VCc21dIPPTZM3n2xnMAXCEx2INSkJXBjKJsttU4QqLLjfEG6yF/xwnT\neTNFkbba1hC17T1UJGlBWRl+mjrDRGLGNaMdaO7ixG89xvM7B+4t8MKuBv65rY4XdzUOuJ5DnWdW\n+sqeJr790OsYY6hrC5GfFSAn6FdN4gjT0B5yNd/MgA+f9GqSrx1q5dXqVhZWWLlA3nBZ6K095kRF\nJeOT1OHUOSm06uQSNYMRicXJDPjIDfrd56a5M0JxTpDsDD89kXhCmfKdde2c/5On+fFjbyTsx5tv\nccSqwCoTD6fOi+O4ht4bIhyN8+tndydkSANuyY3jZhRy2vxSbnliBw0dIZZMy2eoODOdkhRCoign\n6JbxWFCe7x5zMJZW5bPdTqirbu5melE2N7/vBG59/woA3rVyBrNKslk5u8jdZm5pDuFYnL0NnUyz\ns2odMgM+NxZ+epG17MVdjbR0RXh598Av/912OO5Qy0s7x/Fy18v7OdTSTWVBFsU5wYSoMmVs6Q5b\nPdodc5OIkBMMuJrEx+6wouOOnWFNjNr6CAnr5dyfJuH3JZqbalq7Of8nT7PxQDNleUF+e91J/PmT\npwHQEUrP3BSxzcd5WYGE6CbH3ASJmsH3Ht7OjroOHt5S02c/DqpJTGEcTSLD1iSgV6V+cXcj3/n7\ntj4duRwhkZXh5/8+foo7vjgNIREM+MjO8LtRGP3hOK4vPb5q0H0urSpgR10H9e0hqpu7mFmczRUr\nZvL2463wxarCbJ698Vzu/9QZbrTKAnsmGDe9fg2HzAwfh10hYWkS6/dZpUKSczKScZISh1oqxJvM\n5/CNv27lsddrqSzIpCQ3qJrEEcQJGfVOYrKDfrojUXoiMWpaezh/WSVffNsiAj7po0m0DapJSIJZ\n99XqVnbUdbD1YBvzy/M4Z0kFc8usez8dTSIWN8SN9TznZQboCHuFRNCdCHpNTk5kYrL5KxLtHRit\nDo0qJCYhrrkp0FdIOHH5+5OcwI2dYUrth0dE+O11JzG/PJfjZxaRDucuqeC0+aUDrpObGWDjN87n\nqxctGXR/jrnrpO/+kw37W1zfRiqcbnyOLwOsCCkvVgis9f+Zbof21ti258E0BEdIDCZMusMxXtjV\n0EeTuP261e7nyvwsinODNGkI7BHDeekXeXxhOUEr+s/Ji7j0uCqyMvwUZGf0cS4PpkkkRzd5fRpl\neb194Z1lqUrnp8KZ/Qf84vaV7whFqW0LMa8sl1z7Gfeajxy/WXINKq/ZeTAT9FAZtJ+EMvEIx3o7\nZ2UFErtQHW61bhqvkIjHTZ8Kr+csqXD7O6TDz69ZOaT1UvktUnHe0gouPLaSR1+zsqlnFfdfN98x\ndznRUwDzkoSEUwkWrCRBL7vtlqupHPXGGHbbQmR3fQfxuEkZ4QLw//66hfs3HGR+WS75mb3JjGcs\nKOPcJRU8ub2OioIs4sYkRLy/PgsaAAAgAElEQVQoY4uToVyY0ysksu0Q8QNN1uTJKVpZmJ1Ba1KT\nLOelXtCPJuH3JSbT1XiEhBPJl2VHVP1izS7r55qVXHLcwBq1U78s6JibQlE34m9BRZ6rvTgJdTH7\nefb7hPaQpSU5x3UETn5mgJCam6YuYVultBzXlpx3Sg84phZvOGlbT4RY3KT0JYw3WRl+brl6hfv3\nzJL+NQlHSMwpzSXgE7Iz/EwrSPZJ9DoRvdc7vyyXcDTOQU8E1cGWbv62+RCHW3uobw/RGY6xtKqA\nUDTOwX46/m092Mr9Gw4iYgmdK1f3tmjPDPiZbftlcoN+S5NQc9MRwymIV5ikSXSHY264qzMJKcgK\nuD6Jx1+v5UePvuG2we0/uikxmc6bTV+aIkMbcPup9MeDmw+5RTcDfiE3GKAzFHUrHCyoyOv1O9ql\nOZo6w8SN5c8D+lQeAEubHy1NQoXEJMQbAuuG+dmzBscEsr+pi9+/tI/Lbn3OTfLp70Yeb7wv9pkD\naBJO9nZhdgaVBVnMLcvtM9vP9PQlLsoOsmpOMecsLueblx0LJJqcvnbfq3z27o18+++vU20LBSd5\nMJVTGmDTAatT2DffeSxvXVTOVy5YnLB82XTLfJYd9DO/PI+OUJQ30+hPrAwf19zk8ZlZjusoB5q6\nEnKCCrIz3PU/fuc6bn1qp2tu6k+T8NZuemVPEzs991JpXt9co+mFWQlVAZIxxiREJzmO6/aeKDvr\nOsjwC3NKclxzk6NJOKampbaptr6jr5DIywoQiZmEiKjhouamSUgqx3WvucnWJJq7eGJbLZurW3nR\njuopye0/aW688YnliB4o+9uZIeZnBbho+TQ3Q9WLIyRyg36CAR9//uRpiIjrQN5Z1+Ga2Zz/1Y7a\ndmrtz8fPtMox1PXTb2B3fSfZGX4+cMocPnTaXADu/MjJrrC+cuVMBHjnidNp645y0wNbeXDTIb5y\n4eKU+xsK9e0h9jd1uXkqSmpcc5NHk8gO+mnoCHGgqZuZxdluBYCC7IwErRJ6Z+R5/UU32T6JnkiM\n9/7PiwnLyjxa6/2fOp2i7Ay+eO/mhKoAyRxu63GrH4DVdrQgK4O27gg769qZX5ZHwO9zNWLnnnTO\nc6ldwSCxZpQlFHJt30g4FifLN7IOkCokJiEDOa5r23rI8As9kThr3qgH4MFNBwFcx/VE5I+fOI0/\nvLSvj/nIizPDy8sM8I23L0u5jjPTm2dHWDkvheLcIKW5wQRNwjEF7W3scs1LjpDoT5PY3dDBvCQN\n5qxFvTWpfD7hPXa59fJ8P2csKOPhLTUjEhIX//QZGjrC7PnPSxLKnCiJtHZbZSxyPXkLOUE/3ZEY\nuxs6mFPa678qtB3XdZ7veW9DJ7lBf7/JpU4yndeEGAz4CEfjCZrEytmWMK/Iz+xTRcBLcrOwDL+l\n6bSHorxZ2+GGp88qySHDL+6962oStpBw/u4Ox/j9S1Y3yHxbSIQicddfMVzU3DTBufuV/fxja2Is\ntNdxne1qElFC0RiNnWHeuijRIb12rxUCOhF9Eg4nzS3hv69a0a+zGKweFGcvLk+ZvORw5oJyVswu\n4rZrVvVZdkx5HvdvPMjn79lIe0+E5q4w5fmZhKNxNu5vIej3Mb8sjwy/pAxvhcSufEPh9GPK2N3Q\nOaJQWMdcOJaFCo8GWrqtMhZeQZoTtJIrd9V3cuz03sTRgizL3PTaod6mV3sbO/sNf4XeZLoWT8Ta\n/LJcCrMz+gRQgCUkkjXSps6wG766J6ntcMDvcydy+5u6qLQnTBl+H3NKc93QbEcoOOHrjibxyNYa\n7n7F6h/v5FaEYiO/Z1RITHBufXInd7ywL2HM67jOdR3XMfdmOX9Zr5DwRgJNZCExFM5ZXMHvPnzy\ngLPpi5ZP4y+fOsNN7PNyTIXlvH5g0yG+fv8W4gZW2yacF3Y1UFGQic8nVORnpTQThKJWKGVybsZA\nOJrJYA7M/vDWhGpMUZBO6aW1y+p17qWqMJv2niixuEkQEoXZGURixs2hASsEuj+nNfT6JFpsB3lB\nVoCfXb2CzTddkLL+WUV+Fk2d4YSy4Rf/9BlO//6TAOxr7CIY6BUMQb8kNDvyVhNYUJ7n0STCBAM+\ninMyKM0NuhMab1mbXI8mMVJUSExgIrE4Na3dfV5YjuPaSW4DS0g4M5yinCDvWmlVsfzQaXPc7Uaq\ndk52vLPEh+yOeo6dv7kr4s7cyvMzUzocd9d3EjdwTBqaxPIZlpB4tbplWOfsdBEEaOjUlqwD0dod\nSciRADjf0/PEW/7b8VtsPNArJAaq2wRWCKwxvZrEHz9xGgsr+09GrbBrRHkdy84LvbEjxJ6GTuaU\n5Ljh4gGfL6HZkbM9WBOcfY1dhKNxGtpDlOdlIiJML8p2TaWHPBF5eR6fxEhRITGBqWnpIW7o88Ly\n1m7y+YSsDB/dkVhCMtAP3n08a75yNuct7dsYaKrynlUzOXluSUKS38LKfHf25vhDKgsyEwSzMYYP\n/uZlvvHXrYBVbn2oOKaIV6v7ahKhaCyhrHgqth7qXZ6OJrGlujXtSqSTnRa7IJ4Xb9kZb6KmEym3\n+UBrwveZrIl4cZLpHCFRPEjlAUcTcPwe3kijTQda2NvQydyyXFewBfyS4DesyO/1zy2oyCMWN+xv\n6kwoYjizONtNFDyYQkioJnGU43z57aEonZ5ieV7HNfSG+XmTgTL8PuaW5fZpRzqVWViZz72fPC2h\nDlRpbpB3r7K0LoP1EFcWZCX4JJq7Ijy7o4F1+5opz890cyGGyvEzC1Oam264awNv/9lz7gzwcGtP\nQi9yZ8yhcYjVaSOxOO+49Tmuvf2VtM5zMuPM8JNLxogI//PBVXzn8uUJZkqn0ZbVYKgAZ9FABS99\nPiFmest/FKWIrvPivOQdv4S3OvCT2+vY19jF/PJcdz89kViC2cr7eVqBdb51bSEaOsKU2+HsM4uz\nOWg3UPIKiVzVJKYG3nr3de0husMxvvm319zIGyfcMzvDT2co5iYDJcd53/y+ExIS1qY6cz1OxuLc\nIO8/2eqst7jSekFMK8yitTviahP7PA7Gk+YWpx1hdNyMQmpaexK0k131HW6/7+d2WHW2Pvy7tXz7\noW0J2zZ1ht1Z4VCLBTqOzY37h2fimox8+HdrqW7uTlme/sJjp/GBU+ckjB03o9f0NL88z62BtHqA\nMGO/WMKotTtCVoZvUPNtca51Lo7g39vQ+zz/4eX9hGNx3rNqpltduaUrQlaG3/2+veYmJ8epsTNM\nfXtvz4yZxTmEonHqO0IJ5ibHbDYaWdcqJCYg8bihpSuc4Iiqa+vh4S01/Pb5vfz0iR3kZQbcGcjc\nshz+uukgf3jZDn9LsqtesWIm7zxh+pG7gAmO1yFYkhNkTmkuz331HG44+xgALl5ehQjc8cJegIRY\n9jMXlJMuTn2sLbbJqaUrzMu7m9zlz+yoJx437Krr4EBzFz2RGP/5yDZq23po7gozrTCL/MxAnzo9\n/eHVggbrM3K08Moe6/95zSmzB1nTIhjwuWGi3vpfA+Wi9JqbwhRlDx4E4ggsJ2lvrz3ZuO2alZTk\nBnn3ypksqMjn/fY5n2LXRCvNC+KTxKZdTtBJfXuIpk6vkLA0jC3VrW7NMsANaBkNTULzJCYgn7xr\nPY+9Xss7TpjuJpnVtocI+HtnsMeU57oz2p9dvZILbn7anTn2lwykWHg1ASeE2JvpPa8sl4uXT+OX\nT+/G77N6EohYTZCmD9APvD+OnV6AT2BzdSvHzSjkzB8+xZySHAI+4e3HV/H0m/XUtYcIx+I0dIT4\ny8aD/M/Tu+kMRa2aWzlBorE4exs7ae+JDBimCYk5HlaTnf5zT44GusJRusIxbrxo8YCO5GQuOHYa\n922oZm5ZLsU5GTR3RQasOebzWULC6Rg3GHmZAfyearObD7QQDPi44NhpnLu0Ar99H66aU8ze71/q\nbleWl0l3OJaQr1GcE0TE0kDjpregoHPfvrynd9IBve8A9UkchdS3h3jsdavY3WsHW1lk3/R1bT2u\nOQngmKTQVsf3kJ3hJ8OvX+tI+d4Vx3H+0kpufXIHz7xZz/TCbGYW5wyYx9EfuZkBFlbks3F/M6/V\ntBGOxtlR10FVURanzC+luSviNkRqaA/x141W8mN1c7fVeCY3g2DAx5o36vnwb9cOejxvgtjrnjyA\noxUnsKMyPz1h+N0rlnPXR09hXlku//zSW3np6+cNuL5frGS61iEKCRGhICtAa3eErQdbuXfdAa5c\nNRO/T8gM+An085wun17ghk67x/YJxTlBt8RLuX2tM2xN4nH7neHg5BKpT+Io5NHXDrufdzd0srAy\nn6wMH4dbexISshZUJMbqO+rnQCF8Si+Pf/GshL4ayRTlBPnmZcfi9wkb9rek7axO5vQFpbyyp4mt\nniinmUU5rm38ETthsq0n6s4K1+9rpqEjREluEMESTuv2NfdxbifjmJsCPuGpN+rSPtf9jV1u2fTJ\ngKM5pasxZWX4OXNhGWDVXkpuYJWMz4ebJzEUcxP0Vpu966V95AQDfO3iwcvnf/Oy5fz62pP6jJfk\nBt2QaG9p8nlluexpsMrFfPOdVo0yx1SV3HxsOKiQmGAk992tKsxiYUU+rx1qSygHcEx5spCwbpqB\nQviUXhZW5nP6MWUDrlNZkMWNFy6hJDfovkyGy1mLyglF4/zh5f3u2IzibBZV5hMM+PjntsSX+aXH\nVdHeE6WxM0xxTpCfvX8FX7lgEQBPv2mVWwlFY/z+xb1Ek2aLtW09VBZkcslxVfx148GEhLyhcO6P\n13DOj9b02e9Epdb21VQWjG1tsoDPRyQWH7K5CSwh0dIV5p/bajl7cXm/xQOHQmlu0LUmePMpHD/K\n0qp8rj19Lnu/f6l7ft5EvuGiQmKCcTipZlBlQRar5xaz8UCz67gsywv2idV3NAknMkIZHT5+1nw2\nfON8Pn3OghHt59R5pQQDvoTvd2ZxNsGAz63B48VJhgRrBrmoMp8bzl5ASW6QZ+1oqCe21fGNB17j\nhaSe3I4f4r2rZ9HWE+UZW6gMhVA05vZJfizJhDFRcYozVoyx76WqMIu9DZ00dIQG1TocCrIzeHZH\nAw0dYS44dtqIju+t4uzNzHYispZ5Msqd8PiQComjj9q2HpZ5XhrTCrI4aW4JPZE4L+xq4MRZRaz7\nt/P7qNbOTTNVolkmG9lBPx8+fW7CmON0fLctELwNk7yai5O05fcJy2cUss1uUrOjtrdJkpfath4q\n8rNYOacIEdhW05u1/fLuRlcTScXWg70+jPs3VPOb5/bwwKaDCR3ZJhq1bT1kZ/gpGGNT65zSXNp6\nohjTt9lVf3hDcgfr6DgYToRTcU5GwrWeMr8UETjB02XSCY8fd01CRPaKyBYR2SQi6+yxEhF5XER2\n2L+L7XERkVtEZKeIvCoiKz37udZef4eIXDuySzpyfO7ujTyS1Ih8pNS1hZhZnO3eENMKM92ZQnNX\npN/6S476ORozB2Vs+OL5i3jnCdO5+X0nMLM4mxV2Ut+HTpvLP7/0Vn573cnuupkBv1vN1PudL5mW\nz466DqKxuFvLZ/vhdl6zM7OjsTj7m6xe4TnBALNLcnijtvfF/75fvTRgkt3G/VaZirMWlfPMmw18\n+6HX+fw9m3h4lO/z/thS3crq7zzex+w6ELXtISoLMse8Qu6c0sQIuKHgCIm8zIBrEh4uAZ/1un7H\nCdMTrnVeWS4Pf+4tvGtlbwOsiaZJnGOMOdEY4zT4/RrwhDFmIfCE/TfAxcBC++d64DawhApwE3AK\ncDJwkyNYBmJfY9e4tobsicR4cPMhbvjDhrS2G6wJSG17D5UFWW4s/7TCbCoKstwbtL9SAM4NqEJi\n4uJ04btixUye++q5CX6lBRV5nDArMaLF0TS8Ic2LKvMJR+Psa+pyq4Les/YAl97yHPetr+b1mja6\nwjHXTr1kWj7bbU2iI5TYrjMVr9e0Ma0gi/OXVSZExlQ3p+7UN9q8sreJho4wmzw1lcDqrtifj6Sm\npfuIhPl6hcTcNIXE7JKcEQsx59m/YsWMPsuWVhUkhMwG/b1CIhyNc/FPn+WJbcMzH46Fueky4A77\n8x3A5Z7xO43FS0CRiFQBFwKPG2OajDHNwOPARYMdpK0nwku7Gwdbbcw41E97y4H449r9HP/Nx/ok\nRd38+Js882Y9N/55My1dESoLMqkoyEKkN/Fr9RyrY1pJbmrHV7ltbhqtvrbKkcdpRXuC7W/64vmW\no3qupw/CYjskentNO7sbEs1M//qXLfzFDp9dPdcSEounFbC3sZOeSIxNngxsp91tMo0dYSoLMllh\nn8OMomzyMwP99tdIl5rWgZ8bJ7vdEYAOF978DCu+/XifZ8cYw876jrQq8w4Xpx9FaW5wyA5oR0hU\njIJT/RNvnc8Dnz6DFbMHbz4lIgQDPkLRGIdbe9hW0+YmHKbLSIWEAR4TkfUicr09VmmMqQGwfzt1\nq2cABzzbVttj/Y33QUSuF5F1jmmruWv8Cpj11wO5P1q7I3z1vi10hKIJNuGWrjA/fWIHH7r9Fe5d\nVw1YDrg5JTnMKMp2cx5Osh/6/pJ9HJNEWYqSxcrk4dkbz+H/PmaF5l60fBp7v39pQg2fhZV5+MQK\nlfZm2H7irfMRgd8+v5cZRdlubaKl0/KJG9hW08a6fb0vie8/sp0Xd/WdZDV1hinJDbJ4Wj65QT9n\nLCilsjCrj5AwxvCrZ3axJinE9q8bD/KBX7/slgbx8uf11Zz2n0+6LWBT4YTeeoVEa3eEmtYe2nui\n/Gm99aroCkfZ09BJY2eYlq5In5DwscAxGQ1Vi4DeGkrJ1WmHQ1aG351ADIVMuyGSEyxRk4YJz8tI\nhcQZxpiVWKakT4vIWQOsm0rXMgOM9x005lfGmNWOacup6z4eOOp3MDC0f+G6vb0P6HM7eoXErvq+\nJrPinCBfvmARf/hYbxy/45zqL+O3NC+TH155PL/64OqUy5XJwaySHPfFkoqsDD+r5hTz4OZDAPzw\nyuOZU5rD9W+Zz39deQIrZxdxncdBvsqeXLy0u8l1dAPc+eI+rv7fl9y2tw5NnWGKc4Nk+H388ROn\n8dWLllBZkMnBlm427m/GGEMoGuOPaw/wvYe388U/bnK33bC/mX/582ae29nA5+7e2Ofc71tvTYLe\nONzWryPcKYHi7R/tbTPa1BHmYEs3y/79Uc750RrW2Q21joSQALj2tLm876RZQ17fKcyZXHjwSJAZ\n8BGKxl0BP5gW1x8jCgcwxhyyf9eJyF+wfAq1IlJljKmxzUnOVKMa8P53ZwKH7PGzk8bXDOX4LZ3j\nqEnYN27GEDNwnRyHlbOLeHZHA8YYRMSNTPn25cuZVZzN1+/fwgkzCynKCSbcWPPKcvnbZ850u1Gl\n4r2rh37zKpOXS46rYu3eZpZVFfDe1bPc7/0dJ0znHUk1uirys1hYkceLuxtp7Y4wvTCLQ54Z5Zf/\ntImfvPdEdtd38sCmgzR2hiix7zunF0ZlQRbP7zzIFb94gbmlOURihojtH2juinDxT5/lc+cu4IeP\nvkFlQRZvXVTOPWsPEI3FE7KK99utPL/38HZ+/NibPPfVcxMmWeFonOrmLnwCu+o6iccNPp+41ZDB\n6j7nDel9cLNlXjtSQuKz5y1Ma32nYsIZC0aWZzMcMgN+wglC4ghrEiKSKyL5zmfgAmAr8CDgRChd\nCzxgf34Q+JAd5XQq0Gqbox4FLhCRYtthfYE9NijNg2SejiXOjdsZjrkPzEA4NejPXlxBY6c1G2rv\nibCrvpMMv3D1SbM4e3EFL379vH7jvZfPKNSSGwqXHFdFZsDHlatmDr4ycPoxpazd08S+xk5WeArY\nXXPKbB7ecpjbn9/DJbc8y/88s5ueSJySpCgcr1PY6Qde1x7i0uOrAMuU9YU/bmJPQyc/ePfxHDej\nkFjcUNPaQ2OHVb1468FW10RrVdgNuSUmHA40d1ndAueW0B2J8cT2Op7dUc8Be0I2rSCLlq5Igunr\n4S2HyQ36mT7EvIUjzTlLKnj2xnMSmh8dKYK2JuFEitW29QwaOJOKkWgSlcBfbI99APg/Y8w/RGQt\ncK+IfBTYD7zHXv9h4BJgJ9AFfBjAGNMkIt8GnKI03zLGDMnD0jJBfBLNnWH3xd7cGaamtSchsQUs\ngRbwiTvj+dgd68gJ+inNy2RuaW6/dVwUJZnKgiye/eo5lOUOzf900rwS7nhxH92RGIsq8vk7Vjjr\ndy5fzt+31HDrkzsT1i9JMo04zZjmlubwhbct4rY1uzjY0s1XL1zC3+0Of6FonFPmlXDGgjKetc2p\nO+s6uPG+V1lWVUB1cxdleZlMK8x0czE2HWhxtRWAf2y1StJ85Ix5vLKniU/9YT2ZAT/vXjmDnKCf\nuWU5tHaHqWsPUZobxOcT6ttDrJidfvn2I0mqVrpHAssnEXN9EpGYGVZ3w2ELCWPMbuCEFOONQJ9K\nWcbK8vp0P/u6Hbg93XMYT03icFsPQb+PcCxOo0dIXP/7dazd28zr37rQjVaB3ibtTqbm9sPt+H3C\ntIIsls/ov9GJoqSiIo1idt7eCTM83dlEhKXTCngxKUowOTjCSdBcOaeYy1fMYGlVAU2dYWaX5nDd\n6XNZPC2fW57YweffZpliZtjFJr/z99epbw/xdHs9PoG7PnYKtzyxw93v5gMtbp+HaCzOXS/t48wF\nZVywrJL8rADtPVEisShPbK9jVnEOxTlBdtZ1UNcWojw/k+12HaOrTlYzayocTaLZY5ZPJ//EYVJP\nX1u6x0+TaOmMuJVYvYX3Nh+wkppe2Jn44LV0hSnKCVLlUYtjcaubVDoRC4qSLt7ihNOLsvjHF97C\n0/9yNtBbysFrDklO2Lxw+TTml+XyGbs0yeJp+Zx2jJU9/B/vPJarT57Ni18/z62F5VQk3lXfyWnz\nS1k9p5h/u3QZpx9TxgXLrNIUCyvy2FzdwraaNvY0dPKn9dXUtPbw4TPm4vMJKz1hntXN3cwqyaYo\nJ4MWuxlUZUEW/++SpeRlBtx9Kol4o5vm233ZD7WkLyQmdaGflq6w6wA+koSjcdpDURZU5LGtpi2h\nY1hVURb7Grt48o063uZ58Jo7IxTnZFCel+n2iHA4a2H6jWwUZah4n4+ZRTnM9iSFOSVgVs8pdstN\nJwuJqsJsnvzK2UM+nrdj2xUrZvBeTzTQh8+Yy+UrZvDb5/fw86d2cvFPnwWs4nyr5hRz7hIrYv6i\n5dOobetxtYWrT57N2r3NtHZF8ImVL/Lxs+bzsbfMm9CmpvGkNDeTzdUtNHSEuGh5FbvrO4eUUJnM\npNUkBMvG1hk+8sljTujtMbZ0buwIYYzBGOM61V7yxKBbjUrCFGYHCfh9CXHvpbnBhFpNijIWnDLP\nSsZMLkx32jGlzC/L5bylFe5Ysk9iJJy9JHECJCKU5AZZWlWQMFGqbQvx1YuWuC/8q0+ezT++cBaf\nO3cB7z9lNuctraQoJ4NwLE5tW8hNTlMB0T+nzC+hprWHSMxw9iLrexhO6fBJq0k4oXPNnh7ARwrH\nxndMeR4FWQEe2HyIH/zjDX5xzUp6InFyg372N3URjcWpbQ9xxvefBHptw9MKsqhtC3HekgpWzC4a\nViMbRUmH31x3Evsbu/rk9Uwv6tUSKvIzqWsPjUq5+Q+eOof1+5r79Z0kT4zOW1LBybYg8/KlCxa7\nn70JaUd7t73RwAm7zQz43IKRw+lUN2mFhKMSt3RFmNX33hpTHId5aW6QVXOKeeoNK5rjh4++AcBb\nFpbzj9cOU93czS/W9EaOFLtF+7LYXN3KLVevGDBxSlFGi7zMQJ+Iu2Qe+MwZbK9pT6gBNFy+ffny\nAZfPLskhN+inMxzjoc+eOaQsZm8PhwqtLDAoCyvyqMjPZElVgVseZDi13SatucmJHEruv3AkcBzV\nRTlBVs/tlVBOCWdHar9R2+7W0rHWt76opVUFLKjIUwGhTCiqCrM5Z0nF4CuOAj6fsKSqgBlF2Syf\nUTgka0Chpxtcqh4cSiIiwu8+fDLfu2K5p+DfFDI3ZQZ8dMG4VIJ1akaV2JoEwMXLp/HI1sNkZfhc\nR/Tjr9cSiRnml+Wyu6HTbYj+2XMXcsPZxxzx81aUicS/XrK0T1mQgfC25p1TOvT6SVOZhEZEft+w\nNIlJKySsxuAZ7GkcDyHhaBIZnJRfwr9dupQrV83k5vedSGt3hIr8TPIyA24N/n+5cDE3/GEDp9pN\nR/w+we/z97t/RZkKrJozeDVTL/PLczltfik3XrR48JWVPmQGfFPLJwFWPaM9KQrkjTXNnWFygn43\n1O9jb5nvLnPG5pXlsuVgK9kZfi44dho7vnuxltRQlBGQEwxw9/WnjvdpTFoyM3zDMjdN6rfWvLI8\nt7TwkeDx12u54a711LWH+m3+4+BkgXZHYvh9ogJCUZRxJTPgn1rmJrDUz/s2VHOgqeuI1Ef5xZqd\nbLQbtwxWSuOqk2bz5LY6NzNVURRlPHFKh6fLpJ7enn5MKX6f8M5bn3Prto8lATs0sCArwLtWDFyB\n0+8TfnPdSQmmKEVRlPEiGPANq3PlpBYSK2YXc9s1K2nuivCndQdYv6958I1GwL7GLt6zaiabb7qA\nj5w5b0yPpSiKMppkZvjpmWqaBMDpC8rwCfzH317nI79bOyzHzFDoCkepaw8xp3TkDc0VRVGONJlT\nUZMAK5PUqQHT2h3hyW11nPfjNdz54t6U6z+xrTZlb9/BcLpqzdb4bEVRJiFZGcNzXE96IQHw8bdY\npp+S3CBfu38Lu+o7eWhzTZ/1dtS288m71vOxO9ZyqCW9fq9O790549RARFEUZSRMSce1w9cvXsr2\nb1/EVSfNcrOaNx5opiuc6Mz+2ZM7yc7wE40bbluzK61jHHA0CRUSiqJMQiwhMQXNTWDVgcnK8PNx\nTyRRJGZ4aHMNN9y1ni3VViOg3Q0drJpTzCnzS1m7N7FDajQWp2WATneHWnrIzvAnFBlTFEWZLGQG\n/MPKuD4qhIRDcW6QR/L2YiEAABDsSURBVD7/FtZ85WyyMnx882+v8cjWw7zj1udo6gxzqKWH6UXZ\nnDizkDdr2xM0jV+s2cVZP3yq31Daw23dVBVlqdNaUZRJiZVxPcWFBFjVIeeW5XLO4oqEhkT/3FZL\nU2fYEhKzi4gbXA0D4KFXD9HWY/XTdTDGcO/aA7R2Rahp7UloPaooijKZmNLmplRcenwVAF+5YBF5\nmQHu31ANWD1+T5hp9ZTeYGdP72vs5M3aDgC+9bfXeWWPZYp6cXcjN973Krc+tYPDrT1MK8hOPoyi\nKMqkYEqW5RiI85dV8qXzF/GBU+ewcX+LqyFML8ymNC+TZVUFPPb6YW44+xi3t++7V87kvg3VXPWr\nFynKCdJk9424d101HaEo04tUk1AUZXKSGfARVnNTL5kBP587byFFOUHeuri3z+70IksbuPT4Kjbu\nb+FgSzf/3FbLkmn5/Pi9J7D1mxdy2YkzXIFQmJ1Ba3eEWNz06Q+sKIoyWcjMGN7r/qgVEl6uWDHD\n/ey86N9+fBU+gQ/++mVe2t3E25ZWAlZy3s3vO5G/fuoMvnz+Iu7/1OksrswHLC1EURRlMpIZGF4P\nmykhJPKzMvjomfNYNafYLdk9pzSXW9+/koN2Ut1Fy6clbBPw+/jseQs5pjyP686Ya2+jORKKokxO\nMgPDe90ftT6JZL7x9mV9xi45rorzl1VS3x5yzVCpuOqkWaycXcz88ryxPEVFUZQxY7hCYkpoEgOR\n4fcNKCDAaii+eFr+ETojRVGU0SczQ81NiqIoSj+oJqEoiqL0iwoJRVEUpV80uklRFEXplxNmFfLP\nL52V9nYqJBRFUaYAOcEACyrSD8CZMEJCRC4SkTdEZKeIfG28z0dRFEWZIEJCRPzAz4GLgWXA1SLS\nN7FBURRFOaJMCCEBnAzsNMbsNsaEgXuAy8b5nBRFUaY8E0VIzAAOeP6utscSEJHrRWSdiKyrr68/\nYienKIoyVZkoQiJVuzfTZ8CYXxljVhtjVpeXl6fYRFEURRlNJoqQqAZmef6eCRwap3NRFEVRbCaK\nkFgLLBSReSISBK4CHhznc1IURZnyiDF9rDrjgohcAvw34AduN8Z8d5D124HDQGuKxYWjNO5dVgY0\njNK+xvMYDs6xRmNfg40nX9dYHMO7bKT/x3T+J4P9H0f7/5tB3//lWH6H3v/laP0fB7pPImN8DO+y\nI/W8jeR/OJxtBnvephljhp4wYYyZlD/AOuBX/SwblXHvMmDdaO1rPI/h/f+N1r6GML5urI8xmv/H\ndP4ng/0fR/v/m+p/OZbfofd4Y/28HY3P9Ej/h8P9Pw60r4GWp/qZKOam4fK3MR6fqPuabOc7EBPx\nfCfb/1fPd3yOMZr7Gs1jDETa20wYc1O6iMg6Y8zqo+l4R/KajtZjHenjHc3XdqSPd7Re20S7rnTP\nZzJrEr86Co93JK/paD3WkT7e0XxtR/p4R+u1TbTrSut8Jq0moSiKoow9k1mTUBRFUcYYFRKKoihK\nv0x4ISEiHUfgGDER2eT5mTvAumeLyEPDOIYRkd97/g6ISP1w9pXmca+wj71kjPY/LtdlH2vM7410\njykia0Rk2E7Ksf6+Uhzv/4nIayLyqn3vnzLGx5spIg+IyA4R2SUiP7UTaPtb/wsikjOM4xgR+bHn\n76+IyH8M87QHO5bz/nhNRDaLyJdEZMzfrUfq/p/wQuII0W2MOdHzs3cMjtEJLBeRbPvv84GD6exA\nRALDOO7VwHNYWezpHGuovQ5HfF1KAsP6voaDiJwGvB1YaYw5HngbiYU2R/t4AtwP/NUYsxBYBOQB\nAyXOfgFIW0gAIeBdIlI2jG3TxXl/HIt1/18C3HQEjntEmBRCQkTyROQJEdkgIltE5DJ7fK6IbBOR\n/7Wl+GOel9VIj+kXkf8SkbX2LOsTnsUFIvIXEXldRH6ZxqzhEeBS+/PVwN2e450sIi+IyEb792J7\n/DoR+ZOI/A14LM1ryAPOAD6K/dKxNaFnUp2/iHSIyLdE5GXgtDQONZzrelZETvSs97yIHJ/O9Xmu\n5yHP37eKyHX2570i8k3PfTMqs/OBjjnC/fb3ffV3fZeIyHYReU5EbhmG9lYFNBhjQgDGmAZjzCER\nWSUiT4vIehF5VESq7OOtEZH/tr/HrSJycprHOxfoMcb81j5eDPgi8BERyRWRH9nf06si8lkR+Rww\nHXhKRJ5K81hRrCieLyYvEJE59vvkVfv3bBEptO8X51nIEZEDIpKRzkGNMXXA9cBnxKLf94iI3Ghf\n72YR+X6a1+fsY8zfjZNCSAA9wBXGmJXAOcCP7VkJwELg57YUbwHePYz9Z0uvqekv9thHgVZjzEnA\nScDHRWSevexk4MvAccAxwLuGeJx7gKtEJAs4HnjZs2w7cJYxZgXw78D3PMtOA641xpyb5nVdDvzD\nGPMm0CQiKwc5/1xgqzHmFGPMc2kcZzjX9WvgOgARWQRkGmNeTfP6hkKDfd/cBnxlDPY/mvT3ffXB\n/l//D3CxMeZMYDhlkR8DZonImyLyCxF5q/1S/BlwpTFmFXA7iTP9XGPM6cCn7GXpcCyw3jtgjGkD\n9gMfA+YBK2yt5g/GmFuwCn2eY4w5ZxjX93PgGhEpTBq/FbjTOQ5wizGmFdgMvNVe5x3Ao8aYSLoH\nNcbsxnq3VtDPe0RELsb6vk8xxpwA/DD9ywPG/t04aYSEAN8TkVeBf2L1mqi0l+0xxmyyP68H5g5j\n/15z0xX22AXAh0RkE9ZLrxTrnw7wirEaJMWwZs1nDuUg9ktwLtZs++GkxYXAn0RkK3Az1gPl8Lgx\npmkY13U11gsc+/fVg5x/DLgv3YMM87r+BLzdfil9BPhduscdIvfbv4d7bxxJ+vu+UrEE2G2M2WP/\nffcA66bEGNMBrMKa+dYDfwQ+ASwHHrfv/X/DqsrscLe97TNYGnVRGocUUrQAsMfPAn5pjIna+x/O\n/Z6ALYDuBD6XtOg04P/sz7+n9/7/I/A++/NV9t/DxXlR9/ceeRvwW2NMl32uw73esX43Mhwb93hw\nDdZMaZUxJiIie4Ese1nIs14MGBVzE9Y//7PGmEcTBkXOpu+Nnk6yyYPAj4CzsW4Yh28DTxljrhDL\ncb7Gs6wzjf0DICKlWOr9chExWIUTDdZLvL/z77EFx3BI67qMMV0i8jhWB8L3AsN19kZJnOxkJS13\n7o8Yo3e/D3bMtBng+3qwn2Ol6sGSNvb3vQZYIyJbgE8Drxlj+jM3juTef42k2ayIFGC1Cdid5r6G\nyn8DG4DfDrCOc9wHgf8UkRIs4fnkcA4oIvOx7rc6+n+PXMToXO+YvxsniyZRCNTZ/4RzgDlH4JiP\nAjc4NkkRWSQiufayk22V0Yc180jHNHM78C1jzJak8UJ6Hb7XDf+0Xa7EUqnnGGPmGmNmAXuwZk0j\nOf/+GM51/Rq4BVg7gpnUPmCZiGTaZoXzhrmf8T5mf98X/RxrOzBfeiPx3keaiMhiEVnoGToR2AaU\ni+XURkQyRMSr1b7PHj8Ty4zSX+XSVDwB5IjIh+x9+IEfY2mRjwGfFDs4w35RA7QDQ69YmoR9X92L\nZfZxeIHewIBrsO9/W7N6Bfgp8NBwJkwiUg78ErjVWJnK/b1HHsPyxeTY4yX97XMQxvzdOKE1CfuG\nCWHZDf8mIuuATVgPyFjzayz1bINt46vHsiECvAh8H8um/wzwl1Q7SIUxphrrJkzmh8AdIvIlhjmD\nSeJq+xy93AfcwAjOvz+Gc13GmPX/v737D7mzrOM4/v7kSqRZsz8ytUJaplkwh0QlZkL9E0Q9IVJk\noMNW0g812CgsoyBIKAyKCW1Uin+Uiw3qD5vuD7MHNdmcTh0LfyQ56sEMXVOwH7pPf3yvh509Pec5\n5zw7O88993n9s7P73Pd1Xefs3vW9z3Vf1/eWdICFr/LmNXtu2N4naTPwMPA48ODIje9Gnf3+vT5L\ndXKH1WX7JUlfArZJ+gfVuY1qOfCTNmT0MvAENfS0EfhxC0rLqKvxPe2Y5yXdC7yBGiYcmm1L+hRw\nk6TrqYvU24HrqCvddwEPS/ovsIm6d7AR+J2kmUXel4AKRF/p+fvVwM8lraf+X6/pee82aij04hHK\nP6kNJ72W+h5vBW5s783bj9jeppq4sVPSfzj0PQxlkn1jp9NySFoFbLI96iyK6KMNl62z/fEOtOV0\naqjjHNsHRzx24udG185HScttv9g6nw3A47Z/dBTr+z117uw8WnXEcCZ5LnZ2uEnSVdRNsm8tdVti\n/NqQw/3ANxcRICZ+bnT0fFzbrmD3UMMOP13i9sQETPpc7PQviYiIWFqd/SURERFLrzNBQtLbJN2l\nWiW4R9I1bfubJG1X5XrZLumUtv0cSfdJ+rekdT3lnK3D8zAdkHTtUn2uiIgjMa6+sb33tVbGo5J+\nqVqUuXD9XRluUi39P832LkknU4s/pqhpk8/ZvkHSN4BTbH9d0pup6V5TwPO2fzhPmSdQ0y/fb/sv\nk/osERHjMq6+UdIZ1HTfc9vsuM3A7bZvXqj+zvySsD1je1d7/QI1X/sMarHVLW23W2jTUG3/3fYO\nYKFl8x8BnkyAiIhj1Zj7xmXUlN1lVOLEvw2qvzNBoldbILSamv1yqu0ZqC+LyocyrM+wiHQFERFd\ndCR9o+2/UlkRngZmqMWQA5OGdi5IqDJhbgGubblXFlvO64BPUAtjIiKOaUfaN7Z7Fp+kEimeDrxe\n0ucGHdepINGWrm+hMkDOJmZ7RodSFZ9G5UMZxseAXbafGX9LIyImZ0x940eppH/Ptuy2W4ELBtXd\nmSDRVo3+DNhr+8aet34LXN5eXw78ZsgiD3uuQUTEsWiMfePTwAdUz8oQdc9278D6OzS76UJgGngE\nmF2Bex019rYZeDv1IS+1/ZyktwA7qRwyB4EXqbv2B1rSrH3AO0ZMQBYR0Slj7hu/SyVpfJnKA/Z5\nt4dO9a2/K0EiIiK6pzPDTRER0T0JEhER0VeCRERE9JUgERERfSVIREREXwkSERHRV4JExBhIukLS\ns5IebKmb75A0cDWrpClJ5w6x33fmpn1u28+U9Ohi2x0xSIJExPjcZnu17bOAG4Ctkt494JgpYGCQ\niFgqCRLxqteutvdK2tQeuHKnpJMkrZS0TdIDkqbbw1pOkPRnlRWSDkq6qJUzLemdw9Rp+y5gI/CF\nduxaSTsk7Za0paVGuIBKQvmD9oCslfO1aZ7Pc34r5z7gy2P7oiLmkSARx4uzgA223wPsBy6hOvGv\n2j4fWAfcZPsV4DHq6v5C6gEvH5J0IvBW20+MUOcuYLaT32r7fbZXUflyrrR9L5V/Z73t82w/OV+b\n5in3F8DVtj84yhcQsRjLlroBERPylO2H2usHgDOpDJi/rlxnAJzY/pwGLqJSKn8fWAvcDewYsU71\nvH6vpO8BK4DlwB3/t3Olgu7Xptl93gissH1323QrlfE44qhIkIjjRW8Ss1eAU4H9ts+bZ99p4Coq\n5/63gfXAxcAfRqxzNYeybN4MTNneLemKVt5cr1mgTbMEJOFaTEyGm+J4dQB4StKlUOmYJa1q791P\nXdEftP0v4CHgi1TwGIqkD1P3Iza1TScDM+25AJf17PpCe4/2IJl+baLtsx/4Z8sMypyyIsYuQSKO\nZ5cBV0raDeyhntpFS528D/hj22+a6sgfGVDep9sN6MeoVM6X2J79JXE9FXy2A3/qOeZXwPo2dXZl\nvzbNsQbY0G5cvzTKB44YVVKFR0REX/klERERfeXGdcQIJK0Brpmz+R7bWa8Qr0oZboqIiL4y3BQR\nEX0lSERERF8JEhER0VeCRERE9PU/BY2N4HnSzEAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x11dca2160>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "b = data1.plot()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}